fct_subscription_charges

version: 2

models:
  - name: fct_subscription_charges
    description: >
      Subscription charge fact. Grain: one row per (sm_store_id, charge_id).
    columns:
      - name: sm_store_id
        description: SourceMedium's unique store identifier.

      - name: charge_id
        description: Platform identifier for the charge.

      - name: subscriber_id
        description: Subscriber who was billed, when ReCharge supplied one.

      - name: reporting_timezone
        description: Workspace timezone used for charge reporting dates.

      - name: charge_scheduled_date
        description: Scheduled charge date in the reporting timezone.

      - name: charge_process_date
        description: Processed charge date in the reporting timezone, falling back to created date when processed_at is absent.

      - name: is_settled_charge
        description: Whether this charge collected successfully.