	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

67 columns | 920 | WR01 | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0911	Account Ledger	81	GL	WR01	Categories - Work Order 01	String	UDC	4	0
TOP03B: Enhanced Accounts Receivable
2	F03B117	Revenue Recognition GL Info	27	RL	WR01	Categories - Work Order 01	String	UDC	4	0
3	F03B119	Revenue Recognition GL Info Audit	15	RN	WR01	Categories - Work Order 01	String	UDC	4	0
TOP05: Time Accounting and HRM Base
4	F06106	Employee Pay Instructions	83	YM	WR01	Categories - Work Order 01	String	UDC	4	0
5	F0618	Employee Transaction History	19	YT	WR01	Categories - Work Order 01	String	UDC	4	0
TOP05T: Time Entry
6	F06116	Employee Transaction Detail File	19	YT	WR01	Categories - Work Order 01	String	UDC	4	0
7	F06116Z1	Employee Transactions - Batch File	36	VL	WR01	Categories - Work Order 01	String	UDC	4	0
8	F06116Z2	ESS Timecard History	36	VM	WR01	Categories - Work Order 01	String	UDC	4	0
9	F0624	Burden Distribution File	14	J#	WR01	Categories - Work Order 01	String	UDC	4	0
10	F06241	Burden Distribution File	14	J#	WR01	Categories - Work Order 01	String	UDC	4	0
11	F06278	Retro Timecard Detail File	22	YT	WR01	Categories - Work Order 01	String	UDC	4	0
12	F06290	Payroll Accounting Journal Work File	9	YR	WR01	Categories - Work Order 01	String	UDC	4	0
13	F063951	Payroll Journal (Compressed) File	26	GL	WR01	Categories - Work Order 01	String	UDC	4	0
TOP07: Payroll
14	F05290	WF - Payroll Journal (Detail)	26	JR	WR01	Categories - Work Order 01	String	UDC	4	0
15	F0716701	Employee Assignment T/E Template Information	31	EA	WR01	Categories - Work Order 01	String	UDC	4	0
16	F0716709	Employee Assignment T/E Template Info History	31	EA	WR01	Categories - Work Order 01	String	UDC	4	0
17	F071861	Stub Detail Piece Rate History File	15	Y8	WR01	Categories - Work Order 01	String	UDC	4	0
18	F0724	Burden Distribution File	17	YS	WR01	Categories - Work Order 01	String	UDC	4	0
19	F07241	Burden Distribution File	17	YS	WR01	Categories - Work Order 01	String	UDC	4	0
20	F073521	Stub Detail Piece Rate File	15	Y2	WR01	Categories - Work Order 01	String	UDC	4	0
21	F07UI200	Timecard History Work File	22	TH	WR01	Categories - Work Order 01	String	UDC	4	0
TOP08AD: ADP Integration
22	F051371	ADP Employee DBA Instructions	89	AD	WR01	Categories - Work Order 01	String	UDC	4	0
TOP09: General Accounting
23	F0911P	Purge - Account Ledger	81	GL	WR01	Categories - Work Order 01	String	UDC	4	0
24	F0911Z1	Journal Entry Transactions - Batch File	98	VN	WR01	Categories - Work Order 01	String	UDC	4	0
25	F0911Z4	F0911 Interoperability Table	103	SZ	WR01	Categories - Work Order 01	String	UDC	4	0
26	F09UI015	Indexed Computations Multi-Tiered Entries	81	GL	WR01	Categories - Work Order 01	String	UDC	4	0
TOP13: Plant/Equipment Management
27	F13411	PM Projections	18	RX	WR01	Categories - Work Order 01	String	UDC	4	0
TOP17: Customer Service Management
28	F4801Z2	Warranty Claim/Supplier Recovery processing	56	WS	WR01	Categories - Work Order 01	String	UDC	4	0
TOP18: Timecard Automation
29	F186602	Labor Rules Tag File	33	TF	WR01	Categories - Work Order 01	String	UDC	4	0
TOP31: Shop Floor Control
30	F31091	Schedule Quantity Detail	13	IQ	WR01	Categories - Work Order 01	String	UDC	4	0
31	F31091S	Schedule Quantity Detail Purge	13	IQ	WR01	Categories - Work Order 01	String	UDC	4	0
TOP41: Inventory Management
32	F41UI001	Inventory Transactions Detail File	168	IT	WR01	Categories - Work Order 01	String	UDC	4	0
TOP41F: Apparel Management
33	FCW65	Work Order Header for Style Items	38	OF	WR01	Categories - Work Order 01	String	UDC	4	0
TOP42: Sales Management
34	F42800G1	Sales Update G Batch Detail Workfile	33	DG	WR01	Categories - Work Order 01	String	UDC	4	0
TOP43: Procurement
35	F43080	Approvals Fields Constants	135	PD	WR01	Categories - Work Order 01	String	UDC	4	0
36	F4311	Purchase Order Detail File	135	PD	WR01	Categories - Work Order 01	String	UDC	4	0
37	F4311Z	Purchase Order Generator File	139	PW	WR01	Categories - Work Order 01	String	UDC	4	0
38	F4311Z1	Purchase Order Detail Unedited Transaction Table	148	SZ	WR01	Categories - Work Order 01	String	UDC	4	0
39	F43199	P.O. Detail Ledger File - Flexible Version	135	OL	WR01	Categories - Work Order 01	String	UDC	4	0
TOP47: Electronic Commerce
40	F47017	EDI Purchase Order Detail - Outbound	149	SZ	WR01	Categories - Work Order 01	String	UDC	4	0
41	F47022	EDI P.O. Acknowledgment Detail - Inbound	149	SZ	WR01	Categories - Work Order 01	String	UDC	4	0
42	F47072	EDI Receiving Advice Detail - Inbound	150	SZ	WR01	Categories - Work Order 01	String	UDC	4	0
43	F47077	EDI Receiving Advice Detail - Outbound	150	SZ	WR01	Categories - Work Order 01	String	UDC	4	0
44	F47097	EDI Request for Quote Detail - Outbound	149	SZ	WR01	Categories - Work Order 01	String	UDC	4	0
45	F47102	EDI Response to RFQ Detail - Inbound	149	SZ	WR01	Categories - Work Order 01	String	UDC	4	0
46	F47122	EDI Product Activity Data Detail - Inbound	72	MJ	WR01	Categories - Work Order 01	String	UDC	4	0
47	F47127	EDI Product Activity Data Detail - Outbound	72	MJ	WR01	Categories - Work Order 01	String	UDC	4	0
48	F47137	EDI Purchase Order Change Detail - Outbound	150	SZ	WR01	Categories - Work Order 01	String	UDC	4	0
49	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	151	SZ	WR01	Categories - Work Order 01	String	UDC	4	0
50	F47157	EDI Shipping Schedule Detail - Outbound	158	SZ	WR01	Categories - Work Order 01	String	UDC	4	0
TOP48: Work Order Processing
51	F48001	Work Order Default Coding File	1	WE	WR01	Categories - Work Order 01	String	UDC	4	0
52	F4801	Work Order Master File	37	WA	WR01	Categories - Work Order 01	String	UDC	4	0
53	F4801S	Purge - Work Order Master file	37	WA	WR01	Categories - Work Order 01	String	UDC	4	0
54	F4801Z1	Outbound Work Order Header	56	SY	WR01	Categories - Work Order 01	String	UDC	4	0
55	F48710	Work Order Mass Update Template Table	45	WT	WR01	Categories - Work Order 01	String	UDC	4	0
56	F48UI001	X4801 Master Business Function Workfile	40	WA	WR01	Categories - Work Order 01	String	UDC	4	0
TOP48S: Service Billing
57	F4812	Billing Detail Workfile	14	WD	WR01	Categories - Work Order 01	String	UDC	4	0
58	F4812H	Billing Workfile History	14	WD	WR01	Categories - Work Order 01	String	UDC	4	0
59	F4812HS	Billing Workfile History Purged Save	14	WD	WR01	Categories - Work Order 01	String	UDC	4	0
60	F48S0618	Payroll Reclassification Workfile	19	YT	WR01	Categories - Work Order 01	String	UDC	4	0
61	F48S910	Billing Detail Journal Workfile	47	W2	WR01	Categories - Work Order 01	String	UDC	4	0
62	F48S911	Summarized Journal Workfile	38	W3	WR01	Categories - Work Order 01	String	UDC	4	0
63	F48SUI01	Billing Detail Print Workfile	14	WD	WR01	Categories - Work Order 01	String	UDC	4	0
TOP89: Conversion Programs
64	F07186T	Piece Rate History File	14	Y8	WR01	Categories - Work Order 01	String	UDC	4	0
65	F07352T	Piece Rate Stub Detail Tag File	15	Y2	WR01	Categories - Work Order 01	String	UDC	4	0
66	F43199A	Temp F43199 for ERP 9.0 Upgrade	135	OL	WR01	Categories - Work Order 01	String	UDC	4	0
TOPH99: Product Version Control
67	F9900003	Software Update Object Verification Work Table	11	SU	WR01	Categories - Work Order 01	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 00 / W1 (Phase/System Codes) stock values

	Value	Description	Special Handling Code	Hard Coded
