message

Stores communication records such as emails, system notifications, and customer messages.

Columns


Name	Type	References	Description
id [KEY]	Integer		Unique internal identifier for the message.
activity	String		Activity or record associated with the message.
attachments	String		List of attachments included with the message.
author	String		Sender of the message.
authoremail	String		Email address of the sender.
datetime	Date		Date and time when the message was created.
emailed	Boolean		Indicates whether the message was sent via email.
externalid	String		External identifier used for integrations or external systems.
hasattachment	Boolean		Specifies whether the message includes attachments.
incoming	Boolean		Indicates whether the message is an incoming message.
internalonly	Boolean		Specifies whether the message is visible only to internal users.
message	String		Content of the message.
primaryrecipient	String		Main recipient of the message.
subject	String		Subject line of the message.
template	String		Template used for the message, if applicable.
to	String		List of recipients to whom the message was sent.