Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACACCTCATX


                            ACACCTCATX FILE

                        Account Category Detail

This file includes detailed override information on account categories from
AC06.1 (Override Account Categories).  This form (AC06) and file are only
utilized if the parameters assigned to the category structure need to be
overridden.  The records can only be added for posting level activities. This
file allows override on account category status (to inactivate), Billing,
Revenue, T&M, Captialization, and markup percentages.

REFERENCED BY

AC108     AC112     AC113     AC12.1    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    AC20.7    AC200     AC203     AC206
AC207     AC210     AC213     AC218     AC22.1    AC220
AC225     AC240     AC246     AC261     AC265     AC290
AC295     AC298     AC30.4    AC346     AC40.1    AC40.4
AC400     AC401     AC41.1    AC41.4    AC410     AC412
AC42.1    AC420     AC421     AC440     AC45.1    AC45.4
AC46.1    AC460     AC471     AC472     AC473     AC480
AC490     AC493     AC494     AC50.1    AC500     AC527
AC54.1    AC540     AC56.1    AC580     AC581     AC583
AC61.1    AC69.1    AC704     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    ACDR.1
AP125     AP126     AP170     AP193     AP211     AP25.1
AP25.2    AP26.1    AP27.1    AP30.2    AP520     AR237
AR239     AR257     AR296     AR32.1    BR00.1    BR00.2
BR00.3    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    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.1
BR40.3    BR40.4    BR400     BR405     BR41.1    BR41.4
BR420     BR422     BR43.1    BR430     BR44.1    BR450
BR46.1    BR46.2    BR46.4    BR51.1    BR51.2    BR52.1
BR521     BR530     BR54.1    BR54.2    BR54.3    BR54.4
BR570     BR580     BR70.1    BR70.2    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
ET542     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    PW110     PW510     SB515
HAXX.1

UPDATED BY

AC06.1    AC06.2    AC105     AC110     AC120     AC300
AC310     AC560     AC10.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AXX-ACTIVITY-GRP       Alpha 15                                  AC06.1  AC06.2
Element: Activity GroupRequired. This is the activity group      AC105   AC110
                       for the account category.                 AC120   AC560

AXX-ACTIVITY           Alpha 15                                  AC06.1  AC06.2
Element: Activity      Identifies the posting level activity     AC105   AC110
                       for which override edits exist for        AC120   AC560
                       account category detail.

AXX-ACCT-CATEGORY      Alpha 5                                   AC06.1  AC06.2
Element: Account CategoAccount categories are groupings of       AC105
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Lawson Project
                       Accounting application. 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.

                       The error suspense account category is
                       automatically assigned to all
                       activities.

AXX-BILLABLE-FLAG      Alpha 1                                   AC06.1  AC06.2
Element: Billable Flag This flag indicates whether an account    AC105
                       category is billable.
                       Y = Billable
                       N = Non-billable

AXX-CAPITAL-FLAG       Alpha 1                                   AC06.1  AC06.2
Element: CapitalizationThis flag indicates whether an account    AC105
                       category is to be capitalized.
                       Y = Yes
                       N = No

AXX-MARK-UP-PCT        Signed 5.2                                AC06.1  AC06.2
Element: Mark-up PercenThis field indicates the percentage of    AC105
                       markup for billing. If an account
                       category is billable, a mark-up
                       percentage can be established. A rate
                       schedule is for labor transactions only.
                       Mark-up percentages will increase the
                       amount by the percent entered.

AXX-REVENUE-FLAG       Alpha 1                                   AC06.1  AC06.2
Element: Revenue Flag  This flag identifies whether an           AC105
                       activity/account category is eligible
                       for revenue recognition.
                       Y = Yes
                       N = No

AXX-TM-FLAG            Alpha 1                                   AC06.1  AC06.2
Element: Tm Flag       This flag indicates whether this          AC105
                       account category represents time (labor)
                       or materials for T&M processing.
                       M = Materials
                       T = Time

AXX-SUM-ACCT-CAT       Alpha 5                                   AC06.1  AC06.2
Summary Account        Identifies the summary account category   AC105
Category               the detail account category is assigned
                       to in the category structure (lowest
                       summary level account category in the
                       structure).

AXX-ACTIVE-STATUS      Alpha 1                                   AC06.1  AC06.2
Element: Active Status The account category status.              AC105
                       Valid values are "A" Active and "I"
                       Inactive.
                       A = Active
                       I = Inactive

                         ACACCTCATX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AXXSET1   ACTIVITY-GRP                                           AC06.1  AC06.2
          ACTIVITY                                               AC10.1  AC10.3
          ACCT-CATEGORY                                          AC105   AC108
                                                                 AC110   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
                                                                 ...

AXXSET2   ACTIVITY-GRP                                           AC310
          ACCT-CATEGORY
          ACTIVITY

