JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides |  920 VMs | Schema:
920 910 812
System  Table 
Column 
Searchbeta 

JDE Ref icon of database logic symbolJDE TABLESv3Made in Britain

SAPTables.Net - the webs number one SAP Tables Definition reference

920: Top 10 requests

TablePrefixDescription
1F4211SDSales Order Detail File
2F0101ABAddress Book Master
3F4101IMItem Master
4F0911GLAccount Ledger
5F4311PDPurchase Order Detail File
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F0006MCBusiness Unit Master
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

116 columns | Print definition?920 | HMCO

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP05: Time Accounting and HRM Base
1F051124Director Text Setup File1Y4HMCOCompany - HomeStringGeneric Edit50
2F0605D/B/A Period Control File7J@HMCOCompany - HomeStringGeneric Edit50
3F0609Deduction/Benefit/Accrual Ledger File12Y$HMCOCompany - HomeStringGeneric Edit50
4F06145Calendar Month DBA Summary History File7YHHMCOCompany - HomeStringGeneric Edit50
5F06149Fiscal and Anniversary Rollover Work File5Y7HMCOCompany - HomeStringGeneric Edit50
6F0618Employee Transaction History8YTHMCOCompany - HomeStringGeneric Edit50
7F0619Benefit/Accrual Detail File12Y$HMCOCompany - HomeStringGeneric Edit50
8F0626Wage Attachment Control File13JGHMCOCompany - HomeStringGeneric Edit50
9F0627Workers Compensation Summary History6JHHMCOCompany - HomeStringGeneric Edit50
10F069116Payroll Transaction Constants91YCHMCOCompany - HomeStringGeneric Edit50
11F06915Holiday Table2JHHMCOCompany - HomeStringGeneric Edit50
12F06920Savings Bond General Constant1YQHMCOCompany - HomeStringGeneric Edit50
13F06926Tax Area/ Vendor Cross Reference3Y#HMCOCompany - HomeStringGeneric Edit50
14F0709Deduction/Benefit/Accrual Ledger File14Y$HMCOCompany - HomeStringGeneric Edit50
TOP05A: PeopleSoft HR & PR Foundation
15F05003Verification of Employment Data25EVHMCOCompany - HomeStringGeneric Edit50
16F05844Approval Hierarchy Table1AHHMCOCompany - HomeStringGeneric Edit50
17F060116Employee Master Information21YAHMCOCompany - HomeStringGeneric Edit50
18F0601161Point-In-Time Employee Master23PTHMCOCompany - HomeStringGeneric Edit50
19F060116WEE Master Request File21YAHMCOCompany - HomeStringGeneric Edit50
20F060116ZUnedited Quick Hire Transaction File22SZHMCOCompany - HomeStringGeneric Edit50
21F06345Historical Payroll Register6JLHMCOCompany - HomeStringGeneric Edit50
TOP05T: Time Entry
22F051123Self Service Time Entry Layout Setup File1Y3HMCOCompany - HomeStringGeneric Edit50
23F06116Employee Transaction Detail File8YTHMCOCompany - HomeStringGeneric Edit50
24F06116Z1Employee Transactions - Batch File25VLHMCOCompany - HomeStringGeneric Edit50
25F06116Z2ESS Timecard History25VMHMCOCompany - HomeStringGeneric Edit50
26F0623Piecework History File10JLHMCOCompany - HomeStringGeneric Edit50
27F06278Retro Timecard Detail File11YTHMCOCompany - HomeStringGeneric Edit50
28F06290Payroll Accounting Journal Work File22YRHMCOCompany - HomeStringGeneric Edit50
TOP06: Payroll (old) - Obsolete-do not reuse
29F06146Employee Transaction History Summary7YNHMCOCompany - HomeStringGeneric Edit50
TOP07: Payroll
30F055011WAuto Deposit Instructions Work File4ADHMCOCompany - HomeStringGeneric Edit50
31F06136Tax History6YZHMCOCompany - HomeStringGeneric Edit50
32F06136ATax Summary (Additional)7YZHMCOCompany - HomeStringGeneric Edit50
33F06136BTax Summary (PA ACT 32)7YZHMCOCompany - HomeStringGeneric Edit50
34F06147Fiscal and Anniversary Year History5YDHMCOCompany - HomeStringGeneric Edit50
35F06148Tax Area Transaction History6Y@HMCOCompany - HomeStringGeneric Edit50
36F06156Pay Check History Summary27YUHMCOCompany - HomeStringGeneric Edit50
37F06166Pay Check History Tax Ledger17YVHMCOCompany - HomeStringGeneric Edit50
38F06166ATax Ledger (Additional)19YVHMCOCompany - HomeStringGeneric Edit50
39F06166BTax Ledger (PA ACT 32)12YVHMCOCompany - HomeStringGeneric Edit50
40F06270Retro Processing Parameter38JPHMCOCompany - HomeStringGeneric Edit50
41F063106Deduction/Benefit Work File4Y7HMCOCompany - HomeStringGeneric Edit50
42F06350IWF - Paycheck (Interims)36Y4HMCOCompany - HomeStringGeneric Edit50
43F06490Payroll/Accounts Payable Ledger Detail7JRHMCOCompany - HomeStringGeneric Edit50
44F065016Automatic Bank Deposit Master4YGHMCOCompany - HomeStringGeneric Edit50
45F068500941 - Federal Tax History11YZHMCOCompany - HomeStringGeneric Edit50
46F06900Payroll Fiscal Patterns1Y$HMCOCompany - HomeStringGeneric Edit50
47F0701734Prior Head Tax from a Previous Employer8Y3HMCOCompany - HomeStringGeneric Edit50
48F0701740Quantum Control Tax11YQHMCOCompany - HomeStringGeneric Edit50
49F0701741Canadian Deduction11YDHMCOCompany - HomeStringGeneric Edit50
50F0705DBA Period Control File8J@HMCOCompany - HomeStringGeneric Edit50
51F07107Employee Wage Attachment Rules16JWHMCOCompany - HomeStringGeneric Edit50
52F07149Accrual Fiscal/Anniversary History Work File5Y8HMCOCompany - HomeStringGeneric Edit50
53F0716701Employee Assignment T/E Template Information26EAHMCOCompany - HomeStringGeneric Edit50
54F0716709Employee Assignment T/E Template Info History26EAHMCOCompany - HomeStringGeneric Edit50
55F0717ROE Summary History36JFHMCOCompany - HomeStringGeneric Edit50
56F0719DBA Transaction Detail History14Y$HMCOCompany - HomeStringGeneric Edit50
57F07235Auto Deposit Bank Workfile4Y6HMCOCompany - HomeStringGeneric Edit50
58F07236Auto Deposit Tape File Setup1Y6HMCOCompany - HomeStringGeneric Edit50
59F07236TAuto Deposit Tape File Setup (Additional)1Y6HMCOCompany - HomeStringGeneric Edit50
60F0729Employee DBA Override Instructions61Y9HMCOCompany - HomeStringGeneric Edit50
61F07350Payment File10Y0HMCOCompany - HomeStringGeneric Edit50
62F07353Tax Detail File22Y3HMCOCompany - HomeStringGeneric Edit50
63F07355Pre-Payroll Error File24Y5HMCOCompany - HomeStringGeneric Edit50
64F073911Leave Rollover Balance Report Work File3Y8HMCOCompany - HomeStringGeneric Edit50
65F074001New Hire Reporting Workfile - OneWorld Only47NHHMCOCompany - HomeStringGeneric Edit50
66F07490Payroll - Accounts Payable Detail (One World)7JRHMCOCompany - HomeStringGeneric Edit50
67F077011BTax Integrity (PA Act32)2Y3HMCOCompany - HomeStringGeneric Edit50
68F07727Canadian Pension Information2J7HMCOCompany - HomeStringGeneric Edit50
69F07822Company Federal Control Table3JIHMCOCompany - HomeStringGeneric Edit50
70F07824Company State/Local Control Table3JDHMCOCompany - HomeStringGeneric Edit50
71F07825Company Special Handling Control Table3JAHMCOCompany - HomeStringGeneric Edit50
72F07830Employee Federal Control Table60Y0HMCOCompany - HomeStringGeneric Edit50
73F07831Employee State/Local Control Table36YBHMCOCompany - HomeStringGeneric Edit50
74F07832Employee Special Handling Control Table22YHHMCOCompany - HomeStringGeneric Edit50
75F078506ADP Company Code to JDE Company Code1YJHMCOCompany - HomeStringGeneric Edit50
76F07880SUI Magnetic Media Workfile2YWHMCOCompany - HomeStringGeneric Edit50
77F07885SUI Payments for Quarterly Reporting1YWHMCOCompany - HomeStringGeneric Edit50
78F07UI200Timecard History Work File11THHMCOCompany - HomeStringGeneric Edit50
TOP08: Human Resources
79F08116ACA Applicable Large Employer2ACHMCOCompany - HomeStringGeneric Edit50
80F081161ACA Employee Eligibility24ADHMCOCompany - HomeStringGeneric Edit50
81F0811619ACA Employee Eligibility Archive24ADHMCOCompany - HomeStringGeneric Edit50
82F081163ACA Home Company Summary4ASHMCOCompany - HomeStringGeneric Edit50
83F0811639ACA Home Company Summary Archive4ASHMCOCompany - HomeStringGeneric Edit50
84F08771CBPA System Company Constants1XGHMCOCompany - HomeStringGeneric Edit50
85F087711BPerformance Appraisal Header Template Keys4XKHMCOCompany - HomeStringGeneric Edit50
86F08771ACBPA System Company Constants Tag Table1XGHMCOCompany - HomeStringGeneric Edit50
87F08773CBPA System Appraisal Type Overrides2XLHMCOCompany - HomeStringGeneric Edit50
88F08773ACBPA System Appraisal Type Overrides Tag Table2XLHMCOCompany - HomeStringGeneric Edit50
89F08776CBPA Appraisal Templates2XOHMCOCompany - HomeStringGeneric Edit50
TOP08AD: ADP Integration
90F05137ADP Employee Master Information36ADHMCOCompany - HomeStringGeneric Edit50
91F051375ADP Payroll DBA Transaction Constants93ADHMCOCompany - HomeStringGeneric Edit50
TOP08H: Health and Safety
92F08601Injury/Illness Case Master9HLHMCOCompany - HomeStringGeneric Edit50
TOP08U: PeopleSoft HR US
93F08360Nondiscrimination Groups4HEHMCOCompany - HomeStringGeneric Edit50
94F08367NDT - Company Selection Criteria3HZHMCOCompany - HomeStringGeneric Edit50
95F083675NDT - Prior Year Testing Method Selection Criteria3PFHMCOCompany - HomeStringGeneric Edit50
96F08368NDT - Nondiscrimination Totals3DBHMCOCompany - HomeStringGeneric Edit50
97F08910COBRA Qualified Beneficiary File28J1HMCOCompany - HomeStringGeneric Edit50
98F08992Qualifying Event Rules Header3QEHMCOCompany - HomeStringGeneric Edit50
TOP08W: Wage and Salary
99F08201Salary Review Workfile6HRHMCOCompany - HomeStringGeneric Edit50
TOP18: Timecard Automation
100F186602Labor Rules Tag File22TFHMCOCompany - HomeStringGeneric Edit50
TOP48S: Service Billing
101F48S0618Payroll Reclassification Workfile8YTHMCOCompany - HomeStringGeneric Edit50
TOP54HS: Health & Safety Incident Mgt
102F54HS02Incident People18S2HMCOCompany - HomeStringGeneric Edit50
103F54HS02MIncident People Change History21I2HMCOCompany - HomeStringGeneric Edit50
TOP74U: United Kingdom Localizations
104F74U4051Header - CIS Monthly Return - UK - 042HMCOCompanyStringGeneric Edit50
105F74UUI51Header - XML Work File CIS Monthly Return - UK - 042HMCOCompanyStringGeneric Edit50
TOP75A: Australia
106F75A0140Australian Payment Summary2ZGHMCOCompany - HomeStringGeneric Edit50
107F75A0500AU Bonus and Back Pay Tax Workfile10BPHMCOCompany - HomeStringGeneric Edit50
108F75A0501AU Bonus and Back Pay Tax History10THHMCOCompany - HomeStringGeneric Edit50
TOP77: Payroll (Canadian)
109F06176Unemployment Insurance History File13YSHMCOCompany - HomeStringGeneric Edit50
110F0713Tax History6YZHMCOCompany - HomeStringGeneric Edit50
111F0713SAVBackup Copy of F0713 For Tax Ledger Repost6YZHMCOCompany - HomeStringGeneric Edit50
112F0716Pay Check History Tax Ledger - Canadian DB17YVHMCOCompany - HomeStringGeneric Edit50
113F07183Commission History Detail File9ZBHMCOCompany - HomeStringGeneric Edit50
114F77220Employee Special Handling Detail - F772206J3HMCOCompany - HomeStringGeneric Edit50
115F77230Employee Pension Maintenance - F772302J8HMCOCompany - HomeStringGeneric Edit50
116F77703Payroll History Audit Report - Worktable2ARHMCOCompany - HomeStringGeneric Edit50