P 2 K_AM_USER_CALCS
Back to current versionRestore this version

Alias: MUC#

(P2K_AM_USER_CALCS)

Unique Keys: USER_CALC_CODE + User Name (MUS_ID)

ERD: ERD-AM60

User Calcs

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
USER_CALC_CODEVarchar2(16)CODEY
MPD_IDNumber(10)IDYlink to P2K_AM_PRODUCTS
MUS_IDNumber(10)ID link to P2K_AM_USERS
USER_CALC_TYPEVarchar2(1)X_USER_CALC_TYPEY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
USER_CALC_STATUSVarchar2(2)X_USER_CALC_STATUSY
RETURN_VALUE_TYPEVarchar2(2)X_FIELD_TYPE
DESCRIPTIONVarchar2(50)DESCRIPTION
USER_CALC_USAGEVarchar2(2)X_USER_CALC_USAGE

User Fields: Not Allowed
Audit Logging: Not Allowed