Lawson Insight Technical Documentation |
|
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 AC295 AC32.1 AC37.1 AC420
AC473 AC490 AC65.1 AC65.2 ACTA.1 BR165
BR65.1 BR65.2 BRCC.1 AC472 ACDL.1 BR130
BR430 BR530 AC400 AC410 AC493 AC93.4
AC93.5
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
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
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 AC420
ACDR.1
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
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
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
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
CSL-LEVEL-DEPTH Numeric 1
Element: Level Depth This field indicates the number of
variable levels pertaining to this
record.
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
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
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
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
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
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
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
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
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 AC295
AC310 AC32.1
AC37.1 AC420
AC473 AC490
AC65.1 AC65.2
ACDR.1 ACTA.1
BR165 BR65.1
BR65.2 BRCC.1
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
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 AC295
AC32.1 AC37.1
AC472 AC473
AC490 AC65.1
AC65.2 ACDL.1
ACDR.1 ACTA.1
BR130 BR430
BR530 BR65.1
BR65.2 BRCC.1
CSLSET5 ACTIVITY-GRP AC300 AC310
ACTIVITY AC400 AC410
CURRENCY-CODE AC420 AC493
ACCT-CATEGORY AC93.4 AC93.5
BUDGET-NBR
FISCAL-YEAR*
CSLSET6 FISCAL-YEAR AC400
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
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
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
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
|