IV00300 - Item Lot Number Master | Prospr - Dynamics GP Table Reference

IV00300 - Item Lot Number Master

Select * from IV00300

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
LOTNUMBR	Lot Number	String	22	View
QTYRECVD	QTY Received	Currency	10	View
QTYSOLD	QTY Sold	Currency	10	View
ATYALLOC	QTY Allocated	Currency	10	View
UNITCOST	Unit Cost	Currency	10	View
RCTSEQNM	Receipt SEQ Number	Long Integer	4	View
VNDRNMBR	Vendor Number	String	26	View
LTNUMSLD	Lot 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
MFGDATE	Manufacture Date	Date	4	View
EXPNDATE	Expiration Date	Date	4	View