Appendix > Appendix > Format Requirements for Importing Transactions > Accounts Receivable File Format Requirements > External File Format Requirements for the AR Transaction Detail
External File Format Requirements for the AR Transaction Detail
The table below contains the external file format requirements for the AR Transaction Detail.
 
NOTE: If you are importing a transaction that will not be applied, do not include the detail record in your import. You will not be able to import unapplied transactions with a detail record.
Required fields are noted with an asterisk (*).
Field Order1
 
Field Description
Maximum Field Length2
 
Character Position (Fixed Length Format)3
 
Data Type
12
* Detail Identifier (D)
1
1
Char-Caps
13
* Document to Pay
 
50
2
Char-Caps
14
Discount Override4
 
1
52
Numeric
15
Discount Amount
17
53
Numeric
16
* Apply Amount
17
70
Numeric
 
* End of Record
2
87
 

1 This number is for reference purposes only and will not appear in the actual text file.

2 If the file format is tab or semi-colon delimited, any characters over the specified length will be cut off at the length limit.
If the file format is fixed length (column position) each field must be the exact length shown in the Maximum Field Length column. It cannot be longer or shorter.

3 If the field doesn’t start in the character position specified, it will create an error and potentially prohibit the transaction from being imported.

4 If the Discount Override has a value of 8, then the discount used will be the amount in the Discount Amount field. (0-No Discount; 1-Discount #1; 2-Discount #2; 3-Discount #3; 4-Discount #4; 5-Discount #5; 8‑Special Discount; 9-Normal Discount).

 
Published date: 06/04/2021