	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

9 columns | 910 | METRIC | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F80D307	Metric Action Cross Reference	2	HD	METRIC	Metric ID	Numeric	UDC	4	0
2	F80D309	Metric Series Cross Ref	1	MS	METRIC	Metric ID	Numeric	UDC	4	0
3	F80D322	UI Metric Group Detail	3	MD	METRIC	Metric ID	Numeric	UDC	4	0
TOP80D: Plant Manager Dashboard
4	F80D107	Goals Definition	1	GD	METRIC	Metric ID	Numeric	UDC	4	0
5	F80D107A	Goals Definition Tag	1	GT	METRIC	Metric ID	Numeric	UDC	4	0
6	F80D108	Goals Definition Cross Reference	1	GK	METRIC	Metric ID	Numeric	UDC	4	0
7	F80D301	Dashboard Code Metric Cross Reference	2	DM	METRIC	Metric ID	Numeric	UDC	4	0
8	F80D302	Metric ID Time Dimension Cross Reference	1	CR	METRIC	Metric ID	Numeric	UDC	4	0
9	F80D303	Metric Definition	1	MD	METRIC	Metric ID	Numeric	UDC	4	0

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

TOPUDC 00 / MI (Metrics Identifier) stock values

	Value	Description	Special Handling Code	Hard Coded
