General Ledger Flat File Format

This format can be used to upload documents via the General Ledger Correction Process document or used as a data file for the Enterprise Batch Feed upload.

 No header or trailer records are required for these files. They should contain only the General Ledger entries.

An example file with both actual, encumbrance and budget transactions is available for download here. 

General Ledger flat file format

Name	Starting Character Position	Length	Required?	Special Formatting
Fiscal Year	1	4	No
Chart of Accounts Code	5	2	Yes	Can be left blank if the GL Pre-Scrubber is being used and accounts do not cross charts (Financials-SYS ACCOUNTS_CAN_CROSS_CHARTS_IND parameter must be set to N)
Account Number	7	7	Yes
Sub-Account Number	14	5	No
Object Code	19	4	Yes
Sub-Object Code	23	3	No
Balance Type Code	26	2	No
Object Type Code	28	2	No
Fiscal Period Code	30	2	No
Document Type Code	32	4	Yes
System Origination Code	36	2	Yes
Financial Document Number	38	14	Yes
Entry Sequence Number	52	5	No	Transaction entry sequence number must be numeric. Null and blank values are replaced with zeroes. Non-numeric values are demerged and do not post.
Transaction Description	57	40	Yes
Transaction Amount	97	21	Yes	Signed (+ or -) dollar amount with 2 decimal places
Debit/Credit Code	118	1	Yes	Must have value D or C, leave blank if budget transactions.
Transaction Date	119	10	No	YYYY-MM-DD format
Organization Document Number	129	10	No
Project Code	139	10	No
Organization Reference ID	149	8	No
Reference Document Type Code	157	4	No
Reference Origination Code	161	2	No
Reference Document Number	163	14	No
Reversal Date	177	10	No
Encumbrance Update Code	187	1	No	Valid values are R (update open amount) and D (update closed amount) and N (none)