Contract Template Data Fields
When you specify data fields in a contract template, you can include information like the patron name and address, contact name and address, reservation date, and group itinerary. You can also include transaction information and due dates for the deposit, security deposit, contract, and order balance.
The following table includes a list of the data fields you can include in your contract templates. For examples that illustrate of how these fields are typically used in a contract, see Preconfigured Contract Templates.
Note: You use the ORGANIZATION fields listed in the table to pull your organization’s name, address, phone number, and website address into the contract.
|
Field name |
Description |
|
BUSINESSPROCESSOUTPUT...PKID |
This field is related to a system business process and should not be added to the contract template. |
|
ID |
This field is the systemID for the reservation and should not be added to a contract template. |
|
PATRON_NAME |
Patron name |
|
PATRON_ADDRESS |
Patron address |
|
PATRON_CITY |
Patron city |
|
PATRON_STATE |
Patron state |
|
PATRON_ZIP |
Patron ZIP |
|
CONTACT_NAME |
Contact name |
|
CONTACT_ADDRESS |
Contact address |
|
CONTACT_CITY |
Contact city |
|
CONTACT_STATE |
Contact state |
|
CONTACT_ZIP |
Contact ZIP |
|
CONTACT_PHONE |
Contact phone |
|
CONTACT_EMAIL |
Contact email |
|
ORGANIZATION_NAME |
Name of the organization creating the contract |
|
ORGANIZATION_ADDRESS |
Organization address |
|
ORGANIZATION_CITY |
Organization city |
|
ORGANIZATION_STATE |
Organization state |
|
ORGANIZATION_ZIP |
Organization ZIP |
|
ORGANIZATION_PHONE |
Organization phone |
|
ORGANIZATION_WEB |
Organization website address |
|
ORDER_TOTAL |
Order total |
|
ORDER_BALANCE |
Amount due when the contract is created |
|
BALANCE_AFTER_DEPOSIT |
Remaining balance after deposit (Order total – deposit) |
|
DEPOSIT_AMOUNT |
Deposit amount |
|
DEPOSIT_DUE_DATE |
Deposit due date |
|
FINAL_COUNT_DUE_DATE |
Final count due date |
|
ORDER_BALANCE_DUE_DATE |
Order balance due date |
|
SECURITY_DEPOSIT_AMOUNT |
Security deposit amount |
|
SECURITY_DEPOSIT_DUE_DATE |
Security deposit due date |
|
SECURITY_DEPOSIT_BALANCE |
Security deposit balance |
|
RESERVATION_DATE |
Reservation date |
|
ARRIVAL_TIME |
Arrival time |
|
NUMBER_OF_BUSES |
Number of buses |
|
ARRIVAL_AREA |
Arrival area |
|
NUMBER_OF_VISITORS |
Total number of visitors |
|
FACILITY_BLOCK |
This is a list of the facilities booked by the group, formatted as follows:
Location name - start and end time @ cost
If applicable, repeat for each group on the reservation, with a line break between groups. |
|
ITINERARY_BLOCK |
This is a list of all the items in the group’s itinerary, formatted as follows:
Group name<line break> Item start time - Item name<line break> <repeat for each itinerary item>
Repeat for each group on the reservation, with a line break between groups. |
|
RESOURCES_BLOCK |
This is a list of all the resources attached to the reservation, formatted as follows:
Resource name - Quantity @ unit cost: total cost<line break>
Repeat for each group on the reservation, with a line break between groups. |
| TKTDESC1 | Description #1 |
| TKTSTARTDT1 | Start date #1 |
| TKTSTARTTM1 | Start time #1 |
| TKTQTY1 | Quantity #1 |
| TKTPRICE1 | Price #1 |
| TKTDSC1 | Discount #3 |
| TKTFEE1 | Fee #3 |
| TKTTOTAL1 | Total #3 |
| TKTDESC2 | Description #2 |
| TKTSTARTDT2 | Start date #2 |
| TKTSTARTTM2 | Start time #2 |
| TKTQTY2 | Quantity #2 |
| TKTPRICE2 | Price #2 |
| TKTDSC2 | Discount #2 |
| TKTFEE2 | Fee #2 |
| TKTTOTAL2 | Total #2 |
| TKTDESC3 | Description #3 |
| TKTSTARTDT3 | Start date #3 |
| TKTSTARTTM3 | Start time #3 |
| TKTQTY3 | Quantity #3 |
| TKTPRICE3 | Price #3 |
| TKTDSC3 | Discount #3 |
| TKTFEE3 | Fee #3 |
| TKTTOTAL3 | Total #3 |
| TKTDESC4 | Description #4 |
| TKTSTARTDT4 | Start date #4 |
| TKTSTARTTM4 | Start time #4 |
| TKTQTY4 | Quantity #4 |
| TKTPRICE4 | Price #4 |
| TKTDSC4 | Discount #4 |
| TKTFEE4 | Fee #4 |
|
TKTTOTAL4 |
Total #4 |
| Fields below are displayed if more than 4 price types are associated with this reservation | |
| TKTDESCREST | Field displays as “Other tickets” when additional price types are present |
| TKTQTYREST | Sum total of number of tickets for these additional price types |
| TKTPRICEREST | Sum total of ticket prices for these additional price types |
| TKTDSCREST | Sum total of ticket discounts for these additional price types |
| TKTFEEREST | Sum total of ticket fees for these additional price types |
| TKTTOTALREST | Sum total of tickets sold for these additional price types |
| RSCDESC1 | Name of the resource |
| RSCSTDT1 | Start Date of itinerary-program that is associated with resource |
| RSCENDDT1 | End Date of itinerary-program that is associated with resource |
| RSCQTY1 | Quantity of resource associated with the itinerary |
| RSCPRICE1 | Price of resource associated with the itinerary |
| RSCTOTAL1 | Total price of the resources associated with the itinerary |
| Values for resource #2, #3 and #4 as per #1 details above | |
| RSCDESC2 | Name #2 |
| RSCSTDT2 | Start Date #2 |
| RSCENDDT2 | End Date #2 |
| RSCQTY2 | Resource Quantity #2 |
| RSCPRICE2 | Resource Price #2 |
| RSCTOTAL2 | Resource Total #2 |
| RSCDESC3 | Name #3 |
| RSCSTDT3 | Start Date #3 |
| RSCENDDT3 | End Date #3 |
| RSCQTY3 | Resource Quantity #3 |
| RSCPRICE3 | Resource Price #3 |
| RSCTOTAL3 | Resource Total # |
| RSCDESC4 | Name #4 |
| RSCSTDT4 | Start Date #4 |
| RSCENDDT4 | End Date #4 |
| RSCQTY4 | Resource Quantity #4 |
| RSCPRICE4 | Resource Price #4 |
| RSCTOTAL4 | Resource Total #4 |
| Fields below are displayed if more than 4 resources are connected to the reservation | |
| RSCDESCREST | Field displays as “Other resources” when reservation has more than 4 resources |
| RSCTOTALREST | Total amount based on resources over the 4 count |
| STFTYPE1 | Staffing Resource Name #1 |
| STFNAME1 | Person assigned to this staffing resource #1 |
| STFST1 | Starting Time for this staffing resource #1 |
| STFET1 | Ending time for this staffing resource #1 |
| STFIN1 | Itinerary Name for this resource #1 |
| STFII1 | Itinerary Item for this resource #1 |
| STFOPEN1 | Number of available resources left to assign for this staffing resource |
| STFPRICE1 | Price for this staffing resource #1 |
| Values for staffing resource #2, #3 and #4 as per #1 details above | |
| STFTYPE2 | Staffing Resource Name #2 |
| STFNAME2 | Person assigned to this staffing resource #2 |
| STFST2 | Starting Time for this staffing resource #2 |
| STFET2 | Ending time for this staffing resource #2 |
| STFIN2 | Itinerary Name for this resource #2 |
| STFII2 | Itinerary Item for this resource #2 |
| STFOPEN2 | Number of available resources left to assign for this staffing resource |
| STFPRICE2 | Price for this staffing resource #2 |
| STFTYPE3 | Staffing Resource Name #3 |
| STFNAME3 | Person assigned to this staffing resource #3 |
| STFST3 | Starting Time for this staffing resource #3 |
| STFET3 | Ending time for this staffing resource #3 |
| STFIN3 | Itinerary Name for this resource #3 |
| STFII3 | Itinerary Item for this resource #3 |
| STFOPEN3 | Number of available resources left to assign for this staffing resource |
| STFPRICE3 | Price for this staffing resource #3 |
| STFTYPE4 | Staffing Resource Name #4 |
| STFNAME4 | Person assigned to this staffing resource #4 |
| STFST4 | Starting Time for this staffing resource #4 |
| STFET4 | Ending time for this staffing resource #4 |
| STFIN4 | Itinerary Name for this resource #4 |
| STFII4 | Itinerary Item for this resource #4 |
| STFOPEN4 | Number of available resources left to assign for this staffing resource |
| STFPRICE4 | Price for this staffing resource #4 |
| STFTYPEREST | Field displays as “More staff resources…” when reservation has more than 4 staff resources. |
| ITINNAME1 | Name of itinerary #1 |
| ITINLDR1 | Name of the contact for itinerary #1 |
| ITINGT1 | Group type for itinerary #1 |
| ITINST1 | Start time of the itinerary #1 |
| ITINET1 | End time of the itinerary #1 |
| Values for itineraries #2, #3 and #4 as per #1 details above | |
| ITINNAME2 | Name of itinerary #2 |
| ITINLDR2 | Name of the contact for itinerary #2 |
| ITINGT2 | Group type for itinerary #2 |
| ITINST2 | Start time of the itinerary #2 |
| ITINET2 | End time of the itinerary #2 |
| ITINNAME3 | Name of itinerary #3 |
| ITINLDR3 | Name of the contact for itinerary #3 |
| ITINGT3 | Group type for itinerary #3 |
| ITINST3 | Start time of the itinerary #3 |
| ITINET3 | End time of the itinerary #3 |
| ITINNAME4 | Name of itinerary #4 |
| ITINLDR4 | Name of the contact for itinerary #4 |
| ITINGT4 | Group type for itinerary #4 |
| ITINST4 | Start time of the itinerary #4 |
| ITINET4 | End time of the itinerary #4 |
| ITINNAMEREST | Field displays as “Other Itineraries” when reservation has more than 4 itineraries |
| RESERVATIONNAME | Name of the reservation |
| ORDERID | Sales Order ID # |
| CONTRACTCREATEDDATE | Date contract was created |
| IMPORTANTNOTES | Important Notes Field |