ACACTGRPAU – Activity Group Audit
- System
- Activity Management (AC)
- Prefix
AGU- Primary key
ACTIVITY-GRP,UNIQUE-I-D- Fields
- 11
- Updated by
- 6 programs
- Referenced by
- 2 programs
ACACTGRPAU is the Activity Group Audit table in Lawson Activity Management (prefix AGU). It is indexed by ACTIVITY-GRP, UNIQUE-I-D (AGUSET1); alternate indexes: AGUSET2 and AGUUID. It is related 1:1 to ACACTGRP. It is updated by AC00.1, AC00.3, AC110, AC300, AC305 and AC581 and referenced by AC200 and AC88.1. The table has 11 fields, 3 indexes and 1 documented relation.
About ACACTGRPAU
No description in the Lawson data dictionary.
Fields (11)
Column = COBOL field name without the AGU- 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 |
|---|---|---|---|
#AGU-UNIQUE-I-D PKUNIQUE_I_D | Bad Type 36 | — | — |
#AGU-ACTIVITY-GRP PKACTIVITY_GRP | Alpha 15 | — | AC00.1, AC00.3, AC110, AC300, AC581 |
#AGU-ACTIONACTION | Alpha 1 | — | AC00.1, AC00.3, AC110, AC300, AC581 |
#AGU-OPERATOR SET2OPERATOR | Alpha 10 | — | AC00.1, AC00.3, AC110, AC300, AC581 |
#AGU-DATE SET2DATE | Numeric 8 (yyyymmdd) | — | AC00.1, AC00.3, AC110, AC300, AC581 |
#AGU-TIMETIME | Numeric 6 (hhmmss) | — | AC00.1, AC00.3, AC110, AC300, AC581 |
#AGU-PROGRAMPROGRAM | Alpha 5 | — | AC00.1, AC00.3, AC110, AC300, AC581 |
#AGU-FIELD-NAMEFIELD_NAME | Alpha 15 | — | AC00.1, AC00.3, AC110, AC300, AC581 |
#AGU-FIELD-IDFIELD_ID | Numeric 4 | — | AC00.1, AC00.3, AC110, AC300, AC581 |
#AGU-OLD-VALUEOLD_VALUE | Alpha 30 (Lower Case) | — | AC00.1, AC00.3, AC110, AC300, AC581 |
#AGU-NEW-VALUENEW_VALUE | Alpha 30 (Lower Case) | — | AC00.1, AC00.3, AC110, AC300, AC581 |
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 |
|---|---|---|---|---|
AGUSET1 |
| Primary | AC200, AC305, AC88.1 | |
AGUSET2 |
| AC305, AC88.1 | ||
AGUUID |
| — |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||
|---|---|---|---|---|---|---|---|
| Acactgrp | ACACTGRP | Required |
|
Programs
Updated by (6)
- AC00.1 Activity Group
- AC00.3 Activity Group Purge Status
- AC110 Activity Copy
- AC300 Activity Group Purge
- AC305 Activity Audit Analysis Purge
- AC581 Mass Report Currency Change