Lawson Insight Technical Documentation |
|
ACCONSOLX
ACCONSOLX FILE
Activity Consolidation Detail
This file maintains consolidation detail for the Activity Master and Activity
Budget files by period.
REFERENCED BY
AC130 AC165 AC295 AC297 AC32.1 AC37.1
AC400 AC410 AC490 AC65.1 AC65.2 ACTA.1
BR130 BR530 BR65.1 BR65.2 BRCC.1 AC473
ACDL.1 BR430
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
CSX-FISCAL-YEAR Numeric 4 AC121 AC123
Element: Last Closed YeThis is the current fiscal year. This AC127 AC190
field is updated by Period Closing AC20.1 AC20.2
(GL199). AC20.3 AC20.4
AC20.5 AC20.7
AC22.1 AC45.1
ACDR.1
CSX-BUDGET-NBR Numeric 3 AC121 AC123
Element: Budget Number This is the budget number for the AC127 AC190
consolidation detail. Budgets are AC20.1 AC20.2
defined in the AC20 (Budget) forms. AC20.3 AC20.4
AC20.5 AC20.7
AC22.1 AC45.1
ACDR.1
CSX-ACTIVITY-GRP Alpha 15 AC121 AC123
Element: Activity GroupThis is the activity group for the AC127 AC190
consolidation detail. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.7
AC22.1 AC45.1
ACDR.1
CSX-ACTIVITY Alpha 15 AC121 AC123
Element: Activity This is the activity for the AC127 AC190
consolidation detail. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.7
AC22.1 AC45.1
ACDR.1
CSX-ACCT-CATEGORY Alpha 5 AC121 AC123
Element: Account CategoThis is the account category for the AC127 AC190
consolidation detail. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.7
AC22.1 AC45.1
ACDR.1
CSX-CURRENCY-CODE Alpha 5 AC121 AC123
Element: Currency Code This field contains the company base AC127 AC190
currency code established in Company AC20.1 AC20.2
(GL10.1 ). AC20.3 AC20.4
AC20.5 AC20.7
AC22.1 AC45.1
ACDR.1
CSX-PERIOD Numeric 2 AC121 AC123
Element: Period This is the fiscal period. for the AC127 AC190
consolidation detail AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.7
AC22.1 AC45.1
ACDR.1
CSX-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
CSX-AMOUNT Currency 15.2 AC121 AC123
Element: Amount These are the amounts by period for the AC127 AC190
consolidation detail. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.7
AC22.1 AC310
AC45.1 ACDR.1
CSX-UNIT Signed 15.2 AC121 AC123
Element: Units These are the units by period for the AC127 AC190
consolidation detail. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.7
AC22.1 AC310
AC45.1 ACDR.1
CSX-ACCT-CAT-TYPE Derived
Element: Acct Cat Type This is the account category type:
cost, revenue, or accrual.
ACCONSOLX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CSXSET1 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
PERIOD AC22.1 AC295
AC297 AC32.1
AC37.1 AC400
AC410 AC45.1
AC490 AC65.1
AC65.2 ACDR.1
ACTA.1 BR130
BR530 BR65.1
BR65.2 BRCC.1
CSXSET2 ACTIVITY-GRP AC295 AC297
ACTIVITY AC300 AC310
CURRENCY-CODE AC410 AC473
BUDGET-NBR ACDL.1 ACDR.1
ACCT-CATEGORY BR430
FISCAL-YEAR
PERIOD
CSXSET3 FISCAL-YEAR AC400 AC473
PERIOD
ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
BUDGET-NBR
ACCT-CATEGORY
CSXSET4 ACTIVITY-GRP KeyChange
PARENT-ACTV
CURRENCY-CODE
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR
PERIOD
ACTIVITY
ACCONSOLX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
CSX-ACCT-CATEGORY -> AAX-ACCT-CATEGORY (AAXSET1)
Acacctcatx ACACCTCATX Not Required
CSX-ACTIVITY-GRP -> AXX-ACTIVITY-GRP
CSX-ACTIVITY -> AXX-ACTIVITY
CSX-ACCT-CATEGORY -> AXX-ACCT-CATEGORY
Acactgrp ACACTGRP Required
CSX-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Not Required
CSX-ACTIVITY -> ACV-ACTIVITY
Acconsol ACCONSOL Required
CSX-FISCAL-YEAR -> CSL-FISCAL-YEAR
CSX-BUDGET-NBR -> CSL-BUDGET-NBR
CSX-ACTIVITY-GRP -> CSL-ACTIVITY-GRP
CSX-ACTIVITY -> CSL-ACTIVITY
CSX-ACCT-CATEGORY -> CSL-CURRENCY-CODE
CSX-CURRENCY-CODE -> CSL-ACCT-CATEGORY
Aclevel ACLEVEL Required
When ACV-VAR-LEVELS != Spaces
CSX-ACTIVITY-GRP -> LVL-ACTIVITY-GRP
ACV-VAR-LEVELS -> LVL-VAR-LEVELS
ACCONSOLX FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acbuddtlx Chld ACBUDDTLX
Valid When CSX-CURRENCY-CODE = CSX-CURRENCY-CODE
CSX-ACTIVITY-GRP -> BDX-ACTIVITY-GRP
CSX-ACTIVITY -> BDX-PARENT-ACTV
CSX-BUDGET-NBR -> BDX-BUDGET-NBR
CSX-ACCT-CATEGORY -> BDX-ACCT-CATEGORY
CSX-FISCAL-YEAR -> BDX-FISCAL-YEAR
CSX-PERIOD -> BDX-PERIOD
BDX-ACTIVITY
Acconsolx Chld ACCONSOLX
Valid When ACV-VAR-LEVELS != Spaces
CSX-ACTIVITY-GRP -> CSX-ACTIVITY-GRP
CSX-ACTIVITY -> CSX-PARENT-ACTV
CSX-CURRENCY-CODE -> CSX-CURRENCY-CODE
CSX-BUDGET-NBR -> CSX-BUDGET-NBR
CSX-ACCT-CATEGORY -> CSX-ACCT-CATEGORY
CSX-FISCAL-YEAR -> CSX-FISCAL-YEAR
CSX-PERIOD -> CSX-PERIOD
CSX-ACTIVITY
Accuamtx Chld ACCUAMTX
CSX-ACTIVITY-GRP -> ACX-ACTIVITY-GRP
CSX-ACTIVITY -> ACX-PARENT-ACTV
CSX-CURRENCY-CODE -> ACX-CURRENCY-CODE
CSX-BUDGET-NBR -> ACX-BUDGET-NBR
CSX-ACCT-CATEGORY -> ACX-ACCT-CATEGORY
CSX-FISCAL-YEAR -> ACX-FISCAL-YEAR
CSX-PERIOD -> ACX-PERIOD
ACX-ACTIVITY
Acmasterx Chld ACMASTERX
Valid When CSX-CURRENCY-CODE = CSX-CURRENCY-CODE
CSX-ACTIVITY-GRP -> MSX-ACTIVITY-GRP
CSX-ACTIVITY -> MSX-PARENT-ACTV
CSX-ACCT-CATEGORY -> MSX-ACCT-CATEGORY
CSX-FISCAL-YEAR -> MSX-FISCAL-YEAR
CSX-PERIOD -> MSX-PERIOD
MSX-ACTIVITY
|