WebSphere Commerce database table: RCPTSTVW

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

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.
RECEIPTQUANTITY INTEGER SUM(RECEIPT.QTYONHAND - RECEIPT.QTYINPROCESS)
Related reference