How to use the Tariff Search Screen
Summary:
Where to find the Tariff Search?
The tariff search can be found on the menu under 'Search' --> 'Tariff Search'
The Tariff Search screen
Search criteria for a tariff search can be specified on this screen.
The most commonly used search criteria are the departure and destination airports, the date criteria and tariff type.
Note: Leaving a field blank is interpreted as meaning ‘All’.
1. Market, Origin, Destination, Carrier
The market is predefined, depending on the account settings. When more then 1 market is assign to the account, the market has to be filled in.
Origin and Destination should be based on the 3 letter-code. When typing, a list of possible codes are displayed from which a selection may be made. To search multiple codes, the 3-letter codes should be comma-separated i.e. JFK,NRT,KIX.
The Carrier should be based on the 2 (or 3) letter code of the carrier. When typing, a list of possible codes are displayed from which a selection may be made. To search multiple codes, the 3-letter codes should be comma-separated i.e. BA,CX,EK.
Marking the checkbox in front of ‘Predefined carrier only’, the search result will only show the preferred carriers. Preferred Carriers can be set up under ‘Settings --> Preferred Carriers’. See the help section at that page for more information.
The Market, Origin and Carrier can be pre-defined in the ‘User Preferences’ which can be adjusted at ‘settings --> user preferences’. See the help section at that page for more information.
2. Date, Status, Chargeable weight (Chg wt)
The date can be adjusted to search from a date in the past or future
The status fields Active, Future and Expired can be selected to display the appropriate results.
When the chargeable weight is filled in, a column with the total freight amount will be added to the search results.
3. Keyword, Product, DGR, SHC/SCR, x-ref
These fields can be used to further refine a search based on a Keyword, the Product, the DGR column and the Special Handling codes(SHC) and/or Specific Commodity Codes(SCR).
Keyword: AFRA will limit the results to the given keyword when this keyword appears in the 'carrierproduct' field or in the remarks. This is a 'free text' field
Product: Formely named 'IMP code' Examples: GEN, ICE, AOG etc. This field can only contain specific codes and is therefore searchable, just start typing.
DGR: The default DGR is set to 'ANY' To limit searchresults, a selection from the dropdownlist can be made. Possible options: ANY, NO, CAO, PAX, PAX and CAO
SHC/SCR: AFRA supports the IATA TACT SCR numbering system for special commodity rates.
When tariffs are created in the system they can be created with either SHC or SCR codes.
Searching is possible on either SHC or SCR.
When using the checkbox underneath the field “Use SHC/SCR cross reference”, AFRA will attempt to cross reference the search criteria with the appropriate tariffs in the system.
4. Tariff-type and calculation method
The search results can be refined based on the tariff-type i.e. general rates and the calculation method i.e. Weight break or ULD. One or multiple selections can be made for each of both. When no selection is made, all types and methods will be searched for.
5. Advanced Criteria: weight and volume
The chargeable weight can be calculated by inserting dimensions or by filling in the
‘chg wt’ field manually.
The measuring units Kg/Lb and Cm/In are predefined in the ‘User Preferences’ which can be adjusted at ‘settings --> user preferences’.
These setting can be changed temporarily by clicking the icon next to the unit.
6. Advanced Criteria: Surcharges, Margins, Currency, Customers
The surcharges can be included in the total amount by selecting one or both checkboxes. If the shipment details are not inserted (see 5, weight and volume), selecting the surcharges will insert the columns with the surcharges in the search results.
A Sales Margin can be added to the buying rates by selecting a predefined sales-margin from the dropdown list. Sales-margins can be set up under ‘SettingsSales Margins’
The currency is account depended, but can be changed temporarily. A conversion will not be applied.
To search for sales rates for a specific customer, the customer field can be used.
7. Advanced Criteria: Sorting Order and Results per Page
The sorting order can be changed by using the drop-down menu. Sorting can be based on ‘calculated tariff’, ‘tariff type’, ‘preferred carrier’, ‘destination’, or ‘effective date’.
The number of search-results per page can be set to 20, 50 or 100.
The default Market, Origin, Carrier and the number of results can be pre-defined in the ‘User Preferences’ which can be adjusted at ‘settings user preferences’.
Once all criteria are set, press [search] to execute the search.
Default Settings
Depending on the settings in the user preferences the ‘search criteria’ and the ‘advanced criteria’ will collapse to enlarge the result-screen or remains expanded. Both parts can also be collapsed/expanded manually by using the ‘–‘ or ‘+’ icons at the left side of each section. User settings can be changed by the user at 'settings --> user preference'. See the help section at that page for more information.
Tariff-search results
The tariff-search results will show once the search is executed by clicking the [search] button.
Only those columns containing data will be shown on the screen.
1. On top the number of pages is displayed; use the << and >> buttons to navigating to next, previous, last or first page. The number of results shown is depending on the user preferences which can be found at settings --> user preferences.
2. The icons at tariff line level give information about the ownership and the tariff-type. When hovering the mouse over the icon, a mouse-over will display the meaning.
Ownership:
Tariff-Type:
3. A preferred carrier is printed in bold. It is possible in the extended search to have the preferred carriers displayed first.
Preferred carriers can be set up under settings --> Preferred carriers (administrators only)
Display
Airports (both at origin and destination) are displayed in 2 different ways:
a. Between square brackets. i.e [LON] This is indicating it is a city-code, which can cover one or multiple airport codes.
b. Between curly brackets. i.e. {UK1} This is indicating it is a zone-code. A zone can contain multiple airport and city codes.
b. Without any brackets. i.e. SIN. This is indicating it is an airport code or a city code without any available airport codes.
The column 'Deck' can contain 'LD' (lower deck), 'UD' (upper deck, main deck) or 'both'.
The column 'Ops' can contain 'PAX' (Passenger aircraft), 'Frtr' (cargo aircraft only) or 'both'.
The column 'DGR' can contain 'No', 'Pax', 'CAO' or 'Pax and CAO'
The above columns are only to identify if a rate is valid for a certain deck, ops or dangerous goods.
Tariff-details
To be able to view all details of a tariff, click anywhere on the tariff-line.
A new page will open, displaying the tariff, together with the information from the set such as owner- and contact information, notes, remarks and surcharges.
To view the entire set, click [Show full set]
Options
With the buttons found at the tariff-search result screen various features are available. A grey button is only applied on a selection made first, a blue button will be applied on the entire result.
1. Hovering the mouse over the grey [Copy to] button, opens a sub-menu with the option 'copy to Basket' and 'copy to New set'
To copy the tariffs to the tariff basket, select one or mulitple tariff-lines with the check-box in front of the line(s) and select [Copy to Basket]
More information on the Tariff Basket can be found at the help section on the tariff basket page (menu --> tariff basket)
2. Hovering the mouse over the grey or blue [Export to] button, opens a submenu with the options to export to a PDF, Excel or CSV file.
To export, select one set with the checkbox in front of the line - exporting multple sets is not possible - and select the desired output format.
A pop-up window will appear from which the desired template can be selected.
Click [export] and another pop-up will appear to aks if the file has to be saved or opened
