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. |
No |
sku_id |
INTEGER | FK | Foreign key to ccdw_dim_product 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 |