JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.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
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

2 columns | Print definition?812 | CESI | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP05A: OW HR & PR Foundation
1F060117Employee Master - International Data16YACESISector Indust. Code - Can Emp EquityStringUDC40
TOP08C: OW HR Canadian
2F08022Canadian Employment Equity Workfile10YZCESISector Indust. Code - Can Emp EquityStringUDC40

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

TOPUDC 05 / SI (Sector Industrial Code) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1          .N
2      011 Livestock FarmsN
3      021 Svcs Incidental Livestock FarmN
4      022 Svcs Incidental Agricult CropsN
5      031 Fishing IndustriesN
6      032 Svcs Incidental to FishingN
7      061 Metal MinesN
8      062 Non-Metal Mines (not Coal)N
9      063 Coal MinesN
10      071 Crude Petroleum/Natural Gas InN
11      091 Svcs Incidental Crude Pet/N GaN
12      101 Meat/Poultry Products IndustryN
13      102 Fish Products IndustriesN
14      105 Flour/Prepared Cereal/Feed IndN
15      106 Vegetable Oil Mills (not corn)N
16      284 Combined Publ/Printing IndustrN
17      304 Stamp/Pressed/Coated Metal ProN
18      327 Shipbuilding/Repair IndustryN
19      371 Chemical Products IndustriesN
20      391 Scientific/Prof Equip IndustriN
21      412 Highway/Heavy Construction IndN
22      441 Project Mgmt ConstructionN
23      449 Other Svcs Incidental ConstrucN
24      451 Air Transport IndustriesN
25      452 Svcs Incidental Air TransportN
26      453 Railway Transport/Rel Svc InduN
27      454 Water Transport IndustriesN
28      455 Svc Ind Incidental Water TransN
29      456 Truck Transport IndustriesN
30      457 Pub Pass Transit Sys IndustrieN
31      458 Other Transportation IndustrieN
32      459 Other Svc Ind Incidental TransN
33      461 Pipeline Transport IndustriesN
34      471 Grain Elevator IndustryN
35      479 Other Storage/Warehouse IndustN
36      481 Telecomm Broadcasting IndustriN
37      482 Telecomm Carriers IndustryN
38      483 Other Telecomm IndustriesN
39      484 Postal/Courier Svc IndustriesN
40      491 Electric Power System IndustryN
41      501 Farm Products, WholesaleN
42      701 Central BankN
43      702 Chartered Banks/Bank Type InteN
44      712 Business Financing CompaniesN
45      759 Other Real Estate OperatorsN
46      775 Arch/Engi/Other Scie/Tech SvcsN
47      777 Mgmt Consulting ServicesN
48      779 Other Business ServicesN
49      812 Protective ServicesN
50      814 Foreign Affairs/Intnl AssistanN
51      816 Human Resource AdministrationN
52      817 Economic Services AdministratiN
53      855 Museums and ArchivesN
54      963 Theatrical/Other Staged Ent SvN
55      982 Business AssociationsN