...
This dataset provides information per reserved resources (ie.eg. 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 |
|
exact 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 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 |
|
exact actual start date of the Reserved Resource (e.g. people check in on 20th of April, but bike rental |
|
wil 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 |
Invoice Amount | Amount the customer get's invoiced for reserving the resourceTotal 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 12 10 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 |
Reserved Resources will be 2 |
Number of Teens | Number of Teens that are linked to the reservation. Age >/= |
12 Sleeper Nights10 years and < 18 years |
Quantity |
Resource Turnover | Created turnover by reserved resource, for example created turnover by bike-rentals |
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 |