BKRC - xxGEN
General Characteristics for Bank Reconciliation file
This is one code of many that builds an upload file for loading a bank statement into the BK Update Bank Statement Info (BKUPBA) page via BK Load Bank Reconciliation File (BKUTLB) utility. The various BKRC common codes help BusinessPLUS read bank records, interpret bank codes, tell BusinessPLUS where in the upload file to read specific details, and more. Additionally, BKUTLB and BKUPBA require the upload file to be bank specific where xx represents a valid bank ID (also known as a CKID or check stock).
BKRC/xxGEN is required and used to describe general characteristics of the bank's statement file. For instance, define the file's format within the Medium Desc field to declare the bank's file (to be uploaded using BKUTLB) is formatted as fixed length or comma-separated value.
Code Category: BKRC
Code Value: xxGEN
Short Description: "Y" / "N" field that dictates if an existing statement may be purged if the statement being imported is a duplicate.
Medium Description: The default is "N" for a fixed width (not delimited) input file. Alternatively, a delimited file may be read. See below for options. (optional)
Code | Delimiter | Example (3 field record) | File extension example |
Blank or "N" or FIXED | NONE | ABC123XYZ | .prn |
Y or COMMA or single comma | Comma | ABC,123,XYZ | .csv |
Long Description: Used to describe this common code. (optional).
Associated Numeric Values
1: Length of bank file record (required). The accuracy of the fixed file's length is critical. Count each character that will upload. Example using the above sample shows a file length of 9. User would then need to place a 9 within the 1st Numeric value; NUUPCD's field would then display the 9 as "9.00000."
2-5: Reserved for future use.
Associated Codes
1: "Y" or "N" – "Y" indicates the Bank Recon file has a header record. All header information will be ignored. The default is no header record. (optional).
2: "Y" or "N" – "Y" indicates the Bank Recon file has a trailer record. All trailer information will be ignored. (optional)
3: Override CKID: Enter 2-character CKID to use for every record. (optional)
4-5: Reserved for future use.
Associated Descriptions
1-5: Reserved for future use.