!!!Alias: MTD Unique Keys: ___\\ Child Table: ___\\ Parent Table: ___\\ \\ Table Details !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[TABLE_NAME]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[TABLE_ALIAS]|Varchar2(16)|[CODE]|Y| |[MPD_ID]|Number(10)|[ID]|Y|link to [P2K_AM_PRODUCTS] |[MTD_ID]|Number(10)|[ID]| |link to [P2K_AM_TABLE_DETAILS] |[MFN_ID]|Number(10)|[ID]| |link to [P2K_AM_FUNCTIONS] |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| | |[SUBJECT_AREA]|Varchar2(2)|[X_SUBJECT_AREA]| | |[USER_FIELDS_NOT_ALLOWED]|Varchar2(1)|[TOGGLE]| | |[LOGGING_NOT_ALLOWED]|Varchar2(1)|[TOGGLE]| | |[DISABLE_LOGGING]|Varchar2(1)|[TOGGLE]| | |[HISTORICAL_TABLE]|Varchar2(1)|[TOGGLE]| | |[RETAINED_PERIODS]|Number(5)|[NUMBER5|NUMBERn]| | |[PERIOD_TYPE]|Varchar2(2)|[X_PERIOD_TYPE]| | |[PURGE_DATE]|Date()|[DATE]| | |[NOTES_NOT_ALLOWED]|Varchar2(1)|[TOGGLE]| | |[MAX_NOTE_SIZE]|Number(5)|[NUMBER5|NUMBERn]| | |[TABLE_IS_CACHED]|Varchar2(1)|[TOGGLE]| | |[USE_ABBREV_ON_LOV]|Varchar2(1)|[TOGGLE]| | |[MWC_ID_AUDIT]|Number(10)|[ID]| |link to [P2K_AM_WHERE_CLAUSES] |[NO_MONITOR_TRIGGERS]|Varchar2(1)|[TOGGLE]| | User Fields: Not Allowed\\ Audit Logging: Not Allowed\\