> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sourcemedium.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# obt_subscription_charges

> ReCharge charges with billing sequence and subscriber context. Pro warehouse only.

<Note>
  **Pro warehouses only.** Subscription tables are not delivered on Foundation warehouses. See [Foundation and Pro](/docs/data-activation/managed-data-warehouse/overview).
</Note>

Charge-grain One Big Table. Use it for revenue per recharge, 1st vs nth charge, and dunning recovery.

**Platforms:** ReCharge only. Medusa subscribers have no charge rows here.

A charge can exist without a matching subscriber dimension row. Those charges are kept. Subscriber context is null on those rows.

```yaml theme={null}
version: 2

models:
  - name: obt_subscription_charges
    description: >
      Charge OBT. 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 available.

      - name: charge_sequence_number
        description: 1-based billing sequence across the subscriber's charge history.

      - name: successful_charge_sequence_number
        description: Running count of settled charges for the subscriber through this charge.

      - name: subscriber_status
        description: Denormalized subscriber status at the last model refresh.

      - name: subscriber_cohort_month
        description: Denormalized first-subscription month.

      - name: subscriber_lifetime_revenue
        description: Denormalized realized charge revenue for the subscriber.
```

`subscriber_lifetime_revenue` is charge-based. It is not converted with the subscription-start FX used on `subscription_price` / `subscription_mrr`. See [Reporting Currency](/docs/help-center/core-concepts/data-definitions/reporting-currency).
