Introduction to Work Fields

Work fields are temporary fields that are not maintained in a file, but can be manipulated by processes in APPX (usually through the use of statements). They are used to display values that are not stored, such as a calculated line item amount (quantity multiplied by price) or a constant value like p (pi). A work field value is available in memory to a user.

The Work Fields screen, shown in Figure 2-5-1, displays attributes that are common to all work fields, regardless of type (alphanumeric or date, for example). You access this screen by selecting the work fields option from the Database Management menu overlay.

Figure_2-05-01.png

Figure 2-5-1. Work Fields Screen

The Work Fields screen contains the following fields:

·    Field Name uniquely identifies individual work fields within an APPX application. Work fields are referenced by their Field Name throughout application design.

·    Field Type categorizes fields according to their function within APPX. The specifications that are presented on subsequent screen overlays depend on the Field Type entered here. The Field Type options are:

·    Domain assumes the attributes that are defined for an alpha, date, logic, or numeric work field.

·    Alpha work fields may contain numbers, letters, and special characters (-, #, or &, for example).

·    Format work fields may contain an edit mask.

·    Text work fields may contain text.

·    Token work fields use specific values that are stored as corresponding numbers.

·    Numeric work fields are restricted to number, decimal (.), and sign (-) entries.

·    Date work fields may contain dates and/or times, from a hundredth of a second through a century.

·    Logic work fields have possible values of yes iconcheckyes.png, no iconcheckno.png, or iconcheckunkn.png to represent an unknown value.

There are three options available from the Work Fields screen: Toolbox, Data Lookup, and Additional Attributes.