Calibre Group - Technology solutions for the travel industry
Home Travel Technology TravelCampaigner Bespoke Solutions Domains/Hosting Contact Us
You are here: Projects > ACRES > Table > LocationGeoCountry
Geographical area large than a country but smaller than a continent. e.g. The Caribbean
 
LocationGeoCountry Table
LocationGeoCountryID system allocated
LocationGeoCountryName User definable. e.g. Scandinavia
Parent Can only be from continent level or blank


At each of the location levels. There needs to be the ability to store multiple taxes that may apply to product contracts and whether those taxes are exclusive throughout the location system, exclusive at the location level or non-exclusive. Possibly use a drop down box to select which of the 3 options apply when using this feature.

A tax that is flagged as 'Location Exclusive' could only be set if there was not already a tax flag setting exclusivity for the location in question.

A tax that is flagged as 'Location Level Exclusive' could only be set if there was not already a 'Location Exclusive' or 'Location Level Exclusive' tax flag for the location in question.

A tax that is flagged as 'Non-Exclusive' could only be set if there was not already a 'Location Exclusive' or 'Location Level Exclusive' tax flag setting for the location in question.