	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

142 columns | 812 | UM | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0911	Account Ledger	33	GL	UM	Unit of Measure	String	UDC	2	0
2	F4303	Log Master	19	PK	UM	Unit of Measure	String	UDC	2	0
3	F4303M	Log Models	17	PM	UM	Unit of Measure	String	UDC	2	0
TOP03: Accounts Receivable
4	F0311	Accounts Receivable Ledger	99	RP	UM	Unit of Measure	String	UDC	2	0
TOP03B: Enhanced Accounts Receivable
5	F03B11	Customer Ledger	97	RP	UM	Unit of Measure	String	UDC	2	0
6	F03B11P	Customer Ledger Purge File	97	RP	UM	Unit of Measure	String	UDC	2	0
7	F03B11Z1	Invoice Transactions - Batch File	113	VJ	UM	Unit of Measure	String	UDC	2	0
8	F03B11Z2	F03B11 Interoperability Table	110	SY	UM	Unit of Measure	String	UDC	2	0
9	F03B575	Auto Debit Invoice Select and Build	106	RD	UM	Unit of Measure	String	UDC	2	0
TOP04: Accounts Payable
10	F0411	Accounts Payable Ledger	77	RP	UM	Unit of Measure	String	UDC	2	0
11	F0411A	WF - As Of - Accounts Payable Ledger	77	RP	UM	Unit of Measure	String	UDC	2	0
12	F0411P	Purge - Accounts Payable Ledger	77	RP	UM	Unit of Measure	String	UDC	2	0
13	F0411Z1	Voucher Transactions - Batch File	95	VL	UM	Unit of Measure	String	UDC	2	0
14	F0411Z3	F0411 Interoperability Table	100	SZ	UM	Unit of Measure	String	UDC	2	0
TOP05: Time Accounting and HRM Base
15	F06106	Employee Pay Instructions	24	YM	UM	Unit of Measure	String	UDC	2	0
16	F0618	Employee Transaction History	27	YT	UM	Unit of Measure	String	UDC	2	0
17	F069116	Payroll Transaction Constants	16	YC	UM	Unit of Measure	String	UDC	2	0
18	F069162	Job Type/ Item Cross Reference File	5	JH	UM	Unit of Measure	String	UDC	2	0
TOP05T: Time Entry
19	F06116	Employee Transaction Detail File	27	YT	UM	Unit of Measure	String	UDC	2	0
20	F06116Z1	Employee Transactions - Batch File	44	VL	UM	Unit of Measure	String	UDC	2	0
21	F0623	Piecework History File	7	JL	UM	Unit of Measure	String	UDC	2	0
22	F06278	Retro Timecard Detail File	30	YT	UM	Unit of Measure	String	UDC	2	0
23	F06916	Piecework Item Master	3	JJ	UM	Unit of Measure	String	UDC	2	0
24	F069161	Item Master Cross Reference File	5	JE	UM	Unit of Measure	String	UDC	2	0
25	F06918	PF - Piece Rate File	9	JN	UM	Unit of Measure	String	UDC	2	0
TOP07: Payroll
26	F06156	Pay Check History Summary	12	YU	UM	Unit of Measure	String	UDC	2	0
27	F06350I	WF - Paycheck (Interims)	24	Y4	UM	Unit of Measure	String	UDC	2	0
28	F0716702	Employee Assignment Rates	9	EA	UM	Unit of Measure	String	UDC	2	0
29	F071861	Stub Detail Piece Rate History File	12	Y8	UM	Unit of Measure	String	UDC	2	0
30	F073521	Stub Detail Piece Rate File	12	Y2	UM	Unit of Measure	String	UDC	2	0
31	F07UI200	Timecard History Work File	30	TH	UM	Unit of Measure	String	UDC	2	0
TOP08: Human Resources
32	F08711	Employee Setup Tasks	8	ET	UM	Unit of Measure	String	UDC	2	0
TOP08AD: ADP Integration
33	F051371	ADP Employee DBA Instructions	29	AD	UM	Unit of Measure	String	UDC	2	0
34	F051375	ADP Payroll DBA Transaction Constants	18	AD	UM	Unit of Measure	String	UDC	2	0
TOP09: General Accounting
35	F0901	Account Master	13	GM	UM	Unit of Measure	String	UDC	2	0
36	F0909	Chart of Accounts - Reference File	6	AC	UM	Unit of Measure	String	UDC	2	0
37	F0911P	Purge - Account Ledger	33	GL	UM	Unit of Measure	String	UDC	2	0
38	F0911R	WF - Acct Ledger File for Reconciliation	30	GL	UM	Unit of Measure	String	UDC	2	0
39	F0911Z1	Journal Entry Transactions - Batch File	50	VN	UM	Unit of Measure	String	UDC	2	0
40	F0911Z4	F0911 Interoperability Table	55	SZ	UM	Unit of Measure	String	UDC	2	0
41	F0912	Cost Allocations/Flex Budgeting	34	RJ	UM	Unit of Measure	String	UDC	2	0
42	F09UI015	Indexed Computations Multi-Tiered Entries	33	GL	UM	Unit of Measure	String	UDC	2	0
TOP09E: Expense Reimbursment
43	F09E108	Policy Edit Rules	20	PR	UM	Unit of Measure	String	UDC	2	0
TOP12: Fixed Assets
44	F1208	Units of Production Schedule Master File	4	FP	UM	Unit of Measure	String	UDC	2	0
45	F1215	Specification Cross Reference	15	GV	UM	Unit of Measure	String	UDC	2	0
TOP13: Plant/Equipment Management
46	F13017	Equipment Parts List	16	PL	UM	Unit of Measure	String	UDC	2	0
47	F3111IGS	WO Parts for IGS Integration	8	IG	UM	Unit of Measure	String	UDC	2	0
TOP15: Property Management
48	F1503	Log Standards Master	18	NB	UM	Unit of Measure	String	UDC	2	0
49	F1514	Area Master	11	NW	UM	Unit of Measure	String	UDC	2	0
50	F15141	Gross Lease Occupied Areas	12	NC	UM	Unit of Measure	String	UDC	2	0
51	F1521	Log Detail Master	17	NB	UM	Unit of Measure	String	UDC	2	0
52	F1523	Log Standard Master	10	OG	UM	Unit of Measure	String	UDC	2	0
53	F15703	Legal Clause Amounts	7	NI	UM	Unit of Measure	String	UDC	2	0
TOP15L: Adv Real Estate Forecasting
54	F15L101	AREF Unit Master	24	UM	UM	Unit of Measure	String	UDC	2	0
55	F15L141	AREF Gross Lease Occupied Area	13	GL	UM	Unit of Measure	String	UDC	2	0
TOP17: Customer Service Management
56	F1721	Contract Detail	64	CD	UM	Unit of Measure	String	UDC	2	0
57	F3111Z2	Warranty Claim/Supplier Recovery processing	59	WP	UM	Unit of Measure	String	UDC	2	0
TOP17C: Call Management
58	F1755	Customer Call Master	178	ZA	UM	Unit of Measure	String	UDC	2	0
59	F1760	Time Entry	55	ZB	UM	Unit of Measure	String	UDC	2	0
TOP18: Resource Scheduling
60	F186602	Labor Rules Tag File	40	TF	UM	Unit of Measure	String	UDC	2	0
TOP30: Product Data Management
61	F300210	Lean Multi Level Bill of Material Header	15	EH	UM	Unit of Measure	String	UDC	2	0
62	F300211	Lean Multi Level Bill of Material Detail	23	ED	UM	Unit of Measure	String	UDC	2	0
63	F3002Z1	Bill of Material Transaction File	27	SZ	UM	Unit of Measure	String	UDC	2	0
64	F3007	Work Center Resource Units	5	WU	UM	Unit of Measure	String	UDC	2	0
65	F3016	Kanban Master	18	KM	UM	Unit of Measure	String	UDC	2	0
66	F30UI008	Bill of Material Comparison Work File	5	IJ	UM	Unit of Measure	String	UDC	2	0
TOP31: Shop Floor Control
67	F3111	Work Order Parts List	46	WM	UM	Unit of Measure	String	UDC	2	0
68	F3111S	Purge - Shop Floor Parts List	46	WM	UM	Unit of Measure	String	UDC	2	0
69	F3111Z1	Outbound Work Order Parts List	59	SZ	UM	Unit of Measure	String	UDC	2	0
70	F3118	Shortage Maintenance Master File	7	WN	UM	Unit of Measure	String	UDC	2	0
71	F31UI802	Accumulate Amounts by Account	8	WG	UM	Unit of Measure	String	UDC	2	0
72	F31UI803	Work File for Summarizing Journal Entries	8	SG	UM	Unit of Measure	String	UDC	2	0
TOP32: Configuration Management
73	F3283	Rules Table Detail	32	RD	UM	Unit of Measure	String	UDC	2	0
74	F3293	Assembly Inclusions Rules	25	KY	UM	Unit of Measure	String	UDC	2	0
TOP33: Capacity Planning
75	F3303	Capacity Resource Profile	9	CT	UM	Unit of Measure	String	UDC	2	0
76	F3311	Capacity Message File	8	CN	UM	Unit of Measure	String	UDC	2	0
77	F3312	Capacity Pegging	8	CW	UM	Unit of Measure	String	UDC	2	0
78	F3313	Capacity Load Table	4	CR	UM	Unit of Measure	String	UDC	2	0
TOP40: Inventory/OP Base
79	F3002	Bill of Material Master File	14	IX	UM	Unit of Measure	String	UDC	2	0
80	F3011	Bill of Materials Change File	14	IZ	UM	Unit of Measure	String	UDC	2	0
81	F3013	ECO Parts List Detail	18	CY	UM	Unit of Measure	String	UDC	2	0
82	F30UI004	Bill of Material Update Work File	25	WF	UM	Unit of Measure	String	UDC	2	0
83	F41002	Item Units of Measure Conversion Factors	3	UM	UM	Unit of Measure	String	UDC	2	0
84	F41003	Unit of Measure standard conversion	1	UC	UM	Unit of Measure	String	UDC	2	0
85	F49211	Sales Order Detail File - Tag File	11	UD	UM	Unit of Measure	String	UDC	2	0
86	F49211Z1	Sales Order Detail Tag Unedited Transaction File	24	S1	UM	Unit of Measure	String	UDC	2	0
87	F49219	Sales Order Detail - Tag History File	11	UD	UM	Unit of Measure	String	UDC	2	0
TOP40G: Grower Management
88	F40G031	Harvest Estimate Freeze Hdr	10	FH	UM	Unit of Measure	String	UDC	2	0
TOP41: Inventory Management
89	F41013	Unique Product Number	5	UN	UM	Unit of Measure	String	UDC	2	0
90	F4118	Container Deposit File	7	CN	UM	Unit of Measure	String	UDC	2	0
91	F41181	Container Transaction File	6	CM	UM	Unit of Measure	String	UDC	2	0
TOP42: Sales Management
92	F4020	Freight/Additional Charges Rate Information	27	AR	UM	Unit of Measure	String	UDC	2	0
93	F42800G1	Sales Update G Batch Detail Workfile	23	DG	UM	Unit of Measure	String	UDC	2	0
TOP42B: Sales Order Entry
94	F49299	S.O. Detail Tag Ledger File	11	UD	UM	Unit of Measure	String	UDC	2	0
TOP43: Procurement
95	F4305	Log Master	27	PL	UM	Unit of Measure	String	UDC	2	0
TOP45: Advanced Pricing
96	F4575	Ship and Debit History	51	AH	UM	Unit of Measure	String	UDC	2	0
97	F4575TMP	Ship and Debit History - Temp Table	51	AH	UM	Unit of Measure	String	UDC	2	0
98	F4576	Ship and Debit Claims	79	AC	UM	Unit of Measure	String	UDC	2	0
99	F4576TMP	Ship and Debit Claims- Temp Table	79	AC	UM	Unit of Measure	String	UDC	2	0
100	F4576Z1	Ship and Debit Claims Unedited Transaction Table	76	Z1	UM	Unit of Measure	String	UDC	2	0
TOP46: Warehouse Management
101	F4142	Warehouse Count Transactions	40	CT	UM	Unit of Measure	String	UDC	2	0
TOP47: Electronic Commerce
102	F47057	EDI Payment Order Remittance Advice - Outbound	88	D3	UM	Unit of Measure	String	UDC	2	0
103	F47057W	EDI Payment Order Remittance Advice - Work	88	D3	UM	Unit of Measure	String	UDC	2	0
TOP48S: Service Billing
104	F4812	Billing Detail Workfile	55	WD	UM	Unit of Measure	String	UDC	2	0
105	F4812H	Billing Workfile - History	55	WD	UM	Unit of Measure	String	UDC	2	0
106	F4812HS	Billing Workfile History Purged Save	55	WD	UM	Unit of Measure	String	UDC	2	0
107	F4822	Invoice Summary Work File	38	W4	UM	Unit of Measure	String	UDC	2	0
108	F4823	Voucher Summary	34	W0	UM	Unit of Measure	String	UDC	2	0
109	F48S0618	Payroll Reclassification Workfile	27	YT	UM	Unit of Measure	String	UDC	2	0
110	F48S910	Billing Detail Journal File	33	W2	UM	Unit of Measure	String	UDC	2	0
111	F48S911	Compressed Journal File	30	W3	UM	Unit of Measure	String	UDC	2	0
112	F48SUI01	Billing Detail Print Workfile	55	WD	UM	Unit of Measure	String	UDC	2	0
TOP49: Transportation Management
113	F4941	Shipment Routing Steps	35	RS	UM	Unit of Measure	String	UDC	2	0
114	F4960	Load Header	49	TM	UM	Unit of Measure	String	UDC	2	0
TOP51: Job Costing
115	F5109	Chart Type Master	7	GJ	UM	Unit of Measure	String	UDC	2	0
TOP52: Contract Billing
116	F5202	Contract Billing Line Detail	29	G6	UM	Unit of Measure	String	UDC	2	0
TOP53: Change Management
117	F5302	F5302 World Specs	16	DK	UM	Unit of Measure	String	UDC	2	0
TOP74U: United Kingdom Localizations
118	F74U03BT	Lease Master Alternative UOM Tag File - 15	6	PF	UM	Unit of Measure	String	UDC	2	0
TOP76A: Argentina
119	F76A0219	Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A	11	DL	UM	Unit of Measure	String	UDC	2	0
120	F76A021P	Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A	11	DL	UM	Unit of Measure	String	UDC	2	0
121	F76AUI21	Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 00	11	DL	UM	Unit of Measure	String	UDC	2	0
TOP76B: Brazil - Reporting System Only
122	F76B3010	Work Table for Item/Part List - 30	9	IP	UM	Unit of Measure	String	UDC	2	0
123	F76B60	Products Table - IN68 - 30	4	PR	UM	Unit of Measure	String	UDC	2	0
124	F76B61	Packing and Raw Material Table - IN68 - 30	6	IE	UM	Unit of Measure	String	UDC	2	0
TOP89: Conversion Programs
125	F07352T	Piece Rate Stub Detail Tag File	12	Y2	UM	Unit of Measure	String	UDC	2	0
TOPD3N: dcLINK (data collection) - DSI
126	FD3N1611	Pallet Tracking Table 2	5	PD	UM	Unit of Measure	String	UDC	2	0
127	FD3N4041	Pallet Tracking Table 6	8	CD	UM	Unit of Measure	String	UDC	2	0
128	FD3N421P	Pallet Tracking Table 3	8	SH	UM	Unit of Measure	String	UDC	2	0
TOPF30L: DFM Line Design
129	FF30L002	DFM Bill of Material Master	10	DH	UM	Unit of Measure	String	UDC	2	0
130	FF30L116	Components Consumed	10	CC	UM	Unit of Measure	String	UDC	2	0
131	FF30L512	DFM Item Units of Measure Conversion Factors	4	UM	UM	Unit of Measure	String	UDC	2	0
132	FF30L513	DFM Units of Measure Standard Conversion	1	UC	UM	Unit of Measure	String	UDC	2	0
133	FF30L801	Sales Order Master	9	SD	UM	Unit of Measure	String	UDC	2	0
TOPF31: Lean Transactions
134	FF31010	Production Master File	27	EH	UM	Unit of Measure	String	UDC	2	0
135	FF31011	TransactionID Master File	10	EH	UM	Unit of Measure	String	UDC	2	0
136	FF31011S	Purge - TransactionID Master File	10	ER	UM	Unit of Measure	String	UDC	2	0
137	FF31111	Lean Transaction Parts List	15	PL	UM	Unit of Measure	String	UDC	2	0
138	FF31111S	Purge - Lean Transaction Parts List	15	PR	UM	Unit of Measure	String	UDC	2	0
139	FF31112	Routing Transaction Table	60	EH	UM	Unit of Measure	String	UDC	2	0
140	FF31112S	Purge - Routing Transaction Table	60	ET	UM	Unit of Measure	String	UDC	2	0
TOPF34S: DFM Production Sequencing
141	FF34S002	Daily Plan	20	DP	UM	Unit of Measure	String	UDC	2	0
142	FF34S01W	DFM Plan Demand Work File	12	PD	UM	Unit of Measure	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 00 / UM (Unit of Measure) stock values

	Value	Description	Special Handling Code	Hard Coded
