17,090
edits
Changes
Jump to navigation
Jump to search
DAT NOC - adds a date columncharges will not be displayed but their vat values are still calculated for the vat summary (VAT)
no edit summary
[PROPERTYFAX] - property fax
[PROPERTYCONTACTLASTNAME] - property contact last name
[PROPERTYCONTACTFIRSTNAME] - property contact first name
[PROPERTYID] - property id number
[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 ==
[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
[BOOKINGINFOITEMS] - Booking Info Codes - Codes and text
[BOOKINGINFOITEMSBR] - Booking Info Codes - Codes and text with line break
[BOOKINGINFOTEXTS] - Booking Info Codes - Text only
[BOOKINGINFOTEXTSBR] Booking Info Codes - Text only with line break
[BOOKINGINFOCODES] - Booking Info Codes - Codes only
[BOOKINGINFOCODESBR] - Booking Info Codes - Codes and text with line break
[BOOKINGINFOCODETEXT:] - the most recent Text value of the specified Booking Info Code
[CARDLASTFOUR] - last 4 digits of card
[CARDFIRSTSIX] - first 6 digits of card
[INVOICEEXTRAITEMQTY1] - quantity of extra invoice item 1 (number can be between 0 to 20)
[INVOICEGROSS:1] - gross amount of the inserted VAT rate (number is the VAT rate), value is displayed with a decimal point and no thousands separator (for calculations)
INVOICEGROSSNUM:1] gross amount of the inserted VAT rate (number is the VAT rate)
[INVOICENET:1] - net amount of the inserted VAT rate (number is the VAT rate)
[INVOICENETNUM:1] - net amount of the inserted VAT rate (number is the VAT rate), value is displayed with a decimal point and no thousands separator (for calculations)
[INVOICEVAT:1] - VAT amount of the inserted VAT rate (number is the VAT rate)
[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)
[UPSELLTABLE] - table with all upsell items
CEX - charges excluded (charges will not be shown)
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
CUA - currency symbol showing after the numbers. Example: CUA€ will show € after the figures
CUB - currency symbol showing before the numbers. Example: CUB€ will show € before the figures
DAT - adds a date column
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
MUL - multiplier. Example: MUL1.2 will multiply all prices by 1.2
PAY - shows payments
[INVOICEETEMPLATE8] - template value 8 of the invoice account the invoice is assigned to or blank
== Guest Variables ==
[GUESTIDS] - comma separated list of guest Id's connected to the booking
[GUESTFLAGTEXTS] - comma separated list of flag text values for each guest (when not empty) connected to the booking
== Payment Request Variables ==
[PAYPALBUTTON:200] - Creates a Paypal payment button for a fixed amount. A zero amount will cause paypal to provide a field to enter an amount. Not recommended for emails.
== Mathematical Operators ==
<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 ==
[MASTERLOGGEDINACCOUNTTEMPLATE4] - Account Template 4 from master account
== Smart Template Variables ==
If the first word is contained in the second word the first option is displayed, otherwise the second option is displayed
[INWORDS] - writes out a number in words. This works in English only.
Expamles:
[INWORDS] 10 will write out then
[INWORDS] [INVOICEPAYMENTSNUM] will write out the invoice sum of all payments
[INWORDS] [INVOICEPAYMENTSNUM] [+] 10 will write out the invoice sum of all payments plus 10
== Encoding Template Variables ==
[ENCODEURL:value] encode value for URL data format
[ENCODEJSON:value] encode value for JSON data format
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.
