Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            WFRDIDTYPE FILE

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

WTY-DIR-ID-TYPE      Alpha 10
Dir Id Type

WTY-DIRTYPE-STATUS   Alpha 1
Dirtype Status       A = Active
                     I = Inactive

WTY-DIRTYPE-DESC     Alpha 50  (Lower Case)
Dirtype Desc

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

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


                         WFRDIDTYPE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WTYSET1   DIR-ID-TYPE

                         WFRDIDTYPE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfrdiddtl      WFRDIDDTL

                            WTY-DIR-ID-TYPE    -> WRD-DIR-ID-TYPE  (WRDSET3)
                                                  WRD-DIRECTORY-ID
                                                  WRD-SEQ-NUMBER
                                                  WRD-EFFECTIVE-DATE
                                                  WRD-PARENT-DIR-ID