• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

s_message Table (335)

Some tooltip text!
• 3 minutes to read
 • 3 minutes to read

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

Fields

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

s_message table relationship diagram

Indexes

Fields Types Description
id PK Clustered, Unique

Relationships

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.
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_sent_message Emarketeer message control
s_shipment Contains info about one shipment. The addresses are stored in s_shipment_addr

Replication Flags

  • None

Security Flags

  • No access control via user's Role.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top