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

1 column | Print definition?812 | SFIT | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F4096Sales Flex Accounting13FASFITData ItemStringUDC100

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

TOPUDC 40 / DI (Data Item) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1AC01      Category Code 11Y
2AC02      Category Code 021Y
3AC03      Category Code 031Y
4AC04      Category Code 041Y
5AC05      Region1Y
6AC06      Category Code 061Y
7AC07      Category Code 071Y
8AC08      Category Code 081Y
9AC09      Category Code091Y
10AC10      Category Code 101Y
11AC11      Category Code 111Y
12AC12      Category Code 121Y
13AC13      Category Code 131Y
14AC14      Category Code 141Y
15AC15      Category Code 151Y
16AC16      Category Code 161Y
17AC17      Category Code 171Y
18AC18      Category Code 181Y
19AC19      Category Code 191Y
20AC20      Category Code 201Y
21AC21      Category Code 211Y
22AC22      Category Code 221Y
23AC23      Category Code 231Y
24AC24      Category Code 241Y
25AC25      Category Code 251Y
26AC26      Category Code 261Y
27AC27      Area1Y
28AC28      Category Code 281Y
29AC29      Category Code 291Y
30AC30      Category Code 301Y
31AN8       Address Number3Y
32AST       Price Adjustment Name4Y
33CYCL      Cycle Count Category2Y
34DOC       Document Number3Y
35DOCO      Sales Order Number3Y
36EMCU      Business Unit - Header3Y
37GLPT      GL Category2Y
38ITM       Item Number - Short3Y
39MCU       SO Revenue Business Unit3Y
40MKFR      Mark for Address3Y
41PA01      Rebate Beneficiary4Y
42PRP6      Group - Item Dimension2Y
43PRP7      Group - Warehouse Process 12Y
44PRP8      Group - Warehouse Process 22Y
45PRP9      Group - Warehouse Process 32Y
46SHAN      Address Number - Ship To3Y
47SHCM      Shipping Commodity Class2Y
48SHCN      Shipping Conditions Code2Y
49SLM2      SO Salesman Number 23Y
50SLSM      SO Salesman Number 13Y
51SRP1      Sales Catalog Section3Y
52SRP2      Subsection3Y
53SRP3      Sales Category Code 33Y
54SRP4      Sales Category Code 43Y
55SRP5      Sales Category Code 53Y
56SRP6      Category Code 62Y
57SRP7      Category Code 72Y
58SRP8      Category Code 82Y
59SRP9      Category Code 92Y
60SRPO      Category Code 102Y