	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

45 tables920 | 45

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

45 tables920 | 45