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 |
| Assets | Stores and manages asset records within Xero. It enables querying, inserting, and updating asset data, such as purchase price, asset type, depreciation settings, and more. |
| AssetTypes | Defines asset types in Xero. It enables querying, inserting, and updating different asset categories used in asset management, such as vehicles, property, and equipment. |