Lawson Insight Technical Documentation

                             ACCOLGRP FILE

The Collection Group Header file stores collection names and descriptions. A
Collection is a group of Activity Groups. The file also stores an All flag to
indicate if a collection includes all activity groups. Collections are defined
on AC08.2.

REFERENCED BY

AC10.1    AC105     AC120     AC121     AC123     AC13.1
AC13.2    AC130     AC165     AC176     AC190     AC191
AC196     AC198     AC20.1    AC20.2    AC20.3    AC20.4
AC20.5    AC200     AC208     AC210     AC213     AC218
AC220     AC240     AC255     AC256     AC258     AC261
AC265     AC290     AC295     AC297     AC298     AC30.2
AC30.3    AC300     AC310     AC32.1    AC34.1    AC400
AC401     AC410     AC420     AC421     AC440     AC460
AC471     AC472     AC473     AC480     AC490     AC493
AC494     AC50.1    AC500     AC510     AC55.1    AC580
AC581     AC90.1    AC90.2    AC90.4    AC90.6    AC90.8
AC92.1    AC92.2    AC92.4    AC92.6    AC93.1    AC93.2
AC93.3    AC93.4    AC93.5    AC94.1    AC94.2    AC94.4
AC94.6    AC95.1    AC95.2    AC95.4    AC95.6    AC97.1
AC97.2    AC97.4    AC97.6    ACBA.1    ACDL.1    ACDM.2
ACDR.1    SE90.1    BR120     BR121     BR142     BR200
BR202     BR204     BR205     BR210     BR220     BR265
BR400     BR405     BR420     BR430     BR450     BRCC.1
MX00.3

UPDATED BY

AC08.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CLG-COLLECTION       Alpha 15                                    AC08.2
Collection

CLG-DESCRIPTION      Alpha 30  (Lower Case)                      AC08.2
Description          This field displays the description.

CLG-ALL-FLAG         Alpha 1                                     AC08.2
All Flag             Y = Yes
                     N = No

                         ACCOLGRP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CLGSET1   COLLECTION                                             AC08.2  AC10.1
                                                                 AC105   AC120
                                                                 AC121   AC123
                                                                 AC13.1  AC13.2
                                                                 AC130   AC165
                                                                 AC176   AC190
                                                                 AC191   AC196
                                                                 AC198   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC200   AC208
                                                                 AC210   AC213
                                                                 AC218   AC220
                                                                 AC240   AC255
                                                                 AC256   AC258
                                                                 ...

                         ACCOLGRP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accolgrpx      ACCOLGRPX

                            CLG-COLLECTION    -> CLX-COLLECTION
                                                 CLX-ACTIVITY-GRP

Matrix Cat     MXOBJCAT

                            "ACTVY"           -> MOC-OBJ-TYPE
                            CLG-COLLECTION    -> MOC-APPLY-TO-GROUP
                                                 MOC-MATRIX-CAT