	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

63 columns | 920 | EFFT

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP13: Plant/Equipment Management
1	F13017	Equipment Parts List	18	PL	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
TOP16: Profit Management (EPS)
2	F1610	Cost Calculation Definitions	64	CD	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
TOP17C: Call Management
3	F1755	Case Master	168	ZA	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
TOP30: Product Data Management
4	F3002Z1	Bill of Material Transaction File	32	SZ	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
5	F3003Z1	Routing Transactions File	25	SZ	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
6	F30UI008	Bill of Material Comparison Work File	16	IJ	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
7	F30UI014	BOM Header Work File for BI	9	BH	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
8	F30UI015	BOM Item Fact Work File for BI	13	BD	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
9	F30UI016	BOM Explosion Work File for BI	20	BE	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
TOP31: Shop Floor Control
10	F3109	Line/Item Relationship Master	11	IP	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
TOP32: Configuration Management
11	F3281	Rules Table Definition	8	RT	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
12	F3282	Configured Item/Rules Table Cross Reference	6	RK	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
13	F32821	Rules Table Value Definition	7	RL	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
14	F3283	Rules Table Detail	27	RD	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
15	F3291	Configured Item Segments	7	KW	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
16	F3292	Cross Segment Editing Rules	8	KU	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
17	F32921	Cross Segment Editing Rules - Values	8	KX	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
18	F32922	Cross Segment Editing Rules - Range	9	KV	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
19	F3293	Assembly Inclusions Rules	35	KY	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
TOP33: Capacity Planning
20	F3303	Capacity Resource Profile	12	CT	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
TOP34: Requirements Planning
21	F3403	Branch Relationships Master File	10	MP	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
22	F3404	Co-Products Planning/Costing Table	6	PM	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
23	F43211	Supplier Schedule Master File	8	SS	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
TOP34X: In-Memory Planning Advisor
24	F34X310W	Planning Advisor BOM Component Detail Table	32	PD	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
TOP36: Forecasting
25	F34007	Forecast Prices	6	FH	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
TOP37: Quality Management
26	F3701	Test Definitions Master File	4	QA	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
27	F3702	Specifications Definitions Master File	6	QS	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
28	F37021	Specifications Detail File	5	QD	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
29	F3711	Test Results	42	TR	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
30	F3711Z1	Test Results Unedited Transaction Table	55	SZ	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
31	F37900	Certificate of Analysis (COA) Extract	42	TR	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
32	F40318	Preference Profile - Quality Management	15	QC	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
TOP40: Inventory/OP Base
33	F3002	Bill of Material Master File	19	IX	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
34	F3003	Routing Master File	12	IR	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
35	F3011	Bill of Materials Change File	19	IZ	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
36	F3013	ECO Parts List Detail	24	CY	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
37	F3015	Component Locator File	5	CQ	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
38	F40318R	Preference Resolution Ledger - Quality Management	17	QC	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
TOP41: Inventory Management
39	F4101A	Item File	4	IM	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
40	F4101B	Item Master Bulk Data	4	IM	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
41	F4101C	Item Category Codes	4	IM	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
42	F4101F	Item Customer Service Data	4	IM	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
43	F4101G	Item Branch Quantities	4	IB	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
44	F4101M	Item Manufacturing Data	4	IM	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
45	F4101P	Item Master Packaging	4	IM	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
46	F4101S	Item Master Shipping Data	4	IM	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
47	F4101W	Item Profile Data	4	IM	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
48	F4101Z1	F4101 Item Master Unedited Transaction Table	193	SZ	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
49	F4101Z1A	F4101 Detail Item Master Unedited Transaction	113	SZ	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
TOP43: Procurement
50	F41291	Item Cost Components	18	IG	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
TOP74U: United Kingdom Localizations
51	F74U420A	SPC Application Amount Drill Down - UK - 43	17	PA	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
52	F74U421B	Application Approval Delegates - UK - 43	4	AD	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
53	F74U4321	Requisition Template Answers - UK - 43	9	RA	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
TOP75I: India
54	F75I791	Item/Supplier Cost Components - IND - 43B	19	IS	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
TOP75T: Taiwan
55	F75T002	GUI/VAT Number Register - 75T	8	NR	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
56	F75T0029	GUI/VAT Number Register History - 75T	8	NR	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
57	F75T003	GUI/VAT Number Segment - 75T	11	NS	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
58	F75T0039	GUI/VAT Number Segment History - 75T	11	NS	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
TOP76B: Brazil
59	F76B3010	Work Table for Item/Part List - 30	13	IP	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
TOP76V: Venezuela
60	F76V4010	Tributary Unit Setup - 04 - VE	3	IS	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
61	F76V410	Tributary Unit Setup - VEN - 04	3	TU	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
TOPF30L: DFM Line Design
62	FF30L002	DFM Bill of Material Master	15	DH	EFFT	Effective - Thru Date	Date	Generic Edit	6	0
63	FF30L930	DFM Routings	11	LR	EFFT	Effective - Thru 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

63 columns | 920 | EFFT