Appendix > Appendix > Format Requirements for Importing Transactions > General Ledger File Format Requirements > External File Format Requirements for the GL Transaction Detail
External File Format Requirements for the GL Transaction Detail
The table below contains the external file format requirements for the GL Transaction Detail.
Required fields are noted with an asterisk (*).
Field Order1
 
Field Description
Maximum Field Length2
 
Character Position
(Fixed-Length Format)3
 
Data Type
5
* Detail Identifier
1
1
Char-Caps
6
* Account Number
50
2
Char-Caps
7
Detail Description
50
52
Character
8
* Debit/Credit Flag4
 
1
102
Character
9
Transaction Amount5
 
17
103
Numeric
10
Encumbered Flag (Fund)
1
120
Numeric6
 
* End of Record
2
120 (Accounting) 121(Fund)
 

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 The debit/credit flag must either be blank or contain a “D” for debit or a “C” for credit. If left blank, the field defaults to “D”.

5 This field must contain a positive number.

6 “0” = NO, “1” = YES

Published date: 06/04/2021