# Schema Information

## Tables/APIs 

The following is the list of tables or APIs associated with the Xero v2 connector:

1. [Accounts](#accounts)
2. [Bank\_Transfer](#bank_transfers)
3. [Bank\_Transactions](#bank_transactions)
4. [Contacts](#contacts)
5. [ContactGroups](#contact_groups)
6. [Employees](#employees)
7. [Invoices](#invoices)
8. [Currencies](#currencies)
9. [CreditNotes](#creditnotes)

### Xero Data

#### **Accounts**

This API retrieves the full chart of accounts. For more information, see [Accounts](https://developer.xero.com/documentation/api/accounting/accounts)

**Fields**

| Field Name              | Data Type |
| ----------------------- | --------- |
| AccountID               | STRING    |
| Code                    | STRING    |
| Name                    | STRING    |
| Status                  | STRING    |
| Type                    | STRING    |
| TaxType                 | STRING    |
| Class                   | STRING    |
| EnablePaymentsToAccount | BOOLEAN   |
| ShowInExpenseClaims     | BOOLEAN   |
| BankAccountNumber       | STRING    |
| BankAccountType         | STRING    |
| CurrencyCode            | STRING    |
| ReportingCode           | STRING    |
| ReportingCodeName       | STRING    |
| HasAttachments          | BOOLEAN   |
| UpdatedDateUTC          | STRING    |
| AddToWatchlist          | BOOLEAN   |
| Description             | STRING    |
| SystemAccount           | STRING    |

#### **Bank\_Transfers**

This API returns a list of all the bank transfers. For more information, see [Bank Transfer](https://developer.xero.com/documentation/api/accounting/banktransfers)

**Fields**

| Field Name                | Data Type |
| ------------------------- | --------- |
| BankTransferID            | STRING    |
| CreatedDateUTCString      | DATETIME  |
| CreatedDateUTC            | STRING    |
| DateString                | DATETIME  |
| Date                      | STRING    |
| FromBankAccount           | RECORD    |
| ToBankAccount             | RECORD    |
| Amount                    | STRING    |
| FromBankTransactionID     | STRING    |
| ToBankTransactionID       | STRING    |
| FromIsReconciled          | STRING    |
| ToIsReconciled            | STRING    |
| Reference                 | STRING    |
| FromBankAccount.AccountID | STRING    |
| FromBankAccount.Name      | STRING    |
| ToBankAccount.AccountID   | STRING    |
| ToBankAccount.Name        | STRING    |

#### **Bank\_Transactions**

This API returns history of any spend or receive money transactions. For more information, see [Bank Transactions](https://developer.xero.com/documentation/api/banktransactions)

**Fields**

| Field Name                  | Data Type |
| --------------------------- | --------- |
| BankTransactionID           | STRING    |
| BankAccount                 | RECORD    |
| Type                        | STRING    |
| Reference                   | STRING    |
| IsReconciled                | BOOLEAN   |
| HasAttachments              | BOOLEAN   |
| Contact                     | RECORD    |
| DateString                  | DATETIME  |
| Date                        | STRING    |
| Status                      | STRING    |
| LineAmountTypes             | STRING    |
| SubTotal                    | NUMERIC   |
| TotalTax                    | NUMERIC   |
| Total                       | NUMERIC   |
| UpdatedDateUTC              | STRING    |
| CurrencyCode                | STRING    |
| BankAccount.AccountID       | STRING    |
| BankAccount.Code            | STRING    |
| BankAccount.Name            | STRING    |
| Contact.ContactID           | STRING    |
| Contact.Name                | STRING    |
| Contact.HasValidationErrors | BOOLEAN   |

#### **Contacts**

This API returns a list of all the contacts. For more information. see [Contacts](https://developer.xero.com/documentation/api/contacts)

**Fields**

| Field Name                              | Data Type |
| --------------------------------------- | --------- |
| ContactID                               | STRING    |
| ContactStatus                           | STRING    |
| Name                                    | STRING    |
| Addresses                               | RECORD    |
| Phones                                  | RECORD    |
| UpdatedDateUTC                          | STRING    |
| IsSupplier                              | BOOLEAN   |
| IsCustomer                              | BOOLEAN   |
| HasAttachments                          | BOOLEAN   |
| HasValidationErrors                     | BOOLEAN   |
| Balances                                | RECORD    |
| ContactNumber                           | STRING    |
| FirstName                               | STRING    |
| LastName                                | STRING    |
| EmailAddress                            | STRING    |
| BankAccountDetails                      | STRING    |
| DefaultCurrency                         | STRING    |
| BatchPayments                           | RECORD    |
| ContactGroups                           | RECORD    |
| BrandingTheme                           | RECORD    |
| TaxNumber                               | STRING    |
| AccountsReceivableTaxType               | STRING    |
| AccountsPayableTaxType                  | STRING    |
| Addresses.AddressType                   | STRING    |
| Addresses.City                          | STRING    |
| Addresses.Region                        | STRING    |
| Addresses.PostalCode                    | STRING    |
| Addresses.Country                       | STRING    |
| Addresses.AttentionTo                   | STRING    |
| Addresses.AddressLine1                  | STRING    |
| Addresses.AddressLine2                  | STRING    |
| Addresses.AddressLine3                  | STRING    |
| Addresses.AddressLine4                  | STRING    |
| Phones.PhoneType                        | STRING    |
| Phones.PhoneNumber                      | STRING    |
| Phones.PhoneAreaCode                    | STRING    |
| Phones.PhoneCountryCode                 | STRING    |
| Balances.AccountsReceivable             | RECORD    |
| Balances.AccountsReceivable.Outstanding | NUMERIC   |
| Balances.AccountsReceivable.Overdue     | NUMERIC   |
| Balances.AccountsPayable                | RECORD    |
| Balances.AccountsPayable.Outstanding    | NUMERIC   |
| Balances.AccountsPayable.Overdue        | NUMERIC   |
| BatchPayments.BankAccountNumber         | STRING    |
| BatchPayments.BankAccountName           | STRING    |
| BatchPayments.Details                   | STRING    |
| BatchPayments.Code                      | STRING    |
| BatchPayments.Reference                 | STRING    |
| ContactGroups.ContactGroupID            | STRING    |
| ContactGroups.Name                      | STRING    |
| ContactGroups.Status                    | STRING    |
| ContactGroups.HasValidationErrors       | BOOLEAN   |
| BrandingTheme.BrandingThemeID           | STRING    |
| BrandingTheme.Name                      | STRING    |

#### **Contact\_Groups**

This API returns a list of all the Contact groups. For more information, see [Conact Groups](https://developer.xero.com/documentation/api/contactgroups)

**Fields**

| Field Name          | Data Type |
| ------------------- | --------- |
| ContactGroupID      | STRING    |
| Name                | STRING    |
| Status              | STRING    |
| HasValidationErrors | BOOLEAN   |

#### **Employees**

This API returns a list of all the employees. For more information, see [Employees](https://developer.xero.com/documentation/api/employees)

**Fields**

| Field Name               | Data Type |
| ------------------------ | --------- |
| EmployeeID               | STRING    |
| Status                   | STRING    |
| FirstName                | STRING    |
| LastName                 | STRING    |
| ExternalLink             | RECORD    |
| UpdatedDateUTC           | STRING    |
| ExternalLink.Url         | STRING    |
| ExternalLink.Description | STRING    |

#### **Invoices**

This API Returns a list of all the Invoices. For more information, see [invoices](https://developer.xero.com/documentation/api/invoices)

**Fields**

| Field Name                  | Data Type |
| --------------------------- | --------- |
| Type                        | STRING    |
| InvoiceID                   | STRING    |
| InvoiceNumber               | STRING    |
| Reference                   | STRING    |
| AmountDue                   | NUMERIC   |
| AmountPaid                  | NUMERIC   |
| AmountCredited              | NUMERIC   |
| CurrencyRate                | NUMERIC   |
| IsDiscounted                | BOOLEAN   |
| HasAttachments              | BOOLEAN   |
| HasErrors                   | BOOLEAN   |
| Contact                     | RECORD    |
| DateString                  | DATETIME  |
| Date                        | STRING    |
| DueDateString               | DATETIME  |
| DueDate                     | STRING    |
| BrandingThemeID             | STRING    |
| Status                      | STRING    |
| LineAmountTypes             | STRING    |
| SubTotal                    | NUMERIC   |
| TotalTax                    | NUMERIC   |
| Total                       | NUMERIC   |
| UpdatedDateUTC              | STRING    |
| CurrencyCode                | STRING    |
| LineItems                   | RECORD    |
| Url                         | STRING    |
| Contact.ContactID           | STRING    |
| Contact.Name                | STRING    |
| Contact.HasValidationErrors | BOOLEAN   |
| Contact.ContactNumber       | STRING    |
| LineItems.Description       | STRING    |
| LineItems.UnitAmount        | NUMERIC   |
| LineItems.TaxType           | STRING    |
| LineItems.TaxAmount         | NUMERIC   |
| LineItems.LineAmount        | NUMERIC   |
| LineItems.AccountCode       | STRING    |
| LineItems.Quantity          | NUMERIC   |
| LineItems.LineItemID        | STRING    |
| LineItems.AccountID         | STRING    |

#### **Currencies**

This API returns the list of all the currencies. For more information, see [currencies](https://developer.xero.com/documentation/api/currencies)

**Fields**

| Field Name  | Data Type |
| ----------- | --------- |
| Code        | STRING    |
| Description | STRING    |

#### **CreditNotes**

This API retrieves the list of all the Credit notes. For more information, see [Credit Notes](https://developer.xero.com/documentation/api/credit-notes)

**Fields**

| Field Name                        | Data Type |
| --------------------------------- | --------- |
| CreditNoteID                      | STRING    |
| CreditNoteNumber                  | STRING    |
| ID                                | STRING    |
| HasErrors                         | BOOLEAN   |
| Type                              | STRING    |
| Reference                         | STRING    |
| RemainingCredit                   | NUMERIC   |
| Allocations                       | RECORD    |
| HasAttachments                    | BOOLEAN   |
| Contact                           | RECORD    |
| DateString                        | DATETIME  |
| Date                              | STRING    |
| Status                            | STRING    |
| LineAmountTypes                   | STRING    |
| SubTotal                          | NUMERIC   |
| TotalTax                          | NUMERIC   |
| Total                             | NUMERIC   |
| UpdatedDateUTC                    | STRING    |
| CurrencyCode                      | STRING    |
| FullyPaidOnDate                   | STRING    |
| Allocations.AllocationID          | STRING    |
| Allocations.Amount                | NUMERIC   |
| Allocations.Date                  | STRING    |
| Allocations.Invoice               | RECORD    |
| Allocations.Invoice.InvoiceID     | STRING    |
| Allocations.Invoice.InvoiceNumber | STRING    |
| Allocations.Invoice.IsDiscounted  | BOOLEAN   |
| Allocations.Invoice.HasErrors     | BOOLEAN   |
| Contact.ContactID                 | STRING    |
| Contact.Name                      | STRING    |
| Contact.HasValidationErrors       | BOOLEAN   |