IV00103 - Item Vendor Master | Prospr - Dynamics GP Table Reference

IV00103 - Item Vendor Master

Query Builder

Select * from IV00103

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ITEMNMBR	Item Number	String	32	View
VENDORID	Vendor ID	String	16	View
ITMVNDTY	Item Vendor Type	Integer	2	View
VNDITNUM	Vendor Item Number	String	32	View
QTYRQSTN	QTY Requisitioned	Currency	10	View
QTYONORD	QTY On Order	Currency	10	View
QTY_Drop_Shipped	QTY Drop Shipped	Currency	10	View
LSTORDDT	Last ORD Date	Date	4	View
LSORDQTY	Last ORD QTY	Currency	10	View
LRCPTQTY	Last RCPT QTY	Currency	10	View
LSRCPTDT	Last RCPT Date	Date	4	View
LRCPTCST	Last RCPT Cost	Currency	10	View
AVRGLDTM	Average Lead Time	Long Integer	4	View
NORCTITM	Number Of RCPTS For Item	Integer	2	View
MINORQTY	Minimum ORD QTY	Currency	10	View
MAXORDQTY	Maximum ORD QTY	Currency	10	View
ECORDQTY	Economic ORD QTY	Currency	10	View
VNDITDSC	Vendor Item Description	String	102	View
Last_Originating_Cost	Last Originating Cost	Currency	10	View
Last_Currency_ID	Last Currency ID	String	16	View
FREEONBOARD	Free On Board	Integer	2	View
PRCHSUOM	Purchasing U Of M	String	10	View
CURRNIDX	Currency Index	Integer	2	View
PLANNINGLEADTIME	Planning Lead Time	Integer	2	View
ORDERMULTIPLE	Order Multiple	Currency	10	View
MNFCTRITMNMBR	Manufacture Item Number	String	32	View