This data object is used to display all fixed asset file information from the Fusion business system.

This information is found within the Fixed Assets File program within the Fusion business system.

URL

/frw/FixedAssets

Field Details…

SQL Field Name Column Description
AccumulatedDepreciation This field displays the accumulated depreciation of a given asset.
AcquisitionCost This field displays the cost of acquiring a given asset.
AcquisitionDate This field displays the date on which an asset was acquired.
AddDate This field displays the date on which a fixed asset was added.
AddUser This field displays the user name that added the record.
AllocationName This field displays the allocation tied to a fixed asset.
Asset This field displays the name and/or number attached to a given asset.
BookBranch This field displays the book branch tied to a given asset.
Category This field displays the category to which an asset is assigned.
CurrentValue This field displays the current value of a given asset.
Description This field displays the description of a given asset.
DisposalDate This field displays the date on which an asset was disposed of.
DisposalValue This field displays the value of an asset at the time in which it was disposed of.
EstimatedLifeDate This field displays the estimated ending life date of an asset.
EstimatedLifeMos This field displays the estimated life, in months, of a given asset.
ExtendAssetLife This field displays whether or not an asset’s life has been extended.
InServiceDate This field displays the date on which an asset went into service.
LastUpdate This field displays the date on which an A/P invoice was last updated.
UpdateUser This field displays the user name of the individual who made the update.
LocationBranch This field displays the location branch of a given asset.
Method This field displays the depreciation method for a given fixed asset.
MfgSerialNumber This field displays the manufacturer’s serial number attached to an asset.
MinRemainLifeMonths This field displays the remaining life, expressed in months, of a given asset.
MonthlyDepreciation This field displays the depreciation of an asset, broken down by month.
PostDate This field displays the date on which appreciation was posted for a fixed asset.
PostingPeriod This field displays the posting period that was used to depreciate a fixed asset.
RemainLifeMonths This field displays the remaining life, in months, of a given asset.
ResidualValue This field displays the estimated value of an asset at the end of its life.
Type This field displays the classification of an asset.
UsedLifeMonths This field displays the used life, expressed in months, of a given unit.
YTDDepreciation This field displays the total depreciation of the asset so far this year.