Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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     AC135     AC165     AC190     AC191     AC192
AC196     AC198     AC20.1    AC20.2    AC20.3    AC20.4
AC20.5    AC200     AC208     AC210     AC213     AC218
AC220     AC240     AC256     AC258     AC261     AC265
AC290     AC295     AC297     AC298     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    ACDM.9
ACDR.1    DA233     DA240     GR240     BR120     BR121
BR130     BR131     BR142     BR165     BR200     BR202
BR204     BR205     BR210     BR220     BR265     BR400
BR405     BR420     BR430     BR450

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
                                                                 AC135   AC165
                                                                 AC190   AC191
                                                                 AC192   AC196
                                                                 AC198   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC200   AC208
                                                                 AC210   AC213
                                                                 AC218   AC220
                                                                 AC240   AC256
                                                                 AC258   AC261
                                                                 ...

                         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