	Table	Prefix	Description
1	F4211	SD	Sales Order Detail File
2	F0101	AB	Address Book Master
3	F4101	IM	Item Master
4	F0911	GL	Account Ledger
5	F4311	PD	Purchase Order Detail File
6	F9671	SD	Software Update Detail Table
7	F4102	IB	Item Branch File
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0011W	IC	F0011W - WF - Batch To Detail
2	F76AUI46	WF	CERG A/R -Work File - ARG - 03B - 76A
3	F4211	SD	Sales Order Detail File
4	F4101	IM	Item Master
5	F0101	AB	Address Book Master
6	F0911	GL	Account Ledger
7	F4102	IB	Item Branch File
8	F03B11	RP	Customer Ledger
9	F4111	IL	Item Ledger File
10	F4311	PD	Purchase Order Detail File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0006	MC	Business Unit Master
5	F0411	RP	Accounts Payable Ledger
6	F4211	SD	Sales Order Detail File
7	F42119	SD	Sales Order History File
8	F03012	AI	Customer Master by Line of Business
9	F0902	GB	Account Balances
10	F4801	WA	Work Order Master File

6 columns | 812 | SY1 | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F00091	Supplemental Database Data Types	8	T2	SY1	System Code	String	UDC	4	0
TOP08: Human Resources
2	F08090	HRM Supplemental Data Types	15	JX	SY1	System Code	String	UDC	4	0
TOP37: Quality Management
3	F3711	Test Results	127	TR	SY1	System Code	String	UDC	4	0
4	F3711Z1	Test Results Unedited Transaction Table	128	SZ	SY1	System Code	String	UDC	4	0
TOP87: JDE Internal
5	F87SAR	SAR/Object Cross Reference	4	WS	SY1	System Code	String	UDC	4	0
TOPH96P: Product Packaging Tools
6	F9640S	ESU Dependencies	9	ED	SY1	System Code	String	UDC	4	0

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

TOPUDC 98 / SY (System Code) stock values

	Value	Description	Special Handling Code	Hard Coded
