	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

93 columns | 812 | EDST | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP40: Inventory/OP Base
1	F4001Z	Batch Receiver File - Order Headings	7	SY	EDST	EDI - Transaction Set Number	String	UDC	6	0
2	F4011Z	Batch Receiver File - Order Details	7	SZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
TOP40R: Demand Scheduling
3	F47171	EDI Demand Header	7	EH	EDST	EDI - Transaction Set Number	String	UDC	6	0
4	F47172	EDI Demand Detail	7	ED	EDST	EDI - Transaction Set Number	String	UDC	6	0
5	F471721	EDI Demand Supplemental Data	7	EU	EDST	EDI - Transaction Set Number	String	UDC	6	0
6	F471722	EDI Demand Addresses	7	EA	EDST	EDI - Transaction Set Number	String	UDC	6	0
7	F471723	EDI Demand Contact Names	7	EC	EDST	EDI - Transaction Set Number	String	UDC	6	0
8	F471724	EDI Demand Contact Numbers	7	EN	EDST	EDI - Transaction Set Number	String	UDC	6	0
9	F47173	EDI Demand Scheduling Detail	7	ES	EDST	EDI - Transaction Set Number	String	UDC	6	0
10	F471731	EDI Demand Packaging	7	EP	EDST	EDI - Transaction Set Number	String	UDC	6	0
11	F47800	EDI Transmission Values	5	FF	EDST	EDI - Transaction Set Number	String	UDC	6	0
TOP42: Sales Management
12	F47027T	Tag for F47027 - EDI P.O. Acknowledgment Detail - Outbound	17	UZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
13	F470371T	Tag for F470371- EDI shipping Notice Detail - Outbound	28	UZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
14	F47047T	Tag for F47047- EDI Invoice Detail (Sales) - Outbound	17	UZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
15	F47107T	Tag for F47107- EDI Response to RFQ Detail - Outbound	17	UZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
16	F47147T	Tag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound	17	UZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
TOP42B: Sales Order Entry
17	F4011ZT	Batch Receiver File - Order Details Tag	7	UZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
18	F47012T	EDI Purchase Order Detail Tag - Inbound	7	UZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
19	F47092T	EDI Request for Quote Detail Tag - Inbound	7	UZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
20	F47132T	EDI Purchase Order Change Detail Tag - Inbound	7	UZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
TOP45: Advanced Pricing
21	F4576Z1	Ship and Debit Claims Unedited Transaction Table	105	Z1	EDST	EDI - Transaction Set Number	String	UDC	6	0
TOP47: Electronic Commerce
22	F47003	EDI Discrepancy Report Work File	9	SX	EDST	EDI - Transaction Set Number	String	UDC	6	0
23	F47011	EDI Purchase Order Header - Inbound	7	SY	EDST	EDI - Transaction Set Number	String	UDC	6	0
24	F47012	EDI Purchase Order Detail - Inbound	7	SZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
25	F47016	EDI Purchase Order Header - Outbound	7	SY	EDST	EDI - Transaction Set Number	String	UDC	6	0
26	F470161	EDI Purchase Order Additional Header - Outbound	72	S3	EDST	EDI - Transaction Set Number	String	UDC	6	0
27	F47017	EDI Purchase Order Detail - Outbound	7	SZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
28	F470171	EDI Purchase Order Additional Detail - Outbound	53	S4	EDST	EDI - Transaction Set Number	String	UDC	6	0
29	F47021	EDI P.O. Acknowledgment Header - Inbound	7	SY	EDST	EDI - Transaction Set Number	String	UDC	6	0
30	F47022	EDI P.O. Acknowledgment Detail - Inbound	7	SZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
31	F47026	EDI P.O. Acknowledgment Header - Outbound	7	SY	EDST	EDI - Transaction Set Number	String	UDC	6	0
32	F47027	EDI P.O. Acknowledgment Detail - Outbound	7	SZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
33	F47031	EDI Shipping Notice Header - Inbound	7	SY	EDST	EDI - Transaction Set Number	String	UDC	6	0
34	F47032	EDI Shipping Notice Detail - Inbound	7	SZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
35	F47036	EDI Shipping Notice Header - Outbound	7	SY	EDST	EDI - Transaction Set Number	String	UDC	6	0
36	F47037	EDI Shipping Notice Detail - Outbound	7	SZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
37	F470371	EDI Shipping Notice Detail - Outbound	7	SZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
38	F470372	EDI ASN Demand Scheduling Detail	7	AI	EDST	EDI - Transaction Set Number	String	UDC	6	0
39	F470373	EDI ASN Shipping	6	AG	EDST	EDI - Transaction Set Number	String	UDC	6	0
40	F470374	EDI ASN Demand Addresses	8	AM	EDST	EDI - Transaction Set Number	String	UDC	6	0
41	F470375	EDI ASN Packaging Detail	7	AK	EDST	EDI - Transaction Set Number	String	UDC	6	0
42	F47041	EDI Invoice Header - Inbound	7	SY	EDST	EDI - Transaction Set Number	String	UDC	6	0
43	F47042	EDI Invoice Detail - Inbound	7	SZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
44	F47044	EDI Invoice Summary - Inbound	7	SW	EDST	EDI - Transaction Set Number	String	UDC	6	0
45	F47046	EDI Invoice Header (Sales) - Outbound	7	SY	EDST	EDI - Transaction Set Number	String	UDC	6	0
46	F47047	EDI Invoice Detail (Sales) - Outbound	7	SZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
47	F47056	EDI Payment Order Header - Outbound	7	D1	EDST	EDI - Transaction Set Number	String	UDC	6	0
48	F47056W	EDI Payment Order Header - Work	7	D1	EDST	EDI - Transaction Set Number	String	UDC	6	0
49	F47057	EDI Payment Order Remittance Advice - Outbound	7	D3	EDST	EDI - Transaction Set Number	String	UDC	6	0
50	F47057W	EDI Payment Order Remittance Advice - Work	7	D3	EDST	EDI - Transaction Set Number	String	UDC	6	0
51	F47061	EDI Planning Schedule Header - Inbound	7	MJ	EDST	EDI - Transaction Set Number	String	UDC	6	0
52	F47062	EDI Planning Schedule Detail - Inbound	7	MY	EDST	EDI - Transaction Set Number	String	UDC	6	0
53	F47066	EDI Planning Schedule Header - Outbound	7	MJ	EDST	EDI - Transaction Set Number	String	UDC	6	0
54	F47067	EDI Planning Schedule Detail - Outbound	7	MY	EDST	EDI - Transaction Set Number	String	UDC	6	0
55	F47071	EDI Receiving Advice Header - Inbound	7	SY	EDST	EDI - Transaction Set Number	String	UDC	6	0
56	F47072	EDI Receiving Advice Detail - Inbound	7	SZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
57	F47076	EDI Receiving Advice Header - Outbound	7	SY	EDST	EDI - Transaction Set Number	String	UDC	6	0
58	F47077	EDI Receiving Advice Detail - Outbound	7	SZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
59	F47081	EDI Price Sales Catalog Header - Inbound	7	FV	EDST	EDI - Transaction Set Number	String	UDC	6	0
60	F47082	EDI Price Sales Catalog Detail - Inbound	7	FY	EDST	EDI - Transaction Set Number	String	UDC	6	0
61	F47091	EDI Request for Quote Header - Inbound	7	SY	EDST	EDI - Transaction Set Number	String	UDC	6	0
62	F47092	EDI Request for Quote Detail - Inbound	7	SZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
63	F47096	EDI Request for Quote Header - Outbound	7	SY	EDST	EDI - Transaction Set Number	String	UDC	6	0
64	F47097	EDI Request for Quote Detail - Outbound	7	SZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
65	F47101	EDI Response to RFQ Header - Inbound	7	SY	EDST	EDI - Transaction Set Number	String	UDC	6	0
66	F47102	EDI Response to RFQ Detail - Inbound	7	SZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
67	F47106	EDI Response to RFQ Header - Outbound	7	SY	EDST	EDI - Transaction Set Number	String	UDC	6	0
68	F47107	EDI Response to RFQ Detail - Outbound	7	SZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
69	F47111	EDI Lockbox/Payment Header - Transaction	7	Z1	EDST	EDI - Transaction Set Number	String	UDC	6	0
70	F47112	EDI Lockbox Header - Transaction	7	Z2	EDST	EDI - Transaction Set Number	String	UDC	6	0
71	F47121	EDI Product Activity Data Header - Inbound	7	M1	EDST	EDI - Transaction Set Number	String	UDC	6	0
72	F47122	EDI Product Activity Data Detail - Inbound	7	MJ	EDST	EDI - Transaction Set Number	String	UDC	6	0
73	F47126	EDI Product Activity Data Header - Outbound	7	M1	EDST	EDI - Transaction Set Number	String	UDC	6	0
74	F47127	EDI Product Activity Data Detail - Outbound	7	MJ	EDST	EDI - Transaction Set Number	String	UDC	6	0
75	F47131	EDI Purchase Order Change Header - Inbound	7	SY	EDST	EDI - Transaction Set Number	String	UDC	6	0
76	F47132	EDI Purchase Order Change Detail - Inbound	7	SZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
77	F47136	EDI Purchase Order Change Header - Outbound	7	SY	EDST	EDI - Transaction Set Number	String	UDC	6	0
78	F47137	EDI Purchase Order Change Detail - Outbound	7	SZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
79	F47141	EDI P.O. Change Acknowledgment Header - Inbound	7	SY	EDST	EDI - Transaction Set Number	String	UDC	6	0
80	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	7	SZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
81	F47146	EDI P.O. Change Acknowledgment Header - Outbound	7	SY	EDST	EDI - Transaction Set Number	String	UDC	6	0
82	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	7	SZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
83	F47156	EDI Shipping Schedule Header - Outbound	7	SY	EDST	EDI - Transaction Set Number	String	UDC	6	0
84	F47157	EDI Shipping Schedule Detail - Outbound	7	SZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
85	F4716	EDI Item Text - Inbound/Outbound	7	SZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
86	F47191	EDI Acknowledgement Header	7	AH	EDST	EDI - Transaction Set Number	String	UDC	6	0
87	F47192	EDI Acknowledgement Error Detail	7	AE	EDST	EDI - Transaction Set Number	String	UDC	6	0
88	F47194	EDI Acknowledgement References	7	AR	EDST	EDI - Transaction Set Number	String	UDC	6	0
89	F47196	EDI Acknowledgement Name And Address	7	AA	EDST	EDI - Transaction Set Number	String	UDC	6	0
90	F47198	EDI Acknowledgement Notes	7	AN	EDST	EDI - Transaction Set Number	String	UDC	6	0
91	F4722	EDI Tolerance Rules	1	PZ	EDST	EDI - Transaction Set Number	String	UDC	6	0
92	F47CTL	EDI Lockbox/Payment Work File	11	Z5	EDST	EDI - Transaction Set Number	String	UDC	6	0
93	F47HL	Hierarchical Configuration	1	HL	EDST	EDI - Transaction Set Number	String	UDC	6	0

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

