Phone: (248) 374-0510       Email: sales@koalainc.com

 
Koala Home    |    Tutorial Index    |    Support Index    |    Context Help Index    |    Information Request / Problem Report    |    Contact Us

 
What is a Substitution Field?

It may sound complex, but when you use your computer to design a quote or a form letter a "Substitution Field" is a placeholder to mark where MLS 2000 should place information.

For example, in a form letter if you want to create a form letter that says the following:

Dear Bob,

Thank you for responding to our advertisement. We have put Acme Machinery on our mailing list and will send you notifications before all of our auctions.

Sincerely,

John Doe

Obviously, you don't want each letter to say "Dear Bob". You want to SUBSTITE the name of the specific customer. Instead you put a "Substitution Field" to mark the spot and information to substitute.

ALL SUBSTITUTION FIELD START AND END WITH THE CHARACTERS "~~".

In our example, to substitute the customer's first name the substitution field is "~~CN_FIRST~~". Using this and other substitutions, the form letter becomes:

Dear ~~CN_FIRST~~,

Thank you for responding to our advertisement. We have put ~~CP_NAME~~ on our mailing list and will send you notifications before all of our auctions.

Sincerely,

~~SYS_USERNM~~

Below is a comprehensive list of substitution fields that may be available. NOT ALL VARIABLES ARE AVAILABLE IN ALL SITUATIONS! Some are only available when quoting equipment, others are only available when sending customers form letters.

~~ Variables available for use in template
   
Equipment variables (Available when designing quote documents)
~~AV_CODE~~   6 digit equipment code
~~AV_REFCODE~~   6 digit equipment code
~~AV_KEY6~~   The 6th key lookup field
~~AV_KEY7~~   The 7th key lookup field
~~AV_KEY8~~   The 8th key lookup field
~~AV_DESCSH~~   Short description
~~AV_DESCAD~~   Advertising description
~~AV_DESCLN~~   Full description
~~AV_SELL~~   Selling price
Customer / Contact variables (Available when designing both form letters and quote documents)
~~CN_ATTN~~   Attention to person name
~~CONTACTNAME~~   First and last name
~~CN_GREET~~   Contact greeting field
~~CN_FIRST~~   Contact first name
~~CN_LAST~~   Contact last name
~~CN_TITLE~~   Contact title
~~CP_EMAIL~~   Contact email
~~CN_FAX~~   Contact fax number
~~CP_NAME~~   Customer company name
~~CP_ADDR1~~   Customer address line 1
~~CP_ADDR2~~   Customer address line 2
~~CP_ADDR3~~   Customer address line 3
~~CP_CITY~~   Customer city
~~CP_STATE~~   Customer state
~~CP_ZIP~~   Customer zip code
~~CP_COUNTRY~~   Customer country
Your system variables (Available everywhere)
~~SYS_USERNM~~   LocPlus MLS user name
~~SYS_CLIENT_NAME~~   Your company name
~~SYS_CLIENT_ADDR1~~   Your address line 1
~~SYS_CLIENT_ADDR2~~   Your address line 2
~~SYS_CLIENT_ADDR3~~   Your address line 3
~~SYS_CLIENT_CITY~~   Your city
~~SYS_CLIENT_STATE~~   Your state
~~SYS_CLIENT_PHONE~~   Your phone #
~~SYS_CLIENT_FAX~~   Your fax #
~~SYS_CLIENT_EMAIL~~   Your email address
Quotes only:
~~QP_ALINE1~~   Quote address line 1
~~QP_ALINE2~~   Quote address line 2
~~QP_ALINE3~~   Quote address line 3
~~QP_ALINE4~~   Quote address line 4
~~QP_ALINE5~~   Quote address line 5
~~QE_MESS~~   Quote message
~~QE_TERMS~~   Terms of quote
~~QE_PRICE~~   Price quoted
~~SP_FNAME~~   Salesperson first name
~~SP_LNAME~~   Salesperson last name
~~SP_TITLE~~   Salesperson title
Form letters only:
~~RPMESSAGE~~   Contents of the Message field in Form letter
~~RPMESSAGE1~~   Answer to the first "ASK FOR" question
~~RPMESSAGE2~~   Answer to the second "ASK FOR" question