	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

45 columns | 812 | HOLD | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0401Z1	Supplier Master - Batch File	51	VO	HOLD	Hold Orders Code	String	UDC	2	0
TOP01: Address Book
2	F0401	Supplier Master	37	A6	HOLD	Hold Orders Code	String	UDC	2	0
TOP03: Accounts Receivable
3	F03012	Customer Master by Line of Business	85	AI	HOLD	Hold Orders Code	String	UDC	2	0
4	F03012Z1	Customer Master LOB-Batch File	98	VO	HOLD	Hold Orders Code	String	UDC	2	0
TOP40: Inventory/OP Base
5	F4001Z	Batch Receiver File - Order Headings	66	SY	HOLD	Hold Orders Code	String	UDC	2	0
6	F4011Z	Batch Receiver File - Order Details	249	SZ	HOLD	Hold Orders Code	String	UDC	2	0
7	F4201Z1	Sales Order Header Unedited Transaction File	55	SY	HOLD	Hold Orders Code	String	UDC	2	0
8	F4211Z1	Sales Order Detail Unedited Transaction File	242	SZ	HOLD	Hold Orders Code	String	UDC	2	0
TOP40R: Demand Scheduling
9	F40R30WF	Demand Work File	26	DS	HOLD	Hold Orders Code	String	UDC	2	0
TOP42: Sales Management
10	F4201	Sales Order Header File	42	SH	HOLD	Hold Orders Code	String	UDC	2	0
11	F42019	Sales Order Header History File	42	SH	HOLD	Hold Orders Code	String	UDC	2	0
12	F4211	Sales Order Detail File	229	SD	HOLD	Hold Orders Code	String	UDC	2	0
13	F42119	Sales Order History File	229	SD	HOLD	Hold Orders Code	String	UDC	2	0
14	F42199	S.O. Detail Ledger File	229	SL	HOLD	Hold Orders Code	String	UDC	2	0
15	F42UI01	SO Header Cache File (MBF)	47	ZH	HOLD	Hold Orders Code	String	UDC	2	0
16	F42UI11	SO Detail Cache File (MBF)	168	ZD	HOLD	Hold Orders Code	String	UDC	2	0
TOP43: Procurement
17	F4301	Purchase Order Header	36	PH	HOLD	Hold Orders Code	String	UDC	2	0
18	F4301Z	PO Header Work File	40	PA	HOLD	Hold Orders Code	String	UDC	2	0
19	F4301Z1	Purchase Order Header Unedited Transaction Table	49	SY	HOLD	Hold Orders Code	String	UDC	2	0
TOP47: Electronic Commerce
20	F47011	EDI Purchase Order Header - Inbound	126	SY	HOLD	Hold Orders Code	String	UDC	2	0
21	F47012	EDI Purchase Order Detail - Inbound	250	SZ	HOLD	Hold Orders Code	String	UDC	2	0
22	F47016	EDI Purchase Order Header - Outbound	52	SY	HOLD	Hold Orders Code	String	UDC	2	0
23	F47021	EDI P.O. Acknowledgment Header - Inbound	52	SY	HOLD	Hold Orders Code	String	UDC	2	0
24	F47026	EDI P.O. Acknowledgment Header - Outbound	118	SY	HOLD	Hold Orders Code	String	UDC	2	0
25	F47027	EDI P.O. Acknowledgment Detail - Outbound	250	SZ	HOLD	Hold Orders Code	String	UDC	2	0
26	F47031	EDI Shipping Notice Header - Inbound	47	SY	HOLD	Hold Orders Code	String	UDC	2	0
27	F47036	EDI Shipping Notice Header - Outbound	51	SY	HOLD	Hold Orders Code	String	UDC	2	0
28	F470371	EDI Shipping Notice Detail - Outbound	234	SZ	HOLD	Hold Orders Code	String	UDC	2	0
29	F47046	EDI Invoice Header (Sales) - Outbound	116	SY	HOLD	Hold Orders Code	String	UDC	2	0
30	F47047	EDI Invoice Detail (Sales) - Outbound	233	SZ	HOLD	Hold Orders Code	String	UDC	2	0
31	F47071	EDI Receiving Advice Header - Inbound	53	SY	HOLD	Hold Orders Code	String	UDC	2	0
32	F47076	EDI Receiving Advice Header - Outbound	53	SY	HOLD	Hold Orders Code	String	UDC	2	0
33	F47091	EDI Request for Quote Header - Inbound	126	SY	HOLD	Hold Orders Code	String	UDC	2	0
34	F47092	EDI Request for Quote Detail - Inbound	250	SZ	HOLD	Hold Orders Code	String	UDC	2	0
35	F47096	EDI Request for Quote Header - Outbound	52	SY	HOLD	Hold Orders Code	String	UDC	2	0
36	F47101	EDI Response to RFQ Header - Inbound	52	SY	HOLD	Hold Orders Code	String	UDC	2	0
37	F47106	EDI Response to RFQ Header - Outbound	119	SY	HOLD	Hold Orders Code	String	UDC	2	0
38	F47107	EDI Response to RFQ Detail - Outbound	251	SZ	HOLD	Hold Orders Code	String	UDC	2	0
39	F47131	EDI Purchase Order Change Header - Inbound	123	SY	HOLD	Hold Orders Code	String	UDC	2	0
40	F47132	EDI Purchase Order Change Detail - Inbound	251	SZ	HOLD	Hold Orders Code	String	UDC	2	0
41	F47136	EDI Purchase Order Change Header - Outbound	52	SY	HOLD	Hold Orders Code	String	UDC	2	0
42	F47141	EDI P.O. Change Acknowledgment Header - Inbound	53	SY	HOLD	Hold Orders Code	String	UDC	2	0
43	F47146	EDI P.O. Change Acknowledgment Header - Outbound	120	SY	HOLD	Hold Orders Code	String	UDC	2	0
44	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	253	SZ	HOLD	Hold Orders Code	String	UDC	2	0
45	F47156	EDI Shipping Schedule Header - Outbound	55	SY	HOLD	Hold Orders Code	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 42 / HC (Hold Codes) stock values

	Value	Description	Special Handling Code	Hard Coded
1	AH	Approval Hold	1	Y
2	B1	Budget Hold		N
3	C1	Credit Hold		N
4	C2	Credit Hold - Aging		N
5	C3	Credit Hold		N
6	CA	Credit Card Authorization Hold		N
7	CS	Credit Card Settlement Hold		N
8	L1	Order Level 1		N
9	L2	Order Level 2		N
10	L3	Order Level 3		N
11	L4	Order Level 4		N
12	L5	Order Level 5		N
13	M1	Margin Order Hold		N
14	M2	Margin Line Hold		N
15	MN	Minimum Value Checking		N
16	MX	Maximum Value Checking		N
17	PA	Product Allocation Hold		N
18	PH	Partial Order Hold		N
19	Q1	Receipt Quantity Hold		N
20	WO	Work Order/PO Change		N
21	XX	Administrative Hold		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

45 columns | 812 | HOLD | STOCK UDC

TOPUDC 42 / HC (Hold Codes) stock values