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
AC128     AC135     AC145     AC160     AC165     AC169
AC190     AC191     AC197     AC198     AC200     AC203
AC206     AC207     AC210     AC213     AC218     AC220
AC225     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     AC527     AC54.1    AC540     AC90.1
AC90.2    AC90.4    AC90.6    AC90.8    AC92.1    AC92.2
AC92.4    AC92.6    AC93.4    AC93.5    AC94.1    AC94.2
AC94.4    AC94.6    AC95.1    AC95.2    AC95.4    AC95.6
ACAC.1    AP211     AR237     AR239     AR257     AR296
AR32.1    BR00.1    BR00.2    BR02.3    BR120     BR121
BR122     BR123     BR130     BR131     BR140     BR142
BR145     BR151     BR152     BR153     BR154     BR155
BR156     BR157     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     BR251     BR252     BR253     BR265
BR300     BR40.3    BR40.4    BR400     BR405     BR420
BR422     BR430     BR450     BR46.1    BR46.2    BR46.4
BR521     BR530     BR580     ET540     PW510     BR218


UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

BCX-CTR-CAT-GRP        Alpha 5                                   BR120   BR121
Element: Ctr Cat Grp                                             BR122   BR123
                                                                 BR140   BR151
                                                                 BR152   BR156
                                                                 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: 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

                         ACCTRCATGX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

BCXSET3   CONTRACT      KeyChange                                BR120   BR121
          CTR-CAT-GRP                                            BR122   BR123
          ACCT-CATEGORY                                          BR140   BR151
                                                                 BR152   BR156
                                                                 BR18.1  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