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 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.
FFMCENTER_ID INTEGER NOT NULL The FulfillmentCenter where the inventory is located.
RECEIPTQUANTITY INTEGER SUM(RECEIPT.QTYONHAND - RECEIPT.QTYINPROCESS)

Feedback