Tableau Connector for Workday

Build 20.0.7740

Assets_Acquisition_Data

Contains data related to the acquisition or creation of the asset. This includes the date, method, initial cost, and source information.

Columns

Name Type References Description
Asset_Asset_Reference_WID String

Assets.Asset_Reference_WID

The unique identifier type. Each
Acquisition_Cost Decimal The initial cost when the asset was acquired.
Acquisition_Date Date The date the asset was acquired, or the transaction effective date of the acquisition.
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.
PO_Number String If this asset was created from a Purchase order, this is the PO Number for that Purchase Order.
Receipt_Number String If this asset was created from a Receipt, this is the Receipt number the asset was created from.
Supplier_Invoice_Number String If this asset was created from a Supplier Invoice, this is the Supplier Invoice Number the asset was created from.
Residual_Value_At_Acquisition Decimal The residual value at the time of acquisition.
Supplier_Invoice_Line_Reference String If this asset was created from a Supplier Invoice, this is a reference to the corresponding Supplier Invoice Line.
Receipt_Line_Reference_IID String Contains a unique identifier for an instance of an object.
Receipt_Line_Reference_WID String Contains a unique identifier for an instance of an object.
Transfer_From_Business_Asset_Reference_WID String Contains a unique identifier for an instance of an object.
Transfer_From_Business_Asset_Reference_Asset_ID String Contains a unique identifier for an instance of an object.
Transfer_From_Business_Asset_Reference_Asset_Reference_ID String Contains a unique identifier for an instance of an object.
Worktag_Reference String The worktags specified on the initial acquisition transaction.
Memo String Memo from manual registration.
Project_Number String Project number for the business asset.
External_Contract_Number String External Contract Number from manual registration.
Lease_Accounting_Method_Reference_WID String Contains a unique identifier for an instance of an object.
Lease_Accounting_Method_Reference_Accounting_Method_ID String Contains a unique identifier for an instance of an object.
Supplier_Contract_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Supplier_Contract_Type_Reference_Supplier_Contract_Type_ID String Contains a unique identifier for an instance of an object.
External_Contract_Start_Date Date External Contract Start Date from manual registration.
External_Contract_End_Date Date External Contract End Date from manual registration.

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