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 Descriptions:

NameTypeDescription
ITEMSPC_IDBIGINT NOT NULLThe inventory item identifier.
RECEIPTQUANTITYINTEGERReceipt quantity
QTYAVAILABLEINTEGERExisting quantity available for this item derived from RECEIPT.QTYONHAND - RECEIPT.QTYINPROCESS - (ITEMFFMCTR.QTYRESERVED + ITEMFFMCTR.QTYALLOCBACKORDER).