# Zuora: Billing History

## Description

* Each record is an invoice to evaluate the history of charges billed, enhanced with additional details from payments, refunds, adjustments, discounts, and taxes.

## Supported Data Sources

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

## Columns

| Type     | Name                                                | Description                                                                                                                                 |
| -------- | --------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------- |
| STRING   | invoice\_id                                         | The unique identifier of the invoice table.                                                                                                 |
| STRING   | account\_id                                         | The account associated with the invoice.                                                                                                    |
| DATETIME | created\_at                                         | The time at which the invoice was created.                                                                                                  |
| STRING   | invoice\_number                                     | The unique identification number for the invoice.                                                                                           |
| DATE     | invoice\_date                                       | Specifies the date on which to generate the invoice.                                                                                        |
| DECIMAL  | invoice\_amount                                     | The sum of all charges and taxes associated with the invoice.                                                                               |
| DECIMAL  | invoice\_amount\_home\_currency                     | The sum of all charges and taxes associated with the invoice in its home currency.                                                          |
| DECIMAL  | invoice\_amount\_paid                               | The amount of the invoice currently paid for.                                                                                               |
| DECIMAL  | invoice\_amount\_unpaid                             | The amount of the invoice yet to be paid for.                                                                                               |
| DECIMAL  | tax\_amount                                         | The total amount of the taxes applied to the invoice.                                                                                       |
| INTEGER  | refund\_amount                                      | The amount of refunds applied to the invoice.                                                                                               |
| DECIMAL  | credit\_balance\_adjustment\_amount                 | The amount of the credit balance adjustment applied to the invoice.                                                                         |
| INTEGER  | tax\_amount\_home\_currency                         | The amount of tax in home currency for the invoice.                                                                                         |
| STRING   | transaction\_currency                               | Transaction currency the customer is billed in.                                                                                             |
| STRING   | home\_currency                                      | Home currency the customer is billed in.                                                                                                    |
| DATE     | exchange\_rate\_date                                | The date of the exchange rate used for the invoice.                                                                                         |
| DATE     | due\_date                                           | The due date of the invoice.                                                                                                                |
| STRING   | status                                              | The status of the invoice in the system. This status is not the status of the payment of the invoice just the status of the invoice itself. |
| STRING   | purchase\_type                                      | The type of the invoice source.                                                                                                             |
| INTEGER  | invoice\_items                                      | The amount of invoice items in the invoice.                                                                                                 |
| INTEGER  | products                                            | The number of products billed in the invoice.                                                                                               |
| INTEGER  | subscriptions                                       | The number of subscriptions in the invoice.                                                                                                 |
| DECIMAL  | discount\_charges                                   | The discount charges applied to the invoice.                                                                                                |
| DECIMAL  | discount\_charges\_home\_currency                   | The discount charges home currency applied to the invoice.                                                                                  |
| DECIMAL  | units                                               | The units in the invoice.                                                                                                                   |
| DATETIME | first\_charge\_date                                 | The first charge date for the invoice.                                                                                                      |
| DATETIME | most\_recent\_charge\_date                          | The most recent charge date for the invoice.                                                                                                |
| DATE     | invoice\_service\_start\_date                       | Earliest invoice item service start date for the invoice.                                                                                   |
| DATE     | invoice\_service\_end\_date                         | Earliest invoice item service end date for the invoice.                                                                                     |
| INTEGER  | payments                                            | The number of payments applied to the invoice.                                                                                              |
| DECIMAL  | invoice\_amount\_paid\_home\_currency               | The amount of the invoice amount paid in the home currency on the invoice.                                                                  |
| DECIMAL  | invoice\_amount\_unpaid\_home\_currency             | The amount of the invoice amount unpaid in the home currency on the invoice.                                                                |
| DATE     | first\_payment\_date                                | The first date when a payment is applied to the invoice.                                                                                    |
| DATE     | most\_recent\_payment\_date                         | The most recent date when a payment is applied to the invoice.                                                                              |
| INTEGER  | payment\_methods                                    | The number of payment methods associated with the invoice.                                                                                  |
| INTEGER  | credit\_balance\_adjustments                        | The number of the credit balance adjustments applied on the invoice.                                                                        |
| DECIMAL  | credit\_balance\_adjustment\_amount\_home\_currency | The amount for the credit balance adjustment in home currency on the invoice.                                                               |
| DATE     | first\_credit\_balance\_adjustment\_date            | The first date when a credit balance adjustment is applied to the invoice.                                                                  |
| DATE     | most\_recent\_credit\_balance\_adjustment\_date     | The most recent date when a credit balance adjustment is applied to the invoice.                                                            |


---

# 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-billing-history.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.