SOP00200 - Sales Prospect Master | Prospr - Dynamics GP Table Reference

SOP00200 - Sales Prospect Master

Query Builder

Select * from SOP00200

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
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
PHONE3	Phone 3	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