Travel Reports Glossary

ITILITE's reports are built from a common pool of data columns. If you're not sure which columns appear in a specific report, open the report and check the column headers, or use + Add filter to see the full list of columns available in that report.

Trip details

• Trip ID — The unique identifier for the trip inside ITILITE.
• Trip Creator Name (also shown as Trip Requestor Name) — The name of the person who created or requested the trip.
• Trip Creator Email (also shown as Trip Requestor Email) — The email address of the person who created or requested the trip.
• Trip Creator Entity (also shown as Trip Requestor Entity) — The legal entity associated with the trip creator.
• Approval For — Which user or employee does the approval request apply to.
• Approved By — The email address of the person who approved or rejected the trip.
• Designated Approver — The approver assigned to review the trip.
• Approved Reason — The reason given when the trip was approved or rejected.

Booking details

• Ticket Number — The airline, hotel or rental car confirmation/ticket number for the booking.
• Days Before Travel — The number of days between when the booking was made and the travel date. Used to identify last-minute bookings.
• Special Instructions — Any special notes or requests added to the booking.
• Traveler Name — The name of the person traveling.
• Traveler Email — The email address of the traveler.

User details

• Traveler Employee ID — The employee ID entered in the traveler's user profile inside ITILITE.
• Traveler Department — The department the traveler belongs to.
• Trip Creator Employee ID (also shown as Trip Requestor Employee ID) — The employee ID of the person who created or requested the trip.
• Trip Creator Department (also shown as Trip Requestor Department) — The department of the person who created or requested the trip.

Transaction details

• Transaction Type — Whether the row represents a booking, a cancellation, or another transaction type.
• Transaction Date — The date the transaction occurred.
• Month Of Transaction — The month and year the transaction falls into.
• Billing Date — The date the transaction was billed, i.e. the invoice date.
• Transaction Currency — The currency the transaction was made in.
• Transaction Amount — The amount charged or credited for the transaction.
• Transaction Invoice Number — The invoice number associated with the transaction.
• Refund Amount — The amount refunded, for cancellations.
• Refund Processed Date — The date the refund was processed.
• Refund Status — The current status of the refund.
• Remarks — Any free-text notes added to the transaction.

Flight details

• Type of Travel — Whether the flight was domestic or international.
• Airline PNR — The airline's booking reference (passenger name record) for the flight.
• Airline Name — The name of the airline.
• Airline Code — The airline's code (e.g., UA, AA).
• Flight No — The flight number.
• Class of Travel — The cabin class booked (e.g., Economy, Business).
• Oneway Or Return — Whether the flight was booked one-way or round-trip.
• Departure Date — The date of departure.
• Origin (also shown as Source) — The departure city/airport.
• Destination — The arrival city/airport.

Hotel details

• Hotel Name (also shown as Property) — The name of the hotel booked.
• City (also shown as Address) — The city or address of the hotel.
• Check In Date — The check-in date.
• Check Out Date — The check-out date.
• Rate Per Night — The nightly room rate incl. of taxes.

Flight travel credits

• Booking ID — The booking the travel credit is tied to.
• Previous Booking ID — The original booking the credit was generated from.
• Sector Code — The route/sector code associated with the credit.
• Currency — The currency the credit is denominated in.
• Credit Value — The value of the available travel credit.
• Expiry Date — The date the credit expires.
• State — The current status of the credit (e.g., unused, used, expired).

CO2 emissions

• Estimated Travel Distance (in Miles) — The estimated distance traveled, in miles.
• Estimated Travel Distance (in KM) — The estimated distance traveled, in kilometers.
• Estimated Carbon Footprint (in kg) — The estimated carbon footprint of the trip, in kilograms.
• Estimated Carbon Footprint (in Metric tonnes) — The estimated carbon footprint of the trip, in metric tonnes.

Company account details

• Company ID — The internal ID ITILITE uses to identify your company account.
• Company Name — Your company's name as registered with ITILITE.
• Company Entity — The specific legal entity or subsidiary your booking or trip is associated with.
• Default Currency — The default currency configured for your company account.