	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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

18 columns | 920 | PRP9 | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP34A: Advanced Planning & Scheduling
1	F34A40	APS Integration Group Setup Table	21	N0	PRP9	Group - Warehouse Process 3	String	UDC	6	0
TOP41: Inventory Management
2	F4101	Item Master	26	IM	PRP9	Group - Warehouse Process 3	String	UDC	6	0
3	F4101C	Item Category Codes	28	IM	PRP9	Group - Warehouse Process 3	String	UDC	6	0
4	F4101Z1	F4101 Item Master Unedited Transaction Table	41	SZ	PRP9	Group - Warehouse Process 3	String	UDC	6	0
5	F4102	Item Branch File	23	IB	PRP9	Group - Warehouse Process 3	String	UDC	6	0
6	F41UI001	Inventory Transactions Detail File	67	IT	PRP9	Group - Warehouse Process 3	String	UDC	6	0
TOP41F: Apparel Management
7	FCW08	Category Codes Work File	26	WK	PRP9	Group - Warehouse Process 3	String	UDC	6	0
8	FCW10	Item Branch Work File	51	WB	PRP9	Group - Warehouse Process 3	String	UDC	6	0
9	FCW96	Material Analysis	33	WO	PRP9	Group - Warehouse Process 3	String	UDC	6	0
10	FCW97	Grouping Messages	33	GM	PRP9	Group - Warehouse Process 3	String	UDC	6	0
TOP46: Warehouse Management
11	F46015	Replenishment Information by Random Rule	8	RR	PRP9	Group - Warehouse Process 3	String	UDC	6	0
12	F46093	Process Selection Rules	4	EM	PRP9	Group - Warehouse Process 3	String	UDC	6	0
13	F46093T	Process Group Tag Table	4	JC	PRP9	Group - Warehouse Process 3	String	UDC	6	0
14	F4611	Warehouse Suggestions	86	R2	PRP9	Group - Warehouse Process 3	String	UDC	6	0
15	F4611PU	Warehouse Suggestions - Purged	85	R2	PRP9	Group - Warehouse Process 3	String	UDC	6	0
16	F4611Z1	Unedited Suggestion Table	97	SZ	PRP9	Group - Warehouse Process 3	String	UDC	6	0
TOP47: Electronic Commerce
17	F47082	EDI Price Sales Catalog Detail - Inbound	40	FY	PRP9	Group - Warehouse Process 3	String	UDC	6	0
TOPF30L: DFM Line Design
18	FF30L501	DFM Item Definition Master	26	IB	PRP9	Group - Warehouse Process 3	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 41 / 02 (Warehouse Process Group) stock values

	Value	Description	Hard Coded
1		Blank	N
2	BIKE	Bicycle	N
3	BIND	Staples & Clips
4	BOOMER	Explosive Materials
5	CAROSL	Carousel Stored Goods
6	CASS	Cassettes
7	CII	Class II Controlled Substances
8	CONSUM	Consumer Goods
9	CPG	Cheese Process Group	N
10	DISK	Compact Disks
11	EAR	Earphones
12	ETHICL	Ethical Drugs
13	EXPLOD	Explosive Materials
14	FAST	Fast Movers
15	FROZEN	Frozen Items
16	HAZMAT	Hazardeous Materials
17	HEALTH	Health Products
18	HEAVY	Heavy Goods
19	HIVAL	High Value Goods
20	MED	Medical Equipment	N
21	NONINV	Non-Inventory Items
22	OFC	Office Supplies
23	OTC	Over the Counter	N
24	PAPER	Paper Products
25	PEN	Pens, Pencils, Markers
26	PERISH	Perishable Items
27	PMETAL	Precious Metal	N
28	PROMO	Promotional Items
29	RACK	Rack Stored Goods
30	REFRIG	Refrigerated Goods
31	RETURN	Sales Returns to Warehouse
32	SECURE	Goods Stored in Secured Areas
33	SHOE	Athletic Shoes
34	SLOW	Slow Movers
35	SPORT	Sporting Goods	N
36	STEREO	Stereo Equipment
37	T1	Type #1
38	T2	Type #2
39	TOPSEL	Top Selling Goods
40	TOWER	Tower Storage Items
41	UFO	Unidentified items	N
42	VIDEO	Video Cassettes	N
43	VIT	Vitamins
44	VPG	Vitamin Process Group	N
45	WATER	Mineral Water
46	WIRE	Stereo Wire

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

18 columns | 920 | PRP9 | STOCK UDC

TOPUDC 41 / 02 (Warehouse Process Group) stock values