	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

162 tables920 | 40

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

162 tables920 | 40