Order Action Required

Table name (referenced in Insights SQL queries): marts_mdc__order_action_required

This table tracks actions required for orders, including their type, creation, and resolution timestamps, along with unresolved status.

Columns

Column	Type	Description
order_id	number	Represents a unique identifier assigned to each order. It links each record to a specific order, ensuring precise association for the respective order.
account_id	number	Represents a unique identifier assigned to each merchant. It links each record to a specific merchant, ensuring precise association for the respective merchant.
warehouse_id	number	Identifier for the warehouse processing the order.
order_action_required_type	varchar	Type of action required for the order.
order_action_required_created_at_utc	timestamp_ntz	Timestamp when the required action was created.
order_action_required_resolved_at_utc	timestamp_ntz	Timestamp when the required action was resolved.
unresolved	number	Indicator if the required action remains unresolved.