ACMASTER

Activity Balances

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 AC297 AC47.2 AC472 AC493 AC82.1
AC82.2 AC96.1 AC96.4 AC98.2 ACBD.2 ACDL.1
ACTA.1 SNAC.1 AC130 AC32.1 AC37.1 AC473
AC490 AC05.1 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 AC145 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC20.6 AC20.7 AC21.5
AC22.1 AC300 AC45.1 ACDR.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MST-ACTIVITY-GRP
Element: Activity Group
Alpha 15
Required key. This is the activity group for the balances.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
MST-ACTIVITY
Element: Activity
Alpha 15
Required key. This is the activity for the balances.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
MST-ACCT-CATEGORY
Element: Account Category
Alpha 5
Required key. This is the account category for the balances.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
MST-FISCAL-YEAR
Element: Fiscal Year
Numeric 4
Required key. This is the fiscal year.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
MST-VAR-LEVELS
Element: Variable Levels
Alpha 30
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.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
MST-PARENT-ACTV
Element: Parent Actv
Alpha 15
The parent activity field contains the activity name of the member parent.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
MST-BASE-ND
Base Number of
Decimals
Numeric 1
This is the number of decimal positions defined for the activity group base currency.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
MST-BEGIN-BAL-AMT
Amount Beginning
Balance
Signed 18.2
This is the life-to-date amount up until the start of the current year.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
MST-BEGIN-BAL-UNT
Units Beginning
Balance
Signed 15.2
This is the life-to-date units up until the start of the current year.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
MST-BALANCE-AMOUNT
Element: Amount Balance
Signed 18.2
This is the amount balance for the current year.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
MST-BALANCE-UNIT
Element: Units Balance
Signed 17.2
This is the units balance for the current year.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
MST-LTD-AMOUNT
Element: Life-to-Date Amount
Derived
This is the sum of the Amount Balance and the Amount Beginning Balance fields for the fiscal year.
MST-LTD-UNIT
Element: Life-to-Date Units
Derived
This is the sum of the Units Balance and the Units Beginning Balance fields for the fiscal year.
MST-MAINT-DATE
Element: Maint Date
Numeric 8 (yyyymmdd)
The date last changed.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
MST-MAINT-TIME
Element: Sys Time
Numeric 6 (hhmmss)
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
MST-ACCT-CAT-TYPE
Element: Acct Cat Type
Derived
This is the account category type: cost, revenue, or accrual.
MST-PERIOD-AMT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
MST-PERIOD-UNIT
Element: Unit
Signed 15.2 Occurs 13 Times
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1


ACMASTER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MSTSET1 ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
FISCAL-YEAR
AC10.1 AC121
AC123 AC127
AC145 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
AC297 AC300
AC45.1 AC47.2
AC472 AC493
AC82.1 AC82.2
AC96.1 AC96.4
AC98.2 ACBD.2
ACDL.1 ACDR.1
ACTA.1 SNAC.1
MSTSET2 ACTIVITY-GRP
ACTIVITY
FISCAL-YEAR
ACCT-CATEGORY
AC123
MSTSET3 ACTIVITY-GRP
FISCAL-YEAR
ACTIVITY
ACCT-CATEGORY
AC121 AC123
AC127 AC130
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC21.5
AC22.1 AC32.1
AC37.1 AC473
AC490 ACDR.1
MSTSET4 ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
FISCAL-YEAR*
...
AC05.1 AC121
AC123 AC127
AC130 AC145
AC165 AC190
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC21.5
AC22.1 AC297
AC32.1 AC37.1
AC47.2 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
KeyChange


ACMASTER FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
Acmstbod ACMSTBOD Not Required, Delete Cascades
MST-ACTIVITY-GRP->YAM-ACTIVITY-GRP
MST-ACTIVITY->YAM-ACTIVITY
MST-ACCT-CATEGORY->YAM-ACCT-CATEGORY
MST-FISCAL-YEAR->YAM-FISCAL-YEAR


ACMASTER FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 02:03:09 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.