Tables
The cmdlet models the data in Xero as a list of tables in a relational database that can be queried using standard SQL statements.
CData Cmdlets PowerShell Module 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. |