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 . | 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 |