	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

43 tables812 | 45

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
45: Advanced Pricing
1	812	F4070	SN	22	8	Price Adjustment Schedule	Master Files	45: Advanced Pricing	AS400 Coexistence Tables
2	812	F4070P	SN			Price Adjustment Schedule Purge	Master Files	45: Advanced Pricing	Business Data
3	812	F4071	AT	62	2	Price Adjustment Type	Master Files	45: Advanced Pricing	AS400 Coexistence Tables
4	812	F4071P	AT			Price Adjustment Type Purge	Master Files	45: Advanced Pricing	Business Data
5	812	F4072	AD	37	7	Price Adjustment Detail	Master Files	45: Advanced Pricing	AS400 Coexistence Tables
6	812	F4072P	AD			Price Adjustment Detail Purge	Master Files	45: Advanced Pricing	Business Data
7	812	F4072W	AD	40	2	Price Adjustment Detail Work File	Master Files	45: Advanced Pricing	Business Data
8	812	F4073	FG	23	3	Free Goods Master File	Master Files	45: Advanced Pricing	AS400 Coexistence Tables
9	812	F4073P	FG			Free Goods Master File Purge	Master Files	45: Advanced Pricing	Business Data
10	812	F4075	VB	12	3	Price Variable Table	Master Files	45: Advanced Pricing	AS400 Coexistence Tables
11	812	F4076	FM	8	3	Price Formula Master	Master Files	45: Advanced Pricing	AS400 Coexistence Tables
12	812	F4077	RT	31	5	Rebate Thresholds	Master Files	45: Advanced Pricing	AS400 Coexistence Tables
13	812	F4077P	RT			Rebate Thresholds Purge	Master Files	45: Advanced Pricing	Business Data
14	812	F4078	RH	33	2	Rebate Transaction Summary	Transaction Files	45: Advanced Pricing	AS400 Coexistence Tables
15	812	F4079	SV	36	5	Rebate Transaction Detail	Transaction Files	45: Advanced Pricing	AS400 Coexistence Tables
16	812	F4094TEM	TC	13	3	ICID Conversion X-Ref	Files	45: Advanced Pricing	Business Data
17	812	F40UI84	XR	7	1	Orders Affected by Price Change (Work-file)	Work Files	45: Advanced Pricing	No
18	812	F4501	MS	14	2	Master Schedule Adjustment	Master Files	45: Advanced Pricing	No
19	812	F4502	FG	13	1	Free Goods Catalog	Files	45: Advanced Pricing	Business Data
20	812	F4510	PW	16	6	Price Workbench Query Header	Files	45: Advanced Pricing
21	812	F4511W	AP	99	6	Pricing Structure View	Files	45: Advanced Pricing	Business Data
22	812	F4550	BH	13	1	Basket Master Header	Files	45: Advanced Pricing	Business Data
23	812	F4551	BD	18	2	Basket Master Detail	Files	45: Advanced Pricing	Business Data
24	812	F45510	SH	12	1	Search Agent Directives Header	Files	45: Advanced Pricing	Business Data
25	812	F45511	SD	12	1	Search Agent Directives Detail	Files	45: Advanced Pricing	Business Data
26	812	F45511W	SW	11	1	Search Agent Directives Work File	Files	45: Advanced Pricing	Business Data
27	812	F45520	PH	29	1	Price List Header	Files	45: Advanced Pricing	Business Data
28	812	F45521	PD	29	2	Price List Detail	Files	45: Advanced Pricing	Business Data
29	812	F45522	PL	10	2	Price List Level-Break Pattern	Files	45: Advanced Pricing	Business Data
30	812	F45523	PC	9	3	Price List Columns Group Pattern	Files	45: Advanced Pricing	Business Data
31	812	F45524	PI	10	2	Price List Item Selection	Files	45: Advanced Pricing	Business Data
32	812	F45715	AB	45	2	Adjustment Balances	Balance Files	45: Advanced Pricing	No
33	812	F4572	XR	30	4	Live Promotions X-Reference by Cost Type	Files	45: Advanced Pricing	No
34	812	F4572Z1	LP	50	1	Live Promotions Interface - Inbound / Outbound	Files	45: Advanced Pricing	No
35	812	F4572ZP	PG	50	1	Purge Live Promotions Interface	Files	45: Advanced Pricing	No
36	812	F4573	RF	11	1	Free Goods Reference File	Transaction Files	45: Advanced Pricing	AS400 Coexistence Tables
37	812	F4574	KR	97	8	Key Reference Table	Transaction Files	45: Advanced Pricing	No
38	812	F4575	AH	83	1	Ship and Debit History	Transaction Files	45: Advanced Pricing	No
39	812	F4575TMP	AH	85	1	Ship and Debit History - Temp Table	Transaction Files	42: Sales Management	Business Data
40	812	F4576	AC	88	1	Ship and Debit Claims	Master Files	45: Advanced Pricing	No
41	812	F4576TMP	AC	88	1	Ship and Debit Claims- Temp Table	Master Files	42: Sales Management	Business Data
42	812	F4576Z1	Z1	158	1	Ship and Debit Claims Unedited Transaction Table	Transaction Files	45: Advanced Pricing	No
43	812	F4580	MX	11	2	Price Matrix Definition	Files	45: Advanced Pricing

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

43 tables812 | 45