Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCONSOL


                             ACCONSOL FILE

                         Activity Consolidation

This file maintains consolidation balances for the Activity Master and
Activity Budget files, as well as activity group total amounts. It includes
amounts and units beginning balances, amount and units current balances, and
life-to-date amount and units totals. Consolidation records are kept for
summary level activities if the Consolidate option is selected in AC00.1
(Activity Group). This file reports summary balances in activity group
currency.

REFERENCED BY

AC130     AC165     AC32.1    AC37.1    AC473     AC490
AC65.1    AC65.2    ACTA.1    BR165     BR65.1    BR65.2
BR65.3    AC472     ACDL.1    BR12.2    BR130     BR430
BR530     AC420     AC493     AC93.4    AC93.5    SNAC.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

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

CSL-BUDGET-NBR         Numeric 3                                 AC121   AC123
Element: Budget Number Required key. This is the budget number   AC127   AC20.1
                       for the consolidation, as defined in the  AC20.2  AC20.3
                       Activity Management system.               AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

CSL-ACTIVITY-GRP       Alpha 15                                  AC121   AC123
Element: Activity GroupThis is the activity group for the        AC127   AC20.1
                       consolidation.                            AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

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

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

CSL-CURRENCY-CODE      Alpha 5                                   AC121   AC123
Element: Currency Code This field contains the base currency     AC127   AC20.1
                       code for the activity group. It must      AC20.2  AC20.3
                       have been defined already in AC00.1       AC20.4  AC20.5
                       (Activity Group).                         AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

CSL-LEVEL-DEPTH        Numeric 1                                 AC121   AC123
Element: Level Depth   This field indicates the number of        AC127   AC20.1
                       variable levels pertaining to this        AC20.2  AC20.3
                       record.                                   AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

CSL-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.

CSL-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

CSL-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  AC310
                                                                 ACDR.1  SB515

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

CSL-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  AC310
                                                                 ACDR.1  SB515

CSL-BEGIN-BAL-UNT      Signed 15.2                               AC121   AC123
Unit 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  AC310
                                                                 ACDR.1  SB515

CSL-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.

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

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

CSL-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  AC310
                                                                 ACDR.1  SB515

CSL-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  AC310
                                                                 ACDR.1  SB515

                         ACCONSOL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CSLSET1   FISCAL-YEAR                                            AC121   AC123
          BUDGET-NBR                                             AC127   AC130
          ACTIVITY-GRP                                           AC165   AC20.1
          ACTIVITY                                               AC20.2  AC20.3
          CURRENCY-CODE                                          AC20.4  AC20.5
          ACCT-CATEGORY                                          AC20.6  AC20.7
                                                                 AC22.1  AC310
                                                                 AC32.1  AC37.1
                                                                 AC473   AC490
                                                                 AC65.1  AC65.2
                                                                 ACDR.1  ACTA.1
                                                                 BR165   BR65.1
                                                                 BR65.2  BR65.3
                                                                 SB515

CSLSET2   ACTIVITY-GRP                                           AC121   AC123
          ACTIVITY                                               AC127   AC20.1
          CURRENCY-CODE                                          AC20.2  AC20.3
          BUDGET-NBR                                             AC20.4  AC20.5
          ACCT-CATEGORY                                          AC20.6  AC20.7
          FISCAL-YEAR                                            AC22.1  ACDR.1
                                                                 SB515

CSLSET3   ACTIVITY-GRP  KeyChange
          PARENT-ACTV
          CURRENCY-CODE
          BUDGET-NBR
          ACCT-CATEGORY
          FISCAL-YEAR*
          ACTIVITY

