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` for the UTC record day.	Yes
`utc_record_time_id`	SMALLINT	FK	Foreign key to `ccdw_dim_time` 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`.	Yes
`location_group_id`	INTEGER	FK	Foreign key to `ccdw_dim_location_group`.	Yes
`sku_id`	INTEGER	FK	Foreign key to `ccdw_dim_product` 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