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
00: Foundation Environment
1	812	F0008	CD	25	2	Date Fiscal Patterns	Constants Files	00: Foundation Environment	AS400 Coexistence Tables

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	CDDTPN	Fiscal Date Pattern	Character	UDC (H00 DP)	1	Allow NULL?
2	CDFY	Fiscal Year	Numeric	Generic Edit	2	Allow NULL?
3	CDDFYJ	Date - Fiscal Year Begins	Date	Generic Edit	6
4	CDFQ	Fiscal Quarter (Obsolete)	String	UDC (H09 FQ)	4	Allow NULL?
5	CDD01J	Date - End of Period 01	Date	Generic Edit	6
6	CDD02J	Date - End of Period 02	Date	Generic Edit	6
7	CDD03J	Date - End of Period 03	Date	Generic Edit	6
8	CDD04J	Date - End of Period 04	Date	Generic Edit	6
9	CDD05J	Date - End of Period 05	Date	Generic Edit	6
10	CDD06J	Date - End of Period 06	Date	Generic Edit	6
11	CDD07J	Date - End of Period 07	Date	Generic Edit	6
12	CDD08J	Date - End of Period 08	Date	Generic Edit	6
13	CDD09J	Date - End of Period 09	Date	Generic Edit	6
14	CDD10J	Date - End of Period 10	Date	Generic Edit	6
15	CDD11J	Date - End of Period 11	Date	Generic Edit	6
16	CDD12J	Date - End of Period 12	Date	Generic Edit	6
17	CDD13J	Date - End of Period 13	Date	Generic Edit	6
18	CDD14J	Date - End of Period 14	Date	Generic Edit	6
19	CDPNT	Date Pattern Type	Character	UDC (00 PT)	1	Allow NULL?
20	CDUSER	User ID	String	Generic Edit	10	Allow NULL?
21	CDPID	Program ID	String	Generic Edit	10	Allow NULL?
22	CDUPMJ	Date - Updated	Date	Generic Edit	6
23	CDJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
24	CDUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?
25	CDCTRY	Century	Numeric	Generic Edit	2	Allow NULL?