Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCTRCATGX


                            ACCTRCATGX FILE

REFERENCED BY

AC112     AC113     AC12.1    AC120     AC121     AC123
AC135     AC145     AC160     AC165     AC190     AC191
AC197     AC198     AC200     AC203     AC206     AC207
AC210     AC213     AC218     AC220     AC240     AC246
AC261     AC265     AC290     AC295     AC298     AC346
AC40.1    AC40.4    AC400     AC401     AC41.1    AC41.4
AC410     AC412     AC42.1    AC420     AC421     AC440
AC45.1    AC460     AC471     AC472     AC473     AC480
AC490     AC493     AC494     AC50.1    AC500     AC54.1
AC540     ACAC.1    AP211     BR00.1    BR00.2    BR02.3
BR120     BR121     BR122     BR130     BR131     BR140
BR142     BR145     BR165     BR19.1    BR190     BR20.1
BR20.2    BR20.3    BR20.4    BR20.5    BR20.6    BR200
BR202     BR204     BR205     BR210     BR212     BR215
BR220     BR245     BR265     BR300     BR40.3    BR40.4
BR400     BR405     BR420     BR430     BR450     BR46.1
BR46.2    BR46.4    BR521     BR530     BR580     BR218

UPDATED BY

AC300     AC310     BR18.1    BR18.2    BR18.3    AC10.1
BR10.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BCX-CONTRACT           Alpha 10                                  BR18.1  BR18.2
Element: Contract      Activity Management contract.             BR18.3

BCX-CTR-CAT-GRP        Alpha 5                                   BR120   BR121
Element: Ctr Cat Grp                                             BR122   BR18.1
                                                                 BR18.2  BR18.3
                                                                 BR20.1  BR20.2
                                                                 BR20.3  BR20.4
                                                                 BR20.5  BR420
                                                                 BR521

BCX-ACCT-CATEGORY      Alpha 5                                   BR18.1  BR18.2
Element: Account CategoAccount 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

                         ACCTRCATGX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BCXSET1   CONTRACT                                               AC10.1  AC112
          ACCT-CATEGORY                                          AC113   AC12.1
                                                                 AC120   AC121
                                                                 AC123   AC135
                                                                 AC145   AC160
                                                                 AC165   AC190
                                                                 AC191   AC197
                                                                 AC198   AC200
                                                                 AC203   AC206
                                                                 AC207   AC210
                                                                 AC213   AC218
                                                                 AC220   AC240
                                                                 AC246   AC261
                                                                 AC265   AC290
                                                                 AC295   AC298
                                                                 ...

BCXSET2   CTR-CAT-GRP   KeyChange
          ACCT-CATEGORY
          CONTRACT

BCXSET3   CONTRACT      KeyChange                                BR120   BR121
          CTR-CAT-GRP                                            BR122   BR18.1
          ACCT-CATEGORY                                          BR18.3  BR19.1
                                                                 BR190   BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR218   BR420
                                                                 BR521

                         ACCTRCATGX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Required

                            BCX-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY

Accntract      ACCNTRACT    Required

                            BCX-CONTRACT         -> CNT-CONTRACT

Acctrcatg      ACCTRCATG    Required

                            BCX-CTR-CAT-GRP      -> BCG-CTR-CAT-GRP
                            BCX-CONTRACT         -> BCG-CONTRACT