Ticket Transaction
Name |
Ticket Transaction |
Code |
TktTrans |
Source |
Entity TktTrans |
XML Element |
TicketingData/TicketEvent, TicketingData/TicketTransaction, TicketingData/OBFeesTotals |
Description
Details of ticketing activity on the behalf of a Travel Order. The data replaces previously stored ticketing data for the Travel Order. The previous contents are retained for potential review. Individual airline commission amount shall be linked to each corresponding ticket and the airline commission percentage shall be captured and reported through existing TBF ticketing transaction table.
Fields
Travel Order Event Identifier
Field Label |
TravelOrderIdentifier |
XML Element |
No equivalent XML. |
Attributes |
4 N |
Status |
Mandatory |
Description |
A programmatically generated number that uniquely identifies travel order event. Passed to this table from the TableOrderEvent table. |
Event Type |
Ticketing |
Allowable Values |
Not applicable. |
Ticket Number
Field Label |
TicketNbr |
XML Element |
TicketNumber |
Attributes |
10 N |
Status |
Mandatory |
Description |
A GDS-generated number that uniquely identifies a printed ticket. |
Event Type |
Ticketing |
Allowable Values |
Not applicable. |
Transaction Year
Field Label |
TransactionYear |
XML Element |
YearOfTravel |
Attributes |
1N |
Status |
Mandatory |
Description |
The last digit of the year of travel. |
Event Type |
Ticketing |
Allowable Values |
Not applicable. |
Transaction Computerized Reservation System
Field Label |
TransactionCrs |
XML Element |
CRS |
Attributes |
5 A/N |
Status |
Optional |
Description |
The Global Distribution System (GDS) that created the ticketing transaction. |
Event Type |
Ticketing |
Allowable Values |
05880 Apollo 07733 Galileo |
Transaction Stock Type
Field Label |
TransactionStockType |
XML Element |
StockType |
Attributes |
1 A/N |
Status |
Optional |
Description |
The industry-standard code of the type of printable stock that was used for a paper ticket. Entered by the ticketing agent. |
Event Type |
Ticketing |
Allowable Values |
O Optat A ATB T TAT P Paper (Itinerary only) |
Ticket Type
Field Label |
TicketType |
XML Element |
TicketType |
Attributes |
1 A/N |
Status |
Optional |
Description |
The physical status of the ticket. |
Event Type |
Ticketing |
Allowable Values |
E Electronic P Paper |
Active/Void Status
Field Label |
ActiveVoidStatus |
XML Element |
TicketStatus |
Attributes |
1 A/N |
Status |
Optional |
Description |
Identifies whether a travel or reservation agent (or an automated tool acting on their behalf) has voided or refunded a ticket transaction. |
Event Type |
Ticketing |
Allowable Values |
A Active R Refund3.0 V Void E Exchange |
Transaction Plating Alpha
Field Label |
TransactionPlatingAlpha |
XML Element |
PlatingCarrierAlpha |
Attributes |
3 A/N |
Status |
Mandatory |
Description |
The alpha code identifying the carrier for which the ticket was validated. |
Event Type |
Ticketing |
Allowable Values |
Not applicable. |
Transaction Plating Number
Field Label |
TransactionPlatingNbr |
XML Element |
PlatingCarrierNumeric |
Attributes |
3 N |
Status |
Mandatory |
Description |
The numeric code assigned to and identifying the carrier in which the ticket was validated. |
Event Type |
Ticketing |
Allowable Values |
Not applicable. |
OB Fee Total Amount
Field Label |
OBFeeTotalAmount |
Attributes |
11 N Variable |
Status |
Optional |
Description |
Total amount of OB Fees and taxes on OB Fees collected. |
Event Type |
Ticketing |
Allowable Values |
Not applicable. |
OB Fee Grand Total Amount
Field Label |
OBFeeGrandTotalAmount |
Attributes |
11 N Variable |
Status |
Optional |
Description |
Total amount of ticket Fare plus OB Fees and taxes on OB Fees collected. |
Event Type |
Ticketing |
Allowable Values |
Not applicable. |
OBF Currency Code
Field Label |
OBFCurrencyCode |
XML Element |
OBFCurcyCode |
Attributes |
3 A/N |
Status |
Optional |
Description |
The currency in which the OB Fees and taxes on OB Fees were collected. |
Event Type |
Ticketing |
Allowable Values |
Not applicable. |
OBF Decimal Number
Field Label |
OBFDecimalNumber |
XML Element |
OBFNbrDec |
Attributes |
4 N |
Status |
Optional |
Description |
Indicator that identifies where the decimal is placed on the monetary value, if applicable. |
Event Type |
Ticketing |
Allowable Values |
Not applicable. |
Transaction Type
Field Label |
TransactionType |
||||||||||||||||
XML Element |
TransactionType |
||||||||||||||||
Attributes |
1 A/N |
||||||||||||||||
Status |
Optional |
||||||||||||||||
Description |
The ticket transaction type. Note: These values are not sent for “void” ticket transactions. Therefore, this field will not populate for “void” tickets. |
||||||||||||||||
Event Type |
Ticketing |
||||||||||||||||
Allowable Values |
|
Tour Code
Field Label |
TourCode |
XML Element |
TourCode |
Attributes |
15 A/N |
Status |
Optional |
Description |
The tour code from the document being issued. A Tour Code may be present for a ticketing event that uses either:
|
Event Type |
Ticketing |
Allowable Values |
Not applicable. |
IT BT Indicator
Field Label |
IT BT Indicator |
XML Element |
ITBTIndicator |
Attributes |
2 A/N |
Status |
Optional |
Description |
This indicator is set when fare amounts on the Passenger Receipt for a ticketing event are overlaid with ‘IT’ or ‘BT’. Note:If 'IT' or 'BT' values appear, it is not mandatory for the ‘Net Remit Indicator’ field to contain the value ‘NR'. In other words, ‘IT’ or ‘BT’ can be used for Net Remit or non-Net Remit transactions. |
Event Type |
Ticketing |
Allowable Values |
IT Fare amounts overlaid with ‘IT’ BT Fare amounts overlaid with ‘BT’ blank |
Net Remit Indicator
Field Label |
NetRemitIndicator |
XML Element |
NRIndicator |
Attributes |
15 A |
Status |
Optional |
Description |
The indicator is set when a ticketing event contains Net Remit data. When ‘the data field contains NR’ Net Remit data is present in the ticketing event and one or more of the net remit data fields will be populated (as applicable). |
Event Type |
Ticketing |
Allowable Values |
NR Net Remit data is present. |
Fare Calculation Pricing Indicator
Field Label |
FareCalculationPricingInd |
||||||||||||||||||||||||||||||||||||||||||||
XML Element |
FareCalcPriceInd |
||||||||||||||||||||||||||||||||||||||||||||
Attributes |
1 A/N |
||||||||||||||||||||||||||||||||||||||||||||
Status |
Mandatory |
||||||||||||||||||||||||||||||||||||||||||||
Description |
A system-generated indicator that identifies the pricing method used to calculate the fare on the ticket. The Fare Calculation Pricing Indicators (on Apollo and Galileo) are the source of reference to determine if the ticketed fare qualifies under the Travelport Fare Guarantee Policy. |
||||||||||||||||||||||||||||||||||||||||||||
Event Type |
Ticketing |
||||||||||||||||||||||||||||||||||||||||||||
Allowable Values |
Galileo Values:
Note: A,G, and Z are used in the case of baggage and/or TFC manipulations. Apollo Values:
|
Airline Commission Amount 7.1
Field Label |
AirlineCommissionAmt |
XML Element |
AirlineCommissionAmt |
Attributes |
11 A/N |
Status |
Optional |
Description |
Amount, including decimal places if required |
Event Type |
Ticketing |
Allowable Values |
Not applicable. |
Airline Commission Percentage 7.1
Field Label |
AirlineCommissionPercent |
XML Element |
AirlineCommissionPercent |
Attributes |
5 A/N |
Status |
Optional |
Description |
Percentage, including decimal places if required. Can be entered with Capped Amount(1G) |
Event Type |
Ticketing |
Allowable Values |
Not applicable. |
Invoice Number 7.1
Field Label |
InvoiceNumber |
XML Element |
InvoiceID |
Attributes |
10 A/N |
Status |
Optional |
Description |
Alpha/Numerical value to indicate invoice |
Event Type |
Ticketing |
Allowable Values |
Not applicable. |