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:

NameTypeDescription
ITEMSPC_IDBIGINT NOT NULLThe inventory item identifier.
STORE_IDINTEGER NOT NULLThe Store that owns the inventory.
RECEIPTQUANTITYINTEGERSUM(RECEIPT.QTYONHAND - RECEIPT.QTYINPROCESS)