# Recharge: Subscription Overview

## Description

* Each record represents a subscription, enriched with customer and charge information.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/recharge/resources/recharge.svg" alt="" data-size="line"> Recharge

## Columns

| Type     | Name                                         | Description                                                                                                                 |
| -------- | -------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------- |
| INTEGER  | subscription\_id                             | The unique identifier of the subscription.                                                                                  |
| INTEGER  | customer\_id                                 | The unique identifier of the customer.                                                                                      |
| INTEGER  | address\_id                                  | The unique identifier of the address.                                                                                       |
| DATETIME | subscription\_created\_at                    | The date and time the subscription was created.                                                                             |
| INTEGER  | external\_product\_id\_ecommerce             | The ID of the product in your external ecommerce platform.                                                                  |
| INTEGER  | external\_variant\_id\_ecommerce             | The ID of the variant in your external ecommerce platform.                                                                  |
| STRING   | product\_title                               | The name of the product in a shop's catalog.                                                                                |
| STRING   | variant\_title                               | The name of the variant in a shop's catalog.                                                                                |
| STRING   | sku                                          | The unique identifier of the item in fulfillment.                                                                           |
| DECIMAL  | price                                        | The price of the item before discounts, taxes, or shipping have been applied.                                               |
| INTEGER  | quantity                                     | The number of items in the subscription.                                                                                    |
| STRING   | subscription\_status                         | The status of the subscription. Possible values are ACTIVE, CANCELLED, EXPIRED.                                             |
| INTEGER  | charge\_interval\_frequency                  | The number of units (specified in order\_interval\_unit) between each charge.                                               |
| STRING   | order\_interval\_unit                        | The frequency with which a subscription should have the order created with (valid values are “day”, “week”, and “month”).   |
| INTEGER  | order\_interval\_frequency                   | The number of units (specified in order\_interval\_unit) between each order.                                                |
| INTEGER  | order\_day\_of\_month                        | The set day of the month order is created. Default is that there isn’t a strict day of the month when the order is created. |
| INTEGER  | order\_day\_of\_week                         | The set day of the week order is created. Default is that there isn’t a strict day of the week order is created.            |
| INTEGER  | expire\_after\_specific\_number\_of\_charges | Set number of charges until subscription expires.                                                                           |
| DATETIME | subscription\_updated\_at                    | The date and time the subscription was last updated.                                                                        |
| DATETIME | subscription\_next\_charge\_scheduled\_at    | The date and time of the next scheduled charge for the subscription.                                                        |
| DATETIME | subscription\_cancelled\_at                  | The date and time the subscription was cancelled.                                                                           |
| STRING   | cancellation\_reason                         | Reason provided for cancellation.                                                                                           |
| INTEGER  | cancellation\_reason\_comments               | Additional comments related to the cancellation of the subscription.                                                        |
| DATETIME | \_fivetran\_synced                           | Timestamp of when Fivetran synced a record.                                                                                 |
| BOOLEAN  | is\_most\_recent\_record                     | A flag indicating if the record is the most recent for the subscription.                                                    |
| INTEGER  | count\_successful\_charges                   | The count of successful charges for the subscription.                                                                       |
| INTEGER  | count\_queued\_charges                       | The count of queued charges for the subscription.                                                                           |
| INTEGER  | charges\_until\_expiration                   | The number of charges until the subscription expires.                                                                       |
| INTEGER  | charge\_interval\_frequency\_days            | The number of days between charges for the subscription.                                                                    |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/recharge-subscription-overview.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.