BKRC - xxCKDATE
Convert the "Date" 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/xxCKDATE is required for loading the bank's processing date into BKUTLB, BKUPBA, and BKUPCD. This code indicates the date that the "document" was officially recognized by the bank. The "document" may be a check, deposit, interest, or other Document Type; these documents are records within the bank statement file. Additionally, this date serves many purposes within the BK database. The CKDATE starts as the "Clear Dt" on the BKUTLB's report of file data (verify date parses correctly). Once the statement is loaded successfully into BKUPBA, the CKDATE is then titled "Entry Date." Then after the matching process is performed for the statement using BKUPRC, the record held in BKUPCD will be updated with a "Cancel Date," which is the CKDATE. In summary, the CKDATE is the Entry date, Clear Date, and the Cancel Date.
The Medium Desc field holds a date format code. Review the options below and identify the format that best fits the description of the bank's date format.
Create the file and run BKUTLB in trial mode before committing to load a file. Again, verify the date parses correctly. Also verify the system reads the file correctly and fully before proceeding.
Code Category: BKRC
Code Value: xxCKDATE
Short Description: Reserved for future use.
Medium Description: Define date format (Required)
Fixed Format: There is no error checking here, so choose wisely. "Y" - indicates year position, "M" indicates month position, "D" indicates day position. "/" indicates any filler position. Do not use spaces or any other characters. Examples:
YYYYMMDD
YYMMDD
YMMDD
DD / MM / YY
DD / MM / YYYY
DDMMYY
DDMMYYYY
Comma Delimited Format: The following date formats are available and must be used for CSV files where a date can be in any of these formats (6/10/2015, 10/1/2015, 1/1/2015) There is some duplication with the above formats.
Code | Input Format | Example (date of July 1st, 2015) |
DR | MMDDYY | 070115 |
DS | MM/DD | 07/01 |
DT | MM/DD/YY or MMDDYY | 07/01/15 or 070115 |
DU | MM/DD/CCYY or MMDDCCYY | 07/01/2015 or 07012015 |
DV | DD/MM/YY | 01/07/15 |
DW | DD/MM/CCYY | 01/07/2015 |
DX | YY/MM/DD | 15/07/01 |
DY | CCYY/MM/DD | 2015/07/01 |
DZ | MM/YY | 07/15 |
Long Description: Not required.
Associated Numeric Values
1: Fixed Format: Start position of date field indicator (required), or Comma Delimited Format: Column number that corresponds to date field positions within the file. (Required).
2: Fixed Format: Length of date field. (Required.) Note that if using a format that includes the "/" (slash), the slash will count as a character. The example of "01/01/2016" is 10 characters long. Comma Delimited Format: Not required.
3-5: Reserved for future use.
Associated Codes, Associated Descriptions
1-5: Reserved for future use.