TourCode: quotation and issuance

Owned by Andrea Sanguinetti
Last updated: Aug 11, 2021 by Daniela Salomon
16 min read

 

 



Introduction

The configuration of the TourCode Table that allows the application of discounts to the published rates is described.



Description

Tour Codes for Host offices and / or Agencies will be published in this table.

For each Tour Code discounts, specific ticket designators, specify office, sales channel may be applied (in case no data is entered, it will be applied to both: HA, dates of application (From-To).

Discounts can also be applied to the booking class / s (up to 10 classes can be detailed), to specific flights (also by numbering range of flights or for all when specifying ALL), to specific route (for all when specifying ALL, both for origin as for destination), and date of the itinerary

In case the same Tour Code has different discounts, the system will apply the most restrictive, that is, the one with the lowest discount (applies to itineraries with more than one coupon)

In the event that a segment does not apply to any Tour Code, no discount will be applied to the entire itinerary.



Considerations

This functionality is integrated for broadcasts from KIU Host, KIU GDS (agencies), and the new IBE version (e-commerce). It does not apply to other systems’ distribution.

The Tour Code Manager (TCM) indicator must be activated in the corresponding JJETKT table / s so that the Tour Codes of the TCODE / * table are applicable and controlled in the listing and issuance

If the same Tour Code applies different discounts for different classes and the itinerary contains the different classes, the discount that will be applied will be the most restrictive on all the segments that apply discount.

If a Tour Code applies to only part of the listed itinerary, no discount will apply. Segments should be quoted and issued individually.



Add

TCODE/A-<tourcode>/DP<discount>/TK<ticket designator>/OF<office or ALL>/CH<host, agency or host and agency>/PE<pricing date DDMMMYY>/PD<DDMMMYY>/CL<class>/FL<flight1>-(flight2)/FR<origin>/TO<destination/TE <travel date begin DDMMMYY>/TD<travel date end DDMMMYY>/ET<apply on TKT Y or N>/MD<apply on EMD Y or N>

Description:

Indicator

Description

<tourcode>

  • Tour code name.

  • Identifies a special agreement between an airline and an agency or any point of sale.

  • It must be 3 to 15 alphanumeric characters long.

  • The Tour Code cannot be repeated when it affects the same office

DP<discount>

  • Discount percentage to apply.

  • Accepts whole numbers (1 or 2 digits) and decimals (2) separated with a period

  • For 100% discount, must use the option 100

  • Accepts 0%

  • Could be configurated by passenger type: ADT %+CHD %+INF %

example: DP100+80+0

If it is configurated with only one percentage, this one will apply for all type of passengers.

TK<ticket designator>

Ticket designator type to be added to the farebasis to indicate the discount description

OF<office or ALL>

  • Office on which the TourCode applies.

  • It can be Agency or Host.

  • If not specified it applies to all.

  • The Tour Code cannot be repeated when it affects the same office

CH<host, agency or host and agency>

  • Sales channel: H for Host and A for Agency.

  • They can one or both HA.

  • If not specified, it applies to both

PE<pricing date DDMMMYY>

  • Quote date from.

  • Indicates the validity of the rule, it will apply when the quote / issue date corresponds to the range indicated in the table.

  • Supports OPEN indicator

PD<DDMMMYY>

  • Quote date up to.

  • Indicates the validity of the rule, it will apply when the quote / issue date corresponds to the range indicated in the table.

  • Supports OPEN indicator

CL<class>

  • Up to 10 classes can be specified in the list.

  • The default of the command is ALL

FL<flight1>-(flight2)

  • Flight or range of flights.

  • If ALL is applied it applies to all flights.

FR<origin>

  • FROM.

  • Indicates the origin of the flight.

  • If ALL is applied it applies to all sources

TO<destination>

  • TO.

  • Indicates the Destination of the flight.

  • If ALL is applied it applies to all destinations

TE<travel date begin DDMMMYY>

  • Sale date from.

  • Indicates the validity of the rule, it will apply when the start date corresponds to the range indicated in the table.

  • Supports OPEN indicator

TD<travel date end DDMMMYY>

  • Sale date until.

  • Indicates the validity of the rule, it will apply when the date corresponds to the range indicated in the table.

  • Supports OPEN indicator

ET<apply on TKT>

  • Y: Apply on TKT

  • N: Does not apply on TKT

If this indicator is not used in the configuration, the default will be Yes.

MD<apply on EMD>

  • Y: Apply on EMD

  • N: Do not apply on EMD

If this indicator is not used in the configuration, the default will be Yes.

Example:

TCODE/A-PROMO01/DP44.00/TKMCS/OFALL/CHHA/PE29FEB20/PD31DEC21/CLHYX/FL322-322/FRAEP/TOALL/TE08APR20/TD31DEC21/ETY/MDN OK. ITEM ADD

Display

TCODE/* ITEM TOUR CODE OFFICE TRANSACT CLASS FLIGHTS FROM TO CH PERCENTAGE DESIGNATOR PRICING DATE TRAVEL DATE .... 20. PROMO01 TKT/EMD HXY 0322-0322 AEP ALL HA 44.00% MCS 29FEB20 31DEC21 08APR20 31DEC21

 



Modify

TCODE/M-<item>/DP<discount>/TK<ticket designator>/OF<office or ALL>/CH<host, agency or host and agency>/PE<pricing date DDMMMYY>/PD<DDMMMYY>/CL<class>/FL<flight1>-(flight2)/FR<origin>/TO<destination/TE<travel date begin DDMMMYY>/TD<travel date end DDMMMYY>>/ET<apply on TKT Y or N>/MD<apply on EMD Y or N>

Description:

Indicator

Description

<item>

Item number of the list previously displayed with the query command TCODE / *

It is possible to modify one or several indicators in the same entry

You can change all the fields except the name, in which case you must delete the item and re-create it.

Example:

The first step is to look for the number of the item to be modified

TCODE/* ITEM TOUR CODE OFFICE TRANSACT CLASS FLIGHTS FROM TO CH PERCENTAGE DESIGNATOR PRICING DATE TRAVEL DATE .... 20. PROMO01 TKT/EMD HXY 0322-0322 AEP ALL HA 44.00% MCS 29FEB20 31DEC21 08APR20 31DEC21

 



Delete

TCODE/D-<item>

Description:

Indicator

Description

<item>

Item number of the list previously displayed with the query command TCODE / *

Example:

The first step is to look for the number of the item to be deleted

 



TourCode quotation

In case you need to add a tourcode when quoting, there is the option to add *U (after the WS*) followed by different display options (at the time of printing the electronic ticket) of BT or IT tourcodes with or without display.

The options are as follows:

  • UB/:

    • This indicator will show the abbreviation BT in the place where the amount of the base fare is shown when the electronic ticketing (ITR) is printed.

    • The tour code name is displayed as BT <tourcode>

WS*UB/<tourcode>

  • UB:

    • This indicator will show the amount of the base fare in the printing of the electronic ticket (ITR).

    • The tourcode name is displayed as BT <tour code>

WS*UB<tourcode>

  • UI/:

    • This indicator will show the acronym IT in the place where the amount of the base fare is displayed when the electronic ticketing (ITR) is printed.

    • The tour code name is displayed as IT <tourcode>

WS*UI/<tourcode>

  • UI:

    • This indicator will show the amount of the base fare in the printing of the electronic ticket (ITR).

    • The tourcode name is displayed as IT <tour code>

WS*UI<tourcode>

  • UN:

    • This indicator will show the amount of the base fare in the printing of the electronic ticket (ITR).

    • The tour code name is displayed without any acronym, the selected tourcode will be seen.

WS*UN<tourcode>



TourCode issuance

In case you need to add a tourcode at the time of issuance, there is the option to add *U (after the WK*) followed by different display options (at the time of printing the electronic ticket) of BT or IT tourcodes with or without display.

The options are as follows:

  • UB/:

    • This indicator will show the abbreviation BT in the place where the amount of the base fare is shown when the electronic ticketing (ITR) is printed.

    • The tour code name is displayed as BT <tourcode>

WK*FCA*UB/<tourcode>

  • UB:

    • This indicator will show the amount of the base fare in the printing of the electronic ticket (ITR).

    • The tourcode name is displayed as BT <tour code>

WK*FCA*UB<tourcode>

  • UI/:

    • This indicator will show the acronym IT in the place where the amount of the base fare is displayed when the electronic ticketing (ITR) is printed.

    • The tour code name is displayed as IT <tourcode>

WK*FCA*UI/<tourcode>

  • UI:

    • This indicator will show the amount of the base fare in the printing of the electronic ticket (ITR).

    • The tourcode name is displayed as IT <tour code>

WK*FCA*UI<tourcode>

  • UN:

    • This indicator will show the amount of the base fare in the printing of the electronic ticket (ITR).

    • The tour code name is displayed without any acronym, the selected tourcode will be seen.

WK*FCA*UN<tourcode>



Cases of use

Example of Table

Published Fare

Case 1 - *UN issuance

Itinerary

Quotation should apply TOURCODE PROMO01 (designator MC10) because it considers the more restricted condition (flight XX1031)

Quotation

Issuance

Electronic ticket preview

TourCode (PROMO01) is shown, amount of the fare, and the designator MC10 (following the fare basis in the itinerary)

 

Case 2 - *UB/ issuance

Itinerary

Quotation should apply TOURCODE PROMO01 (designator MC20) because it does not includes the more restricted condition (flight XX1031)

Quotation

Issuance

Electronic ticket preview

TourCode (PROMO01) is shown, word "BT" is shown where the fare is located, and the designator MC20 (following the fare basis in the itinerary)

 

Case 3 - *UI/ issuance

Itinerary

Quotation should apply TOURCODE PROMO01 (designator MC30) because it does not comply with the table conditions per flight or origin/destionation but it matches with the ALL/ALL condition.

Quotation

Issuance

Electronic Ticket preview

TourCode (PROMO01) is shown, word "IT" is shown where the fare is located, and the designator MC30 (following the fare basis in the itinerary)