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.

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

 

Encumbrance Update Code

187

1

No

Valid values are “R” and “D”

More:

Enterprise Feed Reconciliation Flat File Format