Changes Field Descriptions

Change Type

This field indicates the type of change you wish to apply against the fares identified by the selection criteria. This is an edit-able field that is required if change criteria exists. Different field validations may occur depending on which option is selected. For example, if the Source is Transaction then the only two options for this field are Copy and Change to New and Copy as is. However, if the Source is Master then the options are (depending on the Scope selected): Modify, Add, Restore, or Cancel.

Use the button to remove data from all fields.

Change Type = Modify

Field Name	Field Description
Footnote Action	This field consists of two separate drop-down lists, the first list allows you to indicate Change versus Remove, and the second list allows you to indicate All Footnotes versus Specified Footnote. The drop-down lists help you describe your intent. For example, you can Change All Footnotes to [whatever you enter in the available text field]. The default values are Change and All Footnotes. The All Footnotes versus Specified Footnote drop-down list is disabled when By Itself is selected in the Find Footnotes field in the Inclusions group box. The text field is disabled when Remove is specified as the action.
Fare Class	This is an editable field that is not required and defaults to blank when the screen is first opened. The fare class entered in this field replaces the fare class of the fare identified in the Inclusions group box. You can type up to eight alphanumeric characters; the first character must be alpha.
Adjustment 1 / Adjustment 2	This is an editable field that is not required and defaults to blank when the screen is first opened. These fields are used to change the fare amount of the new fare. The drop-down list boxes at the right of the text fields contain three options: Amount, Multiply By, and Percent. The default is Amount. Select Amount to add to or subtract from the fare amount. Amount is assumed to be a positive value. You can type a minus (-) symbol to indicate a negative value when needed. Select Multiply By to multiply the fare by the value indicated in the Adjustment 1 or Adjustment 2 fields. For example, if the value indicated is 2 then the fare amount will by multiplied by 2 (doubled). Select Percent to multiply by the fare amount and then add to or subtract from the result to the fare amount. Percent is assumed to be a positive value. You can type a minus (-) symbol to indicate a negative value when needed. For example, if the value indicated is 2 then the fare amount will be increased by 2%. If both Adjustment 1 and Adjustment 2 fields are coded, the program performs the calculation according to Adjustment 1, then take the resulting fare amount and perform the calculation according to Adjustment 2.
Change Rule	This check box should only be checked if you are intending to change the rule number. This check box is available when the Source is Master and the Scope is either International or US/CA. You should perform the rule change to the fare classes in the rules system prior to running the query to prevent errors. The most common scenario for using this check box is if you are trying to change a fare class from one rule number to the another one (see the example below). Example: I currently have fare class Y in tariff TAFP in rule 7000. I cancelled fare class Y in rule 7000 and added it to rule 7500 in the rule systems in order to realign my rules. The fares in the Fare Master (database) still reflect the incorrect rule information. I run a query to correct my fares. When I select fare class y, tariff/carrier in the inclusion, and check change in rule in the change portion, I will generate change results that will cancel all of the fares attached to rule 7000 and create new fares attached to rule 7500.
City 1 / City 2	Both of these fields allow for entry of a single city code. Valid values are three alpha characters. These fields may be coded together or alone. Click the City field label to access the Help List for Locations dialog box.
Location 1 / Location 2	This is an editable field that is not required and defaults to blank when the screen is first opened. Multiple, comma separated locations may be typed. Click the Location 1 or Location 2 field labels to access the Help List for Locations dialog box. If the Scope is US/CA the Location 1 and Location 2 fields are based on alphabetical order of the city codes and not whether it was the origin or destination. US/CA fares are always published in alphabetical order ( i.e., LAX-NYC, but will never appear as NYC-LAX). If the Scope is International or Add-on, the Location 1 and Location 2 fields are origin/destination based.
Fare Amount	This is an editable field that is not required and defaults to blank when the screen is first opened. You can type up to 12 numeric characters, including a decimal, in this field. You can enter a fixed fare amount for the fare being modified. The system replaces the fare amount of the identified fare with the value entered in this field when the change result is created.
Rounding Direction	This is an editable field that is not required and defaults to blank when the screen is first opened. If a selection is not made from this field the default rounding instructions are retrieved for the currency code in the Change Results. Once the rounding instructions have been obtained, the fare amount is rounded and the new fare amount is placed in the Change Results. This field is used to indicate the rounding direction you wish to apply to a percentage adjusted amount. Valid values for this field include the following: Up Down Nearest decimals Nearest Disregard Extra decimals Up on discard extra decimals Round down on disregard extra decimals Up even Up to value Nearest— disregard last decimal Down on— disregard last decimal Up on— disregard last decimal If a selection is not made from the Rounding Direction or the Rounding Unit fields, the default rounding for the currency will be used when making fare adjustments with percentages. If you want to round the fare amount to something other than the default rounding, a selection must be made from the Rounding Direction and a Rounding Unit fields. The rounding direction instructs the system how to round the newly calculated fare amount. The rounding unit instructs the system how the fare amount should appear after the rounding has completed. International Example: You want to decrease a fare by 20 percent to celebrate your airline's anniversary. The anniversary sale fares must all end in the number 9. The fare is published in USD. The default rounding is up or down to the nearest dollar. The default rounding will not generate the correct results for this sale fare. To override the default use a rounding direction and a rounding unit. In the Changes group box of the query, code the amount of the decrease in the Adjustment field and select “Percent” from the drop-down list, in the Rounding Direction drop-down list select “Up to value”, and the Rounding Unit drop-down list select “9”. This will produce fares that have 9 as the last digit. Fare with a Rounding Direction and Rounding Unit: NYC - LON 1077.00 USD - 215.40 (20 PERCENT DECREASE) = 861.60 USD, ROUND UP TO VALUE AND END IN 9. THE FARE WILL NOW BE 869.00 BECAUSE IT WAS SPECIFIED TO UP TO THE NEXT NINE. Fare Using Default Rounding (no rounding direction or unit): NYC - LON 1077.00 USD - 215.40 (20 PERCENT DECREASE) = 861.60 USD. THIS WILL GET ROUNDED UP TO THE NEXT DOLLAR AND THE END FARE AMOUNT WILL BE 862.00 USD
Currency	This is an editable field that is not required and defaults to blank when the screen is first opened. You can change the currency code that is attached to the fare that is being modified. The system replaces the currency of the identified fare with the value entered in this field when the change result is created. This field accepts a three alpha character code (e.g., USD). Only one entry is permitted in this field.
Use Post Tax Amount	The default value for this check box is unchecked. This check box only displays when the Scope is US/CA. Checking this box instructs the program to use the post tax amount for calculations.
Rounding Unit	This is an editable field that is not required and defaults to blank when the screen is first opened. This is the unit used to round the Fare Amount field. Indicate the number and position on the number relative to the decimal point to which you wish the rounding to apply (.001, .01, .1, 1, 10, 100, 1000, 10000, 9, .25, or 25.00) See the field description for Rounding Direction above for further information about using this field.
Routing	This is an editable field that is not required and defaults to blank when the screen is first opened. Multiple, comma separated routing numbers may be typed in this field. You can change the routing number that is attached to the fare that is being modified. The system replaces the routing number of the identified fare with the value entered in this field when the change result is created. If the field is left blank the routing number of the identified fare is retained.
Add-on Zone	This is an editable field that is not required and defaults to blank when the screen is first opened. This field displays when the Scope is Add-on. Add-on zones consists of up to three numeric characters identifying arbitraries with the coded zone number. The carrier can pick any available number 001-999. The carrier always specifies the definition of the zone. Example: add-on DFW-CLE (tariff AUSA ) for 0.00 USD zone 100.
Effective Date	The default value is DDMMMYY (the date format, if you want to manually enter a date). Click the Calendar button to select a date from the Calendar dialog box. This field indicates the effective date that you wish to apply to the transaction.
OW/RT	This drop-down list box is not required and defaults to blank when the screen is first opened. The available options for this field include leaving the field blank or selecting 1 or 2 from the drop-down list. Select 1 to indicate one-way fares. Select 2 to indicate round-trip fares. If the field is left blank the trip indicator of the identified fare is retained. This field is used to change the trip indicator that is attached to the fare that is being modified. The system replaces the trip indicator of the identified fare with the value entered in this field when the change result is created. The trip indicator may get overlaid during validation of a published fare according to the Record 1 information in the rule.

