Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCATGRPX


                             ACCATGRPX FILE

                     Account Category Group Detail

The Account Category Group Detail file stores the specific account category
names that make up a group. If the All flag is set on the Account Category
Group Header file, there are no detail records. Account Category Groups are
defined on AC08.1

REFERENCED BY

AC08.5    AC105     AC121     AC123     AC130     AC135
AC145     AC160     AC165     AC169     AC190     AC197
AC20.1    AC20.2    AC20.3    AC20.4    AC20.5    AC205
AC240     AC246     AC256     AC290     AC295     AC298
AC30.1    AC32.1    AC34.1    AC346     AC37.1    AC40.1
AC40.4    AC401     AC41.1    AC41.4    AC410     AC42.1
AC420     AC440     AC45.4    AC46.1    AC460     AC471
AC480     AC490     AC494     AC527     AC55.1    AC65.1
AC65.2    AC90.1    AC90.2    AC90.4    AC90.6    AC90.8
AC92.1    AC92.2    AC92.4    AC92.6    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     AP170     AP193     AP25.1    AP25.2
AP26.1    AP27.1    AP30.2    AP520     AR239     AR296
BR02.3    BR120     BR121     BR122     BR123     BR130
BR140     BR142     BR151     BR152     BR156     BR165
BR18.2    BR190     BR20.1    BR20.2    BR20.3    BR20.4
BR20.5    BR41.1    BR41.4    BR420     BR43.1    BR450
BR515     BR516     BR521     BR530     BR65.1    BR65.2
BR65.3    CB10.1    CB15.1    CB15.2    CB150     CB191
CB20.1    CB30.1    CB45.1    CB46.1    CB500     CB543
CB544     CB55.1    CB554     EE135     EE20.3    EE35.1
EE35.2    EE520     ET700     GL146     GL165     GL170
GL197     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    POIG.1    SNAC.1

UPDATED BY

AC05.2    AC05.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

CGX-ACCT-CATEGORY      Alpha 5                                   AC05.2  AC05.3
Element: Acct Category Account categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

                         ACCATGRPX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CGXSET1   CAT-GROUP                                              AC05.2  AC05.3
          ACCT-CATEGORY                                          AC08.5  AC105
                                                                 AC121   AC123
                                                                 AC130   AC135
                                                                 AC145   AC160
                                                                 AC165   AC169
                                                                 AC190   AC197
                                                                 AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC20.5  AC205
                                                                 AC240   AC246
                                                                 AC256   AC290
                                                                 AC295   AC298
                                                                 AC30.1  AC32.1
                                                                 AC34.1  AC346
                                                                 ...

                         ACCATGRPX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Not Required

                            CGX-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY

Accatgrp       ACCATGRP     Required

                            CGX-CAT-GROUP        -> CGP-CAT-GROUP