	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

40 tables920 | 12

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
12: Fixed Assets
1	920	F1200	LN	2	1	Fixed Asset Constants	Constants Files	12: Fixed Assets	Business Data
2	920	F12002	FD	25	1	Default Accounting Constants	Constants Files	12: Fixed Assets	Business Data
3	920	F12003	FF	22	1	Default Depreciation Constants	Constants Files	12: Fixed Assets	Business Data
4	920	F1201	FA	106	13	Asset Master File	Master Files	12: Fixed Assets	Business Data
5	920	F1201D	LJ	6	2	Asset Master - Alternate Description	Master Files	12: Fixed Assets	Business Data
6	920	F1201P	FA	106	1	Asset Master Purge Table	Master Files	12: Fixed Assets	Business Data
7	920	F1201Z1	FA	126	1	Unedited Asset Master Transactions	Transaction Files	12: Fixed Assets	Business Data
8	920	F1202	FL	52	8	Asset Account Balances File	Balance Files	12: Fixed Assets	Business Data
9	920	F1202P	FL	52	1	Asset Account Balances Purge Table	Balance Files	12: Fixed Assets	Business Data
10	920	F1204	FM	33	8	Location Tracking Table	History Files	13: Plant/Equipment Management	Business Data
11	920	F1204P	FM	33	1	Location Tracking Purge Table	History Files	13: Plant/Equipment Management	Business Data
12	920	F1205	FT	28	1	Equipment Messages	History Files	13: Plant/Equipment Management	Business Data
13	920	F1205P	FT	28	1	Equipment Messages Purge Table	History Files	13: Plant/Equipment Management	Business Data
14	920	F1208	FP	15	1	Units of Production Schedule Master File	Extra Features Files	12: Fixed Assets	Business Data
15	920	F12090	F2	10	1	Asset Mgt Supplemental Database Types	Extra Features Files	12: Fixed Assets	Business Data
16	920	F12092	F3	11	1	Fixed Assets Supplemental Data Codes Type	Extra Features Files	12: Fixed Assets	Business Data
17	920	F1210	FB	8	1	Location History Text	History Files	13: Plant/Equipment Management	Business Data
18	920	F1210W	FB	8	1	WF - Location History - Log Detail	Regular Work Files	13: Plant/Equipment Management	Business Data
19	920	F1212	FY	8	3	Parent History	History Files	13: Plant/Equipment Management	Business Data
20	920	F1212P	FY	8	1	Parent History Purge Table	History Files	13: Plant/Equipment Management	Business Data
21	920	F12141	DT	7	2	Disposal Account Rule Table	Constants Files	12: Fixed Assets	Business Data
22	920	F1215	GV	15	1	Specification Cross Reference	Constants Files	13: Plant/Equipment Management	Business Data
23	920	F1216	GZ	18	1	Specification Data	Secondary Master Files	13: Plant/Equipment Management	Business Data
24	920	F1217	WR	71	2	Equipment Master Extension	Secondary Master Files	17C: Call Management	Business Data
25	920	F1217P	WR	71	2	Equipment Master Extension Purge Table	Secondary Master Files	17C: Call Management	Business Data
26	920	F1217Z1	WR	72	1	Unedited Equipment Tag Transactions	Transaction Files	17C: Call Management	Business Data
27	920	F1217Z2	WR	86	1	Unedited Equipment Tag Transactions	Transaction Files	17C: Call Management	Business Data
28	920	F12841	RI	6	2	Revaluation Index	Secondary Master Files	12: Fixed Assets	Business Data
29	920	F12851	LU	26	1	Depreciation Rules	Constants Files	12: Fixed Assets	Business Data
30	920	F12851D	LU	26	1	Demo Depreciation Rules	Install Files	12: Fixed Assets	Business Data
31	920	F12852	LV	23	2	Annual Depreciation Rules	Constants Files	12: Fixed Assets	Business Data
32	920	F12852D	LV	23	1	Demo Annual Depreciation Rules	Install Files	12: Fixed Assets	Business Data
33	920	F12853	LW	17	1	Depreciation Formulas	Constants Files	12: Fixed Assets	Business Data
34	920	F12853D	LW	17	1	Demo Depreciation Formulas	Install Files	12: Fixed Assets	Business Data
35	920	F12854	LZ	16	1	Depreciation Period Spread Rules	Constants Files	12: Fixed Assets	Business Data
36	920	F12911ER	GL	20	1	Post G/L to FA Exceptions Work File	Regular Work Files	12: Fixed Assets	Business Data
37	920	F1301	FG	23	5	Equipment Rates	Extra Features Files	13: Plant/Equipment Management	Business Data
38	920	F1301P	FG	23	1	Equipment Rates Purge Table	Extra Features Files	13: Plant/Equipment Management	Business Data
39	920	F1391	F8	3	1	Equipment Category Code Mapping	Constants Files	13: Plant/Equipment Management	Business Data
40	920	F1392	GF	2	2	Supplemental Data Cross Ref	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

40 tables920 | 12