ACGRPMXVAL – The ACGRPMXVAL file is the primary file updated by AC13.
- System
- Activity Management (AC)
- Prefix
AGV- Primary key
OBJ-ID,MATRIX-CAT- Fields
- 3
- Updated by
- 7 programs
- Referenced by
- 119 programs
ACGRPMXVAL is the The ACGRPMXVAL file is the primary file updated by AC13. table in Lawson Activity Management (prefix AGV). It is indexed by OBJ-ID, MATRIX-CAT (AGVSET1); alternate indexes: AGVSET2. It is related 1:1 to ACACTGRP, MXCATDEF and MXOBJCAT and 1:M to ACGRPMXVAL. It is updated by AC00.1, AC135, AC14.1, AC14.2, AC300, AC560 and MX500 and referenced by AC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 and 111 more. The table has 3 fields, 2 indexes and 4 documented relations.
About ACGRPMXVAL
The ACGRPMXVAL file is the primary file updated by AC13. It stores the activity group attributes and assigned values by object ID.
Fields (3)
Column = COBOL field name without the AGV- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#AGV-OBJ-ID PKOBJ_ID | Numeric 12 | This is the object identifier. It is used to relate attributes and attribute values back to the activity group. | AC135, AC14.1, AC14.2, AC560, MX500 |
#AGV-MATRIX-CAT PKMATRIX_CAT | Alpha 12 | Attribute name assigned to an object (like accounting unit) to track additional information. Attribute values may then be used in selection and sorting for report and analysis. | AC135, AC14.1, AC14.2, AC560, MX500 |
#AGV-MX-VALUE SET2MX_VALUE | Alpha 32 | The attribute value. | AC135, AC14.1, AC14.2, AC560, MX500 |
Indexes (2)
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
AGVSET1 |
| Primary | AC00.1, AC01.1, AC105, AC112, AC113, AC120, AC121, AC123 +22 more (list truncated in source) | |
AGVSET2 |
| KeyChange | AC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 +22 more (list truncated in source) |
Relations
One to one (3) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Acactgrp | ACACTGRP | Required |
| |||||||
| Mxcatdef | MXCATDEF | Required |
| |||||||
| Mxobjcat | MXOBJCAT | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Same Value | ACGRPMXVAL |
|
Programs
Updated by (7)
- AC00.1 Activity Group
- AC135 Attribute Effective Date Update
- AC14.1 Activity Group Attributes
- AC14.2 Values by Activity Group Attributes
- AC300 Activity Group Purge
- AC560 Setup Interface
- MX500 Attribute Value Population
Referenced by (119)
- AC01.1 Mass Activity Copy
- AC105 Assignment Copy
- AC112 Mass Activity Status Change
- AC113 Activity Mass Change
- AC120 Level Reorganization
- AC121 Budget Calculation
- AC123 Budget Copy
- AC128 Mass Budget Lock
- AC145 Mass Transaction Backout
- AC147 Activity Commitment Capture
- AC160 Asset Management Interface
- AC165 Percent Complete Calculation
- AC169 Mass Capitalization Hold
- AC190 Activity Posting
- AC191 Accounting Unit Balance Post
- AC196 Beginning Balance Update
- AC197 Burden Recalculation Based on Total Cost
- AC198 Burden Rate Recalculation
- AC200 Activity Grp Listing and Audit
- AC203 Resource Assignment Listing
- AC206 Acct Cat Ovrd List and Audit
- AC207 Account Assignment Listing
- AC210 Activity Listing and Audit
- AC213 Activity Attribute Listing
- AC218 Activity Resource Rate Listing
- AC220 Budget Listing
- AC225 Budget Control Report
- AC240 Journal Edit Listing
- AC246 Manual Commitment Listing
- AC247 Activity Commitment History
- AC256 Transaction Writer Report
- AC261 Burden Assignment Listing
- AC265 Percent Complete Report
- AC290 Transaction Listing
- AC295 Activity Commitment Summary
- AC297 Commitment Analysis Summary
- AC298 Commitment Detail Report
- AC30.3 List Allocation
- AC310 Transaction Consolidation
- AC311 Purge and Archive
- AC32.1 Allocation Pool
- AC34.1 Compute Parameters
- AC346 Manual Commitments Purge
- AC35.1 Activity Total Names
- AC36.1 Activity Total Range
- AC400 Activity Group Analysis Report
- AC401 Activity Trend
- AC410 Activity Analysis Report
- AC412 Activity Status Report
- AC420 Budget Variance Report
- AC421 Change Order History
- AC440 Resource Charge
- AC460 Capitalization History
- AC471 Bill of Costs
- AC472 Bill of Activities
- AC473 Profit and Loss Statement
- AC480 Activity Balances
- AC490 Activity Reconciliation
- AC493 Output Measure Analysis
- AC494 Activity Accounting Unit Analysis
- AC527 AC to GL Budget Interface
- AC55.1 Transaction Writer
- AC580 Balance Rebuild
- AC583 Activity Transaction Rebuild
- AC90.1 Activity Analysis
- AC92.1 Resource Analysis
- AC93.1 Output Measure Analysis
- AC94.1 Activity Accounting Unit Analysis
- AC95.1 Account Category Analysis
- AC97.1 Account Category Encumbrance Analysis
- ACDM.2 Activity Dimension Definition
- AP211 Vendor Invoicing
- ARLL.1 AR Transaction Interface
- BR120 Invoice Calculation
- BR121 Invoice Print and Interface
- BR130 Revenue Calculation
- BR131 Revenue Realization
- BR140 Billing and Revenue Backout
- BR142 Mass Transaction Hold
- BR145 Invoice Control Maintenance
- BR151 Product Invoicing
- BR152 Maintenance Invoicing
- BR153 Product Revenue Calculation
- BR154 Maintenance Revenue Calculation
- BR155 Maintenance Schedule Copy
- BR156 Maintenance Quote
- BR157 Maintenance Cancel
- BR165 Percent Complete Calculation
- BR19.2 Filter
- BR190 Billing and Revenue Recalculation
- BR20.9 Filter
- BR200 Billing Listing
- BR202 Retainer Listing
- BR204 Burden Billing Rate Listing
- BR205 Milestone Listing
- BR210 Contract Listing
- BR212 Contract Modification Listing
- BR215 Fee Code Listing
- BR220 Invoice Audit Listing
- BR245 Invoice Control Listing
- BR251 Product Contract Listing
- BR252 Maintenance Schedule Listing
- BR253 Deferred Revenue Listing
- BR254 Product Milestone Listing
- BR265 Percent of Completion Report
- BR300 Invoice Purge
- BR400 Invoice History
- BR405 Milestone Analysis
- BR422 Contract Change Order History Report
- BR430 Revenue History
- BR450 Activity Aging
- BR521 Billing Import
- BR530 Revenue Import
- BR580 Applied Balance Rebuild
- GL299 GL and AC History commitment
- MX123 List Member Build
- MX202 Attribute Value Listing
- SE90.1 Analysis by Activity
- SN02.1 Activity Management Notification Parameters