ACRPTGRPX FILE

                     Account Category Group Detail

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

REFERENCED BY

AC13.2    AC13.1    AC165     AC196     AC297     AC10.1
AC105     AC208     AC256     AC300     AC50.1    AC500
AC510     AC55.1    AC87.1    ACBA.1    ACDL.1    AC121
AC123     AC127     AC130     AC170     AC20.1    AC20.2
AC20.3    AC20.4    AC22.1    AC30.1    AC30.2    AC30.3
AC32.1    AC401     AC471     AC480     AC65.1    AC65.2
AC90.1    AC90.2    AC95.1    AC95.2    AC97.1    AC97.2
ACBC.1

UPDATED BY

AC08.1    AC08.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

RGX-GROUP            Alpha 15                                    AC08.1  AC08.2
Report Group         Required key. This is the account
                     category group.

                     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.

RGX-ACCT-CATEGORY    Alpha 5                                     AC08.1
Account Category     Key field. These are the account
                     categories belonging to the account
                     category group.

RGX-ACTIVITY-GRP     Alpha 15                                    AC08.2
Activity Group       Required key. This is the activity
                     group for the account category group.

                         ACRPTGRPX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RGXSET1   GROUP                                                  AC13.2  AC165
          ACCT-CATEGORY                                          AC196   AC297
          ACTIVITY-GRP

RGXSET2   GROUP         KeyChange, Subset                        AC08.1  AC08.2
          ACTIVITY-GRP  Where (ACCT-CATEGORY = Spaces )          AC10.1  AC105
                                                                 AC13.1  AC208
                                                                 AC256   AC300
                                                                 AC50.1  AC500
                                                                 AC510   AC55.1
                                                                 AC87.1  ACBA.1
                                                                 ACDL.1

RGXSET3   GROUP         KeyChange, Subset                        AC08.1  AC08.2
          ACCT-CATEGORY Where (ACTIVITY-GRP = Spaces )           AC121   AC123
                                                                 AC127   AC130
                                                                 AC165   AC170
                                                                 AC196   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC208
                                                                 AC22.1  AC256
                                                                 AC297   AC30.1
                                                                 AC30.2  AC30.3
                                                                 AC32.1  AC401
                                                                 AC471   AC480
                                                                 AC55.1  AC65.1
                                                                 AC65.2  AC87.1
                                                                 AC90.1  AC90.2
                                                                 ...

                         ACRPTGRPX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Not Required

                            RGX-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY

Acactgrp       ACACTGRP     Not Required

                            RGX-ACTIVITY-GRP     -> AGP-ACTIVITY-GRP

Acrptgrp       ACRPTGRP     Required

                            RGX-GROUP            -> RGH-GROUP