	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

165 columns | 920 | MMCU

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0007	Workday Calendar	2	CZ	MMCU	Branch	String	Generic Edit	12	0
TOP04: Accounts Payable
2	F09UI005	Tax Offsets User Index	29	GL	MMCU	Branch	String	Generic Edit	12	0
TOP12: Fixed Assets
3	F1217	Equipment Master Extension	4	WR	MMCU	Branch	String	Generic Edit	12	0
4	F1217P	Equipment Master Extension Purge Table	4	WR	MMCU	Branch	String	Generic Edit	12	0
5	F1217Z1	Unedited Equipment Tag Transactions	17	WR	MMCU	Branch	String	Generic Edit	12	0
6	F1217Z2	Unedited Equipment Tag Transactions	17	WR	MMCU	Branch	String	Generic Edit	12	0
TOP13: Plant/Equipment Management
7	F13411	PM Projections	12	RX	MMCU	Branch	String	Generic Edit	12	0
TOP13E: Equipment Cost Analysis
8	F1381	Equipment Analysis Filters	13	EF	MMCU	Branch	String	Generic Edit	12	0
TOP13R: Resource Assignments
9	F48301	Resource Assignments Constants	2	RX	MMCU	Branch	String	Generic Edit	12	0
10	F48307	Resource Working Hours	2	RH	MMCU	Branch	String	Generic Edit	12	0
11	F48310	Resource Master	5	RM	MMCU	Branch	String	Generic Edit	12	0
TOP17: Customer Service Management
12	F17113	Assessor Defaults	4	AD	MMCU	Branch	String	Generic Edit	12	0
13	F1721	Contract Detail	46	CD	MMCU	Branch	String	Generic Edit	12	0
14	F1775	Claim Temporary Table	27	TC	MMCU	Branch	String	Generic Edit	12	0
15	F1791	Entitlement Dates	4	EM	MMCU	Branch	String	Generic Edit	12	0
16	F3112Z2	Warranty Claim/Supplier Recovery processing	21	WL	MMCU	Branch	String	Generic Edit	12	0
17	F41171	Item Branch Master - Service/Warranty Extension	2	PB	MMCU	Branch	String	Generic Edit	12	0
18	F4801Z2	Warranty Claim/Supplier Recovery processing	34	WS	MMCU	Branch	String	Generic Edit	12	0
19	F48164	Failure Analysis Detail	40	KB	MMCU	Branch	String	Generic Edit	12	0
TOP17C: Call Management
20	F17111	Base Warranty Defaults	4	BC	MMCU	Branch	String	Generic Edit	12	0
21	F1713	ECOs Applied to Equipment	7	EE	MMCU	Branch	String	Generic Edit	12	0
22	F1755	Case Master	72	ZA	MMCU	Branch	String	Generic Edit	12	0
23	F1790	Product Family/Model Master	11	PM	MMCU	Branch	String	Generic Edit	12	0
TOP30: Product Data Management
24	F0007Z1	Work Day Calendar Transaction File	17	SZ	MMCU	Branch	String	Generic Edit	12	0
25	F30006	Work Center Master File	3	IW	MMCU	Branch	String	Generic Edit	12	0
26	F30006Z1	Work Center Transaction File	16	SZ	MMCU	Branch	String	Generic Edit	12	0
27	F30008	Work Center Rates File	25	IW	MMCU	Branch	String	Generic Edit	12	0
28	F300210	Lean Multi Level Bill of Material Header	4	EH	MMCU	Branch	String	Generic Edit	12	0
29	F300211	Lean Multi Level Bill of Material Detail	8	ED	MMCU	Branch	String	Generic Edit	12	0
30	F3002Z1	Bill of Material Transaction File	18	SZ	MMCU	Branch	String	Generic Edit	12	0
31	F300311	Lean Multi-Level Routing Detail File	4	EH	MMCU	Branch	String	Generic Edit	12	0
32	F3003T	Routing Tag File - not used in B9, obsolete in B10	3	IR	MMCU	Branch	String	Generic Edit	12	0
33	F3003Z1	Routing Transactions File	18	SZ	MMCU	Branch	String	Generic Edit	12	0
34	F3007	Work Center Resource Units	4	WU	MMCU	Branch	String	Generic Edit	12	0
35	F3009T	Manufacturing Constants Tag File - Needed for upgrade	1	IA	MMCU	Branch	String	Generic Edit	12	0
36	F3016	Kanban Master	12	KM	MMCU	Branch	String	Generic Edit	12	0
37	F30UI008	Bill of Material Comparison Work File	6	IJ	MMCU	Branch	String	Generic Edit	12	0
38	F30UI014	BOM Header Work File for BI	2	BH	MMCU	Branch	String	Generic Edit	12	0
39	F30UI015	BOM Item Fact Work File for BI	3	BD	MMCU	Branch	String	Generic Edit	12	0
40	F30UI016	BOM Explosion Work File for BI	9	BE	MMCU	Branch	String	Generic Edit	12	0
TOP30A: Product Costing
41	F300261	Item Cost Component Detail	4	IE	MMCU	Branch	String	Generic Edit	12	0
42	F30UI012	Work File for Parent Child	6	PC	MMCU	Branch	String	Generic Edit	12	0
TOP31: Shop Floor Control
43	F3102	Production Cost	33	IG	MMCU	Branch	String	Generic Edit	12	0
44	F3102S	Purge - Production Cost	33	IG	MMCU	Branch	String	Generic Edit	12	0
45	F3102WF	Production Cost Work File	33	IG	MMCU	Branch	String	Generic Edit	12	0
46	F3109	Line/Item Relationship Master	4	IP	MMCU	Branch	String	Generic Edit	12	0
47	F31091	Schedule Quantity Detail	4	IQ	MMCU	Branch	String	Generic Edit	12	0
48	F31091S	Schedule Quantity Detail Purge	4	IQ	MMCU	Branch	String	Generic Edit	12	0
49	F3112	Work Order Routing	8	WL	MMCU	Branch	String	Generic Edit	12	0
50	F31122	Work Order Time Transactions	9	WT	MMCU	Branch	String	Generic Edit	12	0
51	F31122S	Purge Work Order Time Transactions	9	WT	MMCU	Branch	String	Generic Edit	12	0
52	F31122Z1	Work Order Time Transactions Unedited Transaction Table	22	SZ	MMCU	Branch	String	Generic Edit	12	0
53	F3112S	Purge Shop Floor Control Routing Instructions	8	WL	MMCU	Branch	String	Generic Edit	12	0
54	F3112Z1	Outbound Work Order Routings	21	SZ	MMCU	Branch	String	Generic Edit	12	0
55	F3114	Rate Schedule Transaction File	2	IQ	MMCU	Branch	String	Generic Edit	12	0
56	F3115	Net Change Transaction table	4	NC	MMCU	Branch	String	Generic Edit	12	0
57	F3118	Shortage Maintenance Master File	1	WN	MMCU	Branch	String	Generic Edit	12	0
58	F31UI006	Line Scheduling Workbench - Work File	3	LS	MMCU	Branch	String	Generic Edit	12	0
59	F31UI427	Labor Variance User Index	9	W1	MMCU	Branch	String	Generic Edit	12	0
TOP31A: Manufacturing Accounting
60	F30UI003	WIP Revaluation Work File	3	WR	MMCU	Branch	String	Generic Edit	12	0
TOP31B: Blend Management
61	F31B07	EUR Master File	40	EU	MMCU	Branch	String	Generic Edit	12	0
62	F31B5101	Wine Premises Report Line Definition	1	WL	MMCU	Branch	String	Generic Edit	12	0
63	F31B5102	Wine Premises Report Configuration	1	WC	MMCU	Branch	String	Generic Edit	12	0
64	F31B5103	Wine Premises Report Operation Detail	4	AD	MMCU	Branch	String	Generic Edit	12	0
65	F31B5120	Wine Premises Report Preview	2	WP	MMCU	Branch	String	Generic Edit	12	0
66	F31B60	Operation Trace Track Workfile	8	OT	MMCU	Branch	String	Generic Edit	12	0
67	F31B61	End Wine Lots Workfile	4	EL	MMCU	Branch	String	Generic Edit	12	0
68	F31B65	Operation Header	4	OH	MMCU	Branch	String	Generic Edit	12	0
69	F31B65Z1	Operations Transaction File	24	SZ	MMCU	Branch	String	Generic Edit	12	0
70	F31BQAZ1	Operations Quality Test Transaction File	20	SZ	MMCU	Branch	String	Generic Edit	12	0
TOP31P: Engineer To Order
71	F31P11	Project Quote Detail	25	QP	MMCU	Branch	String	Generic Edit	12	0
72	F31P21	Cost Classification Table	1	CC	MMCU	Branch	String	Generic Edit	12	0
TOP32: Configuration Management
73	F3212	Configurator Routings File	4	RC	MMCU	Branch	String	Generic Edit	12	0
TOP33: Capacity Planning
74	F3303	Capacity Resource Profile	5	CT	MMCU	Branch	String	Generic Edit	12	0
75	F3312	Capacity Pegging	4	CW	MMCU	Branch	String	Generic Edit	12	0
76	F33133	Capacity Dates File	1	DC	MMCU	Branch	String	Generic Edit	12	0
77	F33UI001	Shop Floor Control Routing Instructions	4	WL	MMCU	Branch	String	Generic Edit	12	0
TOP34: Requirements Planning
78	F3403	Branch Relationships Master File	1	MP	MMCU	Branch	String	Generic Edit	12	0
79	F3404	Co-Products Planning/Costing Table	2	PM	MMCU	Branch	String	Generic Edit	12	0
80	F3411	MPS/MRP/DRP Message File	4	MM	MMCU	Branch	String	Generic Edit	12	0
81	F3412	MPS/MRP/DRP Lower Level Requirements File	6	MW	MMCU	Branch	String	Generic Edit	12	0
82	F43213	SRS Ship Dates	6	VP	MMCU	Branch	String	Generic Edit	12	0
TOP34A: Advanced Planning & Scheduling
83	F34A10	APS Integration Constants	49	N0	MMCU	Branch	String	Generic Edit	12	0
84	F34A110	Work Center Resource Table	3	N0	MMCU	Branch	String	Generic Edit	12	0
85	F34A120	Routing Master Resource Table	3	N0	MMCU	Branch	String	Generic Edit	12	0
86	F34A160	Work Center Resource Set	2	WR	MMCU	Branch	String	Generic Edit	12	0
87	F34A170	Work Center Resource and Set XRef	2	WD	MMCU	Branch	String	Generic Edit	12	0
88	F34A180	Routing Master Resource Set	3	RR	MMCU	Branch	String	Generic Edit	12	0
89	F34A190	Routing Master Resource and Set XRef	3	RD	MMCU	Branch	String	Generic Edit	12	0
90	F34A32	Star Item	2	GP	MMCU	Branch	String	Generic Edit	12	0
91	F34A40	APS Integration Group Setup Table	2	N0	MMCU	Branch	String	Generic Edit	12	0
92	F34A60	Last Outbound Purchase Order/Transfer Order	3	OB	MMCU	Branch	String	Generic Edit	12	0
93	F34A90	Last Outbound Phantom Information	2	PI	MMCU	Branch	String	Generic Edit	12	0
TOP34X: In-Memory Planning Advisor
94	F34X200W	Planning Details Supply/Demand Work Table	84	SD	MMCU	Branch	String	Generic Edit	12	0
95	F34X310W	Planning Advisor BOM Component Detail Table	15	PD	MMCU	Branch	String	Generic Edit	12	0
TOP37: Quality Management
96	F3701	Test Definitions Master File	49	QA	MMCU	Branch	String	Generic Edit	12	0
97	F3702	Specifications Definitions Master File	14	QS	MMCU	Branch	String	Generic Edit	12	0
98	F3703	Non-Conforming Material	25	QE	MMCU	Branch	String	Generic Edit	12	0
99	F3711	Test Results	81	TR	MMCU	Branch	String	Generic Edit	12	0
100	F3711Z1	Test Results Unedited Transaction Table	94	SZ	MMCU	Branch	String	Generic Edit	12	0
101	F37900	Certificate of Analysis (COA) Extract	87	TR	MMCU	Branch	String	Generic Edit	12	0
102	F40318	Preference Profile - Quality Management	55	QC	MMCU	Branch	String	Generic Edit	12	0
TOP40: Inventory/OP Base
103	F3002	Bill of Material Master File	5	IX	MMCU	Branch	String	Generic Edit	12	0
104	F30026	Item Cost Component Add-Ons	4	IE	MMCU	Branch	String	Generic Edit	12	0
105	F3003	Routing Master File	5	IR	MMCU	Branch	String	Generic Edit	12	0
106	F3009	Job Shop Manufacturing Constants	2	IA	MMCU	Branch	String	Generic Edit	12	0
107	F3011	Bill of Materials Change File	5	IZ	MMCU	Branch	String	Generic Edit	12	0
108	F3013	ECO Parts List Detail	6	CY	MMCU	Branch	String	Generic Edit	12	0
109	F3015	Component Locator File	7	CQ	MMCU	Branch	String	Generic Edit	12	0
110	F30UI002	Bill of Material Structure Analysis Work File	6	IX	MMCU	Branch	String	Generic Edit	12	0
111	F30UI004	Bill of Material Update Work File	13	WF	MMCU	Branch	String	Generic Edit	12	0
112	F30UI006	Lot Tracking Work File	9	IL	MMCU	Branch	String	Generic Edit	12	0
113	F40051	Return Material Authorization	46	RD	MMCU	Branch	String	Generic Edit	12	0
114	F40052	Return Material Authorization Defaults	3	RV	MMCU	Branch	String	Generic Edit	12	0
115	F40318R	Preference Resolution Ledger - Quality Management	57	QC	MMCU	Branch	String	Generic Edit	12	0
TOP41: Inventory Management
116	F4101Z1	F4101 Item Master Unedited Transaction Table	154	SZ	MMCU	Branch	String	Generic Edit	12	0
117	F4101Z1A	F4101 Detail Item Master Unedited Transaction	17	SZ	MMCU	Branch	String	Generic Edit	12	0
118	F41051	Average Cost Work file	3	CH	MMCU	Branch	String	Generic Edit	12	0
119	F4111	Item Ledger File	18	IL	MMCU	Branch	String	Generic Edit	12	0
120	F41UI001	Inventory Transactions Detail File	36	IT	MMCU	Branch	String	Generic Edit	12	0
TOP41F: Apparel Management
121	FCW15	Work File F41171	3	WF	MMCU	Branch	String	Generic Edit	12	0
122	FCW48	Bill of Material Association Header	2	BH	MMCU	Branch	String	Generic Edit	12	0
123	FCW49	Bill of Material Association Detail	2	BD	MMCU	Branch	String	Generic Edit	12	0
124	FCW50	Bill of Material Association Matrix	2	BX	MMCU	Branch	String	Generic Edit	12	0
125	FCW51	BOM Usage	2	BU	MMCU	Branch	String	Generic Edit	12	0
126	FCW52	Style Routing Master File	2	RC	MMCU	Branch	String	Generic Edit	12	0
127	FCW65	Work Order Header for Style Items	16	OF	MMCU	Branch	String	Generic Edit	12	0
128	FCW67	Style Work Order Parts List	83	WM	MMCU	Branch	String	Generic Edit	12	0
129	FCW68	Style Work Order Routings	9	WL	MMCU	Branch	String	Generic Edit	12	0
130	FCW85	Item Cost Component Add Ons Work File	5	IE	MMCU	Branch	String	Generic Edit	12	0
131	FCW86	BOM Quantity Work File	3	WF	MMCU	Branch	String	Generic Edit	12	0
132	FCW93	Copy to Outsource Operations for Style Items	9	ST	MMCU	Branch	String	Generic Edit	12	0
133	FCW97	Grouping Messages	14	GM	MMCU	Branch	String	Generic Edit	12	0
TOP42X: In-Memory Sales Advisor
134	F42X060W	Supply Monitor Chart Work File	5	DC	MMCU	Branch	String	Generic Edit	12	0
TOP47: Electronic Commerce
135	F47122	EDI Product Activity Data Detail - Inbound	45	MJ	MMCU	Branch	String	Generic Edit	12	0
136	F47127	EDI Product Activity Data Detail - Outbound	45	MJ	MMCU	Branch	String	Generic Edit	12	0
TOP48: Work Order Processing
137	F4801	Work Order Master File	15	WA	MMCU	Branch	String	Generic Edit	12	0
138	F4801S	Purge - Work Order Master file	15	WA	MMCU	Branch	String	Generic Edit	12	0
139	F4801Z1	Outbound Work Order Header	34	SY	MMCU	Branch	String	Generic Edit	12	0
140	F4808	Order Routing Approval Master	1	CA	MMCU	Branch	String	Generic Edit	12	0
141	F48710	Work Order Mass Update Template Table	113	WT	MMCU	Branch	String	Generic Edit	12	0
142	F48UI001	X4801 Master Business Function Workfile	18	WA	MMCU	Branch	String	Generic Edit	12	0
TOP75I: India
143	F75I395B	ER - 5 (2)	6	ER	MMCU	Branch	String	Generic Edit	12	0
144	F75I395T	ER - 5 (temp)	6	ER	MMCU	Branch	String	Generic Edit	12	0
145	F75I396B	ER-6	10	SE	MMCU	Branch	String	Generic Edit	12	0
146	F75I396T	ER-6 Temp	10	SE	MMCU	Branch	String	Generic Edit	12	0
TOP76B: Brazil
147	F76B3010	Work Table for Item/Part List - 30	3	IP	MMCU	Branch	String	Generic Edit	12	0
TOP76H: Chile
148	F76H6002	Indirect Costs Selection EPS F1602 - CHI - 41 - 76H	25	I1	MMCU	Branch	String	Generic Edit	12	0
149	F76H6003	Indirect Costs Selection EPS F1642 - CHI - 41 - 76H	26	I2	MMCU	Branch	String	Generic Edit	12	0
150	F76H6004	Item Cost Component WF - CHI - 41 - 76H	5	IC	MMCU	Branch	String	Generic Edit	12	0
151	F76H611	Actual Item Ledger File - CHI - 41 - 76H	18	AL	MMCU	Branch	String	Generic Edit	12	0
TOP79A: Greenhouse Gas Accounting
152	F79A11	GHG Ledger	9	GR	MMCU	Branch	String	Generic Edit	12	0
153	F79A11Z1	GHG Ledger - Batch File	27	GL	MMCU	Branch	String	Generic Edit	12	0
154	F79A12	GHG Ledger Audit	10	GR	MMCU	Branch	String	Generic Edit	12	0
155	F79AU11	GHG Ledger Work Table	12	GR	MMCU	Branch	String	Generic Edit	12	0
TOP89: Conversion Programs
156	F49090	Work Day Calendar (Used for Table Conversions ONLY)	2	CZ	MMCU	Branch	String	Generic Edit	12	0
TOPF31: Lean Transactions
157	FF31010	Production Master File	6	EH	MMCU	Branch	String	Generic Edit	12	0
158	FF31011	TransactionID Master File	30	EH	MMCU	Branch	String	Generic Edit	12	0
159	FF31011S	Purge - TransactionID Master File	30	ER	MMCU	Branch	String	Generic Edit	12	0
160	FF31111	Lean Transaction Parts List	7	PL	MMCU	Branch	String	Generic Edit	12	0
161	FF31111S	Purge - Lean Transaction Parts List	7	PR	MMCU	Branch	String	Generic Edit	12	0
162	FF31112	Routing Transaction Table	22	EH	MMCU	Branch	String	Generic Edit	12	0
163	FF31112S	Purge - Routing Transaction Table	22	ET	MMCU	Branch	String	Generic Edit	12	0
164	FF31113	Lean Transaction Labor Detail	11	LD	MMCU	Branch	String	Generic Edit	12	0
165	FF31113S	Purge - Lean Transaction Labor Detail	11	LR	MMCU	Branch	String	Generic Edit	12	0

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

165 columns | 920 | MMCU