# ccdw_aggr_inventory_by_location

This table aggregates daily inventory levels by individual location.

| Column Alias           | Data Type | Key    | Description                                                                                                  | Index? |
| ---------------------- | --------- | ------ | ------------------------------------------------------------------------------------------------------------ | ------ |
| `record_date`          | DATE      |        | Date of the inventory record.                                                                                | No     |
| `location_id`          | INTEGER   | **FK** | Foreign key to [`ccdw_dim_location`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_location.md).           | No     |
| `sku_id`               | INTEGER   | **FK** | Foreign key to [`ccdw_dim_product`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_product.md) for the SKU. | No     |
| `available_to_fulfill` | INTEGER   |        | Total quantity available to fulfill orders at this location.                                                 | No     |
| `available_to_order`   | INTEGER   |        | Total quantity available to be ordered at this location.                                                     | No     |
| `reserved`             | INTEGER   |        | Total quantity reserved at this location.                                                                    | No     |
| `soft_reserved`        | INTEGER   |        | Total quantity soft reserved at this location.                                                               | No     |
| `on_hand`              | INTEGER   |        | Total quantity on hand at this location.                                                                     | No     |