IV00200 - Item Serial Number Master | Prospr - Dynamics GP Table Reference

IV00200 - Item Serial Number Master

Select * from IV00200

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ITEMNMBR	Item Number	String	32	View
LOCNCODE	Location Code	String	12	View
DATERECD	Date Received	Date	4	View
DTSEQNUM	Date SEQ Number	Currency	10	View
SERLNMBR	Serial Number	String	22	View
FGDITMNM	Finished Good Item Number	String	32	View
FGSERNBR	Finished Good Serial Number	String	22	View
UNITCOST	Unit Cost	Currency	10	View
RCTSEQNM	Receipt SEQ Number	Long Integer	4	View
VNDRNMBR	Vendor Number	String	26	View
CMPFINGD	Component Of Finished Good	Boolean	2	View
SERLNSLD	Serial Number Sold	Boolean	2	View
QTYTYPE	QTY Type 1 = On Hand 2 = Returned 3 = In Use 4 = In Service 5 = Damaged	Integer	2	View
BIN	Bin	String	16	View