|
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 ACTA.1 BR165 BR65.1 BR65.2
BR65.3 AC472 ACDL.1 BR12.2 BR130 BR430
BR530 AC420 AC493 AC93.4 AC93.5 SNAC.1
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 SB515
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
SB515
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 ACDR.1
SB515
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
SB515
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
SB515
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
SB515
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
SB515
CSL-LEVEL-DEPTH Numeric 1 AC121 AC123
Element: Level Depth This field indicates the number of AC127 AC20.1
variable levels pertaining to this AC20.2 AC20.3
record. AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
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 SB515
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
SB515
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 SB515
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 SB515
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 SB515
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 SB515
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 SB515
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 SB515
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 AC310
AC32.1 AC37.1
AC473 AC490
AC65.1 AC65.2
ACDR.1 ACTA.1
BR165 BR65.1
BR65.2 BR65.3
SB515
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
SB515
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 AC32.1
AC37.1 AC472
AC473 AC490
AC65.1 AC65.2
ACDL.1 ACDR.1
ACTA.1 BR12.2
BR130 BR165
BR430 BR530
BR65.1 BR65.2
...
CSLSET5 ACTIVITY-GRP AC300 AC310
ACTIVITY AC420 AC493
CURRENCY-CODE AC93.4 AC93.5
ACCT-CATEGORY
BUDGET-NBR
FISCAL-YEAR*
CSLSET6 FISCAL-YEAR SNAC.1
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
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
Accommit ACCOMMIT
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
Accommitx ACCOMMITX
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 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
Actrans ACTRANS
CSL-ACTIVITY -> ATN-ACTIVITY
CSL-ACCT-CATEGORY -> ATN-ACCT-CATEGORY
CSL-FISCAL-YEAR -> ATN-FISCAL-YEAR
ATN-PERIOD
ATN-OBJ-ID
|