Recurly
## Columns
| Type | Name | Description |
| -------- | ---------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| STRING | subscription\_id | Unique identifier for the subscription. |
| DATETIME | updated\_at | When the subscription was updated. |
| STRING | subscription\_key | Unique identifier for the subscription daily overview table. |
| DATETIME | activated\_at | When the subscription was activated. |
| DECIMAL | add\_ons\_total | Total price of add-ons. Greater or equal to 0. |
| DATETIME | canceled\_at | When the subscription was canceled. Can take future dates. |
| DATETIME | current\_period\_ended\_at | Current billing period ends at. |
| DATETIME | current\_period\_started\_at | Current billing period started at. |
| STRING | expiration\_reason | Reason for subscription expiration. |
| DATETIME | expires\_at | When the subscription has expired. Can take future dates. |
| BOOLEAN | has\_auto\_renew | Whether the subscription renews at the end of its term. Default: true |
| INTEGER | subscription\_period | The nth subscription defined by the time period set. Subscriptions start with month 0. |
| STRING | subscription\_state | The current state of the subscription. Enum: "active", "canceled", "expired", "failed", "future", "paused" |
| DATETIME | subscription\_end\_date | When the subscription actually ends, factors in cancellations earlier than the expected end date. |
| INTEGER | subscription\_interval\_days | Subscription interval by number of days, accounting for cancelled/expired periods. |
| DECIMAL | subtotal | Estimated total, before tax. |
| DATETIME | trial\_ends\_at | Trial period ends at. |
| DATETIME | trial\_started\_at | Trial period started at. |
| INTEGER | trial\_interval\_days | Period of trial, in days. |
| DECIMAL | unit\_amount | Subscription unit price. |
| STRING | account\_id | The account this subscription belongs to. |
| DATETIME | account\_created\_at | The date this account was created. |
| STRING | account\_email | Email address associated with the account for this subscription. |
| STRING | account\_first\_name | First name associated with the account for this subscription. |
| STRING | account\_last\_name | Last name associated with the account for this subscription. |
| STRING | account\_state | Current state of the account. |
| STRING | plan\_code | Unique code to identify the plan. This is used in Hosted Payment Page URLs and in the invoice exports. |
| DATETIME | plan\_created\_at | When the plan was created. |
| DATETIME | plan\_deleted\_at | When the plan was deleted. |
| INTEGER | plan\_interval\_days | The number of days on the expected Recurly plan. |
| BOOLEAN | plan\_is\_tax\_exempt | true exempts tax on the plan, false applies tax on the plan. |
| STRING | plan\_name | This name describes your plan and will appear on the Hosted Payment Page and the subscriber's invoice. |
| STRING | plan\_state | The current state of the plan. Enum: "active", "inactive" |
| INTEGER | plan\_total\_billing\_cycles | Automatically terminate subscriptions after a defined number of billing cycles. Number of billing cycles before the plan automatically stops renewing, defaults to null for continuous, automatic renewal. |
---
# 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/recurly-subscription-overview.md?ask=