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

65 COLUMNS | 4 INDEXES | 920 | 09 | F09330 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
09: General Accounting
1	920	F09330	RT	65	4	OVFS Statement Definition Setup 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 RTRPSTN, RTRPSTD, RTLINN, RTRSTN, RTRPRID, RTRIDDS, RTRPCOL01, RTRPCOL02, RTRPCOL03, RTRPCOL04, RTRPCOL05, RTRPCOL06, RTRPCOL07, RTRPCOL08, RTRPCOL09, RTRPCOL10, RTRPCOL11, RTRPCOL12, RTRPCOL13, RTRPCOL14, RTRPCOL15, RTRPCOL16, RTRPCOL17, RTRPCOL18, RTRPCOL19, RTRPCOL20, RTRPCOL21, RTRPCOL22, RTRPCOL23, RTRPCOL24, RTRPCOL25, RTSTMSG, RTFRCC1, RTFRCC2, RTFRCC3, RTFRCC4, RTFRCC5, RTWOBNM, RTRPNU1, RTRPNU2, RTRPNU3, RTRPST1, RTRPST2, RTRPST3, RTRPCT1, RTRPCT2, RTRPCT3, RTRPDT1, RTRPDT2, RTRPDT3, RTCRTBY, RTUSER, RTPID, RTJOBN, RTUPMJ, RTUPMT, RTLVERS, RTLODR, RTGAIGF, RTRWCF, RTRWRSF, RTSSNF, RTSSNT, RTSISF, RTRDCCF FROM F09330

