Fixed Assets Data Model
API limitations and requirements are documented in this section; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.
Tables
The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your Xero account.
The tables include:
| Table | 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. |
| Settings | Provides access to asset-related settings within Xero, including default asset settings for the organization. It helps with configuring asset management preferences. |
| Tenants | Queries the list of organizations (tenants) connected to your Xero account. It provides basic details about each organization, including ID and status, for asset management. |
API limitations and requirements are documented in each table.
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard create, read, update, delete (CRUD) operations, including managing OAuth tokens.