P 2 K_AM_VIEW_COLUMNS

Alias: MVC#

(P2K_AM_VIEW_COLUMNS)

Unique Keys: None

ERD: ERD-AM40

View Columns

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
MVD_IDNumber(10)IDYlink to P2K_AM_VIEW_DETAILS
MCD_IDNumber(10)ID link to P2K_AM_COLUMN_DETAILS
COLUMN_NAMEVarchar2(200)VARCHAR200Y
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
EXPRESSION_TEXTVarchar2(2000)VARCHAR2000
COLUMN_SEQUENCENumber(5)NUMBER5Y
DOMAIN_NAMEVarchar2(30)VARCHAR30

User Fields: Not Allowed
Audit Logging: Not Allowed


Notes #

Click to create a new notes page