JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.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
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4211SDSales Order Detail File
5F4311PDPurchase Order Detail File
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F42119SDSales Order History File
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

27 columns | Print definition?910 | ORIG | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP31B: Blend Management
1F31B85Weigh Tag Master74WTORIGCountry of OriginStringUDC30
TOP40: Inventory/OP Base
2F4108Lot Master62IOORIGCountry of OriginStringUDC30
TOP41: Inventory Management
3F4101AItem File74IMORIGCountry of OriginStringUDC30
4F4101Z1F4101 Item Master Unedited Transaction Table156SZORIGCountry of OriginStringUDC30
5F4102Item Branch File32IBORIGCountry of OriginStringUDC30
6F41UI001Inventory Transactions Detail File247ITORIGCountry of OriginStringUDC30
TOP41F: Apparel Management
7FCW10Item Branch Work File12WBORIGCountry of OriginStringUDC30
8FCW22Lot Master Work File62WLORIGCountry of OriginStringUDC30
TOP42: Sales Management
9F420UI55Kit Balance Work File33UIORIGCountry of OriginStringUDC30
TOP43: Procurement
10F43121Z1Receipts Unedited Transaction Table203SZORIGCountry of OriginStringUDC30
TOP47: Electronic Commerce
11F47032EDI Shipping Notice Detail - Inbound182SZORIGCountry of OriginStringUDC30
12F470371EDI Shipping Notice Detail - Outbound258SZORIGCountry of OriginStringUDC30
13F470472EDI Invoice Expanded Detail (Sales)17S6ORIGCountry of OriginStringUDC30
14F47072EDI Receiving Advice Detail - Inbound259SZORIGCountry of OriginStringUDC30
15F47077EDI Receiving Advice Detail - Outbound245SZORIGCountry of OriginStringUDC30
16F47082EDI Price Sales Catalog Detail - Inbound45FYORIGCountry of OriginStringUDC30
17F47122EDI Product Activity Data Detail - Inbound90MJORIGCountry of OriginStringUDC30
TOP49: Transportation Management
18F49110Transportation Bill of Lading Workfile88BWORIGCountry of OriginStringUDC30
TOP74: EMEA Localization
19F0018TIntrastat Revision16TDORIGCountry of OriginStringUDC30
20F744101Intrastat Supplier/Item Cross Reference Table3INORIGCountry of OriginStringUDC30
TOP74R: CIS
21F74R3033Line additional info (Print Info) - RUS - 03B10DFORIGCountry of OriginStringUDC30
22F74R3036Country of Origin Relationship - RUS - 74R1COORIGCountry of OriginStringUDC30
TOP76A: Argentina
23F76A0209Header & Footer Invoice/ShipmentNote History WF - ARG - 76A74HFORIGCountry of OriginStringUDC30
24F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A74HFORIGCountry of OriginStringUDC30
25F76A09Invoice Total - ARG - 03B - 76A62TTORIGCountry of OriginStringUDC30
26F76A09PInvoice Total Purge - ARG - 03B - 76A62TTORIGCountry of OriginStringUDC30
27F76AUI20Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A74HFORIGCountry of OriginStringUDC30

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