17,530
edits
Changes
Jump to navigation
Jump to search
ICAN EMAI = Include cancelled bookingsBooking Email
NAME FLAG = Guest nameBooking flag text
ONAM FNAM = Offer Name ONLY = Just show the one booking PAID = Paid amount PEOP = the number of guestsBooking first name
PROP = Property name
RDE0 GADD = Room description (Settings > Channel Manager > Property Content > Room Content) Guest address
RDE1 GCIT = Room description 1 (Settings > Properties > Rooms > Setup)Guest city
RNAM GCOM = Room Display Name ROOM = Room nameGuest company
TOTA GCOU = Total priceGuest country
UNI2 GFLA = Unit first additional information UNI3 = Unit second additional informationGuest flag text
UNIT GFNA = Unit Guest first name
Connect the variables with an underscore. GMOB = Guest mobile
Examples: GNAM = Guest full name
[BOOKGROUP:PROP_ROOM_BREF_NAME] will display the property name, room name, booking number and guest name in this order.GEMA = Guest Email
[BOOKGROUP:BREF_NAME_PROP_ROOM] will display the booking number, guest name property name and room name in this order.GPOS = Guest postcode
[GUESTGROUP:PROP_ROOM_BREF_NAME] GSTA = Guest state
ADDR GTEL = AddressGuest phone
ARIV ICAN = Arrival dateInclude cancelled bookings
BREF LNAM = Booking number last name
CITY MOBI = CityBooking mobile
COMP NAME = CompanyBooking full name
COUN NOTE = CountryBooking note
DEPT ONAM = Departure dateOffer Name
FNAM ONLY = Guest first name Just show the one booking
GUID PAID = id of the guestPaid amount
ICAN PEOP = Include cancelled bookingsthe number of guests
LNAM PHON = Guest last nameBooking phone
GMOB POST = Guests mobile phoneBooking postcode
NAME PROP = Guest Property name
NOTE RDE0 = Notes Room description from {#fas:cog}} (SETTINGS) CHANNEL MANAGER > PROPERTY CONTENT > ROOM CONTENT
PROP RDE1 = PropertyRoom description 1 from {#fas:cog}} (SETTINGS) PROPERTIES> ROOMS > SETUP
PHON STAT = Guest phoneBooking state
POST TOTA = Post code STAT = State TITL = TitleTotal price
ORB PAA - shows the items orderd by bookinga column with payment amounts PAY - shows payments
PAY PEN - shows pending paymentsdescription
no edit summary
[PROPERTYNAME] - property name
[PROPERTYADDRESS] - property full address
[PROPERTYCITY] - property city
[PROPERTYLOCATIONDESCRIPTIONBR] - property location description with line break
[PROPERTYDIRECTIONS] - property directions from (Settings > Channel Manager {#fas:cog}} (SETTINGS) CHANNEL MANNAGER > Property ContentPROPERTY CONTENT)
[PROPERTYHEADLINE] - property headline
[PROPERTYCANCELPOLICYBR] - property cancellation policy with line breaks
[PROPERTYHOUSERULES] - property house rules (Settings {#fas:cog}} (SETTINGS) CHANNEL MANAGER > Channel Manager > Property ContentPROPERTY CONTENT)
[PROPERTYTEMPLATE1] - Property Template 1
[PERMITID] - the permit ID
[CHECKINSTART] - check-in start time in 24hr format (From Settings > Channel Manager > Property Content {#fas:cog}} (SETTINGS) CHANNEL MANAGER > PROPERTY CONTENT 'Check-in start')
[CHECKINEND] - check-in end time in 24hr format (From Settings > Channel Manager > Property Content {#fas:cog}} (SETTINGS) CHANNEL MANAGER > PROPERTY CONTENT 'Check-in end')
[CHECKOUTEND] - check-out end time in 24hr format (From Settings > Channel Manager > Property Content {#fas:cog}} (SETTINGS) CHANNEL MANAGER > PROPERTY CONTENT 'Check-out end')
[CHECKINSTART12] - check-in start time in am/pm format (From Settings > Channel Manager > Property Content {#fas:cog}} (SETTINGS) CHANNEL MANAGER > PROPERTY CONTENT 'Check-in start')
[CHECKINEND12] - check-in end time in am/pm format (From Settings > Channel Manager > Property Content {#fas:cog}} (SETTINGS) CHANNEL MANAGER > PROPERTY CONTENT 'Check-in end')
[CHECKOUTEND12] - check-out end time in am/pm format (From Settings > Channel Manager > Property Content {#fas:cog}} (SETTINGS) CHANNEL MANAGER > PROPERTY CONTENT 'Check-out end')
[PROPERTYDESCRIPTION1] - Property Description 1 from Settings {#fas:cog}} (SETTINGS) BOOKING ENGINE > Booking Page PROPERTY BOOKING PAGE > Page Design > Content CONTENT
[PROPERTYDESCRIPTION2] - Property Description 2 from Settings {#fas:cog}} (SETTINGS) BOOKING ENGINE > Booking Page PROPERTY BOOKING PAGE > Page Design > Content CONTENT
[PROPERTYDESCBOOKPAGE1] - Property Description Booking Page 1 from Settings {#fas:cog}} (SETTINGS) BOOKING ENGINE > Booking Page PROPERTY BOOKING PAGE > Page Design > Content CONTENT
[PROPERTYDESCBOOKPAGE2] - Property Description Booking Page 1 from Settings {#fas:cog}} (SETTINGS) BOOKING ENGINE > Booking Page PROPERTY BOOKING PAGE > Page Design > Content CONTENT
[PROPERTYGUESTDETAILSHEADER] - Guest Details Header from Settings {#fas:cog}} (SETTINGS) BOOKING ENGINE > Booking Page PROPERTY BOOKING PAGE > Page Design > Content CONTENT
[PROPERTYGUESTENQUIRYHEADER] - Guest Enquiry Header from Settings {#fas:cog}} (SETTINGS) BOOKING ENGINE > Booking Page PROPERTY BOOKING PAGE > Page Design > Content CONTENT
[PROPERTYCONFIRMBOOKBUTTON] - Confirm Booking Button Message from from Settings {#fas:cog}} (SETTINGS) BOOKING ENGINE > Booking Page PROPERTY BOOKING PAGE > Page Design > Content CONTENT
[PROPERTYROOMNOTAVAIL] - Room Not Available Message from from Settings {#fas:cog}} (SETTINGS) BOOKING ENGINE > Booking Page PROPERTY BOOKING PAGE > Page Design > Content CONTENT
[PROPERTYROOMNOPRICE] - Room No Price Message from from Settings {#fas:cog}} (SETTINGS) BOOKING ENGINE > Booking Page PROPERTY BOOKING PAGE > Page Design > Content CONTENT
[PROPERTYNOROOMSAVAIL] - No Rooms Available Message from from Settings {#fas:cog}} (SETTINGS) BOOKING ENGINE > Booking Page PROPERTY BOOKING PAGE > Page Design > ContentCONTENT
== Room Variables ==
[ROOMID] - room id number
[ROOMNAME] - room names of all booked rooms(not for cancelled bookings use ROOMNAMEINC if used for cacelled bookings)
[ROOMNAMEBR] - room name names with line break [ROOMNAMEINC] room names of all booked rooms including for cancelled bookings [ROOMNAMEINCBR] room names with line break
[ROOMNAME1] - room name of first booked room
[ROOMNAMEOFFERBR] - room names of all booked rooms with offer name with line break
[ROOMNAMEOFFERINC] room names of all booked rooms with offer name inkl. cancelled bookings
[ROOMNAMEOFFERINCBR] - room names of all booked rooms with offer name with line break
[ROOMTYPEDESC] - room accommodation type first booked room
[ROOMTYPEDESCS] - room accommodation type all booked rooms
[ROOMTYPEDESCSINC] - room accommodation type all booked rooms including cancelled bookings
[ROOMSIZE] - size of the room
[ROOMMETAAUXTEXT] - room meta text setting for first booked room
[ROOMMETAAUXTEXTS] - room meta text setting for all booked rooms [ROOMMETAAUXTEXTSINC] - room meta auxiliary text setting for all booked rooms
[INTERNALROOMNAME] - internal room name as used in the control panel, this is not the translated room name shown on the booking page
[OFFERNAME1] - offer name for this booked room only
[OFFERNAMEINC] - offer name for this booked room only inluding cancelled bookings
[OFFERDESCRIPTION1] - offer description 1 for all booked rooms
[OFFERDESCRIPTION1INC] - offer description 1 for all booked rooms inkl. cancelled
[OFFERDESCRIPTION2] - offer description 2 for all booked rooms
[OFFERDESCRIPTION2INC] - offer description 2 for all booked rooms inkl. cancelled
[OFFERDESCRIPTION1-1] - offer description 1 for this booked room
[OFFERDESCRIPTION2-1] - offer description 2 for this booked room
[OFFERSUMMARY] - summary offers
[OFFERSUMMARYINC] - summary offers including cancelled bookings
[UNITNAME] - unit names of all the assigned room types in the booking group (cancelled bookings are not shown)
[UNITNAMEINC] - unit names of all the assigned room types in the booking group including cancelled bookings
[UNITNAME:1] - additional information about the unit for all the assigned room types in the booking group (cancelled bookings are not shown)
[UNITNAME1:1] - additional information about the assigned room for this booking number / add the additional information on each line after a | symbol where you set the unit names
[ROOMDESCRIPTION] - Room description from {#fas:cog}} (Settings SETTINGS) CHANNEL MANAGER > Channel Manager PROPERTY CONTENT > Property Content > Room Content)ROOM CONTENT
[ROOMDESCRIPTION1] - Room description 1 from {#fas:cog}} (Settings SETTINGS) PROPERTIES > Properties ROOMS > Rooms > Setup)SETUP
[LEAVINGDAYAVAIL] - returns yes or no, can be used to trigger an Auto Action
[ROOMRACKRATENUM] - Rack Rate from {#fas:cog}} (SETTINGS) CHANNEL MANAGER > PROPERTY CONTENT > ROOM CONTENT
[ROOMCLEANINGFEENUM] - Cleaning fee from {#fas:cog}} (SETTINGS) CHANNEL MANAGER > PROPERTY CONTENT > ROOM CONTENT
[ROOMSECURITYDEPOSITNUM] - Securty deposit from {#fas:cog}} (SETTINGS) CHANNEL MANAGER > PROPERTY CONTENT > ROOM CONTENT
[ROOMTAXPERCENTNUM] - Tax percentate from from {#fas:cog}} (SETTINGS) CHANNEL MANAGER > PROPERTY CONTENT > ROOM CONTENT
[ROOMTAXPERSONNUM] - Tax per Person Night from from {#fas:cog}} (SETTINGS) CHANNEL MANAGER > PROPERTY CONTENT > ROOM CONTENT
== Booking Variables ==
[BOOKID] - booking reference
[BOOKIDS] - booking reference of all bookings in a group
[BOOKIDSINC] - booking reference of all bookings in a group including cancelled bookings
[GROUPID] - booking reference of the master booking
[NUMROOMS] - the quantity of rooms booked (sum of all rooms and room types)
[NUMROOMSINC] - the quantity of rooms booked (sum of all rooms and room types) inc. cancelled
[NUMNIGHT] - number of nights
[NUMNIGHTS] - number of nights sum across group booking
[NUMNIGHTSINC] - number of nights sum across group booking incl. cancelled [NUMADULT] - number of adults in this room or in group if master booking(not for cancelled bookings use NUMADULTINC if used for cacelled bookings) [NUMADULTINC] - number of adults in this room or in group if master booking incl. cancelled bookings
[NUMADULT1] - number of adults in this room
[NUMCHILD] - number of children in this room or in group if master booking (not for cancelled bookings use NUMCHILDINC if used for cacelled bookings) [NUMCHILDINC] number of children in this room or in group if master booking including cancelled bookings
[NUMCHILD1] - number of children in this room
[NUMPEOPLE] - number of guests in this room or in group if master booking
[NUMPEOPLEINC] - number of guests in this room or in group if master booking incl. cancelled bookings
[NUMPEOPLE1] - number of people in this room
[BASEGROUPPRICENUM] - same as BASEGROUPPRICE] with a decimal point and no thousands separator and no currency symbols (for calculation)
[BASEVAT] - Lodging Price vat amount
[BASEVATNUM] - same as [BASEVAT] with a decimal point and no thousands separator and no currency symbols (for calculation)
[BASEGROUPVAT] - Lodging Price vat amount for Group
[BASEGROUPVATNUM] - same as BASEGROUPVAT] with a decimal point and no thousands separator and no currency symbols (for calculation)
[AVBASEPRICE] - Average Nightly Lodging Price
[COMMISSIONNUM] - As per [COMMISSION] but the value is displayed with a decimal point and no thousands separator and no currency symbols (for calculation).
[GUESTTITLEGUESTSNAME] - guest titlename of all guests listed on the "guests" tab of this booking [GUESTSNAMES] - name of all guests listed on the "guests" tab of the booking of the group booking [GUESTSFIRSTNAMES] - first name of all guests listed on the "guests" tab of this booking [GUESTSFIRSTNAMESINC] - first name of all guests listed on the "guests" tab of this booking incl. cancelled [GUESTSLASTNAMES] - last name of all guests listed on the "guests" tab of this booking
[GUESTFIRSTNAMEGUESTSLASTNAMESINC] - first last name of all guests listed on the "guests" tab of this booking incl. cancelled
[GUESTNAMEGUESTTITLE] - last nameguest title on the "summary" tab of the booking
[GUESTSNAMEGUESTFIRSTNAME] - first name on the "summary" tab of the booking [GUESTNAME] - last name on the "summary" tab of the booking [GUESTNAMES] - name of all guests listed in the booking on the "guestssummary" tab of this the booking
[GUESTNAMESGUESTNAMESINC] - name of all guests in the booking on the "summary" tab of the booking incl. cancelled bookings
[GUESTSFIRSTNAMESGUESTNAMESINCBR] - first name of all guests in the booking on the "summary" tab of the booking incl. cancelled bookings with line break on the "summary" tab of the booking
[GUESTSLASTNAMESGUESTFULLNAME] - title, first name, last name on the "summary" tab of all guests in the booking
[GUESTSNAMESGUESTFULLNAMES] - name titles, first names, last names of all guests listed in the booking on the "guestssummary" tab of the booking of the group booking
[GUESTFULLNAMEGUESTFULLNAMESBR] - titletitles, first namenames, last namenames of all guests in the booking with line break on the "summary" tab of the booking
[GUESTFULLNAMESGUESTFULLNAMESINC] - titles, first names, last names of all guests in the booking on the "summary" tab of the booking incl. cancelled
[GUESTFULLNAMESBRGUESTFULLNAMESINCBR] - titles, first names, last names of all guests in the booking with line breakon the "summary" tab of the booking incl. cancelled
[GUESTEMAIL] - guest's Email addresson the "summary" tab of the booking
[GUESTPHONE] - guests phone number
[GUESTADDRESSBR] - guests address with line breaks
[GUESTSADDRESSSBR1INC] - guests address with line breaks incl. cancelled bookings
[GUESTPOSTCODE] - guests postcode
[GUESTCOUNTRY] - guests country from free text field is not empty, otherwise from selector list
[GUESTCOUNTRYHL] - guests country from free text field is not empty, otherwise from selector list in hosts languabelanguage
[GUESTCOUNTRYGL] - guests country from free text field is not empty, otherwise from selector list in guests language
[GUESTCOUNTRYTEXT] - guests country from free text field
[GUESTCOUNTRY2] - guests country from selector list as two letter code
[GUESTARRIVALTIME] - arrival time
[APISOURCE] - Beds24 channel number
[APISOURCETEXT] - human readalbe readable name of the channel
[NOTES] - notes
[REFERENCE] - content of the booking reference field
[STATUS] - status of booking (Values: 0=Cancelled, 1=Confirmed, 2=New, 3=Request, 4=Black) [SUBSTATUS] - sub status of the booking
[FLAG] - Flag
[BOOKINGINFOCODEDATE:infoCode]- the most recent date value of the specified Booking Info Code, "infoCode" in this example
[BOOKINGINVOICEEID] - invoicee id assigned to this booking, this comes from the booking invoicee setting, not from the bookings invoice items
[BOOKINGINVOICEENAME] - invoicee name assigned to this booking, this comes from the booking invoicee setting, not from the bookings invoice items
[CARDLASTFOUR] - last 4 digits of card
[CARDFIRSTSIX] - first 6 digits of card
[INTERNALNOTES] - content from "Internal Notes" on the Info Tab
[INTERNALNOTESBR] - content from "Internal Notes" on the Info Tab with line break
== Booking Group variables ==
=== Custom Booking Group Table ===
create your own booking group list by specifying the columns in the order you want them to appear. for example: [BOOKGROUP:PROP_ROOM_BREF_NAME] column parameters ADDR = Booking address
ADUL= the number of adults
BREF = Booking number
CITY = Booking city
CHAR = Charges
CHIL = the number of children
COUN = Booking country
DEPT = Departure date
GLNA = Guest last name
GNOT = Guest note
GREF === Custom Guest Group Table ===This template variable uses the information from the guests attached to the booking Id
RNAM = Room Display Name
ROOM = Room name
UNI2 = Unit first additional information
Connect the variables parameters with an underscore.
Examples:
[GUESTGROUPBOOKGROUP:PROP_ROOM_BREF_NAME] will display the property name, room name, booking number and guest name in this order.
[GUESTGROUPBOOKGROUP:BREF_NAME_PROP_ROOM] will display the booking number, guest name property name and room name in this order.
=== Booking Group Table with fixed content===
[INVOICEPARTPAYMENTSNUM:status1,status2,status4:10%] - As per INVOICEPARTCHARGES but the value is displayed with a decimal point and no thousands separator (for calculation).
[INVOICEPENDPAY] - all (auto and manual) pending payments including failed
[INVOICEPENDPAYNUM] - all (auto and manual) pending payments including failed but the value is displayed with a decimal point and no thousands separator (for calculation).
[INVOICEPENDPAY1234] - all (auto and manual) pending payments including failed for the specified invoicee
[INVOICEPENDPAYNUM1234] - all (auto and manual) pending payments including failed for the specified invoicee but the value is displayed with a decimal point and no thousands separator (for calculation).
[INVOICEPENDPAYAUTO] - auto pending payments before due date
[INVOICEPENDPAYAUTONUM] - auto pending payments before due date but the value is displayed with a decimal point and no thousands separator (for calculation).
[INVOICEPENDPAYAUTO1234] auto pending payments before due date for the specified invoicee but the value is displayed with a decimal point and no thousands separator (for calculation)
[INVOICEPENDPAYAUTONUM1234] auto pending payments before due date for the specified invoicee but the value is displayed with a decimal point and no thousands separator (for calculation)
[INVOICEPENDPAYFAIL] - failed pending payments (all also past)
[INVOICEPENDPAYFAILNUM] - failed pending payments (all also past) but the value is displayed with a decimal point and no thousands separator (for calculation)
[INVOICEPENDPAYFAIL234] - failed pending payments (all also past) for the specified invoicee
[INVOICEPENDPAYFAILNUM234] - failed pending payments (all also past) for the specified invoicee but the value is displayed with a decimal point and no thousands separator (for calculation)
[INVOICECREDITS] - invoice sum of all credit items (negative items)
[INVOICEFIRSTITEMNUM] - price of the item listed first in the invoice but the value is displayed with a decimal point and no thousands separator (for calculations)
[INVOICESECONDITEM] - price of the item listed second in the invoice
[INVOICESECONDITEMNUM] - price of the item listed second in the invoice but the value is displayed with a decimal point and no thousands separator (for calculations)
[INVOICETHIRDITEM] - price of the item listed third in the invoice
[INVOICETHIRDITEMNUM] - price of the item listed third in the invoice but the value is displayed with a decimal point and no thousands separator (for calculations)
[INVOICEUPSELL0] - base price without upsell items or other charges added later
[INVOICEEXTRAITEMQTY1] - quantity of extra invoice item 1 (number can be between 0 to 20) Note: the order goes by the order in the dropdown list not by the order the items are entered.
[INVOICEGROSS:1] - gross amount of the inserted VAT rate (number is the VAT rate), value is displayed with a decimal point and no thousands separator (for calculations)
[INVOICEVATNUM:1] VAT amount of the inserted VAT rate (number is the VAT rate), value is displayed with a decimal point and no thousands separator (for calculations)
[INVOICEITEMBYDESC:Searchterm] - searches the invoice for items with this search term and adds them up
[INVOICEITEMBYDESCNUM:Searchterm] - searches the invoice for items with this search term and adds them up, value is displayed with a decimal point and no thousands separator (for calculations)
[INVOICEPAYMENTBYDESC:Searchterm] - searches the payments for items with this search term and adds them up
[INVOICEPAYMENTBYDESCNUM:Searchterm] - searches the payments for items with this search term and adds them up, value is displayed with a decimal point and no thousands separator (for calculations)
[UPSELLTABLE] - table with all upsell items
== Invoice Table ==
=== Custom Invoice Table ===
You have the option to create a custom invoice table. Available content variables are:
GRT - Grand Total
INV - invoicee, add the invoicee number at the end. Example: INV20 to show invoicee number 20, INV0 will show items not assigned to an invoicee, INV-1 will show all items from the booking regardless of invoicee. You can combine INV[BOOKINGINVOICEEID]] to add the invoicee from the booking
LAN - language. Example LANDE will force the language to German
NOC - charges will not be displayed but their vat values are still calculated for the vat summary (VAT)
NOP - payments will not be displayed
ONE - shows only items from the specified booking (not the booking group)
PPA - shows pending payments amount PRI - shows prices in a column
QTY - shows quantity
[ACCOUNTTEMPLATE4] - Account Template 4
[COMMISSIONLIMIT] - shows the available commission amount for the owner account of the booking
[MASTERACCOUNTTEMPLATE1] - Account Template 1 from master account
