	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	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

77 COLUMNS | 3 INDEXES | 920 | 79A | F79A11Z1 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
79A: Greenhouse Gas Accounting
1	920	F79A11Z1	GL	77	3	GHG Ledger - Batch File	Files	79A: Greenhouse Gas Accounting

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT GLEDUS, GLEDTY, GLEDSQ, GLEDTN, GLEDCT, GLEDTS, GLEDLN, GLEDFT, GLEDDT, GLEDER, GLEDDL, GLEDSP, GLEDTC, GLEDTR, GLEDBT, GLEDGL, GLEDDH, GLEDAN, GLUKID, GLKCO, GLDCT, GLDOC, GLSFX, GLSFXE, GLLNID, GLAN8, GLMMCU, GLITM, GLLITM, GLAITM, GLTRQT, GLUOM1, GLTREX, GLTRDJ, GL79ADGHG, GLCTRY, GLFY, GLPN, GL79AGESID, GL79ASRC, GL79AEMSC, GL79AGCUM, GL79AEUQTY, GL79AEGJ, GL79ACO2Q, GLRE, GL79AGRCD, GL79AGS01, GL79AGS02, GLCOUN, GLADDS, GLCTR, GLNUMB, GLASII, GL79AGELT, GL79AVN01, GLCRCD, GLCRR, GLBCRC, GL79ABV01, GL79AGCRIT, GLMCU, GL79AGBNO, GL79AGCM, GL79AGZYN, GL79AAPDF, GL79AAPDT, GLURCD, GLURRF, GLURAB, GLURAT, GLURDT, GLPID, GLUSER, GLJOBN, GLUPMJ, GLTDAY FROM F79A11Z1

