	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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

163 tables812 | 40

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

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

163 tables812 | 40