	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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

156 columns | 910 | 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	F3109	Line/Item Relationship Master	4	IP	MMCU	Branch	String	Generic Edit	12	0
46	F31091	Schedule Quantity Detail	4	IQ	MMCU	Branch	String	Generic Edit	12	0
47	F31091S	Schedule Quantity Detail Purge	4	IQ	MMCU	Branch	String	Generic Edit	12	0
48	F3112	Work Order Routing	8	WL	MMCU	Branch	String	Generic Edit	12	0
49	F31122	Work Order Time Transactions	9	WT	MMCU	Branch	String	Generic Edit	12	0
50	F31122S	Purge Work Order Time Transactions	9	WT	MMCU	Branch	String	Generic Edit	12	0
51	F31122Z1	Work Order Time Transactions Unedited Transaction Table	22	SZ	MMCU	Branch	String	Generic Edit	12	0
52	F3112S	Purge Shop Floor Control Routing Instructions	8	WL	MMCU	Branch	String	Generic Edit	12	0
53	F3112Z1	Outbound Work Order Routings	21	SZ	MMCU	Branch	String	Generic Edit	12	0
54	F3114	Rate Schedule Transaction File	2	IQ	MMCU	Branch	String	Generic Edit	12	0
55	F3115	Net Change Transaction table	4	NC	MMCU	Branch	String	Generic Edit	12	0
56	F3118	Shortage Maintenance Master File	1	WN	MMCU	Branch	String	Generic Edit	12	0
57	F31UI006	Line Scheduling Workbench - Work File	3	LS	MMCU	Branch	String	Generic Edit	12	0
58	F31UI427	Labor Variance User Index	9	W1	MMCU	Branch	String	Generic Edit	12	0
TOP31B: Blend Management
59	F31B07	EUR Master File	40	EU	MMCU	Branch	String	Generic Edit	12	0
60	F31B60	Operation Trace Track Workfile	8	OT	MMCU	Branch	String	Generic Edit	12	0
61	F31B61	End Wine Lots Workfile	4	EL	MMCU	Branch	String	Generic Edit	12	0
62	F31B65	Operation Header	4	OH	MMCU	Branch	String	Generic Edit	12	0
63	F31B65Z1	Operations Transaction File	24	SZ	MMCU	Branch	String	Generic Edit	12	0
64	F31BQAZ1	Operations Quality Test Transaction File	20	SZ	MMCU	Branch	String	Generic Edit	12	0
TOP31P: Engineer To Order
65	F31P11	Project Quote Detail	25	QP	MMCU	Branch	String	Generic Edit	12	0
66	F31P21	Cost Classification Table	1	CC	MMCU	Branch	String	Generic Edit	12	0
TOP32: Configuration Management
67	F3212	Configurator Routings File	4	RC	MMCU	Branch	String	Generic Edit	12	0
TOP33: Capacity Planning
68	F3303	Capacity Resource Profile	5	CT	MMCU	Branch	String	Generic Edit	12	0
69	F3312	Capacity Pegging	4	CW	MMCU	Branch	String	Generic Edit	12	0
70	F33133	Capacity Dates File	1	DC	MMCU	Branch	String	Generic Edit	12	0
71	F33UI001	Shop Floor Control Routing Instructions	4	WL	MMCU	Branch	String	Generic Edit	12	0
TOP34: Requirements Planning
72	F3403	Branch Relationships Master File	1	MP	MMCU	Branch	String	Generic Edit	12	0
73	F3404	Co-Products Planning/Costing Table	2	PM	MMCU	Branch	String	Generic Edit	12	0
74	F3411	MPS/MRP/DRP Message File	4	MM	MMCU	Branch	String	Generic Edit	12	0
75	F3412	MPS/MRP/DRP Lower Level Requirements File	6	MW	MMCU	Branch	String	Generic Edit	12	0
76	F43213	SRS Ship Dates	6	VP	MMCU	Branch	String	Generic Edit	12	0
TOP34A: Advanced Planning & Scheduling
77	F34A10	APS Integration Constants	49	N0	MMCU	Branch	String	Generic Edit	12	0
78	F34A110	Work Center Resource Table	3	N0	MMCU	Branch	String	Generic Edit	12	0
79	F34A120	Routing Master Resource Table	3	N0	MMCU	Branch	String	Generic Edit	12	0
80	F34A160	Work Center Resource Set	2	WR	MMCU	Branch	String	Generic Edit	12	0
81	F34A170	Work Center Resource and Set XRef	2	WD	MMCU	Branch	String	Generic Edit	12	0
82	F34A180	Routing Master Resource Set	3	RR	MMCU	Branch	String	Generic Edit	12	0
83	F34A190	Routing Master Resource and Set XRef	3	RD	MMCU	Branch	String	Generic Edit	12	0
84	F34A32	Star Item	2	GP	MMCU	Branch	String	Generic Edit	12	0
85	F34A40	APS Integration Group Setup Table	2	N0	MMCU	Branch	String	Generic Edit	12	0
86	F34A60	Last Outbound Purchase Order/Transfer Order	3	OB	MMCU	Branch	String	Generic Edit	12	0
87	F34A90	Last Outbound Phantom Information	2	PI	MMCU	Branch	String	Generic Edit	12	0
TOP37: Quality Management
88	F3701	Test Definitions Master File	49	QA	MMCU	Branch	String	Generic Edit	12	0
89	F3702	Specifications Definitions Master File	14	QS	MMCU	Branch	String	Generic Edit	12	0
90	F3703	Non-Conforming Material	25	QE	MMCU	Branch	String	Generic Edit	12	0
91	F3711	Test Results	81	TR	MMCU	Branch	String	Generic Edit	12	0
92	F3711Z1	Test Results Unedited Transaction Table	94	SZ	MMCU	Branch	String	Generic Edit	12	0
93	F37900	Certificate of Analysis (COA) Extract	87	TR	MMCU	Branch	String	Generic Edit	12	0
94	F40318	Preference Profile - Quality Management	55	QC	MMCU	Branch	String	Generic Edit	12	0
TOP40: Inventory/OP Base
95	F3002	Bill of Material Master File	5	IX	MMCU	Branch	String	Generic Edit	12	0
96	F30026	Item Cost Component Add-Ons	4	IE	MMCU	Branch	String	Generic Edit	12	0
97	F3003	Routing Master File	5	IR	MMCU	Branch	String	Generic Edit	12	0
98	F3009	Job Shop Manufacturing Constants	2	IA	MMCU	Branch	String	Generic Edit	12	0
99	F3011	Bill of Materials Change File	5	IZ	MMCU	Branch	String	Generic Edit	12	0
100	F3013	ECO Parts List Detail	6	CY	MMCU	Branch	String	Generic Edit	12	0
101	F3015	Component Locator File	7	CQ	MMCU	Branch	String	Generic Edit	12	0
102	F30UI002	Bill of Material Structure Analysis Work File	6	IX	MMCU	Branch	String	Generic Edit	12	0
103	F30UI004	Bill of Material Update Work File	13	WF	MMCU	Branch	String	Generic Edit	12	0
104	F30UI006	Lot Tracking Work File	9	IL	MMCU	Branch	String	Generic Edit	12	0
105	F40051	Return Material Authorization	46	RD	MMCU	Branch	String	Generic Edit	12	0
106	F40052	Return Material Authorization Defaults	3	RV	MMCU	Branch	String	Generic Edit	12	0
107	F40318R	Preference Resolution Ledger - Quality Management	57	QC	MMCU	Branch	String	Generic Edit	12	0
TOP41: Inventory Management
108	F4101Z1	F4101 Item Master Unedited Transaction Table	154	SZ	MMCU	Branch	String	Generic Edit	12	0
109	F4101Z1A	F4101 Detail Item Master Unedited Transaction	17	SZ	MMCU	Branch	String	Generic Edit	12	0
110	F41051	Average Cost Work file	3	CH	MMCU	Branch	String	Generic Edit	12	0
111	F4111	Item Ledger File	18	IL	MMCU	Branch	String	Generic Edit	12	0
112	F41UI001	Inventory Transactions Detail File	36	IT	MMCU	Branch	String	Generic Edit	12	0
TOP41F: Apparel Management
113	FCW15	Work File F41171	3	WF	MMCU	Branch	String	Generic Edit	12	0
114	FCW48	Bill of Material Association Header	2	BH	MMCU	Branch	String	Generic Edit	12	0
115	FCW49	Bill of Material Association Detail	2	BD	MMCU	Branch	String	Generic Edit	12	0
116	FCW50	Bill of Material Association Matrix	2	BX	MMCU	Branch	String	Generic Edit	12	0
117	FCW51	BOM Usage	2	BU	MMCU	Branch	String	Generic Edit	12	0
118	FCW52	Style Routing Master File	2	RC	MMCU	Branch	String	Generic Edit	12	0
119	FCW65	Work Order Header for Style Items	16	OF	MMCU	Branch	String	Generic Edit	12	0
120	FCW67	Style Work Order Parts List	83	WM	MMCU	Branch	String	Generic Edit	12	0
121	FCW68	Style Work Order Routings	9	WL	MMCU	Branch	String	Generic Edit	12	0
122	FCW85	Item Cost Component Add Ons Work File	5	IE	MMCU	Branch	String	Generic Edit	12	0
123	FCW86	BOM Quantity Work File	3	WF	MMCU	Branch	String	Generic Edit	12	0
124	FCW93	Copy to Outsource Operations for Style Items	9	ST	MMCU	Branch	String	Generic Edit	12	0
125	FCW97	Grouping Messages	14	GM	MMCU	Branch	String	Generic Edit	12	0
TOP47: Electronic Commerce
126	F47122	EDI Product Activity Data Detail - Inbound	45	MJ	MMCU	Branch	String	Generic Edit	12	0
127	F47127	EDI Product Activity Data Detail - Outbound	45	MJ	MMCU	Branch	String	Generic Edit	12	0
TOP48: Work Order Processing
128	F4801	Work Order Master File	15	WA	MMCU	Branch	String	Generic Edit	12	0
129	F4801S	Purge - Work Order Master file	15	WA	MMCU	Branch	String	Generic Edit	12	0
130	F4801Z1	Outbound Work Order Header	34	SY	MMCU	Branch	String	Generic Edit	12	0
131	F4808	Order Routing Approval Master	1	CA	MMCU	Branch	String	Generic Edit	12	0
132	F48710	Work Order Mass Update Template Table	113	WT	MMCU	Branch	String	Generic Edit	12	0
133	F48UI001	X4801 Master Business Function Workfile	18	WA	MMCU	Branch	String	Generic Edit	12	0
TOP75I: India
134	F75I395B	ER - 5 (2)	6	ER	MMCU	Branch	String	Generic Edit	12	0
135	F75I395T	ER - 5 (temp)	6	ER	MMCU	Branch	String	Generic Edit	12	0
136	F75I396B	ER-6	10	SE	MMCU	Branch	String	Generic Edit	12	0
137	F75I396T	ER-6 Temp	10	SE	MMCU	Branch	String	Generic Edit	12	0
TOP76B: Brazil - Reporting System Only
138	F76B3010	Work Table for Item/Part List - 30	3	IP	MMCU	Branch	String	Generic Edit	12	0
TOP76H: Chile
139	F76H6002	Indirect Costs Selection EPS F1602 - CHI - 41 - 76H	25	I1	MMCU	Branch	String	Generic Edit	12	0
140	F76H6003	Indirect Costs Selection EPS F1642 - CHI - 41 - 76H	26	I2	MMCU	Branch	String	Generic Edit	12	0
141	F76H6004	Item Cost Component WF - CHI - 41 - 76H	5	IC	MMCU	Branch	String	Generic Edit	12	0
142	F76H611	Actual Item Ledger File - CHI - 41 - 76H	18	AL	MMCU	Branch	String	Generic Edit	12	0
TOP79A: Greenhouse Gas Accounting
143	F79A11	GHG Ledger	9	GR	MMCU	Branch	String	Generic Edit	12	0
144	F79A11Z1	GHG Ledger - Batch File	27	GL	MMCU	Branch	String	Generic Edit	12	0
145	F79A12	GHG Ledger Audit	10	GR	MMCU	Branch	String	Generic Edit	12	0
146	F79AU11	GHG Ledger Work Table	12	GR	MMCU	Branch	String	Generic Edit	12	0
TOP89: Conversion Programs
147	F49090	Work Day Calendar (Used for Table Conversions ONLY)	2	CZ	MMCU	Branch	String	Generic Edit	12	0
TOPF31: Lean Transactions
148	FF31010	Production Master File	6	EH	MMCU	Branch	String	Generic Edit	12	0
149	FF31011	TransactionID Master File	30	EH	MMCU	Branch	String	Generic Edit	12	0
150	FF31011S	Purge - TransactionID Master File	30	ER	MMCU	Branch	String	Generic Edit	12	0
151	FF31111	Lean Transaction Parts List	7	PL	MMCU	Branch	String	Generic Edit	12	0
152	FF31111S	Purge - Lean Transaction Parts List	7	PR	MMCU	Branch	String	Generic Edit	12	0
153	FF31112	Routing Transaction Table	22	EH	MMCU	Branch	String	Generic Edit	12	0
154	FF31112S	Purge - Routing Transaction Table	22	ET	MMCU	Branch	String	Generic Edit	12	0
155	FF31113	Lean Transaction Labor Detail	11	LD	MMCU	Branch	String	Generic Edit	12	0
156	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

156 columns | 910 | MMCU