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) |
Comments
0 comments
Please sign in to leave a comment.