P 2 K_AM_WHERE_CLAUSES
Back to current versionRestore this version

Alias: MWC#

(P2K_AM_WHERE_CLAUSES)

Unique Keys: Data Access Object (MDAO_ID) + WHERE_CLAUSE_CODE

ERD: ERD-AM75

description

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
MDAO_IDNumber(10)IDYlink to P2K_AM_DATA_ACCESS_OBJECTS
WHERE_CLAUSE_CODEVarchar2(16)CODEY
WHERE_CLAUSE_USAGEVarchar2(2)X_WHERE_CLAUSE_USAGEY
DESCRIPTIONVarchar2(50)DESCRIPTION
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y

User Fields: Not Allowed
Audit Logging: Not Allowed