AXXSET4   ACCT-CATEGORY
          ACTIVITY-GRP
          ACTIVITY

AXXSET6   ACTIVITY                                               AC10.1  HAXX.1
          ACTIVITY-GRP
          ACCT-CATEGORY

                         ACACCTCATX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Required

                            AXX-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY

Acactgrp       ACACTGRP     Required

                            AXX-ACTIVITY-GRP     -> AGP-ACTIVITY-GRP

Acactivity     ACACTIVITY   Not Required

                            AXX-ACTIVITY         -> ACV-ACTIVITY

Acamcode       ACAMCODE     Not Required

                            AXX-ACTIVITY         -> MCD-ACTIVITY
                            AXX-ACCT-CATEGORY    -> MCD-ACCT-CATEGORY

Acbudhdr       ACBUDHDR     Not Required

                            AXX-ACTIVITY-GRP     -> BDH-ACTIVITY-GRP
                            AXX-ACTIVITY         -> BDH-ACTIVITY
                            ACV-ACTIVE-BUD       -> BDH-BUDGET-NBR

Accatsum       ACCATSUM     Required

                            ACV-STRUCTURE        -> SRS-STRUCTURE
                            AXX-SUM-ACCT-CAT     -> SRS-SUM-ACCT-CAT

                         ACACCTCATX FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acbrdndtl      ACBRDNDTL

                            AXX-ACTIVITY-GRP     -> BRD-ACTIVITY-GRP
                            AXX-ACTIVITY         -> BRD-ACTIVITY
                            AXX-ACCT-CATEGORY    -> BRD-ACCT-CATEGORY
                                                    BRD-BURDEN-CD
                                                    BRD-POOL-NBR

Acbuddtl       ACBUDDTL

                            AXX-ACTIVITY-GRP     -> BDT-ACTIVITY-GRP
                            AXX-ACTIVITY         -> BDT-ACTIVITY
                            ACV-ACTIVE-BUD       -> BDT-BUDGET-NBR
                            AXX-ACCT-CATEGORY    -> BDT-ACCT-CATEGORY
                                                    BDT-FISCAL-YEAR

Accommit       ACCOMMIT

                            AXX-ACTIVITY-GRP     -> MIT-ACTIVITY-GRP
                            AXX-ACTIVITY         -> MIT-ACTIVITY
                            AXX-ACCT-CATEGORY    -> MIT-ACCT-CATEGORY
                                                    MIT-FISCAL-YEAR
                                                    MIT-PERIOD
                                                    MIT-SYSTEM
                                                    MIT-COMPANY
                                                    MIT-CURRENCY-CODE

Accommitx      ACCOMMITX

                            AXX-ACTIVITY-GRP     -> MIX-ACTIVITY-GRP
                            AXX-ACTIVITY         -> MIX-ACTIVITY
                            AXX-ACCT-CATEGORY    -> MIX-ACCT-CATEGORY
                                                    MIX-FISCAL-YEAR
                                                    MIX-PERIOD
                                                    MIX-SYSTEM
                                                    MIX-COMPANY
                                                    MIX-CURRENCY-CODE
                                                    MIX-ATN-OBJ-ID

Acglacct       ACGLACCT

                            AXX-ACTIVITY-GRP     -> AGA-ACTIVITY-GRP
                            AXX-ACTIVITY         -> AGA-ACTIVITY
                            AXX-ACCT-CATEGORY    -> AGA-ACCT-CATEGORY
                                                    AGA-SEQ-NUMBER

Acmaster       ACMASTER

                            AXX-ACTIVITY-GRP     -> MST-ACTIVITY-GRP
                            AXX-ACTIVITY         -> MST-ACTIVITY
                            AXX-ACCT-CATEGORY    -> MST-ACCT-CATEGORY
                                                    MST-FISCAL-YEAR

Actrans Commit ACTRANS

                            AXX-ACTIVITY-GRP     -> ATN-ACTIVITY-GRP
                            AXX-ACTIVITY         -> ATN-ACTIVITY
                            AXX-ACCT-CATEGORY    -> ATN-ACCT-CATEGORY
                                                    ATN-POSTING-DATE
                                                    ATN-OBJ-ID

Actrans Posted ACTRANS

                            AXX-ACTIVITY-GRP     -> ATN-ACTIVITY-GRP
                            AXX-ACTIVITY         -> ATN-ACTIVITY
                            AXX-ACCT-CATEGORY    -> ATN-ACCT-CATEGORY
                                                    ATN-POSTING-DATE
                                                    ATN-OBJ-ID

Actrans Releas ACTRANS

                            AXX-ACTIVITY-GRP     -> ATN-ACTIVITY-GRP
                            AXX-ACTIVITY         -> ATN-ACTIVITY
                            AXX-ACCT-CATEGORY    -> ATN-ACCT-CATEGORY
                                                    ATN-POSTING-DATE
                                                    ATN-OBJ-ID