MAINTAIN VIEW DETAILS#

The Maintain View Details (IMVD) screen is used to see view details as they are saved in our view details table.

The definition data for the Maintain View Details screen is stored in the P2K_AM_VIEW_DETAILS, P2K_AM_VIEW_COLUMNS, P2K_AM_DATA_ACCESS_OBJECTS, and P2K_AM_FORM_TABLE_USAGES tables.

View Alias

This field provides the abbreviated view identifier.

View Name

This field identifies the view.

View Details Usage

Description

A short description of the view is provided here.

Where Clause

This field is used to filter information being queried.

View Column#

Seq #

Table

Column

View Column Name

Domain Name

Expression Text

Form Usage Tab#

Function

This field displays a function which makes use of the data source selected in the find block.

MFN Usage

This field displays the function's usage, meaning if the function is pre-loaded or user-defined.

Join Clause

This field displays the join clause to the data source selected in the find block.

Where Clause

If the function has a where clause defined for the data source selected, the where clause code will display here.

MFT Usage

This field indicates if the form's table usages are pre-loaded with the application or if they were user-defined.

Create/Retrieve/Update/Delete Allowed

The security access available for the function is displayed using these toggles.