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