# ccdw_fact_inventory_record_snapshot

This table captures daily snapshots of inventory levels. This table currently only represents data sourced from OCI.

| Column Alias                 | Data Type | Key    | Description                                                                                                        | Index? |
| ---------------------------- | --------- | ------ | ------------------------------------------------------------------------------------------------------------------ | ------ |
| `inventory_record_id`        | BIGINT    | **PK** | Unique identifier for an inventory record snapshot.                                                                | Yes    |
| `utc_record_timestamp`       | TIMESTAMP |        | UTC timestamp of the inventory record snapshot.                                                                    | Yes    |
| `utc_record_day_id`          | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_date`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_date.md) for the UTC record day.  | Yes    |
| `utc_record_time_id`         | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_time`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_time.md) for the UTC record time. | Yes    |
| `utc_update_timestamp`       | TIMESTAMP |        | Last modified UTC timestamp of this record.                                                                        | Yes    |
| `location_id`                | INTEGER   | **FK** | Foreign key to [`ccdw_dim_location`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_location.md).                 | Yes    |
| `location_group_id`          | INTEGER   | **FK** | Foreign key to [`ccdw_dim_location_group`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_location_group.md).     | Yes    |
| `sku_id`                     | INTEGER   | **FK** | Foreign key to [`ccdw_dim_product`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_product.md) for the SKU.       | Yes    |
| `available_to_fulfill_alloc` | NUMERIC   |        | Allocated quantity available to fulfill orders.                                                                    | No     |
| `available_to_order_alloc`   | NUMERIC   |        | Allocated quantity available to be ordered.                                                                        | No     |
| `on_hand_alloc`              | NUMERIC   |        | Allocated quantity currently on hand.                                                                              | No     |
| `reserved_alloc`             | NUMERIC   |        | Allocated quantity that is reserved.                                                                               | No     |
| `soft_reserved_alloc`        | NUMERIC   |        | Allocated quantity that is soft reserved.                                                                          | No     |
| `safety_stock_count_alloc`   | NUMERIC   |        | Allocated quantity for safety stock.                                                                               | No     |
| `available_to_fulfill`       | NUMERIC   |        | Total quantity available to fulfill orders.                                                                        | No     |
| `available_to_order`         | NUMERIC   |        | Total quantity available to be ordered.                                                                            | No     |
| `on_hand`                    | NUMERIC   |        | Total quantity currently on hand.                                                                                  | No     |
| `reserved`                   | NUMERIC   |        | Total quantity that is reserved.                                                                                   | No     |
| `soft_reserved`              | NUMERIC   |        | Total quantity that is soft reserved.                                                                              | No     |
| `safety_stock_count`         | NUMERIC   |        | Total quantity for safety stock.                                                                                   | No     |
| `total_futures_quantity`     | NUMERIC   |        | Total quantity of future inventory.                                                                                | No     |