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 AC20.1
AC20.2 AC20.3 AC20.4 AC20.5 AC22.1 AC295
AC297 AC32.1 AC400 AC410 AC420 AC473
AC490 AC65.1 AC65.2 AC96.1 AC98.2 ACDL.1
ACTA.1 BR130 BR131 BR20.1 BR20.2 BR20.3
BR20.4 BR20.5 BR430 BR65.1 BR65.2 BRCC.1
BRIP.1 ACAC.1
UPDATED BY
AC190 AC300 AC310 AC45.1 ACDR.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MSX-ACTIVITY-GRP Alpha 15 AC190 ACDR.1
Activity Group Required key. This is the activity
group for the actual amounts.
MSX-ACTIVITY Alpha 15 AC190 ACDR.1
Activity Required key. This is the activity for
the actual amounts.
MSX-ACCT-CATEGORY Alpha 5 AC190 ACDR.1
Account Category Required key. This is the account
category for the actual amounts.
MSX-FISCAL-YEAR Numeric 4 AC190 ACDR.1
Fiscal Year Required key. This is the fiscal year
.
MSX-PERIOD Numeric 2 AC190 ACDR.1
Period Required key. This is the fiscal
period.
MSX-PARENT-ACTV Alpha 15 AC190 ACDR.1
Parent Actv
MSX-AMOUNT Currency 15.2 AC190 ACDR.1
Amount This is the amount for this fiscal
period.
MSX-UNIT Signed 15.2 AC190 ACDR.1
Unit This is the number of units for this
fiscal period.
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 AC121 AC123
ACTIVITY AC127 AC130
ACCT-CATEGORY AC165 AC190
FISCAL-YEAR AC20.1 AC20.2
PERIOD AC20.3 AC20.4
AC20.5 AC22.1
AC295 AC297
AC300 AC310
AC32.1 AC400
AC410 AC420
AC45.1 AC473
AC490 AC65.1
AC65.2 AC96.1
AC98.2 ACDL.1
ACDR.1 ACTA.1
...
MSXSET2 ACTIVITY-GRP ACAC.1
ACTIVITY
FISCAL-YEAR
PERIOD
ACCT-CATEGORY
MSXSET3 ACTIVITY-GRP AC400 AC473
FISCAL-YEAR ACAC.1
PERIOD
ACTIVITY
ACCT-CATEGORY
MSXSET4 ACTIVITY-GRP KeyChange
PARENT-ACTV
ACCT-CATEGORY
FISCAL-YEAR
PERIOD
ACTIVITY
ACMASTERX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
MSX-ACCT-CATEGORY -> AAX-ACCT-CATEGORY (AAXSET1)
Acactgrp ACACTGRP Required
MSX-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Required
MSX-ACTIVITY -> ACV-ACTIVITY
Aclevel ACLEVEL Required
MSX-ACTIVITY-GRP -> LVL-ACTIVITY-GRP
MST-VAR-LEVELS -> LVL-VAR-LEVELS
Acmaster ACMASTER Not Required
MSX-ACTIVITY-GRP -> MST-ACTIVITY-GRP
MSX-ACTIVITY -> MST-ACTIVITY
MSX-ACCT-CATEGORY -> MST-ACCT-CATEGORY
MSX-FISCAL-YEAR -> MST-FISCAL-YEAR
ACMASTERX FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Actrans ACTRANS
MSX-ACTIVITY-GRP -> ATN-ACTIVITY-GRP
ACV-VAR-LEVELS -> ATN-VAR-LEVELS
9 -> ATN-STATUS
MSX-ACCT-CATEGORY -> ATN-ACCT-CATEGORY
MSX-FISCAL-YEAR -> ATN-FISCAL-YEAR
MSX-PERIOD -> ATN-PERIOD
ATN-OBJ-ID
|
