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 AC410 AC420 AC472 AC493 AC720
AC96.1 AC98.2 ACDL.1 AC123 ACAC.1 AC121
AC130 AC20.1 AC20.2 AC20.3 AC20.4 AC20.5
AC30.2 AC30.3 AC32.1 AC473 AC490 AC05.1
AC165 AC295 AC297 AC400 AC65.1 AC65.2
AC93.2 AC93.3 AC93.4 AC93.5 ACTA.1 BR430
BR65.1 BR65.2 BRCC.1 BRIP.1
UPDATED BY
AC190 AC300 AC310 AC45.1 ACDR.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MST-ACTIVITY-GRP Alpha 15 AC190 ACDR.1
Activity Group Required key. This is the activity
group for the balances.
MST-ACTIVITY Alpha 15 AC190 ACDR.1
Activity Required key. This is the activity for
the balances.
MST-ACCT-CATEGORY Alpha 5 AC190 ACDR.1
Account Category Required key. This is the account
category for the balances.
MST-FISCAL-YEAR Numeric 4 AC190 ACDR.1
Fiscal Year Required key. This is the fiscal year.
MST-VAR-LEVELS Alpha 30 AC190 ACDR.1
Variable Levels Levels define an addressing system that
organizes activities into a reporting
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-PARENT-ACTV Alpha 15 AC190 ACDR.1
Parent Actv
MST-BASE-ND Numeric 1 AC190 ACDR.1
Base Number of This is the number of decimal positions
Decimals defined for the activity group base
currency.
MST-BEGIN-BAL-AMT Signed 15.2 AC190 ACDR.1
Amount Beginning This is the life-to-date amount up
Balance until the start of the current year.
MST-BEGIN-BAL-UNT Signed 15.2 AC190 ACDR.1
Units Beginning This is the life-to-date units up until
Balance the start of the current year.
MST-BALANCE-AMOUNT Signed 17.2 AC190 ACDR.1
Amount Balance This is the amount balance for the
current year.
MST-BALANCE-UNIT Signed 17.2 AC190 ACDR.1
Units Balance This is the units balance for the
current year.
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) AC190 AC45.1
Maintenance Date The date last changed. ACDR.1
MST-MAINT-TIME Numeric 6 (hhmmss) AC190 AC45.1
Maintenance Time The time last changed. ACDR.1
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 AC190
ACTIVITY AC300 AC310
ACCT-CATEGORY AC410 AC420
FISCAL-YEAR AC45.1 AC472
AC493 AC720
AC96.1 AC98.2
ACDL.1 ACDR.1
MSTSET2 ACTIVITY-GRP AC123 ACAC.1
ACTIVITY
FISCAL-YEAR
ACCT-CATEGORY
MSTSET3 ACTIVITY-GRP AC121 AC123
FISCAL-YEAR AC130 AC20.1
ACTIVITY AC20.2 AC20.3
ACCT-CATEGORY AC20.4 AC20.5
AC30.2 AC30.3
AC32.1 AC473
AC490 ACAC.1
MSTSET4 ACTIVITY-GRP AC05.1 AC121
ACTIVITY AC123 AC130
ACCT-CATEGORY AC165 AC190
FISCAL-YEAR* AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC295
AC297 AC30.2
AC30.3 AC32.1
AC400 AC473
AC490 AC65.1
AC65.2 AC93.2
AC93.3 AC93.4
AC93.5 AC96.1
AC98.2 ACAC.1
ACDL.1 ACDR.1
...
MSTSET5 ACTIVITY-GRP
PARENT-ACTV
ACCT-CATEGORY
FISCAL-YEAR
ACTIVITY
ACMASTER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
MST-ACCT-CATEGORY -> AAX-ACCT-CATEGORY (AAXSET1)
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
|
