17,090
edits
Changes
Jump to navigation
Jump to search
[GUESTVOUCHER] - voucher code used with booking
[GUESTCOMPANY] - company name
[GUESTCOMPANYBR] - company name with line breaks
[RANDOM6] - a 6 digit random number seeded from the booking number
== iCal Links ==These template variables will create iCal links which allow the booking to be added to a calendar.[INVOICETABLEVAT2NOSUM] - invoice table with vat information and status field without vat summary
Example:[UPSELLTABLE] - table with all upsell items
Calendar link [UPSELLTABLEVAT] - table with check-in time 16:00, check-out time 10:00, the all upsell items with vat information and vat summary text "Booking" and the description text "Sunny Hotel":
=== Invoice Tables with predefined content ===
[INVOICETABLE] - invoice table
[INVOICETABLE:$1.1$] - invoice table and currency multiplier with optional new currency symbol before or after price.
[INVOICETABLEPART:status1,status2,!status4] - Invoice table showing only items with matching status. The status items can be a comma separated list. To exclude status items prefix them with an exclamation mark, for example !status1.
[INVOICETABLE2] - invoice table with status field
[INVOICETABLE2:$1.1$] - invoice table with status field and currency multiplier with optional new currency symbol before or after price.
[INVOICETABLECHARGES] - invoice table showing charges only
[INVOICETABLECHARGESINVOICEE1234] - invoice table showing charges only assigned to the specified invoicee, specify the invoicee Id number.
[INVOICETABLENOTOT] - invoice table without grand total
[INVOICETABLENOTOT:$1.1$] - invoice table without grand total and currency multiplier with optional new currency symbol before or after price.
[INVOICETABLENOTOT2] - invoice table with status field without grand total
[INVOICETABLENOTOT2:$1.1$] - invoice table with status field without grand total and currency multiplier with optional new currency symbol before or after price.
[INVOICETABLEVAT] - invoice table with vat information and vat summary
[INVOICETABLEVAT:$1.1$] - invoice table with vat information and currency multiplier with optional new currency symbol before or after price.
[INVOICETABLEVATCOMPACT] - compact version of invoice table with vat information and vat summary
[INVOICETABLEVATCOMPACT:$1.1$] - compact version of invoice table with vat information and vat summary and currency multiplier with optional new currency symbol before or after price.
[INVOICETABLEVATCOMPACTNOSUM] - compact version of invoice table with vat information without vat summary
[INVOICETABLEVATCOMPACTNOSUM:$1.1$] - compact version of invoice table with vat information without vat summary and currency multiplier with optional new currency symbol before or after price.
[INVOICETABLEVATNOSUM] - invoice table with vat information without vat summary
[INVOICETABLEVATNOSUM:$1.1$] - invoice table with vat information without vat summary and currency multiplier with optional new currency symbol before or after price.
[INVOICETABLEDATEVATNOSUM] - invoice table with vat information and date without vat summary
[INVOICETABLEDATEVATNOSUM:$1.1$] - invoice table with vat information and date without vat summary and currency multiplier with optional new currency symbol before or after price.
[INVOICETABLEVAT2] - invoice table with vat information and status field and vat summary
[INVOICETABLEVAT2:$1.1$] - invoice table with vat information and status field and vat summary and currency multiplier with optional new currency symbol before or after price.
[INVOICETABLEVAT2NOSUM] - invoice table with vat information and status field without vat summary
[INVOICETABLEVAT2NOSUM:$1.1$] - invoice table with vat information and status field without vat summary and currency multiplier with optional new currency symbol before or after price.
[INVOICETABLEVATCHARGES] - invoice table showing charges only with vat information and vat summary
[INVOICETABLENOPRICE] - invoice table with no price information
[INVOICETABLEINVOICEE] - invoice table excluding items assigned to an invoicee.
[INVOICETABLEINVOICEE1234] - invoice table for a specific invoicee, specify the invoicee Id number.
== Dates ==
You can use PHP strftime format strings to create custom time formats. Information on PHP strftime strings is available at [http://php.net/manual/en/function.strftime.php http://php.net/manual/en/function.strftime.php]
[DAYSBETWEEN:2019-11-01:2019-11-10] - this template variable will calculate the number of days between the :: the dates need to be in yyyy-mm-dd format. Template variables can be used for calculation.
Example: [[DAYSBETWEEN:[FIRSTNIGHT:+5 days{%G-%m-%d}]:[CURRENTDATE:{%G-%m-%d}]] will calculate the days between 5 days after check-in and today.
[FIRSTNIGHT:{%A, %e %B, %Y}] - first night booked
[FIRSTNIGHT:+1day{%A, %e %B, %Y}] - optional date offset and display format. The offset can be any plus or minus any number of days and the display can be any valid PHP strftime format string.
[LASTNIGHT:{%A, %e %B, %Y}] - last night booked
[LASTNIGHT:+1day{%A, %e %B, %Y}] - optional date offset and display format. The offset can be any plus or minus any number of days and the display can be any valid PHP strftime format string.
[LEAVINGDAY:{%A, %e %B, %Y}] - check-out
[LEAVINGDAY:+1day{%A, %e %B, %Y}] - optional date offset and display format. The offset can be any plus or minus any number of days and the display can be any valid PHP strftime format string.
[CURRENTDATE:{%A, %e %B, %Y}] - current date
[CURRENTDATE:+1day{%A, %e %B, %Y}] - optional date offset and display format. The offset can be any plus or minus any number of days and the display can be any valid PHP strftime format string.
[BOOKINGDATE:{%A, %e %B, %Y}] - booking date
[BOOKINGDATE:+1day{%A, %e %B, %Y}] - optional date offset and display format. The offset can be any plus or minus any number of days and the display can be any valid PHP strftime format string.
[MODIFYDATE:{%A, %e %B, %Y}] - last booking modification date/time, the display can be any valid PHP strftime format string.
[PAYMENTDATE:{%A, %e %B, %Y}] - most recent payment date
[PAYMENTDATE:+1day{%A, %e %B, %Y}:1:1000] - optional date offset and display format. The offset can be any plus or minus any number of days and the display can be any valid PHP strftime format string. The second parameter specifies the payment to show, 0 or missing means the most recent payment. The third parameter specifies the invoicee.
The last element is the [IF=:if this:equals this:display this text to show based on the result of the IF comparison, texts for the true and false case are separated by a pipe |otherwise display this text]
Template variables can be used inside [IFIN:if this template variable as per the examples.:is contained in this:display this text|otherwise display this text]
These template variables are processed in the following order from left to right through the text.i.e. all the [IF<span style="color: #019cde">IFIN:DEPOSIT: will be processed first, then all the [IFINBOOKINGINFOCODES]: etc. You can use the processing order to construct logic where certain items should be processed before other items. I[IF=:[IFINGUESTCOUNTRY2]:[IFLIKE:[IFAU</span><span style="color:[IF#75d5ad">=:[IFCredit card details are required <:[IF/span><span style="color:[IFBETWEEN:#fe746c">|A deposit is required]|No deposit is required</span>]
[PROPERTYNOROOMSAVAIL] - No Rooms Available Message from {#fas:cog}} (SETTINGS) BOOKING ENGINE > PROPERTY BOOKING PAGE > CONTENT
[PROPERTYGROUP] - shows the group keywords
== Room Variables ==
[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
[UNITSTATUS1] - the status if the unit
[ROOMDESCRIPTION] - Room description from {#fas:cog}} (SETTINGS) CHANNEL MANAGER > PROPERTY CONTENT > ROOM CONTENT
== Booking Variables ==
[BOOKIDVIEWBOOKING] - create a URL to log into the control panel and view this booking reference (for hosts, not intended to be sent to guests)
[BOOKID] - booking reference number [BOOKIDS] - booking reference numbers 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
[REFERENCENUMBER] - booking reference (same as [BOOKID])
[FIRSTNIGHTBOOKIDLAST1] - first night bookedLast 1 digit of booking number
[FIRSTNIGHTSHORTBOOKIDLAST2] - first night booked in 1 Apr 2016 format Last 2 digits of booking number
[FIRSTNIGHTYYYY-MM-DDBOOKIDLAST3] - first night booked in YYYY-MM-DD formatLast 3 digits of booking number
[LASTNIGHTBOOKIDLAST4] - last night booked Last 4 digits of booking number
[LASTNIGHTSHORTBOOKIDLAST5] - last night booked in 1 Apr 2016 format Last 5 digits of booking number
[LASTNIGHTYYYY-MM-DDBOOKIDLAST6] - last night booked in YYYY-MM-DD formatLast 6 digits of booking number
[LEAVINGDAYBOOKIDLAST7] - check-out dayLast 7 digits of booking number
[LEAVINGDAYSHORTBOOKIDLAST8] - check-out day in 1 Apr 2016 formatLast 8 digits of booking number
[LEAVINGDAYYYYY-MM-DDBEDDING] - check-out day in YYYY-MM-DD formatdisplays bedding info codes
[DAYSTOCHECKINRANDOM1] - a 1 digit random number seeded from the booking number of days until check-in
[INADVANCERANDOM2] - a 2 digit random number of days between seeded from the booking and check-in.number
[NUMROOMRANDOM3] - a 3 digit random number seeded from the quantity of rooms booked (first room type only) booking number
[NUMROOMSRANDOM4] - a 4 digit random number seeded from the quantity of rooms booked (sum of all rooms and room types) booking number
[NUMROOMSINCRANDOM5] - a 5 digit random number seeded from the quantity of rooms booked (sum of all rooms and room types) inc. cancelledbooking number
[NUMNIGHTRANDOM6] - a 6 digit random number seeded from the booking number of nights
[RANDOM7] - a 7 digit random number seeded from the booking number
[NUMNIGHTSRANDOM8] - a 8 digit random number of nights sum across group seeded from the bookingnumber
=== Content from "Info" tab ===[NUMNIGHTSINCBOOKINGINFOITEMS] - number of nights sum across group booking incl. cancelledBooking Info Codes - Codes and text
[NUMADULTBOOKINGINFOITEMSBR] - number of adults in this room or in group if master booking (not for cancelled bookings use NUMADULTINC if used for cacelled bookings)Booking Info Codes - Codes and text with line break
[NUMADULTINCBOOKINGINFOTEXTS] - number of adults in this room or in group if master booking incl. cancelled bookingsBooking Info Codes - Text only
[NUMADULT1BOOKINGINFOTEXTSBR] Booking Info Codes - number of adults in this roomText only with line break
[NUMCHILDBOOKINGINFOCODES] - number of children in this room or in group if master booking (not for cancelled bookings use NUMCHILDINC if used for cacelled bookings)Booking Info Codes - Codes only
[NUMCHILDINCBOOKINGINFOCODESBR] number of children in this room or in group if master booking including cancelled bookings - Booking Info Codes - Codes and text with line break
[NUMCHILD1BOOKINGINFOCODETEXT:infoCode] - number the most recent Text value of children the specified Booking Info Code, "infoCode" in this roomexample
[NUMPEOPLEBOOKINGINFOCODEDATE:infoCode] - number the most recent date value of guests the specified Booking Info Code, "infoCode" in this room or in group if master bookingexample
[NUMPEOPLEINCINTERNALNOTES] - number of guests in this room or in group if master booking incl. cancelled bookingscontent from "Internal Notes" on the Info Tab
[NUMPEOPLE1INTERNALNOTESBR] - number of people in this roomcontent from "Internal Notes" on the Info Tab with line break
[RATEDESCINTERNALNOTESHR] - rate description (in content from "Internal Notes" on the booking popup under the tab 'Charges & Payments')Info Tab with separating line
=== Content from "Summary" tab see also under "Room" and "Property" ===[RATEDESCBRSTATUS] - name status of the rate with HTML <BR> to force new linesbooking
[PRICESUBSTATUS] - Value in price field (number entered in the price field sub status of the booking) with currency symbol
[PRICENCFIRSTNIGHT] - Value in price field (number entered in the price field of the booking) without currency symbol (do not use in calculations, use PRICENUM)first night booked
[PRICE:10%FIRSTNIGHTSHORT] - Percentage value of Price first night booked in 1 Apr 2016 format
[PRICE:FIRSTNIGHTYYYY-10MM-DD] - Price with offset amountfirst night booked in YYYY-MM-DD format
[PRICENUMLASTNIGHT] - As per [PRICE] but the value is displayed with a decimal point and no thousands separator and no currency symbols (for calculation). last night booked
[PRICENUM:LASTNIGHTSHORT] - As per [PRICE:] but the value is displayed with a decimal point and no thousands separator and no currency symbols (for calculation). last night booked in 1 Apr 2016 format
[PRICELESSCOMMISSIONLASTNIGHTYYYY-MM-DD] - Value last night booked in price field less value in commission field with currency symbolYYYY-MM-DD format
[PRICELESSCOMMISSIONNUMLEAVINGDAY] - As per [PRICELESSCOMMISSION] but the value is displayed with a decimal point and no thousands separator and no currency symbols (for calculation).check-out day
[PRICELESSTAXLEAVINGDAYSHORT] - Value in price field less value check-out day in tax field with currency symbol1 Apr 2016 format
[PRICELESSTAXNUMLEAVINGDAYYYYY-MM-DD] - As per [PRICELESSTAX] but the value is displayed with a decimal point and no thousands separator and no currency symbols (for calculation).check-out day in YYYY-MM-DD format
[AVPRICENUMNIGHT] - Average Nightly Price with currency symbolnumber of nights
[AVPRICENUMNUMNIGHTS] - Average Nightly Price with a decimal point and no thousands separator and no currency symbols (for calculation). number of nights sum across group booking
[AVPRICE:20%NUMNIGHTSINC] - Percentage value number of Average Nightly Price nights sum across group booking incl. cancelled
[AVPRICE:15GUESTTITLE] - Average Nightly Price with offset amountguest title on the "summary" tab of the booking
[BASEPRICEGUESTFIRSTNAME] - Lodging Price first name on the "summary" tab of the booking
[BASEPRICENUMGUESTNAME] - same as [BASEPRICE] with a decimal point and no thousands separator and no currency symbols (for calculation) last name on the "summary" tab of the booking
[BASEGROUPPRICEGUESTNAMES] - Lodging Price for Groupname of all guests in the booking on the "summary" tab of the booking
[BASEGROUPPRICENUMGUESTNAMESINC] - same as BASEGROUPPRICE] with a decimal point and no thousands separator and no currency symbols (for calculation) name of all guests in the booking on the "summary" tab of the booking incl. cancelled bookings
[BASEVATGUESTNAMESINCBR] - Lodging Price vat amountname 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
[BASEVATNUMGUESTFULLNAME] - same as [BASEVAT] with a decimal point and no thousands separator and no currency symbols (for calculation) title, first name, last name on the "summary" tab of the booking
[BASEGROUPVATGUESTFULLNAMES] - Lodging Price vat amount for Grouptitles, first names, last names of all guests in the booking on the "summary" tab of the booking
[BASEGROUPVATNUMGUESTFULLNAMESBR] - same as BASEGROUPVAT] titles, first names, last names of all guests in the booking with a decimal point and no thousands separator and no currency symbols (for calculation) line break on the "summary" tab of the booking
[AVBASEPRICEGUESTFULLNAMESINC] - Average Nightly Lodging Price titles, first names, last names of all guests in the booking on the "summary" tab of the booking incl. cancelled
[AVBASEPRICENUMGUESTFULLNAMESINCBR] - same as [AVBASEPRICE] titles, first names, last names of all guests in the booking with a decimal point and no thousands separator and no currency symbols (for calculation) line break on the "summary" tab of the booking incl. cancelled
[AVBASEGROUPPRICEGUESTCOMMENTS] Average Nightly Lodging Price for Group- comments in the booking
[AVBASEGROUPPRICENUMGUESTCOMMENTSBR] - same as [AVBASEGROUPPRICE] comments in the booking with a decimal point and no thousands separator and no currency symbols (for calculation) line breaks <BR>
[DEPOSITNOTES] - Value in deposit field with currency symbolnotes
[DEPOSITNUMNOTESBR] - As per [DEPOSIT] but the value is displayed notes with a decimal point and no thousands separator and no currency symbols (for calculation). line breaks <BR>
[TAXGUESTARRIVALTIME] - Value in tax field with currency symbolarrival time
[TAXNUMNUMADULT] - As per [TAX] but the value is displayed with a decimal point and no thousands separator and no currency symbols number of adults in this room or in group if master booking (not for cancelled bookings use NUMADULTINC if used for calculationcacelled bookings).
[COMMISSIONNUMADULTINC] - Value number of adults in commission field with currency symbolthis room or in group if master booking incl. cancelled bookings
[COMMISSIONGROUPNUMADULT1] - Value number of the commission of the complete group bookingadults in this room
[COMMISSIONNUMNUMCHILD] - As per [COMMISSION] but the value is displayed with a decimal point and no thousands separator and no currency symbols number of children in this room or in group if master booking (not for cancelled bookings use NUMCHILDINC if used for calculationcacelled bookings).
[GUESTSNAMENUMCHILDINC] - name of all guests listed on the "guests" tab number of children in this room or in group if master bookingincluding cancelled bookings
[GUESTSNAMESNUMCHILD1] - name number of all guests listed on the "guests" tab of the booking of the group booking children in this room
[GUESTSFIRSTNAMESNUMPEOPLE] - first name number of all guests listed on the "guests" tab of in this room or in group if master booking
[GUESTSFIRSTNAMESINCNUMPEOPLEINC] - first name number of all guests listed on the "guests" tab of in this room or in group if master booking incl. cancelledbookings
[GUESTSLASTNAMESNUMPEOPLE1] - last name of all guests listed on the "guests" tab of this booking [GUESTSLASTNAMESINC] - last name of all guests listed on the "guests" tab number of people in this booking incl. cancelled [GUESTTITLE] - guest title on the "summary" tab of the booking [GUESTFIRSTNAME] - first name on the "summary" tab of the booking [GUESTNAME] - last name on the "summary" tab of the booking [GUESTNAMES] - name of all guests in the booking on the "summary" tab of the booking [GUESTNAMESINC] - name of all guests in the booking on the "summary" tab of the booking incl. cancelled bookings [GUESTNAMESINCBR] - 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 [GUESTFULLNAME] - title, first name, last name on the "summary" tab of the booking [GUESTFULLNAMES] - titles, first names, last names of all guests in the booking on the "summary" tab of the booking [GUESTFULLNAMESBR] - titles, first names, last names of all guests in the booking with line break on the "summary" tab of the booking [GUESTFULLNAMESINC] - titles, first names, last names of all guests in the booking on the "summary" tab of the booking incl. cancelled [GUESTFULLNAMESINCBR] - titles, first names, last names of all guests in the booking with line break on the "summary" tab of the booking incl. cancelled [GUESTEMAIL] - guest's Email address on the "summary" tab of the bookingroom
[GUESTPHONE] - guests phone number
[PHONELAST6] - last 6 digits of the guests phone number if guest phone is empty it will use the guests mobile number
[GUESTCOMPANY] - company name
[GUESTCOMPANYBR] - company name with line breaks
[GUESTFAX] - guests fax number
[GUESTFAXNUM] - guests fax number with all non-numeric characters removed
[GUESTADDRESS] - guests address
[GUESTCOUNTRY2] - guests country from selector list as two letter code
=== Content from "Details" tab ===[GUESTARRIVALTIMEMESSAGE] - arrival time the content of the booking message field
[GUESTCOMMENTSMESSAGEBR] - comments in the booking [GUESTCOMMENTSBR] - comments in content of the booking message field with line breaks <BR>
[GUESTCUSTOMQ1] - answer to custom question 1
[GUESTCUSTOMQ10] - answer to custom question 10
[GUESTLANGUAGEREFERENCE] - guest languagecontent of the booking reference field [NUMROOM] - the quantity of rooms booked (first room type only) [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 [FLAG] - Flag
[REFERRERSTATUSCODE] - Referrer 'Status Code' (Under tab 'Detail'. Can be a value between 0-100.)
[ORIGINALREFERRER] - Original referrer
[REFERRER] - Referrer
[APIREF] - the booking number at the originating channel
[APISOURCE] - Beds24 channel number
[APISOURCETEXT] - human readable name of the channel
[BOOKINGDATE] - booking date
[BOOKINGTIMEDATE] - booking date and time
[BOOKINGDATEYYYY-MM-DD] - booking date in YYYY-MM-DD format
[BOOKINGIP] - ip address of booker's computer
[APIMESSAGE] - api message sent by originating channel
=== Content from "Charges and Payments" tab (also see "Invoice/Invoicee/Room") ===[APISOURCEBOOKINGINVOICEEID] - Beds24 channel invoicee id assigned to this booking, this comes from the booking invoicee setting, not from the bookings invoice items [RATEDESC] - rate description (in the booking popup under the tab 'Charges & Payments') [RATEDESCBR] - name of the rate with HTML <BR> to force new lines [PRICE] - Value in price field (numberentered in the price field of the booking) with currency symbol [PRICENC] - Value in price field (number entered in the price field of the booking) without currency symbol (do not use in calculations, use PRICENUM) [PRICE:10%] - Percentage value of Price [PRICE:-10] - Price with offset amount [PRICENUM] - As per [PRICE] but the value is displayed with a decimal point and no thousands separator and no currency symbols (for calculation). [PRICENUM:] - As per [PRICE:] but the value is displayed with a decimal point and no thousands separator and no currency symbols (for calculation) [PRICELESSCOMMISSION] - Value in price field less value in commission field with currency symbol [PRICELESSCOMMISSIONNUM] - As per [PRICELESSCOMMISSION] but the value is displayed with a decimal point and no thousands separator and no currency symbols (for calculation) [PRICELESSTAX] - Value in price field less value in tax field with currency symbol [PRICELESSTAXNUM] - As per [PRICELESSTAX] but the value is displayed with a decimal point and no thousands separator and no currency symbols (for calculation) [AVPRICE] - Average Nightly Price with currency symbol [AVPRICENUM] - Average Nightly Price with a decimal point and no thousands separator and no currency symbols (for calculation) [AVPRICE:20%] - Percentage value of Average Nightly Price [AVPRICE:15] - Average Nightly Price with offset amount [BASEPRICE] - Lodging Price [BASEPRICENUM] - same as [BASEPRICE] with a decimal point and no thousands separator and no currency symbols (for calculation) [BASEGROUPPRICE] - Lodging Price for Group [BASEGROUPPRICENUM] - same as BASEGROUPPRICE] with a decimal point and no thousands separator and no currency symbols (for calculation)
[APISOURCETEXTBASEVAT] - human readable name of the channelLodging Price vat amount
[NOTESBASEVATNUM] - notes same as [BASEVAT] with a decimal point and no thousands separator and no currency symbols (for calculation)
[NOTESBRBASEGROUPVAT] - notes with line breaks <BR> Lodging Price vat amount for Group
[GROUPNOTEBASEGROUPVATNUM] - group note same as BASEGROUPVAT] with a decimal point and no thousands separator and no currency symbols (for calculation)
[MESSAGEAVBASEPRICE] - the content of the booking message fieldAverage Nightly Lodging Price
[MESSAGEBRAVBASEPRICENUM] - the content of the booking message field same as [AVBASEPRICE] with line breaks <BR>a decimal point and no thousands separator and no currency symbols (for calculation)
[REFERENCEAVBASEGROUPPRICE] - content of the booking reference fieldAverage Nightly Lodging Price for Group
[STATUSAVBASEGROUPPRICENUM] - status of bookingsame as [AVBASEGROUPPRICE] with a decimal point and no thousands separator and no currency symbols (for calculation)
[SUBSTATUSDEPOSIT] - sub status of the bookingValue in deposit field with currency symbol
[FLAGDEPOSITNUM] - FlagAs per [DEPOSIT] but the value is displayed with a decimal point and no thousands separator and no currency symbols (for calculation)
[STATUSCODETAX] - 'Status Code' (Under tab 'Detail'. Can be a value between 0-100.)Value in tax field with currency symbol
[CANCELURLTAXNUM] - URL to view As per [TAX] but the value is displayed with a decimal point and no thousands separator and cancel bookings no currency symbols (for calculation).
[CANCELDATECOMMISSION] - date until when the booking is cancelable displaying a phraseValue in commission field with currency symbol
[CANCELDATEYYYY-MMCOMMISSIONNUM] -DDAs per [COMMISSION] - date until when but the booking value is cancelable displaying displayed with a date. If the date is in the past 00-00-0000 will be showndecimal point and no thousands separator and no currency symbols (for calculation)
[GUESTLOGINCOMMISSIONGROUP] - URL to view bookings Value of the commission of the complete group booking
[CURRENTDATEGUESTVOUCHER] - current datevoucher code used with booking
[CURRENTDATEYYYY-MM-DDCARDLASTFOUR] - current date in YYYY-MM-DD formatlast 4 digits of card
[CURRENTTIMECARDFIRSTSIX] - current timefirst 6 digits of card
===Content from Invoice" tab===[BOOKINGDATEBOOKINGINVOICEEID] - invoicee id assigned to this booking date, this comes from the booking invoicee setting, not from the bookings invoice items
[BOOKINGTIMEDATEBOOKINGINVOICEENAME] - invoicee name assigned to this booking date and time, this comes from the booking invoicee setting, not from the bookings invoice items
===Content from "Group Invoice" tab===[BOOKINGDATEYYYY-MM-DDGROUPNOTE] - booking date in YYYY-MM-DD formatgroup note
=== Content from "Mail & Actions" tab ===[BOOKINGIPGUESTEMAIL] - ip guest's Email address on the "summary" tab of booker's computerthe booking
[VIEWBOOKINGGUESTLANGUAGE] - create a URL to log into the control panel and view this booking (for hosts, not intended to be sent to guests)guest language
[EMAIL:00] - Status of an Auto Action email. Replace 00 with the number of the Auto Action. This shows if the email has been sent and if so, the time it was sent.
=== Content from "Guests" tab ===[BOOKIDLAST1GUESTSID] - Last 1 digit all IDs of this booking number [GUESTSID1] - ID of the first guest [GUESTSIDS] - all IDs for all bookings in the group [GUESTSNAME] - name 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 [GUESTSNAMESINC] - name of all guests listed on the "guests" tab of the booking of the group booking incl. cancelled [GUESTSFIRSTNAMES] - first name of all guests listed on the "guests" tab of this booking last separated by an & [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 [GUESTSLASTNAMESINC] - last name of all guests listed on the "guests" tab of this booking incl. cancelled [GUESTSADDRESSSBR1] - address of the first guest on the "guests" tab of this booking group [GUESTSADDRESSSBR1INC] - address of the first guest on the "guests" tab of this booking group incl. cancelled ===Cancellation and Guest Login===[CANCELURL] - URL to view and cancel bookings
[BOOKIDLAST2CANCELDATE] - Last 2 digits of date until when the booking numberis cancellable displaying a phrase
[BOOKIDLAST3CANCELDATEYYYY-MM-DD] - Last 3 digits of date until when the booking numberis cancellable displaying a date. If the date is in the past 00-00-0000 will be shown
[BOOKIDLAST4DAYSTOCANCEL] - Last 4 digits number of days until booking numbercan be cancelled / Anzahl der Tage bis zu denen stroniert werden kann
[BOOKIDLAST5GUESTLOGIN] - Last 5 digits of booking numberURL to view bookings
==Date and Time==[BOOKIDLAST6CURRENTDATE] - Last 6 digits of booking numbercurrent date
[BOOKIDLAST7CURRENTDATEYYYY-MM-DD] - Last 7 digits of booking numbercurrent date in YYYY-MM-DD format
[BOOKIDLAST8CURRENTDATE:{%A, %e %B, %Y}] - Last 8 digits of booking numbercurrent date
[RANDOM1CURRENTDATE:+1day{%A, %e %B, %Y}] - a 1 digit random optional date offset and display format. The offset can be any plus or minus any number seeded from of days and the booking numberdisplay can be any valid PHP strftime format string.
[RANDOM2CURRENTTIME] - a 2 digit random number seeded from current time and the booking numberdisplay can be any valid PHP strftime format string.
[RANDOM3CURRENTTIME:+1day{%A, %e %B, %Y}] - a 3 digit random optional date offset and display format. The offset can be any plus or minus any number seeded from of days and the booking numberdisplay can be any valid PHP strftime format string.
[RANDOM4DAYSTOCHECKIN] - a 4 digit random number seeded from the booking numberof days until check-in
[RANDOM5INADVANCE] - a 5 digit random number seeded from the of days between booking numberand check-in
You can use PHP strftime format strings to create custom time formats. Information on PHP strftime strings is available at [RANDOM7http://php.net/manual/en/function.strftime.php http://php.net/manual/en/function.strftime.php] - a 7 digit random number seeded from the booking number
[RANDOM8DAYSBETWEEN:2019-11-01:2019-11-10] - a 8 digit random this template variable will calculate the number seeded from of days between the booking number:: the dates need to be in yyyy-mm-dd format. Template variables can be used for calculation.
Example: [BOOKINGINFOITEMS[DAYSBETWEEN:[FIRSTNIGHT:+5 days{%G-%m-%d}] :[CURRENTDATE:{%G-%m- Booking Info Codes %d}]] will calculate the days between 5 days after check- Codes in and texttoday.
[BOOKINGINFOITEMSBRFIRSTNIGHT:{%A, %e %B, %Y}] - Booking Info Codes - Codes and text with line break first night booked
[BOOKINGINFOTEXTSFIRSTNIGHT:+1day{%A, %e %B, %Y}] - Booking Info Codes - Text onlyoptional date offset and display format. The offset can be any plus or minus any number of days and the display can be any valid PHP strftime format string.
[BOOKINGINFOTEXTSBRLASTNIGHT:{%A, %e %B, %Y}] Booking Info Codes - Text only with line break last night booked
[BOOKINGINFOCODESLASTNIGHT:+1day{%A, %e %B, %Y}] - Booking Info Codes - Codes onlyoptional date offset and display format. The offset can be any plus or minus any number of days and the display can be any valid PHP strftime format string.
[BOOKINGINFOCODESBRLEAVINGDAY:{%A, %e %B, %Y}] - check- Booking Info Codes - Codes and text with line break out
[BOOKINGINFOCODETEXTLEAVINGDAY:infoCode+1day{%A, %e %B, %Y}] - the most recent Text value optional date offset and display format. The offset can be any plus or minus any number of days and the specified Booking Info Code, "infoCode" in this exampledisplay can be any valid PHP strftime format string.
[BOOKINGINFOCODEDATEBOOKINGDATE:infoCode{%A, %e %B, %Y}]- the most recent booking date value of the specified Booking Info Code, "infoCode" in this example
[BOOKINGINVOICEEIDBOOKINGDATE:+1day{%A, %e %B, %Y}] - invoicee id assigned to this booking, this comes from the booking invoicee setting, not from optional date offset and display format. The offset can be any plus or minus any number of days and the bookings invoice itemsdisplay can be any valid PHP strftime format string.
[BOOKINGINVOICEENAMEMODIFYDATE:{%A, %e %B, %Y}] - invoicee name assigned to this booking, this comes from the last booking invoicee settingmodification date/time, not from the bookings invoice itemsdisplay can be any valid PHP strftime format string.
[CARDLASTFOURPAYMENTDATE:{%A, %e %B, %Y}] - last 4 digits of cardmost recent payment date
[CARDFIRSTSIXPAYMENTDATE:+1day{%A, %e %B, %Y}:1:1000] - first 6 digits optional date offset and display format. The offset can be any plus or minus any number of carddays and the display can be any valid PHP strftime format string. The second parameter specifies the payment to show, 0 or missing means the most recent payment. The third parameter specifies the invoicee.
== Booking Group variables ==
== Invoice Variables ==
[INVOICENUMBER] - invoice number
[INVOICEDATE:+1day{%A, %e %B, %Y}] - optional date offset and display format. The offset can be any plus or minus any number of days and the display can be any valid PHP strftime format string.
=== Invoice Values ===
These template variables will display a value form the invoice.
==== Custom Invoice Values====
You have the option to create a custom invoice variable to display a value from an invoice. Available content variables are:
CHA - charges
CON - currency conversion. Example: CONEURUSD will convert the first currency (Euros) to the second currency (USD). CON1.234 would multiply the prices by 1.234
DEC - Decimal points. Example: DEC, will show a comma as decimal point. If nothing is set the system will use the default for the language
DP0 - no decimal places
DP1 - 1 decimal place
DP2 - 2 decimal places
DP3 - 3 decimal places
DP4 - 4 decimal places
DESsome description - sum of values with "some description"
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
IT1 - item 1 in the invoice
IT2 - item 2 in the invoice
IT3 - item 3 in the invoice
IT4 - item 4 in the invoice
IT5 - item 5 in the invoice
MUL - multiplier. Example: MUL1.2 will multiply all prices by 1.2
NUM - show with decimal place (for scripts)
THO - thousands separator. THO. will show a dot as thousand separator. If nothing is set the system will use the default for the language
UPS1 - upsell 1
UPS2 - upsell 2
UPS3 - upsell 3
UPS4 - upsell 4
UPS5 - upsell 5
ONE - shows only items from the specified booking (not the booking group)
PAY - shows payments
QTY - shows quantity
SEX - status excluded. Calculate the balance of all invoice items except for the ones with these status, the status items can be a comma separated list. Example: SEX status1,status2,status4 will not show items with this status.
SIN - status included. Calculate the balance of all invoice items with matching status, the status items can be a comma separated list. Example: SIN status1,status2,status4 will only show items with this status.
VAT - VAT summary
Connect the variables with an underscore.
Examples:
[INVOICEVAL:PAY_THO] will show payments with a thousands separator
[INVOICEVAL:UPS1_UPS1] will show the sum of upsell 1 and upsell 2
==== Standard Invoice Values====
[INVOICEBALANCE] - invoice balance
[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)
[INVOICEPENDPAYRULE1] - shows all pending payment for this rule (exchange 1 for the rule number)
[INVOICEPENDPAYRULENUM1] - shows all pending payment for this rule (exchange 1 for the rule number) displayed with a decimal point and no thousands separator (for calculation)
[INVOICECREDITS] - invoice sum of all credit items (negative items)
[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)
[UPSELLTABLEINVOICEITEMBYDESC: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) === Invoice Table ===These template varibles will display an invoice table . ==== Standard Invoice Tables ====[INVOICETABLE] - invoice table [INVOICETABLEVAT] - invoice table with vat information and vat summary [INVOICETABLE:$1.1$] - invoice table and currency multiplier with all upsell optional new currency symbol before or after price. [INVOICETABLEPART:status1,status2,!status4] - Invoice table showing only items with matching status. The status itemscan be a comma separated list. To exclude status items prefix them with an exclamation mark, for example !status1. [INVOICETABLE2] - invoice table with status field [INVOICETABLE2:$1.1$] - invoice table with status field and currency multiplier with optional new currency symbol before or after price. [INVOICETABLECHARGES] - invoice table showing charges only [INVOICETABLECHARGESINVOICEE1234] - invoice table showing charges only assigned to the specified invoicee, specify the invoicee Id number. [INVOICETABLENOTOT] - invoice table without grand total [INVOICETABLENOTOT:$1.1$] - invoice table without grand total and currency multiplier with optional new currency symbol before or after price. [INVOICETABLENOTOT2] - invoice table with status field without grand total [INVOICETABLENOTOT2:$1.1$] - invoice table with status field without grand total and currency multiplier with optional new currency symbol before or after price. [INVOICETABLEVAT:$1.1$] - invoice table with vat information and currency multiplier with optional new currency symbol before or after price. [INVOICETABLEVATCOMPACT] - compact version of invoice table with vat information and vat summary [INVOICETABLEVATCOMPACT:$1.1$] - compact version of invoice table with vat information and vat summary and currency multiplier with optional new currency symbol before or after price. [INVOICETABLEVATCOMPACTNOSUM] - compact version of invoice table with vat information without vat summary [INVOICETABLEVATCOMPACTNOSUM:$1.1$] - compact version of invoice table with vat information without vat summary and currency multiplier with optional new currency symbol before or after price. [INVOICETABLEVATNOSUM] - invoice table with vat information without vat summary [INVOICETABLEVATNOSUM:$1.1$] - invoice table with vat information without vat summary and currency multiplier with optional new currency symbol before or after price. [INVOICETABLEDATEVATNOSUM] - invoice table with vat information and date without vat summary [INVOICETABLEDATEVATNOSUM:$1.1$] - invoice table with vat information and date without vat summary and currency multiplier with optional new currency symbol before or after price.
[UPSELLTABLEVATINVOICETABLEVAT2] - invoice table with all upsell items with vat information and status field and vat summary
[UPSELLTABLENOREFUNDINVOICETABLEVAT2:$1.1$] - invoice table with all upsell items except refundable itemsvat information and status field and vat summary and currency multiplier with optional new currency symbol before or after price.
[ICALURLINVOICETABLEVAT2NOSUM:$1.1$] - Calendar linkinvoice table with vat information and status field without vat summary and currency multiplier with optional new currency symbol before or after price.
[ICALURL:16INVOICETABLEVATCHARGES] - Calendar link invoice table showing charges only with check-in hour. Replace '16' with the hour check-in starts.vat information and vat summary
[ICALURL::10INVOICETABLENOPRICE] - Calendar link invoice table with check-out hour. Replace '10' with the hour with the hour check-out ends.no price information
[ICALURL:::summary textINVOICETABLEINVOICEE] - Calendar link with a summary textinvoice table excluding items assigned to an invoicee.
[ICALURL::::description textINVOICETABLEINVOICEE1234] - Calendar link with invoice table for a descriptive textspecific invoicee, specify the invoicee Id number.
[ICALURL:16:10:Booking:Sunny HotelUPSELLTABLENOREFUND]- table with all upsell items except refundable items
== Invoice Table ===== Custom Invoice Table ====
You have the option to create a custom invoice table. Available content variables are:
[INVOICE:PAY_TOT_CEX] will create an invoice table which will only show payments.
== Invoicee Variables ==
[REPLACE|searchForThisText|replaceWithThisText|textToSearch] - replace "searchForThisText" with "replaceWithThisText" within the text "textToSearch"
== iCal Links ==
These template variables will create iCal links which allow the booking to be added to a calendar.
[ICALURL] - Calendar link
[ICALURL:16] - Calendar link with check-in hour. Replace '16' with the hour check-in starts.
[ICALURL::10] - Calendar link with check-out hour. Replace '10' with the hour with the hour check-out ends.
[ICALURL:::summary text] - Calendar link with a summary text
[ICALURL::::description text] - Calendar link with a descriptive text
Example:
Calendar link with check-in time 16:00, check-out time 10:00, the summary text "Booking" and the description text "Sunny Hotel":
[ICALURL:16:10:Booking:Sunny Hotel]
== Mathematical Operators ==
[MAX] - Example: 2 [MAX] 3 = 3
Brackets are not supported as a way to control processing order, the processing order is fixed as *, /, +, -, MIN, MAX
=== Rounding and controlling decimal places ===
123456*[CONVERT:USD-EUR][/]0.85 will convert to Euros and divides the price by 0.85 which raises it by circa 15%
==Account Variables (account of the booking) ==
[MASTERLOGGEDINACCOUNTTEMPLATE4] - Account Template 4 from master account
== Smart Logic Template Variables ==Smart IF style template variables will compare two values and display a text if the set content only comparison is true and an alternative text if the comparison is false. Colons : are used between the two comparison values and the first text, a certain condition pipe | is used between the two texts.Empty text is met or allowed if you do not metwant to display anything for a condition.
[IFLIKE:if this:is like this:display this text|otherwise display this text]
[IF>:if this:is greater than this:display this text|otherwise display this text] [IF>=:if this:is greater than or equal to this:display this text|otherwise display this text] [IF<:if this:is less than this:display this text|otherwise display this text] [IF<=:if this:is less than or equal to this:display this text|otherwise display this text] [IFBETWEEN:if this:is between this:and this:display this text|if it is lower display this text|if it is higher display this text] You can use IF variables inside other IF variables to create complex logic but the internal IF: must be processed before the external IFThey are processed in the following order from left to right so choose an internal one that is different and processed before the external one.i.e. all the [IF=: will be processed first, then all the [IFIN: etc. [IF=:[IFIN:[IFLIKE:[IF>:[IF>=:[IF<:[IF<=:[IFBETWEEN: Template variables can be used inside this template variable as per the examples <span style="color: #019cde">comparison in blue</span>, <span style="color: #75d5ad">positive result in green</span>, <span style="color: #fe746c">negative result in red</span>: 1. [<span style="color: #019cde">IF=:[GUESTNAME]</span><span style="color: #75d5ad">:Miller</span><span style="color: #75d5ad"><span style="color: #75d5ad">:yes</span> <span style="color: #fe746c">|no</span>]
If the guestname is Miller the text "yes" will display. If the guest name is not Miller the text "no" will display
2. [<span style="color: #019cde"> IF>:[NUMADULT]:2</span><span style="color: #75d5ad">:please contact us about you bedding requirements|</span>]
If the number of adults is higher than 2 the text"please contact us about you bedding requirements" will display. If the number of adults is lower than or equal 2 nothing will display.
3. [<span style="color: #019cde">IF<:[NUMADULT]:3</span><span style="color: #75d5ad">:|linen for two adults is included free of charge</span>]
If the number of adults is lower than 3 nothing will display. If the number of adults is not lower than 3 the text "linen for two adults is included free of charge" will display.
4. [<span style="color: #019cde">IF<=:[NUMADULT]:2</span><span style="color: #75d5ad">:yes</span><span style="color: #fe746c">|no</span>]
5. [<span style="color: #019cde">IF>=:[NUMADULT]:2</span><span style="color: #75d5ad">:yes</span><span style="color: #fe746c">|no</span>]
6. [<span style="color: #019cde">IFBETWEEN:[NUMADULT]:1:3</span><span style="color: #75d5ad">:yes</span><span style="color: #fe746c">|too low|too high</span>]
7. [<span style="color: #019cde">IFLIKE:[GUESTTITLE]</span><span style="color: #75d5ad">:Mr:Dear|Hi</span>]
IFLIKE works like IF= except it is case insensitive and removes any spaces from the start and end of the words
8. [<span style="color: #019cde">IFIN:John:[GUESTFIRSTNAME]</span><span style="color: #75d5ad">:Hi John</span><span style="color: #fe746c">|Your name does not contain John?</span>]
If the first word is contained in the second word the first option is displayed, otherwise the second option is displayed
9. [<span style="color: #019cde">IFIN:CHECKIN:[BOOKINGINFOITEMS]</span><span style="color: #75d5ad">:[BOOKINGINFOCODETEXT:CHECKIN]</span><span style="color: #fe746c">|</span>]
If the Booking Info Code CHECKIN has been added to the booking then you will see the value in the text (date/time) otherwise blank.
[INWORDS] - writes out a number in words. This works in English only.
[INWORDS] [INVOICEPAYMENTSNUM] [+] 10 will write out the invoice sum of all payments plus 10
Example: You want to display a special message to Australians if the booking has a DEPOSIT info item code, if a deposit is required from a non Australia they get "A deposit is required" and if no deposit is required they see "No deposit is required"
== Encoding Template Variables ==
[ENCODEURL:value] encode value for URL data format
