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. |