	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

40 columns | 910 | PRODM | STOCK UDC

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

	Value	Description	Hard Coded
1		.	N
2	ACDUL	ACD Ultra Model	N
3	ADAPT	Adapt	N
4	AGENTS	Agent Software	N
5	C100	CBX Model 100	N
6	C200	CBX Model 200	N
7	CAB13	13 Foot Cable	N
8	CAB25	25 Foot Cable	N
9	CAB7	7 Foot Cable	N
10	CALLR	Call Routing Software	N
11	CIRCBD	Circuit Board	N
12	CUSH	Ear Cushions	N
13	DISPLAY	Display Phone	N
14	DLX	Deluxe Pagers	N
15	DRIVER	Great Big Bubba Driver	N
16	EARSET	Headset one ear piece	N
17	HEADB	Headset Headband	N
18	IRONS	Cobra II Irons	N
19	JACK	Handset Jack	N
20	LASER	Laser Printer	N
21	MEDKIT	Server Media Kit	N
22	MOD38	38 Series Modem	N
23	MONMED	Medium Monitor 17"	N
24	PH12DIG	12 Digit Phone	N
25	PH24DIG	24 Digit Phone	N
26	PUTTER	Odyessy DF 772	N
27	REPORT	Reporting Software	N
28	STD	Standard Pagers	N
29	TERMSER	Terminal Server	N
30	TESTSET	Test Set Tool	N
31	V100	VM Model 100	N
32	V200	VM Model 200	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

40 columns | 910 | PRODM | STOCK UDC

TOPUDC 17 / PM (Product Model) stock values