Sunshine travel agency

LN-central

cologne-news sales agency Bonn

cologne-news sales agency Solingen
On all levels can be stored a contract, the contract will be searched bottom up until a contract will be found.
In all agencies there can be stored a parent agency. There are different types of belonging and different time tables so that the storing of the data are in a grid.

Type of agency The entry in the field type of agency is for orientation in the hierarchy tree of assignments. Is the value chain header, then this agency is the first one in the tree. When chain header or free agency is selected, then there can't be a parent assigned agency. Only when chain agency is selected, then there is the possibility to select another agency in the grid.
No sales office This agency makes no own bookings. She has only the function to store provision conditions.
From / to If there is only one value the to date can be left empty. If there should be an new entry then the to date from the first line must be filled an the date should have the value from the from date of the new line -1
Assignment This assignment has three values, "Provision", "Statistic" and "Authorization". These values are hardcoded. That means that the agency relationships don't differ for reporting's and provisions. That means that for reporting for different sales area or travel agencies the agency hierarchy can be used. The system differs between these two types. The entry "Authorization" means that the sub agency has the same rights as the chain head. It is just used for this.

Anker
_Toc227487343 _Toc227487343

Chain tree

View of the chain belonging:
132
Area 1In this area you can enter filter criteria for the display of agencies and their contracts.
Date Depending on the date the hierarchy can change, because for different dates there can be entered different assignments. This date is compared with the valid dates. The default is the current day.
Type There are three types, provision, statistic and authorization. This setting defines on which hierarchy the tree will be build. The default is provision.
Chain In this combo box are listed all agencies, which have the state chain header. After selecting one of these, only the tree of this agency will be shown. If it is empty all are shown.
Validity In this two date fields can be entered a valid period. Contracts have an own validity, so only these where the date matches will be shown in area 3.
Apply This button overtake all changes and refresh the view with the new settings.
Area 2 This area shows all assigned agencies, every point is an own address. The agency on the highest level is the chain header. Additionally there is created a entry single agencies on highest level in the tree. This one is done by the system. Within this entry there will be shown all free agencies, so all agencies which are not assigned to a chain header.
The following actions are possible:
Open agency opens the address of the agency
Search agency opens the address search for selecting one agency. After selecting one, the tree of the agency is shown.
Create contract opens the contract tree. There can be stored a new contract.
Area 3 The area (3) includes all contracts of the marked agency and all above assigned agencies. The overview in the list is supported by a filter, which doesn't show contracts, whose validity date is off the validity defined in area 1.
With a double click on a marked contract, the contract tree will open and the contract can be modified.

Anker
_Toc227487344 _Toc227487344

Contracts

A contract has different constituent parts:
Contract head contract head with contract number. A contract can have different types.
Types Head of a specific contract type. A type can have several levels.
Levels Levels of a specific contract type, which can have several entries.
Entries This entry defines the provision. There can be several entries for one level.
This leads into the following schema:

Contract head

Types

Levels

Entries