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 Description(s):
Column NameColumn TypeDescription
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)

Feedback