JDBC Driver for SugarCRM

Build 22.0.8462

Emails

Create, update, delete, and query the Emails module in SugarCRM.

Columns

Name Type ReadOnly Description
Team_Id String False

The Id of the primary team.

Team_Set_Id String False

The Id of the team set.

Team_Count String False

The count of the team set.

Team_Name String False

The name of the primary team.

Id [KEY] String False

The unique identifier of the email.

Date_Entered Datetime False

The date the record was created.

Date_Modified Datetime False

The date the record was last modified.

Assigned_User_Id String False

The Id of the user assigned to the record.

Assigned_User_Name String False

The user name of the user assigned to the record.

Modified_User_Id String False

The Id of the user who last modified the record.

Modified_By_Name String False

The user name of the user who last modified the record.

Created_By String True

The Id of the user who created the record.

Created_By_Name String False

The user name of the user who created the record.

Deleted Bool False

The record deletion indicator.

From_Addr_Name String False

The from address in the email.

Reply_To_Addr String False

The reply-to address in the email.

To_Addrs_Names String False

The to addresses in the email.

Cc_Addrs_Names String False

The cc addresses in the email.

Bcc_Addrs_Names String False

The bcc addresses in the email.

Raw_Source String False

The raw source for the email.

Description_Html String False

The HTML description for the email.

Description String False

The description for the email.

Date_Sent Datetime False

The date the email was sent.

Message_Id String False

The Id of the email item obtained from the email transport system.

Message_Uid String False

The UID of the email item obtained from the email transport system.

Name String False

The subject of the email.

Type String False

The type of the email (e.g., draft).

Status String False

The status of the email.

Flagged Bool False

The flagged status of the email.

Reply_To_Status 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.

Mailbox_Id String False

The Id of the mailbox associated with the email.

Parent_Name String False

The name of the Sugar module associated with the email.

Parent_Type String False

The type of the Sugar module associated with the email. (Deprecated as of 4.2.)

Parent_Id String False

The Id of the Sugar module associated with the email. (Deprecated as of 4.2.)

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462