	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

27 tables920 | 34

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
34: Requirements Planning
1	920	F34004	MG	4	3	Demand/Supply Inclusion Rules	Constants Files	34: Requirements Planning	Business Data
2	920	F34006	SJ	5	3	Forecast Summary Work File	Work Files	36: Forecasting	Business Data
3	920	F3403	MP	21	3	Branch Relationships Master File	Master Files	34: Requirements Planning	Business Data
4	920	F3404	PM	13	2	Co-Products Planning/Costing Table	Master Files	34: Requirements Planning	Business Data
5	920	F3406	CR	10	1	Customer Address Relationship	Files	34: Requirements Planning
6	920	F3411	MM	33	10	MPS/MRP/DRP Message File	Transaction Files	34: Requirements Planning	Business Data
7	920	F3412	MW	18	7	MPS/MRP/DRP Lower Level Requirements File	Transaction Files	34: Requirements Planning	Business Data
8	920	F3413	MR	5	2	MPS/MRP/DRP Summary File	Transaction Files	34: Requirements Planning	Business Data
9	920	F3420	MS	3	1	Semphore Value Table	Transaction Files	34: Requirements Planning	Business Data
10	920	F3430	MV	16	2	Vendor Schedule Quantity File	Transaction Files	34: Requirements Planning	Business Data
11	920	F3435	MC	29	2	Vendor Schedule Commitment File	Transaction Files	34: Requirements Planning	Business Data
12	920	F3440	MH	26	2	Vendor Schedule History File	Transaction Files	34: Requirements Planning	Business Data
13	920	F34401	PN	40	2	Production Number Master File	Files	34: Requirements Planning
14	920	F34401T	PN	11	2	Production Number Master Tag File	Files	34: Requirements Planning
15	920	F34402	PT	20	2	Production Number Structure File	Files	34: Requirements Planning
16	920	F3450	MA	30	2	Adhoc Vendor Schedule File	Transaction Files	34: Requirements Planning	Business Data
17	920	F3460	MF	22	4	Forecast File	Master Files	34: Requirements Planning	Business Data
18	920	F3460SW	FS	8	1	Forecast Summary Work Table	Files	36: Forecasting
19	920	F34A70	OW	8	2	Last Outbound Work Order Table	Files	34: Requirements Planning
20	920	F34UI003	M8	65	1	MPS Time Series User Index	"T" Work Files	34: Requirements Planning	Business Data
21	920	F34UI004	M8	13	1	MPS Net Change User Index	"T" Work Files	34: Requirements Planning	Business Data
22	920	F34UI005	F5	7	4	MRP Orders/Requirements User Index-Process Item	"T" Work Files	34: Requirements Planning	Business Data
23	920	F34UI006	W6	6	1	MRP Co/By Product Net Quantity User Index	"T" Work Files	34: Requirements Planning	Business Data
24	920	F4321	PB	51	1	Supplier Schedule Master File	Secondary Master Files	34: Requirements Planning	Business Data
25	920	F43211	SS	13	1	Supplier Schedule Master File	Secondary Master Files	34: Requirements Planning	Business Data
26	920	F43213	VP	26	2	SRS Ship Dates	Secondary Master Files	34: Requirements Planning	Business Data
27	920	F4321T	PB	12	1	Supplier Schedule Master Tag File - Used for Upgrade from Xe	Secondary Master Files	89: Conversion Programs	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

27 tables920 | 34