Alias: MVR#

(P2K_AM_USER_VARIABLES)

Unique Keys: USER_VARIABLE_CODE

ERD: ERD-AM85

User Variables

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
USER_VARIABLE_CODEVarchar2(16)CODEY
CREATE_DATEDate()DATEY
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
CREATE_USERVarchar2(30)VARCHAR30Y
FIELD_TYPEVarchar2(2)X_FIELD_TYPE
DESCRIPTIONVarchar2(50)DESCRIPTION

User Fields: Not Allowed
Audit Logging: Not Allowed


Notes #

Click to create a new notes page