SVC3200V - SVC_SOP_History_View | Prospr - Dynamics GP Table Reference

SVC3200V - SVC_SOP_History_View

Select * from SVC3200V

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
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
SOPNUMBE	SOP Number	String	22	View
CUSTNMBR	Customer Number	String	16	View
CUSTNAME	Customer Name	String	66	View
CSTPONBR	Customer PO Number	String	22	View
DOCDATE	Document Date	Date	4	View
CMPNTSEQ	Component Sequence	Long Integer	4	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
ITEMNMBR	Item Number	String	32	View
ITEMDESC	Item Description	String	102	View
LOCNCODE	Location Code	String	12	View
UOFM	U Of M	String	10	View
PRCLEVEL	PriceLevel	String	12	View
EXTDCOST	Extended Cost	Currency	10	View
XTNDPRCE	Extended Price	Currency	10	View
QTYFULFI	QTY Fulfilled	Currency	10	View