	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

69 columns | 812 | EFFF

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP09: General Accounting
1	F0050A	Structure Definition File	43	MA	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP10: Financial Reporting
2	F0050B	Business Unit Structure Build File	43	MA	EFFF	Effective - From Date	Date	Generic Edit	6	0
3	F10430A	Account Structure Definition	21	CG	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP12: Fixed Assets
4	F1217	Equipment Master Extension	57	WR	EFFF	Effective - From Date	Date	Generic Edit	6	0
5	F1217P	Equipment Master Extension Purge Table	57	WR	EFFF	Effective - From Date	Date	Generic Edit	6	0
6	F1217Z1	Unedited Equipment Tag Transactions	61	WR	EFFF	Effective - From Date	Date	Generic Edit	6	0
7	F1217Z2	Unedited Equipment Tag Transactions	61	WR	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP13: Plant/Equipment Management
8	F13017	Equipment Parts List	17	PL	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP16: Profit Management (EPS)
9	F1610	Cost Calculation Definitions	63	CD	EFFF	Effective - From Date	Date	Generic Edit	6	0
10	F1642	Rate Master Header File	7	RH	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP30: Product Data Management
11	F3002Z1	Bill of Material Transaction File	31	SZ	EFFF	Effective - From Date	Date	Generic Edit	6	0
12	F3003Z1	Routing Transactions File	24	SZ	EFFF	Effective - From Date	Date	Generic Edit	6	0
13	F30UI008	Bill of Material Comparison Work File	15	IJ	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP31: Shop Floor Control
14	F3109	Line/Item Relationship Master	10	IP	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP32: Configuration Management
15	F3281	Rules Table Definition	7	RT	EFFF	Effective - From Date	Date	Generic Edit	6	0
16	F3282	Configured Item/Rules Table Cross Reference	5	RK	EFFF	Effective - From Date	Date	Generic Edit	6	0
17	F32821	Rules Table Value Definition	6	RL	EFFF	Effective - From Date	Date	Generic Edit	6	0
18	F3283	Rules Table Detail	26	RD	EFFF	Effective - From Date	Date	Generic Edit	6	0
19	F3291	Configured Item Segments	6	KW	EFFF	Effective - From Date	Date	Generic Edit	6	0
20	F3292	Cross Segment Editing Rules	7	KU	EFFF	Effective - From Date	Date	Generic Edit	6	0
21	F32921	Cross Segment Editing Rules - Values	7	KX	EFFF	Effective - From Date	Date	Generic Edit	6	0
22	F32922	Cross Segment Editing Rules - Range	8	KV	EFFF	Effective - From Date	Date	Generic Edit	6	0
23	F3293	Assembly Inclusions Rules	34	KY	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP33: Capacity Planning
24	F3303	Capacity Resource Profile	11	CT	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP34: Requirements Planning
25	F3403	Branch Relationships Master File	9	MP	EFFF	Effective - From Date	Date	Generic Edit	6	0
26	F3404	Co-Products Planning/Costing Table	5	PM	EFFF	Effective - From Date	Date	Generic Edit	6	0
27	F43211	Supplier Schedule Master File	7	SS	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP34A: Advanced Planning & Scheduling
28	F34A120	Routing Master Resource Table	6	N0	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP36: Forecasting
29	F34007	Forecast Prices	5	FH	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP37: Quality Management
30	F3701	Test Definitions Master File	6	QA	EFFF	Effective - From Date	Date	Generic Edit	6	0
31	F3702	Specifications Definitions Master File	4	QS	EFFF	Effective - From Date	Date	Generic Edit	6	0
32	F37021	Specifications Detail File	4	QD	EFFF	Effective - From Date	Date	Generic Edit	6	0
33	F3711	Test Results	41	TR	EFFF	Effective - From Date	Date	Generic Edit	6	0
34	F3711Z1	Test Results Unedited Transaction Table	54	SZ	EFFF	Effective - From Date	Date	Generic Edit	6	0
35	F37900	Certificate of Analysis (COA) Extract	41	TR	EFFF	Effective - From Date	Date	Generic Edit	6	0
36	F40318	Preference Profile - Quality Management	14	QC	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP40: Inventory/OP Base
37	F3002	Bill of Material Master File	18	IX	EFFF	Effective - From Date	Date	Generic Edit	6	0
38	F3003	Routing Master File	11	IR	EFFF	Effective - From Date	Date	Generic Edit	6	0
39	F3003T	Routing Tag File	6	IR	EFFF	Effective - From Date	Date	Generic Edit	6	0
40	F3011	Bill of Materials Change File	18	IZ	EFFF	Effective - From Date	Date	Generic Edit	6	0
41	F3013	ECO Parts List Detail	23	CY	EFFF	Effective - From Date	Date	Generic Edit	6	0
42	F3015	Component Locator File	4	CQ	EFFF	Effective - From Date	Date	Generic Edit	6	0
43	F40318R	Preference Resolution Ledger - Quality Management	16	QC	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP41: Inventory Management
44	F4101A	Item File	7	IM	EFFF	Effective - From Date	Date	Generic Edit	6	0
45	F4101B	Item Master Bulk Data	7	IM	EFFF	Effective - From Date	Date	Generic Edit	6	0
46	F4101C	Item Category Codes	7	IM	EFFF	Effective - From Date	Date	Generic Edit	6	0
47	F4101F	Item Customer Service Data	7	IM	EFFF	Effective - From Date	Date	Generic Edit	6	0
48	F4101G	Item Branch Quantities	7	IB	EFFF	Effective - From Date	Date	Generic Edit	6	0
49	F4101M	Item Manufacturing Data	7	IM	EFFF	Effective - From Date	Date	Generic Edit	6	0
50	F4101P	Item Master Packaging	7	IM	EFFF	Effective - From Date	Date	Generic Edit	6	0
51	F4101S	Item Master Shipping Data	7	IM	EFFF	Effective - From Date	Date	Generic Edit	6	0
52	F4101W	Item Profile Data	7	IM	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP43: Procurement
53	F41291	Item Cost Components	17	IG	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP44H: Homebuilder Management
54	F4459	Material Item Pricing (World)	8	JL	EFFF	Effective - From Date	Date	Generic Edit	6	0
55	F4461	Option Master (World)	31	JN	EFFF	Effective - From Date	Date	Generic Edit	6	0
56	F44H603	Material Item Pricing	6	MP	EFFF	Effective - From Date	Date	Generic Edit	6	0
57	F44H604	Vendor Assignment	7	VA	EFFF	Effective - From Date	Date	Generic Edit	6	0
58	F44H604W	Vendor Assignment Workfile	10	VW	EFFF	Effective - From Date	Date	Generic Edit	6	0
59	F44H604Z	HB Vendor Assignment Unedited Transaction File	20	SZ	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP75T: Taiwan
60	F75T002	GUI/VAT Number Register - 75T	7	NR	EFFF	Effective - From Date	Date	Generic Edit	6	0
61	F75T0029	GUI/VAT Number Register History - 75T	7	NR	EFFF	Effective - From Date	Date	Generic Edit	6	0
62	F75T003	GUI/VAT Number Segment - 75T	10	NS	EFFF	Effective - From Date	Date	Generic Edit	6	0
63	F75T0039	GUI/VAT Number Segment History - 75T	10	NS	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP76B: Brazil - Reporting System Only
64	F76B3010	Work Table for Item/Part List - 30	12	IP	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP76H: Chile
65	F76H6003	Indirect Costs Selection EPS F1642 - CHI - 41 - 76H	10	I2	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP76V: Venezuela
66	F76V4010	Tributary Unit Setup - 04 - VE	2	IS	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOPF30L: DFM Line Design
67	FF30L002	DFM Bill of Material Master	14	DH	EFFF	Effective - From Date	Date	Generic Edit	6	0
68	FF30L930	DFM Routings	10	LR	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOPH79: CS - Forecasting
69	F7901	Language Master	6	LM	EFFF	Effective - From Date	Date	Generic Edit	6	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

69 columns | 812 | EFFF