Inclusions Field Descriptions

Field Name	Field Description
Carrier	This is a required field. For non-ATPCO users, the Carrier field is pre-filled according to the user ID of the person signed on to the program. You can change default value to another carrier code. Use this field to indicate the carrier code you wish to apply to the transactions by typing up to three alphanumeric characters. Click the Carrier field label to access a list of valid carrier codes. For ATPCO users, the Carrier field defaults to blank.
Tariff	This is a required field. This field accepts up to seven alphanumeric characters; one tariff per inclusion or generic wildcard values of “Any”, “Any Public”, and “Any Private”. The tariff must match the selected Source (for example, if the selected Source is International, an international tariff must be used). Click the Tariff field label to access a list of valid tariff codes. You have the ability to access the Tariff look-up in the Inclusions section of Fares (International, US/CA, and Add-ons) and download a list of all your fare tariffs by clicking the Download button. Follow the on-screen prompts for directions regarding saving the file. When a generic wildcard value is used, the query set must only contain a single query number in the criteria set.
Fare Class/Family	This is an editable field that is not required and defaults to blank when the screen is first opened. You can type up to eight alphanumeric characters; the first character must be alpha. User defined groups (UDGs) may be employed in this field. Click the Fare Class field label to select or create a UDG using the UDG dialog box. Fare families may be typed. For example, type F- to find fare classes that begin with the letter F. This field may be used to limit the query to a specific fare class or a group of fare classes (using UDGs). Multiple single entries of fare classes, UDGs, or a combination of fare classes and UDGs may be coded in this field. Entries must be separated by a comma (for example, F, Y, +first class fares, J). This field allows for a maximum of 255 characters. Fare Family Positional Match You can match to a fare family where the alphanumeric characters listed are in specific positions. A symbol is used to match to a designated position of one or more alphanumeric characters within the fare class. Additional alphanumeric characters may or may not follow the designated alphanumeric characters. Option 1 – Whole Number Exclamation point (!) Numbers are applied as a single unit and will be treated as a whole number in the match process. Example: W!!M1! will match W21M1A or W2AM1B7 but will not match W21M17 or W2AM17B (‘W’ must be in position 1, ‘M’ must be in position 4, ‘1’ must be position 5. ‘1’ must remain a whole number; therefore, position 6 must be an alpha character). Having the ‘7’ in position 6 changes the ‘1’ to ‘17’. Option 2 – Position Only Ampersand (&) Numbers are matched as individual characters, each based on its position. Example: W&&M1& will match W21M1A, W2AM1B7, W21M17, or W2AM17B but will not match W21MA1 or W2AMB1 (‘W’ must be in position 1, ‘M’ must be in position 4, ‘1’ must be position 5. ‘1’ does not have to remain a whole number; therefore, position 6 may be an alpha or numeric character). Having the ‘7’ in position 6 does not impact the ‘1’ in position 5, each are matched individually.
Location 1 / Location 2	This is an editable field that is not required and defaults to blank when the screen is first opened. This field allows for a maximum of 255 characters. Multiple, comma separated locations may be typed. UDGs may be employed in this field. Click the Location 1 or Location 2 field labels to select a UDG or create a UDG using the UDG dialog box. When the Source is International, location codes for city, airport, nation, and IATA zone may be used. When the Source is US/CA, location codes for city, airport, and nation may be used. When the Source is Add-ons, location codes for city, airport, nation, and IATA zone may be used. This field may be used to limit the query to the specified market or groups of markets. City, airport, nation, and IATA zone code indicators are not needed and assumed. For example, if you wish to indicate C (City) LON, you just type LON.
Bi-Directional	This field displays when the Source is International. Check this box to include when the code indicated in the Location 1 field can be an origin or destination point. This box is only enabled after an entry is made in the Location 1 field. Once this box has been checked, the Location 2 field is disabled.
Also as Loc 2	This check box only displays when the Scope is US/CA. The query selects fares to/from the city entered in the Location 1 field. If LAX is coded in Location 1 field and the Also as Loc 2 box is checked, the query matches fares where LAX is the first city shown in the market pair and fares where LAX is the second city shown. This box is only enabled after an entry has been coded in the Location 1 field. Once this box has been checked, the Location 2 field is disabled. If Also as Loc 2 is checked, you cannot access the UDG Groups dialog box by clicking the Location 2 field label.
Market UDG	This is an editable field that is not required and defaults to blank when the screen is first opened. This field can only contain a UDG. Multiple UDG entries separated by commas are allowed (for example, +DFWHOU, MYMARKETS). This field allows for up to a maximum of 255 characters. Click the Market UDG field label to select or create a UDG using the UDG dialog box. When your scope is International, the market UDG will be an international market group. When your scope is US/CA, the market UDG, will be a US/CA market group. When your scope is Add-ons, the market UDG will be an Add-on market group.
FC Matching UDG	Fare Class Matching is used to create a new fare based on an existing fare. You can create a Fare Class Matching via the User Defined Groups tab or by clicking this field label in Inclusions group box (Query tab). This field can only contain a UDG. Fare Class Matching can only be used when the Scope equals International, US/CA, and Add-on. Comma separated entries are allowed.
Routing	This is an editable field that is not required and defaults to blank when the screen is first opened. This field accepts up to 255 characters. Multiple, comma separated routing numbers, UDGs, or a combination of routing numbers and UDGs may be typed in this field. UDGs may be employed in this field. Click the Routing field label to select or create a UDG using the UDG dialog box. This field may be used to limit the query to fares holding the specified routing number(s).
Add-on Zone	This field displays when the Scope is Add-on. Multiple entries, separated by commas, are allowed. This field allows for up to a maximum of 255 characters. Add-on zones consists of up to three numeric characters identifying arbitraries with the coded zone number. A hyphen (-) may also be used to indicate a match on all numbers from 0–9 in that position of the add-on zone number. Only one or two hyphens may be coded in a number; hyphens may not be used in all three positions.
Rule	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 International, or US/CA. UDGs may be entered in this field. Click the Rule field label to select or create a UDG using the UDG dialog box. You can enter one or more rule numbers, a UDG, or both. This field may be used to limit the query to fares holding the specified rule number(s). A rule consists of four alphanumeric characters. This field accepts up to 255 alphanumeric characters. This field will also accept a hyphen (-) in any position of the rule to indicate that it applies to all letter/numbers in that position. -1- - will match to 2100, 3105, or 100, but not on 1411 or 10 A- - - will match to A700 or A210, but not on 2A00 or 0A10 -23- will match to 4231 or 1234, but not on 2300 or 0123
Footnote	This is an editable field that is not required and defaults to blank when the screen is first opened. UDGs may be entered in this field. Click the Footnote field label to select or create a UDG using the UDG dialog box. This field allows for up to a maximum of 255 characters. Multiple, comma separated footnotes, UDGs, or both can be typed in this field. This field may be used to limit the query to fares holding the specified footnote(s).
Only Un-Footnoted	The default value for this check box is unchecked. This field may be used to limit the query to only fares that do not hold a footnote. Once this box has been checked, the Footnote field becomes disabled.
Find Footnote	This field may only be used when a value is present in the Footnote field. By Itself— This option is used to limit the query to only fares that hold the specified footnote and no other footnote. In Combination— This option is only available for US/CA domestic and add-on tariffs and is used to limit the query to only fares that hold the specified footnote in combination with it and either of the directional footnotes F or T. By Itself & In Combination— This option is only available for US/CA domestic and add-ons tariffs and used to limit search to fares that hold only the specified footnote and fares that hold the specified footnote in combination with it and either of the directional footnotes F or T.
Include Un-Footnoted	The default value for this check box is unchecked. This field may only be used when a value is present in the Footnote field. This field may be used to expand the query to include fares that do not hold a footnote.
Fare Type	This is an editable field that is not required and defaults to blank when the screen is first opened. This field allows for up to a maximum of 255 characters. Multiple, comma separated fare type codes may be typed in this field. Click the Fare Type field label to open the Fare Type dialog box, which allows you to select from a list of valid fare types. This field may be used to limit the query to only fares that match the specified fare type.
OW/RT	This is not required and defaults to blank when the screen is first opened. This field may be used to limit the query to only fares that are one-way or round-trip. 1—Indicates one-way fares 2—Indicates round-trip fares
Batch ID	This is not a required field for queries for source Master; however, it is required for source Transaction. This field accepts up to seven characters, where the first two are alphanumeric (generally a carrier code or ATPCO Batch ID) and the last five are numeric (indicating the batch number). Separate multiple entries in this field with commas.
Currency	This is an editable field that is not required and defaults to blank when the screen is first opened. This field may be used to limit the query to only fares that hold the specified currency code.
Effective Date	This is an editable field that is not required and defaults to blank when the screen is first opened. The default value is DDMMMYY (the date format, if you want to manually enter a date), which selects all fares with any effective date. Click the Calendar button to select a date from the Calendar dialog box. This field may be used to limit the query to only fares that hold the specified effective date.
GFS Date	This is an editable field that is not required and defaults to blank when the screen is first opened. The default value is DDMMMYY (the date format, if you want to manually enter a date), which selects all fares with any GFS date. Click the Calendar button to select a date from the Calendar dialog box. This field may be used to limit the query to only fares that hold the specified GFS date.
FAN	This is an editable field and defaults to blank when the screen is first opened. Type a valid filing advice number (FAN). This field is required for non-ATPCO users when a GFS date is provided. This field may be used to limit the query to only fares that were filed with the specified GFS filing advice. The field accepts up to three alphanumeric characters.
Read All	The default value for this check box is checked. This field may be used to expand the query to read all fares that have been cancelled, but that have not yet purged from the database. If the Read All check box is unchecked the results includes any fare with a discontinue date (including Last Sale Date) that is in effect today. If the Read All check box is checked the results includes any fare that meets the inclusion criteria of the query. Click here for an example.
Click the button, at the bottom of the Inclusions group box to display the following fields:
In Effect On Date Min	This is an editable field that is not required and defaults to blank when the screen is first opened. 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 may be used to limit the query to include fare sequences that hold effective dates no earlier than the specified date. This field must be used with the In Effect On Max field to create a date range.
In Effect On Date Max	This is an editable field that is not required and defaults to blank when the screen is first opened. 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 may be used to limit the query to include fare sequences that hold effective dates no later than the specified date. This field must be used with the In Effect On Min field to create a date range. If you are trying to isolate to a one day, then the In Effect On Date Min and Max needs to be the same date.
Last Sale Date	This is an editable field that is not required and defaults to blank when the screen is first opened. 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 may be used to limit the query to include fare sequences that hold last sale dates no later than the specified date.
Discontinue Date	This is an editable field that is not required and defaults to blank when the screen is first opened. 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 may be used to limit the query to include fare sequences that hold discontinue dates no later than the specified date.
Mileage Min/Max	This is an editable field that is not required and defaults to blank when the screen is first opened. These fields may be used to limit the query to include fares that hold mileage values above the value specified in the Mileage Min field or below the specified value in the Max field. These fields must be used together so that the query will correctly search for a mileage range.
Fare Amount Min/Max	This is an editable field that is not required and defaults to blank when the screen is first opened. These fields may be used to limit the query to include fares that hold fare amounts above the value specified in the Fare Amount Min field or below the specified value in the Max field. These fields must be used together so that the query will correctly search for a fare range.
Use Post Tax Amount	The default value for this check box is unchecked. This field displays only when the Scope is US/CA. Use of this field does not limit or expand query results. When the check box is selected, fare values will display with tax amounts included.
Validated	The default value for this check box is checked. This field displays only when the Source is Transaction. This field may be used to limit the query to include only fare transactions that have been validated.
Validated With Warnings	The default value for this check box is checked. This field displays only when the Source is Transaction. This field may be used to limit the query to include only fare transactions that have been validated.
Validated With Errors	The default value for this check box is checked. This field displays only when the Source is Transaction. This field may be used to limit the query to include only fare transactions that have been validated.
Applied	The default value for this check box is unchecked. This field displays only when the Source is Transaction. This field may be used to limit the query to include only fare transactions that have been applied against the Fare Master.
Applied With Warnings	The default value for this check box is unchecked. This field displays only when the Source is Transaction. This field may be used to limit the query to include only fare transactions that have been applied against the Fare Master but, returned with warning messages.