Alias: MMS#

(P2K_AM_MESSAGES)

Unique Keys: MESSAGE_CODE + LANGUAGE_CODE

ERD: ERD-AM33

Messages

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
LANGUAGE_CODEVarchar2(3)X_LANGUAGE_CODEY
MESSAGE_CODEVarchar2(16)CODEY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
MESSAGE_TEXTVarchar2(2000)VARCHAR2000Y
ALERT_BOXVarchar2(1)X_YES_NOY
SUPPRESS_WARNINGVarchar2(1)X_YES_NOY
WARNING_ONLYVarchar2(1)X_YES_NOY
MESSAGE_USAGEVarchar2(2)X_MESSAGE_USAGEY
HELP_TEXTVarchar2(2000)VARCHAR2000

User Fields: Not Allowed
Audit Logging: Not Allowed


Notes #

Click to create a new notes page