WebSphere Commerce database table: INVITMVW

WebSphere Commerce database table: INVITMVW

This is a view derived from the RECEIPT and ITEMFFMCTR tables which contains the existing quantity available for an item across all Stores and FulfillmentCenters.
Column Descriptions
Column Name Column Type Description
ITEMSPC_ID BIGINT NOT NULL The inventory item identifier.
RECEIPTQUANTITY INTEGER Receipt quantity
QTYAVAILABLE INTEGER Existing quantity available for this item derived from RECEIPT.QTYONHAND - RECEIPT.QTYINPROCESS - (ITEMFFMCTR.QTYRESERVED + ITEMFFMCTR.QTYALLOCBACKORDER).
Related reference

Views and temporary tables data model
ATP inventory data model

Column Name	Column Type	Description
ITEMSPC_ID	BIGINT NOT NULL	The inventory item identifier.
RECEIPTQUANTITY	INTEGER	Receipt quantity
QTYAVAILABLE	INTEGER	Existing quantity available for this item derived from RECEIPT.QTYONHAND - RECEIPT.QTYINPROCESS - (ITEMFFMCTR.QTYRESERVED + ITEMFFMCTR.QTYALLOCBACKORDER).