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
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

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

1 column | Print definition?920 | 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
1AC01Category Code 11Y
2AC02Category Code 021Y
3AC03Category Code 031Y
4AC04Category Code 041Y
5AC05Region1Y
6AC06Category Code 061Y
7AC07Category Code 071Y
8AC08Category Code 081Y
9AC09Category Code091Y
10AC10Category Code 101Y
11AC11Category Code 111Y
12AC12Category Code 121Y
13AC13Category Code 131Y
14AC14Category Code 141Y
15AC15Category Code 151Y
16AC16Category Code 161Y
17AC17Category Code 171Y
18AC18Category Code 181Y
19AC19Category Code 191Y
20AC20Category Code 201Y
21AC21Category Code 211Y
22AC22Category Code 221Y
23AC23Category Code 231Y
24AC24Category Code 241Y
25AC25Category Code 251Y
26AC26Category Code 261Y
27AC27Area1Y
28AC28Category Code 281Y
29AC29Category Code 291Y
30AC30Category Code 301Y
31AN8Address Number3Y
32ASTPrice Adjustment Name4Y
33CYCLCycle Count Category2Y
34DOCDocument Number3Y
35DOCOSales Order Number3Y
36EMCUBusiness Unit - Header3Y
37GLPTGL Category2Y
38ITMItem Number - Short3Y
39MCUSO Revenue Business Unit3Y
40MKFRMark for Address3Y
41PA01Rebate Beneficiary4Y
42PRP6Group - Item Dimension2Y
43PRP7Group - Warehouse Process 12Y
44PRP8Group - Warehouse Process 22Y
45PRP9Group - Warehouse Process 32Y
46SHANAddress Number - Ship To3Y
47SHCMShipping Commodity Class2Y
48SHCNShipping Conditions Code2Y
49SLM2SO Salesman Number 23Y
50SLSMSO Salesman Number 13Y
51SRP1Sales Catalog Section3Y
52SRP2Subsection3Y
53SRP3Sales Category Code 33Y
54SRP4Sales Category Code 43Y
55SRP5Sales Category Code 53Y
56SRP6Category Code 62Y
57SRP7Category Code 72Y
58SRP8Category Code 82Y
59SRP9Category Code 92Y
60SRPOCategory Code 102Y
61TXA1Tax Area3Y