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
02: Electronic Mail
1	812	F0113	ZZ	25	1	Message Log Ledger File	Transaction Files	02: Electronic Mail	AS400 Coexistence Tables

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	ZZAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
2	ZZALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
3	ZZDTI	Date - Tickler	Date	Generic Edit	6	0
4	ZZTCNT	Message Type - 1	Character	UDC (H01 TC)	1	0	Allow NULL?
5	ZZCMPR	Message Type - 2	Character	UDC (H01 CM)	1	0	Allow NULL?
6	ZZMSG	Message Type - 3	Character	UDC (01 MT)	1	0	Allow NULL?
7	ZZCFRM	Call - From	String	Generic Edit	30	0	Allow NULL?
8	ZZCCO	Call - From Company	String	Generic Edit	30	0	Allow NULL?
9	ZZCPH	call from phone	String	Generic Edit	20	0	Allow NULL?
10	ZZPXT1	Phone Extension	String	Generic Edit	5	0	Allow NULL?
11	ZZEXPL	Explanation - Full	String	Generic Edit	1200	0	Allow NULL?
12	ZZMSGA	Action - Message Control	Character	UDC (H01 MR)	1	0	Allow NULL?
13	ZZENTT	Time - Entered	Numeric	Generic Edit	6	0	Allow NULL?
14	ZZUSER	User ID	String	Generic Edit	10	0	Allow NULL?
15	ZZPID	Program ID	String	Generic Edit	10	0	Allow NULL?
16	ZZUPMJ	Date - Updated	Date	Generic Edit	6	0
17	ZZJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
18	ZZUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
19	ZZBASE	Base Member Name	String	Generic Edit	10	0	Allow NULL?
20	ZZSY	Product Code	String	UDC (98 SY)	4	0	Allow NULL?
21	ZZDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
22	ZZSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
23	ZZDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
24	ZZLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
25	ZZKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?