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 formats:

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

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