[{TableOfContents }]

!!!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|VIEW_ALIAS]:This field provides the abbreviated view identifier. 
;[View Name|VIEW_NAME]:This field identifies the view. 
;[View Details Usage|VIEW_DETAILS_USAGE]: 
;[Description|DESCRIPTION]:A short description of the view is provided here.
;[Where Clause|WHERE_CLAUSE]:This field is used to filter information being queried. 

----
!!!View Column Tab
;[Seq #|COLUMN_SEQUENCE]:This field indicates the sequential order of the column within the View. 
;[Table|TABLE_ALIAS]: The alias of the table the column belongs to is indicated here in this field. 
;[Column|COLUMN_NAME]: The name of the column on the original table displays here. 
;[View Column Name|COLUMN_NAME]: The name of the column that is to be used for the View is displayed here. 
;[Domain Name|DOMAIN_NAME]:This field displays the name of the domain. 
;[Expression Text|EXPRESSION_TEXT]: 

----
!!!Form Usage Tab
;[Function|FUNCTION_NAME]:This field displays a function which makes use of the data source selected in the find block. 
;[MFN Usage|FUNCTION_USAGE]:This field displays the function's usage, meaning if the function is pre-loaded or user-defined.
;[Join Clause|JOIN_CLAUSE]:This field displays the join clause to the data source selected in the find block.
;[Where Clause|WHERE_CLAUSE_CODE]:If the function has a where clause defined for the data source selected, the [where clause code|WHERE_CLAUSE_CODE] will display here.
;[MFT Usage|FORM_TABLE_USAGE]: This field indicates if the form's table usages are pre-loaded with the application or if they were user-defined.
;[Create|CREATE_ALLOWED]/[Retrieve|RETRIEVE_ALLOWED]/[Update|UPDATE_ALLOWED]/[Delete Allowed|DELETE_ALLOWED]:  The security access available for the function is displayed using these toggles.