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 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.
- Trip Creator Entity (also shown as Trip Requestor Entity) — The legal entity associated with the trip creator.
- Trip Created Date — The date and time the trip was created.
- Trip Status — The current status of the trip (e.g., pending approval, approved, booked, cancelled).
- Approval For — Which user or employee the approval request applies to.
- Approved/Rejected By — The email address of the person who approved or rejected the trip.
- Designated Approver — The approver assigned to review the trip.
- Approve/Reject Reason — The reason given when the trip was approved or rejected.
- Approval Time — The date and time the trip was approved or rejected.
- Out of Policy (Flag) — Indicates whether the booking violates your company's travel policy.
- Policy Level — The level of the travel policy that applied to the booking.
- Policy Inventory Class — The class of travel inventory the policy allows for the booking (e.g., cabin class for flights, star category for hotels).
- Policy Violation Amount — The amount by which the booking exceeded the limit set in the policy.
- Policy Budget Cap — The maximum budget the policy allows for the booking.
Booking details
- Booking ID — The unique identifier for the booking inside ITILITE.
- Previous Booking ID — The original booking this booking was created from (after a change or reissue).
- Ticket Number — The airline, hotel or rental car confirmation/ticket number for the booking.
- PNR / Confirmation # — The vendor's booking reference: the airline PNR (passenger name record) for flights, or the confirmation number for hotels and rental cars.
- Travel options — The type of travel (flight, hotel or rental car).
- Special Instructions — Any special notes or requests added to the booking.
- Company Discount Code — The corporate discount code applied to the booking.
- Personal Membership Code — The traveler's personal loyalty or membership number applied to the booking.
User details
- Traveler Name — The name of the person traveling.
- Traveler Email — The email address of the traveler.
- Traveler Employee ID — The employee ID entered in the traveler's user profile inside ITILITE.
- Traveler Department — The department the traveler belongs to.
- Traveler Type — The category the traveler belongs to (e.g., employee or guest).
- Logged-in as (Delegate Access) — The user who made the booking on the traveler's behalf when a delegate was logged in.
- Gender — The traveler's gender, as entered in their profile.
- Passport Number — The traveler's passport number, as entered in their profile.
- Passport Citizenship Country — The country of citizenship on the traveler's passport, as entered in their profile.
- Passport Issuing Country — The country that issued the traveler's passport, as entered in their profile.
- Passport Issued Date — The date the passport was issued, as entered in their profile.
- Passport Expiry Date — The date the passport expires, as entered in their profile.
- Expires In(days) — The number of days remaining until the passport expires, as entered in their profile.
Transaction details
- Billing SL No — The serial number of the billing record.
- Transaction Type — Whether the row represents a booking, a cancellation, or another transaction type.
- Transaction Date — The date the transaction occurred.
- Billing Date — The date the transaction was billed, i.e. the invoice date.
- Billing Status — The current billing status of the transaction.
- Transaction Currency — The currency the transaction was made in.
- Transaction Amount — The amount charged or credited for the transaction.
- Base Price — The base price of the booking before taxes and fees.
- Tax — The taxes applied to the booking.
- Extra Fees — Any additional fees charged on the booking.
- Seat Fees — The fees charged for seat selection.
- Net Service Fee — The ITILITE service fee charged on the transaction, net of taxes.
- Payment Gateway Charges — The charges levied by the payment gateway for processing the payment.
- Total Amount Charged — The total amount charged for the transaction, including fees and taxes.
- Invoice Amount — The total amount shown on the ITILITE invoice.
- Balance After Transaction — The balance remaining on your company account after the transaction.
- Reshop Savings — The amount saved when a booking was repriced to a lower fare after it was made.
- 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.
Flight details
- Type Of Travel — Whether the flight was domestic or international.
- Airline Name — The name of the airline.
- Airline Code — The airline's code (e.g., UA, AA).
- Flight No — The flight number.
- Flight Route — The full route of the flight, including any connecting airports.
- Class Of Travel — The cabin class booked (e.g., Economy, Business).
- Oneway Or Return — Whether the flight was booked one-way or round-trip.
- Origin (also shown as Source) — The departure city/airport.
- Destination — The arrival city/airport.
- Departure Date — The date of departure.
- Departure Day — The day of the week of departure.
- Departure Hour — The hour of the day the flight departs.
- Arrival Date — The date of arrival.
- No. of Stops — The number of stops on the flight.
- Total Flight Hours — The total duration of the journey, in hours.
- Days Before Travel — The number of days between when the booking was made and the travel date. Used to identify last-minute bookings.
Hotel details
- Hotel Name (also shown as Property) — The name of the hotel booked.
- City — The city the hotel is in.
- Hotel Address — The street address of the hotel.
- CheckIn Date — The check-in date.
- CheckOut Date — The check-out date.
- Total Nights — The total number of nights booked.
- Rate Per Night — The nightly room rate incl. of taxes.
- Room Type — The type of room booked.
- Hotel Stars — The hotel's star rating.
- Hotel Breakfast — Whether breakfast is included in the booking.
Flight travel credits
- 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.
- Flight Credits Status — 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 booking, in kilograms.
- Estimated Carbon Footprint (in Metric tonnes) — The estimated carbon footprint of the booking, 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.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article