IS010001 - ICONrol Sale Order Line | Prospr - Dynamics GP Table Reference

IS010001 - ICONrol Sale Order Line

Select * from IS010001

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
MANUFACTUREORDER_I	Manufacture Order	String	32	View
SOITEMDUEDATE_I	SO Item Due Date	Date	4	View
SOITEMPROMISEDATE_I	SO Item Promise Date	Date	4	View
CUSTOMERPARTNUMBER_I	Customer Part Number	String	32	View
SOCHANGEDATE_I	SO Change Date	Date	4	View
ITEMNMBR	Item Number	String	32	View
REVISIONLEVEL_I	Revision Level	String	52	View
MFGNOTEINDEX_I	MFG Note Index	Currency	10	View
MRKDNAMT	Markdown Amount	Currency	10	View
Markdown_Amount_Addition	Markdown Amount Additional	Currency	10	View
CHANGEDATE_I	Change Date	Date	4	View
USERID	User ID	String	16	View
QTYProcess	QTY To Process	Currency	10	View
QTYMATCH	QTY Matched	Currency	10	View