Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACACCTCAT


                             ACACCTCAT FILE

                      Activity Account Categories

This file contains information on account categories from AC05.1 (Account
Categories). In addition to the account category identifier, this file
includes description and the category type.  Use the Error suspense tab to
identify the error suspense account category identifier.

REFERENCED BY

AC01.1    AC06.1    AC06.2    AC07.1    AC08.1    AC08.3
AC08.5    AC08.7    AC10.1    AC10.3    AC105     AC108
AC112     AC113     AC120     AC121     AC123     AC127
AC128     AC130     AC135     AC145     AC16.2    AC16.3
AC16.4    AC16.7    AC16.8    AC16.9    AC160     AC165
AC169     AC19.1    AC190     AC191     AC197     AC198
AC20.1    AC20.2    AC20.3    AC20.4    AC20.5    AC20.6
AC20.7    AC200     AC203     AC205     AC206     AC207
AC208     AC21.1    AC21.2    AC21.3    AC21.4    AC210
AC213     AC218     AC22.1    AC220     AC225     AC227
AC240     AC246     AC256     AC261     AC265     AC27.1
AC29.2    AC290     AC292     AC295     AC298     AC30.1
AC30.2    AC30.3    AC30.4    AC310     AC32.1    AC34.1
AC346     AC35.1    AC36.1    AC37.1    AC40.1    AC40.4
AC400     AC401     AC41.1    AC41.4    AC410     AC412
AC42.1    AC42.3    AC420     AC421     AC440     AC45.1
AC45.4    AC46.1    AC46.2    AC460     AC471     AC472
AC473     AC480     AC490     AC493     AC494     AC50.1
AC500     AC527     AC54.1    AC540     AC55.1    AC56.1
AC560     AC58.1    AC58.2    AC580     AC583     AC60.1
AC60.2    AC61.1    AC62.1    AC65.1    AC65.2    AC69.1
AC71.1    AC90.1    AC90.2    AC90.4    AC90.6    AC90.8
AC91.1    AC91.2    AC92.1    AC92.2    AC92.4    AC92.6
AC93.1    AC93.2    AC93.3    AC93.4    AC93.5    AC94.1
AC94.2    AC94.4    AC94.6    AC95.1    AC95.2    AC95.4
AC95.6    AC96.1    AC96.4    AC98.1    ACAC.1    ACBC.1
ACDL.1    ACDM.2    ACDR.1    ACEX.1    ACVW.1    ATVW.1
SE90.1    AM117     AM118     AM125     AM223     AM224
AP125     AP126     AP170     AP178     AP193     AP211
AP237     AP25.1    AP25.2    AP26.1    AP27.1    AP30.2
AP30.4    AP520     AR15.2    AR15.4    AR21.2    AR21.1
AR21.3    AR237     AR239     AR250     AR257     AR27.2
AR29.1    AR29.2    AR296     AR30.5    AR30.1    AR32.1
AR33.2    AR38.5    AR39.3    AR39.4    AR42.1    AR42.2
AR42.7    AR43.1    AR502     AR503     AR55.1    AR560
AR575     AR800     AR91.1    ARLL.1    BN305     BR00.2
BR00.3    BR00.1    BR01.1    BR01.2    BR02.3    BR03.1
BR03.2    BR03.3    BR05.1    BR05.2    BR05.3    BR05.4
BR05.5    BR10.1    BR10.3    BR12.1    BR12.2    BR120
BR121     BR122     BR123     BR124     BR130     BR131
BR140     BR142     BR145     BR15.1    BR15.2    BR151
BR152     BR153     BR154     BR155     BR156     BR157
BR165     BR18.1    BR18.2    BR19.2    BR19.1    BR190
BR20.1    BR20.2    BR20.3    BR20.4    BR20.5    BR20.9
BR20.6    BR200     BR202     BR204     BR205     BR210
BR212     BR215     BR218     BR220     BR245     BR251
BR252     BR253     BR254     BR265     BR300     BR40.1
BR40.3    BR40.4    BR400     BR405     BR41.1    BR41.4
BR42.2    BR420     BR422     BR43.1    BR430     BR44.1
BR450     BR46.3    BR46.1    BR46.2    BR46.4    BR47.1
BR47.2    BR50.2    BR51.1    BR51.2    BR52.1    BR521
BR530     BR54.1    BR54.2    BR54.3    BR54.4    BR570
BR58.1    BR580     BR65.1    BR65.2    BR65.3    BR70.1
BR70.2    BR96.1    BRIP.1    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     ET540     ET700
GL100     GL122     GL146     GL165     GL170     GL197
GL40.1    GL40.2    GL40.3    GL40.7    GL40.8    GL44.1
GL45.1    GL50.4    GL70.1    GL70.2    GL70.3    GL70.5
GL70.6    GL75.1    HAXX.1    HR11.1    HR11.2    HR511
GL00.1    GL00.3    GL02.1    GL02.2    GL02.3    GL124
GL13.1    GL14.2    GL160     GL20.2    GL60.1    MX123
MX202     MX223     MX500     LP100     LP101     LP180
LP197     LP31.1    LP80.1    MA65.1    PA02.1    PA100
PA102     PA115     PA13.1    PA13.2    PA502     PA513
PA52.1    PA52.3    PA52.4    PA52.5    POIG.1    POII.1
HS34.1    HS36.1    PR04.1    PR05.1    PR05.7    PR110
PR113     PR120     PR13.1    PR13.5    PR13.6    PR13.8
PR134     PR20.4    PR30.1    PR55.1    PW110     PW510
SB15.1    SB515     SN02.1    SNAC.1    AC12.1    AC131
AC581     AC704     AM190     AP131     AP190     AP20.1
AP20.2    AP20.3    AP20.4    AP20.5    AP20.7    AP21.1
AP23.1    API1.1    API2.1    AR115     AR124     AR190
AR20.1    AR24.1    AR34.1    AR570     AR580     BL120
BL122     BL130     BL20.1    BL20.3    BL21.2    BL21.5
BL29.1    BL29.2    BL520     BL820     BL92.1    BN150
BN66.1    CB180     CB80.1    CB82.1    CXCP.1    ET175
ET530     ET542     ETI2.1    GL199     IFGT.1    LP130
MA180     MA41.1    MA41.2    MA41.4    MA41.7    MA43.1
MA43.2    MA43.3    MA43.7    MA530     MA531     MA60.2
MA60.3    MA60.5    MA61.1    MA66.2    MA66.3    MA67.2
MA67.3    MA68.2    MA68.3    MA68.5    MA70.1    MA75.1
MA80.1    MAI1.1    PA182     PD10.1    PD10.2    PD130
PD20.1    PD20.2    PD20.3    PO100     PO101     PO122
PO131     PO135     PO150     PO190     PO20.1    PO21.1
PO21.2    PO21.3    PO21.4    PO21.5    PO22.1    PO23.1
PO24.1    PO25.1    PO25.5    PO25.6    PO25.7    PO27.2
PO29.1    PO30.1    PO30.2    PO30.3    PO300     PO31.1
PO31.2    PO32.2    PO32.4    PO33.1    PO34.1    PO35.1
PO36.1    PO36.2    PO38.1    PO39.1    PO39.2    PO44.1
PO50.1    PO52.1    PO520     PO536     POCP.1    POD0.1
POI3.1    POID.1    POIF.1    POIJ.1    PR128     PR130
PR131     PR132     PR136     PR137     PR140     PR189
PR195     PR197     PR29.1    PR32.1    PR32.2    PR33.1
PR33.2    PR33.3    PR35.1    PR35.2    PR35.3    PR35.4
PR35.5    PR35.6    PR35.8    PR35.9    PR36.1    PR37.1
PR38.1    PR45.1    PR529     PR530     PR560     PR80.1
PR82.1    PR85.1    PR89.1    UK102     UK330     UK560
RQ10.1    RQ10.2    RQ12.1    RQ13.1    RQ13.2    RQ35.1
RQ500     RQD0.1    RQIF.1    TA147     WH130     WH132
WH190     WH20.2    WH20.7    WH222     WH30.1    WH30.2
WH30.3    WH30.4    WH31.1    WH31.2    WH31.3    WH31.4
WH32.1    WH32.2    WH32.3    WH32.4    WH33.1    WH33.2
WH33.3    WH33.4    WH33.5    WH33.6    WH33.8    WH33.9
WH34.1    WH34.2    WH34.3    WH34.4    WH40.1    WH40.2
WH520     WH830

