WebSphere Commerce database table: INVSTFFMVW

WebSphere Commerce database table: INVSTFFMVW

This is a view derived from the RECEIPT and ITEMFFMCTR tables which contains the existing quantity available for an item at a Store and FulfillmentCenter.
Column Descriptions
Column Name Column Type Description
STORE_ID INTEGER NOT NULL The Store which owns the inventory.
FFMCENTER_ID INTEGER NOT NULL The FulfillmentCenter where this inventory is available.
ITEMSPC_ID BIGINT NOT NULL The identifier for the inventory item.
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
ATP inventory reservations data model

Column Name	Column Type	Description
STORE_ID	INTEGER NOT NULL	The Store which owns the inventory.
FFMCENTER_ID	INTEGER NOT NULL	The FulfillmentCenter where this inventory is available.
ITEMSPC_ID	BIGINT NOT NULL	The identifier for the inventory item.
QTYAVAILABLE	INTEGER	Existing quantity available for this item derived from RECEIPT.QTYONHAND - RECEIPT.QTYINPROCESS - (ITEMFFMCTR.QTYRESERVED + ITEMFFMCTR.QTYALLOCBACKORDER).