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     AC130     AC131     AC135     AC145     AC160
AC165     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     AC220     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
AC46.1    AC460     AC471     AC472     AC473     AC480
AC490     AC493     AC494     AC50.1    AC500     AC54.1
AC540     AC580     AC581     AC583     AC60.1    AC61.1
ACAC.1    ACDR.1    AP125     AP126     AP211     AP25.1
AP25.2    AP26.1    AP27.1    AP30.2    AP520     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
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.1    BR40.3    BR40.4    BR400     BR405
BR41.1    BR41.4    BR42.2    BR420     BR43.1    BR430
BR44.1    BR450     BR46.1    BR46.2    BR46.4    BR521
BR530     BR580     CB10.1    CB15.1    CB15.2    CB191
CB20.1    CB30.1    CB500     EE135     EE20.3    EE35.1
EE35.2    EE520     GL146     GL165     GL170     GL197
GL199     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    HAXX.1

UPDATED BY

AC06.1    AC06.2    AC105     AC110     AC120     AC300
AC310     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

AXX-ACTIVITY           Alpha 15                                  AC06.1  AC06.2
Element: Activity      Identifies the posting level activity     AC105   AC110
                       for which override edits exist for        AC120
                       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 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.

                       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 account  AC105
                       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
                                                                 AC130   AC131
                                                                 AC135   AC145
                                                                 AC160   AC165
                                                                 AC190   AC191
                                                                 AC197   AC198
                                                                 AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC20.5  AC20.6
                                                                 ...

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