pricing engine - dolphin ddownloads.dolphind.com/training/traininglibrarybmm...dolphin's...

40
Copyright © 2016 Dolphin Dynamics Ltd. The information contained herein is the property of Dolphin Dynamics Ltd. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or any means electronic or mechanical, including photocopying and recording fo of Dolphin Dynamics Ltd. Dolphin Dynamics Ltd. 162-164 Upper Richmond Road London, SW15 2SL www.dolphind.com Pricing Engine

Upload: dinhliem

Post on 23-Jun-2018

232 views

Category:

Documents


0 download

TRANSCRIPT

Copyright © 2016 Dolphin Dynamics Ltd.

The information contained herein is the property of Dolphin Dynamics Ltd. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in anyform or any means electronic or mechanical, including photocopying and recording foof Dolphin Dynamics Ltd.

Dolphin Dynamics Ltd.162-164 Upper Richmond RoadLondon, SW15 2SLwww.dolphind.com

Pricing Engine

Dolphin Dynamics Ltd Confidential 2

Table of ContentsGlossary of Abbreviations........................................................................................................................3

Glossary of New Names ..........................................................................................................................3

Introduction ..............................................................................................................................................5

Activation..................................................................................................................................................5

Configuration Steps .................................................................................................................................5

Structure of a Travel Folder .....................................................................................................................7

Pricing Engine Logic ................................................................................................................................8

Initiation of the Pricing Engine .................................................................................................................9

Automatic Initiation ...............................................................................................................................9

Manual Initiation ...................................................................................................................................9

Dolphin's Reservation Module and Pricing Engine ............................................................................10

Pricing Engine Setup .............................................................................................................................11

Categories..............................................................................................................................................11

Categories Configuration....................................................................................................................11

Category Types ..................................................................................................................................12

Rules ......................................................................................................................................................12

Rules Configuration............................................................................................................................12

Prioritising Rules within Categories....................................................................................................14

Conditions Configuration........................................................................................................................14

Actions ...................................................................................................................................................14

Update Actions ...................................................................................................................................14

Insert Actions......................................................................................................................................17

Product DB Duration Unit Category.......................................................................................................21

Cancellation Conditions Category .........................................................................................................23

Credit Card Fee Category......................................................................................................................26

Item Level Category...............................................................................................................................27

Pricing Level Category...........................................................................................................................29

Folder Level Category............................................................................................................................30

Pricing Profile Codes .............................................................................................................................30

Mark-up Codes.......................................................................................................................................31

Contract Cancellation Codes .................................................................................................................33

Condition Types Tables .........................................................................................................................34

Dolphin Dynamics Ltd Confidential 3

Glossary of AbbreviationsTerm / Abbreviation Definition

BMM booking management module

LCC low cost carrier

RM reservation module

Glossary of New NamesVersion 16.5 andAfter

Version 16.3 and Before

BOOKING CREATION

Res Window Opening the Reservation Module (RM) in a new window within theBooking Management Module (BMM)

Booking Engine Consumer Booking Engine (CBE)Reseller Booking Engine

Dynamic Packaging Anchored Packaging

Predefined Packaging (PDP)

BOOKING MANAGEMENT

Res View Reservation View - Opening the RM within a tab of the travel folderdialog

Manage View Management View Viewing the BMM travel folder in its defaultview

Booking Import Interfacing Creating/Updating folders via files from the BookingImport QueueData Capture

Booking Import Queue Interface Box

Vendor Booking UpdatePage

Mini Extranet

My Account Manage My Booking (MMB)Web Customer Service (WCS)

Task List Inbox - the window that lists a user's tasks

Task List Profile Inbox Profile - the profile where the workflow query templates toapply and columns to display are configured

Workflow QueryTemplate

Inbox Query Template - the query templates to build rules for autopopulating the Task List

Dolphin Dynamics Ltd Confidential 4

COMMUNICATION

Marketing Campaigns Marketing Campaign Module

Vendor Comms Vendor Communications

PRICING

Multicurrency Sales Foreign currency Sales

Pricing Engine Dolphin Pricing Engine (DPE)Dolphin Pricing & Preferencing Engine (DPPE)

PAYMENT

Corporate Cards Lodge cards

Corporate Card Export Lodge Card ExportCredit Card Export

Payment Gateway Payment Service Provider (PSP)

AUTOMATION

Bulk Customer Docs Bulk Printing

Auto Booking Import Auto PNRAuto Interfacing

Linked Remarks Auto remarks

Windows Service Dolphin Windows Service

Scheduled Tasks Robotic Tasks

CONNECTIONS

Product DB Product Database (PDB, DPD)

Product Connector Data Source

Supplier Connection - the wordname of the connector (example Expedia Connector)

Res API XML Booking EngineWeb ServicesXML web services

Admin API Booking Management Module (BMM) 2 Way APIWeb Services 2 Way API

OTHER

Content Sync Hotel Vendor Sync (HVS)

Web Publishing Web Publishing Module (WPM)

Dolphin Dynamics Ltd Confidential 5

IntroductionThe pricing engine is a module based on rules that trigger an automated update of pricings (pricingengine) and allow the configuration of preferencing rules against your vendors and/or data sources(preferencing engine).

The pricing engine can calculate vendor and customer deposits or add additional pricings such as feesor discounts. It works by comparing pricings against a list of configured rules and performing updateactions or insert actions, depending on the criteria of the rule. Update actions can be configured to allowtactical discounts, commissions, or deposits, which would contradict normal amounts from yourvendors.

For example, you may have a special incentive on a water bungalow room in the Maldives from a certainvendor. For departures between 1st October and 31st October, you will receive an additional 3%commission; the vendor will give a discount of £150 per room and will only require a deposit of £50,rather than the normal £100 per person. This can be manually driven or you can configure thesechanges under one rule that will apply automatically.

The pricing engine provides a greater focus on the sales aspect of the booking, rather than thecalculations of commissions, discounts, fees, and deposits.

This section will provide you with systematic instructions to set up these rules and how they interactwithin both the booking management module and the reservation module.

PrerequisitesThe pricing engine must be activated in the database. For further information, contact Dolphin DynamicsHelpdesk.

ActivationTo activate this functionality, you need to contact Dolphin Dynamics and you might incur in additionalfees.

Configuration StepsBranch SetupTo use the pricing engine rules to calculate customer deposits based on the vendor requirements, youmust configure the branch details screen for the appropriate branches within the database.

To set a pay now amount, go to Options > Site Details > Branch 1 tab

The checkbox Allow Pay Now Amount allows you to set a pay now amount within a rule in the pricingengine.

To display pricing engine fees after the originating item, go to Options > Site Details >Branch 1 tab

Dolphin Dynamics Ltd Confidential 6

This adds the fee originated by the pricing engine after the item to which the rules applied.

Vendor SetupTo set up a vendor so that the pricing engine rules run automatically on an originating pricing, go to theFinancial 1 tab of the vendor profile, and select the Use DPE check box.

Selecting this box will turn off the functionality to set a fixed deposit amount per passenger or apercentage deposit/balance amount and calculate deposit amount on sell price facilities.

Therefore, you must create the appropriate rule in the pricing engine to ensure that the correct vendordeposit/balance payments are taken.

You will still be able to set the applicable date rules within the vendor profile for both balance and depositpayments.

ExampleThe following example shows that the deposit is required at time of booking with the balance 28 daysbefore the segment date.

Although the pricing engine will be able to use a list of rules to calculate the commission on theoriginating pricing (which is a pricing line that the pricing engine did not scan yet), you can still set theunder-lying commission level that will be automatically calculated. If the segment pricing then falls withinthe boundaries of a pricing engine rule that contains an update action based on commission, thecommission will be overwritten with the pricing engine rule.

User SetupSeveral levels of security restrict the ability to add, delete or edit the pricing rules.

To activate the pricing engine for users, a supervisor level user will need to select a combination of thefollowing settings for each user.

Go to Options > Security > Access/Updates tab, and select the following:

Dolphin Dynamics Ltd Confidential 7

Can Edit Pricing Rules This setting allows the user to fully configure and edit rules within the pricingengine (once selected, it will auto select the Can Add/Delete Pricing Rules setting).

