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
05: Time Accounting and HRM Base
1	812	F054111	CH	25	1	Employee Emergency Contact History Table	Files	05: Time Accounting and HRM Base

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	CHAN8	Address Number	Numeric	UDC	8	Allow NULL?
2	CHIDLN	Who's Who Line Number - ID	Numeric	Generic Edit	5	Allow NULL?
3	CHSLNM	Salutation Name	String	Generic Edit	40	Allow NULL?
4	CHMLNM	Name - Mailing	String	Generic Edit	40	Allow NULL?
5	CHGNNM	Name - Given	String	Generic Edit	25	Allow NULL?
6	CHIMN	Initial - Middle Name (Govt Rpts)	Character	Generic Edit	1	Allow NULL?
7	CHSRNM	Name - Surname	String	Generic Edit	25	Allow NULL?
8	CHADD1	Address Line 1	String	Generic Edit	40	Allow NULL?
9	CHCTY1	City	String	Generic Edit	25	Allow NULL?
10	CHADDS	State	String	UDC (00 S)	3	Allow NULL?
11	CHADDZ	Postal Code	String	Generic Edit	12	Allow NULL?
12	CHCTR	Country	String	UDC (00 CN)	3	Allow NULL?
13	CHTYC	Type Code	Character	UDC (01 W0)	1	Allow NULL?
14	CHATTL	Professional Title	String	Generic Edit	40	Allow NULL?
15	CHDSS5	Display Sequence- 5.2	Numeric	Generic Edit	5	Allow NULL?
16	CHREM1	Remark 1	String	Generic Edit	40	Allow NULL?
17	CHUSER	User ID	String	Generic Edit	10	Allow NULL?
18	CHPID	Program ID	String	Generic Edit	10	Allow NULL?
19	CHJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
20	CHUPMJ	Date - Updated	Date	Generic Edit	6
21	CHUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?
22	CHESIGN	E-Signature ID	String	Generic Edit	16	Allow NULL?
23	CHMUMJ	Update Date	Date	Generic Edit	6
24	CHMUMT	Update Time	Numeric	Generic Edit	6	Allow NULL?
25	CHUPID	Updated By	String	Generic Edit	10	Allow NULL?