MRP0101 - mrpItemSitesList | Prospr - Dynamics GP Table Reference

MRP0101 - mrpItemSitesList

Select * from MRP0101

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ITEMNMBR	Item Number	String	32	View
LOCNCODE	Location Code	String	12	View
REPLENISHMENTMETHOD	Replenishment Method 1 – Make 2 – Buy 3- Make or Buy	Integer	2	View
PRIMVNDR	Primary Vendor	String	16	View
PRCHSNGLDTM	Purchasing Lead Time	Currency	10	View
MNFCTRNGFXDLDTM	Manufacturing Fixed Lead Time	Currency	10	View
MNFCTRNGVRBLLDTM	Manufacturing Variable Lead Time	Currency	10	View
MNMMORDRQTY	Minimum Order Qty	Currency	10	View
MXMMORDRQTY	Maximum Order Qty	Currency	10	View
ORDERMULTIPLE	Order Multiple	Currency	10	View
FXDORDRQTY	Fixed Order Qty	Currency	10	View
NMBROFDYS	Number of Days	Integer	2	View
ORDRPNTQTY	Order Point Qty	Currency	10	View
ORDRUPTOLVL	Order Up To Level	Currency	10	View
SFTYSTCKQTY	Safety Stock Qty	Currency	10	View
ORDERPOLICY	Order Policy 1 – Not planned 2 – Lot for Lot 3 – Fixed Order Quantity 4 – Period Order Quantity 5 – Order Point 6 – Manually Planned (Removed for version 10.0)	Integer	2	View
SHRINKAGEFACTOR	Shrinkage Factor	Currency	10	View
PLNNNGTMFNCDYS	Planning Time Fence Days	Integer	2	View
PLANNERID	Planner ID	String	16	View
BUYERID	Buyer ID	String	16	View
MOVEIN	MoveIn	Boolean	2	View
MOVEOUT	MoveOut	Boolean	2	View
CANCELED	Cancelled	Boolean	2	View
Move_Out_Fence	Move-Out Fence	Integer	2	View