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.

Field / column	Type	Description & values	Updated by
`AGU-UNIQUE-I-D` PK UNIQUE_I_D	Bad Type 36	—	—
`AGU-ACTIVITY-GRP` PK ACTIVITY_GRP	Alpha 15	—	AC00.1, AC00.3, AC110, AC300, AC581
`AGU-ACTION` ACTION	Alpha 1	—	AC00.1, AC00.3, AC110, AC300, AC581
`AGU-OPERATOR` OPERATOR	Alpha 10	—	AC00.1, AC00.3, AC110, AC300, AC581
`AGU-DATE` DATE	Numeric 8 (yyyymmdd)	—	AC00.1, AC00.3, AC110, AC300, AC581
`AGU-TIME` TIME	Numeric 6 (hhmmss)	—	AC00.1, AC00.3, AC110, AC300, AC581
`AGU-PROGRAM` PROGRAM	Alpha 5	—	AC00.1, AC00.3, AC110, AC300, AC581
`AGU-FIELD-NAME` FIELD_NAME	Alpha 15	—	AC00.1, AC00.3, AC110, AC300, AC581
`AGU-FIELD-ID` FIELD_ID	Numeric 4	—	AC00.1, AC00.3, AC110, AC300, AC581
`AGU-OLD-VALUE` OLD_VALUE	Alpha 30 (Lower Case)	—	AC00.1, AC00.3, AC110, AC300, AC581
`AGU-NEW-VALUE` NEW_VALUE	Alpha 30 (Lower Case)	—	AC00.1, AC00.3, AC110, AC300, AC581

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`AGUSET1`	`ACTIVITY-GRP`, `UNIQUE-I-D`	Primary	AC200, AC305, AC88.1
`AGUSET2`	`ACTIVITY-GRP`, `DATE`, `OPERATOR`, `UNIQUE-I-D`		AC305, AC88.1
`AGUUID`	`UNIQUE-I-D`		—

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Acactgrp	ACACTGRP	Required		`AGU-ACTIVITY-GRP` → `AGP-ACTIVITY-GRP (AGPSET1)`

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

Referenced by (2)

AC200 Activity Grp Listing and Audit
AC88.1 Activity Group Audit Analysis