Database View: 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 Name Column Type Column Description
FFMCENTER_ID INTEGER
NOT NULL
The FulfillmentCenter where the inventory is located.
ITEMSPC_ID BIGINT
NOT NULL
The inventory item identifier.
RECEIPTQUANTITY INTEGER
NULL
SUM(RECEIPT.QTYONHAND - RECEIPT.QTYINPROCESS)
STORE_ID INTEGER
NOT NULL
The Store that owns the inventory.
Indexes:
Index Name Indexed Column Names Index Type
Not Applicable
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable