ACCONSOL – Activity Consolidation

System
Activity Management (AC)
Prefix
CSL
Primary key
FISCAL-YEAR, BUDGET-NBR, ACTIVITY-GRP, ACTIVITY, CURRENCY-CODE, ACCT-CATEGORY
Fields
18
Updated by
15 programs
Referenced by
307 programs

ACCONSOL is the Activity Consolidation table in Lawson Activity Management (prefix CSL). It is indexed by FISCAL-YEAR, BUDGET-NBR, ACTIVITY-GRP, ACTIVITY, CURRENCY-CODE, ACCT-CATEGORY (CSLSET1); alternate indexes: CSLSET2, CSLSET3, CSLSET4, CSLSET5 and CSLSET6. It is related 1:1 to ACACCTCAT, ACACTGRP and ACACTIVITY and 1:M to ACBUDDTL, ACCNTRACT, ACCOMMIT, ACCOMMITX, ACCONSOL, ACCUAMT, ACMASTER and ACTRANS. It is updated by AC10.1, AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4 and 7 more and referenced by AC130, AC165, AC297, AC32.1, AC37.1, AC40.1, AC40.4, AC41.1 and 299 more. The table has 18 fields, 6 indexes and 11 documented relations.

About ACCONSOL

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.

Fields (18)

Column = COBOL field name without the CSL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
CSL-FISCAL-YEAR PK
FISCAL_YEAR
Numeric 4Required key. This is the fiscal year for the consolidation.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
CSL-BUDGET-NBR PK
BUDGET_NBR
Numeric 3Required key. This is the budget number for the consolidation, as defined in the Activity Management system.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
CSL-ACTIVITY-GRP PK
ACTIVITY_GRP
Alpha 15This is the activity group for the consolidation.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
CSL-ACTIVITY PK
ACTIVITY
Alpha 15Required key. This is the activity for the consolidation.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
CSL-ACCT-CATEGORY PK
ACCT_CATEGORY
Alpha 5Required key. This is the account category for the consolidation.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
CSL-CURRENCY-CODE PK
CURRENCY_CODE
Alpha 5This field contains the base currency code for the activity group. It must have been defined already in AC00.1 (Activity Group).AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
CSL-LEVEL-DEPTH
LEVEL_DEPTH
Numeric 1This field indicates the number of variable levels pertaining to this record.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
CSL-VAR-LEVELS
VAR_LEVELS
Alpha 30Levels define an addressing system that organizes activities into a reporting hierarchy. Level names are defined for an activity group and should be able to be used across all activities in an activity group. Levels facilitate rollup or consolidation of budgets, costs, and revenues from activities at lower levels to macro activities at a higher level within the hierarchy.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
CSL-PARENT-ACTV
PARENT_ACTV
Alpha 15The parent activity field contains the activity name of the member parent.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
CSL-BALANCE-AMOUNT
BALANCE_AMOUNT
Signed 18.2This is the amount balance for the current year.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
CSL-BALANCE-UNIT
BALANCE_UNIT
Signed 17.2This is the unit balance for the current year.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
CSL-BEGIN-BAL-AMT
BEGIN_BAL_AMT
Signed 18.2This is the life-to-date amount up until the start of the current year.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
CSL-BEGIN-BAL-UNT
BEGIN_BAL_UNT
Signed 15.2This is the life-to-date units up until the start of the current year.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
CSL-LTD-AMOUNT
LTD_AMOUNT
DerivedThis is the sum of the Amount Balance and the Amount Beginning Balance fields for the fiscal year.
CSL-LTD-UNIT
LTD_UNIT
DerivedThis is the sum of the Unit Balance and the Unit Beginning Balance fields for the fiscal year.
CSL-ACCT-CAT-TYPE
ACCT_CAT_TYPE
DerivedThis is the account category type: cost, revenue, or accrual.
CSL-PERIOD-AMT
PERIOD_AMT
Signed 18.2 Occurs 13 Times ×13AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
CSL-PERIOD-UNIT
PERIOD_UNIT
Signed 15.2 Occurs 13 Times ×13AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more

