fct_refunds_processed - SourceMedium

Refund transaction fact table for revenue adjustments and return analytics.

Grain: One row per sm_refund_line_key.
Date field: refunded_at_local_datetime.
Filters to start with: source_system for platform-specific refund reporting; refunded_at_local_datetime for temporal analysis.
Joins: dim_order_lines via sm_order_line_key (many:1); dim_orders via sm_order_key (many:1).

Columns

Column	Type	Description
`sm_customer_key`	STRING	Stable SourceMedium customer key. Unique per customer. Key joins: `dim_customers` (1:1); `dim_orders`/`obt_orders` (1:many). Platform caveat: TikTok Shop coverage may be limited.
`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_product_key`	STRING	Stable SourceMedium join key for products to related tables.
`sm_product_variant_key`	STRING	Stable SourceMedium join key for product variants to related tables.
`sm_refund_key`	STRING	The unique refund key created by SourceMedium that can be used to join refund dimensions to related tables.
`sm_refund_line_key`	STRING	The unique refund line key created by SourceMedium that can be used to join refund line 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_duty_refunds`	NUMERIC	The amount of order duty refunds applied to an order.
`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_line_refund_quantity`	FLOAT64	The quantity of order lines that were refunded. This value is always negative.
`order_line_refunds`	FLOAT64	The amount of order line refunds applied to an order.
`order_line_tax_refunds`	FLOAT64	The amount of order line tax refunds applied to an order.
`refunded_at`	TIMESTAMP	The autogenerated date and time when the refund was processed.
`refunded_at_local_datetime`	DATETIME	The autogenerated date and time when the refund was processed, converted to the reporting timezone configured in SourceMedium.
`shipping_refunds`	NUMERIC	The amount of shipping refunds applied to an order.
`shipping_tax_refunds`	NUMERIC	The amount of shipping tax refunds applied to an order.
`source_system`	STRING	Originating platform for the record (e.g., Shopify, Amazon, TikTok Shop, Chargebee). Used for platform‑specific behavior and coverage.