Emails

Create, update, delete, and query the SuiteCRM Emails

Table Specific Information

Select

You can query the Emails table using any criteria in the WHERE clause. The driver will use the SuiteCRM API to filter the results.

SELECT * FROM Emails WHERE Name = 'test'

Insert

Create an Email by specifying any writable column.

INSERT INTO Emails (Id, Name) VALUES ('id', 'Energy')

Update

You can update any Email column that is writable, by specifying the Id.

UPDATE Emails SET Name = 'new name', Description = 'Desc' WHERE Id = 'Test123'

Delete

Delete an Email by specifying the Id.

DELETE FROM Emails WHERE Id = '10003'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	The unique identifier of the email.
Name	String	False	The subject of the email.
DateEntered	Datetime	False	The date the record was created.
DateModified	Datetime	False	The date the record was last modified.
ModifiedUserId	String	False	The Id of the user who last modified the record.
ModifiedByName	String	True	The name of the user who last modified the record.
CreatedBy	String	False	The Id of the user who created the record.
CreatedByName	String	True	The name of the user who created the record.
Description	String	False	The description for the email.
Deleted	Bool	False	The record deletion indicator.
CreatedByLink	String	True	Link to the record who created it
ModifiedUserLink	String	True	Link to the record who modified it.
AssignedUserId	String	False	The Id of the user assigned to the record.
AssignedUserName	String	True
AssignedUserLink	String	True	Link to the user which the record has been assigned to
SecurityGroups	String	True	The security group associated with the record.
Orphaned	Bool	False
LastSynced	Datetime	False
FromAddrName	String	False	The from address in the email.
ReplyToAddr	String	False	The reply-to address in the email.
ToAddrsNames	String	False	The to addresses in the email.
CcAddrsNames	String	False	The cc addresses in the email.
BccAddrsNames	String	False	The bcc addresses in the email.
ImapKeywords	String	False
RawSource	String	False	The raw source for the email.
DescriptionHtml	String	False	The HTML description for the email.
DateSentReceived	Datetime	False
MessageId	String	False	The Id of the email item obtained from the email transport system.
Type	String	False	The type of the email (e.g., draft).
Status	String	False	The status of the record.
Flagged	Bool	False	The flagged status of the email.
ReplyToStatus	Bool	False	The reply-to status of the email. If you reply to an email then the reply-to status of original email is set.
Intent	String	False	The target of the action used in the Inbound Email assignment.
MailboxId	String	False
ParentName	String	True	The name of the parent of this account.
ParentType	String	False	The type of the Sugar module associated with the email. (Deprecated as of 4.2.)
ParentId	String	False	The Id of the parent of this account.
Indicator	String	False
Subject	String	False
Attachment	String	False
Uid	String	False
Msgno	String	False
Folder	String	False
FolderType	String	False
InboundEmailRecord	String	False
IsImported	String	False
HasAttachment	String	False
IsOnlyPlainText	Bool	False
Accounts	String	True	The accounts associated with the record
Bugs	String	True	The bugs associated with the record.
Cases	String	True	The cases associated with the record.
Contacts	String	True	The contacts associated with the record
Leads	String	True	The leads associated with the record.
Opportunities	String	True	The opportunities associated with the record.
Project	String	True	The project associated with the record.
Projecttask	String	True
Prospects	String	True
AosContracts	String	True
Tasks	String	True	The tasks associated with the record.
Users	String	True
Notes	String	True	The notes associated with the record.
Meetings	String	True	The meetings associated with the record.
CategoryId	String	False
EmailsEmailTemplates	String	True
EmailsEmailTemplatesName	String	True
EmailsEmailTemplatesIdb	String	True
OptIn	String	False