UPDATED BY

AC05.1    AC558

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AAX-ACCT-CATEGORY      Alpha 5                                   AC05.1  AC558
Element: Account CategoRequired. Account categories are
                       groupings of costs, revenues, or
                       accruals used for reporting and
                       inquiries for activities in Project
                       Accounting. 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.

AAX-DESCRIPTION        Alpha 30  (Lower Case)                    AC05.1  AC197
Account Category       This is the account category              AC198   AC558
Description            description.

AAX-CATEGORY-TYPE      Alpha 1                                   AC05.1  AC558
Element: Category Type Required. This field defines the
                       account category type: revenue, cost,
                       accrual, or pass thru.
                       R = Revenue
                       A = Accrual
                       C = Cost
                       P = Pass Thru

AAX-TIME-EXP-FLAG      Alpha 1
Element: Time Expense FT = Time
                       E = Expense
                       B = Both

AAX-ES-ACCT-CAT-FL     Alpha 1                                   AC05.1
Error Suspense Acct    This is the error suspense account
Category               category flag. "Yes" identifies one
                       account category as the error suspense
                       account category.
                       Y = Yes
                       N = No

                         ACACCTCAT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AAXSET1   ACCT-CATEGORY                                          AC01.1  AC05.1
                                                                 AC05.2  AC05.3
                                                                 AC06.1  AC06.2
                                                                 AC07.1  AC08.1
                                                                 AC08.3  AC08.5
                                                                 AC08.7  AC10.1
                                                                 AC10.3  AC105
                                                                 AC108   AC112
                                                                 AC113   AC120
                                                                 AC121   AC123
                                                                 AC127   AC128
                                                                 AC130   AC135
                                                                 AC145   AC16.2
                                                                 AC16.3  AC16.4
                                                                 AC16.7  AC16.8
                                                                 ...

AAXSET2   ACCT-CATEGORY Subset                                   AC05.1  AC10.1
                        Where (ES-ACCT-CAT-FL = "Y" )            AC10.3  AC108
                                                                 AC112   AC113
                                                                 AC12.1  AC120
                                                                 AC121   AC123
                                                                 AC127   AC128
                                                                 AC130   AC131
                                                                 AC135   AC145
                                                                 AC160   AC165
                                                                 AC169   AC19.1
                                                                 AC190   AC191
                                                                 AC197   AC198
                                                                 AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC20.5  AC20.6
                                                                 ...

AAXSET4   CATEGORY-TYPE KeyChange                                AC05.1  AC05.3
          ACCT-CATEGORY                                          AC401   AC480
                                                                 AC95.1  AC95.2
                                                                 AC95.4  AC95.6
                                                                 BR130   BR530

                         ACACCTCAT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcatx     ACACCTCATX

                            AAX-ACCT-CATEGORY    -> AXX-ACCT-CATEGORY
                                                    AXX-ACTIVITY-GRP
                                                    AXX-ACTIVITY