SOP60100 - SOP_POPLink | Prospr - Dynamics GP Table Reference

SOP60100 - SOP_POPLink

Select * from SOP60100

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
LNITMSEQ	Line Item Sequence	Long Integer	4	View
CMPNTSEQ	Component Sequence	Long Integer	4	View
PONUMBER	PO Number	String	18	View
ORD	Ord	Long Integer	4	View
RCTINVCERRORS	Receipt Invoicing Errors	Long Integer	4	View
RCPTCOST	Receipt Cost	Currency	10	View
RCPTPRIORITY	Receipt Priority	Integer	2	View
QTYONPO	QTY On PO	Currency	10	View
QTYONPOBASE	QTY On PO In Base	Currency	10	View
QTYRECVD	QTY Received	Currency	10	View
QTYRECINBASE	QTY Received In Base	Currency	10	View
RQSTFFDATE	Requested Fulfillment Date	Date	4	View
QTYBSUOM	QTY In Base U Of M	Currency	10	View
LOCNCODE	Location Code	String	12	View