	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

25 tables812 | 34

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
34: Requirements Planning
1	812	F34004	MG	4	3	Demand/Supply Inclusion Rules	Constants Files	34: Requirements Planning	AS400 Coexistence Tables
2	812	F34006	SJ	5	3	Forecast Summary Work File	Work Files	36: Forecasting	AS400 Coexistence Tables
3	812	F3403	MP	21	3	Branch Relationships Master File	Master Files	34: Requirements Planning	AS400 Coexistence Tables
4	812	F3404	PM	13	2	Co-Products Planning/Costing Table	Master Files	34: Requirements Planning	AS400 Coexistence Tables
5	812	F3406	CR	10	1	Customer Address Relationship	Files	34: Requirements Planning
6	812	F3411	MM	31	10	MPS/MRP/DRP Message File	Transaction Files	34: Requirements Planning	AS400 Coexistence Tables
7	812	F3412	MW	17	7	MPS/MRP/DRP Lower Level Requirements File	Transaction Files	34: Requirements Planning	AS400 Coexistence Tables
8	812	F3413	MR	5	2	MPS/MRP/DRP Summary File	Transaction Files	34: Requirements Planning	AS400 Coexistence Tables
9	812	F3420	MS	3	1	Semphore Value Table	Transaction Files	34: Requirements Planning	No
10	812	F3430	MV	14	2	Vendor Schedule Quantity File	Transaction Files	34: Requirements Planning	AS400 Coexistence Tables
11	812	F3435	MC	27	2	Vendor Schedule Commitment File	Transaction Files	34: Requirements Planning	Business Data
12	812	F3440	MH	26	2	Vendor Schedule History File	Transaction Files	34: Requirements Planning	Business Data
13	812	F3450	MA	28	2	Adhoc Vendor Schedule File	Transaction Files	34: Requirements Planning	Business Data
14	812	F3460	MF	20	4	Forecast File	Master Files	34: Requirements Planning	AS400 Coexistence Tables
15	812	F34A10	N0	50	1	Numetrix Integration Constants	Constants Files	34: Requirements Planning	No
16	812	F34A11	N1	15	1	Numetrix Integration File Definition	Constants Files	34: Requirements Planning	No
17	812	F34A70	OW	8	2	Last Outbound Work Order Table	Files	34: Requirements Planning
18	812	F34UI003	M8	65	1	MPS Time Series User Index	"T" Work Files	34: Requirements Planning	No
19	812	F34UI004	M8	13	1	MPS Net Change User Index	"T" Work Files	34: Requirements Planning	No
20	812	F34UI005	F5	7	4	MRP Orders/Requirements User Index-Process Item	"T" Work Files	34: Requirements Planning	No
21	812	F34UI006	W6	6	1	MRP Co/By Product Net Quantity User Index	"T" Work Files	34: Requirements Planning	No
22	812	F4321	PB	51	1	Supplier Schedule Master File	Secondary Master Files	34: Requirements Planning	AS400 Coexistence Tables
23	812	F43211	SS	13	1	Supplier Schedule Master File	Secondary Master Files	34: Requirements Planning	AS400 Coexistence Tables
24	812	F43213	VP	26	2	SRS Ship Dates	Secondary Master Files	34: Requirements Planning	No
25	812	F4321T	PB	12	1	Supplier Schedule Master Tag File	Secondary Master Files	34: Requirements Planning	No

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

25 tables812 | 34