Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ACCATGRPX FILE

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

AC121     AC123     AC130     AC165     AC190     AC196
AC20.1    AC20.2    AC20.3    AC20.4    AC20.5    AC208
AC240     AC256     AC290     AC295     AC297     AC298
AC30.1    AC30.2    AC30.3    AC32.1    AC34.1    AC401
AC410     AC440     AC460     AC471     AC480     AC490
AC494     AC541     AC55.1    AC550     AC65.1    AC65.2
AC741     AC750     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    AC97.1    AC97.2    AC97.4    AC97.6    ACBC.1
ACDL.1    ACDM.3    ACVW.1    GR741     SE90.1    BR142
BR450     BR65.1    BR65.2    BRCC.1

UPDATED BY

AC08.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CGX-CAT-GROUP        Alpha 15                                    AC08.1
Cat Group

CGX-ACCT-CATEGORY    Alpha 5                                     AC08.1
Account 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.

                         ACCATGRPX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CGXSET1   CAT-GROUP                                              AC08.1  AC121
          ACCT-CATEGORY                                          AC123   AC130
                                                                 AC165   AC190
                                                                 AC196   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC208   AC240
                                                                 AC256   AC290
                                                                 AC295   AC297
                                                                 AC298   AC30.1
                                                                 AC30.2  AC30.3
                                                                 AC32.1  AC34.1
                                                                 AC401   AC410
                                                                 AC440   AC460
                                                                 AC471   AC480
                                                                 ...

                         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