BKNC - xxRECSEL and BKPP - VALUEnn
Bank ID Checks Issued Followed by RECSEL
Bank ID for the checks that will be issued followed by MISC, where xx is the bank ID for the checks that will be uploaded.
Code Category: BKNC
Code Value: xxRECSEL
Short Description: Not required.
Medium Description: Not required. Used to describe the common code.
Long Description: Not required. Used to describe the common code.
Associated Numeric Values
1: For ASCII and EBCDIC type files, this field indicates the starting position (column) of a value that can be used as a selection indicator in the record. For COMMA type files, this value should indicate the field number of the field used as a selection indicator.
2: For ASCII and EBCDIC type files, this field indicates the length of the selection indicator in the record with a maximum value of 2. For COMMA type files, this value is not used and should be set to 2.
3-5: Reserved for future use.
Associated Codes
1-5: Value of selection indicator to include.
Associated Descriptions
1-5: An explanation of the contents of lines 1 through 5.
BKPP Output Codes
Refining Detail within a Positive Pay File
The positive pay file is compiled through relationship between the Common Codes, Output Codes, and the file content derived from BKUPCD. The Output Codes listed in the grid below are to be placed within BKPP common codes to deliver a greater range of detail, options, clarity, format, and so on. Refer to the File Hierarchy when designing a file per bank specifications.
The following common codes are designed to use Output Codes for expanding the number of data elements that may be arranged within the positive pay file. The Code Values should be numbered in a sequential manner, from 01 up to 99, such as BKPP/Header01, BKPP/Header02.
File Hierarchy | CKID Specific | CKID Generic |
Header | BKPP/xxHEADnn | BKPP/HEADERnn |
Detail (1st line) ** | BKPP/xxDETLnn | BKPP/DETAILnn |
Sub Detail (2nd Line) | BKPP/xxSUBDnn | BKPP/SUBDTLnn |
Extended Detail (3rd line) | BKPP/xxEXTDnn | BKPP/Extdtlnn |
Control Total (summarize group; group by issue date or bank ID) | BKPP/xxCTRLnn | BKPP/CONTRLnn |
Footer | BKPP/xxFOOTnn | BKPP/FOOTERnn |
Report | BKPP/xxREPTnn | BKPP/REPORTnn |
File requires BKPP/GEN or xxGEN and at least one instance of BKPP/Detailnn or xxDETLnn. Other common codes will also modify file; review all BKPP codes.
BKPP - VALUEnn
Code Category: BKPP
Code Value: [VALUEnn] (see list within the File Hierarchy above)
Short Description: Reference the Output Code (or add text to Medium Desc, but not both) – see grid below.
Medium Description: Hard code a text field, like a title introducing or clarifying an Output Code nearby (or place Output Code in Short Desc; but not both) – see grid below.
Long Description: Not required. Used to describe the common code.
Associated Numeric Values
Fixed format
1: Starting column position (number) - required for fixed format.
2: Field length (number) - required for fixed format. Output longer than the number in this field will be truncated.
3: Justification (number) – optional for fixed format. 1=Right; 2=Center; 3=Left (default if Associated Code 3 is left blank).
4-5: Reserved for future use.
Delimited format
1-5: Not required. (Limit field length, similar to fixed format, when place number in Associated Code 2). Otherwise the "nn" is the sequence number stated within the Code Value and will arrange output in field order as dictated by the "nn."
Associated Codes
1-5: Mini lookup table. If a code is used to populate this field (in the Short Desc), then Code 1-5 can be used to convert this value into another value (in the corresponding Desc 1-5). "@" may be used to convert all values that do not already have a match. (optional)
Associated Descriptions
1-5: Mini lookup table. Up to 30-characters to use to populate this field when the corresponding value in Code 1-5 is found. May be left blank to populate the field with spaces or use "@" followed by one of the codes in the short desc above to populate with a value from the BK record. E.g., "@REF" (optional)
Short Description: Check Record Value: One of the following codes may be used to populate this field with a value from the check record. Fields in italics are the most commonly used. See the BKUPCD screen for more information on these fields. (Add an output code or text in Medium Desc, but not both.)
Output Codes | Description | Length/Type |
CKCC | Concatenated Bank ID (Check ID) and Check Number. E.g., AP12345678 | 10 |
CKID | Bank ID/Check ID | 2 |
DTYPE or | Document Type (ADJ, CHK, DEP, EFT, FEE, INT) | 4 |
CKNO or | Document Number (Check Number). This field will always be right justified and left zero-filled to the length specified in Val 2. E.g., 00123456 | 8 |
CKNOB or | Document Number (Check Number). This field will always be left justified with no leading zeros. E.g., 00123456 would be 123456 | 8 |
CTYPE or TYPE2 | Check Type (HW, MW, VH, VM) | 2 |
STATUS | Status (CX, ES, IS, RS, RV, SD, SP, VD) | 2 |
SUBSYS | Subsystem (CR, IP, JE, OH, OT, PY, TR) | 2 |
WARRANT | Warrant | 10 |
JOBNO | Job Number | Number |
JOBNO2 | Job Number 2 | Number |
JOBNORV | Reversal Job | Number |
DATE | Issue Date | Date |
DSTATUS | Deposit Status | 2 |
MSTATUS | Match Status | 2 |
RSTATUS | Recon Status | 2 |
CANCDATE | Cancel Date | Date |
STALDATE | Stale Date | Date |
STOPDATE | Stop Date | Date |
RELEDATE | Release Date | Date |
REVIDATE | Review Date | Date |
ESCHDATE | Escheat Date | Date |
HOLDDATE | Hold Date | Date |
MAILDATE | Mail Date | Date |
AUDITREF | Audit Reference | 16 |
AAMT | Audit Amount | Amount |
AUDIDATE | Audit Date | Date |
RECONTYP | Recon Type | 4 |
RECONNUM | Recon Document Number | 10 |
AMT | Amount | Amount |
PEID | Payee ID | 12 |
NAME or | Name | 50 |
NAMER | Name Reversed | 50 |
ADDR1 | Address 1 | 40 |
ADDR2 | Address 2 | 40 |
ADDR3 | Address 3 | 40 |
ADDR4 | Address 4 | 40 |
CITY | City | 20 |
STATE | State Code | 2 |
ZIP | Zip | 10 |
COUNTRY | Country | 4 |
CKIDACCT | Account Number from the BKPP/CKID common code for the current CKID. | 30 |
STATCODE | Status Code from the BKPP/STATUS common code for the current BK Status. | 30 |
CURRDATE | Current Date | Date |
TOTAL | This is the total dollar amount for all of the detail records written. When using CONTROL common codes, this is a sub-total. When used on a detail record, this is the total dollar amount for all detail records written so far (including the current one). Will always be zero if used on a header record. | Amount |
GRANDTOTAL | Used on a footer record as the grand total amount of the detail records written to the file. Will always be zero if used on a header record. | Amount |
CXTOTAL | Total dollar amount of records written with a "Cancelled" status. | Amount |
ESTOTAL | Total dollar amount of records written with an "Escheated" status. | Amount |
ISTOTAL | Total dollar amount of records written with an "Issued" status. | Amount |
RSTOTAL | Total dollar amount of records written with a "Reverse Stop" status. | Amount |
RVTOTAL | Total dollar amount of records written with a "Reversed" status. | Amount |
SDTOTAL | Total dollar amount of records written with a "Stale Date" status. | Amount |
SPTOTAL | Total dollar amount of records written with a "Stop Payment" status. | Amount |
VDTOTAL | Total dollar amount of records written with a "Void" status. | Amount |
COUNT | When used on a detail record, this is the current detail record number (similar to a line item number in POUPPR). When used on a footer record, this is the total number of detail records written. Will always be zero if used on a header record. | Number |
COUNTALL | Total number of records written to the file. | Number |
CXCOUNT | Total number of records written with a "Cancelled" status. | Number |
ESCOUNT | Total number of records written with an "Escheated" status. | Number |
ISCOUNT | Total number of records written with an "Issued" status. | Number |
RSCOUNT | Total number of records written with a "Reverse Stop" status. | Number |
RVCOUNT | Total number of records written with a "Reversed" status. | Number |
SDCOUNT | Total number of records written with a "Stale Date" status. | Number |
SPCOUNT | Total number of records written with a "Stop Payment" status. | Number |
VDCOUNT | Total number of records written with a "Void" status. | Number |
CKIDTEXT | Long Description from the BKPP/xx common code for the current CKID. | 72 |
HASHTOTAL | Hash Total (summation) of all Check Numbers. | Number |
MULTIxy | Joins multiple fields together (using the codes above) into a single delimited field. Where "x" is the delimiter and "y" is the number of spaces surrounding the delimiter (0 or 1). The codes are listed in the long description. E.g., MULTI,0 in the short description and "NAME,ADDR1,ADDR2" in the long description would put the Name, Address 1, and Address 2 in a single field delimited by commas. | Varies |
FINAL | Final Input Indicator (BKUTPP only): This is the response from question: "Is this the final report for the month." "Y" is last issue capture for cutoff date. "N" is not the final issue capture for cutoff date. If left blank, this defaults to "N." To use this value, question CKEB must be added to the JCL for BKUTPP. | 1 |
CUTOFFDATE | Certification Cutoff Date (BKUTPP only): This is the response from the question: "Please enter the cutoff date." To use this value, question CK80 must be added to the JCL for BKUTPP. | Date |
REF | Reference from the first document detail record. | 16 |
REF2 | Secondary Reference from the first document detail record. | 16 |
RELONE | "Relate To" code 1 from the first document detail record. | 2 |
RELTWO | "Relate To" code 2 from the first document detail record. | 2 |
PAYTYPE | CR Payment Type from the first document detail record. | 2 |
FINCD | The Finance Code from the first document detail record. | 4 |
REFDATE | Reference Date from the first document detail record. | Date |
REF2DATE | Second Reference Date from the first document detail record. | Date |
Medium Description: Literal Value or Override Date/Numeric format. (Add text within the Medium Desc field or an Output Code in Short Desc, but not both.)
If this is a text field, this can be a literal value to populate the field with (if the Short Desc field is left blank or the resulting value is blank). Leave empty to populate the field with blanks. Maximum length is 30 characters.
If this is a date field, this can be an overriding date format. See Associated Code 4 on the BKPP/GEN or BKPP/GENxx common code for a list of valid formats.
If this is a numeric field, this can be an overriding numeric format. See Associated Code 5 on the BKPP/GEN or BKPP/GENxx common code for a list of valid formats.
Long Description: Used to describe this field. E.g., the bank's description of this field. (Optional)