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
41: Inventory Management
1	920	F4101G	IB	20	1	Item Branch Quantities	Secondary Master Files	41: Inventory Management	Business Data

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	IBMCU	Business Unit	String	Generic Edit	12	Allow NULL?
2	IBITM	Item Number - Short	Numeric	Generic Edit	8	Allow NULL?
3	IBSTAW	Status	Character	UDC (00 WS)	1	Allow NULL?
4	IBEFFT	Effective - Thru Date	Date	Generic Edit	6
5	IBDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	Allow NULL?
6	IBDCT	Document Type	String	UDC (00 DT)	2	Allow NULL?
7	IBEFFF	Effective - From Date	Date	Generic Edit	6
8	IBSERK	Key Value Serial Number	Numeric	Generic Edit	15	Allow NULL?
9	IBROPI	Reorder Point - Input	Numeric	Generic Edit	15	Allow NULL?
10	IBROQI	Reorder Quantity - Input	Numeric	Generic Edit	15	Allow NULL?
11	IBRQMX	Reorder Quantity - Maximum	Numeric	Generic Edit	15	Allow NULL?
12	IBRQMN	Reorder Quantity - Minimum	Numeric	Generic Edit	15	Allow NULL?
13	IBSAFE	Safety Stock	Numeric	Generic Edit	15	Allow NULL?
14	IBUPC	Units - Per Container	Numeric	Generic Edit	15	Allow NULL?
15	IBMULT	Quantity - Order Multiples (MRP)	Numeric	Generic Edit	15	Allow NULL?
16	IBUSER	User ID	String	Generic Edit	10	Allow NULL?
17	IBPID	Program ID	String	Generic Edit	10	Allow NULL?
18	IBJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
19	IBUPMJ	Date - Updated	Date	Generic Edit	6
20	IBTDAY	Time of Day	Numeric	Generic Edit	6	Allow NULL?