Tableau Connector for Workday

Build 20.0.7740

AllocationDefinitions

Contains the detailed information about an Allocation Definition.

Columns

Name Type References Description
Allocation_Definition_Reference_WID String Contains a unique identifier for an instance of an object.
Allocation_Definition_Reference_Allocation_Definition_ID String Contains a unique identifier for an instance of an object.
Allocation_Definition_ID String The ID for the Allocation Definition.
Allocation_Definition_Name String Text attribute identifying Allocation Definition Name.
Account_Set_Reference_WID String Contains a unique identifier for an instance of an object.
Account_Set_Reference_Account_Set_ID String Contains a unique identifier for an instance of an object.
Fiscal_Schedule_Reference_WID String Contains a unique identifier for an instance of an object.
Fiscal_Schedule_Reference_Fiscal_Schedule_ID String Contains a unique identifier for an instance of an object.
Currency_Rate_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Currency_Rate_Type_Reference_Currency_Rate_Type_ID String Contains a unique identifier for an instance of an object.
Used_by_Organization_Reference String Reference to an existing Organization(s) that can use this allocation definition.
Create_Reversal Bool When this flag is set to true, it creates a corresponding reversal journal for this allocation.
Balancing_Worktag_Reference_WID String Contains a unique identifier for an instance of an object.
Balancing_Worktag_Reference_Business_Unit_ID String Contains a unique identifier for an instance of an object.
Balancing_Worktag_Reference_Cost_Center_Reference_ID String Contains a unique identifier for an instance of an object.
Balancing_Worktag_Reference_Custom_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Balancing_Worktag_Reference_Fund_ID String Contains a unique identifier for an instance of an object.
Balancing_Worktag_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Balancing_Worktag_Reference_Region_Reference_ID String Contains a unique identifier for an instance of an object.
Optional_Balancing_Worktag_Reference String Reference to an existing Optional Anchor Balancing Worktag to balance the generated Journal per Optional Balancing Worktag.
Inactive Bool A flag to determine if this Allocation Definition is active or not.
Allocation_Reference_Text String Text that identifies any applicable reference information for this allocation definition
Source_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Source_Type_Reference_Source_Type_ID String Contains a unique identifier for an instance of an object.
Source_Allocation_Percent Decimal The percentage value used to allocate portion of the source funds.
Currency_Reference_WID String Contains a unique identifier for an instance of an object.
Currency_Reference_Currency_ID String Contains a unique identifier for an instance of an object.
Currency_Reference_Currency_Numeric_Code String Contains a unique identifier for an instance of an object.
Fixed_Amount Decimal Amount to be allocated
Ledger_or_Budget_Structure_for_Source_Reference_WID String Contains a unique identifier for an instance of an object.
Ledger_or_Budget_Structure_for_Source_Reference_Budget_Structure_ID String Contains a unique identifier for an instance of an object.
Ledger_or_Budget_Structure_for_Source_Reference_Ledger_Type_ID String Contains a unique identifier for an instance of an object.
Source_Book_Code_Reference_WID String Contains a unique identifier for an instance of an object.
Source_Book_Code_Reference_Book_Code_ID String Contains a unique identifier for an instance of an object.
Source_Condition_Rule_Reference_WID String Contains a unique identifier for an instance of an object.
Source_Condition_Rule_Reference_Condition_Rule_ID String Contains a unique identifier for an instance of an object.
Source_Condition_Rule_Reference_WCP_Component_ID String Contains a unique identifier for an instance of an object.
Ledger_or_Budget_Structure_for_Basis_Reference_WID String Contains a unique identifier for an instance of an object.
Ledger_or_Budget_Structure_for_Basis_Reference_Budget_Structure_ID String Contains a unique identifier for an instance of an object.
Ledger_or_Budget_Structure_for_Basis_Reference_Ledger_Type_ID String Contains a unique identifier for an instance of an object.
Basis_Allocation_Method_Reference_WID String Contains a unique identifier for an instance of an object.
Basis_Allocation_Method_Reference_Allocation_Method_ID String Contains a unique identifier for an instance of an object.
Basis_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Basis_Type_Reference_Allocation_Basis_Type_ID String Contains a unique identifier for an instance of an object.
Translation_Currency_Reference_WID String Contains a unique identifier for an instance of an object.
Translation_Currency_Reference_Currency_ID String Contains a unique identifier for an instance of an object.
Translation_Currency_Reference_Currency_Numeric_Code String Contains a unique identifier for an instance of an object.
Account_Translation_Rule_Set_Reference_WID String Contains a unique identifier for an instance of an object.
Account_Translation_Rule_Set_Reference_Account_Translation_Rule_Set_ID String Contains a unique identifier for an instance of an object.
Balance_or_Activity_Reference_WID String Contains a unique identifier for an instance of an object.
Balance_or_Activity_Reference_Statistic_Type_ID String Contains a unique identifier for an instance of an object.
Statistic_Definition_Reference_WID String Contains a unique identifier for an instance of an object.
Statistic_Definition_Reference_Financial_Headcount_Definition_ID String Contains a unique identifier for an instance of an object.
Statistic_Definition_Reference_Statistic_Definition_ID String Contains a unique identifier for an instance of an object.
Basis_Dimension_Reference String Reference to an existing Worktag Type used as dimension by which the basis is calculated - for example, we can allocate $1,000 based on the ledger balance for each cost center and region (where the dimensions were cost center and region). This gets populated if Allocation Basis Type is 'Ledger Accounts'
Basis_Group_By_Reference String Reference to an existing Worktag Type used to group the basis. Example when allocating between Cost Centers within a Region. Group by will sum per Region and allocate the total sum per Region between the cost centers within the region.
Basis_Book_Code_Reference_WID String Contains a unique identifier for an instance of an object.
Basis_Book_Code_Reference_Book_Code_ID String Contains a unique identifier for an instance of an object.
Basis_Condition_Rule_Reference_WID String Contains a unique identifier for an instance of an object.
Basis_Condition_Rule_Reference_Condition_Rule_ID String Contains a unique identifier for an instance of an object.
Basis_Condition_Rule_Reference_WCP_Component_ID String Contains a unique identifier for an instance of an object.
Ledger_or_Budget_Structure_for_Target_Reference_WID String Contains a unique identifier for an instance of an object.
Ledger_or_Budget_Structure_for_Target_Reference_Budget_Structure_ID String Contains a unique identifier for an instance of an object.
Ledger_or_Budget_Structure_for_Target_Reference_Ledger_Type_ID String Contains a unique identifier for an instance of an object.
Budget_Amendment_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Budget_Amendment_Type_Reference_Business_Plan_Amendment_Type_ID String Contains a unique identifier for an instance of an object.
Company_is_from_Reference_WID String Contains a unique identifier for an instance of an object.
Company_is_from_Reference_Allocation_Dimension_Source_ID String Contains a unique identifier for an instance of an object.
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.
Target_Account_Ledger_Account_is_from_Reference_WID String Contains a unique identifier for an instance of an object.
Target_Account_Ledger_Account_is_from_Reference_Allocation_Dimension_Source_ID String Contains a unique identifier for an instance of an object.
Target_Account_Ledger_Account_Reference_WID String Contains a unique identifier for an instance of an object.
Target_Account_Ledger_Account_Reference_Ledger_Account_ID String Contains a unique identifier for an instance of an object.
Target_Account_Ledger_Account_Reference_Ledger_Account_Summary_ID String Contains a unique identifier for an instance of an object.
Target_Book_Code_Reference_WID String Contains a unique identifier for an instance of an object.
Target_Book_Code_Reference_Book_Code_ID String Contains a unique identifier for an instance of an object.
Offset_Account_Ledger_Account_is_from_Reference_WID String Contains a unique identifier for an instance of an object.
Offset_Account_Ledger_Account_is_from_Reference_Allocation_Dimension_Source_ID String Contains a unique identifier for an instance of an object.
Offset_Account_Ledger_Account_Reference_WID String Contains a unique identifier for an instance of an object.
Offset_Account_Ledger_Account_Reference_Ledger_Account_ID String Contains a unique identifier for an instance of an object.
Offset_Account_Ledger_Account_Reference_Ledger_Account_Summary_ID String Contains a unique identifier for an instance of an object.

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