# Xero

Xero is an online accounting software for small businesses, automating invoicing, bank reconciliations, and reporting.

Xero integration replicates data using the [Xero Accounting API](https://developer.xero.com/documentation/api/api-overview).

See the [Schema](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#Schema) section for a list of objects available for replication.

## Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Information noteMake sure that the account you use has read access to the tables you want to fetch.

To connect to the Xero integration, you need to have your client ID, client secret, user ID, and tenant ID. Follow the procedures below to copy each setting.

To obtain your client ID and secret:

1. Log into your [Xero](https://developer.xero.com/app/manage) account.
2. Create a new app.
3. Click Configuration on the left. The client ID and secret are displayed.
4. As the client secret is displayed only once, copy and paste it to a secured file. Otherwise, you have to create a new app.
5. Make sure Authorized Redirect URIs is set to https://connector.qlik.com/auth/oauth/v3.htm.

To obtain your user ID:

1. Log into your [Xero](https://go.xero.com/Settings/OrganisationSettings) account.

2. Select the organization in the drop-down list in the top-left corner.

3. Select User from the menu.

4. Select the user account you want to use.

   The user ID is part of the URL `https://go.xero.com/app/.../settings/users/edit?userId=%7BTHIS_IS_THE_USER_ID%7D)`.

To obtain your tenant ID:

1. Log into your [Xero](https://api-explorer.xero.com/) account.
2. To display the tenant ID, select Show auto-generated headers.

## Creating the connection

For more information, see [Connecting to SaaS applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Landing/connecting-web-applications.htm).

1. Click Authenticate when you have filled in the required connection settings.

   You may be asked to log in to the source application.

   A window is displayed with an authentication code.

2. Copy the code to the clipboard and return to the connection dialog.

3. Paste the code in Complete authentication with the code provided by the source and click Verify.

   Tip noteYou may need to scroll down to see this field.

   When status is Verified, the authentication is verified.

4. Provide a name for the connection in Connection name.

5. Select Open connection metadata to define metadata for the connection when it has been created.

Connection settings

| Setting | Description |
| --- | --- |
| Data gateway | Select a Data Movement gateway if required by your use case.<br><br>Information note<br><br>This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None.<br><br>For information on the benefits of Data Movement gateway and use cases that require it, see [Qlik Data Gateway - Data Movement](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/replication-gateway.htm). |
| Start Date | Enter the date, in the format `MM/DD/YYYY`, from which the data must be replicated from your source to your target. |
| Include Archived Contacts | Select the check box to include archive contacts. |
| Client ID | Client ID. |
| Access Token | Access token. |
| Organization Name | Organization name. |
| Xero User ID | Xero user ID. |
| Tenant ID | Tenant ID. |

## Schema

Information note

**Schemas and versioning**

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

### accounts

The `accounts` table contains info about the various accounts (ex: banking) connected to your Xero account.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | AccountID |
| **Replication Key** | UpdatedDateUTC |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/accounts "Opens in new tab: Xero API method") |

accounts table foreign keys

| Join accounts with | on |
| --- | --- |
| [bank_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#bank-transactions) | ```<br>accounts.AccountID = bank_transactions.BankAccount.AccountID<br>```<br><br>```<br>accounts.CurrencyCode = bank_transactions.CurrencyCode<br>``` |
| [bank_transfers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#bank-transfers) | ```<br>accounts.AccountID = bank_transfers.FromBankAccount.AccountID<br>```<br><br>```<br>accounts.AccountID = bank_transfers.ToBankAccount.AccountID<br>``` |
| [journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#journals) | ```<br>accounts.AccountID = journals.JournalLines.AccountID<br>``` |
| [payments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#payments) | ```<br>accounts.AccountID = payments.Account.AccountID<br>``` |
| [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#credit-notes) | ```<br>accounts.CurrencyCode = credit_notes.CurrencyCode<br>``` |
| [currencies](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#currencies) | ```<br>accounts.CurrencyCode = currencies.Code<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#invoices) | ```<br>accounts.CurrencyCode = invoices.CurrencyCode<br>``` |
| [prepayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#prepayments) | ```<br>accounts.CurrencyCode = prepayments.CurrencyCode<br>``` |
| [purchase_orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#purchase-orders) | ```<br>accounts.CurrencyCode = purchase_orders.CurrencyCode<br>``` |
| [repeating_invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#repeating-invoices) | ```<br>accounts.CurrencyCode = repeating_invoices.CurrencyCode<br>``` |

accounts table schema

| **AccountID**<br><br><br>STRING |
| --- |
| **BankAccountNumber**<br><br><br>STRING |
| **BankAccountType**<br><br><br>STRING |
| **Class**<br><br><br>STRING |
| **Code**<br><br><br>STRING |
| **CurrencyCode**<br><br><br>STRING |
| **Description**<br><br><br>STRING |
| **EnablePaymentsToAccount**<br><br><br>BOOLEAN |
| **HasAttachments**<br><br><br>BOOLEAN |
| **Name**<br><br><br>STRING |
| **ReportingCode**<br><br><br>STRING |
| **ReportingCodeName**<br><br><br>STRING |
| **ShowInExpenseClaims**<br><br><br>BOOLEAN |
| **Status**<br><br><br>STRING |
| **SystemAccount**<br><br><br>STRING |
| **TaxType**<br><br><br>STRING |
| **Type**<br><br><br>STRING |
| **UpdatedDateUTC**<br><br><br>DATE-TIME |

### bank\_transactions

The `bank_transactions` table contains info about the bank transactions in your Xero account.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | BankTransactionID |
| **Replication Key** | UpdatedDateUTC |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/banktransactions "Opens in new tab: Xero API method") |

bank\_transactions table foreign keys

| Join bank\_transactions with | on |
| --- | --- |
| [accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#accounts) | ```<br>bank_transactions.BankAccount.AccountID = accounts.AccountID<br>```<br><br>```<br>bank_transactions.CurrencyCode = accounts.CurrencyCode<br>``` |
| [bank_transfers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#bank-transfers) | ```<br>bank_transactions.BankAccount.AccountID = bank_transfers.FromBankAccount.AccountID<br>```<br><br>```<br>bank_transactions.BankAccount.AccountID = bank_transfers.ToBankAccount.AccountID<br>``` |
| [journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#journals) | ```<br>bank_transactions.BankAccount.AccountID = journals.JournalLines.AccountID<br>``` |
| [payments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#payments) | ```<br>bank_transactions.BankAccount.AccountID = payments.Account.AccountID<br>```<br><br>```<br>bank_transactions.OverpaymentID = payments.Overpayment.OverpaymentID<br>```<br><br>```<br>bank_transactions.PrepaymentID = payments.Prepayments.PrepaymentID<br>``` |
| [linked_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#linked-transactions) | ```<br>bank_transactions.BankTransactionID = linked_transactions.SourceTransactionID<br>``` |
| [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#credit-notes) | ```<br>bank_transactions.CurrencyCode = credit_notes.CurrencyCode<br>``` |
| [currencies](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#currencies) | ```<br>bank_transactions.CurrencyCode = currencies.Code<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#invoices) | ```<br>bank_transactions.CurrencyCode = invoices.CurrencyCode<br>```<br><br>```<br>bank_transactions.OverpaymentID = invoices.Overpayments.Overpayment.OverpaymentID<br>```<br><br>```<br>bank_transactions.PrepaymentID = invoices.Prepayments.PrepaymentID<br>```<br><br>```<br>bank_transactions.BankTransactionID = invoices.InvoiceID<br>``` |
| [prepayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#prepayments) | ```<br>bank_transactions.CurrencyCode = prepayments.CurrencyCode<br>```<br><br>```<br>bank_transactions.PrepaymentID = prepayments.PrepaymentID<br>``` |
| [purchase_orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#purchase-orders) | ```<br>bank_transactions.CurrencyCode = purchase_orders.CurrencyCode<br>``` |
| [repeating_invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#repeating-invoices) | ```<br>bank_transactions.CurrencyCode = repeating_invoices.CurrencyCode<br>``` |
| [overpayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#overpayments) | ```<br>bank_transactions.OverpaymentID = overpayments.OverpaymentID<br>``` |

bank\_transactions table schema

| **BankAccount**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>AccountID: STRING</li><li>BankAccountNumber: STRING</li><li>BankAccountType: STRING</li><li>Class: STRING</li><li>Code: STRING</li><li>CurrencyCode: STRING</li><li>Description: STRING</li><li>EnablePaymentsToAccount: BOOLEAN</li><li>HasAttachments: BOOLEAN</li><li>Name: STRING</li><li>ReportingCode: STRING</li><li>ReportingCodeName: STRING</li><li>ShowInExpenseClaims: BOOLEAN</li><li>Status: STRING</li><li>SystemAccount: STRING</li><li>TaxType: STRING</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li></ul> |
| --- |
| **BankTransactionID**<br><br><br>STRING |
| **Contact**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>AccountNumber: STRING</li><li>AccountsPayableTaxType: STRING</li><li>AccountsReceivableTaxType: STRING</li><li>Addresses: ARRAY, which is also a nested data structure.											<ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode:  STRING</li><li>Region: STRING</li></ul></li><li>Attachments: ARRAY</li><li>Balances: OBJECT, which is also a nested data structure.											<ul><li>AccountsPayable: OBJECT,  which is also a nested data structure.													<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.													<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul></li><li>BankAccountDetails: STRING</li><li>BatchPayments: OBJECT, which is also a nested data structure.											<ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul></li><li>BrandingTheme: OBJECT, which is also a nested data structure.											<ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DATE-TIME</li><li>Name: STRING</li><li>SortOrder: INTEGER</li></ul></li><li>ContactGroups: ARRAY, which is also a nested data structure.											<ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul></li><li>ContactID: STRING</li><li>ContactNumber: STRING</li><li>ContactPersons: ARRAY, which is also a nested data structure.											<ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul></li><li>ContactStatus: STRING</li><li>DefaultCurrency: STRING</li><li>Discount: NUMBER</li><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>HasAttachments: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>IsCustomer: BOOLEAN</li><li>IsSupplier: BOOLEAN</li><li>LastName: STRING</li><li>Name: STRING</li><li>PaymentTerms: OBJECT, which is also a nested data structure.											<ul><li>Bills: OBJECT, which is also a nested data structure.													<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.													<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul></li><li>Phones: ARRAY, which is also a nested data structure.											<ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul></li><li>PurchasesDefaultAccountCode: STRING</li><li>PurchasesTrackingCategories: ARRAY, which is also a nested data structure.											<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.													<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SalesDefaultAccountCode: STRING</li><li>SalesTrackingCategories: ARRAY, which is also a nested data structure.											<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.													<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SkypeUserName: STRING</li><li>TaxNumber: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingCategoryOption: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>ValidationErrors: ARRAY, which is also a nested data structure.											<ul><li>Message: STRING</li></ul></li><li>Website: STRING</li><li>XeroNetworkKey: STRING</li></ul> |
| **CurrencyCode**<br><br><br>STRING |
| **CurrencyRate**<br><br><br>NUMBER |
| **Date**<br><br><br>DATE-TIME |
| **DateString**<br><br><br>DATE-TIME |
| **ExternalLinkProviderName**<br><br><br>STRING |
| **HasAttachments**<br><br><br>BOOLEAN |
| **IsReconciled**<br><br><br>BOOLEAN |
| **LineAmountTypes**<br><br><br>STRING |
| **LineItems**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>AccountCode: STRING</li><li>Description: STRING</li><li>DiscountRate: NUMBER</li><li>ItemCode: STRING</li><li>LineAmount: NUMBER</li><li>LineItemID: STRING</li><li>Quantity: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.											<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.													<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>UnitAmount: NUMBER</li></ul> |
| **OverpaymentID**<br><br><br>STRING |
| **PrepaymentID**<br><br><br>STRING |
| **Reference**<br><br><br>STRING |
| **Status**<br><br><br>STRING |
| **SubTotal**<br><br><br>NUMBER |
| **Total**<br><br><br>NUMBER |
| **TotalTax**<br><br><br>NUMBER |
| **Type**<br><br><br>STRING |
| **UpdatedDateUTC**<br><br><br>DATE-TIME |
| **Url**<br><br><br>STRING |

### bank\_transfers

The `bank_transfers` table contains info about bank transfers.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | BankTransferID |
| **Replication Key** | CreatedDateUTC |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/bank-transfers "Opens in new tab: Xero API method") |

bank\_transfers table foreign keys

| Join bank\_transfers with | on |
| --- | --- |
| [accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#accounts) | ```<br>bank_transfers.FromBankAccount.AccountID = accounts.AccountID<br>```<br><br>```<br>bank_transfers.ToBankAccount.AccountID = accounts.AccountID<br>``` |
| [bank_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#bank-transactions) | ```<br>bank_transfers.FromBankAccount.AccountID = bank_transactions.BankAccount.AccountID<br>```<br><br>```<br>bank_transfers.ToBankAccount.AccountID = bank_transactions.BankAccount.AccountID<br>``` |
| [journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#journals) | ```<br>bank_transfers.FromBankAccount.AccountID = journals.JournalLines.AccountID<br>```<br><br>```<br>bank_transfers.ToBankAccount.AccountID = journals.JournalLines.AccountID<br>``` |
| [payments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#payments) | ```<br>bank_transfers.FromBankAccount.AccountID = payments.Account.AccountID<br>```<br><br>```<br>bank_transfers.ToBankAccount.AccountID = payments.Account.AccountID<br>``` |

bank\_transfers table schema

| **Amount**<br><br><br>NUMBER |
| --- |
| **BankTransferID**<br><br><br>STRING |
| **CreatedDateUTC**<br><br><br>DATE-TIME |
| **CreatedDateUTCString**<br><br><br>DATE-TIME |
| **CurrencyRate**<br><br><br>NUMBER |
| **Date**<br><br><br>DATE-TIME |
| **DateString**<br><br><br>DATE-TIME |
| **FromBankAccount**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>AccountID: STRING</li><li>BankAccountNumber: STRING</li><li>BankAccountType: STRING</li><li>Class: STRING</li><li>Code: STRING</li><li>CurrencyCode: STRING</li><li>Description: STRING</li><li>EnablePaymentsToAccount: BOOLEAN</li><li>HasAttachments: BOOLEAN</li><li>Name: STRING</li><li>ReportingCode: STRING</li><li>ReportingCodeName: STRING</li><li>ShowInExpenseClaims: BOOLEAN</li><li>Status: STRING</li><li>SystemAccount: STRING</li><li>TaxType: STRING</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li></ul> |
| **FromBankTransactionID**<br><br><br>STRING |
| **HasAttachments**<br><br><br>BOOLEAN |
| **ToBankAccount**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>AccountID: STRING</li><li>BankAccountNumber: STRING</li><li>BankAccountType: STRING</li><li>Class: STRING</li><li>Code: STRING</li><li>CurrencyCode: STRING</li><li>Description: STRING</li><li>EnablePaymentsToAccount: BOOLEAN</li><li>HasAttachments: BOOLEAN</li><li>Name: STRING</li><li>ReportingCode: STRING</li><li>ReportingCodeName: STRING</li><li>ShowInExpenseClaims: BOOLEAN</li><li>Status: STRING</li><li>SystemAccount: STRING</li><li>TaxType: STRING</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li></ul> |
| **ToBankTransactionID**<br><br><br>STRING |

### branding\_themes

The `branding_themes` table contains info about your branding themes. A branding theme is customization you can apply to customer-facing documents such as invoices, statements, quotes, etc.

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | BrandingThemeID |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/branding-themes "Opens in new tab: Xero API method") |

branding\_themes table foreign keys

| Join branding\_themes with | on |
| --- | --- |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#contacts) | ```<br>branding_themes.BrandingThemeID = contacts.BrandingTheme.BrandingThemeID<br>``` |
| [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#credit-notes) | ```<br>branding_themes.BrandingThemeID = credit_notes.BrandingThemeID<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#invoices) | ```<br>branding_themes.BrandingThemeID = invoices.BrandingThemeID<br>``` |
| [purchase_orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#purchase-orders) | ```<br>branding_themes.BrandingThemeID = purchase_orders.BrandingThemeID<br>``` |
| [repeating_invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#repeating-invoices) | ```<br>branding_themes.BrandingThemeID = repeating_invoices.BrandingThemeID<br>``` |

branding\_themes table schema

| **BrandingThemeID**<br><br><br>STRING |
| --- |
| **CreatedDateUTC**<br><br><br>DATE-TIME |
| **Name**<br><br><br>STRING |
| **SortOrder**<br><br><br>INTEGER |

### contact\_groups

The `contact_groups` table contains info about your contact groups. A contact group is a group of contacts that have something in common.

**Note**: Due to the limits of Xero’s API, only active contact groups (`Status: ACTIVE`) may be retrieved.

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | ContactGroupID |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/contactgroups "Opens in new tab: Xero API method") |

contact\_groups table foreign keys

| Join contact\_groups with | on |
| --- | --- |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#contacts) | ```<br>contact_groups.ContactGroupID = contacts.ContactGroups.ContactGroupID<br>``` |

contact\_groups table schema

| **ContactGroupID**<br><br><br>STRING |
| --- |
| **HasValidationErrors**<br><br><br>BOOLEAN |
| **Name**<br><br><br>STRING |
| **Status**<br><br><br>STRING |

### contacts

The `contacts` table contains info about the customers and suppliers you do business with.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | ContactID |
| **Replication Key** | UpdatedDateUTC |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/contacts "Opens in new tab: Xero API method") |

contacts table foreign keys

| Join contacts with | on |
| --- | --- |
| [branding_themes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#branding-themes) | ```<br>contacts.BrandingTheme.BrandingThemeID = branding_themes.BrandingThemeID<br>``` |
| [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#credit-notes) | ```<br>contacts.BrandingTheme.BrandingThemeID = credit_notes.BrandingThemeID<br>```<br><br>```<br>contacts.ContactID = credit_notes.Contact.ContactID<br>```<br><br>```<br>contacts.SalesTrackingCategories.TrackingCategoryID = credit_notes.LineItems.Tracking.TrackingCategoryID<br>```<br><br>```<br>contacts.PurchasesTrackingCategories.TrackingCategoryID = credit_notes.LineItems.Tracking.TrackingCategoryID<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#invoices) | ```<br>contacts.BrandingTheme.BrandingThemeID = invoices.BrandingThemeID<br>```<br><br>```<br>contacts.ContactID = invoices.Contact.ContactID<br>```<br><br>```<br>contacts.SalesTrackingCategories.TrackingCategoryID = invoices.LineItems.Tracking.TrackingCategoryID<br>```<br><br>```<br>contacts.PurchasesTrackingCategories.TrackingCategoryID = invoices.LineItems.Tracking.TrackingCategoryID<br>``` |
| [purchase_orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#purchase-orders) | ```<br>contacts.BrandingTheme.BrandingThemeID = purchase_orders.BrandingThemeID<br>```<br><br>```<br>contacts.SalesTrackingCategories.TrackingCategoryID = purchase_orders.LineItems.Tracking.TrackingCategoryID<br>```<br><br>```<br>contacts.PurchasesTrackingCategories.TrackingCategoryID = purchase_orders.LineItems.Tracking.TrackingCategoryID<br>``` |
| [repeating_invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#repeating-invoices) | ```<br>contacts.BrandingTheme.BrandingThemeID = repeating_invoices.BrandingThemeID<br>```<br><br>```<br>contacts.ContactID = repeating_invoices.Contact.ContactID<br>```<br><br>```<br>contacts.SalesTrackingCategories.TrackingCategoryID = repeating_invoices.LineItems.Tracking.TrackingCategoryID<br>```<br><br>```<br>contacts.PurchasesTrackingCategories.TrackingCategoryID = repeating_invoices.LineItems.Tracking.TrackingCategoryID<br>``` |
| [contact_groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#contact-groups) | ```<br>contacts.ContactGroups.ContactGroupID = contact_groups.ContactGroupID<br>``` |
| [linked_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#linked-transactions) | ```<br>contacts.ContactID = linked_transactions.ContactID<br>``` |
| [overpayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#overpayments) | ```<br>contacts.ContactID = overpayments.Contact.ContactID<br>```<br><br>```<br>contacts.SalesTrackingCategories.TrackingCategoryID = overpayments.LineItems.Tracking.TrackingCategoryID<br>```<br><br>```<br>contacts.PurchasesTrackingCategories.TrackingCategoryID = overpayments.LineItems.Tracking.TrackingCategoryID<br>``` |
| [prepayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#prepayments) | ```<br>contacts.ContactID = prepayments.Contact.ContactID<br>```<br><br>```<br>contacts.SalesTrackingCategories.TrackingCategoryID = prepayments.LineItems.Tracking.TrackingCategoryID<br>```<br><br>```<br>contacts.PurchasesTrackingCategories.TrackingCategoryID = prepayments.LineItems.Tracking.TrackingCategoryID<br>``` |
| [receipts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#receipts) | ```<br>contacts.ContactID = receipts.Contact.ContactID<br>```<br><br>```<br>contacts.SalesTrackingCategories.TrackingCategoryID = receipts.LineItems.Tracking.TrackingCategoryID<br>```<br><br>```<br>contacts.PurchasesTrackingCategories.TrackingCategoryID = receipts.LineItems.Tracking.TrackingCategoryID<br>``` |
| [journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#journals) | ```<br>contacts.SalesTrackingCategories.TrackingCategoryID = journals.JournalLines.TrackingCategories.TrackingCategoryID<br>```<br><br>```<br>contacts.PurchasesTrackingCategories.TrackingCategoryID = journals.JournalLines.TrackingCategories.TrackingCategoryID<br>``` |
| [manual_journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#manual-journals) | ```<br>contacts.SalesTrackingCategories.TrackingCategoryID = manual_journals.JournalLines.Tracking.TrackingCategoryID<br>```<br><br>```<br>contacts.PurchasesTrackingCategories.TrackingCategoryID = manual_journals.JournalLines.Tracking.TrackingCategoryID<br>``` |
| [tracking_categories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#tracking-categories) | ```<br>contacts.SalesTrackingCategories.TrackingCategoryID = tracking_categories.TrackingCategoryID<br>```<br><br>```<br>contacts.PurchasesTrackingCategories.TrackingCategoryID = tracking_categories.TrackingCategoryID<br>``` |

contacts table schema

| **AccountNumber**<br><br><br>STRING |
| --- |
| **AccountsPayableTaxType**<br><br><br>STRING |
| **AccountsReceivableTaxType**<br><br><br>STRING |
| **Addresses**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul> |
| **Attachments**<br><br><br>ARRAY |
| **Balances**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>AccountsPayable: OBJECT, which is also a nested data structure.											<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.											<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul> |
| **BankAccountDetails**<br><br><br>STRING |
| **BatchPayments**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul> |
| **BrandingTheme**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DATE-TIME</li><li>Name: STRING</li><li>SortOrder: INTEGER</li></ul> |
| **ContactGroups**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul> |
| **ContactID**<br><br><br>STRING |
| **ContactNumber**<br><br><br>STRING |
| **ContactPersons**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul> |
| **ContactStatus**<br><br><br>STRING |
| **DefaultCurrency**<br><br><br>STRING |
| **Discount**<br><br><br>NUMBER |
| **EmailAddress**<br><br><br>STRING |
| **FirstName**<br><br><br>STRING |
| **HasAttachments**<br><br><br>BOOLEAN |
| **HasValidationErrors**<br><br><br>BOOLEAN |
| **IsCustomer**<br><br><br>BOOLEAN |
| **IsSupplier**<br><br><br>BOOLEAN |
| **LastName**<br><br><br>STRING |
| **Name**<br><br><br>STRING |
| **PaymentTerms**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>Bills: OBJECT, which is also a nested data structure.											<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.											<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul> |
| **Phones**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul> |
| **PurchasesDefaultAccountCode**<br><br><br>STRING |
| **PurchasesTrackingCategories**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.											<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul> |
| **SalesDefaultAccountCode**<br><br><br>STRING |
| **SalesTrackingCategories**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.											<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul> |
| **SkypeUserName**<br><br><br>STRING |
| **TaxNumber**<br><br><br>STRING |
| **TrackingCategoryName**<br><br><br>STRING |
| **TrackingCategoryOption**<br><br><br>STRING |
| **UpdatedDateUTC**<br><br><br>DATE-TIME |
| **ValidationErrors**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>Message: STRING</li></ul> |
| **Website**<br><br><br>STRING |
| **XeroNetworkKey**<br><br><br>STRING |

### credit\_notes

The `credit_notes` table contains info about credit notes. A credit note is similar to an invoice, except it reduces the amount you owe a supplier or the amount a customer owes you.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | CreditNoteID |
| **Replication Key** | UpdatedDateUTC |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/credit-notes "Opens in new tab: Xero API method") |

credit\_notes table foreign keys

| Join credit\_notes with | on |
| --- | --- |
| [branding_themes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#branding-themes) | ```<br>credit_notes.BrandingThemeID = branding_themes.BrandingThemeID<br>``` |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#contacts) | ```<br>credit_notes.BrandingThemeID = contacts.BrandingTheme.BrandingThemeID<br>```<br><br>```<br>credit_notes.Contact.ContactID = contacts.ContactID<br>```<br><br>```<br>credit_notes.LineItems.Tracking.TrackingCategoryID = contacts.SalesTrackingCategories.TrackingCategoryID<br>```<br><br>```<br>credit_notes.LineItems.Tracking.TrackingCategoryID = contacts.PurchasesTrackingCategories.TrackingCategoryID<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#invoices) | ```<br>credit_notes.BrandingThemeID = invoices.BrandingThemeID<br>```<br><br>```<br>credit_notes.Contact.ContactID = invoices.Contact.ContactID<br>```<br><br>```<br>credit_notes.CreditNoteID = invoices.CreditNotes.CreditNoteID<br>```<br><br>```<br>credit_notes.CurrencyCode = invoices.CurrencyCode<br>```<br><br>```<br>credit_notes.LineItems.Tracking.TrackingCategoryID = invoices.LineItems.Tracking.TrackingCategoryID<br>``` |
| [purchase_orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#purchase-orders) | ```<br>credit_notes.BrandingThemeID = purchase_orders.BrandingThemeID<br>```<br><br>```<br>credit_notes.CurrencyCode = purchase_orders.CurrencyCode<br>```<br><br>```<br>credit_notes.LineItems.Tracking.TrackingCategoryID = purchase_orders.LineItems.Tracking.TrackingCategoryID<br>``` |
| [repeating_invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#repeating-invoices) | ```<br>credit_notes.BrandingThemeID = repeating_invoices.BrandingThemeID<br>```<br><br>```<br>credit_notes.Contact.ContactID = repeating_invoices.Contact.ContactID<br>```<br><br>```<br>credit_notes.CurrencyCode = repeating_invoices.CurrencyCode<br>```<br><br>```<br>credit_notes.LineItems.Tracking.TrackingCategoryID = repeating_invoices.LineItems.Tracking.TrackingCategoryID<br>``` |
| [linked_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#linked-transactions) | ```<br>credit_notes.Contact.ContactID = linked_transactions.ContactID<br>``` |
| [overpayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#overpayments) | ```<br>credit_notes.Contact.ContactID = overpayments.Contact.ContactID<br>```<br><br>```<br>credit_notes.LineItems.Tracking.TrackingCategoryID = overpayments.LineItems.Tracking.TrackingCategoryID<br>``` |
| [prepayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#prepayments) | ```<br>credit_notes.Contact.ContactID = prepayments.Contact.ContactID<br>```<br><br>```<br>credit_notes.CurrencyCode = prepayments.CurrencyCode<br>```<br><br>```<br>credit_notes.LineItems.Tracking.TrackingCategoryID = prepayments.LineItems.Tracking.TrackingCategoryID<br>``` |
| [receipts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#receipts) | ```<br>credit_notes.Contact.ContactID = receipts.Contact.ContactID<br>```<br><br>```<br>credit_notes.LineItems.Tracking.TrackingCategoryID = receipts.LineItems.Tracking.TrackingCategoryID<br>``` |
| [accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#accounts) | ```<br>credit_notes.CurrencyCode = accounts.CurrencyCode<br>``` |
| [bank_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#bank-transactions) | ```<br>credit_notes.CurrencyCode = bank_transactions.CurrencyCode<br>``` |
| [currencies](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#currencies) | ```<br>credit_notes.CurrencyCode = currencies.Code<br>``` |
| [journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#journals) | ```<br>credit_notes.LineItems.Tracking.TrackingCategoryID = journals.JournalLines.TrackingCategories.TrackingCategoryID<br>``` |
| [manual_journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#manual-journals) | ```<br>credit_notes.LineItems.Tracking.TrackingCategoryID = manual_journals.JournalLines.Tracking.TrackingCategoryID<br>``` |
| [tracking_categories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#tracking-categories) | ```<br>credit_notes.LineItems.Tracking.TrackingCategoryID = tracking_categories.TrackingCategoryID<br>``` |

credit\_notes table schema

| **Allocations**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>Amount: NUMBER</li><li>Date: DATE-TIME</li><li>Invoice: OBJECT, which is also a nested data structure.											<ul><li>AmountCredited: NUMBER</li><li>AmountDue: NUMBER</li><li>AmountPaid: NUMBER</li><li>BrandingThemeID: STRING</li><li>Contact: OBJECT, which is also a nested data structure.													<ul><li>AccountNumber: STRING</li><li>AccountsPayableTaxType: STRING</li><li>AccountsReceivableTaxType: STRING</li><li>Addresses: ARRAY, which is also a nested data structure.															<ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul></li><li>Attachments: ARRAY</li><li>Balances: OBJECT, which is also a nested data structure.															<ul><li>AccountsPayable: OBJECT, which is also a nested data structure.																	<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.																	<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul></li><li>BankAccountDetails: STRING</li><li>BatchPayments: OBJECT, which is also a nested data structure.															<ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul></li><li>BrandingTheme: OBJECT, which is also a nested data structure.															<ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DATE-TIME</li><li>Name: STRING</li><li>SortOrder: INTEGER</li></ul></li><li>ContactGroups: ARRAY, which is also a nested data structure.															<ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul></li><li>ContactID: STRING</li><li>ContactNumber: STRING</li><li>ContactPersons: ARRAY, which is also a nested data structure.															<ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul></li><li>ContactStatus: STRING</li><li>DefaultCurrency: STRING</li><li>Discount: NUMBER</li><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>HasAttachments: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>IsCustomer: BOOLEAN</li><li>IsSupplier: BOOLEAN</li><li>LastName: STRING</li><li>Name: STRING</li><li>PaymentTerms: OBJECT, which is also a nested data structure.															<ul><li>Bills: OBJECT, which is also a nested data structure.																	<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.																	<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul></li><li>Phones: ARRAY, which is also a nested data structure.															<ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul></li><li>PurchasesDefaultAccountCode: STRING</li><li>PurchasesTrackingCategories: ARRAY, which is also a nested data structure.															<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.																	<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SalesDefaultAccountCode: STRING</li><li>SalesTrackingCategories: ARRAY, which is also a nested data structure.															<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.																	<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SkypeUserName: STRING</li><li>TaxNumber: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingCategoryOption: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>ValidationErrors: ARRAY, which is also a nested data structure.															<ul><li>Message: STRING</li></ul></li><li>Website: STRING</li><li>XeroNetworkKey: STRING</li></ul></li><li>CurrencyCode: STRING</li><li>CurrencyRate: NUMBER</li><li>Date: DATE-TIME</li><li>DateString: DATE-TIME</li><li>DueDate: DATE-TIME</li><li>DueDateString: DATE-TIME</li><li>ExpectedPaymentDate: DATE-TIME</li><li>FullyPaidOnDate: DATE-TIME</li><li>HasAttachments: BOOLEAN</li><li>HasErrors: BOOLEAN</li><li>InvoiceID: STRING</li><li>InvoiceNumber: STRING</li><li>IsDiscounted: BOOLEAN</li><li>LineAmountTypes: STRING</li><li>LineItems: ARRAY, which is also a nested data structure.													<ul><li>AccountCode: STRING</li><li>Description: STRING</li><li>DiscountRate: NUMBER</li><li>ItemCode: STRING</li><li>LineAmount: NUMBER</li><li>LineItemID: STRING</li><li>Quantity: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.															<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.																	<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>UnitAmount: NUMBER</li></ul></li><li>PlannedPaymentDate: DATE-TIME</li><li>Reference: STRING</li><li>SentToContact: BOOLEAN</li><li>Status: STRING</li><li>SubTotal: NUMBER</li><li>Total: NUMBER</li><li>TotalDiscount: NUMBER</li><li>TotalTax: NUMBER</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>Url: STRING</li></ul></li></ul> |
| --- |
| **AppliedAmount**<br><br><br>NUMBER |
| **BrandingThemeID**<br><br><br>STRING |
| **Contact**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>AccountNumber: STRING</li><li>AccountsPayableTaxType: STRING</li><li>AccountsReceivableTaxType: STRING</li><li>Addresses: ARRAY, which is also a nested data structure.											<ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul></li><li>Attachments: ARRAY</li><li>Balances: OBJECT, which is also a nested data structure.											<ul><li>AccountsPayable: OBJECT, which is also a nested data structure.													<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.													<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul></li><li>BankAccountDetails: STRING</li><li>BatchPayments: OBJECT, which is also a nested data structure.											<ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul></li><li>BrandingTheme: OBJECT, which is also a nested data structure.											<ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DATE-TIME</li><li>Name: STRING</li><li>SortOrder: INTEGER</li></ul></li><li>ContactGroups: ARRAY, which is also a nested data structure.											<ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul></li><li>ContactID: STRING</li><li>ContactNumber: STRING</li><li>ContactPersons: ARRAY, which is also a nested data structure.											<ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul></li><li>ContactStatus: STRING</li><li>DefaultCurrency: STRING</li><li>Discount: NUMBER</li><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>HasAttachments: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>IsCustomer: BOOLEAN</li><li>IsSupplier: BOOLEAN</li><li>LastName: STRING</li><li>Name: STRING</li><li>PaymentTerms: OBJECT, which is also a nested data structure.											<ul><li>Bills: OBJECT, which is also a nested data structure.													<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.													<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul></li><li>Phones: ARRAY, which is also a nested data structure.											<ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul></li><li>PurchasesDefaultAccountCode: STRING</li><li>PurchasesTrackingCategories: ARRAY, which is also a nested data structure.											<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.													<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SalesDefaultAccountCode: STRING</li><li>SalesTrackingCategories: ARRAY, which is also a nested data structure.											<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.													<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SkypeUserName: STRING</li><li>TaxNumber: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingCategoryOption: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>ValidationErrors: ARRAY, which is also a nested data structure.											<ul><li>Message: STRING</li></ul></li><li>Website: STRING</li><li>XeroNetworkKey: STRING</li></ul> |
| **CreditNoteID**<br><br><br>STRING |
| **CreditNoteNumber**<br><br><br>STRING |
| **CurrencyCode**<br><br><br>STRING |
| **CurrencyRate**<br><br><br>NUMBER |
| **Date**<br><br><br>DATE-TIME |
| **DateString**<br><br><br>DATE-TIME |
| **DueDate**<br><br><br>DATE-TIME |
| **DueDateString**<br><br><br>DATE-TIME |
| **FullyPaidOnDate**<br><br><br>DATE-TIME |
| **HasAttachments**<br><br><br>BOOLEAN |
| **ID**<br><br><br>STRING |
| **LineAmountTypes**<br><br><br>STRING |
| **LineItems**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>AccountCode: STRING</li><li>Description: STRING</li><li>DiscountRate: NUMBER</li><li>ItemCode: STRING</li><li>LineAmount: NUMBER</li><li>LineItemID: STRING</li><li>Quantity: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.											<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.													<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>UnitAmount: NUMBER</li></ul> |
| **Reference**<br><br><br>STRING |
| **RemainingCredit**<br><br><br>NUMBER |
| **SentToContact**<br><br><br>BOOLEAN |
| **Status**<br><br><br>STRING |
| **SubTotal**<br><br><br>NUMBER |
| **Total**<br><br><br>NUMBER |
| **TotalTax**<br><br><br>NUMBER |
| **Type**<br><br><br>STRING |
| **UpdatedDateUTC**<br><br><br>DATE-TIME |

### currencies

The `currencies` table contains info about the currencies available in your Xero account.

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | Code |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/currencies "Opens in new tab: Xero API method") |

currencies table foreign keys

| Join currencies with | on |
| --- | --- |
| [accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#accounts) | ```<br>currencies.Code = accounts.CurrencyCode<br>``` |
| [bank_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#bank-transactions) | ```<br>currencies.Code = bank_transactions.CurrencyCode<br>``` |
| [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#credit-notes) | ```<br>currencies.Code = credit_notes.CurrencyCode<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#invoices) | ```<br>currencies.Code = invoices.CurrencyCode<br>``` |
| [prepayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#prepayments) | ```<br>currencies.Code = prepayments.CurrencyCode<br>``` |
| [purchase_orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#purchase-orders) | ```<br>currencies.Code = purchase_orders.CurrencyCode<br>``` |
| [repeating_invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#repeating-invoices) | ```<br>currencies.Code = repeating_invoices.CurrencyCode<br>``` |

currencies table schema

| **Code**<br><br><br>STRING |
| --- |
| **Description**<br><br><br>STRING |

### employees

The `employees` table contains info about employees.

**Note**: According to [Xero’s documentation](https://developer.xero.com/documentation/api/employees), the endpoint that produces this table is:

> Used for an [employee type](https://help.xero.com/int/Contacts_EmployeeAdd) used exclusively by the global Payrun functionality in Xero core accounting.

As a result, this table may not contain all employee data. Refer to the `contacts` table if you believe you are missing records.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | EmployeeID |
| **Replication Key** | UpdatedDateUTC |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/employees "Opens in new tab: Xero API method") |

employees table schema

| **EmployeeID**<br><br><br>STRING |
| --- |
| **ExternalLink**<br><br><br>STRING |
| **FirstName**<br><br><br>STRING |
| **LastName**<br><br><br>STRING |
| **Status**<br><br><br>STRING |
| **UpdatedDateUTC**<br><br><br>DATE-TIME |

### expense\_claims

The `expense_claims` table contains info about expense claims.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | ExpenseClaimID |
| **Replication Key** | UpdatedDateUTC |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/expense-claims "Opens in new tab: Xero API method") |

expense\_claims table foreign keys

| Join expense\_claims with | on |
| --- | --- |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#invoices) | ```<br>expense_claims.Payments.PaymentID = invoices.Payments.PaymentID<br>``` |
| [overpayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#overpayments) | ```<br>expense_claims.Payments.PaymentID = overpayments.Payments.PaymentID<br>``` |
| [payments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#payments) | ```<br>expense_claims.Payments.PaymentID = payments.PaymentID<br>``` |
| [receipts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#receipts) | ```<br>expense_claims.Receipts.ReceiptID = receipts.ReceiptID<br>```<br><br>```<br>expense_claims.User.UserID = receipts.User.UserID<br>``` |

expense\_claims table schema

| **AmountDue**<br><br><br>NUMBER |
| --- |
| **AmountPaid**<br><br><br>NUMBER |
| **ExpenseClaimID**<br><br><br>STRING |
| **PaymentDueDate**<br><br><br>DATE-TIME |
| **Payments**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>Account: OBJECT, which is also a nested data structure.											<ul><li>AccountID: STRING</li><li>BankAccountNumber: STRING</li><li>BankAccountType: STRING</li><li>Class: STRING</li><li>Code: STRING</li><li>CurrencyCode: STRING</li><li>Description: STRING</li><li>EnablePaymentsToAccount: BOOLEAN</li><li>HasAttachments: BOOLEAN</li><li>Name: STRING</li><li>ReportingCode: STRING</li><li>ReportingCodeName: STRING</li><li>ShowInExpenseClaims: BOOLEAN</li><li>Status: STRING</li><li>SystemAccount: STRING</li><li>TaxType: STRING</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li></ul></li><li>Amount: NUMBER</li><li>BankAmount: NUMBER</li><li>BatchPaymentID: STRING</li><li>CreditNote: OBJECT, which is also a nested data structure.											<ul><li>CreditNoteNumber: STRING</li></ul></li><li>CurrencyRate: NUMBER</li><li>Date: DATE-TIME</li><li>HasAccount: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>Invoice: OBJECT, which is also a nested data structure.											<ul><li>AmountCredited: NUMBER</li><li>AmountDue: NUMBER</li><li>AmountPaid: NUMBER</li><li>BrandingThemeID: STRING</li><li>Contact: OBJECT, which is also a nested data structure.													<ul><li>AccountNumber: STRING</li><li>AccountsPayableTaxType: STRING</li><li>AccountsReceivableTaxType: STRING</li><li>Addresses: ARRAY, which is also a nested data structure.															<ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul></li><li>Attachments: ARRAY</li><li>Balances: OBJECT, which is also a nested data structure.															<ul><li>AccountsPayable: OBJECT, which is also a nested data structure.																	<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.																	<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul></li><li>BankAccountDetails: STRING</li><li>BatchPayments: OBJECT, which is also a nested data structure.															<ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul></li><li>BrandingTheme: OBJECT, which is also a nested data structure.															<ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DATE-TIME</li><li>Name: STRING</li><li>SortOrder: INTEGER</li></ul></li><li>ContactGroups: ARRAY, which is also a nested data structure.															<ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul></li><li>ContactID: STRING</li><li>ContactNumber: STRING</li><li>ContactPersons: ARRAY, which is also a nested data structure.															<ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul></li><li>ContactStatus: STRING</li><li>DefaultCurrency: STRING</li><li>Discount: NUMBER</li><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>HasAttachments: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>IsCustomer: BOOLEAN</li><li>IsSupplier: BOOLEAN</li><li>LastName: STRING</li><li>Name: STRING</li><li>PaymentTerms: OBJECT, which is also a nested data structure.															<ul><li>Bills: OBJECT, which is also a nested data structure.																	<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.																	<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul></li><li>Phones: ARRAY, which is also a nested data structure.															<ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul></li><li>PurchasesDefaultAccountCode: STRING</li><li>PurchasesTrackingCategories: ARRAY, which is also a nested data structure.															<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.																	<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SalesDefaultAccountCode: STRING</li><li>SalesTrackingCategories: ARRAY, which is also a nested data structure.															<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.																	<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SkypeUserName: STRING</li><li>TaxNumber: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingCategoryOption: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>ValidationErrors: ARRAY, which is also a nested data structure.															<ul><li>Message: STRING</li></ul></li><li>Website: STRING</li><li>XeroNetworkKey: STRING</li></ul></li><li>CurrencyCode: STRING</li><li>CurrencyRate: NUMBER</li><li>Date: DATE-TIME</li><li>DateString: DATE-TIME</li><li>DueDate: DATE-TIME</li><li>DueDateString: DATE-TIME</li><li>ExpectedPaymentDate: DATE-TIME</li><li>FullyPaidOnDate: DATE-TIME</li><li>HasAttachments: BOOLEAN</li><li>HasErrors: BOOLEAN</li><li>InvoiceID: STRING</li><li>InvoiceNumber: STRING</li><li>IsDiscounted: BOOLEAN</li><li>LineAmountTypes: STRING</li><li>LineItems: ARRAY, which is also a nested data structure.													<ul><li>AccountCode: STRING</li><li>Description: STRING</li><li>DiscountRate: NUMBER</li><li>ItemCode: STRING</li><li>LineAmount: NUMBER</li><li>LineItemID: STRING</li><li>Quantity: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.															<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.																	<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>UnitAmount: NUMBER</li></ul></li><li>PlannedPaymentDate: DATE-TIME</li><li>Reference: STRING</li><li>SentToContact: BOOLEAN</li><li>Status: STRING</li><li>SubTotal: NUMBER</li><li>Total: NUMBER</li><li>TotalDiscount: NUMBER</li><li>TotalTax: NUMBER</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>Url: STRING</li></ul></li><li>IsReconciled: BOOLEAN</li><li>Overpayment: ARRAY, which is also a nested data structure.											<ul><li>OverpaymentID: STRING</li></ul></li><li>PaymentID: STRING</li><li>PaymentType: STRING</li><li>Prepayments: ARRAY, which is also a nested data structure.											<ul><li>PrepaymentID: STRING</li></ul></li><li>Reference: STRING</li><li>Status: STRING</li><li>UpdatedDateUTC: DATE-TIME</li></ul> |
| **Receipts**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>Attachments: ARRAY</li><li>Contact: OBJECT, which is also a nested data structure.											<ul><li>AccountNumber: STRING</li><li>AccountsPayableTaxType: STRING</li><li>AccountsReceivableTaxType: STRING</li><li>Addresses: ARRAY, which is also a nested data structure.													<ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul></li><li>Attachments: ARRAY</li><li>Balances: OBJECT, which is also a nested data structure.													<ul><li>AccountsPayable: OBJECT, which is also a nested data structure.															<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.															<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul></li><li>BankAccountDetails: STRING</li><li>BatchPayments: OBJECT, which is also a nested data structure.													<ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul></li><li>BrandingTheme: OBJECT, which is also a nested data structure.													<ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DATE-TIME</li><li>Name: STRING</li><li>SortOrder: STRING</li></ul></li><li>ContactGroups: ARRAY, which is also a nested data structure.													<ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul></li><li>ContactID: STRING</li><li>ContactNumber: STRING</li><li>ContactPersons: ARRAY, which is also a nested data structure.													<ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul></li><li>ContactStatus: STRING</li><li>DefaultCurrency: STRING</li><li>Discount: NUMBER</li><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>HasAttachments: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>IsCustomer: BOOLEAN</li><li>IsSupplier: BOOLEAN</li><li>LastName: STRING</li><li>Name: STRING</li><li>PaymentTerms: OBJECT, which is also a nested data structure.													<ul><li>Bills: OBJECT, which is also a nested data structure.															<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.															<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul></li><li>Phones: ARRAY, which is also a nested data structure.													<ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul></li><li>PurchasesDefaultAccountCode: STRING</li><li>PurchasesTrackingCategories: ARRAY, which is also a nested data structure.													<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.															<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SalesDefaultAccountCode: STRING</li><li>SalesTrackingCategories: ARRAY, which is also a nested data structure.													<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.															<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SkypeUserName: STRING</li><li>TaxNumber: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingCategoryOption: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>ValidationErrors: ARRAY, which is also a nested data structure.													<ul><li>Message: STRING</li></ul></li><li>Website: STRING</li><li>XeroNetworkKey: STRING</li></ul></li><li>Date: DATE-TIME</li><li>HasAttachments: BOOLEAN</li><li>ID: STRING</li><li>LineAmountTypes: STRING</li><li>LineItems: ARRAY, which is also a nested data structure.											<ul><li>AccountCode: STRING</li><li>Description: STRING</li><li>DiscountRate: NUMBER</li><li>ItemCode: STRING</li><li>LineAmount: NUMBER</li><li>LineItemID: STRING</li><li>Quantity: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.													<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.															<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>UnitAmount: NUMBER</li></ul></li><li>ReceiptID: STRING</li><li>ReceiptNumber: INTEGER</li><li>Reference: STRING</li><li>Status: STRING</li><li>SubTotal: NUMBER</li><li>Total: NUMBER</li><li>TotalTax: NUMBER</li><li>UpdatedDateUTC: DATE-TIME</li><li>Url: STRING</li><li>User: OBJECT, which is also a nested data structure.											<ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IsSubscriber: BOOLEAN</li><li>LastName: STRING</li><li>OrganisationRole: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>UserID: STRING</li><li>ValidationErrors: ARRAY, which is also a nested data structure.													<ul><li>Message: STRING</li></ul></li></ul></li><li>ValidationErrors: ARRAY, which is also a nested data structure.											<ul><li>Message: STRING</li></ul></li></ul> |
| **ReportingDate**<br><br><br>DATE-TIME |
| **Status**<br><br><br>STRING |
| **Total**<br><br><br>NUMBER |
| **UpdatedDateUTC**<br><br><br>DATE-TIME |
| **User**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IsSubscriber: BOOLEAN</li><li>LastName: STRING</li><li>OrganisationRole: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>UserID: STRING</li><li>ValidationErrors: ARRAY, which is also a nested data structure.											<ul><li>Message: STRING</li></ul></li></ul> |

### invoices

The `invoices` table contains info about sales invoices, which are requests for payment for goods and services.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | InvoiceID |
| **Replication Key** | UpdatedDateUTC |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/invoices "Opens in new tab: Xero API method") |

invoices table foreign keys

| Join invoices with | on |
| --- | --- |
| [branding_themes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#branding-themes) | ```<br>invoices.BrandingThemeID = branding_themes.BrandingThemeID<br>``` |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#contacts) | ```<br>invoices.BrandingThemeID = contacts.BrandingTheme.BrandingThemeID<br>```<br><br>```<br>invoices.Contact.ContactID = contacts.ContactID<br>```<br><br>```<br>invoices.LineItems.Tracking.TrackingCategoryID = contacts.SalesTrackingCategories.TrackingCategoryID<br>```<br><br>```<br>invoices.LineItems.Tracking.TrackingCategoryID = contacts.PurchasesTrackingCategories.TrackingCategoryID<br>``` |
| [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#credit-notes) | ```<br>invoices.BrandingThemeID = credit_notes.BrandingThemeID<br>```<br><br>```<br>invoices.Contact.ContactID = credit_notes.Contact.ContactID<br>```<br><br>```<br>invoices.CreditNotes.CreditNoteID = credit_notes.CreditNoteID<br>```<br><br>```<br>invoices.CurrencyCode = credit_notes.CurrencyCode<br>```<br><br>```<br>invoices.LineItems.Tracking.TrackingCategoryID = credit_notes.LineItems.Tracking.TrackingCategoryID<br>``` |
| [purchase_orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#purchase-orders) | ```<br>invoices.BrandingThemeID = purchase_orders.BrandingThemeID<br>```<br><br>```<br>invoices.CurrencyCode = purchase_orders.CurrencyCode<br>```<br><br>```<br>invoices.LineItems.Tracking.TrackingCategoryID = purchase_orders.LineItems.Tracking.TrackingCategoryID<br>``` |
| [repeating_invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#repeating-invoices) | ```<br>invoices.BrandingThemeID = repeating_invoices.BrandingThemeID<br>```<br><br>```<br>invoices.Contact.ContactID = repeating_invoices.Contact.ContactID<br>```<br><br>```<br>invoices.CurrencyCode = repeating_invoices.CurrencyCode<br>```<br><br>```<br>invoices.LineItems.Tracking.TrackingCategoryID = repeating_invoices.LineItems.Tracking.TrackingCategoryID<br>``` |
| [linked_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#linked-transactions) | ```<br>invoices.Contact.ContactID = linked_transactions.ContactID<br>```<br><br>```<br>invoices.InvoiceID = linked_transactions.SourceTransactionID<br>```<br><br>```<br>invoices.InvoiceID = linked_transactions.TargetTransactionID<br>``` |
| [overpayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#overpayments) | ```<br>invoices.Contact.ContactID = overpayments.Contact.ContactID<br>```<br><br>```<br>invoices.InvoiceID = overpayments.Allocations.Invoice.InvoiceID<br>```<br><br>```<br>invoices.Overpayments.Overpayment.OverpaymentID = overpayments.OverpaymentID<br>```<br><br>```<br>invoices.Payments.PaymentID = overpayments.Payments.PaymentID<br>```<br><br>```<br>invoices.LineItems.Tracking.TrackingCategoryID = overpayments.LineItems.Tracking.TrackingCategoryID<br>``` |
| [prepayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#prepayments) | ```<br>invoices.Contact.ContactID = prepayments.Contact.ContactID<br>```<br><br>```<br>invoices.CurrencyCode = prepayments.CurrencyCode<br>```<br><br>```<br>invoices.InvoiceID = prepayments.Allocations.Invoice.InvoiceID<br>```<br><br>```<br>invoices.Prepayments.PrepaymentID = prepayments.PrepaymentID<br>```<br><br>```<br>invoices.LineItems.Tracking.TrackingCategoryID = prepayments.LineItems.Tracking.TrackingCategoryID<br>``` |
| [receipts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#receipts) | ```<br>invoices.Contact.ContactID = receipts.Contact.ContactID<br>```<br><br>```<br>invoices.LineItems.Tracking.TrackingCategoryID = receipts.LineItems.Tracking.TrackingCategoryID<br>``` |
| [accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#accounts) | ```<br>invoices.CurrencyCode = accounts.CurrencyCode<br>``` |
| [bank_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#bank-transactions) | ```<br>invoices.CurrencyCode = bank_transactions.CurrencyCode<br>```<br><br>```<br>invoices.Overpayments.Overpayment.OverpaymentID = bank_transactions.OverpaymentID<br>```<br><br>```<br>invoices.Prepayments.PrepaymentID = bank_transactions.PrepaymentID<br>```<br><br>```<br>invoices.InvoiceID = bank_transactions.BankTransactionID<br>``` |
| [currencies](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#currencies) | ```<br>invoices.CurrencyCode = currencies.Code<br>``` |
| [payments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#payments) | ```<br>invoices.InvoiceID = payments.Invoice.InvoiceID<br>```<br><br>```<br>invoices.Overpayments.Overpayment.OverpaymentID = payments.Overpayment.OverpaymentID<br>```<br><br>```<br>invoices.Payments.PaymentID = payments.PaymentID<br>```<br><br>```<br>invoices.Prepayments.PrepaymentID = payments.Prepayments.PrepaymentID<br>``` |
| [expense_claims](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#expense-claims) | ```<br>invoices.Payments.PaymentID = expense_claims.Payments.PaymentID<br>``` |
| [journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#journals) | ```<br>invoices.LineItems.Tracking.TrackingCategoryID = journals.JournalLines.TrackingCategories.TrackingCategoryID<br>``` |
| [manual_journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#manual-journals) | ```<br>invoices.LineItems.Tracking.TrackingCategoryID = manual_journals.JournalLines.Tracking.TrackingCategoryID<br>``` |
| [tracking_categories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#tracking-categories) | ```<br>invoices.LineItems.Tracking.TrackingCategoryID = tracking_categories.TrackingCategoryID<br>``` |

invoices table schema

| **AmountCredited**<br><br><br>NUMBER |
| --- |
| **AmountDue**<br><br><br>NUMBER |
| **AmountPaid**<br><br><br>NUMBER |
| **BrandingThemeID**<br><br><br>STRING |
| **Contact**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>AccountNumber: STRING</li><li>AccountsPayableTaxType: STRING</li><li>AccountsReceivableTaxType: STRING</li><li>Addresses: ARRAY, which is also a nested data structure.											<ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul></li><li>Attachments: ARRAY</li><li>Balances: OBJECT, which is also a nested data structure.											<ul><li>AccountsPayable: OBJECT, which is also a nested data structure.													<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.													<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul></li><li>BankAccountDetails: STRING</li><li>BatchPayments: OBJECT, which is also a nested data structure.											<ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul></li><li>BrandingTheme: OBJECT, which is also a nested data structure.											<ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DATE-TIME</li><li>Name: STRING</li><li>SortOrder: INTEGER</li></ul></li><li>ContactGroups: ARRAY, which is also a nested data structure.											<ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul></li><li>ContactID: STRING</li><li>ContactNumber: STRING</li><li>ContactPersons: ARRAY, which is also a nested data structure.											<ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul></li><li>ContactStatus: STRING</li><li>DefaultCurrency: STRING</li><li>Discount: NUMBER</li><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>HasAttachments: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>IsCustomer: BOOLEAN</li><li>IsSupplier: BOOLEAN</li><li>LastName: STRING</li><li>Name: STRING</li><li>PaymentTerms: OBJECT, which is also a nested data structure.											<ul><li>Bills: OBJECT, which is also a nested data structure.													<ul><li>Day: NUMBER</li><li>Type: NUMBER</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.													<ul><li>Day: NUMBER</li><li>Type: NUMBER</li></ul></li></ul></li><li>Phones: ARRAY, which is also a nested data structure.											<ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul></li><li>PurchasesDefaultAccountCode: STRING</li><li>PurchasesTrackingCategories: ARRAY, which is also a nested data structure.											<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.													<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SalesDefaultAccountCode: STRING</li><li>SalesTrackingCategories: ARRAY, which is also a nested data structure.											<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.													<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SkypeUserName: STRING</li><li>TaxNumber: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingCategoryOption: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>ValidationErrors: ARRAY, which is also a nested data structure.										<ul><li>Message: STRING</li></ul></li><li>Website: STRING</li><li>XeroNetworkKey: STRING</li></ul> |
| **CreditNotes**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>Allocations: ARRAY, which is also a nested data structure.											<ul><li>Amount: NUMBER</li><li>Date: DATE-TIME</li><li>Invoice: OBJECT, which is also a nested data structure.													<ul><li>AmountCredited: NUMBER</li><li>AmountDue: NUMBER</li><li>AmountPaid: NUMBER</li><li>BrandingThemeID: STRING</li><li>Contact: OBJECT, which is also a nested data structure.															<ul><li>AccountNumber: STRING</li><li>AccountsPayableTaxType: STRING</li><li>AccountsReceivableTaxType: STRING</li><li>Addresses: ARRAY, which is also a nested data structure.																	<ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul></li><li>Attachments: ARRAY</li><li>Balances: OBJECT, which is also a nested data structure.																	<ul><li>AccountsPayable: OBJECT, which is also a nested data structure.																			<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.																			<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul></li><li>BankAccountDetails: STRING</li><li>BatchPayments: OBJECT, which is also a nested data structure.																	<ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul></li><li>BrandingTheme: OBJECT, which is also a nested data structure.																	<ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DATE-TIME</li><li>Name: STRING</li><li>SortOrder: INTEGER </li></ul></li><li>ContactGroups: ARRAY, which is also a nested data structure.																	<ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul></li><li>ContactID: STRING</li><li>ContactNumber: STRING</li><li>ContactPersons: ARRAY, which is also a nested data structure.																	<ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul></li><li>ContactStatus: STRING</li><li>DefaultCurrency: STRING</li><li>Discount: NUMBER</li><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>HasAttachments: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>IsCustomer: BOOLEAN</li><li>IsSupplier: BOOLEAN</li><li>LastName: STRING</li><li>Name: STRING</li><li>PaymentTerms: OBJECT, which is also a nested data structure.																	<ul><li>Bills: OBJECT, which is also a nested data structure.																			<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.																			<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul></li><li>Phones: ARRAY, which is also a nested data structure.																	<ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul></li><li>PurchasesDefaultAccountCode: STRING</li><li>PurchasesTrackingCategories: ARRAY, which is also a nested data structure.																	<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.</li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SalesDefaultAccountCode: STRING</li><li>SalesTrackingCategories: ARRAY, which is also a nested data structure.																	<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.</li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SkypeUserName: STRING</li><li>TaxNumber: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingCategoryOption: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>ValidationErrors: ARRAY, which is also a nested data structure.																	<ul><li>Message: STRING</li></ul></li><li>Website: STRING</li><li>XeroNetworkKey: STRING</li></ul></li><li>CurrencyCode: STRING</li><li>CurrencyRate: NUMBER</li><li>Date: DATE-TIME</li><li>DateString: DATE-TIME</li><li>DueDate: DATE-TIME</li><li>DueDateString: DATE-TIME</li><li>ExpectedPaymentDate: DATE-TIME</li><li>FullyPaidOnDate: DATE-TIME</li><li>HasAttachments: BOOLEAN</li><li>HasErrors: BOOLEAN</li><li>InvoiceID: STRING</li><li>InvoiceNumber: STRING</li><li>IsDiscounted: BOOLEAN</li><li>LineAmountTypes: STRING</li><li>LineItems: ARRAY, which is also a nested data structure.															<ul><li>AccountCode: STRING</li><li>Description: STRING</li><li>DiscountRate: NUMBER</li><li>ItemCode: STRING</li><li>LineAmount: NUMBER</li><li>LineItemID: STRING</li><li>Quantity: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.																	<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.																			<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>UnitAmount: NUMBER</li></ul></li><li>PlannedPaymentDate: DATE-TIME</li><li>Reference: STRING</li><li>SentToContact: BOOLEAN</li><li>Status: STRING</li><li>SubTotal: NUMBER</li><li>Total: NUMBER</li><li>TotalDiscount: NUMBER</li><li>TotalTax: NUMBER</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>Url: STRING</li></ul></li></ul></li><li>AppliedAmount: NUMBER</li><li>BrandingThemeID: STRING</li><li>Contact: OBJECT, which is also a nested data structure.											<ul><li>AccountNumber: STRING</li><li>AccountsPayableTaxType: STRING</li><li>AccountsReceivableTaxType: STRING</li><li>Addresses: ARRAY, which is also a nested data structure.													<ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul></li><li>Attachments: ARRAY</li><li>Balances: OBJECT, which is also a nested data structure.													<ul><li>AccountsPayable: OBJECT, which is also a nested data structure.															<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.															<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul></li><li>BankAccountDetails: STRING</li><li>BatchPayments: OBJECT, which is also a nested data structure.													<ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul></li><li>BrandingTheme: OBJECT, which is also a nested data structure.													<ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DATE-TIME</li><li>Name: STRING</li><li>SortOrder: INTEGER</li></ul></li><li>ContactGroups: ARRAY, which is also a nested data structure.													<ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul></li><li>ContactID: STRING</li><li>ContactNumber: STRING</li><li>ContactPersons: ARRAY, which is also a nested data structure.													<ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul></li><li>ContactStatus: STRING</li><li>DefaultCurrency: STRING</li><li>Discount: NUMBER</li><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>HasAttachments: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>IsCustomer: BOOLEAN</li><li>IsSupplier: BOOLEAN</li><li>LastName: STRING</li><li>Name: STRING</li><li>PaymentTerms: OBJECT, which is also a nested data structure.													<ul><li>Bills: OBJECT, which is also a nested data structure.															<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.															<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul></li><li>Phones: ARRAY, which is also a nested data structure.																									<ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul></li><li>PurchasesDefaultAccountCode: STRING</li><li>PurchasesTrackingCategories: ARRAY, which is also a nested data structure.													<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.															<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SalesDefaultAccountCode: STRING</li><li>SalesTrackingCategories: ARRAY, which is also a nested data structure.													<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.															<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SkypeUserName: STRING</li><li>TaxNumber: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingCategoryOption: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>ValidationErrors: ARRAY, which is also a nested data structure.													<ul><li>Message: STRING</li></ul></li><li>Website: STRING</li><li>XeroNetworkKey: STRING</li></ul></li><li>CreditNoteID: STRING</li><li>CreditNoteNumber: STRING</li><li>CurrencyCode: STRING</li><li>CurrencyRate: NUMBER</li><li>Date: DATE-TIME</li><li>DateString: DATE-TIME</li><li>DueDateString: DATE-TIME</li><li>FullyPaidOnDate: DATE-TIME</li><li>HasAttachments: BOOLEAN</li><li>ID: STRING</li><li>LineAmountTypes: STRING</li><li>LineItems: ARRAY, which is also a nested data structure.											<ul><li>AccountCode: STRING</li><li>Description: STRING</li><li>DiscountRate: NUMBER</li><li>ItemCode: STRING</li><li>LineAmount: NUMBER</li><li>LineItemID: STRING</li><li>Quantity: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.													<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.															<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>UnitAmount: NUMBER</li></ul></li><li>Reference: STRING</li><li>RemainingCredit: NUMBER</li><li>SentToContact: BOOLEAN</li><li>Status: STRING</li><li>SubTotal: NUMBER</li><li>Total: NUMBER</li><li>TotalTax: NUMBER</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li></ul> |
| **CurrencyCode**<br><br><br>STRING |
| **CurrencyRate**<br><br><br>NUMBER |
| **Date**<br><br><br>DATE-TIME |
| **DateString**<br><br><br>DATE-TIME |
| **DueDate**<br><br><br>DATE-TIME |
| **DueDateString**<br><br><br>DATE-TIME |
| **ExpectedPaymentDate**<br><br><br>DATE-TIME |
| **ExpectedPaymentDateString**<br><br><br>DATE-TIME |
| **FullyPaidOnDate**<br><br><br>DATE-TIME |
| **HasAttachments**<br><br><br>BOOLEAN |
| **HasErrors**<br><br><br>BOOLEAN |
| **InvoiceID**<br><br><br>STRING |
| **InvoiceNumber**<br><br><br>STRING |
| **IsDiscounted**<br><br><br>BOOLEAN |
| **LineAmountTypes**<br><br><br>STRING |
| **LineItems**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>AccountCode: STRING</li><li>Description: STRING</li><li>DiscountRate: NUMBER</li><li>ItemCode: STRING</li><li>LineAmount: NUMBER</li><li>LineItemID: STRING</li><li>Quantity: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.											<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.								<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>UnitAmount: NUMBER</li></ul> |
| **Overpayments**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>Account: OBJECT, which is also a nested data structure.											<ul><li>AccountID: STRING</li><li>BankAccountNumber: STRING</li><li>BankAccountType: STRING</li><li>Class: STRING</li><li>Code: STRING</li><li>CurrencyCode: STRING</li><li>Description: STRING</li><li>EnablePaymentsToAccount: BOOLEAN</li><li>HasAttachments: BOOLEAN</li><li>Name: STRING</li><li>ReportingCode: STRING</li><li>ReportingCodeName: STRING</li><li>ShowInExpenseClaims: BOOLEAN</li><li>Status: STRING</li><li>SystemAccount: STRING</li><li>TaxType: STRING</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li></ul></li><li>Amount: NUMBER</li><li>BankAmount: NUMBER</li><li>BatchPaymentID: STRING</li><li>CreditNote: OBJECT, which is also a nested data structure.											<ul><li>CreditNoteNumber: STRING</li></ul></li><li>CurrencyRate: NUMBER</li><li>Date: DATE-TIME</li><li>HasAccount: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>Invoice: OBJECT, which is also a nested data structure.											<ul><li>AmountCredited: NUMBER</li><li>AmountDue: NUMBER</li><li>AmountPaid: NUMBER</li><li>BrandingThemeID: STRING</li><li>Contact: OBJECT, which is also a nested data structure.													<ul><li>AccountNumber: STRING</li><li>AccountsPayableTaxType: STRING</li><li>AccountsReceivableTaxType: STRING</li><li>Addresses: ARRAY, which is also a nested data structure.															<ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul></li><li>Attachments: ARRAY</li><li>Balances: OBJECT, which is also a nested data structure.															<ul><li>AccountsPayable: OBJECT, which is also a nested data structure.																	<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.																	<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul></li><li>BankAccountDetails: STRING</li><li>BatchPayments: OBJECT, which is also a nested data structure.															<ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul></li><li>BrandingTheme: OBJECT, which is also a nested data structure.															<ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DARE-TIME</li><li>Name: STRING</li><li>SortOrder: INTEGER</li></ul></li><li>ContactGroups: ARRAY, which is also a nested data structure.															<ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul></li><li>ContactID: STRING</li><li>ContactNumber: STRING</li><li>ContactPersons: ARRAY, which is also a nested data structure.															<ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul></li><li>ContactStatus: STRING</li><li>DefaultCurrency: STRING</li><li>Discount: NUMBER</li><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>HasAttachments: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>IsCustomer: BOOLEAN</li><li>IsSupplier: BOOLEAN</li><li>LastName: STRING</li><li>Name: STRING</li><li>PaymentTerms: OBJECT, which is also a nested data structure.															<ul><li>Bills: OBJECT, which is also a nested data structure.																	<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.																	<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul></li><li>Phones: ARRAY, which is also a nested data structure.															<ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul></li><li>PurchasesDefaultAccountCode: STRING</li><li>PurchasesTrackingCategories: ARRAY, which is also a nested data structure.															<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.																	<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SalesDefaultAccountCode: STRING</li><li>SalesTrackingCategories: ARRAY, which is also a nested data structure.															<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.																	<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SkypeUserName: STRING</li><li>TaxNumber: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingCategoryOption: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>ValidationErrors: ARRAY, which is also a nested data structure.															<ul><li>Message: STRING</li></ul></li><li>Website: STRING</li><li>XeroNetworkKey: STRING</li></ul></li><li>CurrencyCode: STRING</li><li>CurrencyRate: NUMBER</li><li>Date: DATE-TIME</li><li>DateString: DATE-TIME</li><li>DueDate: DATE-TIME</li><li>DueDateString: DATE-TIME</li><li>ExpectedPaymentDate: DATE-TIME</li><li>FullyPaidOnDate: DATE-TIME</li><li>HasAttachments: BOOLEAN</li><li>HasErrors: BOOLEAN</li><li>InvoiceID: STRING</li><li>InvoiceNumber: STRING</li><li>IsDiscounted: BOOLEAN</li><li>LineAmountTypes: STRING</li><li>LineItems: ARRAY, which is also a nested data structure.													<ul><li>AccountCode: STRING</li><li>Description: STRING</li><li>DiscountRate: NUMBER</li><li>ItemCode: STRING</li><li>LineAmount: NUMBER</li><li>LineItemID: STRING</li><li>Quantity: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.															<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.																	<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>UnitAmount: NUMBER</li></ul></li><li>PlannedPaymentDate: DATE-TIME</li><li>Reference: STRING</li><li>SentToContact: BOOLEAN</li><li>Status: STRING</li><li>SubTotal: NUMBER</li><li>Total: NUMBER</li><li>TotalDiscount: NUMBER</li><li>TotalTax: NUMBER</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>Url: STRING</li></ul></li><li>IsReconciled: BOOLEAN</li><li>Overpayment: ARRAY, which is also a nested data structure.											<ul><li>OverpaymentID: STRING</li></ul></li><li>PaymentID: STRING</li><li>PaymentType: STRING</li><li>Prepayments: ARRAY, which is also a nested data structure.											<ul><li>PrepaymentID: STRING</li></ul></li><li>Reference: STRING</li><li>Status: STRING</li><li>UpdatedDateUTC: DATE-TIME</li></ul> |
| **Payments**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>Account: OBJECT, which is also a nested data structure.											<ul><li>AccountID: STRING</li><li>BankAccountNumber: STRING</li><li>BankAccountType: STRING</li><li>Class: STRING</li><li>Code: STRING</li><li>CurrencyCode: STRING</li><li>Description: STRING</li><li>EnablePaymentsToAccount: BOOLEAN</li><li>HasAttachments: BOOLEAN</li><li>Name: STRING</li><li>ReportingCode: STRING</li><li>ReportingCodeName: STRING</li><li>ShowInExpenseClaims: BOOLEAN</li><li>Status: STRING</li><li>SystemAccount: STRING</li><li>TaxType: STRING</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li></ul></li><li>Amount: NUMBER</li><li>BankAmount: NUMBER</li><li>BatchPaymentID: STRING</li><li>CreditNote: OBJECT, which is also a nested data structure.											<ul><li>CreditNoteNumber: STRING</li></ul></li><li>CurrencyRate: NUMBER</li><li>Date: DATE-TIME</li><li>HasAccount: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>Invoice: OBJECT, which is also a nested data structure.											<ul><li>AmountCredited: NUMBER</li><li>AmountDue: NUMBER</li><li>AmountPaid: NUMBER</li><li>BrandingThemeID: STRING</li><li>Contact: OBJECT, which is also a nested data structure.													<ul><li>AccountNumber: STRING</li><li>AccountsPayableTaxType: STRING</li><li>AccountsReceivableTaxType: STRING</li><li>Addresses: ARRAY, which is also a nested data structure.															<ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul></li><li>Attachments: ARRAY</li><li>Balances: OBJECT, which is also a nested data structure.															<ul><li>AccountsPayable: OBJECT, which is also a nested data structure.																	<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.																	<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul></li><li>BankAccountDetails: STRING</li><li>BatchPayments: OBJECT, which is also a nested data structure.															<ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul></li><li>BrandingTheme: OBJECT, which is also a nested data structure.															<ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DATE-TIME</li><li>Name: STRING</li><li>SortOrder: INTEGER</li></ul></li><li>ContactGroups: ARRAY, which is also a nested data structure.															<ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul></li><li>ContactID: STRING</li><li>ContactNumber: STRING</li><li>ContactPersons: ARRAY, which is also a nested data structure.															<ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul></li><li>ContactStatus: STRING</li><li>DefaultCurrency: STRING</li><li>Discount: NUMBER</li><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>HasAttachments: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>IsCustomer: BOOLEAN</li><li>IsSupplier: BOOLEAN</li><li>LastName: STRING</li><li>Name: STRING</li><li>PaymentTerms: OBJECT, which is also a nested data structure.															<ul><li>Bills: OBJECT, which is also a nested data structure.																	<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.																	<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul></li><li>Phones: ARRAY, which is also a nested data structure.															<ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul></li><li>PurchasesDefaultAccountCode: STRING</li><li>PurchasesTrackingCategories: ARRAY, which is also a nested data structure.															<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.																	<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SalesDefaultAccountCode: STRING</li><li>SalesTrackingCategories: ARRAY, which is also a nested data structure.															<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.																	<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SkypeUserName: STRING</li><li>TaxNumber: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingCategoryOption: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>ValidationErrors: ARRAY, which is also a nested data structure.															<ul><li>Message: STRING</li></ul></li><li>Website: STRING</li><li>XeroNetworkKey: STRING</li></ul></li><li>CurrencyCode: STRING</li><li>CurrencyRate: NUMBER</li><li>Date: DATE-TIME</li><li>DateString: DATE-TIME</li><li>DueDate: DATE-TIME</li><li>DueDateString: DATE-TIME</li><li>ExpectedPaymentDate: DATE-TIME</li><li>FullyPaidOnDate: DATE-TIME</li><li>HasAttachments: BOOLEAN</li><li>HasErrors: BOOLEAN</li><li>InvoiceID: STRING</li><li>InvoiceNumber: STRING</li><li>IsDiscounted: BOOLEAN</li><li>LineAmountTypes: STRING</li><li>LineItems: ARRAY, which is also a nested data structure.													<ul><li>AccountCode: STRING</li><li>Description: STRING</li><li>DiscountRate: NUMBER</li><li>ItemCode: STRING</li><li>LineAmount: NUMBER</li><li>LineItemID: STRING</li><li>Quantity: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.															<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.																	<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>UnitAmount: NUMBER</li></ul></li><li>PlannedPaymentDate: DATE-TIME</li><li>Reference: STRING</li><li>SentToContact: BOOLEAN</li><li>Status: STRING</li><li>SubTotal: NUMBER</li><li>Total: NUMBER</li><li>TotalDiscount: NUMBER</li><li>TotalTax: NUMBER</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>Url: STRING</li></ul></li><li>IsReconciled: BOOLEAN</li><li>Overpayment: ARRAY, which is also a nested data structure.											<ul><li>OverpaymentID: STRING</li></ul></li><li>PaymentID: STRING</li><li>PaymentType: STRING</li><li>Prepayments: ARRAY, which is also a nested data structure.											<ul><li>PrepaymentID: STRING</li></ul></li><li>Reference: STRING</li><li>Status: STRING</li><li>UpdatedDateUTC: DATE-TIME</li></ul> |
| **PlannedPaymentDate**<br><br><br>DATE-TIME |
| **PlannedPaymentDateString**<br><br><br>DATE-TIME |
| **Prepayments**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>Allocations: ARRAY, which is also a nested data structure.											<ul><li>Amount: NUMBER</li><li>Date: DATE-TIME</li><li>Invoice: OBJECT, which is also a nested data structure.													<ul><li>AmountCredited: NUMBER</li><li>AmountDue: NUMBER</li><li>AmountPaid: NUMBER</li><li>BrandingThemeID: STRING</li><li>Contact: OBJECT, which is also a nested data structure.															<ul><li>AccountNumber: STRING</li><li>AccountsPayableTaxType: STRING</li><li>AccountsReceivableTaxType: STRING</li><li>Addresses: ARRAY, which is also a nested data structure.																	<ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul></li><li>Attachments: ARRAY</li><li>Balances: OBJECT, which is also a nested data structure.																	<ul><li>AccountsPayable: OBJECT, which is also a nested data structure.																			<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.																			<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul></li><li>BankAccountDetails: STRING</li><li>BatchPayments: OBJECT, which is also a nested data structure.																	<ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul></li><li>BrandingTheme: OBJECT, which is also a nested data structure.																	<ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DATE-TIME</li><li>Name: STRING</li><li>SortOrder: INTEGER</li></ul></li><li>ContactGroups: ARRAY, which is also a nested data structure.																	<ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul></li><li>ContactID: STRING</li><li>ContactNumber: STRING</li><li>ContactPersons: ARRAY, which is also a nested data structure.																	<ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul></li><li>ContactStatus: STRING</li><li>DefaultCurrency: STRING</li><li>Discount: NUMBER</li><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>HasAttachments: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>IsCustomer: BOOLEAN</li><li>IsSupplier: BOOLEAN</li><li>LastName: STRING</li><li>Name: STRING</li><li>PaymentTerms: OBJECT, which is also a nested data structure.																	<ul><li>Bills: OBJECT, which is also a nested data structure.																			<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.																			<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul></li><li>Phones: ARRAY, which is also a nested data structure.																	<ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul></li><li>PurchasesDefaultAccountCode: STRING</li><li>PurchasesTrackingCategories: ARRAY, which is also a nested data structure.																	<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.																			<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SalesDefaultAccountCode: STRING</li><li>SalesTrackingCategories: ARRAY, which is also a nested data structure.																	<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.																			<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SkypeUserName: STRING</li><li>TaxNumber: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingCategoryOption: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>ValidationErrors: ARRAY, which is also a nested data structure.																	<ul><li>Message: STRING</li></ul></li><li>Website: STRING</li><li>XeroNetworkKey: STRING</li></ul></li><li>CurrencyCode: STRING</li><li>CurrencyRate: NUMBER</li><li>Date: DATE-TIME</li><li>DateString: DATE-TIME</li><li>DueDate: DATE-TIME</li><li>DueDateString: DATE-TIME</li><li>ExpectedPaymentDate: DATE-TIME</li><li>FullyPaidOnDate: DATE-TIME</li><li>HasAttachments: BOOLEAN</li><li>HasErrors: BOOLEAN</li><li>InvoiceID: STRING</li><li>InvoiceNumber: STRING</li><li>IsDiscounted: BOOLEAN</li><li>LineAmountTypes: STRING</li><li>LineItems: ARRAY, which is also a nested data structure.															<ul><li>AccountCode: STRING</li><li>Description: STRING</li><li>DiscountRate: NUMBER</li><li>ItemCode: STRING</li><li>LineAmount: NUMBER</li><li>LineItemID: STRING</li><li>Quantity: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.																	<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.																			<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>UnitAmount: NUMBER</li></ul></li><li>PlannedPaymentDate: DATE-TIME</li><li>Reference: STRING</li><li>SentToContact: BOOLEAN</li><li>Status: STRING</li><li>SubTotal: NUMBER</li><li>Total: NUMBER</li><li>TotalDiscount: NUMBER</li><li>TotalTax: NUMBER</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>Url: STRING</li></ul></li></ul></li><li>AppliedAmount: NUMBER</li><li>Contact: OBJECT, which is also a nested data structure.											<ul><li>AccountNumber: STRING</li><li>AccountsPayableTaxType: STRING</li><li>AccountsReceivableTaxType: STRING</li><li>Addresses: ARRAY, which is also a nested data structure.													<ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul></li><li>Attachments: ARRAY</li><li>Balances: OBJECT, which is also a nested data structure.													<ul><li>AccountsPayable: OBJECT, which is also a nested data structure.															<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.															<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul></li><li>BankAccountDetails: STRING</li><li>BatchPayments: OBJECT, which is also a nested data structure.													<ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul></li><li>BrandingTheme: OBJECT, which is also a nested data structure.													<ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DATE-TIME</li><li>Name: STRING</li><li>SortOrder: INTEGER</li></ul></li><li>ContactGroups: ARRAY, which is also a nested data structure.													<ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul></li><li>ContactID: STRING</li><li>ContactNumber: STRING</li><li>ContactPersons: ARRAY, which is also a nested data structure.													<ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul></li><li>ContactStatus: STRING</li><li>DefaultCurrency: STRING</li><li>Discount: NUMBER</li><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>HasAttachments: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>IsCustomer: BOOLEAN</li><li>IsSupplier: BOOLEAN</li><li>LastName: STRING</li><li>Name: STRING</li><li>PaymentTerms: OBJECT, which is also a nested data structure.													<ul><li>Bills: OBJECT, which is also a nested data structure.															<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.															<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul></li><li>Phones: ARRAY, which is also a nested data structure.													<ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul></li><li>PurchasesDefaultAccountCode: STRING</li><li>PurchasesTrackingCategories: ARRAY, which is also a nested data structure.													<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.															<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SalesDefaultAccountCode: STRING</li><li>SalesTrackingCategories: ARRAY, which is also a nested data structure.													<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.															<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SkypeUserName: STRING</li><li>TaxNumber: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingCategoryOption: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>ValidationErrors: ARRAY, which is also a nested data structure.													<ul><li>Message: STRING</li></ul></li><li>Website: STRING</li><li>XeroNetworkKey: STRING</li></ul></li><li>CurrencyCode: STRING</li><li>CurrencyRate: NUMBER</li><li>Date: DATE-TIME</li><li>DateString: DATE-TIME</li><li>HasAttachments: BOOLEAN</li><li>ID: STRING</li><li>LineAmountTypes: STRING</li><li>LineItems: ARRAY, which is also a nested data structure.											<ul><li>AccountCode: STRING</li><li>Description: STRING</li><li>DiscountRate: NUMBER</li><li>ItemCode: STRING</li><li>LineAmount: NUMBER</li><li>LineItemID: STRING</li><li>Quantity: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.													<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.															<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>UnitAmount: NUMBER</li></ul></li><li>Payments: ARRAY, which is also a nested data structure.											<ul><li>Account: OBJECT, which is also a nested data structure.													<ul><li>AccountID: STRING</li><li>BankAccountNumber: STRING</li><li>BankAccountType: STRING</li><li>Class: STRING</li><li>Code: STRING</li><li>CurrencyCode: STRING</li><li>Description: STRING</li><li>EnablePaymentsToAccount: BOOLEAN</li><li>HasAttachments: BOOLEAN</li><li>Name: STRING</li><li>ReportingCode: STRING</li><li>ReportingCodeName: STRING</li><li>ShowInExpenseClaims: BOOLEAN</li><li>Status: STRING</li><li>SystemAccount: STRING</li><li>TaxType: STRING</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li></ul></li><li>Amount: NUMBER</li><li>BankAmount: NUMBER</li><li>BatchPaymentID: STRING</li><li>CreditNote: OBJECT, which is also a nested data structure.													<ul><li>CreditNoteNumber: STRING</li></ul></li><li>CurrencyRate: NUMBER</li><li>Date: DATE-TIME</li><li>HasAccount: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>Invoice: OBJECT, which is also a nested data structure.													<ul><li>AmountCredited: NUMBER</li><li>AmountDue: NUMBER</li><li>AmountPaid: NUMBER</li><li>BrandingThemeID: STRING</li><li>Contact: OBJECT, which is also a nested data structure.																<ul><li>AccountNumber: STRING</li><li>AccountsPayableTaxType: STRING</li><li>AccountsReceivableTaxType: STRING</li><li>Addresses: ARRAY, which is also a nested data structure.																		<ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul></li><li>Attachments: ARRAY</li><li>Balances: OBJECT, which is also a nested data structure.																		<ul><li>AccountsPayable: OBJECT, which is also a nested data structure.																				<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.																				<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul></li><li>BankAccountDetails: STRING</li><li>BatchPayments: OBJECT, which is also a nested data structure.																		<ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul></li><li>BrandingTheme: OBJECT, which is also a nested data structure.																		<ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DATE-TIME</li><li>Name: STRING</li><li>SortOrder: INTEGER</li></ul></li><li>ContactGroups: ARRAY, which is also a nested data structure.																		<ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul></li><li>ContactID: STRING</li><li>ContactNumber: STRING</li><li>ContactPersons: ARRAY, which is also a nested data structure.																		<ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul></li><li>ContactStatus: STRING</li><li>DefaultCurrency: STRING</li><li>Discount: NUMBER</li><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>HasAttachments: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>IsCustomer: BOOLEAN</li><li>IsSupplier: BOOLEAN</li><li>LastName: STRING</li><li>Name: STRING</li><li>PaymentTerms: OBJECT, which is also a nested data structure.																		<ul><li>Bills: OBJECT, which is also a nested data structure.																				<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.																				<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul></li><li>Phones: ARRAY, which is also a nested data structure.																		<ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul></li><li>PurchasesDefaultAccountCode: STRING</li><li>PurchasesTrackingCategories: ARRAY, which is also a nested data structure.																		<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.																				<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SalesDefaultAccountCode: STRING</li><li>SalesTrackingCategories: ARRAY, which is also a nested data structure.																		<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.																				<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SkypeUserName: STRING</li><li>TaxNumber: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingCategoryOption: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>ValidationErrors: ARRAY, which is also a nested data structure.																		<ul><li>Message: STRING</li></ul></li><li>Website: STRING</li><li>XeroNetworkKey: STRING</li></ul></li><li>CurrencyCode: STRING</li><li>CurrencyRate: NUMBER</li><li>Date: DATE-TIME</li><li>DateString: DATE-TIME</li><li>DueDate: DATE-TIME</li><li>DueDateString: DATE-TIME</li><li>ExpectedPaymentDate: DATE-TIME</li><li>FullyPaidOnDate: DATE-TIME</li><li>HasAttachments: BOOLEAN</li><li>HasErrors: BOOLEAN</li><li>InvoiceID: STRING</li><li>InvoiceNumber: STRING</li><li>IsDiscounted: BOOLEAN</li><li>LineAmountTypes: STRING</li><li>LineItems: ARRAY, which is also a nested data structure.																<ul><li>AccountCode: STRING</li><li>Description: STRING</li><li>DiscountRate: NUMBER</li><li>ItemCode: STRING</li><li>LineAmount: NUMBER</li><li>LineItemID: STRING</li><li>Quantity: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.																		<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.																				<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>UnitAmount: NUMBER</li></ul></li><li>PlannedPaymentDate: DATE-TIME</li><li>Reference: STRING</li><li>SentToContact: BOOLEAN</li><li>Status: STRING</li><li>SubTotal: NUMBER</li><li>Total: NUMBER</li><li>TotalDiscount: NUMBER</li><li>TotalTax: NUMBER</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>Url: STRING</li></ul></li><li>IsReconciled: BOOLEAN</li><li>Overpayment: ARRAY, which is also a nested data structure.													<ul><li>OverpaymentID: STRING</li></ul></li><li>PaymentID: STRING</li><li>PaymentType: STRING</li><li>Prepayments: ARRAY, which is also a nested data structure.													<ul><li>PrepaymentID: STRING</li></ul></li><li>Reference: STRING</li><li>Status: STRING</li><li>UpdatedDateUTC: DATE-TIME</li></ul></li><li>PrepaymentID: STRING</li><li>Reference: STRING</li><li>RemainingCredit: NUMBER</li><li>Status: STRING</li><li>SubTotal: NUMBER</li><li>Total: NUMBER</li><li>TotalTax: NUMBER</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li></ul> |
| **Reference**<br><br><br>STRING |
| **SentToContact**<br><br><br>BOOLEAN |
| **Status**<br><br><br>STRING |
| **SubTotal**<br><br><br>NUMBER |
| **Total**<br><br><br>NUMBER |
| **TotalDiscount**<br><br><br>NUMBER |
| **TotalTax**<br><br><br>NUMBER |
| **Type**<br><br><br>STRING |
| **UpdatedDateUTC**<br><br><br>DATE-TIME |
| **Url**<br><br><br>STRING |

### items

The `items` table contains info about the [products and services you buy and sell](https://help.xero.com/us/Inventory).

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | ItemID |
| **Replication Key** | UpdatedDateUTC |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/items "Opens in new tab: Xero API method") |

items table schema

| **Code**<br><br><br>STRING |
| --- |
| **Description**<br><br><br>STRING |
| **InventoryAssetAccountCode**<br><br><br>STRING |
| **IsPurchased**<br><br><br>BOOLEAN |
| **IsSold**<br><br><br>BOOLEAN |
| **IsTrackedAsInventory**<br><br><br>BOOLEAN |
| **ItemID**<br><br><br>STRING |
| **Name**<br><br><br>STRING |
| **PurchaseDescription**<br><br><br>STRING |
| **PurchaseDetails**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>AccountCode: STRING</li><li>COGSAccountCode: STRING</li><li>TaxType: STRING</li><li>UnitPrice: NUMBER</li></ul> |
| **QuantityOnHand**<br><br><br>NUMBER |
| **SalesDetails**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>AccountCode: STRING</li><li>TaxType: STRING</li><li>UnitPrice: NUMBER</li></ul> |
| **TotalCostPool**<br><br><br>NUMBER |
| **UpdatedDateUTC**<br><br><br>DATE-TIME |

### journals

The `journals` table contains info about journal entries.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | JournalID |
| **Replication Key** | JournalNumber |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/journals "Opens in new tab: Xero API method") |

journals table foreign keys

| Join journals with | on |
| --- | --- |
| [accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#accounts) | ```<br>journals.JournalLines.AccountID = accounts.AccountID<br>``` |
| [bank_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#bank-transactions) | ```<br>journals.JournalLines.AccountID = bank_transactions.BankAccount.AccountID<br>``` |
| [bank_transfers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#bank-transfers) | ```<br>journals.JournalLines.AccountID = bank_transfers.FromBankAccount.AccountID<br>```<br><br>```<br>journals.JournalLines.AccountID = bank_transfers.ToBankAccount.AccountID<br>``` |
| [payments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#payments) | ```<br>journals.JournalLines.AccountID = payments.Account.AccountID<br>``` |
| [tax_rates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#tax-rates) | ```<br>journals.JournalLines.TaxName = tax_rates.Name<br>``` |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#contacts) | ```<br>journals.JournalLines.TrackingCategories.TrackingCategoryID = contacts.SalesTrackingCategories.TrackingCategoryID<br>```<br><br>```<br>journals.JournalLines.TrackingCategories.TrackingCategoryID = contacts.PurchasesTrackingCategories.TrackingCategoryID<br>``` |
| [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#credit-notes) | ```<br>journals.JournalLines.TrackingCategories.TrackingCategoryID = credit_notes.LineItems.Tracking.TrackingCategoryID<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#invoices) | ```<br>journals.JournalLines.TrackingCategories.TrackingCategoryID = invoices.LineItems.Tracking.TrackingCategoryID<br>``` |
| [manual_journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#manual-journals) | ```<br>journals.JournalLines.TrackingCategories.TrackingCategoryID = manual_journals.JournalLines.Tracking.TrackingCategoryID<br>``` |
| [overpayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#overpayments) | ```<br>journals.JournalLines.TrackingCategories.TrackingCategoryID = overpayments.LineItems.Tracking.TrackingCategoryID<br>``` |
| [prepayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#prepayments) | ```<br>journals.JournalLines.TrackingCategories.TrackingCategoryID = prepayments.LineItems.Tracking.TrackingCategoryID<br>``` |
| [purchase_orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#purchase-orders) | ```<br>journals.JournalLines.TrackingCategories.TrackingCategoryID = purchase_orders.LineItems.Tracking.TrackingCategoryID<br>``` |
| [receipts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#receipts) | ```<br>journals.JournalLines.TrackingCategories.TrackingCategoryID = receipts.LineItems.Tracking.TrackingCategoryID<br>``` |
| [repeating_invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#repeating-invoices) | ```<br>journals.JournalLines.TrackingCategories.TrackingCategoryID = repeating_invoices.LineItems.Tracking.TrackingCategoryID<br>``` |
| [tracking_categories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#tracking-categories) | ```<br>journals.JournalLines.TrackingCategories.TrackingCategoryID = tracking_categories.TrackingCategoryID<br>``` |

journals table schema

| **CreatedDateUTC**<br><br><br>DATE-TIME |
| --- |
| **JournalDate**<br><br><br>DATE-TIME |
| **JournalID**<br><br><br>STRING |
| **JournalLines**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>AccountCode: STRING</li><li>AccountID: STRING</li><li>AccountName: STRING</li><li>AccountType: STRING</li><li>Description: STRING</li><li>GrossAmount: NUMBER</li><li>JournalLineID: STRING</li><li>NetAmount: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxName: STRING</li><li>TaxType: STRING</li><li>TrackingCategories: ARRAY, which is also a nested data structure.<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li></ul> |
| **JournalNumber**<br><br><br>INTEGER |
| **Reference**<br><br><br>STRING |
| **SourceID**<br><br><br>STRING |
| **SourceType**<br><br><br>STRING |

### linked\_transactions

The `linked_transactions` table contains info about linked transactions. Linked transactions are transactions where line items from a purchase transaction to a customer are linked to a sales transaction.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | LinkedTransactionID |
| **Replication Key** | UpdatedDateUTC |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/linked-transactions "Opens in new tab: Xero API method") |

linked\_transactions table foreign keys

| Join linked\_transactions with | on |
| --- | --- |
| [bank_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#bank-transactions) | ```<br>linked_transactions.SourceTransactionID = bank_transactions.BankTransactionID<br>``` |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#contacts) | ```<br>linked_transactions.ContactID = contacts.ContactID<br>``` |
| [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#credit-notes) | ```<br>linked_transactions.ContactID = credit_notes.Contact.ContactID<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#invoices) | ```<br>linked_transactions.ContactID = invoices.Contact.ContactID<br>```<br><br>```<br>linked_transactions.SourceTransactionID = invoices.InvoiceID<br>```<br><br>```<br>linked_transactions.TargetTransactionID = invoices.InvoiceID<br>``` |
| [overpayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#overpayments) | ```<br>linked_transactions.ContactID = overpayments.Contact.ContactID<br>```<br><br>```<br>linked_transactions.SourceTransactionID = overpayments.Allocations.Invoice.InvoiceID<br>```<br><br>```<br>linked_transactions.TargetTransactionID = overpayments.Allocations.Invoice.InvoiceID<br>``` |
| [prepayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#prepayments) | ```<br>linked_transactions.ContactID = prepayments.Contact.ContactID<br>```<br><br>```<br>linked_transactions.SourceTransactionID = prepayments.Allocations.Invoice.InvoiceID<br>```<br><br>```<br>linked_transactions.TargetTransactionID = prepayments.Allocations.Invoice.InvoiceID<br>``` |
| [receipts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#receipts) | ```<br>linked_transactions.ContactID = receipts.Contact.ContactID<br>``` |
| [repeating_invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#repeating-invoices) | ```<br>linked_transactions.ContactID = repeating_invoices.Contact.ContactID<br>``` |
| [payments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#payments) | ```<br>linked_transactions.SourceTransactionID = payments.Invoice.InvoiceID<br>```<br><br>```<br>linked_transactions.TargetTransactionID = payments.Invoice.InvoiceID<br>``` |

linked\_transactions table schema

| **ContactID**<br><br><br>STRING |
| --- |
| **LinkedTransactionID**<br><br><br>STRING |
| **SourceLineItemID**<br><br><br>STRING |
| **SourceTransactionID**<br><br><br>STRING |
| **SourceTransactionTypeCode**<br><br><br>STRING |
| **Status**<br><br><br>STRING |
| **TargetLineItemID**<br><br><br>STRING |
| **TargetTransactionID**<br><br><br>STRING |
| **Type**<br><br><br>STRING |
| **UpdatedDateUTC**<br><br><br>DATE-TIME |

### manual\_journals

The `manual_journals` table contains info about manual journals, which are used by accountants or bookkeepers to work directly with a general ledger. For example: To record accrued expenses or completed work that wasn’t invoiced.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | ManualJournalID |
| **Replication Key** | UpdatedDateUTC |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/manual-journals "Opens in new tab: Xero API method") |

manual\_journals table foreign keys

| Join manual\_journals with | on |
| --- | --- |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#contacts) | ```<br>manual_journals.JournalLines.Tracking.TrackingCategoryID = contacts.SalesTrackingCategories.TrackingCategoryID<br>```<br><br>```<br>manual_journals.JournalLines.Tracking.TrackingCategoryID = contacts.PurchasesTrackingCategories.TrackingCategoryID<br>``` |
| [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#credit-notes) | ```<br>manual_journals.JournalLines.Tracking.TrackingCategoryID = credit_notes.LineItems.Tracking.TrackingCategoryID<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#invoices) | ```<br>manual_journals.JournalLines.Tracking.TrackingCategoryID = invoices.LineItems.Tracking.TrackingCategoryID<br>``` |
| [journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#journals) | ```<br>manual_journals.JournalLines.Tracking.TrackingCategoryID = journals.JournalLines.TrackingCategories.TrackingCategoryID<br>``` |
| [overpayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#overpayments) | ```<br>manual_journals.JournalLines.Tracking.TrackingCategoryID = overpayments.LineItems.Tracking.TrackingCategoryID<br>``` |
| [prepayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#prepayments) | ```<br>manual_journals.JournalLines.Tracking.TrackingCategoryID = prepayments.LineItems.Tracking.TrackingCategoryID<br>``` |
| [purchase_orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#purchase-orders) | ```<br>manual_journals.JournalLines.Tracking.TrackingCategoryID = purchase_orders.LineItems.Tracking.TrackingCategoryID<br>``` |
| [receipts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#receipts) | ```<br>manual_journals.JournalLines.Tracking.TrackingCategoryID = receipts.LineItems.Tracking.TrackingCategoryID<br>``` |
| [repeating_invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#repeating-invoices) | ```<br>manual_journals.JournalLines.Tracking.TrackingCategoryID = repeating_invoices.LineItems.Tracking.TrackingCategoryID<br>``` |
| [tracking_categories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#tracking-categories) | ```<br>manual_journals.JournalLines.Tracking.TrackingCategoryID = tracking_categories.TrackingCategoryID<br>``` |

manual\_journals table schema

| **Date**<br><br><br>DATE-TIME |
| --- |
| **HasAttachments**<br><br><br>BOOLEAN |
| **JournalLines**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>AccountCode: STRING</li><li>AccountID: STRING</li><li>Description: STRING</li><li>IsBlank: BOOLEAN</li><li>LineAmount: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li></ul> |
| **LineAmountTypes**<br><br><br>STRING |
| **ManualJournalID**<br><br><br>STRING |
| **Narration**<br><br><br>STRING |
| **ShowOnCashBasisReports**<br><br><br>BOOLEAN |
| **Status**<br><br><br>STRING |
| **UpdatedDateUTC**<br><br><br>DATE-TIME |
| **Url**<br><br><br>STRING |

### organisations

The `organisations` table contains info about the organisations in your Xero account.

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | OrganisationID |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/organisation "Opens in new tab: Xero API method") |

organisations table schema

| **APIKey**<br><br><br>STRING |
| --- |
| **Addresses**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul> |
| **BaseCurrency**<br><br><br>STRING |
| **CountryCode**<br><br><br>STRING |
| **CreatedDateUTC**<br><br><br>DATE-TIME |
| **DefaultPurchasesTax**<br><br><br>STRING |
| **DefaultSalesTax**<br><br><br>STRING |
| **EndOfYearLockDate**<br><br><br>DATE-TIME |
| **ExternalLinks**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>LinkType: STRING</li><li>Url: STRING</li></ul> |
| **FinancialYearEndDay**<br><br><br>INTEGER |
| **FinancialYearEndMonth**<br><br><br>INTEGER |
| **IsDemoCompany**<br><br><br>BOOLEAN |
| **LegalName**<br><br><br>STRING |
| **LineOfBusiness**<br><br><br>STRING |
| **Name**<br><br><br>STRING |
| **OrganisationEntityType**<br><br><br>STRING |
| **OrganisationID**<br><br><br>STRING |
| **OrganisationStatus**<br><br><br>STRING |
| **OrganisationType**<br><br><br>STRING |
| **PaymentTerms**<br><br><br>OBJECT<br><br><ul><li>Bills: OBJECT, which is also a nested data structure.    <ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul> |
| **PaysTax**<br><br><br>BOOLEAN |
| **PeriodLockDate**<br><br><br>DATE-TIME |
| **Phones**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul> |
| **RegistrationNumber**<br><br><br>STRING |
| **SalesTaxBasis**<br><br><br>STRING |
| **SalesTaxPeriod**<br><br><br>STRING |
| **ShortCode**<br><br><br>STRING |
| **TaxNumber**<br><br><br>STRING |
| **Timezone**<br><br><br>STRING |
| **Version**<br><br><br>STRING |

### overpayments

The `overpayments` table contains info about overpayments, which are transactions where a customer pays too much or you mistakenly overpay a supplier.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | OverpaymentID |
| **Replication Key** | UpdatedDateUTC |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/overpayments "Opens in new tab: Xero API method") |

overpayments table foreign keys

| Join overpayments with | on |
| --- | --- |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#contacts) | ```<br>overpayments.Contact.ContactID = contacts.ContactID<br>```<br><br>```<br>overpayments.LineItems.Tracking.TrackingCategoryID = contacts.SalesTrackingCategories.TrackingCategoryID<br>```<br><br>```<br>overpayments.LineItems.Tracking.TrackingCategoryID = contacts.PurchasesTrackingCategories.TrackingCategoryID<br>``` |
| [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#credit-notes) | ```<br>overpayments.Contact.ContactID = credit_notes.Contact.ContactID<br>```<br><br>```<br>overpayments.LineItems.Tracking.TrackingCategoryID = credit_notes.LineItems.Tracking.TrackingCategoryID<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#invoices) | ```<br>overpayments.Contact.ContactID = invoices.Contact.ContactID<br>```<br><br>```<br>overpayments.Allocations.Invoice.InvoiceID = invoices.InvoiceID<br>```<br><br>```<br>overpayments.OverpaymentID = invoices.Overpayments.Overpayment.OverpaymentID<br>```<br><br>```<br>overpayments.Payments.PaymentID = invoices.Payments.PaymentID<br>```<br><br>```<br>overpayments.LineItems.Tracking.TrackingCategoryID = invoices.LineItems.Tracking.TrackingCategoryID<br>``` |
| [linked_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#linked-transactions) | ```<br>overpayments.Contact.ContactID = linked_transactions.ContactID<br>```<br><br>```<br>overpayments.Allocations.Invoice.InvoiceID = linked_transactions.SourceTransactionID<br>```<br><br>```<br>overpayments.Allocations.Invoice.InvoiceID = linked_transactions.TargetTransactionID<br>``` |
| [prepayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#prepayments) | ```<br>overpayments.Contact.ContactID = prepayments.Contact.ContactID<br>```<br><br>```<br>overpayments.Allocations.Invoice.InvoiceID = prepayments.Allocations.Invoice.InvoiceID<br>```<br><br>```<br>overpayments.LineItems.Tracking.TrackingCategoryID = prepayments.LineItems.Tracking.TrackingCategoryID<br>``` |
| [receipts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#receipts) | ```<br>overpayments.Contact.ContactID = receipts.Contact.ContactID<br>```<br><br>```<br>overpayments.LineItems.Tracking.TrackingCategoryID = receipts.LineItems.Tracking.TrackingCategoryID<br>``` |
| [repeating_invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#repeating-invoices) | ```<br>overpayments.Contact.ContactID = repeating_invoices.Contact.ContactID<br>```<br><br>```<br>overpayments.LineItems.Tracking.TrackingCategoryID = repeating_invoices.LineItems.Tracking.TrackingCategoryID<br>``` |
| [payments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#payments) | ```<br>overpayments.Allocations.Invoice.InvoiceID = payments.Invoice.InvoiceID<br>```<br><br>```<br>overpayments.OverpaymentID = payments.Overpayment.OverpaymentID<br>```<br><br>```<br>overpayments.Payments.PaymentID = payments.PaymentID<br>``` |
| [bank_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#bank-transactions) | ```<br>overpayments.OverpaymentID = bank_transactions.OverpaymentID<br>``` |
| [expense_claims](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#expense-claims) | ```<br>overpayments.Payments.PaymentID = expense_claims.Payments.PaymentID<br>``` |
| [journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#journals) | ```<br>overpayments.LineItems.Tracking.TrackingCategoryID = journals.JournalLines.TrackingCategories.TrackingCategoryID<br>``` |
| [manual_journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#manual-journals) | ```<br>overpayments.LineItems.Tracking.TrackingCategoryID = manual_journals.JournalLines.Tracking.TrackingCategoryID<br>``` |
| [purchase_orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#purchase-orders) | ```<br>overpayments.LineItems.Tracking.TrackingCategoryID = purchase_orders.LineItems.Tracking.TrackingCategoryID<br>``` |
| [tracking_categories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#tracking-categories) | ```<br>overpayments.LineItems.Tracking.TrackingCategoryID = tracking_categories.TrackingCategoryID<br>``` |

overpayments table schema

| **Allocations**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>Amount: NUMBER</li><li>Date: DATE-TIME</li><li>Invoice: OBJECT, which is also a nested data structure.                                            <ul><li>AmountCredited: NUMBER</li><li>AmountDue: NUMBER</li><li>AmountPaid: NUMBER</li><li>BrandingThemeID: STRING</li><li>Contact: OBJECT, which is also a nested data structure.                                                    <ul><li>AccountNumber: STRING</li><li>AccountsPayableTaxType: STRING</li><li>AccountsReceivableTaxType: STRING</li><li>Addresses: ARRAY, which is also a nested data structure.                                                            <ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul></li><li>Attachments: ARRAY</li><li>Balances: OBJECT, which is also a nested data structure.                                                            <ul><li>AccountsPayable: OBJECT, which is also a nested data structure.                                                                    <ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.                                                                    <ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul></li><li>BankAccountDetails: STRING</li><li>BatchPayments: OBJECT, which is also a nested data structure.                                                            <ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul></li><li>BrandingTheme: OBJECT, which is also a nested data structure.                                                            <ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DARE-TIME</li><li>Name: STRING</li><li>SortOrder: INTEGER</li></ul></li><li>ContactGroups: ARRAY, which is also a nested data structure.                                                            <ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul></li><li>ContactID: STRING</li><li>ContactNumber: STRING</li><li>ContactPersons: ARRAY, which is also a nested data structure.                                                            <ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul></li><li>ContactStatus: STRING</li><li>DefaultCurrency: STRING</li><li>Discount: NUMBER</li><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>HasAttachments: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>IsCustomer: BOOLEAN</li><li>IsSupplier: BOOLEAN</li><li>LastName: STRING</li><li>Name: STRING</li><li>PaymentTerms: OBJECT, which is also a nested data structure.                                                            <ul><li>Bills: OBJECT, which is also a nested data structure.                                                                    <ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.                                                                    <ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul></li><li>Phones: ARRAY, which is also a nested data structure.                                                            <ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul></li><li>PurchasesDefaultAccountCode: STRING</li><li>PurchasesTrackingCategories: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SalesDefaultAccountCode: STRING</li><li>SalesTrackingCategories: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SkypeUserName: STRING</li><li>TaxNumber: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingCategoryOption: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>ValidationErrors: ARRAY, which is also a nested data structure.                                                            <ul><li>Message: STRING</li></ul></li><li>Website: STRING</li><li>XeroNetworkKey: STRING</li></ul></li><li>CurrencyCode: STRING</li><li>CurrencyRate: NUMBER</li><li>Date: DATE-TIME</li><li>DateString: DATE-TIME</li><li>DueDate: DATE-TIME</li><li>DueDateString: DATE-TIME</li><li>ExpectedPaymentDate: DATE-TIME</li><li>FullyPaidOnDate: DATE-TIME</li><li>HasAttachments: BOOLEAN</li><li>HasErrors: BOOLEAN</li><li>InvoiceID: STRING</li><li>InvoiceNumber: STRING</li><li>IsDiscounted: BOOLEAN</li><li>LineAmountTypes: STRING</li><li>LineItems: ARRAY, which is also a nested data structure.                                                    <ul><li>AccountCode: STRING</li><li>Description: STRING</li><li>DiscountRate: NUMBER</li><li>ItemCode: STRING</li><li>LineAmount: NUMBER</li><li>LineItemID: STRING</li><li>Quantity: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>UnitAmount: NUMBER</li></ul></li><li>PlannedPaymentDate: DATE-TIME</li><li>Reference: STRING</li><li>SentToContact: BOOLEAN</li><li>Status: STRING</li><li>SubTotal: NUMBER</li><li>Total: NUMBER</li><li>TotalDiscount: NUMBER</li><li>TotalTax: NUMBER</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>Url: STRING</li></ul></li></ul> |
| --- |
| **AppliedAmount**<br><br><br>NUMBER |
| **Contact**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>AccountNumber: STRING</li><li>AccountsPayableTaxType: STRING</li><li>AccountsReceivableTaxType: STRING</li><li>Addresses: ARRAY, which is also a nested data structure.                                                            <ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul></li><li>Attachments: ARRAY</li><li>Balances: OBJECT, which is also a nested data structure.                                                            <ul><li>AccountsPayable: OBJECT, which is also a nested data structure.                                                                    <ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.                                                                    <ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul></li><li>BankAccountDetails: STRING</li><li>BatchPayments: OBJECT, which is also a nested data structure.                                                            <ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul></li><li>BrandingTheme: OBJECT, which is also a nested data structure.                                                            <ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DARE-TIME</li><li>Name: STRING</li><li>SortOrder: INTEGER</li></ul></li><li>ContactGroups: ARRAY, which is also a nested data structure.                                                            <ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul></li><li>ContactID: STRING</li><li>ContactNumber: STRING</li><li>ContactPersons: ARRAY, which is also a nested data structure.                                                            <ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul></li><li>ContactStatus: STRING</li><li>DefaultCurrency: STRING</li><li>Discount: NUMBER</li><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>HasAttachments: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>IsCustomer: BOOLEAN</li><li>IsSupplier: BOOLEAN</li><li>LastName: STRING</li><li>Name: STRING</li><li>PaymentTerms: OBJECT, which is also a nested data structure.                                                            <ul><li>Bills: OBJECT, which is also a nested data structure.                                                                    <ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.                                                                    <ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul></li><li>Phones: ARRAY, which is also a nested data structure.                                                            <ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul></li><li>PurchasesDefaultAccountCode: STRING</li><li>PurchasesTrackingCategories: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SalesDefaultAccountCode: STRING</li><li>SalesTrackingCategories: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SkypeUserName: STRING</li><li>TaxNumber: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingCategoryOption: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>ValidationErrors: ARRAY, which is also a nested data structure.                                                            <ul><li>Message: STRING</li></ul></li><li>Website: STRING</li><li>XeroNetworkKey: STRING</li></ul> |
| **CurrencyCode**<br><br><br>STRING |
| **CurrencyRate**<br><br><br>NUMBER |
| **Date**<br><br><br>DATE-TIME |
| **DateString**<br><br><br>DATE-TIME |
| **HasAttachments**<br><br><br>BOOLEAN |
| **ID**<br><br><br>STRING |
| **LineAmountTypes**<br><br><br>STRING |
| **LineItems**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>AccountCode: STRING</li><li>Description: STRING</li><li>DiscountRate: NUMBER</li><li>ItemCode: STRING</li><li>LineAmount: NUMBER</li><li>LineItemID: STRING</li><li>Quantity: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>UnitAmount: NUMBER</li></ul> |
| **OverpaymentID**<br><br><br>STRING |
| **Payments**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>Account: OBJECT, which is also a nested data structure.                                            <ul><li>AccountID: STRING</li><li>BankAccountNumber: STRING</li><li>BankAccountType: STRING</li><li>Class: STRING</li><li>Code: STRING</li><li>CurrencyCode: STRING</li><li>Description: STRING</li><li>EnablePaymentsToAccount: BOOLEAN</li><li>HasAttachments: BOOLEAN</li><li>Name: STRING</li><li>ReportingCode: STRING</li><li>ReportingCodeName: STRING</li><li>ShowInExpenseClaims: BOOLEAN</li><li>Status: STRING</li><li>SystemAccount: STRING</li><li>TaxType: STRING</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li></ul></li><li>Amount: NUMBER</li><li>BankAmount: NUMBER</li><li>BatchPaymentID: STRING</li><li>CreditNote: OBJECT, which is also a nested data structure.                                            <ul><li>CreditNoteNumber: STRING</li></ul></li><li>CurrencyRate: NUMBER</li><li>Date: DATE-TIME</li><li>HasAccount: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>Invoice: OBJECT, which is also a nested data structure.                                            <ul><li>AmountCredited: NUMBER</li><li>AmountDue: NUMBER</li><li>AmountPaid: NUMBER</li><li>BrandingThemeID: STRING</li><li>Contact: OBJECT, which is also a nested data structure.                                                    <ul><li>AccountNumber: STRING</li><li>AccountsPayableTaxType: STRING</li><li>AccountsReceivableTaxType: STRING</li><li>Addresses: ARRAY, which is also a nested data structure.                                                            <ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul></li><li>Attachments: ARRAY</li><li>Balances: OBJECT, which is also a nested data structure.                                                            <ul><li>AccountsPayable: OBJECT, which is also a nested data structure.                                                                    <ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.                                                                    <ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul></li><li>BankAccountDetails: STRING</li><li>BatchPayments: OBJECT, which is also a nested data structure.                                                            <ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul></li><li>BrandingTheme: OBJECT, which is also a nested data structure.                                                            <ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DARE-TIME</li><li>Name: STRING</li><li>SortOrder: INTEGER</li></ul></li><li>ContactGroups: ARRAY, which is also a nested data structure.                                                            <ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul></li><li>ContactID: STRING</li><li>ContactNumber: STRING</li><li>ContactPersons: ARRAY, which is also a nested data structure.                                                            <ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul></li><li>ContactStatus: STRING</li><li>DefaultCurrency: STRING</li><li>Discount: NUMBER</li><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>HasAttachments: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>IsCustomer: BOOLEAN</li><li>IsSupplier: BOOLEAN</li><li>LastName: STRING</li><li>Name: STRING</li><li>PaymentTerms: OBJECT, which is also a nested data structure.                                                            <ul><li>Bills: OBJECT, which is also a nested data structure.                                                                    <ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.                                                                    <ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul></li><li>Phones: ARRAY, which is also a nested data structure.                                                            <ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul></li><li>PurchasesDefaultAccountCode: STRING</li><li>PurchasesTrackingCategories: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SalesDefaultAccountCode: STRING</li><li>SalesTrackingCategories: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SkypeUserName: STRING</li><li>TaxNumber: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingCategoryOption: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>ValidationErrors: ARRAY, which is also a nested data structure.                                                            <ul><li>Message: STRING</li></ul></li><li>Website: STRING</li><li>XeroNetworkKey: STRING</li></ul></li><li>CurrencyCode: STRING</li><li>CurrencyRate: NUMBER</li><li>Date: DATE-TIME</li><li>DateString: DATE-TIME</li><li>DueDate: DATE-TIME</li><li>DueDateString: DATE-TIME</li><li>ExpectedPaymentDate: DATE-TIME</li><li>FullyPaidOnDate: DATE-TIME</li><li>HasAttachments: BOOLEAN</li><li>HasErrors: BOOLEAN</li><li>InvoiceID: STRING</li><li>InvoiceNumber: STRING</li><li>IsDiscounted: BOOLEAN</li><li>LineAmountTypes: STRING</li><li>LineItems: ARRAY, which is also a nested data structure.                                                    <ul><li>AccountCode: STRING</li><li>Description: STRING</li><li>DiscountRate: NUMBER</li><li>ItemCode: STRING</li><li>LineAmount: NUMBER</li><li>LineItemID: STRING</li><li>Quantity: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>UnitAmount: NUMBER</li></ul></li><li>PlannedPaymentDate: DATE-TIME</li><li>Reference: STRING</li><li>SentToContact: BOOLEAN</li><li>Status: STRING</li><li>SubTotal: NUMBER</li><li>Total: NUMBER</li><li>TotalDiscount: NUMBER</li><li>TotalTax: NUMBER</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>Url: STRING</li></ul></li><li>IsReconciled: BOOLEAN</li><li>Overpayment: ARRAY, which is also a nested data structure.                                            <ul><li>OverpaymentID: STRING</li></ul></li><li>PaymentID: STRING</li><li>PaymentType: STRING</li><li>Prepayments: ARRAY, which is also a nested data structure.                                            <ul><li>PrepaymentID: STRING</li></ul></li><li>Reference: STRING</li><li>Status: STRING</li><li>UpdatedDateUTC: DATE-TIME</li></ul> |
| **Reference**<br><br><br>STRING |
| **RemainingCredit**<br><br><br>NUMBER |
| **Status**<br><br><br>STRING |
| **SubTotal**<br><br><br>NUMBER |
| **Total**<br><br><br>NUMBER |
| **TotalTax**<br><br><br>NUMBER |
| **Type**<br><br><br>STRING |
| **UpdatedDateUTC**<br><br><br>DATE-TIME |

### payments

The `payments` table contains info about the payments recorded in your Xero account.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | PaymentID |
| **Replication Key** | UpdatedDateUTC |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/payments "Opens in new tab: Xero API method") |

payments table foreign keys

| Join payments with | on |
| --- | --- |
| [accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#accounts) | ```<br>payments.Account.AccountID = accounts.AccountID<br>``` |
| [bank_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#bank-transactions) | ```<br>payments.Account.AccountID = bank_transactions.BankAccount.AccountID<br>```<br><br>```<br>payments.Overpayment.OverpaymentID = bank_transactions.OverpaymentID<br>```<br><br>```<br>payments.Prepayments.PrepaymentID = bank_transactions.PrepaymentID<br>``` |
| [bank_transfers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#bank-transfers) | ```<br>payments.Account.AccountID = bank_transfers.FromBankAccount.AccountID<br>```<br><br>```<br>payments.Account.AccountID = bank_transfers.ToBankAccount.AccountID<br>``` |
| [journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#journals) | ```<br>payments.Account.AccountID = journals.JournalLines.AccountID<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#invoices) | ```<br>payments.Invoice.InvoiceID = invoices.InvoiceID<br>```<br><br>```<br>payments.Overpayment.OverpaymentID = invoices.Overpayments.Overpayment.OverpaymentID<br>```<br><br>```<br>payments.PaymentID = invoices.Payments.PaymentID<br>```<br><br>```<br>payments.Prepayments.PrepaymentID = invoices.Prepayments.PrepaymentID<br>``` |
| [linked_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#linked-transactions) | ```<br>payments.Invoice.InvoiceID = linked_transactions.SourceTransactionID<br>```<br><br>```<br>payments.Invoice.InvoiceID = linked_transactions.TargetTransactionID<br>``` |
| [overpayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#overpayments) | ```<br>payments.Invoice.InvoiceID = overpayments.Allocations.Invoice.InvoiceID<br>```<br><br>```<br>payments.Overpayment.OverpaymentID = overpayments.OverpaymentID<br>```<br><br>```<br>payments.PaymentID = overpayments.Payments.PaymentID<br>``` |
| [prepayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#prepayments) | ```<br>payments.Invoice.InvoiceID = prepayments.Allocations.Invoice.InvoiceID<br>```<br><br>```<br>payments.Prepayments.PrepaymentID = prepayments.PrepaymentID<br>``` |
| [expense_claims](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#expense-claims) | ```<br>payments.PaymentID = expense_claims.Payments.PaymentID<br>``` |

payments table schema

| **Account**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>AccountID: STRING</li><li>BankAccountNumber: STRING</li><li>BankAccountType: STRING</li><li>Class: STRING</li><li>Code: STRING</li><li>CurrencyCode: STRING</li><li>Description: STRING</li><li>EnablePaymentsToAccount: BOOLEAN</li><li>HasAttachments: BOOLEAN</li><li>Name: STRING</li><li>ReportingCode: STRING</li><li>ReportingCodeName: STRING</li><li>ShowInExpenseClaims: BOOLEAN</li><li>Status: STRING</li><li>SystemAccount: STRING</li><li>TaxType: STRING</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li></ul> |
| --- |
| **Amount**<br><br><br>NUMBER |
| **BankAmount**<br><br><br>NUMBER |
| **BatchPaymentID**<br><br><br>STRING |
| **CreditNote**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>CreditNoteNumber: STRING</li></ul> |
| **CurrencyRate**<br><br><br>NUMBER |
| **Date**<br><br><br>DATE-TIME |
| **HasAccount**<br><br><br>BOOLEAN |
| **HasValidationErrors**<br><br><br>BOOLEAN |
| **Invoice**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>AmountCredited: NUMBER</li><li>AmountDue: NUMBER</li><li>AmountPaid: NUMBER</li><li>BrandingThemeID: STRING</li><li>Contact: OBJECT, which is also a nested data structure.                                                    <ul><li>AccountNumber: STRING</li><li>AccountsPayableTaxType: STRING</li><li>AccountsReceivableTaxType: STRING</li><li>Addresses: ARRAY, which is also a nested data structure.                                                            <ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul></li><li>Attachments: ARRAY</li><li>Balances: OBJECT, which is also a nested data structure.                                                            <ul><li>AccountsPayable: OBJECT, which is also a nested data structure.                                                                    <ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.                                                                    <ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul></li><li>BankAccountDetails: STRING</li><li>BatchPayments: OBJECT, which is also a nested data structure.                                                            <ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul></li><li>BrandingTheme: OBJECT, which is also a nested data structure.                                                            <ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DARE-TIME</li><li>Name: STRING</li><li>SortOrder: INTEGER</li></ul></li><li>ContactGroups: ARRAY, which is also a nested data structure.                                                            <ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul></li><li>ContactID: STRING</li><li>ContactNumber: STRING</li><li>ContactPersons: ARRAY, which is also a nested data structure.                                                            <ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul></li><li>ContactStatus: STRING</li><li>DefaultCurrency: STRING</li><li>Discount: NUMBER</li><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>HasAttachments: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>IsCustomer: BOOLEAN</li><li>IsSupplier: BOOLEAN</li><li>LastName: STRING</li><li>Name: STRING</li><li>PaymentTerms: OBJECT, which is also a nested data structure.                                                            <ul><li>Bills: OBJECT, which is also a nested data structure.                                                                    <ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.                                                                    <ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul></li><li>Phones: ARRAY, which is also a nested data structure.                                                            <ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul></li><li>PurchasesDefaultAccountCode: STRING</li><li>PurchasesTrackingCategories: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SalesDefaultAccountCode: STRING</li><li>SalesTrackingCategories: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SkypeUserName: STRING</li><li>TaxNumber: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingCategoryOption: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>ValidationErrors: ARRAY, which is also a nested data structure.                                                            <ul><li>Message: STRING</li></ul></li><li>Website: STRING</li><li>XeroNetworkKey: STRING</li></ul></li><li>CurrencyCode: STRING</li><li>CurrencyRate: NUMBER</li><li>Date: DATE-TIME</li><li>DateString: DATE-TIME</li><li>DueDate: DATE-TIME</li><li>DueDateString: DATE-TIME</li><li>ExpectedPaymentDate: DATE-TIME</li><li>FullyPaidOnDate: DATE-TIME</li><li>HasAttachments: BOOLEAN</li><li>HasErrors: BOOLEAN</li><li>InvoiceID: STRING</li><li>InvoiceNumber: STRING</li><li>IsDiscounted: BOOLEAN</li><li>LineAmountTypes: STRING</li><li>LineItems: ARRAY, which is also a nested data structure.                                                    <ul><li>AccountCode: STRING</li><li>Description: STRING</li><li>DiscountRate: NUMBER</li><li>ItemCode: STRING</li><li>LineAmount: NUMBER</li><li>LineItemID: STRING</li><li>Quantity: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>UnitAmount: NUMBER</li></ul></li><li>PlannedPaymentDate: DATE-TIME</li><li>Reference: STRING</li><li>SentToContact: BOOLEAN</li><li>Status: STRING</li><li>SubTotal: NUMBER</li><li>Total: NUMBER</li><li>TotalDiscount: NUMBER</li><li>TotalTax: NUMBER</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>Url: STRING</li></ul> |
| **IsReconciled**<br><br><br>BOOLEAN |
| **Overpayment**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>OverpaymentID: STRING</li></ul> |
| **PaymentID**<br><br><br>STRING |
| **PaymentType**<br><br><br>STRING |
| **Prepayments**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>PrepaymentID: STRING</li></ul> |
| **Reference**<br><br><br>STRING |
| **Status**<br><br><br>STRING |
| **UpdatedDateUTC**<br><br><br>DATE-TIME |

### prepayments

The `prepayments` table contains info about prepayments, which are payments made in advance of an invoice being raised for a customer or a bill being received from a supplier.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | PrepaymentID |
| **Replication Key** | UpdatedDateUTC |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/prepayments "Opens in new tab: Xero API method") |

prepayments table foreign keys

| Join prepayments with | on |
| --- | --- |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#contacts) | ```<br>prepayments.Contact.ContactID = contacts.ContactID<br>```<br><br>```<br>prepayments.LineItems.Tracking.TrackingCategoryID = contacts.SalesTrackingCategories.TrackingCategoryID<br>```<br><br>```<br>prepayments.LineItems.Tracking.TrackingCategoryID = contacts.PurchasesTrackingCategories.TrackingCategoryID<br>``` |
| [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#credit-notes) | ```<br>prepayments.Contact.ContactID = credit_notes.Contact.ContactID<br>```<br><br>```<br>prepayments.CurrencyCode = credit_notes.CurrencyCode<br>```<br><br>```<br>prepayments.LineItems.Tracking.TrackingCategoryID = credit_notes.LineItems.Tracking.TrackingCategoryID<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#invoices) | ```<br>prepayments.Contact.ContactID = invoices.Contact.ContactID<br>```<br><br>```<br>prepayments.CurrencyCode = invoices.CurrencyCode<br>```<br><br>```<br>prepayments.Allocations.Invoice.InvoiceID = invoices.InvoiceID<br>```<br><br>```<br>prepayments.PrepaymentID = invoices.Prepayments.PrepaymentID<br>```<br><br>```<br>prepayments.LineItems.Tracking.TrackingCategoryID = invoices.LineItems.Tracking.TrackingCategoryID<br>``` |
| [linked_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#linked-transactions) | ```<br>prepayments.Contact.ContactID = linked_transactions.ContactID<br>```<br><br>```<br>prepayments.Allocations.Invoice.InvoiceID = linked_transactions.SourceTransactionID<br>```<br><br>```<br>prepayments.Allocations.Invoice.InvoiceID = linked_transactions.TargetTransactionID<br>``` |
| [overpayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#overpayments) | ```<br>prepayments.Contact.ContactID = overpayments.Contact.ContactID<br>```<br><br>```<br>prepayments.Allocations.Invoice.InvoiceID = overpayments.Allocations.Invoice.InvoiceID<br>```<br><br>```<br>prepayments.LineItems.Tracking.TrackingCategoryID = overpayments.LineItems.Tracking.TrackingCategoryID<br>``` |
| [receipts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#receipts) | ```<br>prepayments.Contact.ContactID = receipts.Contact.ContactID<br>```<br><br>```<br>prepayments.LineItems.Tracking.TrackingCategoryID = receipts.LineItems.Tracking.TrackingCategoryID<br>``` |
| [repeating_invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#repeating-invoices) | ```<br>prepayments.Contact.ContactID = repeating_invoices.Contact.ContactID<br>```<br><br>```<br>prepayments.CurrencyCode = repeating_invoices.CurrencyCode<br>```<br><br>```<br>prepayments.LineItems.Tracking.TrackingCategoryID = repeating_invoices.LineItems.Tracking.TrackingCategoryID<br>``` |
| [accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#accounts) | ```<br>prepayments.CurrencyCode = accounts.CurrencyCode<br>``` |
| [bank_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#bank-transactions) | ```<br>prepayments.CurrencyCode = bank_transactions.CurrencyCode<br>```<br><br>```<br>prepayments.PrepaymentID = bank_transactions.PrepaymentID<br>``` |
| [currencies](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#currencies) | ```<br>prepayments.CurrencyCode = currencies.Code<br>``` |
| [purchase_orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#purchase-orders) | ```<br>prepayments.CurrencyCode = purchase_orders.CurrencyCode<br>```<br><br>```<br>prepayments.LineItems.Tracking.TrackingCategoryID = purchase_orders.LineItems.Tracking.TrackingCategoryID<br>``` |
| [payments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#payments) | ```<br>prepayments.Allocations.Invoice.InvoiceID = payments.Invoice.InvoiceID<br>```<br><br>```<br>prepayments.PrepaymentID = payments.Prepayments.PrepaymentID<br>``` |
| [journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#journals) | ```<br>prepayments.LineItems.Tracking.TrackingCategoryID = journals.JournalLines.TrackingCategories.TrackingCategoryID<br>``` |
| [manual_journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#manual-journals) | ```<br>prepayments.LineItems.Tracking.TrackingCategoryID = manual_journals.JournalLines.Tracking.TrackingCategoryID<br>``` |
| [tracking_categories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#tracking-categories) | ```<br>prepayments.LineItems.Tracking.TrackingCategoryID = tracking_categories.TrackingCategoryID<br>``` |

prepayments table schema

| **Allocations**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>Amount: NUMBER</li><li>Date: DATE-TIME</li><li>Invoice: OBJECT, which is also a nested data structure.                                            <ul><li>AmountCredited: NUMBER</li><li>AmountDue: NUMBER</li><li>AmountPaid: NUMBER</li><li>BrandingThemeID: STRING</li><li>Contact: OBJECT, which is also a nested data structure.                                                    <ul><li>AccountNumber: STRING</li><li>AccountsPayableTaxType: STRING</li><li>AccountsReceivableTaxType: STRING</li><li>Addresses: ARRAY, which is also a nested data structure.                                                            <ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul></li><li>Attachments: ARRAY</li><li>Balances: OBJECT, which is also a nested data structure.                                                            <ul><li>AccountsPayable: OBJECT, which is also a nested data structure.                                                                    <ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.                                                                    <ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul></li><li>BankAccountDetails: STRING</li><li>BatchPayments: OBJECT, which is also a nested data structure.                                                            <ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul></li><li>BrandingTheme: OBJECT, which is also a nested data structure.                                                            <ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DARE-TIME</li><li>Name: STRING</li><li>SortOrder: INTEGER</li></ul></li><li>ContactGroups: ARRAY, which is also a nested data structure.                                                            <ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul></li><li>ContactID: STRING</li><li>ContactNumber: STRING</li><li>ContactPersons: ARRAY, which is also a nested data structure.                                                            <ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul></li><li>ContactStatus: STRING</li><li>DefaultCurrency: STRING</li><li>Discount: NUMBER</li><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>HasAttachments: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>IsCustomer: BOOLEAN</li><li>IsSupplier: BOOLEAN</li><li>LastName: STRING</li><li>Name: STRING</li><li>PaymentTerms: OBJECT, which is also a nested data structure.                                                            <ul><li>Bills: OBJECT, which is also a nested data structure.                                                                    <ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.                                                                    <ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul></li><li>Phones: ARRAY, which is also a nested data structure.                                                            <ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul></li><li>PurchasesDefaultAccountCode: STRING</li><li>PurchasesTrackingCategories: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SalesDefaultAccountCode: STRING</li><li>SalesTrackingCategories: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SkypeUserName: STRING</li><li>TaxNumber: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingCategoryOption: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>ValidationErrors: ARRAY, which is also a nested data structure.                                                            <ul><li>Message: STRING</li></ul></li><li>Website: STRING</li><li>XeroNetworkKey: STRING</li></ul></li><li>CurrencyCode: STRING</li><li>CurrencyRate: NUMBER</li><li>Date: DATE-TIME</li><li>DateString: DATE-TIME</li><li>DueDate: DATE-TIME</li><li>DueDateString: DATE-TIME</li><li>ExpectedPaymentDate: DATE-TIME</li><li>FullyPaidOnDate: DATE-TIME</li><li>HasAttachments: BOOLEAN</li><li>HasErrors: BOOLEAN</li><li>InvoiceID: STRING</li><li>InvoiceNumber: STRING</li><li>IsDiscounted: BOOLEAN</li><li>LineAmountTypes: STRING</li><li>LineItems: ARRAY, which is also a nested data structure.                                                    <ul><li>AccountCode: STRING</li><li>Description: STRING</li><li>DiscountRate: NUMBER</li><li>ItemCode: STRING</li><li>LineAmount: NUMBER</li><li>LineItemID: STRING</li><li>Quantity: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>UnitAmount: NUMBER</li></ul></li><li>PlannedPaymentDate: DATE-TIME</li><li>Reference: STRING</li><li>SentToContact: BOOLEAN</li><li>Status: STRING</li><li>SubTotal: NUMBER</li><li>Total: NUMBER</li><li>TotalDiscount: NUMBER</li><li>TotalTax: NUMBER</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>Url: STRING</li></ul></li></ul> |
| --- |
| **AppliedAmount**<br><br><br>NUMBER |
| **Contact**<br><br><br>OBJECT<br><br><ul><li>AccountNumber: STRING</li><li>AccountsPayableTaxType: STRING</li><li>AccountsReceivableTaxType: STRING</li><li>Addresses: ARRAY, which is also a nested data structure.                                                            <ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul></li><li>Attachments: ARRAY</li><li>Balances: OBJECT, which is also a nested data structure.                                                            <ul><li>AccountsPayable: OBJECT, which is also a nested data structure.                                                                    <ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.                                                                    <ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul></li><li>BankAccountDetails: STRING</li><li>BatchPayments: OBJECT, which is also a nested data structure.                                                            <ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul></li><li>BrandingTheme: OBJECT, which is also a nested data structure.                                                            <ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DARE-TIME</li><li>Name: STRING</li><li>SortOrder: INTEGER</li></ul></li><li>ContactGroups: ARRAY, which is also a nested data structure.                                                            <ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul></li><li>ContactID: STRING</li><li>ContactNumber: STRING</li><li>ContactPersons: ARRAY, which is also a nested data structure.                                                            <ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul></li><li>ContactStatus: STRING</li><li>DefaultCurrency: STRING</li><li>Discount: NUMBER</li><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>HasAttachments: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>IsCustomer: BOOLEAN</li><li>IsSupplier: BOOLEAN</li><li>LastName: STRING</li><li>Name: STRING</li><li>PaymentTerms: OBJECT, which is also a nested data structure.                                                            <ul><li>Bills: OBJECT, which is also a nested data structure.                                                                    <ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.                                                                    <ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul></li><li>Phones: ARRAY, which is also a nested data structure.                                                            <ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul></li><li>PurchasesDefaultAccountCode: STRING</li><li>PurchasesTrackingCategories: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SalesDefaultAccountCode: STRING</li><li>SalesTrackingCategories: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SkypeUserName: STRING</li><li>TaxNumber: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingCategoryOption: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>ValidationErrors: ARRAY, which is also a nested data structure.                                                            <ul><li>Message: STRING</li></ul></li><li>Website: STRING</li><li>XeroNetworkKey: STRING</li></ul> |
| **CurrencyCode**<br><br><br>STRING |
| **CurrencyRate**<br><br><br>NUMBER |
| **Date**<br><br><br>DATE-TIME |
| **DateString**<br><br><br>DATE-TIME |
| **HasAttachments**<br><br><br>BOOLEAN |
| **ID**<br><br><br>STRING |
| **LineAmountTypes**<br><br><br>STRING |
| **LineItems**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>AccountCode: STRING</li><li>Description: STRING</li><li>DiscountRate: NUMBER</li><li>ItemCode: STRING</li><li>LineAmount: NUMBER</li><li>LineItemID: STRING</li><li>Quantity: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>UnitAmount: NUMBER</li></ul> |
| **Payments**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>Account: OBJECT, which is also a nested data structure.                                            <ul><li>AccountID: STRING</li><li>BankAccountNumber: STRING</li><li>BankAccountType: STRING</li><li>Class: STRING</li><li>Code: STRING</li><li>CurrencyCode: STRING</li><li>Description: STRING</li><li>EnablePaymentsToAccount: BOOLEAN</li><li>HasAttachments: BOOLEAN</li><li>Name: STRING</li><li>ReportingCode: STRING</li><li>ReportingCodeName: STRING</li><li>ShowInExpenseClaims: BOOLEAN</li><li>Status: STRING</li><li>SystemAccount: STRING</li><li>TaxType: STRING</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li></ul></li><li>Amount: NUMBER</li><li>BankAmount: NUMBER</li><li>BatchPaymentID: STRING</li><li>CreditNote: OBJECT, which is also a nested data structure.                                            <ul><li>CreditNoteNumber: STRING</li></ul></li><li>CurrencyRate: NUMBER</li><li>Date: DATE-TIME</li><li>HasAccount: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>Invoice: OBJECT, which is also a nested data structure.                                            <ul><li>AmountCredited: NUMBER</li><li>AmountDue: NUMBER</li><li>AmountPaid: NUMBER</li><li>BrandingThemeID: STRING</li><li>Contact: OBJECT, which is also a nested data structure.                                                    <ul><li>AccountNumber: STRING</li><li>AccountsPayableTaxType: STRING</li><li>AccountsReceivableTaxType: STRING</li><li>Addresses: ARRAY, which is also a nested data structure.                                                            <ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul></li><li>Attachments: ARRAY</li><li>Balances: OBJECT, which is also a nested data structure.                                                            <ul><li>AccountsPayable: OBJECT, which is also a nested data structure.                                                                    <ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.                                                                    <ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul></li><li>BankAccountDetails: STRING</li><li>BatchPayments: OBJECT, which is also a nested data structure.                                                            <ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul></li><li>BrandingTheme: OBJECT, which is also a nested data structure.                                                            <ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DARE-TIME</li><li>Name: STRING</li><li>SortOrder: INTEGER</li></ul></li><li>ContactGroups: ARRAY, which is also a nested data structure.                                                            <ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul></li><li>ContactID: STRING</li><li>ContactNumber: STRING</li><li>ContactPersons: ARRAY, which is also a nested data structure.                                                            <ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul></li><li>ContactStatus: STRING</li><li>DefaultCurrency: STRING</li><li>Discount: NUMBER</li><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>HasAttachments: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>IsCustomer: BOOLEAN</li><li>IsSupplier: BOOLEAN</li><li>LastName: STRING</li><li>Name: STRING</li><li>PaymentTerms: OBJECT, which is also a nested data structure.                                                            <ul><li>Bills: OBJECT, which is also a nested data structure.                                                                    <ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.                                                                    <ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul></li><li>Phones: ARRAY, which is also a nested data structure.                                                            <ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul></li><li>PurchasesDefaultAccountCode: STRING</li><li>PurchasesTrackingCategories: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SalesDefaultAccountCode: STRING</li><li>SalesTrackingCategories: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SkypeUserName: STRING</li><li>TaxNumber: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingCategoryOption: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>ValidationErrors: ARRAY, which is also a nested data structure.                                                            <ul><li>Message: STRING</li></ul></li><li>Website: STRING</li><li>XeroNetworkKey: STRING</li></ul></li><li>CurrencyCode: STRING</li><li>CurrencyRate: NUMBER</li><li>Date: DATE-TIME</li><li>DateString: DATE-TIME</li><li>DueDate: DATE-TIME</li><li>DueDateString: DATE-TIME</li><li>ExpectedPaymentDate: DATE-TIME</li><li>FullyPaidOnDate: DATE-TIME</li><li>HasAttachments: BOOLEAN</li><li>HasErrors: BOOLEAN</li><li>InvoiceID: STRING</li><li>InvoiceNumber: STRING</li><li>IsDiscounted: BOOLEAN</li><li>LineAmountTypes: STRING</li><li>LineItems: ARRAY, which is also a nested data structure.                                                    <ul><li>AccountCode: STRING</li><li>Description: STRING</li><li>DiscountRate: NUMBER</li><li>ItemCode: STRING</li><li>LineAmount: NUMBER</li><li>LineItemID: STRING</li><li>Quantity: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>UnitAmount: NUMBER</li></ul></li><li>PlannedPaymentDate: DATE-TIME</li><li>Reference: STRING</li><li>SentToContact: BOOLEAN</li><li>Status: STRING</li><li>SubTotal: NUMBER</li><li>Total: NUMBER</li><li>TotalDiscount: NUMBER</li><li>TotalTax: NUMBER</li><li>Type: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>Url: STRING</li></ul></li><li>IsReconciled: BOOLEAN</li><li>Overpayment: ARRAY, which is also a nested data structure.                                            <ul><li>OverpaymentID: STRING</li></ul></li><li>PaymentID: STRING</li><li>PaymentType: STRING</li><li>Prepayments: ARRAY, which is also a nested data structure.                                            <ul><li>PrepaymentID: STRING</li></ul></li><li>Reference: STRING</li><li>Status: STRING</li><li>UpdatedDateUTC: DATE-TIME</li></ul> |
| **PrepaymentID**<br><br><br>STRING |
| **Reference**<br><br><br>STRING |
| **RemainingCredit**<br><br><br>NUMBER |
| **Status**<br><br><br>STRING |
| **SubTotal**<br><br><br>NUMBER |
| **Total**<br><br><br>NUMBER |
| **TotalTax**<br><br><br>NUMBER |
| **Type**<br><br><br>STRING |
| **UpdatedDateUTC**<br><br><br>DATE-TIME |

### purchase\_orders

The `purchase_orders` table contains info about your purchase orders. Purchase orders are requests sent to suppliers for specific goods and services.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | PurchaseOrderID |
| **Replication Key** | UpdatedDateUTC |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/purchase-orders "Opens in new tab: Xero API method") |

purchase\_orders table foreign keys

| Join purchase\_orders with | on |
| --- | --- |
| [branding_themes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#branding-themes) | ```<br>purchase_orders.BrandingThemeID = branding_themes.BrandingThemeID<br>``` |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#contacts) | ```<br>purchase_orders.BrandingThemeID = contacts.BrandingTheme.BrandingThemeID<br>```<br><br>```<br>purchase_orders.LineItems.Tracking.TrackingCategoryID = contacts.SalesTrackingCategories.TrackingCategoryID<br>```<br><br>```<br>purchase_orders.LineItems.Tracking.TrackingCategoryID = contacts.PurchasesTrackingCategories.TrackingCategoryID<br>``` |
| [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#credit-notes) | ```<br>purchase_orders.BrandingThemeID = credit_notes.BrandingThemeID<br>```<br><br>```<br>purchase_orders.CurrencyCode = credit_notes.CurrencyCode<br>```<br><br>```<br>purchase_orders.LineItems.Tracking.TrackingCategoryID = credit_notes.LineItems.Tracking.TrackingCategoryID<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#invoices) | ```<br>purchase_orders.BrandingThemeID = invoices.BrandingThemeID<br>```<br><br>```<br>purchase_orders.CurrencyCode = invoices.CurrencyCode<br>```<br><br>```<br>purchase_orders.LineItems.Tracking.TrackingCategoryID = invoices.LineItems.Tracking.TrackingCategoryID<br>``` |
| [repeating_invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#repeating-invoices) | ```<br>purchase_orders.BrandingThemeID = repeating_invoices.BrandingThemeID<br>```<br><br>```<br>purchase_orders.CurrencyCode = repeating_invoices.CurrencyCode<br>```<br><br>```<br>purchase_orders.LineItems.Tracking.TrackingCategoryID = repeating_invoices.LineItems.Tracking.TrackingCategoryID<br>``` |
| [accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#accounts) | ```<br>purchase_orders.CurrencyCode = accounts.CurrencyCode<br>``` |
| [bank_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#bank-transactions) | ```<br>purchase_orders.CurrencyCode = bank_transactions.CurrencyCode<br>``` |
| [currencies](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#currencies) | ```<br>purchase_orders.CurrencyCode = currencies.Code<br>``` |
| [prepayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#prepayments) | ```<br>purchase_orders.CurrencyCode = prepayments.CurrencyCode<br>```<br><br>```<br>purchase_orders.LineItems.Tracking.TrackingCategoryID = prepayments.LineItems.Tracking.TrackingCategoryID<br>``` |
| [journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#journals) | ```<br>purchase_orders.LineItems.Tracking.TrackingCategoryID = journals.JournalLines.TrackingCategories.TrackingCategoryID<br>``` |
| [manual_journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#manual-journals) | ```<br>purchase_orders.LineItems.Tracking.TrackingCategoryID = manual_journals.JournalLines.Tracking.TrackingCategoryID<br>``` |
| [overpayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#overpayments) | ```<br>purchase_orders.LineItems.Tracking.TrackingCategoryID = overpayments.LineItems.Tracking.TrackingCategoryID<br>``` |
| [receipts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#receipts) | ```<br>purchase_orders.LineItems.Tracking.TrackingCategoryID = receipts.LineItems.Tracking.TrackingCategoryID<br>``` |
| [tracking_categories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#tracking-categories) | ```<br>purchase_orders.LineItems.Tracking.TrackingCategoryID = tracking_categories.TrackingCategoryID<br>``` |

purchase\_orders table schema

| **AttentionTo**<br><br><br>STRING |
| --- |
| **BrandingThemeID**<br><br><br>STRING |
| **Contact**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>AccountNumber: STRING</li><li>AccountsPayableTaxType: STRING</li><li>AccountsReceivableTaxType: STRING</li><li>Addresses: ARRAY, which is also a nested data structure.                                                            <ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul></li><li>Attachments: ARRAY</li><li>Balances: OBJECT, which is also a nested data structure.                                                            <ul><li>AccountsPayable: OBJECT, which is also a nested data structure.                                                                    <ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.                                                                    <ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul></li><li>BankAccountDetails: STRING</li><li>BatchPayments: OBJECT, which is also a nested data structure.                                                            <ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul></li><li>BrandingTheme: OBJECT, which is also a nested data structure.                                                            <ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DARE-TIME</li><li>Name: STRING</li><li>SortOrder: INTEGER</li></ul></li><li>ContactGroups: ARRAY, which is also a nested data structure.                                                            <ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul></li><li>ContactID: STRING</li><li>ContactNumber: STRING</li><li>ContactPersons: ARRAY, which is also a nested data structure.                                                            <ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul></li><li>ContactStatus: STRING</li><li>DefaultCurrency: STRING</li><li>Discount: NUMBER</li><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>HasAttachments: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>IsCustomer: BOOLEAN</li><li>IsSupplier: BOOLEAN</li><li>LastName: STRING</li><li>Name: STRING</li><li>PaymentTerms: OBJECT, which is also a nested data structure.                                                            <ul><li>Bills: OBJECT, which is also a nested data structure.                                                                    <ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.                                                                    <ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul></li><li>Phones: ARRAY, which is also a nested data structure.                                                            <ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul></li><li>PurchasesDefaultAccountCode: STRING</li><li>PurchasesTrackingCategories: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SalesDefaultAccountCode: STRING</li><li>SalesTrackingCategories: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SkypeUserName: STRING</li><li>TaxNumber: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingCategoryOption: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>ValidationErrors: ARRAY, which is also a nested data structure.                                                            <ul><li>Message: STRING</li></ul></li><li>Website: STRING</li><li>XeroNetworkKey: STRING</li></ul> |
| **CurrencyCode**<br><br><br>STRING |
| **CurrencyRate**<br><br><br>NUMBER |
| **Date**<br><br><br>DATE-TIME |
| **DateString**<br><br><br>DATE-TIME |
| **DeliveryAddress**<br><br><br>STRING |
| **DeliveryDate**<br><br><br>DATE-TIME |
| **DeliveryDateString**<br><br><br>DATE-TIME |
| **DeliveryInstructions**<br><br><br>STRING |
| **ExpectedArrivalDate**<br><br><br>DATE-TIME |
| **ExpectedArrivalDateString**<br><br><br>DATE-TIME |
| **HasAttachments**<br><br><br>BOOLEAN |
| **HasErrors**<br><br><br>BOOLEAN |
| **IsDiscounted**<br><br><br>BOOLEAN |
| **LineAmountTypes**<br><br><br>STRING |
| **LineItems**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>AccountCode: STRING</li><li>Description: STRING</li><li>DiscountRate: NUMBER</li><li>ItemCode: STRING</li><li>LineAmount: NUMBER</li><li>LineItemID: STRING</li><li>Quantity: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.                                                            <ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.                                                                    <ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>UnitAmount: NUMBER</li></ul> |
| **PurchaseOrderID**<br><br><br>STRING |
| **PurchaseOrderNumber**<br><br><br>STRING |
| **Reference**<br><br><br>STRING |
| **SentToContact**<br><br><br>BOOLEAN |
| **Status**<br><br><br>STRING |
| **SubTotal**<br><br><br>NUMBER |
| **Telephone**<br><br><br>STRING |
| **Total**<br><br><br>NUMBER |
| **TotalDiscount**<br><br><br>NUMBER |
| **TotalTax**<br><br><br>NUMBER |
| **Type**<br><br><br>STRING |
| **UpdatedDateUTC**<br><br><br>DATE-TIME |

### receipts

The `receipts` table contains info about invoice receipts, which are receipts sent to customers after an invoice has been received.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | ReceiptID |
| **Replication Key** | UpdatedDateUTC |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/receipts "Opens in new tab: Xero API method") |

receipts table foreign keys

| Join receipts with | on |
| --- | --- |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#contacts) | ```<br>receipts.Contact.ContactID = contacts.ContactID<br>```<br><br>```<br>receipts.LineItems.Tracking.TrackingCategoryID = contacts.SalesTrackingCategories.TrackingCategoryID<br>```<br><br>```<br>receipts.LineItems.Tracking.TrackingCategoryID = contacts.PurchasesTrackingCategories.TrackingCategoryID<br>``` |
| [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#credit-notes) | ```<br>receipts.Contact.ContactID = credit_notes.Contact.ContactID<br>```<br><br>```<br>receipts.LineItems.Tracking.TrackingCategoryID = credit_notes.LineItems.Tracking.TrackingCategoryID<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#invoices) | ```<br>receipts.Contact.ContactID = invoices.Contact.ContactID<br>```<br><br>```<br>receipts.LineItems.Tracking.TrackingCategoryID = invoices.LineItems.Tracking.TrackingCategoryID<br>``` |
| [linked_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#linked-transactions) | ```<br>receipts.Contact.ContactID = linked_transactions.ContactID<br>``` |
| [overpayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#overpayments) | ```<br>receipts.Contact.ContactID = overpayments.Contact.ContactID<br>```<br><br>```<br>receipts.LineItems.Tracking.TrackingCategoryID = overpayments.LineItems.Tracking.TrackingCategoryID<br>``` |
| [prepayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#prepayments) | ```<br>receipts.Contact.ContactID = prepayments.Contact.ContactID<br>```<br><br>```<br>receipts.LineItems.Tracking.TrackingCategoryID = prepayments.LineItems.Tracking.TrackingCategoryID<br>``` |
| [repeating_invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#repeating-invoices) | ```<br>receipts.Contact.ContactID = repeating_invoices.Contact.ContactID<br>```<br><br>```<br>receipts.LineItems.Tracking.TrackingCategoryID = repeating_invoices.LineItems.Tracking.TrackingCategoryID<br>``` |
| [expense_claims](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#expense-claims) | ```<br>receipts.ReceiptID = expense_claims.Receipts.ReceiptID<br>```<br><br>```<br>receipts.User.UserID = expense_claims.User.UserID<br>``` |
| [journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#journals) | ```<br>receipts.LineItems.Tracking.TrackingCategoryID = journals.JournalLines.TrackingCategories.TrackingCategoryID<br>``` |
| [manual_journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#manual-journals) | ```<br>receipts.LineItems.Tracking.TrackingCategoryID = manual_journals.JournalLines.Tracking.TrackingCategoryID<br>``` |
| [purchase_orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#purchase-orders) | ```<br>receipts.LineItems.Tracking.TrackingCategoryID = purchase_orders.LineItems.Tracking.TrackingCategoryID<br>``` |
| [tracking_categories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#tracking-categories) | ```<br>receipts.LineItems.Tracking.TrackingCategoryID = tracking_categories.TrackingCategoryID<br>``` |

receipts table schema

| **Attachments**<br><br><br>ARRAY |
| --- |
| **Contact**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>AccountNumber: STRING</li><li>AccountsPayableTaxType: STRING</li><li>AccountsReceivableTaxType: STRING</li><li>Addresses: ARRAY, which is also a nested data structure.											<ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul></li><li>Attachments: ARRAY</li><li>Balances: OBJECT, which is also a nested data structure.											<ul><li>AccountsPayable: OBJECT, which is also a nested data structure.													<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.													<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul></li><li>BankAccountDetails: STRING</li><li>BatchPayments: OBJECT, which is also a nested data structure.											<ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul></li><li>BrandingTheme: OBJECT, which is also a nested data structure.											<ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DARE-TIME</li><li>Name: STRING</li><li>SortOrder: INTEGER</li></ul></li><li>ContactGroups: ARRAY, which is also a nested data structure.											<ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul></li><li>ContactID: STRING</li><li>ContactNumber: STRING</li><li>ContactPersons: ARRAY, which is also a nested data structure.											<ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul></li><li>ContactStatus: STRING</li><li>DefaultCurrency: STRING</li><li>Discount: NUMBER</li><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>HasAttachments: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>IsCustomer: BOOLEAN</li><li>IsSupplier: BOOLEAN</li><li>LastName: STRING</li><li>Name: STRING</li><li>PaymentTerms: OBJECT, which is also a nested data structure.											<ul><li>Bills: OBJECT, which is also a nested data structure.													<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.													<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul></li><li>Phones: ARRAY, which is also a nested data structure.											<ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul></li><li>PurchasesDefaultAccountCode: STRING</li><li>PurchasesTrackingCategories: ARRAY, which is also a nested data structure.											<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.													<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SalesDefaultAccountCode: STRING</li><li>SalesTrackingCategories: ARRAY, which is also a nested data structure.											<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.													<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SkypeUserName: STRING</li><li>TaxNumber: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingCategoryOption: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>ValidationErrors: ARRAY, which is also a nested data structure.											<ul><li>Message: STRING</li></ul></li><li>Website: STRING</li><li>XeroNetworkKey: STRING</li></ul> |
| **Date**<br><br><br>DATE-TIME |
| **HasAttachments**<br><br><br>BOOLEAN |
| **ID**<br><br><br>STRING |
| **LineAmountTypes**<br><br><br>STRING |
| **LineItems**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>AccountCode: STRING</li><li>Description: STRING</li><li>DiscountRate: NUMBER</li><li>ItemCode: STRING</li><li>LineAmount: NUMBER</li><li>LineItemID: STRING</li><li>Quantity: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.											<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.													<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>UnitAmount: NUMBER</li></ul> |
| **ReceiptID**<br><br><br>STRING |
| **ReceiptNumber**<br><br><br>INTEGER |
| **Reference**<br><br><br>STRING |
| **Status**<br><br><br>STRING |
| **SubTotal**<br><br><br>NUMBER |
| **Total**<br><br><br>NUMBER |
| **TotalTax**<br><br><br>NUMBER |
| **UpdatedDateUTC**<br><br><br>DATE-TIME |
| **Url**<br><br><br>STRING |
| **User**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IsSubscriber: BOOLEAN</li><li>LastName: STRING</li><li>OrganisationRole: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>UserID: STRING</li><li>ValidationErrors: ARRAY, which is also a nested data structure.											<ul><li>Message: STRING</li></ul></li></ul> |
| **ValidationErrors**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>Message: STRING</li></ul> |

### repeating\_invoices

The `repeating_invoices` table contains info about invoices set up to repeat in your Xero account. A repeating invoice is a recurring transaction, or a transaction that occurs on a regular basis.

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | RepeatingInvoiceID |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/repeating-invoices "Opens in new tab: Xero API method") |

repeating\_invoices table foreign keys

| Join repeating\_invoices with | on |
| --- | --- |
| [branding_themes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#branding-themes) | ```<br>repeating_invoices.BrandingThemeID = branding_themes.BrandingThemeID<br>``` |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#contacts) | ```<br>repeating_invoices.BrandingThemeID = contacts.BrandingTheme.BrandingThemeID<br>```<br><br>```<br>repeating_invoices.Contact.ContactID = contacts.ContactID<br>```<br><br>```<br>repeating_invoices.LineItems.Tracking.TrackingCategoryID = contacts.SalesTrackingCategories.TrackingCategoryID<br>```<br><br>```<br>repeating_invoices.LineItems.Tracking.TrackingCategoryID = contacts.PurchasesTrackingCategories.TrackingCategoryID<br>``` |
| [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#credit-notes) | ```<br>repeating_invoices.BrandingThemeID = credit_notes.BrandingThemeID<br>```<br><br>```<br>repeating_invoices.Contact.ContactID = credit_notes.Contact.ContactID<br>```<br><br>```<br>repeating_invoices.CurrencyCode = credit_notes.CurrencyCode<br>```<br><br>```<br>repeating_invoices.LineItems.Tracking.TrackingCategoryID = credit_notes.LineItems.Tracking.TrackingCategoryID<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#invoices) | ```<br>repeating_invoices.BrandingThemeID = invoices.BrandingThemeID<br>```<br><br>```<br>repeating_invoices.Contact.ContactID = invoices.Contact.ContactID<br>```<br><br>```<br>repeating_invoices.CurrencyCode = invoices.CurrencyCode<br>```<br><br>```<br>repeating_invoices.LineItems.Tracking.TrackingCategoryID = invoices.LineItems.Tracking.TrackingCategoryID<br>``` |
| [purchase_orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#purchase-orders) | ```<br>repeating_invoices.BrandingThemeID = purchase_orders.BrandingThemeID<br>```<br><br>```<br>repeating_invoices.CurrencyCode = purchase_orders.CurrencyCode<br>```<br><br>```<br>repeating_invoices.LineItems.Tracking.TrackingCategoryID = purchase_orders.LineItems.Tracking.TrackingCategoryID<br>``` |
| [linked_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#linked-transactions) | ```<br>repeating_invoices.Contact.ContactID = linked_transactions.ContactID<br>``` |
| [overpayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#overpayments) | ```<br>repeating_invoices.Contact.ContactID = overpayments.Contact.ContactID<br>```<br><br>```<br>repeating_invoices.LineItems.Tracking.TrackingCategoryID = overpayments.LineItems.Tracking.TrackingCategoryID<br>``` |
| [prepayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#prepayments) | ```<br>repeating_invoices.Contact.ContactID = prepayments.Contact.ContactID<br>```<br><br>```<br>repeating_invoices.CurrencyCode = prepayments.CurrencyCode<br>```<br><br>```<br>repeating_invoices.LineItems.Tracking.TrackingCategoryID = prepayments.LineItems.Tracking.TrackingCategoryID<br>``` |
| [receipts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#receipts) | ```<br>repeating_invoices.Contact.ContactID = receipts.Contact.ContactID<br>```<br><br>```<br>repeating_invoices.LineItems.Tracking.TrackingCategoryID = receipts.LineItems.Tracking.TrackingCategoryID<br>``` |
| [accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#accounts) | ```<br>repeating_invoices.CurrencyCode = accounts.CurrencyCode<br>``` |
| [bank_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#bank-transactions) | ```<br>repeating_invoices.CurrencyCode = bank_transactions.CurrencyCode<br>``` |
| [currencies](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#currencies) | ```<br>repeating_invoices.CurrencyCode = currencies.Code<br>``` |
| [journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#journals) | ```<br>repeating_invoices.LineItems.Tracking.TrackingCategoryID = journals.JournalLines.TrackingCategories.TrackingCategoryID<br>``` |
| [manual_journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#manual-journals) | ```<br>repeating_invoices.LineItems.Tracking.TrackingCategoryID = manual_journals.JournalLines.Tracking.TrackingCategoryID<br>``` |
| [tracking_categories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#tracking-categories) | ```<br>repeating_invoices.LineItems.Tracking.TrackingCategoryID = tracking_categories.TrackingCategoryID<br>``` |

repeating\_invoices table schema

| **BrandingThemeID**<br><br><br>STRING |
| --- |
| **Contact**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br>Contact: OBJECT, which is also a nested data structure.<br><ul><li>AccountNumber: STRING</li><li>AccountsPayableTaxType: STRING</li><li>AccountsReceivableTaxType: STRING</li><li>Addresses: ARRAY, which is also a nested data structure.												<ul><li>AddressLine1: STRING</li><li>AddressLine2: STRING</li><li>AddressLine3: STRING</li><li>AddressLine4: STRING</li><li>AddressType: STRING</li><li>AttentionTo: STRING</li><li>City: STRING</li><li>Country: STRING</li><li>PostalCode: STRING</li><li>Region: STRING</li></ul></li><li>Attachments: ARRAY</li><li>Balances: OBJECT, which is also a nested data structure.												<ul><li>AccountsPayable: OBJECT, which is also a nested data structure.														<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li><li>AccountsReceivable: OBJECT, which is also a nested data structure.														<ul><li>Outstanding: NUMBER</li><li>Overdue: NUMBER</li></ul></li></ul></li><li>BankAccountDetails: STRING</li><li>BatchPayments: OBJECT, which is also a nested data structure.												<ul><li>BankAccountName: STRING</li><li>BankAccountNumber: STRING</li><li>Code: STRING</li><li>Details: STRING</li><li>Reference: STRING</li></ul></li><li>BrandingTheme: OBJECT, which is also a nested data structure.												<ul><li>BrandingThemeID: STRING</li><li>CreatedDateUTC: DARE-TIME</li><li>Name: STRING</li><li>SortOrder: INTEGER</li></ul></li><li>ContactGroups: ARRAY, which is also a nested data structure.												<ul><li>ContactGroupID: STRING</li><li>HasValidationErrors: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li></ul></li><li>ContactID: STRING</li><li>ContactNumber: STRING</li><li>ContactPersons: ARRAY, which is also a nested data structure.												<ul><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>IncludeInEmails: BOOLEAN</li><li>LastName: STRING</li></ul></li><li>ContactStatus: STRING</li><li>DefaultCurrency: STRING</li><li>Discount: NUMBER</li><li>EmailAddress: STRING</li><li>FirstName: STRING</li><li>HasAttachments: BOOLEAN</li><li>HasValidationErrors: BOOLEAN</li><li>IsCustomer: BOOLEAN</li><li>IsSupplier: BOOLEAN</li><li>LastName: STRING</li><li>Name: STRING</li><li>PaymentTerms: OBJECT, which is also a nested data structure.												<ul><li>Bills: OBJECT, which is also a nested data structure.														<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li><li>Sales: OBJECT, which is also a nested data structure.														<ul><li>Day: INTEGER</li><li>Type: STRING</li></ul></li></ul></li><li>Phones: ARRAY, which is also a nested data structure.												<ul><li>PhoneAreaCode: STRING</li><li>PhoneCountryCode: STRING</li><li>PhoneNumber: STRING</li><li>PhoneType: STRING</li></ul></li><li>PurchasesDefaultAccountCode: STRING</li><li>PurchasesTrackingCategories: ARRAY, which is also a nested data structure.												<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.														<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SalesDefaultAccountCode: STRING</li><li>SalesTrackingCategories: ARRAY, which is also a nested data structure.												<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.														<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>SkypeUserName: STRING</li><li>TaxNumber: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingCategoryOption: STRING</li><li>UpdatedDateUTC: DATE-TIME</li><li>ValidationErrors: ARRAY, which is also a nested data structure.												<ul><li>Message: STRING</li></ul></li><li>Website: STRING</li><li>XeroNetworkKey: STRING</li></ul> |
| **CurrencyCode**<br><br><br>STRING |
| **HasAttachments**<br><br><br>BOOLEAN |
| **ID**<br><br><br>STRING |
| **LineAmountTypes**<br><br><br>STRING |
| **LineItems**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>AccountCode: STRING</li><li>Description: STRING</li><li>DiscountRate: NUMBER</li><li>ItemCode: STRING</li><li>LineAmount: NUMBER</li><li>LineItemID: STRING</li><li>Quantity: NUMBER</li><li>TaxAmount: NUMBER</li><li>TaxType: STRING</li><li>Tracking: ARRAY, which is also a nested data structure.											<ul><li>Name: STRING</li><li>Option: STRING</li><li>Options: ARRAY, which is also a nested data structure.													<ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul></li><li>Status: STRING</li><li>TrackingCategoryID: STRING</li><li>TrackingCategoryName: STRING</li><li>TrackingOptionID: STRING</li><li>TrackingOptionName: STRING</li></ul></li><li>UnitAmount: NUMBER</li></ul> |
| **Reference**<br><br><br>STRING |
| **RepeatingInvoiceID**<br><br><br>STRING |
| **Schedule**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>DueDate: INTEGER</li><li>DueDateType: STRING</li><li>EndDate: STRING</li><li>NextScheduledDate: DATE-TIME</li><li>Period: INTEGER</li><li>StartDate: DATE-TIME</li><li>Unit: STRING</li></ul> |
| **Status**<br><br><br>STRING |
| **SubTotal**<br><br><br>NUMBER |
| **Total**<br><br><br>NUMBER |
| **TotalDiscount**<br><br><br>NUMBER |
| **TotalTax**<br><br><br>NUMBER |
| **Type**<br><br><br>STRING |

### tax\_rates

The `tax_rates` table contains info about the tax rates set up in your Xero account.

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | Name |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/tax-rates "Opens in new tab: Xero API method") |

tax\_rates table foreign keys

| Join tax\_rates with | on |
| --- | --- |
| [journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#journals) | ```<br>tax_rates.Name = journals.JournalLines.TaxName<br>``` |

tax\_rates table schema

| **CanApplyToAssets**<br><br><br>BOOLEAN |
| --- |
| **CanApplyToEquity**<br><br><br>BOOLEAN |
| **CanApplyToExpenses**<br><br><br>BOOLEAN |
| **CanApplyToLiabilities**<br><br><br>BOOLEAN |
| **CanApplyToRevenue**<br><br><br>BOOLEAN |
| **DisplayTaxRate**<br><br><br>NUMBER |
| **EffectiveRate**<br><br><br>NUMBER |
| **Name**<br><br><br>STRING |
| **ReportTaxType**<br><br><br>STRING |
| **Status**<br><br><br>STRING |
| **TaxComponents**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>IsCompound: BOOLEAN</li><li>IsNonRecoverable: BOOLEAN</li><li>Name: STRING</li><li>Rate: NUMBER</li></ul> |
| **TaxType**<br><br><br>STRING |

### tracking\_categories

The `tracking_categories` table contains info about the tracking categories in your Xero account. Tracking categories are used to track the performance of different areas of a business.

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | TrackingCategoryID |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/tracking-categories "Opens in new tab: Xero API method") |

tracking\_categories table foreign keys

| Join tracking\_categories with | on |
| --- | --- |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#contacts) | ```<br>tracking_categories.TrackingCategoryID = contacts.SalesTrackingCategories.TrackingCategoryID<br>```<br><br>```<br>tracking_categories.TrackingCategoryID = contacts.PurchasesTrackingCategories.TrackingCategoryID<br>``` |
| [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#credit-notes) | ```<br>tracking_categories.TrackingCategoryID = credit_notes.LineItems.Tracking.TrackingCategoryID<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#invoices) | ```<br>tracking_categories.TrackingCategoryID = invoices.LineItems.Tracking.TrackingCategoryID<br>``` |
| [journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#journals) | ```<br>tracking_categories.TrackingCategoryID = journals.JournalLines.TrackingCategories.TrackingCategoryID<br>``` |
| [manual_journals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#manual-journals) | ```<br>tracking_categories.TrackingCategoryID = manual_journals.JournalLines.Tracking.TrackingCategoryID<br>``` |
| [overpayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#overpayments) | ```<br>tracking_categories.TrackingCategoryID = overpayments.LineItems.Tracking.TrackingCategoryID<br>``` |
| [prepayments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#prepayments) | ```<br>tracking_categories.TrackingCategoryID = prepayments.LineItems.Tracking.TrackingCategoryID<br>``` |
| [purchase_orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#purchase-orders) | ```<br>tracking_categories.TrackingCategoryID = purchase_orders.LineItems.Tracking.TrackingCategoryID<br>``` |
| [receipts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#receipts) | ```<br>tracking_categories.TrackingCategoryID = receipts.LineItems.Tracking.TrackingCategoryID<br>``` |
| [repeating_invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Xero.htm#repeating-invoices) | ```<br>tracking_categories.TrackingCategoryID = repeating_invoices.LineItems.Tracking.TrackingCategoryID<br>``` |

tracking\_categories table schema

| **Name**<br><br><br>STRING |
| --- |
| **Option**<br><br><br>STRING |
| **Options**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>HasValidationErrors: BOOLEAN</li><li>IsActive: BOOLEAN</li><li>IsArchived: BOOLEAN</li><li>IsDeleted: BOOLEAN</li><li>Name: STRING</li><li>Status: STRING</li><li>TrackingOptionID: STRING</li></ul> |
| **Status**<br><br><br>STRING |
| **TrackingCategoryID**<br><br><br>STRING |
| **TrackingCategoryName**<br><br><br>STRING |
| **TrackingOptionID**<br><br><br>STRING |
| **TrackingOptionName**<br><br><br>STRING |

### users

The `users` table contains info about the users in an organisation.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | UserID |
| **Replication Key** | UpdatedDateUTC |
| **Useful links** | [Xero API method](https://developer.xero.com/documentation/api/users "Opens in new tab: Xero API method") |

users table schema

| **EmailAddress**<br><br><br>STRING |
| --- |
| **FirstName**<br><br><br>STRING |
| **IsSubscriber**<br><br><br>BOOLEAN |
| **LastName**<br><br><br>STRING |
| **OrganisationRole**<br><br><br>STRING |
| **UpdatedDateUTC**<br><br><br>DATE-TIME |
| **UserID**<br><br><br>STRING |
| **ValidationErrors**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>Message: STRING</li></ul> |