fct_subscription_charges - SourceMedium

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

BI subscription charge fact.

Grain: (sm_store_id, charge_id).

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 created date when processed_at is absent.
`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 reporting timezone.
`charge_sequence`	STRING	`first_order` for checkout charges and `recurring` for other charge types.
`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_id`	STRING	Subscriber who was billed, when ReCharge supplied one.

For sequence (1st vs nth recharge) and denormalized subscriber context, use obt_subscription_charges.