Detail File Specifications Requirements

Overview

This guide provides detailed information about the fields required for Card Details File Requirements specific to Account Reconciliation.

The file must contain a trailer record that indicates how many detail 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 needs to use this format: RF_XXXXDetail.txt

❗️

Important

There should be a summary record on the file that nets the file by account to zero.

Here is a Bank Account Level Example:

If the file has three detail records for Account A for $100.00 debit, $35.00 credit and $50.00 debit and Account B has two records for $72.00 debit and $34.00 credit, the following records should be included (details are below):

• Summary record for Account A - $115.00 debit
• Summary record for Account B - $38.00 debit

Card Details Fields

📘

Note

Additional fields may be required, based upon business processes specific to the program.