Home > Technical > Table Definitions > 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) |