!!!Alias: MTD (P2K_AM_TABLE_DETAILS) Unique Keys: [TABLE_NAME] also [TABLE_ALIAS] ERD: [ERD-AM30] 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\\ [{If var='loginstatus' contains 'authenticated' ---- ![Discussion|Edit:Internal.P2K_AM_TABLE_DETAILS] [{InsertPage page='Internal.P2K_AM_TABLE_DETAILS' default='Click to create a new discussion page'}] }]