reply_template_body table - SuperOffice

reply_template_body Table (279)

Contains the body of the reply templates in different languages

Fields

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
reply_template_id	Links the body to a reply template	FK reply_template	No
language_id	Links the body to a reply template	FK cust_lang	No
flags	Identifies the status of the template body. Default, not default etc.	Enum ReplyTemplateBodyFlags	No
body_plain	The plain text version of the body.	Clob	Yes
body_html	The html version of the body.	Clob	Yes
subject	Subject of the outgoing message. Ignored if not needed	Clob	Yes
headers	Additional headers. Optional	Clob	Yes
body_sms	The sms version of the body.	Clob	Yes

Indexes

Fields	Types	Description
reply_template_id	FK	Index
language_id	FK	Index

Relationships

Table	Description
cust_lang	This table contains entries for customer languages.
reply_template	Templates for automatic and manual replies to emails/sms organized hierachically

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

reply_template table Enum ReplyTemplateBodyFlags Enum values for ReplyTemplateBodyFlags reply_template_folder table reply_template_attachment table cust_lang table