	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

108 COLUMNS | 5 INDEXES | 920 | 09 | F09300 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
09: General Accounting
1	920	F09300	FR	108	5	OVFS Report Table	Files	09: General 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 FRRUNID, FRLINN, FRGRPV1, FRGRPV2, FRGRPV3, FRGRPV4, FRGRPV5, FRGRPV6, FRGRPV7, FRGRPV8, FRGRPV9, FRGRPV10, FRCOLAMT01, FRCOLCUR01, FRCOLAMT02, FRCOLCUR02, FRCOLAMT03, FRCOLCUR03, FRCOLAMT04, FRCOLCUR04, FRCOLAMT05, FRCOLCUR05, FRCOLAMT06, FRCOLCUR06, FRCOLAMT07, FRCOLCUR07, FRCOLAMT08, FRCOLCUR08, FRCOLAMT09, FRCOLCUR09, FRCOLAMT10, FRCOLCUR10, FRCOLAMT11, FRCOLCUR11, FRCOLAMT12, FRCOLCUR12, FRCOLAMT13, FRCOLCUR13, FRCOLAMT14, FRCOLCUR14, FRCOLAMT15, FRCOLCUR15, FRCOLAMT16, FRCOLCUR16, FRCOLAMT17, FRCOLCUR17, FRCOLAMT18, FRCOLCUR18, FRCOLAMT19, FRCOLCUR19, FRCOLAMT20, FRCOLCUR20, FRCOLAMT21, FRCOLCUR21, FRCOLAMT22, FRCOLCUR22, FRCOLAMT23, FRCOLCUR23, FRCOLAMT24, FRCOLCUR24, FRCOLAMT25, FRCOLCUR25, FRGRVDSC01, FRGRVDSC02, FRGRVDSC03, FRGRVDSC04, FRGRVDSC05, FRGRVDSC06, FRGRVDSC07, FRGRVDSC08, FRGRVDSC09, FRGRVDSC10, FRCO, FRCODES, FRMCU, FRBUDES, FROBJ, FRSUB, FRAID, FRACCDESC, FRLDA, FRPEC, FRRPRID, FRRIDDS, FRLODSEQ, FRLODTOTAL, FRGAIGID, FRGAIGDSC, FRRSTTY, FRRWRSF, FRLODR, FRFRNU1, FRFRNU2, FRFRNU3, FRFRST1, FRFRST2, FRFRST3, FRFRCT1, FRFRCT2, FRFRCT3, FRFRDT1, FRFRDT2, FRFRDT3, FRUSER, FRRPSTN, FRVERN, FRUPMJ, FRUPMT FROM F09300

