This dataset provides information per reserved resources (e.g. booked resources in a reservation like bikes, extra beds or ...).
Attribute | Definition |
|---|
Distribution Channel | | Distribution Channel Brand | If used in MXTS, the brand of the distribution channel | | Distribution Channel Level 1 |
The distribution channel through which the reservation of the resource was made. Level 1 - 5 depends on the tree-structure in MXTS | | Distribution Channel Level 2 | | Distribution Channel Level 3 | | Distribution Channel Level 4 | | Distribution Channel Level 5 | | Distribution Channel Type | Type of the distribution channel (e.g. Direct, Touroperator or Reseller) |
|
End Date | | End Date | The actual end date of the Reserved Resource (e.g. When people return rented bikes on the 27th of April, the End Date will be 27-04-2019) | | End Date Day of Week | The day of the week the reservation will end | | End Date ISO Week | The ISO week in which this date is classified | | End Date ISO Year | The ISO year in which this date is classified | | End Date Month | The month the reservation will end | | End Date Quarter | The quarter the reservation will end | | End Date Year | The year the reservation will end |
|
Ledger | | Ledger | Name of the ledger to which the revenue of the resource is linked to | | Ledger Number | The number of the ledger to which the revenue of the resource is linked to |
|
Location | | Location Country | Country in which the accommodation (is relation to the reserved resource) is located | | Location Level 1 |
Location level as classified in MXTS tree-structure (1 - 5 is possible) | | Location Level 2 | | Location Level 3 | | Location Level 4 | | Location Level 5 |
|
Reservation | | Reservation | Number of the reservation to which the resource is linked | | Reservationcategory | If used, the categorie of the reservation, for example the source of the reservation (by phone, e-mail or website) |
|
Reservation Date | | Reservation Date | The exact date the reservation was created | | Reservation Date Day of Week | The day of the week the reservation was created | | Reservation Date ISO Week | The ISO week in which this date is classified | | Reservation Date ISO Year | The ISO year in which this date is classified | | Reservation Date Month | The month the reservation was created | | Reservation Date Quarter | The quarter the reservation was created | | Reservation Date Year | The year the reservation was created |
|
Reservation Duration | | Reservation Duration | This is the number of days between the End Date and the Start Date | | Reservation Duration Interval 30 Days | The 30-days interval in which the duration is classified. For example: A reservation duration of 8 days is in this attribute classified in the interval 1 - 30 days | | Reservation Duration Interval 5 Days | The 5-days interval in which the duration is classified. For example: A reservation duration of 8 days is in this attribute classified in the interval 6 - 10 days | | Reservation Duration Interval 7 Days | The 7-days interval in which the duration is classified. For example: A reservation duration of 8 days is in this attribute classified in the interval 8 - 14 days |
|
Reservation Lag | | Reservation Lag | The number of days between the actual reservation date and actual arrival date. This way you can see how many days in advance your customers are making a reservation. | | Reservation Lag Interval 30 Days | The 30-days interval in which the reservation lag is classified. For example: A reservation lag of 33 days is in this attribute classified in the interval 31 - 60 days | | Reservation Lag Interval 5 Days | The 5-days interval in which the reservation lag is classified. For example: A reservation lag of 33 days is in this attribute classified in the interval 31 - 35 days | | Reservation Lag Interval 7 Days | The 7-days interval in which the reservation lag is classified. For example: A reservation lag of 33 days is in this attribute classified in the interval 29 - 35 days |
|
Reserved Resource | | Payer Type | The type of the payer for the reserved resource (e.g. Agent or Customer) | | Resource Status | The status of the resource (e.g. Cancelled, Checked out, Declined of Definitive) |
|
Resource | | Accommodation Kind | Accommodation kind of accommodation in case if resource is an Accommodation or Accommodation Type | | Resource | Name of the reserved resource | | Resource Level 1 |
The level of the resource as classified in MXTS (1 - 5 possible) | | Resource Level 2 | | Resource Level 3 | | Resource Level 4 | | Resource Level 5 | | Resource Type | Type of the resource (e.g. Accommodation, Accommodation Type, Extra, Product, Composition or Special) |
|
Resource Group | | Resource Group Level 1 |
The group level to which the resource belongs (1 - 5 is possible) | | Resource Group Level 2 | | Resource Group Level 3 | | Resource Group Level 4 | | Resource Group Level 5 |
|
Start Date | | Start Date | The actual start date of the Reserved Resource (e.g. people check in on 20th of April, but bike rental will start at the 21st of April. Start Date is 21-05-2019) | | Start Date Day of Week | The day of the week the reservation will start | | Start Date ISO Week | The ISO week in which this date is classified | | Start Date ISO Year | The ISO year in which this date is classified | | Start Date Month | The month the reservation will start | | Start Date Quarter | The quarter the reservation will start | | Start Date Year | The year the reservation will start |
|
Metric | Definition |
|---|
Final Internal Price | Total net turnover of all booked accommodations in this reservation, meaning the gross price of the booked accommodations minus specials and included reserved resources. |
Invoice Amount | The total price of the reserved resource on the bill. In case there is provided a price override by the user then such price override is used, otherwise the calculated total price. |
Number of Adults | Number of Adults that are linked to the reservation. Age >/= 18 years |
Number of Babies | Number of Babies that are linked to the reservation. Age < 2 years |
Number of Children | Number of Children that are linked to the reservation. Age >/= 2 years and < 12 years |
Number of Persons | Number of Persons that are linked to the reservation. Not depending on age |
Number of Pets | Number of Pets that are linked to the reservation |
Number of Resources | The number of resources booked irrespective of quantity.
If in a particular reservation 2 bikes and 4 bicycles are booked, then Number of Resources will be 2 |
Number of Teens | Number of Teens that are linked to the reservation. Age >/= 12 years and < 18 years |
Quantity | Quantity of the Reserved Resource e.g. number of bikes that is rented |
Resource Turnover | Contribution of each booked reserved resource to the turnover of the accommodation turnover/reservation turnover. If the reservation is declined there is no resource turnover. The total resource turnover per reservation is also known as the "base deduction sum" used in owner settlements. |
Sleeper Nights | Sleeper Nights are Number of Persons multiplied by Reservation Duration |
