Report List with Descriptions

List of GraspDATA reports including report number, report name, and description. Note: if on a dedicated server the report number may be different.

Report ID	Report Name	Long Description
1	Advance Purchase Summary	Advance Purchase Summary. This report includes Air and Rail. Transaction types include Sales ONLY. Voids and Vouchers Excluded. Summary for Advance days 0 to 20 and over 20. Grand Total provided. Report results are # of days Advance, Ticket Total $, % of Total, Volume, % of Volume, Average Price. Advance = Start Date Less Issue Date when Start Date > Issue Date and Total Paid not equal to zero; Volume = Total Paid; Average Price = Volume/Tickets.
2	Air Activity Cost Savings By Pass With Sort1	Air Activity Cost Savings Sorted By Passenger Name includes Sort 1. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Voids and Vouchers Excluded. Domestic and International reported separately. Report results are Issue Date, Booking Date, Passenger Name, Sort 1, Invoice #, Ticket #, Fare Paid, Full Fare, Low Fare, Savings, Reason Description, Airlines, Flight #, Class, Depart Date, From City, To City - Subtotal by Passenger Name. Passenger Name Summary provided at end of detail - Passenger Name, # of Transactions, Total Fare Paid, % of Total Fare, Savings. Total Paid = Fare Paid, Coach = Full Fare. Three reports in one - Activity by Passenger Name detail; Reason Code Summary by Reason Code; Passenger Name Summary Sorted by Fare Paid. Itinerary includes both Code and Name.
3	Air Activity Refunds By Passenger Name	Air Activity Refunds By Passenger Name. This report includes Air and Rail. Transaction types include Refunds ONLY. Voids and Vouchers Excluded. Report results are Issue Date, Booking Date, Passenger Name, Invoice #, Ticket #, Airline, Flight #, Class, Depart Date, From City, To City and Refund $. Passenger Name Summary provided at end of detail - Passenger Name, Transaction #, Total Fare $, % of Total Fare, Net Savings. Itinerary includes code and name.
4	Air Activity Simple	Air Activity Simple Sorted by Issue Date then Passenger Name. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Voids and Vouchers Excluded. Report results are Passenger Name, Issue Date, Depart Date, Return Date, Airline code, Itinerary, Invoice #, Ticket #, Original Ticket #, Total $. Grand Total provided. Start Date = Depart Date; End Date = Return Date; Total Paid = Fare Paid; Itinerary by Code only.
5	Air Activity By Invoice	Air Activity Sorted By Invoice. This report includes Air, Rail and Service Fees. Transaction types include Sales, Refunds and Exchanges. Voids and Vouchers Excluded. Report results include Passenger Name, Issue Date, Depart Date, Return Date, Airline code, Itinerary, Invoice #, Ticket #, Original Ticket # and Fare Paid $. Grand Total provided. Start Date = Depart Date; End Date = Return Date; Total Paid = Fare Paid. Itinerary by Code only.
6	Air Activity By Invoice With Sort 1	Air Activity Sorted By Invoice includes Sort 1. This report includes Air, Rail and Service Fees. Transaction types include Sales, Refunds and Exchanges. Voids and Vouchers Excluded. Report results include Passenger Name, Issue Date, Depart Date, Return Date, Airline, Itinerary, Invoice #, Ticket #, Original Ticket # and Fare Paid $. Grand Total provided. Start Date = Depart Date; End Date = Return Date; Total Paid = Fare Paid. Itinerary by Code only.
7	Air Activity By Passenger Name	Air Activity Sorted By Passenger Name. This report includes Air, Rail and Service Fees. Transaction types include Sales, Refunds and Exchanges. Voids and Vouchers Excluded. Report results include Passenger Name, Issue Date, Depart Date, Return Date, Airline code, Itinerary, Invoice #, Ticket #, Original Ticket # and Fare Paid $. Grand Total provided. Start Date = Depart Date; End Date = Return Date; Total Paid = Fare Paid. Itinerary by Code only.
8	Air Activity By Passenger Name With CC	Air Activity Sorted By Passenger Name With credit card #. This report includes Air, Rail and Service Fees. Transaction types include Sales, Refunds and Exchanges. Voids and Vouchers Excluded. Report results include Passenger Name, Issue Date, Depart Date, Return Date, Airline, Itinerary, Invoice #, Ticket #, Original Ticket #, credit card # and Fare Paid $. Grand Total provided. Start Date = Depart Date; End Date = Return Date; Total Paid = Fare Paid. Itinerary by Code Only.
9	Air Activity Simple By Sort 1	Air Activity Simple Sorted By Sort 1. This report includes Air, Rail and Service Fees. Transaction types include Sales, Refunds and Exchanges. Voids and Vouchers Excluded. Report results include Passenger Name, Issue Date, Sort 1, Depart Date, Return Date, Airline, Itinerary, Invoice #, Ticket #, Original Ticket # and Fare Paid $. Grand Total provided. Start Date = Depart Date; End Date = Return Date; Total Paid = Fare Paid; Itinerary by Code Only.
10	Air Volume Summary	Air Volume Summary sorted by Grand Total # of Trips. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers Excluded. Report results include Summary for Domestic, International and Grand Totals. Summary of Airline, Total Trips, % of Trips, Ticketed Price, % of Ticketed Price, Average Price and Grand Totals. All amounts and nets are count (because sales, exchanges, and refunds are counted). Average Ticket Price = Intl Volume + Dom Volume / Dom Trips + Intl Trips; Trips = Domestic Trips + International Trips ; Ticketed Price = International Volume + Domestic Volume / Domestic Trips + International Trips.
11	Audit Report	Audit Report. Vouchers Excluded. Summary report on Air (Domestic and International), Car and Hotel with # of Bookings, Commissions by Booking Total and Grand Totals. Cross checks TRAMS for # of transactions and $ amount by Travel Category and Travel Type.
12	Car Detail by Passenger Name	Car Detail Sorted by Passenger Name. This report includes Car ONLY. Vouchers excluded. The report results include Traveler Name, Car Company, City, Invoice #, Issue Date, Pick Up Date, Drop Off Date, Confirmation #, Confirmation #, # of days, Rate, Total before tax. The report Subtotals by Passenger Name. Grand Total provided. Start Date = Pick Up Date; End Date = Drop Off Date; document # = Confirmation #, duration * # of units = # of days.
13	Car Summary By Company	Car Summary By Car Company sorted by # of bookings. This report includes Car ONLY. Transaction types include Sales ONLY. Voids and Vouchers excluded. The report results in Car Company, # of Car bookings, % of Total, # of Car days, % of Total, Average Rate, Total before tax, % of Total. Bookings = Total Paid ;Car Days = Car Rental Days; Average Rate = Total Paid / Car Rental Days.
14	Executive Summary Compare Periods - Full Fare Compare	Executive Summary Compare Full Fare - Current Year Month to Previous Year Month / Current Year to Date to Previous Year to Date. This report includes Air, Rail, Car and Hotel. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results include Domestic and International Summary for Air, Rail, Car and Hotel. Grand Total for each category provided. Coach = Full Fare. Volume Issued = Sales Invoices; Volume Refunded = Refund Invoices; Net Volume = Sales - Refunds; Net Savings = High Fare - (Sales + Refunds)
15	Executive Summary Compare Periods - Low Fare Compare	Executive Summary Compare Low Fare - Current Year Month to Previous Year Month / Current Year to Date to Previous Year to Date. This report includes Air, Rail, Car and Hotel. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results include Domestic and International Summary for Air, Rail, Car and Hotel. Grand Total for each category provided. Volume Issued = Sales Invoices; Volume Refunded = Refund Invoices; Net Volume = Sales - Refunds; Net Savings = Low Fare - (Sales + Refunds)
16	Executive Summary Report	Executive Summary - Current Year Month to Previous Year Month / Current Year to Date to Previous Year to Date. This report includes Air, Rail, Car and Hotel. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results include Domestic, International and Transborder Summary for Air, Rail, Car and Hotel. Grand Total for each category provided. Grand Total on Total Spend. Volume Issued = Sales Invoices; Volume Refunded = Refund Invoices; Net Volume = Sales - Refunds; Net Savings = High Fare - (Sales + Refunds) ; Lost Savings = Low Fare - (Sales + Refunds).
17	Hotel Detail by Passenger Name	Hotel Detail sorted by Passenger Name. This report includes Hotels ONLY. Vouchers excluded. The report results in Traveler Name, Hotel Property, City, Invoice #, Issue Date, In Date, Out Date, Confirmation #, # of Nights, Rate and Total Paid. Subtotal by Passenger Name. Grand Total Provided. Start Date = In Date; Return Date = Out Date; # of Nights = Bookings ; Total Paid = # of Nights * Rate
18	Hotel Summary By Chain	Hotel Summary Sorted By Chain (# of Nights in descending order) This report includes Hotels ONLY. Vouchers excluded. The reports results in Hotel Chain, # of Bookings, % of Bookings, # of Nights, % of # Nights, Average Rate, Total Paid, % of Total Paid. Grand Total provided at end of report. Formulas: Nights = Number Of Units; Total Paid = # of Nights * Rate; Average Rate = Total Paid / Number Of Units.
19	Hotel Summary By Property	Hotel Summary Sorted By Property (# of Nights in descending order) This report includes Hotels ONLY. Vouchers excluded. The reports results in Hotel Property, Booking #, % of Booking #, # of Nights, % of # Nights, Average Rate, Total Paid, % of Total Paid. Formulas: Nights = dataBooking.Nights; Total Paid = # of Nights * Rate; Average Rate = Total Paid / Nights.
20	Hotel Summary By Top Cities By Property	Hotel Summary Sorted By Top Cities then Property (# of Nights in descending order). Top 50 Hotel Cities Top 5 Properties per city plus Others. This report includes Hotels ONLY. Vouchers excluded. The reports results in Hotel Property, City, # of Bookings, % of Bookings, # of Nights, % of Nights, Average Rate, Total Paid, % of Total Paid Subtotaled by City. Grand Total provided. Hotel City and State checks existence in vendor Table first and then city table. Formulas: Nights = Number Of Units * Duration; Total Paid = # of Nights * Rate; Average Rate = Total Paid / Nights.
21	Top 50 Market Pair By Trip Count	Top 50 Market Pair Sorted by Trip Count. This report includes Air ONLY. Transaction types Sales, Refunds and Exchanges. Vouchers excluded. Report results Market Pair, # of Ticketed trips, % of Ticketed trips, Ticketed Volume, % of Ticketed Volume and Grand Total. Valid segments - one way not counting connections. Formulas: Volume = Net Base Fare. Net Transaction Count = Transactions. Sales = 1, Refunds = -1, Exchanges = 0.
22	Overnight Stay without Hotel	Overnight Stay without Hotel includes Pie Chart. This report includes where Booking type = Air AND Hotel ID is blank. This report excludes when Total Paid = $ 150.00 or $ 200.00. Transaction types include Sales ONLY. Vouchers excluded. The report results in Issue Date, Passenger Name , Amount, Depart Date, Return Date, Airline Code, Routing (Itinerary by Code). Grand Total provided for # of Trips without Hotel. Pie Chart Hotels Booked vs. Hotels Not Booked; Total Paid = Amount; Depart Date = Start Date; Return Date = End Date.
23	Savings/Lost Savings Summary	Savings/Lost Savings Summary Report by Reason Code. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Voids and Vouchers excluded. The report results are Summary by reason code, # of Transactions, Total Fare $, Savings $, Lost Savings $, Net Savings $ with Grand Total. Net Transaction Count calculated as follows: Sales = 1, Refunds = -1, Exchanges = 0. Formulas: Savings = High Fare - Volume; Lost Savings = Low Fare - Volume; Net Savings = Savings - Lost Savings.
24	Top 10 Hotel Analysis	Top 10 Hotel Analysis Pie Charts with tables. This report includes Hotels ONLY. Vouchers excluded. Report results are two pie charts - Net Booking and Net Volume. Summary report includes Hotel Property, Net Bookings, % of Net Bookings, Net Volume, % of Net Volume and Grand Total.
25	Top 25 Travelers by Transactions	Top 25 Travelers Sorted by Transactions This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results in Traveler name, Gross Fare Paid, % of Total Gross Fare Paid, Average Ticket price, # of Transactions, % of Total Transactions. Grand Total included. Average Ticket Price = Gross Fare Paid / # of Transactions.
26	Top 25 Travelers by Volume	Top 25 Travelers Sorted by Volume This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results in Traveler name, Gross Fare Paid, % of Total Gross Fare Paid, Average Ticket price, # of Transactions, % of Total Transactions. Grand Total included. Average Ticket Price = Gross Fare Paid / # of Transactions.
27	Top 50 Markets for AA,AC,BA,CO,US	Top 50 Markets for AA,AC,BA,CO,US. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. Report results Market Pair, All trips, % of all trips, AA trips, % of AA trips, AC trips, % of AC trips, BA trips, % of BA trips, CO trips, % of CO trips, US trips, % of US trips, Others, % of Others and Grand Total. Arrival Airline = Airline; Depart City and Arrival City used for Market Pairs.
28	Top 5 Airline Analysis	Top 5 Airline Analysis. This report includes Air ONLY. Transactions types Sales, Refunds and Exchanges. Vouchers excluded. Two Pie Graphs - Net Tickets and Net Volume with charts which include Airline, Net Tickets, % of Net Tickets, Net Volume, % of Net Volume and Grand Total. Net is calculated by Sales = 1, Refunds = -1 and Exchanges = 0.
29	Top Car Analysis	Top Car Analysis. This report includes Car ONLY. Vouchers excluded. Two Pie Charts - Net Bookings and Net Volume with chart - Car Company, Net Booking, % of Net Booking, Net Volume, % of Net Volume and Grand Total. Total Paid = Net Volume. Net is calculated by Sales = 1, Refunds = -1 and Exchanges = 0
30	Traveler Activity By Passenger Name	Traveler Activity Sorted By Passenger Name then Travel type. Subtotaled by Travel type and Passenger Name. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results are Issue Date, Traveler, Invoice Date, Ticket # / Confirmation #, Amount, from Date, to Date, City Codes, Vendor Name and Grand Total. Start Date = From Date; End Date = To Date; Amount = Total Paid.
31	Traveler Activity With Segments	Traveler Activity Sorted By Passenger Name then Booking type. NO $$ Value on this report. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results are Issue Date, Traveler Name, Ticket # / Confirmation #, Date/Time, Departure City Code and Name, Airline/Flight #, Arrival City Code and Name, Cities, Date/Time.
32	Top 5 Executive Travel Summary	Top 5 Executive Travel Summary. This reports includes Air, Rail, Car and Hotel. Transaction type Sales ONLY. Vouchers excluded. Produces 4 Pie Charts - Expense Summary (Air, Car, Hotel), Top 5 Airlines, Top 5 Cars and Top 5 Hotels with table. Air table = # of Tickets, Total Paid, Average $. Car table = # of Bookings, # of days, Total Paid, Average per day. Hotel table = # of Bookings, # of Nights, Total Paid, Average per Night. Grand Totals Provided. Average Rate = Total Amount / # of Nights for Car and Hotel; Average Amount = Total Amount / # of Tickets (Airlines).
33	Validated Carrier Analysis By Travel Type	validated Carrier Analysis By Travel Type. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers Excluded. Three parts to this report - Domestic, International and Grand Total. Report results include Fare Paid, % of Fare Paid, Average Fare, Net Transactions, % of Net Transactions, Total Paid and Grand Totals. Count Booking ID = Net Transactions.
38	Advance Purchase Summary by Sort 1	Advance Purchase Summary by Sort 1. This report includes Air and Rail. Transaction types include Sales ONLY. Vouchers Excluded. Summary for Advance days 0 to 20 and over 20. Grand Total provided. Report results are Sort 1, # of days Advance, Ticket Total $, % of Total, Volume, % of Volume, Average Price. Advance = Start Date > Issue Date and Total Paid not equal to zero; Average Price = Volume / Tickets.
39	Advance Purchase Summary by Sort 1 and Sort 2	Advance Purchase Summary by Sort 1and Sort 2. This report includes Air and Rail. Transaction types include Sales ONLY. Vouchers Excluded. Summary for Advance days 0 to 20 and over 20. Grand Total provided. Report results are Sort 1, Sort 2, # of days Advance, Ticket Total $, % of Total, Volume, % of Volume, Average Price. Advance = Start Date > Issue Date and Total Paid not equal to zero; Average Price = Volume / Tickets.
40	Air Spend By Month Summary	Air Spend By Month Summary - Bar Graph with Chart. This report includes Air ONLY, Transaction types Sales, Refunds and Exchanges. Vouchers excluded. Chart includes Month, Net Transactions, % of Net Transactions, Net Volume, % of Net Volume and Grand Total. Net Transactions calculated by Sales = 1, Refunds = -1 and Exchanges = 0.
41	Air Net Transactions By Month Summary	Air Net Transactions by Month Summary - Bar Graph with Chart. This report includes Air ONLY, Transaction types Sales, Refunds and Exchanges. Vouchers excluded. Chart includes Month, Net Transactions, % of Net Transactions, Net Volume, % of Net Volume and Grand Total. Net Transactions calculated by Sales = 1, Refunds = -1 and Exchanges = 0.
42	Top 5 Air, Car and Hotel Summary	Top 5 Air, Car and Hotel Summary. Three pie graphs with tables. This report includes Air, Car and Hotel. Transaction type Sales, Refunds and Exchanges. Vouchers excluded. Top Air Graph with chart showing Net Volume %, Top Car Graph with chart showing Net Volume % and Top Hotel Graph with chart showing Net Volume %. Grand Totals provided. Total Paid = Net Volume.
43	Top Sort1 Air Analysis	Top Air Analysis by Sort 1. Two Pie Graphs with table. This report includes Air ONLY. Transaction types Sales, Refunds and Exchanges. Vouchers excluded. Graphs - Net Tickets and Net Volume. Tables; Sort 1, Net Tickets, % of Net Tickets, Net Volume, $ of Net Volume. Grand Total Net Tickets calculated by Sales = 1, Refunds = -1, Exchanges =0. Total Paid = Net Volume
45	Savings Detail Full Fare By Sort1 and Sort 2	Savings Detail Full Fare By Sort1 and Sort 2. Page Break per Sort 1 and Sort 2; This report includes Air ONLY. Transaction types Sales, Refunds and Exchanges. Vouchers excluded. Report results are Sort 1, Sort 2, Reason Description, Reason Code, Passenger Name, Issue Date, Depart Date, Return Date, Airline Code, Itinerary, Ticket #, Full Fare, Fare Paid, Savings. Subtotal per Reason Code. Grand Total Provided. Start Date = Depart Date; End Date = Return Date; Itinerary by Code Only; Coach Fare = Full Fare.
46	validated Carrier Analysis	validated Carrier Analysis sorted by Carrier. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers Excluded. Report results include validated Carrier, Fare Paid, % of Fare Paid, Average Fare, Net Transactions, % of Net Transactions, Total Paid and Grand Totals. Count Booking ID = Net Transactions. Net Transactions calculated by Sales = 1, Refunds = -1 and Exchanges = 0. Fare Paid = Net Total Paid; Average Fare Paid = Fare Paid / # of Transactions.
47	Savings/Lost Savings Summary - Low Fare	Savings/Lost Savings Summary - Low Fare Sorted by reason code. The report includes Air and Rail. Transactions types Sales, Refunds and Exchanges. Vouchers excluded. Report results in reason code, Passenger Name, Issue Date, Depart Date, Return Date, Airline, Itinerary, Ticket low Fare, Fare Paid, Savings, Total Paid and reason description. This report includes Grand Totals. Start Date = Depart Date; End Date = Return Date, Vendor Code = Airline, document # = Ticket #.; Total Paid = Fare Paid; Low Fare - Total Paid = Savings.
51	Validated Carrier Analysis By Volume	validated Carrier Analysis Sorted by Volume This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers Excluded. Three parts to this report - Domestic, International and Grand Total. Report results include Fare Paid, % of Fare Paid, Average Fare, Net Transactions, % of Net Transactions, Total Paid and Grand Totals. Count Booking ID = Net Transactions.
52	Car Detail by Invoice Date	Car Detail Sorted by Invoice Date. This report includes Car ONLY. Vouchers excluded. The report results include Traveler, Car Company, City, Invoice #, Issue Date, Pick Up Date, Drop Off Date, Confirmation #, Class, # of days, Rate, Total before tax. The report Subtotals by Passenger Name. Grand Total provided. Start Date = Pick Up Date; End Date = Drop Off Date; document # = Confirmation #, duration * # of units = # of days.
53	Car Detail by Rate Category	Car Detail Sorted by Rate Category. This report includes Car ONLY. Vouchers excluded. The report results include Booking Rate Category, Traveler, Car Company, Car City, Invoice #, Issue Date, Pick Up Date, Drop Off Date, Confirmation #, # of days, Rate, Total $. Subtotaled by Booking Rate categories. Grand Totals Provided. Start Date = Pick Up Date; End Date = Drop Off Date; document # = Confirmation #.
54	Car Detail by Class Category	Car Detail Sorted by Class Category. This report includes Car ONLY. Vouchers excluded. The report results include Booking Class Rate Category, Traveler, Car Company, Car City, Invoice #, Issue Date, Pick Up Date, Drop Off Date, Confirmation #, # of days, Rate, Total $. Subtotaled by Booking Rate categories. Grand Totals Provided. Start Date = Pick Up Date; End Date = Drop Off Date; document # = Confirmation #.
55	Hotel Detail	Hotel Detail Report. This report is Hotels ONLY. Vouchers excluded. The report results Traveler, Hotel property, Hotel City, Invoice #, Issue Date, Check-in, Check-out, Confirmation #, # of Nights, Rate, Total Paid. Grand Total provided.
56	Hotel Detail by Rate Category	Hotel Detail Report Sorted by Rate Category. This report is Hotels ONLY. Vouchers excluded. The report results Rate, Traveler, Hotel property, Hotel City, Invoice #, Issue Date, Check-in, Check-out, Confirmation #, # of Nights, Rate, Total Paid. Subtotaled by Rate categories. Grand Total provided.
57	Hotel Detail by Class Category	Hotel Detail Report Sorted by Class Category. This report is Hotels ONLY. Vouchers excluded. The report results Class, Traveler, Hotel property, Hotel City, Invoice #, Issue Date, Check-in, Check-out, Confirmation #, # of Nights, Rate, Total Paid. Subtotaled by Class categories. Grand Total provided.
58	Traveler Activity By Invoice	Traveler Activity by Invoice. Transaction types Sales, Refunds and Exchanges. Vouchers excluded. The report results in Invoice #, type of travel, Issue Date, Traveler, Ticket # / Confirmation #, Total Paid, from Date, to Date, cities, vendor. The report is Subtotaled by Invoice number. Grand Total is provided.
59	Service Fees By Month Summary	Service Fees By Month Summary. This report is Service Fees ONLY. Transaction types Sales, Refunds and Exchanges. Voids and Vouchers Excluded. The report results in a Bar Chart representing each month Service Fee. Summary report included with Month, Net Transactions, % of Transactions, Fee Expense, % of Fee Expense, Average Fee. Formulas: Transactions are counted as Sales = 1; Refunds = -1; Exchanges = 0; Average Fee Expense = Fee Expense / Net Transactions.
60	Travel Spend By Category By Month Summary	Travel Spend By Category By Month Summary. This report creates three separate bar charts on Air, Car and Hotel Sales. Transactions type Sales, Refunds and Exchanges. Voids and Vouchers Excluded. Chart # 1 - Air Activity By Month Summary. Bar Chart represents each months Total Amount. Summary report includes Month, Net Transactions, % of Net Transactions, Amount, % of Amount, Average Amount. Chart # 2 - Car Activity By Month Summary. Bar Chart represents each months Total Amount. Summary report includes Month, Net Transactions, % of Net Transactions, Amount, % of Amount, Average. Chart # 3 - Hotel Activity By Month Summary. Bar Chart represents each months Total Amount. Summary report includes Month, Net Transactions, % of Net Transactions, Amount, % of Amount, Average. Formulas: Transactions are counts as Sales = 1, Refunds = -1, Exchanges = 0; Net Total Paid = Amount; Average = Amount / Net Transactions.
61	Where Are My Travelers	Where Are My Travelers. This report shows by Traveler Name the active trips they are currently on based on the day the report was printed. Grey sections indicate portions of travel that have already been completed. Report results in Traveler Name, Invoice Date, Depart Date/Time, Departure City, Airline/Flight#, Arrival City, Arrival Date/Time. Formulas: Start Date = Depart Date; End Date = Arrival Date; City Name and City Code provided; Airline Code Only.
62	Air Activity with Service Fees by Invoice Date	Air Activity with Service Fees by Invoice Date. This report is Air, Rail and Service Fees. Transaction type = Sales, Refunds and Exchanges. Voids and Vouchers Excluded. Report results in Issue Date, Passenger Name , Invoice #, Ticket #, Amount, Segment Information - Airline Code, Flight #, Class of Service, Depart Date, From, To. Grand Total Provided. City Information includes City Name and City Code. Amount = Total Paid.
63	Air Activity Summary By Price	Air Activity Summary By Price. This report includes Air and Rail. Transaction types Sales, Refunds, and Exchanges. Voids and Vouchers Excluded. Report results in Price Range, Fare Paid, % of Total, Transactions, % of Transactions, Average Fare Paid. Grand Total Provided. Formulas: Fare Paid = Total Paid; Transactions = Net Transactions calculated as Sales = 1, Refunds = -1, Exchanges = 0; Average Fare Paid = Fare Paid / Transactions.
64	Hotel Commission Detail By Sort1 and Sort2	Hotel Commission Detail By Sort 1 and Sort 2 then Invoice Date and Traveler Name. Hotels ONLY. Vouchers Excluded. The report results in Sort 1, Sort 2, Traveler Name, Hotel Property, City, Issue Date, Check In, Nights, Rate, Total Paid, Commission, Status. Grand Total Provided. Start Date = Check In Date. Total Paid = # of Nights * Rate / Day.
65	Traveler Activity By Invoice With Sort 1	Traveler Activity by Invoice including Sort 1. Transaction types Sales, Refunds and Exchanges. Voids and Vouchers excluded. The report results in Invoice #, type of travel, Issue Date, Traveler Name, Ticket # / Confirmation #, Amount, From Date, To Date, Sort 1,Cities, Vendor Name. The report is Subtotaled by Booking Type and Totaled by Invoice number. Grand Total is provided. Start Date = From Date: End Date = To Date; Cities by City Code Only; Amount = Total Paid.
66	Traveler Activity By Invoice With Sort 1 with Sort 2 and 3	Traveler Activity by Invoice including Sort 1, Sort 2, Sort 3. Transaction types Sales, Refunds and Exchanges. Voids and Vouchers excluded. The report results in Invoice #, type of travel, Issue Date, Traveler Name, Ticket # / Confirmation #, Amount, From Date, To Date, Sort 1,Sort 2, Sort 3Cities, Vendor Name. The report is Subtotaled by Booking Type and Totaled by Invoice number. Grand Total is provided. Start Date = From Date: End Date = To Date; Cities by City Code Only; Amount = Total Paid.
68	Traveler Activity By Sort1 By Passenger Name with Sort 2 and 3	Traveler Activity by Passenger Name and by Sort 1 including Sort 2 and Sort 3. Transaction types Sales, Refunds and Exchanges. Voids and Vouchers excluded. The report results in Passenger Name , Sort 1, Invoice #, type of travel, Issue Date, Ticket # / Confirmation #, Amount, From Date, To Date, Sort 2, Sort 3, Cities, Vendor. The report is Subtotaled by Invoice and Totaled by Passenger Name. Grand Total is provided. Start Date = From Date: End Date = To Date; Cities by City Code Only; Amount = Total Paid.
69	Airline Contract Report - AA	Airline Contract Report - AA. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. Voids and Vouchers excluded. The report results in Market Pair, Ticketed Trips (All, AA, AA %), Segment Volume (All, AA, AA %). Grand Total provided. Calculations: AA % = AA/All.
70	Airline Contract Report - UA	Airline Contract Report - UA. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. Voids and Vouchers excluded. The report results in Market Pair, Ticketed Trips (All, UA, UA %), Segment Volume (All, UA, UA %). Grand Total provided. Calculations: UA % = UA/All.
71	Airline Contract Report - US	Airline Contract Report - US. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. Voids and Vouchers excluded. The report results in Market Pair, Ticketed Trips (All, US, US %), Segment Volume (All, US, U %). Grand Total provided. Calculations: US % = US/All.
72	Advance Purchase Detail - 14 Days or Less	Advance Purchase Detail sorted by 14 Days or Less. This report includes Air and Rail. Transactions type Sales ONLY. Vouchers Excluded. The report results in Passenger Name , Issue Date, Depart, Return, Airline Code, Itinerary, Fare Paid. Subtotaled by # of Days Advance. Grand Total Provided. Start Date = Depart Date; End Date = Return Date; Itinerary by city Code; Fare Paid = Total Paid.
73	Advance Purchase Detail - 7 Days or Less	Advance Purchase Detail sorted by 7 Days or Less. This report includes Air and Rail. Transactions type Sales ONLY. Vouchers Excluded. The report results in Passenger Name , Issue Date, Depart, Return, Airline Code, Itinerary, Fare Paid. Subtotaled by # of Days Advance. Grand Total Provided. Start Date = Depart Date; End Date = Return Date; Itinerary by city Code; Fare Paid = Total Paid.
74	Advance Purchase Savings Detail - 14 Days or Less	Advance Purchase Detail sorted by 14 Days or Less. This report includes Air and Rail. Transactions type Sales ONLY. Vouchers Excluded. The report results in Passenger Name , Issue Date, Depart, Return, Airline Code, Itinerary, Fare Paid, Fare Offered, Savings/Loss. Subtotaled by # of Days Advance. Grand Total Provided. Start Date = Depart Date; End Date = Return Date; Itinerary by city Code; Fare Paid = Total Paid; Fare Offered = : Savings/Loss = .
75	Advance Purchase Savings Detail - 7 Days or Less	Advance Purchase Detail sorted by 7 Days or Less. This report includes Air and Rail. Transactions type Sales ONLY. Vouchers Excluded. The report results in Passenger Name , Issue Date, Depart, Return, Airline Code, Itinerary, Fare Paid, Fare Offered, Savings/Loss. Subtotaled by # of Days Advance. Grand Total Provided. Start Date = Depart Date; End Date = Return Date; Itinerary by city Code; Fare Paid = Total Paid; Fare Offered = : Savings/Loss = .
76	Executive Summary Report - No Savings	Executive Summary Report - No Savings This report includes Air, Rail, Car and Hotel. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. Reports on Current Month and Year to Date. The report results in Air travel purchase, Hotel reservations, Car reservations broken down by domestic, international and transborder. Grand Total of all three at bottom of report. Total Ticket Volume = Sales Only; Total Volume Refunded = Refunds; Total Ticket Transactions = Net Transaction (Sales = 1; Refunds = -1; Exchanges = 0); Average #'s = Volume / # of Nights.
77	Where Are My Travelers by OA	Where Are My Travelers sorted by Outside Agent. This report shows by Traveler Name the active trips they are currently on based on the day the report was printed. Grey sections indicate portions of travel that have already been completed. Report results in Traveler Name, Invoice Date, Depart Date/Time, Departure City, Airline/Flight#, Arrival City, Arrival Date/Time. Formulas: Start Date = Depart Date; End Date = Arrival Date; City Name and City Code provided; Airline Code Only.
78	Passenger Name Invoice Summary By Sort 1,Sort2	Passenger Name Invoice Summary By Sort 1 and Sort2. This reports includes Air, Rail, Car, Hotel and Service Fee. Transaction types include Sales, Refunds and Exchanges. Vouchers Excluded. Report results include Traveler, Issue Date, Invoice, Arrive Date, City/State, Air Fare, Fee, Hotel Rate, Hotel Amount, Car Rate, Car Amount, Total Cost. Subtotal by Sort. Grand Total provided. Start Date = Arrive Date; Hotel Amount = # of Nights * Rate; Car Amount = # of Nights * Rate; Total Cost = Total Paid. Report includes travel with air segment and all items issued on the same invoice.
79	Passenger Name Invoice Export By Sort 1,Sort2	Passenger Name Invoice Export By Sort 1 and Sort2. This reports includes Air, Rail, Car, Hotel and Service Fee. Transaction types include Sales, Refunds and Exchanges. Vouchers Excluded. Report results include Traveler, Issue Date, Invoice, Arrive Date, City/State, Air Fare, Fee, Hotel Rate, Hotel Amount, Car Rate, Car Amount, Total Cost. Subtotal by Sort. Grand Total provided. Start Date = Arrive Date; Hotel Amount = # of Nights * Rate; Car Amount = # of Nights * Rate; Total Cost = Total Paid. Report includes travel with air segment and all items issued on the same invoice.
80	Traveler Insurance Report By Sort1/Sort2	Traveler Insurance Report sorted by Domestic/International, Sort 1 and Sort 2. This report includes Air and Rail. Transaction types includes Sales, Refunds and Exchanges. Vouchers Excluded. Report results in Domestic/International, Sort 1, Sort 2, Duration, Ticket #, Depart Date, Origin, Destination, Net Trip. Subtotaled by Sort. Grand Total provided. Start Date = Depart Date. Duration = End Date - Start Date.
81	Traveler Insurance Report	Traveler Insurance Report sorted by Domestic/International. This report includes Air and Rail. Transaction types includes Sales, Refunds and Exchanges. Vouchers Excluded. Report results in Domestic/International, Duration, Ticket #, Depart Date, Origin, Destination, Net Trip. Subtotaled by Sort. Grand Total provided. Start Date = Depart Date. Duration = End Date - Start Date.
82	GDS Service Fee Detail Report	GDS Distribution Fee Detail Report sorted by Passenger Name. This report includes Booking Type = Air and Document Type = A. Transaction types includes Air ONLY. Vouchers Excluded. Report results include Issued, Passenger Name , Record Locator, Invoice #, Ticket #, Amount, Segment Information - Airline, Flight #, Class, Depart, From, To. Grand Total provided. From = City Name and Code; To = City Name and Code; Amount = Total Paid; Total Paid <> $ 0.
87	Exchange Ticket Cost Report	Exchange Ticket Cost Report Sorted by Passenger Name. This report includes Air and Rail. Transaction types include Sales and Exchanges. Vouchers excluded. Report results include Passenger Name, Issue Date, Depart Date, Return Date, Airline Code, Itinerary, Record Locator, Invoice #, Ticket #, Origin Ticket # and Total. Subtotaled per Invoice #. Grand Total provided. Start Date = Depart Date; End Date = Return Date; Itinerary by City Code Only; Total = Total Paid.
90	Savings-Lost Savings Detail By Sort 1	Savings-Lost Savings Detail Sorted by Sort 1. The report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers Excluded. Report results include Sort 1, Passenger Name, Advance, Issued, Depart, Airline Code, Itinerary, Fare Paid, Low Fare, Save/Lost Savings. Subtotaled by Sort 1. Grand Total provided. Formulas: Total Paid <> $ 0; Advance Purchase = Start Date - Issue Date; Start Date = Depart Date; Fare Paid = Total Paid; Save/Lost Savings = Total Paid - Low Fare; Itinerary w/ Full City Name.
91	Savings-Lost Savings Detail	Savings-Lost Savings Detail sorted by Reason Code then Passenger Name . The report includes Air and Refund. Transaction types include Sales, Refunds, Exchanges. Vouchers Excluded. Report results include Reason Code, Passenger Name, Advance, Issued, Depart, Airline Code, Itinerary, Fare Justification, Fare Paid, Low Fare, Save/Lost Savings. Subtotaled by Reason Code, Grand Total provided. Advance Purchase = Start Date - Issue Date; Start Date = Depart Date; Fare Paid = Total Paid; Save/Lost Savings = Total Paid - Low Fare; Itinerary w/ Full City Name.
92	Advance Purchase Detail - Potential Savings By Sort1	Advance Purchase Detail - Potential Savings Sorted by Sort 1. This report includes Air ONLY. Transaction types include Sales ONLY. Vouchers Excluded. Report results include Passenger Name , Advance, Issued, Depart, Airline Code, Itinerary, Fare Paid, Potential Savings. Subtotal on Advance Days. Grand Total provided. Total Paid <> $ 0; Advance Purchase = Start Date - Issue Date; Start Date = Depart Date; Fare Paid = Total Paid; Potential Savings = Fare Paid * 38 %; Start Date - Issue Date < 14 Days.
93	Airline Contract Report - DL	Airline Contract Report - DL. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. Vouchers and Vouchers excluded. The report results in Market Pair, Ticketed Trips (All, DL, DL %), Segment Volume (All, DL, DL %). Grand Total provided. Calculations: DL % = DL/All.
94	Passenger Name Invoice Detail with Sort1 and Sort2	Passenger Name Invoice Detail with Sort 1 and Sort 2. The report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Voucher Excluded. Report results include Traveler Name, Issue Date, Invoice, Arrive Date, City/State, Air Fare, Fee, Hotel Rate, Hotel Amount, Car Rate, Car Amount, Total Cost. Subtotal by Sort. Grand Total provided. Start Date = Arrive Date; Hotel Amount = # of Nights * Rate; Car Amount = # of Nights * Rate; Total Cost = Total Paid. Report includes travel with air segment and all items issued on the same invoice.
95	Passenger Name Invoice Detail By Sort1 with Sort2	Passenger Name Invoice Detail by Sort 1 and Sort 2. The report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Voucher Excluded. Report results include Sort 1, Sort 2, Traveler Name, Issue Date, Invoice, Arrive Date, City/State, Air Fare, Fee, Hotel Rate, Hotel Amount, Car Rate, Car Amount, Total Cost. Subtotal by Sort. Grand Total provided. Start Date = Arrive Date; Hotel Amount = # of Nights * Rate; Car Amount = # of Nights * Rate; Total Cost = Total Paid. Report includes travel with air segment and all items issued on the same invoice.
98	Executive Summary Sort1 Sort2	Executive Summary with Sort1 and Sort2. This report includes Air, Rail, Car and Hotel. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report is broken into three area - Domestic, International and Grand Total. The report results in Total Ticket Volume Issues, Total Ticket Volume Exchanged, Total Ticket Volume Refunded, Net Ticket Volume, Average Ticket Price, Total Tickets Issues, Total Tickets Exchanged, Total Tickets Refunded, Net Tickets Issued, Tickets Voided, Total Car Volume, Average Car Rate, Total Car Reservations, Total Car Days, Total Hotel Volume, Average Hotel Rate, Total Hotel Reservations, Total Hotel Room Nights. Total Paid = Ticket Volume = Car Volume = Hotel Volume; Transaction Count calculated as follows: Sales = 1; Refunds =1, Exchanges =1.
99	Hotel Detail by Rate Category Sort1	Hotel Detail Report Sorted by Rate Category and Sort 1. This report is Hotels ONLY. Vouchers excluded. The report results Rate, Sort 1, Traveler, Hotel property, Hotel City, Invoice #, Issue Date, Check-in, Check-out, Confirmation #, # of Nights, Rate, Total Paid. Subtotaled by Rate categories. Grand Total provided.
105	Arrival Manifest	Arrival Manifest. This report includes Air and Rail. Transactions types include Sales and Exchanges. Vouchers Excluded. Report results in Long Date, Arrival City Name and Code, Arrival Time, Traveler Name; Arrival short date and time, Airline Code, Flight #, From Airport, Origin Airport. Summary by Traveler. Total Summary of all Travelers. This report uses the Master City Table. Report parameters include: Start Date not NULL; End Date not NULL; Reissues not included.
106	Departure Manifest	Departure Manifest. This report includes Air and Rail. Transactions types include Sales and Exchanges. Vouchers Excluded. Report results in Long Date, Depart City Name and Code, Depart Time, Traveler Name; Depart short date and time, Airline Code, Flight #, From Airport, Origin Airport. Summary by Traveler. Total Summary of all Travelers. This report uses the Master City Table. Report parameters include: Start Date not NULL; End Date not NULL; Reissues not included.
107	Air Activity With CC By Sort1	Air Activity With Credit Card # by Sort1, then Issued Date, then Passenger Name. This report includes Air, Rail and Service Fees and excludes Voids. Report results include Passenger Name, Issue Date, Depart Date, Return Date
109	Executive Summary Report - No Savings - CPM	Executive Summary Report - No Savings - CPM. Current Year Month to Previous Year Month / Current Year to Date to Previous Year to Date. This report includes Air, Rail, Car and Hotel. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results include Domestic and International Summary for Air, Rail, Car and Hotel. Grand Total for each category provided. Coach = Full Fare. Volume Issued = Sales Invoices; Volume Refunded = Refund Invoices; Net Volume = Sales - Refunds; Net Savings = High Fare - (Sales + Refunds)
110	Air Activity With CC With Sort1	Air Activity With CC With Sort1. This report includes Air, Rail and Service Fees. Transaction types include Sales, Refunds and Exchanges. Voids and Vouchers Excluded. Report results include Passenger Name, Issue Date, Depart Date, Return Date, Airline, Itinerary, Invoice #, Ticket #, Original Ticket # and Fare Paid $. Grand Total provided. Start Date = Depart Date; End Date = Return Date; Total Paid = Fare Paid. Itinerary by Code only.
115	Air Activity Cost Savings By Sort1	Air Activity Cost Savings By Sort1. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Voids and Vouchers Excluded. Domestic and International reported separately. Report results are Issue Date, Booking Date, Passenger Name, Sort 1, Invoice #, Ticket #, Fare Paid, Full Fare, Low Fare, Savings, Reason Description, Airlines, Flight #, Class, Depart Date, From City, To City - Subtotal by Passenger Name. Passenger Name Summary provided at end of detail - Passenger Name, # of Transactions, Total Fare Paid, % of Total Fare, Savings. Total Paid = Fare Paid, Coach = Full Fare. Three reports in one - Activity by Passenger Name detail; Reason Code Summary by Reason Code; Passenger Name Summary Sorted by Fare Paid. Itinerary includes both Code and Name.
118	Complete Executive Summary By Sort1 and Sort 2	Complete Executive Summary By Sort1 and Sort 2 showing Current Period and Year to Date. Vouchers Excluded. The report results in Sales, Mileage, Average and Totals. Count = Transaction Count = All Transitions = 1.
119	Validated Carrier Analysis	validated Carrier Analysis. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers Excluded. Three parts to this report - Domestic, International and Grand Total. Report results include Agent, Fare Paid, % of Fare Paid, Average Fare, Net Transactions, % of Net Transactions, Total Paid and Grand Totals. Count Booking ID = Net Transactions.
120	Exchange Ticket Cost Report With Sort1	Exchange Ticket Cost Report Sorted with Sort 1 - Sorted by Passenger Name. This report includes Air ONLY. Transaction types include Sales and Exchanges. Vouchers excluded. Report results include Passenger Name, Issue Date, Depart Date, Return Date, Airline, Itinerary, Record Locator, Invoice #, Ticket #, origin $ and Total Cost.
121	Air Detail with Service Fees by Passenger Name	Air Detail with Service Fees sorted by Passenger Name. This report includes Air, Rail and Service Fee. The transaction types include Sales, Refunds, and Exchanges. Vouchers excluded. This report results in information by Passenger Name - Issued Date, Passenger Name , Invoice #, Ticket #, Amount, Airline Code, Flight #, Class, Depart Date an time, From City Name and Code, To City Name and Code, Arrive date and time. Calculations used in this report include Issued Date = Booked date; Document # = Ticket #, Total Paid = Fare Paid = Amount, Master City Table and Segment Table used.
122	Air Detail with Service Fees by Passenger Name With Sort1	Air Detail with Service Fees by Passenger Name includes Sort1. This report includes Air, Rail and Service Fee. The transaction types include Sales, Refunds, and Exchanges. Vouchers excluded. This report results in information by Passenger Name - Issued Date, Passenger Name , Invoice #, Ticket #, Amount, Airline Code, Flight #, Class, Depart Date an time, From City Name and Code, To City Name and Code, Arrive date and time. Calculations used in this report include Issued Date = Booked date; Document # = Ticket #, Total Paid = Fare Paid = Amount, Master City Table and Segment Table used.
123	Air Detail with Service Fees by Passenger Name By Sort1	Air Detail with Service Fees by Passenger Name then sorted by Sort1. This report includes Air, Rail and Service Fee. The transaction types include Sales, Refunds, and Exchanges. Vouchers excluded. This report results in information by Passenger Name - Issued Date, Passenger Name , Invoice #, Ticket #, Amount, Airline Code, Flight #, Class, Depart Date an time, From City Name and Code, To City Name and Code, Arrive date and time. Calculations used in this report include Issued Date = Booked date; Document # = Ticket #, Total Paid = Fare Paid = Amount, Master City Table and Segment Table used.
124	Air Analysis By Month Summary	Air Analysis By Month Summary. Three bar charts and one summary table. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. Report results in Net Spend by Month Bar Chart, Net Transactions by Month bar Chart and Average Spend by Month bar Chart. Summary Table includes Month, Net Tickets, % of transactions, Net Volume, % of Volume, Average. Calculations used in report are Total Paid = Net Volume; Net Transactions Total as Sales = 1, Exchanges = 1 and Refunds = -1; Issue Date used for Year, Month and Day breakouts.
126	Travel Analysis By Category By Month Summary	Travel Analysis By Category By Month Summary. Three bar charts and one summary table. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. Report results in Net Spend by Month Bar Chart, Net Transactions by Month bar Chart and Average Spend by Month bar Chart. Summary Table includes Month, Net Tickets, % of transactions, Net Volume, % of Volume, Average. Calculations used in report are Total Paid = Net Volume; Net Transactions Total as Sales = 1, Exchanges = 1 and Refunds = -1; Issue Date used for Year, Month and Day breakouts
130	Vendor Analysis Report	Vendor Analysis Report - Summary Report and Pie Chart. Transaction type Sales, Refunds and Exchanges. Vouchers excluded. Top 10 Vendors and the balance of the vendors totaled together. Report results in Vendor Name; Fare Paid; % Total; Transactions; % Total; Average Fare Paid. Grand Total provided. Calculations include: Net Transaction Count = Sales (1), Refunds (-1) and Exchanges (0); Total Paid = Net Amount.
133	Air and Service Fee Detail By Passenger Name with Reason	Air and Service Fee Detail sorted By Passenger Name with Reason. Detail report with Pie Chart based on reason code and savings. This report includes Air and Service Fees. Transaction Types include Sales, Refunds and Exchanges. Vouchers excluded. Detail report includes Issue date; Passenger Name ; Ticket #; Advance Purchase; Fare Paid, Fare Offered; Savings/Loss Reason; Trip Segments with Depart Date, Airline Code, From City Name and To City Name. Subtotaled per Traveler. Grand Total provided. Master City Table and Segment Table used for this report. Calculations include; Issue Date = Invoice Date; Depart City = Origin Airport; Arrive City = Destination Airport; Total Paid = Invoice Amount; Low Fare = Fare Offered.
142	Refund Fee Detail Report By Outside Agent	Refund Fee Detail Report By Outside Agent. The report includes Refunds ONLY. Vouchers excluded. This report includes Booking type = Air AND Document type = A. This report includes Agent Name, Issue Date; Passenger Name ; Record Locator; Invoice #; Ticket #; Amount; Airline code; Flight #; Class; Depart Date; From City Code and Name; To City Code and Name; This report uses Master City Table and Segment Table. Issue Date = Issued = Booked. Total Paid = Fare Paid.
145	Lost Savings Detail Report	Lost Savings Detail Report sorted by Reason Code and Passenger Name . The report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. Report parameter = Total Paid > Low Fare Only. The report results are Reason Code, Passenger Name , Advance Purchases, Issue Date, Depart Date, Airline Code, Itinerary by Code, Fare Paid, Low Fare, save/Lost Savings. Grand Total included. Calculations used: Issue date = Issued = Booked; Total Paid = Fare Paid; Payment # = Bill To; Coach = High Fare.
149	Lost Savings By Pass With Sort1	Lost Savings By Pass With Sort 1. This report includes Air and Rail. Transaction type includes Sales, Refunds and Exchanges. Vouchers excluded. Report results by Passenger Name , Invoice type, Issue Date, Booked date, Passenger Name , Sort 1, Invoice #, Ticket #, Fare Paid Full Fare, Low Fare, Saved, Reason Code/Description, Airline Code, Flight #, Class, Depart Date, Depart City and Code, To City and Code. Includes Summary by Traveler at the end of the report. Transaction type = Invoice type; Total Paid = Fare Paid; Coach Full = Full Fare.
164	Advance Purchase Detail By Sort1 and Sort2	Advance Purchase Detail By Sort 1 and Sort 2. This report includes Air and Rail. Transactions type Sales ONLY. Vouchers Excluded. The report results in Passenger Name , Issue Date, Depart Date, Return Date, Airline Code, Itinerary by City Code, Invoice, and Total Cost. Subtotaled by # of Days Advance. Grand Total Provided. Start Date = Depart Date; End Date = Return Date; Itinerary by city Code.
165	Graphic Executive Summary	Graphic Executive Summary. Graphs include sales only for Air and Rail transactions. Refunds, Exchanges and Voids are excluded. This report displays Air sales, Tickets issued, Average Ticket Price, Car Volume Booked, Car Days Booked, Car Average Booked Daily Rate, Hotel Volume Booked, Hotel Nights Booked, Hotel Average Booked Rate.
167	Savings Detail Full Fare	Savings Detail Full Fare. This report includes Air, Rail and Service Fees and excludes Voids. Sort order is by Division, Issued Date then Passenger Name. Report results are Sort 1, Sort 2, Reason Description, Reason Code, Passenger Name, Issue Date, Depart Date, Return Date, Airline Code, Itinerary, Ticket #, Full Fare, Fare Paid, Savings. Subtotal per Reason Code. Grand Total Provided. Start Date = Depart Date; End Date = Return Date; Itinerary by Code Only; Coach Fare = Full Fare.
168	Traveler Insurance Report Simple	Traveler Insurance Report Simple sorted by Domestic/International. This report includes Air and Rail. Transaction types includes Sales, Refunds and Exchanges. Vouchers Excluded. Report results in Domestic/International, Duration, Ticket #, Depart Date, Routing, Net Trip. Subtotaled by Sort. Grand Total provided. Start Date = Depart Date. Duration = End Date - Start Date.
169	Hotel Summary By Top Cities By Property	Hotel Summary By Top Cities By Property This report includes Hotel ONLY. Vouchers excluded. The report results in Hotel property City/state, Hotel name, top 5 properties in City, # of Bookings each, % of Total books per City, # of Nights in City, % of Total Nights per City, Average Rate, Total Paid, % of Total Paid per City. Grand Totals of all properties per City included.
170	Hotel Summary By Top Metro Areas By Property	Hotel Summary By Top Metro Areas By Property This report includes Hotel ONLY. Vouchers excluded. The report results in Hotel property City/state, Hotel name, top 5 properties in metro area, # of Bookings each, % of Total books per City, # of Nights in City, % of Total Nights per City, Average Rate, Total Paid, % of Total Paid per City. Grand Totals of all properties per metro area included.
171	Agent Summary Report	Agent Summary Report Sorted by Inside Agent and Outside Agent. Within each category - Sorted alphabetically. This report includes all Sales types and Transaction types. Vouchers are excluded. Report results include agent name, Net Volume, % of Total Volume of all agents, Transactions, % of Total Transactions of all agents, Average Booking, Booking commission and % Total commission for all agents.
172	First and Business Class Detail by Passenger Name	First and Business Class Detail sorted by Passenger Name. This report includes Air and Rail. Transaction type includes Sales, Refunds and Exchanges. Vouchers Excluded. Report results by Passenger Name , Invoice #, Ticket #, Amount, Issue Date, Passenger Name , Airline Code, Flight #, Class, Depart Date and Time, From City Name and Code, To City Name and Code, Arrival Date and Time. Subtotaled by Passenger Name. Grand Total provided. Total Paid = Fare Paid.
174	Arrival Departure Export	Arrival Departure Export. This report includes Air and Rail. Transaction type Sales and Exchanges. Voids and Vouchers Excluded. Does not include reissues and segments with connection code = "X". Report results in Traveler Name, Arrive city Name and Code, Arrival Date, Airline Code, Flight #, From City Name and Code, Depart Time, Arrival Time, Depart Date, Airline Code, Depart Time, Cost. No subtotals or Grand Total on this report.
175	Fare Savings Analysis By Sort1	Fare Savings Analysis By Sort 1. This report includes Air and Rail. Transaction types include Sales and Exchanges. Vouchers Excluded. Report sorted by Sort 1 then by Passenger Name . Report order is Passenger Name , Issue Date, Invoice #, Depart Date, Origin City Name and Date, Destination Name and Date, Airline Code, Full Fare, Fare Paid, Fare Savings, Reason Code. Subtotaled by Sort 1. Grand total provided. Parameters: Total Paid = Fare Paid; Coach Fare = High Fare; Class = Fare Basis.
176	Top 25 Traveler Spend By Volume	Top 25 Traveler Spend By Volume. This report includes Air, Car, Hotel and Service Fees. Transaction types include Sales, Refunds and Exchanges. Vouchers Excluded. Report sorted by Total Spend. Report results are Traveler Name, # of Invoices, Air Data (Net Tickets, # Travel Days, Air Spend), Car Data (# of Cars, # of Days, Car Spend), Hotel Data (# of Rooms, # of Nights, Hotel Spend), Total Spend. Grand Total provided. Invoices = Distinct Count on Invoice Numbers; Net Tickets = Net Transaction Count (Sales = 1, Refunds = -1, Exchanges = 0); Total Paid = Spend Amount.
179	Agency User Activity Report	Agency User Activity Report. Report results in Client Name, User Access, User Name, Login Count, Last Login date and time; # of reports assigned to user; # of reports used by user; # of reports in history of user; Last report run date; # of batches.
180	Top 100 Travelers by Transactions	Top 100 Travelers Sorted by Transactions This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results in Traveler name, Gross Fare Paid, % of Total Gross Fare Paid, Average Ticket price, # of Transactions, % of Total Transactions. Grand Total included.
181	Top 100 Travelers by Volume	Top 100 Travelers Sorted by Volume This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results in Traveler name, Gross Fare Paid, % of Total Gross Fare Paid, Average Ticket price, # of Transactions, % of Total Transactions. Grand Total included.
182	Credit Card Detail By Passenger Name with Sort 1	Credit Card Detail By Passenger Name with Sort 1. This report includes Air, Rail and Service Fees. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. Report sorted by Passenger Name and includes Ticket # Issue date, Itinerary, Depart Date, Return Date, Total Paid, encrypted credit card #, Sort 1. Grand total provided. Parameters included: Start Date = Depart Date; End Date = Return Date; Total Paid = Fare Paid.
184	Sales Report By Invoice With Sort1	Sales Report By Invoice With Sort 1. This report includes Air, Rail and Service Fees. Transaction types of Sales, Refunds and Exchanges. Vouchers Excluded. Report results: Invoice #, Invoice Date, Passenger Name, Ticket # Original Ticket #, Total Paid, Sort 1. Grand Total Provided.
185	Void Activity By Invoice.	Void Activity By Invoice. This report includes Air, Rail and Service Fees. Transaction Type Voids ONLY. Report results in Passenger Name , Issue Date, Depart Date, Return Date, Airline Code, Itinerary, Invoice #, Ticket #, Original Ticket #, Total Paid, Grand Total Provided. Parameters included: Start Date = Depart Date; End Date = Return Date; Total Paid = Fare Paid.
186	Arrival Departure Export Small	Arrival Departure Export Small. This report includes Air and Rail. Transaction type Sales and Exchanges. Voids and Vouchers Excluded. Does not include reissues and segments with connection code = "X". Report results in Traveler Name, Arrival Date, Arrival Time, Airline Code, Flight #, Origin City Code, Destination City Code, , Depart Date, Depart Time, Airline Code, Flight #, Origin City Code and Destination City Code. No subtotals or Grand Total on this report.
188	Top 50 Market Pair With Airlines	Top 50 Market Pair With Airlines. Listed alphabetically by the Market Pair and then by # of Trips. This report includes Air ONLY. Transaction type Sales ONLY. Vouchers excluded. Report results Market Pair, Airline Code, Net Trips, % of Trips, Net Volume, % of Volume. Grand Total provided. Net Trips = Booking ID Count; Net Volume = City Pair Fare.
192	Traveler Analysis Sort By Total Spend	Traveler Analysis Sort By Total Spend. This report includes Air, Car, Hotel and Service Fees. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results by Traveler Name and includes Trip Count, Air Amount, Fee Amount, Hotel Amount, Hotel Nights, Car Amount, Total Cost, Average Air Cost / Trip Average Hotel Night Expense, Average Cost / Trip, Trip Count, Average Cost / Trip, Total Cost. Grand Total Provided.
201	Arrival Departure Reports Combined	Arrival Departure Reports Combined. This report includes Air and Rail. Transaction type Sales and Exchanges. Vouchers Excluded. Reissued Tickets Excluded. Report results in Date, Day Time, AM/PM, Airline Code, Flight #, From City Name, Passenger Name, Record #, Booking ID, Arrival City Name, Origin City Name. This report does not have subtotals or Grand Totals. Master City Table used for this report.
205	Vendor Analysis By Division	Vendor Analysis By Division Summary Report. Transaction type Sales, Refunds and Exchanges. Vouchers excluded. Report results in Vendor Name; Fare Paid; % Total; Transactions; % Total; Average Fare Paid. Subtotaled by Booking Type. Grand Total provided. Calculations include: Net Transaction Count = Sales (1), Refunds (-1) and Exchanges (0); Total Paid = Net Amount.
208	Form of Payment Report with Sort1 and Sort2	Form of Payment Report with Sort 1 and Sort 2. This report includes Air, Rail and Service Fees, The transaction type is Sales, Refunds and Exchanges. Vouchers Excluded. The report results in Credit Card #, Issue Date, Passenger Name , Sort 1, Sort 2, Invoice #, Amount, Depart Date, Airline Code and Routing. Subtotal per credit card number. Grand total provided at end of report.
210	Graphical Air Volume Summary	Graphical Air Volume Summary. . This report includes Air and Rail. Transaction types are Sales, Refunds and Exchanges. Vouchers Excluded. The report results in Three Categories: Domestic, International and Grand Total. The information under each category is Trips, % of Trips. Volume % of Volume and Average. Grand Total Provided. Two charts at the bottom -Pie Chart Domestic Vendor Contribution; International Vendor Contribution.
211	Graphical Car Summary By Company	Graphical Car Summary By Company. This report is CAR ONLY. Vouchers Excluded. The report results in Company sort then Car Company, Bookings, % of Bookings, Car Days, % of Car Days, Average Rate, Total Paid, Percentage of Total Paid. Pie Char based on Car Spend at the bottom. Report calculates on Total Paid > 0.
213	Graphical HotelSummary By Top Cities By Property	Graphical Hotel Summary By Top Cities By Property . This report is Hotel ONLY. Vouchers excluded. The report results in Hotel City with Properties, Bookings, % of Bookings, Nights, % of Nights Average Rate, Total Paid, % of Total Paid and then a subtotal by the city. Pie chart showing the Distribution City Amount Paid at the end of the report.
214	Graphical Market Pair	Graphical Market Pair. This report includes Air ONLY. Transaction types include Sales, and Exchanges. Vouchers Excluded. Report results in Market Pair, Ticketed Tips, % of Trips, Ticketed Volume, % of Volume. Grand Total Provided. Bar Chart with Top 5 Market Pairs by Trips. Calculations include City Pair Fare > 0; Net Transaction Count = Sales (1), Exchanges = (0).
217	Graphical validated Carrier Analysis	Graphical validated Carrier Analysis. This report includes Air and Rail. Transaction types are Sales, Refunds and Exchanges. Vouchers Excluded. The report results in Validated Carrier, Fare Paid, % of Fare Paid, Transaction, % of Transactions, Average Fare Paid. Followed by a Bar Chart with the Top Vendor Contribution. Net Transactions used on this report = Sales (1), Refunds (-1), Exchanges (0).
218	Airline Contract Report - NW	Airline Contract Report - NW. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. Vouchers and Vouchers excluded. The report results in Market Pair, Ticketed Trips (All, NW, NW %), Segment Volume (All, NW, NW %). Grand Total provided. Calculations: NW % = NW/All.
224	Air Activity Simple By Sort 2	Air Activity Simple Sorted by Sort 2. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers Excluded. Report results are Sort 2, Passenger Name, Issue Date, Depart Date, Return Date, Airline, Itinerary, Invoice #, Ticket #, Original Ticket #, Total $. Grand Total provided. Start Date = Depart Date; End Date = Return Date; Original Document = Exchange Ticket; Total Paid = Fare Paid
225	Air Activity Simple By Sort 3	Air Activity Simple Sorted by Sort 3. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers Excluded. Report results are Sort 3, Passenger Name, Issue Date, Depart Date, Return Date, Airline, Itinerary, Invoice #, Ticket #, Original Ticket #, Total $. Grand Total provided. Start Date = Depart Date; End Date = Return Date; Original Document = Exchange Ticket; Total Paid = Fare Paid
227	Where Are My Travelers By Sort2	Where Are My Travelers By Sort 2 and by Passenger Name . This report includes Air, Rail, Car and Hotel. Transaction type Sales and Exchanges. Vouchers excluded. The report results in Passenger Name; start date; start time Origin City Name and Code; Airline Code; Flight #; Destination City Name and Code; End Date and Time. This report results are based on the date the report is printed and it will not produce results if the start date and / or the end date are NULL. Report uses Master City Table and Segment Table.
232	UK Traveller Insurance Report	UK Traveler Insurance Report. This report includes Air ONLY, Transaction types are Sales, Refunds and Exchanges. Vouchers Excluded. The report results in Alphabetical by Traveler, Issue Date, Depart Date, Duration, Net Trip Count, Airline, Routing, From State, From Country, To State, To Country. Subtotaled by Traveler. Grand Total Provided.
237	Airline Contract Report - AS	Airline Contract Report - AS. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. Vouchers and Vouchers excluded. The report results in Market Pair, Ticketed Trips (All, AS, AS %), Segment Volume (All, AS, AS %). Grand Total provided. Calculations: AS % = AS/All.
252	Executive Summary Sales Only	Executive Summary. Report includes Air, Car and Hotel. Transaction type SALES ONLY. Vouchers Excluded. Booking Subtypes 1, 2, 3, 8. Report results are broken into Domestic, International and Total. Provides Year to Date Summary for Air, Car and Hotel. Bar Charts for Average Air Sale, Average Car Sole and Average Hotel Sale.
260	Air Activity By CC	Air Activity Sorted By Credit Card Number.. This report includes Air, Rail and Service Fees. Transaction types include Sales, Refunds and Exchanges. Voids and Vouchers Excluded. Report results include Credit Card # - Passenger Name, Issue Date, Depart Date, Return Date, Airline code, Itinerary, Invoice #, Ticket #, Original Ticket # and Total Paid. Grand Total provided. Start Date = Depart Date; End Date = Return Date; Total Paid = Fare Paid. Itinerary by Code only.
261	City Pair Mileage	City Pair Mileage. This report includes Air and Rail. Transaction type Sales ONLY. Vouchers Excluded. The report results in City Pair, Sector Pair Miles, Ticketed Trips, Total Miles, Total Km's. Grand Total Provided. Trips counts as one ways not counting connections.
264	Travelers Summary With Sort 1 & 2	Travel Summary By Sort 1 and Sort 2 This report includes Air, rail, Car, Hotel, Service Fees. Transaction types include Sales, Refunds, Exchanges. Vouchers excluded. The report results in Three categories of data: Air: trips taken, Total trip days, cost/mile, miles, Average trip cost. Hotel: Potential Nights, actual Nights, missed Bookings, % missed Bookings, Total $, Average Hotel Rate. Car: Total days,
265	Market Pair By Passenger Name	Market Pair sorted By Passenger Name. Report includes Air ONLY. Transaction types Sales, Refunds and Exchanges, Vouchers Excluded. Report results in Market Pair, Passenger Name, Airline Name, Market Pair by Code, Ticket #, Depart Date, Arrive Date, Miles, Cost Per Mile, Amount. Subtotaled by Passenger Name and then Subtotaled by Market Pair. Amount = City Pair Fare; Master City Table used; Depart City <> Null; Arrive City <> Null.
266	Market Pair By Passenger Name With Segments	Market Pair sorted By Passenger Name with Segments. Report includes Air ONLY. Transaction types Sales, Refunds and Exchanges, Vouchers Excluded. Report results in Market Pair, Passenger Name, Airline Name, Market Pair by Code, Ticket #, Depart Date, Arrive Date, Miles, Cost Per Mile, Amount. Subtotaled by Passenger Name and then Subtotaled by Market Pair. Amount = City Pair Fare; Master City Table used; Depart City <> Null; Arrive City <> Null.
268	Top Travelers Summary	Top Travelers Summary Sorted by # of Tickets. This report includes Air, Car, Hotel. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. Report results include Traveler name, # of Tickets, Air Ticket cost, Hotel cost, Car cost, Total expense per Traveler. Grand Totals of all categories provided at the end of the report.
269	Top 5 Market Pair	Top 5 Market Pair. Report includes Air ONLY. Transaction types Sales and Exchanges. Vouchers Excluded. Report results in Market Pair, Ticketed Trips, % of Trips, Ticketed Volume, % of Volume. Grand Total provided. Bar Chart w/ Top 5 City Pairs. Trips are counted as one ways not counting connections. Total Paid = Ticketed Volume. Net Transactions = Sales (1), Refunds (-1) and Exchanges (0).
270	Top 5 Air	Top 5 Air. Report includes Air ONLY. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results in Vendor Name, Ticketed Trips, % of Trips, Ticketed Volume, % of Volume. Grand Total provided. Bar Chart w/ Top 5 Airlines. Trips are counted as one ways not counting connections. Total Paid = Ticketed Volume. Net Transactions = Sales (1), Refunds (-1) and Exchanges (0).
271	Top 5 Car	Top 5 Car Report includes Car ONLY. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results in Vendor Name, Ticketed Trips, % of Trips, Ticketed Volume, % of Volume. Grand Total provided. Bar Chart w/ Top 5 Cars. Trips are counted as one ways not counting connections. Total Paid = Ticketed Volume. Net Transactions = Sales (1), Refunds (-1) and Exchanges (0).
272	Top 5 Hotel	Top 5 Hotel. Report includes Hotel ONLY. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results in Vendor Name, Ticketed Trips, % of Trips, Ticketed Volume, % of Volume. Grand Total provided. Bar Chart w/ Top 5 Hotels. Trips are counted as one ways not counting connections. Total Paid = Ticketed Volume. Net Transactions = Sales (1), Refunds (-1) and Exchanges (0).
280	Top 100 MarketPair With Airline	Top 100 Market Pair With Airlines. Listed alphabetically by the Market Pair and then by # of Trips. This report includes Air ONLY. Transaction type Sales ONLY. Vouchers excluded. Report results Market Pair, Airline Code, Net Trips, % of Trips, Net Volume, % of Volume. Grand Total provided. Net Trips = Booking ID Count; Net Volume = City Pair Fare.
294	Exception Code Summary by Department	Exception Code Summary by Department. Report includes Air ONLY. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results Department - Passenger Name , Invoice #, Issue Date, Ticket #, Depart Date, Return Date, Airline Code, Itinerary, Total, Exception, Difference. Subtotal by Department. Grand total provided. Start Date - Depart Date; End date = return date; Reason Code = Exception Code.
303	Exchange Detail Report	Exchange Detail Report Sorted by Issue Date then Passenger Name. This report includes Air. Transaction types include Sales and Exchanges. Vouchers excluded. Report results include Passenger Name, Issue Date, Depart Date, Return Date, Airline, Itinerary, Invoice #, Ticket #, origin $ and add collect
305	Advance Purchase Detail By Sort2	Advance Purchase Detail By Sort 2. This report includes Air and Rail. Transactions type Sales ONLY. Vouchers Excluded. Header sorting by Sort 2; The report results in Passenger Name , Issue Date, Depart, Return, Airline Code, Itinerary, Invoice, and Total Cost. Subtotaled by # of Days Advance. Grand Total Provided. Start Date = Depart Date; End Date = Return Date; Itinerary by city Code.
306	Hotel Summary By City By Property	Hotel Summary Sorted By Cities then Property (# of Nights in descending order). Top 50 Hotel Cities Top 5 Properties per city plus Others. This report includes Hotels ONLY. Vouchers excluded. The reports results in Hotel Property, City, # of Bookings, % of Bookings, # of Nights, % of Nights, Average Rate, Total Paid, % of Total Paid Subtotaled by City. Grand Total provided. Hotel City and State checks existence in vendor Table first and then city table. Formulas: Nights = Number Of Units * Duration; Total Paid = # of Nights * Rate; Average Rate = Total Paid / Nights.
308	Advance Purchase Detail Report	Advance Purchase Detail Report. This report includes Air and Rail. Transactions type Sales ONLY. Vouchers Excluded. The report results in Passenger Name , Issue Date, Depart, Return, Airline Code, Itinerary, Fare Paid. Subtotaled by # of Days Advance. Grand Total Provided. Start Date = Depart Date; End Date = Return Date; Itinerary by city Code; Fare Paid = Total Paid.
309	Hotel Detail By Property	Hotel Detail Report Sorted by Property. This report is Hotels ONLY. Vouchers excluded. The report results Traveler, Hotel property, Hotel City, Invoice #, Issue Date, Check-in, Check-out, Confirmation #, # of Nights, Rate, Total Paid. Subtotaled by property categories. Grand Total provided.
310	Top 25 MarketPair By Segment Count	Top 25 Market Pair. Report includes Air ONLY. Transaction types Sales and Exchanges. Vouchers Excluded. Report results in Market Pair, Ticketed Trips, % of Trips, Ticketed Volume, % of Volume. Grand Total provided. Bar Chart w/ Top 5 City Pairs. Trips are counted as one ways not counting connections. Total Paid = Ticketed Volume. Net Transactions = Sales (1), Refunds (-1) and Exchanges (0).
311	Top 10 Airlines	Top 10 Airlines. Report includes Air ONLY. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results in Vendor Name, Ticketed Trips, % of Trips, Ticketed Volume, % of Volume. Grand Total provided. Bar Chart w/ Top 5 Airlines. Trips are counted as one ways not counting connections. Total Paid = Ticketed Volume. Net Transactions = Sales (1), Refunds (-1) and Exchanges (0).
312	Top 10 Car Rentals	Top 10 Car Rentals Report includes Car ONLY. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results in Vendor Name, Ticketed Trips, % of Trips, Ticketed Volume, % of Volume. Grand Total provided. Bar Chart w/ Top 5 Cars. Trips are counted as one ways not counting connections. Total Paid = Ticketed Volume. Net Transactions = Sales (1), Refunds (-1) and Exchanges (0).
313	Top Travelers By Nights	Top Travelers By Nights. Top 25 Travelers. Report includes Air ONLY. Transaction types Sales, Refunds, and Exchanges. Vouchers Excluded. Report results in Traveler Name, # of Nights, # of Transactions, % Total. Grand Total Provided.
314	Car Detail By Company	Car Detail Sorted by Car Company. This report includes Car ONLY. Vouchers excluded. The report results include Traveler, Car Company, Car City, Invoice #, Issue Date, Pick Up Date, Drop Off Date, Confirmation #, # of days, Rate, Total $. Subtotaled by Car companies. Grand Totals Provided. Start Date = Pick Up Date; End Date = Drop Off Date; document # = Confirmation #.
315	Top Travelers By Nights	Top Travelers By Nights. Top 25 Travelers. Report includes Air ONLY. Transaction types Sales, Refunds, and Exchanges. Vouchers Excluded. Report results in Traveler Name, # of Nights, # of Transactions, % Total. Grand Total Provided.
316	Top 20 Travelers	Top 25 Travelers. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results in Traveler name, Gross Fare Paid, % of Total Gross Fare Paid, Average Ticket price, # of Transactions, % of Total Transactions. Grand Total included.
317	Top 10 Hotel Bookings	Top 10 Hotel bookings. Report includes Hotel ONLY. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results in Vendor Name, Ticketed Trips, % of Trips, Ticketed Volume, % of Volume. Grand Total provided. Bar Chart w/ Top 5 Hotels. Trips are counted as one ways not counting connections. Total Paid = Ticketed Volume. Net Transactions = Sales (1), Refunds (-1) and Exchanges (0).
318	Top 20 Hotel Cities	Top 20 Hotel Cities. This report includes Hotels ONLY. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. Total Paid > 0 ONLY. The report results in Hotel City, # of stays, # of Nights, % of Total Nights, Volume booked, % of Volume, Average booked Rate, Average Nights / stay, Average cost / stay, Average cost / night.
319	Top 20 Car Cities	Top 20 Car Cities. This report includes Cars ONLY. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. Total Paid > 0 ONLY. The report results in Car Companies, # of rentals, # of Nights, % of Total, Volume booked, % of Volume, Average booked Rate, Average Nights / stay, Average cost / stay, Average cost / night.
320	Lost Savings Summary By Passenger Name	Lost Savings Summary By Passenger Name. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report Results in Passenger Name , # f Transactions; Fare Paid, Savings; Lost Savings; Net Savings. Savings - High Fare - Fare Paid. Lost Savings = Fare Paid - Low Fare; Net Transactions = Sales (1), Refunds (-1) and Exchanges (0).
321	Lost Savings Summary By Reason	Lost Savings Summary By Reason Code. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report Results in Reason Code, # of Transactions; Fare Paid, Savings; Lost Savings; Net Savings. Savings - High Fare - Fare Paid. Lost Savings = Fare Paid - Low Fare; Net Transactions = Sales (1), Refunds (-1) and Exchanges (0).
322	Airline Contract Report - CO	Airline Contract Report - CO. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. Vouchers and Vouchers excluded. The report results in Market Pair, Ticketed Trips (All, CO, CO %), Segment Volume (All, CO, CO %). Grand Total provided. Calculations: CO % = CO/All.
335	Advance Purchase Detail	Advance Purchase Detail. This report includes Air and Rail. Transactions type Sales ONLY. Vouchers Excluded. The report results in Passenger Name , Issue Date, Depart, Return, Airline Code, Itinerary, Invoice, and Total Cost. Subtotaled by # of Days Advance. Grand Total Provided. Start Date = Depart Date; End Date = Return Date; Itinerary by city Code.
339	Air Activity By Passenger Name with Segments	Air Activity Sorted By Passenger Name with Segments. This report includes Air, Rail and Service Fees. Transaction types include Sales, Refunds and Exchanges. Vouchers Excluded. Report results include Passenger Name Invoice Date, Invoice #, Vendor Name, Ticket #, Original City, Destination City, Fare Paid, Full Fare, Low Fare., Grand Total provided. Start Date = Depart Date; End Date = Return Date; Original document = Exchange; Total Paid = Fare Paid.
340	Car Detail by Vendor	Car Detail Sorted by Vendor. This report includes Car ONLY. Vouchers excluded. The report results include Car Company - Traveler Name, City, Invoice #, Issue Date, Pick Up Date, Drop Off Date, Confirmation #, Confirmation #, Car Type, # of days, Rate, Total before tax. The report Subtotals by Passenger Name. Grand Total provided. Start Date = Pick Up Date; End Date = Drop Off Date; document # = Confirmation #, duration * # of units = # of days.
342	Hotel Detail by Sort 3 with Sort 1	Hotel Detail Report Sorted by Sort 3 and with Sort 1. This report is Hotels ONLY. Vouchers excluded. The report results Sort 3, Traveler, Hotel property, Hotel City, Invoice #, Issue Date, Check-in, Check-out, Confirmation # Sort 1, # of Nights, Rate, Total Paid. Subtotaled by Sort 1. Grand Total provided.
344	Air Detail Exceptions by Sort 1, Sort 2, Sort 3	Air Detail Exceptions Report sorted by Sort 1, Sort 2 and Sort 3. This report includes Air ONLY. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results in Sort 1, Sort 2, Sort 3 - Passenger Name , Invoice #, Invoice Date, # of Days Advance, Depart Date, Airline Code, Ticket #, Fare Basis, origin City, Destination City, Connection Code, Fare Pair, Full Fare, Low Fare, Savings, Loss, Reason Code. Advance Purchase = Issue Date - Start Date; Savings = Full Fare - Total Paid; Loss = Fare Paid - Low Fare; Total Paid > Low Fare
345	Air Activity Summary by Month	Air Activity Summary by Month. This report includes Air ONLY. Transaction types Sales, Refunds, and Exchanges. Vouchers Exclude. Report results in Airline Vendor Name, Month, Total. Grand Total Provided. Issue Date = Start Date; Vendor ID used for Airline Vendor Name.
355	Arrival Manifest With No Sorts	Arrival Manifest with no Sorts This report includes Air and Rail. Transactions types include Sales and Exchanges. Vouchers Excluded. Report results in Long Date, Arrival City Name and Code, Arrival Time, Traveler Name; Arrival short date and time, Airline Code, Flight #, From Airport, Origin Airport. . Summary by Traveler. Total Summary of all Travelers. This report uses the Master City Table. Report parameters include: Start Date not NULL; End Date not NULL; Reissues not included.
381	Air Detail By Passenger Name With Class	Air Detail By Passenger Name With Class. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. The report results in Passenger Name - Issue Date, Invoice #, Ticket #, Amount, Airline Code, Flight #, Class of Service, Depart Date and Time, From City Code and Name, To City Code and Name, Arrive Date and Time. Subtotaled by Passenger Name. Grand Total Provided. Total Paid = Amount.
390	Top 50 Car Cities	Top 50 Car Cities. This report includes Cars ONLY. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. Total Paid > 0 ONLY. The report results in Car Companies, # of rentals, # of Nights, % of Total, Volume booked, % of Volume, Average booked Rate, Average Nights / stay, Average cost / stay, Average cost / night.
413	Exchange Ticket Cost Report Sorted by Passenger Name	Exchange Ticket Cost Report Sorted by Passenger Name - includes Service Fees. This report includes Air. Transaction types include Sales and Exchanges. Vouchers excluded. Report results include Passenger Name, Issue Date, Depart Date, Return Date, Airline, Itinerary, Invoice #, Ticket #, origin $ and add collect
420	Airline Contract Report -WS	Airline Contract Report - WS. This report includes Top 200 (plus others) -Depart Air = WS. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. Report results include market Pair, Ticketed trips (All, WS, % of WS), Segment Volume. (All, WS, % WS). Trips = One way. This report includes a Grand Total.
451	Advance Purchase Detail - 21 Days or Less	Advance Purchase Detail sorted by 21 Days or Less. This report includes Air and Rail. Transactions type Sales ONLY. Vouchers Excluded. The report results in Passenger Name , Issue Date, Depart, Return, Airline Code, Itinerary, Fare Paid, Fare Offered, Savings/Loss. Subtotaled by # of Days Advance. Grand Total Provided. Start Date = Depart Date; End Date = Return Date; Itinerary by city Code; Fare Paid = Total Paid; Fare Offered = : Savings/Loss = .
452	Air Detail with Service Fees by Passenger Name - Canada	Air Detail with Service Fees Sorted by Passenger Name Name(CANADA) This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results in Date issued, Passenger Name , booked by, Invoice #, Ticket #, amount, GST, HST, Airline, flight #, Class, Depart Date and time, Depart City, arrival City, arrival Date and time. Total per Passenger Name provided on the report.
454	TravCom Hotel Summary by Property	TravCom Hotel Summary Sorted By Property (# of Nights in descending order) This report includes Hotels ONLY. Vouchers excluded. The reports results in Hotel Property, Booking #, % of Booking #, # of Nights, % of # Nights, Average Rate, Total Paid, % of Total Paid. Formulas: Nights = dataBooking.Nights; Total Paid = # of Nights * Rate; Average Rate = Total Paid / Nights.
455	TravCom Where Are My Travelers	TravCom Where Are My Travelers. This report shows by Traveler Name the active trips they are currently on based on the day the report was printed. Grey sections indicate portions of travel that have already been completed. Report results in Traveler Name, Invoice Date, Depart Date/Time, Departure City, Airline/Flight#, Arrival City, Arrival Date/Time. Formulas: Start Date = Depart Date; End Date = Arrival Date; City Name and City Code provided; Airline Code Only.
456	Graphic Executive Summary With Fees	Graphic Executive Summary with Service Fees. Graphs include sales only for Air and Rail transactions. Refunds, Exchanges and Voids are excluded. This report displays Air sales, Tickets issued, Average Ticket Price, Car Volume Booked, Car Days Booked, Car Average Booked Daily Rate, Hotel Volume Booked, Hotel Nights Booked, Hotel Average Booked Rate.
460	Complete Executive Summary By Sort1 and Sort 2 and Sort3	Complete Executive Summary By Sort1, Sort 2 and Sort 3 showing Current Period and Year to Date. Vouchers Excluded. The report results in Sales, Mileage, Average and Totals. Count = Transaction Count = All Transactions = 1.
467	Air Detail By Passenger Name with Mileage	Air Detail By Passenger Name With Mileage. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. The report results in Passenger Name - Issue Date, Invoice #, Ticket #, Amount, Airline Code, Flight #, Class of Service, Depart Date and Time, From City Code and Name, To City Code and Name, Arrive Date and Time, # of miles. Subtotaled by Passenger Name. Grand Total Provided. Total Paid = Amount.
468	Air Volume Summary With Transborder	Air Volume Summary with Transborder. Sorted by Grand Total # of Trips. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers Excluded. Report results include Summary for Domestic, International, Transborder and Grand Totals. Summary of Airline, Total Trips, % of Trips, Ticketed Price, % of Ticketed Price, Average Price and Grand Totals. All amounts and nets are count (because sales, exchanges, and refunds are counted). Average Ticket Price = Intl Volume + Dom Volume / Dom Trips + Intl Trips; Trips = Domestic Trips + International Trips ; Ticketed Price = International Volume + Domestic Volume / Domestic Trips + International Trips.
469	Traveler Activity By Invoice By Sort 1 and Sort 2	Traveler Activity by Invoice and by Sort 1,Sort 2. Transaction types Sales, Refunds and Exchanges. Vouchers excluded. The report results in Invoice #, Sort 1, Sort 2, Type of Travel, Issue Date, Ticket # / Confirmation #, Total Paid, From Date, To Date, Cities by City Code, Vendor. The report is Subtotaled by Invoice number. Grand Total is provided.
473	Executive Summary Sales Only	Executive Summary. Report includes Air, Car and Hotel. Transaction type SALES ONLY. Vouchers Excluded. Booking Subtypes 1, 2, 3, 8. Report results are broken into Domestic, International and Total. Provides Year to Date Summary for Air, Car and Hotel. Bar Charts for Average Air Sale, Average Car Sole and Average Hotel Sale.
474	Traveler Activity By Passenger Name By Sort 1 Sort 2 and Sort 3	Traveler Activity by Passenger Name and by Sort 1,Sort 2, Sort 3. Transaction types Sales, Refunds and Exchanges. Vouchers excluded. The report results in Passenger Name, Sort 1, Sort 2, Sort 3, type of travel, Issue Date, Ticket # / Confirmation #, Total Paid, from Date, to Date, cities, vendor. The report is Subtotaled by Passenger Name. Grand Total is provided.
476	Class Of Service Summary	Class Of Service Summary. This report includes Air ONLY. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results in Business/First Class, Coach and Total breakdowns by # of trips, % of trips, Volume, % of Volume. Calculated Mileage Total Fare = Segment Fare. Net Transactions = Trips = Sales (1), Refunds (-1) and Exchanges (0).
482	Travel Activity Detail By Sort1 Sort2 and Sort3	Traveler Activity by Sort 1,Sort 2, Sort 3. Transaction types Sales, Refunds and Exchanges. Vouchers excluded. The report results in Sort 1, Sort 2, Sort 3, type of travel, Passenger Name, Issue Date, Ticket # / Confirmation #, Total Paid, from Date, to Date, cities, vendor. Grand Total is provided.
484	Agent Summary By Vendor	Agent Summary by Vendor. This report includes all travel types. Transaction types include Sales, Refunds and Exchanges. Vouchers and Vouchers excluded. The report results in vendor name, # of Bookings, Total Paid, Commission, Agent Commission. Total per agent and Grand Total provided.
487	Complete Executive Summary - Net ATP	Complete Executive Summary with Net Air Ticket Price - Current Year Month to Previous Year Month / Current Year to Date to Previous Year to Date. This report includes Air, Rail, Car and Hotel. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results include Domestic, International and Transborder Summary for Air, Rail, Car and Hotel. Grand Total for each category provided. Grand Total on Total Spend. Volume Issued = Sales Invoices; Volume Refunded = Refund Invoices; Net Volume = Sales - Refunds; Net Savings = High Fare - (Sales + Refunds) ; Lost Savings = Low Fare - (Sales + Refunds).
490	Air Activity Simple By Sort 4	Air Activity Simple Sorted by Sort 4. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers Excluded. Report results are Sort 4, Passenger Name, Issue Date, Depart Date, Return Date, Airline, Itinerary, Invoice #, Ticket #, Original Ticket #, Total $. Grand Total provided. Start Date = Depart Date; End Date = Return Date; Original Document = Exchange Ticket; Total Paid = Fare Paid
491	Air Activity Simple By Sort 5	Air Activity Simple Sorted by Sort 5. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers Excluded. Report results are Sort 5, Passenger Name, Issue Date, Depart Date, Return Date, Airline, Itinerary, Invoice #, Ticket #, Original Ticket #, Total $. Grand Total provided. Start Date = Depart Date; End Date = Return Date; Original Document = Exchange Ticket; Total Paid = Fare Paid
495	Airline Contract Report - CI	Airline Contract Report - CI. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. Vouchers and Vouchers excluded. The report results in Market Pair, Ticketed Trips (All, CI, CI %), Segment Volume (All, CI, CI %). Grand Total provided. Calculations: CI % = CI/All.
498	Hotel Detail by Sort 1 with Sort 3	Hotel Detail Report Sorted by Sort 1 and with Sort 3. This report is Hotels ONLY. Vouchers excluded. The report results Sort 1, Traveler, Hotel property, Hotel City, Invoice #, Issue Date, Check-in, Check-out, Confirmation # Sort 2, # of Nights, Rate, Total Paid. Subtotaled by Sort 1. Grand Total provided.
499	Fare Savings Analysis By Sort1-LowFare	Fare Savings Analysis By Sort1-LowFare. This report includes Air and Rail. Transaction types include Sales and Exchanges. Vouchers Excluded. Report sorted by Sort 1 then by Passenger Name . Report order is Passenger Name , Issue Date, Invoice #, Depart Date, Origin City Name and Date, Destination Name and Date, Airline Code, Low Fare, Fare Paid, Fare Savings, Reason Code. Subtotaled by Sort 1. Grand total provided. Parameters: Total Paid = Fare Paid; Coach Fare = High Fare; Class = Fare Basis.
502	Top 100 Market Pair By Airlines	Top 100 Market Pair sorted By Airlines. This report includes Air ONLY. Transaction type Sales ONLY. Voucher Excluded. This report includes Market Pair, # of Ticketed Trips, % of Trips, Miles, Net Volume, Average Ticket Cost, Cost Per Mile, % of Volume. Volume = Net Base Fare on valid segments only. Trips counted as one ways not counting connections. Net Fare = City Pair Fare.
504	Top 200 Market Pair By Trip Count	Top 200 Market Pair Sorted by Trip Count. This report includes Air ONLY. Transaction types Sales, Refunds and Exchanges. Vouchers excluded. Report results Market Pair, # of Ticketed trips, % of Ticketed trips, Ticketed Volume, % of Ticketed Volume and Grand Total. Net Transaction Count = Transactions. Sales = 1, Refunds = -1, Exchanges = 0.
507	Hotel Detail With Sort1	Hotel Detail Report includes Sort 1. This report is Hotels ONLY. Vouchers excluded. The report results Rate, Traveler, Hotel property, Hotel City, Invoice #, Issue Date, Check-in, Check-out, Confirmation #, Sort 1, # of Nights, Rate, Total Paid. Grand Total provided.
510	Traveler Activity By Invoice With Agent With Sort1,2,3,4	Traveler Activity Detail by Invoice includes Agent ID, Sort 1, Sort 2, Sort 3 and Sort 4. Transaction types Sales, Refunds and Exchanges. Vouchers excluded. The report results in Invoice #, type of travel, Passenger Name, Issue Date, Ticket # / Confirmation #, Agent ID, Total Paid, from Date, to Date, cities, vendor. Subtotaled by Invoice #. Grand Total is provided.
511	MarketPair By Airline By Class Of Service	Market Pair sorted By Airlines and by Class of Service. This report includes Air ONLY. Transaction type Sales ONLY. Voucher Excluded. This report includes Market Pair, Airline Code, Class of Service Code, # of Ticketed Trips, Ticketed Fare.. Volume = Net Base Fare on valid segments only. Trips counted as one ways not counting connections. Net Fare = City Pair Fare.
530	TravCom Invoice Report	TravCom Invoice Report. Sorted by Date and then Invoice #. One invoice after another.
532	Advance Purchase Detail - Potential Savings	Advance Purchase Detail - Potential Savings. This report includes Air and Rail. Transactions type Sales ONLY. Vouchers Excluded. The report results in Passenger Name , Issue Date, Depart, Return, Airline Code, Itinerary, Fare Paid,, Potential Savings. Subtotaled by # of Days Advance. Grand Total Provided. Start Date = Depart Date; End Date = Return Date; Itinerary by city Code; Fare Paid = Total Paid; Fare Offered = Total Paid: Potential Savings = calculated on 38%.
533	Grasp Invoice Report	Grasp Invoice Report. Sorted by Date and then Invoice #. One invoice after another.
535	Advance Purchase Detail - Savings By Sort1	Advance Purchase Detail sorted by Sort 1- 14 Days or Less. This report includes Air and Rail. Transactions type Sales ONLY. Vouchers Excluded. The report results in Passenger Name , Issue Date, Depart, Return, Airline Code, Itinerary, Fare Paid, Fare Offered, Savings/Loss. Subtotaled by # of Days Advance. Grand Total Provided. Start Date = Depart Date; End Date = Return Date; Itinerary by city Code; Fare Paid = Total Paid; Fare Offered = Total Paid: Savings/Loss = High Fare - Total Paid .
540	Departure Manifest With Sort1	Departure Manifest with Sort 1. This report includes Air and Rail. Transactions types include Sales and Exchanges. Vouchers Excluded. Report results in Sort 1 - Long Date, Depart City Name and Code, Depart Time, Traveler Name; Depart short date and time, Airline Code, Flight #, From Airport, Origin Airport. Summary by Traveler. Total Summary of all Travelers. This report uses the Master City Table. Report parameters include: Start Date not NULL; End Date not NULL; Reissues not included.
541	Year Over Year Air Sales	Year Over Year Air Sales includes two bar charts. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Summary Sales and Transactions for Domestic, International and Total. Sales Compare Current Month to Prior Year Month and the % Difference. Transactions Current Month Compared to Prior Year Month and the % Difference. Bar Chart # 1 Sum of Sales Total. Bar Chart #2 Transaction Comparison.
543	Year Over Year Air Sales By Month	Year Over Year Air Sales by Month includes two line charts. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Summary Sales and Transactions for Domestic, International and Total. Sales Compare Current Month to Prior Year Month and the % Difference. Transactions Current Month Compared to Prior Year Month and the % Difference. Line Chart # 1 Sales Analysis. Line Chart #2 Transaction Analysis.
545	Agent Activity Detail	Agent Activity Detail. This report includes all travel types. Transaction types include all except Vouchers. Document type voucher excluded. This report is Sorted by Agent Name. The report results in Invoice #, Issue Date, Net Volume, commission, agent commission, Fare productivity, commission productivity. Total given by agent and Grand Total provided. Calculations: Booked Commission / Booking count = Commission Productivity; Booked Volume / Booking count = Fare Productivity; Total Paid = Volume.
546	Graphic Executive Summary - No Voids	Graphic Executive Summary - No Voids. Graphs include sales only for Air and Rail transactions. Refunds, Exchanges and Voids are excluded. This report displays Air sales, Tickets issued, Average Ticket Price, Car Volume Booked, Car Days Booked, Car Average Booked Daily Rate, Hotel Volume Booked, Hotel Nights Booked, Hotel Average Booked Rate.
549	Traveler Activity With Segments With Agent	Traveler Activity Sorted By Passenger Name then Booking type. NO $$ Value on this report. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results are Issue Date, Traveler Name, Ticket # / Confirmation #, Agent, Date/Time, Departure City Code and Name, Airline/Flight #, Arrival City Code and Name, Cities, Date/Time.
552	Air Travel Summary By Month- Domestic and International Air Travel Summary By Month	Air Travel Summary By Month – Domestic and International. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report Results in Monthly numbers and Grand Total. Domestic Sales, Domestic Transactions, International Sales, International Transactions. Total Paid = Sales Total.
564	Global Grasp Invoice Report	Global Grasp Invoice Report. Sorted by Date and then Invoice #. One invoice after another.
572	Advance Purchase Summary Graphic	Advance Purchase Summary Graphic This report includes Air and Rail. Transaction types include Sales ONLY. Vouchers excluded. The report results in Advance Purchase time, # of Tickets, % of Tickets, Volume, % if Volume, Average Price. Calculations for Transactions: Advance Purchase = Issue Date less Departure Date.
577	Top 50 Hotel Cities Top 10 Properties	Top 50 Hotel Cities Top 10 Properties. This report includes Hotels ONLY. Vouchers excluded. The report results in Hotel City, Hotel Property, # of Bookings, % of Bookings, # of Nights, % of Total Nights, Average Rate, Total Paid, % of Total Paid. Subtotaled by City, Grand Total Provided.
578	Travel Summary By Sort1	Travel Summary By Sort 1 This report includes Air, rail, Car, Hotel, Service Fees. Transaction types include Sales, Refunds, Exchanges. Vouchers excluded. The report results in Three categories of data: Air: trips taken, Total trip days, cost/mile, miles, Average trip cost. Hotel: Potential Nights, actual Nights, missed Bookings, % missed Bookings, Total $, Average Hotel Rate. Car: Total days,
579	Travel Summary By Account	Travel Summary Account. This report includes Air, Car and Hotel. Transaction types include Sales, Refunds, Exchanges. Vouchers excluded. The report results in Three categories of data: Air: Hotel, Car and Total. Report results Account Name, Air Trips Taken, Air Total Amount, Air Trip Days, Air Cost Per Mile, Air Miles Traveler, Air Average Trip Cost, Hotel Potential Nights, Hotel Actual Nights, Hotel Missed Booking %, Hotel Total Amount, Hotel Average Rate, Car Total Days, Car Total Amount Car Average Rate, Total Amount.
580	Advance Purchase Summary With High Fare	Advance Purchase Summary with High Fare. This report includes Air and Rail. Transaction types include Sales ONLY. Voids and Vouchers Excluded. Summary for Advance days 0 to 20 and over 20. Grand Total provided. Report results are # of days Advance, Ticket Total $, % of Total, Volume, % of Volume, High Fare Value, Diff. Booked.. Advance = Start Date Less Issue Date when Start Date > Issue Date and Total Paid not equal to zero; Volume = Total Paid; Diff. Booked = High Fare Volume - Booked Volume..
583	Car Summary By Company And Car Type	Car Summary Sorted by Car Company And Car Type. This report includes Car ONLY. Transaction types include Sales, Refunds, Exchanges. Vouchers excluded. The report results in Car Company, Car type, Bookings, Total %, Car days, days %, Average Rate, Total Paid, % Total Paid.
588	Air Trans By Current Year And Previous Year Month Summary	Air Trans By Current Year And Previous Year Month Summary. This report includes Air and Rail. Transaction type Sales, Refunds and Exchanges. The report results include Month, Net Tickets, % Transactions, Net Volume, Volume % for current and previous year. Includes Line Graph comparing current and previous year.
596	Agent Summary Report - Inside Agents Only	Agent Summary Report Sorted by Inside Agent. Within each category - Sorted alphabetically. This report includes all Sales types and Transaction types. Vouchers are excluded. Report results include agent name, Net Volume, % of Total Volume of all agents, Transactions, % of Total Transactions of all agents, Average Booking, Booking commission and % Total commission for all agents.
597	Agent Summary Report - Outside Agents Only	Agent Summary Report Sorted by Outside Agent. Within each category - Sorted alphabetically. This report includes all Sales types and Transaction types. Vouchers are excluded. Report results include agent name, Net Volume, % of Total Volume of all agents, Transactions, % of Total Transactions of all agents, Average Booking, Booking commission and % Total commission for all agents.
599	Traveler Activity By Invoice - No Service Fees	Traveler Activity by Invoice - No Service Fees. Transaction types Sales, Refunds and Exchanges. Vouchers excluded. The report results in Sort 1, Sort 2, Sort 3, type of travel, Passenger Name, Issue Date, Ticket # / Confirmation #, Total Paid, from Date, to Date, cities, vendor. Grand Total is provided.
608	Travel Summary by Sort 1 and Sort 2	Travel Summary By Sort 1 and Sort 2 This report includes Air, Rail, Car, Hotel, Service Fees. Transaction types include Sales, Refunds, Exchanges. Vouchers excluded. The report results in Three categories of data: Air: Hotel, Car and Total. Rank 1-25, City Code, Air Trips Taken, Air Total $, Air # of Days, Air Cost Per Mile, Air Miles Traveled, Air Average Trip Cost, Hotel Potential Nights, Hotel Actual Nights, Hotel Missed %, Hotel Total Amount, Hotel Average Rate, Car Total Days, Car Total Amount, Car Average Rate, Total.
611	Advance Purchase Detail (filter by origin country Code)	Advance Purchase Detail (filter by origin Country Code) This report includes Air and Rail. Transactions type Sales ONLY. Vouchers Excluded. The report results in Passenger Name , Issue Date, Depart, Return, Airline Code, Itinerary, Invoice, and Total Cost. Subtotaled by # of Days Advance. Grand Total Provided. Start Date = Depart Date; End Date = Return Date; Itinerary by city Code.
612	Advance Purchase Detail (filter by destination country Code)	Advance Purchase Detail (filter by Destination Country Code) This report includes Air and Rail. Transactions type Sales ONLY. Vouchers Excluded. The report results in Passenger Name , Issue Date, Depart, Return, Airline Code, Itinerary, Invoice, and Total Cost. Subtotaled by # of Days Advance. Grand Total Provided. Start Date = Depart Date; End Date = Return Date; Itinerary by city Code.
613	Graphic Executive Summary YOY	Graphic Executive Summary with Year Over Year . Graphs include sales only for Air and Rail transactions. Refunds, Exchanges and Voids are excluded. This report displays Air sales, Tickets issued, Average Ticket Price, Car Volume Booked, Car Days Booked, Car Average Booked Daily Rate, Hotel Volume Booked, Hotel Nights Booked, Hotel Average Booked Rate.
615	Vendor Analysis Report	Vendor Analysis Report Summary Report. Transaction type Sales, Refunds and Exchanges. Vouchers excluded. Report results in Vendor Name; Fare Paid; % Total; Transactions; % Total; Average Fare Paid. Grand Total provided. Calculations include: Net Transaction Count = Sales (1), Refunds (-1) and Exchanges (0); Total Paid = Net Amount.
616	Top 50 Travelers by Transactions	Top 50 Travelers Sorted by Transactions Count. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results in Traveler name, Gross Fare Paid, % of Total Gross Fare Paid, Average Ticket price, # of Transactions, % of Total Transactions. Grand Total included.
617	Top 50 Travelers by Volume	Top 50 Travelers Sorted by Volume This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results in Traveler name, Gross Fare Paid, % of Total Gross Fare Paid, Average Ticket price, # of Transactions, % of Total Transactions. Grand Total included.
625	Air Activity Cost Savings By Passenger Name	Air Activity Cost Savings By Passenger Name. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Voids and Vouchers are excluded. Report results by Passenger Name , Invoice type, Issue Date, Booked date, Passenger Name , Sort 1,Invoice #, Ticket #, Fare Paid, Full Fare, Low Fare, Saved, Reason Code/Description, Airline Code, Flight #, Class, Depart Date, Depart City and Code, To City and Code. Transaction type = Invoice type; Total Paid = Fare Paid; Coach Fare = Full Fare.
629	Grasp Invoice Report-CANADA	Grasp Invoice Report - CANADA. Sorted by Date and then Invoice #. One invoice after another.
639	Class Of Service By Airline	Class Of Service Summary. This report includes Air ONLY. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results in Domestic and International breakdowns. Airline Vendor Name, # of transactions, subtotal. Grand Total Provided. Net Transactions = Trips = Sales (1), Refunds (-1) and Exchanges (0).
640	City Pair Mileage All Cities	City Pair Mileage all Cities. This report includes Air and Rail. Transaction type Sales ONLY. Vouchers Excluded. The report results in City Pair, Sector Pair Miles, Ticketed Trips, Total Miles, Total Km's. Grand Total Provided. Trips counts as one ways not counting connections.
642	Executive Summary Year Over Year	Executive Summary Year Over Year. This report includes Air, Rail, Car ad Hotel. Transaction type Sales ONLY. Vouchers Excluded. Compares current year by month to previous year by month. Air # of tickets, Air Total Cost, Air Price / Ticket, Hotel Total Bookings, Hotel Total Cost, Hotel Room, Nights, Hotel Rate / Room, Car Total Bookings, Car Total Cost, Car # of Days, Car Rate / Day.
647	Country Travel Summary	Country Travel Summary. This report includes Air and Rail. Transaction types include Sales, Refunds, Exchanges. Vouchers excluded. The report results in # of Nights (broken down as 0-5 / 6-10 / 11-15 / 16 +) and trips, Nights. Then the report Totals the # of Nights information into Total Trips, Total Nights, Average Nights, maximum Nights.
648	Grasp Invoice Report With Sort1	Grasp Invoice Report with Sort 1. Sorted by Date and then Invoice #. One invoice after another.
649	Class of Service by Airline Segment	Class of Service By Airline Segment. Report includes Air and Rail. Transaction type Sales, Refunds and Exchanges. Vouchers Excluded. Report results in Airline Name, Class of Service # of Flights, % of Total flights, Total Amount, % of Total Amount, Average Flight Price, Cost Per Mile. Subtotal per Airline. Grand Total provided. Total Amount = Segment Base Fare.
653	Account Summary By Month	Account Summary By Month. Account Name, Total Volume per month. Grand Total.
661	Air Activity By Invoice with Tour Code	Air Activity Sorted By Invoice with Tour Code. This report includes Air, Rail and Service Fees. Transaction types include Sales, Refunds and Exchanges. Vouchers Excluded. Report results include Passenger Name, Issue Date, Depart Date, Return Date, Airline, tour Code, Itinerary, Invoice #, Ticket #, Original Ticket # and Fare Paid $. Grand Total provided. Start Date = Depart Date; End Date = Return Date; Original document = Exchange; Total Paid = Fare Paid.
663	Car Detail by Passenger Name With Sort1 Sort2 Sort3 Sort4	Car Detail Sorted by Passenger Name with Sort 1, Sort 2, Sort 3 and Sort 4. This report includes Car ONLY. Vouchers excluded. The report results include Traveler, Car Company, City, Invoice #, Issue Date, Pick Up Date, Drop Off Date, Confirmation #, Sort 1, Sort 2, Sort 3, Sort 4, Class, # of days, Rate, Total before tax. The report Subtotals by Passenger Name. Grand Total provided. Start Date = Pick Up Date; End Date = Drop Off Date; document # = Confirmation #, duration * # of units = # of days.
664	Credit Card Detail By Passenger Name with Sort 1 Sort2 Sort3 Sort4	Credit Card Detail By Passenger Name with Sort 1, Sort 2, Sort 3 and Sort 4.. This report includes Air, Rail and Service Fees. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. Report sorted by Passenger Name and includes Ticket # Issue date, Itinerary, Depart Date, Return Date, Total Paid, encrypted credit card #, Sort 1, Sort 2, Sort 3, Sort 4. Grand total provided. Parameters included: Start Date = Depart Date; End Date = Return Date; Total Paid = Fare Paid.
675	Where Are My Travelers By Sort1	Where Are My Travelers By Sort 1and by Passenger Name . This report includes Air, Rail, Car and Hotel. Transaction type Sales and Exchanges. Vouchers excluded. The report results in Passenger Name; start date; start time Origin City Name and Code; Airline Code; Flight #; Destination City Name and Code; End Date and Time. This report results are based on the date the report is printed and it will not produce results if the start date and / or the end date are NULL. Report uses Master City Table and Segment Table.
687	Air Travel Report Sorted by Passenger Name Name - KDS Bookings	Air Travel Report Sorted by Passenger Name - KDS Bookings This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results in Date issued, Passenger Name , booked by, Invoice #, Ticket #, amount, GST, HST, Airline, flight #, Class, Depart Date and time, Depart City, arrival City, arrival Date and time. Total per Passenger Name provided on the report.
691	Executive Summary Compare Periods - Full Fare Compare -Year Over Year Only	Executive Summary Compare Periods - Full Fare. Current Year Month to Current Year to Date. This report includes Air, and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results include Bar Graphs for Air Sales, Tickets Issued and Average Ticket Price. Tables for Tickets, Refunds, Exchanges and Voids. Top 10 Market Pairs, Top 10 Travelers and Top 10 Cities. This report uses Net Transactions = Sales (1), Refunds (-1) and Exchanges (0). Advance Purchase = Issue Date - Start Date.
692	Department Summary By Month	Department Summary By Month. Transaction type Sales, Refunds and Exchanges. Total Paid per month and Grand Total.
693	Air and Service Fee Detail By Passenger Name with Reason With Sort1	Air and Service Fee Detail sorted By Passenger Name with Reason and Sort 1. This report includes Air and Service Fees. Transaction Types include Sales, Refunds and Exchanges. Vouchers excluded. Detail report includes Issue date; Passenger Name ; Ticket #; Sort 1, Advance Purchase; Fare Paid, Fare Offered; Savings/Loss Reason; Trip Segments with Depart Date, Airline Code, From City Name and To City Name. Subtotaled per Traveler. Grand Total provided. Master City Table and Segment Table used for this report. Calculations include; Issue Date = Invoice Date; Depart City = Origin Airport; Arrive City = Destination Airport; Total Paid = Invoice Amount; Low Fare = Fare Offered.
694	Air Detail By Passenger Name With Class with Sort1	Air and Service Fee Detail sorted By Passenger Name with Class and Sort 1. This report includes Air and Service Fees. Transaction Types include Sales, Refunds and Exchanges. Vouchers excluded. Detail report includes Issue date; Passenger Name ; Sort 1, Invoice #, Ticket #; Fare Paid, Trip Segments with Airline Code, Flight #, Class, Depart Date and Time, From City Name and To City Name, Arrive Date and Time. Subtotaled per Traveler. Grand Total provided. Master City Table and Segment Table used for this report. Calculations include; Issue Date = Invoice Date; Depart City = Origin Airport; Arrive City = Destination Airport; Total Paid = Invoice Amount; Low Fare = Fare Offered.
698	Top 20 Account Summary	Top 20 Account Summary. This report includes Air, Rail and Service Fees. Transaction type Sales, Refund and Exchanges. Vouchers Excluded. The report results in Account Name, # of Trips, % of Trips, Volume, % of Volume, Average Cost Per Trip, Commission, Service Fee. Subtotal of Accounts Listed. Subtotal of Accounts Not Listed. Grand Total. Net Transaction = Trips = Sales (1), Refunds (-1) and Exchanges (0).
710	Sales Report By Invoice By Sort1	Sales Report By Invoice By Sort 1. This report includes Air, Rail and Service Fees. Transaction types of Sales, Refunds and Exchanges. Vouchers Excluded. Report results: Sort 1, Invoice #, Invoice Date, Passenger Name, Ticket # Original Ticket #, Total Paid. Grand Total Provided.
714	Traveler Summary By Sort1 With Sort2, Sort3 and Sort4	Traveler Summary By Sort1 With Sort 2, Sort 3 and Sort 4. This report included Air, Car, Hotel and Service Fees. Transaction Type Sales ONLY. Vouchers excluded. Report results in Traveler Name, Total Spend, # of Air Tickets, # of hotel Bookings, # of Car Days. Grand Total provided.
715	Air Detail By Passenger Name With Mileage With CC	Air and Service Fee Detail sorted By Passenger Name with Mileage and Credit Card. This report includes Air and Service Fees. Transaction Types include Sales, Refunds and Exchanges. Vouchers excluded. Detail report includes Issue date; Passenger Name ; Sort 1, Invoice #, Payment #, Ticket #; Fare Paid, Trip Segments with Airline Code, Flight #, Class, Depart Date and Time, From City Name and To City Name, Arrive Date and Time, Mileage per segment. Subtotaled per Traveler. Grand Total provided. Master City Table and Segment Table used for this report. Calculations include; Issue Date = Invoice Date; Depart City = Origin Airport; Arrive City = Destination Airport; Total Paid = Invoice Amount; Low Fare = Fare Offered.
719	Account Summary	Account Summary. This report includes Air, Rail and Service Fees. Transaction type Sales, Refund and Exchanges. Vouchers Excluded. The report results in Account Name, # of Trips, % of Trips, Volume, % of Volume, Average Cost Per Trip, Commission, Service Fee. Subtotal of Accounts Listed. Subtotal of Accounts Not Listed. Grand Total. Net Transaction = Trips = Sales (1), Refunds (-1) and Exchanges (0).
720	Agency Data Audit Report	Agency Data Audit Report. Two pie charts comparing top accounts sync current year to previous year. Account Names, per month sync numbers from 2011-2013.
721	Traveler Summary By Sort1	Traveler Summary By Sort 1. This report included Air, Car, Hotel and Service Fees. Transaction Type Sales ONLY. Vouchers excluded. Report results in Traveler Name, Total Spend, # of Air Tickets, # of hotel Bookings, # of Car Days. Grand Total provided.
732	Car Detail by Passenger Name By Sort1	Car Detail Sorted by Passenger Name with Sort 1. This report includes Car ONLY. Vouchers excluded. The report results include Traveler, Car Company, City, Invoice #, Issue Date, Pick Up Date, Drop Off Date, Confirmation #, Sort 1, Class, # of days, Rate, Total before tax. The report Subtotals by Passenger Name. Grand Total provided. Start Date = Pick Up Date; End Date = Drop Off Date; document # = Confirmation #, duration * # of units = # of days.
733	Hotel Detail by Sort 1	Hotel Detail Report Sorted by Sort 1. This report is Hotels ONLY. Vouchers excluded. The report results Sort 1, Rate, Traveler, Hotel property, Hotel City, Invoice #, Issue Date, Check-in, Check-out, Confirmation #, # of Nights, Rate, Total Paid. Report Subtotaled by Sort 1. Grand Total provided.
734	Complete Executive Summary By Sort1	Complete Executive Summary by sort . - Current Year Month / Current Year to Date. This report includes Air, Rail, Car and Hotel. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results include Domestic, International and Transborder Summary for Air, Rail, Car and Hotel. Grand Total for each category provided. Report results in # of transactions, % of transactions, Amount, % of Amount and Average for each category. Volume Issued = Sales Invoices; Volume Refunded = Refund Invoices; Net Volume = Sales - Refunds; Net Savings = High Fare - (Sales + Refunds) ; Lost Savings = Low Fare - (Sales + Refunds).
735	Top 100 MarketPair With Airline By Sort1	Top 100 Market Pair With Airlines sorted by sort 1. Listed alphabetically by the Market Pair and then by # of Trips. This report includes Air ONLY. Transaction type Sales ONLY. Vouchers excluded. Report results Market Pair, Airline Code, Net Trips, % of Trips, Net Volume, % of Volume. Grand Total provided. Net Trips = Booking ID Count; Net Volume = City Pair Fare.
736	Top 100 Travelers by Volume By Sort1	Top 100 Travelers Sorted by Volume and by Sort 1 This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results in Sort 1, Traveler name, Gross Fare Paid, % of Total Gross Fare Paid, Average Ticket price, # of Transactions, % of Total Transactions. Grand Total included.
740	Airline Contract Report - F9	Airline Contract Report - F9. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. Vouchers and Vouchers excluded. The report results in Market Pair, Ticketed Trips (All, F9, F9 %), Segment Volume (All, F9, F9 %). Grand Total provided. Calculations: F9 % = F9/All.
742	Airline Contract Report - YX	Airline Contract Report - YX. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. Vouchers and Vouchers excluded. The report results in Market Pair, Ticketed Trips (All, YX, YX %), Segment Volume (All, YX, YX %). Grand Total provided. Calculations: YX % = YX/All.
743	Lost Savings By Account By Pass By Sort1	Lost Savings By Account, Passenger Name and Sort 1. This report includes Air and Rail. Transaction type includes Sales, Refunds and Exchanges. Vouchers excluded. Report results by Account Name, Issue Date, Booked date, Passenger Name , Sort 1, Invoice #, Ticket #, Fare Paid Full Fare, Low Fare, Saved, Reason Code/Description, Airline Code, Flight #, Class, Depart Date, Depart City and Code, To City and Code. Includes Summary by Traveler at the end of the report. Transaction type = Invoice type; Total Paid = Fare Paid; Coach Full = Full Fare.
744	Audit Report Year Over Year	Audit Report Year Over Year. Vouchers Excluded. Summary report on Air (Domestic and International), Car and Hotel with # of Bookings, Commissions by Booking Total and Grand Totals. Cross checks TRAMS for # of transactions and $ amount by Travel Category and Travel Type.
752	Air Detail By Passenger Name With Mileage With CC-Flown	Air and Service Fee Detail sorted By Passenger Name with Mileage and Credit Card. This report includes Air and Service Fees. Transaction Types include Sales, Refunds and Exchanges. Vouchers excluded. Detail report includes Issue date; Passenger Name ; Sort 1, Invoice #, Payment #, Ticket #; Fare Paid, Trip Segments with Airline Code, Flight #, Class, Depart Date and Time, From City Name and To City Name, Arrive Date and Time, Mileage per segment. Subtotaled per Traveler. Grand Total provided. Master City Table and Segment Table used for this report. Calculations include; Issue Date = Invoice Date; Depart City = Origin Airport; Arrive City = Destination Airport; Total Paid = Invoice Amount; Low Fare = Fare Offered.
754	Audit Report Year Over Year Corp and Leisure	Audit Report Year Over Year Corporate and Leisure. Vouchers Excluded. Summary report in two categories - Corporate and Leisure. the reporting fields are Air (Domestic and International), Car and Hotel with # of Bookings, Commissions by Booking Total and Grand Totals. Cross checks TRAMS for # of transactions and $ amount by Travel Category and Travel Type.
755	Air Activity By Passenger Name With Sort1 Sort2 Sort3	Air Activity Sorted By Passenger Name with Sort 1, Sort 2 and Sort 3. This report includes Air, Rail and Service Fees. Transaction types include Sales, Refunds and Exchanges. Vouchers Excluded. Report results include Passenger Name, Issue Date, Depart Date, Return Date, Airline, Itinerary, Sort 1, Sort 2, Sort 3, Invoice #, Ticket #, Original Ticket # and Fare Paid $. Grand Total provided. Start Date = Depart Date; End Date = Return Date; Original document = Exchange; Total Paid = Fare Paid.
757	Top 10 Market Pair	Top10 Market Pair with Graph, Sorted by # of Ticketed trips. This report includes Air ONLY. Transaction types include Sales and Exchanges. Vouchers excluded. The report results in Market Pair, Ticketed Trips, % of trips, Ticketed Volume, % of Volume. Calculations: Trips are counted as one ways not counting connections.
761	Air Activity By Passenger Name With Sort1 Sort2 Sort3 Sort4 Sort5	Air Activity Sorted By Passenger Name with Sort 1, Sort 2, Sort 3 Sort 4 and Sort 5. This report includes Air, Rail and Service Fees. Transaction types include Sales, Refunds and Exchanges. Vouchers Excluded. Report results include Passenger Name, Issue Date, Depart Date, Return Date, Airline, Itinerary, Sort 1, Sort 2, Sort 3, Sort 4 and Sort 5. Invoice #, Ticket #, Original Ticket # and Fare Paid $. Grand Total provided. Start Date = Depart Date; End Date = Return Date; Original document = Exchange; Total Paid = Fare Paid.
765	Market Pair With Airlines By Region	Market Pair With Airlines by Region. Listed alphabetically by the Market Pair and then by # of Trips. This report includes Air ONLY. Transaction type Sales ONLY. Vouchers excluded. Report results Market Pair, Airline Code, Net Trips, % of Trips, Net Volume, % of Volume. Grand Total provided. Net Trips = Booking ID Count; Net Volume = City Pair Fare.
767	Traveler Activity By Passenger Name With Sort1,2,3,4	Traveler Activity Sorted By Passenger Name with sort 1, sort 2, sort 3, sort 4. Subtotaled by Travel type and Passenger Name. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results are Issue Date, Traveler, Invoice Date, Ticket # / Confirmation #, Amount, from Date, to Date, City Codes, Vendor Name and Grand Total. Start Date = From Date; End Date = To Date; Amount = Total Paid.
779	Grasp Invoice Report With Sort1	Grasp Invoice Report with Sort 1. Sorted by Date and then Invoice #. One invoice after another.
782	Air CO2 Emission Report	Air CO2 Emission Report includes bar chart showing Monthly Hauls and Emission. This report includes Air ONLY. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. The report is broken into three categories: Short Haul (miles less than 727.45), Medium Haul (miles between 727.45 and 2575.04), Long Haul (miles greater than 2575.04). Sorted by Miles. The report results in Market Pair, Transactions, Total Miles, CO2 (Kgs). Net Transaction = Transactions = Sales (1), Refunds (-1), Exchanges (0).
792	Traveler Analysis	Traveler Analysis Sort By Total Spend. This report includes Air, Car, Hotel and Service Fees. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results by Traveler Name and includes Trip Count, Air Amount, Fee Amount, Hotel Amount, Hotel Nights, Car Amount, Total Cost, Average Air Cost / Trip Average Hotel Night Expense, Average Cost / Trip, Trip Count, Average Cost / Trip, Total Cost. Grand Total Provided.
793	Global Travelers Summary	Global Travelers Summary. This report included Air, Car, Hotel and Service Fees. Transaction Type Sales ONLY. Vouchers excluded. Report results in Traveler Name, Air Tickets Cost, Hotel Cost, Car Cost, Total Expense. Grand Total provided.
794	Global Traveler Summary By Sort1	Global Traveler Summary By Sort 1. This report included Air, Car, Hotel and Service Fees. Transaction Type Sales ONLY. Vouchers excluded. Report results in Sort 1, Traveler Name, Total Spend, # of Air Tickets, # of hotel Bookings, # of Car Days. Grand Total provided.
795	Global Traveler Analysis	Global Traveler Analysis Sorted by Traveler Name. This report includes Air, Car, Hotel and Service Fees. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results by Traveler Name and includes Trip Count, Air Amount, Fee Amount, Hotel Amount, Hotel Nights, Car Amount, Total Cost, Average Air Cost / Trip Average Hotel Night Expense, Average Cost / Trip, Trip Count, Average Cost / Trip, Total Cost. Grand Total Provided.
796	Vendor Analysis By Base Fare	Vendor Analysis By Base Fare Summary. Transaction type Sales, Refunds and Exchanges. Vouchers excluded. Report results in Vendor Name; Fare Paid; % Total; Transactions; % Total; Average Fare Paid. Grand Total provided. Calculations include: Net Transaction Count = Sales (1), Refunds (-1) and Exchanges (0); Total Paid = Net Amount.
798	Hotel Detail by Sort 3 with Agent	Hotel Detail Report by Sort 3 with Agent. This report is Hotels ONLY. Vouchers excluded. The report results Sort 3, Traveler Name, Hotel property, Agent, Invoice #, Issue Date, Check-in, Check-out, Confirmation #, # of Nights, Rate, Total Paid. Subtotaled by Sort 1. Grand Total provided.
804	Traveler Activity With Segments TravCOM	Traveler Activity with Segments TravCOM. Sorted By Passenger Name then Booking type. NO $$ Value on this report. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results are Issue Date, Traveler Name, Ticket # / Confirmation #, Agent, Date/Time, Departure City Code and Name, Airline/Flight #, Arrival City Code and Name, Cities, Date/Time.
805	Traveler Activity With Segments With Agent TravCOM	Traveler Activity with Segments with Agent TravCom. Sorted By Passenger Name then Booking type. NO $$ Value on this report. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results are Issue Date, Traveler Name, Ticket # / Confirmation #, Agent, Date/Time, Departure City Code and Name, Airline/Flight #, Arrival City Code and Name, Cities, Date/Time.
806	Where Are My Travelers By Sort1 TravCOM	Where Are My Travelers By Sort 1 and by Passenger Name (TravCom). This report includes Air, Rail, Car and Hotel. Transaction type Sales and Exchanges. Vouchers excluded. The report results in Passenger Name; start date; start time Origin City Name and Code; Airline Code; Flight #; Destination City Name and Code; End Date and Time. This report results are based on the date the report is printed and it will not produce results if the start date and / or the end date are NULL. Report uses Master City Table and Segment Table.
809	Where Are My Travelers TravCOM	Where Are My Travelers by Passenger Name (TravCom). This report includes Air, Rail, Car and Hotel. Transaction type Sales and Exchanges. Vouchers excluded. The report results in Passenger Name; start date; start time Origin City Name and Code; Airline Code; Flight #; Destination City Name and Code; End Date and Time. This report results are based on the date the report is printed and it will not produce results if the start date and / or the end date are NULL. Report uses Master City Table and Segment Table.
811	Traveler Analysis Sort By Total Cost	Traveler Analysis Sort By Total Cost. This report includes Air, Car, Hotel and Service Fees. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results by Traveler Name and includes Trip Count, Air Amount, Fee Amount, Hotel Amount, Hotel Nights, Car Amount, Total Cost, Average Air Cost / Trip Average Hotel Night Expense, Average Cost / Trip, Trip Count, Average Cost / Trip, Total Cost. Grand Total Provided.
813	Traveler Analysis Sort By Total Trips	Traveler Analysis Sort By Total Trips. This report includes Air, Car, Hotel and Service Fees. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results by Traveler Name and includes Trip Count, Air Amount, Fee Amount, Hotel Amount, Hotel Nights, Car Amount, Total Cost, Average Air Cost / Trip Average Hotel Night Expense, Average Cost / Trip, Trip Count, Average Cost / Trip, Total Cost. Grand Total Provided.
820	Air CO2 Emission Report By Sort1	Air CO2 Emission Report By Sort 1. Includes Bar Chart of Emissions by Month. This report includes Air ONLY. Transactions types Sales, Refunds and Exchanges. Voids Excluded. Report results in Sort 1, Market Pair, Transactions, Total Miles, CO2 (Kgs). Short Haul (miles less than 727.45), Medium Haul (miles between 727.45 and 2575.04), Long Haul (miles greater than 2575.04). Net Transactions = Transactions = Sales (1), Refunds (-1), Exchanges (0).
822	Service Fee QC Report	Service Fee QC Report. This report includes Service Fees ONLY. Report results in Client Name, Agent , Record Locator, Issue Date, Invoice #, Passenger Name and Total. Grand Total provided.
835	Top 25 Travelers With Advance Purchase Days	Top 25 Travelers Sorted by Transactions Count. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results in Traveler name, Gross Fare Paid, % of Total Gross Fare Paid, Average Ticket price, # of Transactions, % of Total Transactions. Grand Total included.
836	Top 10 Airlines By Flown Carrier	Top 10 Airlines By Flown Carrier: This report Includes Air ONLY. Transaction type Sales ONLY. Excludes Vouchers. Based on Segments, Net Transactions. By # of Trips. Report results in Carrier, # of Trips, % of Total, Volume Booked, % of Volume, Average Cost per Trip. Subtotal for Top 10 Carriers, Sub total for Carriers Not Listed. Grand Total Provided.
837	Top 10 Airline YOY Analysis	Top 10 Airline YOY Analysis. This report includes Air ONLY. Transaction type Sales ONLY. Vouchers Excluded. Report results in Airline Name, Current Period and Current Year to Date, Previous Period, Previous Year to Date, Year To Year Changes in Percentages.
838	Traveler Activity With Summary	Traveler Activity with Summary. Sorted By Passenger Name then Booking type. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results are Issue Date, Traveler Name, Invoice #, Ticket / Confirmation #, Amount, From Date, To Date, Itinerary by City Code , Vendor. Subtotaled by Traveler. Grand Total Provided. Traveler Summary provided at end of report.
839	Traveler Activity With Summary With YTD Cost	Traveler Activity with Summary and Year To Date Costs. Sorted By Passenger Name then Booking type. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results are Issue Date, Traveler Name, Invoice #, Ticket / Confirmation #, Amount, From Date, To Date, Itinerary by City Code , Vendor. Subtotaled by Traveler. Grand Total Provided. Traveler Summary provided at end of report.
845	Executive Summary Year Over Year	Executive Summary - Previous Year To Date / Current Year to Date. This report includes Air, Rail, Car, Hotel and Service Fees. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results in Air Spend , Estimated Car Spend, Estimated Hotel Sped and Estimated Total Spend. Report includes # of Tickets, # of invoices, # of Credits, Net # Same Day Round Trips / One Ways, Net # Overnight Trips; Average Days Purchased in Advance, Average Ticket Price, Savings From Standard Fare, Negotiated Savings, Lost Savings, Total Miles, Average Miles per trip, Average Cost per Mile. Volume Issued = Sales Invoices; Volume Refunded = Refund Invoices; Net Volume = Sales - Refunds; Net Savings = High Fare - (Sales + Refunds) ; Lost Savings = Low Fare - (Sales + Refunds).
850	Hotel Detail By Passenger Name With Sort1	Hotel Detail Report Sorted by Passenger Name includes Sort 1. This report is Hotels ONLY. Vouchers excluded. The report results Traveler, Hotel property, Hotel City, Invoice #, Issue Date, Check-in, Check-out, Confirmation #, Sort 1, # of Nights, Rate, Total Paid. Report Subtotaled by Passenger Name. Grand Total provided.
853	Traveler Activity With Segments (filter by Depart/arrive cities)	Traveler Activity Sorted By Passenger Name then Booking type. NO $$ Value on this report. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results are Issue Date, Traveler Name, Ticket # / Confirmation #, Date/Time, Departure City Code and Name, Airline/Flight #, Arrival City Code and Name, Cities, Date/Time.
854	Air Detail with Service Fees by Passenger Name (filter by Depart/arrive cities)	Air Detail By Passenger Name With Service Fees. (filter by Depart / Arrive Cities). This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. The report results in Passenger Name - Issue Date, Invoice #, Ticket #, Amount, Airline Code, Flight #, Class of Service, Depart Date and Time, From City Code and Name, To City Code and Name, Arrive Date and Time. Subtotaled by Passenger Name. Grand Total Provided. Total Paid = Amount.
856	Car Detail By Account Name, Vender With Sorts	Car Detail Sorted by Account Name and then Vendor. This report includes Car ONLY. Vouchers excluded. The report results include Account Name -Vendor Name --- Traveler Name, Car Rental Company, City, Invoice #, Issue Date, Pick Up Date, Drop Off Date, Confirmation #, # of days, Rate, Total before tax. The report Subtotals by Vendor. Grand Total provided. Start Date = Pick Up Date; End Date = Drop Off Date; document # = Confirmation #, duration * # of units = # of days.
857	Hotel Detail By City With Sort1	Hotel Detail Report Sorted by City includes Sort 1. This report is Hotels ONLY. Vouchers excluded. The report results Traveler, Hotel property, Hotel City, Invoice #, Issue Date, Check-in, Check-out, Confirmation #, Sort 1, # of Nights, Rate, Total Paid. Report Subtotaled by property cities. Grand Total provided.
858	Hotel Detail By Property With Sort1	Hotel Detail Report Sorted by property includes Sort 1. This report is Hotels ONLY. Vouchers excluded. The report results Traveler, Hotel property, Hotel City, Invoice #, Issue Date, Check-in, Check-out, Confirmation #, Sort 1, # of Nights, Rate, Total Paid. Report Subtotaled by Hotel properties. Grand Total provided.
860	Hotel Detail By Account Name	Hotel Detail Report Sorted by Interface ID. This report is Hotels ONLY. Vouchers excluded. The report results interface ID, Traveler, Hotel property, Hotel City, Invoice #, Issue Date, Check-in, Check-out, Confirmation #, # of Nights, Rate, Total Paid. Report Subtotaled by Interface ID. Grand Total provided.
861	Savings Lost Savings Detail Low Fare By Sort1234 By Account Name	Savings Lost Savings Detail Low Fare by Account Name and Sort 1, Sort 2, Sort 3, Sort 4. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results in Sort 1 - Sort 2 - Sort 3 - Sort 4 -Reason Code Description ---- Passenger Name , Advance Purchase Days, Issue Date, Depart Date, Airline Code, Itinerary, Fare Paid, Low Fare, Savings $. Start Date = Depart Date; End Date = Return Date; Total Paid = Fare Paid; Coach Fare = High Fare.
863	Savings Detail	Savings Detail Full Farr by Account Name and Reason Code Description. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results in Account Name - Reason Code Description ----Reason Code, Passenger Name , Issue Date, Depart Date, Airline Code, Itinerary, Ticket #, Full Fare, Fare Paid, Savings $. Start Date = Depart Date; End Date = Return Date; Total Paid = Fare Paid; Coach Fare = High Fare.
865	Air Detail Report with Sort 1	Air Detail With Sort 1. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. The report results in Passenger Name - Invoice #, Sort 1, Depart Date, Original City Name, Destination City Name, Airline Code, Flight #, Fare Basis, Full Fare, Low Fare, Fare Paid, Fare Savings, Lost Savings, Reason Code. Subtotaled by Passenger Name. Grand Total Provided. Total Paid = Amount.
868	Top 12 Travelers	Top 12 Travelers. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results in Traveler name, Gross Fare Paid, % of Total Gross Fare Paid, Average Ticket price, # of Transactions, % of Total Transactions. Grand Total included.
872	Top 50 Market Pair With Airlines With Segment Count	Top 50 Market Pair With Airlines with Segment Count. Listed alphabetically by the Market Pair. This report includes Air ONLY. Transaction type Sales ONLY. Vouchers excluded. Report results Market Pair, Airline Code, Segment Count, Net Trips, % of Trips, Net Volume, % of Volume. Grand Total provided. Net Trips = Booking ID Count; Net Volume = City Pair Fare; Trips are counted as one ways (not counting connections)
874	Hotel Detail By Account Name By Sort1	Hotel Detail Report Sorted by Account Name and by Sort 1. This report is Hotels ONLY. Vouchers excluded. The report results account name, Sort 1, interface ID, Traveler, Hotel property, Hotel City, Invoice #, Issue Date, Check-in, Check-out, Confirmation #, # of Nights, Rate, Total Paid. Report Subtotaled by Account Name. Grand Total provided.
878	Car Detail By Vendor By Sort1 With Summary	Car Detail Sorted by Vendor and by Sort 1 with Summary. This report includes Car ONLY. Vouchers excluded. The report results include Car Company - Traveler Name, City, Invoice #, Issue Date, Pick Up Date, Drop Off Date, Confirmation #, Car Type, # of days, Rate, Total before tax. The report Subtotals by Passenger Name. Grand Total provided. Start Date = Pick Up Date; End Date = Drop Off Date; document # = Confirmation #, duration * # of units = # of days.
880	Top 20 Travelers By Volume	Top 20 Travelers Sorted by Volume. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results in Traveler name, Gross Fare Paid, % of Total Gross Fare Paid, Average Ticket price, # of Transactions, % of Total Transactions. Grand Total included.
882	Top 25 City Pair By Airline	Top 25 City Pair By Airline. This report includes Air ONLY. Transaction type Sales ONLY. Vouchers Excluded. Report results in City Pair, Airlines and Totals. Grand Total Provided. Trips = Net Transactions = Sales (1), Refunds (-1), Exchanges (0).
884	YOY Airline Summary	Year Over Year Airline Summary includes Pie Chart Airline Summary. This report includes Air ONLY. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results in Current Month Compared to Same Month Last Year. Report results in Airline, # of Passenger Names, Gross $, Taxes, Total $, % of Total $ for each period. % of change provided. Grand Totals located at bottom of report. Booking ID Count = # of Passenger Names, Base Fare = Gross, Total Tax = Tax, Total Paid = Total.
898	Credit card Detail By Passenger Name With CC With Invoice	Credit Card Detail By Passenger Name with Sort Credit Card and Invoice #. This report includes Air, Rail and Service Fees. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. Report sorted by Credit Card # and includes Passenger Name , Vendor Name, Invoice #, Ticket #, Issue Date, Itinerary, Depart Date, Return Date, Total. Grand total provided. Parameters included: Start Date = Depart Date; End Date = Return Date; Total Paid = Fare Paid.
899	TravCom Top 25 Hotel Bookings By Account	TravCom Top 25Hotel Bookings By Account. This report includes Hotels ONLY. Vouchers excluded. Report results in Account Name, # of Stays, # of Nights, % of Nights, Volume Booked, % of Volume, Average Nights per stay, Average Cost per Stay, Average Cost per Day. Subtotal by top accounts. Subtotaled by Accounts Not listed. Grand total provided. Trips = Net Transactions = Sales (1), Refunds (-1), Exchanges (0). Durations < 30 days, Total Paid > $ 0. Booking Rate > $ 20.
900	TravCom Top 25 Car Rentals By Account	TravCom Top 25 Car Rentals By Account. This report includes Cars ONLY. Vouchers excluded. Report results in Account Name, # of Rentals, # of Days, % of Days, Volume Booked, % of Volume, Average Nights per Rental, Average Cost per Rental, Average Cost per Day. Subtotal by top accounts. Subtotaled by Accounts Not listed. Grand total provided. Trips = Net Transactions = Sales (1), Refunds (-1), Exchanges (0). Durations < 30 days, Total Paid > $ 0. Booking Rate > $ 20.
901	Top 100 Market Pairs With Miles	Top 100 Market Pairs With Miles. This report includes Air ONLY. Transaction types Sales Refunds and Exchanges. Vouchers Excluded. Report results in Market Pair, Airline, Miles, Ticketed Trips, % of Trips, Ticketed Volume, Cost Per Mile, % of Total. Subtotaled by Market Pair. Grand Total Provided. Depart City Not Blank; Arrive City not blank; Trips - Net Transactions = Sales (1), Refunds (-1), Exchanges (0).
903	Top 100 Segments	Top 100 Segments. This report includes Air ONLY. Transaction types Sales Refunds and Exchanges. Vouchers Excluded. Report results in Market Pair, Cost Per Mile, Miles, Segments, Cost per Segment, , % of Trips, Ticketed Volume, % of Total. Subtotaled by Market Pair. Grand Total Provided. Depart City Not Blank; Arrive City not blank; Trips - Net Transactions = Sales (1), Refunds (-1), Exchanges (0).
907	Air Detail By Sort 1 With Service Fees	Air Detail with Service Fees sorted by Sort 1. This report includes Air, Rail and Service Fee. The transaction types include Sales, Refunds, and Exchanges. Vouchers excluded. This report results in information by Sort 1 - Invoice #, Issued Date, Ticket #, Passenger Name , Credit Card, Origin City name, Destination City Name, Airline Code, Flight #, Depart Date, Service Fees, Total Paid. Calculations used in this report include Issued Date = Booked date; Document # = Ticket #, Total Paid = Fare Paid = Amount, Master City Table and Segment Table used.
917	Where Are My Travelers With Sort1, 2 And 3	Where Are My Travelers By Sort 1, Sort 2 and Sort 3 . This report includes Air, Rail, Car and Hotel. Transaction type Sales and Exchanges. Vouchers excluded. The report results in Sort 1, Sort 2, Sort 3 -- Passenger Name; Depart Date and Time, Departure City Name and Code; Airline Code; Flight #; Arrival City Name and Code; Arrival Date and Time. This report results are based on the date the report is printed and it will not produce results if the start date and / or the end date are NULL. Report uses Master City Table and Segment Table.
922	Arrival Manifest Excel Data Only	Arrival Manifest Excel Data ONLY with Sort 1, Sort 2 and Sort 3. This report includes Air and Rail. Transactions types include Sales and Exchanges. Vouchers Excluded. Report results in Company Name, Booking Id, Start Date, End Date, Traveler Name, Departure City Code, Departure City Name, Departure State Code Departure Country, Departure Date, Departure Time, Departure Airline Code, Flight #, Arrival City Code, Arrival City Name, Arrival State Code, Arrival Country Code Arrival Date, Arrival Time, Sort 1, Sort 2, Connection Code, Original City Code, Origin City Name, Destination City Code Destination City Name, Sort 3. Code Long Date, Arrival City Name and Code, Arrival Time, Traveler Name; Arrival short date and time, Airline Code, Flight #, From Airport, Origin Airport. Summary by Traveler. Total Summary of all Travelers. This report uses the Master City Table. Report parameters include: Start Date not NULL; End Date not NULL; Reissues not included.
930	Batch Detail Report	Batch Detail Report. Report on Batch set-up. By Login Name, Batch name, Batch ID, Report ID, Run Time, Report Name, Original Report Name Date Field, Date Filter, Export Type, Corporation Name
931	Air Detail By Pass With Mileage Without CC	Air Detail By Passenger Name With Mileage Without Credit Card. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report sorted by Passenger Name . Report results in Issue Date, Passenger Name , Invoice #, Ticket #, Amount, Airline Code, Flight #, Class, Depart Date and Time, From City and Code, To City and Code, Arrive ate and Time, Miles. Subtotaled by Passenger Name for Amount and Miles. Grand Total Provided. Total Paid = Amount.
932	Air Detail By Pass With Mileage Without CC-Flown	Air Detail By Passenger Name With Mileage Without Credit Card - Flown. This report includes Air and Rail. Transaction types Sales and Refunds. Vouchers Excluded. Report sorted by Passenger Name . Report results in Issue Date, Passenger Name , Invoice #, Ticket #, Amount, Airline Code, Flight #, Class, Depart Date and Time, From City and Code, To City and Code, Arrive ate and Time, Miles. Subtotaled by Passenger Name for Amount and Miles. Grand Total Provided. Total Paid = Amount; Refunds and Reissues Not included in this report.
933	Traveler Activity By Invoice With Agent ID	Traveler Activity Detail by Invoice includes Agent ID. Transaction types Sales, Refunds and Exchanges. Vouchers excluded. The report results in Invoice #, type of travel, Passenger Name, Issue Date, Ticket # / Confirmation #, Agent ID, Total Paid, from Date, to Date, cities, vendor. Subtotaled by Invoice #. Grand Total is provided.
935	Account Sales/Revenue Period Comparison	Account Sales/Revenue Period Comparison. This report Excludes Vouchers and Voids. Report Results in Four Categories: Current Period, Previous Period, Difference % of Difference. Sorted by Account Name. Report fields are Account Name, Booking Type, Total Sales, Revenue, and Transactions. Subtotaled by Account Name, Grand Total provided. Transactions = Net Transactions = Sales (1), Refunds (-1), Exchanges (0).
938	Travel Management Summary	Travel Management Summary. This report includes Air, Rail, Car and Hotel. Transaction types Sales, Refunds and Exchanges, Vouchers excluded. Air/Rail Sales and Net Transactions broken into Domestic and International. Grand Totals Include Air Volume, Refund Volume, # of Invoices, # of Refunds, Full Fare, Low Fare, Savings, Missed Savings, Exchanges. Hotel includes # of Rooms Booked, Hotel Cost, # of Nights, Averages. Car includes # of Cars Booked, Car Rental Cost, # of Cars and Averages. Grand Total NOT provided on this report. Calculation Information: Issue date = Issued Month; Total Paid = Volume; Invoice # used for Invoice Count; Coach Fare = High Fare; Savings = Total Paid - High Fare; Missed Savings = Total Paid - Low Fare.
944	Air Travel Detail With Sort1 And Sort2	Air Travel Detail including Sort 1 and Sort 2 This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers excluded. The report results in Sort 1,Passenger Name , Invoice #, Sort 1, Depart Date, Sort 2, Origin City Name, Destination City Name, Airline Code, Flight #, Fare Basis, Full Fare, Low Fare, Fare Paid, Fare Savings, Lost Savings, CD. Subtotaled by Passenger Name . Grand Total is provided.
947	Air Activity Simple By Passenger Name With CC Sort1 With Record Locator	Air Activity Simple By Passenger Name With Credit Card, Sort 1 and Record Locator. This report includes Air, Rail and Service Fee. Transaction types Sales, Refunds and Exchanges. Vouchers excluded. The report sorts in the following order: Sort 1,Issue Date and then Passenger Name . The report results are Sort 1, Passenger Name , Issue Date, Depart Date, Return Date, Airline Code, Itinerary by City Code, Invoice #, Ticket #, Original Ticket #, Record Locator, Billed To and Total. Subtotals by Sort 1, Grand Total Provided. Start Date = Depart Date; End Date = Return Date; Document # = Ticket #, Original Document # = Exchange Ticket #, Fare Paid = Total Paid, Payment # = Billed To.
948	Sales Report By Invoice With Sort1 With Record Locator	Sales Report sorted By Invoice with Sort 1 and Record Locator. This report includes Air, Rail and Service Fees. Transaction types of Sales, Refunds and Exchanges. Vouchers Excluded. Report results: Invoice #, Invoice Date, Passenger Name , Ticket #, Record Locator, Original Ticket #, Total Paid, Sort 1. Grand Total Provided.
949	Sales Report By Invoice By Sort1 With Record Locator	Sales Report sorted By Invoice and By Sort 1 with Record Locator. This report includes Air, Rail and Service Fees. Transaction types of Sales, Refunds and Exchanges. Vouchers Excluded. Report results: Sort 1,Invoice #, Invoice Date, Passenger Name , Ticket #, Record Locator, Original Ticket #, Total Paid. Grand Total Provided.
953	GST HST QST Report	GST HST QST Report. This report includes Air, Rail, Car, Hotel and Service Fees. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report is sorted by Invoice Number. Report results in Invoice #, Invoice Date, Passenger Name , Ticket #, Travel Type, Base Fare, Total Taxes, GST/HST, QST, Fare Paid. Grand Total Provided. Total Paid = Fare Paid.
954	Advance Purchase Detail Sort1 Sort2 Sort3	Advance Purchase Detail by Sort 1, Sort 2, Sort 3. This report includes Air and Rail. Transactions type Sales ONLY. Vouchers Excluded. The report sorts by Sort 1, Sort 2, and Sort 3 withe results of Passenger Name , Sort 1, Sort 2, Sort 3, Issue Date, Depart Date, Return Date, Airline Code, Itinerary by City Code, Invoice, and Total Cost. Subtotaled by # of Days Advance. Grand Total Provided. Start Date = Depart Date; End Date = Return Date.
957	WestJet Market Pair Report	WestJet Market Pair Report. This report includes Air ONLY, Transaction types Sales and Refunds. Vouchers Excluded. Report broken out into Four Categories: Domestic, International, Transborder, Grand Total; Report results in Market Pair, Segment Count All Carriers, Segment Count WestJet, WestJet Market Share, City Pair Market Share, WestJet total Fare, Total Fare All Carriers. Subtotal per category. Segment Fare = City Pair Fare; Count = Net Transactions = Sales (1), Refunds (-1), Exchanges (0).
959	West Jet Air Carrier Validation Report	West Jet Air Carrier Validation Report. This report includes Air ONLY. Transaction Types Sales and Refunds. Vouchers Excluded. Airline Vendors WestJet and Other. Report results in types, segment carrier, # of segments, Segment Fare, Average Fare, Market Share %. Grand Total Provided. # of segments = net transactions = Sales (1), Refunds (-1).
960	Hotel Commission Detail	Hotel Commission Detail. This report includes Hotel ONLY. Vouchers Excluded. Report sorted by Invoice Date. Report results in Traveler Name, Invoice #, Hotel Property, Address, City, Phone #, Issue Date, Check In Date, # of nights, Rate, Total Paid, Commission. Grand Total Provided. Start Date = Check-in Date.
962	Global Car Detail By Passenger Name	Global Car Detail Sorted by Passenger Name. This report includes Car ONLY. Vouchers excluded. The report results include Traveler, Car Company, City, Invoice #, Issue Date, Pick Up Date, Drop Off Date, Confirmation #, Class, # of days, Rate, Total before tax. The report Subtotals by Passenger Name. Grand Total provided. Start Date = Pick Up Date; End Date = Drop Off Date; document # = Confirmation #, duration * # of units = # of days.
963	Global Car Detail By Passenger Name By Sort1	Global Car Detail Sorted by Sort 1. This report includes Car ONLY. Vouchers excluded. The report results include Sort 1, Traveler, Car Company, City, Invoice #, Issue Date, Pick Up Date, Drop Off Date, Confirmation #, Class, # of days, Rate, Total before tax. The report Subtotals by Passenger Name. Grand Total provided. Start Date = Pick Up Date; End Date = Drop Off Date; document # = Confirmation #, duration * # of units = # of days.
964	Global Car Detail By Passenger Name By Sort1 Sort2	Global Car Detail Sorted by Sort 1 and by Sort 2. This report includes Car ONLY. Vouchers excluded. The report results include Sort 1, Sort 2, Traveler, Car Company, City, Invoice #, Issue Date, Pick Up Date, Drop Off Date, Confirmation #, Class, # of days, Rate, Total before tax. The report Subtotals by Passenger Name. Grand Total provided. Start Date = Pick Up Date; End Date = Drop Off Date; document # = Confirmation #, duration * # of units = # of days.
965	Global Car Summary By Company	Global Car Summary By Car Company sorted by # of bookings. This report includes Car ONLY. Transaction types include Sales ONLY. Voids and Vouchers excluded. The report results in Car Company, # of Car bookings, % of Total, # of Car days, % of Total, Average Rate, Total before tax, % of Total. Bookings = Total Paid ;Car Days = Car Rental Days; Average Rate = Total Paid / Car Rental Days.
966	Global Car Summary By Company By Sort1	Global Car Summary By Car Company sorted by Sort 1. This report includes Car ONLY. Transaction types include Sales ONLY. Voids and Vouchers excluded. The report results in Sort 1, Car Company, # of Car bookings, % of Total, # of Car days, % of Total, Average Rate, Total before tax, % of Total. Bookings = Total Paid ;Car Days = Car Rental Days; Average Rate = Total Paid / Car Rental Days.
967	Global Car Summary By Company By Sort1 Sort2	Global Car Summary By Car Company sorted by Sort 1 and by Sort 2. This report includes Car ONLY. Transaction types include Sales ONLY. Voids and Vouchers excluded. The report results in Sort 1, Sort 2, Car Company, # of Car bookings, % of Total, # of Car days, % of Total, Average Rate, Total before tax, % of Total. Bookings = Total Paid ;Car Days = Car Rental Days; Average Rate = Total Paid / Car Rental Days.
968	Global Hotel Summary By Property	Global Hotel Summary Sorted By Property (# of Nights in descending order) This report includes Hotels ONLY. Vouchers excluded. The reports results in Hotel Property, Booking #, % of Booking #, # of Nights, % of # Nights, Average Rate, Total Paid, % of Total Paid.
969	Global Hotel Summary By Property By Sort1	Global Hotel Summary Sorted By Property and by Sort 1 (# of Nights in descending order) This report includes Hotels ONLY. Vouchers excluded. The reports results in Hotel Property, Sort 1, Booking #, % of Booking #, # of Nights, % of # Nights, Average Rate, Total Paid, % of Total Paid.
970	Global Hotel Summary By Property By Sort1 Sort2	Global Hotel Summary Sorted By Property , Sort 1 and Sort 2 (# of Nights in descending order) This report includes Hotels ONLY. Vouchers excluded. The reports results in Hotel Property, Sort 1, Sort 2, Booking #, % of Booking #, # of Nights, % of # Nights, Average Rate, Total Paid, % of Total Paid.
971	Global Air Detail Report	Global Air Detail. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. The report results in Passenger Name - Invoice #, Sort 1, Depart Date, Original City Name, Destination City Name, Airline Code, Flight #, Fare Basis, Full Fare, Low Fare, Fare Paid, Fare Savings, Lost Savings, Reason Code. Subtotaled by Passenger Name. Grand Total Provided. Total Paid = Amount.
972	Global Air Detail Report By Sort1	Global Air Detail By Sort 1. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. The report results in Sort 1 - Passenger Name , Invoice #, Sort 1, Depart Date, Original City Name, Destination City Name, Airline Code, Flight #, Fare Basis, Full Fare, Low Fare, Fare Paid, Fare Savings, Lost Savings, Reason Code. Subtotaled by Passenger Name. Grand Total Provided. Total Paid = Amount.
973	Global Air Detail Report By Sort1 Sort2	Global Air Detail By Sort 1 and Sort 2. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. The report results in Sort 1 - Sort 2 -Passenger Name , Invoice #, Sort 1, Depart Date, Original City Name, Destination City Name, Airline Code, Flight #, Fare Basis, Full Fare, Low Fare, Fare Paid, Fare Savings, Lost Savings, Reason Code. Subtotaled by Passenger Name. Grand Total Provided. Total Paid = Amount.
974	Global Top 50 Market Pairs For Airline AA AC BA CO WS	Global Top 50 Markets for AA,AC,BA,CO,WS. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. Report results Market Pair, All trips, % of all trips, AA trips, % of AA trips, AC trips, % of AC trips, BA trips, % of BA trips, CO trips, % of CO trips, WS trips, % of WS trips, Others, % of Others and Grand Total. Arrival Airline = Airline; Depart City and Arrival City used for Market Pairs.
975	Global Top 50 Market Pairs By Airline AA AC BA CO WS By Sort1	Global Top 50 Markets for AA,AC,BA,CO,WS Sorted by Sort 1. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. Report results Sort 1, Market Pair, All trips, % of all trips, AA trips, % of AA trips, AC trips, % of AC trips, BA trips, % of BA trips, CO trips, % of CO trips, WS trips, % of WS trips, Others, % of Others and Grand Total. Arrival Airline = Airline; Depart City and Arrival City used for Market Pairs.
978	Global Travel Summary By Sort1	Global Travel Summary By Sort 1 This report includes Air, rail, Car, Hotel, Service Fees. Transaction types include Sales, Refunds, Exchanges. Vouchers excluded. The report results in Three categories of data: Air: trips taken, Total trip days, cost/mile, miles, Average trip cost. Hotel: Potential Nights, actual Nights, missed Bookings, % missed Bookings, Total $, Average Hotel Rate. Car: Total days,
979	Global Travel Summary By Sort1 Sort2	Global Travel Summary By Sort 1 and Sort 2 This report includes Air, rail, Car, Hotel, Service Fees. Transaction types include Sales, Refunds, Exchanges. Vouchers excluded. The report results in Three categories of data: Air: trips taken, Total trip days, cost/mile, miles, Average trip cost. Hotel: Potential Nights, actual Nights, missed Bookings, % missed Bookings, Total $, Average Hotel Rate. Car: Total days,
980	Global Where Are My Travelers	Global Where Are My Travelers. This report shows by Traveler Name the active trips they are currently on based on the day the report was printed. Grey sections indicate portions of travel that have already been completed. Report results in Traveler Name, Invoice Date, Depart Date/Time, Departure City, Airline/Flight#, Arrival City, Arrival Date/Time. Formulas: Start Date = Depart Date; End Date = Arrival Date; City Name and City Code provided; Airline Code Only.
981	Global Where Are My Travelers By Sort1	Global Where Are My Travelers By Sort 1 and by Passenger Name . This report includes Air, Rail, Car and Hotel. Transaction type Sales and Exchanges. Vouchers excluded. The report results in Passenger Name; start date; start time Origin City Name and Code; Airline Code; Flight #; Destination City Name and Code; End Date and Time. This report results are based on the date the report is printed and it will not produce results if the start date and / or the end date are NULL. Report uses Master City Table and Segment Table.
982	Global Where Are My Travelers By Sort1 Sort2	Global Where Are My Travelers By Sort 1, Sort 2 and by Passenger Name . This report includes Air, Rail, Car and Hotel. Transaction type Sales and Exchanges. Vouchers excluded. The report results in Passenger Name; start date; start time Origin City Name and Code; Airline Code; Flight #; Destination City Name and Code; End Date and Time. This report results are based on the date the report is printed and it will not produce results if the start date and / or the end date are NULL. Report uses Master City Table and Segment Table.
984	Global Travel Management Summary By Sort1	Global Travel Management Summary by Sort 1. This report includes Air, Rail, Car and Hotel. Transaction types Sales, Refunds and Exchanges, Vouchers excluded. Air/Rail Sales and Net Transactions broken into Domestic and International. Grand Totals Include Air Volume, Refund Volume, # of Invoices, # of Refunds, Full Fare, Low Fare, Savings, Missed Savings, Exchanges. Hotel includes # of Rooms Booked, Hotel Cost, # of Nights, Averages. Car includes # of Cars Booked, Car Rental Cost, # of Cars and Averages. Grand Total NOT provided on this report. Calculation Information: Issue date = Issued Month; Total Paid = Volume; Invoice # used for Invoice Count; Coach Fare = High Fare; Savings = Total Paid - High Fare; Missed Savings = Total Paid - Low Fare.
985	Global Travel Management Summary By Sort1 Sort2	Global Travel Management Summary by Sort 1 and Sort 2. This report includes Air, Rail, Car and Hotel. Transaction types Sales, Refunds and Exchanges, Vouchers excluded. Air/Rail Sales and Net Transactions broken into Domestic and International. Grand Totals Include Air Volume, Refund Volume, # of Invoices, # of Refunds, Full Fare, Low Fare, Savings, Missed Savings, Exchanges. Hotel includes # of Rooms Booked, Hotel Cost, # of Nights, Averages. Car includes # of Cars Booked, Car Rental Cost, # of Cars and Averages. Grand Total NOT provided on this report. Calculation Information: Issue date = Issued Month; Total Paid = Volume; Invoice # used for Invoice Count; Coach Fare = High Fare; Savings = Total Paid - High Fare; Missed Savings = Total Paid - Low Fare.
986	Global Air Volume Summary	Global Air Volume Summary sorted by Grand Total # of Trips. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers Excluded. Report results include Summary for Domestic, International and Grand Totals. Summary of Airline, Total Trips, % of Trips, Ticketed Price, % of Ticketed Price, Average Price and Grand Totals. All amounts and nets are count (because sales, exchanges, and refunds are counted). Average Ticket Price = Intl Volume + Dom Volume / Dom Trips + Intl Trips; Trips = Domestic Trips + International Trips ; Ticketed Price = International Volume + Domestic Volume / Domestic Trips + International Trips.
987	Global Air Volume Summary By Sort1	Global Air Volume Summary sorted by Sort 1 and Grand Total # of Trips. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers Excluded. Report results include Summary for Domestic, International and Grand Totals. Summary of Airline, Total Trips, % of Trips, Ticketed Price, % of Ticketed Price, Average Price and Grand Totals. All amounts and nets are count (because sales, exchanges, and refunds are counted). Average Ticket Price = Intl Volume + Dom Volume / Dom Trips + Intl Trips; Trips = Domestic Trips + International Trips ; Ticketed Price = International Volume + Domestic Volume / Domestic Trips + International Trips.
988	Global Air Volume Summary By Sort1 Sort2	Global Air Volume Summary sorted by Sort 1, Sort 2 and Grand Total # of Trips. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers Excluded. Report results include Summary for Domestic, International and Grand Totals. Summary of Airline, Total Trips, % of Trips, Ticketed Price, % of Ticketed Price, Average Price and Grand Totals. All amounts and nets are count (because sales, exchanges, and refunds are counted). Average Ticket Price = Intl Volume + Dom Volume / Dom Trips + Intl Trips; Trips = Domestic Trips + International Trips ; Ticketed Price = International Volume + Domestic Volume / Domestic Trips + International Trips.
989	Global Graphical Air Volume Summary	Global Graphical Air Volume Summary. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Two Pie Charts at the bottom of the report for Domestic Vendor Contribution and International Vendor Contribution. Report broken into three categories: Domestic, International, Grand Total. Report results in Airline, # of Trips, % of Trips, Ticket Price, % of Ticket, Average Ticket Price. Grand Total provided.
990	Global Graphical Air Volume Summary By Sort1	Global Graphical Air Volume Summary by Sort 1. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Two Pie Charts at the bottom of the report for Domestic Vendor Contribution and International Vendor Contribution. Report broken into three categories: Domestic, International, Grand Total. Report results in Sort 1 - Airline, # of Trips, % of Trips, Ticket Price, % of Ticket, Average Ticket Price. Grand Total provided.
992	Global credit card Detail By Passenger Name	Global Credit Card Detail By Passenger Name. This report includes Air, Rail and Service Fees. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. Report sorted by Credit Card # and Passenger Name and includes Vendor Name, Airline Code, Ticket #, Issue Date, Itinerary, Total Paid. Grand Total Provided.
993	Global credit card Detail By Passenger Name By Sort1	Global Credit Card Detail By Passenger Name and by Sort 1. This report includes Air, Rail and Service Fees. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. Report sorted by Credit Card #, Sort 1 and Passenger Name and includes Vendor Name, Airline Code, Ticket #, Issue Date, Depart Date, Itinerary, Return Date, Total Paid. Grand Total Provided.
994	Global credit card Detail By Passenger Name By Sort1 Sort2	Global Credit Card Detail By Passenger Name and by Sort 1 and Sort 2.. This report includes Air, Rail and Service Fees. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. Report sorted by Credit Card #, Sort 1, Sort 2 and Passenger Name and includes Vendor Name, Airline Code, Ticket #, Issue Date, Itinerary, Total Paid. Grand Total Provided.
1000	Global Airline Contract Report - AA	Airline Contract Report - AA. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. Vouchers and Vouchers excluded. The report results in Market Pair, Ticketed Trips (All, AA, AA %), Segment Volume (All, AA, AA %). Grand Total provided. Calculations: AA % = AA/All.
1001	Global Executive Summary Report-ALL	Global Executive Summary Report (All) - Current Year Month to Previous Year Month / Current Year to Date to Previous Year to Date. This report includes Air, Rail, Car and Hotel. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results Air (Volume Issued, Volume Refunded, Savings, Lost Savings, Transactions) Hotel (Spend, Reservations, Room Nights, Average Rate) and Car (Spend, Reservations, Days, Average Rate) Grand Total Provided. Volume Issued = Sales Invoices; Volume Refunded = Refund Invoices; Net Volume = Sales - Refunds; Net Savings = High Fare - (Sales + Refunds) ; Lost Savings = Low Fare - (Sales + Refunds).
1002	Global Savings Summary	Global Savings Summary. Report by Reason Code. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Voids and Vouchers excluded. The report results are Summary by reason code, # of Transactions, Total Fare $, Savings , with Grand Total. Net Transaction Count calculated as follows: Sales = 1, Refunds = -1, Exchanges = 0. Formulas: Savings = High Fare - Volume; Lost Savings = Low Fare - Volume; Net Savings = Savings - Lost Savings.
1003	Global Lost Savings Summary	Global Lost Savings Summary. Report by Reason Code. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Voids and Vouchers excluded. The report results are Summary by reason code, # of Transactions, Total Fare $, Lost Savings $, with Grand Total. Net Transaction Count calculated as follows: Sales = 1, Refunds = -1, Exchanges = 0. Formulas: Savings = High Fare - Volume; Lost Savings = Low Fare - Volume; Net Savings = Savings - Lost Savings.
1004	Top 20 MarketPair With Advance Purchase	Top 20 Market Pair With Advance Purchase. Listed alphabetically by the Market Pair and then by # of Trips. This report includes Air ONLY. Transaction type Sales ONLY. Vouchers excluded. Report results Market Pair broken down by Advance Purchase days, Net Trips,, Net Volume, % of Volume, Average Ticket Cost. Grand Total provided. Net Trips = Booking ID Count; Net Volume = City Pair Fare.
1005	Top 20 MarketPair With Advance Purchase Summary	Top 20 Market Pair With Advance Purchase. Listed alphabetically by the Market Pair and then by # of Trips. This report includes Air ONLY. Transaction type Sales ONLY. Vouchers excluded. Report results Market Pair broken down by Advance Purchase days, Net Trips,, Net Volume, % of Volume, Average Ticket Cost. Grand Total provided. Net Trips = Booking ID Count; Net Volume = City Pair Fare.
1006	Account Summary Sort By Account Name	Account Summary. This report includes Air, Rail and Service Fees. Transaction type Sales, Refund and Exchanges. Vouchers Excluded. The report results in Account Name, # of Trips, % of Trips, Volume, % of Volume, Average Cost Per Trip, Commission, Service Fee. Subtotal of Accounts Listed. Subtotal of Accounts Not Listed. Grand Total. Net Transaction = Trips = Sales (1), Refunds (-1) and Exchanges (0).
1007	Air Volume Summary With Commission	Air Volume Summary with Commission. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers Excluded. Report results include Summary for Domestic, International and Grand Totals. This report results in Total Trips, % of Trips, Ticketed Price, % of Ticketed Price, Commission and Grand Totals. All amounts and nets are count (because sales, exchanges, and refunds are counted). Average Ticket Price = Intl Volume + Dom Volume / Dom Trips + Intl Trips; Trips = Domestic Trips + International Trips ; Ticketed Price = International Volume + Domestic Volume / Domestic Trips + International Trips.
1010	Global Traveler Activity By Invoice	Global Traveler Activity by Invoice. This report includes all travel types. Transaction types include Sales, Refunds and Exchanges. Vouchers and Vouchers excluded. The report results in type of sale, Issue Date, Traveler name, Ticket/Confirmation #, Total Paid, From Date, To Date, cities, Vendor. Subtotal by Invoice and Grand Total provided.
1025	Executive Summary with Current YTD	Executive Summary with Current Year To Date - Current Year Month to Previous Year Month / Current Year to Date to Previous Year to Date. This report includes Air, Rail, Car and Hotel. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results include Domestic, International and Transborder Summary for Air, Rail, Car and Hotel. Grand Total for each category provided. Grand Total on Total Spend. Volume Issued = Sales Invoices; Volume Refunded = Refund Invoices; Net Volume = Sales - Refunds; Net Savings = High Fare - (Sales + Refunds) ; Lost Savings = Low Fare - (Sales + Refunds).
1029	Real Time Where Are My Travelers	Real Time Where Are My Travelers. This report shows by Traveler Name the active trips they are currently on based on the day the report was printed. Grey sections indicate portions of travel that have already been completed. There are no $ Information on this report. Report results in Traveler Name, Invoice Date, Record Locator, Agent ID, Confirmation # / Ticket #, Check in Date, Vendor Name, Vendor Address, Vencor City and State, Vendor Phone, Check Out Date. Formulas: Start Date = Depart Date; End Date = Arrival Date; City Name and City Code provided; Airline Code Only.
1033	Air Detail By Passenger Name With Class with Sort1 Sort2	Air and Service Fee Detail sorted By Passenger Name with Class, Sort 1 and Sort 2. This report includes Air and Service Fees. Transaction Types include Sales, Refunds and Exchanges. Vouchers excluded. Detail report includes Issue date; Passenger Name ; Sort 1, Invoice #, Ticket #; Fare Paid, Trip Segments with Airline Code, Flight #, Class, Depart Date and Time, From City Name and To City Name, Arrive Date and Time. Subtotaled per Traveler. Grand Total provided. Master City Table and Segment Table used for this report. Calculations include; Issue Date = Invoice Date; Depart City = Origin Airport; Arrive City = Destination Airport; Total Paid = Invoice Amount; Low Fare = Fare Offered.
1037	Traveler Activity By Invoice With Sort1 2 3 4	Traveler Activity Detail including Sort 1 and Sort 2 Transaction types Sales, Refunds and Exchanges. Vouchers excluded. The report results in type of travel, Passenger Name, Issue Date, Ticket # / Confirmation #, Sort 1, Sort 2 Total Paid, from Date, to Date, cities, vendor. Grand Total is provided.
1038	Airline Contract Report - B6	Airline Contract Report - B6. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. Vouchers and Vouchers excluded. The report results in Market Pair, Ticketed Trips (All, B6, B6 %), Segment Volume (All, B6, B6 %). Grand Total provided. Calculations: B6 % = B6/All.
1039	Traveler Activity with Fee by Account With Sort 1,2,3,4	Traveler Activity Detail with Service Fee includes Sort 1, Sort 2, Sort 3 and Sort 4 Transaction types Sales, Refunds and Exchanges. Vouchers excluded. The report results in type of travel, Passenger Name, Issue Date, Ticket # / Confirmation #, Sort 1, Sort 2, Sort 3, and Sort 4, Service Fee, Total Paid, from Date, to Date, cities, vendor. Grand Total is provided.
1047	Traveler Activity with Fee by Account With Sort 1,2,3	Traveler Activity Detail with Service Fee includes Sort 1, Sort 2, Sort 3. Transaction types Sales, Refunds and Exchanges. Vouchers excluded. The report results in type of travel, Passenger Name, Issue Date, Ticket # / Confirmation #, Sort 1, Sort 2, Sort 3, Service Fee, Total Paid, from Date, to Date, cities, vendor. Grand Total is provided.
1056	Airline Contract Report - US - ALL	Airline Contract Report - ALL. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. Vouchers and Vouchers excluded. The report results in Market Pair, Ticketed Trips (All, FL, FL %), Segment Volume (All, FL, FL %). Grand Total provided. Calculations: FL % = FL/All.
1061	Airline Contract Report - FL	Airline Contract Report - FL. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. Vouchers and Vouchers excluded. The report results in Market Pair, Ticketed Trips (All, FL, FL %), Segment Volume (All, FL, FL %). Grand Total provided. Calculations: FL % = FL/All.
1064	Call Center vs Online Bookings	Call Center vs. Online Bookings includes pie charts for current period and year to date. This report includes Air ONLY. Transaction types Sales, Refunds and Exchanges. Vouchers excluded. This report compares Agent Assisted Bookings with Online Bookings for Current Period and Year To Date. Fields include Volume, Volume %, Transactions, Transactions %. Grand Total Provided. Volume = Total Paid. Transactions = Net Transactions = Sales (1), Refunds (-1), Exchanges (0).
1065	Travel Time Online Adoption Report	Travel Time Online Adoption Report. This report includes Air and Service Fees. Transaction types Sales, Refunds, Exchanges. Vouchers Excluded. Compares Monthly Transactions and Volume for Domestic Tickets issued by Agent and Online with % of Adoption; International Tickets issued by Agent and Online with % of Adoption; Total Tickets issued by Agent and Online Savings and Potential Savings calculated.
1095	Agent Detail Report	Agent Detail Report. This report includes all travel types. Transaction types include all except Vouchers. Document type Voucher excluded. Report Sorted by Inside and Outside Agent The report results Passenger Name, Invoice #, Record Locator, Booking type, start Date, end Date, Net Volume, Booking commission. Subtotals per agent and Grand Total provided.
1098	Travel Management Summary with Roll over Months	Travel Management Summary with Roll over Months. This report includes Air, Rail, Car and Hotel. Transaction types Sales, Refunds and Exchanges, Vouchers excluded. Air/Rail Sales and Net Transactions broken into Domestic and International. Grand Totals Include Air Volume, Refund Volume, # of Invoices, # of Refunds, Full Fare, Low Fare, Savings, Missed Savings, Exchanges. Hotel includes # of Rooms Booked, Hotel Cost, # of Nights, Averages. Car includes # of Cars Booked, Car Rental Cost, # of Cars and Averages. Grand Total NOT provided on this report. Calculation Information: Issue date = Issued Month; Total Paid = Volume; Invoice # used for Invoice Count; Coach Fare = High Fare; Savings = Total Paid - High Fare; Missed Savings = Total Paid - Low Fare.
1107	Air Activity Detail With Fees	Air Activity with Service Fees Sorted By Issue Date and then Passenger Name. This report includes Air, Rail and Service Fees. Transaction types include Sales, Refunds and Exchanges. Voids and Vouchers Excluded. Report results include Passenger Name, Issue Date, Depart Date, Return Date, Airline code, Itinerary (City Codes), Invoice #, Ticket #, Original Ticket # and Air Fare, Fees, Total Paid. Grand Total provided. Start Date = Depart Date; End Date = Return Date; Total Paid = Fare Paid. Itinerary by Code only.
1135	Traveler Analysis By Country	Traveler Analysis By Country. This report includes Air, Care, Hotel and Service Fees. Transaction types Sales, Refunds, and Exchanges. Vouchers Excluded. Report sorts by Country - Traveler Name, Trip Count, Air Amount, Fee Amount, Hotel Amount # of Nights, Car Amount Total Cost; Average Air Cost / Trip; Average Hotel Night Expense; Average Cost / Trip. Subtotaled by Country. Grand Total provided. Trip Count = Net Transaction = Sales (1), Refunds (-1), Exchanges (0)
1141	Vendors QC Report	Vendors QC Report. This report searches for Duplicate Vendors.
1165	Air Detail By Pass With Kilometers Without CC	Air Detail By Passenger Name With Kilometers Without Credit Card. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report sorted by Passenger Name . Report results in Issue Date, Passenger Name , Invoice #, Ticket #, Amount, Airline Code, Flight #, Class, Depart Date and Time, From City and Code, To City and Code, Arrive Date and Time, Kilometers. Subtotaled by Passenger Name for Amount and Miles. Grand Total Provided. Total Paid = Amount.
1168	Grasp CO2 Emission Report With Kilometers By Sort1	Grasp CO2 Emission Report with Kilometers by Sort 1 includes bar chart showing Emission for Each Month of the year, by Short Haul, Medium Haul and Long Haul. This report includes Air ONLY. Transaction type Sales, Refunds and Exchanges. Vouchers Excluded. Report results in Market Pair, Transactions, Total Kilometers and CO@(Kgs) Grand Total Provided. Short Haul < 452 km; Medium Haul between 452 km and 1600 km; Long Haul . 1600 km
1169	Grasp CO2 Emission Report With Kilometers	Grasp CO2 Emission Report with Kilometers This report includes Air ONLY. Transaction type Sales, Refunds and Exchanges. Vouchers Excluded. Report results in Market Pair per Three categories - Long Haul, Medium Haul and Short Haul., Transactions, Total Kilometers and CO@(Kgs) Subtotal per Category. Grand Total Provided. Short Haul < 452 km; Medium Haul between 452 km and 1600 km; Long Haul . 1600 km.
1185	Global Traveler Activity By Invoice WITH Voids	Traveler Activity Detail Sorted by Invoice and includes Voids. Transaction types Sales, Refunds and Exchanges. The report results in Invoice #, type of travel, Passenger Name, Issue Date, Ticket # / Confirmation #, Total Paid, from Date, to Date, cities, vendor. Subtotaled by Invoice #. Grand Total is provided.
1202	Lost Savings Summary By Reason Low Fare	Lost Savings Summary By Reason code with Low Fare. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results in Reason Code, Reason Description, Transactions, Fare Paid, Low Fare, Lost Savings. Grand Total Provided. Total Paid > Low Fare; Transactions = Net Transactions (Sales (1), Refunds (-1), Exchanges (0); Lost Savings = Low Fare - Fare Paid.
1211	Traveler Activity By Invoice By Sort 2	Traveler Activity Detail Sorted by Invoice and by Sort 2. Transaction types Sales, Refunds and Exchanges. Vouchers excluded. The report results in Invoice #, Sort 2, type of travel, Passenger Name, Issue Date, Ticket # / Confirmation #, Total Paid, from Date, to Date, cities, vendor. Subtotaled by Invoice #. Grand Total is provided.
1213	Global Air Activity By Invoice With Sort 1	Global Air Activity Sorted By Invoice includes Sort 1. This report includes Air, Rail and Service Fees. Transaction types include Sales, Refunds and Exchanges. Voids and Vouchers Excluded. Report results include Passenger Name, Issue Date, Depart Date, Return Date, Airline, Itinerary, Invoice #, Ticket #, Original Ticket # and Fare Paid $. Grand Total provided. Start Date = Depart Date; End Date = Return Date; Total Paid = Fare Paid. Itinerary by Code only.
1214	Global Market Pair Report	Global Market Pair Report sorted by # of Ticketed Trips. This report includes Air ONLY. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. The report results in Market Pair, Ticketed Trips, % of Trips Ticketed Volume, % of Volume. Grand Total Provided. Ticketed Trips = Net Transactions = Sales (1), Refunds (-1), Exchanges (0); Depart city and Arrive City not Blank; Valid Segments Only; City Pair Fare > $ 0; Trip are counted as one ways not counting connections.
1217	Top 10 Traveler Exception	Top 10 Traveler Exception. This report includes Air and Rail. Transaction Types Sales, Refunds, and Exchanges. Vouchers Excluded. Report results in Rank, Traveler Name, Count, % of Count, Lost Volume % of Lost Volume. Subtotaled for top 10 Travelers. Subtotaled for Travelers Not listed. Grand Total Provided. Total Paid
1218	Arrival Manifest With Sort 1234	Arrival Manifest With Sort 1, Sort 2, Sort 3 and Sort 4. EXCEL DATA ONLY. This report includes Air and Rail. Transaction type Sales and Exchanges. Vouchers Excluded. Report results in Company Name, Booked Date, Start Date, End Date, Traveler Name, Departure City Code, Departure City Name, Departure State, Departure Country, Departure Date, Departure Time, Departure Airline, Departure Flight, Arrival City Code, Arrival City Name, Arrival State, Arrival Country, Arrival Date, Arrival Time, Sort 1, Connection Code, Origin City Code, Origin City Name, Destination City Code, Destination City Name, Sort 2, Sort 3, Sort 4, Record Locator. This report uses Master City Table. Does not includes reissued tickets.
1239	Car Commission Detail	Car Commission Detail. This report includes Car ONLY. Vouchers Excluded. Report results in Traveler Name, Invoice #, Car Rental Company, Rental City, Issue Date, Check In Date, # of Days, Rate, Total Paid, Commission. Start Date = Check In Date.
1243	Global Hotel Detail By City - TravCOM	Global Hotel Detail Report Sorted by City TravCom. This report is Hotels ONLY. Vouchers excluded. The report results City - Traveler, Hotel property, Hotel City, Invoice #, Issue Date, Check-in, Check-out, Confirmation #, # of Nights, Rate, Total Paid Original Amount, Total Paid Default Amount. Report Subtotaled by property cities. Grand Total provided.
1244	Global Car Detail By Vendor - TravCOM	Global Car Detail Sorted by Vendor TravCom. This report includes Car ONLY. Vouchers excluded. The report results include Car Company - Traveler Name, City, Invoice #, Issue Date, Pick Up Date, Drop Off Date, Confirmation #, Car Type, # of days, Rate, Total Paid Original Amount, Total Paid Default Amount. The report Subtotals by Passenger Name. Grand Total provided. Start Date = Pick Up Date; End Date = Drop Off Date; document # = Confirmation #, duration * # of units = # of days.
1245	Global Car Detail By City - TravCOM	Global Car Detail Sorted by City TravCom. This report includes Car ONLY. Vouchers excluded. The report results include City - Traveler Name, Vendor Name, Invoice #, Issue Date, Pick Up Date, Drop Off Date, Confirmation #,, Car Type, # of days, Rate, Total Paid Original Amount, Total Paid Default Amount. The report Subtotals by City. Grand Total provided. Start Date = Pick Up Date; End Date = Drop Off Date; document # = Confirmation #, duration * # of units = # of days.
1253	Top 10 Destinations	Top 10 Destinations. This report includes Air, Rail, Car and Hotel. Transaction types Sales, Refunds, Exchanges. Voucher Excluded. Report results in Destination Country by Rank, Current Period (# of Trips, % of Trip, Volume Booked, % of Booked, Average Cost per Trip) and Year to Date (# of Trips, % of Trip, Volume Booked, % of Booked, Average Cost per Trip). Subtotaled by Top 10 Countries. Subtotal for Countries not listed. Grand Total provided. Destination city code not Blank; Average Cost per Trip = Net Volume / Net Trips (Sales (1), Refunds (-1), Exchanges (1))
1256	Ticket and Segment Export With Sort1 Data Only	Ticket and Segment Export With Sort 1. EXCEL DATA ONLY. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results in Company ID, Company Name, Sort 1, Issue Date, Invoice #, Record Locator, Ticket #, Last Name, First Name, Booking ID, Payment #, From City Code, From City Name, To City Code, To City Name, Depart Date, Airline Code, Flight #, Ticket Designator, Class, Segment Fare, Service Fee, Exchange (T/F), Original Ticket #. Document # = Ticket #; Leg # = Segment #; Original Document # = Original Ticket #.
1257	Grasp Data - Data QC Report	Grasp Data - Data QC Report. EXCEL DATA ONLY. Report multiple tab Excel Spreadsheet - Missing Airports, Missing Reason Codes, Possible Bad Travel Types, Hotel Chain Codes, Airline Class Code, Grasp Data Look up, Missing Tour codes.
1263	New Travel Management Summary Rollover Month	New Travel Management Summary with Roll over Months. This report includes Air, Rail, Car and Hotel. Transaction types Sales, Refunds and Exchanges, Vouchers excluded. Air/Rail Sales and Net Transactions broken into Domestic and International. Grand Totals Include Air Volume, # of Invoices, Average Sales Amount; Savings: Full Fare Volume, Low Fare Volume, Savings, Missed Savings. Refunds: Refund Volume, # of Refunds, Average Refund Amount, Exchanges: Exchanges Volume, # of Exchanges, Average Exchange Amount. Hotel includes # of Rooms Booked, Hotel Cost, # of Nights, Averages. Car includes # of Cars Booked, Car Rental Cost, # of Cars and Averages. Grand Total NOT provided on this report. Calculation Information: Issue date = Issued Month; Total Paid = Volume; Invoice # used for Invoice Count; Coach Fare = High Fare; Savings = Total Paid - High Fare; Missed Savings = Total Paid - Low Fare.
1271	Exchange TKT Cost with Serv Fees Including Sales	Exchange Ticket Cost Report Sorted with Service Fees - Sorted by Passenger Name. This report includes Air. Transaction types include Sales and Exchanges ONLY. Vouchers excluded. Report results include Passenger Name , Ticket #, Passenger Name , Issue Date, Depart Date, Return Date, Airline Code, Itinerary, Record Locator, Invoice #, Ticket #, Original Ticket #, Service Fees, and Total Cost.
1274	Air Detail Report By Passenger Name With Regions	Air Detail By Passenger Name With Regions. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. The report results in Issue Date, Airline Code, Ticket #, Passenger Name , Destination Airport, Origin Airport, Amount, Destination Region, Origin Region, Booked. Grand Total Provided. Total Paid = Amount.
1296	Global Air Activity Simple	Global Air Activity Simple Sorted by Issue Date then Passenger Name. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers Excluded. Report results are Passenger Name, Issue Date, Depart Date, Return Date, Airline, Itinerary, Invoice #, Ticket #, Original Ticket #, Total $. Grand Total provided. Start Date = Depart Date; End Date = Return Date; Original Document = Exchange Ticket; Total Paid = Fare Paid
1297	Global Top 25 Travelers by Volume	Global Top 25 Travelers Sorted by Volume. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results in Traveler name, Gross Fare Paid, % of Total Gross Fare Paid, Average Ticket price, # of Transactions, % of Total Transactions. Grand Total included.
1298	Global Air Spend By Month Summary	Global Air Spend By Month Summary - Bar Graph with Chart. This report includes Air ONLY, Transaction types Sales, Refunds and Exchanges. Vouchers excluded. Chart includes Month, Net Transactions, % of Net Transactions, Net Volume, % of Net Volume and Grand Total. Net Transactions calculated by Sales = 1, Refunds = -1 and Exchanges = 0.
1299	Global Air Trans By Current Year And Previous Year	Global Air Trans By Current Year And Previous Year Month Summary. This report includes Air and Rail. Transaction type Sales, Refunds and Exchanges. The report results include Month, Net Tickets, % Transactions, Net Volume, Volume % for current and previous year. Includes Line Graph comparing current and previous year.
1316	Exchange Ticket Cost Report With Sort 1 - Current Period	Exchange Ticket Cost Report Sorted by Sort 1 and then Passenger Name. This report includes Air and Rail. Transaction types include Sales and Exchanges. Vouchers excluded. Report results include Sort 1 - Passenger Name , Issue Date, Depart Date, Return Date, Airline Code, Itinerary by City Code, Record Locator, Invoice #, Ticket #, Origin Ticket # and Total $. Subtotaled per Invoice #. Grand Total provided. Start Date = Depart Date; End Date = Return Date; Itinerary by City Code Only; Total = Total Paid.
1322	Fare Savings - Lost Savings Analysis By Sort 1	Fare Savings - Lost Savings Analysis By Sort 1. This report includes Air and Rail. Transaction types Sales ONLY. Vouchers Excluded. The report results in Sort 1 - Passenger Name, Issue Date, Invoice #, Depart Date, Origin City Name and Code, Destination City Name and Code, Airline Code, Full Fare, Low Fare, Fare Paid, Savings, Loss, Reason Code. Subtotaled by Sort 1, Grand Total Provided. Total Paid = Fare Paid; Coach Fare = Full Fare; Savings = Full Fare - Fare Paid; Lost = Fare Paid - Low Fare.
1323	Savings - Lost Savings Detail with HF LF	Fare Savings - Lost Savings Detail with High Fare and Low Fare . This report includes Air and Rail. Transaction types Sales ONLY. Vouchers Excluded. The report results in Reason Code - Passenger Name , Issue Date, Invoice #, Depart Date, Return Date, Airline Code, Itinerary by City Code, Ticket #, Full Fare, Low Fare, Fare Paid, Savings, Loss. Subtotaled by Reason Code, Grand Total Provided. Total Paid = Fare Paid; Coach Fare = Full Fare; Savings = Full Fare - Fare Paid; Lost = Fare Paid - Low Fare.
1324	Savings - Lost Savings Summary HF LF	Fare Savings - Lost Savings Summary with High Fare and Low Fare . This report includes Air and Rail. Transaction types Sales ONLY. Vouchers Excluded. The report results in Reason Code, Transactions,, Fare Paid, Savings, % of Savings, Loss, % of Lost, Net Savings. Grand Total Provided. Total Paid = Fare Paid; Coach Fare = Full Fare; Savings = Full Fare - Fare Paid; Lost = Fare Paid - Low Fare.
1325	Travel Management Summary HF LF	Travel Management Summary High Fare and Low Fare. This report includes Air, Rail, Car and Hotel. Transaction types Sales, Refunds and Exchanges, Vouchers excluded. Air/Rail Sales and Net Transactions broken into Domestic and International. Grand Totals Include Air Volume, Refund Volume, # of Invoices, # of Refunds, Full Fare, Low Fare, Savings, Missed Savings, Exchanges. Hotel includes # of Rooms Booked, Hotel Cost, # of Nights, Averages. Car includes # of Cars Booked, Car Rental Cost, # of Cars and Averages. Grand Total NOT provided on this report. Calculation Information: Issue date = Issued Month; Total Paid = Volume; Invoice # used for Invoice Count; Coach Fare = High Fare; Savings = Total Paid - High Fare; Missed Savings = Total Paid - Low Fare.
1326	Air Detail With Sort 1 HF LF	Air Detail With Sort 1, High Fare and Low Fare. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. The report results in Passenger Name - Invoice #, Sort 1, Depart Date, Origin City Name, Destination City Name, Airline Code, Flight #, Fare Basis, Full Fare, Low Fare, Fare Paid, Fare Savings, Lost Savings, Reason Code. Subtotaled by Passenger Name. Grand Total Provided. Total Paid = Amount.
1334	Grasp Invoice Report for Alphanumeric Invoice Numbers	Grasp Invoice Report for Alphanumeric Invoice Numbers.. Sorted by Date and then Invoice #. One invoice after another.
1340	Global Hotel Summary By Chain TravCOM	Global Hotel Summary Sorted By Chain (# of Nights in descending order) TravCOM Back Office. This report includes Hotels ONLY. Vouchers excluded. The reports results in Hotel Chain, # of Bookings, % of Bookings, # of Nights, % of # Nights, Average Rate, Total Paid, % of Total Paid. Grand Total provided at end of report. Formulas: Nights = Number Of Units; Total Paid = # of Nights * Rate; Average Rate = Total Paid / Number Of Units.
1342	Global Traveler Activity By Passenger Name TravCOM	Global Traveler Activity Sorted By Passenger Name then Travel type TravCom. Subtotaled by Travel type and Passenger Name. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results are Issue Date, Traveler, Invoice Date, Ticket # / Confirmation #, Amount, from Date, to Date, City Codes, Vendor Name and Grand Total. Start Date = From Date; End Date = To Date; Amount = Total Paid.
1343	Global Hotel Summary By Property - TravCOM	Global Hotel Summary Sorted By Property (# of Nights in descending order) TravCOM Back Office. This report includes Hotels ONLY. Vouchers excluded. The reports results in Hotel Property, Booking #, % of Booking #, # of Nights, % of # Nights, Average Rate, Total Paid, % of Total Paid. Formulas: Nights = dataBooking.Nights; Total Paid = # of Nights * Rate; Average Rate = Total Paid / Nights.
1344	Global Traveler Activity By Invoice - TravCOM	Global Traveler Activity by Invoice TravCOM. Transaction types Sales, Refunds and Exchanges. Vouchers excluded. The report results in Invoice #, type of travel, Issue Date, Traveler, Ticket # / Confirmation #, Total Paid, from Date, to Date, cities, vendor. The report is Subtotaled by Invoice number. Grand Total is provided.
1352	Travel Management Summary With Rollover Month - Dom/Int/Trans Shown	Travel Management Summary with Roll over Months Domestic / International and Transborder Information. This report includes Air, Rail, Car and Hotel. Transaction types Sales, Refunds and Exchanges, Vouchers excluded. Air/Rail Sales and Net Transactions broken into Domestic and International and Transborder. Grand Totals Include Air Volume, # of Invoices, Average Amount; Grand Totals: Sales Volume, # of Sales, Average Sale Amount; Online: # of Tickets, Volume, % of Online; Savings: Low Fare, Missed Savings, Negotiated Savings; Refunds: Refund Volume, # of Refunds, Average Refund; Exchanges: Exchange Volume, # of Exchanges, Average Exchange; Hotel includes # of Rooms Booked, Hotel Cost, # of Nights, Averages. Car includes # of Cars Booked, Car Rental Cost, # of Cars and Averages. Grand Total NOT provided on this report. Calculation Information: Issue date = Issued Month; Total Paid = Volume; Invoice # used for Invoice Count; Coach Fare = High Fare; Savings = Total Paid - High Fare; Missed Savings = Total Paid - Low Fare.
1360	Air Activity Simple With Service Fees and Sort1	Air Activity Simple Sorted by Issue Date then Passenger Name with Service Fees and Sort 1. This report includes Air and Rail. Transaction types include Sales, Refunds and Exchanges. Voids and Vouchers Excluded. Report results are Passenger Name , Invoice #, Ticket #, Total Cost, Vendor Name Invoice Date, Depart Date, Itinerary by City Code, Sort 1. Grand Total provided. Start Date = Depart Date; End Date = Return Date; Total Paid = Fare Paid; Itinerary by Code only.
1361	Agent Monthly Comparison Current Year to Previous Year	Agent Monthly Comparison Current Month over Previous Month. This report includes all travel types. Transaction types include all except Vouchers. Document type voucher excluded. This report is Sorted by inside and outside agent. The report results in Agent name, Current Month Sales, Previous Year Month Sales, % of Sales, Commissions. Grand Total provided on report. Calculations: Current Month Sales / Previous Year Month Sales
1362	Air Activity Detail With Fees (GDS)	Air Activity with Service Fees (GDS) Sorted By Issue Date and then Passenger Name. This report includes Air, Rail and Service Fees. Transaction types include Sales, Refunds and Exchanges. Voids and Vouchers Excluded. Report results include Passenger Name, Issue Date, Depart Date, Return Date, Airline code, Itinerary (City Codes), Invoice #, Ticket #, Original Ticket # and Air Fare, Fees, Total Paid. Grand Total provided. Start Date = Depart Date; End Date = Return Date; Total Paid = Fare Paid. Itinerary by Code only.
1367	Mini Itinerary Report (GDS)	Mini Itinerary Report (GDS). This report includes Air and Rail. Transaction types includes Sales and Exchanges. Report results in Depart Date, Depart City Name and State, Arrival City Name and State, Airline, Flight #, Depart Time, Arrival Time, Arrival Date.
1370	Departure Manifest (GDS)	Departure Manifest (GDS). This report includes Air and Rail. Transactions types include Sales and Exchanges. Report results in Depart City Name and Code, Depart Date, Passenger Name , From Airport, Arriving Into Airport. Airline Name, flight #, Depart Time, Record Locator.
1371	Arrival Manifest (GDS)	Arrival Manifest (GDS). This report includes Air and Rail. Transactions types include Sales and Exchanges. Report results in Depart City Name and Code, Depart Date, Passenger Name , From Airport, Arriving Into Airport. Airline Name, flight #, Depart Time, Record Locator.
1392	Grasp Data Only Summary Detail	Grasp Summary Detail EXCEL DATA ONLY. This report includes Air and Rail. Vouchers and Voids Excluded. The report results in Booking Date, Indicator, Departure Date, Passenger Name, Carrier, Fare Type , Class, Itinerary in City Code, Ticket Price, Base Fare, High Price, Low Price, Total Tax, Ticket # Transaction Fee, Advance Days, Booking ID. Start Date = Depart Date; Vender Name = Carrier Name; Total Paid = Ticket Price Coach Fare = High Fare; Document # = Ticket #.
1394	Air Detail By Passenger Name With Class - International Travel	Air Detail By Passenger Name With Class - International Travel ONLY. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. The report results in Passenger Name - Issue Date, Invoice #, Ticket #,Travel Authorization, Airline Code, Class of Service, From City Name, To City Name, Amount. Grand Total Provided. Total Paid = Amount.
1395	Credit card Reconciliation - Standard	Credit Card Reconciliation - Standard (THIS REPORT FOR CC REC CLIENTS ONLY)
1406	Car Detail by Class Category With Sort1	Car Detail Sorted by Class category includes Sort 1. This report includes Car ONLY. Vouchers excluded. The report results include Class category, Traveler, Car Company, Car City, Invoice #, Issue Date, Pick Up Date, Drop Off Date, Confirmation #, Sort 1 , # of days, Rate, Total $. Subtotaled by Class Category. Grand Totals Provided. Start Date = Pick Up Date; End Date = Drop Off Date; document # = Confirmation #.
1407	Hotel Detail by Rate With Sort1	Hotel Detail Report Sorted by Rate Category with Sort 1. This report is Hotels ONLY. Vouchers excluded. The report results Rate - Traveler, Hotel property, Hotel City, Invoice #, Issue Date, Check-in, Check-out, Confirmation #, Sort 1, # of Nights, Rate, Total Paid. Subtotaled by Rate categories. Grand Total provided.
1408	Advance Purchase Detail With Sort 1 - 7 Days or Less	Advance Purchase Detail with Sort 1 and sorted by 7 Days or Less. This report includes Air and Rail. Transactions type Sales ONLY. Vouchers Excluded. The report results in Passenger Name , Issue Date, Depart, Return, Airline Code, Itinerary, Fare Paid, Fare Offered, Savings/Loss. Subtotaled by # of Days Advance. Grand Total Provided. Start Date = Depart Date; End Date = Return Date; Itinerary by city Code; Fare Paid = Total Paid; Fare Offered = : Savings/Loss = .
1409	Global credit card Detail By Passenger Name With Sort1	Global Credit Card Detail By Passenger Name with Sort 1. This report includes Air, Rail and Service Fees. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. Report sorted by Credit Card # and Passenger Name and includes Sort 1, Vendor Name, Airline Code, Ticket #, Issue Date, Itinerary, Total Paid. Grand Total Provided.
1413	Exchange Ticket Cost Report with Service Fees	Exchange Ticket Cost Report Sorted by Passenger Name with Service Fee. This report includes Air and Rail. Transaction types include Exchanges only. Vouchers excluded. Report results Original Ticket # - Passenger Name , Issue Date, Depart Date, Return Date, Airline Code, Itinerary by Full City Names, Record Locator, Invoice #, Ticket #, Original Ticket #, Service Fee and Total. Subtotaled per Original Ticket #. Grand Total provided. Start Date = Depart Date End Date = Return Date Itinerary by City Code Only Total = Total Paid.
1426	Refund Detail Report	Refund Detail Report. This report includes Air and Rail. Transaction by Sales and Refunds. Vouchers Excluded. Report Results in Passenger Name , Issue Date, Depart Date, Return Date, Airline Code, Itinerary by City Code, Record Locator, Invoice #m Ticket #, Origin Ticket #, Total. Grand Total Provided. This report includes refunds for the time period specified as well as any related historical tickets prior to the selected date range. Total Paid = Fare Paid.
1429	Global Hotel Detail by Property - TravCOM	Global Hotel Detail Report Sorted by Property. TravCOM This report is Hotels ONLY. Vouchers excluded. The report results Traveler, Hotel property, Class, Hotel City, Invoice #, Issue Date, Check-in, Check-out, Confirmation #, # of Nights, Rate, Total Paid. Report Subtotaled by Hotel properties. Grand Total provided.
1431	Passenger Name Invoice Summary By Sort 1 and Sort 2 - without Service Fees	Passenger Name Invoice Summary By Sort 1 and Sort 2 - Without Service Fees. This report includes Air, Rail, Car and Hotel. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. This report results in Sort 1, Sort 2, Traveler Name, Issue Date, Invoice #, Arrive Date, City and State, Air Fare, Hotel Rate, Hotel Amount, Car Rate, Car Amount, Total Cost. Start Date = Arrive Date; Total Paid = Fare Amount / Amount.
1432	Fare Savings by Class and Airline	Fare Savings by Class and Airline - EXCEL DATA ONLY. This report incudes Air and Rail. Transaction type Sales, Refunds and Exchanges. Vouchers Excluded. Report results in Reason Code, Airline, Bookings, Full Fare, Fare Paid, Savings, Company. Savings = Full Fare - Fare Paid.
1460	Corporate Account Summary Compare Periods	Corporate Account Summary Compare Periods. This report includes Air and Service Fees. Transaction type Sales ONLY. Vouchers Excluded. The report results in three categories: Current Period, Previous Period, Current Year To Date. Fields on the report are Account Name, DK #, Sales, Commission, Fees, # of Transactions.
1471	Top 200 City Pair by Airline	Top 200 City Pair By Airline. This report includes Air ONLY. Transaction type Sales ONLY. Vouchers Excluded. Report results in City Pair, Airlines and Totals. Grand Total Provided. Trips = Net Transactions = Sales (1), Refunds (-1), Exchanges (0).
1473	Global Hotel Detail By City	Global Hotel Detail Report Sorted by City. This report is Hotels ONLY. Vouchers excluded. The report results City - Traveler, Hotel property, Hotel City, Invoice #, Issue Date, Check-in, Check-out, Confirmation #, # of Nights, Rate, Total Paid Original Amount, Total Paid Default Amount. Grand Total provided.
1476	Car Expense Summary	Car Expense Summary. This report includes Pie Chart of Top Five Car Chains Based on Expenses. This report includes Sales ONLY. Transaction types Car ONLY. The report results in Car Chain Name, # of Days, # of Cars, Average Daily Rate, Total Care Expenses. Grand Total Provided.
1482	Global Hotel Spend by Month Summary	Global Hotel Spend by Month Summary. This report includes bar chart by Month and Volume. This report includes Hotel ONLY. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Summary information includes Month, # of nights, % of Transactions, Net Volume, % of Volume. Grand Total Provided.
1483	Global Car Spend by Month Summary	Global Car Spend by Month Summary. This report includes bar chart by Month and Volume. This report includes Car ONLY. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Summary information includes Month, # of rentals, % of Transactions, Net Volume, % of Volume. Grand Total Provided.
1522	Travel Summary by Corporation	Travel Summary By Corporation. This report includes Air, Rail, Car, Hotel and Service Fees. Transaction types Sales, Refunds, and Exchanges. Vouchers Excluded. The report results in three Categories: Air, Hotel and Car. Fields = Rank, Corporation. Air: Trips Taken, Total Amount, Tip Days, Cost per Mile, Miles Traveled, Average Trips Cost. Hotel: Potential Nights, Actual Nights, Missed Booking %, Total Amount, Average Hotel Rate. Car: Total Days, Total Amount, Average Car Rate. Total for each Corporation and Grand Total Provided.
1525	Travel Summary By Corporation with Commission Transactions	Travel Summary By Corporation with Commission Transactions. This report includes Air, Rail, Car, Hotel and Service Fees. Transaction types Sales, Refunds, and Exchanges. Vouchers Excluded. The report results in three Categories: Air, Hotel and Car. Fields = Rank, Corporation. Transactions, Commission, Average Commission / Transaction. Total per Company and Grand Total provided.
1537	Global Advance Purchase Summary	Global Advance Purchase Summary. This report includes Air and Rail. Transaction types include Sales ONLY. Voids and Vouchers Excluded. Summary for Advance days 0 to 20 and over 20. Grand Total provided. Report results are # of days Advance, Ticket Total $, % of Total, Volume, % of Volume, Average Price. Advance = Start Date Less Issue Date when Start Date > Issue Date and Total Paid not equal to zero; Volume = Total Paid; Average Price = Volume/Tickets.
1538	Global Top 5 Executive Travel Summary	Global Top 5 Executive Travel Summary. This reports includes Air, Rail, Car and Hotel. Transaction type Sales ONLY. Vouchers excluded. Produces 4 Pie Charts - Expense Summary (Air, Car, Hotel), Top 5 Airlines, Top 5 Cars and Top 5 Hotels with table. Air table = # of Tickets, Total Paid, Average $. Car table = # of Bookings, # of days, Total Paid, Average per day. Hotel table = # of Bookings, # of Nights, Total Paid, Average per Night. Grand Totals Provided. Average Rate = Total Amount / # of Nights for Car and Hotel; Average Amount = Total Amount / # of Tickets (Airlines).
1539	Global Travel Spend by Category by Month Summary	Global Travel Spend by Category by Month Summary. This report includes bar chart by Month and Volume for Air, Car and Hotel. This report includes Air, Car and Hotel. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Summary information includes Month, Net Transactions, % of Transactions, Net Volume, % of Volume. Grand Total Provided.
1540	Advance Purchase Detail Report - Sort 2	Advance Purchase Detail Report By Sort 2. This report includes Air and Rail. Transactions type Sales ONLY. Vouchers Excluded. Header sorting by Sort 2; The report results in Passenger Name , Advance Purchase Booking Date, Depart Date, Airline Code, Itinerary by City Code, Fare Paid, and Potential Savings. Subtotaled by # of Days Advance. Grand Total Provided. Start Date = Depart Date; End Date = Return Date; Itinerary by city Code.
1541	Advance Purchase Detail Report - Less Than 14 Days	Advance Purchase Detail sorted by 14 Days or Less. This report includes Air and Rail. Transactions type Sales ONLY. Vouchers Excluded. The report results in Passenger Name , Advance Purchase Issue Date, Depart, Airline Code, Itinerary by City Code, Fare Paid, Savings Subtotaled by # of Days Advance. Grand Total Provided. Start Date = Depart Date; End Date = Return Date; Itinerary by city Code; Fare Paid = Total Paid; Fare Offered = : Savings/Loss = .
1547	Top 10 Destinations By Number of Travelers	Top 10 Destinations by Number of Travelers . This report includes Air and Rail. Transaction types Sales and Exchanges. Voucher Excluded. Reissued Tickets are not included in this report. Report results in Destination City by # of Travelers, Traveler Name, Start Date, Routing by City Code, End Date, Duration and Total Paid. Subtotaled by Cities.
1551	Travel Summary by Sort 2	Travel Summary By Sort 2 This report includes Air, rail, Car, Hotel, Service Fees. Transaction types include Sales, Refunds, Exchanges. Vouchers excluded. The report results in Three categories of data: Air: trips taken, Total trip days, cost/mile, miles, Average trip cost. Hotel: Potential Nights, actual Nights, missed Bookings, % missed Bookings, Total $, Average Hotel Rate. Car: Total days,
1558	Online Vs. Agent Travel Summary Report	Online vs. Agent Travel Summary Report. This report includes Air ONLY. Vouchers and Voids Excluded. This report include two pie charts - Current Period and Year to Date by %. The report results in Agent Assisted and Online Bookings - Volume, % of Volume, Transactions, % of Transactions for Current Period and Year to Date. Transactions = Sales (1), Refunds (-1), Exchanges (0).
1564	Insurance Report	Insurance Report Summary. This report includes Air and Rail. Transaction type Sales and Exchanges. Vouchers Excluded. The report results in Domestic/International/Transborder, Region, Country, Trips, Days, Travelers, Spend. Trips = # of Booking Id's; Days = Start Date - End Date; Travelers = Distinct Traveler Name; Spend = Total Paid.
1590	Global Car Detail by City	Global Car Detail Sorted by City. This report includes Car ONLY. Vouchers excluded. The report results include City - Traveler Name, Vendor Name, Invoice #, Issue Date, Pick Up Date, Drop Off Date, Confirmation #, Car Type, # of days, Rate, Total Paid Original Amount, Total Paid Default Amount. Grand Total provided. Start Date = Pick Up Date; End Date = Drop Off Date; document # = Confirmation #, duration * # of units = # of days.
1593	Global Savings Detail - Low Fare	Global Savings Detail Low Fare. This report includes Air, Rail and Service Fees and excludes Voids. Sort order is by Reason Code then Passenger Name. Report results are Reason Description, Passenger Name , Advance Purchase, Issue Date, Depart Date, Airline Code, Itinerary by City Code, Fare Paid, Low Fare, Savings. Subtotal per Reason Code. Grand Total Provided. Start Date = Depart Date; End Date = Return Date; Itinerary by Code Only; Coach Fare = Full Fare; Savings = Low Fare - Fare Paid.
1599	Executive Summary Report with Air Average	Executive Summary Report with Average Air This report includes Air, Rail, Car and Hotel. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. Reports on Current Month/ Previous Year Month and Current Year to Date/ Previous Year to Date. The report results in Air travel purchase, Hotel reservations, Car reservations broken down by domestic, international and transborder. Grand Total of all three at bottom of report. Total Ticket Volume = Sales Only; Total Volume Refunded = Refunds; Total Ticket Transactions = Net Transaction (Sales = 1; Refunds = -1; Exchanges = 0); Average #'s = Volume / # of Nights.
1601	Top Travelers Summary with Duration	Top Travelers Summary with Duration Sorted by # of Tickets. This report includes Air, Car, Hotel. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. Report results include Traveler name, # of Tickets, Air Duration, Air Ticket cost, Hotel Duration, Hotel cost, Car Duration, Car cost, Total expense per Traveler. Grand Totals Provided.
1611	Print My Invoice Usage Detail	Print My Invoice Usage Detail. This report shows usage from the Print My Invoice Product. Report results Invoice #, Date Invoice Queried, IP Address, Filter Used. Account Total.
1616	Advance Purchase Detail 14 Day with Sort 1 and Sort 2	Advance Purchase Detail with Sort 1 and Sort 2. This report includes Air and Rail. Transactions type Sales ONLY. Vouchers Excluded. The report results in Advance Purchase Days - Passenger Name , Sort 1, Sort 2, Issue Date, Depart Date, Return Date, Airline Code, Itinerary by City Code, Fare Paid. Subtotaled by # of Days Advance. Grand Total Provided. Start Date = Depart Date; End Date = Return Date; Itinerary by city Code.
1635	Agency User Activity Report	Agency User Activity Report. Report results in Client Name, User Access, User Name, Login Count, Last Login date and time; # of reports assigned to user; # of reports used by user; # of reports in history of user; Last report run date; # of batches.
1638	Travel Management Online Summary with Rollover Month	Travel Management Online Summary with Roll Over Months. This report includes Air, Rail, Car and Hotel. Transaction types Sales, Refunds and Exchanges, Vouchers excluded. Air/Rail Sales and Net Transactions broken into Domestic and International. Grand Totals Include Air Volume, # of Sales, Average Sale Amount; Online includes # of tickets booked Online, Volume Booked and % of Booked; Savings includes Low Fare, Savings, Missed Savings, Negotiated Savings; Refunds includes Refund Volume, # of Refunds, Average Refund; Exchanges includes Exchange Volume, # of Exchange and Average Amount; Hotel includes # of Rooms Booked, Hotel Cost, # of Nights, Averages. Car includes # of Cars Booked, Car Rental Cost, # of Cars and Averages. Grand Total NOT provided on this report. Calculation Information: Issue date = Issued Month; Total Paid = Volume; Invoice # used for Invoice Count; Coach Fare = High Fare; Savings = Total Paid - High Fare; Missed Savings = Total Paid - Low Fare.
1639	Online Adoption Report	Online Adoption Report. This report includes Air and Service Fee. Transaction types Sales, Refunds and Exchanges. Vouchers excluded. This report shows six months of data for Transactions and Volume for Domestic Tickets Issued by Agent, International Tickets Issued by Agent, Total Tickets Issued by Agent, Total Tickets issued Online, Companywide Adoption Rate, Fee Savings From Online, Potential Additional Savings w/ 100% Adoption Rate.
1642	Top 10 Destination Cities	Top 10 Destination Cities. This report includes Air, Rail, Car and Hotel. Transaction types Sales, Refunds, Exchanges. Vouchers Excluded. Report results in Destination Cities by Rank, Current Period (# of Trips, % of Trip, Volume Booked, % of Booked, Average Cost per Trip) and Year to Date (# of Trips, % of Trip, Volume Booked, % of Booked, Average Cost per Trip). Subtotaled by Top 10 Countries. Subtotal for Countries not listed. Grand Total provided. Destination city code not Blank; Average Cost per Trip = Net Volume / Net Trips (Sales (1), Refunds (-1), Exchanges (1))
1690	Global Traveler Activity by Invoice by Sort 1 with CC	Global Traveler Activity by Invoice and by Sort 1 with Credit Card. Transaction types Sales, Refunds and Exchanges. Vouchers excluded. The report results in Sort 1 - Invoice #, Credit Card #, Type of travel, Issue Date, Traveler Name, Ticket # / Confirmation #, Record Locator, Amount,, From Date, To Date, Cities by City Code, Vendor. The report is Subtotaled by Invoice number. Grand Total is provided.
1711	More Than 3 Passenger Names on a Plane	More Than 3 Passenger Names on a Plane. This report includes Air and Rail. Transaction types Sales and Exchanges. Vouchers Excluded. The report results in Account ID and Name - Departure Date and Time - Record Locator, Carrier Name, Flight #, Origin City Name and State, Destination City Name and State, Schedule, Traveler Name, Ticket # Class. Subtotal by Passenger Name Count.
1712	More Than 4 Passenger Names on a Plane	More Than 4 Passenger Names on a Plane. This report includes Air and Rail. Transaction types Sales and Exchanges. Vouchers Excluded. The report results in Account ID and Name - Departure Date and Time - Record Locator, Carrier Name, Flight #, Origin City Name and State, Destination City Name and State, Schedule, Traveler Name, Ticket # Class. Subtotal by Passenger Name Count.
1714	Top 100 Market Pairs with Miles with Class	Top 100 Market Pairs With Miles With Class. This report includes Air ONLY. Transaction types Sales Refunds and Exchanges. Vouchers Excluded. Report results in Market Pair, Airline, Class, Miles, Ticketed Trips, % of Trips, Ticketed Volume, Cost Per Mile, % of Total. Subtotaled by Market Pair. Grand Total Provided. Depart City Not Blank; Arrive City not blank; Trips - Net Transactions = Sales (1), Refunds (-1), Exchanges (0).
1727	Real Time Where Are My Travelers with Sort 1	Real Time Where Are My Travelers with Sort 1. This report shows by Traveler Name the active trips they are currently on based on the day the report was printed. Grey sections indicate portions of travel that have already been completed. There are no $ Information on this report. Report results in Sort 1 - Traveler Name, Invoice Date, Record Locator, Agent ID, Confirmation # / Ticket #, Check in Date, Vendor Name, Vendor Address, Vencor City and State, Vendor Phone, Check Out Date. Formulas: Start Date = Depart Date; End Date = Arrival Date; City Name and City Code provided; Airline Code Only.
1778	Top 10 Hotel Summary by Cities By Property	Top 10 Hotel Summary Sorted By Cities then by Property (# of Nights in descending order). Top 10 Hotel Cities Top 5 Properties per city plus Others. This report includes Hotels ONLY. Vouchers excluded. The reports results in Rank, Hotel Chain, Hotel Property Name, # of Bookings, % of Bookings, # of Nights, % of Nights, Total Cost, % of Total Cost, Average Room, Average Cost. Subtotaled by City. Grand Total provided. Hotel City and State checks existence in vendor Table first and then city table. Formulas: Nights = Number Of Units * Duration; Total Paid = # of Nights * Rate; Average Rate = Total Paid / Nights.
1800	Simple Arrival Depature Export with Remarks	Simple Arrival/Departure Export with Remarks. EXCEL DATA ONLY. This report includes Air and Rail. Transaction types Sales and Exchanges. Vouchers Excluded. Report Results in Traveler Name, Arrival Date, Arrival Airline Code, Arrive City Code, Arrival City Name, Depart Date, Departure Airline Code, Invoice Date, Total Paid, Client Remarks, Company Name. Reissued Tickets not included.
1824	Airline Contract Report - BA	Airline Contract Report - BA. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. Voids and Vouchers excluded. The report results in Market Pair, Ticketed Trips (All, BA, BA %), Segment Volume (All, BA, BA %). Grand Total provided. Calculations: BA % = BA/All.
1825	Airline Contract Report - LH	Airline Contract Report - LH. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. Voids and Vouchers excluded. The report results in Market Pair, Ticketed Trips (All, LH, LH %), Segment Volume (All, LH, LH %). Grand Total provided. Calculations: LH % = LH/All.
1826	Airline Contract Report - SV	Airline Contract Report - SV. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. Voids and Vouchers excluded. The report results in Market Pair, Ticketed Trips (All, SV, SV %), Segment Volume (All, SV, SV %). Grand Total provided. Calculations: SV % = SV/All.
1845	Airline Contract Report - US - Formatted	Airline Contract Report - US - EXCEL DATA ONLY. This report includes Air ONLY. Transaction types Sales, Refunds and Exchanges. Voids and Vouchers excluded. The report results in Market Pair, Total Segments, Total US Segments, Total Air Amount, Total US Amount.
1883	Year Over Year Sales by Month	Year Over Year Air Sales by Month includes two line charts. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Summary Sales and Transactions for Domestic, International and Total. Sales Compare Current Month to Prior Year Month and the % Difference. Transactions Current Month Compared to Prior Year Month and the % Difference. Line Chart # 1 Sales Analysis. Line Chart #2 Transaction Analysis.
1961	Tramada Hotel Detail	Tramada Hotel Detail Report Sorted by City. This report is Hotels ONLY. Vouchers excluded. The report results Hotel City - Traveler Name, Hotel Property, Booking #, Booked Date, Check-in, Check-out, Confirmation #, # of Nights, Rate, Total Paid (Original Amount). Report Subtotaled by property cities. Grand Total provided.
1962	Tramada Air Exchange Detail	Tramada Air Exchange Detail Report Sorted by Passenger Name . This report includes Air. Transaction types include Sales and Exchanges. Vouchers excluded. Report results include Passenger Name , Sort 1, Booked Date, Depart Date, Return Date, Airline Code, Itinerary by City Code, Booking #, Ticket #, Original Ticket # and Total Paid, Grand Total Provided.
1963	Tramada Exchange Ticket Cost	Tramada Exchange Ticket Cost Report Sorted by Passenger Name. This report includes Air and Rail. Transaction types include Sales and Exchanges. Report results include Passenger Name , Booked Date, Depart Date, Return Date, Airline Code, Itinerary by City Code, Record Locator, Booking #, Ticket #, Original Ticket # and Total Paid. Subtotaled per Invoice #. Grand Total provided.
1964	Tramada Savings Lost Savings LF	Tramada Savings Lost Savings LF. This report includes Air and Rail. Transaction type Sales ONLY. Vouchers Excluded. This report results in Reason Code, Transactions, % of Transactions, Fare Paid, % of Fare Paid, Savings, % of savings, Average.
1966	Tramada Savings Lost Savings HF	Tramada Savings Lost Savings LH. This report includes Air and Rail. Transaction type Sales ONLY. Vouchers Excluded. This report results in Reason Code, Transactions, % of Transactions, Fare Paid, % of Fare Paid, Savings, % of savings, Average.
1967	Tramada City Pair by Airline	Tramada City Pair By Airline. This report includes Air ONLY. Transaction type Sales ONLY. Report results in City Pair, Airlines and Totals. Grand Total Provided.
1968	Tramada Traveler Analysis	Tramada Traveler Analysis Sort By Passenger Name . This report includes Air, Car, Hotel and Service Fees. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Report results by Traveler Name, Trip Count, Air Amount, Fee Amount, Hotel Amount, Hotel Nights, Car Amount, Total Cost, Average Air Cost / Trip Average Hotel Night Expense, Average Cost / Trip, Trip Count, Average Cost / Trip, Total Cost. Grand Total Provided.
1969	Tramada Executive Summary	Tramada Executive Summary. This report includes Air, Car, Hotel and Service Fees. Transaction Types Sales, Refunds and Exchanges. Broken into Three categories: Total Spend, Airline and Car/Hotel. Total Spend: Split by Domestic and International. - Current Month to Previous Month with Variance. Fields include Booking Type, Spend $ and Number of Transactions. Grand Total provided. Bar Chart for Total Spend comparing Current Month to Previous Month. Airline: Top 3 Domestic and Top 3 International by Current Month compared to Previous Month with Variance. Fields include Airlines, Spend $, Average Total Price, Grand Total Provided. Two Pie Charts 0 Domestic and International Class Splits. Hotel/Car: Split by Domestic and International with Current Month Compared to Previous Month with Variance. Fields include # of Days / Nights, Spend $ Average Rental Rate/Average Daily Rate. Chart with Top 5 Cities, # of Nights, Spend $ and Average Rental Rate. Chart with Top 5 Properties, # of Days and Spend $. Chart with Top 3 Car Company's, # of Days, Spend $ and Average Daily Rate.
1970	Tramada Car Detail by City	Tramada Car Detail Sorted by City. This report includes Car ONLY. Transaction type Sales ONLY. Vouchers excluded. The report results include City - Traveler Name, Vendor Name, Booking #, Pick Up Date, Drop Off Date, Confirmation #,, Car Type, # of days, Rate, Total Paid Original Amount, Total Paid Default Amount. Grand Total provided. Start Date = Pick Up Date; End Date = Drop Off Date; document # = Confirmation #, duration * # of units = # of days.
2042	Global Top 10 Market Pair,	Global Top10 Market Pair with Graph, Sorted by # of Ticketed trips. This report includes Air ONLY. Transaction types include Sales and Exchanges. Vouchers excluded. The report results in Market Pair, Ticketed Trips, % of trips, Ticketed Volume, % of Volume. Calculations: Trips are counted as one ways not counting connections.
2043	Global Top 10 Hotel Analysis	Global Top 10 Hotel Analysis Pie Charts with tables. This report includes Hotels ONLY. Vouchers excluded. Report results are two pie charts - Net Booking and Net Volume. Summary report includes Hotel Property, Net Bookings, % of Net Bookings, Net Volume, % of Net Volume and Grand Total.
2044	Global Top Car Analysis	Global Top Car Analysis. This report includes Car ONLY. Vouchers excluded. Two Pie Charts - Net Bookings and Net Volume with chart - Car Company, Net Booking, % of Net Booking, Net Volume, % of Net Volume and Grand Total. Total Paid = Net Volume. Net is calculated by Sales = 1, Refunds = -1 and Exchanges = 0
2045	Global Hotel Summary By Top Metro Areas By Property	Global Hotel Summary By Top Metro Areas By Property This report includes Hotel ONLY. Vouchers excluded. The report results in Hotel property City/state, Hotel name, top 5 properties in metro area, # of Bookings each, % of Total books per City, # of Nights in City, % of Total Nights per City, Average Rate, Total Paid, % of Total Paid per City. Grand Totals of all properties per metro area included.
2046	Global Top 20 Hotel Cities	Global Top 20 Hotel Cities. This report includes Hotels ONLY. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. Total Paid > 0 ONLY. The report results in Hotel City, # of stays, # of Nights, % of Total Nights, Volume booked, % of Volume, Average booked Rate, Average Nights / stay, Average cost / stay, Average cost / night.
2047	Global Top 20 Car Cities	Global Top 20 Car Cities. This report includes Cars ONLY. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. Total Paid > 0 ONLY. The report results in Car Companies, # of rentals, # of Nights, % of Total, Volume booked, % of Volume, Average booked Rate, Average Nights / stay, Average cost / stay, Average cost / night.
8126	Advance Purchase Summary Graphic Round Trip	Advance Purchase Summary Graphic This report includes Air and Rail. Transaction types include Sales ONLY on Round Trip tickets. Vouchers excluded. The report results in Advance Purchase time, # of Tickets, % of Tickets, Volume, % if Volume, Average Price. Calculations for Transactions: Advance Purchase = Issue Date less Departure Date.
8170	Missing Data Hotel Chains	Missing Data Hotel Chains - this report identifies missing links from hotel Vendors from dataVendor to dataHotelChain
8553	Prime Numbers XML Export	Prime Numbers XML Export
9029	Batch Report Using CC Numbers	Batch Report Using CC Numbers
9325	Grasp QC - Class of Service Descriptions (Excel Only)	Report contains Airline Class Code, Class Airline, Class Description, Data SourceID, TimeStamp and Number of Segments. Use this report to modify the class descriptions (UNKN, Coach, First, Business etc.) seen on numerous reports. Only provide the changes required, save and send to Support@Grasptech.com to update the Class of Service.
9832	Top 10 Destination Cites By Volume	Top 10 Destination Cites By Volume
9834	Manual Import QC	Manual Import QC
9918	Grasp Data Quality Scorecard	Grasp Data Quality Scorecard
10259	Airline Contract Report - B6 - All	Airline Contract Report - ALL. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. Vouchers and Vouchers excluded. The report results in Market Pair, Ticketed Trips (All, B6, B6 %), Segment Volume (All, B6, B6 %). Grand Total provided. Calculations: B6 % = B6/All
10276	Grasp Core Where Are My Travelers (GDS)	Grasp Core Where Are My Travelers (GDS)
10297	Top 10 Destination Cities (YTD)	Top 10 Destination Cities (YTD)
11924	Grasp Detailed Itinerary Report	Grasp Detailed Itinerary Report
12132	Grasp Traveler Activity QC By Travel Type	Grasp Traveler Activity QC By Travel Type
12317	Savings-Lost Savings Detail By Sort 1 and Sort 2	Savings-Lost Savings Detail By Sort 1 and Sort 2
12476	Hotel Chain Master Table QC	Hotel Chain Master Table QC. Tab 1 - existing master hotel chain table. Tab 2 - existing hotel chain codes with NO chain name.
12661	Grasp Region Name Descriptions	Grasp Region Name Descriptions
12901	Global Year Over Year Top 10 Airline	Global Year Over Year Top 10 Airline
13315	Advanced TMC Hotel Contract Rate Variance	Hotel Contract Rate Variance - Rate Variance when Average Nightly Rate exceeds Negotiated Rate at preferred property. Black out dates excluded from detail. Excludes Refunds and Voids.
13383	Global Hotel Summary by Chain	Hotel Summary Sorted By Chain (# of Nights in descending order) This report includes Hotels ONLY. Vouchers excluded. The reports results in Hotel Chain, # of Bookings, % of Bookings, # of Nights, % of # Nights, Average Rate, Total Paid, % of Total Paid. Grand Total provided at end of report. Formulas: Nights = Number Of Units; Total Paid = # of Nights * Rate; Average Rate = Total Paid / Number Of Units.
13509	Advanced TMC Hotel Summary by Chain	Hotel Summary by Chain - Hotel bookings only. Graph shows Top 5 Hotel chains, based on number of nights. Excludes voids.
13510	Advanced TMC Top Property by Metro	Top Property by Metro - Hotel bookings only. Graph shows Top 10 Metro areas, based on number of nights. Excludes voids.
13511	Advanced TMC Top 10 Market Pair	Top 10 Market Pair - Air bookings only. Graph shows Top 10 Market Pairs, based on transaction count. Excludes voids.
13512	Advanced TMC Air Summary Year-Over-Year	Air Summary Year-Over-Year - Returns Airline Name, Transaction Count, Gross Volume, Tax, Total and Percent of Total for Current Period and same period for the Previous Year. Sales, Refunds and Exchanges only. Transaction counts are Sale = 1, Exchange = 0 and Refund = -1. Includes Grand Totals, excludes Voids.
14042	Advanced TMC Class of Service Summary	Class of Service Summary - Air bookings only. Returns breakdown of Service Classes, with subtotals. Excludes voids.
14064	Advanced TMC Top Traveler Summary	Top Traveler Summary - Returns breakdown of Top Travelers, with subtotals. Excludes voids.
14070	Advanced TMC Exception Code Detail	Exception Code Detail - Air and rail bookings only. Breakdown of Exception Code detail. Excludes voids.
14128	Advanced TMC Travel Management Summary	Travel Management Summary - Includes air, rail, hotel and car bookings. Breakdown of current + 12 months. Excludes voids.
14137	Advanced TMC Air Contract Summary	Air Contract Summary - Includes air bookings. Comparison of Preferred (contract) vs. Non-Preferred (non-contract) airlines. Excludes voids.
14142	Advanced TMC Hotel Contract Summary	Hotel Contract Summary - Includes hotel bookings. Comparison of Preferred (contract) vs. Non-Preferred (non-contract) hotel chains. Excludes voids.
14143	Advanced TMC Car Contract Summary	Car Contract Summary - Includes car bookings. Comparison of Preferred (contract) vs. Non-Preferred (non-contract) car vendors. Excludes voids.
14145	Advanced TMC ATP Summary	ATP Summary - Includes air bookings. Comparison of Preferred (contract) vs. Non-Preferred (non-contract) airlines. Excludes voids.
14148	Advanced TMC Advance Purchase Summary	Advance Purchase Summary - Breakdown of Advance Purchase summary information. Transaction type = Sales Only Booking Type = Air Report is grouped by Domestic/International. Sections grouped show the following: # of Bookings, % of Total Bookings, Total Paid, ATP (Average Total Price).
14155	Advanced TMC Where Are My Travelers	Where Are My Travelers - Includes air, rail, hotel and car. Details of all current travelers. Excludes voids.
14396	Advanced TMC Advance Purchase Detail	Advance Purchase Detail - Transaction type = Sales Only Booking Type = Air Report is grouped by Domestic/International. Sections grouped show total count and total fare. Fields included in the detail are: Traveler Name, issued date, Invoice #, PNR, Depart Date, Return Date, Origin, Destination, Airline Name, Ticket #, Total Paid.
14406	Advanced TMC Car Summary by Company	Car Summary by Company - Graph and details for Top 5 Car Rental companies. Excludes voids.
14422	Advanced TMC Car Summary by Company and Car Type	Car Summary by Company and Car Type - Graph and details for Top 5 Car Rental companies, and car types. Excludes voids.
14519	Advanced TMC Hotel Summary by Parent Brand	Hotel Summary by Parent Brand - Hotel bookings only. Graph of Top 5 Hotel Brands, based on number of nights. Excludes voids.
14521	Advanced TMC More Than 3 Passengers On A Plane	More Than 3 Passengers On A Plane - Detail listing of passengers, and related travel data. Includes Air and Rail. Excludes Refunds and Voids.
17719	Agent Detail with Summary	Agent Detail with Summary - shows sale,exchanges and refunds only.
17929	Advanced TMC ATP 2	ATP 2 - Graphs detailing Advance Ticket Purchase and Average Ticket Price. Includes air bookings. Excludes voids.
17942	Advanced TMC One Page Summary	One Page Summary - Excludes Voids and Service Fees. Savings is based on low fare and lost savings is based on high fare. Total Ticket Volume is calculated based on Sales and Exchanges only. Net Ticket Volume is Sales + Exchanges - Refunds.
17953	Advanced TMC Spend Analysis	Spend Analysis - Spend Analysis
18007	Advanced TMC Business Review	Business Review - Business Review
18038	Advanced TMC Executive Summary	Executive Summary - Executive Summary
18400	Advanced TMC Exchange Ticket Cost Report	Exchange Ticket Cost Report - Includes exchanges for the time period specified as well as any related historical tickets prior to the selected date range.
18401	Advanced TMC Exchange Ticket Report by Sort1	Exchange Ticket Report by Sort1 - Includes Air and Rail. Sort order is by Passenger then Original Ticket Group. Excludes voids.
18403	Advanced TMC Exchange Detail Report	Exchange Detail Report - Includes Air, Rail. Sort order is by Issued Date then Passenger. Excludes voids.
19427	Transaction Summary By Account	This report is sorted by account and returns total volume and transactions, categorized by Sales, Exchanges, Refunds and Voids, with percentages of each against the account total.
19518	Carrier Concentration Report	This report returns Market Pairs and City Pairs, with a breakdown of each carriers share for the time range chosen.
19896	Grasp Interactive Arrival Departure Report	IMPORTANT: This is an interactive report. Once opened, click ENABLE CONTENT if prompted. This report will run using the On The Road date field type for the HOTEL and CAR tabs. The AIR tabs will use the Date Filter that you choose. Data filters are NOT passed to the report. The report is designed to return ALL flights within the date range chosen. Once the report is opened, the filters on each page should be used to narrow down the results. Transaction types = Sales and Exchanges. Booking types = Air, Rail, Hotel and Car.
20564	Advanced TMC One Page Summary with Transborder	One Page Summary - Excludes Voids and Service Fees. Savings is based on low fare and lost savings is based on high fare. Total Ticket Volume is calculated based on Sales and Exchanges only. Net Ticket Volume is Sales + Exchanges - Refunds.
20888	Advanced TMC Travel Mgmt Summary w/Transborder	Travel Management Summary - Includes air, rail, hotel and car bookings. Breakdown of current + 12 months. Excludes voids.
20889	Advanced TMC ATP Summary w/Transborder	ATP Summary - Includes air bookings. Comparison of Preferred (contract) vs. Non-Preferred (non-contract) airlines. Excludes voids.
20890	Advanced TMC Adv Purch Summary w/Transborder	Advance Purchase Summary - Breakdown of Advance Purchase summary information. Transaction type = Sales Only Booking Type = Air Report is grouped by Domestic/International/Transborder. Sections grouped show the following: # of Bookings, % of Total Bookings, Total Paid, ATP (Average Total Price).
20891	Advanced TMC Adv Purch Detail w/Transborder	Advance Purchase Detail - Transaction type = Sales Only Booking Type = Air Report is grouped by Domestic/International/Transborder. Sections grouped show total count and total fare. Fields included in the detail are: Traveler Name, issued date, Invoice #, PNR, Depart Date, Return Date, Origin, Destination, Airline Name, Ticket #, Total Paid.
20892	Advanced TMC ATP 2 w/Transborder	ATP 2 - Graphs detailing Advance Ticket Purchase and Average Ticket Price. Includes air bookings. Excludes voids.
20983	Real Time Where Are My Travelers With REFUNDS	Real Time Where Are My Travelers With REFUNDS. This report shows by Traveler Name and includes Sales, Exchanges and Refunds. The Refunded segments are marked in red on the report and will include the word REFUND in bold. Grey sections indicate portions of travel that have already been completed. There are no $ Information on this report. Report results in Traveler Name, Invoice Date, Record Locator, Agent ID, Confirmation # / Ticket #, Check in Date, Vendor Name, Vendor Address, Vencor City and State, Vendor Phone, Check Out Date. Formulas: Start Date = Depart Date; End Date = Arrival Date; City Name and City Code provided; Airline Code Only.
21072	Business Review With Transborder	Business Review With Transborder
21179	Advanced TMC Global Business Review	Business Review - Business Review
21180	Advanced TMC Global Spend Analysis	Spend Analysis - Spend Analysis
21181	Advanced TMC Global Hotel Contract Rate Variance	Hotel Contract Rate Variance - Rate Variance when Average Nightly Rate exceeds Negotiated Rate at preferred property. Black out dates excluded from detail. Excludes Refunds and Voids.
21182	Advanced TMC Global Hotel Summary by Chain	Hotel Summary by Chain - Hotel bookings only. Graph shows Top 5 Hotel chains, based on number of nights. Excludes voids.
21183	Advanced TMC Global Top Property by Metro	Top Property by Metro - Hotel bookings only. Graph shows Top 10 Metro areas, based on number of nights. Excludes voids.
21184	Advanced TMC Global Top 10 Market Pair	Top 10 Market Pair - Air bookings only. Graph shows Top 10 Market Pairs, based on transaction count. Excludes voids.
21185	Advanced TMC Global Air Summary Year-Over-Year	Air Summary Year-Over-Year - Returns Airline Name, Transaction Count, Gross Volume, Tax, Total and Percent of Total for Current Period and same period for the Previous Year. Sales, Refunds and Exchanges only. Transaction counts are Sale = 1, Exchange = 0 and Refund = -1. Includes Grand Totals, excludes Voids.
21186	Advanced TMC Global Class of Service Summary	Class of Service Summary - Hotel bookings only. Returns breakdown of Service Classes, with subtotals. Excludes voids.
21187	Advanced TMC Global Top Traveler Summary	Top Traveler Summary - Returns breakdown of Top Travelers, with subtotals. Excludes voids.
21188	Advanced TMC Global Exception Code Detail	Exception Code Detail - Air and rail bookings only. Breakdown of Exception Code detail. Excludes voids.
21189	Advanced TMC Global Travel Management Summary	Travel Management Summary - Includes air, rail, hotel and car bookings. Breakdown of current + 12 months. Excludes voids.
21190	Advanced TMC Global Air Contract Summary	Air Contract Summary - Includes air bookings. Comparison of Preferred (contract) vs. Non-Preferred (non-contract) airlines. Excludes voids.
21191	Advanced TMC Global Hotel Contract Summary	Hotel Contract Summary - Includes hotel bookings. Comparison of Preferred (contract) vs. Non-Preferred (non-contract) hotel chains. Excludes voids.
21192	Advanced TMC Global Car Contract Summary	Car Contract Summary - Includes car bookings. Comparison of Preferred (contract) vs. Non-Preferred (non-contract) car vendors. Excludes voids.
21193	Advanced TMC Global ATP Summary	ATP Summary - Includes air bookings. Comparison of Preferred (contract) vs. Non-Preferred (non-contract) airlines. Excludes voids.
21194	Advanced TMC Global Advance Purchase Summary	Advance Purchase Summary - Breakdown of Advance Purchase summary information. Transaction type = Sales Only Booking Type = Air Report is grouped by Domestic/International. Sections grouped show the following: # of Bookings, % of Total Bookings, Total Paid, ATP (Average Total Price).
21195	Advanced TMC Global Where Are My Travelers	Where Are My Travelers - Includes air, rail, hotel and car. Details of all current travelers. Excludes voids.
21196	Advanced TMC Global Advance Purchase Detail	Advance Purchase Detail - Global does not use currency symbols. Transaction type = Sales Only Booking Type = Air Report is grouped by Domestic/International. Sections grouped show total count and total fare. Fields included in the detail are: Traveler Name, issued date, Invoice #, PNR, Depart Date, Return Date, Origin, Destination, Airline Name, Ticket #, Total Paid.
21197	Advanced TMC Global Car Summary by Company	Car Summary by Company - Graph and details for Top 5 Car Rental companies. Excludes voids.
21198	Advanced TMC Global Car Summary by Company and Type	Car Summary by Company and Car Type - Graph and details for Top 5 Car Rental companies, and car types. Excludes voids.
21199	Advanced TMC Global Hotel Summary by Parent Brand	Hotel Summary by Parent Brand - Hotel bookings only. Graph of Top 5 Hotel Brands, based on number of nights. Excludes voids.
21200	Advanced TMC Global More Than 3 Passengers On A Plane	More Than 3 Passengers On A Plane - Detail listing of passengers, and related travel data. Includes Air and Rail. Excludes Refunds and Voids.
21201	Advanced TMC Global ATP 2	ATP 2 - Graphs detailing Advance Ticket Purchase and Average Ticket Price. Includes air bookings. Excludes voids.
21202	Advanced TMC Global One Page Summary	One Page Summary - Excludes Voids and Service Fees. Savings is based on low fare and lost savings is based on high fare. Total Ticket Volume is calculated based on Sales and Exchanges only. Net Ticket Volume is Sales + Exchanges - Refunds.
21203	Advanced TMC Global Exchange Ticket Cost Report	Exchange Ticket Cost Report - Includes exchanges for the time period specified as well as any related historical tickets prior to the selected date range.
21204	Advanced TMC Global Exchange Ticket Report by Sort1	Exchange Ticket Report by Sort1 - Includes Air and Rail. Sort order is by Passenger then Original Ticket Group. Excludes voids.
21205	Advanced TMC Global Exchange Detail Report	Exchange Detail Report - Includes Air, Rail. Sort order is by Issued Date then Passenger. Excludes voids.
21206	Advanced TMC Global One Page Summary with Transborder	One Page Summary - Excludes Voids and Service Fees. Savings is based on low fare and lost savings is based on high fare. Total Ticket Volume is calculated based on Sales and Exchanges only. Net Ticket Volume is Sales + Exchanges - Refunds.
21207	Advanced TMC Global Travel Mgmt Summary w/Transborder	Travel Management Summary - Includes air, rail, hotel and car bookings. Breakdown of current + 12 months. Excludes voids.
21208	Advanced TMC Global ATP Summary w/Transborder	ATP Summary - Includes air bookings. Comparison of Preferred (contract) vs. Non-Preferred (non-contract) airlines. Excludes voids.
21209	Advanced TMC Global Adv Purch Summary w/Transborder	Advance Purchase Summary - Global does not use currency symbols. Breakdown of Advance Purchase summary information. Transaction type = Sales Only Booking Type = Air Report is grouped by Domestic/International/Transborder. Sections grouped show the following: # of Bookings, % of Total Bookings, Total Paid, ATP (Average Total Price).
21210	Advanced TMC Global Adv Purch Detail w/Transborder	Advance Purchase Detail - Global does not use currency symbols. Transaction type = Sales Only Booking Type = Air Report is grouped by Domestic/International/Transborder. Sections grouped show total count and total fare. Fields included in the detail are: Traveler Name, issued date, Invoice #, PNR, Depart Date, Return Date, Origin, Destination, Airline Name, Ticket #, Total Paid.
21211	Advanced TMC Global ATP 2 w/Transborder	ATP 2 - Graphs detailing Advance Ticket Purchase and Average Ticket Price. Includes air bookings. Excludes voids.
21238	Traveler Activity By Passenger With Sort 1-10	Traveler Activity By Passenger With Sort 1-10 - Transaction types Sales, Refunds and Exchanges. Vouchers excluded. The report results in Invoice #, type of travel, Issue Date, Traveler, Ticket # / Confirmation #, Total Paid, from Date, to Date, cities, vendor. The report is Subtotaled by Passenger . Grand Total is provided.
21239	Traveler Activity By Invoice With Sort 1-10	Traveler Activity By Invoice With Sort 1-10. Transaction types Sales, Refunds and Exchanges. Vouchers excluded. The report results in Invoice #, type of travel, Issue Date, Traveler, Ticket # / Confirmation #, Total Paid, from Date, to Date, cities, vendor. The report is Subtotaled by Invoice number. Grand Total is provided.
21240	Traveler Activity With Summary With Sort 1-10	Traveler Activity With Summary With Sort 1-10 - This report includes Air, Car and Hotel bookings. Transaction types Sales, Refunds and Exchanges. Vouchers excluded.
21241	Grasp Standard Detail Itinerary With Sort 1-10	Grasp Standard Detailed Itinerary Report, With Sort 1-10. Report is sorted by passenger and results in Actual Fare, Lowest Fare, Service Fee and Exception (if any). Validating Carrier, Ticket #, Record Locator, Invoice Number and Invoice Date also shown. Full itinerary is shown including detailed segment data.
21247	Where Are My Travelers With REFUNDS Sort 1-10	Where Are My Travelers With REFUNDS Sort 1-10. This report shows by Traveler Name and includes Sales, Exchanges and Refunds. The Refunded segments are marked in red on the report and will include the word REFUND in bold. Grey sections indicate portions of travel that have already been completed. There are no $ Information on this report. Report results in Traveler Name, Invoice Date, Record Locator, Agent ID, Confirmation # / Ticket #, Check in Date, Vendor Name, Vendor Address, Vencor City and State, Vendor Phone, Check Out Date. Formulas: Start Date = Depart Date; End Date = Arrival Date; City Name and City Code provided; Airline Code Only.
21557	Airline Contract Report - Master	Airline Contract Report - Master. This report includes Air ONLY. Transaction types include Sales, Refunds and Exchanges. MUST use filter tab to specify airline. Use Filter 1, select Vendor Name (Active) and airline from the dropdown. Only one airline can be selected at a time. Report uses City Pair data and excludes connections.
21812	Advanced TMC MoM Spend Summary	Report includes Sales, Refund and Exchanges. Results include total spend and transactions by month for Air, Rail, Car and Hotel, grouped by Travel Type. Average transaction cost and % of total month included. Report includes 2 graphs. The month with the highest spend in each category is show on the bottom.Report includes Sales, Refund and Exchanges. Results include total spend and transactions by month for Air, Rail, Car and Hotel, grouped by Travel Type. Average transaction cost and % of total month included. Report includes 2 graphs. The month with the highest spend in each category is show on the bottom.
21821	Grasp Report History By User	Report is Excel Data Only and includes User Name, Login, Role, Report ID, Report Name and Last Processed Date.
21972	Air CO2 Emission Report ICM	Air CO2 Emission Report ICM includes bar chart showing Monthly Emission. This report includes Air ONLY. Report is grouped by Market Pair. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Sorted by Total Co2. The report results in Market Pair, Transactions, Total Miles, CO2 (Lbs). Net Transaction = Transactions = Sales (1), Refunds (-1), Exchanges (0).
21973	Air CO2 Emission Report By Sort1 ICM	Air CO2 Emission Report By Sort 1 ICM, includes bar chart showing Monthly Emission. This report includes Air ONLY. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Sorted by Total CO2. The report results in Market Pair, Transactions, Total Miles, CO2 (Lbs). Net Transaction = Transactions = Sales (1), Refunds (-1), Exchanges (0).
21974	Grasp CO2 Emission Report With KM By Sort1 ICM	Grasp CO2 Emission Report with Kilometers by Sort 1 ICM includes bar chart showing Emission for Each Month of the year. This report includes Air ONLY. Transaction type Sales, Refunds and Exchanges. Vouchers Excluded. Report results in Market Pair, Transactions, Total Kilometers and CO2(Kgs) Grand Total Provided.
21975	Grasp CO2 Emission Report With Kilometers ICM	Grasp CO2 Emission Report with Kilometers ICM This report includes Air ONLY. Transaction type Sales, Refunds and Exchanges. Vouchers Excluded. Report results in Market Pair , Transactions, Total Kilometers and CO2(Kgs) Subtotal per Category. Grand Total Provided.
22215	Full Travel Detail ICM	Full Travel Detail ICM
22837	Executive Summary Year Over Year 2YB	Executive Summary - Current Year to Date compared to Year to Date 2 years back. This report includes Air, Rail, Car, Hotel and Service Fees. Transaction types include Sales, Refunds and Exchanges. Vouchers excluded. The report results in Air Spend , Estimated Car Spend, Estimated Hotel Sped and Estimated Total Spend. Report includes # of Tickets, # of invoices, # of Credits, Net # Same Day Round Trips / One Ways, Net # Overnight Trips Average Days Purchased in Advance, Average Ticket Price, Savings From Standard Fare, Negotiated Savings, Lost Savings, Total Miles, Average Miles per trip, Average Cost per Mile. Volume Issued = Sales Invoices Volume Refunded = Refund Invoices Net Volume = Sales - Refunds Net Savings = High Fare - (Sales + Refunds) Lost Savings = Low Fare - (Sales + Refunds).
22842	Year Over Year Air Sales By Month 2YB	This report uses the current date range, then the previous date range is 2 years back. For example, 2021 compared to 2019. Year Over Year Air Sales by Month includes two line charts. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Summary Sales and Transactions for Domestic, International and Total. Sales Compare Current Month to Prior Year Month and the % Difference. Transactions Current Month Compared to Prior Year Month and the % Difference. Line Chart # 1 Sales Analysis. Line Chart #2 Transaction Analysis.
22843	Graphic Executive Summary YOY 2YB	This report uses the current date range, then the previous date range is 2 years back. For example, 2021 compared to 2019. Graphic Executive Summary with Year Over Year. Graphs include sales only for Air and Rail transactions. Refunds, Exchanges and Voids are excluded. This report displays Air sales, Tickets issued, Average Ticket Price, Car Volume Booked, Car Days Booked, Car Average Booked Daily Rate, Hotel Volume Booked, Hotel Nights Booked, Hotel Average Booked Rate.
22846	Year Over Year Analysis By Account 2YB	This report uses the current date range, then the previous date range is 2 years back. For example, 2021 compared to 2019.
22847	Agent Year Over Year Analysis 2YB	This report uses the current date range, then the previous date range is 2 years back. For example, 2021 compared to 2019.
22848	Year Over Year Air Sales 2YB	This report uses the current date range, then the previous date range is 2 years back. For example, 2021 compared to 2019. Year Over Year Air Sales includes two bar charts. This report includes Air and Rail. Transaction types Sales, Refunds and Exchanges. Vouchers Excluded. Summary Sales and Transactions for Domestic, International and Total. Sales Compare Current Month to Prior Year Month and the % Difference. Transactions Current Month Compared to Prior Year Month and the % Difference. Bar Chart # 1 Sum of Sales Total. Bar Chart #2 Transaction Comparison.
22849	Air Tickets By Current Period And Previous Period 2YB	This report uses the current date range, then the previous date range is 2 years back. For example, 2021 compared to 2019. Air Tickets By Current Year And Previous Year Month Summary. This report includes Air and Rail. Transaction type Sales, Refunds and Exchanges. The report results include Month, Net Tickets (S=1,R=-1,X=1), % Transactions, Net Volume, Volume % for current and previous year. Includes Line Graph comparing current and previous year.
23000	Account Sales/Revenue Period Comparision 2YB	Account Sales/Revenue Period Comparison. This report Excludes Vouchers and Voids. Report Results in Four Categories: Current Period, Previous Period (2 years prior), Difference % of Difference. Sorted by Account Name. Report fields are Account Name, Booking Type, Total Sales, Revenue, and Transactions. Subtotaled by Account Name, Grand Total provided. Transactions = Net Transactions = Sales (1), Refunds (-1), Exchanges (0).