ACMXVAL – AC Trans Attribute Values
- System
- Activity Management (AC)
- Prefix
ATV- Primary key
OBJ-ID,MATRIX-CAT- Fields
- 4
- Updated by
- 32 programs
- Referenced by
- 8 programs
ACMXVAL is the AC Trans Attribute Values table in Lawson Activity Management (prefix ATV). It is indexed by OBJ-ID, MATRIX-CAT (ATVSET1); alternate indexes: ATVSET2. It is related 1:1 to MXCATDEF and MXOBJCAT. It is updated by AC197, AC198, AC300, AC40.1, AC40.4, AC41.1, AC41.4, AC42.1 and 24 more and referenced by AC190, AC256, AC290, AC54.1, ACAC.1, BR190, BR20.6 and BR44.1. The table has 4 fields, 2 indexes and 2 documented relations.
About ACMXVAL
This file contains information on activity transaction attribute values. These values are used in determining billing rates or just to store additional information about a transaction. These values can be printed using the Activity Management Transaction Writer.
Fields (4)
Column = COBOL field name without the ATV- 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 |
|---|---|---|---|
#ATV-OBJ-ID PKOBJ_ID | Numeric 12 | Required key. This is the identifier of the object for the attribute. | AC197, AC198, AC40.1, AC40.4, AC41.1, AC41.4, AC42.1, AC45.1 +23 more |
#ATV-MATRIX-CAT PKMATRIX_CAT | Alpha 12 | Required key. An attribute is a name assigned to an object (for example, job code in Payroll) to track additional information. Attribute values can then be linked to transactions for reporting and analysis. | AC197, AC198, AC40.1, AC40.4, AC41.1, AC41.4, AC42.1, AC45.1 +13 more |
#ATV-MX-VALUE SET2MX_VALUE | Alpha 32 | This is the value of the object for the attribute. | AC197, AC198, AC40.1, AC40.4, AC41.1, AC41.4, AC42.1, AC45.1 +13 more |
#ATV-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field displays the description. | AC197, AC198 |
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 |
|---|---|---|---|---|
ATVSET1 |
| Primary | AC190, AC197, AC198, AC256, AC290, AC300, AC40.1, AC40.4 +22 more (list truncated in source) | |
ATVSET2 |
| KeyChange | AC256 |
Relations
One to one (2) — lookups and parents
Programs
Updated by (32)
- AC197 Burden Recalculation Based on Total Cost
- AC198 Burden Rate Recalculation
- AC300 Activity Group Purge
- AC40.1 Journal Entry (AC only)
- AC40.4 Journal Entry (AC and GL)
- AC41.1 Resource Time Entry (AC only)
- AC41.4 Resource Time Entry (AC and GL)
- AC42.1 Subcontractor Time and Material Entry
- AC45.1 Transaction Edit
- AC540 Transaction Interface
- BR124 Deferred Revenue Adjustment
- BR153 Product Revenue Calculation
- BR154 Maintenance Revenue Calculation
- BR40.3 Transfer
- BR40.4 Write Up, Down
- BR46.2 Transfer Invoice Transaction
- BR46.4 Split Transfer
- BR530 Revenue Import
- BRIP.1 Invoice Print Program
- CX05.1 Preference Template
- CX30.1 Case Completion Feedback
- GL146 Batch Journal Control
- GL197 Period, Year End GL Commitments Processing
- GL199 Period Closing
- GL40.1 Journal Entry
- GL40.2 Define Journal
- GL40.3 Speed Entry
- GL40.7 Totals
- GL40.8 Journal Entry
- GL44.1 Report Currency Entry
- GL45.1 Journal Control
- IFGT.1 GLTRANS Interface