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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|