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.
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 (KFS-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 Description |
57 |
40 |
Yes |
|
Transaction Amount |
97 |
21 |
Yes |
Signed dollar amount with 2 decimal places |
Debit/Credit Code |
118 |
1 |
Yes |
Must have value 'D' or 'C' |
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 |
|
|
187 |
1 |
No |
Valid values are “R” and “D” |
More: