	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 | 920 | LEDG | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP16: Profit Management (EPS)
1	F1642	Rate Master Header File	9	RH	LEDG	Cost Method	String	UDC	2	0
TOP17: Customer Service Management
2	F4801TZ2	Warranty Claim/Supplier Recovery processing	20	WQ	LEDG	Cost Method	String	UDC	2	0
TOP30: Product Data Management
3	F30008	Work Center Rates File	2	IW	LEDG	Cost Method	String	UDC	2	0
TOP30A: Product Costing
4	F300261	Item Cost Component Detail	7	IE	LEDG	Cost Method	String	UDC	2	0
TOP31A: Manufacturing Accounting
5	F30UI003	WIP Revaluation Work File	16	WR	LEDG	Cost Method	String	UDC	2	0
TOP40: Inventory/OP Base
6	F30026	Item Cost Component Add-Ons	7	IE	LEDG	Cost Method	String	UDC	2	0
7	F40UI74	Price Adjustment History Work File	24	AW	LEDG	Cost Method	String	UDC	2	0
8	F4106	Item Base Price File	19	BP	LEDG	Cost Method	String	UDC	2	0
TOP41: Inventory Management
9	F4105	Item Cost File	8	CO	LEDG	Cost Method	String	UDC	2	0
10	F4105Z1	Unedited Transaction Table - Item Cost	21	SZ	LEDG	Cost Method	String	UDC	2	0
11	F41UI001	Inventory Transactions Detail File	164	IT	LEDG	Cost Method	String	UDC	2	0
TOP41F: Apparel Management
12	FCW11	Item Base Price File Work File	18	WP	LEDG	Cost Method	String	UDC	2	0
13	FCW12	Item Cost File Work File	6	WC	LEDG	Cost Method	String	UDC	2	0
14	FCW85	Item Cost Component Add Ons Work File	8	IE	LEDG	Cost Method	String	UDC	2	0
TOP42: Sales Management
15	F4074	Price Adjustment Ledger File	18	AL	LEDG	Cost Method	String	UDC	2	0
TOP43: Procurement
16	F43121Z	Receiver workfile	30	PW	LEDG	Cost Method	String	UDC	2	0
TOP45: Advanced Pricing
17	F4072	Price Adjustment Detail	15	AD	LEDG	Cost Method	String	UDC	2	0
18	F4072P	Price Adjustment Detail Purge	16	AD	LEDG	Cost Method	String	UDC	2	0
19	F4072W	Price Adjustment Detail Work File	15	AD	LEDG	Cost Method	String	UDC	2	0
20	F4511W	Pricing Structure View	52	AP	LEDG	Cost Method	String	UDC	2	0
21	F4574	Key Reference Table	61	KR	LEDG	Cost Method	String	UDC	2	0
22	F4575	Ship and Debit History	23	AH	LEDG	Cost Method	String	UDC	2	0
23	F4575TMP	Ship and Debit History - Temp Table	23	AH	LEDG	Cost Method	String	UDC	2	0
24	F4576Z1	Ship and Debit Claims Unedited Transaction Table	109	Z1	LEDG	Cost Method	String	UDC	2	0
TOP48: Work Order Processing
25	F4801ST	Purge - Work Order Master Tag File	7	WA	LEDG	Cost Method	String	UDC	2	0
26	F4801T	Work Order Master Tag File	7	WA	LEDG	Cost Method	String	UDC	2	0
27	F4801Z1	Outbound Work Order Header	154	SY	LEDG	Cost Method	String	UDC	2	0
TOP76H: Chile
28	F76H6001	Actual Cost Process Header - CHI - 41 - 76H	10	PH	LEDG	Cost Method	String	UDC	2	0
29	F76H6002	Indirect Costs Selection EPS F1602 - CHI - 41 - 76H	20	I1	LEDG	Cost Method	String	UDC	2	0
30	F76H6003	Indirect Costs Selection EPS F1642 - CHI - 41 - 76H	22	I2	LEDG	Cost Method	String	UDC	2	0
31	F76H6004	Item Cost Component WF - CHI - 41 - 76H	8	IC	LEDG	Cost Method	String	UDC	2	0
32	F76H6105	Item Actual Cost File - CHI - 41 - 76H	8	AC	LEDG	Cost Method	String	UDC	2	0
33	F76H6205	Item Replacement Cost - CHI - 41	8	IR	LEDG	Cost Method	String	UDC	2	0
TOP89: Conversion Programs
34	F4072TEM	Price Adjustment Detail - Temp for Upgrade	17	AD	LEDG	Cost Method	String	UDC	2	0
TOPF31: Lean Transactions
35	FF31010	Production Master File	38	EH	LEDG	Cost Method	String	UDC	2	0
36	FF31011	TransactionID Master File	34	EH	LEDG	Cost Method	String	UDC	2	0
37	FF31011S	Purge - TransactionID Master File	34	ER	LEDG	Cost Method	String	UDC	2	0

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

TOPUDC 40 / CM (Cost Method) stock values

	Value	Description	Special Handling Code	Hard Coded
1		01 - 19 Reserved for PS		Y
2	01	Last In		Y
3	02	Weighted Average		Y
4	03	Memo		Y
5	04	Current		Y
6	05	Future		Y
7	06	Lot		Y
8	07	Standard		Y
9	08	Purchasing-Base Cost No Adds		Y
10	09	Manufacturing Last Cost	N	Y
11	20	Historical Average		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

37 columns | 920 | LEDG | STOCK UDC

TOPUDC 40 / CM (Cost Method) stock values