Home > Technical > Table Definitions > ALERTMSGCONTACT

ALERTMSGCONTACT

Superceded by MICROS Alerts Engine.

This table records to where an alert message should be sent for an alert. The alert itself is stored in ALERTMSGDATA.

Column

Type

Description

INTMSGNUM

INT

The alert to which this contact belongs.

ALERTMSGDATA.intMsgNum

STRUSERCODE

VARCHAR(20)

If the message is to be sent to a specific user, the user's code should be recorded here. If this is not entered then the STRUSERTYPE should be.

USERCODE.strUserCode

STRUSERTYPE

VARCHAR(1)

If the message is to be sent to a type of user, the user type should be recorded here. If this is not entered then the STRUSERCODE should be.
TRADCODE.strText  (where strType='C')

 

Primary Key: INTMSGNUM + STRUSERTYPE + STRUSERCODE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)