	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

43 columns | 920 | GLPT | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP17: Customer Service Management
1	F1729	Service Contract Service Package	5	SP	GLPT	Category - G/L	String	UDC	4	0
TOP31: Shop Floor Control
2	F31UI427	Labor Variance User Index	8	W1	GLPT	Category - G/L	String	UDC	4	0
3	F31UI804	Exception Report Work FIle	5	WR	GLPT	Category - G/L	String	UDC	4	0
TOP31A: Manufacturing Accounting
4	F30UI003	WIP Revaluation Work File	15	WR	GLPT	Category - G/L	String	UDC	4	0
TOP31B: Blend Management
5	F31B23	GL Category Cost Group Cross Reference	1	CR	GLPT	Category - G/L	String	UDC	4	0
6	F31B66	Blend Transactions	17	BT	GLPT	Category - G/L	String	UDC	4	0
TOP38: Agreement Management
7	F38111	Agreements Transaction Ledger	58	DZ	GLPT	Category - G/L	String	UDC	4	0
TOP39: Advanced Stock Valuation
8	F39041	Valuation Category Master	5	VC	GLPT	Category - G/L	String	UDC	4	0
9	F39061	Valuation Period Table	23	SO	GLPT	Category - G/L	String	UDC	4	0
10	F390619	Historical Valuation Period Detail Table	23	SO	GLPT	Category - G/L	String	UDC	4	0
TOP40: Inventory/OP Base
11	F4095	Distribution/Manufacturing - AAI Values	5	ML	GLPT	Category - G/L	String	UDC	4	0
12	F41112	Item ASOF File	10	IN	GLPT	Category - G/L	String	UDC	4	0
TOP41: Inventory Management
13	F4101	Item Master	55	IM	GLPT	Category - G/L	String	UDC	4	0
14	F4101A	Item File	35	IM	GLPT	Category - G/L	String	UDC	4	0
15	F4101Z1	F4101 Item Master Unedited Transaction Table	70	SZ	GLPT	Category - G/L	String	UDC	4	0
16	F4102	Item Branch File	31	IB	GLPT	Category - G/L	String	UDC	4	0
17	F41021	Item Location File	6	LI	GLPT	Category - G/L	String	UDC	4	0
18	F41021WF	F41021 Transaction Workfile	11	LW	GLPT	Category - G/L	String	UDC	4	0
19	F41021Z1	Item Location Unedited Transaction File	19	SZ	GLPT	Category - G/L	String	UDC	4	0
20	F41025	Consignment Sites (FUTURE)	6	CS	GLPT	Category - G/L	String	UDC	4	0
21	F4111	Item Ledger File	28	IL	GLPT	Category - G/L	String	UDC	4	0
22	F4141	Cycle Count Transaction File	15	PJ	GLPT	Category - G/L	String	UDC	4	0
23	F4141Z1	F4141 Cycle Count Unedited Transaction Table	28	SZ	GLPT	Category - G/L	String	UDC	4	0
24	F41UI001	Inventory Transactions Detail File	26	IT	GLPT	Category - G/L	String	UDC	4	0
TOP41F: Apparel Management
25	FCW09	Item Revisions Work File	9	WR	GLPT	Category - G/L	String	UDC	4	0
26	FCW10	Item Branch Work File	5	WB	GLPT	Category - G/L	String	UDC	4	0
27	FCW13	Item Location Work File	7	WL	GLPT	Category - G/L	String	UDC	4	0
TOP42B: Sales Order Entry
28	F42420	Audit Log Transaction	65	AL	GLPT	Category - G/L	String	UDC	4	0
TOP43: Procurement
29	F4095TEM	F4095 Temporary Table	5	ML	GLPT	Category - G/L	String	UDC	4	0
30	F41291	Item Cost Components	16	IG	GLPT	Category - G/L	String	UDC	4	0
31	F43091	Receipt Routing Master File	9	PP	GLPT	Category - G/L	String	UDC	4	0
32	F43092	Purchase Order Receipt Routing File	16	PX	GLPT	Category - G/L	String	UDC	4	0
33	F43092Z1	Receipt Routing Unedited Transaction Table	29	SZ	GLPT	Category - G/L	String	UDC	4	0
34	F43147	Freight Distribution Workfile	17	FD	GLPT	Category - G/L	String	UDC	4	0
TOP43Q: Strategic Sourcing
35	F43Q11	Event Detail	11	ED	GLPT	Category - G/L	String	UDC	4	0
TOP44H: Homebuilder Management
36	F44H73W1	Lot Start - P.O. / Committment Generation Work File	62	CG	GLPT	Category - G/L	String	UDC	4	0
TOP47: Electronic Commerce
37	F47122	EDI Product Activity Data Detail - Inbound	56	MJ	GLPT	Category - G/L	String	UDC	4	0
38	F47127	EDI Product Activity Data Detail - Outbound	56	MJ	GLPT	Category - G/L	String	UDC	4	0
TOP75I: India
39	F75I791	Item/Supplier Cost Components - IND - 43B	17	IS	GLPT	Category - G/L	String	UDC	4	0
TOP76A: Argentina
40	F76A394	Adjustments - 76A	10	C4	GLPT	Category - G/L	String	UDC	4	0
TOP76H: Chile
41	F76H611	Actual Item Ledger File - CHI - 41 - 76H	29	AL	GLPT	Category - G/L	String	UDC	4	0
42	F76H6112	Actual Item ASOF File - CHI - 41 - 76H	10	AN	GLPT	Category - G/L	String	UDC	4	0
43	F76H6205	Item Replacement Cost - CHI - 41	9	IR	GLPT	Category - G/L	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

43 columns | 920 | GLPT | STOCK UDC

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