	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

12 columns | 920 | SDCT | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP03: Accounts Receivable
1	F0311	Accounts Receivable Ledger	85	RP	SDCT	Sales Document Type	String	UDC	2	0
TOP03B: Enhanced Accounts Receivable
2	F03B11	Customer Ledger	81	RP	SDCT	Sales Document Type	String	UDC	2	0
3	F03B11P	Customer Ledger Purge File	81	RP	SDCT	Sales Document Type	String	UDC	2	0
4	F03B11Z1	Batch Invoices	97	VJ	SDCT	Sales Document Type	String	UDC	2	0
5	F03B11Z2	F03B11 Interoperability Table	94	SY	SDCT	Sales Document Type	String	UDC	2	0
6	F03B21	A/R Notification History Detail	53	ZS	SDCT	Sales Document Type	String	UDC	2	0
7	F03B575	Auto Debit Invoice Select and Build	90	RD	SDCT	Sales Document Type	String	UDC	2	0
TOP41: Inventory Management
8	F41UI001	Inventory Transactions Detail File	197	IT	SDCT	Sales Document Type	String	UDC	2	0
TOP45: Advanced Pricing
9	F4576	Ship and Debit Claims	37	AC	SDCT	Sales Document Type	String	UDC	2	0
10	F4576TMP	Ship and Debit Claims- Temp Table	37	AC	SDCT	Sales Document Type	String	UDC	2	0
11	F4576Z1	Ship and Debit Claims Unedited Transaction Table	50	Z1	SDCT	Sales Document Type	String	UDC	2	0
TOP76A: Argentina
12	F76AUI81	Draft - Invoices Work File - ARG - 03B - 76A	35	WF	SDCT	Sales Document Type	String	UDC	2	0

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

TOPUDC 00 / DT (Document Type - All Documents) stock values

	Value	Description	Special Handling Code	Hard Coded
