This is version 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

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_FORM_TABLE_USAGES table.

Table Alias

This field provides the abbreviated table identifier.

Table

This field identifies the table being defined.

Product

This field displays the product the table is associated with.

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