Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             WFCHANDIR FILE

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

WCD-CHANNEL-NAME     Alpha 20
Channel Name

WCD-DIRECTORY-NAME   Alpha 20
Directory Name

WCD-CHANDIR-STATUS   Alpha 1
Chandir Status       A = Active
                     I = Inactive

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

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


                         WFCHANDIR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WCDSET1   CHANNEL-NAME
          DIRECTORY-NAME

WCDSET2   DIRECTORY-NAME
          CHANNEL-NAME

                         WFCHANDIR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfchannel      WFCHANNEL    Required

                            WCD-CHANNEL-NAME      -> WCN-CHANNEL-NAME  (WCNSET1)

Wfchdirect     WFCHDIRECT   Required

                            WCD-DIRECTORY-NAME    -> DIR-DIRECTORY-NAME