1	0	System/Product Coding Scheme		N
2	00	.		N
3	01	A = AS/400 Products		N
4	02	B = AS/400 Translations		N
5	03	C = AS/400 BP Localization		N
6	04	D = AS/400 Comp Products		N
7	05	E = AS/400 FDP`s		N
8	1	.		N
9	10	.		N
10	11	= Standard Products		N
11	12	B = Language Translations		N
12	13	J = PC/Client BP Localizat		N
13	14	D = Complementary Products		N
14	15	E = Industry Developed Prods.		N
15	2	.		N
16	21	H = OneWorld Tools		N
17	22	S = OS/Server Translations		N
18	23	T = OS/Server BP Localizat		N
19	24	U = OS/Server Comp Products		N
20	25	V = OS/Server FDP`s		N
21	26	.		N
22	27	.		N
23	28	.		N
24	29	.		N
25	3	.		N
26	30	.		N
27	31	.		N
28	0	System/Product Coding Scheme		N
29	00	Foundation Environment		N
30	01	Address Book		N
31	01A	PIM Sync		N
32	01RS	Rapid Start		N
33	02	Electronic Mail		N
34	03	Accounts Receivable		N
35	0301	Credit Management		N
36	03B	Enhanced Accounts Receivable		N
37	03C	Issue Management System		N
38	04	Accounts Payable		N
39	05	Time Accounting and HRM Base		N
40	0510	Advanced Time Management		N
41	05A	OW HR & PR Foundation		N
42	05C	OW HR & PR Foundation Canadian		N
43	05T	Time Entry		N
44	05U	OW HR & PR Foundation US		N
45	06	Payroll (old)		N
46	07	Payroll		N
47	07S	Payroll SUI		N
48	07U	Payroll - U.S. Specific Only		N
49	07Y	US Payroll Year End		N
50	08	Human Resources		N
51	08A	eRecruit		N
52	08AD	ADP Integration		N
53	08B	Benefits Administration		N
54	08C	OW HR Canadian		N
55	08H	Health and Safety		N
56	08LM	HCM Learning Management Integr		N
57	08P	Position Control		N
58	08R	Recruitment Management		N
59	08U	OW HR US		N
60	08W	Wage and Salary		N
61	09	General Accounting		N
62	09E	Expense Reimbursment	N	Y
63	10	Financial Reporting		N
64	10C	Multi-Site Consolidations		N
65	11	Multi Currency		N
66	11C	Cash Basis		N
67	12	Fixed Assets		N
68	13	Plant/Equipment Management		N
69	13C	Condition-Base Maintenance		N
70	13E	Equipment Cost Analysis		N
71	13R	Resource Assignments		N
72	14	Modeling, Planning & Budgeting		N
73	15	Property Management		N
74	15S	Real Estate Self-Service		N
75	16	Profit Management (EPS)		N
76	17	Customer Service Management		N
77	17A	Ariba Integration		N
78	17C	Call Management		N
79	17S	Siebel Integration		N
80	18	Resource Scheduling		N
81	19	Utility CIS		N
82	20	Energy Base		N
83	30	Product Data Management		N
84	3010	Process Data Management		N
85	30A	Product Costing		N
86	31	Shop Floor Control		N
87	3110	Process Control		N
88	31A	Manufacturing Accounting		N
89	31E	Engineer to Order		N
90	31P	Engineer To Order		N
91	32	Configuration Management		N
92	32C	Custom Works		N
93	33	Capacity Planning		N
94	34	Requirements Planning		N
95	34A	Advanced Planning & Scheduling		N
96	35	Enterprise Facility Planning		N
97	36	Forecasting		N
98	37	Quality Management		N
99	38	Agreement Management		N
100	39	Advanced Stock Valuation		N
101	40	Inventory/OP Base		N
102	4010	Advanced Price Adjustments		N
103	40P	Promotions Management		N
104	40R	Demand Scheduling		N
105	41	Inventory Management		N
106	41A	Supply Chain Extensions		N
107	41B	Bulk Stock Management		N
108	41V	Product Variants		N
109	42	Sales Management		N
110	42B	Sales Order Entry		N
111	42E	ECS Sales Management		N
112	43	Procurement		N
113	43BW	Buyer Workspace		N
114	43C	Contracts		N
115	43E	Requisition Self Service		N
116	43Q	Strategic Sourcing		N
117	44	Subcontract Management		N
118	4401	Homebuilder Management		N
119	44H	Homebuilder Management		N
120	45	Advanced Pricing		N
121	46	Warehouse Management		N
122	46L	License Plating		N
123	46R	RFID Outbound		N
124	47	Electronic Commerce		N
125	48	Work Order Processing		N
126	48S	Service Billing		N
127	49	Transportation Management		N
128	50	Job Cost Base		N
129	51	Job Costing		N
130	52	Contract Billing		N
131	52G	Government Contracting		N
132	53	Change Management		N
133	55	Reserved for Clients		N
134	5501	General Development		N
135	55FP	F.A.P.		N
136	56	Reserved for Clients		N
137	5615	Development for B?ly Rt		N
138	57	Reserved for Clients		N
139	58	Reserved for Clients		N
140	59	Reserved for Clients		N
141	59MZ	Exclusive for Modli Zoli		N
142	60	Reserved for JDE Custom		N
143	61	Reserved for JDE Custom		N
144	62	Reserved for JDE Custom		N
145	62CL	Outside Operation		N
146	62SC	Sales Commissions		N
147	63	Reserved for JDE Custom		N
148	64	Reserved for JDE Custom		N
149	65	Reserved for JDE Custom		N
150	66	Reserved for JDE Custom		N
151	67	Reserved for JDE Custom		N
152	68	Reserved for JDE Custom		N
153	69	Reserved for JDE Custom		N
154	70	Multi-National Products		N
155	71	Client Server Applications		N
156	72	World Vision		N
157	73	M & D complementary products		N
158	74	EMEA Localization		N
159	74A	Austria		Y
160	74B	Begium Localization		N
161	74C	Switzerland		Y
162	74D	Germany		Y
163	74F	France		Y
164	74G	Greece		Y
165	74H	Hungary		N
166	74I	Ireland		N
167	74L	Portugal		N
168	74M	Denmark		Y
169	74N	Nordics		N
170	74O	Norway		Y
171	74P	Poland		N
172	74R	CIS		N
173	74S	Spain		N
174	74T	Turkey		N
175	74U	United Kingdom Localizations		N
176	74V	Finland		Y
177	74W	Sweden		Y
178	74X	South Africa		Y
179	74Y	Italy		Y
180	74Z	Czech Republic		N
181	75	ASEAN Localization		N
182	75A	Australia		Y
183	75C	China		Y
184	75H	Thailand		N
185	75I	India		N
186	75J	Japan		Y
187	75K	Korea		N
188	75O	Hong Kong		Y
189	75S	Singapore		Y
190	75T	Taiwan		N
191	75Z	New Zealand		N
192	76	Latin American Localization		N
193	76A	Argentina		N
194	76B	Brazil		Y
195	76C	Colombia
196	76E	Ecuador		N
197	76H	Chile
198	76M	Mexico		N
199	76N	Canada		Y
200	76P	Peru
201	76U	United States		Y
202	76V	Venezuela
203	77	Payroll (Canadian)		N
204	77Y	Canada Payroll Year End		N
205	79	Translation Tools		N
206	80	COBOL Translator		N
207	80B	Business Intelligence		N
208	80C	Content Management		N
209	80D	Plant Manager Dashboard		N
210	81	DREAM Writer		N
211	82	World Writer		N
212	82A	World Writer Conversion Tool		N
213	83	Management Reporting - FASTR		N
214	83A	FASTR Conversion Tool		N
215	84	Distributive Data Processing		N
216	85	Custom Programming		N
217	86	Electronic Doc. Interchange		N
218	87	JDE Internal		N
219	88	Cautious Purge System		N
220	89	Conversion Programs		N
221	90CA	CRM Foundation		N
222	90CB	CRM Sales Force Automation		N
223	90CC	CRM Marketing Automation		N
224	90CD	CRM Service Management		N
225	90CE	CRM Solution Advisor		N
226	90CF	CRM Call Scripting		N
227	90CG	CRM Case Management		N
228	90CM	Mobile Sales		N
229	91	Documentation		N
230	92	Computer Assisted Design		N
231	93	Computer Assisted Programming		N
232	94	Security Officer		N
233	95	Sleeper-now in system 96		N
234	96	Computer Operations		N
235	97	Software Installation		N
236	98	Technical Tools		N
237	98E	Electronic Burst and Bind		N
238	98FT	Form Type		N
239	98SA	Sample Application		N
240	99	Technical Tools - Internal		N
241	99D	Technical Tools - DASD Sizer		N
242	99M	Technical Tools-Masters/Update		N
243	A65	Custom Document Tool		N
244	A67A	CBT-Foundation & Financials		N
245	A67B	CBT-Foundatoin & Distribution		N
246	A67C	CBT-Foundation & Manufacturing		N
247	A70	AutoPilot		N
248	A75	Call Management		N
249	A88P	PeopleSoft Portal		N
250	A89	Mexican Payroll		N
251	B	LANGUAGE TRANSLATIONS		N
252	B1A	Chinese - Simple		N
253	B1B	Chinese - Complex		N
254	B1E	English		N
255	B1F	French		N
256	B1G	German		N
257	B1I	Italian		N
258	B1J	Japanese		N
259	B1P	Portuguese		N
260	B1S	Spanish		N
261	B2A	Dutch		N
262	B2D	Danish		N
263	B2F	Finish		N
264	B2N	Norwiegian		N
265	B2S	Swedish		N
266	B3C	Czech		N
267	B3H	Hebrew		N
268	B3R	Russian		N
269	BC1	Chinese - Simple		N
270	BC2	Chinese - Complex		N
271	BCR	Czech		N
272	BDN	Danish		N
273	BDU	Dutch		N
274	BFI	Finish		N
275	BFR	French		N
276	BGR	German		N
277	BHE	Hebrew		N
278	BIT	Italian		N
279	BJP	Japanese		N
280	BNO	Norwiegian		N
281	BPO	Portuguese		N
282	BRU	Russian		N
283	BSP	Spanish		N
284	BSW	Swedish		N
285	D3N	dcLINK (data collection)		N
286	F30L	DFM Line Design		N
287	F30X	DFM Performance Metrics		N
288	F31	Lean Transactions		N
289	F31K	DFM Kanban Management		N
290	F34R	DFM Resource Management		N
291	F34S	DFM Production Sequencing		N
292	H	.		N
293	H00	.		N
294	H01	Address Book (inc ALL Mail)		N
295	H03	Accounts Receivable		N
296	H03B	New Accounts Receivable		N
297	H04	Accounts Payable		N
298	H05	Standalone Time Accounting		N
299	H07	Payroll		N
300	H08	Human Resources		N
301	H09	General Accounting		N
302	H12	Fixed Assets		N
303	H13	Equipment/Plant Management		N
304	H15	Commercial Property Management		N
305	H30	Product Data Management		N
306	H301	Process Data Management		N
307	H31	Shop Floor Control		N
308	H311	Process Control		N
309	H32	Configuration Management		N
310	H33	Capacity Requirements Planning		N
311	H34	DRP/MRP/MPS		N
312	H35	Enterprise Facility Planning		N
313	H36	Advanced Forecasting		N
314	H40	Inventory/OP Base		N
315	H41	Inventory Management		N
316	H415	Bulk Inventory Management		N
317	H42	Sales Order Processing		N
318	H43	Purchase Order Processing		N
319	H44	Contract Management		N
320	H44H	Homebuilder Management		N
321	H45	Sales Analysis		N
322	H46	Warehouse Management		N
323	H50	Job Cost Base		N
324	H72	Client/Server Base		N
325	H73	CS - A/P Voucher Entry		N
326	H74	CS - Pay Time Entry		N
327	H75	CS - Sales Order Entry		N
328	H76	CS - Training & Development		N
329	H78	CS - Travel Expense Management		N
330	H79	CS - Forecasting		N
331	H87	JDE Internal		N
332	H90	ONEWORLD TOOLS		N
333	H90A	XPI Enterprise - Active SW		N
334	H90B	B2B Collaboration		N
335	H90E	XPIe PeopleSoft		N
336	H90N	XPI Collaborative - NetFish		N
337	H90S	Rapid Start		N
338	H91	Design Tools		N
339	H91B	Batch Design Tools		N
340	H92	Interactive Engine/OL		N
341	H92T	Test Automation		N
342	H93	Data Base and Communications		N
343	H93F	Enterprise Infrastructure		N
344	H93J	Business Logic Infrastructure		N
345	H93S	EOne Security Vulnerability		N
346	H94	Batch Engine		N
347	H95	Tech Resources/Applications		N
348	H96	Deployment		N
349	H96P	Product Packaging Tools		N
350	H97	Benchmarking/Performance		N
351	H98	Internet		N
352	H99	Product Version Control		N
353	H99P	Technical Tools-OWPVC Internal		N
354	H99Q	E1 Technical Tools		N
355	H99W	World Data Dictionary		N
356	JE42	Sales Order/Pricing		N
357	JE44	Distribution Contracts		N
358	JE48	Automated Gantry Inter.		N
359	KZ1	PC Budget Upload (A3 to A5)		N
360	KZ2	PC Data Entry for AP		N
361	KZ3	PC Data Entry for Payroll		N
362	Z101	MTI Electrical Distribution		N
363	Z102	CRES		N
364	Z14	Reserved for Paradigm Tech.		N
365	Z15	Reserved for Paradigm Tech.		N
366	Z16	Reserved for Paradigm Tech.		N
367	Z17	Reserved for Paradigm Tech.		N
368	Z18	Reserved for Paradigm Tech.		N
369	Z19	Reserved for Paradigm Tech.		N
370	Z20	Reserved for Paradigm Tech.		N
371	Z21	Reserved for Paradigm Tech.		N
372	Z22	Reserved for Paradigm Tech.		N
373	Z23	Reserved for Paradigm Tech.		N
374	Z24	Reserved for Paradigm Tech.		N
375	Z25	Reserved for Paradigm Tech.		N
376	Z26	Reserved for Paradigm Tech.		N
377	Z27	Reserved for Paradigm Tech.		N
378	Z28	Reserved for Paradigm Tech.		N
379	Z29	Reserved for Paradigm Tech.		N
380	Z30	Reserved for Paradigm Tech.		N
381	Z91	System/ Product Codes		N
382	Z92	------------------------------		N

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

6 columns | 812 | SY1 | STOCK UDC

TOPUDC 98 / SY (System Code) stock values