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
9F0006MCBusiness Unit Master
10F03012AICustomer Master by Line of Business

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
3F4211SDSales Order Detail File
4F0411RPAccounts Payable Ledger
5F4311PDPurchase Order Detail File
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F03012AICustomer Master by Line of Business
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

70 columns | Print definition?910 | TAXX

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP05: Time Accounting and HRM Base
1F0605D/B/A Period Control File6J@TAXXTax Identification NumberStringGeneric Edit200
2F06145Calendar Month DBA Summary History File8YHTAXXTax Identification NumberStringGeneric Edit200
3F06149Fiscal and Anniversary Rollover Work File4Y7TAXXTax Identification NumberStringGeneric Edit200
4F0618Employee Transaction History122YTTAXXTax Identification NumberStringGeneric Edit200
5F0627Workers Compensation Summary History10JHTAXXTax Identification NumberStringGeneric Edit200
6F069086Payroll Corporate Tax Identification4YITAXXTax Identification NumberStringGeneric Edit200
7F0709Deduction/Benefit/Accrual Ledger File15Y$TAXXTax Identification NumberStringGeneric Edit200
TOP05T: Time Entry
8F06116Employee Transaction Detail File175YTTAXXTax Identification NumberStringGeneric Edit200
9F0623Piecework History File11JLTAXXTax Identification NumberStringGeneric Edit200
TOP06: Payroll (old) - Obsolete-do not reuse
10F06146Employee Transaction History Summary8YNTAXXTax Identification NumberStringGeneric Edit200
TOP07: Payroll
11F06136Tax History10YZTAXXTax Identification NumberStringGeneric Edit200
12F06136ATax Summary (Additional)6YZTAXXTax Identification NumberStringGeneric Edit200
13F06136BTax Summary (PA ACT 32)6YZTAXXTax Identification NumberStringGeneric Edit200
14F06147Fiscal and Anniversary Year History4YDTAXXTax Identification NumberStringGeneric Edit200
15F06148Tax Area Transaction History5Y@TAXXTax Identification NumberStringGeneric Edit200
16F06156Pay Check History Summary32YUTAXXTax Identification NumberStringGeneric Edit200
17F06166Pay Check History Tax Ledger19YVTAXXTax Identification NumberStringGeneric Edit200
18F06166ATax Ledger (Additional)20YVTAXXTax Identification NumberStringGeneric Edit200
19F06166BTax Ledger (PA ACT 32)13YVTAXXTax Identification NumberStringGeneric Edit200
20F06720W-2/1099 Processing Control7JETAXXTax Identification NumberStringGeneric Edit200
21F068500941 - Federal Tax History12YZTAXXTax Identification NumberStringGeneric Edit200
22F0701734Prior Head Tax from a Previous Employer9Y3TAXXTax Identification NumberStringGeneric Edit200
23F0701740Quantum Control Tax3YQTAXXTax Identification NumberStringGeneric Edit200
24F0701741Canadian Deduction3YDTAXXTax Identification NumberStringGeneric Edit200
25F0705DBA Period Control File7J@TAXXTax Identification NumberStringGeneric Edit200
26F07149Accrual Fiscal/Anniversary History Work File4Y8TAXXTax Identification NumberStringGeneric Edit200
27F0719DBA Transaction Detail History15Y$TAXXTax Identification NumberStringGeneric Edit200
28F07350Payment File11Y0TAXXTax Identification NumberStringGeneric Edit200
29F07353Tax Detail File23Y3TAXXTax Identification NumberStringGeneric Edit200
30F074001New Hire Reporting Workfile - OneWorld Only26NHTAXXTax Identification NumberStringGeneric Edit200
31F077011Tax History Integrity (Temp)10Y$TAXXTax Identification NumberStringGeneric Edit200
32F077011ATax History Integrity Additional (Temp)10Y$TAXXTax Identification NumberStringGeneric Edit200
33F077011BTax Integrity (PA Act32)10Y3TAXXTax Identification NumberStringGeneric Edit200
34F077021Transaction History Integrity(Temp)9Y$TAXXTax Identification NumberStringGeneric Edit200
35F07727Canadian Pension Information8J7TAXXTax Identification NumberStringGeneric Edit200
36F07821Company Form Count Table6JGTAXXTax Identification NumberStringGeneric Edit200
37F07822Company Federal Control Table4JITAXXTax Identification NumberStringGeneric Edit200
38F07824Company State/Local Control Table4JDTAXXTax Identification NumberStringGeneric Edit200
39F07825Company Special Handling Control Table4JATAXXTax Identification NumberStringGeneric Edit200
40F07830Employee Federal Control Table3Y0TAXXTax Identification NumberStringGeneric Edit200
41F07831Employee State/Local Control Table3YBTAXXTax Identification NumberStringGeneric Edit200
42F07832Employee Special Handling Control Table3YHTAXXTax Identification NumberStringGeneric Edit200
43F07880SUI Magnetic Media Workfile6YWTAXXTax Identification NumberStringGeneric Edit200
44F07885SUI Payments for Quarterly Reporting9YWTAXXTax Identification NumberStringGeneric Edit200
45F8907422New Hire Detail File - Massachusetts (22)3MATAXXTax Identification NumberStringGeneric Edit200
46F8907427New Hire Detail File - Montana (27)6MTTAXXTax Identification NumberStringGeneric Edit200
47F8907428New Hire Detail File - Nebraska(28)5NETAXXTax Identification NumberStringGeneric Edit200
48F8907444New Hire Detail File Transfer - Texas (44)21TXTAXXTax Identification NumberStringGeneric Edit200
TOP08U: OW HR US
49F08360Nondiscrimination Groups5HETAXXTax Identification NumberStringGeneric Edit200
50F08368NDT - Nondiscrimination Totals4DBTAXXTax Identification NumberStringGeneric Edit200
TOP18: Resource Scheduling
51F186602Labor Rules Tag File181TFTAXXTax Identification NumberStringGeneric Edit200
TOP48S: Service Billing
52F48S0618Payroll Reclassification Workfile122YTTAXXTax Identification NumberStringGeneric Edit200
TOP75A: Australia - Reporting System Only
53F75A0500AU Bonus and Back Pay Tax Workfile11BPTAXXTax Identification NumberStringGeneric Edit200
54F75A0501AU Bonus and Back Pay Tax History11THTAXXTax Identification NumberStringGeneric Edit200
TOP76A: Argentina
55F76A0209Header & Footer Invoice/ShipmentNote History WF - ARG - 76A28HFTAXXTax Identification NumberStringGeneric Edit200
56F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A28HFTAXXTax Identification NumberStringGeneric Edit200
57F76A0440Check details RG 1547 - ARG - 04 - 76A3CDTAXXTax Identification NumberStringGeneric Edit200
58F76AUI20Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A28HFTAXXTax Identification NumberStringGeneric Edit200
TOP76H: Chile
59F76H3B31Legal Document Header (Print Info) - CHI - 03B - 76H32PITAXXTax Identification NumberStringGeneric Edit200
TOP77: Payroll (Canadian)
60F06176Unemployment Insurance History File25YSTAXXTax Identification NumberStringGeneric Edit200
61F0713Tax History10YZTAXXTax Identification NumberStringGeneric Edit200
62F0713SAVBackup Copy of F0713 For Tax Ledger Repost10YZTAXXTax Identification NumberStringGeneric Edit200
63F0716Pay Check History Tax Ledger - Canadian DB19YVTAXXTax Identification NumberStringGeneric Edit200
64F77173ROE Summary History Work File10JFTAXXTax Identification NumberStringGeneric Edit200
65F77200Canadian Employee Year-End Form Header - F772009J5TAXXTax Identification NumberStringGeneric Edit200
66F77201TNegative Amount Print8NATAXXTax Identification NumberStringGeneric Edit200
67F77210Canadian Employee Year-End Form Detail - F722107J6TAXXTax Identification NumberStringGeneric Edit200
68F77220Employee Special Handling Detail - F772207J3TAXXTax Identification NumberStringGeneric Edit200
69F77230Employee Pension Maintenance - F772303J8TAXXTax Identification NumberStringGeneric Edit200
70F77703Payroll History Audit Report - Worktable3ARTAXXTax Identification NumberStringGeneric Edit200