3,040
edits
Changes
Jump to navigation
Jump to search
ICAN EMAI = Include cancelled bookingsBooking Email
NAME FLAG = Booking full nameflag text
ONAM FNAM = Offer Name Booking first name
ONLY = Just show the one booking
PAID GADD = Paid amountGuest address
PEOP GCIT = the number of guestsGuest city
PROP GCOM = Property nameGuest company
RDE0 GCOU = Room description (Settings > Channel Manager > Property Content > Room Content) Guest country
RDE1 GFLA = Room description 1 (Settings > Properties > Rooms > Setup)Guest flag text
RNAM GFNA = Room Display Name ROOM = Room Guest first name
TOTA GLNA = Total priceGuest last name
UNI2 GMOB = Unit first additional information UNI3 = Unit second additional informationGuest mobile
UNIT GNAM = Unit Guest full name
coming soon:GNOT = Guest note
FNAM GPOS = Booking first nameGuest postcode
LNAM GREF = Booking last nameGuest Id
EMAI GSTA = Booking emailGuest state
PHON GTEL = Booking Guest phone
MOBI ICAN = Booking mobileInclude cancelled bookings
COMP LNAM = Booking companylast name
ADDR MOBI = Booking addressmobile
CITY NAME = Booking city STAT = Booking state POST = Booking postcode COUN = Booking country FLAG = Booking flag textfull name
including any of the following will show the information from the guests attached to the booking and will show one row per attached guest.ONAM = Offer Name
GNAM ONLY = Guest full nameJust show the one booking
GFNA PAID = Guest first name Paid amount
GLNA PEOP = Guest last namethe number of guests
GREF PHON = Guest IdBooking phone
GEMA POST = Guest emailBooking postcode
GTEL PROP = Guest phoneProperty name
GMOB RDE0 = Guest mobile Room description (Settings > Channel Manager > Property Content > Room Content)
GCOM RDE1 = Guest companyRoom description 1 (Settings > Properties > Rooms > Setup)
GADD RNAM = Guest addressRoom Display Name ROOM = Room name
GCIT STAT = Guest cityBooking state
GSTA TOTA = Guest stateTotal price
GPOS UNI2 = Guest postcodeUnit first additional information GCOU UNI3 = Guest country GFLA = Guest flag text GNOT = Guest noteUnit second additional information
[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
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
GEMA = Guest Email
NOTE = Booking note
UNIT = Unit name
