DEFINE USER FIELDS#
The Define User Fields (IMUF) screen allows you to create and maintain the user fields used by the associated table within the system.
User fields may be defined in any table that allows them. When you wish to enter a user field, you may select the User Fields icon, or select from the menu. When user fields exist for a record, the User Field icon will "light" up by changing color. User-defined fields are stored in the database as character fields, regardless of how they may be represented or defined to the user.
The definition data for the Define Code Sequences screen is stored in the P2K_AM_TABLE_DETAILS and P2K_AM_USER_FIELDS tables.
- Table
- The table that will contain the user defined field. This table must be permitted to have user defined fields.
User Field Info #
- Seq #
- This specifies the order that fields are to be displayed on the user fields form.
- User Field
- This field identifies the name of the user field. Field names may be alphanumeric, or contain the dollar ( $ ), pound sign ( # ) or underscore ( _ ) and must start with a letter.
- Prompt
- this field displays how the user field will be identified on the column.
- Prompt (FRE)
- If the form is to be displayed in a second language, this field allows you to provide an alternate language name for the user field. (On the example screen, the second language is identified as French, ‘Prompt (FRE)’.)
- Field Type
- This field defines the type of data is to be contained within the user field. The types of fields supported are Date, Number, and Char (alphanumeric)
- Required
- If this toggle is turned on, this field becomes a required entry. That is, a blank entry is invalid.
- Format Mask
- If there is some special formatting required for the field, the edit mask is defined in this field. This is typically used for date fields, to specify the format the date is to be shown in (DD-Mon-YYYY)
- Lexicon Name
- If the field is to have limited values to choose from, you may wish to define a lexicon to contain those values. The name of the lexicon would be entered here, or may be chosen from a list. The lexicon must exist prior to selecting the name.
