| Column Name | Explanation |
| Advance Booking Days | The number days between booking date and travel start date |
| Airline Credit Amount Issued | Amount of airline credit issued on flight cancellation |
| Airline Credit Amount Used | Amount of airline credit used for this booking |
| Airline Credit Number Issued | MCO or Ticket Number of the credit issued under this booking event |
| Airline Credit Number Used | MCO or Ticket Number of the credit used under this booking event |
| Airline Credit Type Issued | Unused Ticket or MCO |
| Airline Credit Type Used | Unused Ticket or MCO |
| Approved By | Email address of the user who approved the travel request |
| Booked By | Name of the user who booked the travel |
| Booking Confirmation Number | Confirmation number of the travel booking |
| Booking Date | Date of "posting" the "booking transaction" |
| Booking fee | Routespring fee associated for the travel booking |
| Booking Session ID | Routespring session ID associated with the travel booking |
| Booking Status |
1. Cancelled = if booking is cancelled
2. Voided if booking option is voided
3. Booked = if the booking event has only "booking transaction"
4. Modified = if any transaction is "posted" in addition to "booking transaction"
|
| Booking Type | The type of travel booking made: car rental, flight, hotel, or train. |
| Carry-on Baggage | Sum of all amounts with "Carry-on Baggage" line item under that booking "event" |
| Checked Baggage | Sum of all amounts with "Checked Baggage" line item under that booking "event" |
| Class Of Service | Class of service of the travel booked |
| Commissionable Rate | Explains if the booked fare is commissionable or not |
| Company Payment Method | Payment method if company paid for any portion of the travel fare |
| Custom Field: <name 1> | Value of the custom field selected at the time of booking |
| Custom Field: <name 2> | Value of the custom field selected at the time of booking |
| Custom Field: <name 3> | Value of the custom field selected at the time of booking |
| Department | The department of the traveler |
| Destination | Travel destination |
| Employee Id | Employee ID of the traveler |
| End Date | Travel end date |
| Entity Name | Name of the entity of the traveler |
| Event Name | The name of the Event, if the booking is related to any Event configured in the system |
| Incidentals | Sum of all amounts with "Incidentals" line item under that booking "event" |
| Last Modification Date | Latest date of "posting" any transaction under that booking's "event" |
| Merchant Group | - no change - |
| Merchant Name | The name of the merchant for the travel booked |
| Merchant Receipt | Receipt received from the merchant will be attached when applicable |
| Miscellaneous | Sum of all amounts with "Miscellaneous" line item under that booking "event" |
| Modification Note | Any notes to explain the booking modification |
| Modification Type | The type of modification made to the booking |
| Modified Base Price | Base Price under the latest "Booking Modification" transaction |
| Modified By | Name of the user who modified the booking |
| Modified End Date | End Date under the latest "Booking Modification" transaction |
| Modified Merchant Taxes & Fees | Merchant Taxes & Fees under the latest "Booking Modification" transaction |
| Modified Start Date | Start Date under the latest "Booking Modification" transaction |
| Modified Total Amount | Sum of Modified Base Price + Modified Merchant Taxes & Fees |
| Number Of Travelers | The number of travelers booked in that itinerary |
| Original Base Price | Base Price under the "booking transaction". Note: in case of flight, this is flight ticket base price (without considering any airline credit applied) |
| Original Merchant Taxes & Fees | Merchant Taxes & Fees under the "booking transaction". Note: in case of flight, this is flight ticket taxes & fees (without considering any airline credit applied) |
| Original Total Amount | Sum of Original Base Price + Original Merchant Taxes & Fees |
| Total Amount | Sum of all individual transaction amounts for that booking |
| Outgoing Arrival Airport | Outgoing Arrival Airport for flight booking |
| Outgoing Arrival Date | Outgoing Arrival Date for flight booking |
| Outgoing Arrival Flight Number | Outgoing Arrival Flight Number for flight booking |
| Paid by Company | Sum of all amounts paid by the company |
| Paid by User | Sum of all amounts paid by the user |
| Payment Processing Fee | Routespring's payment processing fee when applicable |
| Policy Status | Whether the travel policy was violated or not (Yes/No) |
| Policy Violation Details | Explanation of policy violation |
| Rate Type | Whether the booked rate was regular rate or a corporate rate |
| Refund Amount | Sum of all amounts with "Refund" line item under that booking "event" |
| Returning Departure Airport | Returning Departure Airport for flight booking |
| Returning Departure Date | Returning Departure Date for flight booking |
| Returning Departure Flight Number | Returning Departure Flight Number for flight booking |
| Routespring ID | This is an unque Routespring ID associated with the booking |
| Seat Purchase | Sum of all amounts with "Seat Purchase" line item under that booking "event" |
| Start Date | Travel start date |
| Supplier | Routespring's supplier used for that travel booking |
| Ticket Number | Ticket number for flight booking |
| Travel Duration (Days) | Number of days between travel start and end date |
| Travel Purpose | Travel purpose note added by the user at the time of booking |
| Traveler Name | Name of the traveler |
| User Payment Method | Payment method if user paid for any portion of the travel booking |