Change Type = Add

In addition to the fields described above, the following fields will also display when the Change Type is Add.

Field Name	Field Description
Flip Indicator	The default value for this check box is unchecked. This check box displays when the Scope is International and the Source is Master. Check this box if you want the Location 1 and Location 2 of the Changes results to have the opposite order of the identified fare. For example, if the Inclusion contains Location 1 LON and Location 2 PAR identifying fare(s) published FROM LON TO PAR. If the “Flip Indicator” box is checked in the Changes – Add portion of the query then the results display in the opposite direction FROM PAR TO LON.
Carrier	This is an editable field that is not required and defaults to blank when the screen is first opened. Type up to three alphanumeric characters in this field, or click the Carrier field label to open the Carrier Codes dialog box where you can search through a list of valid carrier codes. This field is used to change the carrier that is associated with the fare that is being added. The system replaces the carrier code of the identified fare with the value entered in this field when the new fare is created. For example, if the Inclusion has carrier 01 coded and you want to change the carrier to 02, so the Carrier field on the Changes portion would be coded with 02.
Tariff	This is an editable field that is not required and defaults to blank when the screen is first opened. Type up to seven alphanumeric characters in this field, or click the Tariff field label to open the Tariff dialog box where you can search through a list of valid tariff codes. This field is used to change the tariff that is associated with the fare that is being added. The system replaces the tariff of the identified fare with the value entered in this field when the new fare is created.

Change Type = Restore

In addition to the fields described above, the following fields will also display when the Change Type is Restore.

Field Name	Field Description
Restore To	This radio button is the default selection. Selecting this radio button restores the fare to the sequence indicated in the selection criteria.
Restore Before	Select this radio button to restore to the sequence effective prior to the sequence identified in the selection criteria.
Effective Date	The default value is DDMMMYY (the date format, if you want to manually enter a date). Click the Calendar button to select a date from the Calendar dialog box. This date is used as the effective date of the restored fare. The system will attach the effective date entered in this field to the change results. If this field is left blank, the program uses the effective date provided when the results are submitted to a batch.

Change Type = Cancel

In addition to the fields described above, the following fields will also display when the Change Type is Cancel.

Field Name

Field Description

Effective Date

The default value is DDMMMYY (the date format, if you want to manually enter a date). Click the Calendar button to select a date from the Calendar dialog box.
This date is used to provide the effective date of the canceled fare.
The system will attach the effective date entered in this field to the canceled fare on the change results.
If this field is left blank, the program uses the effective date provided when the results are submitted to a batch.

Change Type = Copy and Change to New

The Copy and Change to New option copies transactions according to criteria selected in the Inclusion and Exclusions group boxes and pastes that information into a new batch. You can change the components of the associated copied transactions, or leave these fields blank.

The fields have the same descriptions as discussed above.

Change Type = Copy as is

The Copy as is option copies transactions according to criteria selected in the Inclusions and Exclusions group boxes and pastes that information into a new batch. The program retains all components of the fare from the original batch.