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
15: Property Management
1	812	F15011	NK	23	1	Billings Generation Control Master	Balance Files	15: Property Management	AS400 Coexistence Tables

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	NKDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	Allow NULL?
2	NKBCI	Billing Control ID	Numeric	Generic Edit	8	Allow NULL?
3	NKGENT	Generation Type	Character	UDC (15 GE)	1	Allow NULL?
4	NKCTRY	Century	Numeric	Generic Edit	2	Allow NULL?
5	NKYR	Year - Calendar Year	Numeric	Generic Edit	2	Allow NULL?
6	NKBF01	Billing Period 01	Character	Generic Edit	1	Allow NULL?
7	NKBF02	Billing Period 02	Character	Generic Edit	1	Allow NULL?
8	NKBF03	Billing Period 03	Character	Generic Edit	1	Allow NULL?
9	NKBF04	Billing Period 04	Character	Generic Edit	1	Allow NULL?
10	NKBF05	Billing Period 05	Character	Generic Edit	1	Allow NULL?
11	NKBF06	Billing Period 06	Character	Generic Edit	1	Allow NULL?
12	NKBF07	Billing Period 07	Character	Generic Edit	1	Allow NULL?
13	NKBF08	Billing Period 08	Character	Generic Edit	1	Allow NULL?
14	NKBF09	Billing Period 09	Character	Generic Edit	1	Allow NULL?
15	NKBF10	Billing Period 10	Character	Generic Edit	1	Allow NULL?
16	NKBF11	Billing Period 11	Character	Generic Edit	1	Allow NULL?
17	NKBF12	Billing Period 12	Character	Generic Edit	1	Allow NULL?
18	NKBF13	Billing Period 13	Character	Generic Edit	1	Allow NULL?
19	NKUSER	User ID	String	Generic Edit	10	Allow NULL?
20	NKUPMJ	Date - Updated	Date	Generic Edit	6
21	NKPID	Program ID	String	Generic Edit	10	Allow NULL?
22	NKJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
23	NKUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?