ODBC Driver for SugarCRM

Build 24.0.9062

Emails

The Emails table.

Columns

Name Type ReadOnly Description
Acl_Team_Names String True

Acl_Team_Set_Id String False

Assigned_User_Id String False

User ID that last modified record

Assigned_User_Name String True

Attachments_Collection String True

Bcc_Addrs_Names String False

Bcc_Collection String True

Cc_Addrs_Names String False

Cc_Collection String True

Created_By String True

User name who created record

Created_By_Name String True

Date_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

Date_Sent Datetime False

Deleted Bool False

Record deletion indicator

Description String False

Description_Html String True

Direction String False

Email direction is one of Unknown, Outbound, Inbound, Internal

Flagged Bool False

flagged status

Following Bool False

Is user following this record

From_Addr_Name String False

From_Collection String True

Id [KEY] String True

Unique identifier

Intent String False

Target of action used in Inbound Email assignment

Mailbox_Id String False

Mailbox_Name String True

Message_Id String False

ID of the email item obtained from the email transport system

Message_Uid String False

UID of the email item obtained from the email transport system

Modified_By_Name String True

Modified_User_Id String True

User ID that last modified record

My_Favorite Bool False

Favorite for the user

Name String False

The subject of the email

Outbound_Email_Id String False

The configuration used to send an email, only used for emails sent using SugarCRM

Parent_Id String False

ID of Sugar object referenced by parent_type

Parent_Name String True

Parent_Type String True

Identifier of Sugar module to which this email is associated

Raw_Source String False

Reply_To_Addr String False

Reply_To_Id String False

Identifier of email record that this email was a reply to

Reply_To_Status Bool False

If you reply to an email then reply to status of original email is set

State String False

An email is either a draft or archived

Status String False

Sync_Key String True

Tag String False

Team_Count String False

Team_Id String False

Team ID for the account

Team_Name String False

Team_Set_Id String False

To_Addrs_Names String False

To_Collection String True

Total_Attachments Int True

Type String False

Type of email (ex: draft)

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062