	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

37 columns | 812 | 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
TOP31B: Blend Management
4	F31B23	GL Category Cost Group Cross Reference	1	CR	GLPT	Category - G/L	String	UDC	4	0
5	F31B66	Blend Transactions	17	BT	GLPT	Category - G/L	String	UDC	4	0
TOP38: Agreement Management
6	F38111	Agreements Transaction Ledger	58	DZ	GLPT	Category - G/L	String	UDC	4	0
TOP39: Advanced Stock Valuation
7	F39041	Valuation Category Master	5	VC	GLPT	Category - G/L	String	UDC	4	0
8	F39061	Valuation Period Table	23	SO	GLPT	Category - G/L	String	UDC	4	0
9	F390619	Historical Valuation Period Detail Table	23	SO	GLPT	Category - G/L	String	UDC	4	0
TOP40: Inventory/OP Base
10	F4095	Distribution/Manufacturing - AAI Values	5	ML	GLPT	Category - G/L	String	UDC	4	0
11	F41112	Item ASOF File	10	IN	GLPT	Category - G/L	String	UDC	4	0
TOP41: Inventory Management
12	F4101	Item Master	55	IM	GLPT	Category - G/L	String	UDC	4	0
13	F4101A	Item File	35	IM	GLPT	Category - G/L	String	UDC	4	0
14	F4101Z1	F4101 Item Master Unedited Transaction Table	70	SZ	GLPT	Category - G/L	String	UDC	4	0
15	F4102	Item Branch File	31	IB	GLPT	Category - G/L	String	UDC	4	0
16	F41021	Item Location File	6	LI	GLPT	Category - G/L	String	UDC	4	0
17	F41021WF	F41021 Transaction Workfile	11	LW	GLPT	Category - G/L	String	UDC	4	0
18	F41021Z1	Item Location Unedited Transaction File	19	SZ	GLPT	Category - G/L	String	UDC	4	0
19	F4111	Item Ledger File	28	IL	GLPT	Category - G/L	String	UDC	4	0
20	F4141	Cycle Count Transaction File	15	PJ	GLPT	Category - G/L	String	UDC	4	0
21	F4141Z1	F4141 Cycle Count Unedited Transaction Table	28	SZ	GLPT	Category - G/L	String	UDC	4	0
22	F41UI001	Inventory Transactions Detail File	26	IT	GLPT	Category - G/L	String	UDC	4	0
TOP42B: Sales Order Entry
23	F42420	Audit Log Transaction	65	AL	GLPT	Category - G/L	String	UDC	4	0
TOP43: Procurement
24	F4095TEM	F4095 Temporary Table	5	ML	GLPT	Category - G/L	String	UDC	4	0
25	F41291	Item Cost Components	16	IG	GLPT	Category - G/L	String	UDC	4	0
26	F43091	Receipt Routing Master File	9	PP	GLPT	Category - G/L	String	UDC	4	0
27	F43092	Purchase Order Receipt Routing File	16	PX	GLPT	Category - G/L	String	UDC	4	0
28	F43092Z1	Receipt Routing Unedited Transaction Table	29	SZ	GLPT	Category - G/L	String	UDC	4	0
TOP43Q: Strategic Sourcing
29	F43Q11	Event Detail	11	ED	GLPT	Category - G/L	String	UDC	4	0
TOP44H: Homebuilder Management
30	F44H73W1	Lot Start - P.O. / Committment Generation Work File	62	CG	GLPT	Category - G/L	String	UDC	4	0
TOP47: Electronic Commerce
31	F47122	EDI Product Activity Data Detail - Inbound	56	MJ	GLPT	Category - G/L	String	UDC	4	0
32	F47127	EDI Product Activity Data Detail - Outbound	56	MJ	GLPT	Category - G/L	String	UDC	4	0
TOP55: Reserved for Clients
33	F74H105S	Slovakian Invoice Accounting Summary	4	AS	GLPT	Category - G/L	String	UDC	4	0
TOP76A: Argentina
34	F76A394	Adjustments - 76A	10	C4	GLPT	Category - G/L	String	UDC	4	0
TOP76H: Chile
35	F76H611	Actual Item Ledger File - CHI - 41 - 76H	29	AL	GLPT	Category - G/L	String	UDC	4	0
36	F76H6112	Actual Item ASOF File - CHI - 41 - 76H	10	AN	GLPT	Category - G/L	String	UDC	4	0
37	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	BF10	Brokerage Fees / IN10	Y
2	BF13	Brokerage Fees / IN13	Y
3	BF20	Brokerage Fees / IN20	Y
4	BF30	Brokerage Fees / IN30	Y
5	BF40	Brokerage Fees / IN40	Y
6	BF50	Brokerage Fees / IN50	Y
7	C001	Company 001	Y
8	C002	Company 002	Y
9	FT10	Freight Exp. / IN10	Y
10	FT13	Freight Exp. / IN13	Y
11	FT20	Freight Exp. / IN20	Y
12	FT30	Freight Exp. / IN30	Y
13	FT40	Freight Exp. / IN40	Y
14	FT50	Freight Exp. / IN50	Y
15	ID10	Import Duty / IN10	Y
16	ID13	Import Duty / IN13	Y
17	ID20	Import Duty / IN20	Y
18	ID30	Import Duty / IN30	Y
19	ID40	Import Duty / IN40	Y
20	ID50	Import Duty / IN50	Y
21	IN10	Purchased Raw Material	Y
22	IN40	Co- / By- Products	Y
23	IN50	Purchased Finished Goods	Y
24	MB10	Material Burden / IN10	Y
25	MB13	Material Burden / IN13	Y
26	MB20	Material Burden / IN20	Y
27	MB30	Material Burden / IN30	Y
28	MB40	Material Burden / IN40	Y
29	MB50	Material Burden / IN50	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

37 columns | 812 | GLPT | STOCK UDC

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