Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACMASTER


                             ACMASTER FILE

                            Activity Master

This file contains Activity Management actual amounts in base currency by
fiscal year. Information contained in the file is by activity group, activity,
and account category. It includes fiscal year, levels, current amount and unit
balances, as well as beginning balances and life-to-date balances.

Activity Management system master records are created by AC190 (Activity
Posting) and can be updated using AC55.1 (Activity Transaction Edit).

This file can be listed by running AC290 (Transaction Listing).

REFERENCED BY

AC10.1    AC420     AC472     AC493     AC96.1    AC96.4
AC98.2    ACDL.1    ACTA.1    SNAC.1    AC130     AC32.1
AC37.1    AC473     AC490     AC05.1    AC145     AC165
AC190     AC65.1    AC65.2    AC93.2    AC93.3    AC93.4
AC93.5    BR130     BR131     BR140     BR153     BR165
BR430     BR530     BR65.1    BR65.2    BR65.3    BRIP.1


UPDATED BY

AC121     AC123     AC127     AC20.1    AC20.2    AC20.3
AC20.4    AC20.5    AC20.6    AC20.7    AC22.1    AC300
AC310     ACDR.1    SB515

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MST-ACTIVITY-GRP       Alpha 15                                  AC121   AC123
Element: Activity GroupRequired key. This is the activity        AC127   AC20.1
                       group for the balances.                   AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

MST-ACTIVITY           Alpha 15                                  AC121   AC123
Element: Activity      Required key. This is the activity for    AC127   AC20.1
                       the balances.                             AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

MST-ACCT-CATEGORY      Alpha 5                                   AC121   AC123
Element: Account CategoRequired key. This is the account         AC127   AC20.1
                       category for the balances.                AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

MST-FISCAL-YEAR        Numeric 4                                 AC121   AC123
Element: Fiscal Year   Required key. This is the fiscal year.    AC127   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

MST-VAR-LEVELS         Alpha 30                                  AC121   AC123
Element: Variable LevelLevels define an addressing system that   AC127   AC20.1
                       organizes activities into a reporting     AC20.2  AC20.3
                       hierarchy.  Level names are defined for   AC20.4  AC20.5
                       an activity group and should be able to   AC20.6  AC20.7
                       be used across all activities in an       AC22.1  ACDR.1
                       activity group. Levels facilitate rollup  SB515
                       or consolidation of budgets, costs, and
                       revenues from activities at lower levels
                       to macro activities at a higher level
                       within the hierarchy.

MST-PARENT-ACTV        Alpha 15                                  AC121   AC123
Element: Parent Actv   The parent activity field contains the    AC127   AC20.1
                       activity name of the member parent.       AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

MST-BASE-ND            Numeric 1                                 AC121   AC123
Base Number of         This is the number of decimal positions   AC127   AC20.1
Decimals               defined  for the activity group base      AC20.2  AC20.3
                       currency.                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

MST-BEGIN-BAL-AMT      Signed 18.2                               AC121   AC123
Amount Beginning       This is the life-to-date amount up        AC127   AC20.1
Balance                until the start of the current year.      AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

MST-BEGIN-BAL-UNT      Signed 15.2                               AC121   AC123
Units Beginning        This is the life-to-date units up until   AC127   AC20.1
Balance                the start of the current year.            AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

MST-BALANCE-AMOUNT     Signed 18.2                               AC121   AC123
Element: Amount BalanceThis is the amount balance for the        AC127   AC20.1
                       current year.                             AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

MST-BALANCE-UNIT       Signed 17.2                               AC121   AC123
Element: Units Balance This is the units balance for the         AC127   AC20.1
                       current year.                             AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

MST-LTD-AMOUNT         Derived
Element: Life-to-Date AThis is the sum of the Amount Balance
                       and the Amount Beginning Balance fields
                       for the fiscal year.

MST-LTD-UNIT           Derived
Element: Life-to-Date UThis is the sum of the Units Balance
                       and the Units Beginning Balance fields
                       for the fiscal year.

MST-MAINT-DATE         Numeric 8  (yyyymmdd)                     AC121   AC123
Element: Maint Date    The date last changed.                    AC127   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

MST-MAINT-TIME         Numeric 6  (hhmmss)                       AC121   AC123
Element: Sys Time                                                AC127   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

MST-ACCT-CAT-TYPE      Derived
Element: Acct Cat Type This is the account category type:
                       cost, revenue, or accrual.

MST-PERIOD-AMT         Signed 18.2 Occurs 13 Times               AC121   AC123
Element: Intl Amt                                                AC127   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

MST-PERIOD-UNIT        Signed 15.2 Occurs 13 Times               AC121   AC123
Element: Unit                                                    AC127   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

                         ACMASTER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MSTSET1   ACTIVITY-GRP                                           AC10.1  AC121
          ACTIVITY                                               AC123   AC127
          ACCT-CATEGORY                                          AC20.1  AC20.2
          FISCAL-YEAR                                            AC20.3  AC20.4
                                                                 AC20.5  AC20.6
                                                                 AC20.7  AC22.1
                                                                 AC300   AC310
                                                                 AC420   AC472
                                                                 AC493   AC96.1
                                                                 AC96.4  AC98.2
                                                                 ACDL.1  ACDR.1
                                                                 ACTA.1  SB515
                                                                 SNAC.1

MSTSET2   ACTIVITY-GRP                                           AC123
          ACTIVITY
          FISCAL-YEAR
          ACCT-CATEGORY

MSTSET3   ACTIVITY-GRP                                           AC121   AC123
          FISCAL-YEAR                                            AC130   AC20.1
          ACTIVITY                                               AC20.2  AC20.3
          ACCT-CATEGORY                                          AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC473   AC490

MSTSET4   ACTIVITY-GRP                                           AC05.1  AC121
          ACTIVITY                                               AC123   AC127
          ACCT-CATEGORY                                          AC130   AC145
          FISCAL-YEAR*                                           AC165   AC190
                                                                 AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC20.5  AC20.6
                                                                 AC20.7  AC22.1
                                                                 AC32.1  AC37.1
                                                                 AC473   AC490
                                                                 AC65.1  AC65.2
                                                                 AC93.2  AC93.3
                                                                 AC93.4  AC93.5
                                                                 AC96.1  AC96.4
                                                                 AC98.2  ACDR.1
                                                                 ...

MSTSET5   ACTIVITY-GRP  KeyChange
          PARENT-ACTV
          ACCT-CATEGORY
          FISCAL-YEAR
          ACTIVITY

                         ACMASTER FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Required

                            MST-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY  (AAXSET1)

Acacctcatx     ACACCTCATX   Not Required

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

Acactgrp       ACACTGRP     Required

                            MST-ACTIVITY-GRP     -> AGP-ACTIVITY-GRP

Acactivity     ACACTIVITY   Required

                            MST-ACTIVITY         -> ACV-ACTIVITY

                         ACMASTER FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accommit       ACCOMMIT

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

Accommitx      ACCOMMITX

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

Actrans        ACTRANS

                            MST-ACTIVITY         -> ATN-ACTIVITY
                            MST-ACCT-CATEGORY    -> ATN-ACCT-CATEGORY
                            MST-FISCAL-YEAR      -> ATN-FISCAL-YEAR
                                                    ATN-PERIOD
                                                    ATN-OBJ-ID