 |
Lawson Insight Technical Documentation |
|
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 AC30.2 AC30.3 AC32.1 AC472
AC473 AC490 AC65.1 AC65.2 BR65.1 BR65.2
BRCC.1 AC198 AC295 AC297 AC541 AC741
ACTA.1 GR741 BR430 AC400 AC410 AC493
AC66.1 AC93.4 AC93.5
UPDATED BY
AC121 AC123 AC127 AC190 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC20.7 AC22.1 AC300
AC310 AC45.1 ACDR.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CSL-FISCAL-YEAR Numeric 4 AC121 AC123
Fiscal Year Required key. This is the fiscal year AC127 AC190
for the consolidation. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.7
AC22.1 AC45.1
ACDR.1
CSL-BUDGET-NBR Numeric 3 AC121 AC123
Budget Number Required key. This is the budget number AC127 AC190
for the consolidation, as defined in the AC20.1 AC20.2
Activity Management system. AC20.3 AC20.4
AC20.5 AC20.7
AC22.1 AC45.1
ACDR.1
CSL-ACTIVITY-GRP Alpha 15 AC121 AC123
Activity Group This is the activity group for the AC127 AC190
consolidation. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.7
AC22.1 AC45.1
ACDR.1
CSL-ACTIVITY Alpha 15 AC121 AC123
Activity Required key. This is the activity for AC127 AC190
the consolidation. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.7
AC22.1 AC45.1
ACDR.1
CSL-ACCT-CATEGORY Alpha 5 AC121 AC123
Account Category Required key. This is the account AC127 AC190
category for the consolidation. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.7
AC22.1 AC45.1
ACDR.1
CSL-CURRENCY-CODE Alpha 5 AC121 AC123
Currency Code This field contains the base currency AC127 AC190
code for the activity group. It must AC20.1 AC20.2
have been defined already in AC00.1 AC20.3 AC20.4
(Activity Group). AC20.5 AC20.7
AC22.1 AC45.1
ACDR.1
CSL-LEVEL-DEPTH Numeric 1 AC121 AC123
Level Depth This field indicates the number of AC127 AC190
variable levels pertaining to this AC20.1 AC20.2
record. AC20.3 AC20.4
AC20.5 AC20.7
AC22.1 AC45.1
ACDR.1
CSL-VAR-LEVELS Alpha 30 AC121 AC123
Variable Levels Levels define an addressing system that AC127 AC190
organizes activities into a reporting AC20.1 AC20.2
hierarchy. Level names are defined for AC20.3 AC20.4
an activity group and should be able to AC20.5 AC20.7
be used across all activities in an AC22.1 AC45.1
activity group. Levels facilitate rollup ACDR.1
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
Parent Actv AC127 AC190
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.7
AC22.1 AC45.1
ACDR.1
CSL-BALANCE-AMOUNT Signed 17.2 AC121 AC123
Amount Balance This is the amount balance for the AC127 AC190
current year. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.7
AC22.1 AC310
AC45.1 ACDR.1
CSL-BALANCE-UNIT Signed 17.2 AC121 AC123
Unit Balance This is the unit balance for the AC127 AC190
current year. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.7
AC22.1 AC310
AC45.1 ACDR.1
CSL-BEGIN-BAL-AMT Signed 15.2 AC121 AC123
Amount Beginning This is the life-to-date amount up AC127 AC190
Balance until the start of the current year. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.7
AC22.1 AC310
AC45.1 ACDR.1
CSL-BEGIN-BAL-UNT Signed 15.2 AC121 AC123
Unit Beginning This is the life-to-date units up until AC127 AC190
Balance the start of the current year. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.7
AC22.1 AC310
AC45.1 ACDR.1
CSL-LTD-AMOUNT Derived
Life-to-Date Amount This is the sum of the Amount Balance
and the Amount Beginning Balance fields
for the fiscal year.
CSL-LTD-UNIT Derived
Life-to-Date Units This is the sum of the Unit Balance and
the Unit Beginning Balance fields for
the fiscal year.
CSL-ACCT-CAT-TYPE Derived
Acct Cat Type This is the account category type:
cost, revenue, or accrual.
ACCONSOL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CSLSET1 FISCAL-YEAR AC121 AC123
BUDGET-NBR AC127 AC130
ACTIVITY-GRP AC165 AC190
ACTIVITY AC20.1 AC20.2
CURRENCY-CODE AC20.3 AC20.4
ACCT-CATEGORY AC20.5 AC20.7
AC22.1 AC30.2
AC30.3 AC32.1
AC45.1 AC472
AC473 AC490
AC65.1 AC65.2
ACDR.1 BR65.1
BR65.2 BRCC.1
CSLSET2 ACTIVITY-GRP KeyChange
PARENT-ACTV
CURRENCY-CODE
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR*
ACTIVITY
CSLSET4 ACTIVITY-GRP AC121 AC123
ACTIVITY AC130 AC165
CURRENCY-CODE AC190 AC198
BUDGET-NBR AC20.1 AC20.2
ACCT-CATEGORY AC20.3 AC20.4
FISCAL-YEAR* AC20.5 AC295
AC297 AC30.2
AC30.3 AC32.1
AC473 AC490
AC541 AC65.1
AC65.2 AC741
ACTA.1 GR741
BR430 BR65.1
BR65.2 BRCC.1
CSLSET5 ACTIVITY-GRP AC121 AC123
ACTIVITY AC127 AC190
CURRENCY-CODE AC20.1 AC20.2
ACCT-CATEGORY AC20.3 AC20.4
BUDGET-NBR AC20.5 AC20.7
FISCAL-YEAR* AC22.1 AC300
AC310 AC400
AC410 AC45.1
AC493 AC66.1
AC93.4 AC93.5
ACDR.1
CSLSET6 FISCAL-YEAR
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 (AAXSET1)
Acactgrp ACACTGRP Required
CSL-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Not Required
CSL-ACTIVITY -> ACV-ACTIVITY
Aclevel ACLEVEL Required
When CSL-VAR-LEVELS != Spaces
CSL-ACTIVITY-GRP -> LVL-ACTIVITY-GRP
CSL-VAR-LEVELS -> LVL-VAR-LEVELS
ACCONSOL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accntract ACCNTRACT
CSL-ACTIVITY -> CNT-ACTIVITY
CNT-CONTRACT
Acconsolx ACCONSOLX
CSL-ACTIVITY-GRP -> CSX-ACTIVITY-GRP
CSL-ACTIVITY -> CSX-ACTIVITY
CSL-CURRENCY-CODE -> CSX-CURRENCY-CODE
CSL-BUDGET-NBR -> CSX-BUDGET-NBR
CSL-ACCT-CATEGORY -> CSX-ACCT-CATEGORY
CSL-FISCAL-YEAR -> CSX-FISCAL-YEAR
CSX-PERIOD
|