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
2F9671SDSoftware Update Detail Table
3F0101ABAddress Book Master
4F4101IMItem Master
5F0911GLAccount Ledger
6F4311PDPurchase Order Detail File
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F03012AICustomer Master by Line of Business
10F41021LIItem Location File

910: Top 10 requests

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

812: Top 10 requests

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

72 columns | Print definition?812 | CTR | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0030Bank Transit Number Master File26AYCTRCountryStringUDC30
2F004201Prepayment Transaction Table29PTCTRCountryStringUDC30
3F0070Country Constants Master File1CKCTRCountryStringUDC30
TOP01: Address Book
4F0101Z2Address Book - Interoperability93SZCTRCountryStringUDC30
5F0116Address by Date14ALCTRCountryStringUDC30
6F01161Alternate Address13WLCTRCountryStringUDC30
7F01161Z1Batch - Alternative Address26LBCTRCountryStringUDC30
8F0117Postal Code Transactions5A8CTRCountryStringUDC30
TOP05: Time Accounting and HRM Base
9F054101Employee Personal Profile Information History Table21EHCTRCountryStringUDC30
10F054101WEmployee Personal Profile Information Work Table21EPCTRCountryStringUDC30
11F054111Employee Emergency Contact History Table12CHCTRCountryStringUDC30
12F054111WEmployee Emergency Contact Work Table12ECCTRCountryStringUDC30
TOP05A: OW HR & PR Foundation
13F05003Verification of Employment Data18EVCTRCountryStringUDC30
14F060116ZUnedited Quick Hire Transaction File76SZCTRCountryStringUDC30
TOP07: Payroll
15F074001New Hire Reporting Workfile - OneWorld Only19NHCTRCountryStringUDC30
16F07880SUI Magnetic Media Workfile35YWCTRCountryStringUDC30
17F07900Non Calendar Tax Fiscal Date Patterns1NCCTRCountryStringUDC30
18F07940Set Vertex Tax Table4YYCTRCountryStringUDC30
19F8907444New Hire Detail File Transfer - Texas (44)15TXCTRCountryStringUDC30
TOP08A: eRecruit
20F08490Recruitment Information13RICTRCountryStringUDC30
TOP08B: Benefits Administration
21F0833WFBenefit Statement Work file12WFCTRCountryStringUDC30
TOP08H: Health and Safety
22F08601Injury/Illness Case Master43HLCTRCountryStringUDC30
23F08601BInjury/Illness Case Master Tag Table2ITCTRCountryStringUDC30
TOP09E: Expense Reimbursment
24F09E105Tax Mapping3TMCTRCountryStringUDC30
TOP12: Fixed Assets
25F1217Equipment Master Extension2WRCTRCountryStringUDC30
26F1217PEquipment Master Extension Purge Table2WRCTRCountryStringUDC30
27F1217Z1Unedited Equipment Tag Transactions15WRCTRCountryStringUDC30
28F1217Z2Unedited Equipment Tag Transactions15WRCTRCountryStringUDC30
TOP13C: Condition-Base Maintenance
29F1310Condition-Based Alerts55CACTRCountryStringUDC30
30F1310Z1Unedited Condition-Based Alerts69CBCTRCountryStringUDC30
TOP15: Property Management
31F1507Unit Master File21NHCTRCountryStringUDC30
TOP17: Customer Service Management
32F17113Assessor Defaults3ADCTRCountryStringUDC30
33F1791Entitlement Dates6EMCTRCountryStringUDC30
34F4801TZ2Warranty Claim/Supplier Recovery processing73WQCTRCountryStringUDC30
TOP17C: Call Management
35F17111Base Warranty Defaults3BCCTRCountryStringUDC30
36F17311Installed Base Location Details21LDCTRCountryStringUDC30
37F1755Customer Call Master36ZACTRCountryStringUDC30
TOP31B: Blend Management
38F31B01Winery Master9WICTRCountryStringUDC30
TOP40: Inventory/OP Base
39F4006Order Address Information16OACTRCountryStringUDC30
40F4006ZBatch Order Receiver - Order Address Information16OYCTRCountryStringUDC30
41F40333Preference Profile - Carrier22CACTRCountryStringUDC30
42F40334Preference Profile - Mode of Transport21MTCTRCountryStringUDC30
43F4215Shipment Header38XHCTRCountryStringUDC30
TOP40R: Demand Scheduling
44F40R14Demand Addresses15DACTRCountryStringUDC30
45F40R143Demand Address History14DSCTRCountryStringUDC30
46F471722EDI Demand Addresses24EACTRCountryStringUDC30
TOP47: Electronic Commerce
47F47037EDI Shipping Notice Detail - Outbound212SZCTRCountryStringUDC30
48F470373EDI ASN Shipping25AGCTRCountryStringUDC30
49F470374EDI ASN Demand Addresses26AMCTRCountryStringUDC30
50F470561EDI Payment Order Bank N and A - Outbound32D2CTRCountryStringUDC30
51F470561WEDI Payment Order Bank N and A - Work32D2CTRCountryStringUDC30
52F470562EDI Payment Order Vendor N and A - Outbound32D4CTRCountryStringUDC30
53F470562WEDI Payment Order Vendor N and A - Work32D4CTRCountryStringUDC30
54F470563EDI Payment Order Payee N and A - Outbound32D5CTRCountryStringUDC30
55F470563WEDI Payment Order Payee N and A - Work32D5CTRCountryStringUDC30
56F4706EDI Order Address Information26ZACTRCountryStringUDC30
57F47081EDI Price Sales Catalog Header - Inbound29FVCTRCountryStringUDC30
TOP48: Work Order Processing
58F4801STPurge - Work Order Master Tag File60WACTRCountryStringUDC30
59F4801TWork Order Master Tag File60WACTRCountryStringUDC30
60F4817Service Order Extension14SRCTRCountryStringUDC30
TOP49: Transportation Management
61F49020Vehicle/Staff License Information7VLCTRCountryStringUDC30
62F4950Routing Entries13RTCTRCountryStringUDC30
63F4951Carrier Zone Definitions8ZNCTRCountryStringUDC30
64F4960Load Header12TMCTRCountryStringUDC30
TOP74: EMEA Localization
65F7430031Legal Document Address (Print Info) - COMM - 03B16PICTRCountryStringUDC30
66F74900Foreign Receivables and Payables - EMEA10RPCTRCountryStringUDC30
TOP74R: CIS
67F74R0018Russian Tax File - 74R57TDCTRCountryStringUDC30
TOP74U: United Kingdom Localizations
68F74U4052Subcontractor Detail - CIS Monthly Return - UK - 049SMCTRCountryStringUDC30
TOP75A: Australia - Reporting System Only
69F75A0010Australian Employee Termination Details62A0CTRCountryStringUDC30
TOP76A: Argentina
70F76A82A/P Payment Control Group File - ARG - 04 - 76A31C6CTRCountryStringUDC30
TOP76H: Chile
71F76H3B31Legal Document Header (Print Info) - CHI - 03B - 76H16PICTRCountryStringUDC30
TOPH95: Tech Resources/Applications
72F00921User Display Preferences9ULCTRCountryStringUDC30

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