IS010202 - Manufacturing Sales Serial/Lot Work and History | Prospr

IS010202 - Manufacturing Sales Serial/Lot Work and History

Select * from IS010202

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
LNITMSEQ	Line Item Sequence	Long Integer	4	View
CMPNTSEQ	Component Sequence	Long Integer	4	View
QTYTYPE	QTY Type 1 = On Hand 2 = Returned 3 = In Use 4 = In Service 5 = Damaged	Integer	2	View
SLTSQNUM	Serial/Lot SEQ Number	Long Integer	4	View
DATE1	Date	Date	4	View
DTSEQNUM	Date SEQ Number	Currency	10	View
SERLTNUM	Serial/Lot Number	String	22	View
SERLTQTY	Serial/Lot QTY	Currency	10	View
BIN	Bin	String	16	View