1	2000	Days Sales Outstanding		Y
2	2010	Days Payables Outstanding		Y
3	2020	Cash to Cash Cycle Time		Y
4	2100	OnTime Shipment Cust Request		Y
5	2110	OnTime Shipment Promised		Y
6	2111	OnTime Shipment Promised Sum		Y
7	2120	Past Due Count		Y
8	2121	Past Due Amount		Y
9	2130	BackOrder Count		Y
10	2131	BackOrder Amount		Y
11	2140	Promise to Request Variance		Y
12	2150	Book to Ship Days		Y
13	2200	Days Sales in Inventory		Y
14	2201	Inventory Turns		Y
15	2300	On Time Production Completions		Y
16	2310	Actual Production versus Plan		Y
17	2400	Booked Order Value		Y
18	2410	Shipped Order Revenue		Y
19	2411	Revenue Trend by Brand 1		Y
20	2412	Revenue Trend by Brand 2		Y
21	2413	Revenue Trend by Branch 1		Y
22	2414	Revenue Trend by Branch 2		Y
23	2415	Revenue Trend by Product 1		Y
24	2416	Revenue Trend by Product 2		Y
25	2420	Projected Revenue		Y
26	2430	Backlog		Y
27	2500	Supplier On Time Delivery		Y
28	2510	Material Lead Time Exceptions		Y
29	2520	Pass Quality		Y
30	3301	AR Invoice and Receipt Amounts		Y
31	3302	AR Average Invoice Amounts		Y
32	3303	AR Invoice and Receipt counts		Y
33	3305	AR Open Chargeback		Y
34	3306	AR Open Chrgbck by Reason Cd		Y
35	3307	AR Total Chargeback		Y
36	3308	AR Total Chrgbck by Reason Cd		Y
37	3309	AR Delinquency Amounts		Y
38	3310	AR Delinquency Counts		Y
39	3311	AR Open Invoice Amount		Y
40	3312	AR Open Invoice Count		Y
41	3313	AR Discount Amount		Y
42	3314	AR Discount Percentage		Y
43	3315	DSO by Company		Y
44	3316	DSO by Customer		Y
45	3344	Unposted Trans Inc and Exp		Y
46	3400	AP Discount Amount		Y
47	3401	AP Discount Percentage		Y
48	3402	AP Open Voucher Amount		Y
49	3403	AP Open Voucher Count		Y
50	3404	AP Vouchers Paid Late Amount		Y
51	3405	AP Vouchers Paid Late Count		Y
52	3406	AP Voucher and Payment Amounts		Y
53	3407	AP Voucher and Payment Counts		Y
54	3501	Forecasted Cash Flow	2	Y
55	3502	Profit Margin On Sales	2	Y
56	3503	Return On Total Assets	2	Y
57	3504	After tax Profit On Sales	2	Y
58	3505	Return On Net Worth	2	Y
59	3506	Current Ratio	2	Y
60	3507	Quick Acid Test	2	Y
61	3508	Times Interest Earned	2	Y
62	3509	Debt To Total Assets	2	Y
63	3510	Fixed Asset turnover	2	Y
64	3511	Inventory Turnover	2	Y
65	3512	Total Asset Turnover	2	Y
66	3513	Operating Income		Y
67	3514	Operating Expense		Y
68	3515	Operating Profit		Y
69	3516	Most Profitable Brands		Y
70	3517	Most Profitable Customers		Y
71	3518	Most Profitable Products		Y
72	5501	Open Purchase Amount - Date		Y
73	5502	Open Purchase Amount-Commodity		Y
74	5503	Open Purchase Amount-Supplier		Y
75	5504	PO Count - Date		Y
76	5505	PO Count - Supplier		Y
77	5506	Average PO Amt - Date		Y
78	5507	Average PO Amt-Supp		Y
79	5508	Total Purchase Amount-Date		Y
80	5509	Total Purchase Amt-Supplier		Y
81	5510	Total Purchase Amt-LineType		Y
82	5511	Total Purchase Amt-Commodity		Y
83	5521	Blanket Purchase Amt-Date		Y
84	5522	Blanket Purchase Amount-Cmdty		Y
85	5523	Blanket Purchase Amt-Supplier		Y
86	5524	Agreement Purchase Amt-Date		Y
87	5525	Agreement Purchase Amt-Cmdty		Y
88	5526	Agreement Purchase Amt-Supp		Y
89	5527	Manual Priced PO Amount-Date		Y
90	5528	Manual Priced PO Amt-Cmdty		Y
91	5529	Manual Priced PO Amt-Supplier		Y
92	5530	Manual Priced PO Count-Date		Y
93	5531	Manual Priced PO Count-Cmdty		Y
94	5532	Manual Priced PO Count-Supp		Y
95	5541	Mtrl LeadTime Exc Count-Supp		Y
96	5542	Mtrl LeadTime Exc Percent-Supp		Y
97	5561	Disposition Quantity-Date		Y
98	5562	Disposition Quantity-Commodity		Y
99	5563	Disposition Quantity-Supplier		Y
100	5564	Disposition Amount-Date		Y
101	5565	Disposition Amount-Commodity		Y
102	5566	Disposition Amount-Supplier		Y
103	5567	Stock/Disposition Qty-Date		Y
104	5568	Stock/Disposition Qty-Cmdty		Y
105	5569	Stock/Disposition Qty-Supplier		Y
106	5581	In-Full Count-Supplier		Y
107	5582	In-Full Percent-Supplier		Y
108	5583	In-Spec Count-Supplier		Y
109	5584	In-Spec Percent-Supplier		Y
110	5585	On-Time Count-Supplier		Y
111	5586	On-Time Percent-Supplier		Y
112	5601	Price Variance Amt-Date		Y
113	5602	Price Variance Amt-Commodity		Y
114	5603	Price Variance Amt-Supplier		Y
115	5604	Price Variance Percent-Date		Y
116	5605	Price Variance Percent-Cmdty		Y
117	5606	Price Variance Percent-Supp		Y
118	5621	Sourcing Event Count-Date		Y
119	5622	Sourcing Event Count-Commodity		Y
120	5623	Sourcing Event Count-Supplier		Y
121	5624	Sourcing Award Amount-Date		Y
122	5625	Sourcing Award Amount-Cmdty		Y
123	5626	Sourcing Award Amount-Supplier		Y
124	8000	Metric Ids 8000 - 8999		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

9 columns | 910 | METRIC | STOCK UDC

TOPUDC 00 / MI (Metrics Identifier) stock values