TOP 920 | 09 | F09300 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	FRRUNID	Run ID	Numeric	Generic Edit	14	0	Allow NULL?
2	FRLINN	Line Number	Numeric	Generic Edit	7	3	Allow NULL?
3	FRGRPV1	Grouping Value 1	String	Generic Edit	30	0	Allow NULL?
4	FRGRPV2	Grouping Value 2	String	Generic Edit	30	0	Allow NULL?
5	FRGRPV3	Grouping Value 3	String	Generic Edit	30	0	Allow NULL?
6	FRGRPV4	Grouping Value 4	String	Generic Edit	30	0	Allow NULL?
7	FRGRPV5	Grouping Value 5	String	Generic Edit	30	0	Allow NULL?
8	FRGRPV6	Grouping Value 6	String	Generic Edit	30	0	Allow NULL?
9	FRGRPV7	Grouping Value 7	String	Generic Edit	30	0	Allow NULL?
10	FRGRPV8	Grouping Value 8	String	Generic Edit	30	0	Allow NULL?
11	FRGRPV9	Grouping Value 9	String	Generic Edit	30	0	Allow NULL?
12	FRGRPV10	Grouping Value 10	String	Generic Edit	30	0	Allow NULL?
13	FRCOLAMT01	Column Amount 01	Numeric	Generic Edit	15	2	Allow NULL?
14	FRCOLCUR01	Column Currency 01	String	Generic Edit	3	0	Allow NULL?
15	FRCOLAMT02	Column Amount 02	Numeric	Generic Edit	15	2	Allow NULL?
16	FRCOLCUR02	Column Currency 02	String	Generic Edit	3	0	Allow NULL?
17	FRCOLAMT03	Column Amount 03	Numeric	Generic Edit	15	2	Allow NULL?
18	FRCOLCUR03	Column Currency 03	String	Generic Edit	3	0	Allow NULL?
19	FRCOLAMT04	Column Amount 04	Numeric	Generic Edit	15	2	Allow NULL?
20	FRCOLCUR04	Column Currency 04	String	Generic Edit	3	0	Allow NULL?
21	FRCOLAMT05	Column Amount 05	Numeric	Generic Edit	15	2	Allow NULL?
22	FRCOLCUR05	Column Currency 05	String	Generic Edit	3	0	Allow NULL?
23	FRCOLAMT06	Column Amount 06	Numeric	Generic Edit	15	2	Allow NULL?
24	FRCOLCUR06	Column Currency 06	String	Generic Edit	3	0	Allow NULL?
25	FRCOLAMT07	Column Amount 07	Numeric	Generic Edit	15	2	Allow NULL?
26	FRCOLCUR07	Column Currency 07	String	Generic Edit	3	0	Allow NULL?
27	FRCOLAMT08	Column Amount 08	Numeric	Generic Edit	15	2	Allow NULL?
28	FRCOLCUR08	Column Currency 08	String	Generic Edit	3	0	Allow NULL?
29	FRCOLAMT09	Column Amount 09	Numeric	Generic Edit	15	2	Allow NULL?
30	FRCOLCUR09	Column Currency 09	String	Generic Edit	3	0	Allow NULL?
31	FRCOLAMT10	Column Amount 10	Numeric	Generic Edit	15	2	Allow NULL?
32	FRCOLCUR10	Column Currency 10	String	Generic Edit	3	0	Allow NULL?
33	FRCOLAMT11	Column Amount 11	Numeric	Generic Edit	15	2	Allow NULL?
34	FRCOLCUR11	Column Currency 11	String	Generic Edit	3	0	Allow NULL?
35	FRCOLAMT12	Column Amount 12	Numeric	Generic Edit	15	2	Allow NULL?
36	FRCOLCUR12	Column Currency 12	String	Generic Edit	3	0	Allow NULL?
37	FRCOLAMT13	Column Amount 13	Numeric	Generic Edit	15	2	Allow NULL?
38	FRCOLCUR13	Column Currency 13	String	Generic Edit	3	0	Allow NULL?
39	FRCOLAMT14	Column Amount 14	Numeric	Generic Edit	15	2	Allow NULL?
40	FRCOLCUR14	Column Currency 14	String	Generic Edit	3	0	Allow NULL?
41	FRCOLAMT15	Column Amount 15	Numeric	Generic Edit	15	2	Allow NULL?
42	FRCOLCUR15	Column Currency 15	String	Generic Edit	3	0	Allow NULL?
43	FRCOLAMT16	Column Amount 16	Numeric	Generic Edit	15	2	Allow NULL?
44	FRCOLCUR16	Column Currency 16	String	Generic Edit	3	0	Allow NULL?
45	FRCOLAMT17	Column Amount 17	Numeric	Generic Edit	15	2	Allow NULL?
46	FRCOLCUR17	Column Currency 17	String	Generic Edit	3	0	Allow NULL?
47	FRCOLAMT18	Column Amount 18	Numeric	Generic Edit	15	2	Allow NULL?
48	FRCOLCUR18	Column Currency 18	String	Generic Edit	3	0	Allow NULL?
49	FRCOLAMT19	Column Amount 19	Numeric	Generic Edit	15	2	Allow NULL?
50	FRCOLCUR19	Column Currency 19	String	Generic Edit	3	0	Allow NULL?
51	FRCOLAMT20	Column Amount 20	Numeric	Generic Edit	15	2	Allow NULL?
52	FRCOLCUR20	Column Currency 20	String	Generic Edit	3	0	Allow NULL?
53	FRCOLAMT21	Column Amount 21	Numeric	Generic Edit	15	2	Allow NULL?
54	FRCOLCUR21	Column Currency 21	String	Generic Edit	3	0	Allow NULL?
55	FRCOLAMT22	Column Amount 22	Numeric	Generic Edit	15	2	Allow NULL?
56	FRCOLCUR22	Column Currency 22	String	Generic Edit	3	0	Allow NULL?
57	FRCOLAMT23	Column Amount 23	Numeric	Generic Edit	15	2	Allow NULL?
58	FRCOLCUR23	Column Currency 23	String	Generic Edit	3	0	Allow NULL?
59	FRCOLAMT24	Column Amount 24	Numeric	Generic Edit	15	2	Allow NULL?
60	FRCOLCUR24	Column Currency 24	String	Generic Edit	3	0	Allow NULL?
61	FRCOLAMT25	Column Amount 25	Numeric	Generic Edit	15	2	Allow NULL?
62	FRCOLCUR25	Column Currency 25	String	Generic Edit	3	0	Allow NULL?
63	FRGRVDSC01	Grouping Value Description 01	String	Generic Edit	40	0	Allow NULL?
64	FRGRVDSC02	Grouping Value Description 02	String	Generic Edit	40	0	Allow NULL?
65	FRGRVDSC03	Grouping Value Description 03	String	Generic Edit	40	0	Allow NULL?
66	FRGRVDSC04	Grouping Value Description 04	String	Generic Edit	40	0	Allow NULL?
67	FRGRVDSC05	Grouping Value Description 05	String	Generic Edit	40	0	Allow NULL?
68	FRGRVDSC06	Grouping Value Description 06	String	Generic Edit	40	0	Allow NULL?
69	FRGRVDSC07	Grouping Value Description 07	String	Generic Edit	40	0	Allow NULL?
70	FRGRVDSC08	Grouping Value Description 08	String	Generic Edit	40	0	Allow NULL?
71	FRGRVDSC09	Grouping Value Description 09	String	Generic Edit	40	0	Allow NULL?
72	FRGRVDSC10	Grouping Value Description 10	String	Generic Edit	40	0	Allow NULL?
73	FRCO	Company	String	Generic Edit	5	0	Allow NULL?
74	FRCODES	Company Description	String	Generic Edit	30	0	Allow NULL?
75	FRMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
76	FRBUDES	Business Unit Description	String	Generic Edit	30	0	Allow NULL?
77	FROBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
78	FRSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
79	FRAID	Account ID	String	Generic Edit	8	0	Allow NULL?
80	FRACCDESC	Account Description	String	Generic Edit	30	0	Allow NULL?
81	FRLDA	Account Level of Detail	Character	Generic Edit	1	0	Allow NULL?
82	FRPEC	Posting Edit	Character	UDC (H00 PE)	1	0	Allow NULL?
83	FRRPRID	Section Number	Numeric	Generic Edit	7	3	Allow NULL?
84	FRRIDDS	Section Description	String	Generic Edit	80	0	Allow NULL?
85	FRLODSEQ	Level Of Detail Sequence	Numeric	Generic Edit	7	0	Allow NULL?
86	FRLODTOTAL	Level Of Detail Total	Character	Generic Edit	1	0	Allow NULL?
87	FRGAIGID	GLG AAI Item Number	String	Generic Edit	10	0	Allow NULL?
88	FRGAIGDSC	GLG AAI Item Description	String	Generic Edit	40	0	Allow NULL?
89	FRRSTTY	Row Definition Type	Character	UDC (09 GT)	1	0	Allow NULL?
90	FRRWRSF	Row Reverse Sign Flag	Character	Generic Edit	1	0	Allow NULL?
91	FRLODR	Enable Level of Detail Rollup	Character	Generic Edit	1	0	Allow NULL?
92	FRFRNU1	F09300 Future Use Number 1	Numeric	Generic Edit	15	0	Allow NULL?
93	FRFRNU2	F09300 Future Use Number 2	Numeric	Generic Edit	15	0	Allow NULL?
94	FRFRNU3	F09300 Future Use Number 3	Numeric	Generic Edit	15	0	Allow NULL?
95	FRFRST1	F09300 Future Use String 1	String	Generic Edit	80	0	Allow NULL?
96	FRFRST2	F09300 Future Use String 2	String	Generic Edit	80	0	Allow NULL?
97	FRFRST3	F09300 Future Use String 3	String	Generic Edit	80	0	Allow NULL?
98	FRFRCT1	F09300 Future Use Character 1	Character	Generic Edit	1	0	Allow NULL?
99	FRFRCT2	F09300 Future Use Character 2	Character	Generic Edit	1	0	Allow NULL?
100	FRFRCT3	F09300 Future Use Character 3	Character	Generic Edit	1	0	Allow NULL?
101	FRFRDT1	F09300 Future Use Date 1	Date	Generic Edit	6	0
102	FRFRDT2	F09300 Future Use Date 2	Date	Generic Edit	6	0
103	FRFRDT3	F09300 Future Use Date 3	Date	Generic Edit	6	0
104	FRUSER	User ID	String	Generic Edit	10	0	Allow NULL?
105	FRRPSTN	Statement Definition Name	String	Generic Edit	20	0	Allow NULL?
106	FRVERN	Statement Version Name	String	Generic Edit	20	0	Allow NULL?
107	FRUPMJ	Date - Updated	Date	Generic Edit	6	0
108	FRUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?

