Emails
Create, update, delete, and query the SuiteCRM Emails
テーブル固有の情報
Select
WHERE 句で任意の条件を使用して、Emails テーブルをクエリできます。本製品 はSuiteCRM API を使用して結果をフィルタリングします。
SELECT * FROM Emails WHERE Name = 'test'
Insert
書き込み可能なカラムを指定して、Email を作成します。
INSERT INTO Emails (Id, Name) VALUES ('id', 'Energy')
Update
Id を指定して、書き込み可能なEmail カラムを更新できます。
UPDATE Emails SET Name = 'new name', Description = 'Desc' WHERE Id = 'Test123'
Delete
Id を指定して、Email を削除します。
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 |
|