Tableau Connector for Workday

Build 20.0.7740

ExpenseItems

Expense Item

Columns

Name Type References Description
Expense_Item_Reference_WID String Contains a unique identifier for an instance of an object.
Expense_Item_Reference_Expense_Item_ID String Contains a unique identifier for an instance of an object.
Expense_Item_ID String Expense Item ID. This is the Expense Item unique identifier
Item_Name String Free form text field for meaningful Expense Item Name
Resource_Category_Reference_WID String Contains a unique identifier for an instance of an object.
Resource_Category_Reference_Spend_Category_ID String Contains a unique identifier for an instance of an object.
Item_Description String Free form text field to provide detailed description of the Expense Item
Synonyms_and_Keywords String Synonyms and Key words which are similar to the Expense Item name. These will allow an infrequent user to type in something reasonable and find the correct expense item.
Per_Diem_Expense Bool Boolean flag indicating if the Expense Item is a Per Diem Expense. Used for reporting purposes only.
Item_Unit_Price Decimal Currency field for Item Unit Price
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.
Expense_Policy_Group_Reference String Reference to an existing Expense Policy Group. Assigning expense item to policy groups is done to make it easier for an administrator to search for and select items for segmented security setup.
Expense_Item_Group_Reference String Reference to an existing Expense Item Group. Assigning expense items to item groups is done to make it easier to search for and select items. Expense items can belong to multiple groups.
Job_Profile_Reference String Reference to an existing Job Profile. Workers in this Job Profile can use this Expense Item.
Unit_of_Measure_Reference_WID String Contains a unique identifier for an instance of an object.
Unit_of_Measure_Reference_UN_CEFACT_Common_Code_ID String Contains a unique identifier for an instance of an object.
Unit_of_Measure_Reference_UOM_EDI_Code_ID String Contains a unique identifier for an instance of an object.
Tax_Applicability_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Applicability_Reference_Tax_Applicability_ID String Contains a unique identifier for an instance of an object.
Travel_Journal Bool This boolean will enable travel journal entry on the expense report line.
Travel_Journal_Item_Reference_WID String Contains a unique identifier for an instance of an object.
Travel_Journal_Item_Reference_Expense_Item_ID String Contains a unique identifier for an instance of an object.
Travel_Journal_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Travel_Journal_Type_Reference_Travel_Journal_Type_ID String Contains a unique identifier for an instance of an object.
Rounding_Option_for_Hours_Reference_WID String Contains a unique identifier for an instance of an object.
Rounding_Option_for_Hours_Reference_Rounding_Option_ID String Contains a unique identifier for an instance of an object.
Non_Editable_Number_of_Hours Bool This boolean will make the Number of Hours not enterable on the Travel Journal lines.
Quantity_and_Per_Unit_Amount_Not_Enterable Bool This boolean will make the Amount and Quantity not enterable on the expense report line.
Inactive Bool Boolean flag indicating if the Expense Item is Inactive. Set for expense items that should no longer be selected on Expense Report Lines
Fixed_Expense Bool Boolean flag indicating if the Expense Item is a Fixed Expense. Set for expenses that are always the same amount, for example, a fixed rate for mileage.
Maximum_Line_Expense Bool Boolean flag indicating if the Expense Item has a Maximum Expense. Set for expenses where you want to establish a maximum amount that can't be exceeded, such as the maximum amount for one night at a hotel.
Maximum_Daily_Expense Bool Boolean flag indicating if the Expense Item has a Maximum Daily Expense. Set for expenses where you want to establish a maximum daily amount that can't be exceeded, such as the maximum daily amount per meal.
Allow_Overage Bool Boolean flag indicating if a Maximum Expense Item will allow overages. Set for expenses where you want to give the user a warning that they have surpassed the maximum amount allowed for the expense item rather than giving the user an error.
Based_on_Allowance_Plan Bool Boolean flag indicating if the Expense Item is based on an Allowance Plan. Set for expenses that would have a Tuition Allowance Plan for example.
Memo_Required Bool Boolean flag indicating if a Memo is Required by the user when entering the expense item.
Display_Arrival_Date_before_Departure_Date Bool Display Arrival Date before Departure Date
Non_Editable_Number_of_Days Bool This boolean will make the Number of Days not enterable on the expense report lines.
Expense_Accumulator_Reference_WID String Contains a unique identifier for an instance of an object.
Expense_Accumulator_Reference_Expense_Accumulator_ID String Contains a unique identifier for an instance of an object.
Expense_Rate_Table_Reference_WID String Contains a unique identifier for an instance of an object.
Expense_Rate_Table_Reference_Expense_Rate_Table_ID String Contains a unique identifier for an instance of an object.
Enable_Rate_Tables_for_Spend_Authorizations Bool Boolean flag, Enable Rate Tables on Spend Authorizations, that allows rate tables to be enforced on the spend authorization line using the expense item. This boolean will force all expense item attributes required by the related rate table to be displayed on required on spend authorizations. This boolean will only be available when a base rate table exists on the expense item.

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