|
|
ACMASTER FILE
Activity Master
This file contains Activity Management actual amounts in base currency by
fiscal year. Information contained in the file is by activity group, activity,
and account category. It includes fiscal year, levels, current amount and unit
balances, as well as beginning balances and life-to-date balances.
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
AC10.1 AC420 AC96.1 ACDL.1 AC123 ACAC.1
AC121 AC127 AC130 AC20.1 AC20.2 AC20.3
AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 AC400
AC05.1 AC165 AC170 AC295 AC297 AC410
AC473 AC480 AC65.1 AC65.2 AC90.1 AC90.2
AC95.1 AC95.2 AC97.1 AC97.2
UPDATED BY
AC120 AC190 AC300 AC310 AC580 AC730
AC980
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MST-ACTIVITY-GRP Alpha 15 AC120 AC190
Activity Group Required key. This is the activity AC580 AC730
group for the balances. AC980
MST-ACTIVITY Alpha 15 AC120 AC190
Activity Required key. This is the activity for AC580 AC730
the balances. AC980
MST-ACCT-CATEGORY Alpha 5 AC120 AC190
Account Category Required key. This is the account AC580 AC730
category for the balances. AC980
MST-FISCAL-YEAR Numeric 4 AC120 AC190
Fiscal Year Required key. This is the fiscal year. AC580 AC730
AC980
MST-VAR-LEVELS Alpha 30 AC120 AC190
Variable Levels Levels define an addressing system that AC580 AC730
organizes activities into a reporting AC980
hierarchy. Level names are defined for
an activity group and should be able to
be used across all activities in an
activity group. Levels facilitate rollup
or consolidation of budgets, costs, and
revenues from activities at lower levels
to macro activities at a higher level
within the hierarchy.
MST-BASE-ND Numeric 1 AC120 AC190
Base Number of This is the number of decimal positions AC580 AC730
Decimals defined for the activity group base AC980
currency.
MST-BEGIN-BAL-AMT Signed 15.2 AC120 AC190
Amount Beginning This is the life-to-date amount up AC580 AC730
Balance until the start of the current year. AC980
MST-BEGIN-BAL-UNT Signed 15.2 AC120 AC190
Units Beginning This is the life-to-date units up until AC580 AC730
Balance the start of the current year. AC980
MST-BALANCE-AMOUNT Signed 17.2 AC120 AC190
Amount Balance This is the amount balance for the AC580 AC730
current year. AC980
MST-BALANCE-UNIT Signed 17.2 AC120 AC190
Units Balance This is the units balance for the AC580 AC730
current year. AC980
MST-LTD-AMOUNT Derived
Life-to-Date Amount This is the sum of the Amount Balance
and the Amount Beginning Balance fields
for the fiscal year.
MST-LTD-UNIT Derived
Life-to-Date Units This is the sum of the Units Balance
and the Units Beginning Balance fields
for the fiscal year.
MST-MAINT-DATE Numeric 8 (yyyymmdd) AC120 AC190
Maintenance Date The date last changed. AC580 AC730
MST-MAINT-TIME Numeric 6 (hhmmss) AC120 AC190
Maintenance Time The time last changed. AC580 AC730
MST-ACCT-CAT-TYPE Derived
Acct Cat Type This is the account category type:
cost, revenue, or accrual.
ACMASTER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MSTSET1 ACTIVITY-GRP AC10.1 AC120
ACTIVITY AC190 AC300
ACCT-CATEGORY AC310 AC420
FISCAL-YEAR AC580 AC730
AC96.1 AC980
ACDL.1
MSTSET2 ACTIVITY-GRP AC123 ACAC.1
ACTIVITY
FISCAL-YEAR
ACCT-CATEGORY
MSTSET3 ACTIVITY-GRP AC121 AC123
FISCAL-YEAR AC127 AC130
ACTIVITY AC20.1 AC20.2
ACCT-CATEGORY AC20.3 AC20.4
AC22.1 AC30.2
AC30.3 AC32.1
AC400 ACAC.1
MSTSET4 ACTIVITY-GRP AC05.1 AC120
ACTIVITY AC121 AC123
ACCT-CATEGORY AC127 AC130
FISCAL-YEAR* AC165 AC170
AC190 AC20.1
AC20.2 AC20.3
AC20.4 AC22.1
AC295 AC297
AC30.2 AC30.3
AC32.1 AC400
AC410 AC473
AC480 AC580
AC65.1 AC65.2
AC90.1 AC90.2
AC95.1 AC95.2
...
ACMASTER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
MST-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Acacctcatx ACACCTCATX Not Required
MST-ACTIVITY-GRP -> AXX-ACTIVITY-GRP
MST-ACTIVITY -> AXX-ACTIVITY
MST-ACCT-CATEGORY -> AXX-ACCT-CATEGORY
Acactgrp ACACTGRP Required
MST-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Required
MST-ACTIVITY -> ACV-ACTIVITY
Aclevel ACLEVEL Required
MST-ACTIVITY-GRP -> LVL-ACTIVITY-GRP
MST-VAR-LEVELS -> LVL-VAR-LEVELS
ACMASTER FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acmasterx ACMASTERX
MST-ACTIVITY-GRP -> MSX-ACTIVITY-GRP
MST-ACTIVITY -> MSX-ACTIVITY
MST-ACCT-CATEGORY -> MSX-ACCT-CATEGORY
MST-FISCAL-YEAR -> MSX-FISCAL-YEAR
MSX-PERIOD
|