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
2F9671SDSoftware Update Detail Table
3F0101ABAddress Book Master
4F4101IMItem Master
5F0911GLAccount Ledger
6F4311PDPurchase Order Detail File
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F03012AICustomer Master by Line of Business
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F03B11RPCustomer Ledger
8F4311PDPurchase Order Detail File
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
6F42119SDSales Order History File
7F0006MCBusiness Unit Master
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

65 columns | Print definition?812 | ADDZ

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