Export Transaction Data - Segments file

This topic lists the information included in the Segments file created by the Exporting Transaction Data module. The Segments file contains information on individual segments in transaction.

Column

Description

Segment ID

The segment number in the transaction

Travel file number

The travel file number

Transaction ID

The transaction ID

Ticket/Reservation number

The ticket number of the first passenger in the transaction

Airline Code

The IATA code of the Airline

Depart City Code

The IATA code of the segment's origin

Depart Date

The departure date

Depart Time

The departure time

Flight Number

The flight number

Arrival City Code

The IATA code of the segment's destination

Arrival Date

The arrival date

Arrival Time

The arrival time

Fare Basis

The segment's Fare basis

Class

The class

Mileage

The segment's mileage

Seat Assignment

The passenger's seat assignment

Equipment Type

The segment's Equipment (taken from the more fields in the transaction Details tab)

Is Connection

The departing flight is X. Connection flights are O. All flights after the first flight in any given direction are connection flights.

Mode

  • Flight segments: A

  • Train segments: R

  • Other service types: column is blank

Debit/Credit

  • Cash invoice issued:  1.

  • Credit invoice issued: 0

  • No invoice issued: Column is blank

Batch in#

The batch-in number that was created for the transaction when the transaction data was refreshed.