IV00102 - Item Quantity Master | Prospr - Dynamics GP Table Reference

IV00102 - Item Quantity Master

Query Builder

Select * from IV00102

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ITEMNMBR	Item Number	String	32	View
LOCNCODE	Location Code	String	12	View
BINNMBR	Bin Number	String	22	View
RCRDTYPE	Record Type	Integer	2	View
PRIMVNDR	Primary Vendor	String	16	View
ITMFRFLG	Item Freeze Flag	Boolean	2	View
BGNGQTY	Beginning QTY	Currency	10	View
LSORDQTY	Last ORD QTY	Currency	10	View
LRCPTQTY	Last RCPT QTY	Currency	10	View
LSTORDDT	Last ORD Date	Date	4	View
LSORDVND	Last ORD Vendor	String	16	View
LSRCPTDT	Last RCPT Date	Date	4	View
QTYRQSTN	QTY Requisitioned	Currency	10	View
QTYONORD	QTY On Order	Currency	10	View
QTYBKORD	QTY Back Ordered	Currency	10	View
QTY_Drop_Shipped	QTY Drop Shipped	Currency	10	View
QTYINUSE	QTY In Use	Currency	10	View
QTYINSVC	QTY In Service	Currency	10	View
QTYRTRND	QTY Returned	Currency	10	View
QTYDMGED	QTY Damaged	Currency	10	View
QTYONHND	QTY On Hand	Currency	10	View
ATYALLOC	QTY Allocated	Currency	10	View
QTYCOMTD	QTY Committed	Currency	10	View
QTYSOLD	QTY Sold	Currency	10	View
NXTCNTDT	Next Count Date	Date	4	View
NXTCNTTM	Next Count Time	Time	4	View
LSTCNTDT	Last Count Date	Date	4	View
LSTCNTTM	Last Count Time	Time	4	View
STCKCNTINTRVL	Stock Count Interval	Integer	2	View
Landed_Cost_Group_ID	Landed Cost Group ID	String	16	View
BUYERID	Buyer ID	String	16	View
PLANNERID	Planner ID	String	16	View
ORDERPOLICY	Order Policy 1 – Not planned 2 – Lot for Lot 3 – Fixed Order Quantity 4 – Period Order Quantity 5 – Order Point 6 – Manually Planned (Removed for version 10.0)	Integer	2	View
FXDORDRQTY	Fixed Order Qty	Currency	10	View
ORDRPNTQTY	Order Point Qty	Currency	10	View
NMBROFDYS	Number of Days	Integer	2	View
MNMMORDRQTY	Minimum Order Qty	Currency	10	View
MXMMORDRQTY	Maximum Order Qty	Currency	10	View
ORDERMULTIPLE	Order Multiple	Currency	10	View
REPLENISHMENTMETHOD	Replenishment Method 1 – Make 2 – Buy 3- Make or Buy	Integer	2	View
SHRINKAGEFACTOR	Shrinkage Factor	Currency	10	View
PRCHSNGLDTM	Purchasing Lead Time	Currency	10	View
MNFCTRNGFXDLDTM	Manufacturing Fixed Lead Time	Currency	10	View
MNFCTRNGVRBLLDTM	Manufacturing Variable Lead Time	Currency	10	View
STAGINGLDTME	Staging Lead Time	Currency	10	View
PLNNNGTMFNCDYS	Planning Time Fence Days	Integer	2	View
DMNDTMFNCPRDS	Demand Time Fence Periods	Integer	2	View
INCLDDINPLNNNG	Included in Planning	Boolean	2	View
CALCULATEATP	Calculate ATP	Boolean	2	View
AUTOCHKATP	Auto Check ATP	Boolean	2	View
PLNFNLPAB	Plan Final PAB	Boolean	2	View
FRCSTCNSMPTNPRD	Forecast Consumption Period 1 – Days 2 – Weeks 3 – Months	Integer	2	View
ORDRUPTOLVL	Order Up To Level	Currency	10	View
SFTYSTCKQTY	Safety Stock Qty	Currency	10	View
REORDERVARIANCE	Reorder Variance	Currency	10	View
PORECEIPTBIN	Purchase Receipt Bin	String	16	View
PORETRNBIN	Purchase Returns Bin	String	16	View
SOFULFILLMENTBIN	SO Fulfillment Bin	String	16	View
SORETURNBIN	SO Return Bin	String	16	View
BOMRCPTBIN	BOM Receipt Bin	String	16	View
MATERIALISSUEBIN	Material Issues Bin	String	16	View
MORECEIPTBIN	MO Receipt Bin	String	16	View
REPAIRISSUESBIN	Repair Issues Bin	String	16	View
ReplenishmentLevel	Replenishment Level	Integer	2	View
POPOrderMethod	POP Order Method	Integer	2	View
MasterLocationCode	Master Location Code	String	12	View
POPVendorSelection	POP Vendor Selection	Integer	2	View
POPPricingSelection	POP Pricing Selection	Integer	2	View
PurchasePrice	Purchase Price	Currency	10	View
IncludeAllocations	Include Allocations	Boolean	2	View
IncludeBackorders	Include Backorders	Boolean	2	View
IncludeRequisitions	Include Requisitions	Boolean	2	View
PICKTICKETITEMOPT	Picking Ticket Item Option	Integer	2	View
INCLDMRPMOVEIN	IncludeMRPMoveIn	Boolean	2	View
INCLDMRPMOVEOUT	IncludeMRPMoveOut	Boolean	2	View
INCLDMRPCANCEL	IncludeMRPCancel	Boolean	2	View
Move_Out_Fence	Move-Out Fence	Integer	2	View
INACTIVE	Inactive	Boolean	2	View

IV00102 - Item Quantity Master

Query Builder

Customer Service

Information

My Account

Contact Us