Payroll Tables - EnterpriseOne

rdg

Member
Can someone please help me to find a document that has all Payroll tables and relations among them?

Thanks
 
Oracle and JD Edwards have never published an ERD. You need to search for payroll books or use data browser.
 
Hi,
Some of the payroll related tables in JDE:
Object Name Member Description
F051375 ADP Payroll DBA Transaction Constants
F05290 WF - Payroll Journal (Detail)
F06210 Payroll Cycle Parameters
F06290 Payroll Accounting Journal Work File
F06345 Historical Payroll Register
F063951 Payroll Journal (Compressed) File
F06490 Payroll/Accounts Payable Ledger Detail
F06491 Payroll/Accounts Payable Ledger Detail
F06492 Payroll - Accounts Payable Control
F06900 Payroll Fiscal Patterns
F069016 Payroll Tax Area Profile
F069016T Payroll Tax Area Profile - Tag File
F069026 Payroll Generic Tables
F069036 Payroll Transaction Cross Reference
F069086 Payroll Corporate Tax Identification
F069096 Payroll General Constants
F069116 Payroll Transaction Constants
F069171 Payroll Payment/ Reporting Terms
F07355 Pre-Payroll Error File
F07490 Payroll - Accounts Payable Detail (One World)
F07491 Payroll - Accounts Payable Summary File
F07492 Payroll - Accounts Payable Control File
F07901 Pre-Payroll DBA Calculation Control Table
F07992 Payroll Tax History Conversion Data
F08095 Payroll Resume/HR Conversion
F48S0618 Payroll Reclassification Workfile
F75A0401 Australia State Payroll Tax Thresholds and Rates
F75A0402 Australia State Payroll Tax Threshold Proration Formulas
F75A0403 Australia State Payroll Tax Company Groups
F75A0404 Australia State Payroll Tax Company Group Members
F75A0405 Australia State Payroll Tax Eligible PDBs
F75A0406 Australia State Payroll Taxable Wages History
F75A0407 Australia State Payroll Tax Liability History
F77703 Payroll History Audit Report - Worktable
 
Back
Top