ASIEXP17 - ASI_SOP_Prospect_MSTR_SmartList | Prospr - Dynamics GP Table Reference

ASIEXP17 - ASI_SOP_Prospect_MSTR_SmartList

Query Builder

Select * from ASIEXP17

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ASI_Order_By	ASI_Order_By	Long Integer	4	View
PROSPID	Prospect ID	String	16	View
NOTEINDX	Note Index	Currency	10	View
CUSTNAME	Customer Name	String	66	View
CNTCPRSN	Contact Person	String	62	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
ADDRESS3	Address 3	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIP	Zip	String	12	View
COUNTRY	Country	String	62	View
CUSTCLAS	Customer Class	String	16	View
PHONE1	Phone 1	String	22	View
PHONE2	Phone 2	String	22	View
PRCLEVEL	PriceLevel	String	12	View
FAX	Fax	String	22	View
SHIPMTHD	Shipping Method	String	16	View
TAXSCHID	Tax Schedule ID	String	16	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
USER2ENT	User To Enter	String	16	View
CREATDDT	Created Date	Date	4	View
MODIFDT	Modified Date	Date	4	View
ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	4	View
PHONE3	Phone 3	String	22	View