MRP4060 - mrpSopLinesEPS | Prospr - Dynamics GP Table Reference

MRP4060 - mrpSopLinesEPS

Query Builder

Select * from MRP4060

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
ORDERNUMBER	Order Number	String	32	View
SOPTYPE	SOP Type 1 = Quote 2 = Order 3 = Invoice 4 = Return 5 = Back Order 6 = Fulfillment Order (In SBF, this value is not available.)	Integer	2	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
CMPNTSEQ	Component Sequence	Long Integer	4	View
MRPTYPE	MRP_Type	Integer	2	View
Status	Status	Integer	2	View
STSDESCR	Status Description	String	32	View
QUOTESALESORDERS	QuoteSalesOrders	Currency	10	View
ORDERSALESORDERS	OrderSalesOrders	Currency	10	View
BOSALESORDERS	BackOrderSalesOrders	Currency	10	View
UNMTSALESFRCST	UnmetSalesForecast	Currency	10	View
HASMRPEXCEPTION_1	HasMRPException[1]	Boolean	2	View
HASMRPEXCEPTION_2	HasMRPException[2]	Boolean	2	View
HASMRPEXCEPTION_3	HasMRPException[3]	Boolean	2	View
HASMRPEXCEPTION_4	HasMRPException[4]	Boolean	2	View
HASMRPEXCEPTION_5	HasMRPException[5]	Boolean	2	View
HASMRPEXCEPTION_6	HasMRPException[6]	Boolean	2	View
HASMRPEXCEPTION_7	HasMRPException[7]	Boolean	2	View
HASMRPEXCEPTION_8	HasMRPException[8]	Boolean	2	View
HASMRPEXCEPTION_9	HasMRPException[9]	Boolean	2	View
HASMRPEXCEPTION_10	HasMRPException[10]	Boolean	2	View
HASMRPEXCEPTION_11	HasMRPException[11]	Boolean	2	View
HASMRPEXCEPTION_12	HasMRPException[12]	Boolean	2	View
HASMRPEXCEPTION_13	HasMRPException[13]	Boolean	2	View
HASMRPEXCEPTION_14	HasMRPException[14]	Boolean	2	View
HASMRPEXCEPTION_15	HasMRPException[15]	Boolean	2	View
HASMRPEXCEPTION_16	HasMRPException[16]	Boolean	2	View
HASMRPEXCEPTION_17	HasMRPException[17]	Boolean	2	View
HASMRPEXCEPTION_18	HasMRPException[18]	Boolean	2	View
HASMRPEXCEPTION_19	HasMRPException[19]	Boolean	2	View
HASMRPEXCEPTION_20	HasMRPException[20]	Boolean	2	View

MRP4060 - mrpSopLinesEPS

Query Builder

Customer Service

Information

My Account

Contact Us