Common Codes - BK

Post New Checks (BKUTBK)

Purpose	Code Category/Value for BK Post New Checks from Bank File	Description
General Setup Information (required)	CKID Specific: BKNC/XX	This common code is used to define the Bank File of new checks to be written to BK for the specified bank ID.
	Specific: BKNC/xxTAPE	Bank ID for the checks that will be uploaded followed by TAPE.
Additional MISC Records	Specific: BKNC/xxMISC BKNC/xxMISC2	Bank ID for the checks that will be issued followed by MISC.
	Specific: BKNC/xxPEID	Bank ID for the checks that will be issued followed by PEID
	Specific: BKNC/xxDATEID	Bank ID for the checks that will be issued followed by DATEID.
	Specific: BKNC/xxRECSEL	Bank ID for the checks that will be issued followed by RECSEL.
	Specific: CKIF/XX	Eliminates tail sheet error.

Load Bank Reconciliation File (BKUTLB)

The common codes may be ledger-specific or set to "@@" ledger for all ledgers. Disable common codes by typing "OFF" in the short description field. The file must be bank-specific for BKUTLB, BKUPBA, and BKUPRC by replacing the XX with a specific Bank ID.

Purpose	Code Category/Value	Description
General Setup Information (required)	BKRC/xxGEN	Used to describe general characteristics of the Bank Reconciliation file.
Cancelled Check Indicator (required) Additional Cancelled Check Codes (optional)	BKRC/xxCHK BKRC/xxCHK2 or xxCHK3	Indicates which records are cancelled checks (document type of "CHK"). Additional bank codes that indicate record is a cancelled check. Common code BKRC/xxCHK must also exist with all six strings defined.
Deposit Indicator (optional) Additional Deposit Codes (optional)	BKRC/xxDEP BKRC/xxDEP2 or xxDEP3	Indicates which records are deposits (Document type of "DEP"). Additional bank codes that indicate record is a deposit. Common code BKRC/xxDEP must also exist with all six strings defined.
Adjustment Indicator (optional) Additional Adjustment Indicator	BKRC/xxADJ BKRC/xxADJ2 or xxADJ3	Indicates which records are adjustments (Document type of "ADJ"). Additional bank codes that indicate record is an adjustment. Common code BKRC/xxADJ must also exist with all six strings defined.
Interest Indicator (optional) Additional Interest Codes (optional)	BKRC/xxINT BKRC/xxINT2 or xxINT3	Indicates which records represent Interest (document type of "INT"). Common code BKRC/xxINT must also exist with all six strings defined.
Bank Fee Indicator (optional)	BKRC/xxFEE	Indicates which records are fees (Document type of "FEE").
EFT Indicator (optional)	BKRC/xxEFT	Indicates which records are EFTs (Document type of "EFT"). However, EFTs are transfers and will typically update to a Status of "CX" after disbursement.
Check Number (required)	BKRC/xxCKNUM	Defines check number position within the Bank Recon file. This same position is often used for non-check unique references as well. Use Common Code BKRC/xxTRANNO for non-check records.
CKID Position (optional)	BKRC/xxCKID	This information will identify the CKID to use when writing records to BK. The CKID entered at run-time will only be used for reading the configuration common codes used by the program.
Non-Check Transaction Reference (required only if non-checks are to be reconciled)	BKRC/xxTRANNO	Defines unique transaction reference position within Bank Recon file for non-checks. If this unique reference is not provided in the bank file, define seed code in medium description so that a unique reference may be derived. Import the bank reference number or generate a seed, but not both.
Check Amount (required) 2nd Check Amount (optional)	BKRC/xxCKAMT BKRC/xxCKAMT2	Defines check amount position within bank file and if formatted with a decimal. It is assumed that the amount is fixed with no "." If not, update the Short Desc field. Defines a 2nd check amount position within bank file. This amount will be used if the amount identified by the BKRC/xxCKAMT or /xxCKAMT2 common code is zero. It is assumed that the amount is fixed with no ".". If not, update the Short Desc field.
Check Date (required)	BKRC/xxCKDATE	Defines position and format of the date the document was processed by the bank within bank file. Note that this date will be titled "Clear Date" on the BKUTLB report; insert into BKUPBA as "Entry Date"; then become the "Cancel Date" on BKUPCD after reconciliation.
Skip Records (optional)	BKRC/xxSKIP1	Defines string values that will prompt the interface to skip a bank input record(s).
Record Selection (optional)	BKRC/xxRECSL1	Defines record selection based on specific character strings and column position. BKRC/xxSKIP takes precedence.
Define Type based on two fields (optional)	BKRC/xxCOMBO	Determines the document type code based two fields within the bank file. BKRC/xxCOMBO takes precedence.

