RCPTSTFFVW
A view which summarizes the quantity of inventory available from the RECEIPT table for an item owned by a Store at a FulfillmentCenter.
Column Descriptions:
| Name | Type | Description |
|---|---|---|
| ITEMSPC_ID | BIGINT NOT NULL | The inventory item identifier. |
| STORE_ID | INTEGER NOT NULL | The Store that owns the inventory. |
| FFMCENTER_ID | INTEGER NOT NULL | The FulfillmentCenter where the inventory is located. |
| RECEIPTQUANTITY | INTEGER | SUM(RECEIPT.QTYONHAND - RECEIPT.QTYINPROCESS) |