Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             WFCHLIST FILE

                             Channels List

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

LIS-LIST             Alpha 15
List

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

LIS-LIST-STATUS      Alpha 1
List Status          A = Active
                     I = Inactive

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

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


                         WFCHLIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

LISSET1   LIST

                         WFCHLIST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfchlstdtl     WFCHLSTDTL

                            LIS-LIST    -> LDT-LIST  (LDTSET1)
                                           LDT-DIRECTORY-ID

Wfchlstgrp     WFCHLSTGRP

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

Wfchrulist     WFCHRULIST

                            LIS-LIST    -> RLS-LIST
                                           RLS-RULETAG