	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

35 columns | 812 | 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 - Customer Service Extension	3	PR	PRODF	Product Family	String	UDC	8	0
19	F41171	Item Branch Master - Customer Service 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
TOP17C: Call Management
21	F17111	Base Warranty Defaults	7	BC	PRODF	Product Family	String	UDC	8	0
22	F1754	Call Queue Routing Rules	2	ZB	PRODF	Product Family	String	UDC	8	0
23	F1755	Customer Call Master	68	ZA	PRODF	Product Family	String	UDC	8	0
24	F1790	Product Family/Model Master	1	PM	PRODF	Product Family	String	UDC	8	0
25	F48162	Knowledge Base Tree Names	4	KN	PRODF	Product Family	String	UDC	8	0
26	F48164	Knowledge Base Detail	29	KB	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
TOP44H: Homebuilder Management
30	F44H0920	Extended Homebuilder Data Template	8	ST	PRODF	Product Family	String	UDC	8	0
31	F44H0929	Extended Homebuilder Data	30	ED	PRODF	Product Family	String	UDC	8	0
TOP48: Work Order Processing
32	F4801ST	Purge - Work Order Master Tag File	74	WA	PRODF	Product Family	String	UDC	8	0
33	F4801T	Work Order Master Tag File	74	WA	PRODF	Product Family	String	UDC	8	0
34	F4817	Service Order Extension	49	SR	PRODF	Product Family	String	UDC	8	0
TOPH90: ONEWORLD TOOLS
35	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	ACCES	Accesories	N
3	ACD	Automatic Call Dist.	N
4	CABLE	Cable	N
5	CBX	Computerized Branch Exchange	N
6	GOLF	Golf Group	N
7	HEAD	Headset	N
8	MODEM	Modem	N
9	MON	Monitor	N
10	PG	Pagers	N
11	PHONE	Phone Sets	N
12	PRINT	Printer	N
13	SERV	Server	N
14	SOFTW	Software	N
15	TOOLS	Tool Set	N
16	VM	Voice Messaging Phone Mail	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

35 columns | 812 | PRODF | STOCK UDC

TOPUDC 17 / PA (Product Family) stock values