IV10302 - Stock Count Serial Lot | Prospr - Dynamics GP Table Reference

IV10302 - Stock Count Serial Lot

Select * from IV10302

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
STCKCNTID	Stock Count ID	String	16	View
ITEMNMBR	Item Number	String	32	View
LOCNCODE	Location Code	String	12	View
BINNMBR	Bin Number	String	22	View
COUNTEDQTY	Counted Qty	Currency	10	View
CAPTUREDQTY	Captured Qty	Currency	10	View
DATERECD	Date Received	Date	4	View
DTSEQNUM	Date SEQ Number	Currency	10	View
ITMTRKOP	Item Tracking Option 1. None 2. Serial Numbers 3. Lot Numbers	Integer	2	View
SERLTNUM	Serial/Lot Number	String	22	View
SERIALSTATUS	Serial Status	Integer	2	View
VARIANCEQTY	Variance Qty	Currency	10	View
VERIFIED	Verified	Boolean	2	View
QTYTYPE	QTY Type 1 = On Hand 2 = Returned 3 = In Use 4 = In Service 5 = Damaged	Integer	2	View
Temp_Allocated_Quantity	Temp Allocated Quantity	Currency	10	View
MFGDATE	Manufacture Date	Date	4	View
EXPNDATE	Expiration Date	Date	4	View