Tables

The connector models the data in Xero as a list of tables in a relational database that can be queried using standard SQL statements.

CData Python Connector for Xero Tables


Name	Description
Accounts	Allows for the querying, insertion, updating, and deletion of accounts for a Xero organization. Accounts represent the various financial categories used to track and record the organization's financial transactions, such as assets, liabilities, and equity.
BankTransactions	Queries, inserts, and updates bank transactions within Xero. Bank transactions include deposits, withdrawals, and other activities that affect the cash accounts of the organization.
BankTransfers	Manages bank transfer records. It allows for querying and editing transfers between accounts, helping track money movements between different bank accounts.
BatchPayments	Queries and inserts batch payments in Xero. Batch payments group multiple payments together, making it easier to process large sets of payments to vendors or suppliers.
ContactGroups	Allows for the querying, insertion, updating, and deletion of contact groups. Contact groups enable the categorization of contacts into different segments for easier management and reporting.
Contacts	Used for querying, inserting, and updating contact records within a Xero organization. Contacts include customers, suppliers, and other entities that the organization interacts with for business transactions.
CreditNotes	Used to query, insert, and update credit notes for a Xero organization. Credit notes are used to adjust invoices, typically in cases of overpayment, returns, or errors.
Employees	Used for querying, inserting, and updating employee records within a Xero organization. Employees are individuals working for the organization and their data includes payroll, tax, and employment information.
ExpenseClaims	Used for querying, inserting, and updating expense claims. Expense claims are submitted by employees or contractors for reimbursement of business-related expenses.
HistoryBankTransactions	Used for querying and inserting the history and notes of bank transactions. This helps maintain historical records of financial activity within Xero.
HistoryBatchPayments	Used to query and insert history and notes of batch payments. This helps track historical data on bulk payments made to vendors or suppliers.
HistoryContacts	Queries and maintains the history and notes of contact records. It helps keep track of all actions and updates related to contacts within the Xero organization.
HistoryCreditNotes	Records the history and notes of credit notes issued within Xero. This is used for auditing purposes and tracking past credit note activities.
HistoryInvoices	Used to query and insert the history of invoices issued within a Xero organization. It records all changes made to invoices over time.
HistoryPurchaseOrders	Used to query and insert the history and notes of purchase orders within Xero. This helps track the lifecycle of purchase orders.
Invoices	Used to query, insert, and update invoices within Xero. Invoices are sent to customers for payment for goods or services provided.
Items	Manages items in Xero. Items can be products, services, or other billable units used in transactions.
LinkedTransactions	Used to manage linked transactions, allowing users to associate related transactions in Xero for better tracking and reporting.
ManualJournals	Used to query, insert, and update manual journals. Manual journals are used to record financial transactions that don't follow standard processes.
Payments	Used to query, insert, and delete payment records within Xero. Payments include transactions made to suppliers or received from customers.
PurchaseOrders	Used to query, insert, and update purchase orders in Xero. Purchase orders are used to track items or services that the organization intends to buy from suppliers.
Quotes	Allows querying and managing quotes for a Xero organization. Quotes are used to provide potential customers with a detailed offer of goods or services at specified prices before an order is placed.
Receipts	Enables querying, inserting, and updating receipts for a Xero organization. Receipts confirm that payments have been made, and they help track money received by the organization.
TaxRates	Manages tax rates in Xero. It allows you to query, insert, and update tax rates, which are necessary for calculating tax liabilities on sales and purchases.