# Recurly: Account Daily Overview

## Description

* Each record is a day in an account and its accumulated balance totals based on all line item transactions up to that day.

## Supported Data Sources

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

## Columns

| Type     | Name                       | Description                                                                                                                 |
| -------- | -------------------------- | --------------------------------------------------------------------------------------------------------------------------- |
| STRING   | account\_id                | Account associated with balance transactions.                                                                               |
| DATETIME | account\_created\_at       | Timestamp of when the account entry was created.                                                                            |
| STRING   | account\_city              | City in the world the account is associated with.                                                                           |
| STRING   | account\_company           | The company related with the account.                                                                                       |
| STRING   | account\_country           | Country in the world the account is associated with.                                                                        |
| STRING   | account\_code              | The unique identifier of the account. This cannot be changed once the account is created. Provided during account creation. |
| STRING   | account\_email             | Email address associated with the account.                                                                                  |
| STRING   | account\_first\_name       | First name associated with the account.                                                                                     |
| STRING   | account\_last\_name        | Last name associated with the account.                                                                                      |
| BOOLEAN  | account\_is\_tax\_exempt   | The tax status of the account. true exempts tax on the account, false applies tax on the account.                           |
| STRING   | account\_postal\_code      | Postal code in the world the account is associated with.                                                                    |
| STRING   | account\_region            | Region in the world the account is associated with (usually would be state if it was a U.S. account.)                       |
| STRING   | account\_state             | Current state of the account.                                                                                               |
| STRING   | account\_username          | A secondary value for the account.                                                                                          |
| STRING   | account\_daily\_id         | Unique account key, based on account id and date of balance data.                                                           |
| DATE     | date\_day                  | Date compiled transactions by day for this account balance took place.                                                      |
| DATE     | date\_week                 | Date compiled transactions by week for this account balance took place.                                                     |
| DATE     | date\_month                | Date compiled transactions by month for this account balance took place.                                                    |
| DATE     | date\_year                 | Date compiled transactions by year for this account balance took place.                                                     |
| INTEGER  | date\_index                | The nth date in the transaction model.                                                                                      |
| INTEGER  | daily\_transaction\_count  | Number of transactions that took place this day for this account.                                                           |
| DECIMAL  | daily\_net\_change         | Total sum of all transactions that took place this day for this account and the balance change that ensued.                 |
| INTEGER  | daily\_invoice\_count      | Number of invoices that day for this account.                                                                               |
| DECIMAL  | daily\_charges             | Total sum of all charges that took place this day for this account.                                                         |
| DECIMAL  | daily\_credits             | Total sum of all credits that took place this day for this account.                                                         |
| DECIMAL  | daily\_discounts           | Total sum of all discounts that took place this day for this account.                                                       |
| DECIMAL  | daily\_taxes               | Total sum of all taxes that took place this day for this account.                                                           |
| INTEGER  | daily\_charge\_count       | Number of charges that day for this account.                                                                                |
| INTEGER  | daily\_credit\_count       | Number of credits that day for this account.                                                                                |
| DECIMAL  | rolling\_account\_balance  | Accumulated account balance based on previous daily transactions on this account.                                           |
| INTEGER  | rolling\_invoices          | Number of invoices on this account since it was created to the current date.                                                |
| INTEGER  | rolling\_transactions      | Number of transactions on this account since it was created to the current date.                                            |
| DECIMAL  | rolling\_charge\_balance   | Accumulated charge balance based on previous daily charges on this account.                                                 |
| DECIMAL  | rolling\_credit\_balance   | Accumulated credit balance based on previous daily credits on this account.                                                 |
| DECIMAL  | rolling\_discount\_balance | Accumulated discount balance based on previous daily discounts on this account.                                             |
| DECIMAL  | rolling\_tax\_balance      | Accumulated tax balance based on previous daily taxes on this account.                                                      |
| INTEGER  | rolling\_charges           | Number of charges on this account since it was created to the current date.                                                 |
| INTEGER  | rolling\_credits           | Number of credits on this account since it was created to the current date.                                                 |


---

# 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-account-daily-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.