MRPV0001 - Workbench Item Master Quantity | Prospr - Dynamics GP Table Reference

MRPV0001 - Workbench Item Master Quantity

Query Builder

Select * from MRPV0001

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ITEMNMBR	Item Number	String	32	View
LOCNCODE	Location Code	String	12	View
BINNMBR	Bin Number	String	22	View
RCRDTYPE	Record Type	Integer	2	View
PRIMVNDR	Primary Vendor	String	16	View
ITMFRFLG	Item Freeze Flag	Boolean	2	View
BGNGQTY	Beginning QTY	Currency	10	View
LSORDQTY	Last ORD QTY	Currency	10	View
LRCPTQTY	Last RCPT QTY	Currency	10	View
LSTORDDT	Last ORD Date	Date	4	View
LSORDVND	Last ORD Vendor	String	16	View
LSRCPTDT	Last RCPT Date	Date	4	View
QTYRQSTN	QTY Requisitioned	Currency	10	View
QTYONORD	QTY On Order	Currency	10	View
QTYBKORD	QTY Back Ordered	Currency	10	View
QTY_Drop_Shipped	QTY Drop Shipped	Currency	10	View
ORDRPNTQTY	Order Point Qty	Currency	10	View
REORDERVARIANCE	Reorder Variance	Currency	10	View
ORDRUPTOLVL	Order Up To Level	Currency	10	View
QTYINUSE	QTY In Use	Currency	10	View
QTYINSVC	QTY In Service	Currency	10	View
QTYRTRND	QTY Returned	Currency	10	View
QTYDMGED	QTY Damaged	Currency	10	View
QTYONHND	QTY On Hand	Currency	10	View
ATYALLOC	QTY Allocated	Currency	10	View
QTYCOMTD	QTY Committed	Currency	10	View
QTYSOLD	QTY Sold	Currency	10	View
NXTCNTDT	Next Count Date	Date	4	View
NXTCNTTM	Next Count Time	Time	4	View
LSTCNTDT	Last Count Date	Date	4	View
LSTCNTTM	Last Count Time	Time	4	View
STCKCNTINTRVL	Stock Count Interval	Integer	2	View