	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 | 79A

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report
79A: Greenhouse Gas Accounting
1	920	F79A02	GS	18	2	GHG Supplier	Files	79A: Greenhouse Gas Accounting
2	920	F79A03	GD	31	5	GHG Source	Files	79A: Greenhouse Gas Accounting
3	920	F79A039	GD	32	2	GHG Source Audit	Files	79A: Greenhouse Gas Accounting
4	920	F79A039T	AT	8	2	GHG Sources Audit Tag Table	Files	79A: Greenhouse Gas Accounting
5	920	F79A03T	ST	7	1	GHG Sources Tag Table	Files	79A: Greenhouse Gas Accounting
6	920	F79A04	GF	23	4	GHG Items	Files	79A: Greenhouse Gas Accounting
7	920	F79A08	GS	19	3	GHG Assets	Files	79A: Greenhouse Gas Accounting
8	920	F79A09	ER	27	4	GHG Energy Rates	Files	79A: Greenhouse Gas Accounting
9	920	F79A10	ER	31	4	GHG Rates	Files	79A: Greenhouse Gas Accounting
10	920	F79A11	GR	56	16	GHG Ledger	Files	79A: Greenhouse Gas Accounting
11	920	F79A11T	GT	7	1	GHG Ledger Text	Files	79A: Greenhouse Gas Accounting
12	920	F79A11T1	GT	10	1	GHG Ledger Target Tag Table	Files	79A: Greenhouse Gas Accounting
13	920	F79A11Z1	GL	77	3	GHG Ledger - Batch File	Files	79A: Greenhouse Gas Accounting
14	920	F79A12	GR	57	5	GHG Ledger Audit	Files	79A: Greenhouse Gas Accounting
15	920	F79A14	EW	3	1	GHG Ledger Energy & Emissions Recalculation Error Workfile	Work Files	79A: Greenhouse Gas Accounting
16	920	F79A21	GT	18	2	GHG Ledger Gas Trans	Files	79A: Greenhouse Gas Accounting
17	920	F79A22	GT	19	1	GHG Ledger Gas Trans Audit	Transaction Files	79A: Greenhouse Gas Accounting
18	920	F79A37	UC	8	1	GHG Unit of Measure Classification	Master Files	79A: Greenhouse Gas Accounting
19	920	F79A38	UC	9	1	GHG Unit of Measure Classification Audit	Master Files	79A: Greenhouse Gas Accounting
20	920	F79A39	UM	9	4	GHG Source UM Conversion	Master Files	79A: Greenhouse Gas Accounting
21	920	F79A41	KP	14	2	GHG KPI	Master Files	79A: Greenhouse Gas Accounting
22	920	F79A42	KP	15	2	GHG KPI Audit	Master Files	79A: Greenhouse Gas Accounting
23	920	F79A43	KL	9	2	GHG KPI List Member	Master Files	79A: Greenhouse Gas Accounting
24	920	F79A44	KL	10	2	GHG KPI List Member Audit	Master Files	79A: Greenhouse Gas Accounting
25	920	F79A45	KT	13	5	GHG KPI Target	Files	79A: Greenhouse Gas Accounting
26	920	F79A70	OH	11	4	GHG Hierarchy	Master Files	79A: Greenhouse Gas Accounting
27	920	F79A71	GO	48	8	GHG Organizations	Master Files	79A: Greenhouse Gas Accounting
28	920	F79A72	OM	9	5	GHG Organization Member	Master Files	79A: Greenhouse Gas Accounting
29	920	F79A73	OC	12	3	GHG Organization Control	Files	79A: Greenhouse Gas Accounting
30	920	F79A74	OI	12	3	GHG Interest	Files	79A: Greenhouse Gas Accounting
31	920	F79A75	GO	19	3	GHG Organization Name	Files	79A: Greenhouse Gas Accounting
32	920	F79A76	GB	10	4	GHG Org to JDE BU Mapping	Files	79A: Greenhouse Gas Accounting
33	920	F79A77	CC	16	1	GHG Company Constants	Files	79A: Greenhouse Gas Accounting
34	920	F79A78	OT	14	5	GHG Organization Target	Files	79A: Greenhouse Gas Accounting
35	920	F79A80	CP	19	4	GHG Carbon Permit Management	Files	79A: Greenhouse Gas Accounting
36	920	F79A81	CS	7	1	GHG Carbon Permit Management Scopes	Files	79A: Greenhouse Gas Accounting
37	920	F79ADC	DC	8	2	GHG Defined Codes	Files	79A: Greenhouse Gas Accounting
38	920	F79ADV	DV	10	2	GHG Defined Codes Values	Files	79A: Greenhouse Gas Accounting
39	920	F79AU11	GR	60	6	GHG Ledger Work Table	Work Files	79A: Greenhouse Gas Accounting
40	920	F79AU21	GW	20	3	GHG Ledger Gas Work File	Work Files	79A: Greenhouse Gas Accounting

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 | 79A