WebSphere Commerce database table: INVITMVW

This is a view derived from the RECEIPT and ITEMFFMCTR tables which contains the existing quantity available for an item across all Stores and FulfillmentCenters.


Column Description(s):
Column NameColumn TypeDescription
ITEMSPC_ID BIGINT NOT NULL The inventory item identifier.
RECEIPTQUANTITY INTEGER No RECEIPTQUANTITY external description assigned yet
QTYAVAILABLE INTEGER Existing quantity available for this item derived from RECEIPT.QTYONHAND - RECEIPT.QTYINPROCESS - (ITEMFFMCTR.QTYRESERVED + ITEMFFMCTR.QTYALLOCBACKORDER).

Feedback