Skip to main content

Variables - Standard FIelds

Here is a list of valid variable field names to use in the Letter Setup Wizard and Confirm Screen. They will work with both letter formats and can be formatted within the letter.

Confirmation Letters/Screens

VariableOutput
CHECKINCheck-In date (Windows Date Setting)
CHECKOUTCheck-out date (Windows Date Setting)
FCHECKINFull Check-In date (mmmmmm dd, yyyy)
FCHECKOUTFull Check-out date (mmmmmm dd, yyyy)
INDOWCheck-In day of week
OUTDOWCheck-Out day of week
NIGHTSNumber of nights
TITLETitle/Prefix such as Mr. Mrs. Miss.
FIRSTFirst name
LASTLast name
MORENAMESMore Names/Additional Names
FORMATADDRFully Formatted Address(including name)
ROOMTYPERoom type code
ROOMDESRoom type description
REFNUMInternal reference number
CONFNUMConfirmation Number
CXLNUMCancellation Number
ROOMSNumber of rooms
RATE1Rate 1 (Weekday or Daily, Weekly, Monthly, Package Total)
RATE2Rate 2 (Weekend or Daily)
DRATE1Rate 1 as above but including any discount amount
DRATE2Rate 2 as above but including any discount amount
RATENAMEFull description of rate
RATEDES1Rate 1 Description such as "Weekday", "Weekly", "Monthly", "Package"
RATEDES2Rate 2 Description such as "Weekend" or "Daily"
RC-SEQSequential list of Rate Changes
RC-COLColumn list of Rate Changes
HOLDDESGuarantee description
HOLDNUMCredit card number
HOLDEXPExpiration date
ADULTSNumber of adults
CHILDNumber of children
DEPOSITTERMSRate Code Deposit Terms and Conditions
USER1User field 1 description
USER2User field 2 description
DEPOSITAmount of deposit
DISCOUNTDiscount percent
TOTALROOMTotal amount of room
TOTALTAXTotal tax amount
SUBTOTALTotal room and tax
DAILYCHARGEDaily charge total (includes tax)
AVGNIGHTTAXAverage Night (Grand Total / Nights)
AVGNIGHTNOTAXAverage Night (Room + Charges / Nights)
GRANDTOTALGrand total
GRANDDEPOSITGrand total accounting for any deposit amount
EXTRA1Custom Freeform field 1
EXTRA2Custom Freeform field 2
EXTRA3Custom Freeform field 3
EXTRA4Custom Freeform field 4
MADEBYMade by
PHONE1Phone number 1
PHONE2Phone number 2
ASSIGNROOMSAssigned rooms
MOVEROOMSSequential list of all room moves for the guest. You can also use VAR:ROOMMOVES > 0 as a RunTime Variable instead and just have a custom paragraph to tell the guest there is a room move but not give the exact details.
IQSCHEDiQ-Schedule events
USERNAMECurrent user profile name
POSITIONCurrent user profile position
ENTRYDATEDate reservation is entered
ENTEREDBYPerson's initials entering the reservation

Guest Profile Letter

VariableOutput
NUMBERGuest Profile Number
TITLETitle/Prefix such as Mr. Mrs. Miss.
FIRSTFirst name
LASTLast name
STREETStreet address
CITYCity
STATEState
ZIPZIP
PHONE1Phone 1
PHONE2Phone 2
REFNUMInternal reference number
USER1User field 1 description
USER2User field 2 description
EXTRAFIELD1Custom Freeform field 1
EXTRAFIELD2Custom Freeform field 2
EXTRAFIELD3Custom Freeform field 3
EXTRAFIELD4Custom Freeform field 4
EXTRAFIELD5Custom Freeform field 5
EXTRAFIELD6Custom Freeform field 6
EMAILEmail address
FIRSTINFirst check-in date
LASTINLast check-in date
F_LASTFOLIOFolio number from last stay
F_LASTROOMRoom Number from last stay
F_LASTFNAMEFirst Name on folio from last stay
F_LASTLNAMELast name on folio from last stay
F_CHECKINCheckin Date on folio of last stay
F_CHECKOUTCheck Out Date on folio from last stay
F_LASTRATERate Code on folio from last stay
F_LASTGROUPGroup Code on folio from last stay
TOTALSALETotal sale amount
TOTALNIGHTSTotal nights
REQROOMRequested room number
HEARDFROMHeard from
CONTACTVIAContacted from
REFERREDBYReferred by (mailing response information)
GENDERGender
SPOUSESpouse
BIRTHDAYBirthday
ANNIVERSARYAnniversary
PROFESSIONProfession
FOLLOWUPFollow-up flag
MAILNOTEInquiry notes
HOUSENOTEHousekeeping notes
NOTEGuest profile notes.