VIEW FORM DEFINITIONS#
Forms are the user interface components that allow a user to view and/or maintain data stored in the system tables. The View Form Definitions (VMFD) form is used to view the form's functionality and details.
Functions provide the rules to access and process the data stored in the tables. Forms are the user interface to view/maintain the data.
Every form is associated with a function, however not every function has a form.
For example, the function âC2310_IMADDâ is better known as âCreate Recordâ. There is no âCreate Recordâ form, only the action executed when the user selects the F6 function key or the green plus sign.
The definition data for the View Form Definitions screen is stored in the P2K_AM_FUNCTIONS, P2K_AM_FORM_TABLE_USAGES, P2K_AM_FORM_GROUPS, P2K_AM_FORM_ITEMS, P2K_AM_EXECUTION_RIGHTS, P2K_AM_PREFERENCE_VALUES, P2K_AM_MENU_ITEMS and P2K_AM_FORM_DRILL_DOWNS tables.
At the top of the screen, you will see a list of the current forms within the application identified by the following fields:
- Function Name
- This field displays the function associated to form.
- Product
- This field displays the name of the product to which the function belongs.
- Description
- This field provides a short description of the function.
- Usage
- This field identifies whether the form table is pre-loaded or user defined.
Table Usages tab #
The Table Usages tab identifies where the form gathers its data.Data can come from one or more database tables or views. If there is more than one source, the way they are joined and their Where Clauses (or files) may also be defined here.
Where Clauses require familiarity with SQL and databases.- Change_Date
- The date the last change to the table was made.
- Change_User
- The user that made the last change to the table.
- Seq#
- This field indicates the sequential order by which the tables are linked to the function.
- Data Source
- This field will hold the official name of the table.
- Table Alias
- This field provides the abbreviated table identifier.
- Parent Data Source
- If this table has a parent table, that parent table will be listed here.
- Join Clause
- This field indicates the clause that will join two or more tables or views.
Form Layout tab #
This Form Layout tab displays the information that is on a form and the visual details such as layouts, field labels and widths. The layout areas on a form, including the form itself are referred to as Form Groups.- Change_Date
- The date the last change to the table was made.
- Change_User
- The user that made the last change to the table.
- Seq #
- This field indicates the sequential order that the groups appear on the form.
- Form Group
- This field provides the official name of the group.
- Parent Group
- If the group is part of another group, that parent group will be listed here.
- Layout
- This field indicates the how the group will be presented.
- e.g. as text, table, box or tabs.
- Group Usage
- This field identifies whether the form group is pre-loaded or user defined.
Group Details #
- SS Rows Displayed
- For any layout types of âTableâ, this field will indicate the numbers of rows to display.
- Title
- This field will show the title of the group which will appear on form.
- Title (Lang)
- If your database uses a secondary language, this field allows you provide the title of the group in that language.
- e.g. If the title of the group is âFindâ this field may provide the Spanish translation, âBuscarâ.
- Decoration
- This field is used to identify how the form is to be decorated, for example 'Line Border'.
- Width
- This is the default width (expressed in pixels) of the group when a user first opens the form.
- Height
- This is the default height (expressed in pixels) of the group when a user first opens the form.
- Max W
- This is the maximum width (expressed in pixels) of the group if the user stretches their screen.
- Max H
- This is the maximum height (expressed in pixels) of the group if the user stretches their screen.
Group Items#
- Change_Date
- The date the last change to the table was made.
- Change_User
- The user that made the last change to the table.
- Seq #
- This field indicates the sequential order that the groups appear on the form.
- Item Name
- This field holds the official name of the group item.
- Type
- This field allows you to categorize the group.
- Width
- This field indicates the width of the area for the group item. The size will default in from Wiki, however you may change it.
- Height
- This field indicates the height of the area for the group item. The size will default in from Wiki, however you may change it.
- If you change the default size or prompt of a group item and that item is repeated anywhere on the form, those changes will remain. You will not be able to edit the size or prompt of the second occurrence separately.
- LOV
- This field allows LOVâs to be associated with specific types of fields.
Item Details#
- Prompt
- This field shows the name that will appear on form for the item. This name will default in from Wiki, however you may change it.
- If a prompt is not specified in IMFD, the 'Field Prompt' from the Column Detail field on IMCD will be displayed as the name of the group item on the form.
- There are screens where a displayed prompt is not necessary or desired. In this case, you will enter two quotation marks (" ") in the prompt field to get a blank title.
- Prompt (Lang)
- If the form is to be displayed in a second language, this field allows you to provide an alternate language name for the group item.
- Dftl Sort Order
- The Default Sort Direction field indicates how the data in the LOV is sorted.
- Format
- This field is used to define the date or numeric format.
- Item Usage
- This field indicates if the item is pre-loaded, user-defined or obsolete.
All Form Items (nn)#
- Change_Date
- The date the last change to the table was made.
- Change_User
- The user that made the last change to the table.
- Seq #
- This field indicates the sequential order that the groups appear on the form.
- Item Name
- This field holds the official name of the group item.
- Item Usage
- This field indicates if the item is pre-loaded, user-defined or obsolete.
- Form Group
- This field provides the official name of the group.