Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            WFFORMFLDS FILE

                          Workflow Form Fields

The Workflow Form Field file describes the fields for the Enterprise Workflow
forms. The information in this file includes the field name, type, and size,
an ordinal position of the field, and a Boolean value indicating whether or
not the field is a key search field.

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

WFD-FORM             Alpha 10
Form                 This is the form for which this field
                     has been defined. Forms are defined on
                     WF02.1 (Form and Field
                     Definition).

WFD-FIELD-NBR        Numeric 4
Field Number         This is a system-specific number that
                     refers to an exact field in a file. Each
                     field in a file has been assigned
                     a unique number for reference purposes.

WFD-KEY-FIELD        Alpha 1
Key Field            This field indicates whether or not
                     this field is required to uniquely
                     search for a work unit.
                     Y = Yes
                     N = No

WFD-FORM-FLD-NAME    Alpha 20
Form Fld Name        This is the name of the field. Field
                     names may be up to 20 characters long.

WFD-FORM-FLD-TYPE    Alpha 1
Form Fld Type        This column indicates whether the field
                     is alphanumeric or numeric.
                     A = Alpha
                     N = Numeric

WFD-FORM-FLD-SIZE    Numeric 2
Form Fld Size        The size of the field in characters.
                     Numeric fields are a maximum of 18,
                     alpha fields are a maximum of 20.

                         WFFORMFLDS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WFDSET1   FORM
          FIELD-NBR

WFDSET2   FORM          KeyChange
          FORM-FLD-NAME

                         WFFORMFLDS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfform         WFFORM       Required

                            WFD-FORM    -> WFR-FORM  (WFRSET1)