Appendix > Appendix > Format Requirements for Importing Transactions > General Ledger File Format Requirements > External File Format Requirements for the GL Transaction Header
External File Format Requirements for the GL Transaction Header
The table below contains the external file format requirements for the GL Transaction Header.
Required fields are noted with an asterisk (*).
Field Order1
 
Field Description
Maximum Field Length2
 
Character Position
(Fixed-Length Format)3
 
Data Type
1
* Header Identifier
1
1
Char-Caps
2
* Transaction Date4
 
10
2
Date
3
* Posting Reference
50
12
Char-Caps
4
Transaction Description
50
62
Character
 
* End of Record (EOR)
02
112
 

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 transaction date is left blank, it will be imported as zeros. The transaction date must be in either MM/DD/YYYY or M/D/YYYY format.

Published date: 06/04/2021