	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

22 tables812 | 10

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
10: Financial Reporting
1	812	F0050B	MA	49	1	Business Unit Structure Build File	Extra Features Files	10: Financial Reporting	AS400 Coexistence Tables
2	812	F10005	GO	10	1	User Defined Code Control File	Extra Features Files	10: Financial Reporting	AS400 Coexistence Tables
3	812	F1001	GP	38	5	Multi-Site Consolidation Transfer File Header	History Files	10: Financial Reporting	AS400 Coexistence Tables
4	812	F1001Z1	IA	51	1	Unedited MSC Interoperability Header Table	Extra Features Files	10: Financial Reporting	No
5	812	F1002	GQ	45	5	Multi-Site Consolidation Transfer File	Balance Files	10: Financial Reporting	AS400 Coexistence Tables
6	812	F1002Z1	SZ	57	1	Unedited MSC Interoperability Table	Batch Input Files	10: Financial Reporting	No
7	812	F1003	GR	38	3	Multi-Site Consolidation Transfer File - Category Codes	Extra Features Files	10: Financial Reporting	AS400 Coexistence Tables
8	812	F100901	FR	32	2	Level of Detail	Extra Features Files	10: Financial Reporting	AS400 Coexistence Tables
9	812	F1017	CS	14	2	Consolidation Specifications	Extra Features Files	10: Financial Reporting	AS400 Coexistence Tables
10	812	F10430	CF	38	3	Multi-Site Consolidation - Account Structure	Extra Features Files	10: Financial Reporting	AS400 Coexistence Tables
11	812	F10430A	CG	27	1	Account Structure Definition	Extra Features Files	10: Financial Reporting	AS400 Coexistence Tables
12	812	F10470	CS	23	2	Consolidation Specifications (OW)	Extra Features Files	10: Financial Reporting	No
13	812	F10471	ER	26	1	Elimination Rules (OW)	Extra Features Files	10: Financial Reporting	No
14	812	F10520	CF	14	2	Statement of Cash Flow Rules	Files	10: Financial Reporting
15	812	F10909	G1	9	1	Object/Subsidiary Control Table	Extra Features Files	10: Financial Reporting	AS400 Coexistence Tables
16	812	F10UI001	CF	41	6	Account Structure Build Workfile	Work Files	10: Financial Reporting	No
17	812	F10UI002	BU	38	2	Dynamically Created Business Units	Work Files	10: Financial Reporting	No
18	812	F10UI003	AC	33	2	Dynamically Created Accounts	Work Files	10: Financial Reporting	No
19	812	F10UI005	SR	31	1	Organization Structure Report Work Table	Work Files	10: Financial Reporting	No
20	812	F10UI006	GE	36	4	MSC - F1002 Elimination Work File	Work Files	10: Financial Reporting	No
21	812	F10UI007	MC	6	2	Business Unit Structure Search Form Work Table	Work Files	10: Financial Reporting	No
22	812	F10UI520	CW	9	1	Cash Flow Statement Worktable	Files	10: Financial Reporting

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

22 tables812 | 10