	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

2 columns | 920 | RFTY2 | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP47: Electronic Commerce
1	F470462	EDI Invoice Expanded Header (Sales)	32	S5	RFTY2	Reference Type-2	String	UDC	3	0
2	F470472	EDI Invoice Expanded Detail (Sales)	57	S6	RFTY2	Reference Type-2	String	UDC	3	0

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

TOPUDC 40R / QF (Qualifier) stock values

	Value	Description	Hard Coded
1	AX	Case Number	N
2	BN	Back Number	N
3	CG	Chargeable Gross Weight	N
4	CL	Color	N
5	CM	Commodity Grouping Number	N
6	CN	Chassis Number	N
7	CO	Customer Order Date	N
8	CS	Consignee Shipment Reference	N
9	CY	Commodity Name	N
10	DE	Main Route Code	N
11	DG	Dangerous Goods Date	N
12	DN	Dangerous Goods Number	N
13	DO	Delivery Number	N
14	DS	Delivery Schedule Date	N
15	DX	Delivery Schedule Number	N
16	EC	Earliest Collection Date/Time	N
17	FD	First Delivery Date/Time	N
18	FX	Free Text	N
19	GB	Buyer's Internal Product Group	N
20	GD	Generation Date	N
21	GO	Gross Weight UOM	N
22	GW	Gross Weight	N
23	HD	Hazardous Goods Date	N
24	HS	Harmonized System Code	N
25	JN	Job Number	N
26	JS	Job Sequence Number	N
27	LC	Latest Collection Date/Time	N
28	LD	Last Delivery Date/Time	N
29	LN	Line Number (866)	N
30	LO	Module Load Type	N
31	LU	Store Address	N
32	MD	Manufacture Date/Time	N
33	MI	Material ID Number	N
34	MN	Model Number	N
35	MP	Manufacturing Department	N
36	MR	Manufacturer Reference Number	N
37	MS	Measurement ID	N
38	MU	Measurement Unit Code	N
39	MV	Measurement Value	N
40	MX	Measurement Range Maximum	N
41	OQ	Final Requirement Number	N
42	PC	Product Characteristics	N
43	PD	Production Date/Time	N
44	PE	Promotion Deal Date	N
45	PI	Product/Item Description	N
46	PN	Process Number	N
47	PO	Purchaser's Order Number	N
48	PR	Previous Delivery Instruction	N
49	PS	Product/Service ID Number	N
50	PU	Promotion Deal Number	N
51	RD	Reference Date/Time	N
52	RI	Reference ID	N
53	RN	Reference Number	N
54	SA	Supplier's Article Number	N
55	SC	SCAC Code	N
56	SD	Ship Direct Order Date/Time	N
57	SM	Special Material ID Code	N
58	SP	Ship Delivery Pattern	N
59	ST	Ship Delivery Time Code	N
60	TM	Transport Means	N
61	TR	Transaction Reference Number	N
62	TT	Transit Time	N
63	TZ	Time Zone	N
64	UC	Ultimate Customer Order Number	N
65	UD	Ultimate Destination Dock	N
66	UL	Ultimate Destination Line Feed	N
67	UP	UPC Code	N
68	VP	Vendor Part Number	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

2 columns | 920 | RFTY2 | STOCK UDC

TOPUDC 40R / QF (Qualifier) stock values