# Zuora: 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
* 
Zuora
## Columns
| Type | Name | Description |
| -------- | -------------------------------------------- | -------------------------------------------------------------------------------------------------- |
| STRING | account\_daily\_id | Unique account key, based on account id and date of balance data. |
| STRING | account\_id | Creation date for the account. |
| DATE | date\_day | Date compiled line item transactions by day for this account balance took place. |
| DATE | date\_week | Date compiled line item transactions by week for this account balance took place. |
| DATE | date\_month | Date compiled line item transactions by month for this account balance took place. |
| DATE | date\_year | Date compiled line item transactions by year for this account balance took place. |
| INTEGER | date\_index | The nth date in the transaction model. |
| DATETIME | account\_created\_at | Timestamp of when the account entry was created. |
| STRING | account\_name | Account name as displayed in Zuora. |
| STRING | account\_number | Unique account number assigned to the account. |
| STRING | account\_status | Status of the account in the system. |
| STRING | account\_country | The country of the contact's address associated with the account. |
| STRING | account\_email | The business email address of the contact associated with the account. |
| STRING | account\_first\_name | The first name of the contact associated with the account. |
| STRING | account\_last\_name | The last name of the contact associated with the account. |
| STRING | account\_postal\_code | The zip code of the contact associated with the account. |
| STRING | account\_state | The state of the contact associated with the account. |
| DATETIME | first\_charge\_processed\_at | Time at which the first charge on the account is processed. |
| INTEGER | daily\_invoices | Number of invoices that day for this account. |
| INTEGER | daily\_invoice\_items | Number of invoice items that day for this account. |
| INTEGER | daily\_invoice\_amount | Total amount of the invoices that day for this account. |
| INTEGER | daily\_invoice\_amount\_paid | Total amount of the invoices paid that day for this account. |
| INTEGER | daily\_invoice\_amount\_unpaid | Total amount of the invoices unpaid that day for this account. |
| INTEGER | daily\_discount\_charges | Total amount of the discount charges that day for this account. |
| INTEGER | daily\_refunds | Total amount of the refunds that day for this account. |
| INTEGER | daily\_tax\_amount | Total amount of the taxes that day for this account. |
| INTEGER | daily\_credit\_balance\_adjustment\_amount | Total amount of the credit balance adjustments that day for this account. |
| INTEGER | rolling\_invoices | Number of invoices on this account since it was created to the current date. |
| INTEGER | rolling\_invoice\_items | Number of invoice items on this account since it was created to the current date. |
| INTEGER | rolling\_invoice\_amount | Accumulated invoice amount based on totalled invoice amounts up to the current date. |
| INTEGER | rolling\_invoice\_amount\_paid | Accumulated invoice amount paid based on totalled invoice amounts paid up to the current date. |
| INTEGER | rolling\_invoice\_amount\_unpaid | Accumulated invoice amount unpaid based on totalled invoice amounts unpaid up to the current date. |
| INTEGER | rolling\_discount\_charges | Accumulated discount charges based on totalled discount charges up to the current date. |
| INTEGER | rolling\_refunds | Accumulated refunds based on totalled refunds up to the current date. |
| INTEGER | rolling\_tax\_amount | Accumulated taxes based on totalled taxes up to the current date. |
| INTEGER | rolling\_credit\_balance\_adjustment\_amount | Accumulated credit balance adjustments based on totalled credit balances up 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/zuora-account-daily-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.