Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Panel
borderColorgris
bgColorgris
Table of Contents
outlinetrue


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> 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 00.00100

  • 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

  • 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:

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

Display

Code Block
languagevb
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>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 / *

Note

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

Code Block
languagevb
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   
Code Block
languagevb
TCODE/M-20/CLABHXY/FLALL/FRALL
OK. ITEM MOD

TCODE/*
ITEM  TOUR CODE        OFFICE  TRANSACT  CLASS       FLIGHTS         FROM      TO        CH       PERCENTAGE  DESIGNATOR   PRICING DATE        TRAVEL DATE      
....
 20. PROMO01                    TKT/EMD  ABHXY       ALL - ALL       ALL       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

Code Block
languagevb
TCODE/*
ITEM  TOUR CODE        OFFICE TRANSACT   CLASS       FLIGHTS         FROM      TO        CH       PERCENTAGE  DESIGNATOR   PRICING DATE        TRAVEL DATE   

....
 20. PROMO01                   TKT/EMD   HXY         ALL - ALL       ALL       ALL       HA       44.00%      MCS          29FEB20   31DEC21    08APR20   31DEC21  
Code Block
languagevb
TCODE/D-20
OK. ITEM DEL


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

Code Block
languagevb
TCODE/*
ITEM  TOUR CODE        OFFICE  TRANSACT  CLASS       FLIGHTS         FROM      TO        CH       PERCENTAGE  DESIGNATOR   PRICING DATE        TRAVEL DATE         
...
   3. PROMO01                  TKT/EMD   BFHMPYZ     1031-1031       AEP       MVD       HA       10.00%      MC10         18JUN20   OPEN       18JUN20   OPEN      
   4. PROMO01                  TKT/EMD   BFHMPYZ     ALL - ALL       AEP       MVD       HA       20.00%      MC20         18JUN20   OPEN       18JUN20   OPEN      
   5. PROMO01                  TKT/EMD   BFHMPYZ     ALL - ALL       ALL       ALL       HA       30.00%      MC30         18JUN20   OPEN       18JUN20   OPEN      

Published Fare

Code Block
languagevb
F*Y/AEPMVD
FILTER - BOOKING CODE: Y 

It   ID.MASTER     FARE BASIS  DEP ARR  PTC    CURR.    VALUE     PUBLIC.  EFFECT.    EXPIR.  RULE
 1  [506491    ]   YFARE       AEP MVD   ADT   USD       150.00  02JAN20  02JAN20    OPEN     
 2  [507897    ]   YAC         AEP MVD   ADT   USD       150.00  23APR20  23APR20    OPEN     
 3  [507756    ]   AKAK        AEP MVD   YCD   USD        10.00  17MAR20  17MAR20    OPEN     

-END OF LIST-      

Case 1 - *UN issuance

Itinerary

Code Block
languagevb
   1  XX1031Y 20JUL MO AEPMVD HK1  0430 0600      

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

Quotation

Code Block
languagevb
WS*UNPROMO01
FARE NOT GUARANTEED UNTIL TICKETED

     PASSENGER           TYPE       FARE (IN ARS)          TAX        FEE       PER PSGR
  1. RO/RA                ADT             9787.50      7194.18       0.98       16982.66
                   TOTALS   1             9787.50      7194.18       0.98       16982.66

FARED: KIUHELPMC 1549/19JUN20 # WS*UNPROMO01
Code Block
languagevb
WW
 PAX:  1.ADT                                   TOTAL PAXS FARED:  1

CHECK FARE RESTRICTION BEFORE ISSUE            0  0
-------------------------------------------------------------------------
            CR FLT  BK DATE  TIME   ST   FARE BASIS          NVB   NVA   BG
 AEP
 MVD        XX 1031 Y  20JUL 0430   OK   YAC/MC10                        25K  


FARE          USD         135.00                              BSR 72.50000
EQUIV         ARS        9787.50
TAX           ARS         735.88AR    3153.75O5     435.00QO     320.45TQ    1824.10XR  
                          725.00YQ  
TOTAL         ARS       16981.68

AIRLINES FEE  ARS           0.98
GRAND TOTAL   ARS       16982.66


 /FC BUE XX MVD 135.00NUC135.00END ROE1.000000 XT 435.00QO 320.45TQ 1824.10XR 725.00YQ 


FARED: AEPXX-MC 1550/19JUN20 # WS*UNPROMO01

Issuance

Code Block
languagevb
WK*FCA*UNPROMO01

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

Code Block
languagevb
    1  XX4370Y 20JUL MO AEPMVD HK1  2200 2300     

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

Quotation

Code Block
languagevb
WS*UB/PROMO01
FARE NOT GUARANTEED UNTIL TICKETED

     PASSENGER           TYPE       FARE (IN ARS)          TAX        FEE       PER PSGR
  1. PEREZ/PABLO MR       ADT             8700.00      6791.80       0.87       15492.67
                   TOTALS   1             8700.00      6791.80       0.87       15492.67
Code Block
languagevb
WW
 PAX:  1.ADT                                   TOTAL PAXS FARED:  1

CHECK FARE RESTRICTION BEFORE ISSUE            0  0
-------------------------------------------------------------------------
            CR FLT  BK DATE  TIME   ST   FARE BASIS          NVB   NVA   BG
 AEP
 MVD        XX 4370 Y  20JUL 2200   OK   YAC/MC20                        25K  


FARE          USD         120.00                              BSR 72.50000
EQUIV         ARS        8700.00
TAX           ARS         659.75AR    2827.50O5     435.00QO     320.45TQ    1824.10XR  
                          725.00YQ  
TOTAL         ARS       15491.80

AIRLINES FEE  ARS           0.87
GRAND TOTAL   ARS       15492.67


 /FC BUE XX MVD 120.00NUC120.00END ROE1.000000 XT 435.00QO 320.45TQ 1824.10XR 725.00YQ 


FARED: AEPXX-MC 1721/19JUN20 # WS*UB/PROMO01

Issuance

Code Block
languagevb
WK*FCA*UB/PROMO01

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

Code Block
languagevb
     1  XX999 Y 20JUL MO AEPMDQ HK1  1000 1100   

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

Code Block
languagevb
WS*UI/PROMO01
FARE NOT GUARANTEED UNTIL TICKETED

     PASSENGER           TYPE       FARE (IN ARS)          TAX        FEE       PER PSGR
  1. ANGLARILL/DIEGO BU.. ADT             1050.00       589.43       0.11        1639.54
                   TOTALS   1             1050.00       589.43       0.11        1639.54
Code Block
languagevb
WW
 PAX:  1.ADT                                   TOTAL PAXS FARED:  1

CHECK FARE RESTRICTION BEFORE ISSUE            0  0
-------------------------------------------------------------------------
            CR FLT  BK DATE  TIME   ST   FARE BASIS          NVB   NVA   BG
 AEP
 MDQ        XX 999  Y  20JUL 1000   OK   YOW/MC30                        20K  


FARE          ARS        1050.00                              BSR 1.00000
EQUIV         ARS        1050.00
TAX           ARS         100.006H     115.21DL     271.00DS      47.25QN      20.00TQ  
                           35.97XR  
TOTAL         ARS        1639.43

AIRLINES FEE  ARS           0.11
GRAND TOTAL   ARS        1639.54


 /FC BUE XX MDQ 1050.00ARS1050.00END XT 271.00DS 47.25QN 20.00TQ 35.97XR 


FARED: AEPXX-MC 1747/19JUN20 # WS*UI/PROMO01

Issuance

Code Block
languagevb
WK*FCA*UI/PROMO01

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)