# Zuora: Subscription Overview
## Description
* Each record is a subscription, enhanced with additional details from rate plan charges and amendments.
## Supported Data Sources
* 
Zuora
## Columns
| Type | Name | Description |
| -------- | ------------------------------ | ------------------------------------------------------------------------------------------------------------ |
| STRING | subscription\_key | The unique subscription key, defined by subscription id and rate plan charge id. |
| STRING | subscription\_id | The unique identifier for the subscription. |
| STRING | account\_id | The unique identifier for the account associated with the subscription. |
| STRING | account\_name | The account name associated with the subscription. |
| BOOLEAN | auto\_renew | Indicates whether the subscription is set to automatically renew at the end of the term. |
| INTEGER | cancel\_reason | The reason for cancelling the subscription, if applicable. |
| DATETIME | cancelled\_date | The date on which the subscription was cancelled, if applicable. |
| INTEGER | current\_term | The length of the current subscription term. |
| STRING | current\_term\_period\_type | The unit of time for the current subscription term (e.g. "Month", "Year"). |
| INTEGER | initial\_term | The length of the initial subscription term. |
| STRING | initial\_term\_period\_type | The unit of time for the initial subscription term (e.g. "Month", "Year"). |
| BOOLEAN | is\_latest\_version | Indicates whether the subscription is the latest version of the subscription on the account. |
| STRING | previous\_subscription\_id | The unique identifier for the previous subscription associated with the subscription. |
| INTEGER | renewal\_term | The length of the renewal subscription term. |
| STRING | renewal\_term\_period\_type | The type of the renewal term for the subscription. |
| DATETIME | service\_activation\_date | The date the subscription was activated. |
| STRING | status | The status of the subscription. |
| DATETIME | subscription\_start\_date | The start date of the subscription. |
| DATETIME | subscription\_end\_date | The end date of the subscription. |
| DATETIME | term\_start\_date | The start date of the subscription term. |
| DATETIME | term\_end\_date | The end date of the subscription term. |
| STRING | term\_type | The type of subscription term. |
| INTEGER | version | The version number of the subscription. |
| STRING | rate\_plan\_charge\_id | The identifier for the rate plan charge associated with the subscription. |
| STRING | rate\_plan\_charge\_name | The name of the rate plan charge associated with the subscription. |
| STRING | charge\_billing\_period | The billing period for the charge associated with the subscription. |
| STRING | charge\_billing\_timing | The billing timing for the charge associated with the subscription. |
| STRING | charge\_model | The model used to calculate the charge associated with the subscription. |
| STRING | charge\_type | TThe type of charge associated with the subscription. |
| DATE | charged\_through\_date | The date through which the charge has been charged on the subscription. |
| DATE | charge\_effective\_start\_date | The date on which the rate plan charge goes into effect on the subscription. |
| DATE | charge\_effective\_end\_date | The date on which the rate plan charge is no longer in effect on the subscription. |
| DECIMAL | charge\_mrr | The monthly recurring revenue of the rate plan charge associated with the subscription. |
| DECIMAL | charge\_mrr\_home\_currency | The monthly recurring revenue of the rate plan charge in the home currency associated with the subscription. |
| STRING | amendment\_id | The id of the amendment associated with the subscription. |
| STRING | amendment\_name | The name of the amendment associated with the subscription. |
| DATE | amendment\_booking\_date | The date when the amendment is signed. |
| DATETIME | amendment\_creation\_date | Creation date for the amendment. |
| STRING | amendment\_type | The type of amendment associated with the subscription. |
| STRING | amendment\_status | The status of the amendment associated with the subscription. |
| DATE | amendment\_contract\_date | The date when the amendment's changes become effective for billing purposes. |
| DATE | amendment\_activation\_date | The date when service is activated for the amendment. |
| INTEGER | current\_term\_days | The length of the current term of the subscription in days. |
| INTEGER | initial\_term\_days | The length of the initial term of the subscription in days. |
| INTEGER | renewal\_term\_days | The length of the renewal term of the subscription in days. |
| INTEGER | subscription\_days | The length of the subscription in days. |
| INTEGER | term\_days | The length of the subscription term in days. |
---
# 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/zuora-subscription-overview.md?ask=
```
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.