MRP1020 - PR_Short_Items_Consolidate | Prospr - Dynamics GP Table Reference

MRP1020 - PR_Short_Items_Consolidate

Query Builder

Select * from MRP1020

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
USERID	User ID	String	16	View
ITEMNMBR	Item Number	String	32	View
LOCNCODE	Location Code	String	12	View
MRPISSUEDATE_I	MRP_Issue Date	Date	4	View
SHORTAMOUNT_I_1	Short Amount[1]	Currency	10	View
SHORTAMOUNT_I_2	Short Amount[2]	Currency	10	View
VENDORID	Vendor ID	String	16	View
ORD	Ord	Long Integer	4	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
Buy_Total	Buy Total	Currency	10	View
STR30	STR30	String	32	View
RNNMBR	Run Number	Long Integer	4	View