	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

80 columns | 920 | 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	F3003T	Routing Tag File - not used in B9, obsolete in B10	6	IR	EFFF	Effective - From Date	Date	Generic Edit	6	0
13	F3003Z1	Routing Transactions File	24	SZ	EFFF	Effective - From Date	Date	Generic Edit	6	0
14	F30UI008	Bill of Material Comparison Work File	15	IJ	EFFF	Effective - From Date	Date	Generic Edit	6	0
15	F30UI014	BOM Header Work File for BI	8	BH	EFFF	Effective - From Date	Date	Generic Edit	6	0
16	F30UI015	BOM Item Fact Work File for BI	12	BD	EFFF	Effective - From Date	Date	Generic Edit	6	0
17	F30UI016	BOM Explosion Work File for BI	19	BE	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP31: Shop Floor Control
18	F3109	Line/Item Relationship Master	10	IP	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP32: Configuration Management
19	F3281	Rules Table Definition	7	RT	EFFF	Effective - From Date	Date	Generic Edit	6	0
20	F3282	Configured Item/Rules Table Cross Reference	5	RK	EFFF	Effective - From Date	Date	Generic Edit	6	0
21	F32821	Rules Table Value Definition	6	RL	EFFF	Effective - From Date	Date	Generic Edit	6	0
22	F3283	Rules Table Detail	26	RD	EFFF	Effective - From Date	Date	Generic Edit	6	0
23	F3291	Configured Item Segments	6	KW	EFFF	Effective - From Date	Date	Generic Edit	6	0
24	F3292	Cross Segment Editing Rules	7	KU	EFFF	Effective - From Date	Date	Generic Edit	6	0
25	F32921	Cross Segment Editing Rules - Values	7	KX	EFFF	Effective - From Date	Date	Generic Edit	6	0
26	F32922	Cross Segment Editing Rules - Range	8	KV	EFFF	Effective - From Date	Date	Generic Edit	6	0
27	F3293	Assembly Inclusions Rules	34	KY	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP33: Capacity Planning
28	F3303	Capacity Resource Profile	11	CT	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP34: Requirements Planning
29	F3403	Branch Relationships Master File	9	MP	EFFF	Effective - From Date	Date	Generic Edit	6	0
30	F3404	Co-Products Planning/Costing Table	5	PM	EFFF	Effective - From Date	Date	Generic Edit	6	0
31	F43211	Supplier Schedule Master File	7	SS	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP34A: Advanced Planning & Scheduling
32	F34A120	Routing Master Resource Table	6	N0	EFFF	Effective - From Date	Date	Generic Edit	6	0
33	F34A180	Routing Master Resource Set	6	RR	EFFF	Effective - From Date	Date	Generic Edit	6	0
34	F34A190	Routing Master Resource and Set XRef	6	RD	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP34X: In-Memory Planning Advisor
35	F34X310W	Planning Advisor BOM Component Detail Table	31	PD	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP36: Forecasting
36	F34007	Forecast Prices	5	FH	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP37: Quality Management
37	F3701	Test Definitions Master File	6	QA	EFFF	Effective - From Date	Date	Generic Edit	6	0
38	F3702	Specifications Definitions Master File	4	QS	EFFF	Effective - From Date	Date	Generic Edit	6	0
39	F37021	Specifications Detail File	4	QD	EFFF	Effective - From Date	Date	Generic Edit	6	0
40	F3711	Test Results	41	TR	EFFF	Effective - From Date	Date	Generic Edit	6	0
41	F3711Z1	Test Results Unedited Transaction Table	54	SZ	EFFF	Effective - From Date	Date	Generic Edit	6	0
42	F37900	Certificate of Analysis (COA) Extract	41	TR	EFFF	Effective - From Date	Date	Generic Edit	6	0
43	F40318	Preference Profile - Quality Management	14	QC	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP40: Inventory/OP Base
44	F3002	Bill of Material Master File	18	IX	EFFF	Effective - From Date	Date	Generic Edit	6	0
45	F3003	Routing Master File	11	IR	EFFF	Effective - From Date	Date	Generic Edit	6	0
46	F3011	Bill of Materials Change File	18	IZ	EFFF	Effective - From Date	Date	Generic Edit	6	0
47	F3013	ECO Parts List Detail	23	CY	EFFF	Effective - From Date	Date	Generic Edit	6	0
48	F3015	Component Locator File	4	CQ	EFFF	Effective - From Date	Date	Generic Edit	6	0
49	F40318R	Preference Resolution Ledger - Quality Management	16	QC	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP41: Inventory Management
50	F4101A	Item File	7	IM	EFFF	Effective - From Date	Date	Generic Edit	6	0
51	F4101B	Item Master Bulk Data	7	IM	EFFF	Effective - From Date	Date	Generic Edit	6	0
52	F4101C	Item Category Codes	7	IM	EFFF	Effective - From Date	Date	Generic Edit	6	0
53	F4101F	Item Customer Service Data	7	IM	EFFF	Effective - From Date	Date	Generic Edit	6	0
54	F4101G	Item Branch Quantities	7	IB	EFFF	Effective - From Date	Date	Generic Edit	6	0
55	F4101M	Item Manufacturing Data	7	IM	EFFF	Effective - From Date	Date	Generic Edit	6	0
56	F4101P	Item Master Packaging	7	IM	EFFF	Effective - From Date	Date	Generic Edit	6	0
57	F4101S	Item Master Shipping Data	7	IM	EFFF	Effective - From Date	Date	Generic Edit	6	0
58	F4101W	Item Profile Data	7	IM	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP43: Procurement
59	F41291	Item Cost Components	17	IG	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP44H: Homebuilder Management
60	F4459	Material Item Pricing (World)	8	JL	EFFF	Effective - From Date	Date	Generic Edit	6	0
61	F4461	Option Master (World)	31	JN	EFFF	Effective - From Date	Date	Generic Edit	6	0
62	F44H603	Material Item Pricing	6	MP	EFFF	Effective - From Date	Date	Generic Edit	6	0
63	F44H604	Vendor Assignment	7	VA	EFFF	Effective - From Date	Date	Generic Edit	6	0
64	F44H604W	Vendor Assignment Workfile	10	VW	EFFF	Effective - From Date	Date	Generic Edit	6	0
65	F44H604Z	HB Vendor Assignment Unedited Transaction File	20	SZ	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP74U: United Kingdom Localizations
66	F74U420A	SPC Application Amount Drill Down - UK - 43	16	PA	EFFF	Effective - From Date	Date	Generic Edit	6	0
67	F74U421B	Application Approval Delegates - UK - 43	3	AD	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP75I: India
68	F75I791	Item/Supplier Cost Components - IND - 43B	18	IS	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP75T: Taiwan
69	F75T002	GUI/VAT Number Register - 75T	7	NR	EFFF	Effective - From Date	Date	Generic Edit	6	0
70	F75T0029	GUI/VAT Number Register History - 75T	7	NR	EFFF	Effective - From Date	Date	Generic Edit	6	0
71	F75T003	GUI/VAT Number Segment - 75T	10	NS	EFFF	Effective - From Date	Date	Generic Edit	6	0
72	F75T0039	GUI/VAT Number Segment History - 75T	10	NS	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP76B: Brazil
73	F76B0765	Item Change Track - BRA - 76B	2	CT	EFFF	Effective - From Date	Date	Generic Edit	6	0
74	F76B3010	Work Table for Item/Part List - 30	12	IP	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP76H: Chile
75	F76H6003	Indirect Costs Selection EPS F1642 - CHI - 41 - 76H	10	I2	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOP76V: Venezuela
76	F76V4010	Tributary Unit Setup - 04 - VE	2	IS	EFFF	Effective - From Date	Date	Generic Edit	6	0
77	F76V410	Tributary Unit Setup - VEN - 04	2	TU	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOPF30L: DFM Line Design
78	FF30L002	DFM Bill of Material Master	14	DH	EFFF	Effective - From Date	Date	Generic Edit	6	0
79	FF30L930	DFM Routings	10	LR	EFFF	Effective - From Date	Date	Generic Edit	6	0
TOPH79: Translation Tools
80	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

80 columns | 920 | EFFF