This page (revision-18) was last changed on 26-Nov-2021 10:22 by JMyers

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
18 26-Nov-2021 10:22 2 KB JMyers to previous
17 26-Nov-2021 10:22 2 KB JMyers to previous | to last
16 26-Nov-2021 10:22 2 KB JMyers to previous | to last
15 26-Nov-2021 10:22 2 KB JEscott to previous | to last
14 26-Nov-2021 10:22 2 KB JEscott to previous | to last
13 26-Nov-2021 10:22 1 KB JEscott to previous | to last
12 26-Nov-2021 10:22 1 KB JEscott to previous | to last
11 26-Nov-2021 10:22 1 KB JEscott to previous | to last
10 26-Nov-2021 10:22 1 KB JEscott to previous | to last
9 26-Nov-2021 10:22 1 KB JEscott to previous | to last
8 26-Nov-2021 10:22 1 KB JMyers to previous | to last
7 26-Nov-2021 10:22 1 KB JMyers to previous | to last
6 26-Nov-2021 10:22 919 bytes JMyers to previous | to last
5 26-Nov-2021 10:22 774 bytes JMyers to previous | to last
4 26-Nov-2021 10:22 650 bytes JMyers to previous | to last
3 26-Nov-2021 10:22 640 bytes JMyers to previous | to last
2 26-Nov-2021 10:22 473 bytes JMyers to previous | to last
1 26-Nov-2021 10:22 652 bytes JMyers to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 1 added 2 lines
[{TableOfContents }]
At line 5 changed one line
The definition data for the Maintain Column Details screen is stored in the [P2K_AM_TABLE_DETAILS] and [P2K_AM_COLUMN_DETAILS] tables.
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.
At line 7 changed one line
;[Seq #|]:
;[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]: This field is used to identify the view detail usage, for example, if it is predefined in Java view.
;[Description|DESCRIPTION]:A short description of the view is provided here.
;[Where Clause|WHERE_CLAUSE]:This field is used to filter information being queried.
At line 9 changed 10 lines
;[View Name |]:
This field identifies the view.
;[View Alias|]:
This field provides the abbreviated view identifier.
;[View Details Usage|]:
;[Description|]:
A short description of the view is provided here.
;[Where Clause |]:
This field is used to filter information being queried.
Seq # Table Column View Column Name Expression Text
----
!!!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]:This field displays the expression used to derive the column.
----
!!!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.
----
![Notes|Edit:Internal.IMVD]
[{InsertPage page='Internal.IMVD' default='Click to create a new notes page'}]