 |
Lawson Insight Technical Documentation |
|
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 AC30.2 AC30.3
AC32.1 AC400 AC410 AC490 AC65.1 AC65.2
ACTA.1 BR65.1 BR65.2 BRCC.1 AC473 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
Fiscal Year This 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
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
Activity Group This 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
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
Account Category This 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
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
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
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
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
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
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 AC30.2
AC30.3 AC32.1
AC400 AC410
AC45.1 AC490
AC65.1 AC65.2
ACDR.1 ACTA.1
BR65.1 BR65.2
BRCC.1
CSXSET2 ACTIVITY-GRP AC295 AC297
ACTIVITY AC300 AC310
CURRENCY-CODE AC410 AC473
BUDGET-NBR ACDR.1 BR430
ACCT-CATEGORY
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 CSX-VAR-LEVELS != Spaces
CSX-ACTIVITY-GRP -> LVL-ACTIVITY-GRP
ACV-VAR-LEVELS -> LVL-VAR-LEVELS
|