Purpose |
Details |
Employee Master |
Time Entry |
Payroll Cycle |
History |
A/P Integration/Journals |
Taxes |
This document provides a list of the most commonly used tables for the EnterpriseOne Payroll application.
F060116 | Employee Master |
F06017 | Employee Tax Overrides |
F0701732 | Additional Tax overrides |
F0101 | Address Book |
F06106 | DBA Instructions |
F060146 | Employee Pay Rate Table |
F065016 | Auto Deposit Instructions |
F06116 | Timecard Detail |
F0709 | DBA Detail |
F06116Z1 | Employee Transactions - Batch File |
F07210 | Pay Cycle Parameters |
F0709 | DBA Detail |
F07300 | Employee Lockout Table (does not clear after final update) |
F07350 | Payment Table |
F07351 | Payment Distributions |
F07352 | Stub Detail |
F07353 | Tax Detail |
F07241 | Journals (Burden Distribution Table) |
F075506 | Auto Deposit Bank Workfile |
F0705 | DBA Period Control |
F07107 | Employee Wage Attachment Rules |
F0729 | Employee DBA Override Instructions |
F07235 | Auto Deposit Bank Workfile |
F0618 | Timecard History |
F0719 | DBA Detail History |
F06136 | Tax Summary (Pay & Taxes) |
F06146 | DBA Summary (Uses Check Date/Payroll Mo) |
F06145 | DBA Summary (Uses PPED/Calendar Mo) |
F06156 | Paycheck Summary (Paycheck Review and Void) |
F06166 | Tax Detail (Check Tax History Detail) |
F07186 | Stub Information Table |
F0627 | Workers Comp History |
F06116Z2 | ESS Timecard History |
F0716 | Tax Detail (Canada) |
F0713 | Tax Summary (Canada) |
F06176 | Unemployment/EI (Canada) |
F05290 | Detail Journal Entries |
F07490 | Voucher Detail |
F07491 | Voucher Summary |
F07492 | Voucher Control |
F0411 | A/P Ledger File |
F063951 | Summary Journal Entries |
F0911 | Account Ledger (General Accounting) |
F0701730 | Populate Vertex Filing Status |
F07500 | Geocoder Report Setup |
F0701740 | Quantum Control Table (stores CPP pay period exemptions) |