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 NameRequiredDescriptionCharacter LengthExample
CompanyYesHardcoded abbreviated company name.5ABCCO
Source IDYesHardcoded value of the source of file10CRDBAL
Bank No.YesRight-Justified, zero fill (i.e. 001) Value is hardcoded3001
Account No.YesRight-Justified, zero fill. Values to be provided.155300000000
Cost CenterYesRight-Justified, zero fill. Values to be provided by the bank540440
AmountYesRight-Justified, zero fill – Explicit decimals (2 decimals positions). Represents end of day total customer balance.2025000.00
DCIPYesCode must be translated into Debit, or Credit (case sensitive).6Debit
Date PostedYesYYYYMMDD.820240101