ACCONSOLX FILE Activity Consolidation Detail This file maintains consolidation detail for the Activity Master and Activity Budget files by period. REFERENCED BY AC130 AC165 AC170 AC295 AC297 AC30.2 AC30.3 AC32.1 AC410 AC65.1 AC65.2 AC90.1 AC95.1 AC95.2 AC97.1 AC97.2 AC401 AC473 UPDATED BY AC120 AC121 AC123 AC127 AC190 AC20.1 AC20.2 AC20.3 AC20.4 AC20.6 AC22.1 AC300 AC310 AC580 AC980 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY CSX-FISCAL-YEAR Numeric 4 AC120 AC121 Fiscal Year This is the current fiscal year. This AC123 AC127 field is updated by GL199 (Period AC190 AC20.1 Closing). AC20.2 AC20.3 AC20.4 AC20.6 AC22.1 AC580 AC980 CSX-BUDGET-NBR Numeric 3 AC120 AC121 Budget Number This is the budget number for the AC123 AC127 consolidation detail. Budgets are AC190 AC20.1 defined in the AC20 (Budget) forms. AC20.2 AC20.3 AC20.4 AC20.6 AC22.1 AC580 AC980 CSX-ACTIVITY-GRP Alpha 15 AC120 AC121 Activity Group This is the activity group for the AC123 AC127 consolidation detail. AC190 AC20.1 AC20.2 AC20.3 AC20.4 AC20.6 AC22.1 AC580 AC980 CSX-ACTIVITY Alpha 15 AC120 AC121 Activity This is the activity for the AC123 AC127 consolidation detail. AC190 AC20.1 AC20.2 AC20.3 AC20.4 AC20.6 AC22.1 AC580 AC980 CSX-ACCT-CATEGORY Alpha 5 AC120 AC121 Account Category This is the account category for the AC123 AC127 consolidation detail. AC190 AC20.1 AC20.2 AC20.3 AC20.4 AC20.6 AC22.1 AC580 AC980 CSX-PERIOD Numeric 2 AC120 AC121 Period This is the fiscal period. for the AC123 AC127 consolidation detail AC190 AC20.1 AC20.2 AC20.3 AC20.4 AC20.6 AC22.1 AC580 AC980 CSX-AMOUNT Currency 15.2 AC120 AC121 Amount These are the amounts by period for the AC123 AC127 consolidation detail. AC190 AC20.1 AC20.2 AC20.3 AC20.4 AC20.6 AC22.1 AC310 AC580 AC980 CSX-UNIT Signed 15.2 AC120 AC121 Units These are the units by period for the AC123 AC127 consolidation detail. AC190 AC20.1 AC20.2 AC20.3 AC20.4 AC20.6 AC22.1 AC310 AC580 AC980 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 AC120 AC121 BUDGET-NBR AC123 AC127 ACTIVITY-GRP AC130 AC165 ACTIVITY AC170 AC190 ACCT-CATEGORY AC20.1 AC20.2 PERIOD AC20.3 AC20.4 AC20.6 AC22.1 AC295 AC297 AC30.2 AC30.3 AC32.1 AC410 AC580 AC65.1 AC65.2 AC90.1 AC95.1 AC95.2 AC97.1 AC97.2 AC980 CSXSET2 ACTIVITY-GRP AC120 AC295 ACTIVITY AC297 AC300 BUDGET-NBR AC310 AC401 ACCT-CATEGORY AC473 AC580 FISCAL-YEAR AC90.1 AC95.1 PERIOD AC95.2 AC97.1 AC97.2 CSXSET3 FISCAL-YEAR AC473 PERIOD ACTIVITY-GRP ACTIVITY ACCT-CATEGORY BUDGET-NBR 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 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-ACCT-CATEGORY |