Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCATGRP


                             ACCATGRP FILE

                         Account Category Group

The Account Category Group Header file stores account category group names and
 descriptions. It also stores an All flag which indicates if the group
consists of all account categories. Account Category Groups are defined on
AC08.1.

REFERENCED BY

AC08.5    AC105     AC113     AC120     AC121     AC123
AC130     AC135     AC145     AC165     AC190     AC191
AC197     AC198     AC20.1    AC20.2    AC20.3    AC20.4
AC20.5    AC205     AC210     AC213     AC220     AC240
AC246     AC256     AC261     AC265     AC290     AC295
AC298     AC30.1    AC32.1    AC34.1    AC346     AC35.1
AC36.1    AC37.1    AC40.1    AC40.4    AC400     AC401
AC41.1    AC41.4    AC410     AC42.1    AC420     AC421
AC440     AC46.1    AC460     AC471     AC472     AC473
AC480     AC490     AC493     AC494     AC55.1    AC583
AC62.1    AC65.1    AC65.2    AC90.1    AC90.2    AC90.4
AC90.6    AC90.8    AC91.1    AC91.2    AC92.1    AC92.2
AC92.4    AC92.6    AC93.2    AC93.4    AC94.1    AC94.2
AC94.4    AC94.6    AC95.1    AC95.2    AC95.4    AC95.6
ACAC.1    ACBC.1    ACDL.1    ACDM.3    ACVW.1    SE90.1
AP125     AP126     AP25.1    AP25.2    AP26.1    AP27.1
AP30.2    AP520     BR02.3    BR10.1    BR120     BR121
BR122     BR130     BR131     BR140     BR142     BR145
BR15.1    BR18.2    BR190     BR20.1    BR20.2    BR20.3
BR20.4    BR20.5    BR202     BR204     BR205     BR215
BR220     BR245     BR265     BR300     BR400     BR405
BR41.1    BR41.4    BR420     BR43.1    BR430     BR450
BR515     BR516     BR521     BR530     BR580     BR65.1
BR65.2    BRCC.1    CB10.1    CB15.1    CB15.2    CB191
CB20.1    CB30.1    CB500     EE135     EE20.3    EE35.1
EE35.2    EE520     GL146     GL165     GL170     GL197
GL199     GL40.1    GL40.2    GL40.3    GL40.7    GL40.8
GL44.1    GL45.1    GL70.1    GL70.2    GL70.3    GL70.5
GL70.6    GL75.1    MA65.1

UPDATED BY

AC05.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CGP-CAT-GROUP          Alpha 15                                  AC05.2
Element: Cat Group

CGP-DESCRIPTION        Alpha 30  (Lower Case)                    AC05.2
Element: Description   This field displays the description.

CGP-ALL-FLAG           Alpha 1                                   AC05.2
Element: All Flag      Y = Yes
                       N = No

                         ACCATGRP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CGPSET1   CAT-GROUP                                              AC05.2  AC05.3
                                                                 AC08.5  AC105
                                                                 AC113   AC120
                                                                 AC121   AC123
                                                                 AC130   AC135
                                                                 AC145   AC165
                                                                 AC190   AC191
                                                                 AC197   AC198
                                                                 AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC20.5  AC205
                                                                 AC210   AC213
                                                                 AC220   AC240
                                                                 AC246   AC256
                                                                 AC261   AC265
                                                                 ...

                         ACCATGRP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accatgrpx      ACCATGRPX

                            CGP-CAT-GROUP    -> CGX-CAT-GROUP
                                                CGX-ACCT-CATEGORY