Handling Fee

Configuration  System setting  Conditions

Attributes

Field Name	Type	Mandatory/ Default value	Description
Name	Text	Yes	Name of the handling fee table
Currency	Drop down	Yes/*	List of all defined currencies from master file. *The local currency as defined in the settings will be shown as the default.
Catalogue	Drop down	No	Catalogue for which the entry is valid. Not filled means valid for all catalogues
Type of Travel	Drop down	No	Type of Travel for which the entry is valid. Not filled means valid for all types of travel. (Statistic code Type of Travel = Statistic code 1)
Product type	Drop down	No	Product type for which the entry is valid. Not filled means valid for all destinations. ( Statistic code 6)
Transport type	Drop down	No	Drop down list of master file transport types. Not filled means valid for all transport type. (Statistic code Transport type = Statistic code 3)
Country	Drop down	No	Country for which the entry is valid. Not filled means valid for all countries. ( Statistic code 4)
Destination	Drop down	No	Destination for which the entry is valid. Not filled means valid for all destinations. ( Statistic code 2)
Requirement	Drop down	No	Drop-down with requirements types for which the line is valid. Multiple requirement types can be selected.
Product type search	Drop down	Yes	Drop down of master file product types. These are the product types that are used in the price lines The price type is only used as the price type for storing the handling fee costs in the booking. It is NOT used to check whether or not the line is valid.
Product type fee	Drop down	Yes	Drop down of master file cost types. These are the cost types that are used in the price lines. The product type is only used as the price type for storing the handling fee costs in the booking. It is NOT used to check whether or not the line is valid.
Source	Drop down	No	Drop down list with all defined booking channels. Not filled means valid for all booking channels. By selecting a channel the entry is only valid for this booking channel.
Calculation	Drop down	Yes/	Possible values: Absolute/Booking Absolute/Unit Absolute/Passenger
Costs	Numeric	Yes	Handling fee costs
Max. cost	Numeric	No	Maximum handling fee per booking
Percentage (deposit)	Numeric	No	Percentage of the fee that has to be paid with the deposit (down payment).
VAT	Drop down	No	Drop down of master file VAT (TAX). When an entry has been selected this will be used for calculation of the VAT on the handling fee.
Ignore deposit	Checkbox	/not checked	If you check this box then the general settings for the deposit will be ignored. Instead use the percentage defined in "Percentage" of the fee for the deposit
Not for Min. Age	Numeric	No	Minimum age of passenger. Fee is only valid if passenger is at least this age.
Not for Max. Age	Numeric	No	Maximum age of passenger. Fee is only valid if passenger is not older than this age.
Valid from	Date	No	First booking date for which the entry is valid. If not filled the entry is valid for all booking dates.
Valid to	Date	No	Last booking date for which the entry is valid. If not filled the entry is valid for all booking dates.
Max days bef.departure	Numeric	No	Used for Last minute fees. This fee will only be taken if the booking date is maximal X days before departure (of booking).
Valid till departure	Date	No	Last departure date for which the entry is valid. If not filled the entry is valid for all departure dates. The departure date of the service will be checked.
Valid from duration	Numeric	No	Minimum duration (of days or nights) for which the entry is valid. If not filled the entry is valid for all durations. This is the duration of a service, not of the complete booking
Valid to duration	Numeric	No	Maximum duration (of days or nights) for which the entry is valid. If not filled the entry is valid for all durations. This is the duration of a service, not of the complete booking. If empty, the fee is valid for all durations
No RRV	Checkbox	/not checked	If checked no RRV will be calculated on Handling fee
Type	Dropdown	N/ empty	Related to LIMIT. Fee is valid if the price of a service is ">","<","<=" or ">=" the Limit.
Limit	Number	N/ empty	Float value. Used in "Type"
Top	Button		Moves the priority (the line with this fee) to the top of the list.
Up	Button		Moves the priority (the line with this fee) one step up in the list.
Down	Button		Moves the priority (the line with this fee) one step down in the list.
Bottom	Button		Moves the priority (the line with this fee) to the bottom of the list.

(1) Please note that the booking functionality will take the first entry in the handling fee table that is valid for the booking that is made. Therefore the order in which the rows are stored in important (the fee on top has the highest priority). The first valid entry is used for calculation of the handling fee. For every service line in the booking the handling fee will be calculated based on this line, and only the highest will be stored. The reason for this is that the costs might need to be calculated per unit and when the booking contains 2 hotels where in the first hotel 1 room is booked and in the second hotel 2 rooms are booked the handling fee needs to be based on the 2 rooms of the second hotel.
So the calculation of the handling fee is both BOOKING related and SERVICE related.

For every service in a booking a different kind of handling could be calculated.
For the complete booking only the handling fee with the highest priority will be taken
If two handling fees with the same priority were calculated, it takes the highest fee.