Can Add/Delete Pricing Rules This setting allows the user only to add or delete rules alreadyconfigured within the pricing engine.

Can Edit Pricing Engine Pricings/Fees/Discounts This setting allows the user to amend pricescreated/updated by the pricing engine within a travel folder.

Restrict Pricing Rule Access to Multi-Branch Filter This setting restricts the user to view only thepricing engine rules related to the branch/es they have access to.

Structure of a Travel FolderTo have a full understanding of the working of the pricing engine it is necessary to know how a travelfolder is constructed.

A folder has links to client and/or company or agent profiles.

A folder contains Items (or segments) for Air Tickets, Hotels, Car Hire, Cruise etc.

Dolphin Dynamics Ltd Confidential 8

An item (segment) contains pricing lines that make up the overall item price, i.e. per room per night,room supplement, board supplement, etc.

Pricing Engine LogicTo effectively load rules into the pricing engine, it is necessary to understand the logic behind it. Belowis a diagram showing the path that an originating unit (which is an item not yet processed by the pricingengine) will take through the engine with an example of the rule conditions and the resultant action ifthe rule is matched.

Dolphin Dynamics Ltd Confidential 9

In this example, there are five categories, each of a different type. Every category contains rules andthe number of rules can vary. The originating unit will move down each one looking for a match. Oncea match is made within each category, an action (update or insert action) will be performed and the unitwill move on to the next category.

For the rule to apply, all conditions within the rule must match. Therefore, the more specific the rule isthe higher priority it should have.

ExampleThe folder has BA flights from London Heathrow to New York JFK. Within the pricing level categorytype called Vendor Mark-ups, the more specific rule concerning BA BSP tickets has higher priority thanthe rule concerning BSP tickets. This ensures that the correct 25% mark-up will apply to the BA tickets.If the rule concerning BSP tickets had higher priority, the item would have matched this rule howeverproviding you with 20% mark-up amount.

We would suggest that prior to entering the rules into the booking management module, you first createa diagram like the one above, detailing all your rules and categories, as this will help in the constructionof the rules and the configuration of the conditions.

Initiation of the Pricing EngineAutomatic InitiationIf the pricing engine is turned on, it will run against any originating units that have been created. Thepricing engine will run automatically at the following points:

When a folder is confirmed from cost quote to normal folder

When a folder is interfaced from the booking import queue.

When a new segment is created manually and the user returns to the Pricing tab (provided thevendor for that segment has Use DPE checked in the Vendor profile > Financial 1 tab)

When a customer financial document i.e. booking confirmation, receipt, refund, invoice, credit note)is printed (any method, email, window, printer)

The pricing engine will check for rule matches against any unit that has not already been flagged ashaving run through the pricing engine. A unit that has been through the engine will be flagged to notautomatically run again even if no insert or update actions were taken.

Manual InitiationPricing tabTo force a manual run of the pricing engine on all un-flagged units in a folder, click on the Price FolderItems button at the bottom-left of the pricing tab.

Individual Segment tabsTo manually run the pricing engine on an individual segment, the same button appears in the segmentas well. However, it will only run the pricing engine against the pricing lines in this segment.

Any unit that has been flagged as run through the pricing engine will generate a message to verifywhether the pricing engine should run again or not.

New pricing lines inserted by a previous action of the pricing engine will not be flagged and so willbe available to run through the pricing engine; therefore, it is essential that rules created should beconfigured to not capture these Insert actions unless absolutely required. For example, you shouldconfigure rules so that any fees or discounts created by the pricing engine will not be run throughthe pricing engine again.

Any update action pricings will not run again through the pricing engine. This is because thecalculations are compounding, therefore the dynamic pricing (a pricing line that has been scannedby the pricing engine) would become an originating pricing (a pricing line that has not been scannedyet by the pricing engine), then it is updated again to become a dynamic pricing again. As the initial

Dolphin Dynamics Ltd Confidential 10

originating pricing is not stored in the database, it would not be possible to reset back to the originalstate before the pricing engine was run initially therefore any pricing that is updated will automaticallyget stopped from passing through the pricing engine again.

ExampleTo demonstrate the effects that the pricing engine has on segment pricings, we will use the HiltonSummer 12 Special rule. This has been set with the following actions:

To apply an update action to the commission rate setting to 15.00%

To apply an Insert action adding a vendor pricing line as -5.00% of the originating price i.e. £25discount

To assign a deposit level of 25% of the value to be paid to the vendor

Once the pricing engine is executed, either manually or automatically the dynamic pricings and itemsshow as:

As you can see the originating pricings are amended with

The commission level being set to 15%

An additional pricing line of a £25 non-commissionable discount

A deposit of £118.75 (25% of £475).

Dolphin's Reservation Module and Pricing EngineThe pricing engine works with the reservation module; however, you will need to configure the rules inthe booking management module.

Dolphin Dynamics Ltd Confidential 11

If you configured preferencing rules, the ranking will apply to the order in which products display in thereservation module search results screen.

The pricings shown on any search results page will automatically run through the pricing engine beforedisplaying and the breakdown of the prices can be displayed simply by clicking on the price hyperlink.

Depending on the source of the prices, the breakdown will show the following pricing lines: any insertactions pricings generated by the pricing engine, the adult fare, adult tax, child fare, child tax, infantfare, and infant tax.

After completing the travel folder, once you are ready to go through to the booking stage on thereservation module, the pricing engine will force through the deposit/balance payment based on therules within the pricing engine. Therefore, the amount required at the time of booking will be correct asper the vendor requirements.

If you configured cancellation conditions rules, they will be visible by clicking on the cancellationconditions hyperlink and they will overwrite any cancellation policy loaded in the product DB contract orin the vendor profile.

Pricing Engine SetupTo configure the pricing engine, go to Search > Pricing Engine and you will find the following options:

Categories They determine a type of action that rules will trigger. Each category will start a differentaction therefore you will choose a category depending on the action you want to trigger.

Rules Each rule includes a list of criteria to be met for the rule to apply and the action that will betriggered.

Profiles Pricing profile codes can be associated to customer profiles to include or exclude themfrom pricing engine rules.

Markup Codes Mark-up codes can be associated to product DB contracts and hotel vendor profilesto include or exclude them from pricing engine rules.

CategoriesCategories Configuration1. Go to Search > Pricing Engine > Categories.

2. To add a category, in the Pricing Rule Category Search screen, click the Add button.

3. In the Add Pricing Rule Category window, enter the following:

Category Name You can specify the category name (for clarity, using simple and descriptive nameshelps maintain the rules in the database).

Order to Apply You can specify the order the pricing engine will run the categories (i.e. all rules incategory 1 then all rules in category 2 and so on). However, the product DB duration unit and thecancellation conditions category types are always processed first and second respectively.

Level The level or category type at which you would like the category to search (cancellation conditions,credit card fee, folder, item, pricing, and product DB duration unit).

Note: Dolphin Dynamics strongly recommend that you have no more than five categories configured,as this can slow down the response times of searches launched in the reservation module. It is alsorecommended to carefully configure product DB duration unit category type rules.

Dolphin Dynamics Ltd Confidential 12

Category TypesThere are six category types available in the pricing engine:

Product DB Duration Unit: this category only applies to product DB hotels and others. It allowsyou to apply an additional mark-up and/or commission to each unit of a stay. The unit can differ:for example, some contracts will be based on a daily rate (therefore the mark-up and/orcommission is added to each day of the stay) and others on a weekly rate (therefore the mark-up and/or commission is added to each week of the stay).

Cancellation Conditions: this category only applies to land products booked and cancelled inthe reservation module. It allows you to setup the supplier cancellation fee based on their termsand conditions.

Credit Card Fee: this category applies to both booking management and reservation module. Itallows you to setup debit and/or credit card fees so that Dolphin automatically calculates andadds them to the booking at the time of issuing a receipt using the credit/debit card paymentmethod.

Item: this category allows you to calculate and apply sector fees (based only on air segmentsrelated criteria) and to configure preferencing rules that will affect the hotel search results inreservation module.

Pricing: this category applies to both booking management and reservation module. It allowsyou primarily to setup rules that will update pricing lines with a mark-up, commission, and/or split

pricing lines related criteria.

