P 2 K_AM_SECURITY_RIGHTS
Back to current versionRestore this version

Alias: MSR#

Unique Keys: _
Child Table:
_
Parent Table: _

Security Rights

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
SECURITY_RIGHT_CODEVarchar2(16)CODEY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
SECURITY_RIGHT_NAMEVarchar2(30)VARCHAR30Y
DATA_TYPEVarchar2(2)X_DATA_TYPE(QMS)Y
VALUE_LENGTHNumber(5)NUMBER5
VALUE_FORMATVarchar2(30)VARCHAR30
LOV_QUERYVarchar2(2000)VARCHAR2000
VALIDATION_CLAUSEVarchar2(2000)VARCHAR2000
ERROR_CODEVarchar2(16)CODE

User Fields: Not Allowed
Audit Logging: Allowed