Skip to end of metadata
Go to start of metadata
You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 11
Next »
This dataset provides information per reserved resources (i.e. booked resources in a reservation).
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 | 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 3 | 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 4 | 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 5 | The distribution channel through which the reservation of the resource was made. Level 1 - 5 depends on the tree-structure in MXTS | Distribution Channel Type | Type of the distribution channel (e.g. Direct, Touroperator or Reseller) |
|
End Date | End Date | The exact 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 |
| Location Level 1 |
| 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 | ? | Resource |
| Resource Level 1 |
| Resource Level 2 |
| Resource Level 3 |
| Resource Level 4 |
| Resource Level 5 |
| Resource Type |
|
|
Resource Group | Resource Group Level 1 |
| Resource Group Level 2 |
| Resource Group Level 3 |
| Resource Group Level 4 |
| Resource Group Level 5 |
|
|
Start Date | Start Date | The exact start date of the Reserved Resource (e.g. people check in on 20th of April, but bike rental wil 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 resource |
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 | Number of Reserved Resources |
Number of Teens | Number of Teens that are linked to the reservation. Age >/= 12 years and < 18 years |
Quantity |
|
Resource Turnover | Created turnover by reserved resource, for example created turnover by bike-rentals |
Sleeper Nights |
|