1	%	Percent		N
2	12	Twelve Pack		N
3	AS	Annual Salary(rounded)xmult.		N
4	AT	Annual Salary(truncated)xmult.		N
5	BA	Bar Absolute (Pressure)		N
6	BC	Bag		N
7	BG	Bar Gauge (Pressure)		N
8	BK	Bucket		N
9	BL	Barrels		N
10	BT	Bottles		N
11	BU	Bushel		N
12	BX	Box		N
13	CA	Case		N
14	CC	Cubic Centimeter	V	N
15	CF	Hundred Feet		N
16	CI	Cubic Inches	V	N
17	CL	Centiliters	V	N
18	CM	Centimeters		N
19	CN	Can		N
20	CR	Carton		N
21	CS	Hundred Square Feet		N
22	CT	Carat		N
23	CW	Hundredweight	W	N
24	CY	Cubic Yard	V	N
25	DC	Decimeters		N
26	DL	Deciliter		N
27	DR	drums		N
28	DW	Penny Weight
29	DY	Days		N
30	DZ	Dozen		N
31	EA	Each		N
32	FC	Cubic Feet	V	N
33	FF	Feet/Inches/16th		N
34	FO	Fluid Ounce		Y
35	FT	Feet		N
36	G1	100 Gallons		N
37	GA	Gallons	V	N
38	GM	Grams	W	N
39	GP	Potent Gallons	VP	N
40	GR	Gross		N
41	H1	Half Hour Calculations		N
42	HA	Average Hourly Rate		N
43	HE	Head Count		N
44	HH	Hours X Hours Worked		N
45	HL	Hectoliter	V	N
46	HQ	Hours per period (zero $)		N
47	HR	Hour		N
48	HT	Hectare		N
49	HZ	Hours x Hrs worked (zero $)		N
50	IC	Cubic Inches	V	N
51	IG	Imperial Gallons	V	N
52	IN	Inches		N
53	JT	Joints		N
54	KG	Kilograms	W	N
55	KL	Kiloliter .		N
56	KM	Kilometers		N
57	KT	Karat		N
58	L3	Pounds per square inch		N
59	LB	Pounds	W	N
60	LC	Cubic Liters	V	N
61	LF	Linear Feet		N
62	LG	Log		N
63	LP	Potent Liters	VP	N
64	LS	Lump Sum		N
65	LT	Liters	V	N
66	M3	Cubic Meters	V	N
67	MF	Thousand Feet		N
68	MG	Milligrams	W	N
69	MH	Man Hour		N
70	MI	Miles		N
71	MK	Micrograms	W	N
72	ML	Milliliter	V	N
73	MM	Millimeters .		N
74	MN	Minutes		Y
75	MO	Months		N
76	MP	Thousand Pieces		N
77	MS	Thousand Square Feet		N
78	MT	Meters		N
79	MW	Thousand Pounds	W	N
80	OP	Potent Ounces	P	N
81	OT	Troy Ounces		N
82	OZ	Ounces	W	N
83	PC	Pieces		N
84	PD	Pad		N
85	PL	Pallet		N
86	PR	Pair		N
87	PT	Pint	V	N
88	QT	Quart	V	N
89	RD	Rental Deposit		N
90	RL	Roll		N
91	RM	Ream		N
92	RT	$1000s of Salary		N
93	SC	Square Centimeters		N
94	SE	Seconds		Y
95	SF	Square Feet		N
96	SI	Square Inches		N
97	SK	Skein		N
98	SL	Sleeve		N
99	SM	Square Meters		N
100	SP	Spaces
101	SX	Six Pack		N
102	SY	Square Yard		N
103	TK	Tank		N
104	TL	Long Ton (English)	W	N
105	TM	Metric Ton	W	N
106	TN	Ton (U.S.)	W	N
107	TS	Short Ton (U.S.)	W	N
108	UN	Units		N
109	WK	Weeks		N
110	WU	Weld Units		N
111	XL	Excess Life		N
112	YD	Yards		N
113	YR	Year		N
114	Z	Set (3-PW)		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

142 columns | 812 | UM | STOCK UDC

TOPUDC 00 / UM (Unit of Measure) stock values