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