ACMASTERX FILE

                         Activity Master Detail

This file contains actual amounts by fiscal year and period in the Activity
Management system. Information contained in the file includes activity group,
activity, account category, fiscal year, period, and amount and unit balances
for the period.

Activity Management system master records are created by AC190 (Activity
Posting) and can be updated using AC55.1 (Activity Transaction Edit).

This file can be listed by running AC290 (Transaction Listing).

REFERENCED BY

AC121     AC123     AC127     AC130     AC165     AC170
AC20.1    AC20.2    AC20.3    AC20.4    AC22.1    AC295
AC297     AC30.2    AC30.3    AC32.1    AC400     AC401
AC410     AC420     AC473     AC480     AC65.1    AC65.2
AC90.1    AC90.2    AC95.1    AC95.2    AC96.1    AC97.1
AC97.2    ACDL.1    ACAC.1

UPDATED BY

AC120     AC190     AC300     AC310     AC580     AC730
AC980

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MSX-ACTIVITY-GRP     Alpha 15                                    AC120   AC190
Activity Group       Required key. This is the activity          AC580   AC730
                     group for the actual amounts.               AC980

MSX-ACTIVITY         Alpha 15                                    AC120   AC190
Activity             Required key. This is the activity for      AC580   AC730
                     the actual amounts.                         AC980

MSX-ACCT-CATEGORY    Alpha 5                                     AC120   AC190
Account Category     Required key. This is the account           AC580   AC730
                     category for the actual amounts.            AC980

MSX-FISCAL-YEAR      Numeric 4                                   AC120   AC190
Fiscal Year          Required key. This is the fiscal year       AC580   AC730
                     .                                           AC980

MSX-PERIOD           Numeric 2                                   AC120   AC190
Period               Required key. This is the fiscal            AC580   AC730
                     period.                                     AC980

MSX-AMOUNT           Currency 15.2                               AC120   AC190
Amount               This is the amount for this fiscal          AC580   AC730
                     period.                                     AC980

MSX-UNIT             Signed 15.2                                 AC120   AC190
Unit                 This is the number of units for this        AC580   AC730
                     fiscal period.                              AC980

MSX-ACCT-CAT-TYPE    Derived
Acct Cat Type        This is the account category type:
                     cost, revenue, or accrual.

                         ACMASTERX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MSXSET1   ACTIVITY-GRP                                           AC120   AC121
          ACTIVITY                                               AC123   AC127
          ACCT-CATEGORY                                          AC130   AC165
          FISCAL-YEAR                                            AC170   AC190
          PERIOD                                                 AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC22.1  AC295
                                                                 AC297   AC30.2
                                                                 AC30.3  AC300
                                                                 AC310   AC32.1
                                                                 AC400   AC401
                                                                 AC410   AC420
                                                                 AC473   AC480
                                                                 AC580   AC65.1
                                                                 AC65.2  AC730
                                                                 ...

MSXSET2   ACTIVITY-GRP                                           AC400   ACAC.1
          ACTIVITY
          FISCAL-YEAR
          PERIOD
          ACCT-CATEGORY

MSXSET3   ACTIVITY-GRP                                           AC473   ACAC.1
          FISCAL-YEAR
          PERIOD
          ACTIVITY
          ACCT-CATEGORY

                         ACMASTERX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Required

                            MSX-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY

Acactgrp       ACACTGRP     Required

                            MSX-ACTIVITY-GRP     -> AGP-ACTIVITY-GRP

Acactivity     ACACTIVITY   Required

                            MSX-ACTIVITY         -> ACV-ACTIVITY

Acmaster       ACMASTER     Required

                            MSX-ACTIVITY-GRP     -> MST-ACTIVITY-GRP
                            MSX-ACTIVITY         -> MST-ACTIVITY
                            MSX-ACCT-CATEGORY    -> MST-ACCT-CATEGORY
                            MSX-FISCAL-YEAR      -> MST-FISCAL-YEAR