	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

38 columns | 920 | PRODF | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP12: Fixed Assets
1	F1217	Equipment Master Extension	25	WR	PRODF	Product Family	String	UDC	8	0
2	F1217P	Equipment Master Extension Purge Table	25	WR	PRODF	Product Family	String	UDC	8	0
3	F1217Z1	Unedited Equipment Tag Transactions	38	WR	PRODF	Product Family	String	UDC	8	0
4	F1217Z2	Unedited Equipment Tag Transactions	38	WR	PRODF	Product Family	String	UDC	8	0
TOP13C: Condition-Base Maintenance
5	F1316	Condition-Based Maintenance Message Rules	6	CM	PRODF	Product Family	String	UDC	8	0
6	F1318	Condition-Based Maintenance Alert Action Rules	5	AR	PRODF	Product Family	String	UDC	8	0
TOP13E: Equipment Cost Analysis
7	F1381	Equipment Analysis Filters	12	EF	PRODF	Product Family	String	UDC	8	0
TOP17: Customer Service Management
8	F17113	Assessor Defaults	7	AD	PRODF	Product Family	String	UDC	8	0
9	F1721	Contract Detail	36	CD	PRODF	Product Family	String	UDC	8	0
10	F1771	Standard Repair Time	1	RT	PRODF	Product Family	String	UDC	8	0
11	F1791	Entitlement Dates	1	EM	PRODF	Product Family	String	UDC	8	0
12	F3111Z2	Warranty Claim/Supplier Recovery processing	128	WP	PRODF	Product Family	String	UDC	8	0
13	F3112Z2	Warranty Claim/Supplier Recovery processing	145	WL	PRODF	Product Family	String	UDC	8	0
14	F31171	Parts List - Extension	35	WS	PRODF	Product Family	String	UDC	8	0
15	F31171S	Purge Parts List - Extension	35	WS	PRODF	Product Family	String	UDC	8	0
16	F31172	Routing Instructions - Extension	38	WS	PRODF	Product Family	String	UDC	8	0
17	F31172S	Purge Routing Instructions - Extension	38	WS	PRODF	Product Family	String	UDC	8	0
18	F4117	Item Master - Service/Warranty Extension	3	PR	PRODF	Product Family	String	UDC	8	0
19	F41171	Item Branch Master - Service/Warranty Extension	4	PB	PRODF	Product Family	String	UDC	8	0
20	F4801TZ2	Warranty Claim/Supplier Recovery processing	87	WQ	PRODF	Product Family	String	UDC	8	0
21	F48162	Failure Analysis Tree Names	4	KN	PRODF	Product Family	String	UDC	8	0
22	F48164	Failure Analysis Detail	29	KB	PRODF	Product Family	String	UDC	8	0
TOP17C: Call Management
23	F17111	Base Warranty Defaults	7	BC	PRODF	Product Family	String	UDC	8	0
24	F1754	Case Provider Group Routing Rules	2	ZB	PRODF	Product Family	String	UDC	8	0
25	F1755	Case Master	68	ZA	PRODF	Product Family	String	UDC	8	0
26	F1790	Product Family/Model Master	1	PM	PRODF	Product Family	String	UDC	8	0
TOP37: Quality Management
27	F37011	Test Equipment	12	TE	PRODF	Product Family	String	UDC	8	0
TOP41: Inventory Management
28	F4101F	Item Customer Service Data	11	IM	PRODF	Product Family	String	UDC	8	0
29	F4101Z1A	F4101 Detail Item Master Unedited Transaction	67	SZ	PRODF	Product Family	String	UDC	8	0
TOP41F: Apparel Management
30	FCW10	Item Branch Work File	88	WB	PRODF	Product Family	String	UDC	8	0
31	FCW15	Work File F41171	5	WF	PRODF	Product Family	String	UDC	8	0
32	FCW58	Item Master - Service/Warranty Extension (F4117) Work File	4	WF	PRODF	Product Family	String	UDC	8	0
TOP44H: Homebuilder Management
33	F44H0920	Extended Homebuilder Data Template	8	ST	PRODF	Product Family	String	UDC	8	0
34	F44H0929	Extended Homebuilder Data	30	ED	PRODF	Product Family	String	UDC	8	0
TOP48: Work Order Processing
35	F4801ST	Purge - Work Order Master Tag File	74	WA	PRODF	Product Family	String	UDC	8	0
36	F4801T	Work Order Master Tag File	74	WA	PRODF	Product Family	String	UDC	8	0
37	F4817	Service Order Extension	49	SR	PRODF	Product Family	String	UDC	8	0
TOPH90: EnterpriseOne TOOLS
38	F1761	Electronic Help JDE Request Log	22	ZA	PRODF	Product Family	String	UDC	8	0

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

TOPUDC 17 / PA (Product Family) stock values

	Value	Description	Hard Coded
1		.	N
2	0000	No Family	N
3	A100	Demo Family	N
4	ACCES	Accesories	N
5	ACD	Automatic Call Dist.	N
6	APP	Appliances	N
7	CABLE	Cable	N
8	CBX	Computerized Branch Exchange	N
9	DRYPART	Clothes Dryer Parts	N
10	HEAD	Headset	N
11	MODEM	Modem	N
12	MON	Monitor	N
13	PG	Pagers	N
14	PHONE	Phone Sets	N
15	PRINT	Printer	N
16	SERV	Server	N
17	SOFTW	Software	N
18	TOOLS	Tool Set	N
19	VM	Voice Messaging Phone Mail	N
20	WASHPART	Clothes Washer Parts	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

38 columns | 920 | PRODF | STOCK UDC

TOPUDC 17 / PA (Product Family) stock values