Versions Compared

Old Version 17

changes.mady.by.user Ruben de Looff

Saved on

compared with

New Version 18

changes.mady.by.user Roelant de Looff

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Attribute

Definition

Arrival Date


Arrival DateThe exact date the customer is arriving
Arrival Date Day of WeekThe day of the week the customer is arriving
Arrival Date ISO WeekThe ISO week in which this date is classified 
Arrival Date ISO YearThe ISO year in which this date is classified 
Arrival Date MonthThe month the customer is arriving
Arrival Date QuarterThe quarter the customer is arriving
Arrival Date YearThe year the customer is arriving


Customer


CityCity of Origin of the customer
CountryCountry of Origin of the customer


Departure Date


Departure DateThe exact date the customer is departing
Departure Date Day of WeekThe day of the week the customer is departing
Departure Date ISO WeekThe ISO week in which this date is classified 
Departure Date ISO YearThe ISO year in which this date is classified 
Departure Date MonthThe month the customer is departing
Departure Date QuarterThe quarter the customer is departing
Departure Date YearThe year the customer is departing


Distribution Channel


Distribution Channel BrandIf 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 TypeType of the distribution channel (e.g. Direct, Touroperator or Reseller)


Employee


EmployeeName of the Employee who created the reservation
EmployeegroupThe group to which the employee who created the reservation belongs (e.g. Reservations, Administrators or Internet)


Location


Location CountryCountry 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
Reservation StatusStates of the reservation (e.g. Definitive, Pre Booking, Expired or Cancelled)
ReservationcategoryIf used, the categorie of the reservation, for example the source of the reservation (by phone, e-mail or website)
SourceIf used, the source of the reservation (e.g. Social Media, Booked from Website, TripAdvisor or Search Engine)


Reservation Date


Reservation Date The exact date the reservation was created
Reservation Date Day of WeekThe day of the week the reservation was created
Reservation Date ISO WeekThe ISO week in which this date is classified 
Reservation Date ISO YearThe ISO year in which this date is classified 
Reservation Date MonthThe month the reservation was created
Reservation Date QuarterThe quarter the reservation was created
Reservation Date YearThe year the reservation was created


Reservation Duration


Reservation Duration

The duration of the reservation calculated in days.

For example: When the arrival day is Sunday and departure is two weeks later on Sunday, the reservation duration is 14 days

Reservation Duration Interval 30 Days

The 30-days interval in which a reservation is classified.

For example: A reservation duration of 14 days is in this attribute classified in the interval 1 - 30 days

Reservation Duration Interval 5 Days

The 5-days interval in which a reservation is classified.

For example: A reservation duration of 14 days is in this attribute classified in the interval 11 - 15 days

Reservation Duration Interval 7 Days

The 7-days interval in which a reservation is classified.

For example: A reservation duration of 14 days is in this attribute classified in the interval 8 - 14 days

Example to show that the different types of duration intervals overlap each other:

Reservation Lag


Reservation LagThe number of days between the reservation date and 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 



Metric

Definition

Agent Bill Total

Total bill amount for agent

Agent Outstanding Amount

Due/outstanding bill amount for agent

Agent Paid Amount

Bill amount paid by agent

Bill totalThe sum of the customer bill, agent bill and paying customer bill.

Customer Bill Total

Total bill amount for customer

Customer Outstanding Amount

Due/outstanding bill amount for customer

Customer Paid Amount

Bill amount paid by customer

Number of Nights

Number of nights for which reservation is made

Number of Reservations

Number of reservations at particular attribute level

Paying Customer Bill Total

If used in MXTS, for example when a reservation for a guest (Customer) is made via an agency (Paying Customer): Total bill amount for paying customer

Paying Customer Outstanding Amount

If used in MXTS, for example when a reservation for a guest (Customer) is made via an agency (Paying Customer): Due/outstanding bill amount for paying customer

Paying Customer Paid Amount

If used in MXTS, for example when a reservation for a guest (Customer) is made via an agency (Paying Customer): Bill amount paid by paying customer

Reservation Turnover

Total net turnover of all booked accommodations in this reservation, meaning gross price of the booked accommodations minus specials and included reservedresources. This amount is including VAT. This reservation turnover is excluding add-ons. That means that the e.g. Customer Bill Total will be higher if add-ons are booked in this reservation.