17,098
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 [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 text external IFThey are processed in the following order from left to show based on right so choose an internal one that is different and processed before the result of external one.i.e. all the [IF comparison=: will be processed first, texts for then all the true and false case are separated by a pipe |[IFIN: etc. [IF=:[IFIN:[IFLIKE:[IF>:[IF>=:[IF<:[IF<=:[IFBETWEEN:
Template variables can be used inside this template variable as per the examples.
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 ==
[ROOMID] - room id number
[ROOMNAME] - room names of all booked rooms (not for cancelled bookings use ROOMNAME1 ROOMNAMEINC if used for cacelled bookings)
[ROOMNAMEBR] - room names with line break
[ROOMNAMEBRROOMNAMEINC] - room name 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
[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)
[GROUPIDBOOKID] - booking reference number [BOOKIDS] - booking reference numbers of the master bookingall bookings in a group
[REFERENCENUMBERBOOKIDSINC] - booking reference of all bookings in a group including cancelled bookings
[FIRSTNIGHTGROUPID] - first night bookedbooking reference of the master booking
[FIRSTNIGHTSHORTREFERENCENUMBER] - first night booked in 1 Apr 2016 format booking reference (same as [BOOKID])
[FIRSTNIGHTYYYY-MM-DDBOOKIDLAST1] - first night booked in YYYY-MM-DD formatLast 1 digit of booking number
[LASTNIGHTBOOKIDLAST2] - last night booked Last 2 digits of booking number
[LASTNIGHTSHORTBOOKIDLAST3] - last night booked in 1 Apr 2016 format Last 3 digits of booking number
[LASTNIGHTYYYY-MM-DDBOOKIDLAST4] - last night booked in YYYY-MM-DD formatLast 4 digits of booking number
[LEAVINGDAYBOOKIDLAST5] - check-out dayLast 5 digits of booking number
[LEAVINGDAYSHORTBOOKIDLAST6] - check-out day in 1 Apr 2016 formatLast 6 digits of booking number
[LEAVINGDAYYYYY-MM-DDBOOKIDLAST7] - check-out day in YYYY-MM-DD formatLast 7 digits of booking number
[DAYSTOCHECKINBOOKIDLAST8] - Last 8 digits of booking number of days until check-in
[INADVANCEBEDDING] - number of days between booking and check-in.displays bedding info codes
[NUMROOMRANDOM1] - a 1 digit random number seeded from the quantity of rooms booked (first room type only) booking number
[NUMROOMSRANDOM2] - a 2 digit random number seeded from the quantity of rooms booked (sum of all rooms and room types) booking number
[NUMNIGHTRANDOM3] - a 3 digit random number seeded from the booking number of nights
[NUMNIGHTSRANDOM4] - a 4 digit random number of nights sum across group seeded from the bookingnumber
[NUMADULTRANDOM5] - a 5 digit random number of adults in this room or in group if master seeded from the booking (not for cancelled bookings use NUMADULT1 if used for cacelled bookings)number
[NUMADULT1RANDOM6] - a 6 digit random number seeded from the booking number of adults in this room
[NUMCHILDRANDOM7] - a 7 digit random number of children in this room or in group if master seeded from the booking (not for cancelled bookings use NUMCHILD1 if used for cacelled bookings)number
[RANDOM8] - a 8 digit random number seeded from the booking number
=== Content from "Info" tab ===[NUMCHILD1BOOKINGINFOITEMS] - number of children in this roomBooking Info Codes - Codes and text
[NUMPEOPLEBOOKINGINFOITEMSBR] - number of guests in this room or in group if master bookingBooking Info Codes - Codes and text with line break
[NUMPEOPLE1BOOKINGINFOTEXTS] - number of people in this roomBooking Info Codes - Text only
[RATEDESCBOOKINGINFOTEXTSBR] Booking Info Codes - rate description (in the booking popup under the tab 'Charges & Payments')Text only with line break
[RATEDESCBRBOOKINGINFOCODES] - name of the rate with HTML <BR> to force new linesBooking Info Codes - Codes only
[PRICEBOOKINGINFOCODESBR] - Value in price field (number entered in the price field of the booking) Booking Info Codes - Codes and text with currency symbolline break
[PRICENCBOOKINGINFOCODETEXT:infoCode] - Value in price field (number entered in the price field most recent Text value of the booking) without currency symbol (do not use specified Booking Info Code, "infoCode" in calculations, use PRICENUM)this example
[PRICEBOOKINGINFOCODEDATE:10%infoCode] - Percentage the most recent date value of Price the specified Booking Info Code, "infoCode" in this example
[PRICE:-10INTERNALNOTES] - Price with offset amountcontent from "Internal Notes" on the Info Tab
[PRICENUMINTERNALNOTESBR] - As per [PRICE] but content from "Internal Notes" on the value is displayed Info Tab with a decimal point and no thousands separator and no currency symbols (for calculation). line break
[PRICENUM:INTERNALNOTESHR] - As per [PRICE:] but content from "Internal Notes" on the value is displayed Info Tab with a decimal point and no thousands separator and no currency symbols (for calculation). separating line
=== Content from "Summary" tab see also under "Room" and "Property" ===[PRICELESSCOMMISSIONSTATUS] - Value in price field less value in commission field with currency symbolstatus of booking
[PRICELESSCOMMISSIONNUMSUBSTATUS] - As per [PRICELESSCOMMISSION] but sub status of the value is displayed with a decimal point and no thousands separator and no currency symbols (for calculation).booking
[PRICELESSTAXFIRSTNIGHT] - Value in price field less value in tax field with currency symbolfirst night booked
[PRICELESSTAXNUMFIRSTNIGHTSHORT] - As per [PRICELESSTAX] but the value is displayed with a decimal point and no thousands separator and no currency symbols (for calculation).first night booked in 1 Apr 2016 format
[AVPRICEFIRSTNIGHTYYYY-MM-DD] - Average Nightly Price with currency symbolfirst night booked in YYYY-MM-DD format
[AVPRICENUMLASTNIGHT] - Average Nightly Price with a decimal point and no thousands separator and no currency symbols (for calculation). last night booked
[AVPRICE:20%LASTNIGHTSHORT] - Percentage value of Average Nightly Price last night booked in 1 Apr 2016 format
[AVPRICE:15LASTNIGHTYYYY-MM-DD] - Average Nightly Price with offset amountlast night booked in YYYY-MM-DD format
[BASEPRICELEAVINGDAY] - Lodging Price check-out day
[BASEPRICENUMLEAVINGDAYSHORT] - same as [BASEPRICE] with a decimal point and no thousands separator and no currency symbols (for calculation) check-out day in 1 Apr 2016 format
[BASEGROUPPRICELEAVINGDAYYYYY-MM-DD] - Lodging Price for Groupcheck-out day in YYYY-MM-DD format
[BASEGROUPPRICENUMNUMNIGHT] - same as BASEGROUPPRICE] with a decimal point and no thousands separator and no currency symbols (for calculation) number of nights
[BASEVATNUMNIGHTS] - Lodging Price vat amountnumber of nights sum across group booking
[BASEVATNUMNUMNIGHTSINC] - same as [BASEVAT] with a decimal point and no thousands separator and no currency symbols (for calculation) number of nights sum across group booking incl. cancelled
[BASEGROUPVATGUESTTITLE] - Lodging Price vat amount for Groupguest title on the "summary" tab of the booking
[BASEGROUPVATNUMGUESTFIRSTNAME] - first name same as BASEGROUPVAT] with a decimal point and no thousands separator and no currency symbols (for calculation) on the "summary" tab of the booking
[AVBASEPRICEGUESTNAME] - Average Nightly Lodging Price last name on the "summary" tab of the booking
[AVBASEPRICENUMGUESTNAMES] - same as [AVBASEPRICE] 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
[AVBASEGROUPPRICEGUESTNAMESINC] Average Nightly Lodging Price for Group- name of all guests in the booking on the "summary" tab of the booking incl. cancelled bookings
[AVBASEGROUPPRICENUMGUESTNAMESINCBR] - same as [AVBASEGROUPPRICE] name of all guests in the booking on the "summary" tab of the booking incl. cancelled bookings with a decimal point and no thousands separator and no currency symbols (for calculation) line break on the "summary" tab of the booking
[DEPOSITGUESTFULLNAME] - Value in deposit field with currency symbol title, first name, last name on the "summary" tab of the booking
[DEPOSITNUMGUESTFULLNAMES] - As per [DEPOSIT] but titles, first names, last names of all guests in the value is displayed with a decimal point and no thousands separator and no currency symbols (for calculation). booking on the "summary" tab of the booking
[TAXGUESTFULLNAMESBR] - Value titles, first names, last names of all guests in tax field the booking with currency symbolline break on the "summary" tab of the booking
[TAXNUMGUESTFULLNAMESINC] - As per [TAX] but titles, first names, last names of all guests in the booking on the "summary" tab of the value is displayed with a decimal point and no thousands separator and no currency symbols (for calculation)booking incl.cancelled
[COMMISSIONGUESTFULLNAMESINCBR] - Value titles, first names, last names of all guests in commission field the booking with currency symbolline break on the "summary" tab of the booking incl. cancelled
[COMMISSIONGROUPGUESTCOMMENTS] - Value of comments in the commission of the complete group booking
[COMMISSIONNUMGUESTCOMMENTSBR] - As per [COMMISSION] but comments in the value is displayed booking with a decimal point and no thousands separator and no currency symbols (for calculation).line breaks <BR>
[GUESTSNAMENOTES] - name of all guests listed on the "guests" tab of this bookingnotes
[GUESTSNAMESNOTESBR] - name of all guests listed on the "guests" tab of the booking of the group booking notes with line breaks <BR>
[GUESTSFIRSTNAMESGUESTARRIVALTIME] - first name of all guests listed on the "guests" tab of this bookingarrival time
[GUESTSLASTNAMESNUMADULT] - last name of all guests listed on the "guests" tab number of adults in this room or in group if master booking(not for cancelled bookings use NUMADULTINC if used for cacelled bookings)
[GUESTTITLENUMADULTINC] - guest title on the "summary" tab number of the adults in this room or in group if master bookingincl. cancelled bookings
[GUESTFIRSTNAMENUMADULT1] - first name on the "summary" tab number of the bookingadults in this room
[GUESTNAMENUMCHILD] - last name on the "summary" tab number of the children in this room or in group if master booking(not for cancelled bookings use NUMCHILDINC if used for cacelled bookings)
[GUESTNAMESNUMCHILDINC] - name number of all guests children in the booking on the "summary" tab of the this room or in group if master bookingincluding cancelled bookings
[GUESTFULLNAMENUMCHILD1] - title, first name, last name on the "summary" tab number of the bookingchildren in this room
[GUESTFULLNAMESNUMPEOPLE] - titles, first names, last names number of all guests in the booking on the "summary" tab of the this room or in group if master booking
[GUESTFULLNAMESBRNUMPEOPLEINC] - titles, first names, last names number of all guests in the booking with line break on the "summary" tab of the this room or in group if master bookingincl. cancelled bookings
[GUESTEMAILNUMPEOPLE1] - guest's Email address on the "summary" tab number of the bookingpeople in this room
[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
[GUESTADDRESSBR] - guests address with line breaks
[GUESTSADDRESSSBR1INC] - guests address with line breaks incl. cancelled bookings
[GUESTPOSTCODE] - guests postcode
[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 readalbe 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 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 pipe | is used between the set content only two texts.Empty text is allowed if you do not want to display anything for a certain condition . [IF=:if this:equals this:display this text|otherwise display this text] [IFIN:if this:is contained in this:display this text|otherwise display this text] [IFLIKE:if this:is like this:display this text|otherwise display this text] [IF>:if this:is met greater than this:display this text|otherwise display this text] [IF>=:if this:is greater than or not met. equal to this:display this text|otherwise display this text]
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
