At JTB details of a trip are held in a 'folder' referred to by a 'booking number'. Each booking number has a single departure date, lead passenger and cost centre allocated to it (if you do not inform us of a cost centre this column will be blank). The departure date usually refers to the departure of the first flight, train etc. to which the booking refers. NOTE, the data are retrieved with reference to the date of the invoices in a booking. This is not the same as the departure date.
          Booking numbers are allocated automatically in a sequential manner. If a booking has a number of elements it is possible that some flights will depart long after the allocated 'departure date'.
          The lead passenger data are used in the creation of the passenger drop-down list on the left of the screen. This shows the different lead passengers in the chosen database (usually only those who have travelled in the past 12 months). Note that the lead passenger is usually but not always the actual passenger on a flight. If there is more than one passenger in a booking the actual passengers' names will differ from the lead passenger.

The air ticket costs are the sum of all costs for airtickets in the booking. If the booking has a long history and a number of invoices and credit notes have been issued, this figure represents the total of all the invoices/credit notes in the folder.
For the purposes of management reporting JTB allocates each booking to a given region, country and city. There is a certain ambiguity in this allocation but the process is as follows. A nine-region breakdown of the world is used to allocate a region. The regions are

  1) United Kingdom
  2) Europe (not UK)
  3) Middle East
  4) North America
  5) South America
  6) Africa
  7) Japan
  8) Asia (not Japan)
  9) Australasia

          In the case of a simple trip the allocation is straightforward. A ticket from London to New York and back would be allocated to North America, USA, New York. However, for more complex journeys the allocation is more difficult. For example, a business trip taking in Tokyo and Beijing could be allocated to Japan or Asia (not Japan). A trip to Frankfurt and then Stockholm and then back to London could be allocated to either Germany or Sweden. In these cases the usual rule of allocation is to pick the most distant region from the list above (so the Tokyo-Beijing trip would be allocated to Asia (not Japan)) or the destination where most time is spent. So if the stop at Beijing was merely to take advantage of a cheaper flight and the day of departure was the same as the arrival day, the trip would be allocated to Japan.
          The itinerary refers to the whole trip contained in the booking, not to an individual sector.
          This allocation should be borne in mind when looking at total expenditure to a specific location.

The data here are organised in sectors - i.e.individual flights. The airline, class, class code and baggage allowance refer to the single leg, or sector, of a flight. Class here is categorised into First, Business, Premium Economy and Economy with a further subdivision if there are any restrictions on the terms of the ticket. The class code and airline taken together should give a full idea of the nature of the restrictions.
     The number of passengers will usually be one but, in the case of a number of tickets being placed in a single booking (e.g. a family trip) this number might be more.

The data here are organised in sectors - i.e.individual flights. The departure and arrival times are the scheduled local times. The flight times are shown in hours and minutes with 3.50 representing 3 hours and 50 minutes.

The departure and arrival airports refer to a single leg or sector.
     The distance presented is the 'great circle distance' and is the shortest distance between the departure and arrival airport based on the assumption that the earth is a perfect sphere. Actual flight distances are typically 10% or so greater as planes follow indirect air corridors, etc.
     CO2 emissions are calculated using DEFRA's Code of Best Practice. They depend on flight distance, class of travel and type of flight (internal, short-haul or long-haul). Radiative forcing factors are not included.

These columns are usually empty, but may contain seat numbers and special details of meals.