Labor Ledger Flat File Format

Overview

This format can be used to upload documents via the Labor Ledger Correction Process document or used as a data file for the Labor Enterprise Batch Feed upload. 

No header or trailer records are required for these files. They should contain only the Labor Ledger entries.

A sample labor ledger file can be accessed from the Accounts and Files to use when Testing in Monsters.

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 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, leave blank if budget transaction.
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 (update open amount) and D (update closed amount) and N (none)
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

 

Labor Enterprise Feed Reconciliation Flat File Format

• When using the Labor Enterprise Batch Feed upload, you must submit a reconciliation (recon) file along with the entry file. This file verifies the count of records and the dollar amount of your entry file. If these files do not reconcile, Financials will not process the file and will generate an error message on the Enterprise Feed report.
• The file will contain three types of rows as detailed below. Each element of each row must be separated by a single space and each row ends with a semi-colon.
• A c row identifying the table being impacted (gl_entry_t or ld_ldgr_entr_t) and the row count of the data file. For example: c gl_entry_t  2 or c ld_ldgr_entr_t  2;
• An S row identifying the field where the dollar amount is found (trn_ldgr_entr_amt) and the dollar amount of the data file. For example: s trn_ldgr_entr_amt 27680.00;
• An e row identifying the number of c and s rows found in the reconciliation file (always 2). For example: e 02;
• So an entire reconciliation made up of these rows would contain the following:

c ld_ldgr_entr_t   2;

s trn_ldgr_entr_amt   27680.00;

e 02;