TOP 920 | 09 | F09300 INDEXES

Number

Description

RUNID RPRID LODSEQ LINN GRPV (Primary/Unique)

Element	Alias	Description	Sequence
1	RUNID	Run ID	Ascending
2	RPRID	Section Number	Ascending
3	LODSEQ	Level Of Detail Sequence	Ascending
4	LINN	Line Number	Ascending
5	GRPV1	Grouping Value 1	Ascending
6	GRPV2	Grouping Value 2	Ascending
7	GRPV3	Grouping Value 3	Ascending
8	GRPV4	Grouping Value 4	Ascending
9	GRPV5	Grouping Value 5	Ascending
10	GRPV6	Grouping Value 6	Ascending
11	GRPV7	Grouping Value 7	Ascending
12	GRPV8	Grouping Value 8	Ascending
13	GRPV9	Grouping Value 9	Ascending
14	GRPV10	Grouping Value 10	Ascending

RUNID RPRID CO MCU OBJ SUB DSC

Element	Alias	Description	Sequence
1	RUNID	Run ID	Ascending
2	RPRID	Section Number	Ascending
3	CO	Company	Ascending
4	MCU	Business Unit	Ascending
5	OBJ	Object Account	Descending
6	SUB	Subsidiary	Descending

USER RPSTN VERN

Element	Alias	Description	Sequence
1	USER	User ID	Ascending
2	RPSTN	Statement Definition Name	Ascending
3	VERN	Statement Version Name	Ascending

RUNID RPRID OBJ SUB

Element	Alias	Description	Sequence
1	RUNID	Run ID	Ascending
2	RPRID	Section Number	Ascending
3	OBJ	Object Account	Descending
4	SUB	Subsidiary	Descending

RUNID RPRID CO MCU OBJ SUB

Element	Alias	Description	Sequence
1	RUNID	Run ID	Ascending
2	RPRID	Section Number	Ascending
3	CO	Company	Ascending
4	MCU	Business Unit	Ascending
5	OBJ	Object Account	Ascending
6	SUB	Subsidiary	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

108 COLUMNS | 5 INDEXES | 920 | 09 | F09300 TABLE

TOP 920 | 09 | F09300 COLUMNS

TOP 920 | 09 | F09300 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

108 COLUMNS | 5 INDEXES | 920 | 09 | F09300 TABLE

TOP920 | 09 | F09300 COLUMNS

TOP920 | 09 | F09300 INDEXES

TOP 920 | 09 | F09300 COLUMNS

TOP 920 | 09 | F09300 INDEXES