Tableau Connector for Workday

Build 20.0.7740

ExpenseReports_Expense_Report_Lines_Reference_Data

Element that encapsulates all data for 1 expense report line (date, credit card, credit card transaction, expense item, quantity, amount, currency, currency rate, converted amount, receipt included, billable, worktags, expense item attributes).

Columns

Name Type References Description
ExpenseReport_Expense_Report_Reference_WID String

ExpenseReports.Expense_Report_Reference_WID

The unique identifier type. Each
Expense_Report_Line_Date Date The date the expense was incurred.
Travel_Booking_Record_Reference_WID String Contains a unique identifier for an instance of an object.
Travel_Booking_Record_Reference_Travel_Booking_Record_ID String Contains a unique identifier for an instance of an object.
Expense_Item_Reference_WID String Contains a unique identifier for an instance of an object.
Expense_Item_Reference_Catalog_Item_ID String Contains a unique identifier for an instance of an object.
Expense_Item_Reference_Catalog_Load_Item_ID 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_Reference_Purchase_Item_ID String Contains a unique identifier for an instance of an object.
Expense_Item_Reference_Sales_Item_ID String Contains a unique identifier for an instance of an object.
Expense_Item_Reference_Supplier_Item_ID String Contains a unique identifier for an instance of an object.
Quantity Decimal Quantity for the expense report line. Leave blank if you are entering a credit card transaction.
Amount Decimal Unit cost for the expense report line. Leave blank if you are entering a credit card transaction.
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.
Tax_Code_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Code_Reference_Tax_Code_ID String Contains a unique identifier for an instance of an object.
Tax_Code_Reference_Withholding_Tax_Code_ID String Contains a unique identifier for an instance of an object.
Tax_Amount Decimal Tax Amount for Expense Line
Tax_Rate_1_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Rate_1_Reference_Tax_Rate_ID String Contains a unique identifier for an instance of an object.
Tax_Rate_1_Reference_Withholding_Tax_Rate_ID String Contains a unique identifier for an instance of an object.
Tax_Recoverability_1_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Recoverability_1_Reference_Tax_Recoverability_Object_ID String Contains a unique identifier for an instance of an object.
Tax_Option_1_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Option_1_Reference_Tax_Option_ID String Contains a unique identifier for an instance of an object.
Tax_Rate_2_Reference String Reference to Tax Rate for Tax Code.
Tax_Recoverability_2_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Recoverability_2_Reference_Tax_Recoverability_Object_ID String Contains a unique identifier for an instance of an object.
Tax_Option_2_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Option_2_Reference_Tax_Option_ID String Contains a unique identifier for an instance of an object.
Tax_Rate_3_Reference String Reference to Tax Rate for Tax Code.
Tax_Recoverability_3_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Recoverability_3_Reference_Tax_Recoverability_Object_ID String Contains a unique identifier for an instance of an object.
Tax_Option_3_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Option_3_Reference_Tax_Option_ID String Contains a unique identifier for an instance of an object.
Tax_Rate_4_Reference String Reference to Tax Rate for Tax Code.
Tax_Recoverability_4_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Recoverability_4_Reference_Tax_Recoverability_Object_ID String Contains a unique identifier for an instance of an object.
Tax_Option_4_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Option_4_Reference_Tax_Option_ID String Contains a unique identifier for an instance of an object.
Tax_Rate_5_Reference String Reference to Tax Rate for Tax Code.
Tax_Recoverability_5_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Recoverability_5_Reference_Tax_Recoverability_Object_ID String Contains a unique identifier for an instance of an object.
Tax_Option_5_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Option_5_Reference_Tax_Option_ID String Contains a unique identifier for an instance of an object.
Tax_Rate_6_Reference String Reference to Tax Rate for Tax Code.
Tax_Recoverability_6_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Recoverability_6_Reference_Tax_Recoverability_Object_ID String Contains a unique identifier for an instance of an object.
Tax_Option_6_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Option_6_Reference_Tax_Option_ID String Contains a unique identifier for an instance of an object.
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.
Currency_Rate Decimal The conversion rate between the currency the expense was incurred in and the currency the expense will be reported in. This cannot be used if you are entering the converted amount. Leave blank if you are entering a credit card transaction.
Converted_Amount Decimal The amount the expense is converted to if it was incurred in a different currency. This cannot be used if you are entering the currency rate. Leave blank if you are entering a credit card transaction.
Total_Amount Decimal The amount to report for the expense. This will only be used for viewing.
Total_Itemized_Lines_Converted_Amount Decimal The total amount of the converted amounts for the itemized lines. This field is READ ONLY.
Receipt_Included Bool Boolean flag that represents whether or not a receipt is included.
Personal_Expense Bool Boolean flag that represents whether or not the expense was for personal use.
Billable Bool Boolean flag that represents whether or not the expense is billable.
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.
Worktag_Reference String Reference to existing worktags. Worktags are a way to mark tasks and business objects to make them easier to access and summarize. Each transaction can include one value for each worktag type and is subject to configurable validation when submitted for approval.
Memo String Text describing the use or purpose of the expense.
Available_Spend_Authorization_Line_Reference_IID String Contains a unique identifier for an instance of an object.
Available_Spend_Authorization_Line_Reference_WID String Contains a unique identifier for an instance of an object.
Send_Back_Reason_For_Line String The reason for sending back this Expense Report Line.
Account_Number String Text representing the account number for the expense.
Business_Topics String Text representing the business topics for the expense.
Business_Reason String Text representing the business reason for the expense.
Reservation_Number String Text representing the reservation number for the expense.
Ticket_Number String Text representing the ticket number for the expense.
Merchant String Text representing the merchant name for the expense.
Merchant_Tax_ID String Text representing the merchant tax id for the expense.
Country_Reference_WID String Contains a unique identifier for an instance of an object.
Country_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
Country_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
Country_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
Travel_Region_Reference_WID String Contains a unique identifier for an instance of an object.
Travel_Region_Reference_Country_Region_ID String Contains a unique identifier for an instance of an object.
Travel_Region_Reference_ISO_3166_2_Code String Contains a unique identifier for an instance of an object.
Origination_Location_Reference_WID String Contains a unique identifier for an instance of an object.
Origination_Location_Reference_Airport_ID String Contains a unique identifier for an instance of an object.
Origination_Location_Reference_Spend_Data_ID String Contains a unique identifier for an instance of an object.
Origination_Location_Reference_Travel_City_ID String Contains a unique identifier for an instance of an object.
Destination_Location_Reference_WID String Contains a unique identifier for an instance of an object.
Destination_Location_Reference_Airport_ID String Contains a unique identifier for an instance of an object.
Destination_Location_Reference_Spend_Data_ID String Contains a unique identifier for an instance of an object.
Destination_Location_Reference_Travel_City_ID String Contains a unique identifier for an instance of an object.
Hotel_Reference_WID String Contains a unique identifier for an instance of an object.
Hotel_Reference_Hotel_ID String Contains a unique identifier for an instance of an object.
Hotel_Reference_Spend_Data_ID String Contains a unique identifier for an instance of an object.
Car_Rental_Agency_Reference_WID String Contains a unique identifier for an instance of an object.
Car_Rental_Agency_Reference_Car_Rental_Agency_ID String Contains a unique identifier for an instance of an object.
Car_Rental_Agency_Reference_Spend_Data_ID String Contains a unique identifier for an instance of an object.
Airline_Reference_WID String Contains a unique identifier for an instance of an object.
Airline_Reference_Airline_ID String Contains a unique identifier for an instance of an object.
Airline_Reference_Spend_Data_ID String Contains a unique identifier for an instance of an object.
Vehicle_Plan_Reference_WID String Contains a unique identifier for an instance of an object.
Vehicle_Plan_Reference_Spend_Data_ID String Contains a unique identifier for an instance of an object.
Vehicle_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Vehicle_Type_Reference_Spend_Data_ID String Contains a unique identifier for an instance of an object.
Engine_Capacity_Reference_WID String Contains a unique identifier for an instance of an object.
Engine_Capacity_Reference_Spend_Data_ID String Contains a unique identifier for an instance of an object.
Fuel_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Fuel_Type_Reference_Spend_Data_ID String Contains a unique identifier for an instance of an object.
Invoice_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Invoice_Type_Reference_Invoice_Type_ID String Contains a unique identifier for an instance of an object.
Invoice_Type_Reference_Spend_Data_ID String Contains a unique identifier for an instance of an object.
Attendee_Reference_Data String Reference to the attendee element that will list the type and name of the person who was an attendee for the expense. This can be used more than once for the expense.
Recipient_Reference_Data String Reference to the recipient element that will list the type and name of the person who was a recipient for the expense. This can be used more than once for the expense.
Passenger_Reference_Data String Reference to the passenger element that will list the type and name of the person who was a passenger for the expense. This can be used more than once for the expense.
Number_of_Persons Decimal Number representing the number of passengers for the expense.
Arrival_Date Date Text representing the arrival date for the expense.
Arrival_Time Time Text representing the arrival time for the expense.
Departure_Date Date Text representing the departure date for the expense.
Departure_Time Time Text representing the departure time for the expense.
Number_of_Days Decimal Number representing the number of days or nights for the expense.
Number_of_Hours Decimal Number representing the number of hours for the expense. This is evaluated as a fraction of a day for expenses with fixed expense items using expense rate tables.
Number_of_Breakfasts_Provided Decimal Number representing the number of breakfasts provided for the expense.
Number_of_Lunches_Provided Decimal Number representing the number of lunches provided for the expense.
Number_of_Dinners_Provided Decimal Number representing the number of dinners provided for the expense.
Number_of_Nights_Private_Accommodation Decimal Text representing the Number of Nights of Private Accommodation for the expense.
Eligibility_Reference_WID String Contains a unique identifier for an instance of an object.
Eligibility_Reference_Eligibility_ID String Contains a unique identifier for an instance of an object.
Class_of_Service_Reference_WID String Contains a unique identifier for an instance of an object.
Class_of_Service_Reference_Class_of_Service_Value String Contains a unique identifier for an instance of an object.
Class_of_Service_Reference_Spend_Data_ID String Contains a unique identifier for an instance of an object.
Daily_Rate Decimal Text representing the daily rate for the expense.
Reference_Number String Text representing a reference number for the expense. This can be used for a hotel folio number or anything else.
Classes_of_Service_Reference String Reference to classes of service.
Document_Number String Text representing the document number for the expense.
Merchant_Postal_Code String TEXT representing the Merchant Postal Code for the expense.
Merchant_Address String TEXT representing the Merchant Address for the expense.
Merchant_City String TEXT representing the Merchant City for the expense.
Merchant_Country_Reference_WID String Contains a unique identifier for an instance of an object.
Merchant_Country_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
Merchant_Country_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
Merchant_Country_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
Merchant_Region_Reference_WID String Contains a unique identifier for an instance of an object.
Merchant_Region_Reference_Country_Region_ID String Contains a unique identifier for an instance of an object.
Merchant_Region_Reference_ISO_3166_2_Code String Contains a unique identifier for an instance of an object.
Configurable_Boolean_1 Bool BOOLEAN representing the Configurable Boolean 1 for the expense.
Configurable_Boolean_2 Bool BOOLEAN representing the Configurable Boolean 2 for the expense.
Configurable_Boolean_3 Bool BOOLEAN representing the Configurable Boolean 3 for the expense.
Configurable_Boolean_4 Bool BOOLEAN representing the Configurable Boolean 4 for the expense.
Configurable_Boolean_5 Bool BOOLEAN representing the Configurable Boolean 5 for the expense.
Configurable_Decimal_1 Decimal NUMERIC representing the Configurable Decimal 1 for the expense.
Configurable_Decimal_2 Decimal NUMERIC representing the Configurable Decimal 2 for the expense.
Configurable_Decimal_3 Decimal NUMERIC representing the Configurable Decimal 3 for the expense.
Configurable_Decimal_4 Decimal NUMERIC representing the Configurable Decimal 4 for the expense.
Configurable_Decimal_5 Decimal NUMERIC representing the Configurable Decimal 5 for the expense.
Configurable_Numeric_1 Decimal NUMERIC representing the Configurable Numeric 1 for the expense.
Configurable_Numeric_2 Decimal NUMERIC representing the Configurable Numeric 2 for the expense.
Configurable_Numeric_3 Decimal NUMERIC representing the Configurable Numeric 3 for the expense.
Configurable_Numeric_4 Decimal NUMERIC representing the Configurable Numeric 4 for the expense.
Configurable_Numeric_5 Decimal NUMERIC representing the Configurable Numeric 5 for the expense.
Configurable_Text_1 String TEXT representing the Configurable Text 1 for the expense.
Configurable_Text_2 String TEXT representing the Configurable Text 2 for the expense.
Configurable_Text_3 String TEXT representing the Configurable Text 3 for the expense.
Configurable_Text_4 String TEXT representing the Configurable Text 4 for the expense.
Configurable_Text_5 String TEXT representing the Configurable Text 5 for the expense.
Configurable_Date_1 Date DATE representing the Configurable Date 1 for the expense.
Configurable_Date_2 Date DATE representing the Configurable Date 2 for the expense.
Configurable_Date_3 Date DATE representing the Configurable Date 3 for the expense.
Configurable_Date_4 Date DATE representing the Configurable Date 4 for the expense.
Configurable_Date_5 Date DATE representing the Configurable Date 5 for the expense.
Itemized_Expense_Report_Lines_Data String Element that encapsulates all data for 1 itemized expense report line (date, expense item, quantity, amount, tax amount, currency, currency rate, converted amount, receipt included, billable, worktags, expense item attributes).
Attachment_Data String Encapsulating element containing all Business Document Attachment data.
Reimbursement_Amount Decimal The amount that represents reimbursement amount in the reimbursement currency. This field is READ ONLY.
Reimbursable Bool Boolean flag that represents whether or not the expense is reimbursable.

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