Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            WFGROUPHDR FILE

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

WGH-DIRECTORY-GRP    Alpha 25  (Lower Case)
Directory Grp

WGH-GROUP-STATUS     Alpha 1
Group Status         A = Active
                     I = Inactive
                     H = Historical

WGH-GRP-DESC         Alpha 50  (Lower Case)
Grp Desc

WGH-SEARCH-NAME      Alpha 30
Search Name

WGH-LAST-GRP-SEQ     Numeric 6
Last Grp Seq

WGH-DATE             Numeric 8  (yyyymmdd)
Date                 This field contains the system date
                     when this was created.

WGH-TIME             Numeric 8
Time                 This field is updated automatically to
                     indicate the time that the GL entry was
                     created. It is system-maintained.


WGH-SH-GRP-DESC      Derived
Sh Grp Desc

                         WFGROUPHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WGHSET1   DIRECTORY-GRP

WGHSET2   DIRECTORY-GRP KeyChange
          GROUP-STATUS

WGHSET3   SEARCH-NAME
          DIRECTORY-GRP
          GROUP-STATUS

                         WFGROUPHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfgrptemp      WFGRPTEMP    Required

                            WGH-DIRECTORY-GRP    -> GUT-DIRECTORY-GRP  (GUTSET1)

                         WFGROUPHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfgroup        WFGROUP

                            WGH-DIRECTORY-GRP    -> GRP-DIRECTORY-GRP
                                                    GRP-SEQ-NUMBER