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
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. |
|
||||||||||||||
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 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MSTSET1 |
ACTIVITY-GRP ACTIVITY ACCT-CATEGORY FISCAL-YEAR |
|
|||||||||||||||||||||||||
MSTSET2 |
ACTIVITY-GRP ACTIVITY FISCAL-YEAR ACCT-CATEGORY |
|
| ||||||||||||||||||||||||
MSTSET3 |
ACTIVITY-GRP FISCAL-YEAR ACTIVITY ACCT-CATEGORY |
|
| ||||||||||||||||||||||||
MSTSET4 |
ACTIVITY-GRP ACTIVITY ACCT-CATEGORY FISCAL-YEAR* |
|
|||||||||||||||||||||||||
MSTSET5 |
ACTIVITY-GRP PARENT-ACTV ACCT-CATEGORY FISCAL-YEAR ACTIVITY |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Acacctcat | ACACCTCAT |
Required
| ||||||||||||
Acacctcatx | ACACCTCATX |
Not Required
| ||||||||||||
Acactgrp | ACACTGRP |
Required
| ||||||||||||
Acactivity | ACACTIVITY |
Required
| ||||||||||||
Acmstbod | ACMSTBOD |
Not Required, Delete Cascades
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Accommit | ACCOMMIT |
| |||||||||||||||||||||||||||
Accommitx | ACCOMMITX |
| |||||||||||||||||||||||||||
Actrans | ACTRANS |
|
All trademarks and registered trademarks are the property of their
respective owners.