Order With Removed Items

Table name (referenced in Insights SQL queries): marts_mdc__order_with_removed_items

The marts_mdc__order_with_removed_items view shows items that were removed manually from orders and are not in split orders (meaning items removed manually by user)

Columns

Column	Type	Description
order_id	number	Unique identifier for the order
order_number	varchar	Order number
order_key	varchar	Unique key identifier for the order used for external reference.
account_id	number	Identifier for the account placing the order.
ordered_at_utc	timestamp_ntz	UTC timestamp when the order was placed.
order_created_at_utc	timestamp_ntz	UTC timestamp when the order record was created in the system.
sku	varchar	Marketing sku given by the account
item_name	varchar	Item name give by the account
item_quantity	number	Requested item quantity