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