Summary File Specifications Requirements
Overview
This guide provides detailed information about the fields required for Card Balance File Requirements specific to Account Reconciliation.
File should contain current day balance record.
The file must contain a trailer record that indicates how many balance records were sent with the transmission. Trailer Record is identified by placing ‘TRLR’ in the Frontier Company Field. Actual record count, excluding the trailer, should be 10 digits long and placed in the SourceId field, right justified, zero fill.
The file name be in this format: RF_**CRDBal.txt
Card Balance Fields
Note
Additional fields may be required, based upon business processes specific to the program.
Field Name | Required | Description | Character Length | Example |
---|---|---|---|---|
Company | Yes | Hardcoded abbreviated company name. | 5 | ABCCO |
Source ID | Yes | Hardcoded value of the source of file | 10 | CRDBAL |
Bank No. | Yes | Right-Justified, zero fill (i.e. 001) Value is hardcoded | 3 | 001 |
Account No. | Yes | Right-Justified, zero fill. Values to be provided. | 15 | 5300000000 |
Cost Center | Yes | Right-Justified, zero fill. Values to be provided by the bank | 5 | 40440 |
Amount | Yes | Right-Justified, zero fill – Explicit decimals (2 decimals positions). Represents end of day total customer balance. | 20 | 25000.00 |
DCIP | Yes | Code must be translated into Debit, or Credit (case sensitive). | 6 | Debit |
Date Posted | Yes | YYYYMMDD. | 8 | 20240101 |
Updated 8 days ago