AccountsEmails
The email address and its associated information.
Table-Specific Information
SELECT
The add-in will use the Oracle Service Cloud API to process WHERE clause conditions built with =,!=,<,>,<=,>=,IN,NOT_IN,IS,IS_NOT,LIKE operators. The rest of the filters are executed client side within the add-in.
SELECT * FROM AccountsEmails WHERE accountsId = 12 SELECT * FROM AccountsEmails WHERE accountsId > 15 SELECT * FROM AccountsEmails WHERE address LIKE '%test' SELECT * FROM AccountsEmails WHERE accountsId IN (12, 23, 123) SELECT * FROM AccountsEmails WHERE certificate IS NOT NULL
Columns
| Name | Type | Description |
| AccountsId | Long | Id of Accounts. |
| Address | String | The string value of the email address. |
| AddressTypeId | Long | Id of addressType. The type of address, such as Primary or Alt1. This is the key for the list entry. |
| AddressTypelookUpName | String | LookUpName of addressType. The type of address, such as Primary or Alt1. This is the key for the list entry. |
| Certificate | String | The associated public email certificate used to encrypt outgoing emails. |
| Invalid | Bool | Indicates whether the email address is disabled. |