ACMASTER – Activity Balances

System
Activity Management (AC)
Prefix
MST
Primary key
ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, FISCAL-YEAR
Fields
18
Updated by
16 programs
Referenced by
39 programs

ACMASTER is the Activity Balances table in Lawson Activity Management (prefix MST). It is indexed by ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, FISCAL-YEAR (MSTSET1); alternate indexes: MSTSET2, MSTSET3, MSTSET4 and MSTSET5. It is related 1:1 to ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY and ACMSTBOD and 1:M to ACCOMMIT, ACCOMMITX and ACTRANS. It is updated by AC121, AC123, AC127, AC145, AC20.1, AC20.2, AC20.3, AC20.4 and 8 more and referenced by AC05.1, AC10.1, AC130, AC165, AC190, AC297, AC32.1, AC37.1 and 31 more. The table has 18 fields, 5 indexes and 8 documented relations.

About ACMASTER

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).

Fields (18)

Column = COBOL field name without the MST- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#MST-ACTIVITY-GRP PK
ACTIVITY_GRP		Alpha 15Required key. This is the activity group for the balances.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#MST-ACTIVITY PK
ACTIVITY		Alpha 15Required key. This is the activity for the balances.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#MST-ACCT-CATEGORY PK
ACCT_CATEGORY		Alpha 5Required key. This is the account category for the balances.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#MST-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4Required key. This is the fiscal year.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#MST-VAR-LEVELS
VAR_LEVELS		Alpha 30Levels 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 +5 more
#MST-PARENT-ACTV SET5
PARENT_ACTV		Alpha 15The parent activity field contains the activity name of the member parent.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#MST-BASE-ND
BASE_ND		Numeric 1This 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 +5 more
#MST-BEGIN-BAL-AMT
BEGIN_BAL_AMT		Signed 18.2This 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 +5 more
#MST-BEGIN-BAL-UNT
BEGIN_BAL_UNT		Signed 15.2This 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 +5 more
#MST-BALANCE-AMOUNT
BALANCE_AMOUNT		Signed 18.2This is the amount balance for the current year.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#MST-BALANCE-UNIT
BALANCE_UNIT		Signed 17.2This is the units balance for the current year.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#MST-LTD-AMOUNT
LTD_AMOUNT		DerivedThis is the sum of the Amount Balance and the Amount Beginning Balance fields for the fiscal year.—
#MST-LTD-UNIT
LTD_UNIT		DerivedThis is the sum of the Units Balance and the Units Beginning Balance fields for the fiscal year.—
#MST-MAINT-DATE
MAINT_DATE		Numeric 8 (yyyymmdd)The date last changed.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#MST-MAINT-TIME
MAINT_TIME		Numeric 6 (hhmmss)—AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#MST-ACCT-CAT-TYPE
ACCT_CAT_TYPE		DerivedThis is the account category type: cost, revenue, or accrual.—
#MST-PERIOD-AMT
PERIOD_AMT		Signed 18.2 Occurs 13 Times ×13—AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#MST-PERIOD-UNIT
PERIOD_UNIT		Signed 15.2 Occurs 13 Times ×13—AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more

Indexes (5)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MSTSET1
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. ACCT-CATEGORY
  4. FISCAL-YEAR
PrimaryAC10.1, AC121, AC123, AC127, AC145, AC20.1, AC20.2, AC20.3 +22 more
MSTSET2
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. FISCAL-YEAR
  4. ACCT-CATEGORY
AC123
MSTSET3
  1. ACTIVITY-GRP
  2. FISCAL-YEAR
  3. ACTIVITY
  4. ACCT-CATEGORY
AC121, AC123, AC127, AC130, AC20.1, AC20.2, AC20.3, AC20.4 +10 more
MSTSET4
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. ACCT-CATEGORY
  4. FISCAL-YEAR ↓
AC05.1, AC121, AC123, AC127, AC130, AC145, AC165, AC190 +22 more (list truncated in source)
MSTSET5
  1. ACTIVITY-GRP
  2. PARENT-ACTV
  3. ACCT-CATEGORY
  4. FISCAL-YEAR
  5. ACTIVITY
KeyChange—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACCTCATACACCTCATXACACTGRPACACTIVITYACMSTBODACCOMMITACCOMMITXACTRANSACMASTER

One to one (5) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATRequired
MST-ACCT-CATEGORY→AAX-ACCT-CATEGORY (AAXSET1)
AcacctcatxACACCTCATXNot Required
MST-ACTIVITY-GRP→AXX-ACTIVITY-GRP
MST-ACTIVITY→AXX-ACTIVITY
MST-ACCT-CATEGORY→AXX-ACCT-CATEGORY
AcactgrpACACTGRPRequired
MST-ACTIVITY-GRP→AGP-ACTIVITY-GRP
AcactivityACACTIVITYRequired
MST-ACTIVITY→ACV-ACTIVITY
AcmstbodACMSTBODNot 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

One to many (3) — child tables

RelationTableRulesConditionField map
AccommitACCOMMIT
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
AccommitxACCOMMITX
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
ActransACTRANS
MST-ACTIVITY→ATN-ACTIVITY
MST-ACCT-CATEGORY→ATN-ACCT-CATEGORY
MST-FISCAL-YEAR→ATN-FISCAL-YEAR
—→ATN-PERIOD
—→ATN-OBJ-ID

Programs

Updated by (16)

Referenced by (39)