1		.		N
2	0	System/Product Coding Scheme		N
3	00	Foundation Environment		N
4	00S	Foundation Self Service		N
5	01	Address Book		N
6	01RS	Rapid Start		N
7	02	Electronic Mail		N
8	03	Accounts Receivable		N
9	0301	Credit Management		N
10	03B	Enhanced Accounts Receivable		N
11	03C	Issue Management System		N
12	04	Accounts Payable		N
13	05	Time Accounting and HRM Base		N
14	0510	Advanced Time Management		N
15	05A	OW HR & PR Foundation		N
16	05C	OW HR & PR Foundation Canadian		N
17	05T	Time Entry		N
18	05U	OW HR & PR Foundation US		N
19	06	Payroll (old)		N
20	07	Payroll		N
21	07S	Payroll SUI		N
22	07T	Payroll Tips Module		N
23	07Y	US Payroll Year End		N
24	08	Human Resources		N
25	08B	Benefits Administration		N
26	08C	OW HR Canadian		N
27	08H	Health and Safety		N
28	08LM	HCM Learning Management Integr		N
29	08P	Position Control		N
30	08R	Recruitment Management		N
31	08U	OW HR US		N
32	08W	Wage and Salary		N
33	09	General Accounting		N
34	09E	Expense Reimbursment	N	Y
35	1	Project Phase 1		N
36	10	Financial Reporting		N
37	10C	Multi-Site Consolidations		N
38	11	Multi Currency		N
39	11C	Cash Basis		N
40	12	Fixed Assets		N
41	13	Plant/Equipment Management		N
42	14	Modeling, Planning & Budgeting		N
43	15	Real Estate Management		N
44	15L	Adv Real Estate Forecasting		N
45	15S	Real Estate Self-Service		N
46	16	Profit Management (EPS)		N
47	17	Customer Service Management		N
48	17A	Ariba Integration		N
49	17C	Call Management		N
50	17S	Siebel Integration		N
51	18	Timecard Automation		N
52	19	Utility CIS		N
53	2	Project Phase 2		N
54	20	Energy Base		N
55	3	Project Phase 3		N
56	30	Product Data Management		N
57	3010	Process Data Management		N
58	30A	Product Costing		N
59	31	Shop Floor Control		N
60	3110	Process Control		N
61	31A	Manufacturing Accounting		N
62	31B	Blend Management		N
63	32	Configuration Management		N
64	32C	Custom Works		N
65	33	Capacity Planning		N
66	34	Requirements Planning		N
67	34A	Advanced Planning & Scheduling		N
68	35	Enterprise Facility Planning		N
69	36	Forecasting		N
70	37	Quality Management		N
71	38	Agreement Management		N
72	39	Advanced Stock Valuation		N
73	4	Project Phase 4		N
74	40	Inventory/OP Base		N
75	4010	Advanced Price Adjustments		N
76	40G	Grower Management		N
77	40S	Supply Chain Self Service		N
78	41	Inventory Management		N
79	41A	Supply Chain Extensions		N
80	41B	Bulk Stock Management		N
81	42	Sales Management		N
82	42B	Sales Order Entry		N
83	42E	ECS Sales Management		N
84	42S	Customer Self Service		N
85	43	Procurement		N
86	43A	Purchase Order Receipt/Routing		N
87	43B	Voucher Match and Landed Cost		N
88	43S	Supplier Self Service		N
89	44	Subcontract Management		N
90	4401	Homebuilder Management		N
91	44H	Homebuilder Management		N
92	44H0	HomeBuilder Setup		N
93	44H1	HomeBuilder Community		N
94	44H2	HomeBuilder Lot		N
95	44H3	HomeBuilder Plan		N
96	44H4	HomeBuilder Option		N
97	44H5	HomeBuilder Sales		N
98	44H6	HomeBuilder Purchasing		N
99	44H7	HomeBuilder Construction		N
100	44H9	Extended Data Levels		N
101	45	Advanced Pricing		N
102	46	Warehouse Management		N
103	47	Electronic Commerce		N
104	48	Work Order Processing		N
105	48S	Service Billing		N
106	49	Transportation Management		N
107	50	Job Cost Base		N
108	51	Job Costing		N
109	51F	Advanced Project Forecasting		N
110	52	Contract Billing		N
111	53	Change Management		N
112	55	Reserved for Clients		N
113	56	Reserved for Clients		N
114	57	Reserved for Clients		N
115	58	Reserved for Clients		N
116	59	Reserved for Clients		N
117	60	Reserved for JDE Custom		N
118	61	Reserved for JDE Custom		N
119	62	Reserved for JDE Custom		N
120	63	Reserved for JDE Custom		N
121	64	Reserved for JDE Custom		N
122	65	Reserved for JDE Custom		N
123	66	Reserved for JDE Custom		N
124	67	Reserved for JDE Custom		N
125	68	Reserved for JDE Custom		N
126	69	Reserved for JDE Custom		N
127	70	Multi-National Products		N
128	71	Client Server Applications		N
129	72	World Vision		N
130	73	M & D complementary products		N
131	74	EMEA Localization		N
132	74A	Austria		Y
133	74B	Begium Localization		N
134	74C	Switzerland		Y
135	74D	Germany		Y
136	74F	France		Y
137	74G	Greece		Y
138	74H	Hungary		N
139	74I	Ireland		N
140	74L	Portugal		N
141	74M	Denmark		Y
142	74N	Nordics		N
143	74O	Norway		Y
144	74P	Poland		N
145	74R	CIS		N
146	74S	Spain		N
147	74T	Turkey		N
148	74U	United Kingdom Localizations		N
149	74V	Finland		Y
150	74W	Sweden		Y
151	74X	South Africa		Y
152	74Y	Italy		Y
153	74Z	Czech Republic		N
154	75	ASEAN Localization		N
155	75A	Australia		Y
156	75C	China		Y
157	75H	Thailand		N
158	75I	India		N
159	75J	Japan		Y
160	75K	Korea		N
161	75O	Hong Kong		Y
162	75S	Singapore		Y
163	75T	Taiwan		N
164	75Z	New Zealand		N
165	76	Latin American Localization		N
166	76A	Argentina		N
167	76B	Brazil		Y
168	76C	Colombia		N
169	76H	Chile		N
170	76M	Mexico		N
171	76N	Canada		Y
172	76P	Peru		N
173	76U	United States		Y
174	76V	Venezuela		N
175	77	Payroll (Canadian)		N
176	77Y	Canada Payroll Year End		N
177	79	Translation Tools		N
178	80	Business Intelligence		N
179	80B	Business Intelligence		N
180	80C	Content Management		N
181	80D	Plant Manager Dashboard		N
182	81	DREAM Writer		N
183	81A	DREAMWriter Conversion Tool		N
184	82	World Writer		N
185	82A	World Writer Conversion Tool		N
186	83	Management Reporting - FASTR		N
187	83A	FASTR Conversion Tool		N
188	84	Distributive Data Processing		N
189	85	Custom Programming		N
190	86	Electronic Doc. Interchange		N
191	87	JDE Internal		N
192	88	Cautious Purge System		N
193	89	Conversion Programs		N
194	90B	CRM Financial Services Base Ap		N
195	90M	CRM Custom		N
196	90S	CRM Standalone Base App		N
197	91	Documentation		N
198	92	Computer Assisted Design		N
199	93	Computer Assisted Programming		N
200	94	Security Officer		N
201	96	Computer Operations		N
202	97	Software Installation		N
203	98	Technical Tools		N
204	98E	Electronic Burst and Bind		N
205	98FT	Form Type		N
206	98SA	Sample Application		N
207	99	Technical Tools - Internal		N
208	99D	Technical Tools - DASD Sizer		N
209	99M	Technical Tools-Masters/Update		N
210	H79	Translation Tools		N
211	H87	JDE Internal		N
212	H90	ONEWORLD TOOLS		N
213	H90A	XPI Enterprise - Active SW		N
214	H90C	XPIe Canonical		N
215	H90M	MH2 XBP set		N
216	H90N	XPI Collaborative - NetFish		N
217	H90P	Proforma's - Solution Modeler		N
218	H91	Design Tools		N
219	H92	Interactive Engine/OL		N
220	H92T	Test Automation		N
221	H93	Data Base and Communications		N
222	H93F	Enterprise Infrastructure		N
223	H93J	Business Logic Infrastructure		N
224	H94	Batch Engine		N
225	H95	Object and Environment Tech		N
226	H96	Deployment		N
227	H96B	Package Build		N
228	H96D	Monitoring and Diagnostics		N
229	H96I	Installation		N
230	H96P	Product Packaging Tools		N
231	H96U	Upgrade		N
232	H97	Benchmarking/Performance		N
233	H98	Internet		N
234	H99	Product Version Control		N
235	H99P	Technical Tools-OWPVC Internal		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

67 columns | 920 | WR01 | STOCK UDC

TOPUDC 00 / W1 (Phase/System Codes) stock values