WebSphere Commerce database table: RCPTSTFFVW

A view which summarizes the quantity of inventory available from the RECEIPT table for an item owned by a Store at a FulfillmentCenter.

Column Descriptions
Column Name Column Type Description
ITEMSPC_ID BIGINT NOT NULL The inventory item identifier.
STORE_ID INTEGER NOT NULL The Store that owns the inventory.
FFMCENTER_ID INTEGER NOT NULL The FulfillmentCenter where the inventory is located.
RECEIPTQUANTITY INTEGER SUM(RECEIPT.QTYONHAND - RECEIPT.QTYINPROCESS)