# Zuora: Line Item History
## Description
* Each record is an invoice item meant to provide all details on all transactions at the most granular level, with details being brought in from subscriptions, amendments, rate plan charges, products, subscriptions, amendments and more.
## Supported Data Sources
* 
Zuora
## Columns
| Type | Name | Description |
| -------- | --------------------------------------- | ------------------------------------------------------------------------------------------------ |
| STRING | invoice\_item\_id | The unique identifier of the invoice item table. |
| STRING | account\_id | Identifier of the account associated with this invoice item. |
| DATE | account\_creation\_day | Day the account associated with the line item was created. |
| STRING | account\_status | Status of the account associated with the line item. |
| STRING | amendment\_id | Amendment identifier associated with the invoice item. |
| DECIMAL | balance | Balance of the invoice item. |
| DECIMAL | charge\_amount | Amount charged for the invoice item. |
| DECIMAL | charge\_amount\_home\_currency | Amount charged for the invoice item in the home currency. |
| DATETIME | charge\_date | Date on which the charge for the invoice item was made. |
| DATE | charge\_day | Day on which the charge for the invoice item was made. |
| DATE | charge\_week | Week on which the charge for the invoice item was made. |
| DATE | charge\_month | Month on which the charge for the invoice item was made. |
| STRING | charge\_name | Name on which the charge for the invoice item was made. |
| DECIMAL | discount\_amount | Discount amount applied for the invoice item. |
| DECIMAL | discount\_amount\_home\_currency | Discount amount applied for the invoice item in the home currency. |
| DATE | first\_charge\_day | First charge day for the account associated with the invoice item. |
| STRING | home\_currency | Home currency the customer is billed in. |
| STRING | invoice\_id | The identifier for the invoice associated with the invoice item. |
| STRING | product\_id | The identifier for the product associated with the invoice item. |
| STRING | product\_rate\_plan\_id | The identifier for the product rate plan associated with the invoice item. |
| STRING | product\_rate\_plan\_charge\_id | The identifier for the product rate plan charge associated with the invoice item. |
| STRING | rate\_plan\_charge\_id | The identifier for the rate plan charge associated with the invoice item. |
| DATE | service\_start\_day | Start date of the service associated with the invoice item. |
| DATE | service\_start\_week | Start week of the service associated with the invoice item. |
| DATE | service\_start\_month | Start month of the service associated with the invoice item. |
| DATE | service\_end\_date | End date of the service associated with the invoice item. |
| STRING | subscription\_id | The id of the subscription associated with the invoice item. |
| STRING | sku | SKU of the invoice item. |
| DECIMAL | tax\_amount | The tax amount for the invoice item. |
| INTEGER | tax\_amount\_home\_currency | The tax amount for the invoice item in the home currency. |
| STRING | transaction\_currency | Transaction currency the customer is billed in. |
| DECIMAL | unit\_price | The unit price for the invoice item. |
| STRING | uom | The unit of measure for the invoice item. |
| STRING | invoice\_number | The unique identification number for the invoice. |
| DATE | invoice\_date | Specifies the date on which to generate the invoice. |
| DATE | invoice\_due\_date | The due date of the invoice. |
| BOOLEAN | subscription\_auto\_renew | Indicates whether the subscription is set to automatically renew at the end of the term. |
| INTEGER | subscription\_cancel\_reason | The reason for cancelling the subscription, if applicable. |
| DATETIME | subscription\_cancel\_date | The date on which the subscription was cancelled, if applicable. |
| DATETIME | subscription\_service\_activation\_date | The date the subscription was activated. |
| STRING | subscription\_status | The status of the subscription associated with the invoice item. |
| DATETIME | subscription\_start\_date | The start date of the subscription associated with the invoice item. |
| DATETIME | subscription\_end\_date | The end date of the subscription associated with the invoice item. |
| DATETIME | subscription\_term\_start\_date | The start date of the subscription term associated with the invoice item. |
| DATETIME | subscription\_term\_end\_date | The end date of the subscription term associated with the invoice item. |
| STRING | subscription\_term\_type | The type of subscription term associated with the invoice item. |
| INTEGER | subscription\_version | The version number of the subscription for the invoice item. |
| STRING | rate\_plan\_charge\_name | The name of the rate plan charge associated with the invoice item. |
| STRING | charge\_billing\_period | The billing period for the charge associated with the invoice item. |
| STRING | charge\_billing\_timing | The timing of the charge for the invoice item. |
| STRING | charge\_model | The model used to calculate the charge for the invoice item. |
| STRING | charge\_type | The type of charge for the invoice item. |
| DATE | charge\_effective\_start\_date | The date on which the rate plan charge goes into effect for the invoice item. |
| DATE | charge\_effective\_end\_date | The date on which the rate plan charge is no longer in effect for the invoice item. |
| INTEGER | charge\_segment | The segment associated with the rate plan charge for the invoice item. |
| DECIMAL | charge\_mrr | The monthly recurring revenue of the rate plan charge for the invoice item. |
| DECIMAL | charge\_mrr\_home\_currency | The monthly recurring revenue of the rate plan charge in the home currency for the invoice item. |
| STRING | amendment\_name | The name of the amendment associated with the invoice item.. |
| STRING | amendment\_type | The type of the amendment associated with the invoice item.. |
| STRING | amendment\_status | The status of the amendment associated with the invoice item. |
| STRING | product\_name | The name of the product associated with the invoice item. |
| STRING | product\_category | The category of the product associated with the invoice item. |
| STRING | product\_description | The description of the product associated with the invoice item. |
| DATE | product\_start\_date | The date when the product becomes available for purchase. |
| DATE | product\_end\_date | The date when the product is no longer available for purchase. |
| STRING | product\_rate\_plan\_name | The name of the product rate plan. |
| STRING | product\_rate\_plan\_description | A brief description of the product rate plan. |
| DECIMAL | gross\_revenue | The charge amount for the invoice item, accumulated as revenue. |
| DECIMAL | discount\_revenue | The discount amount applied to the invoice item, accumulated as revenue. |
| DECIMAL | net\_revenue | The difference between the gross and the discount revenue. |
---
# 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-line-item-history.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.