EXPV1000 - EXP_SalesOrdersNotLinked | Prospr - Dynamics GP Table Reference

EXPV1000 - EXP_SalesOrdersNotLinked

Select * from EXPV1000

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
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
ITEMNMBR	Item Number	String	32	View
UOFM	U Of M	String	10	View
QUANTITY	QTY	Currency	10	View
QTYBACKO	QTY Backordered	Currency	10	View
ITEMFULFILLMETHOD	Item Fulfillment Method	Integer	2	View
ReqShipDate	Requested Ship Date	Date	4	View
CUSTNMBR	Customer Number	String	16	View
ITEMDESC	Item Description	String	102	View
LOCNCODE	Location Code	String	12	View
MAKEBUYCODE_I	Make/Buy_Code	Integer	2	View
AVERAGEORDQTY_I	Average ORD QTY	Currency	10	View
ITEMSTATUS_I	Item Status	Integer	2	View
EFFECTIVEDATE_I	Effective Date0	Date	4	View
CUSTPRIORITY	Customer Priority	Integer	2	View
CUSTNAME	Customer Name	String	66	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
CMPNTSEQ	Component Sequence	Long Integer	4	View