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?920 | SHPCTR | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP17C: Call Management
1F17111Base Warranty Defaults26BCSHPCTRShip To CountryStringUDC30

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

TOPUDC 00 / CN (Country Codes) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1 Default Country N
2       *All Countries N
3       ADAndorra020N
4       AEUnited Arab Emirates (UAE)784N
5       AFAfghanistan004N
6       AGAntigua and Barbuda028N
7       AIAnguilla660N
8       ALAlbania008N
9       AMArmenia051N
10       ANNetherlands Antilles530N
11       AOAngola024N
12       AQAntarctica010N
13       ARArgentina032N
14       ASAmerican Samoa016N
15       ATAustria040N
16       AUAustralia036N
17       AWAruba533N
18       AZAzerbaijan031N
19       BABosnia and Herzegovina070N
20       BBBarbados052N
21       BDBangladesh050N
22       BEBelgium056N
23       BFBurkina Faso854N
24       BGBulgaria100N
25       BHBahrain048N
26       BIBurundi108N
27       BJBenin204N
28       BMBermuda060N
29       BNBrunei096N
30       BOBolivia068N
31       BRBrazil076N
32       BSBahamas044N
33       BTBhutan064N
34       BVBouvet Island074N
35       BWBotswana072N
36       BYByelorussian SSR112N
37       BZBelize084N
38       CACanada124N
39       CCCocos (Keeling) Islands166N
40       CDDemocratic Republic of Congo180N
41       CFCentral African Republic140N
42       CGCongo178N
43       CHSwitzerland756N
44       CIIvory Coast384N
45       CKCook Islands184N
46       CLChile152N
47       CMCameroon120N
48       CNChina156N
49       COColombia170N
50       CRCosta Rica188N
51       CSSerbia and Montenegro891N
52       CUCuba192N
53       CVCape Verde132N
54       CXChristmas Island162N
55       CYCyprus196N
56       CZCzech Republic203N
57       DEGermany276N
58       DJDjibouti262N
59       DKDenmark208N
60       DMDominica212N
61       DODominican Republic214N
62       DZAlgeria012N
63       ECEcuador218N
64       EEEstonia233N
65       EGEgypt818N
66       EHWestern Sahara732N
67       EREritrea232N
68       ESSpain724N
69       ETEthiopia231N
70       FIFinland246N
71       FJFiji242N
72       FKFalkland Islands238N
73       FMMicronesia583N
74       FOFaroe Islands234N
75       FRFrance250N
76       GAGabon266N
77       GBUnited Kingdom826N
78       GDGrenada308N
79       GEGeorgia268N
80       GFFrench Guiana254N
81       GHGhana288N
82       GIGibraltar292N
83       GLGreenland304N
84       GMGambia270N
85       GNGuinea324N
86       GPGuadeloupe312N
87       GQEquatorial Guinea226N
88       GRGreece300N
89       GSSouth Georgia and the South Sa239N
90       GTGuatemala320N
91       GUGuam316N
92       GWGuinea-Bissau624N
93       GYGuyana328N
94       HKHong Kong344N
95       HMHeard Island and McDonald Isla334N
96       HNHonduras340N
97       HRCroatia191N
98       HTHaiti332N
99       HUHungary348N
100       IDIndonesia360N
101       IEIreland372N
102       ILIsrael376N
103       INIndia356N
104       IOBritish Indian Ocean Territory086N
105       IQIraq368N
106       IRIran364N
107       ISIceland352N
108       ITItaly380N
109       JMJamaica388N
110       JOJordan400N
111       JPJapan392N
112       KEKenya404N
113       KGKyrgyzstan417N
114       KHCambodia116N
115       KIKiribati296N
116       KMComoros174N
117       KNSaint Kitts and Nevis659N
118       KPNorth Korea408N
119       KRSouth Korea410N
120       KWKuwait414N
121       KYCayman Islands136N
122       KZKazakhstan398N
123       LALaos418N
124       LBLebanon422N
125       LCSaint Lucia662N
126       LILiechtenstein438N
127       LKSri Lanka144N
128       LRLiberia430N
129       LSLesotho426N
130       LTLithuania440N
131       LULuxembourg442N
132       LVLatvia428N
133       LYLibya434N
134       MAMorocco504N
135       MCMonaco492N
136       MDMoldova, Republic of498N
137       MGMadagascar450N
138       MHMarshall Islands584N
139       MKMacedonia, The Former Yugoslav807N
140       MLMali466N
141       MMMyanmar104N
142       MNMongolia496N
143       MOMacau446N
144       MPNorthern Mariana Islands580N
145       MQMartinique474N
146       MRMauritania478N
147       MSMontserrat500N
148       MTMalta470N
149       MUMauritius480N
150       MVMaldives462N
151       MWMalawi454N
152       MXMexico484N
153       MYMalaysia458N
154       MZMozambique508N
155       NANamibia516N
156       NCNew Caledonia540N
157       NENiger562N
158       NFNorfolk Island574N
159       NGNigeria566N
160       NINicaragua558N
161       NLNetherlands528N
162       NNNone N
163       NONorway578N
164       NPNepal524N
165       NRNauru520N
166       NUNiue570N
167       NZNew Zealand554N
168       OMOman512N
169       PAPanama591N
170       PEPeru604N
171       PFFrench Polynesia258N
172       PGPapua New Guinea598N
173       PHPhillippines608N
174       PKPakistan586N
175       PLPoland616N
176       PMSt. Pierre and Miquelon666N
177       PNPitcairn612N
178       PRPuerto Rico630N
179       PSPalestinian Territory, Occupie275N
180       PTPortugal620N
181       PWPalau585N
182       PYParaguay600N
183       QAQatar634N
184       REReunion638N
185       RORomania642N
186       RURussia643N
187       RWRwanda646N
188       SASaudi Arabia682N
189       SBSolomon Islands090N
190       SCSeychelles690N
191       SDSudan736N
192       SESweden752N
193       SGSingapore702N
194       SHSaint Helena654N
195       SISlovenia705N
196       SJSvalbard and Jan Mayen744N
197       SKSlovakia703N
198       SLSierra Leone694N
199       SMSan Marino674N
200       SNSenegal686N
201       SOSomalia706N
202       SRSuriname740N
203       STSao Tome and Principe678N
204       SVEl Salvador222N
205       SYSyria760N
206       SZSwaziland748N
207       TCTurks and Caicos Islands796N
208       TDChad148N
209       TFFrench Southern Territories260N
210       TGTogo768N
211       THThailand764N
212       TJTajikistan762N
213       TKTokelau772N
214       TLTimor-Leste626N
215       TMTurkmenistan795N
216       TNTunisia788N
217       TOTonga776N
218       TRTurkey792Y
219       TTTrinidad and Tobago780N
220       TVTuvalu798N
221       TWTaiwan158N
222       TZTanzania834N
223       UAUkrainian SSR804N
224       UGUganda800N
225       UMUnited States Minor Outlying I581N
226       USUnited States840N
227       UYUruguay858N
228       UZUzbekistan860N
229       VAVatican City336N
230       VCSaint Vincent & the Grenadines670N
231       VEVenezuela862N
232       VGBritish Virgin Islands092N
233       VIUS Virgin Islands850N
234       VNVietnam704N
235       VUVanuatu548N
236       WFWallis and Futuna Islands876N
237       WSSamoa882N
238       YEYemen887N
239       YTMayotte175N
240       ZASouth Africa710N
241       ZMZambia894N
242       ZWZimbabwe716N