XM_ TRAVEL_LINE_TEM

Entity Name XM_TRAVEL_LINE_ITEM
Entity Type Independent
Definition This table has one row for each travel request line item in all travel requests.

Attributes

Attribute Datatype Width Definition
LINE_ITEM_ID Integer 11 PK
DOCUMENT_ID Integer 11 Identifying the invoice that this line item is part of.
TRAVEL_EXPENSE_TYPE_ID Integer 11 Type of travel cost for this line item, eg 'Hotel' see
COST_AMOUNT_CURRENCY Varchar 3 Currency of amount
COST_AMOUNT Float 3 Cost of amount
TAX_AMOUNT_CURRENCY Varchar 3 Currency of Tax
TAX_AMOUNT_CURRENCY Float Tax
PURPOSE Varchar 255 Purpose
PURPOSE_USER_ID Integer Creater of user purpose
VENDOR_NAME Varchar 255 Vendor
VENDOR_USER_ID Integer 11 Creater of this vendor
FROM_LOCATION_ID Integer Location of origin
FROM_Date DateTime Date of origin
From_time DateTime 38 Time of origin
TO_LOCATION_ID Integer 38 Location of destination
TO_DATE DateTime Date of destination
TO_TIME DateTime Time of destination
CLASS_OF_SERVICE Varchar 255 Class of service
DAILY_RATE_AMOUNT float 3 daily rate for this item, like 29.95 for the car rental
DAILY_RATE_AMOUNT_CURRENCY Varchar 3 Currency of daily rate amount
CUST_DEF_1 varchar 255 Customer defined field
CUST_DEF_2 Varchar 255 Customer defined field
CUST_DEF_3 Varchar 255 Customer defined field
DAILY_RATE_NATIVE_AMOUNT Float daily rate for this item, in currency local to where expense will be incurred
DAILY_RATE_NATIVE_AMOUNT_CURR Varchar 3 Currency of daily rate amount
EXCHANGE_RATE number 28,10 exchange rate between local and default currency
MILES Number Miles driven
REIMBURSE_RATE Float Reimburse rate
AVERAGE_COST_AMOUNT Float Average cost amount
AVERAGE_COST_AMOUNT_CURRENCY Varchar 3 Currency of average cost amount
IS_IMPORTED Number 5 F lag to indicate whether current line item is an imported line item 0 = no 1 = yes
DESCRIPTION1 Varchar 255 For air segment, this field stores the from airport code and name. For car segment, this field stores the pickup location code.
DESCRIPTION2 Varchar 255 For air segment, this field stores the to airport code and name. For car segment, this field stores the dropoff location code
EXT_BOOKING_KEY Varchar 255 For imported line items, this column may contain an external identifier for it into another system.
EXCH_RATE_DEFAULT Number 28 default foreign exchange rate
TRIP_TYPE Varchar 2 RT for round trip, OW for one way, MC for multi-city
FROM_AIRPORT_CODE Varchar 3 three character airport code for the part of this leg of the trip
TO_AIRPORT_CODE Varchar 3 three character airport code for part of trip
LOWEST_AIRFARE_AMT Float the lowest airfare, typically coming from the imported itinerary
LOWEST_AIRFARE_AMT_CURRENCY Varchar 3 Currency of lowest air fair amount
LOWEST_HOTEL_RATE_AMT Float the lowest Hotel fare, typically coming from the imported itinerary
LOWEST_HOTEL_RATE_AMT_CURRENCY Varchar 3 Currency of lowest hotel fair amount
BOOKING_SOURCE Varchar 2 ON for online-booked, OF for offline-booked
AGENCY_NAME Varchar 255 captures the agency name for those travel plans not booked online
NUMBER_OF_GUESTS Number 38 Number of guests
CHANGE_TIMESTAMP DateTime
GUEST_NO_SHOW_COUNT Number 38 The guest no-show count
CREATOR_CLIENT_TYPE Number 38 the client that created the line item (1=HTML, 2=Mobile, 3=Voice, 4=DocumentImportBkg)
EXPORT_STATUS Number 38 the export status (0=not exported, 1=exported, 2=marked for re-export
REVERSAL_LINE_ITEM_ID Number 38 for voided/reversal line items, this is the matching reversal/ voided line item
Void_STATUS Number 38 the void status (0=not voided, 1=voided, 2=this is a reversal that cancels out a voided line item)