Indexes (6)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CSLSET1FISCAL-YEAR, BUDGET-NBR, ACTIVITY-GRP, ACTIVITY, CURRENCY-CODE, ACCT-CATEGORYPrimaryAC121, AC123, AC127, AC130, AC165, AC20.1, AC20.2, AC20.3 +19 more
CSLSET2ACTIVITY-GRP, ACTIVITY, CURRENCY-CODE, BUDGET-NBR, ACCT-CATEGORY, FISCAL-YEARAC10.1, AC121, AC123, AC127, AC165, AC20.1, AC20.2, AC20.3 +22 more (list truncated in source)
CSLSET3ACTIVITY-GRP, PARENT-ACTV, CURRENCY-CODE, BUDGET-NBR, ACCT-CATEGORY, FISCAL-YEAR*, ACTIVITYKeyChange
CSLSET4ACTIVITY-GRP, ACTIVITY, CURRENCY-CODE, BUDGET-NBR, ACCT-CATEGORY, FISCAL-YEAR*KeyChangeAC121, AC123, AC127, AC130, AC165, AC20.1, AC20.2, AC20.3 +22 more (list truncated in source)
CSLSET5ACTIVITY-GRP, ACTIVITY, CURRENCY-CODE, ACCT-CATEGORY, BUDGET-NBR, FISCAL-YEAR*AC300, AC493, AC93.4, AC93.5
CSLSET6FISCAL-YEAR, ACTIVITY-GRP, ACTIVITY, CURRENCY-CODE, ACCT-CATEGORY, BUDGET-NBRSNAC.1

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATNot RequiredCSL-ACCT-CATEGORYAAX-ACCT-CATEGORY
AcactgrpACACTGRPRequiredCSL-ACTIVITY-GRPAGP-ACTIVITY-GRP
AcactivityACACTIVITYNot RequiredCSL-ACTIVITYACV-ACTIVITY

One to many (8) — child tables

RelationTableRulesConditionField map
Acbuddtl ChildACBUDDTLValid When CSL-CURRENCY-CODE = CSL-CURRENCY-CODECSL-ACTIVITY-GRPBDT-ACTIVITY-GRP, CSL-ACTIVITYBDT-PARENT-ACTV, CSL-BUDGET-NBRBDT-BUDGET-NBR, CSL-ACCT-CATEGORYBDT-ACCT-CATEGORY, CSL-FISCAL-YEARBDT-FISCAL-YEAR, BDT-ACTIVITY
AccntractACCNTRACTCSL-ACTIVITYCNT-ACTIVITY, CNT-CONTRACT
AccommitACCOMMITCSL-ACTIVITY-GRPMIT-ACTIVITY-GRP, CSL-ACTIVITYMIT-ACTIVITY, CSL-ACCT-CATEGORYMIT-ACCT-CATEGORY, CSL-FISCAL-YEARMIT-FISCAL-YEAR, MIT-PERIOD, MIT-SYSTEM, MIT-COMPANY, MIT-CURRENCY-CODE
AccommitxACCOMMITXCSL-ACTIVITY-GRPMIX-ACTIVITY-GRP, CSL-ACTIVITYMIX-ACTIVITY, CSL-ACCT-CATEGORYMIX-ACCT-CATEGORY, CSL-FISCAL-YEARMIX-FISCAL-YEAR, MIX-PERIOD, MIX-SYSTEM, MIX-COMPANY, MIX-CURRENCY-CODE, MIX-ATN-OBJ-ID
Acconsol ChildACCONSOLValid When CSL-ACTIVITY != SpacesCSL-ACTIVITY-GRPCSL-ACTIVITY-GRP, CSL-ACTIVITYCSL-PARENT-ACTV, CSL-CURRENCY-CODECSL-CURRENCY-CODE, CSL-BUDGET-NBRCSL-BUDGET-NBR, CSL-ACCT-CATEGORYCSL-ACCT-CATEGORY, CSL-FISCAL-YEARCSL-FISCAL-YEAR, CSL-ACTIVITY
Accuamt ChildACCUAMTCSL-ACTIVITY-GRPACU-ACTIVITY-GRP, CSL-ACTIVITYACU-PARENT-ACTV, CSL-CURRENCY-CODEACU-CURRENCY-CODE, CSL-BUDGET-NBRACU-BUDGET-NBR, CSL-ACCT-CATEGORYACU-ACCT-CATEGORY, CSL-FISCAL-YEARACU-FISCAL-YEAR, ACU-ACTIVITY
Acmaster ChildACMASTERValid When CSL-CURRENCY-CODE = CSL-CURRENCY-CODECSL-ACTIVITY-GRPMST-ACTIVITY-GRP, CSL-ACTIVITYMST-PARENT-ACTV, CSL-ACCT-CATEGORYMST-ACCT-CATEGORY, CSL-FISCAL-YEARMST-FISCAL-YEAR, MST-ACTIVITY
ActransACTRANSCSL-ACTIVITYATN-ACTIVITY, CSL-ACCT-CATEGORYATN-ACCT-CATEGORY, CSL-FISCAL-YEARATN-FISCAL-YEAR, ATN-PERIOD, ATN-OBJ-ID

Programs

Updated by (15)

Referenced by (307)