BKRC - xxTRANNO
Non-Check Reference 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).
This common code is optional and defines unique transaction reference position within bank file for non-checks; typically, this will be the same column or starting position as the Document Number (BKRC/xxCKNUM). If this unique reference is not provided in the bank file, add a system-generated seed value by adding a defined seed code in the medium description so that a unique reference may be derived.
Note: The user can either define the transaction reference position or the seed for non-checks, not both. Also note that records given system-generated seeds will only auto match within BKUPRC if BKUPCD has a matching record (same Document Number) within BKUPBA. Otherwise the user will then need to manually match value or other characteristics to reconcile.
Code Category: BKRC
Code Value: xxTRANNO
Short Description: Set to "Y" to only use the seed value in the Med Desc if the reference number is blank or zero. The default is always to use the seed number. (Optional)
Medium Description: SYNO common code value seed to derive unique reference field (BKR-NUMBER) used only if bank does not provide a reference number for non-checks. The seed common code must also be defined as SYNO/xxxxxx (where SYNO is the code category and "xxxxxx" is the value entered in the Med Desc). Do not enter the code category or "/". Do not define if Val 1 or Val 2 is defined. (Required – if Short Desc is not "Y," otherwise optional).
Long Description: Used to describe the common code. (Optional)
Associated Numeric Values
1: Fixed Format: Start position of non-check reference field. (Required – if Med Desc is not defined)Comma Delimited Format: Column number that corresponds to field position within the file. (Required – if Med Desc is not defined)
2: Fixed Format: Length of non-check reference. (Required – if Med Desc is not defined)Comma Delimited Format: Length of non-check reference. (Required– if Med Desc is not defined)
3-5: Reserved for future use.
Associated Codes, Associated Descriptions
1-5: Reserved for future use.