Views
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
CData JDBC Driver for Xero Views
| Name | Description |
| AgedPayablesByContact | Query Aged Payables for a Contact. |
| AgedReceivablesByContact | Query Aged Receivables for a Contact. |
| BalanceSheet | Query a monthly Balance Sheet. |
| BankStatement | Query the transactions listed on the account. |
| BankSummary | Query the balances and cash movements for each bank account. |
| BrandingThemes | Query the Branding Themes defined for the Xero organisation. |
| BudgetLines | Query Budget line items for a Xero organisation |
| Budgets | Query Budgets for a Xero organisation |
| BudgetSummary | Query a monthly Budget Summary. |
| ContactCISSettings | Query CIS settings for contacts in a Xero organisation. |
| CreditNoteAllocations | Query credit note allocations for a Xero organisation. |
| Currencies | Query the Currencies for a Xero organisation. |
| ExecutiveSummary | Query a summary of changes between a month and the previous month |
| ExpenseClaimPayments | Query payments for a Xero organisation. |
| ExpenseClaimReceipts | Query claimed receipts for a Xero organisation. |
| HistoryBankTransfers | Query BankTransfer history and notes for a Xero organization. |
| HistoryExpenseClaims | Query ExpenseClaim history and notes for a Xero organization. |
| HistoryItems | Query Item history and notes for a Xero organization. |
| HistoryOverpayments | Query Overpayment history and notes for a Xero organization. |
| HistoryPayments | Query Payment history and notes for a Xero organization. |
| HistoryPrepayments | Query Prepayment history and notes for a Xero organization. |
| HistoryReceipts | Query Receipt history and notes for a Xero organization. |
| HistoryRepeatingInvoices | Query RepeatingInvoice history and notes for a Xero organization. |
| Journals | Query the line items in journals for a Xero organisation. |
| Organisation | Query organisation data for a Xero organisation. |
| OrganisationActions | Query organisation data for a Xero organisation. |
| OverpaymentAllocations | Query overpayment allocations for a Xero organisation. |
| Overpayments | Query Overpayments for a Xero organisation. |
| PrepaymentAllocations | Query prepayment allocations for a Xero organisation. |
| Prepayments | Query Prepayments for a Xero organisation. |
| ProfitAndLoss | Query a Profit and Loss report over a date range. |
| Quotes | Query quotes for a Xero organization |
| RepeatingInvoices | Query Repeating Invoice templates. |
| Tenants | Query the list of organizations connected to your Xero account. |
| TrackingCategories | Query Tracking Categories for a Xero organisation. |
| TrialBalance | Query a monthly Trial Balance. |
| Users | Query users for a Xero organisation. |