A view which summarizes the quantity of inventory available from
the RECEIPT table for an item across all Stores and
FulfillmentCenters.
Column Name |
Column Type |
Column Description |
ITEMSPC_ID |
BIGINT
NOT NULL |
The inventory item identifier. |
RECEIPTQUANTITY |
INTEGER
NULL |
SUM(RECEIPT.QTYONHAND - RECEIPT.QTYINPROCESS) |
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 |
