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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET3
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 ×13—AC121, 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 ×13—AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more

Indexes (6)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CSLSET1
  1. FISCAL-YEAR
  2. BUDGET-NBR
  3. ACTIVITY-GRP
  4. ACTIVITY
  5. CURRENCY-CODE
  6. ACCT-CATEGORY
PrimaryAC121, AC123, AC127, AC130, AC165, AC20.1, AC20.2, AC20.3 +19 more
CSLSET2
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. CURRENCY-CODE
  4. BUDGET-NBR
  5. ACCT-CATEGORY
  6. FISCAL-YEAR
AC10.1, AC121, AC123, AC127, AC165, AC20.1, AC20.2, AC20.3 +22 more (list truncated in source)
CSLSET3
  1. ACTIVITY-GRP
  2. PARENT-ACTV
  3. CURRENCY-CODE
  4. BUDGET-NBR
  5. ACCT-CATEGORY
  6. FISCAL-YEAR ↓
  7. ACTIVITY
KeyChange—
CSLSET4
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. CURRENCY-CODE
  4. BUDGET-NBR
  5. ACCT-CATEGORY
  6. FISCAL-YEAR ↓
KeyChangeAC121, AC123, AC127, AC130, AC165, AC20.1, AC20.2, AC20.3 +22 more (list truncated in source)
CSLSET5
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. CURRENCY-CODE
  4. ACCT-CATEGORY
  5. BUDGET-NBR
  6. FISCAL-YEAR ↓
AC300, AC493, AC93.4, AC93.5
CSLSET6
  1. FISCAL-YEAR
  2. ACTIVITY-GRP
  3. ACTIVITY
  4. CURRENCY-CODE
  5. ACCT-CATEGORY
  6. BUDGET-NBR
SNAC.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACCTCATACACTGRPACACTIVITYACBUDDTLACCNTRACTACCOMMITACCOMMITXACCONSOLACCUAMTACMASTERACTRANSACCONSOL

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATNot Required
CSL-ACCT-CATEGORY→AAX-ACCT-CATEGORY
AcactgrpACACTGRPRequired
CSL-ACTIVITY-GRP→AGP-ACTIVITY-GRP
AcactivityACACTIVITYNot Required
CSL-ACTIVITY→ACV-ACTIVITY

One to many (8) — child tables

RelationTableRulesConditionField map
Acbuddtl ChildACBUDDTLValid 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
AccntractACCNTRACT
CSL-ACTIVITY→CNT-ACTIVITY
—→CNT-CONTRACT
AccommitACCOMMIT
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
AccommitxACCOMMITX
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 ChildACCONSOLValid 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 ChildACCUAMT
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 ChildACMASTERValid 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
ActransACTRANS
CSL-ACTIVITY→ATN-ACTIVITY
CSL-ACCT-CATEGORY→ATN-ACCT-CATEGORY
CSL-FISCAL-YEAR→ATN-FISCAL-YEAR
—→ATN-PERIOD
—→ATN-OBJ-ID

Programs

Updated by (15)

Referenced by (307)