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    AC13.7    AC130     AC135     AC165     AC176
AC190     AC191     AC192     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     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    DA233     DA240     GR240     SE90.1
BR120     BR121     BR130     BR131     BR142     BR165
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
                                                                 AC13.7  AC130
                                                                 AC135   AC165
                                                                 AC176   AC190
                                                                 AC191   AC192
                                                                 AC196   AC198
                                                                 AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC20.5  AC200
                                                                 AC208   AC210
                                                                 AC213   AC218
                                                                 AC220   AC240
                                                                 ...

                         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