Database View: INVSTFFMVW

This is a view derived from the RECEIPT and ITEMFFMCTR tables which contains the existing quantity available for an item at a Store and FulfillmentCenter.

Column Name Column Type Column Description
FFMCENTER_ID INTEGER
NOT NULL
The FulfillmentCenter where this inventory is available.
ITEMSPC_ID BIGINT
NOT NULL
The identifier for the inventory item.
QTYAVAILABLE INTEGER
NULL
Existing quantity available for this item derived from RECEIPT.QTYONHAND - RECEIPT.QTYINPROCESS - (ITEMFFMCTR.QTYRESERVED + ITEMFFMCTR.QTYALLOCBACKORDER).
STORE_ID INTEGER
NOT NULL
The Store which 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