Lawson Insight Technical Documentation |
|
ACMASTER
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 AC295 AC410 AC420 AC472 AC493
AC96.1 AC96.4 AC98.2 ACDL.1 ACTA.1 AC400
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
BR430 BR530 BR65.1 BR65.2 BRCC.1 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
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
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
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
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
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
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
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
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
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
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
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
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: Maintenance DaThe date last changed. AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
MST-MAINT-TIME Numeric 6 (hhmmss) AC121 AC123
Element: Sys Time The time last changed. AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
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
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
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
AC295 AC300
AC310 AC410
AC420 AC472
AC493 AC96.1
AC96.4 AC98.2
ACDL.1 ACDR.1
ACTA.1
MSTSET2 ACTIVITY-GRP AC123 AC400
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
AC295 AC32.1
AC37.1 AC400
AC473 AC490
AC65.1 AC65.2
AC93.2 AC93.3
AC93.4 AC93.5
AC96.1 AC96.4
...
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
Aclevel ACLEVEL Required
MST-ACTIVITY-GRP -> LVL-ACTIVITY-GRP
MST-VAR-LEVELS -> LVL-VAR-LEVELS
|