WFCHLSTGRP FILE

                       Channels List Group Detail

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

LGR-LIST-GROUP       Alpha 15
List Group

LGR-LIST             Alpha 15
List

LGR-DIRECTORY-ID     Numeric 15
Directory Id

LGR-SEQ-NUMBER       Numeric 6
Record Sequence      A unique number assigned to each
Number               transaction to be transferred into the
                     Lawson system.

LGR-LISTGRP-STATUS   Alpha 1
Listgrp Status       A = Active
                     I = Inactive

LGR-INFORM-TYPE      Numeric 1
Inform Type          1 = Generally not notified
                     2 = Generally notified
                     3 = Always notified
                     4 = Never notified

LGR-DELIVERY-TYPE    Alpha 1
Delivery Type        A = Attachment
                     E = EMail

LGR-PUBLISH-SUFFIX   Alpha 10  (Lower Case)
Publish Suffix

LGR-START-DATE       Numeric 8  (yyyymmdd)
Start Date

LGR-STOP-DATE        Numeric 8  (yyyymmdd)
Stop Date

LGR-FILTER-CATGORY   Alpha 1
Filter Catgory       Y = Yes
                     N = No

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

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


                         WFCHLSTGRP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

LGRSET1   LIST-GROUP
          LIST
          DIRECTORY-ID
          SEQ-NUMBER

LGRSET2   DIRECTORY-ID
          SEQ-NUMBER
          LIST-GROUP
          LIST

LGRSET3   LIST
          LIST-GROUP
          DIRECTORY-ID
          SEQ-NUMBER

                         WFCHLSTGRP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfchgroup      WFCHGROUP    Required

                            LGR-LIST-GROUP      -> CGR-LIST-GROUP  (CGRSET1)

Wfchlist       WFCHLIST     Required

                            LGR-LIST            -> LIS-LIST

Wfchsubscr     WFCHSUBSCR   Required

                            LGR-LIST-GROUP      -> SUB-LIST-GROUP
                            LGR-DIRECTORY-ID    -> SUB-DIRECTORY-ID

Wfrdidhdr      WFRDIDHDR    Required

                            LGR-DIRECTORY-ID    -> WDR-DIRECTORY-ID