IV10002 - Inventory Serial and Lot Number Work | Prospr - Dynamics GP Table Reference

IV10002 - Inventory Serial and Lot Number Work

Query Builder

Select * from IV10002

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
IVDOCNBR	IV Document Number	String	18	View
IVDOCTYP	IV Document Type	Integer	2	View
ITEMNMBR	Item Number	String	32	View
SERLTNUM	Serial/Lot Number	String	22	View
SERLTQTY	Serial/Lot QTY	Currency	10	View
LNSEQNBR	Line SEQ Number	Currency	10	View
SLTSQNUM	Serial/Lot SEQ Number	Long Integer	4	View
DATERECD	Date Received	Date	4	View
DTSEQNUM	Date SEQ Number	Currency	10	View
OVRSERLT	Override Serial/Lot	Integer	2	View
QTYSCRAPPED	Quantity Scrapped	Currency	10	View
FROMBIN	From Bin	String	16	View
TOBIN	To Bin	String	16	View
MFGDATE	Manufacture Date	Date	4	View
EXPNDATE	Expiration Date	Date	4	View