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

76 columns | Print definition?910 | ADDZ

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP01: Address Book
1F0101Z2Address Book - Interoperability91SZADDZPostal CodeStringGeneric Edit120
2F0116Address by Date8ALADDZPostal CodeStringGeneric Edit120
3F01161Alternate Address9WLADDZPostal CodeStringGeneric Edit120
4F01161DWCustomer Alternate Address Export14DWADDZPostal CodeStringGeneric Edit120
5F01161Z1Batch - Alternative Address22LBADDZPostal CodeStringGeneric Edit120
6F0117Postal Codes1A8ADDZPostal CodeStringGeneric Edit120
7F0118Postal Code Address2A7ADDZPostal CodeStringGeneric Edit120
TOP05: Time Accounting and HRM Base
8F054101Employee Personal Profile Information History Table20EHADDZPostal CodeStringGeneric Edit120
9F054101WEmployee Personal Profile Information Work Table20EPADDZPostal CodeStringGeneric Edit120
10F054111Employee Emergency Contact History Table11CHADDZPostal CodeStringGeneric Edit120
11F054111WEmployee Emergency Contact Work Table11ECADDZPostal CodeStringGeneric Edit120
TOP05A: OW HR & PR Foundation
12F05003Verification of Employment Data17EVADDZPostal CodeStringGeneric Edit120
13F060116ZUnedited Quick Hire Transaction File75SZADDZPostal CodeStringGeneric Edit120
TOP07: Payroll
14F074001New Hire Reporting Workfile - OneWorld Only17NHADDZPostal CodeStringGeneric Edit120
15F07830Employee Federal Control Table62Y0ADDZPostal CodeStringGeneric Edit120
16F07831Employee State/Local Control Table38YBADDZPostal CodeStringGeneric Edit120
17F07832Employee Special Handling Control Table24YHADDZPostal CodeStringGeneric Edit120
18F07880SUI Magnetic Media Workfile13YWADDZPostal CodeStringGeneric Edit120
19F8907422New Hire Detail File - Massachusetts (22)8MAADDZPostal CodeStringGeneric Edit120
20F8907427New Hire Detail File - Montana (27)38MTADDZPostal CodeStringGeneric Edit120
21F8907428New Hire Detail File - Nebraska(28)15NEADDZPostal CodeStringGeneric Edit120
22F8907444New Hire Detail File Transfer - Texas (44)13TXADDZPostal CodeStringGeneric Edit120
TOP08: Human Resources
23F083305Mail Merge Header/Detail14MMADDZPostal CodeStringGeneric Edit120
TOP08A: eRecruit
24F08490Recruitment Information14RIADDZPostal CodeStringGeneric Edit120
TOP08AD: ADP Integration
25F05137ADP Employee Master Information59ADADDZPostal CodeStringGeneric Edit120
TOP08B: Benefits Administration
26F0833WFBenefit Statement Work file11WFADDZPostal CodeStringGeneric Edit120
TOP13C: Condition-Base Maintenance
27F1310Condition-Based Alerts53CAADDZPostal CodeStringGeneric Edit120
28F1310Z1Unedited Condition-Based Alerts67CBADDZPostal CodeStringGeneric Edit120
TOP15: Property Management
29F1507Unit Master20NHADDZPostal CodeStringGeneric Edit120
TOP17C: Call Management
30F17311Equipment Master Location Details20LDADDZPostal CodeStringGeneric Edit120
TOP31B: Blend Management
31F31B01Winery Master8WIADDZPostal CodeStringGeneric Edit120
TOP40: Inventory/OP Base
32F4006Order Address Information10OAADDZPostal CodeStringGeneric Edit120
33F4006ZBatch Order Receiver - Order Address Information10OYADDZPostal CodeStringGeneric Edit120
34F4215Shipment Header37XHADDZPostal CodeStringGeneric Edit120
TOP44H: Homebuilder Management
35F44H201Lot Master6LMADDZPostal CodeStringGeneric Edit120
36F44H201HLot Master History7LMADDZPostal CodeStringGeneric Edit120
37F44H201ZHB Lot Master Unedited Transaction File19SZADDZPostal CodeStringGeneric Edit120
38F44H501HLot Sales History172LSADDZPostal CodeStringGeneric Edit120
TOP47: Electronic Commerce
39F47037EDI Shipping Notice Detail - Outbound213SZADDZPostal CodeStringGeneric Edit120
40F470561EDI Payment Order Bank N & A - Outbound31D2ADDZPostal CodeStringGeneric Edit120
41F470561WEDI Payment Order Bank N & A - Work31D2ADDZPostal CodeStringGeneric Edit120
42F470562EDI Payment Order Vendor N & A - Outbound31D4ADDZPostal CodeStringGeneric Edit120
43F470562WEDI Payment Order Vendor N & A - Work31D4ADDZPostal CodeStringGeneric Edit120
44F470563EDI Payment Order Payee N & A - Outbound31D5ADDZPostal CodeStringGeneric Edit120
45F470563WEDI Payment Order Payee N & A - Work31D5ADDZPostal CodeStringGeneric Edit120
46F4706EDI Order Address Information20ZAADDZPostal CodeStringGeneric Edit120
47F47081EDI Price Sales Catalog Header - Inbound27FVADDZPostal CodeStringGeneric Edit120
TOP49: Transportation Management
48F4950Routing Entries11RTADDZPostal CodeStringGeneric Edit120
49F4960Load Header11TMADDZPostal CodeStringGeneric Edit120
50F4981Freight Audit History56FHADDZPostal CodeStringGeneric Edit120
51F49T50Order Release Location Staging20LOADDZPostal CodeStringGeneric Edit120
52F49T80Locations Staging Table16LCADDZPostal CodeStringGeneric Edit120
TOP54HS: Health & Safety Incident Mgt
53F54HS01Incident Master35S1ADDZPostal CodeStringGeneric Edit120
54F54HS01MIncident Master Change History38I1ADDZPostal CodeStringGeneric Edit120
55F54HS02Incident People44S2ADDZPostal CodeStringGeneric Edit120
56F54HS02MIncident People Change History47I2ADDZPostal CodeStringGeneric Edit120
TOP59: Reserved for Clients
57F594706Alpha EDI Order Address10ZAADDZPostal CodeStringGeneric Edit120
TOP74: EMEA Localization
58F7430031Legal Document Address (Print Info) - COMM - 03B15PIADDZPostal CodeStringGeneric Edit120
TOP74B: Begium Localization
59F7403B11Belgium - Work File Yearly Vat Declaration Data4QAADDZPostal CodeStringGeneric Edit120
60F74B200Yearly/Quarterly VAT Listing - Belgium4VTADDZPostal CodeStringGeneric Edit120
TOP75A: Australia - Reporting System Only
61F75A0010Australian Employee Termination Details61A0ADDZPostal CodeStringGeneric Edit120
62F75A0220Payment Summary Workfile12PSADDZPostal CodeStringGeneric Edit120
TOP75I: India
63F75I100QTDS Form 26Q - WorkFile (Quarterly)22EFADDZPostal CodeStringGeneric Edit120
64F75I100WTDS Form 26 - WorkFile22EFADDZPostal CodeStringGeneric Edit120
TOP76A: Argentina
65F76A0209Header & Footer Invoice/ShipmentNote History WF - ARG - 76A94HFADDZPostal CodeStringGeneric Edit120
66F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A94HFADDZPostal CodeStringGeneric Edit120
67F76A8002SICORE RG738 Withholding Entity - ARG - 04 - 76A6V3ADDZPostal CodeStringGeneric Edit120
68F76A82A/P Payment Control Group File - ARG - 04 - 76A28C6ADDZPostal CodeStringGeneric Edit120
69F76AUI20Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A94HFADDZPostal CodeStringGeneric Edit120
TOP76B: Brazil - Reporting System Only
70F76101BNota Fiscal - Header (Fiscal Books) - 4226QXADDZPostal CodeStringGeneric Edit120
71F76B70Physical and Legal Person Table - IN68 - 4215FJADDZPostal CodeStringGeneric Edit120
72F76B8601IN86-Work Table for Individuals and Legal Entities - 0412FJADDZPostal CodeStringGeneric Edit120
TOP76H: Chile
73F76H3B31Legal Document Header (Print Info) - CHI - 03B - 76H15PIADDZPostal CodeStringGeneric Edit120
TOP79A: Greenhouse Gas Accounting
74F79A75GHG Organization Name11GOADDZPostal CodeStringGeneric Edit120
TOP90CA: CRM Foundation
75F90CA14DTerritory Zip Code Table2TDADDZPostal CodeStringGeneric Edit120
76F90CA14ETerritory City Table4TEADDZPostal CodeStringGeneric Edit120