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
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

82 columns | Print definition?812 | ADDS | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0006Business Unit Master9MCADDSStateStringUDC30
2F0006SDate Effective Business Unit Master11MCADDSStateStringUDC30
3F0006Z1Cost Center Unedited Transaction Table22SZADDSStateStringUDC30
4F004201Prepayment Transaction Table27PTADDSStateStringUDC30
TOP01: Address Book
5F0101Z2Address Book - Interoperability94SZADDSStateStringUDC30
6F0116Address by Date11ALADDSStateStringUDC30
7F01161Alternate Address12WLADDSStateStringUDC30
8F01161Z1Batch - Alternative Address25LBADDSStateStringUDC30
9F0117Postal Code Transactions2A8ADDSStateStringUDC30
TOP05: Time Accounting and HRM Base
10F054101Employee Personal Profile Information History Table19EHADDSStateStringUDC30
11F054101WEmployee Personal Profile Information Work Table19EPADDSStateStringUDC30
12F054111Employee Emergency Contact History Table10CHADDSStateStringUDC30
13F054111WEmployee Emergency Contact Work Table10ECADDSStateStringUDC30
TOP05A: OW HR & PR Foundation
14F05003Verification of Employment Data16EVADDSStateStringUDC30
15F060116ZUnedited Quick Hire Transaction File74SZADDSStateStringUDC30
TOP07: Payroll
16F074001New Hire Reporting Workfile - OneWorld Only16NHADDSStateStringUDC30
17F07880SUI Magnetic Media Workfile12YWADDSStateStringUDC30
18F8907422New Hire Detail File - Massachusetts (22)7MAADDSStateStringUDC30
19F8907427New Hire Detail File - Montana (27)37MTADDSStateStringUDC30
20F8907428New Hire Detail File - Nebraska(28)14NEADDSStateStringUDC30
21F8907444New Hire Detail File Transfer - Texas (44)12TXADDSStateStringUDC30
TOP08: Human Resources
22F083305Mail Merge Header/Detail13MMADDSStateStringUDC30
TOP08A: eRecruit
23F08490Recruitment Information11RIADDSStateStringUDC30
TOP08AD: ADP Integration
24F05137ADP Employee Master Information58ADADDSStateStringUDC30
TOP08B: Benefits Administration
25F0833WFBenefit Statement Work file10WFADDSStateStringUDC30
TOP12: Fixed Assets
26F1201Asset Master File62FAADDSStateStringUDC30
27F1201PAsset Master Purge Table62FAADDSStateStringUDC30
28F1201Z1Unedited Asset Master Transactions74FAADDSStateStringUDC30
TOP13: Plant/Equipment Management
29F1206Equipment License Master3FHADDSStateStringUDC30
30F1206PEquipment License Master Purge Table3FHADDSStateStringUDC30
TOP13C: Condition-Base Maintenance
31F1310Condition-Based Alerts52CAADDSStateStringUDC30
32F1310Z1Unedited Condition-Based Alerts66CBADDSStateStringUDC30
TOP15: Property Management
33F1507Unit Master File19NHADDSStateStringUDC30
TOP17C: Call Management
34F17311Installed Base Location Details19LDADDSStateStringUDC30
TOP31B: Blend Management
35F31B01Winery Master7WIADDSStateStringUDC30
TOP40: Inventory/OP Base
36F4006Order Address Information13OAADDSStateStringUDC30
37F4006ZBatch Order Receiver - Order Address Information13OYADDSStateStringUDC30
38F40333Preference Profile - Carrier17CAADDSStateStringUDC30
39F40334Preference Profile - Mode of Transport16MTADDSStateStringUDC30
40F4215Shipment Header36XHADDSStateStringUDC30
TOP40G: Grower Management
41F40G03Grower Harvest30GHADDSStateStringUDC30
42F40G0300Grower Harvest Update Profile48HUADDSStateStringUDC30
TOP44H: Homebuilder Management
43F44H201Lot Master5LMADDSStateStringUDC30
44F44H201HLot Master History6LMADDSStateStringUDC30
45F44H201ZHB Lot Master Unedited Transaction File18SZADDSStateStringUDC30
46F44H501HLot Sales History171LSADDSStateStringUDC30
TOP47: Electronic Commerce
47F47037EDI Shipping Notice Detail - Outbound211SZADDSStateStringUDC30
48F470561EDI Payment Order Bank N and A - Outbound12D2ADDSStateStringUDC30
49F470561WEDI Payment Order Bank N and A - Work11D2ADDSStateStringUDC30
50F470562EDI Payment Order Vendor N and A - Outbound30D4ADDSStateStringUDC30
51F470562WEDI Payment Order Vendor N and A - Work30D4ADDSStateStringUDC30
52F470563EDI Payment Order Payee N and A - Outbound30D5ADDSStateStringUDC30
53F470563WEDI Payment Order Payee N and A - Work30D5ADDSStateStringUDC30
54F4706EDI Order Address Information23ZAADDSStateStringUDC30
55F47081EDI Price Sales Catalog Header - Inbound26FVADDSStateStringUDC30
TOP49: Transportation Management
56F4950Routing Entries10RTADDSStateStringUDC30
57F4951Carrier Zone Definitions6ZNADDSStateStringUDC30
58F4960Load Header10TMADDSStateStringUDC30
59F4981Freight Audit History55FHADDSStateStringUDC30
TOP55: Reserved for Clients
60F55IFALBEsportazione provvigioni da F421113PRADDSStateStringUDC30
61F55PROVVEsportazione provvigioni da F421113PRADDSStateStringUDC30
TOP74: EMEA Localization
62F74030Bank ID - Italy11BAADDSStateStringUDC30
63F7430031Legal Document Address (Print Info) - COMM - 03B14PIADDSStateStringUDC30
TOP75A: Australia - Reporting System Only
64F75A0010Australian Employee Termination Details60A0ADDSStateStringUDC30
65F75A0220Payment Summary Workfile11PSADDSStateStringUDC30
TOP76A: Argentina
66F76A8002SICORE RG738 Withholding Entity5V3ADDSStateStringUDC30
67F76A82A/P Payment Control Group File - ARG - 04 - 76A30C6ADDSStateStringUDC30
TOP76B: Brazil - Reporting System Only
68F76011Address Book Brazilian Tag File14AIADDSStateStringUDC30
69F76011PArchive Address Book Brazilian Tag Table - 0414PRADDSStateStringUDC30
70F7601BNota Fiscal Header - Brazil24FHADDSStateStringUDC30
71F7608BICMS Tax Rates2TBADDSStateStringUDC30
72F76101BNota Fiscal - Header (Fiscal Books) - 4225QXADDSStateStringUDC30
73F7611BNota Fiscal Detail - Brazil51FDADDSStateStringUDC30
74F761BAAS Fiscal file book54FBADDSStateStringUDC30
75F76B105GNRE Table - 427QCADDSStateStringUDC30
76F76B132GIA City Code - 421TCADDSStateStringUDC30
77F76B70Physical and Legal Person Table - IN68 - 4214FJADDSStateStringUDC30
78F76B8601IN86-Work Table for Individuals and Legal Entities - 0410FJADDSStateStringUDC30
TOP76H: Chile
79F76H3B31Legal Document Header (Print Info) - CHI - 03B - 76H14PIADDSStateStringUDC30
TOPH90: ONEWORLD TOOLS
80F012504Focus Registration11FOADDSStateStringUDC30
TOPH91: Design Tools
81F9801NEWEmployee Information - New Version6AAADDSStateStringUDC30
82F9801OLDEmployee Information - Old Version5AAADDSStateStringUDC30

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 00 / S (State & Province Codes) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1       *  All StatesN