BKRC - xxCOMBO
Convert "Type" 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/xxCOMBO is optional for use with BKUTLB and determines a "Document Type" code based on two fields within the bank file; these fields are defined within the Associated Codes sections.
Create the file and run BKUTLB in trial mode before committing to load a file. Verify the system reads the file correctly and fully before proceeding.
Best practice: Define the usual common codes (CHK, DEP, ADJ, INT, etc.) to determine the intermediate type. The field that provides the finest type granularity should be used. The COMBO common code should be defined for the second less granular field.
Note: Common codes BKRC/xxDEP, BKRC/xxADJ, BKRC/xxINT, BKRC/xxFEE, and BKRC/xxEFT will be ignored if the short description of BKRC/xxCHK set to "ALL." Also note that these common codes represent Document Types. All document types defined typically have the same starting position and field length within the Associated Numeric Values fields.
Code Category: BKRC
Code Value: xxCOMBO
Short Description: Not required.
Medium Description: Not required.
Long Description: Bank file code value(s) that indicate the record is interest. Use a comma to separate multiple values. Do not use spaces. A maximum of six codes may be defined.
Associated Numeric Values
1: Fixed Format: Start position of string to be selected. (Required) Comma Delimited Format: Column number that corresponds to field positions within the file. (Required)
2: Fixed Format: Length of string. (Required)
Comma Delimited Format: Not required.
3-5: Reserved for future use.
Associated Codes
1: Pos 1-3 Intermediate Type (Required)
Pos 4-6 Final Type (Required)
2-5: Repeat of Code 1 Pos 1-6 (Optional)
Associated Descriptions
1: Filter value (Required)
2-5: Repeat of Desc 1.