Xero
## Columns
| Type | Name | Description |
| -------- | ------------------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| DATETIME | \_fivetran\_synced | The timestamp that Fivetran last synced the record. |
| INTEGER | account\_code | Customer defined alpha numeric account code e.g 200 or SALES |
| STRING | line\_item\_description | The description of the line item |
| INTEGER | discount\_entered\_as\_percent | The discount rate for the line item as a percentage. |
| INTEGER | discount\_rate | Percentage discount being applied to a line item. |
| STRING | invoice\_id | The Xero identifier for the invoice the line items belongs to. |
| INTEGER | item\_code | User defined item code. |
| DECIMAL | line\_amount | The line amount reflects the discounted price if a DiscountRate has been used. |
| STRING | line\_item\_id | Xero identifier for the line item. |
| DECIMAL | quantity | The quantity of the line item. |
| DECIMAL | tax\_amount | The tax amount is auto calculated as a percentage of the line amount based on the tax rate. |
| STRING | tax\_type | Used as an override if the default Tax Code for the selected AccountCode is not correct. |
| DECIMAL | unit\_amount | The unit amount of each line item. |
| STRING | source\_relation | The source where this data was pulled from. If you are making use of the `union_schemas` variable, this will be the source schema. If you are making use of the `union_databases` variable, this will be the source database. If you are not unioining together multiple sources, this will be an empty string. |
| DATE | invoice\_date | The date the invoice was issued. |
| STRING | updated\_date | The date the invoice was last modified. |
| INTEGER | planned\_payment\_date | The planned payment date of the invoice, when set. |
| DATE | due\_date | The date the invoice is/was due. |
| INTEGER | expected\_payment\_date | The expected payment date of the invoice, when set. |
| DATE | fully\_paid\_on\_date | The date the invoice was fully paid. Only returned on fully paid invoices |
| STRING | currency\_code | The currency that invoice has been raised in |
| DECIMAL | currency\_rate | The currency rate for a multicurrency invoice |
| STRING | invoice\_number | Alpha numeric code identifying invoice |
| BOOLEAN | is\_sent\_to\_contact | Boolean to indicate whether the invoice in the Xero app displays as "sent" |
| STRING | invoice\_status | The status of the invoice |
| STRING | type | The type of the invoice. |
| INTEGER | url | URL link to a source document |
| STRING | invoice\_reference | Additional reference number. For accounts receivable only. |
| STRING | account\_id | The Xero identifier for the related account. |
| STRING | account\_name | The name of the account. |
| STRING | account\_type | The type of account, e.g. CURRENT, EQUITY, SALES |
| STRING | account\_class | The class of account, e.g. ASSET, EQUITY, EXPENSE, LIABILITY, REVENUE |
| STRING | contact\_name | The name of the associated contact. |
---
# 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/xero-invoice-line-items.md?ask=