SOP40700 - Extended Pricing Customer Price Report | Prospr - Dynamics GP Table Reference

SOP40700 - Extended Pricing Customer Price Report

Query Builder

Select * from SOP40700

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
USERID	User ID	String	16	View
CUSTNMBR	Customer Number	String	16	View
ITEMNMBR	Item Number	String	32	View
ITEMDESC	Item Description	String	102	View
DECPLCUR	Decimal Places Currency	Integer	2	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
UOFM	U Of M	String	10	View
QTYFROM	QTYFrom	Currency	10	View
QTYTO	QTYTo	Currency	10	View
UMQTYINB	U Of M QTY In Base	Currency	10	View
UNITPRCE	Unit Price	Currency	10	View
CURNCYID	Currency ID	String	16	View
ORUNTPRC	Originating Unit Price	Currency	10	View
ERMSGTXT	Error Message Text	String	256	View