Commission

Airline Commission Table

Airline Commission Table allows airlines to store information regarding commission to be applied by default. Therefore, when there is no commission data in the PNR/BF, EZ/TKP/TMU input entry, in the document instructions or in the pricing shell, the system applies the commission data stored in the airline commission table.

To display the table use the following entries.

Galileo

Worldspan

Display commission for a specific airline (YY- airline code). The commission display entry defaults to country of the location making the entry.

Entry: 4G/AM-COM-YY

Display commission for specific country (XX - country code) and airline (YY - airline code).

Entry: 4G/AM-COM*XX-YY

Apollo

Not Available

 

4.1.5 Commission – Bytes 34-63

The Commission fields only specify the commission data that must appear on the ticket. Data in these fields provide the commission information for BSP and ARC usage. Commission data can apply for net remit transactions or other non-net remit fares. These fields do not necessarily reflect the total commission an agency will receive for a negotiated fare.

The Commission fields consist of the following data elements:

• Gross/Net Indicator (byte 34)

• Percentage (bytes 35-41)

• Amount 1 and Amount 2 (bytes 42-63)

These data elements are further defined below.

Gross/Net Indicator (byte 34)

The Gross/Net Indicator identifies whether a calculated commission specified in Percent field (bytes 35-41) or a standard commission is based on the Net Submit Fare amount or on the Gross (Ticketed) Fare amount or whether the commission is the percentage difference between the Net Submit Fare amount and the Gross Fare amount. Data in this field is used to determine the Commission Type (COTP) for BSP reporting.

Applicable values in byte 34 follow:

Value N = Net Amount. Calculated commission or standard commission is based on the net fare amount.

Value G = Gross (Ticketed) Amount. Calculated commission or standard commission is based on the gross (ticketed) amount.

Value B = Calculate the percentage difference between the Net Fare amount and the Ticketed (Gross) Fare amount.

Value Blank =No Application. Standard commission applies, including agent input of commission.

For calculation purposes, the Net Fare amount is retrieved from the Fare Record fare amount, Fare by Rule Resulting fare amount, or Fare Creator Table Number 979. The Gross (Ticketed) Fare amount is the fare used for ticketing purposes, and is retrieved from the Ticketed Fare Information fields (Bytes 136-172) or Fare Box field (Bytes 184-194).

When NET is entered, the Net Fare amount is retrieved from the Fare Record fare amount, Fare by Rule Resulting fare amount, or Fare Creator Table Number 979

If we look at below TARIFF/RULE, you have filed N for Commission, but there is no NET fare amount in the Fare By Rule Resulting fare amount (Type L has been coded) and there is no Fare Creator Table 979

Here the correct coding would be COMMISSION with value G or BLANK and not N which is currently creating issues on the BSP side as having value N is triggering Net Remit COTP N.

COTP = Commission Type

Value N definition =

Commission Conflict Fare Quote Warning Message for Travelport+ only

When there are different commission amounts for private fares or a combination of private and public fares on the same ticket, Travelport+ (Galileo) will issue a warning message at the time of pricing to encourage the user to manually add a commission amount.

Hence, we recommend the user to use the TMU1Z entry to manually add the commission; otherwise, the default airline commission rate will apply.

This warning message is COMMISSION: MANUAL INPUT NEEDED BEFORE TICKETING

Example:

Combo of private and published (Private EFSG TARIFF 912 RULE SG10 + Public EIPH TARIFF 302 RULE IPHN)

Private fare coded with 7% commission in ATPCO Category 35

Public no commission = commission conflict which is why the WARNING is returned for the agent to input the commission manually.

In this case the agent didn’t input the commission manually therefore as per our system logic the default airline commission table was applied = 5%

PNR history showing no commission entered manually by the agent:

Exception to this logic:

The 20OCT23, via PRICING-1445 enhancement, we eliminate the warning & commission override function when public fares, cat15 private fares, or cat35 private fares with no ATPCO commission filed (regardless of what is coded in the airline commission table CGCTD) are combined with cat35 fares with 0% commission coded. In this scenario 0% commission is applied to the whole itinerary priced/ticket. The commission cannot be altered anymore as this is not considered as a commission conflict. If you try to manually add the commission you will get below error message: