Appendix > Appendix > Format Requirements for Importing Transactions > Bank Reconciliation File Format Requirements > External File Format Requirements for the BR Activity Detail
External File Format Requirements for the BR Activity Detail
The table below contains the external file format requirements for the BR Activity Detail.
Required fields are noted with an asterisk (*).
Field Order1
 
Field Description
Maximum Field Length2
 
Character Position
(Fixed-Length Format)3
 
Data Type
18
* Detail Identifier
1
1
Char-Caps
19
Line Description4
50
2
Character
20
* GL Expense Acct
 
50
52
Char-Caps
21
Inv/Doc Number
50
102
Char-Caps
22
* Detail Amount
17
152
Numeric
23
Cash Deposit
1
169
Numeric
 
* End of Record
2
170
 

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 is 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 This is a required field if Bank Reconciliation is integrated to General Ledger.

 
Published date: 06/04/2021