	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

48 COLUMNS | 8 INDEXES | 920 | 79A | F79A71 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
79A: Greenhouse Gas Accounting
1	920	F79A71	GO	48	8	GHG Organizations	Master Files	79A: Greenhouse Gas Accounting

TOP 920 | 79A | F79A71 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	GO79AGOID	Organization Id	Numeric	Generic Edit	15	Allow NULL?
2	GO79AGOCD	Organization Code	String	Generic Edit	60	Allow NULL?
3	GO79AGOT	Organization Type	String	UDC (79A OT)	100	Allow NULL?
4	GO79AGFS	Organization Size	String	UDC (79A FS)	2	Allow NULL?
5	GO79AANZ	Industry Code	String	UDC (79A AC)	6	Allow NULL?
6	GO79ALAT	Latitude	String	Generic Edit	20	Allow NULL?
7	GO79ALON	Longitude	String	Generic Edit	20	Allow NULL?
8	GO79AOLOC	Organization Location	String	Generic Edit	100	Allow NULL?
9	GO79AGOBN	Company Number	String	Generic Edit	30	Allow NULL?
10	GO79AGCN	CEO Name	String	Generic Edit	100	Allow NULL?
11	GOAN8	Address Number	Numeric	Generic Edit	8	Allow NULL?
12	GOBEFD	Beginning Effective Date - Julian	Date	Generic Edit	6
13	GOEEFD	Ending Effective Date - Julian	Date	Generic Edit	6
14	GO79AF01	Organization Facility Code 01	String	Generic Edit	15	Allow NULL?
15	GO79AF02	Organization Facility Code 02	String	Generic Edit	15	Allow NULL?
16	GO79AF03	Organization Facility Code 03	String	Generic Edit	15	Allow NULL?
17	GO79AF04	Organization Facility Code 04	String	Generic Edit	15	Allow NULL?
18	GO79AF05	Organization Facility Code 05	String	Generic Edit	15	Allow NULL?
19	GO79AF06	Organization Facility Code 06	String	Generic Edit	15	Allow NULL?
20	GO79AF07	Organization Facility Code 07	String	Generic Edit	15	Allow NULL?
21	GO79AF08	Organization Facility Code 08	String	Generic Edit	15	Allow NULL?
22	GO79AF09	Organization Facility Code 09	String	Generic Edit	15	Allow NULL?
23	GO79AF10	Organization Facility Code 10	String	Generic Edit	15	Allow NULL?
24	GO79AF11	Organization Facility Code 11	String	Generic Edit	15	Allow NULL?
25	GO79AF12	Organization Facility Code 12	String	Generic Edit	15	Allow NULL?
26	GO79AF13	Organization Facility Code 13	String	Generic Edit	15	Allow NULL?
27	GO79AF14	Organization Facility Code 14	String	Generic Edit	15	Allow NULL?
28	GO79AF15	Organization Facility Code 15	String	Generic Edit	15	Allow NULL?
29	GO79AF16	Organization Facility Code 16	String	Generic Edit	15	Allow NULL?
30	GO79AF17	Organization Facility Code 17	String	Generic Edit	15	Allow NULL?
31	GO79AF18	Organization Facility Code 18	String	Generic Edit	15	Allow NULL?
32	GO79AF19	Organization Facility Code 19	String	Generic Edit	15	Allow NULL?
33	GO79AF20	Organization Facility Code 20	String	Generic Edit	15	Allow NULL?
34	GO79AF21	Organization Facility Code 21	String	Generic Edit	15	Allow NULL?
35	GO79AF22	Organization Facility Code 22	String	Generic Edit	15	Allow NULL?
36	GO79AF23	Organization Facility Code 23	String	Generic Edit	15	Allow NULL?
37	GO79AF24	Organization Facility Code 24	String	Generic Edit	15	Allow NULL?
38	GO79AF25	Organization Facility Code 25	String	Generic Edit	15	Allow NULL?
39	GO79AF26	Organization Facility Code 26	String	Generic Edit	15	Allow NULL?
40	GO79AF27	Organization Facility Code 27	String	Generic Edit	15	Allow NULL?
41	GO79AF28	Organization Facility Code 28	String	Generic Edit	15	Allow NULL?
42	GO79AF29	Organization Facility Code 29	String	Generic Edit	15	Allow NULL?
43	GO79AF30	Organization Facility Code 30	String	Generic Edit	15	Allow NULL?
44	GOPID	Program ID	String	Generic Edit	10	Allow NULL?
45	GOUSER	User ID	String	Generic Edit	10	Allow NULL?
46	GOJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
47	GOUPMJ	Date - Updated	Date	Generic Edit	6
48	GOTDAY	Time of Day	Numeric	Generic Edit	6	Allow NULL?

TOP 920 | 79A | F79A71 INDEXES

Number

Description

79A 79AGOID (Primary/Unique)

Element	Alias	Description	Sequence
1	79AGOID	Organization Id	Ascending

79A 79AGOCD BEFD

Element	Alias	Description	Sequence
1	79AGOCD	Organization Code	Ascending
2	BEFD	Beginning Effective Date - Julian	Ascending

79A 79ABEFD

Element	Alias	Description	Sequence
1	BEFD	Beginning Effective Date - Julian	Ascending

79A 79AGOBN

Element	Alias	Description	Sequence
1	79AGOBN	Company Number	Ascending

79A 79AGCN

Element	Alias	Description	Sequence
1	79AGCN	CEO Name	Ascending

79A 79AGOT BEFD

Element	Alias	Description	Sequence
1	79AGOT	Organization Type	Ascending
2	BEFD	Beginning Effective Date - Julian	Ascending

79A 79AGOCD GOT

Element	Alias	Description	Sequence
1	79AGOCD	Organization Code	Ascending
2	79AGOT	Organization Type	Ascending

79A 79AGOCD (Unique)

Element	Alias	Description	Sequence
1	79AGOCD	Organization Code	Ascending

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

48 COLUMNS | 8 INDEXES | 920 | 79A | F79A71 TABLE

TOP 920 | 79A | F79A71 COLUMNS

TOP 920 | 79A | F79A71 INDEXES

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

48 COLUMNS | 8 INDEXES | 920 | 79A | F79A71 TABLE

TOP920 | 79A | F79A71 COLUMNS

TOP920 | 79A | F79A71 INDEXES

TOP 920 | 79A | F79A71 COLUMNS

TOP 920 | 79A | F79A71 INDEXES