This is a view derived from the RECEIPT and ITEMFFMCTR tables which contains the existing quantity available for an item for a given store across all FulfillmentCenters.
Column Name | Column Type | Description |
---|---|---|
STORE_ID | INTEGER NOT NULL | The Store that owns the inventory. |
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). |
QUANTITYMEASURE | CHAR(16) NOT NULL | The unit of measure for the item. |