Important JD Edwards EnterpriseOne Time and Labor Tables

This table lists the key tables:

Table Name

Table Description

Address Book Master (F0101)

Contains name and address information for all employees.

Employee Master Information (F060116)

Contains detailed information about employees, such as salary, pay grade, birth date, and job type.

Job Information (F08001)

Contains information for job ID and for the job evaluation. The job ID is the combination of the job type and job step.

Employee Transactions - Batch File (F06116Z1)

Contains timecard information that has been uploaded from a third-party time tracking system. Timecards in this table must be reviewed, approved, and transferred to F06116 before they can be processed in the system.

Employee Transaction Detail File (F06116)

Contains detailed timecard information for employees.

Employee Transaction History (F0618)

Contains detailed history information associated with processed timecards.

Union Rate File (F069126)

Contains pay rate information that is recorded by union and job ID.

Employees Pay Rate File (F060146)

Contains pay rate information that is recorded by job ID.

Automatic Accounting Instructions (F06904)

Contains detailed account information that is used to derive timecard account numbers.

Shift Differential (F069246)

Contains information about special pay rates that are associated with specified work shifts.

Payroll Transaction Constants (F069116)

Contains detailed information about each pay type, deduction, benefit, and accrual (PDBA).

Employee Pay Instructions (F06106)

Contains instructions for splitting and prorating employee timecard information across specified business units.

Business Unit Master (F0006)

Contains detailed information about each job or business unit that is set up in the organization.

Account Balances (F0902)

Contains account balance information for each account in the general ledger.

Account Ledger (F0911)

Contains detailed journal entry information that is reviewed and then transferred to F0902.