MRP2230 - mrpWeeksEPS | Prospr - Dynamics GP Table Reference

MRP2230 - mrpWeeksEPS

Query Builder

Select * from MRP2230

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ITEMNMBR	Item Number	String	32	View
LOCNCODE	Location Code	String	12	View
DUEDATE	Due Date	Date	4	View
ORDRPNTQTY	Order Point Qty	Currency	10	View
IVREPLENISHMENT	IvReplenishment	Currency	10	View
MADEBYMOOPEN	MadeByMoOpen	Currency	10	View
MADEBYMORELEASED	MadeByMoReleased	Currency	10	View
ALLCBYMOOPEN	AllocatedByMoOpen	Currency	10	View
ALLOCBYMORELEASED	AllocatedByMoReleased	Currency	10	View
REQBYMOOPEN	RequiredByMoOpen	Currency	10	View
REQBYMORELEASED	RequiredByMoReleased	Currency	10	View
CNSMDBYMOOPEN	ConsumedByMoOpen	Currency	10	View
CNSMDBYMORELEASED	ConsumedByMoReleased	Currency	10	View
QUOTESALESORDERS	QuoteSalesOrders	Currency	10	View
ORDERSALESORDERS	OrderSalesOrders	Currency	10	View
BOSALESORDERS	BackOrderSalesOrders	Currency	10	View
UNMTSALESFRCST	UnmetSalesForecast	Currency	10	View
PLNNDPRCHSORDERS	PlannedPurchaseOrders	Currency	10	View
FIRMPRCHSORDERS	FirmPurchaseOrders	Currency	10	View
REQPLANNED	RequiredPlanned	Currency	10	View
REQFIRM	RequiredFirm	Currency	10	View
ACQUIREDPLANNED	AcquiredPlanned	Currency	10	View
AQUIREDFIRM	AcquiredFirm	Currency	10	View
ONHANDFIRM	OnHandFirm	Currency	10	View
ONHANDTOTAL	OnHandTotal	Currency	10	View
ATPFIRM	AtpFirm	Currency	10	View
ATPTOTAL	AtpTotal	Currency	10	View
GROSSREQUIREMENT	GrossRequirement	Currency	10	View
NETREQUIREMENT	NetRequirement	Currency	10	View
MRPSUGGESTIONS	MRPSuggestions	Currency	10	View