Positive Pay (BKUTPP)

The positive pay file is compiled through relationship between the Common Codes, Output Codes, and the file content derived from BKUPCD. "xx" is a specific CKID code (or Bank ID). CKID-specific will supersede the generic setup.

"nn" is a sequential number from 01 to 99. Codes with "nn" use Output Codes.
Code Values should be numbered in a sequential manner, from 01 up to 99, such as BKPP/Header01, BKPP/Header02.
Ledger-specific will supersede the @@ ledger – except when using CKID-specific vs. generic.
Codes may be disabled by setting the Short Description field to "OFF."

See Positive Pay for information on how to create a positive pay file.

CKID Specific	CKID Generic	Purpose	Required
BKPP/xxCKID	BKPP/CKID	Creates a lookup table to display a bank's account and/or routing numbers for a specific bank ID (CKID or check stock).	N
BKPP/xxCKID2	BKPP/CKID2	An extension of BKPP/xxCKID or CKID to define additional bank IDs.	N
BKPP/xxCONTRL	BKPP/CONTRL	Summarize control totals per bank IDs instead of check issue dates.	N
BKPP/xxCTRLnn	BKPP/CONTRLnn	Control Totals - Summarizes record clusters that share the same Issue Date (or CKID). Output Codes define fields, e.g., total count of "issued" or "voided" checks on a specific Issue Date.	N
BKPP/xxCTYPE	BKPP/CTYPE	Check Type selection, e.g., HW, MW, VH, or VM. May be an Output Code.	N
BKPP/xxDETLnn	BKPP/DETAILnn	Detail - First line of record details; dynamically defined by Output Codes. Record(s) displayed may be limited per BKPP/STATUS.	Y
BKPP/xxEXMASK	BKPP/EXMASK	Exclude masks from positive pay.	N
BKPP/xxEXTDnn	BKPP/EXTDTLnn	Extended Detail - Third line of record details based on BKPP/DETAILnn; dynamically defined by Output Codes.	N
BKPP/xxFILE	BKPP/FILE	Alternate file name (when Short Desc within BKPP/GEN says "CUSTOM").	N
BKPP/xxFOOTnn	BKPP/FOOTERnn	File footer displays after all record details; dynamically defined by Output Codes. Presence controlled by the footer flag on BKPP/GEN.	N
BKPP/xxFTP	BKPP/FTP	FTP transfer setup.	N
BKPP/xxGEN	BKPP/GEN	Core of Positive Pay file - Describes general characteristics of the Positive Pay file, i.e., header, footer, file name, file location, formats, and more.	Y
BKPP/xxHEADnn	BKPP/HEADERnn	File header displays before all record details; dynamically defined by Output Codes. Presence controlled by the header flag on the BKPP/GEN.	N
BKPP/xxREPORT	BKPP/REPORT	If report records are defined, this common code identifies the report header to use.	N
BKPP/xxREPTnn	BKPP/REPORTnn	Defines fields/columns in the report. Up to 99 may be defined.	N
BKPP/xxSTATUS	BKPP/STATUS	Limits record selection to statuses within the Associated Codes 1-5, e.g, IS, CX, RV and so on. (Compare to SUBDTL.)	N
BKPP/xxSUBDTL	BKPP/SUBDTL	Further limits the writing of Sub detail records to statuses within the Associated Codes 1-5, e.g, IS, CX, RV and so on. May be an Output Code. (Compare to STATUS.)	N
BKPP/xxSUBDnn	BKPP/SUBDTLnn	Sub Detail - Second line of record details based on BKPP/DETAILnn; dynamically defined by Output Codes.	N
BKPP/xxTRFOOT	BKPP/TRFOOTER	Transmission footer will display last within file when Final Report Flag is "Yes."	N
BKPP/xxTRHEAD	BKPP/TRHEADER	Transmission header will display first within file. Will display when Final Report Flag is "Yes" or "No."	N