!!!MAINTAIN TABLE DETAILS The Maintain Table Details (IMTD) screen is used to view supplied information. %%warning Most of the information on this screen has been supplied and should not be altered.%% Some values that are user changeable are: * Disable Logging * Retained Periods * Period Type * Purge Date The definition data for the Maintain Table Details screen is stored in the [P2K_AM_TABLE_DETAILS], [P2K_AM_DATA_ACCESS_OBJECTS] and [P2K_AM_FORM_TABLE_USAGES] tables. ;[Product|PRODUCT_CODE]:This field displays the product the table is associated with. ;[Table Alias|TABLE_ALIAS]:This field provides the abbreviated table identifier. ;[Table|TABLE_NAME]:This field identifies the table being defined. ;[Description|DESCRIPTION]:A short description of the table is provided in this field. \\ \\ ---- !!Table Details tab ;[Notes Not Allowed|NOTES_NOT_ALLOWED]: ;[User Fields Not Allowed|USER_FIELDS_NOT_ALLOWED]: ;[Logging Not Allowed|LOGGING_NOT_ALLOWED]: ;[Historical Table|HISTORICAL_TABLE]: This optional toggle indicates that the table contains [date-sensitive|DATE SENSITIVE] information. ;[No Monitor Triggers|NO_MONITOR_TRIGGERS]: ;[Disable Logging|DISABLE_LOGGING]: DISABLE_LOGGING is an optional toggle field. When checked, the field or table that it pertains to will no longer be logged for audit purposes. ;[Table is Cached|TABLE_IS_CACHED]: ;[Maximum Note Size|MAX_NOTE_SIZE]: ;[Subject Area|SUBJECT_AREA]: ;[Retained Periods|RETAINED_PERIODS]: ;[Period Type|PERIOD_TYPE]: ;[Purge Date|PURGE_DATE]: ;[Function|FUNCTION_NAME]: ;[Clear Table Cache|]: ;[Clear All Cached Tables|]: \\ \\ ---- !!Form Usage tab This tab displays any function that utilizes the specified table as a data source. ;[Function|FUNCTION_NAME]:The name of the function that uses the table. ;[Usage|FUNCTION_USAGE]: This field indicates if the function was predefined by the application or if the function was created by the client. ;[Join Clause|JOIN_CLAUSE]: ;[Where Clause|WHERE_CLAUSE_CODE]:This field indicates if a where clause was added to the table's usage in the form definition. ;[Usage|FORM_TABLE_USAGE]:This field identifies if the form's usage of the table has been predefined by the application or if it was added by a client. ;[Create|CREATE_ALLOWED]/[Retrieve|RETRIEVE_ALLOWED]/[Update|UPDATE_ALLOWED]/[Delete Allowed|DELETE_ALLOWED]:These fields indicate the security access defined at the function's level. [CLEANUP]