920: Top 10 requests

	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

910: Top 10 requests

	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

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
98: Technical Tools
1	812	F9201	FR	25	1	Data Field Specifications	Master Files	98: Technical Tools	AS400 Coexistence Tables

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	FRDTAI	Data Item	String	Generic Edit	10	Allow NULL?
2	FRCLAS	Data Item Class	String	Generic Edit	10	Allow NULL?
3	FRDTAT	Data Item Type	Character	UDC (98 DT)	1	Allow NULL?
4	FRDTAS	Data Item Size	Numeric	Generic Edit	5	Allow NULL?
5	FRDTAD	Data File Decimals	Numeric	Generic Edit	2	Allow NULL?
6	FRPDTA	Data Field - Parent	String	Generic Edit	10	Allow NULL?
7	FRARRN	Number of Array Elements	Numeric	Generic Edit	3	Allow NULL?
8	FRDVAL	Value for Entry - Default	String	Generic Edit	40	Allow NULL?
9	FRLR	Justify - Left or Right	Character	UDC (H98 LR)	1	Allow NULL?
10	FRCDEC	Display Decimals	Character	Generic Edit	1	Allow NULL?
11	FRDRUL	Data Display Rules	String	UDC (98 DR)	6	Allow NULL?
12	FRDRO1	Data Display Parameters	String	Generic Edit	40	Allow NULL?
13	FRERUL	Data Edit Rules	String	UDC (98 ER)	6	Allow NULL?
14	FRERO1	Edit Rules Specification 1	String	Generic Edit	40	Allow NULL?
15	FRERO2	Edit Rules Specification 2	String	Generic Edit	40	Allow NULL?
16	FRHLP1	Help Text Program	String	Generic Edit	10	Allow NULL?
17	FRHLP2	Help List Program	String	Generic Edit	10	Allow NULL?
18	FRNNIX	Next Numbering Index Number	Numeric	Generic Edit	2	Allow NULL?
19	FRNSY	System Code - Next Numbers	String	UDC (98 SY)	4	Allow NULL?
20	FRRLS	Release Number	String	UDC (98 RL)	10	Allow NULL?
21	FRUSER	User ID	String	Generic Edit	10	Allow NULL?
22	FRUPMJ	Date - Updated	Date	Generic Edit	6
23	FRPID	Program ID	String	Generic Edit	10	Allow NULL?
24	FRJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
25	FRUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?