Name

Starting Character Position

Length

Required?

Special Formatting

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

19

4

Yes

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

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