TOP 920 | 79A | F79A11Z1 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	GLEDUS	EDI - User ID	String	Generic Edit	10	0	Allow NULL?
2	GLEDTY	Type Record	Character	UDC (00 RD)	1	0	Allow NULL?
3	GLEDSQ	Record Sequence	Numeric	Generic Edit	2	0	Allow NULL?
4	GLEDTN	EDI - Transaction Number	String	Generic Edit	22	0	Allow NULL?
5	GLEDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
6	GLEDTS	EDI - Transaction Set Number	String	Generic Edit	6	0	Allow NULL?
7	GLEDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
8	GLEDFT	EDI - Translation Format	String	Generic Edit	10	0	Allow NULL?
9	GLEDDT	EDI - Transmission Date	Date	Generic Edit	6	0
10	GLEDER	EDI - Send/Receive Indicator	Character	UDC (H00 ED)	1	0	Allow NULL?
11	GLEDDL	EDI - Detail Lines Processed	Numeric	Generic Edit	5	0	Allow NULL?
12	GLEDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
13	GLEDTC	EDI - Transaction Action	Character	Generic Edit	1	0	Allow NULL?
14	GLEDTR	EDI - Transaction Type	Character	Generic Edit	1	0	Allow NULL?
15	GLEDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
16	GLEDGL	Batch File Create G/L Record	Character	Generic Edit	1	0	Allow NULL?
17	GLEDDH	Batch File Discount Handling Flag	Character	Generic Edit	1	0	Allow NULL?
18	GLEDAN	User Address Number	Numeric	Generic Edit	8	0	Allow NULL?
19	GLUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
20	GLKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
21	GLDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
22	GLDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
23	GLSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
24	GLSFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0	Allow NULL?
25	GLLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
26	GLAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
27	GLMMCU	Branch	String	Generic Edit	12	0	Allow NULL?
28	GLITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
29	GLLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
30	GLAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
31	GLTRQT	Quantity Available	Numeric	Generic Edit	15	0	Allow NULL?
32	GLUOM1	Unit of Measure - Primary	String	UDC (00 UM)	2	0	Allow NULL?
33	GLTREX	Explanation - Transaction	String	Generic Edit	30	0	Allow NULL?
34	GLTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
35	GL79ADGHG	Date	Date	Generic Edit	6	0
36	GLCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
37	GLFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
38	GLPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
39	GL79AGESID	Source Id	Numeric	Generic Edit	15	0	Allow NULL?
40	GL79ASRC	Source	String	Generic Edit	25	0	Allow NULL?
41	GL79AEMSC	Emission Scope	String	UDC (79A SC)	10	0	Allow NULL?
42	GL79AGCUM	CO2-e Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
43	GL79AEUQTY	Usage Quantity	Numeric	Generic Edit	24	8	Allow NULL?
44	GL79AEGJ	Energy in GJ	Numeric	Generic Edit	24	8	Allow NULL?
45	GL79ACO2Q	Emission CO2 Quantity	Numeric	Generic Edit	24	8	Allow NULL?
46	GLRE	Reverse or Void (R/V)	Character	UDC (H09 RE)	1	0	Allow NULL?
47	GL79AGRCD	Reason Code	String	UDC (79A GR)	3	0	Allow NULL?
48	GL79AGS01	Source Type	String	UDC (79A GF)	2	0	Allow NULL?
49	GL79AGS02	Actual / Estimate	String	UDC (79A G2)	2	0	Allow NULL?
50	GLCOUN	County	String	UDC (00 CT)	25	0	Allow NULL?
51	GLADDS	State	String	UDC (00 S)	3	0	Allow NULL?
52	GLCTR	Country	String	UDC (00 CN)	3	0	Allow NULL?
53	GLNUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
54	GLASII	Asset Number-Input	String	Generic Edit	26	0	Allow NULL?
55	GL79AGELT	Emission Ledger Type	String	UDC (79A GL)	2	0	Allow NULL?
56	GL79AVN01	Value 01	Numeric	Generic Edit	15	2	Allow NULL?
57	GLCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
58	GLCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
59	GLBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
60	GL79ABV01	Base Value 01	Numeric	Generic Edit	15	2	Allow NULL?
61	GL79AGCRIT	Measurement Criterion	String	UDC (79A GC)	10	0	Allow NULL?
62	GLMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
63	GL79AGBNO	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
64	GL79AGCM	Calculation Method	String	UDC (79A GM)	2	0	Allow NULL?
65	GL79AGZYN	Zero Usage On/Off	Character	UDC (00 ZO)	1	0	Allow NULL?
66	GL79AAPDF	Apportion Date From	Date	Generic Edit	6	0
67	GL79AAPDT	Apportion Date To	Date	Generic Edit	6	0
68	GLURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
69	GLURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
70	GLURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
71	GLURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
72	GLURDT	User Reserved Date	Date	Generic Edit	6	0
73	GLPID	Program ID	String	Generic Edit	10	0	Allow NULL?
74	GLUSER	User ID	String	Generic Edit	10	0	Allow NULL?
75	GLJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
76	GLUPMJ	Date - Updated	Date	Generic Edit	6	0
77	GLTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?

TOP 920 | 79A | F79A11Z1 INDEXES

Number

Description

User Batch# + (Primary/Unique)

Element	Alias	Description	Sequence
1	EDUS	EDI - User ID	Ascending
2	EDBT	EDI - Batch Number	Ascending
3	EDTN	EDI - Transaction Number	Ascending
4	EDLN	EDI - Line Number	Ascending

Batch# Trans +

Element	Alias	Description	Sequence
1	EDBT	EDI - Batch Number	Ascending
2	EDTN	EDI - Transaction Number	Ascending
3	EDSP	EDI - Successfully Processed	Ascending

User Batch# Desc+

Element	Alias	Description	Sequence
1	EDUS	EDI - User ID	Ascending
2	EDBT	EDI - Batch Number	Ascending
3	EDTN	EDI - Transaction Number	Ascending
4	EDLN	EDI - Line Number	Descending

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

77 COLUMNS | 3 INDEXES | 920 | 79A | F79A11Z1 TABLE

TOP 920 | 79A | F79A11Z1 COLUMNS

TOP 920 | 79A | F79A11Z1 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

77 COLUMNS | 3 INDEXES | 920 | 79A | F79A11Z1 TABLE

TOP920 | 79A | F79A11Z1 COLUMNS

TOP920 | 79A | F79A11Z1 INDEXES

TOP 920 | 79A | F79A11Z1 COLUMNS

TOP 920 | 79A | F79A11Z1 INDEXES