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:

Name	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 Transaction 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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	EMLCFG_ID	Primary Key
I0000274	STOREENT_ID+TYPE	Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_965	STOREENT_ID	STOREENT	STOREENT_ID	Cascade