Folder: this category applies to both booking management and reservation module. It allows youto add a fee or a discount to folders based on folder related criteria.

Each category will be assigned a priority so that you can decide in what order actions should take place.However, the product DB duration unit and cancellation conditions categories always apply first andsecond respectively.

The pricing engine processes each originating unit once only, except for the cancellation conditionscategory. This is the only category processing a unit that potentially the pricing engine alreadyprocessed at the time of booking.

RulesRules ConfigurationOnce you have configured your categories and any necessary pricing profile code, contract mark-upcode or cancellation code, you can configure your pricing engine rules.

1. Go to the Search > Pricing Engine > Rules. The Pricing Rules search screen opens.

Dolphin Dynamics Ltd Confidential 13

2. If you have any rules already configured, you can search by Rule Name, Category and/orFinancial Vendor, Pricing Profile Code, Contract Code or Markup Code and CancellationCode. Alternatively, pressing the spacebar followed by <Enter> will display all configured rulesin the database.

3. To add a new rule, click on the Add button. The default Add/Edit Pricing Rule window opensand you can now fill the appropriate fields:

Rule Name Enter an appropriate and distinctive name for the rule.

Category Specify which category this rule belongs to (press F4, for lookup screen).

Dolphin Dynamics Ltd Confidential 14

Conditions Define the list of criteria that must match for the rule to apply. Use Add to add new filters,Retrieve to amend any and Delete to remove them. Multiple filters of the same type can be used andthese will be grouped together as an OR query i.e. only one of these filter conditions must match forthe rule to be applied.

Actions Select the actions to take against the originating unit, if the conditions above match fully. Seealso Update Actions.

Insert Actions Define the actions that will result in a new pricing line in either the segment or the folder.See also Insert Actions.

The options Discount or Fee will add a new discount or fee within the folder whereas Vendor Pricingwill add a new pricing line within the item.

Once you have configured the rule as required, click on OK to save this to the database.

You can then configure more rules and/or prioritise them in the Category list. The pricing engine willonly apply one rule per category and will apply the first match within each category, therefore the morespecific the rule the higher the priority it should be given.

Prioritising Rules within CategoriesOnly one rule per category can be applied to each originating unit. Where multiple and differing rulesneed to be applied to a unit, then you must use more than one category.

ExampleHere you will see that two similar rules have been configured using the pricing category. The secondrule is slightly more specific as it is for upgraded rooms, as opposed to any room type.

You may want this to have a higher priority in the pricing engine so that this rule is applied if theconditions match rather than the generic summer special rule as this may not update/insert pricingscorrectly if processed first.

To move a rule up and down the priority list, click on the rule and then click the appropriate Up or Downbutton as required.

Conditions ConfigurationDepending on the category, no condition is mandatory or at least one condition per rule must beconfigured.

1. In the Add/Edit Pricing Rule screen, click Add next to the Conditions area.

2. In the Pricing Rule Condition window, select the Condition Type from the drop-down menufollowed by the Must Match type. This will either be a drop-down menu if a code within the bookingmanagement module, free-text if a description or a true/false selection. It is also possible to createa negative condition by selecting the check box.

Notes:

For more information on the various conditions, see the Condition Types table.

ActionsUpdate ActionsUpdate actions allow you to update the buy/commission/split commission/sell values of existing pricinglines.

There are several configurable update actions within the pricing engine:

Dolphin Dynamics Ltd Confidential 15

Calc Commission Adjusts the commission that a vendor gives you to a pre-set percentage or amount.

Calc Markup Adjusts the mark-up earned on a net pricing to a pre-set percentage or fixed amount.

When a fixed amount is entered, the Apply and Add To dropdown menus appear below the Mark-upAmt/Unit field.

When a percentage is entered, the Treat Markup Percentage As Margin check box appears to theright of the Markup Amt/Unit or % field.

When ticked, this means that the pricing engine interprets the percentage that was entered as thedesired margin to be achieved by the mark-up. For example, if a you enter 10% this means that youwant the pricing to be marked up sufficiently that the margin you earn represents 10% of the total sell.

When unticked, the pricing engine interprets the percentage as a mark-up percentage and multipliesthis by the buy amount to determine the mark-up amount.

Calc Split Commission Supports calculating split commission either as commission or as a mark-up.When ticked, a Commission Amt/Unit or % field appears to the right of this check box. This is whereyou should enter a VAT exclusive amount or percentage to be applied to the pricing after the CalcCommission and Calc Markup actions have been applied.

Calc Agent Mark-up When ticked, a Mark-up Amt/Unit or % field appears to the right of this checkbox. This is where you should enter a VAT exclusive amount or percentage to be added to the amountthe resale agent is obliged to pay to the branch.

ExampleIf the pricing has a buy amount of 100, a commission amount of 20 and a split commission of 5, thenthe resale agent is due to pay the agency 100+20 5=115, and the traveller is due to pay the resaleagent 120.

If you entered 10% as the agent mark-up % in this example, then the Pricing engine will calculate theagent's mark-up as 11.50, which will replace the split commission of 5 with 11.50 and will increase thecommission amount to 26.50 so that the resale agent is still due to pay 115 to the branch but the travelleris due to pay 126.50 to the resale agent.

The Treat Mark-up Percentage As Margin check box appears to the right of the Mark-up Amt/Unitor % field.

When ticked, this means that the pricing engine interprets the percentage that was entered as thedesired agent margin to be achieved by the agent mark-up.

Calc Resale Agent Commission Allows you to configure a new update action on resale folders:Calculate split commission or agent mark-up which will accept a percentage or amount. The user willbe able to specify whether they want the amount to be treated as a commission or mark-up.

Calc Deposit Adjusts the deposit required by the vendor to a pre-set percentage or amount.

Calc Cust Pay Now Allows a pre-deposit amount to be paid to secure a booking. (This can be doneonly if the check box Allow Pay Now Amount has been selected in the Branch Details window.)

Calc Points Allows setting the points value of the segment in question. For more information on usingpoints, see the section about points calculation in the booking management module online help.

Cap Points Allows setting a capped points value.

Dolphin Dynamics Ltd Confidential 16

Apply Search Rank Allows the configuration of ranking rules. This setting will be available only whena rule is assigned to an item level category type.

Note: It is not necessary to have each one of the calculations active.

ExampleThe following example shows the update actions and how they can be set:

Note: Negative pricings can be set for both commission and mark-up but this is rare as it would resultin your company losing money on the booking.

The Calc Commission, Calc Markup, Calc Vendor Deposits and Calc Cust Pay Now actions dictatethat the pricing should be adjusted to have 15% commission applied, a mark-up of 10% per unit, thevendor requires a £50 deposit and your business requires a £20 pay now amount.

The Calc Cust Pay Now update action will act as a pre-deposit amount and may be used if you wouldlike to accept a lower deposit from your customer than your site details would normally permit, perhapsif your agency would like to encourage sales during a promotional period.

For example, your standard deposit is £75, but for a limited period you would like to offer a reduceddeposit of £20 per person. This does not affect existing Inbox reminders for deposit and balancepayments, it merely allows you to receive a lower than normal deposit on the understanding that the fulldeposit amount will be paid soon after.

For a pay now amount to appear in the payments section of the travel folder, you will first need to tickthe following setting: Allow pay now amount (in the Branch 1 tab pf the branch details).

Once you have configured your pay now amount in the pricing engine, then you will see the pay nowvalue in the payment section of the Travel Folder > Pricing tab.

Notes:

You will also need to ensure that deposit rules are set up in the vendor profile. If you have chosento use the pricing engine to calculate deposits, then ensure that you have set up a rule in the pricingengine to calculate your standard deposits.

If you have not set up a Vendor deposit amount in the vendor profile, or configured a pricing enginerule to do the same, then the Calc Cust Pay Now function will not work, as it is designed to becapped at no more than the standard deposit amount. Therefore, if you have not configured a depositamount, then the booking management module will assume that zero deposit is required for thisVendor, and therefore any pay now amount will be capped at zero.

When the Calc Vendor Deposit check box is selected, you will also see the option Inherit VendorDeposit Calc. This means that your pay now amount will be the same as the minimum depositrequired by the vendor specified in the rule you are creating. This means that although you areaccepting a reduced deposit, you would not risk any financial liability if the customer cancels beforepaying the full deposit or balance.

