[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IEM_EMAIL_ACCOUNTS |
|---|---|
| Object Type: | TABLE |
| Owner: | IEM |
| FND Design Data: |  IEM.IEM_EMAIL_ACCOUNTS
|
| Subobject Name: | |
| Status: | VALID |
This table contains information related to each email account supported by an eMC. An eMC can contain one or more email accounts, each belonging to different domains. These email accounts can be served on one or more IM servers. However any email account can be on only one IM server. The account profile facilitates account maintenance.
.
The Account is displayed on the resources GUI and is unique. Agents/resources are associated with an account in different capacities.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IEM_EMAIL_ACCOUNTS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 EMAIL_ACCOUNT_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EMAIL_ACCOUNT_ID | NUMBER | (15) | Yes | Sequence generated identifier. |
| ACCOUNT_NAME | VARCHAR2 | (256) | Concatenation of email_user @ domain columns. This is the complete email address. | |
| EMAIL_USER | VARCHAR2 | (100) | Yes | Contains the string before the @ in an email address. |
| DOMAIN | VARCHAR2 | (100) | Yes | Contains the string after the @ in an email address. |
| EMAIL_PASSWORD | VARCHAR2 | (100) | Yes | Email account password. |
| ACCOUNT_PROFILE | VARCHAR2 | (400) | Yes | User defined text, 5 lines of additional information. |
| DB_SERVER_ID | NUMBER | (15) | Yes | Sequence generated identifier. Foreign key from IEM_DB_SERVERS. |
| SERVER_GROUP_ID | NUMBER | (15) | Yes | Foriegn key from IEM_SERVER_GROUPS. |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column. |
| CREATION_DATE | DATE | Yes | Standard Who column. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column. |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
| ACCT_LANGUAGE | VARCHAR2 | (50) | Language for the account | |
| REPLY_TO_ADDRESS | VARCHAR2 | (100) | Email address for the reply mail | |
| FROM_NAME | VARCHAR2 | (100) | Name that appears when sending out email | |
| INTENT_ENABLED | VARCHAR2 | (1) | iMT processing flag | |
| CUSTOM_ENABLED | VARCHAR2 | (1) | Customised WF processing | |
| DOCUMENT_ID | NUMBER | (15) | Auto-acknowledge Template document Id. | |
| AUTOACK_ENABLED | VARCHAR2 | (1) | Is the email account auto-acknowledge enabled? | |
| ACCOUNT_FLAG | VARCHAR2 | (1) | Flags on this email account. 'I' for intent and 'A' for acknowledgements. | |
| SC_LANG | VARCHAR2 | (30) | Stores spell-check language dictionary lookup code for the email account. | |
| KEM_FLAG | NUMBER | 1-Themes, 2-Tokens. |
Cut, paste (and edit) the following text to query this object:
SELECT EMAIL_ACCOUNT_ID
, ACCOUNT_NAME
, EMAIL_USER
, DOMAIN
, EMAIL_PASSWORD
, ACCOUNT_PROFILE
, DB_SERVER_ID
, SERVER_GROUP_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, ACCT_LANGUAGE
, REPLY_TO_ADDRESS
, FROM_NAME
, INTENT_ENABLED
, CUSTOM_ENABLED
, DOCUMENT_ID
, AUTOACK_ENABLED
, ACCOUNT_FLAG
, SC_LANG
, KEM_FLAG
FROM IEM.IEM_EMAIL_ACCOUNTS;
IEM.IEM_EMAIL_ACCOUNTS does not reference any database object
IEM.IEM_EMAIL_ACCOUNTS is referenced by following:
APPS
IEM_EMAIL_ACCOUNTS
|
|
|
|