dim_order_discounts - SourceMedium

Pro warehouses only. This table is not delivered on Foundation warehouses. See Foundation and Pro.

Order discount dimension with discount types, codes, and values.

Grain: One row per sm_order_discount_key. No canonical date; _synced_at is a freshness timestamp (not for analysis).
Filters to start with: source_system for platform-specific discount representation.
Joins: dim_order_lines via sm_order_line_key (many:1); dim_orders via sm_order_key (many:1).

Columns

Column	Type	Description
`sm_order_discount_key`	STRING	The unique discount key created by SourceMedium that can be used to join discount dimensions to related tables.
`sm_order_key`	STRING	Stable SourceMedium order key. Unique per order. Key joins: `obt_order_lines` (1:many via `sm_order_key`); `dim_customers` (many:1 via `sm_customer_key`). Platform caveat: TikTok Shop coverage may be limited.
`sm_order_line_key`	STRING	Stable SourceMedium order line key. Unique per line. Key joins: `dim_order_lines` (1:1); `dim_orders` (many:1 via `sm_order_key`). Platform caveat: TikTok Shop coverage may be limited.
`sm_store_id`	STRING	SourceMedium’s unique store identifier. For Shopify stores, derived from the myshopify.com domain; for other platforms (Amazon, TikTok Shop, Walmart.com), uses platform-specific identifiers.
`discount_code`	STRING	The case-insensitive discount code that customers use at checkout.
`discount_index`	INT64	An ordered index that can be used to identify the discount application and indicate the precedence of the discount application for calculations.
`discount_line_entity`	STRING	The entity that the discount is applied to, such as an order line or a shipping line.
`discount_type`	STRING	The type of discount, such as an automatic discount, a discount code, or a manual discount.
`discounts`	FLOAT64	The amount of the discount applied to the discount entity.
`order_currency_code`	STRING	The three-letter code (ISO 4217 format) for the currency used for the tender transaction.
`order_id`	STRING	Platform order identifier. Not globally unique across stores; pair with `sm_store_id` and `source_system` when needed for scoping.
`order_line_id`	STRING	The ID of the order line.
`source_system`	STRING	Originating platform for the record (e.g., Shopify, Amazon, TikTok Shop, Chargebee). Used for platform‑specific behavior and coverage.