Lawson Insight Technical Documentation

                             ACCOLGRPX FILE

The Collection Group Detail file stores the activity group names that make up
a collection. If the All flag is set to Y in the Collection Group Header,
there are no detail records. Collections are defined on AC08.2.

REFERENCED BY

AC10.1    AC105     AC121     AC123     AC13.1    AC13.2
AC130     AC165     AC190     AC191     AC196     AC198
AC20.1    AC20.2    AC20.3    AC20.4    AC20.5    AC200
AC208     AC210     AC213     AC218     AC240     AC256
AC258     AC261     AC265     AC290     AC295     AC297
AC298     AC30.2    AC30.3    AC300     AC32.1    AC34.1
AC400     AC401     AC410     AC420     AC440     AC460
AC471     AC472     AC473     AC480     AC490     AC493
AC494     AC50.1    AC500     AC510     AC55.1    AC581
AC90.1    AC90.2    AC90.4    AC90.6    AC90.8    AC92.1
AC92.2    AC92.4    AC92.6    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    BR120
BR121     BR142     BR200     BR202     BR204     BR205
BR210     BR220     BR265     BR400     BR405     BR420
BR430     BR450     BRCC.1

UPDATED BY

AC08.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CLX-COLLECTION       Alpha 15                                    AC08.2
Collection

CLX-ACTIVITY-GRP     Alpha 15                                    AC08.2
Activity Group

                         ACCOLGRPX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CLXSET1   COLLECTION                                             AC08.2  AC10.1
          ACTIVITY-GRP                                           AC105   AC121
                                                                 AC123   AC13.1
                                                                 AC13.2  AC130
                                                                 AC165   AC190
                                                                 AC191   AC196
                                                                 AC198   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC200   AC208
                                                                 AC210   AC213
                                                                 AC218   AC240
                                                                 AC256   AC258
                                                                 AC261   AC265
                                                                 AC290   AC295
                                                                 ...

                         ACCOLGRPX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactgrp       ACACTGRP     Not Required

                            CLX-ACTIVITY-GRP    -> AGP-ACTIVITY-GRP

Accolgrp       ACCOLGRP     Required

                            CLX-COLLECTION      -> CLG-COLLECTION