dim_order_taxes - SourceMedium

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

Order tax dimension with tax names and amounts for reconciliation and reporting.

Grain: One row per sm_order_tax_key. No canonical date; _synced_at is a freshness timestamp (not for analysis).
Filters to start with: source_system for platform-specific tax reporting, tax_line_entity for line vs shipping taxes.
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_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_order_tax_key`	STRING	The unique order tax key created by SourceMedium that can be used to join order tax dimensions to related tables.
`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.
`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.
`order_shipping_line_id`	STRING	The ID of the shipping line.
`source_system`	STRING	Originating platform for the record (e.g., Shopify, Amazon, TikTok Shop, Chargebee). Used for platform‑specific behavior and coverage.
`tax_line_entity`	STRING	The line the tax applies to (e.g., shipping, order).
`tax_line_rate`	FLOAT64	The proportion of the order price that the tax represents.
`tax_line_type`	STRING	The type of tax (e.g., state, county, excise and use, sales) applied to an order line.
`taxes`	FLOAT64	The amount of tax associated with a tax line entity, after discounts and before returns.