	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

128 columns | 812 | MMCU

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0007	Work Day Calendar	2	CZ	MMCU	Branch	String	Generic Edit	12	0
2	F49090	Work Day Calendar	2	CZ	MMCU	Branch	String	Generic Edit	12	0
TOP04: Accounts Payable
3	F09UI005	Tax Offsets User Index	29	GL	MMCU	Branch	String	Generic Edit	12	0
TOP12: Fixed Assets
4	F1217	Equipment Master Extension	4	WR	MMCU	Branch	String	Generic Edit	12	0
5	F1217P	Equipment Master Extension Purge Table	4	WR	MMCU	Branch	String	Generic Edit	12	0
6	F1217Z1	Unedited Equipment Tag Transactions	17	WR	MMCU	Branch	String	Generic Edit	12	0
7	F1217Z2	Unedited Equipment Tag Transactions	17	WR	MMCU	Branch	String	Generic Edit	12	0
TOP13: Plant/Equipment Management
8	F13411	PM Projections	12	RX	MMCU	Branch	String	Generic Edit	12	0
TOP13E: Equipment Cost Analysis
9	F1381	Equipment Analysis Filters	13	EF	MMCU	Branch	String	Generic Edit	12	0
TOP13R: Resource Assignments
10	F48301	Resource Assignments Constants	2	RX	MMCU	Branch	String	Generic Edit	12	0
11	F48307	Resource Working Hours	2	RH	MMCU	Branch	String	Generic Edit	12	0
12	F48310	Resource Master	5	RM	MMCU	Branch	String	Generic Edit	12	0
TOP17: Customer Service Management
13	F17113	Assessor Defaults	4	AD	MMCU	Branch	String	Generic Edit	12	0
14	F1721	Contract Detail	46	CD	MMCU	Branch	String	Generic Edit	12	0
15	F1775	Claim Temporary Table	27	TC	MMCU	Branch	String	Generic Edit	12	0
16	F1791	Entitlement Dates	4	EM	MMCU	Branch	String	Generic Edit	12	0
17	F3112Z2	Warranty Claim/Supplier Recovery processing	21	WL	MMCU	Branch	String	Generic Edit	12	0
18	F41171	Item Branch Master - Customer Service Extension	2	PB	MMCU	Branch	String	Generic Edit	12	0
19	F4801Z2	Warranty Claim/Supplier Recovery processing	34	WS	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	Customer Call 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
24	F48164	Knowledge Base Detail	40	KB	MMCU	Branch	String	Generic Edit	12	0
TOP30: Product Data Management
25	F0007Z1	Work Day Calendar Transaction File	17	SZ	MMCU	Branch	String	Generic Edit	12	0
26	F30006	Work Center Master File	3	IW	MMCU	Branch	String	Generic Edit	12	0
27	F30006Z1	Work Center Transaction File	16	SZ	MMCU	Branch	String	Generic Edit	12	0
28	F30008	Work Center Rates File	25	IW	MMCU	Branch	String	Generic Edit	12	0
29	F300210	Lean Multi Level Bill of Material Header	4	EH	MMCU	Branch	String	Generic Edit	12	0
30	F300211	Lean Multi Level Bill of Material Detail	8	ED	MMCU	Branch	String	Generic Edit	12	0
31	F3002Z1	Bill of Material Transaction File	18	SZ	MMCU	Branch	String	Generic Edit	12	0
32	F300311	Lean Multi Level Routing Detail File	4	EH	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	F3016	Kanban Master	12	KM	MMCU	Branch	String	Generic Edit	12	0
36	F30UI008	Bill of Material Comparison Work File	6	IJ	MMCU	Branch	String	Generic Edit	12	0
TOP30A: Product Costing
37	F300261	Item Cost Component Detail	4	IE	MMCU	Branch	String	Generic Edit	12	0
TOP31: Shop Floor Control
38	F3102	Production Cost	33	IG	MMCU	Branch	String	Generic Edit	12	0
39	F3102S	Purge - Production Cost	33	IG	MMCU	Branch	String	Generic Edit	12	0
40	F3109	Line/Item Relationship Master	4	IP	MMCU	Branch	String	Generic Edit	12	0
41	F31091	Schedule Quantity Detail	4	IQ	MMCU	Branch	String	Generic Edit	12	0
42	F31091S	Schedule Quantity Detail Purge	4	IQ	MMCU	Branch	String	Generic Edit	12	0
43	F3112	Work Order Routing	8	WL	MMCU	Branch	String	Generic Edit	12	0
44	F31122	Work Order Time Transactions	9	WT	MMCU	Branch	String	Generic Edit	12	0
45	F31122S	Purge Work Order Time Transactions	9	WT	MMCU	Branch	String	Generic Edit	12	0
46	F31122Z1	Work Order Time Transactions Unedited Transaction Table	22	SZ	MMCU	Branch	String	Generic Edit	12	0
47	F3112S	Purge Shop Floor Control Routing Instructions	8	WL	MMCU	Branch	String	Generic Edit	12	0
48	F3112Z1	Outbound Work Order Routings	21	SZ	MMCU	Branch	String	Generic Edit	12	0
49	F3114	Rate Schedule Transaction File	2	IQ	MMCU	Branch	String	Generic Edit	12	0
50	F3115	Net Change Transaction table	4	NC	MMCU	Branch	String	Generic Edit	12	0
51	F3118	Shortage Maintenance Master File	1	WN	MMCU	Branch	String	Generic Edit	12	0
52	F31UI006	Line Scheduling Workbench - Work File	3	LS	MMCU	Branch	String	Generic Edit	12	0
53	F31UI427	Labor Variance User Index	9	W1	MMCU	Branch	String	Generic Edit	12	0
54	F4801S	Purge - Work Order Master file	15	WA	MMCU	Branch	String	Generic Edit	12	0
55	F4801Z1	Outbound Work Order Header	34	SY	MMCU	Branch	String	Generic Edit	12	0
TOP31B: Blend Management
56	F31B07	EUR Master File	40	EU	MMCU	Branch	String	Generic Edit	12	0
57	F31B61	End Wine Lots Workfile	4	EL	MMCU	Branch	String	Generic Edit	12	0
58	F31B65	Operation Header	4	OH	MMCU	Branch	String	Generic Edit	12	0
59	F31B65Z1	Operations Transaction File	24	SZ	MMCU	Branch	String	Generic Edit	12	0
60	F31BQAZ1	Operations Quality Test Transaction File	17	SZ	MMCU	Branch	String	Generic Edit	12	0
TOP31P: Engineer To Order
61	F31P11	Project Quote Detail	25	QP	MMCU	Branch	String	Generic Edit	12	0
62	F31P21	Cost Classification Table	1	CC	MMCU	Branch	String	Generic Edit	12	0
TOP32: Configuration Management
63	F3212	Configurator Routings File	4	RC	MMCU	Branch	String	Generic Edit	12	0
TOP33: Capacity Planning
64	F3303	Capacity Resource Profile	5	CT	MMCU	Branch	String	Generic Edit	12	0
65	F3312	Capacity Pegging	4	CW	MMCU	Branch	String	Generic Edit	12	0
66	F33133	Capacity Dates File	1	DC	MMCU	Branch	String	Generic Edit	12	0
67	F33UI001	Shop Floor Control Routing Instructions	4	WL	MMCU	Branch	String	Generic Edit	12	0
TOP34: Requirements Planning
68	F3403	Branch Relationships Master File	1	MP	MMCU	Branch	String	Generic Edit	12	0
69	F3404	Co-Products Planning/Costing Table	2	PM	MMCU	Branch	String	Generic Edit	12	0
70	F3411	MPS/MRP/DRP Message File	4	MM	MMCU	Branch	String	Generic Edit	12	0
71	F3412	MPS/MRP/DRP Lower Level Requirements File	6	MW	MMCU	Branch	String	Generic Edit	12	0
72	F34A10	Numetrix Integration Constants	49	N0	MMCU	Branch	String	Generic Edit	12	0
73	F43213	SRS Ship Dates	6	VP	MMCU	Branch	String	Generic Edit	12	0
TOP34A: Advanced Planning & Scheduling
74	F34A110	Work Center Resource Table	3	N0	MMCU	Branch	String	Generic Edit	12	0
75	F34A120	Routing Master Resource Table	3	N0	MMCU	Branch	String	Generic Edit	12	0
76	F34A40	APS Integration Group Setup Table	2	N0	MMCU	Branch	String	Generic Edit	12	0
77	F34A60	Last Outbound Purchase Order/Transfer Order	3	OB	MMCU	Branch	String	Generic Edit	12	0
78	F34A90	Last Outbound Phantom Information	2	PI	MMCU	Branch	String	Generic Edit	12	0
TOP37: Quality Management
79	F3701	Test Definitions Master File	49	QA	MMCU	Branch	String	Generic Edit	12	0
80	F3702	Specifications Definitions Master File	14	QS	MMCU	Branch	String	Generic Edit	12	0
81	F3703	Non-Conforming Material	25	QE	MMCU	Branch	String	Generic Edit	12	0
82	F3711	Test Results	81	TR	MMCU	Branch	String	Generic Edit	12	0
83	F3711Z1	Test Results Unedited Transaction Table	94	SZ	MMCU	Branch	String	Generic Edit	12	0
84	F37900	Certificate of Analysis (COA) Extract	87	TR	MMCU	Branch	String	Generic Edit	12	0
85	F40318	Preference Profile - Quality Management	55	QC	MMCU	Branch	String	Generic Edit	12	0
TOP40: Inventory/OP Base
86	F3002	Bill of Material Master File	5	IX	MMCU	Branch	String	Generic Edit	12	0
87	F30026	Item Cost Component Add-Ons	4	IE	MMCU	Branch	String	Generic Edit	12	0
88	F3003	Routing Master File	5	IR	MMCU	Branch	String	Generic Edit	12	0
89	F3003T	Routing Tag File	3	IR	MMCU	Branch	String	Generic Edit	12	0
90	F3009	Job Shop Manufacturing Constants	2	IA	MMCU	Branch	String	Generic Edit	12	0
91	F3009T	Manufacturing Constants Tag File	1	IA	MMCU	Branch	String	Generic Edit	12	0
92	F3011	Bill of Materials Change File	5	IZ	MMCU	Branch	String	Generic Edit	12	0
93	F3013	ECO Parts List Detail	6	CY	MMCU	Branch	String	Generic Edit	12	0
94	F3015	Component Locator File	7	CQ	MMCU	Branch	String	Generic Edit	12	0
95	F30UI002	Bill of Material Structure Analysis Work File	6	IX	MMCU	Branch	String	Generic Edit	12	0
96	F30UI004	Bill of Material Update Work File	13	WF	MMCU	Branch	String	Generic Edit	12	0
97	F30UI006	Lot Tracking Work File	9	IL	MMCU	Branch	String	Generic Edit	12	0
98	F40051	Return Material Authorization	46	RD	MMCU	Branch	String	Generic Edit	12	0
99	F40052	Return Material Authorization Defaults	3	RV	MMCU	Branch	String	Generic Edit	12	0
100	F40318R	Preference Resolution Ledger - Quality Management	57	QC	MMCU	Branch	String	Generic Edit	12	0
TOP41: Inventory Management
101	F4101Z1	F4101 Item Master Unedited Transaction Table	154	SZ	MMCU	Branch	String	Generic Edit	12	0
102	F4101Z1A	F4101 Detail Item Master Unedited Transaction	17	SZ	MMCU	Branch	String	Generic Edit	12	0
103	F41051	Average Cost Work file	3	CH	MMCU	Branch	String	Generic Edit	12	0
104	F4111	Item Ledger File	18	IL	MMCU	Branch	String	Generic Edit	12	0
105	F41UI001	Inventory Transactions Detail File	36	IT	MMCU	Branch	String	Generic Edit	12	0
TOP47: Electronic Commerce
106	F47122	EDI Product Activity Data Detail - Inbound	45	MJ	MMCU	Branch	String	Generic Edit	12	0
107	F47127	EDI Product Activity Data Detail - Outbound	45	MJ	MMCU	Branch	String	Generic Edit	12	0
TOP48: Work Order Processing
108	F4801	Work Order Master File	15	WA	MMCU	Branch	String	Generic Edit	12	0
109	F4808	Order Routing Approval Master	1	CA	MMCU	Branch	String	Generic Edit	12	0
110	F48UI001	X4801 Master Business Function Workfile	18	WA	MMCU	Branch	String	Generic Edit	12	0
TOP76B: Brazil - Reporting System Only
111	F76B3010	Work Table for Item/Part List - 30	3	IP	MMCU	Branch	String	Generic Edit	12	0
TOP76H: Chile
112	F76H6002	Indirect Costs Selection EPS F1602 - CHI - 41 - 76H	25	I1	MMCU	Branch	String	Generic Edit	12	0
113	F76H6003	Indirect Costs Selection EPS F1642 - CHI - 41 - 76H	26	I2	MMCU	Branch	String	Generic Edit	12	0
114	F76H6004	Item Cost Component WF - CHI - 41 - 76H	5	IC	MMCU	Branch	String	Generic Edit	12	0
115	F76H611	Actual Item Ledger File - CHI - 41 - 76H	18	AL	MMCU	Branch	String	Generic Edit	12	0
TOPD3N: dcLINK (data collection) - DSI
116	FD3N901	TranPrint - TranPrint Transaction - Table	8	LP	MMCU	Branch	String	Generic Edit	12	0
117	FD3N902	TranPrint - TranPrint Error - Table	8	LE	MMCU	Branch	String	Generic Edit	12	0
118	FD3N903	TranPrint - Transaction By Script Variable - Table	8	LP	MMCU	Branch	String	Generic Edit	12	0
119	FD3N904	TranPrint - Error By Script Variable - Table	8	LE	MMCU	Branch	String	Generic Edit	12	0
TOPF31: Lean Transactions
120	FF31010	Production Master File	6	EH	MMCU	Branch	String	Generic Edit	12	0
121	FF31011	TransactionID Master File	30	EH	MMCU	Branch	String	Generic Edit	12	0
122	FF31011S	Purge - TransactionID Master File	30	ER	MMCU	Branch	String	Generic Edit	12	0
123	FF31111	Lean Transaction Parts List	7	PL	MMCU	Branch	String	Generic Edit	12	0
124	FF31111S	Purge - Lean Transaction Parts List	7	PR	MMCU	Branch	String	Generic Edit	12	0
125	FF31112	Routing Transaction Table	22	EH	MMCU	Branch	String	Generic Edit	12	0
126	FF31112S	Purge - Routing Transaction Table	22	ET	MMCU	Branch	String	Generic Edit	12	0
127	FF31113	Lean Transaction Labor Detail	11	LD	MMCU	Branch	String	Generic Edit	12	0
128	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

128 columns | 812 | MMCU