17,090
edits
Changes
Jump to navigation
Jump to search
[BOOKGROUPROOMLIST] - create a table of guest names including room type for a group booking
[BOOKGROUPROOMLISTTOTAL] - create a table of guest names including room type for a group booking with guest totals
[BOOKGROUPROOMLISTCHARGETOTAL] - create a table of guest names including room type and charge for a group booking with guest totals
[BOOKGROUPNAMELIST] - create a table of guest names including room type and unit for a group booking
[BOOKGROUPNAMELISTTOTAL] - create a table of guest names including room type and unit for a group booking with guest totals
[BOOKGROUPNAMELISTCHARGETOTAL] - create a table of guest names including room type and unit and charge for a group booking with guest totals
[BOOKGROUPUNITLIST] - create a table of guest names including unit for a group booking
[BOOKGROUPUNITLISTTOTAL] - create a table of guest names including unit for a group booking with guest totals
[BOOKGROUPUNITLISTCHARGETOTAL] - create a table of guest names including unit and charge for a group booking with guest totals
ExampleExamples:
[PROPERTYLOCATIONDESCRIPTION] - property location description
[PROPERTYLOCATIONDESCRIPTIONBR] - property location description with line break
[PROPERTYDIRECTIONS] - property directions (Settings > Channel Manager > Property Content)
[PROPERTYGENERALPOLICY] - property rental policy
[PROPERTYGENERALPOLICYBR] - property rental policy with line break
[PROPERTYLEGALPOLICY] - property rental policy / obsolete
[PROPERTYCANCELPOLICY] - property cancellation policy
[PROPERTYCANCELPOLICYBR] - property cancellation policy with line breaks
[PROPERTYHOUSERULES] - property house rules (Settings > Channel Manager > Property Content)
[PERMITID] - the permit ID
[CHECKINSTART] - check-in start time in 24hr format
[CHECKINEND] - check-in end time in 24hr format
[CHECKOUTEND] - check-out end time in 24hr format
[CHECKINSTART12] - check-in start time in am/pm format
[CHECKINEND12] - check-in end time in am/pm format
[CHECKOUTEND12] - check-out end time in am/pm format
== Room Variables ==
[COMMISSION] - Value in commission field with currency symbol
[COMMISSIONGROUP] - Value of the commission of the complete group booking
[COMMISSIONNUM] - As per [COMMISSION] but the value is displayed with a decimal point and no thousands separator and no currency symbols (for calculation).
[GUESTNAME] - last name
[GUESTSNAME] - name of all guests listed on the "guests" tab of this booking
[GUESTNAMES] - name of all guests in the booking
[GUESTSNAMES] - name of all guests listed on the "guests" tab of the booking of the group booking
[GUESTFULLNAME] - title, first name, last name
[GUESTMOBILENUM] - guests mobile number with all non-numeric characters removed
[PHONELAST1] - last digit of the guests phone number if guest phone is empty it will use the guests mobile number
[PHONELAST2] - last 2 digits of the guests phone number if guest phone is empty it will use the guests mobile number
[PHONELAST3] - last 3 digits of the guests phone number if guest phone is empty it will use the guests mobile number
[PHONELAST4] - last 4 digits of the guests phone number if guest phone is empty it will use the guests mobile number
[PHONELAST5] - last 5 digits of the guests phone number if guest phone is empty it will use the guests mobile number
[PHONELAST6] - last 6 digits of the guests phone number if guest phone is empty it will use the guests mobile number
[GUESTFAX] - guests fax number
[GUESTADDRESS] - guests address
[GUESTADDRESSBR] - guests address with line breaks
[GUESTPOSTCODE] - guests postcode
[GUESTLANGUAGE] - guest language
[REFERRER] - Referrer
[CANCELURL] - URL to view and cancel bookings
[CANCELDATE] - date until when the booking is cancelabledisplaying a phrase [CANCELDATEYYYY-MM-DD] - date until when the booking is cancelable displaying a date. If the date is in the past 00-00-0000 will be shown
[GUESTLOGIN] - URL to view bookings
[CARDLASTFOUR] - last 4 digits of card
== Booking Group variables ==
=== Custom Booking Group Table ===
ADUL= the number of adults
ARIV = Arrival date
BREF = Boking number
CHAR = Charges
CHIL = the number of childeren
DEPT = Departure date
ICAN = Include cancelled bookings
NAME = Guest name
ONLY = Just show the one booking
PAID = Paid amount
PEOP = the number of guests
PROP = Property name
ROOM = Room name
TOTA = Total price
UNI2 = Unit first additional information
UNI3 = Unit second additional information
UNIT = Unit name
Connect the variables with an underscore.
Examples:
[BOOKGROUP:PROP_ROOM_BREF_NAME] will display the property name, room name, booking number and guest name in this order.
[BOOKGROUP:BREF_NAME_PROP_ROOM] will display the booking number, guest name property name and room name in this order.
=== Booking Group Table with fixed content===
[BOOKGROUPROOMLIST] - create a table of guest names including room type for a group booking
[BOOKGROUPROOMLISTTOTAL] - create a table of guest names including room type for a group booking with guest totals
[BOOKGROUPROOMLISTCHARGETOTAL] - create a table of guest names including room type and charge for a group booking with guest totals
[BOOKGROUPNAMELIST] - create a table of guest names including room type and unit for a group booking
[BOOKGROUPNAMELISTTOTAL] - create a table of guest names including room type and unit for a group booking with guest totals
[BOOKGROUPNAMELISTCHARGETOTAL] - create a table of guest names including room type and unit and charge for a group booking with guest totals
[BOOKGROUPUNITLIST] - create a table of guest names including unit for a group booking
[BOOKGROUPUNITLISTTOTAL] - create a table of guest names including unit for a group booking with guest totals
[BOOKGROUPUNITLISTCHARGETOTAL] - create a table of guest names including unit and charge for a group booking with guest totals
== Invoice Variables ==
[INVOICENUMBER] - invoice number
[INVOICENUMBERS] - invoice number if invoicees are involved
[INVOICEDATE] - invoice date
AMO - shows the net value (price x quantity)
CEX - charges excluded (charges will not be shown)
CON - currency conversion. Example: CONEURUSD will convert the first currency (Euros) to the second currency (USD)
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
GRP - Group Totals. Displays the same items as a total
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: SIN 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: SEX SIN status1,status2,status4 will only show items with this status.
STA- shows staus
VAT - VAT summary
Connect the variables with an underscore.
[INVOICE:PRI_QTY_CUA€] will create an invoice table with price and quantity in Euros.
[INVOICE:PAY_TOT_CEX] will create an invoice table which will only show payments.
=== Invoice Tables with predefined content ===
<b>This works on all operators including [MIN] and [MAX]</b>
Note: Always use the template variables ending with NUM. The math functions will only work with numbers with a decimal point (not a decimal comma) and no thousands separator and no currency symbol.
== Currency Conversion ==
123456*[CONVERT:EUR-USD]
123456*[CONVERT:USD-EUR][/]0.85 will convert to Euros and divides the price by 0.85 which raises it by circa 15%
== Custom Date Format Variables ==
If the first word is contained in the second word the first option is displayed, otherwise the second option is displayed
Note: Always use the template variables ending with NUM if numbers are involved. The math functions will only work with numbers with a decimal point (not a decimal comma) and no thousands separator and no currency symbol.
