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
49: Transportation Management
1	812	F4908	II	24	1	Item Shipping Information	Secondary Master Files	49: Transportation Management	No

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	IIITM	Item Number - Short	Numeric	Generic Edit	8	Allow NULL?
2	IIHSCD	Harmonized Shipping Code	String	Generic Edit	12	Allow NULL?
3	IIPDCG	Producer of Goods	String	UDC (49 BV)	4	Allow NULL?
4	IIPFCT	Preference Criteria	Character	UDC (49 BU)	1	Allow NULL?
5	IIDMFR	Domestic/Foreign Commodity	Character	UDC (49 BW)	1	Allow NULL?
6	IIECCN	Export Control Commodity Number	String	Generic Edit	10	Allow NULL?
7	IIUNNA	UN or NA Number	String	Generic Edit	6	Allow NULL?
8	IIHZDC	Hazard Class or Division	String	UDC (49 BX)	3	Allow NULL?
9	IIPKGP	Packaging Group	String	UDC (49 BY)	3	Allow NULL?
10	IISRSK	Subsidiary Risk	String	UDC (49 BZ)	3	Allow NULL?
11	IIFPNT	Flash Point Temperature	Numeric	Generic Edit	4	Allow NULL?
12	IISTPU	Temperature Type	Character	UDC (41B TP)	1	Allow NULL?
13	IIPKIN	Packaging Instructions	String	UDC (49 CB)	4	Allow NULL?
14	IIHZDL	Hazard Label	String	UDC (49 CC)	3	Allow NULL?
15	IINMFI	NMFC Item Number	String	Generic Edit	6	Allow NULL?
16	IINMFC	Freight Classification (NMFC)	String	UDC (49 BE)	4	Allow NULL?
17	IISTCC	Standard Transportation Commodity Code	String	Generic Edit	10	Allow NULL?
18	IIFRT1	Freight Category Code 1	String	UDC (49 CJ)	6	Allow NULL?
19	IIFRT2	Freight Category Code 2	String	UDC (49 CK)	6	Allow NULL?
20	IIUSER	User ID	String	Generic Edit	10	Allow NULL?
21	IIPID	Program ID	String	Generic Edit	10	Allow NULL?
22	IIJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
23	IIUPMJ	Date - Updated	Date	Generic Edit	6
24	IITDAY	Time of Day	Numeric	Generic Edit	6	Allow NULL?