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

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

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP90CB: CRM Sales Force Automation
1F90CB030CRM Address Table (Lead related information)11ADCONTYCountryStringUDC30
TOP90CC: CRM Marketing Automation
2F90CC01CCampaign Event Address table14CACONTYCountryStringUDC30

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       AE UNITED ARAB EMIRATESN
2       AN NETHERLANDS ANTILLESN
3       AZ AZERBAIJANN
4       BA BOSNIAN
5       BB BARBADOSN
6       BD BANGLADESHN
7       BE BELGIUMN
8       BF BURKINA FASON
9       BG BULGARIAN
10       BH BAHRAINN
11       BI BURUNDIN
12       BJ BENINN
13       BM BERMUDAN
14       BN BRUNEIN
15       BO BOLIVIAN
16       BR BRAZILN
17       BS BAHAMASN
18       BT BHUTANN
19       BW BOTSWANAN
20       BY BELARUSN
21       BZ BELIZEN
22       CA CANADAN
23       CD CONGO,N
24       CF CENTRAL AFRICANN
25       CG CONGON
26       CH SWITZERLANDN
27       CI COTE D'IVOIREN
28       CK COOK ISLANDSN
29       CL CHILEN
30       CM CAMEROONN
31       CN CHINA,N
32       CO COLOMBIAN
33       CR COSTA RICAN
34       CU CUBAN
35       CV CAPE VERDEN
36       CY CYPRUSN
37       CZ CZECH REPUBLIC, THEN
38       DE GERMANYN
39       DJ DJIBOUTIN
40       DK DENMARKN
41       DM DOMINICAN
42       DO DOMINICAN REPUBLICN
43       EC ECUADORN
44       EE ESTONIAN
45       EG EGYPTN
46       ER ERITREAN
47       ES SPAINN
48       ET ETHIOPIAN
49       FI FINLANDN
50       FJ FIJIN
51       FK FALKLAND ISLANDSN
52       FM MICRONESIA,N
53       FO FAROE ISLANDSN
54       FR FRANCEN
55       GA GABONN
56       GB UNITED KINGDOMN
57       GD GRENADAN
58       GE GEORGIAN
59       GF FRENCH GUYANAN
60       GG GUERNSEYN
61       GH GHANAN
62       GI GIBRALTARN
63       GL GREENLANDN
64       GM GAMBIAN
65       GN GUINEA REPUBLICN
66       GP GUADELOUPEN
67       GQ GUINEA-EQUATORIALN
68       GR GREECEN
69       GT GUATEMALAN
70       GU GUAMN
71       GW GUINEA-BISSAUN
72       GY GUYANA (BRITISH)N
73       HK HONG KONGN
74       HN HONDURASN
75       HR CROATIAN
76       HT HAITIN
77       HU HUNGARYN
78       IC CANARY ISLANDS, THEN
79       ID INDONESIAN
80       IE IRELAND, REPUBLIC OFN
81       IL ISRAELN
82       IN INDIAN
83       IQ IRAQN
84       IR IRAN (ISLAMIC REPUBLIC OF)N
85       IS ICELANDN
86       IT ITALYN
87       JE JERSEYN
88       JM JAMAICAN
89       JO JORDANN
90       JP JAPANN
91       KE KENYAN
92       KG KYRGYZSTANN
93       KH CAMBODIAN
94       KI KIRIBATIN
95       KM COMOROSN
96       KN ST. KITTSN
97       KP KOREA, THE D.P.R OFN
98       KR KOREA, REPUBLIC OFN
99       KV KOSOVON
100       KW KUWAITN
101       KY CAYMAN ISLANDSN
102       KZ KAZAKHSTANN
103       LA LAO PEOPLE'SN
104       LB LEBANONN
105       LC ST. LUCIAN
106       LI LIECHTENSTEINN
107       LK SRI LANKAN
108       LR LIBERIAN
109       LS LESOTHON
110       LT LITHUANIAN
111       LU LUXEMBOURGN
112       LV LATVIAN
113       LY LIBYAN
114       MA MOROCCON
115       MC MONACON
116       MD MOLDOVA, REPUBLIC OFN
117       ME MONTENEGRO,N
118       MG MADAGASCARN
119       MH MARSHALL ISLANDSN
120       MK MACEDONIA,N
121       ML MALIN
122       MM MYANMARN
123       MN MONGOLIAN
124       MO MACAUN
125       MP SAIPANN
126       MQ MARTINIQUEN
127       MR MAURITANIAN
128       MS MONTSERRATN
129       MT MALTAN
130       MU MAURITIUSN
131       MV MALDIVESN
132       MW MALAWIN
133       MX MEXICON
134       MY MALAYSIAN
135       MZ MOZAMBIQUEN
136       NA NAMIBIAN
137       NC NEW CALEDONIAN
138       NE NIGERN
139       NG NIGERIAN
140       NI NICARAGUAN
141       NL NETHERLANDS, THEN
142       NO NORWAYN
143       NP NEPALN
144       NR NAURU, REPUBLIC OFN
145       NU NIUEN
146       NZ NEW ZEALANDN
147       OM OMANN
148       PA PANAMAN
149       PE PERUN
150       PF TAHITIN
151       PG PAPUA NEW GUINEAN
152       PH PHILIPPINES, THEN
153       PK PAKISTANN
154       PL POLANDN
155       PR PUERTO RICON
156       PT PORTUGALN
157       PW PALAUN
158       PY PARAGUAYN
159       QA QATARN
160       RE REUNION, ISLAND OFN
161       RO ROMANIAN
162       RS SERBIA, REPUBLIC OFN
163       RU RUSSIAN FEDERATION, THEN
164       RW RWANDAN
165       SA SAUDI ARABIAN
166       SB SOLOMON ISLANDSN
167       SC SEYCHELLESN
168       SD SUDANN
169       SE SWEDENN
170       SG SINGAPOREN
171       SI SLOVENIAN
172       SK SLOVAKIAN
173       SL SIERRA LEONEN
174       SM SAN MARINON
175       SN SENEGALN
176       SO SOMALIAN
177       SR SURINAMEN
178       ST SAO TOME AND PRINCIPEN
179       SV EL SALVADORN
180       SY SYRIAN
181       SZ SWAZILANDN
182       TC TURKS AND CAICOS ISLANDSN
183       TD CHADN
184       TG TOGON
185       TH THAILANDN
186       TJ TAJIKISTANN
187       TM TURKMENISTANN
188       TN TUNISIAN
189       TO TONGAN
190       TP EAST TIMORN
191       TR TURKEYN
192       TT TRINIDAD AND TOBAGON
193       TV TUVALUN
194       TW TAIWANN
195       TZ TANZANIAN
196       UA UKRAINEN
197       UG UGANDAN
198       US UNITED STATES OF AMERICAN
199       UY URUGUAYN
200       UZ UZBEKISTANN
201       VC ST. VINCENTN
202       VE VENEZUELAN
203       VG VIRGIN ISLANDS (BRITISH)N
204       VI VIRGIN ISLANDS (US)N
205       VN VIETNAMN
206       VU VANUATUN
207       WS SAMOAN
208       XB BONAIREN
209       XC CURACAON
210       XE ST. EUSTATIUSN
211       XM ST. MAARTENN
212       XN NEVISN
213       XS SOMALILAND,N
214       XY ST. BARTHELEMYN
215       YE YEMEN, REPUBLIC OFN
216       YT MAYOTTEN
217       ZA SOUTH AFRICAN
218       ZM ZAMBIAN
219       ZW ZIMBABWEN