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 TYPE	Document Type (ADJ, CHK, DEP, EFT, FEE, INT)	4
CKNO or CKNUM	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 CKNUMB	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 PAYEE	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)