	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 tables812 | 12

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