P 2 K_AM_CUSTOM_VALUES

Alias: MCV#

(P2K_AM_CUSTOM_VALUES)

Unique Keys: Custom Table(MCT_ID) + CUSTOM_KEY + CUSTOM_SUBKEY +LANGUAGE_CODE

ERD: ERD-AM35

Records user defined tables' data.

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
MCT_IDNumber(10)IDYlink to P2K_AM_CUSTOM_TABLES
CUSTOM_KEYVarchar2(50)VARCHAR50Y
CUSTOM_SUBKEYVarchar2(50)VARCHAR50
CUSTOM_DATAVarchar2(2000)VARCHAR2000
LANGUAGE_CODEVarchar2(3)X_LANGUAGE_CODE
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
START_DATEDate()DATE
END_DATEDate()DATE

User Fields: Not Allowed
Audit Logging: Not Allowed


Notes #

Click to create a new notes page