EMLCFG

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:

NameTypeDescription
EMLCFG_IDINTEGER NOT NULLThe primary key.
NAMEVARCHAR (40) NOT NULLThe name used to refer to this e-mail configuration.
DESCRIPTIONVARCHAR (254)The description of the configuration.
TYPEINTEGER NOT NULLThe type of server to which the configuration applies. Possible values include: 0 - STMP 1 - POP3
HOSTVARCHAR (254) NOT NULLThe hostname of the Transaction server upon which to run the e-mail activity jobs.
TIMEINTEGER NOT NULLThe 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.
EMLSERVERVARCHAR (254) NOT NULLThe hostname of the e-mail server in this configuration (either the POP3 or SMTP server).
ACCOUNTVARCHAR (254) NOT NULLThe account name used to connect to the server.
PORTINTEGER NOT NULLThe port number to use to connect to the server.
PASSWORDBINARYThe password that corresponds to the account used to connect to the server.
STOREENT_IDINTEGER NOT NULLThe ID of the store corresponding to the configuration.
ADDRESSVARCHAR (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.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>EMLCFG_IDPrimary Key
I0000274STOREENT_ID+TYPEUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_965STOREENT_IDSTOREENTSTOREENT_IDCascade