Home > Technical > Table Definitions > B2BEMAILTEMPLATE

B2BEMAILTEMPLATE

Used as a template for sending emails to new loyalty members informing them that they have successfully joined the scheme and advise them on the rules and regulations and on how to earn and use points.

Column

Type

Description

STRTEMPLATECODE

VARCHER(10)

Unique identifier.

STRTEMPLATETYPE VARCHER(10)

NEWMEMBER to specify a new Loyalty member email, or STATEMENT, reserved for future use.

STRTEMPLATEDESCRIPTION VARCHAR(50)

A simple description of the template.

STRTEMPLATESUBJECT VARCHAR(250)

The email subject.

STRTEMPLATEMESSAGE VARCHAR(1000)

The email message (body). When specifying the email message, certain token fields can be replaced automatically by the system. At present the token if used will be replaced by the customers Title and Last Name fields.

Example Template:

Dear

Welcome to our Loyalty scheme.

We hope you enjoy this service for details and terms and conditions please visit our website. http://www.torex.com/Loyalty

  

Primary Key:

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)