gpItmCus - gpsItemLookup | Prospr - Dynamics GP Table Reference

gpItmCus - gpsItemLookup

Select * from gpItmCus

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CUSTNMBR	Customer Number	String	16	View
ITEMNMBR	Item Number	String	32	View
ITEMDESC	Item Description	String	102	View
DOCDATE	Document Date	Date	4	View
QTYTOINV	QTY To Invoice	Currency	10	View
UOFM	U Of M	String	10	View
UNITPRCE	Unit Price	Currency	10	View
SOPNUMBE	SOP Number	String	22	View
SOPTYPE	SOP Type 1 = Quote 2 = Order 3 = Invoice 4 = Return 5 = Back Order 6 = Fulfillment Order (In SBF, this value is not available.)	Integer	2	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
DECPLCUR	Decimal Places Currency	Integer	2	View