Export Transaction Data - Bookings File

This topic lists the information included in the Bookings file created by the Exporting Transaction Data module. The Bookings file contains information on service transactions.

Column	Description
Travel file number	The travel file number
Transaction ID	The transaction or transaction fee ID
Service type	The service type. For transaction fees, the service type is always Transaction Fee.
Transaction type	The transaction type. There are four transaction types: Sale: A service transaction with a voucher or transaction fee with a tax invoice Refund: A service transaction with a voucher and a confirmed refund Exchange: A ticketed service transaction which was reissued Cancel: A service transaction with a voucher or transaction fee with a tax invoice that was cancelled.
Record Locator	The PNR number from the GDS. With hotel transactions, it is the reservation number.
Invoice number	The invoice number of the invoice issued for the service transaction or transaction fee
Account name	The name of the travel agent/corporate client. If none are attached to the travel file, the column is none.
Online GDS code	The travel agent/corporate client GDS code
Vendor name	This information is taken from the supplier account of the ticketing airline or reserving supplier.
Vendor code
Vendor address
Vendor city
Vendor State
Vendor ZIP
Vendor Country
Vendor Phone	The phone number of the ticketing airline or reserving supplier. The number is either the first phone number in the supplier account or the phone number defined as the main phone number.
Airline number	The IATA number of the ticketing airline or reserving supplier
Reason	The Reason field from the UDID Management page
INV Issue date	The issue date of the invoice issued for the service transaction or transaction fee
VCH Issue date	The issue date of the voucher issued for the service transaction or tax invoice issued for the transaction fee
Start date	The service start date
End date	The service end date
Supplier price	The transaction supplier price
Tax	The tax on the transaction
Total paid	The supplier price and tax on the transaction
Average rate per N/D	If the transaction is priced per day or night (for example, hotel, car, insurance), the cost of the transaction for a single day or night. The price is calculated as the supplier price divided by the number of days or nights.
Net currency	The currency code of the transaction net currency
Client payment method	The method of payment the passenger used to pay the receipt. This information is only displayed for transactions with an invoice covered by a receipt. The methods of payment are as follows: CA: Cash CC: Credit Card CK: Check
Passenger name	The name of the first passenger in the transaction
Ticket/Reservation number	For the first passenger in the transaction: Flights: The ticket number Hotels: The hotel reservation number Insurance: The insurance policy number
Origin	With leg transactions, the IATA code of the origin of the first leg in the transaction. With all other transactions, the IATA code of the transaction destination.
Destination	The IATA code of the transaction destination
Cost center	This information is taken from the UDID Management page.
Budget number
Project number
Reference number 1
Reference number 2
Pref. 3
Pref. 4
Pref. 5
Low fare
High fare
Order number
Trip purpose
PNR Status
PNR Update
Proposal 1
Proposal 2
Proposal 3
Air reason code
Saving
Employee ID	The Employee ID of the first passenger in the travel file. Taken from the UDID Management page.
Passenger Email	The e-mail address of the first passenger in the travel file
Company number	The Company number field of the travel agent/corporate client attached to the travel file.
Debit/Credit	Cash invoice issued: 1. Credit invoice issued: 0 No invoice issued: Column is blank
Hotel name	For hotel transactions, the Hotel name field from the Hotel Details tab.
No. of nights/days	For hotel, package, cruise and escorted tour transactions, the No. of nights field. For car and insurance transactions, the No. of Days field. This field is in the Product Details tab.
T. Fee description	The transaction fee description.
Batch in #	The batch-in number that was created for the transaction when the transaction data was refreshed.
Number of units	In hotel, cruise, escorted tour, and package transactions - the number of rooms or cabins in the transaction. For all other service types and transaction fees - 1.
PCC/Office ID	The first PCC of the user attached to the travel file.
GDS	Flight transactions. In the Flight Details tab, in the More fields, the GDS field of the first leg.
INV Due date	The value date of the invoice issued for the transaction (if issued).
INV Currency	The currency of the invoice issued for the transaction (if issued)
INV Net to remit	The Net to remit amount on the invoice, in the invoice currency (if issued)
INV Net to remit in USD	The Net to remit amount on the invoice in USD - only if the transaction is in USD and the invoice is in a different currency. Otherwise column is blank.
INV Line number	The line number of the transaction on the invoice. If the transaction is third on the invoice, the column displays 3.
Form of payment	In the Accounting tab, the Client payment method: To this office Credit supp. Prepaid abroad MCO
Card number	If the Client payment method is Credit supp., the credit card number in the cover link. The number is encrypted as displayed in the Accounting tab.
INV Fare amount	The Fare amount on the invoice.
INV Fare amount in USD	The Fare amount on the invoice in USD - only if the transaction is in USD and the invoice is in a different currency. Otherwise column is blank.
INV Service amount	The Total amount on the invoice.
INV service amount in USD	The Total amount on the invoice in USD - only if the transaction is in USD and the invoice is in a different currency. Otherwise column is blank.
INV Tax amount	The Tax amount on the invoice.
INV Tax in USD	The Tax amount on the invoice in USD - only if the transaction is in USD and the invoice is in a different currency. Otherwise column is blank.
INV Reduction amount	The Reduction amount on the invoice.
INV Reduction amount in USD	The Reduction amount on the invoice in USD - only if the transaction is in USD and the invoice is in a different currency. Otherwise column is blank.
Country code of origin	With leg transactions, the country code of the transaction origin. With all other service types, the country code of the destination.
Destination country code	The country code of the transaction destination.
SIPP Code	Car transactions. The SIPP code in the Car Details tab.
Number of pax	The number of passengers in the transaction.
T.File open date	The date when the travel file was opened
T.File Branch	The branch attached to the travel file
Routing	Leg Transactions: The IATA code of each destination in the transaction route. If the departure and arrival destination are the same they are only displayed once. For example, a round-trip flight from Tel Aviv to Amsterdam is displayed as TLV AMS TLV. All other transacations: The IATA code of the destination. Transaction Fees: Column is blank.