Labor Ledger Upload Flat File Format

The following format can be used to upload documents via the Labor Ledger Correction Process document. No header or trailer records are required for these files. The files should only contain the labor ledger entries.

Labor 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

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

 

Position Number

57

8

No

 

Project Code

 

65

10

No

 

Transaction Description

75

40

Yes

 

Transaction Amount

115

21

Yes

Signed dollar amount with 2 decimal places

Debit/Credit Code

136

1

Yes

Must have value ‘D’ or ‘C’

Transaction Date

137

10

No

YYYY-MM-DD format

Organization Document Number

147

10

No

 

Organization Reference ID

157

8

No

 

Reference Document Type Code

165

4

No

 

Reference Origination Code

169

2

No

 

Reference Document Number

171

14

No

 

Reversal Date

185

10

No

YYYY-MM-DD format

Encumbrance Update Code

195

1

No

Valid values are “R” and “D”

Post Date

196

10

No

YYYY-MM-DD format

Pay Period End Date

206

10

No

YYYY-MM-DD format

Total Hours

216

9

No

 

Payroll Fiscal Year

225

4

No

 

Payroll Fiscal Period

229

2

No

 

Employee ID

231

11

No

 

Employee Record Number

242

3

No

 

Earn Code

245

3

No

 

Paygroup

248

3

No

 

Salary Admin Plan

251

4

No

 

Grade

255

3

No

 

Payroll Run ID

258

10

No

 

Original Chart of Accounts Code

268

2

No

 

Original Account Number

270

7

No

 

Original Sub-Account Number

277

5

No

 

Original Object Code

282

4

No

 

Original Sub-Object Code

286

3

No

 

Company

289

3

No

 

Set Id

292

3

No

 

More:

Balance Inquiries