1	##	Prior Year Transactions		Y
2	$A	Eventual Withholdings		N
3	$B	Gross Income Withholdings		N
4	$G	Profit Withholdings		N
5	$I	V.A.T Withholdings		N
6	$L	Cleaning Services Withholding		N
7	$P	Security Withholdings		Y
8	$Q	General SUSS		Y
9	$S	Contract Withholdings		N
10	%	Percentage Journal Entry		Y
11	@O	Payment order		N
12	A	Inv. Cnv. - Adjustments		N
13	AC	Lease Accrual / Deferral		N
14	AD	Asset Disposal		Y
15	AE	Automatic Entries		Y
16	AF	Adjusting Entries		Y
17	AJ	Service Billing Adjustments		Y
18	AR	Asset Revaluation		Y
19	AS	Asset Split		Y
20	AT	Asset Transfer		Y
21	AU	Units - Committed		Y
22	BA	Billing Adjustments		Y
23	BB	Bulk - Simple Blend		N
24	BC	Base Agreement Contract		N
25	BD	Bulk- Decant		N
26	BE	Billing Entries		N
27	BF	Balance Forward/Summarize		Y
28	BG	Regrade/GSM		N
29	BI	Bulk/Packed Invoice		N
30	BJ	Bulk - Adjustment		N
31	BL	Bulk-Filling		N
32	BM	Bill of Lading		N
33	BO	Bulk-Consumed in Operations		N
34	BP	Bulk-Repacking		N
35	BR	Bulk-Rebrand or Regrade		N
36	BT	Bulk-Tank to Tank Transfer		N
37	BX	Budget Change Order		N
38	C%	TDS Withholding		N
39	C1	Contract Level		Y
40	C2	Invoice Level		Y
41	C3	Funding Level		Y
42	C4	Credit Order - Transportation		N
43	CC	USER		N
44	CD	Container Deposits		N
45	CF	Journal Entry From Conversion		N
46	CG	Lot Grade Change		Y
47	CL	Call		N
48	CM	Service Contracts - CSMS	N	N
49	CO	Credit Order		N
50	CP	Lot Potency Change		Y
51	CS	RFx		N
52	CT	Transportation Confirmation		N
53	CW	HomeBuilder Closing Worksheet		N
54	CX	Change Request		Y
55	CZ	Cash Basis		Y
56	DA	Debit Note		N
57	DD	Sale Order		N
58	DL	Delivery Ticket		N
59	DN	Credit Note		N
60	DP	Depreciation Journal		Y
61	DR	Job Cost Draw Splits		Y
62	E	Energy		N
63	EA	Lease Cost Adjusting Entries		N
64	EC	Revenue Checks		N
65	EG	Engineering Change Request	R	N
66	EN	Engineering Change Order		N
67	EP	Revenue J/E`s 8/8`s		N
68	EQ	Revenue J/E`s Subledger		N
69	ER	Revenue J/E`s Net Company		N
70	ES	Revenue Suspense Entries		N
71	ET	Engineer to Order	N	N
72	EU	Service Billing Revenue		Y
73	EV	Revenue Manual/Void Checks		N
74	EX	Currency Conversion Offsets		Y
75	FA	Invoice		N
76	FC	Forecast		N
77	FE	Revenue Fees		N
78	FJ	Revenue Fees - Jrnl Entry Only		N
79	FO	Firm Work Order W/Parts List		N
80	FP	Field Progress Reporting		N
81	FR	Firm Rate Order W/Parts List		Y
82	FS	FRW Created Doc. Types		N
83	FT	Freight		N
84	G2	Inbound Completions		N
85	GF	General Ledger Transferred		N
86	GG	Environmental Document		Y
87	GL	Bulk Product Gain/Loss		N
88	HP	Purchase Order		N
89	HS	Hours Service		N
90	HT	Purchase Transfer Order		N
91	I	Inv Cnv - Issues		N
92	I1	Interbranch Sales
93	I2	Sorties de Stock- Obsolescence		N
94	I3	Sorties de Stock - Vol		N
95	I4	Sorties de Stock - Dommages		N
96	IA	Inventory Adjustments		N
97	IB	Item Cost Changes		N
98	IC	Completed W.O.`s To Inventory		N
99	ID	Inventory Issue To Blend Mgmt		Y
100	IH	Labor Charged To W.O.`s		N
101	II	Inventory Issue		N
102	IJ	Inventory Adjustments
103	IL	Inventory Issue
104	IM	Material Charged To W.O.`s		N
105	IO	Component Scrap to W.O.`s		N
106	IP	Physical Inventory		Y
107	IQ	Inventory Quantity Only		Y
108	IR	Inventory Receipt		N
109	IS	Scrapped W.O.`s To Inventory		N
110	IT	Inventory Transfers		N
111	IV	Variance Calculated for W.O.`s		N
112	IX	Recalculate Average Cost		Y
113	IZ	Lot Hold/Release		Y
114	JA	Budget or Cost Allocation		Y
115	JB	Joint Interest Billing		N
116	JC	Job Cost % Complete		N
117	JD	JIB Detail Owner Entries		N
118	JE	Journal Entry		Y
119	JF	Journals Brought Forward		N
120	JK	A/P Redistribute Payments		Y
121	JM	AR VAT Redistribution		Y
122	JP	Subscription Sales		N
123	JQ	Sub. Sales Net Ledger		N
124	JR	Subscription Sales Commissions		N
125	JT	Accrued Property Taxes		N
126	JV	A/P Redistribute Prepayments		Y
127	JX	Foreign Currency Revaluation		Y
128	JZ	Cash Basis Journal Entry		Y
129	K1	Kanban Type 1		Y
130	K2	Kanban Type 2		Y
131	K3	Kanban Type 3		Y
132	K4	Kanban Type 4		Y
133	LB	Labels		N
134	LC	Completed Lean Trans to Inv	L3	N
135	LH	Work Order Labor Hours		N
136	LL	Labor charged to Lean Trans	L2	N
137	LM	Material charged to Lean Trans	L1	N
138	LO	Component Scrap to Lean Trans	L	N
139	LP	Scrapped Lean Trans to Inv	L4	N
140	LS	Property Management Lease		N
141	LV	Variance calculated for Lean T	L	N
142	MP	Another Purchase Order		N
143	MS	Material Issue Service		N
144	MU	Mileage (Meter) Update		N
145	N	Other Values	N	N
146	NA	Stand Alone Nota Fiscal		N
147	ND	Ship-To Nota Fiscal Return		N
148	NF	Purchasing Nota Fiscal		N
149	NI	Non Stock Nota Fiscal		N
150	NL	Preliminary Order		N
151	NN	Nota Fiscal Reverse/Void		N
152	NO	Netting Transactions		Y
153	NP	Partial NSF		Y
154	NR	Ship-From Nota Fiscal Return		N
155	NS	Nota Fiscal Sales		N
156	O	Ordering Document Types		N
157	O1	Order Document Type Fixed Asse		N
158	O4	Purchase Order -Transportation		N
159	OA	Do Not Use		Y
160	OB	Blanket Order		N
161	OC	Construction Work Order		N
162	OD	Direct Ship Order		N
163	OE	Do Not Use--Exchange Rate Var.		Y
164	OI	Interoperability Direct P.O.		N
165	OK	Purchase Intercompany Order		N
166	OM	Purchase Order RMA		N
167	OO	Outside Operations
168	OP	Purchase Order		N
169	OQ	Purchase Quote or Bid		N
170	OR	Purchase Requisition		N
171	OS	Subcontract		N
172	OT	Transfer Order		N
173	OU	Requisition Self Service		Y
174	OV	Do Not Use--Receiving Document		Y
175	OX	Change Order		N
176	OY	EDI Purchase Order Quote
177	OZ	EDI Purchase Order
178	P	Payables		N
179	P1	A/P Drafts		Y
180	P7	Alternate Currency Payment		Y
181	P9	Voucher		Y
182	PA	Credit Note Reimbursements		Y
183	PB	BACS Electronic Funds Transfer		Y
184	PC	Percent Complete FASTR Entry		N
185	PD	Debit Memo		Y
186	PE	Change to Voucher Amount		Y
187	PF	Recurring Billing		N
188	PG	Gain/Loss on Exchange Rate		Y
189	PI	Physical Inventory		Y
190	PJ	Sales Overage		N
191	PK	Automated Check		Y
192	PL	Voucher Logging		Y
193	PM	Manual Voucher		Y
194	PN	Manual Check		Y
195	PO	Void Check		Y
196	PP	Periodic Invoice		Y
197	PQ	Manual Billing		N
198	PR	Recurring Voucher		Y
199	PT	Electronic Funds Transfer		Y
200	PV	Voucher		Y
201	PW	Withholding		Y
202	PY	Payment Order - EDI Only		Y
203	PZ	A/P Cash Basis		Y
204	Q7	Suspended VAT - Recognized		N
205	Q8	Suspended and Recognized VAT		N
206	Q9	Suspended VAT		N
207	QA	Non-Comformance Report		N
208	QO	Quote Order		N
209	QR	Quote Request		N
210	R	Receivables		N
211	R%	TDS Withholding		N
212	R1	A/R Drafts		Y
213	R2	Contract Billing		Y
214	R3	Draft Invoice		Y
215	R4	Final Invoice		Y
216	R5	Deduction		Y
217	R6	RMA - Sales Order		Y
218	R7	Alternate Currency Receipt		Y
219	R8	Return Material Authorization		N
220	R9	RMA Credit Order		N
221	RA	Adjustment		Y
222	RB	Chargeback		Y
223	RC	Receipts - A/R		Y
224	RD	Recurring Billing		N
225	RE	Change to Invoice Amount		Y
226	RF	Finance Charge		Y
227	RG	Gain/Loss on Exchange Rate		Y
228	RH	Expense Participation		N
229	RI	Invoice		Y
230	RJ	Sales Overage		N
231	RK	Receipt - Summarized		Y
232	RL	Escalation		N
233	RM	Credit Memo		Y
234	RN	Manual Billing		Y
235	RO	Reversing or Void Entry		Y
236	RP	Direct Payments		Y
237	RQ	Chargeback Amount Created		Y
238	RR	Recurring Invoice		Y
239	RS	Spread Adjustments		Y
240	RT	A/R Fee & Interest		Y
241	RU	Unapplied Cash		Y
242	RV	Non-sufficient Funds		Y
243	RW	Receipt Journal Entry		Y
244	RX	Sales Contracts		N
245	RY	EDI Receipt		Y
246	RZ	A/R Cash Basis		Y
247	S	Sales Order Document Types		N
248	S1	Counter Sales		N
249	S2	Phone Sales		N
250	S3	Sales Order - ECS		N
251	S4	Sales Order - Transportation	10	N
252	SB	Blanket Sales Order		N
253	SC	Actual Rate Schedule		Y
254	SD	Direct Ship		N
255	SE	Extended Warr. Service	N	N
256	SH	Supplier Recovery		N
257	SI	Interbranch Sales		N
258	SK	Sales Intercompany Order		N
259	SN	Nonwarranty Service	N	N
260	SO	Sales Order	SO	N
261	SP	Price List		N
262	SQ	Sales Quote		N
263	SR	Sales Order - Rush		N
264	SS	Do Not Use--Summary Records		Y
265	ST	Transfer Sale		N
266	SV	Base Warranty Service	N	N
267	SW	Sales with Trans. & Warehouse		N
268	SY	EDI Sales Order Quote		N
269	SZ	EDI Sales Order		N
270	T	Time and Pay		N
271	T1	Payroll Disbursement Entries		N
272	T2	Payroll Labor Distribution		N
273	T3	Actual Burden Journal Entries		N
274	T4	Labor Billing Distribution		N
275	T5	Equipment Distribution		N
276	T6	Payroll Accruals / Deferrals		N
277	T7	Payroll Vouchers		N
278	TE	Time Sheet Entry		N
279	TJ	Payroll Journal		N
280	TM	Enterprise Treasury Management		Y
281	TO	Takeoff		N
282	U1	U1 through U9 client reserved		N
283	UA	UA through UZ client reserved		N
284	UP	Used Produt		N
285	V1	Versand Service		N
286	VC	Sales Order Reverse		N
287	VD	Delivery ocument for Service		N
288	VL	Nota Fiscal Batch Return		N
289	VN	Vendor Notice
290	VO	Sales Order		N
291	VR	Sales Order Return		N
292	VS	Purchase Order Return		N
293	VT	Sales Transfer Order		N
294	W1	Work Order Other		N
295	WA	Work order for A		N
296	WC	Warranty Claim		N
297	WD	Write Downs
298	WH	Equipment Work Order		N
299	WM	Maintenance Work Order		N
300	WO	Real (firm) Work Orders		N
301	WP	Planning Work Orders		N
302	WT	Wire Transfer		N
303	X1	User-defined Doc Type X1
304	X2	User-defined Doc Type X2
305	X3	User-defined Doc Type X3
306	X4	User-defined Doc Type X4
307	XR	Rental Contracts		Y
308	Y1	User-defined Doc Type Y1
309	Y2	User-defined Doc Type Y2
310	Y3	User-defined Doc Type Y3
311	Y4	User-defined Doc Type Y4
312	Y5	User-defined Doc Type Y5
313	Z	Inv Cnv - Month End Summary		N
314	ZC	Document ZC		N
315	ZD	Document ZD		N
316	ZZ	Unrecognized Version E Trans.		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

12 columns | 920 | SDCT | STOCK UDC

TOPUDC 00 / DT (Document Type - All Documents) stock values