Lawson Insight Technical Documentation |
|
ACMASTERX
ACMASTERX FILE
Activity Master Detail
This file contains actual amounts by fiscal year and period in the Activity
Management system. Information contained in the file includes activity group,
activity, account category, fiscal year, period, and amount and unit balances
for the period.
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 AC130 AC165 AC20.1
AC20.2 AC20.3 AC20.4 AC20.5 AC22.1 AC295
AC297 AC32.1 AC37.1 AC400 AC410 AC420
AC473 AC490 AC65.1 AC65.2 AC96.1 AC98.2
ACDL.1 ACTA.1 BR130 BR131 BR153 BR20.1
BR20.2 BR20.3 BR20.4 BR20.5 BR430 BR521
BR530 BR65.1 BR65.2 BRCC.1 BRIP.1 BRPI.1
AC40.1 AC40.4 AC41.1 AC41.4 AC42.1 ACAC.1
AP125 AP126 AP25.1 AP25.2 AP26.1 AP27.1
AP520 BR41.1 BR41.4 BR43.1 CB10.1 CB191
CB20.1 CB30.1 EE135 EE20.3 EE35.1 EE35.2
EE520 GL146 GL165 GL170 GL197 GL40.1
GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
GL75.1 MA65.1 POIG.1
UPDATED BY
AC190 AC300 AC310 AC45.1 ACDR.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MSX-ACTIVITY-GRP Alpha 15 AC190 ACDR.1
Element: Activity GroupRequired key. This is the activity
group for the actual amounts.
MSX-ACTIVITY Alpha 15 AC190 ACDR.1
Element: Activity Required key. This is the activity for
the actual amounts.
MSX-ACCT-CATEGORY Alpha 5 AC190 ACDR.1
Element: Account CategoRequired key. This is the account
category for the actual amounts.
MSX-FISCAL-YEAR Numeric 4 AC190 ACDR.1
Element: Fiscal Year Required key. This is the fiscal year
.
MSX-PERIOD Numeric 2 AC190 ACDR.1
Element: Period Required key. This is the fiscal
period.
MSX-PARENT-ACTV Alpha 15 AC190 ACDR.1
Element: Parent Actv
MSX-AMOUNT Currency 15.2 AC190 ACDR.1
Element: Amount This is the amount for this fiscal
period.
MSX-UNIT Signed 15.2 AC190 ACDR.1
Element: Unit This is the number of units for this
fiscal period.
MSX-ACCT-CAT-TYPE Derived
Element: Acct Cat Type This is the account category type:
cost, revenue, or accrual.
ACMASTERX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MSXSET1 ACTIVITY-GRP AC121 AC123
ACTIVITY AC127 AC130
ACCT-CATEGORY AC165 AC190
FISCAL-YEAR AC20.1 AC20.2
PERIOD AC20.3 AC20.4
AC20.5 AC22.1
AC295 AC297
AC300 AC310
AC32.1 AC37.1
AC400 AC410
AC420 AC45.1
AC473 AC490
AC65.1 AC65.2
AC96.1 AC98.2
ACDL.1 ACDR.1
...
MSXSET2 ACTIVITY-GRP AC40.1 AC40.4
ACTIVITY AC41.1 AC41.4
FISCAL-YEAR AC42.1 ACAC.1
PERIOD AP125 AP126
ACCT-CATEGORY AP25.1 AP25.2
AP26.1 AP27.1
AP520 BR41.1
BR41.4 BR43.1
CB10.1 CB191
CB20.1 CB30.1
EE135 EE20.3
EE35.1 EE35.2
EE520 GL146
GL165 GL170
GL197 GL40.1
...
MSXSET3 ACTIVITY-GRP AC40.1 AC40.4
FISCAL-YEAR AC400 AC41.1
PERIOD AC41.4 AC42.1
ACTIVITY AC473 ACAC.1
ACCT-CATEGORY AP125 AP126
AP25.1 AP25.2
AP26.1 AP27.1
AP520 BR41.1
BR41.4 BR43.1
CB10.1 CB191
CB20.1 CB30.1
EE135 EE20.3
EE35.1 EE35.2
EE520 GL146
GL165 GL170
...
MSXSET4 ACTIVITY-GRP KeyChange
PARENT-ACTV
ACCT-CATEGORY
FISCAL-YEAR
PERIOD
ACTIVITY
ACMASTERX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
MSX-ACCT-CATEGORY -> AAX-ACCT-CATEGORY (AAXSET1)
Acactgrp ACACTGRP Required
MSX-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Required
MSX-ACTIVITY -> ACV-ACTIVITY
Aclevel ACLEVEL Required
MSX-ACTIVITY-GRP -> LVL-ACTIVITY-GRP
MST-VAR-LEVELS -> LVL-VAR-LEVELS
Acmaster ACMASTER Not Required
MSX-ACTIVITY-GRP -> MST-ACTIVITY-GRP
MSX-ACTIVITY -> MST-ACTIVITY
MSX-ACCT-CATEGORY -> MST-ACCT-CATEGORY
MSX-FISCAL-YEAR -> MST-FISCAL-YEAR
ACMASTERX FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Actrans ACTRANS
MSX-ACTIVITY-GRP -> ATN-ACTIVITY-GRP
ACV-VAR-LEVELS -> ATN-VAR-LEVELS
9 -> ATN-STATUS
MSX-ACCT-CATEGORY -> ATN-ACCT-CATEGORY
MSX-FISCAL-YEAR -> ATN-FISCAL-YEAR
MSX-PERIOD -> ATN-PERIOD
ATN-OBJ-ID
|