17,090
edits
Changes
Jump to navigation
Jump to search
[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.
== 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.
[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
[BOOKIDLAST8] - Last 8 digits of booking number
[BEDDING] - displays bedding info codes
[RANDOM1] - a 1 digit random number seeded from the booking number
[INTERNALNOTESBR] - content from "Internal Notes" on the Info Tab with line break
[INTERNALNOTESHR] - content from "Internal Notes" on the Info Tab with separating line
=== Content from "Summary" tab see also under "Room" and "Property" ===
=== Content from "Guests" tab ===
[GUESTSID] - all IDs of this booking
[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 &
[GUESTSLASTNAMESINC] - last name of all guests listed on the "guests" tab of this booking incl. cancelled
[BOOKNAMELISTGUESTSADDRESSSBR1] - create a table with address of the first guest names and info for a on the "guests" tab of this booking / Tabelle mit Gastname und Informationen für diese Gruppenbuchunggroup [GUESTSADDRESSSBR1INC] - address of the first guest on the "guests" tab of this booking group incl. cancelled
===Cancellation and Guest Login===
[CANCELDATEYYYY-MM-DD] - date until when the booking is cancellable displaying a date. If the date is in the past 00-00-0000 will be shown
[DAYSTOCANCEL] - number of days until booking can be cancelled / Anzahl der Tage bis zu denen stroniert werden kann [GUESTLOGIN] - URL to view bookings
==Date and Time==
[CURRENTDATEYYYY-MM-DD] - current date in YYYY-MM-DD format
[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. [CURRENTTIME] - current timeand the display can be any valid PHP strftime format string. [CURRENTTIME:+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.
[DAYSTOCHECKIN] - number of days until check-in
[INADVANCE] - number of days between booking and check-in.
[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.
[BOOKINGDATE:{%A, %e %B, %Y}] - booking 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.
== 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
[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)
[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 [UPSELLTABLEINVOICETABLE:$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 itemswith 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:$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 ==
