MAINTAIN TABLE DETAILS#

The Maintain Table Details (IMTD) screen is used to view supplied information. 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
This field displays the product the table is associated with.
Table Alias
This field provides the abbreviated table identifier.
Table
This field identifies the table being defined.
Description
A short description of the table is provided in this field.

Table Details tab#

Notes Not Allowed
User Fields Not Allowed
Logging Not Allowed
Historical Table
No Monitor Triggers
Disable Logging
Table is Cached
Maximum Note Size
Subject Area
Retained Periods
Period Type
Purge Date
Function
Clear Table Cache
Clear All Cached Tables

Form Usage tab#

Function
Usage
Join Clause
Where Clause
Usage
Create/Retrieve/Update/Delete Allowed