Defining fields for user defined screens

Field Name

Specify the name for the field. The field name must be unique and cannot be a database reserved word or contain special characters.

Description

Specify a description of the field.

Field Label

Specify the boiler text for the field. The default Field Label is equivalent to the Field.

Sequence

Specify a numeric value for the sequence. Fields are displayed in ascending order by their sequence.

Field Type

Specify the field type. The default Field Type is Alphabetic. Specify the default Field Type as one of the following options:

• Alphabetic
• Numeric
• Date
• Date Time
• Time
• Free Format Text
• Checkbox

Uppercase

Select to enforce uppercase characters for the field value when the field type is Alphabetic.

Field Length

Specify the maximum character length if the field type is Alphabetic.

Total Digits

Specify the total number of digits allowed including decimal places for the field if the Field Type is Numeric.

Decimal Places

Specify the number of digits allowed after the decimal for the field if the Field Type is Numeric.

Computed Value

Select to indicate the defined field will use the valued entered in the Computed Data field to calculate the field value.

Computed Data

Specify the computed data statement for the field when Field Type is Computed Value.

Retrieved Value

Select to indicate the value can be retrieved from a database table or other screen. If selected the field will behave as a lookup field using the source field value and query code value to create a list of values. Retrieved values can only be used on alphabetic fields.

Source Field

Specify the source field if the value will be retrieved from another database table.

Query Code

Specify the query code to define the list of values available for selection from the LOV. When a query code is specified for a field, the field behaves as an LOV.

Is Primary Key

Select to indicate that there cannot be another record with the same value in that field. Field types of Free Format Text, Checkbox, Date, Date Time, and Time cannot be selected as primary key fields.

Is Nullable

Select to allow users to leave the field blank.

Note: The Is Nullable check box is protected and cannot be edited when a field is selected as a primary key.

Parent Screen Key Field

Specify the key field of the parent screen of this field if the user defined screen for which you are defining this field is the tab on a parent screen.

Out of Service

Select to prevent the field from being displayed in user defined screen lookups.