	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

2 columns | 910 | VCID | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F80D322	UI Metric Group Detail	4	MD	VCID	Variant ID	Numeric	UDC	10	0
TOP80D: Plant Manager Dashboard
2	F80D304	Variant Definition	1	VD	VCID	Variant ID	Numeric	UDC	10	0

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

TOPUDC 00 / VC (Analytics Variant Code) stock values

	Value	Description	Hard Coded
1	0000000000	None Defined	Y
2	0000000001	DateCompanyBranchAddrProdItem	Y
3	0000000002	Date(Week)CompanyBranchAddr	Y
4	0000000003	DateCompanyBranchAddrProd	Y
5	0000000004	DateCompBranchProdItem(NoHier)	Y
6	0000000006	AddressBook	Y
7	0000000007	ItemAddressBook	Y
8	0000000008	AddressBookItem	Y
9	0000000010	Prod	Y
10	0000000011	DateCompanyBranchProd	Y
11	0000000012	Date(Week)CompanyBranch	Y
12	0000000013	DateCompanyBranchProdAddrItem	Y
13	0000000014	DateCompanyBranchProdItem	Y
14	0000000017	DateBranchAddressBook	Y
15	0000000018	DateBranchAddrProd	Y
16	0000000019	DateBranchProdItem(NoHier)	Y
17	0000000020	DateBranchProdAddrItem	Y
18	0000000021	DateBranchAddrProdItem	Y
19	0000000022	DateBranchProd	Y
20	0000000023	Date(Week)Branch	Y
21	0000000025	DateBranchProdItem	Y
22	0000000026	Date(Week)BranchProd	Y
23	0000000027	Date(Week)CompanyBranchProd	Y
24	0000000028	Date(Month)CompanyBranchProd	Y
25	0000000031	DATECOMPANYBUSINESSUNIT	Y
26	0000000032	DateCompanyAddressNumber	Y
27	0000000033	DateAddressNumberCompany	Y
28	0000000035	Brand	Y
29	0000000036	Customer	Y
30	0000000037	Item	Y
31	0000000041	DATE(DAY)COMPANYBUSINESSUNIT	Y
32	0000000051	DATE(DAY)COMPANYBUSINESSUNITRE	Y
33	0000000061	REASONCODEDATE(DAY)COMPANYBUSI	Y
34	0000000071	DATECOMPANYBUSINESSUNITREASONC	Y
35	0000000081	REASONCODEDATECOMPANYBUSINESSU	Y
36	0000000091	Date(Monthj)CompanyBusinesUnit	Y
37	0000000241	COMPANYBUSINESSUNITBRANDDATE	Y
38	0000000242	BrandDate	Y
39	0000000243	CompanyBranchPlantDate(Day)	Y
40	0000000244	BranchPlantDate	Y
41	0000000245	CompanyBusinessUnitProductDate	Y
42	0000000246	ProductDate	Y
43	0000000501	DateCoBranchProdFamItem	Y
44	0000000502	DateBranchProductFamilyItem	Y
45	0000000503	DateCommodityItem	Y
46	0000000504	ParentAddressProductFamilyItem	Y
47	0000000505	LineTypeCompanyBranchDate	Y
48	0000000506	LineTypeBranchDate	Y
49	0000000507	SupplierProductFamilyItem	Y

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

2 columns | 910 | VCID | STOCK UDC

TOPUDC 00 / VC (Analytics Variant Code) stock values