MRPW4060 - mrpSopLinesWork | Prospr - Dynamics GP Table Reference

MRPW4060 - mrpSopLinesWork

Select * from MRPW4060

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
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
SOPNUMBE	SOP Number	String	22	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
CMPNTSEQ	Component Sequence	Long Integer	4	View
ITEMNMBR	Item Number	String	32	View
LOCNCODE	Location Code	String	12	View
REPTING	Repeating 0 = Non-repeating document 1 = Repeating	Boolean	2	View
TRXFREQU	TRX Frequency 1 = Weekly 2 = Biweekly 3 = Semimonthly 4 = Monthly 5 = Bimonthly 6 = Quarterly 7 = Miscellaneous	Integer	2	View
TIMETREP	Times To Repeat	Integer	2	View
DYSTINCR	Days to Increment	Integer	2	View
QUANTITY	QTY	Currency	10	View
QTYTBAOR	QTY To Back Order	Currency	10	View
DUEDATE	Due Date	Date	4	View
STSDESCR	Status Description	String	32	View
Status	Status	Integer	2	View
CALCMRP_I	Calc MRP	Boolean	2	View
MRPEXCEPTIONSARRAY_1	MRP_Exceptions_Array[1]	Integer	2	View
MRPEXCEPTIONSARRAY_2	MRP_Exceptions_Array[2]	Integer	2	View
MRPEXCEPTIONSARRAY_3	MRP_Exceptions_Array[3]	Integer	2	View
MRPEXCEPTIONSARRAY_4	MRP_Exceptions_Array[4]	Integer	2	View
MRPEXCEPTIONSARRAY_5	MRP_Exceptions_Array[5]	Integer	2	View
MRPEXCEPTIONSARRAY_6	MRP_Exceptions_Array[6]	Integer	2	View
MRPEXCEPTIONSARRAY_7	MRP_Exceptions_Array[7]	Integer	2	View
MRPEXCEPTIONSARRAY_8	MRP_Exceptions_Array[8]	Integer	2	View
MRPEXCEPTIONSARRAY_9	MRP_Exceptions_Array[9]	Integer	2	View
MRPEXCEPTIONSARRAY_10	MRP_Exceptions_Array[10]	Integer	2	View
BUYERID	Buyer ID	String	16	View
PLANNERID	Planner ID	String	16	View