	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 | 13

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
13: Plant/Equipment Management
1	920	F1206	FH	10	1	Equipment License Master	Secondary Master Files	13: Plant/Equipment Management	Business Data
2	920	F1206P	FH	10	1	Equipment License Master Purge Table	Secondary Master Files	13: Plant/Equipment Management	Business Data
3	920	F1207	FW	66	6	Maintenance Schedule File	Master Files	13: Plant/Equipment Management	Business Data
4	920	F12071	FZ	76	1	Equipment PM Schedule (Model)	Secondary Master Files	13: Plant/Equipment Management	Business Data
5	920	F1207P	FW	66	1	Maintenance Schedule Purge Table	Master Files	13: Plant/Equipment Management	Business Data
6	920	F12120Z1	SZ	34	2	Unedited Meter Reading Transactions	Batch Input Files	13: Plant/Equipment Management	Business Data
7	920	F12121	ET	15	2	Equipment Templates	Master Files	13: Plant/Equipment Management
8	920	F12122	EL	9	2	Equipment Template Listing	Master Files	13: Plant/Equipment Management
9	920	F1300	F9	10	1	Equipment Constants	Constants Files	13: Plant/Equipment Management	Business Data
10	920	F13017	PL	46	4	Equipment Parts List	Files	13: Plant/Equipment Management	Business Data
11	920	F1302	FK	29	1	Rental Rules	Extra Features Files	13: Plant/Equipment Management	Business Data
12	920	F1303	FJ	12	1	Billing Exception Days	Extra Features Files	13: Plant/Equipment Management	Business Data
13	920	F1304	FN	29	4	Equipment Location Billing	Transaction Files	13: Plant/Equipment Management	Business Data
14	920	F1305	FV	10	1	Equipment Distribution Rules	Extra Features Files	13: Plant/Equipment Management	Business Data
15	920	F1306	F5	16	1	Meter Reading Estimates	Extra Features Files	13: Plant/Equipment Management	Business Data
16	920	F1306P	F5	16	1	Meter Reading Estimates Purge Table	Extra Features Files	13: Plant/Equipment Management	Business Data
17	920	F1307	F1	22	4	Status History File	History Files	13: Plant/Equipment Management	Business Data
18	920	F1307P	F1	22	1	Status History Purge Table	History Files	13: Plant/Equipment Management	Business Data
19	920	F1308	F0	7	2	Equipment Routes Table	Secondary Master Files	13: Plant/Equipment Management	Business Data
20	920	F1308P	F0	7	1	Equipment Routes Purge Table	Secondary Master Files	13: Plant/Equipment Management	Business Data
21	920	F13411	RX	43	2	PM Projections	History Files	13: Plant/Equipment Management	Business Data
22	920	F1390	FV	6	1	Equipment Rate Code Definition	Extra Features Files	13: Plant/Equipment Management	Business Data
23	920	F13907	FC	7	1	Associated Service Types	Extra Features Files	13: Plant/Equipment Management	Business Data
24	920	F13907P	FC	7	1	Associated Service Types Purge Table	Extra Features Files	13: Plant/Equipment Management	Business Data
25	920	F1393	GO	28	1	Maintenance Rules	Constants Files	13: Plant/Equipment Management	Business Data
26	920	F3111IGS	IG	12	1	WO Parts for IGS Integration	Files	13: Plant/Equipment Management
27	920	F4829	DL	17	1	Work Order Delivery Information	Files	13: Plant/Equipment Management	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 | 13