CSLSET4   ACTIVITY-GRP  KeyChange                                AC121   AC123
          ACTIVITY                                               AC127   AC130
          CURRENCY-CODE                                          AC165   AC20.1
          BUDGET-NBR                                             AC20.2  AC20.3
          ACCT-CATEGORY                                          AC20.4  AC20.5
          FISCAL-YEAR*                                           AC20.6  AC20.7
                                                                 AC22.1  AC32.1
                                                                 AC37.1  AC472
                                                                 AC473   AC490
                                                                 AC65.1  AC65.2
                                                                 ACDL.1  ACDR.1
                                                                 ACTA.1  BR12.2
                                                                 BR130   BR165
                                                                 BR430   BR530
                                                                 BR65.1  BR65.2
                                                                 ...

CSLSET5   ACTIVITY-GRP                                           AC300   AC310
          ACTIVITY                                               AC420   AC493
          CURRENCY-CODE                                          AC93.4  AC93.5
          ACCT-CATEGORY
          BUDGET-NBR
          FISCAL-YEAR*

CSLSET6   FISCAL-YEAR                                            SNAC.1
          ACTIVITY-GRP
          ACTIVITY
          CURRENCY-CODE
          ACCT-CATEGORY
          BUDGET-NBR

                         ACCONSOL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Not Required

                            CSL-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY

Acactgrp       ACACTGRP     Required

                            CSL-ACTIVITY-GRP     -> AGP-ACTIVITY-GRP

Acactivity     ACACTIVITY   Not Required

                            CSL-ACTIVITY         -> ACV-ACTIVITY

                         ACCONSOL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acbuddtl Child ACBUDDTL
                            Valid When CSL-CURRENCY-CODE = CSL-CURRENCY-CODE

                            CSL-ACTIVITY-GRP     -> BDT-ACTIVITY-GRP
                            CSL-ACTIVITY         -> BDT-PARENT-ACTV
                            CSL-BUDGET-NBR       -> BDT-BUDGET-NBR
                            CSL-ACCT-CATEGORY    -> BDT-ACCT-CATEGORY
                            CSL-FISCAL-YEAR      -> BDT-FISCAL-YEAR
                                                    BDT-ACTIVITY

Accntract      ACCNTRACT

                            CSL-ACTIVITY         -> CNT-ACTIVITY
                                                    CNT-CONTRACT

Accommit       ACCOMMIT

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

Accommitx      ACCOMMITX

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

Acconsol Child ACCONSOL
                            Valid When CSL-ACTIVITY != Spaces

                            CSL-ACTIVITY-GRP     -> CSL-ACTIVITY-GRP
                            CSL-ACTIVITY         -> CSL-PARENT-ACTV
                            CSL-CURRENCY-CODE    -> CSL-CURRENCY-CODE
                            CSL-BUDGET-NBR       -> CSL-BUDGET-NBR
                            CSL-ACCT-CATEGORY    -> CSL-ACCT-CATEGORY
                            CSL-FISCAL-YEAR      -> CSL-FISCAL-YEAR
                                                    CSL-ACTIVITY

Accuamt Child  ACCUAMT

                            CSL-ACTIVITY-GRP     -> ACU-ACTIVITY-GRP
                            CSL-ACTIVITY         -> ACU-PARENT-ACTV
                            CSL-CURRENCY-CODE    -> ACU-CURRENCY-CODE
                            CSL-BUDGET-NBR       -> ACU-BUDGET-NBR
                            CSL-ACCT-CATEGORY    -> ACU-ACCT-CATEGORY
                            CSL-FISCAL-YEAR      -> ACU-FISCAL-YEAR
                                                    ACU-ACTIVITY

Acmaster Child ACMASTER
                            Valid When CSL-CURRENCY-CODE = CSL-CURRENCY-CODE

                            CSL-ACTIVITY-GRP     -> MST-ACTIVITY-GRP
                            CSL-ACTIVITY         -> MST-PARENT-ACTV
                            CSL-ACCT-CATEGORY    -> MST-ACCT-CATEGORY
                            CSL-FISCAL-YEAR      -> MST-FISCAL-YEAR
                                                    MST-ACTIVITY

Actrans        ACTRANS

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