Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             WFCHANNEL FILE

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

WCN-CHANNEL-NAME     Alpha 20
Channel Name

WCN-CHANNEL          Alpha 50  (Lower Case)
Channel

WCN-CHANNEL-STATUS   Alpha 1
Channel Status       A = Active
                     I = Inactive

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

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


                         WFCHANNEL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WCNSET1   CHANNEL-NAME

                         WFCHANNEL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfchandir      WFCHANDIR

                            WCN-CHANNEL-NAME    -> WCD-CHANNEL-NAME  (WCDSET1)
                                                   WCD-DIRECTORY-NAME

Wfchusrcd      WFCHUSRCD

                            WCN-CHANNEL-NAME    -> UCD-CHANNEL-NAME
                                                   UCD-DIRECTORY-NAME
                                                   UCD-DIRECTORY-ID

Wfchusrcdi     WFCHUSRCDI

                            WCN-CHANNEL-NAME    -> WUI-CHANNEL-NAME
                                                   WUI-DIRECTORY-NAME
                                                   WUI-DIRECTORY-ID
                                                   WUI-INFORMATION
                                                   WUI-RULETAG

Wfchusrch      WFCHUSRCH

                            WCN-CHANNEL-NAME    -> WUC-CHANNEL-NAME
                                                   WUC-DIRECTORY-ID