Tableau Connector for Workday

Build 20.0.7740

Assets_Depreciation_Data

Contains information about this asset related to depreciation.

Columns

Name Type References Description
Asset_Asset_Reference_WID String

Assets.Asset_Reference_WID

The unique identifier type. Each
Depreciation_Profile_Reference_WID String Contains a unique identifier for an instance of an object.
Depreciation_Profile_Reference_Depreciation_Profile_ID String Contains a unique identifier for an instance of an object.
Depreciation_Method_Reference_WID String Contains a unique identifier for an instance of an object.
Depreciation_Method_Reference_Depreciation_Method_ID String Contains a unique identifier for an instance of an object.
Depreciation_Posting_Frequency_Reference_WID String Contains a unique identifier for an instance of an object.
Depreciation_Posting_Frequency_Reference_Depreciation_Posting_Frequency_ID String Contains a unique identifier for an instance of an object.
Depreciation_Convention_Reference_WID String Contains a unique identifier for an instance of an object.
Depreciation_Convention_Reference_Depreciation_Convention_ID String Contains a unique identifier for an instance of an object.
Depreciation_Start_Based_On_Reference_WID String Contains a unique identifier for an instance of an object.
Depreciation_Start_Based_On_Reference_Depreciation_Start_Based_On_ID String Contains a unique identifier for an instance of an object.
Depreciation_Rate_Basis_Reference_WID String Contains a unique identifier for an instance of an object.
Depreciation_Rate_Basis_Reference_Depreciation_Rate_Basis_ID String Contains a unique identifier for an instance of an object.
Depreciation_Start_Date Date The date depreciation started for this asset.
Useful_Life Decimal The useful life, in periods, for this asset.
Depreciation_Percent Decimal The depreciation percent for this asset.
Depreciation_Threshold Decimal The depreciation threshold for this asset.
Depreciation_Start_Date_At_Registration Date The deprecation start date as indicated for a converted asset when it was registered.
Accumulated_Depreciation_At_Registration Decimal The accumulated depreication as indicated for a converted asset when it was registered.
Remaining_Useful_Life_At_Registration Decimal The remaining useful life as indicated for a converted asset when it was registered.
Max_Bonus_Depreciable_Basis Decimal The maximum allowable bonus depreciation that can be taken for a particular asset, i.e. the upper limit for depreciation.
Bonus_Depreciation_Percent Decimal The percentage that will be used to calculate the depreciable basis for bonus depreciation.
Historical_Bonus_Depreciation_for_Depreciation_Schedule Decimal The total amount of bonus depreciation recorded for the asset.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7740