[BASEGROUPPRICENUM] - same as BASEGROUPPRICE] with a decimal point and no thousands separator and no currency symbols (for calculation)
[BASEVAT] - Lodging Price vat amount
[BASEVATNUM] - same as [BASEVAT] with a decimal point and no thousands separator and no currency symbols (for calculation)
[BASEGROUPVAT] - Lodging Price vat amount for Group
[BASEGROUPVATNUM] - same as BASEGROUPVAT] with a decimal point and no thousands separator and no currency symbols (for calculation)
[AVBASEPRICE] - Average Nightly Lodging Price
[REFERENCE] - content of the booking reference field
[STATUS] - status of booking (Values: 0=Cancelled, 1=Confirmed, 2=New, 3=Request, 4=Black) [SUBSTATUS] - sub status of the booking
[FLAG] - Flag
[BOOKINGINFOCODEDATE:infoCode]- the most recent date value of the specified Booking Info Code, "infoCode" in this example
[BOOKINGINVOICEEID] - invoicee id assigned to this booking, this comes from the booking invoicee setting, not from the bookings invoice items
[BOOKINGINVOICEENAME] - invoicee name assigned to this booking, this comes from the booking invoicee setting, not from the bookings invoice items
[CARDLASTFOUR] - last 4 digits of card
== Booking Group variables ==
=== Custom Booking Group Table ===
create your own booking group list by specifying the columns in the order you want them to appear. for example: [BOOKGROUP:PROP_ROOM_BREF_NAME] column parameters ADDR = Booking address
ADUL= the number of adults
BREF = Booking number
CITY = Booking city
CHAR = Charges
CHIL = the number of children
COUN = Booking country
DEPT = Departure date
EMAI = Booking Email
FLAG = Booking flag text
FNAM = Booking first name
GADD = Guest address
GCIT = Guest city
GCOM = Guest company
GCOU = Guest country
GFLA = Guest flag text
GFNA = Guest first name
GLNA = Guest last name
GMOB = Guest mobile
GNAM = Guest full name
GEMA = Guest Email
GNOT = Guest note
GPOS = Guest postcode
GREF = Guest Id
GSTA = Guest state
GTEL = Guest phone
ICAN = Include cancelled bookings
LNAM = Booking last name MOBI = Booking mobile NAME = Guest Booking full name NOTE = Booking note
ONAM = Offer Name
PEOP = the number of guests
PHON = Booking phone
POST = Booking postcode
PROP = Property name
ROOM = Room name
STAT = Booking state
TOTA = Total price
Connect the variables parameters with an underscore.
Examples: