Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             WFCHGROUP FILE

                          Channels List Group

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CGR-LIST-GROUP       Alpha 15
List Group

CGR-DESCRIPTION      Alpha 30  (Lower Case)
Description          This field contains the description.

CGR-GRP-TYPE         Alpha 1
Grp Type             A = All
                     R = Restricted

CGR-GROUP-STATUS     Alpha 1
Group Status         A = Active
                     I = Inactive

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

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


                         WFCHGROUP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CGRSET1   LIST-GROUP

                         WFCHGROUP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfchinfdtl     WFCHINFDTL

                            CGR-LIST-GROUP    -> WID-LIST-GROUP  (WIDSET4)
                                                 WID-INFORMATION
                                                 WID-RULETAG
                                                 WID-DIRECTORY-NAME

Wfchlstgrp     WFCHLSTGRP

                            CGR-LIST-GROUP    -> LGR-LIST-GROUP
                                                 LGR-LIST
                                                 LGR-DIRECTORY-ID
                                                 LGR-SEQ-NUMBER

Wfchsubscr     WFCHSUBSCR

                            CGR-LIST-GROUP    -> SUB-LIST-GROUP
                                                 SUB-DIRECTORY-ID