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

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
6 26-Nov-2021 10:22 3 KB JEscott to previous
5 26-Nov-2021 10:22 3 KB JEscott to previous | to last
4 26-Nov-2021 10:22 2 KB JMyers to previous | to last
3 26-Nov-2021 10:22 2 KB JMyers to previous | to last
2 26-Nov-2021 10:22 3 KB JMyers to previous | to last
1 26-Nov-2021 10:22 2 KB JMyers to last

Page References

Incoming links Outgoing links
IMLOV
IMLOV

Version management

Difference between version and

At line 4 added 2 lines
The definition data for the Maintain List of Values by Table screen is stored in the [P2K_AM_LIST_OF_VALUES], [P2K_AM_LIST_OF_VALUES_COLUMNS] and [P2K_AM_DATA_ACCESS_OBJECTS] tables.
At line 5 changed 6 lines
List of Values
This field will provide the name of the list of values being defined.
Title
This field provides the title of the LOV which will appear at the top of the LOV box.
LOV Usage This field will indicate if the LOV is Pre-loaded (McKessonHigh Line provided), User Defined or Obsolete.
Where Clause The Where Clause corresponds to an SQL statement and dictates how the data in the LOV can be filtered.
;[List of Values|]:This field will provide the name of the list of values being defined.
;[Title|]:This field provides the title of the LOV which will appear at the top of the LOV box.
;[Usage|]: This field will indicate if the LOV is Pre-loaded (McKessonHigh Line provided), User Defined or Obsolete.
;[Where Clause|]: The Where Clause corresponds to an SQL statement and dictates how the data in the LOV can be filtered.
At line 14 changed 6 lines
To Replace
LOV Title (FRE) If the form is to be displayed in a second language, this field allows you to provide an alternate language name for the LOV. (On the example screen, the second language is identified as French, ‘Prompt (FRE)’.)
Purpose This field provides a quick description of the data source. Non-updatable
#
The sequence number indicates the order in which the columns in the LOV box will appear.
Column Use this field to indicate the information to go into the columns. You will make your choice from the selection provided in the drop down menu.
;[To Replace|]:
;[LOV Title (FRE)|]: If the form is to be displayed in a second language, this field allows you to provide an alternate language name for the LOV. (On the example screen, the second language is identified as French, ‘Prompt (FRE)’.)
;[Purpose|]: This field provides a quick description of the data source. Non-updatable
;[Exclude from CACHE|]:
;[#|]:The sequence number indicates the order in which the columns in the LOV box will appear.
;[Column|]: Use this field to indicate the information to go into the columns. You will make your choice from the selection provided in the drop down menu.
At line 21 changed 7 lines
Display As
This field allows you to give a title to the column in the LOV box.
Width
This field indicates the width of the column in the LOV box.
Sort Order
Usage
This field will indicate if the LOV is Pre-loaded (McKessonHigh Line provided), User
;[Display As|]:This field allows you to give a title to the column in the LOV box.
;[Width|]:This field indicates the width of the column in the LOV box.
;[Sort Order|]:
;[Usage|]:This field will indicate if the LOV is Pre-loaded (McKessonHigh Line provided), User
At line 29 changed one line
Column Title (FRE) If the form is to be displayed in a second language, this field allows you to provide an alternate language name for the column. (On the example screen, the second language is identified as French, ‘Prompt (FRE)’.)
;[Column Title (FRE)|]: If the form is to be displayed in a second language, this field allows you to provide an alternate language name for the column. (On the example screen, the second language is identified as French, ‘Prompt (FRE)’.)
At line 31 changed 3 lines
Clear LOV This field clears the old information provided in the LOV. The new information will not be reloaded until the first time a user accesses the LOV. This may cause a time delay for that user.
Load LOV
This field will loads new information into the LOV. This means that the first user who
;[Physical Column Name|]:
;[Clear LOV|]: This field clears the old information provided in the LOV. The new information will not be reloaded until the first time a user accesses the LOV. This may cause a time delay for that user.
;[Load LOV|]:This field will loads new information into the LOV. This means that the first user who
This page (revision-6) was last changed on 26-Nov-2021 10:22 by JEscottTop