Departure Placeholders

Back to Top
The following table provides all of the placeholder values for attributes on the Departure form.  These must be used outside of any section placeholders.

Attribute Label Placeholder Notes
# Tour Days {p15_tripdepartures.p15_tourdays}  
Avail as Template? {p15_tripdepartures.p15_availastemplate}  
Available Spaces {p15_tripdepartures.p15_availablespaces}  
Booked Guests {p15_tripdepartures.p15_bookedguestcount}  
Client {clientname} or
{p15_tripdepartures.p15_clientid}
 
     First Name {p15_clientid.firstname}  
     Last Name {p15_clientid.lastname}  
     Email {p15_clientid.emailaddress1}  
     etc... {p15_clientid."contact attribute name"}  
Comment {p15_tripdepartures.p15_comment} See Text Formatting
Default Commission {p15_tripdepartures.p15_defaultcommission} See Number Formatting
Departure Code {p15_tripdepartures.p15_departurecode}  
Departure Name {p15_tripdepartures.p15_name}  
*Departure Dates {departuredates} The departure's start and end dates, formatted as a condensed string (e.g., January 1 - 8, 2013). See Date Formatting
End Date {enddate} or
{p15_tripdepartures.p15_enddate}
See Departure Dates placeholder. See Date Formatting
Estimated Guests {p15_tripdepartures.p15_estimatedguests} Deprecated
Exclusions {p15_tripdepartures.p15_exclusions} See Text Formatting
Final Itinerary Template {p15_tripdepartures.p15_itinerarytemplate3id}  
From Price {p15_tripdepartures.p15_fromprice}  
Held Spaces {p15_tripdepartures.p15_spacesheld}  
Inclusions {p15_tripdepartures.p15_inclusions} See Text Formatting
Leader {p15_tripdepartures.p15_primaryleaderid}  
Max Guests {p15_tripdepartures.p15_maxguests}  
Min Guests {p15_tripdepartures.p15_minguests}  
Operational Itinerary Template {p15_tripdepartures.p15_itinerarytemplate4id}  
Outline Itinerary Template {p15_tripdepartures.p15_itinerarytemplate1id}  
Owner {p15_tripdepartures.ownerid}  
     First Name {ownerid.firstname}  
     Last Name {ownerid.lastname}  
     Email {ownerid.internalemailaddress}  
     Job Title {ownerid.jobtitle}  
     etc... {ownerid."user attribute name"}  
Payment Schedule    
     Name {p15_tripdepartures.p15_paymentscheduleid} or
{p15_paymentschedules.p15_name}
 
     Description of Payment Terms {p15_paymentschedules.p15_descriptionofterms} See Text Formatting
     Description of Cancellation Terms {p15_paymentschedules.p15_descriptionofcancellationterms} See Text Formatting
     Comment {p15_paymentschedules.p15_comment} See Text Formatting
Price Description {p15_tripdepartures.p15_pricedescription} See Text Formatting
Price Unit {p15_tripdepartures.p15_priceunit}  
Proposal Itinerary Template {p15_tripdepartures.p15_itinerarytemplate2id}  
Start Date {startdate} or
{p15_tripdepartures.p15_startdate}
See Departure Dates Placeholder. See Date Formatting
Trip {tripname} or
{p15_tripdepartures.p15_tripid}
 


Trip Placeholders

Back to Top
The following table provides all of the placeholder values for attributes on the Trip form.   These must be used outside of any section placeholders.

Attribute Label Placeholder Notes
Available as a Template {p15_trips.p15_availableasatemplate}  
Client {p15_trips.p15_contacttripsid}  
Comfort {p15_trips.p15_comfort}  
Comment {p15_trips.p15_comment} See Text Formatting
Default Commission {p15_trips.p15_defaultcommissionpct} See Number Formatting
Description {p15_trips.p15_description} See Text Formatting
Difficulty {p15_trips.p15_difficulty}  
Display On Web? {p15_trips.p15_displayonweb}  
Duration (Days) {p15_trips.p15_numtourdays}  
Duration Description {p15_trips.p15_tripduration} See Text Formatting
Exclusions {p15_trips.p15_exclusions} See Text Formatting
From Price {p15_trips.p15_fromprice} See Number Formatting
Inclusions {p15_trips.p15_inclusions} See Text Formatting
Maximum Guests {p15_trips.p15_maxguests}  
Minimum Guests {p15_trips.p15_minguests}  
Owner {p15_trips.ownerid}  
Payment Schedule {p15_trips.p15_paymentscheduleid}  
Price Description {p15_trips.p15_pricedescription} See Text Formatting
Primary Destination   Also see Other Destination Placeholders
     Name {p15_trips.p15_primarydestinationid} or
{destination.p15_name}
 
     Description {destination.p15_description} See Text Formatting
     Type {destination.p15_destinationtype}  
     Parent Destination Name {destination.p15_parentdestinationid}  
     Image URL {destinationimage.url} See Image Formatting
     Image Name  {destinationimage.name}  
     Image Description {destinationimage.description} See Text Formatting
     Image File (Depcreated) {destinationimage.file} Use Image URL instead
