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 AC32.1 AC37.1 AC473 AC490
AC65.1 AC65.2 BR165 BR65.1 BR65.2 BRCC.1
AC198 AC295 AC297 AC472 AC541 ACDL.1
ACTA.1 BR130 BR430 BR530 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
Element: 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
Element: 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
Element: Activity GroupThis 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
Element: 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
Element: Account CategoRequired 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
Element: 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
Element: 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
Element: Variable LevelLevels 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
Element: 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
Element: Amount BalanceThis 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
Element: 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
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.
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 AC32.1
AC37.1 AC45.1
AC473 AC490
AC65.1 AC65.2
ACDR.1 BR165
BR65.1 BR65.2
BRCC.1
CSLSET2 ACTIVITY-GRP KeyChange ACDR.1
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 AC32.1
AC37.1 AC472
AC473 AC490
AC541 AC65.1
AC65.2 ACDL.1
ACTA.1 BR130
BR430 BR530
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
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
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
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
|