obt_subscription_charges - SourceMedium

Pro warehouses only. Subscription tables are not delivered on Foundation warehouses. See Foundation and Pro.

One Big Table at charge grain: fct_subscription_charges + charge_sequence_number (1st/nth recharge) + nullable subscriber context. For revenue / AOV-per-recharge / sequence / dunning-recovery. Charge rows are preserved even when Recharge has no matching subscription-derived subscriber dimension row.

Columns

Column	Type	Description
`sm_store_id`	STRING	SourceMedium’s unique store identifier.
`charge_amount`	NUMERIC	Total charge amount in `charge_currency_code`.
`charge_attempts`	INT64	Number of attempts ReCharge recorded for the charge.
`charge_created_at`	TIMESTAMP	UTC timestamp when ReCharge created the charge.
`charge_currency_code`	STRING	Currency code for the charge amount fields.
`charge_discount_amount`	NUMERIC	Discount applied to the charge, in `charge_currency_code`.
`charge_error`	STRING	Charge error message supplied by ReCharge, when the charge failed.
`charge_error_type`	STRING	Charge error category supplied by ReCharge, when available.
`charge_id`	STRING	Platform identifier for the charge.
`charge_last_attempt_at`	TIMESTAMP	UTC timestamp of the most recent charge attempt, when available.
`charge_net_amount`	NUMERIC	`charge_amount` minus `charge_refund_amount`, treating null amounts as zero.
`charge_orders_count`	INT64	Number of ecommerce orders associated with the charge.
`charge_payment_processor`	STRING	Payment processor used for the charge, when supplied by ReCharge.
`charge_process_date`	DATE	Processed charge date in the reporting timezone, falling back to the created date.
`charge_processed_at`	TIMESTAMP	UTC timestamp when the charge was processed, when available.
`charge_refund_amount`	NUMERIC	Amount refunded for the charge, in `charge_currency_code`.
`charge_retry_at`	TIMESTAMP	UTC timestamp of the next scheduled retry, when available.
`charge_scheduled_at`	TIMESTAMP	UTC timestamp when the charge was scheduled, when available.
`charge_scheduled_date`	DATE	Scheduled charge date in the workspace reporting timezone.
`charge_sequence`	STRING	`first_order` for checkout charges and `recurring` for other charge types.
`charge_sequence_number`	INT64	1-based billing sequence within the subscriber’s charge history.
`charge_status`	STRING	Lowercase ReCharge charge status, such as `success`, `error`, `refunded`, or `partially_refunded`.
`charge_subtotal_amount`	NUMERIC	Charge subtotal before tax and other adjustments, in `charge_currency_code`.
`charge_tax_amount`	NUMERIC	Tax included on the charge, in `charge_currency_code`.
`charge_type`	STRING	Lowercase ReCharge charge type, such as `checkout` or `recurring`.
`charge_updated_at`	TIMESTAMP	UTC timestamp when ReCharge last updated the charge.
`customer_email_hashed`	STRING	Hashed customer email supplied by ReCharge, when available.
`is_failed`	BOOL	Whether `charge_status` is `error`.
`is_settled_charge`	BOOL	Whether the charge status is `success`, `refunded`, or `partially_refunded`.
`is_successful`	BOOL	Whether `charge_status` is `success`.
`order_id`	STRING	Ecommerce order identifier attached to the charge, when available.
`platform`	STRING	Subscription platform. Published value is `ReCharge`.
`reporting_timezone`	STRING	Your store’s reporting timezone, used for the date columns on this row.
`smcuuid`	STRING	Hashed store identifier.
`subscriber_cohort_month`	DATE	Denormalized first-subscription month.
`subscriber_id`	STRING	Subscriber who was billed, when available.
`subscriber_lifetime_revenue`	NUMERIC	Denormalized realized net charge revenue for the subscriber, or 0 when none is available.
`subscriber_status`	STRING	Denormalized subscriber status at the last model refresh. Published values are `active`, `inactive`, and `dunning`.
`subscriber_tenure_days`	INT64	Denormalized days since the subscriber’s first subscription.
`successful_charge_sequence_number`	INT64	Running count of settled charges for the subscriber through this charge.

subscriber_lifetime_revenue is charge-based. It is not converted with the subscription-start FX used on subscription_price / subscription_mrr. See Reporting Currency.