Tables
The add-in models the data in Xero as a list of tables in a relational database that can be queried using standard SQL statements.
CData Excel Add-In for Xero Tables
| Name | Description |
| Accounts | Query, insert, update and delete accounts for a Xero organisation. |
| BankTransactions | Query, insert and update bank transactions for a Xero organisation. |
| BankTransfers | Usage information for the operation BankTransfers.rsd. |
| BatchPayments | Query and insert BatchPayments for a Xero organisation. |
| ContactGroups | Query, insert, update and delete contact groups for a Xero organisation. |
| Contacts | Query, insert and update contacts for a Xero organisation. |
| CreditNotes | Query, insert and update credit notes for a Xero organisation. |
| Employees | Query, insert and update employees for a Xero organisation. |
| ExpenseClaims | Query, insert and update expense claims for a Xero organisation. |
| HistoryBankTransactions | Query and insert BankTransaction history and notes for a Xero organization. |
| HistoryBatchPayments | Query and insert BatchPayment history and notes for a Xero organization. |
| HistoryContacts | Query and insert Contact history and notes for a Xero organization. |
| HistoryCreditNotes | Query and insert CreditNote history and notes for a Xero organization. |
| HistoryInvoices | Query and insert Invoice history and notes for a Xero organization. |
| HistoryPurchaseOrders | Query and insert PurchaseOrder history and notes for a Xero organization. |
| Invoices | Query, insert and update Invoices for a Xero organisation. |
| Items | Query, insert, update and delete items for a Xero organisation. |
| LinkedTransactions | Query, insert, update and delete LinkedTransactions for a Xero organisation. |
| ManualJournals | Query, insert and update manual journals for a Xero organisation. |
| Payments | Query, insert and delete payments for a Xero organisation. |
| PurchaseOrders | Query, insert and update purchase orders for a Xero organisation. |
| Quotes | Query quotes for a Xero organization |
| Receipts | Query, insert and update receipts for a Xero organisation. |
| TaxRates | Usage information for the operation TaxRates.rsd. |