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
17: Customer Service Management
1	920	F4117	PR	22	1	Item Master - Service/Warranty Extension	Secondary Master Files	17: Customer Service Management	Business Data

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	PRITM	Item Number - Short	Numeric	Generic Edit	8	Allow NULL?
2	PRPRODM	Product Model	String	UDC (17 PM)	8	Allow NULL?
3	PRPRODF	Product Family	String	UDC (17 PA)	8	Allow NULL?
4	PRMCUZ	Business Unit - Alt	String	Generic Edit	12	Allow NULL?
5	PRDCD1	Disposition Code 1	String	UDC (17 P1)	3	Allow NULL?
6	PRDCD2	Disposition Code 2	String	UDC (17 P2)	3	Allow NULL?
7	PRDCD3	Disposition Code 3	String	UDC (17 P3)	3	Allow NULL?
8	PRDCD4	Disposition Code 4	String	UDC (17 P4)	3	Allow NULL?
9	PRDCD5	Disposition Code 5	String	UDC (17 P5)	3	Allow NULL?
10	PRCRTU	Created by user	String	Generic Edit	10	Allow NULL?
11	PRUSER	User ID	String	Generic Edit	10	Allow NULL?
12	PRPID	Program ID	String	Generic Edit	10	Allow NULL?
13	PRJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
14	PRUPMJ	Date - Updated	Date	Generic Edit	6
15	PRUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?
16	PRRTRND	Returnable Flag	Character	UDC (17 TF)	1	Allow NULL?
17	PRRPRBL	Repairable Flag	Character	UDC (17 TF)	1	Allow NULL?
18	PRCCOST	S/WM Cost Component	String	UDC (30 CA)	3	Allow NULL?
19	PRRETPOL	Return Policy	Character	UDC (17 RT)	1	Allow NULL?
20	PRSRYN	Eligible Supplier Recovery	Character	UDC (17 SR)	1	Allow NULL?
21	PRIBYN	Create Equipment Master	Character	Generic Edit	1	Allow NULL?
22	PRVMRS33	Component Code - Part	String	UDC (17 C8)	10	Allow NULL?