Dolphin Dynamics Ltd Confidential 17

Insert ActionsInsert actions allow you to insert a new pricing line either into an item or a folder based on the categorythe rule belongs to.

1. In the Add/Edit Pricing Rule screen, click Add next to the Insert Actions area.

2. In the Add/Edit Pricing Action window, enter details according to the selected insert action.

Vendor Pricing

Insert Select Vendor Pricing in the dropdown.

Description Add the required description which will appear on the pricing line.

Pricing Item Lookup Click this button to retrieve the Pricing Item Search window to search for andselect a pre-loaded pricing description.

Calculate Sell as % of Originating Pricing Select to use a percentage of the originating pricing orremove the % in the Sell % for a flat amount (negative for discount, positive for fee and including a0.00 sell amount when

Comm/Buy Calc Method Select the applicable option from this dropdown.

Select Inherit Comm % From Originating Pricing if you wish to use the same commissionrate on the new pricing line as on the originating pricing. Select Calc Fixed Comm%/Amountto display the Comm Amt/Unit or % field and to enter a commission amount.

Select Calc Fixed Buy %/Amount to display the Buy Amt/Unit or % field and enter the buyprice (i.e. when the sell is 0.00 and you want to enter the buy price, no commission is involved).

Inherit Units From From the drop down list select the unit to enable the vendor pricing calculation.

To multiply the vendor pricing by a specific number of times, select Specified Number andenter the number in the No of Units field. For example, the vendor charges you £8.50 flat perbooking, select Specified Number and enter 1 in the No of Units field. The pricing engine willadd a £8.50 vendor fee to the item.

To multiply the vendor pricing by the number of originating units, select Originating Pricing(the No of Units field disappears). For example, the vendor charges you £1.50 booking fee pernight. You sold a ten-night stay (the hotel segment Pricing tab indicates ten units). SelectOriginating Units and the pricing engine will add a £15 vendor fee (£1.50X10 nights) to theitem.

To multiply the vendor pricing by the number of passengers in the folder, select Fold Pax Count(the No of Units field disappears). For example, the vendor charges you £10 booking fee perpassenger in the folder. The folder contains 4 passengers. Select Fold Pax Count and thepricing engine will add a £40 vendor fee (£10X4) to the item.

To multiply the vendor pricing by the number of non-connecting flights in the folder>AirSegments tab, select Non-Connecting Flight Count (the No of Units field disappears). Forexample, the airline charges you a £2.50 administration fee per ticket per non-connecting flight.There are two tickets in the folder and 2 non-connecting flights in the air segments tab. Select

Dolphin Dynamics Ltd Confidential 18

Non-Connecting Flight Count and the pricing engine will add a £5 administration fee per ticket(£2.50X2) to the item.

To multiply the vendor pricing by the number of passengers in the folder by the number of non-connecting flights in the folder > Air Segments tab, select Fold Pax Count X Non-ConnectingFlight Count (the No of Units field disappears). For example, the airline charges you a £2.50administration fee per ticket per passenger per non-connecting flight. There are two tickets inthe folder and 2 non-connecting flights in the air segments tab. Select Fold Pax Count X Non-Connecting Flight Count and the pricing engine will add £10 administration fee per ticket(£2.50X2X2) to the item.

Remove When Originating Pricing Is Cancelled or Deleted This check box will ensure that shouldthe original pricing be cancelled or deleted, this new Insert action line is also cancelled/deleted as nolonger applicable.

Inherit Package State From Originating Pricing This final check box will ensure that if the originatingpricing line is included in a package the new pricing line will be packaged as well.

Note: The amount inserted as vendor pricing is always in the branch currency, it will never be in thevendor currency.

Note: Vendor pricing insert actions appear as an additional pricing line within the original segment inthe travel folder > Itinerary tab.

Note: Vendor pricing insert actions can only be configured within a rule that belongs to a pricing levelcategory type.

Example

This example would create a new pricing line with the description booking fee, adding a value of £0.00sell price, with the company absorbing £5 buy price.

Discount

Insert Select Discount in the dropdown.

Product Code Select or add a product code from the pre-configured codes in the database (right clickyour mouse or press F4, for lookup screen).

Dolphin Dynamics Ltd Confidential 19

Discount Visible only if Insert Action>Discount has been chosen. Select or add a discount reasoncode from the pre-configured codes in the database (right click your mouse or press F4, for lookupscreen). This is not mandatory, unless in Options > Site Details > Branch 1 > the Require DiscountReason check box is selected.

Description The description of the discount code will appear in this field.

Calculate Sell as % of Originating Pricing Select to use a percentage of the originating pricing orremove the % in the Sell % for a flat negative amount.

Comm/Buy Calc Method Select the applicable option from this dropdown.

Select Inherit Comm % From Originating Pricing if you wish to use the same commissionrate on the new pricing line as on the originating pricing.

Select Calc Fixed Comm%/Amount to display the Comm Amt/Unit or % field and to enter acommission amount.

Select Calc Fixed Buy %/Amount to display the Buy Amt/Unit or % field and enter the buyprice (i. e. when the sell is 0.00 and you want to enter the buy price, no commission is involved).

Inherit Units From From the drop down list select the unit to enable the discount calculation.

To multiply the discount by a specific number of times, select Specified Number and enter thenumber in the No of Units field. For example, you want to discount a flat amount of £8.50 perbooking, select Specified Number and enter 1 in the No of Units field. The pricing engine willdiscount the folder by £8.50.

To multiply the discount by the number of originating units, select Originating Pricing (the Noof Units field disappears). For example, you want to discount a hotel rate by £10 per night. Yousold a ten-night stay (the hotel segment Pricing tab indicates ten units). Select OriginatingUnits and the pricing engine will discount the folder by £100 (£10X10 nights).

To multiply the discount by the number of passengers in the folder, select Fold Pax Count (theNo of Units field disappears). For example, you want to discount £20 per passenger in thefolder. The folder contains 4 passengers. Select Fold Pax Count and the pricing engine willdiscount £80 (£20X4).

To multiply the discount by the number of non-connecting flights in the folder>Air Segmentstab, select Non-Connecting Flight Count (the No of Units field disappears). For example,you want to discount £5 per ticket per non-connecting flight. There are two tickets in the folderand 2 non-connecting flights in the air segments tab. Select Non-Connecting Flight Countand the pricing engine will apply £10 discount per ticket (£5X2).

To multiply the discount by the number of passengers in the folder by the number of non-connecting flights in the folder>Air Segments tab, select Fold Pax Count X Non-ConnectingFlight Count (the No of Units field disappears). For example, you want to discount £5 perticket per passenger per non-connecting flight. There are two tickets in the folder and 2 non-connecting flights in the air segments tab. Select Fold Pax Count X Non-Connecting FlightCount and the pricing engine will apply £20 discount per ticket (£5X2X2).

Remove When Originating Pricing Is Cancelled or Deleted This checkbox will ensure that shouldthe, this new insert action line is also cancelled/deleted as no longer applicable.

Inherit Package State From Originating Pricing This final check box will ensure that if the originatingpricing line is included in a package the new pricing line will be packaged as well.

Note: Discount insert actions can only be configured within a rule that belongs to a pricing or folderlevel category type.

Dolphin Dynamics Ltd Confidential 20

Example

This example would create a new folder pricing line with the description discount, taking a value of 20%of the original sell price, making this a discount.

Note: Discount insert actions appear as agency discounts in the Pricing tab of the travel folder.

Fee

Insert Select Fee in the dropdown.

Product Code Select or add a product code from the pre-configured codes in the database (right clickyour mouse or press F4, for lookup screen).

Description The description of the fee code will appear in this field.

Calculate Sell as % of Originating Pricing Select to use a percentage of the originating pricing orremove the % in the Sell % for a flat negative amount.

Comm./Buy Calc Method Select the applicable option from this dropdown.

Select Inherit Comm % From Originating Pricing if you wish to use the same commissionrate on the new pricing line as on the originating pricing. Select Calc Fixed Comm%/Amountto display the Comm Amt/Unit or % field and to enter a commission amount.

Select Calc Fixed Buy %/Amount to display the Buy Amt/Unit or % field and enter the buyprice (i. e. when the sell is 0.00 and you want to enter the buy price, no commission is involved).

Inherit Units From From the drop down list select the unit to enable the fee calculation.

To multiply the fee by a specific number of times, select Specified Number and enter thenumber in the No of Units field. For example, you charge the customer £8.50 flat per booking.Select Specified Number and enter 1 in the No of Units field and the pricing engine will adda £8.50 vendor fee to the travel folder.

To multiply the fee by the number of originating units, select Originating Pricing (the No ofUnits field disappears). For example, you want to charge the customer £1.50 booking fee pernight. You sold a ten-night stay (the hotel segment Pricing tab indicates ten units). SelectOriginating Units and the pricing engine will add a £15 fee (£1.50X10 nights) to the travelfolder.

Dolphin Dynamics Ltd Confidential 21

To multiply the fee by the number of passengers in the folder, select Fold Pax Count (the Noof Units field disappears). For example, you want to charge the customer £10 booking fee perpassenger in the folder. The folder contains 4 passengers. Select Fold Pax Count and thePricing engine will add a £40 fee (£10X4) to the travel folder.

To multiply the fee by the number of non-connecting flights in the folder>Air Segments tab,select Non-Connecting Flight Count (the No of Units field disappears). For example, youwant to charge the customer a £2.50 administration fee per ticket per non-connecting flight.There are two tickets in the folder and 2 non-connecting flights in the air segments tab. SelectNon-Connecting Flight Count and the pricing engine will add a £5 administration fee per ticket(£2.50X2) to the travel folder.

To multiply the fee by the number of passengers in the folder by the number of non-connectingflights in the folder>Air Segments tab, select Fold Pax Count X Non-Connecting FlightCount (the No of Units field disappears). For example, you want to charge the customer a£2.50 administration fee per ticket per passenger per non-connecting flight. There are twotickets in the folder and 2 non-connecting flights in the air segments tab. Select Fold Pax CountX Non-Connecting Flight Count and the Pricing engine will add £10 administration fee perticket (£2.50X2X2) to the travel folder.

Remove When Originating Pricing Is Cancelled or Deleted This checkbox will ensure that shouldthe, this new Insert action line is also cancelled/deleted as no longer applicable.

Inherit Package State From Originating Pricing This final check box will ensure that if the originatingpricing line is included in a package the new pricing line will be packaged as well.

Note: Fee insert actions appear as agency fees in the Pricing tab of the travel folder.

Note: Fee insert actions can only be configured within a rule that belongs to a pricing or folder levelcategory type.

Product DB Duration Unit CategoryOverviewThe aim of this category is to add a small mark-up and/or commission to the standard mark-up/commission to each unit of a hotel stay separately, based on the dates of the stay. This categoryalways processes each unit first and as soon as a rule matches a unit, the pricing engine processes thenext unit until they are all processed. For example, for a stay of 7 days based on a daily rate, the pricingengine will process each night applying a mark-up/commission amount per applicable night.

ActivationTo activate this type of category, the following setting Use DPE for Duration Unit Mark-Ups must beselected within the contract loaded in the product DB:

Dolphin Dynamics Ltd Confidential 22

Selecting the Pricing Rules button will open the Add/Edit Pricing Rule dialogue box from within thecontract.

The checkbox Force Reprice When Customer Changes is invisible if the Use DPE for Duration UnitMarkups checkbox is not ticked in the contract. This checkbox should only be ticked if the contract hasproduct DB duration unit category rules configured against it and these rules include customer relatedconditions (namely pricing profile codes).

Definition of a unitA unit is equivalent to the duration set within a hotel/other product type contract. The unit shown in thefollowing example tells us that this is a nightly product, which means that you can have a different mark-up for each night (one night is equivalent to one unit):

Note: If the duration unit is set to 7, it means that rates are loaded in multiples of 7 nights; therefore,you would be able to attract a different mark-up per 7 nights.

Construction of rulesAs no conditions are mandatory for this type of category, if you do not add any then this category willprocess all product DB hotels and other products.

Dolphin Dynamics Ltd Confidential 23

Variable mark-ups based on the remaining inventoryTo allow a different mark-up to be applied to each room night based on the remaining inventory for thatnight, the mark-up rules will need to be created using the Product Database Duration Unit category.This is because the two conditions labelled Remaining Inventory Amount and Remaining Inventory% are only available against pricing engine rules that belong to the product DB duration unit categorytype.The Remaining Inventory Amount condition can be configured with a remaining inventory amountrange. The Must Be Between fields support an amount value.The Remaining Inventory % condition can be configured with a remaining inventory percentage range.The Must Be Between fields support a percentage value.

Cancellation Conditions CategoryOverviewThis category applies only to products booked and cancelled in the reservation module/booking engine.

when a product DB booking is cancelled, Dolphin will calculate and apply the supplier cancellationcharge, if applicable, depending on how many days prior to check-in the cancellation takes place.

pricing engine to ensure that the cancellation charge calculation is correct and automated.

Rules configured within the cancellation conditions category type are used to calculate the cancellationcharge from the vendor to your business (i.e. the buy amount of the cancellation charge). However, itis also possible to use the pricing engine to configure normal mark-up rules to mark-up the cancellationcharge and obtain the customer cancellation fee.

This category always processes each cancelled segment after the product DB duration unit categorytype (if there is one configured). The first rule whose conditions match the originating unit will apply andthen the pricing engine moves to the next category. Only one rule per cancellation conditions categorycan apply to each unit.

ActivationTo activate this category, select the setting Use DPE To Calculate Cancellation Charge in thereservation module: Settings > Supplier > Cancellations > click on the Edit hyperlink of the supplieryou want to setup:

Include Cancellation Charges In Printing Notes In Booking Management Module Select this checkbox to include the vendor cancellation policy in the printing notes tab of the travel folder

Suppress Vendor Cancellation Policy Select this check box if you do not wish to display the vendorcancellation policy in the cancellation conditions hyperlink available in the reservation module travelfolder.

Dolphin Dynamics Ltd Confidential 24

Definition of a unitA unit is equivalent to a pricing line within a cancelled segment.

Construction of rulesOne of the following three conditions must be specified:

Financial vendor name

Pricing description

Product code

Contract cancellation code

As there is no pricing line to be updated, only insert actions can be configured and these are referredto as cancellation conditions.

The below rule has been configured to apply cancellation charges to every product booked from thehotel contracts loaded in the product DB.

Below is an example of how to configure cancellation conditions:

Below are examples of how the cancellation charges are configured:

This cancellation fee applies from the day the customer is expected to check in up to next cancellationcondition date band. The cancellation charge is based on 100% of the total sell. If there is no othercancellation condition configured, Dolphin will understand that the fee applies any time the booking iscancelled as there is no date band specified.

If we then add the following cancellation condition, the customer will be charged 80% of the total sell ifthey cancel from 1 day before their expected check in date up to the next cancellation condition dateband. This also means that the previous cancellation condition is limited to customers who cancel theirbookings on their expected check in day -

Dolphin Dynamics Ltd Confidential 25

To define the vendor cancellation charges, it is necessary to configure more cancellation conditions:

Finally, to specify that from 30 days prior to the check in date there is no charge, it is necessary toconfigure a rule like the one below:

These cancellation charges will be displayed in the reservation module by clicking on the CancellationConditions hyperlink of the item booked:

Dolphin Dynamics Ltd Confidential 26

Note: The Vendor Cancellation Policy Details refer to the Contract Cancellation Policy loaded inthe contract or to the cancellation charge details that some data sources directly pass to the reservationmodule.

How to mark-up vendor cancellation chargesIf you wish to mark-up the vendor fee, you must setup a pricing level category type rule as in the belowexample:

Credit Card Fee CategoryOverviewOnly one rule can apply: when all the conditions within a rule find the perfect match, the pricing engineapplies the rule and then moves to the next category.

ActivationThis category will be activated as soon as one category of this type will be configured with at least onerule.

Definition of a unitA unit is equivalent to the amount entered in the This Receipt field of a receipt.

Construction of rulesUse the condition Transaction Credit Card Code to add a credit card fee related to a specific creditcard provider and the condition Transaction is Debit Card to apply the rule to debit cards.

Note: If you use the Multicurrency Sales module, the condition Transaction Currency Code allowsyou to setup multiple credit card fees based on the customer currency.

Only insert actions can be configured because the purpose of this category is to add a new pricing lineto the travel folder indicating the credit card fee.

Dolphin Dynamics Ltd Confidential 27

In the Insert Actions area of the rule, click Add to add the fee calculation:

Product Code Right click with your mouse and select Lookup or press F4 on your keyboard to retrievethe Product Codes Search window. In the Product Code Search window search for the product coderelated to the credit card fee you are configuring and click Use.Description The fee description will auto populate in this field.

Calculate Sell as % of Transaction Amount Select this check box if the credit card fee is a

Sell% Type the credit card fee amount as a percentage of the sell.

Comm/Buy Calc Method From the dropdown select Fixed Comm %/Amount (to display the CommAmt/Unit or % field and enter the commission percentage/amount) or Fixed Buy %/Amount (to displaythe Buy Amt/Unit or % field and enter the buy percentage/amount).

Note: You will be able to edit this field only if the fee is configured to allow the buy price.

Inherit Units From Always leave this dropdown to Specified Number.No of Units Always leave 1 in this field.

Example of credit card fee charged to and absorbed by the travel agency but not charged to the customer

Item Level CategoryOverviewOnly one rule can apply: when all the conditions within a rule find the perfect match, the pricing engineapplies the rule and then moves to the next category.

ActivationThis category will be activated as soon as one category of this type will be configured with at least onerule.

Dolphin Dynamics Ltd Confidential 28

Definition of a unitA unit is equivalent to a segment in the air segments tab.

Construction of rulesOne of the following three conditions must be specified:

Financial vendor name

Membership type

Product code

Only insert actions can be configured because this category applies only to segments in the airsegments tab, where there is no pricing line that can be updated.

Sector Fees ConfigurationOverviewIt is possible to use the pricing engine to setup sector fees. This is done by configuring a rule within anitem level category type, which allows adding one fee/discount line per air segment to the pricing tab ofthe travel folder.

The number of seats stated within an air segment or the number of passengers in the segmentrespectively determine the unit quantity on these fees/discounts.

Further, if you have a flight from LON to SYD with three segments, then in the fare breakdown you seethree lines of 1.50, as the rule is an item level rule. Because there are three air segments, each of whichis considered a unit to be processed by the pricing engine, three matching rules are applied.

Examples of conditions to construct rules for sector feesWhere Item Type = AIR,

Item Itinerary Vendor = BA,

Item First Booking Class Code = F, A, J, C, D, I, W, T, Y, B, H, etc.

This fee will be set with a unit price of £1.50

Configuration of insert actions to setup the sector fees amountBelow is an example of how to setup the sector fee amount:

Product Code Select or add a product code from the pre-configured codes in the database (press F4,for lookup screen)

Description The description of the discount/fee code will appear in this field.

Sell Amt/Unit Enter a fixed amount for the fee/discount.

Inherit Units from Originating Items Pax Count The number of units is inherited from the number ofseats field within an air segment. This will allow a flat fee/discount to be charged per seated passengeron each air segment. Therefore, if there were three adults traveling on an air segment, the fee appliedwould be (£1.5 x 3) so £4.50 for that segment, if the sell price is £1.50.

Remove When Originating Pricing Is Cancelled or Deleted This checkbox will ensure that shouldthe, this new Insert action line is also cancelled/deleted as no longer applicable.

Dolphin Dynamics Ltd Confidential 29

Inherit Package State From Originating Pricing This final check box will ensure that if the originatingpricing line is included in a package the new pricing line will be packaged as well.

Note: The Pricing engine will prevent users from saving a rule where they have selected Inherit Unitsfrom Originating Pax Count but have not specified an item type condition that restricts the rule beingapplied to those products that have a passenger count within a segment, i.e. hotel, tour, cruise or other.

PreferencingOverviewThe preferencing engine allows the configuration of ranking rules against your reservation modulevendors/data sources with a variety of conditions (i. e. folder branch codes or customer pricing profilecodes).

The ranking will decide the order in which products display in the reservation module search resultsscreen, so that specific vendors display first (highest ranking=1), while others display further down inthe list (default ranking=5) or do not display at all (lowest ranking=10). It is possible to assign the sameranking value to more than one vendor.

If no specific ranking is configured, the search results are deemed to have the default rank of 5.However, if ranking is configured, the matching preferencing rule will determine the order in which thesearch results are presented. Any vendor and/or product connector with a rank of ten will be excludedfrom the display.

ActivationThis feature is only available when a rule is assigned to an item level category type. Preferencing rulescan be added in a dedicated category or can be combined with existing rules in an item category typethat triggers sector fees.

Construction of preferencing rulesNo condition is mandatory, however for the rule to work you should specify the item itinerary vendorand/or the item booked via.

Only when a rule is assigned to an item level category type, the following checkbox is available:

By selecting this check box, you will be able to select the ranking value of one to ten from a drop downlist.

Pricing Level CategoryOverviewOnly one rule can apply: when all the conditions within a rule find the perfect match, the pricing engineapplies the rule and then moves to the next category.

ActivationThis category will be activated as soon as one category of this type will be configured with at least onerule.

Definition of a unitA unit is equivalent to a pricing line.

Construction of rulesOne of the following four conditions must be specified:

Financial vendor name

Pricing description

Dolphin Dynamics Ltd Confidential 30

Membership type

Product code

Both update and/or insert actions can apply

Folder Level CategoryOverviewOnly one rule can apply: when all the conditions within a rule find the perfect match, the pricing engineapplies the rule and then moves to the next category.

ActivationThis category will be activated as soon as one category of this type will be configured with at least onerule.

Definition of a unitA unit is equivalent to a travel folder.

Construction of rulesNo conditions are mandatory and only insert actions apply, because there is no pricing information in afolder.

Below is an example of how fees can be configured at folder level:

This example would add a set folder fee of 15GBP. The Inherit Units From drop down menu allowsyou to select the unit to enable the fee calculation.

Pricing Profile CodesOverviewThis feature allows linking a pricing profile code to many client, company and/or agency profiles loadedin the database. This would allow you to restrict a rule to a specific set of customers by using thecondition Customer Pricing Profile Code.

The condition Customer Pricing Profile Code is available in any pricing engine rule assigned to allcategory types apart from the cancellation conditions category type.

This approach is particularly efficient if you sell to other travel agencies, with whom you share your profitdepending on the volume of bookings they generate to your business. If you divide your agencies intosplit commission bands (for example: A=5%, B=3.5%, C=2%, D=1.5%, E=1%) and you create a pricingprofile code per band, you can then assign such code to the relevant agency profile. Each time you adda new agency profile to Dolphin, you just need to enter the correct pricing profile code and the rule willstart working immediately.

Configuration1. Click Search > Pricing Engine > Profiles.

2. To add a profile, in the Pricing Profile Search screen, click the Add button.

Dolphin Dynamics Ltd Confidential 31

3. In the Add Pricing Profile window, enter the following:

Code The pricing profile code which you wish to apply to certain client, company, or agency profileswithin your database. The code must be alphanumeric with a maximum of five characters.

Description An alphanumeric description of this code, e.g. the client, company, or agency name/s thatthis pricing profile relates to.

View Rules When a pricing profile code has been added as a condition in a rule, you will be able toclick on the View Rules button to view the relevant rules loaded in the pricing engine.

ActivationOnce the pricing profile codes are created, it is also necessary to assign any pricing profile codes youset up to the relevant client, company, or agent profiles. This is done by entering the correct pricingprofile code to individual client, company and/or agency profiles in the Other Info tab > Pricing Profilefield:

Mark-up CodesOverviewThis feature allows you to directly link a pricing rule to multiple contracts loaded in the product DB or tohotel (and only hotel) vendor profiles via a mark-up code rather than creating a rule, hence reducingthe number of rules you need to maintain.

This approach is particularly efficient if multiple contracts and/or suppliers are subject to the same mark-up and/or commission band as you can group them up via the mark-up code, rather than creating a ruleper contract and/or vendor.

The condition Pricing Mark-up Code is available in any pricing engine rule assigned to one of thefollowing category types: item, product DB duration unit and pricing.

Configuration1. Click Search > Pricing Engine > Markup Codes.

2. To add a mark-up code, in the Markup Code Search screen, click the Add button.

3. In the Add Markup Code window, enter the following:

Code The mark-up code which you wish to apply to specific product DB contracts and/or vendorprofiles. The code must be alphanumeric with a maximum of five characters.

Dolphin Dynamics Ltd Confidential 32

Note: It is recommended to use generic mark-up codes bands (i. e. A/B/C/D/E) rather than the actualcommission/mark-up percentage (20, 15, etc.). This is because if you need to change thecommission/mark-up percentage, you can amend the percentage/amount in the rule without the codebeing misleading. Otherwise, if you change the mark-up/commission percentage/amount in the rule,you might want to create a new mark-up code as well as to avoid confusion.

Description An alphanumeric description of this code, e.g. the commission/mark-up band this mark-upcode relates to.

View Rules When a mark-up code has been added as a condition in a rule, you will be able to click onthe View Rules button to view the relevant rules.

ActivationOnce the mark-up code and the relevant pricing level category type rule are created, this feature canbe activated by assigning the mark-up code to the contract in the Settings tab > Markup Code field:

Or to a hotel vendor profile > Financial 1 tab:

Dolphin Dynamics Ltd Confidential 33

Contract Cancellation CodesOverviewThis feature allows to directly link a single set of cancellation conditions to many contracts loaded in theproduct DB.

Cancellation conditions can be configured in the pricing engine as a one-off exercise adding thecondition that they only apply to a specific contract cancellation code.

Configuration1. Click Search > Product DB > Contract Cancellation Codes.

2. To add a cancellation code, in the Cancellation Code Search screen, click the Add button.

3. In the Add Cancellation Code window, enter the following:

Code The cancellation code which you wish to apply to specific contracts within your product DB. Thecode must be alphanumeric with a maximum of five characters.

Description An alphanumeric description of this code, e.g. the client, company, or agency name/s thatthis pricing profile relates to.

View Rules When a cancellation code has been added as a condition in a rule, you will be able to clickon the View Rules button to view the relevant rules.

ActivationOnce the cancellation code and the relevant cancellation conditions category type rule are created, thisfeature can be activated by assigning the contract code to the contract in the Add/Edit CancellationPolicy dialog box > Cancellation Code field:

Dolphin Dynamics Ltd Confidential 34

Condition Types TablesProduct DB Duration Unit

Condition Definition

Availability Type Determines on which basis the product is being sold, i.e. free sell, onrequest, etc.

Contract Code The contract code allocated to the contract.

Markup Code The mark-up code that links a percentage commission band to manycontracts, instead of creating one rule per vendor.

Customer Pricing ProfileCode

The pricing profile code assigned within the client/company/agent profile.

Customer Type Determines whether the customer is an agent A, client C or a company- Y

Duration Unit Start Date This is the date on which the Duration Unit starts.

Duration Unit Total Amount(inc. VAT)

This is the total amount of the Duration Unit cost including VAT.

Extras Combo Code The code used to link the extras to a product in a contract.

Folder Branch Code The code of the branch where the folder was created.

Item Duration Days/nights duration of the item.

Item End Country Code The country code of the destination point of the item.

Item End Country Group The country group which includes the country code of the destination pointof the item. You will need to set country groups up in advance.

Item Financial Vendor The incoming agent/vendor that you pay for the segment or ticket.

Item Itinerary Vendor The vendor of the item that the traveller interacts with, i.e. the hotel namerather than the incoming agent or the hotel chain being paid.

Item Meal Plan Code The meal code of the hotel, tour, or cruise segment.

Item Product Code The product code of the item from the product codes list, i.e. CCF for CreditCard Charge Fee.

Item Product Description The description of the item, i.e. Credit Card Charge Fee.

Item Room Type Code The room type code of the item as shown on the contract.

Item Start Country Code The country code of the departure point of the item.

Item Start Country Group The country group which includes the country code of the start/departurepoint of the item. You will need to set country groups up in advance.

Item Start Date This is the date on which the item starts, such as the hotel check-in dateor the car hire pick-up date.

Item Start Point Code The departure point code of the item, such as the departure point of theticket or the car hire pick-up location.

Item Type The type of item (see Item Product Type Codes below).

Pricing Description The description of the pricing item, i.e. Per Room Per Night, Car Rental,Airport Transfers.

Remaining InventoryAmount

The remaining number of products on allocation.

Dolphin Dynamics Ltd Confidential 35

Remaining InventoryPercent

The remaining percentage of products on allocation.

Request date The date on which the request is submitted to the pricing engine.

Request Staff Code The user who submitted the request to the pricing engine.

Cancellation ConditionsCondition Definition

Contract Cancellation Code The Contract Cancellation Code allocated to the contract.

Item Booked Date This is the date that the item was booked on.

Item Booked Via The name of the reservation system in which the item was booked.

Item Financial Vendor The incoming agent/vendor that you pay for the segment or ticket.

Item Itinerary Vendor The vendor of the item that the traveller interacts with, i.e. the hotel namerather than the incoming agent or the hotel chain being paid.

Item Product Code The product code of the item from the product codes list, i.e. CCF for CreditCard Charge Fee.

Item Product Description The description of the item, i.e. Credit Card Charge Fee.

Item Start Date This is the date on which the item starts, such as the hotel check-in dateor the car hire pick-up date.

Item Type The type of item (see Item Product Type Codes below).

Pricing Description The description of the pricing item, i.e. Per Room Per Night, Car Rental,Airport Transfers.

Item categoryCondition Definition

Client Membership Number The membership number allocated to the customer in their profile.

Client Membership Type The membership type specified in the client's profile (Profile tab).

Markup Code The mark-up code that links a percentage commission band to manycontracts, instead of creating one rule per vendor.

Customer Has Credit Determines whether the customer has an active and available credit limit.

Customer Pricing ProfileCode

The pricing profile code assigned within the client/company/agent profile.

Customer Type Determines whether the customer is an agent A, client C or a company- Y

Folder Branch Code The code of the branch where the folder was created.

Folder Creation Date The creation date of the folder.

Folder Destination CountryCode

Determines the destination country code of the folder.

Folder Domestic Tkt Count Determines the number of Domestic Tickets in a folder to which the rulewill apply.

Folder Group Code Determines whether the folder has a Folder Group Code on the folder.

Folder International TktCount

Determines the number of International Tickets in a folder to which the rulewill apply.

Dolphin Dynamics Ltd Confidential 36

Folder Non-stopover Air SegCount

Determines the number of non-stopover air segments in a folder to whichthe rule will apply.

Folder Pax Count Determines the number of passengers in a folder to which the rule willapply.

Folder Staff Code The user who created the item, segment, or folder.

Folder Status Name The Folder Status Code that is on the folder.

Item Banking Branch The banking branch assigned to the user at the time they originally createdthe item.

Item Booked Date The date the item was booked

Item Booked Via The name of the reservation system in which the folder item was booked.

Item Brochure Code The brochure code specified in tour segments.

Item Duration Days/nights duration of the item.

Item End Country Code The country code of the destination point of the item.

Item Country Group The country group which includes the country code of the destination pointof the item. You will need to set country groups up in advance.

Item End Point Code The item destination point code, such as the destination of the ticket or thecar hire drop-off location.

Item Financial Vendor The incoming agent/vendor that you pay for the segment or ticket.

Item First Booking ClassCode

The class code specified on the ticket, or the first segment of the ticket,the room type code, car type or train class.

Item Is Domestic Travel Determines whether the Is Domestic check box has been ticked on theitem.

Is Net Fare Determines whether the Net fare check box has been ticked on the ticket.

Item is Outbound Flight Determines whether the item is an outbound flight.

Item Is Payable To BranchCC Ticket

Determines whether the Payable to Branch check box has been selectedin the ticket.

Item Is Refund Determines whether the item has been generated by creating aticket/segment refund.

Item is Voided Determines whether an item has been voided i.e status of --

Item Itinerary Vendor The vendor of the item that the traveller interacts with, i.e. the hotel namerather than the incoming agent or the hotel chain being paid.

Item Meal Plan Code The meal code of the hotel, tour or cruise segment.

Item Passenger Type The ticket passenger type, i.e. ADT, CHD or INF.

Item Points Payment Code The payment code assigned when entering the points value.

Item Product Code The product code of the item from the product codes list, i.e. CCF for CreditCard Charge Fee.

Item Product Description The description of the item, i.e. Credit Card Charge Fee.

Item Start Country Code The country code of the departure point of the item.

Item Start Country Group The country group which includes the country code of the start/departurepoint of the item. You will need to set country groups up in advance.

Item Start Date This is the date on which the item starts, such as the hotel check-in dateor the car hire pick-up date.

Dolphin Dynamics Ltd Confidential 37

Item Start Point Code The departure point code of the item, such as the departure point of theticket or the car hire pick-up location.

Item Ticket Type The type of the ticket, i.e. TKT, EKT, MPD, MCO.

Item Type The type of item (see Item Product Type Codes below).

Item Vendor Doc Is Issued Determines whether the item has a ticket or voucher number assigned toit.

Request date The date on which the request is submitted to the pricing engine.

Request Staff Code The user who submitted the request to the pricing engine. .

Ticket Has Been Exchanged Determines whether the ticket has been exchanged for another ticket.

Ticket is an Exchange Determines whether the ticket is an exchange ticket.

Ticket Source Code The code used to link a fee that is charged to a customer for an air ticket.

Pricing categoryCondition Definition

Client Membership Number The membership number allocated to the customer in their profile.

Client Membership Type The membership type specified in the client's profile (Profile tab).

Markup Code The mark-up code that links a percentage commission band to manycontracts, instead of creating one rule per vendor.

Customer Has Credit Determines whether the customer has an active and available credit limit.

Customer Pricing ProfileCode

The pricing profile code assigned within the client/company/agent profile.

Customer Type Determines whether the customer is an agent A, client C or a company- Y

Folder Branch Code The code of the branch where the folder was created.

Folder Creation Date The creation date of the folder.

Folder Destination CountryCode

Determines the destination country code of the folder.

Folder Domestic Tkt Count Determines the number of domestic tickets in a folder to which the rule willapply.

Folder Group Code Determines whether the folder has a folder group code on the folder.

Folder International TktCount

Determines the number of international tickets in a folder.

Folder Non-stopover Air SegCount

Determines the number of non-stopover air segments in a folder to whichthe rule will apply.

Folder Pax Count Determines the number of passengers in a folder to which the rule willapply.

Folder Staff Code The user who created the item, segment, or folder.

Folder Status Name The folder status code that is on the folder.

Item Banking Branch The banking branch assigned to the user at the time they originally createdthe item.

Item Booked Date The date the item was booked

Dolphin Dynamics Ltd Confidential 38

Item Booked Via The name of the reservation system in which the folder item was booked.

Item Brochure Code The brochure code specified in tour segments.

Item Duration Days/nights duration of the item.

Item End Country Code The country code of the destination point of the item.

Item Country Group The country group which includes the country code of the destination pointof the item. You will need to set country groups up in advance.

Item End Point Code The item destination point code, such as the destination of the ticket or thecar hire drop-off location.

Item Financial Vendor The incoming agent/vendor that you pay for the segment or ticket.

Item First Booking ClassCode

The class code specified on the ticket, or the first segment of the ticket,the room type code, car type or train class.

Item Is Domestic Travel Determines whether the Is Domestic check box has been ticked on theitem.

Item Is Net Fare Determines whether the Net fare check box has been ticked on the ticket.

Item is Outbound Flight Determines whether the segment is an outbound flight.

Item Is Payable To BranchCC Ticket

Determines whether the Payable to Branch check box has been selectedin the ticket.

Item Is Refund Determines whether the item has been generated by creating aticket/segment refund.

Item is Voided Determines whether an item has been voided i.e. status of --

Item Itinerary Vendor The vendor of the item that the traveller interacts with, i.e. the hotel namerather than the incoming agent or the hotel chain being paid.

Item Meal Plan Code The meal code of the hotel, tour, or cruise segment.

Item Passenger Type The ticket passenger type, i.e. ADT, CHD or INF.

Item Points Payment Code The payment code assigned when entering the points value.

Item Product Code The product code of the item from the product codes list, i.e. CCF for creditcard charge fee.

Item Product Description The description of the item, i.e. credit card charge fee.

Item Start Country Code The country code of the departure point of the item.

Item Start Country Group The country group which includes the country code of the start/departurepoint of the item. You will need to set country groups up in advance.

Item Start Date This is the date on which the item starts, such as the hotel check-in dateor the car hire pick-up date.

Item Start Point Code The departure point code of the item, such as the departure point of theticket or the car hire pick-up location.

Item Ticket Type The type of the ticket, i.e. TKT, EKT, MPD, MCO.

Item Type The type of item (see Item Product Type Codes below).

Item Vendor Doc Is Issued Determines whether the item has a ticket or voucher number assigned toit.

Pricing Description The description of the pricing item, i.e. Per Room Per Night, Car Rental,Airport Transfers.

Dolphin Dynamics Ltd Confidential 39

Pricing Is Packaged Determines whether the pricing line has been included in as part of apackage in the folder.

Pricing Is Payable to Branch Determines whether the pricing is to be payable to the branch or directlyto the vendor (True - when set to be payable to the branch, False - whenset to be paid direct to the vendor).

Pricing Total buy amount(inc VAT)

The total buy value of the Pricing Item.

Pricing Total Comm. amount(excl. VAT)

The total value of the commission in the pricing item.

Pricing total sell amount (incVAT)

The total sell value of the pricing item.

Request date The date on which the request is submitted to the pricing engine.

Request Staff Code The user who submitted the request to the pricing engine. .

Ticket has been Exchanged Determines whether the ticket has been exchanged for another ticket.

Ticket is an Exchange ticket Determines whether the ticket is an exchange ticket.

Ticket Source Code The code used to link a fee that is charged to a customer for an air ticket.

Folder categoryCondition Definition

Client Membership Number The membership number allocated to the customer in their profile.

Client Membership Type The membership type specified in the client's profile (Profile tab).

Customer Has Credit Determines whether the customer has an active and available credit limit.

Customer Pricing ProfileCode

The pricing profile code assigned within the client/company/agent profile.

Folder Branch Code The code of the branch where the folder was created.

Folder Creation Date The creation date of the folder.

Folder Destination CountryCode

Determines the destination country code of the folder.

Folder Domestic Tkt Count Determines the number of domestic tickets in a folder.

Folder Group Code Determines whether the folder has a Folder Group Code on the folder.

Folder International TktCount

Determines the number of international tickets in a folder.

Folder Non-stopover Air SegCount

Determines the number of non-stopover air segments in a folder which areto be charged in a pricing engine rule.

Folder Pax Count Determines the number of passengers in a folder to which the rule willapply.

Folder Staff Code The user who created the item, segment, or folder.

Folder Status Name The folder status code that is on the folder.

Request date The date on which the request is submitted to the pricing engine.

Request Staff Code The user who submitted the request to the pricing engine. .

Dolphin Dynamics Ltd Confidential 40

Credit Card Fee categoryCondition Definition

Client Membership Type The membership type specified in the client's profile (Profile tab).

Customer Pricing ProfileCode

The pricing profile code assigned within the client/company/agent profile.

Customer Type Determines whether the customer is an agent A, client C or a company- Y

Transaction Amount The amount entered in the This Receipt field of a receipt.

Transaction Branch Code The code of the branch where the receipt is created.

Transaction Creation Date The creation date of the receipt.

Transaction Credit CardCode

The code of the credit card used to issue the receipt.

Transaction Currency Code The currency code of the receipt.

Transaction Is Debit Card The credit card used to issue the receipt is a debit card.

Transaction Is Lodge Card The credit card used to issue the receipt is a lodge card.

Transaction Payment Type The payment type selected for the receipt (balance, deposit, etc.).

Item TypesCode Definition

HOT HOTEL

AIR AIR SEGMENTS

CAR CAR HIRE

INS INSURANCE

TUR TOUR/TOUR OP PACKAGE

OTH OTHER i.e. Airport Parking

TKT AIR TICKET

FEE FEE

DIS DISCOUNT

CRU CRUISE

RAI RAIL