Inventory History

Table name (referenced in Insights SQL queries): marts_mdc__inventory_history

Tracks historical inventory data, including stock levels, allocations, expectations, and quarantined inventory across warehouses, accounts, and products.

Columns

Column	Type	Description
date	date	Date of the inventory snapshot.
warehouse_id	number	Identifier of the warehouse associated with the inventory data.
warehouse_name	varchar	Represents the name of the warehouse.
account_id	number	Identifier of the account associated with the inventory data.
account_name	varchar	Name of the account
product_id	number	Identifier of the product related to the inventory record.
warehouse_timezone	varchar	Timezone of the warehouse associated with the inventory record.
refreshed_at_utc	timestamp_ntz	Timestamp indicating when the inventory data was last refreshed.
base_inventory	number	Base level of inventory at the start of the period.
inventory_on_hand	number	Total inventory physically available on hand.
inventory_final	number	Final adjusted inventory after considering all transactions.
inventory_allocated	number	Inventory allocated for orders or reservations.
inventory_expected	number	Inventory expected to arrive based on purchase orders or shipments.
inventory_quarantined	number	Inventory held in quarantine and not available for use.