TOP 920 | 09 | F09330 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	RTRPSTN	Statement Definition Name	String	Generic Edit	20	0	Allow NULL?
2	RTRPSTD	Statement Definition Description	String	Generic Edit	80	0	Allow NULL?
3	RTLINN	Line Number	Numeric	Generic Edit	7	3	Allow NULL?
4	RTRSTN	Row Definition Name	String	Generic Edit	20	0	Allow NULL?
5	RTRPRID	Section Number	Numeric	Generic Edit	7	3	Allow NULL?
6	RTRIDDS	Section Description	String	Generic Edit	80	0	Allow NULL?
7	RTRPCOL01	Column Definition Name 1	String	Generic Edit	20	0	Allow NULL?
8	RTRPCOL02	Column Definition Name 2	String	Generic Edit	20	0	Allow NULL?
9	RTRPCOL03	Column Definition Name 3	String	Generic Edit	20	0	Allow NULL?
10	RTRPCOL04	Column Definition Name 4	String	Generic Edit	20	0	Allow NULL?
11	RTRPCOL05	Column Definition Name 5	String	Generic Edit	20	0	Allow NULL?
12	RTRPCOL06	Column Definition Name 6	String	Generic Edit	20	0	Allow NULL?
13	RTRPCOL07	Column Definition Name 7	String	Generic Edit	20	0	Allow NULL?
14	RTRPCOL08	Column Definition Name 8	String	Generic Edit	20	0	Allow NULL?
15	RTRPCOL09	Column Definition Name 9	String	Generic Edit	20	0	Allow NULL?
16	RTRPCOL10	Column Definition Name 10	String	Generic Edit	20	0	Allow NULL?
17	RTRPCOL11	Column Definition Name 11	String	Generic Edit	20	0	Allow NULL?
18	RTRPCOL12	Column Definition Name 12	String	Generic Edit	20	0	Allow NULL?
19	RTRPCOL13	Column Definition Name 13	String	Generic Edit	20	0	Allow NULL?
20	RTRPCOL14	Column Definition Name 14	String	Generic Edit	20	0	Allow NULL?
21	RTRPCOL15	Column Definition Name 15	String	Generic Edit	20	0	Allow NULL?
22	RTRPCOL16	Column Definition Name 16	String	Generic Edit	20	0	Allow NULL?
23	RTRPCOL17	Column Definition Name 17	String	Generic Edit	20	0	Allow NULL?
24	RTRPCOL18	Column Definition Name 18	String	Generic Edit	20	0	Allow NULL?
25	RTRPCOL19	Column Definition Name 19	String	Generic Edit	20	0	Allow NULL?
26	RTRPCOL20	Column Definition Name 20	String	Generic Edit	20	0	Allow NULL?
27	RTRPCOL21	Column Definition Name 21	String	Generic Edit	20	0	Allow NULL?
28	RTRPCOL22	Column Definition Name 22	String	Generic Edit	20	0	Allow NULL?
29	RTRPCOL23	Column Definition Name 23	String	Generic Edit	20	0	Allow NULL?
30	RTRPCOL24	Column Definition Name 24	String	Generic Edit	20	0	Allow NULL?
31	RTRPCOL25	Column Definition Name 25	String	Generic Edit	20	0	Allow NULL?
32	RTSTMSG	Definition Status	String	UDC (09 SM)	2	0	Allow NULL?
33	RTFRCC1	Financial Statement Category Code 1	String	UDC (09 C1)	10	0	Allow NULL?
34	RTFRCC2	Financial Statement Category Code 2	String	UDC (09 C2)	10	0	Allow NULL?
35	RTFRCC3	Financial Statement Category Code 3	String	UDC (09 C3)	10	0	Allow NULL?
36	RTFRCC4	Financial Statement Category Code 4	String	UDC (09 C4)	10	0	Allow NULL?
37	RTFRCC5	Financial Statement Category Code 5	String	UDC (09 C5)	10	0	Allow NULL?
38	RTWOBNM	Object Name	String	Generic Edit	30	0	Allow NULL?
39	RTRPNU1	F09330 Future Use Number 1	Numeric	Generic Edit	15	0	Allow NULL?
40	RTRPNU2	F09330 Future Use Number 2	Numeric	Generic Edit	15	0	Allow NULL?
41	RTRPNU3	F09330 Future Use Number 3	Numeric	Generic Edit	15	0	Allow NULL?
42	RTRPST1	F09330 Future Use String 1	String	Generic Edit	80	0	Allow NULL?
43	RTRPST2	F09330 Future Use String 2	String	Generic Edit	80	0	Allow NULL?
44	RTRPST3	F09330 Future Use String 3	String	Generic Edit	80	0	Allow NULL?
45	RTRPCT1	F09330 Future Use Character 1	Character	Generic Edit	1	0	Allow NULL?
46	RTRPCT2	F09330 Future Use Character 2	Character	Generic Edit	1	0	Allow NULL?
47	RTRPCT3	F09330 Future Use Character 3	Character	Generic Edit	1	0	Allow NULL?
48	RTRPDT1	F09330 Future Use Date 1	Date	Generic Edit	6	0
49	RTRPDT2	F09330 Future Use Date 2	Date	Generic Edit	6	0
50	RTRPDT3	F09330 Future Use Date 3	Date	Generic Edit	6	0
51	RTCRTBY	Created By	String	Generic Edit	10	0	Allow NULL?
52	RTUSER	User ID	String	Generic Edit	10	0	Allow NULL?
53	RTPID	Program ID	String	Generic Edit	10	0	Allow NULL?
54	RTJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
55	RTUPMJ	Date - Updated	Date	Generic Edit	6	0
56	RTUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
57	RTLVERS	Layout Version	String	Generic Edit	20	0	Allow NULL?
58	RTLODR	Enable Level of Detail Rollup	Character	Generic Edit	1	0	Allow NULL?
59	RTGAIGF	Include GLG AAI Item Number	Character	Generic Edit	1	0	Allow NULL?
60	RTRWCF	Consolidated Row Flag	Character	Generic Edit	1	0	Allow NULL?
61	RTRWRSF	Row Reverse Sign Flag	Character	Generic Edit	1	0	Allow NULL?
62	RTSSNF	Subtotal Section Number From	Numeric	Generic Edit	7	3	Allow NULL?
63	RTSSNT	Subtotal Section Number Thru	Numeric	Generic Edit	7	3	Allow NULL?
64	RTSISF	Include Subtotals Flag	Character	Generic Edit	1	0	Allow NULL?
65	RTRDCCF	Statement Definition Component Changed	Character	Generic Edit	1	0	Allow NULL?

TOP 920 | 09 | F09330 INDEXES

Number

Description

ReportDefName SectionID Line (Primary/Unique)

Element	Alias	Description	Sequence
1	RPSTN	Statement Definition Name	Ascending
2	RPRID	Section Number	Ascending
3	LINN	Line Number	Ascending

GroupID ReportStName Line

Element	Alias	Description	Sequence
1	RPRID	Section Number	Ascending
2	RPSTN	Statement Definition Name	Ascending
3	LINN	Line Number	Ascending

ReportStName

Element	Alias	Description	Sequence
1	RPSTN	Statement Definition Name	Ascending

ReportDefName SectionNum

Element	Alias	Description	Sequence
1	RPSTN	Statement Definition Name	Ascending
2	RPRID	Section Number	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

65 COLUMNS | 4 INDEXES | 920 | 09 | F09330 TABLE

TOP 920 | 09 | F09330 COLUMNS

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

65 COLUMNS | 4 INDEXES | 920 | 09 | F09330 TABLE

TOP920 | 09 | F09330 COLUMNS

TOP920 | 09 | F09330 INDEXES

TOP 920 | 09 | F09330 COLUMNS

TOP 920 | 09 | F09330 INDEXES