Template Fields
${field:name} ${textfield:name} limit 500 chars ${date:today} ${date:fillin} ${date:datefield}
contact.full_name: name
contact.bus_phone: was tl1
contact.bus_email: was uemailbus
contact.per_phone: was tl2
contact.per_email: was uemailpers
contact.add_phone: was uaddphone
contact.drivers_licence: drivers license no
contact.drivers_licexp: drivers lic expiration
contact.ssn: social security no
contact.gender: M or F
Account Information based on the currently selected Master
${field:_master.name} ${field:_master.company} ${field:_master.user} ${field:_master.dba} ${field:_master.initials}
${date:today} - today's date ${date:fillin} - //YYYY (current year) ${date:rev} - in footer to show revision date of the file and the filename
id
slid
acct1
acct2
territory
iid
pid
fr_pid
fr_id
sid
company_name
address1
address2
city
state
zip
zipx
county
country
site_company_name
site_address1
site_address2
site_city
site_state
site_zip
site_zipx
site_county
site_country
site_contact
call_date
call_time
appt_date
appt_time
walkthru_date
nostart_date
start_date
cancel_date
effective_cancel
janitorial_amt
salutation
ein
sic_code
sic2
test_date
test_score
ulead
uinspclass
bill_amt
uica
total_sf
uphone
upriority
frequency
days_cleaned
time_window
current_svc_provider
supply_liners
county_licence
city_license
county_licexp
city_licexp
building_type
supply_restroom
tenant
alarm_code
territory_info
state_registered
weekly_specs
manhours_perday
monthly_1
monthly_2
control_no
monthly_3
lead_initials
rescheduled
reason_code
reason_note
monthly_4
bimonthly
quarterly
semi_anually
salesrep
inspector
opsrep
ufdd
supply_amt
porter_amt
porter_hrs
porter_rate
last_rate
vynl_sf
carpet_sf
concrete_sf
ceramic_sf
directions
directions2
other_sf
floor_type
last_inspection
last_inspector
next_inspection
umonths
udatesold
ubiddate
ubiddel
ubustype
uhotbutton
deliv_method
note_collected
note_status
current_business
candidate_name
network
assign_date
candidate_phone
price
fax_number
comments
mem
entry
updated
con
tl1
uemailbus
touch
batch
transferid
contact_id
contract_id
naics
lat
lng
keywords
bill_id
billing_method
billing_email
fr_company_name
acct.acct2
acct.billing_name
acct.billing_address
acct.billing_city
acct.billing_state
acct.billing_zip
acct.billing_zipx
acct.billing_county
acct.billing_country
acct.billing_contact
acct.billing_email
acct.billing_phone
acct.terms
acct.invoice_instructions
contact.full_name
contact.bus_email
contact.per_email
contact.bus_phone
contact.per_phone
contact.title
contact.add_phone
contact.ssn
contact.gender
contact.bday
contact.drivers_license
contact.drivers_licexp
contact.drivers_insexp
utm.entry
utm.source
utm.vendor
utm.name
utm.content
pp_blue
pp_orange
pp_platinum
pp_amount
disclosure_date
fdd_number
fdd_issuance
purchase_date or upurchased
cancel_date
cancel_reason or reason_code
cancel_note or reason_note
note_collected
fran_no
program
program_ib
ib_owed
ib_start_date
ib_offer_filled
ib_days_filled
days_per_item5
franchise_fee
equip_waiver
pp_financed or finance_amt
pp_monthly or fa_monthly
pp_months or fa_months
pp_terms or fr_terms
dp_total
dp_financed
interest_rate int_rate
dp_monthly
dp_months
dp_terms
gpo
gpo_effective
master.user
master.fname
master.lnamemaster.namemaster.company
master.initials
master.dba
master.addr1
master.addr2master.citymaster.statemaster.zipmaster.zipx
master.county
master.country
master.lang
master.phonemaster.mobilemaster.website
master.mailing_company
master.mailingaddr1
master.mailingaddr2
master.mailingcity
master.mailingstate
master.mailingzip
master.mailingzipx
master.mailingcounty
master.mailingcountry
master.acct
master.remitToHtml