	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

15 columns | 920 | GLCNC | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP17: Customer Service Management
1	F1721	Contract Detail	26	CD	GLCNC	Category - G/L Non-Covered	String	UDC	4	0
2	F1725	Service Contract Services	3	ST	GLCNC	Category - G/L Non-Covered	String	UDC	4	0
3	F3111Z2	Warranty Claim/Supplier Recovery processing	119	WP	GLCNC	Category - G/L Non-Covered	String	UDC	4	0
4	F3112Z2	Warranty Claim/Supplier Recovery processing	138	WL	GLCNC	Category - G/L Non-Covered	String	UDC	4	0
5	F31171	Parts List - Extension	21	WS	GLCNC	Category - G/L Non-Covered	String	UDC	4	0
6	F31171S	Purge Parts List - Extension	21	WS	GLCNC	Category - G/L Non-Covered	String	UDC	4	0
7	F31172	Routing Instructions - Extension	26	WS	GLCNC	Category - G/L Non-Covered	String	UDC	4	0
8	F31172S	Purge Routing Instructions - Extension	26	WS	GLCNC	Category - G/L Non-Covered	String	UDC	4	0
9	F4801TZ2	Warranty Claim/Supplier Recovery processing	79	WQ	GLCNC	Category - G/L Non-Covered	String	UDC	4	0
TOP17C: Call Management
10	F1755	Case Master	95	ZA	GLCNC	Category - G/L Non-Covered	String	UDC	4	0
11	F1760	Time Entry	50	ZB	GLCNC	Category - G/L Non-Covered	String	UDC	4	0
TOP48: Work Order Processing
12	F4801ST	Purge - Work Order Master Tag File	66	WA	GLCNC	Category - G/L Non-Covered	String	UDC	4	0
13	F4801T	Work Order Master Tag File	66	WA	GLCNC	Category - G/L Non-Covered	String	UDC	4	0
14	F4817	Service Order Extension	20	SR	GLCNC	Category - G/L Non-Covered	String	UDC	4	0
15	F48710	Work Order Mass Update Template Table	111	WT	GLCNC	Category - G/L Non-Covered	String	UDC	4	0

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

TOPUDC 41 / 9 (G/L Posting Category) stock values

	Value	Description	Hard Coded
1		Blank G/L Posting Category	N
2	AD20	Accrued Discounts	N
3	AP52	Assembled Products-Personal Co	N
4	BF10	Brokerage Fees / IN10	Y
5	BF13	Brokerage Fees / IN13	Y
6	BF20	Brokerage Fees / IN20	Y
7	BF30	Brokerage Fees / IN30	Y
8	BF40	Brokerage Fees / IN40	Y
9	BF50	Brokerage Fees / IN50	Y
10	BL01	Blend Mat'l Types and WT	N
11	BL02	Blend Consumables	N
12	BL03	Blend Additives	N
13	BL04	Blend EURs	N
14	BL05	Blend Bill of Lading	N
15	BL06	Blend Product	N
16	C001	Company 001	Y
17	C002	Company 002	Y
18	CS10	Warranty Revenue	N
19	CS20	Billable Non-warranty Rev.	N
20	CS30	Service Inventory	N
21	CS50	Depot Covered	N
22	CS55	Depot Non-Covered	N
23	CS60	Onsite Covered	N
24	CS65	Onsite Non-Covered	N
25	CS70	Advanced Exchange Covered	N
26	CS75	Advanced Exch. Non-Covered	N
27	EX60	Expenses/FT60	N
28	FG10	Finished Goods-Bikes	N
29	FG52	Finished Goods-Personal Comput	N
30	FR60	Freight/FT60	N
31	FT10	Freight Exp. / IN10	Y
32	FT13	Freight Exp. / IN13	Y
33	FT20	Freight Exp. / IN20	Y
34	FT30	Freight Exp. / IN30	Y
35	FT40	Freight Exp. / IN40	Y
36	FT50	Freight Exp. / IN50	Y
37	FT60	Freight	N
38	GR01	Grower Spray	N
39	GR02	Grower Weigh Tag	N
40	GR03	Grower Additives	N
41	GR04	Grower Product	N
42	HFE	No Description	N
43	HWF	No Description	N
44	IC30	ICMS Tax / IN30	N
45	ID10	Import Duty / IN10	Y
46	ID13	Import Duty / IN13	Y
47	ID20	Import Duty / IN20	Y
48	ID30	Import Duty / IN30	Y
49	ID40	Import Duty / IN40	Y
50	ID50	Import Duty / IN50	Y
51	IM30	ICMS Rec/IN30	N
52	IN10	Purchased Raw Material	Y
53	IN13	MRO Supplies	Y
54	IN20	Manufactured Subassemblies	Y
55	IN30	Manufactured Finished Goods	Y
56	IN40	Co- / By- Products	Y
57	IN50	Purchased Finished Goods	Y
58	IN99	Inventory	N
59	IP30	IPI Tax / IN30	N
60	IR30	IPI Rec/IN30	N
61	JC30	EPM with Job Cost	N
62	LC21	Harbor Fees	N
63	LC24	Brokerage Fees	N
64	LC26	Import Duty	N
65	LC28	Landed Cost Other	N
66	LCBR	Landed Costs	N
67	MB10	Material Burden / IN10	Y
68	MB13	Material Burden / IN13	Y
69	MB20	Material Burden / IN20	Y
70	MB30	Material Burden / IN30	Y
71	MB40	Material Burden / IN40	Y
72	MB50	Material Burden / IN50	Y
73	MP10	Manufactured Parts - Bikes	N
74	MP52	Manufactured Parts-Personal Co	N
75	NS20	Non-Stock Inventory	N
76	NS22	Non-Stock Inventory	N
77	NS40	Non-Inventory	N
78	NS42	Miscellaneous Transactions	N
79	NS43	Other Matierals	N
80	NS45	Office Supplies	N
81	NS47	Other Supplies	N
82	PP52	Purchased Parts-Personal Compu	N
83	RE30	Repasse/IN30	N
84	RR10	Receipt Route - In Transit	N
85	RR20	Receipt Route - Sea	N
86	RR30	Receipt Route - Customs	N
87	RR40	Receipt Route - Dock	N
88	RR50	Receipt Route - Inspection	N
89	SB30	Subs.Rec/IN30	N
90	SE60	Insurance/FT60	N
91	ST30	ICMS Subs / IN30	N
92	TD30	Trade Disc/IN30	N
93	TXTX	Tax	Y
94	VATB	Belgium VAT Recover/Payable	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

15 columns | 920 | GLCNC | STOCK UDC

TOPUDC 41 / 9 (G/L Posting Category) stock values