ccdw_aggr_inventory_by_location_group
This table aggregates daily inventory levels by location group.
Column Alias | Data Type | Key | Description | Index? |
---|---|---|---|---|
record_date | DATE | Date of the inventory record. | No | |
location_group_id | INTEGER | FK | Foreign key to ccdw_dim_location_group . | 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 for this location group. | No | |
available_to_order | INTEGER | Total quantity available to be ordered for this location group. | No | |
reserved | INTEGER | Total quantity reserved for this location group. | No | |
soft_reserved | INTEGER | Total quantity soft reserved for this location group. | No | |
on_hand | INTEGER | Total quantity on hand for this location group. | No |