	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

3 columns | 812 | SOCC | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP05A: OW HR & PR Foundation
1	F060116	Employee Master Information	107	YA	SOCC	Standard Occupational Class Code	String	UDC	4	0
2	F0601161	Point-In-Time Employee Master	109	PT	SOCC	Standard Occupational Class Code	String	UDC	4	0
3	F060116W	EE Master Request File	107	YA	SOCC	Standard Occupational Class 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 06 / SO (Standard Occupational Class) stock values

	Value	Description
1		Default
2	1412	Accountant/Auditor
3	1419	Fin Officer, Other
4	1430	Labor Relations Specialist
5	1449	Purchasing Agent
6	1450	Buss/Promotion Agent
7	1472	Construction Inspector
8	1610	Architect
9	1623	Eng Metal/Material
10	1628	Engineer Civil
11	1633	Enginner Electrical
12	1634	Engineer Industrial
13	1635	Engineer Mechanical
14	1712	Computer Sys Analyst
15	1912	Econimist
16	3220	Designer
17	3711	Eng Tech Electrical
18	3712	Eng Tech Industrial
19	3713	Eng Tech Mechanical
20	3719	Engineering Tech NEC
21	3720	Drafting Occs
22	4512	Computer Equip Supvr
23	4514	Clk Supvr Info
24	4519	Clk Supvr Record
25	4521	Clk Supvr Fin Record
26	4525	Clk Supvr Mat Dist
27	4612	Computer Operator
28	4642	Clk Interviewing
29	4664	Clk Order
30	4692	Clk Pers X Payroll
31	4696	Clk File
32	4712	Clk Bookkeep/Acct/Audi
33	4713	Clk Payroll/Time
34	4715	Clk Billing
35	4716	Clk Cost/Rate
36	4718	Bill/Post/Calc Mach Op
37	4722	Duplicating Mach Op
38	4744	Clk Mail X Postal
39	4751	Dispatcher
40	4752	Clk Production/Plan
41	4753	Clk Traffic/Ship/Rec
42	4754	Clk Stock/Inventory
43	4758	Expediter
44	4793	Data Entry Keyer
45	5211	Food/Beverage Supvr
46	5214	Cook X Short Order
47	5215	Cook Short Order
48	5216	Food Counter & Related
49	5245	Elevator Op
50	5622	Gardener
51	6176	Elevator Install/Rep
52	6311	Supervisor Overall Constr.
53	6312	Brick/Stone/Tile Supvr
54	6313	Carpenter Supvr
55	6314	Elec/Power Trans Supvr
56	6318	Const Supvr Other
57	6412	Brickmason
58	6413	Stonemason
59	6422	Carpenter
60	6424	Drywall Installer
61	6432	Electrician
62	6433	Elec Power Install/Rep
63	6450	Plumber/Pipefitter/Steamfitter
64	6462	Carpet/Soft Tile Inst.
65	6463	Concrete/Terr Finisher
66	6465	Insulation Worker
67	6474	Driller, Earth
68	6475	Air Hammer Operator
69	6479	Const Trades NEC
70	6530	Explosive Wkr
71	6814	Boilermaker
72	6832	Cabinet Maker
73	7720	Assembler
74	8214	Delivery & Route
75	8315	Crane/Tower Op
76	8316	Excavate/Load Mach Op
77	8620	Fabricate/Inspect Hlp
78	8641	Brick/Stone/Tile Hlp
79	8642	Carpenter Hlp
80	8643	Electrician Hlp
81	8648	Const Trade Hlp Other
82	8650	Extractive Occ Hlp
83	8710	Construction Laborer
84	8722	Garbage Collector

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

3 columns | 812 | SOCC | STOCK UDC

TOPUDC 06 / SO (Standard Occupational Class) stock values