MAINTAIN LEXICONS#
Lexicons are an application concept where a finite list of values is presented to the user in translatable language, for control over data entry.
The Maintain Lexicons (IMLN) screen shows lexicons supplied by Wiki as well as user-defined lexicons.
The definition data for the Maintain Lexicon screen is stored in the P2K_AM_LEXICON_NAMES and P2K_AM_LEXICON_VALUES tables.
- Lexicon Name
- This field is used to define a name for the lexicon. Supplied lexicons are pre-defined with "X_" (e.g. X_APPROVAL_STATUS).
- Lexicon Type
- This field allows you to define the type of lexicon being defined.
- Length
- This field indicates the number of characters in the saved value of the lexicon. This does not affect the displayed value of the lexicon
- Country Sensitive
- If the lexicon is applicable to a specific country, you will indicate ‘Yes’ in this field.
- Saved Value
- The saved value is what any programming or application logic looks for.
- Displayed
- The displayed value is what is presented to the users when they do a drop down on the lexicon.
- Sort
- The sort column can be used to determine the sort order of the fields of the lexicon as they will appear in the drop down when added to a form.
- Usage
- This field determines the value's usage, i.e. Pre-loaded, Obsolete, User-Defined
- Legislation
- This field allows the user to assign a legislation to a lexicon value. This is typically used for taxation purposes.
- Meaning
- This provides the user with additional information on the values.
