s_message table

s_message Table (335)

A message used in a shipment. Can be html and/or plain text

Name	Description	Type	Nullable
id	Primary key	PK	No
plain_message	Plain message text of this message	Clob	Yes
html_message	HTML formatted text of this message	Clob	Yes
sms_message	SMS version of this message	Clob	Yes
description	Describes this message	String(255)	Yes
subject	The mail subject field of the message	String(255)	Yes
header_field	Extra header fields added to mail. Must be formatted correctly	Clob	Yes
flags	Identifies if HTML or plain message is included in message.	Enum ShipmentMessageType	No
folder_id	The folder which this message belongs to. -1 indicates that the message is on the root	Int	No
inline_images	Should images be included inline?	Bool	Yes
register_views	Register message views?	Bool	Yes
access_key	Key used for access verification	String(255)	Yes
registered	Registered when	UtcDateTime	Yes
registered_associate_id	Registered by whom	FK associate	Yes
updated	Last updated when	UtcDateTime	Yes
updated_associate_id	Last updated by whom	FK associate	Yes
updatedCount	Number of updates made to this record	UShort	Yes
document_message	The SM document used as template for this mailing	FK document	Yes
long_description	A field for a long description of this template	String(4000)	Yes
design	Will contain the design part of a message. The format will vary based on the type of designer used to create the message	Clob	Yes
designtype	Enum containing the type of the design	Enum DesignType	No

Fields	Types	Description

Table	Description
associate	Employees, resources and other users - except for External persons
document	Documents, this table is an extension of the Appointment table. There is always a corresponding appointment record; the relation between appointment and document is navigable in both directions. A document-type appointment record always has a corresponding document record and a record in VisibleFor specifying who may see this.
email_flow	A set of properties related to the email workflow.
email_flow_content_link	Links content to an email workflow
external_document	This table stores documents which can be viewed externaly, through the customer module
s_attachment	A connector between a message and attachments. One message can contain many attachments.
s_link	Links in messages to measure success rate of a campaign.
s_sent_message	Emarketeer message control
s_shipment	Contains info about one shipment. The addresses are stored in s_shipment_addr