Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             ACRPTGRP FILE

                         Account Category Group

This file contains information about account category groups from AC11.1
(Account Category Group). It includes the account category group name and
description.

REFERENCED BY

AC10.1    AC105     AC115     AC120     AC121     AC123
AC127     AC13.1    AC13.2    AC130     AC14.1    AC165
AC170     AC176     AC196     AC20.1    AC20.2    AC20.3
AC20.4    AC208     AC22.1    AC220     AC255     AC256
AC265     AC297     AC30.1    AC30.2    AC30.3    AC300
AC32.1    AC400     AC401     AC410     AC415     AC416
AC420     AC421     AC450     AC470     AC471     AC473
AC480     AC50.1    AC500     AC510     AC55.1    AC87.1
AC90.1    AC95.1    AC97.1    ACBA.1    ACDL.1    MX00.3

UPDATED BY

AC08.1    AC08.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

RGH-GROUP            Alpha 15                                    AC08.1  AC08.2
Account Category     Required key. This is the account
Group                category group name.

                     Account category groups are collections
                     of account categories grouped for
                     reporting purposes. Account categories
                     in an account category group can be in
                     the same or different activity groups.
                     The account category group is a way to
                     report on multiple activities with a
                     single request. Using account category
                     groups increases reporting flexibility.

RGH-DESCRIPTION      Alpha 30  (Lower Case)                      AC08.1  AC08.2
Acct Category Grp    This is the account category group
Description          description.

RGH-GROUP-TYPE       Derived
Group Type           This is the type of the report group:
                     report or update.

RGH-ALL-FLAG         Alpha 1                                     AC08.2
All Flag             This flag indicates whether the account
                     category group includes all account
                     categories.
                     Y = Yes
                     N = No

                         ACRPTGRP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RGHSET1   GROUP                                                  AC08.1  AC08.2
                                                                 AC10.1  AC105
                                                                 AC115   AC120
                                                                 AC121   AC123
                                                                 AC127   AC13.1
                                                                 AC13.2  AC130
                                                                 AC14.1  AC165
                                                                 AC170   AC176
                                                                 AC196   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC208
                                                                 AC22.1  AC220
                                                                 AC255   AC256
                                                                 AC265   AC297
                                                                 AC30.1  AC30.2
                                                                 ...

                         ACRPTGRP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acrptgrpx      ACRPTGRPX

                            RGH-GROUP    -> RGX-GROUP
                                            RGX-ACCT-CATEGORY
                                            RGX-ACTIVITY-GRP

Acrptgrpx Cat  ACRPTGRPX

                            RGH-GROUP    -> RGX-GROUP
                                            RGX-ACCT-CATEGORY

Acrptgrpx Grp  ACRPTGRPX

                            RGH-GROUP    -> RGX-GROUP
                                            RGX-ACTIVITY-GRP