MRP1010 - PR_Short_Items_Work | Prospr - Dynamics GP Table Reference

MRP1010 - PR_Short_Items_Work

Query Builder

Select * from MRP1010

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
STR30	STR30	String	32	View
Buy_Total	Buy Total	Currency	10	View
UOFM	U Of M	String	10	View
RELEASEDATE_I	Release Date	Date	4	View
RNNMBR	Run Number	Long Integer	4	View
ITEMDESC	Item Description	String	102	View