Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             WFRDIDGRP FILE

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

WDG-DIRECTORY-ID     Numeric 15
Directory Id

WDG-EFFECTIVE-DATE   Numeric 8  (yyyymmdd)
Effective Date       The date a vendor's prices will be in
                     effect.

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

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


                         WFRDIDGRP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WDGSET1   DIRECTORY-GRP
          DIRECTORY-ID
          EFFECTIVE-DATE*

WDGSET2   DIRECTORY-ID
          EFFECTIVE-DATE*
          DIRECTORY-GRP

                         WFRDIDGRP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfgrouphdr     WFGROUPHDR   Required

                            WDG-DIRECTORY-GRP    -> WGH-DIRECTORY-GRP  (WGHSET1)

Wfrdidhdr      WFRDIDHDR    Required

                            WDG-DIRECTORY-ID     -> WDR-DIRECTORY-ID