	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

161 tables910 | 40

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
40: Inventory/OP Base
1	910	F3002	IX	81	15	Bill of Material Master File	Master Files	30: Product Data Management
2	910	F30026	IE	34	3	Item Cost Component Add-Ons	Secondary Master Files	30A: Product Costing	Business Data
3	910	F3003	IR	77	11	Routing Master File	Master Files	30: Product Data Management	Business Data
4	910	F3009	IA	50	1	Job Shop Manufacturing Constants	Constants Files	30: Product Data Management	Business Data
5	910	F3011	IZ	82	3	Bill of Materials Change File	History Files	30: Product Data Management	Business Data
6	910	F3013	CY	55	8	ECO Parts List Detail	Secondary Master Files	30: Product Data Management	Business Data
7	910	F3015	CQ	13	4	Component Locator File	Secondary Master Files	30: Product Data Management	Business Data
8	910	F30UI001	WF	33	1	Component Locators Work File	"T" Work Files	30: Product Data Management	Business Data
9	910	F30UI002	IX	14	3	Bill of Material Structure Analysis Work File	"T" Work Files	30: Product Data Management	Business Data
10	910	F30UI004	WF	71	2	Bill of Material Update Work File	"T" Work Files	30: Product Data Management	Business Data
11	910	F30UI006	IL	28	6	Lot Tracking Work File	Regular Work Files	41: Inventory Management	Business Data
12	910	F3405	MU	7	2	Forecast Consumption Periods	Master Files	34: Requirements Planning	Business Data
13	910	F3462	MB	14	4	Forecast Shipment Summary	Master Files	34: Requirements Planning	Business Data
14	910	F4001Z	SY	149	1	Batch Receiver File - Order Headings	Batch Input Files	42B: Sales Order Entry	Business Data
15	910	F4001Z50	HC	9	1	Batch Receiver File - Order Headings Commissions	Files	42B: Sales Order Entry
16	910	F4001ZTX	RT	9	1	Recurring Order Header Tax Table	Batch Input Files	42B: Sales Order Entry	Business Data
17	910	F40039	DT	54	1	Document Type Master	Secondary Master Files	41: Inventory Management	Business Data
18	910	F40051	RD	70	4	Return Material Authorization	Master Files	42B: Sales Order Entry	Business Data
19	910	F40052	RV	30	2	Return Material Authorization Defaults	Transaction Files	42B: Sales Order Entry	Business Data
20	910	F4006	OA	22	1	Order Address Information	Transaction Files	40: Inventory/OP Base	Business Data
21	910	F4006Z	OY	21	1	Batch Order Receiver - Order Address Information	Batch Input Files	42B: Sales Order Entry	Business Data
22	910	F40070	PF	17	2	Preference Master File	Master Files	42: Sales Management	Business Data
23	910	F40071	CU	13	2	Customer Preference Groups	Secondary Master Files	42: Sales Management	Business Data
24	910	F40072	GI	13	2	Item Preference Groups	Secondary Master Files	42: Sales Management	Business Data
25	910	F40073	HY	33	2	Preference Hierarchy File	Secondary Master Files	42: Sales Management	Business Data
26	910	F4009	CP	50	1	Distribution/Manufacturing Constants	Constants Files	41: Inventory Management	Business Data
27	910	F40095	DL	8	1	Default Locations/Printers	Constants Files	41: Inventory Management	Business Data
28	910	F40096	DQ	3	1	Default Print Queues	Constants Files	41: Inventory Management	Business Data
29	910	F4009T1	CT	10	1	Distribution/Manufacturing Constant Tag Table	Constants Files	41: Inventory Management
30	910	F4011Z	SZ	251	1	Batch Receiver File - Order Details	Batch Input Files	42B: Sales Order Entry	Business Data
31	910	F4011Z60	DC	11	1	Batch Receiver File - Order Details Commissions	Files	42B: Sales Order Entry
32	910	F4011ZTX	ZT	20	1	Recurring Order Detail Tax Table	Batch Input Files	42B: Sales Order Entry	Business Data
33	910	F4012Z	SP	38	1	Batch Receiver File - Destination Quantity	Batch Input Files	42B: Sales Order Entry	Business Data
34	910	F4012ZW	SP	43	1	WF - Destination Quantity	Regular Work Files	42B: Sales Order Entry	Business Data
35	910	F4013	SX	10	1	Order Processing Cross Reference File	Extra Features Files	40: Inventory/OP Base	Business Data
36	910	F4013Z	KS	21	1	Kit Components Batch File	Batch Input Files	42B: Sales Order Entry	Business Data
37	910	F4015	OT	17	2	Order Templates	Transaction Files	40: Inventory/OP Base	Business Data
38	910	F4016	TU	11	3	Print Messages	Extra Features Files	41: Inventory Management	Business Data
39	910	F4017	TV	10	1	Print Message Report Defaults	Extra Features Files	41: Inventory Management	Business Data
40	910	F40203	FS	15	1	Order Activity Rules	Constants Files	40: Inventory/OP Base	Business Data
41	910	F40205	LF	38	1	Line Type Control Constants File	Constants Files	40: Inventory/OP Base	Business Data
42	910	F40241	CD	2	1	UNSPSC Commodity Code	Files	43B: Voucher Match and Landed Cost
43	910	F40241D	CA	9	1	UNSPSC Code Alternate Description	Files	43B: Voucher Match and Landed Cost
44	910	F40243	CR	4	2	Commodity Relationship	Files	43B: Voucher Match and Landed Cost
45	910	F40300R	PM	31	2	Preference Resolution History - Master	Extra Features Files	42: Sales Management	Business Data
46	910	F40301	PT	26	1	Preference Profile - Payment Terms	Extra Features Files	42B: Sales Order Entry
47	910	F40301R	PT	26	2	Preference Resolution Ledger - Payment Terms	Extra Features Files	42B: Sales Order Entry	Business Data
48	910	F40302	PU	26	1	Preference Profile - Unit of Measure	Extra Features Files	42B: Sales Order Entry	Business Data
49	910	F40302R	PU	24	2	Preference Resolution Ledger - Pricing Unit Of Measure	Extra Features Files	42B: Sales Order Entry	Business Data
50	910	F40303	RV	26	1	Preference Profile - Revenue Cost Center	Extra Features Files	42B: Sales Order Entry	Business Data
51	910	F40303R	RV	24	2	Preference Resolution Ledger - Revenue Business Unit	Extra Features Files	42B: Sales Order Entry	Business Data
52	910	F40304	PE	24	1	Preference Profile - End Use	Extra Features Files	42B: Sales Order Entry	Business Data
53	910	F40304R	PE	25	2	Preference Resolution Ledger - End Use	Extra Features Files	42B: Sales Order Entry	Business Data
54	910	F40305	RM	30	1	Preference Profile - Print Messages	Extra Features Files	42: Sales Management	Business Data
55	910	F40305R	RM	26	2	Preference Resolution Ledger - Print Messages	Extra Features Files	42: Sales Management	Business Data
56	910	F40306	SR	31	1	Preference Profile - Inventory Sourcing	Extra Features Files	42: Sales Management	Business Data
57	910	F40307	LA	29	1	Preference Profile - Product Allocations	Extra Features Files	42B: Sales Order Entry	Business Data
58	910	F40308	GS	27	1	Preference Profile - Grade and Potency	Extra Features Files	42B: Sales Order Entry	Business Data
59	910	F40308R	GS	28	2	Preference Resolution Ledger - Grade and Potency	Extra Features Files	42B: Sales Order Entry	Business Data
60	910	F40309	DY	29	1	Preference Profile - Delivery Date	Extra Features Files	42B: Sales Order Entry	Business Data
61	910	F40309R	DY	30	2	Preference Resolution Ledger - Delivery Date	Extra Features Files	42B: Sales Order Entry	Business Data
62	910	F40310	LB	23	1	Preference Profile - Line of Business	Extra Features Files	42B: Sales Order Entry	Business Data
63	910	F40310R	LB	24	2	Preference Resolution Ledger - Line Of Business	Extra Features Files	42B: Sales Order Entry	Business Data
64	910	F40311	P1	23	1	Preference Profile - Price Code 1	Extra Features Files	42B: Sales Order Entry	Business Data
65	910	F40311R	P1	24	2	Preference Resolution Ledger - User Defined Price Code #1	Extra Features Files	42B: Sales Order Entry	Business Data
66	910	F40312	P2	23	1	Preference Profile - Price Code 2	Extra Features Files	42B: Sales Order Entry	Business Data
67	910	F40312R	P2	24	2	Preference Resolution Ledger - User Defined Price Code #2	Extra Features Files	42B: Sales Order Entry	Business Data
68	910	F40313	P3	23	1	Preference Profile - Price Code 3	Extra Features Files	42B: Sales Order Entry	Business Data
69	910	F40313R	P3	24	2	Preference Resolution Ledger - User Defined Price Code #3	Extra Features Files	42B: Sales Order Entry	Business Data
70	910	F40314	PJ	24	1	Preference Profile - Price Adjustment Schedule	Extra Features Files	42B: Sales Order Entry	Business Data
71	910	F40314R	PJ	26	2	Preference Resolution Ledger - Price Adjustment Schedule	Extra Features Files	42B: Sales Order Entry	Business Data
72	910	F40315	PI	24	1	Preference Profile - Invoice Cycling	Extra Features Files	42: Sales Management	Business Data
73	910	F40315R	PI	26	2	Preference Resolution Ledger - Invoice Cycle	Extra Features Files	42: Sales Management	Business Data
74	910	F40316	OP	26	1	Preference Profile - Order Preparation	Extra Features Files	42B: Sales Order Entry	Business Data
75	910	F40316R	OP	27	2	Preference Resolution Ledger - Order Preparation Days	Extra Features Files	42B: Sales Order Entry	Business Data
76	910	F40318R	QC	71	2	Preference Resolution Ledger - Quality Management	Extra Features Files	37: Quality Management	Business Data
77	910	F40320	LP	41	2	Preference Profile - Multi Shipping/Receiving Locations	Extra Features Files	46: Warehouse Management	Business Data
78	910	F40320R	LP	42	3	Preference Resolution Ledger - Multi ShiP/Rec Locations	Extra Features Files	46: Warehouse Management	Business Data
79	910	F40329	DD	28	1	Preference Profile - Document Distribution	Extra Features Files	49: Transportation Management	Business Data
80	910	F40330	DG	31	1	Preference Profile - Document Set	Extra Features Files	49: Transportation Management	Business Data
81	910	F40331	OE	25	1	Preference Profile - Options and Equipment	Extra Features Files	49: Transportation Management	Business Data
82	910	F40332	CF	32	1	Preference Profile - Customer Freight	Extra Features Files	49: Transportation Management	Business Data
83	910	F40333	CA	36	2	Preference Profile - Carrier	Extra Features Files	49: Transportation Management	Business Data
84	910	F40334	MT	32	1	Preference Profile - Mode of Transport	Extra Features Files	49: Transportation Management	Business Data
85	910	F40338	PT	25	1	Preference Profile - Payment Terms (Branch)	Extra Features Files	42B: Sales Order Entry	Business Data
86	910	F40338R	PT	27	2	Preference Resolution Ledger - Payment Terms (Branch)	Extra Features Files	42B: Sales Order Entry	Business Data
87	910	F40339	LA	29	1	Preference Profile - Product Allocations (Branch)	Extra Features Files	42B: Sales Order Entry	Business Data
88	910	F40341	NS	27	1	Preference Profile - Next Order Status	Extra Features Files	42B: Sales Order Entry	Business Data
89	910	F40341R	NS	29	2	Preference Resolution Ledger - Next Order Status	Extra Features Files	42B: Sales Order Entry	Business Data
90	910	F40344	SA	31	1	Preference Profile - Sales Commission	Extra Features Files	42: Sales Management	Business Data
91	910	F40344R	SA	31	2	Preference Resolution Ledger - Sales Commission	Extra Features Files	42B: Sales Order Entry	Business Data
92	910	F40345	CR	24	1	Preference Profile - Customer Currency	Extra Features Files	42B: Sales Order Entry	Business Data
93	910	F40345R	CR	26	2	Preference Resolution Ledger - Customer Currency	Extra Features Files	42B: Sales Order Entry	Business Data
94	910	F40347	RI	26	1	Preference Profile - Pricing UOM (Branch)	Extra Features Files	42B: Sales Order Entry	Business Data
95	910	F40347R	RI	28	2	Preference Resolution Ledger - Pricing UOM (Branch)	Extra Features Files	42B: Sales Order Entry	Business Data
96	910	F40349	RV	26	1	Preference Profile - Revenue Business Unit (Branch)	Extra Features Files	42B: Sales Order Entry	Business Data
97	910	F40349R	RV	28	2	Preference Resolution Ledger - Revenue Bus Unit (Branch)	Extra Features Files	42B: Sales Order Entry	Business Data
98	910	F40350	OQ	28	1	Preference Profiles - Conatiner Deposit/Rental	Extra Features Files	41: Inventory Management	Business Data
99	910	F40500	CC	25	4	Commodity Structure Definitions	Files	40: Inventory/OP Base
100	910	F40510	UC	9	2	UNSPSC and Commodity Structure Relationship	Files	40: Inventory/OP Base
101	910	F40520	SC	9	3	Supplier and Commodity Structure Relationship	Files	40: Inventory/OP Base
102	910	F40530	SX	10	4	Supplier Commodity Structure Cross Reference	Files	40: Inventory/OP Base
103	910	F40540	IC	8	2	Item and Commodity Structure Relationship	Files	40: Inventory/OP Base
104	910	F40551	GL	9	2	G/L Account and Commodity Structure Relationship	Files	40: Inventory/OP Base
105	910	F40711	PD	13	2	Preference Values Definition	Files	45: Advanced Pricing	Business Data
106	910	F40721	PV	15	2	Preference Values Detail	Files	45: Advanced Pricing	Business Data
107	910	F40741	PH	18	1	Preference Adjustment History	Files	40: Inventory/OP Base	Business Data
108	910	F4080	RO	44	8	Related Order Cross Reference Table	Files	31P: Engineer To Order
109	910	F4090	MK	4	1	Distribution/Manufacturing - AAI Record Type	Constants Files	40: Inventory/OP Base	Business Data
110	910	F4091	KF	50	1	Category Code Key Position File	Master Files	40: Inventory/OP Base	Business Data
111	910	F4092	GP	13	1	Group Code Key Definition Table	Master Files	45: Advanced Pricing	Business Data
112	910	F4093	GD	13	1	Item/Customer Group Relationship	Master Files	45: Advanced Pricing	Business Data
113	910	F4094	KI	11	2	Item/Customer Key ID Master File	Master Files	45: Advanced Pricing	Business Data
114	910	F40941	IK	12	2	Item Key ID Master File	Files	45: Advanced Pricing	Business Data
115	910	F40942	CK	12	2	Customer Key ID Master File	Files	45: Advanced Pricing	Business Data
116	910	F40943	OK	10	2	Order Group Key ID Master File	Files	45: Advanced Pricing	Business Data
117	910	F4095	ML	9	1	Distribution/Manufacturing - AAI Values	Constants Files	40: Inventory/OP Base	Business Data
118	910	F40P01	PH	26	3	Promotion Header File	Files	40: Inventory/OP Base	Business Data
119	910	F40P011	PD	46	2	Promotion Deal Detail File	Files	40: Inventory/OP Base	Business Data
120	910	F40UI002	UT	19	1	Supplier History Rebuild -workfile	Regular Work Files	43: Procurement	Business Data
121	910	F40UI00T	PN	29	1	Tax Work File	Regular Work Files	40: Inventory/OP Base	Business Data
122	910	F40UI17	ZG	22	1	Allocation Work File	Regular Work Files	42B: Sales Order Entry	Business Data
123	910	F40UI74	AW	81	1	Price Adjustment History Work File	Regular Work Files	45: Advanced Pricing	Business Data
124	910	F40UI801	ZB	17	2	Generic Error Table	Batch Input Files	40: Inventory/OP Base	Business Data
125	910	F4100	LM	62	6	Location Master	Master Files	41: Inventory Management	Business Data
126	910	F41001	CI	108	2	Inventory Constants	Constants Files	41: Inventory Management	Business Data
127	910	F41002	UM	16	6	Item Units of Measure Conversion Factors	Constants Files	41: Inventory Management	Business Data
128	910	F41003	UC	10	1	Unit of Measure standard conversion	Constants Files	41: Inventory Management	Business Data
129	910	F41011	PK	37	1	Bulk Item Master	Master Files	41B: Bulk Stock Management	Business Data
130	910	F41015	BA	12	2	Item Duplication Work File	Master Files	41: Inventory Management	Business Data
131	910	F41022	PN	24	1	Bulk Depot/Product Information	Master Files	41B: Bulk Stock Management	Business Data
132	910	F4104	IV	30	5	Item Cross Reference File	Extra Features Files	41: Inventory Management	Business Data
133	910	F4106	BP	32	7	Item Base Price File	Master Files	45: Advanced Pricing	Business Data
134	910	F4106NC	SZ	32	1	Base Price Extraction	Files	45: Advanced Pricing	Business Data
135	910	F4108	IO	62	6	Lot Master	Secondary Master Files	41: Inventory Management	Business Data
136	910	F41112	IN	49	2	Item ASOF File	Transaction Files	41: Inventory Management	Business Data
137	910	F41500	PP	62	4	Tank Master File	Master Files	41B: Bulk Stock Management	Business Data
138	910	F41508	PC	24	7	Default Tank Information	Transaction Files	41B: Bulk Stock Management	Business Data
139	910	F4170	I0	8	1	Lot Status Activity Rules	Files	41: Inventory Management	Business Data
140	910	F4171	I1	16	1	Critical Hold Management	Files	41: Inventory Management	Business Data
141	910	F42008	HC	12	2	Order Hold Constants	Constants Files	40: Inventory/OP Base	Business Data
142	910	F4201Z1	SY	145	3	Sales Order Header Unedited Transaction File	Transaction Files	42: Sales Management	Business Data
143	910	F4207	PM	33	2	Price by Item	Extra Features Files	45: Advanced Pricing	Business Data
144	910	F4208	PG	9	2	Price by Customer	Extra Features Files	45: Advanced Pricing	Business Data
145	910	F4209	HO	27	7	Held Orders	Transaction Files	40: Inventory/OP Base	Business Data
146	910	F4211AU	AU	58	1	Sales Order Detail Audit File	History Files	42: Sales Management	Business Data
147	910	F4211DT	DT	58	1	Sales Order Detail Date Tracking File	History Files	42B: Sales Order Entry	Business Data
148	910	F4211Z1	SZ	253	3	Sales Order Detail Unedited Transaction File	Transaction Files	42: Sales Management	Business Data
149	910	F4215	XH	74	7	Shipment Header	Transaction Files	49: Transportation Management	Business Data
150	910	F4217	XI	13	5	Shipment Reference Numbers	Transaction Files	49: Transportation Management	Business Data
151	910	F4220	SW	33	6	Basic Serial Numbers	Extra Features Files	42: Sales Management	Business Data
152	910	F4231	EF	12	2	RT Event Filter Details	Files	42: Sales Management
153	910	F4314	JM	7	1	Sales Order/Purchasing Text Detail Lines	Extra Features Files	40: Inventory/OP Base	Business Data
154	910	F43800	PR	27	1	Summary Voucher Match	Transaction Files	43B: Voucher Match and Landed Cost	Business Data
155	910	F46010	IP	29	2	Item Profile	Secondary Master Files	46: Warehouse Management	Business Data
156	910	F49080	IC	5	1	Invoice Cycle Calculation	Extra Features Files	42: Sales Management	Business Data
157	910	F49085	ID	5	2	Scheduled Invoice Date	Extra Features Files	42: Sales Management	Business Data
158	910	F49190	DS	17	1	Document Definition File (Conversion from World File)	Extra Features Files	49: Transportation Management	Business Data
159	910	F49211	UD	145	4	Sales Order Detail File - Tag File	Extra Features Files	42: Sales Management	Business Data
160	910	F49211Z1	S1	160	3	Sales Order Detail Tag Unedited Transaction File	Extra Features Files	42: Sales Management	Business Data
161	910	F49219	UD	118	1	Sales Order Detail - Tag History File	Extra Features Files	42: Sales Management	Business Data

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

161 tables910 | 40