The following table lists the template codes you can use in this report. Note that the code must include the brackets around it or it will not function properly in your template. You can copy the code from the list below and paste it directly into your template and the template will pull the corresponding data into your report.
Code |
Code Description |
|
|
| Template Codes | |
[tDate] |
Template Printed Date - MM/DD/YYYY |
[tDateL] |
Template Printed Date - Long (e.g. Friday, March 30, 2007) |
[tDateSt] |
Template Start Date - MM/DD/YYYY |
[tDateEnd] |
Template End Date - MM/DD/YYYY |
[tDescription] |
Template Description |
[tSort] |
Template Sorted By |
[tTime] |
Template Printed Time |
| Group Level Codes | |
[rGrpHdr] |
Group Header Title |
| [rRevTot] | Total Revenue |
| Detail Level Codes: Customer | |
|
|
[cFullName] |
Customer full name |
[cFirst] |
Customer first name |
[cLast] |
Customer last name |
[cCompany] |
Customer company name |
[cOthrName] |
Customer other names |
[cPrefix] |
Customer name prefix (e.g. Mr, Ms, Mrs) |
[cAddr1] |
Customer address 1 |
[cAddr2] |
Customer address 2 |
[cCity] |
Customer city |
[cST] |
Customer state / province (short format, e.g. TX) |
[cSTLong] |
Customer state / province (long format, e.g. Texas) |
[cZip] |
Customer zip code / postal code |
[cCountry] |
Customer country |
[cPhWork] |
Customer work phone |
[cPhHome] |
Customer home phone |
[cPhMobile] |
Customer mobile phone |
[cPhAll] |
Customer phone (all) |
[cEmail1] |
Customer email 1 |
[cEmail2] |
Customer email 2 |
[cEmailAll] |
Customer email (all) |
[cOccasionAll] |
Customer occasions |
[cSource] |
Customer source |
[cNotes] |
Customer notes |
[cCstmFld1] |
Customer custom field 1 |
[cCstmFld2] |
Customer custom field 2 |
[cCstmFld3] |
Customer custom field 3 |
[cCstmFld4] |
Customer custom field 4 |
[cCstmFld5] |
Customer custom field 5 |
[cCstmFld6] |
Customer custom field 6 |
|
|
Detail Level Codes: Reservation |
|
|
|
[sConfNum] |
Reservation confirmation number |
[sStatus] |
Reservation status |
[sDtMade] |
Date reservation made |
[sDayMade] |
Day of week reservation made (e.g. Sat) |
[sTakenBy] |
Name of user that recorded reservation |
[sCkInDt] |
Check in date |
[sCkOtDt] |
Check out date |
[sCkInTm] |
Check in time |
[sCkOtTm] |
Check out time |
[sNumNt] |
Number of nights |
[sGstName] |
Primary guest name |
[sNumGst] |
Number of guests |
[sNumAd] |
Number of adults |
[sNumCh] |
Number of children |
[sRooms] |
Rooms assigned - listed by room name |
[rRmType] |
Rooms assigned - listed by room type |
[rRmAbbr] |
Rooms assigned - listed by room abbreviation |
[sRoomsDescription] |
Room description, in the format: Room 1: Room Description. If multiple rooms, descriptions for all rooms are listed. |
[sAvgRate] |
Average daily rate |
[sRateType] |
Rate type booked (e.g. Rack, BedandBreakfast.com, etc.) |
[sLodgingPackages] |
Lodging packages booked |
[sAddonPackages] |
Addon packages booked |
[sLnDt] |
Line item date |
[rTaxDtl] |
Tax detail |
[rRev] |
Total revenue |
[sTax] |
Total tax |
[sTotal] |
Total after tax |
[sPaid] |
Amount paid |
[sDue] |
Amount due |
[sDueToday] |
Amount due today |
[sPastDue] |
Amount past due |
[sDep] |
Deposit paid |
[sDepUsed] |
Deposit used |
[DepUsedToday] |
Deposit used today |
[sHoldCard] |
Credit card hold |
[sNotesGst] |
Guest notes |
[sNotesInt] |
Internal notes |
[sSource] |
Reservation source |
[sReason] |
Reservation reason for stay |
[sCstmFld1] |
Custom field 1 |
[sCstmFld2] |
Custom field 2 |
[sCstmFld3] |
Custom field 3 |
[sCstmFld4] |
Custom field 4 |
[sCstmFld5] |
Custom field 5 |
[sCstmFld6] |
Custom field 6 |
[sCstmChk1] |
Custom checkbox 1 |
[sCstmChk2] |
Custom checkbox 2 |
[sCstmChk3] |
Custom checkbox 3 |
[sCstmChk4] |
Custom checkbox 4 |
[sCstmChk5] |
Custom checkbox 5 |
[sCstmChk6] |
Custom checkbox 6 |