MSGTYPES

This table is used by the messaging system to store header information about the available message types.

Column Descriptions:

NameTypeDescription
MSGTYPE_IDINTEGER NOT NULLMessage type ID. Unique, primary key.
MSGTDIRINTEGER NOT NULLThe direction of transmission this message is valid for. Valid values: 1=outgoing, 2=incoming, or 3=send-receive.
NAMEVARCHAR (254) NOT NULLShort name for message type.
VIEWNAMEVARCHAR (254) NOT NULLName of view associated with this message type. This view must be registered to be usable in message transmission. This is a mandatory field.
DESCRIPTIONVARCHAR (254)Description of the message type.
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>MSGTYPE_IDPrimary Key
I0000163NAMEUnique Index

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1022MSGTYPE_IDNOTIFYMSGTYPE_IDCascade
F_625MSGTYPE_IDPROFILEMSGTYPE_IDCascade