Home > Technical > Table Definitions > ALERTMSG

ALERTMSG

Superceded by MICROS Alerts Engine.

Column

Type

Description

INTNUM

INT

A unique number assigned by the system.

STRTYPE

VARCHAR(20)

Indicates the type of alert.

SQL  

An SQL statement.

SYSTEMCHECK  

Indicates we want to run the System Check process.

RESULT PROCEDURE  

A stored procedure that will return a result set.

COMMAND PROCEDURE  

A stored procedure that executes a command and does not return a result set.

STRSQL

VARCHAR

 

STRDESCRIPTION VARCHAR(50)

 

INTHOUR INT

The hour the alert was made.

STREMAILTO

VARCHAR

 

STRPARAM1

VARCHAR(20)

The name of the first parameter which can be accepted by this process.

STRPARAM2 VARCHAR(20)

 

STRPARAM3 VARCHAR(20)

 

STRPARAM4 VARCHAR(20)

 

STRPARAM5 VARCHAR(20)

 

STRPARAM6 VARCHAR(20)

 

STRPARAM7 VARCHAR(20)

 

STRPARAM8 VARCHAR(20)

 

STRPARAM9 VARCHAR(20)

 

STRPARAM10 VARCHAR(20)

 

STRPARAM11 VARCHAR(20)

 

STRPARAM12 VARCHAR(20)

 

STRPARAM13 VARCHAR(20)

 

STRPARAM14 VARCHAR(20)

 

STRPARAM15 VARCHAR(20)

 

 

Primary Key: INTNUM

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