This table stores the configuration information about the accounts used in support of e-mail activities. Each store can have one inbound (POP3) and one outbound (SMTP) server configured.
Column Descriptions
| Column Name
| Column Type
| Description
|
| EMLCFG_ID
| INTEGER NOT NULL
| The primary key.
|
| NAME
| VARCHAR(40) NOT NULL
| The name used to refer to this e-mail configuration.
|
| DESCRIPTION
| VARCHAR(254)
| The description of the configuration.
|
| TYPE
| INTEGER NOT NULL
| The type of server to which the configuration applies. Possible values include:
0 - STMP
1 - POP3
|
| HOST
| VARCHAR(254) NOT NULL
| The hostname of the WebSphere Commerce Server upon which to run the e-mail activity jobs.
|
| TIME
| INTEGER NOT NULL
| The number of minutes past 12:00am upon which to run the e-mail activity jobs. This value is only stored for reference. The actual time the e-mail activity will be sent is stored in the SCHCONFIG table.
|
| EMLSERVER
| VARCHAR(254) NOT NULL
| The hostname of the e-mail server in this configuration (either the POP3 or SMTP server).
|
| ACCOUNT
| VARCHAR(254) NOT NULL
| The account name used to connect to the server.
|
| PORT
| INTEGER NOT NULL
| The port number to use to connect to the server.
|
| PASSWORD
| BINARY
| The password that corresponds to the account used to connect to the server.
|
| STOREENT_ID
| INTEGER NOT NULL
| The ID of the store corresponding to the configuration.
|
| ADDRESS
| VARCHAR(254)
| When the type of the e-mail configuration is POP3 (that is, when the value in the TYPE column is 1), this is the e-mail address used as the address of the sender.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|