|
|
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 AC96.1
AC98.2 ACDL.1 AC123 AC40.1 AC40.4 AC41.1
AC41.4 AC42.1 ACAC.1 AP125 AP126 AP25.1
AP25.2 AP26.1 AP27.1 AP520 BR41.1 BR41.4
BR43.1 CB10.1 CB191 CB20.1 CB30.1 EE135
EE20.3 EE35.1 EE35.2 EE520 GL146 GL165
GL170 GL197 GL40.1 GL40.2 GL40.3 GL40.7
GL40.8 GL44.1 GL45.1 GL75.1 MA65.1 POIG.1
AC121 AC130 AC20.1 AC20.2 AC20.3 AC20.4
AC20.5 AC32.1 AC37.1 AC473 AC490 AC05.1
AC165 AC295 AC297 AC400 AC65.1 AC65.2
AC93.2 AC93.3 AC93.4 AC93.5 ACTA.1 BR130
BR131 BR153 BR20.1 BR20.2 BR20.3 BR20.4
BR20.5 BR430 BR521 BR530 BR65.1 BR65.2
BRCC.1 BRIP.1 BRPI.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
Element: Activity GroupRequired key. This is the activity
group for the balances.
MST-ACTIVITY Alpha 15 AC190 ACDR.1
Element: Activity Required key. This is the activity for
the balances.
MST-ACCT-CATEGORY Alpha 5 AC190 ACDR.1
Element: Account CategoRequired key. This is the account
category for the balances.
MST-FISCAL-YEAR Numeric 4 AC190 ACDR.1
Element: Fiscal Year Required key. This is the fiscal year.
MST-VAR-LEVELS Alpha 30 AC190 ACDR.1
Element: Variable LevelLevels 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
Element: 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
Element: Amount BalanceThis is the amount balance for the
current year.
MST-BALANCE-UNIT Signed 17.2 AC190 ACDR.1
Element: Units Balance This is the units balance for the
current year.
MST-LTD-AMOUNT Derived
Element: Life-to-Date AThis is the sum of the Amount Balance
and the Amount Beginning Balance fields
for the fiscal year.
MST-LTD-UNIT Derived
Element: Life-to-Date UThis 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
Element: Date ACDR.1
MST-MAINT-TIME Numeric 6 (hhmmss) AC190 AC45.1
Element: Sys Time ACDR.1
MST-ACCT-CAT-TYPE Derived
Element: 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 AC96.1
AC98.2 ACDL.1
ACDR.1
MSTSET2 ACTIVITY-GRP AC123 AC40.1
ACTIVITY AC40.4 AC41.1
FISCAL-YEAR AC41.4 AC42.1
ACCT-CATEGORY ACAC.1 AP125
AP126 AP25.1
AP25.2 AP26.1
AP27.1 AP520
BR41.1 BR41.4
BR43.1 CB10.1
CB191 CB20.1
CB30.1 EE135
EE20.3 EE35.1
EE35.2 EE520
GL146 GL165
GL170 GL197
...
MSTSET3 ACTIVITY-GRP AC121 AC123
FISCAL-YEAR AC130 AC20.1
ACTIVITY AC20.2 AC20.3
ACCT-CATEGORY AC20.4 AC20.5
AC32.1 AC37.1
AC473 AC490
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 AC32.1
AC37.1 AC40.1
AC40.4 AC400
AC41.1 AC41.4
AC42.1 AC473
AC490 AC65.1
AC65.2 AC93.2
AC93.3 AC93.4
AC93.5 AC96.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
|