TOPUDC 40 / ST (EDI - Transaction Set Number) stock values

	Value	Description	Hard Coded
1		Default - Trans. Set ID 40/ST
2	810	Invoice
3	820	Payment Order
4	823	Lockbox
5	824	Application Advice	Y
6	830	Planning Schedule
7	832	Price Sales Catalog
8	840	Request for Quote
9	843	Response to RFQ
10	844	Claim Notification	N
11	845	Claim Acknowledgement	N
12	849	Claim Status Notification	N
13	850	Purchase Order
14	852	Product Activity Data
15	855	Purchase Order Acknowledgment
16	856	Shipment Notice
17	860	Purchase Order Change
18	861	Receiving Advice
19	865	Purchase Order Change Ack.
20	867	Product Transfer and Resale
21	997	Functional Acknowledgment	Y
22	APERAK	Application Advice	Y
23	CONTRL	Functional Acknowledgment	Y
24	DEBADV	Lockbox
25	DELFOR	Planning Schedule
26	DEMAND	Inbound Demand	Y
27	DESADV	Shipment Notice	Y
28	INVOIC	Invoice
29	ORDERS	Purchase Order
30	ORDRSP	Purchase Order Acknowledgment
31	PAYEXT	Payment Order
32	PRICAT	Price Sales Catalog
33	QUOTES	Response to RFQ
34	REQUOT	Request for Quote

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

93 columns | 812 | EDST | STOCK UDC

TOPUDC 40 / ST (EDI - Transaction Set Number) stock values