Primary Trip Activity {p15_trips.p15_primarytripactivityid}  
Team {p15_trips.p15_teamid}  
Trip Code {p15_trips.p15_tripcode}  
Trip Name {tripname} or
{p15_trips.p15_tripname}
 
Trip Type {p15_trips.p15_triptypestotripsid}  


Cost Placeholders

Back to Top
There are two types of Cost-related Placeholders -- those that summarize information across multiple costs and those that only ever contain detailed information from a specific cost.

The following Cost Summary Placeholders must be used inside of a {departureday.begin} and {departureday.end} or {costing.begin} and {costing.end} section BUT NOT INSIDE of a {repeater.begin} and {repeater.end} section.

Attribute Label Placeholder Notes
*Date {date} The date or dates on which the costs being evaluated occur. See Date Formatting
*Day {day} The numeric day or days on which the costs being evaluated occur.
*Destinations {destinations} A list of start time ordered, dash seperated start and end destinations for the costs being evaluated (e.g., "Destination 1 - Destination 2 - Destination 3).
*Meals {meals} Looks at cost or costs being evaluated and returns a comma-separated list of meal codes (e.g.,"B,D"). If no meal is found, a value of "None" is returned by default. Must be used inside {departureday.begin} and {departureday.end} but outside of {repeater.begin} and {repeater.end}. See Meal Formatting for instructions on how to apply other formatting.
Amount (Base) {p15_tier1_amount_base} Deprecated and replaced with ability to export Planner to Excel
    *Cost Amount Grandtotal (Base) {costamountgrandtotal} Deprecated and replaced with ability to export Planner to Excel
    *Cost Amount Grandtotal - All (Base) {costamountgrandtotal-all} Deprecated and replaced with ability to export Planner to Excel
    *Selling Amount Grandtotal (Base) {sellingamountgrandtotal} Deprecated and replaced with ability to export Planner to Excel
    *Selling Amount Grandtotal - All (Base) {sellingamountgrandtotal-all} Deprecated and replaced with ability to export Planner to Excel


Cost Detail Placeholders

Back to Top
The following Cost Detail Placeholder must be used inside of a {departureday.begin} and {departureday.end} or {costing.begin} and {costing.end} section AND ALSO INSIDE of a {repeater.begin} and {repeater.end} section if you wish to include more than just the first cost record returned on a given day.

Attribute Label Placeholder Notes
Amount {p15_tier1_amount} Deprecated and replaced with ability to export Planner to Excel
Amount (Base) {p15_tier1_amount_base} Deprecated and replaced with ability to export Planner to Excel
    *Cost Amount (Base) {costamount} Deprecated and replaced with ability to export Planner to Excel
    *Selling Amount (Base) {sellingamount} Deprecated and replaced with ability to export Planner to Excel
    *Cost Units {costunits} Deprecated and replaced with ability to export Planner to Excel
    *Cost Amount Total (Base) {costamounttotal} Deprecated and replaced with ability to export Planner to Excel
    *Selling Amount Total (Base) {sellingamounttotal} Deprecated and replaced with ability to export Planner to Excel
Breakfast {p15_mealsbreakfast} See Meals Placeholder
Breakfast Day(s) {p15_mealsbreakfastdays} See Meals Placeholder
Brief Description {p15_description1} See Text Formatting
Brief Room Description {p15_accomdescription1} See Text Formatting
Cancel by (Days Prior) {p15_cancelbydaysprior}
Cancel by Date {p15_cancelbydate} See Date Formatting
Capacity {p15_capacity}
Category {p15_costcategoryid}
Company {vendorname} or
{p15_companyid}
Also see Company Placeholders
    *Company Brief Description {vendor_briefdescription} or
{p15_company.p15_description2}
See Text Formatting
    *Company Full Description {vendor_fulldescription} or
{p15_company.description}
See Text Formatting
Confirmation # {p15_confirmation}
Currency {transactioncurrencyid}
Days {p15_days}
Dinner {p15_mealsdinner} See Meals Placeholder
Dinner Day(s) {p15_mealsdinnerdays} See Meals Placeholder
Duration Type {p15_durationtype}
End Date {p15_enddate} See Date and Day Placeholders. See Date Formatting
End Destination  
    Name {costenddestination.p15_name} Also see Destinations Placeholder 
    Description {costenddestination.p15_description} See Text Formatting
    Type {costenddestination.p15_destinationtype}  
    Parent Destination Name {costenddestination.p15_parentdestinationid}  
    Image URL {costenddestinationimage.url} See Image Formatting
    Image Name {costenddestinationimage.name}  
    Image Description {costenddestinationimage.description} See Text Formatting
    Image File (Deprecated) {costenddestinationimage.file} Use Image URL instead
End Time {p15_endtime}
Exchange Rate {p15_exchangerateid}
Exclusions {p15_exclusions} See Text Formatting
Final Itinerary {p15_itineraryfinal}
Full Description {fulldescription} or
{p15_description2}
See Text Formatting
Full Room Description {p15_accomdescription2} See Text Formatting
Hours {p15_hours}
Image  
     Image URL {image.url} See Image Formatting
    Name {image.name}  
    Description {image.description} See Text Formatting
    File (Deprecated) {image.file} Use Image URL instead
Inclusions {p15_inclusions} See Text Formatting
Lunch {p15_mealslunch} See Meals Placeholder
Lunch Day(s) {p15_mealslunchdays} See Meals Placeholder
Manual Reservation Amount {p15_reservationamount} See Number Formatting
Manual Reservation Amount (Base) {p15_reservationamount_base} See Number Formatting
Maximum Amount {p15_maximumamount} See Number Formatting
Maximum Amount (Base) {p15_maximumamount_base} See Number Formatting
Maximum Type {p15_maximumtype}
Name {p15_name}
Nights {p15_nights} See Date and Day Placeholders
Operational Comments {p15_operationalcomments} See Text Formatting
Operations Itinerary {p15_itineraryoperations}
Outline Itinerary {p15_itineraryoutline}
Owner {ownerid}
Percentage {p15_percentage} See Number Formatting
Proposal Itinerary {p15_itineraryproposal}
Recommendations {p15_recommendations} See Text Formatting
Reservation # {p15_reservationnumber}
Reservation Amount Method {p15_reservationamountmethod}
Reservation Date {p15_reservationdate} See Date Formatting
Reservation Description {p15_comment} See Text Formatting
Reserved With {p15_reservedwithid}
Start Date {p15_startdate} See Date and Day Placeholders. See Date Formatting
Start Day {p15_startday} See Date and Day Placeholders
Start Destination  
    Name {coststartdestination.p15_name} Also see Destinations Placeholder   
    Description {coststartdestination.p15_description} See Text Formatting
    Type {coststartdestination.p15_destinationtype}  
    Parent Destination Name {coststartdestination.p15_parentdestinationid}  
    Image File (Deprecated) {coststartdestinationimage.file} Use Image URL instead
    Image URL {coststartdestinationimage.url} See Image Formatting
    Image Name {coststartdestinationimage.name}  
    Image Description {coststartdestinationimage.description} See Text Formatting
    Image File (Deprecated) {coststartdestinationimage.file} Use Image URL instead
Start Time {p15_starttime}
Multiple Rates {p15_displaytiers}
Unit {p15_unit}


Cost Filters

Back to Top
The following Cost Filters must be used inside of a {departureday.begin} and {departureday.end} or {costing.begin} and {costing.end} section BUT NOT INSIDE of a {repeater.begin} and {repeater.end} section.

Cost Category Filter Notes
Accommodation {accommodations.begin} and {accommodations.end}  
Activity {activities.begin} and {activities.end}  
Meal {meals.begin} and {meals.end}  
Package {packages.begin} and {packages.end}  
Transfer {transfers.begin} and {transfers.end}  
Other {others.begin} and {others.end}  
Multiple Category Types Example: {activities&meals&transfers.begin} and {activities&meals&transfers.end} The order in which multiple category types appear is not relevant


Price Placeholders

Back to Top
The following table provides all of the placeholder values for attributes on the Price form.  These must be used inside of a {pricing.begin} and {pricing.end} section. If you wish to include pricing for multiple group sizes, these must also used inside of {guestrepeater.begin} and {guestrepeater.end} placeholders. See Multiple Group Size Sample.

Attribute Label Placeholder Notes
*Amount {amount} In currency specified on the price. If the price is tiered, will display the price amount based on the estimated scenario from the departure. See Number Formatting.
*Amount (base) {amount_base} In base or home currency of the organization. If the price is tiered, will display the price amount based on the estimated scenario from the departure. See Number Formatting.
    *Amount Total {amounttotal} Sum of the Amounts (in the currency specified on the price) of the currently filtered list of Prices. Note: If the filtered Prices have different currencies, will show in the base or home currency of the organization. See Number Formatting
    *Amount Total (base) {amounttotal_base} Sum of the Amounts (in the base or home currency of the organization) of the currently filtered list of Prices. See Number Formatting
    *Amount Total - All {amounttotal-all} Sum of the Amounts (in the currency specified on the price) of all Prices. Note: If the Prices have different currencies, will show in the base or home currency of the organization. See Number Formatting
    *Amount Total - All (base) {amounttotal-all_base} Sum of the Amounts (in the base or home currency of the organization) of all Prices. See Number Formatting
Category {p15_pricecategoryid}
Comment {p15_comment} See Text Formatting
Currency {transactioncurrencyid}
*Est # of Guests {estimatedguests Deprecated and replaced with ability to export Planner to Excel
Guest Group Size {guestgroupsize} Deprecated and replaced with ability to export Planner to Excel
Est % of Guests {p15_includeinfinancials} Deprecated and replaced with ability to export Planner to Excel
Guest Type {p15_guesttype}
Max # of Guests {p15_maximumguests}
Max # of Units {p15_maximumavailable}
Occupancy {p15_occupancytype} Deprecated and replaced with Rate Type
Optional {p15_optional}
Owner {ownerid}
Percentage {p15_percentage} See Number Formatting
Name {p15_pricename}
Rate Type {p15_ratetype}
Tiered {p15_displaytiers}
*Total {total} Amount (in the currency specified on the Price) x Est # of Guests. See Number Formatting
*Total (base) {totalbase} Deprecated and replaced with ability to export Planner to Excel
    *Grand Total {grandtotal} Deprecated and replaced with ability to export Planner to Excel
    *Grand Total (base) {grandtotalbase} Deprecated and replaced with ability to export Planner to Excel
    *Grant Total - All {grandtotal-all} Deprecated and replaced with ability to export Planner to Excel
    *Grant Total - All (base) {grandtotal-all_base} Deprecated and replaced with ability to export Planner to Excel
Unit {p15_unit}


Price Filters

Back to Top
The following Price Filters must be used inside of a {pricing.begin} and {pricing.end} section BUT NOT INSIDE of a {repeater.begin} and {repeater.end} section.

Price Category Sub Type Filter Notes
Standard (NULL) {pricecategory.null.begin} and {pricecategory.null.end}  
Add On {pricecategory.addon.begin} and {pricecategory.addon.end}  
Cancellation Fee {pricecategory.cancellationfee.begin} and {pricecategory.cancellationfee.end}  
Discount {pricecategory.discount.begin} and {pricecategory.discount.end}  
Single Supplement {pricecategory.singlesupplement.begin} and {pricecategory.singlesupplement.end}  
Other {pricecategory.other.begin} and {pricecategory.other.end}  
NOTE: Combination filters ARE NOT supported in the pricing section


Company Placeholders

Back to Top
The following table provides all of the placeholder values for attributes on the Company form.  These must be used inside of a {departureday.begin} and {departureday.end} or {costing.begin} and {costing.end} section.

Attribute Label Placeholder Notes
Accounting Code {p15_company.p15_externalaccountingcode}  
Address 1: City {p15_company.address1_city}  
Address 1: Comment {p15_company.address1_name}  
Address 1: Country/Region {p15_company.address1_country}  
Address 1: County {p15_company.address1_county}  
Address 1: State/Province {p15_company.address1_stateorprovince}  
Address 1: Street 1 {p15_company.address1_line1}  
Address 1: Street 2 {p15_company.address1_line2}  
Address 1: ZIP/Postal Code {p15_company.address1_postalcode}  
Address 2: City {p15_company.address2_city}  
Address 2: Comment {p15_company.address2_name}  
Address 2: Country/Region {p15_company.address2_country}  
Address 2: County {p15_company.address2_county}  
Address 2: State/Province {p15_company.address2_stateorprovince}  
Address 2: Street 1 {p15_company.address2_line1}  
Address 2: Street 2 {p15_company.address2_line2}  
Address 2: ZIP/Postal Code {p15_company.address2_postalcode}  
Brief Description {p15_company.p15_description2} Text
Cancel by (Days Prior) {p15_company.p15_cancelbydaysprior}  
Client Rating {p15_company.p15_clientrating}  
Comments {p15_company.p15_comments} See Text Formatting
Commission % {p15_company.p15_commission_dec} See Number Formatting
Company Name {p15_company.name}  
Company Type {p15_company.p15_companytypecompanyid}  
Currency {p15_company.transactioncurrencyid}  
Default Agency Commission {p15_company.p15_agencycommissionratedec} See Number Formatting
Default Vendor Bill Payment Automation Level {p15_company.p15_automationlevel}  
Default Vendor Bill Payment Method {p15_company.p15_vendorbillpaymentmethod}  
Default Vendor Bill Payment Schedule {p15_company.p15_vendorbilllingscheduleid}  
Do not allow Bulk E-mails {p15_company.donotbulkemail}  
Do not allow Bulk Mails {p15_company.donotbulkpostalmail}  
Do not allow E-mails {p15_company.donotemail}  
Do not allow Faxes {p15_company.donotfax}  
Do not allow Mails {p15_company.donotpostalmail}  
Do not allow Phone Calls {p15_company.donotphone}  
E-mail {p15_company.emailaddress1}  
E-mail Address 2 {p15_company.emailaddress2}  
E-mail Address 3 {p15_company.emailaddress3}  
Emergency Phone {p15_company.p15_emergencyphone}  
Fax {p15_company.fax}  
Full Description {p15_company.description} See Text Formatting
IATA Code {p15_company.p15_iatacode}  
Image    
    URL {vendorimage.url} See Image Formatting
    Name {vendorimage.name}  
    Description {vendorimage.description} See Text Formatting
    File (Deprecated) {vendorimage.file} Use Image URL instead
Industry Rating {p15_company.p15_industryrating}  
Internal Rating {p15_company.p15_internalrating}  
Last Date Included in Campaign {p15_company.lastusedincampaign}  
Legal Name {p15_company.p15_legalname}  
Main Phone {p15_company.telephone1}  
Other Phone {p15_company.telephone2}  
Owner {p15_company.ownerid}  
Parent Company {p15_company.parentaccountid}  
Payment Relationship {p15_company.p15_paymentrelationship}  
Primary Contact {p15_company.primarycontactid}  
Send Marketing Materials {p15_company.donotsendmm}  
Send Roster (Days Prior) {p15_company.p15_sendrosterdaysprior}  
Tax on Gross % {p15_company.p15_taxongross_dec}  
Tax on Net % {p15_company.p15_taxonnet_dec}  
Telephone 3 {p15_company.telephone3}  
Travel Agency Network {p15_company.p15_travelagencynetworkid}  
Web Site {p15_company.websiteurl}  


Other Destination Placeholders

Back to Top
This section will pull an alphabetical list of destinations based on destinations listed under the "Other Destinations" folder of the Trip form. The following table provides all of the placeholder values for attributes on the Destination form.  These must be used inside of a {otherdestinations.begin} and {otherdestinations.end} section.

Attribute Label Placeholder Notes
Destination Name {otherdestinations.p15_name}  
Description {otherdestinations.p15_description} See Text Formatting
Type {otherdestinations.p15_destinationtype}  
Parent Destination {otherdestinations.p15_parentdestinationid}  
Image    
    URL {otherdestinationsimage.url} See Image Formatting
    Name {otherdestinationsimage.name}  
    Description {otherdestinationsimage.description} See Text Formatting
    File (Deprecated) {otherdestinationsimage.file} Use Image URL instead


All Destination Placeholders

Back to Top
This section pulls an alphabetical list of all destinations, including the Primary Destination, Other Destinations and Cost Start and End Destinations.of destinations based on destinations listed under the "Other Destinations" folder of the Trip formThe following table provides all of the placeholder values for attributes on the Destination form.  These must be used inside of a {destinations.begin} and {destinations.end} section.

Attribute Label Placeholder Notes
Destination Name {destination.p15_name}  
Description {destination.p15_description} See Text Formatting
Type {destination.p15_destinationtype}  
Parent Destination {destination.p15_parentdestinationid}  
Image    
    URL {destinationimage.url} See Image Formatting
    Name {destinationimage.name}  
    Description {destinationimage.description} See Text Formatting
    File (Deprecated) {destinationimage.file} Use Image URL instead


Destination Filters

Back to Top
The following Destination Filters must be used inside of a {destinations.begin} and {destinations.end} section or a {otherdestinations.begin} and {otherdestinations.end} section.

Destination Type Filter Notes
Continent {continent.begin} and {continent.end}  
Continental Section {continentalsection.begin} and {continentalsection.end}  
Country {country.begin} and {country.end}  
Region {region.begin} and {region.end}  
City {city.begin} and {city.end}  
District {district.begin} and {district.end}  
Attraction {attraction.begin} and {attraction.end}  
Airport {airport.begin} and {airport.end}  
NOTE: Combination filters ARE NOT supported in the destination section