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
9F0006MCBusiness Unit Master
10F03012AICustomer Master by Line of Business

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
3F4211SDSales Order Detail File
4F0411RPAccounts Payable Ledger
5F4311PDPurchase Order Detail File
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F03012AICustomer Master by Line of Business
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

28 columns | Print definition?920 | 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
TOP48: Work Order Processing
18F4801Z1Outbound Work Order Header225SYORIGCountry of OriginStringUDC30
TOP49: Transportation Management
19F49110Transportation Bill of Lading Workfile88BWORIGCountry of OriginStringUDC30
TOP74: EMEA Localization
20F0018TIntrastat Revision16TDORIGCountry of OriginStringUDC30
21F744101Intrastat Supplier/Item Cross Reference Table3INORIGCountry of OriginStringUDC30
TOP74R: Russia
22F74R3033Line additional info (Print Info) - RUS - 03B10DFORIGCountry of OriginStringUDC30
23F74R3036Country of Origin Relationship - RUS - 74R1COORIGCountry of OriginStringUDC30
TOP76A: Argentina
24F76A0209Header & Footer Invoice/ShipmentNote History WF - ARG - 76A74HFORIGCountry of OriginStringUDC30
25F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A74HFORIGCountry of OriginStringUDC30
26F76A09Invoice Total - ARG - 03B - 76A62TTORIGCountry of OriginStringUDC30
27F76A09PInvoice Total Purge - ARG - 03B - 76A62TTORIGCountry of OriginStringUDC30
28F76AUI20Header & 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 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