P 2 K_AM_SECURITY_RIGHTS

Alias: MSR#

(P2K_AM_SECURITY_RIGHTS)

Unique Keys: SECURITY_RIGHT_CODE

ERD: ERD-AM40

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


Notes #

Click to create a new notes page