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.

Field NameRequiredDescriptionCharacter LengthExample
CompanyYesHardcoded abbreviated company name.5ABCCO
Source IDYesHardcoded value of the source of file10CRDDTL
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 fill504044
ClassyesRight-Justified, zero fill. Values to be provided by the bank501410
AmountyesRight-Justified, zero fill – Explicit decimals (2 decimals positions)2045000.00
DCIPYesDebit, or Credit (case sensitive).6Debit
Date PostedYesYYYYMMDD.820240101
Date AvailableYesYYYYMMDD.820240102
Description Field 1NoCan be used for multiple options but will most likely be the card number on transaction.1504555123412348880
Description Field 2NoCan be used for multiple options50
Tran CodeYesTransaction Code1016516000