Common Payroll Tables

Purpose
Details
 Employee Master
 Time Entry
 Payroll Cycle
 History
 A/P Integration/Journals
 Taxes

Purpose

 This document provides a list of the most commonly used tables for the EnterpriseOne Payroll application.

Details

Employee Master

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

Time Entry

F06116 Timecard Detail
F0709 DBA Detail
F06116Z1 Employee Transactions  - Batch File

Payroll Cycle

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

History

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)

A/P Integration/Journals

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)

Taxes

F0701730 Populate Vertex Filing Status
F07500 Geocoder Report Setup
F0701740 Quantum Control Table (stores CPP pay period exemptions)