ACACTMXVDT – No description in the Lawson data dictionary
- System
- Activity Management (AC)
- Prefix
MXD- Primary key
OBJ-ID,MATRIX-CAT,EFFECTIVE-DATE- Fields
- 4
- Updated by
- 6 programs
- Referenced by
- 5 programs
ACACTMXVDT is a Lawson Activity Management table (prefix MXD); no description in the lawson data dictionary. It is indexed by OBJ-ID, MATRIX-CAT, EFFECTIVE-DATE (MXDSET1); alternate indexes: MXDSET2 and MXDSET4. It is updated by AC13.1, AC13.7, AC13.8, AC300, AC510 and AC560 and referenced by AC135, AC14.6, AC213, AC51.1 and MX202. The table has 4 fields, 3 indexes and 0 documented relations.
About ACACTMXVDT
No description in the Lawson data dictionary.
Fields (4)
Column = COBOL field name without the MXD- 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 |
|---|---|---|---|
#MXD-OBJ-ID PKOBJ_ID | Numeric 12 | This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. | AC13.1, AC13.7, AC13.8, AC510, AC560 |
#MXD-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. | AC13.1, AC13.7, AC13.8, AC510, AC560 |
#MXD-MX-VALUEMX_VALUE | Alpha 32 | The attribute value. | AC13.1, AC13.7, AC13.8, AC510, AC560 |
#MXD-EFFECTIVE-DATE PKEFFECTIVE_DATE | Numeric 8 (yyyymmdd) | The date a vendor's prices will be in effect. | AC13.1, AC13.7, AC13.8, AC510, AC560 |
Indexes (3)
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 |
|---|---|---|---|---|
MXDSET1 |
| Primary | AC13.1, AC13.7, AC13.8, AC14.6, AC213, AC300, AC51.1, AC510 +2 more | |
MXDSET2 |
| MX202 | ||
MXDSET4 |
| AC135 |
Programs
Updated by (6)
- AC13.1 Activity Attributes
- AC13.7 Attribute Value Effective Date
- AC13.8 Values by Attribute Effective Date
- AC300 Activity Group Purge
- AC510 Attribute Interface
- AC560 Setup Interface