InboundEmail
Stores configuration settings for inbound email accounts that are connected to SugarCRM. This table supports automated mailbox retrieval, assignment rules, and routing of email messages into CRM records.
Columns
| Name | Type | ReadOnly | Description |
| Acl_Team_Names | String | True |
The list of team names that are associated with this inbound email mailbox. These names determine which teams have access to view or administer the mailbox. |
| Acl_Team_Set_Id | String | False |
The unique identifier (Id) of the team set that is associated with this inbound email mailbox. The team set defines all teams that are granted access to the mailbox. |
| Auth_Type | String | True |
The authentication method that is used to connect to the inbound mail server (for example, 'Basic', 'OAuth', or 'token-based authentication'). |
| Authorized_Account | String | True |
The email account that is authorized to retrieve messages for this inbound mailbox. This value identifies the account whose credentials or tokens are in use. |
| Created_By | String | True |
The Id of the user who created the record for this inbound email mailbox. This value supports audit tracking and administrative oversight. |
| Date_Entered | Datetime | True |
The date and time when the record for this inbound email mailbox was created. This timestamp supports chronological sorting and auditing. |
| Date_Modified | Datetime | True |
The date and time when the record for this inbound email mailbox was last modified. This timestamp supports version tracking and administrative review. |
| Delete_Seen | Bool | False |
A Boolean field that returns a value of 'true' when emails should be deleted from the email server after retrieval. It returns a value of 'false' when messages are left on the server after being read. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the record for this inbound email mailbox is marked as deleted. It returns a value of 'false' when the mailbox remains active. |
| Eapm_Id | String | True |
The Id of the external account password management (EAPM) record that is associated with this mailbox for authentication credentials storage. |
| Email_Password | String | False |
The password that is associated with the Email_User value for server authentication, unless external credential management is used. |
| Email_Provider | String | False |
The email service provider that is associated with this mailbox (for example, 'Gmail' or'Exchange'). |
| Email_User | String | False |
The username that is used to authenticate to the mail server for retrieving inbound messages. |
| Group_Id | String | False |
The Id of the group that is associated with this mailbox, when the mailbox is configured for shared or team-based email processing. |
| Groupfolder_Id | String | False |
The Id of the group folder that is associated with this mailbox. Group folders are used to organize inbound messages for shared work queues. |
| Id [KEY] | String | True |
The record Id of this inbound email mailboxd. The system uses this Id to reference and manage the mailbox configuration internally. |
| Is_Personal | Bool | False |
A Boolean field that returns a value of 'true' when the mailbox is configured as a personal mailbox for an individual user. It returns a value of 'false' when the mailbox is shared or group-based. |
| Mailbox | String | False |
The name of the inbox or folder on the mail server from which messages are retrieved. |
| Mailbox_Type | String | False |
The type of mailbox configuration (for example, 'IMAP', 'POP3', or 'Exchange'), that determines how inbound messages are accessed. |
| Modified_User_Id | String | True |
The Id of the user who most recently modified the record for this inbound email mailbox. This value supports audit traceability. |
| Name | String | False |
The display name that is assigned to this inbound email mailbox configuration. This value appears in configuration lists and administrative pages. |
| Port | Int | False |
The network port that is used to connect to the mail server for retrieving messages. |
| Server_Url | String | False |
The URL or hostname of the mail server that is used for inbound message retrieval. |
| Service | String | False |
The messaging service type or integration layer that is used to retrieve email messages for this mailbox. |
| Status | String | False |
The operational status of the inbound email mailbox (for example, 'Active', 'Disabled', or 'Error'). |
| Stored_Options | String | False |
Additional stored configuration settings that are associated with this inbound mailbox. These values can include connection flags, filters, or advanced retrieval options. |
| Team_Count | String | False |
The number of teams that are associated with this inbound email mailbox. This value supports access scope analysis. |
| Team_Id | String | False |
The Id of the primary team that is associated with this inbound email mailbox. The primary team defines the default visibility scope. |
| Team_Name | String | False |
The display name of the primary team that is associated with this inbound email mailbox. This value is shown in assignment and UI displays. |
| Team_Set_Id | String | False |
The Id of the full team set that is associated with this inbound email mailbox. The team set defines all teams that can view or modify the mailbox record. |
| Template_Id | String | False |
The Id of the email template that is used for automatic replies or response automation for inbound messages. |