Assets
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
Last updated