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
01: Address Book
1	812	F01161	WL	22	1	Alternate Address	Secondary Master Files	01: Address Book	No

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	WLAN8	Address Number	Numeric	UDC	8	Allow NULL?
2	WLIDLN	Who's Who Line Number - ID	Numeric	Generic Edit	5	Allow NULL?
3	WLEFTB	Date - Beginning Effective	Date	Generic Edit	6
4	WLATYPE	Type - Address	String	UDC (01 AT)	5	Allow NULL?
5	WLADD1	Address Line 1	String	Generic Edit	40	Allow NULL?
6	WLADD2	Address Line 2	String	Generic Edit	40	Allow NULL?
7	WLADD3	Address Line 3	String	Generic Edit	40	Allow NULL?
8	WLADD4	Address Line 4	String	Generic Edit	40	Allow NULL?
9	WLADDZ	Postal Code	String	Generic Edit	12	Allow NULL?
10	WLCTY1	City	String	Generic Edit	25	Allow NULL?
11	WLCOUN	County	String	UDC (00 CT)	25	Allow NULL?
12	WLADDS	State	String	UDC (00 S)	3	Allow NULL?
13	WLCTR	Country	String	UDC (00 CN)	3	Allow NULL?
14	WLEFTF	Effective Date Existence (1/0)	Character	Generic Edit	1	Allow NULL?
15	WLUSER	User ID	String	Generic Edit	10	Allow NULL?
16	WLPID	Program ID	String	Generic Edit	10	Allow NULL?
17	WLUPMJ	Date - Updated	Date	Generic Edit	6
18	WLJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
19	WLUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?
20	WLMAINA	Main Address Flag	Character	UDC (01 MA)	1	Allow NULL?
21	WLSYNCS	Synchronization Status	Numeric	UDC (90CA SY)	2	Allow NULL?
22	WLCAAD	Server Status	Numeric	UDC (90CA SE)	2	Allow NULL?