ACMASTER

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
ACTA.1


UPDATED BY
AC10.1 SNAC.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.
MST-ACTIVITY
Element: Activity
Alpha 15
Required key. This is the activity for the balances.
MST-ACCT-CATEGORY
Element: Account Category
Alpha 5
Required key. This is the account category for the balances.
MST-FISCAL-YEAR
Element: Fiscal Year
Numeric 4
Required key. This is the fiscal year.
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.
MST-PARENT-ACTV
Element: Parent Actv
Alpha 15
The parent activity field contains the activity name of the member parent.
MST-BASE-ND
Base Number of
Decimals
Numeric 1
This is the number of decimal positions defined for the activity group base currency.
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.
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.
MST-BALANCE-AMOUNT
Element: Amount Balance
Signed 18.2
This is the amount balance for the current year.
MST-BALANCE-UNIT
Element: Units Balance
Signed 17.2
This is the units balance for the current year.
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.
MST-MAINT-TIME
Element: Sys Time
Numeric 6 (hhmmss)
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
MST-PERIOD-UNIT
Element: Unit
Signed 15.2 Occurs 13 Times


ACMASTER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MSTSET1 ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
FISCAL-YEAR
AC10.1 ACTA.1
SNAC.1
MSTSET2 ACTIVITY-GRP
ACTIVITY
FISCAL-YEAR
ACCT-CATEGORY
MSTSET3 ACTIVITY-GRP
FISCAL-YEAR
ACTIVITY
ACCT-CATEGORY
MSTSET4 ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
FISCAL-YEAR*
ACTA.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


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: Wed Jun 08 20:46:56 2016

Home
Contact Us



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