|
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 AC472 AC493 AC96.1 AC96.4
AC98.2 ACDL.1 ACTA.1 SNAC.1 AC130 AC32.1
AC37.1 AC473 AC490 AC05.1 AC145 AC165
AC190 AC65.1 AC65.2 AC93.2 AC93.3 AC93.4
AC93.5 BR130 BR131 BR140 BR153 BR165
BR430 BR530 BR65.1 BR65.2 BR65.3 BRIP.1
UPDATED BY
AC121 AC123 AC127 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC20.6 AC20.7 AC22.1 AC300
AC310 ACDR.1 SB515
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MST-ACTIVITY-GRP Alpha 15 AC121 AC123
Element: Activity GroupRequired key. This is the activity AC127 AC20.1
group for the balances. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
MST-ACTIVITY Alpha 15 AC121 AC123
Element: Activity Required key. This is the activity for AC127 AC20.1
the balances. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
MST-ACCT-CATEGORY Alpha 5 AC121 AC123
Element: Account CategoRequired key. This is the account AC127 AC20.1
category for the balances. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
MST-FISCAL-YEAR Numeric 4 AC121 AC123
Element: Fiscal Year Required key. This is the fiscal year. AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
MST-VAR-LEVELS Alpha 30 AC121 AC123
Element: Variable LevelLevels define an addressing system that AC127 AC20.1
organizes activities into a reporting AC20.2 AC20.3
hierarchy. Level names are defined for AC20.4 AC20.5
an activity group and should be able to AC20.6 AC20.7
be used across all activities in an AC22.1 ACDR.1
activity group. Levels facilitate rollup SB515
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 AC121 AC123
Element: Parent Actv The parent activity field contains the AC127 AC20.1
activity name of the member parent. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
MST-BASE-ND Numeric 1 AC121 AC123
Base Number of This is the number of decimal positions AC127 AC20.1
Decimals defined for the activity group base AC20.2 AC20.3
currency. AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
MST-BEGIN-BAL-AMT Signed 18.2 AC121 AC123
Amount Beginning This is the life-to-date amount up AC127 AC20.1
Balance until the start of the current year. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
MST-BEGIN-BAL-UNT Signed 15.2 AC121 AC123
Units Beginning This is the life-to-date units up until AC127 AC20.1
Balance the start of the current year. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
MST-BALANCE-AMOUNT Signed 18.2 AC121 AC123
Element: Amount BalanceThis is the amount balance for the AC127 AC20.1
current year. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
MST-BALANCE-UNIT Signed 17.2 AC121 AC123
Element: Units Balance This is the units balance for the AC127 AC20.1
current year. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
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) AC121 AC123
Element: Maint Date The date last changed. AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
MST-MAINT-TIME Numeric 6 (hhmmss) AC121 AC123
Element: Sys Time AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
MST-ACCT-CAT-TYPE Derived
Element: Acct Cat Type This is the account category type:
cost, revenue, or accrual.
MST-PERIOD-AMT Signed 18.2 Occurs 13 Times AC121 AC123
Element: Intl Amt AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
MST-PERIOD-UNIT Signed 15.2 Occurs 13 Times AC121 AC123
Element: Unit AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
ACMASTER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MSTSET1 ACTIVITY-GRP AC10.1 AC121
ACTIVITY AC123 AC127
ACCT-CATEGORY AC20.1 AC20.2
FISCAL-YEAR AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC22.1
AC300 AC310
AC420 AC472
AC493 AC96.1
AC96.4 AC98.2
ACDL.1 ACDR.1
ACTA.1 SB515
SNAC.1
MSTSET2 ACTIVITY-GRP AC123
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
AC32.1 AC37.1
AC473 AC490
MSTSET4 ACTIVITY-GRP AC05.1 AC121
ACTIVITY AC123 AC127
ACCT-CATEGORY AC130 AC145
FISCAL-YEAR* AC165 AC190
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC22.1
AC32.1 AC37.1
AC473 AC490
AC65.1 AC65.2
AC93.2 AC93.3
AC93.4 AC93.5
AC96.1 AC96.4
AC98.2 ACDR.1
...
MSTSET5 ACTIVITY-GRP KeyChange
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
ACMASTER FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accommit ACCOMMIT
MST-ACTIVITY-GRP -> MIT-ACTIVITY-GRP
MST-ACTIVITY -> MIT-ACTIVITY
MST-ACCT-CATEGORY -> MIT-ACCT-CATEGORY
MST-FISCAL-YEAR -> MIT-FISCAL-YEAR
MIT-PERIOD
MIT-SYSTEM
MIT-COMPANY
MIT-CURRENCY-CODE
Accommitx ACCOMMITX
MST-ACTIVITY-GRP -> MIX-ACTIVITY-GRP
MST-ACTIVITY -> MIX-ACTIVITY
MST-ACCT-CATEGORY -> MIX-ACCT-CATEGORY
MST-FISCAL-YEAR -> MIX-FISCAL-YEAR
MIX-PERIOD
MIX-SYSTEM
MIX-COMPANY
MIX-CURRENCY-CODE
MIX-ATN-OBJ-ID
Actrans ACTRANS
MST-ACTIVITY -> ATN-ACTIVITY
MST-ACCT-CATEGORY -> ATN-ACCT-CATEGORY
MST-FISCAL-YEAR -> ATN-FISCAL-YEAR
ATN-PERIOD
ATN-OBJ-ID
|