Tableau Connector for Workday

Build 20.0.7740

TravelBookingRecords_Travel_Booking_Record_Data

Travel Booking Record Data.

Columns

Name Type References Description
TravelBookingRecord_Travel_Booking_Record_Reference_WID String

TravelBookingRecords.Travel_Booking_Record_Reference_WID

The unique identifier type. Each
ID String Travel Booking Record ID. This is the Travel Booking Record unique identifier.
Employee_ID String This is the unique identifier of the Employee that is associated with the Travel Booking Record.
Accountholder_Name String Accountholder name with the Travel Management Company.
Traveler_Name String Traveler Name for the Itinerary.
Booking_Date Date Date of this Travel Booking Record event.
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.
Ticket_Number String Ticket Number on Travel Booking Record
Original_Ticket_Number String Original Ticket Number on Travel Booking Record.
Reissued_Ticket_Number String Reissued Ticket Number on Travel Booking Record.
Travel_Provider String Identifying name of the Travel management provider.
Itinerary_Number String Itinerary description from the Travel Management Provider.
Itinerary_Description String Itinerary description from the Travel Management Provider.
Reservation_Number String Reservation number provided for this Travel Booking Record.
Travel_Record_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Travel_Record_Type_Reference_Travel_Type_ID String Contains a unique identifier for an instance of an object.
Booking_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Booking_Status_Reference_Booking_Status_ID String Contains a unique identifier for an instance of an object.
Fare_Category_Reference_WID String Contains a unique identifier for an instance of an object.
Fare_Category_Reference_Fare_Category_ID String Contains a unique identifier for an instance of an object.
Ticket_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Ticket_Type_Reference_Ticket_Type_ID String Contains a unique identifier for an instance of an object.
Location_Code_Destination String Destination Location Code for Travel Booking Record.
Location_Code_Origin String Origination Location Code for Travel Booking Record.
Travel_Route String Concatenate codes for this route, with each code representing a destination on the trip and separated by a dash. Example: For airports, SFO-ORD-GRR-DEN-SFO.
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.
Purchased Bool Purchase Status of Travel Booking Record.
Purchase_Date Date Purchase Date of Travel Booking.
Source_Base_Fare_Amount Decimal Populated for Travel Type Air, Rail, and Other only.
Transaction_Extended_Amount Decimal Total amount for this Travel Booking item in source currency. Includes the Tax amount. This may be a refund amount or Fees.
Source_Total_Amount Decimal The total amount paid for the Travel Booking Record, including base fare, tax, fees, and ancillaries.
Source_Currency_Reference_WID String Contains a unique identifier for an instance of an object.
Source_Currency_Reference_Currency_ID String Contains a unique identifier for an instance of an object.
Source_Currency_Reference_Currency_Numeric_Code String Contains a unique identifier for an instance of an object.
Source_Lowest_Logical_Amount Decimal Identifies the lowest logical fare for the identified Travel Booking booking in Source Currency.
Last_4_Digits_of_Credit_Card_Number String Last four digits of the card number used for Travel Booking.
Credit_Card_Transaction_Reference String Card Transaction Reference Number if Booking Item is prepaid.
Destination_City String Destination City
Destination_State String Destination State
Destination_Country String Destination Country
Origination_City String Origination City
Origination_State String Origination State
Origination_Country String Origination Country
Merchant_Code String Merchant Code
Merchant_Name String Merchant Name for Travel Booking.
Start_Date Date Travel Booking related Start Date. Example : Air: Departure Date, Hotel: Check in Date, Car Rental: Pick up Date.
End_Date Date Travel Booking Related End Date. Example: Air: Return Date, Hotel: Check Out Date, Car Rental: Return Date.
Source_Daily_Amount Decimal Source Daily Amount.
Travel_Policy_Code String Travel Policy Code.
Policy_Description String Travel Policy Description.
Travel_Booking_Record_Name_Match_Data String Travel Booking Record Name Match Data.

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