Assets
Query, insert and update assets for a Xero organization.
Table-Specific Information
Creating Assets
An asset can be created with only an AssetName and an AssetNumber. This will create a draft asset with blank settings for purchase date and price, serial number and all other values.
INSERT INTO Assets (AssetName, AssetNumber) VALUES ('Corporate van', 'FA-0042')
Updating Assets
Like asset types, an asset's value can be measured with either a depreciation rate or an estimated lifetime. Once these values have been set, you can only change between the two by setting the other to null:UPDATE Assets SET BookDepreciationSetting_DepreciationRate = 0.12, BookDepreciationSetting_EffectiveLifeYears = null WHERE AssetId = '46c7f1f4-7cdb-47d3-8772-2796d0b83e87'
Registering Assets
To move an asset from the draft to the registered state, you must assign these properties on it:
- AssetTypeId
- PurchaseDate
- PurchasePrice
- BookDepreciationSetting_DepreciationStartDate
- BookDepreciationSetting_AveragingMethod
- Either a BookDepreciationSetting_DepreciationRate or a BookDepreciationSetting_EffectiveLifeYears
Then you can update the AssetStatus field to the value "Registered".
Disposing Assets
Disposing of assets is not supported through the API.
Columns
Name | Type | ReadOnly | Description |
AssetId [KEY] | String | True |
The unique Xero-generated ID of the asset |
AssetName | String | False |
The name of the asset |
AssetNumber | String | False |
A unique code for the asset |
AssetStatus | String | False |
Either DRAFT, REGISTERED or DISPOSED |
Description | String | False |
Free-form comments on the asset |
PurchaseDate | Date | False |
When the asset was purchased |
PurchasePrice | Decimal | False |
How much asset cost when it was purchased |
DisposalDate | Date | False |
When the asset was purchased |
DisposalPrice | Decimal | False |
What price the asset was disposed at |
WarrantyExpiryDate | Date | False |
When the asset's warranty expires |
SerialNumber | String | False |
The asset's serial number |
AssetTypeId | String | False |
The Id of the type of this asset |
BookDepreciationSetting_DepreciationMethod | String | False |
Either NoDepreciation, StraightLine, DiminishingValue100, DiminishingValue150, DiminishingValue200 or FullDepreciation |
BookDepreciationSetting_AveragingMethod | String | False |
Either ActualDays or FullMonth |
BookDepreciationSetting_DepreciationRate | Double | False |
The rate of depreciation in percent |
BookDepreciationSetting_EffectiveLifeYears | Int | False |
The effective life of the asset in years |
BookDepreciationSetting_DepreciationCalculationMethod | String | False |
Either Rate, Life or None |
BookDepreciationDetail_CurrentCapitalGain | Decimal | False |
Once the asset is disposed, this will be the sell price minus the purchase price |
BookDepreciationDetail_CurrentGainLoss | Decimal | False |
Once the asset is disposed, this will be the minimum of the sell and purchase price, minus the current book value |
BookDepreciationDetail_DepreciationStartDate | Date | False |
When the depreciation takes effect |
BookDepreciationDetail_CostLimit | Decimal | False |
The value of the asset to be depreciated, if this is less than the cost |
BookDepreciationDetail_ResidualValue | Decimal | False |
The value of the asset once it's been fully depreciated |
BookDepreciationDetail_PriorAccumDepreciationAmount | Decimal | False |
All depreciation prior to the current fiscal year |
BookDepreciationDetail_CurrentAccumDepreciationAmount | Decimal | False |
All depreciation occurring in the current financial year |
CanRollBack | Boolean | True |
Whether the asset's depreciation can be rolled back |
AccountingBookValue | Decimal | True |
The accounting value of the asset |
TenantId | String | False |
The ID of the tenant to query instead of the connection tenant |