!!!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]: This field, set by the system, identifies if notes are permitted to be attached to the table.
;[User Fields Not Allowed|USER_FIELDS_NOT_ALLOWED]: This field, set by the system, identifies if [User Defined Fields|USER DEFINED FIELD] are permitted on the table.
;[Logging Not Allowed|LOGGING_NOT_ALLOWED]:  This field, set by the system, indicates if logging is even permitted on this field/table.  Some tables do not make sense to log, due to their volatility or transactional nature.
;[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]: This is a toggle which indicates if the data within the table is 'cached', in other words is the data stored in a temporary storage area or is it accessed directly from the database. Caching tables improves the query performance of the application.
;[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|ACT_CLEAR_TABLE_CACHE]: If necessary the user may clear the table's data from the cache. This may be necessary if changes to the data within the table are not refreshing for the users.
;[Clear All Cached Tables|ACT_CLEAR_ALL_TABLE_CACHES]: This action button will clear data from ALL of the cached tables, not just the one selected in the find block. 
\\ \\
----
!!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]