Tableau Connector for Workday

Build 20.0.7740

AssetBookConfigurations

Element containing Asset Depreciation Schedule data that may be updated by Update Asset Depreciation Schedule operation.

Columns

Name Type References Description
Asset_ID String The primary ID of the asset of this asset depreciation schedule. The value of this field and the asset book reference represent a unique ID that can be used to identify this asset depreciation schedule instance
Asset_Book_Reference_WID String Contains a unique identifier for an instance of an object.
Asset_Book_Reference_Asset_Book_ID String Contains a unique identifier for an instance of an object.
Accounting_Treatment_Reference_WID String Contains a unique identifier for an instance of an object.
Accounting_Treatment_Reference_Accounting_Treatment_ID String Contains a unique identifier for an instance of an object.
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_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_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_Percent Decimal Numeric value representing the depreciation percent for Declining Balance with Switch to Straight Line method. It is required when the depreciation method is declining balance. It left blank, it will be defaulted from the depreciation profile.
Useful_Life_Periods_ Decimal Numeric value representing the useful life (in periods) for the asset depreciation schedule. It is required if the accounting treatment is depreciable capital. If left blank it will be defaulted from the depreciation profile.
Depreciation_Threshold Decimal Depreciation Threshold. Enter only if method is declining balance.
Contract_Start_Date Date Workday uses these dates to update External Contract Start and End date if you manually register the asset but updates the In service Start and End date for all other sources.
Contract_End_Date Date Workday uses these dates to update External Contract Start and End date if you manually register the asset but updates the In service Start and End date for all other sources.
Date_Placed_in_Service Date Date value representing the date this asset depreciation schedule is placed in service. It is required if the depreciation schedule has historical information. It cannot be after depreciation start date and prior to the asset acquisition date.
Bonus_Depreciation_Percent Decimal Numeric value representing bonus depreciation percent for this asset depreciation schedule. Value cannot be more than 100.
Max_Bonus_Depreciable_Basis Decimal Numeric value representing the maximum bonus depreciation basis. Workday would use the lesser of this field and asset cost that is applicable to bonus depreciation to calculated the bonus amount.
Depreciation_Start_Date Date For converted assets, the depreciation start date represents the date that depreciation starts in Workday. For converted assets with historical accumulated depreciation, the depreciation start date should be 1 day greater than the date up to which the historical accumulated depreciation is calculated. The date cannot be prior to the acquisition date. For converted assets with no historical accumulated depreciation, leave the depreciation start date blank so that Workday can determine the correct date.
Remaining_Depreciation_Periods Decimal Numeric value for remaining depreciation periods if entering accumulated depreciation from a prior system and depreciation start date. Workday will generate depreciation entries for this schedule for the number of remaining periods.
Accumulated_Depreciation Decimal Numeric value representing historical accumulated depreciation as of a day prior to depreciation start date. This value cannot be greater than historical cost minus historical residual value. Workday uses this accumulated depreciation value to determine depreciable cost basis to generate the depreciation schedule for remaining useful life starting from depreciation start date.
Year_to_Date_Depreciation Decimal Numeric value representing year-to-date depreciation as of a day period to depreciation start date. This field is required if the asset depreciation schedule has historical information and the depreciation method is either declining balance or sum of years digits. The value of this field cannot be greater than historical accumulated depreciation.
Historical_Bonus_Depreciation Decimal Numeric value representing historical bonus depreciation amount. This field is required if the depreciation schedule has historical information and bonus depreciation percent is populated, else it should be left empty. The value of this field cannot be greater than accumulated depreciation.
Asset_Book_Configuration_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Asset_Book_Configuration_Status_Reference_Document_Status_ID String Contains a unique identifier for an instance of an object.
Historical_Cost_Balance Decimal A numeric value that represents historical cost balance for depreciation schedule. Historical cost are those transactions with transaction effective date prior to depreciation start date.
Company_Reference_WID String Contains a unique identifier for an instance of an object.
Company_Reference_Company_Reference_ID String Contains a unique identifier for an instance of an object.
Company_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Asset_Name String The name of the asset.
Spend_Category_Reference_WID String Contains a unique identifier for an instance of an object.
Spend_Category_Reference_Spend_Category_ID String Contains a unique identifier for an instance of an object.
Asset_Class_Reference_WID String Contains a unique identifier for an instance of an object.
Asset_Class_Reference_Asset_Class_Reference_ID String Contains a unique identifier for an instance of an object.
Asset_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Asset_Type_Reference_Asset_Type_Reference_ID String Contains a unique identifier for an instance of an object.
Location_Reference_WID String Contains a unique identifier for an instance of an object.
Location_Reference_Location_ID String Contains a unique identifier for an instance of an object.
Acquisition_Method_Reference_WID String Contains a unique identifier for an instance of an object.
Acquisition_Method_Reference_Acquisition_Method_ID String Contains a unique identifier for an instance of an object.
Date_Acquired Date The date the asset was acquired, or the transaction effective date of the acquisition.
First_Issue_Date Date The date the asset was first issued to a worker

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