SOP70100 - Sales Inquiry Restrictions | Prospr - Dynamics GP Table Reference

SOP70100 - Sales Inquiry Restrictions

Query Builder

Select * from SOP70100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
INQID	Inquiry ID	String	16	View
HISTORY	History	Boolean	2	View
UNPSTTRX	Unposted Trx	Boolean	2	View
SORTBY	Sort By	Integer	2	View
NOTEINDX	Note Index	Currency	10	View
CREATDDT	Created Date	Date	4	View
MODIFDT	Modified Date	Date	4	View
USER2ENT	User To Enter	String	16	View
STCUSTID	Start Customer ID	String	16	View
ENCUSTID	End Customer ID	String	16	View
STCUSTNM	Start Customer Name	String	66	View
ENCSTNAM	End Customer Name	String	66	View
STTDOCDT	Start Document Date	Date	4	View
ENDDOCDT	End Document Date	Date	4	View
STDOCNUM	Start Document Number	String	22	View
ENDOCNUM	End Document Number	String	22	View
STSOPTYP	Start SOP Type	Integer	2	View
EDSOPTYP	End SOP Type	Integer	2	View
STTDOCID	Start Document ID	String	16	View
ENDDOCID	End Document ID	String	16	View
STTITNUM	Start Item Number	String	32	View
ENITMNBR	End Item Number	String	32	View
STMSTNMB	Start Master Number	Long Integer	4	View
EDMASNMB	End Master Number	Long Integer	4	View
STTPHON1	Start Phone 1	String	22	View
ENDPHON1	End Phone 1	String	22	View
STQUOEXD	Start Quote Expiration Date	Date	4	View
EDQUOEXD	End Quote Expiration Date	Date	4	View
STREQDAT	Start Requested Ship Date	Date	4	View
ENDREQDT	End Requested Ship Date	Date	4	View
STSPRSID	Start Salesperson ID	String	16	View
ENSPSNID	End Salesperson ID	String	16	View
STTUDEF1	Start User Defined 1	String	22	View
ENUSRDF1	End User Defined 1	String	22	View
Start_Purchasing_Status	Start Purchasing Status	Integer	2	View
End_Purchasing_Status	End Purchasing Status	Integer	2	View