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
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

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

110 columns | Print definition?910 | 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: OW 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
30F06136Tax History6YZHMCOCompany - HomeStringGeneric Edit50
31F06136ATax Summary (Additional)7YZHMCOCompany - HomeStringGeneric Edit50
32F06136BTax Summary (PA ACT 32)7YZHMCOCompany - HomeStringGeneric Edit50
33F06147Fiscal and Anniversary Year History5YDHMCOCompany - HomeStringGeneric Edit50
34F06148Tax Area Transaction History6Y@HMCOCompany - HomeStringGeneric Edit50
35F06156Pay Check History Summary27YUHMCOCompany - HomeStringGeneric Edit50
36F06166Pay Check History Tax Ledger17YVHMCOCompany - HomeStringGeneric Edit50
37F06166ATax Ledger (Additional)19YVHMCOCompany - HomeStringGeneric Edit50
38F06166BTax Ledger (PA ACT 32)12YVHMCOCompany - HomeStringGeneric Edit50
39F06270Retro Processing Parameter38JPHMCOCompany - HomeStringGeneric Edit50
40F063106Deduction/Benefit Work File4Y7HMCOCompany - HomeStringGeneric Edit50
41F06350IWF - Paycheck (Interims)36Y4HMCOCompany - HomeStringGeneric Edit50
42F06490Payroll/Accounts Payable Ledger Detail7JRHMCOCompany - HomeStringGeneric Edit50
43F065016Automatic Bank Deposit Master4YGHMCOCompany - HomeStringGeneric Edit50
44F068500941 - Federal Tax History11YZHMCOCompany - HomeStringGeneric Edit50
45F06900Payroll Fiscal Patterns1Y$HMCOCompany - HomeStringGeneric Edit50
46F0701734Prior Head Tax from a Previous Employer8Y3HMCOCompany - HomeStringGeneric Edit50
47F0701740Quantum Control Tax11YQHMCOCompany - HomeStringGeneric Edit50
48F0701741Canadian Deduction11YDHMCOCompany - HomeStringGeneric Edit50
49F0705DBA Period Control File8J@HMCOCompany - HomeStringGeneric Edit50
50F07107Employee Wage Attachment Rules16JWHMCOCompany - HomeStringGeneric Edit50
51F07149Accrual Fiscal/Anniversary History Work File5Y8HMCOCompany - HomeStringGeneric Edit50
52F0716701Employee Assignment T/E Template Information26EAHMCOCompany - HomeStringGeneric Edit50
53F0716709Employee Assignment T/E Template Info History26EAHMCOCompany - HomeStringGeneric Edit50
54F0717ROE Summary History36JFHMCOCompany - HomeStringGeneric Edit50
55F0719DBA Transaction Detail History14Y$HMCOCompany - HomeStringGeneric Edit50
56F07235Auto Deposit Bank Workfile4Y6HMCOCompany - HomeStringGeneric Edit50
57F07236Auto Deposit Tape File Setup1Y6HMCOCompany - HomeStringGeneric Edit50
58F07236TAuto Deposit Tape File Setup (Additional)1Y6HMCOCompany - HomeStringGeneric Edit50
59F0729Employee DBA Override Instructions61Y9HMCOCompany - HomeStringGeneric Edit50
60F07350Payment File10Y0HMCOCompany - HomeStringGeneric Edit50
61F07353Tax Detail File22Y3HMCOCompany - HomeStringGeneric Edit50
62F07355Pre-Payroll Error File24Y5HMCOCompany - HomeStringGeneric Edit50
63F073911Leave Rollover Balance Report Work File3Y8HMCOCompany - HomeStringGeneric Edit50
64F074001New Hire Reporting Workfile - OneWorld Only47NHHMCOCompany - HomeStringGeneric Edit50
65F07490Payroll - Accounts Payable Detail (One World)7JRHMCOCompany - HomeStringGeneric Edit50
66F077011BTax Integrity (PA Act32)2Y3HMCOCompany - HomeStringGeneric Edit50
67F07727Canadian Pension Information2J7HMCOCompany - HomeStringGeneric Edit50
68F07822Company Federal Control Table3JIHMCOCompany - HomeStringGeneric Edit50
69F07824Company State/Local Control Table3JDHMCOCompany - HomeStringGeneric Edit50
70F07825Company Special Handling Control Table3JAHMCOCompany - HomeStringGeneric Edit50
71F07830Employee Federal Control Table60Y0HMCOCompany - HomeStringGeneric Edit50
72F07831Employee State/Local Control Table36YBHMCOCompany - HomeStringGeneric Edit50
73F07832Employee Special Handling Control Table22YHHMCOCompany - HomeStringGeneric Edit50
74F078506ADP Company Code to JDE Company Code1YJHMCOCompany - HomeStringGeneric Edit50
75F07880SUI Magnetic Media Workfile2YWHMCOCompany - HomeStringGeneric Edit50
76F07885SUI Payments for Quarterly Reporting1YWHMCOCompany - HomeStringGeneric Edit50
77F07UI200Timecard History Work File11THHMCOCompany - HomeStringGeneric Edit50
TOP08: Human Resources
78F08771CBPA System Company Constants1XGHMCOCompany - HomeStringGeneric Edit50
79F087711BPerformance Appraisal Header Template Keys4XKHMCOCompany - HomeStringGeneric Edit50
80F08771ACBPA System Company Constants Tag Table1XGHMCOCompany - HomeStringGeneric Edit50
81F08773CBPA System Appraisal Type Overrides2XLHMCOCompany - HomeStringGeneric Edit50
82F08773ACBPA System Appraisal Type Overrides Tag Table2XLHMCOCompany - HomeStringGeneric Edit50
83F08776CBPA Appraisal Templates2XOHMCOCompany - HomeStringGeneric Edit50
TOP08AD: ADP Integration
84F05137ADP Employee Master Information36ADHMCOCompany - HomeStringGeneric Edit50
85F051375ADP Payroll DBA Transaction Constants93ADHMCOCompany - HomeStringGeneric Edit50
TOP08H: Health and Safety
86F08601Injury/Illness Case Master9HLHMCOCompany - HomeStringGeneric Edit50
TOP08U: OW HR US
87F08360Nondiscrimination Groups4HEHMCOCompany - HomeStringGeneric Edit50
88F08367NDT - Company Selection Criteria3HZHMCOCompany - HomeStringGeneric Edit50
89F083675NDT - Prior Year Testing Method Selection Criteria3PFHMCOCompany - HomeStringGeneric Edit50
90F08368NDT - Nondiscrimination Totals3DBHMCOCompany - HomeStringGeneric Edit50
91F08910COBRA Qualified Beneficiary File28J1HMCOCompany - HomeStringGeneric Edit50
92F08992Qualifying Event Rules Header3QEHMCOCompany - HomeStringGeneric Edit50
TOP08W: Wage and Salary
93F08201Salary Review Workfile6HRHMCOCompany - HomeStringGeneric Edit50
TOP18: Resource Scheduling
94F186602Labor Rules Tag File22TFHMCOCompany - HomeStringGeneric Edit50
TOP48S: Service Billing
95F48S0618Payroll Reclassification Workfile8YTHMCOCompany - HomeStringGeneric Edit50
TOP54HS: Health & Safety Incident Mgt
96F54HS02Incident People17S2HMCOCompany - HomeStringGeneric Edit50
97F54HS02MIncident People Change History20I2HMCOCompany - HomeStringGeneric Edit50
TOP74U: United Kingdom Localizations
98F74U4051Header - CIS Monthly Return - UK - 042HMCOCompanyStringGeneric Edit50
99F74UUI51Header - XML Work File CIS Monthly Return - UK - 042HMCOCompanyStringGeneric Edit50
TOP75A: Australia - Reporting System Only
100F75A0140Australian Payment Summary2ZGHMCOCompany - HomeStringGeneric Edit50
101F75A0500AU Bonus and Back Pay Tax Workfile10BPHMCOCompany - HomeStringGeneric Edit50
102F75A0501AU Bonus and Back Pay Tax History10THHMCOCompany - HomeStringGeneric Edit50
TOP77: Payroll (Canadian)
103F06176Unemployment Insurance History File13YSHMCOCompany - HomeStringGeneric Edit50
104F0713Tax History6YZHMCOCompany - HomeStringGeneric Edit50
105F0713SAVBackup Copy of F0713 For Tax Ledger Repost6YZHMCOCompany - HomeStringGeneric Edit50
106F0716Pay Check History Tax Ledger - Canadian DB17YVHMCOCompany - HomeStringGeneric Edit50
107F07183Commission History Detail File9ZBHMCOCompany - HomeStringGeneric Edit50
108F77220Employee Special Handling Detail - F772206J3HMCOCompany - HomeStringGeneric Edit50
109F77230Employee Pension Maintenance - F772302J8HMCOCompany - HomeStringGeneric Edit50
110F77703Payroll History Audit Report - Worktable2ARHMCOCompany - HomeStringGeneric Edit50