ACAUDIT – Activity Audit

System: Activity Management (AC)
Prefix: AUD
Primary key: ACTIVITY, PROCESS-DATE, PROCESS-TIME, COPY-FR-AG, COPY-TO-AG, REORG-OR-COPY
Fields: 26
Updated by: 11 programs
Referenced by: 3 programs

ACAUDIT is the Activity Audit table in Lawson Activity Management (prefix AUD). It is indexed by ACTIVITY, PROCESS-DATE, PROCESS-TIME, COPY-FR-AG, COPY-TO-AG, REORG-OR-COPY (AUDSET1); alternate indexes: AUDSET2, AUDSET3, AUDSET4 and AUDSET6. It is updated by AC00.1, AC00.3, AC01.1, AC10.1, AC10.5, AC11.1, AC110, AC120 and 3 more and referenced by AC19.1, AC56.1 and AC560. The table has 26 fields, 5 indexes and 0 documented relations.

About ACAUDIT

This file contains activity change information from AC10.3 (Activity Levels). It includes changes in the activity level structure definition, a change description, process time and date, and last-changed date.

Fields (26)

Column = COBOL field name without the AUD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`AUD-ACTIVITY` PK ACTIVITY	Alpha 15	Required key. This is the new or changed activity.	AC10.1, AC10.5, AC11.1, AC110
`AUD-PROCESS-DATE` PK PROCESS_DATE	Numeric 8 (yyyymmdd)	This is the date the activity record was processed.	AC10.1, AC10.5, AC11.1, AC110, AC120
`AUD-PROCESS-TIME` PK PROCESS_TIME	Numeric 6 (hhmmss)	This is the time the activity record was processed.	AC10.1, AC10.5, AC11.1, AC110, AC120
`AUD-DATE-CHANGED` DATE_CHANGED	Numeric 8 (yyyymmdd)	This is the date the activity record was changed.	AC10.1, AC10.5, AC11.1, AC110
`AUD-OLD-LEVELS` OLD_LEVELS	Alpha 30	This is the old variable level definition for the activity.	AC10.1, AC10.5, AC11.1, AC110
`AUD-NEW-LEVELS` NEW_LEVELS	Alpha 30	This is the new variable level definition for the activity.	AC10.1, AC10.5, AC11.1, AC110
`AUD-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This is a description of the change to the activity level structure (work breakdown structure).	AC10.5, AC11.1, AC110
`AUD-LONG-DESC` LONG_DESC	Alpha 60 (Lower Case)	Occurs 4 Times This is a long description of the change to the activity level structure (work breakdown structure).	AC10.5, AC11.1, AC110
`AUD-REORG-OR-COPY` PK REORG_OR_COPY	Alpha 1	This field indicates whether the new activity level structure definition is a copy or a reorganization. Use C for copy, and R for reorganization. `R` Reorg `C` Copy `M` Move	AC10.1, AC10.5, AC11.1, AC110
`AUD-COPY-FR-ACTV` COPY_FR_ACTV	Alpha 15	This is the original activity.	AC10.5, AC11.1, AC110
`AUD-POSTING-FLAG` POSTING_FLAG	Alpha 1	This field indicates whether the new activity is posting-level or summary-level. Use P for posting and S for summary. `P` Posting `S` Summary	AC10.5, AC11.1, AC110
`AUD-COPY-FR-DEPTH` COPY_FR_DEPTH	Numeric 1	This field indicates the number of levels in the original level structure.	AC10.5, AC11.1, AC110
`AUD-COPY-TO-DEPTH` COPY_TO_DEPTH	Numeric 1	This field indicates the number of levels in the new level structure.	AC10.5, AC11.1, AC110
`AUD-COPY-FR-AG` PK COPY_FR_AG	Alpha 15	Key field. This is the original activity group.	AC10.1, AC10.5, AC11.1, AC110
`AUD-COPY-TO-AG` PK COPY_TO_AG	Alpha 15	Key field. This is the new or changed activity group.	AC10.1, AC10.5, AC11.1, AC110
`AUD-COPY-TO-AG-DES` COPY_TO_AG_DES	Alpha 30	This is the new activity group description.	AC10.5, AC11.1, AC110
`AUD-RUN-GROUP` RUN_GROUP	Alpha 15	This is the run group for the level changes.	AC10.5, AC11.1, AC110
`AUD-MOVE-FR-ACTV` MOVE_FR_ACTV	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	AC10.5
`AUD-MOVE-TO-AG` MOVE_TO_AG	Alpha 15	The activity group is the overall project.	AC10.5
`AUD-MOVE-TO-ACTV` MOVE_TO_ACTV	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	AC10.5
`AUD-MOVE-TOP-LVL` MOVE_TOP_LVL	Alpha 1	— `Y` Yes `N` No	AC10.5, AC120
`AUD-BEGIN-DATE` BEGIN_DATE	Numeric 8 (yyyymmdd)	The begin date for the new activity being created.	AC11.1, AC110
`AUD-END-DATE` END_DATE	Numeric 8 (yyyymmdd)	The end date for the new activity being created.	AC11.1, AC110
`AUD-FROM-CONTRACT` FROM_CONTRACT	Alpha 15	Activity Management contract.	AC10.1, AC10.5
`AUD-TO-CONTRACT` TO_CONTRACT	Alpha 15	Activity Management contract.	AC10.1, AC10.5
`AUD-PARENT-ACTV` PARENT_ACTV	Alpha 15	The parent activity field contains the activity name of the member parent.	AC10.1, AC10.5, AC120

Indexes (5)

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

Index	Keys	Flags	Condition	Used in
`AUDSET1`	`ACTIVITY`, `PROCESS-DATE`, `PROCESS-TIME`, `COPY-FR-AG`, `COPY-TO-AG`, `REORG-OR-COPY`	Primary		AC10.1, AC10.5, AC11.1, AC110, AC120, AC19.1, AC300, AC50.1 +3 more
`AUDSET2`	`RUN-GROUP`, `COPY-FR-AG`, `COPY-TO-AG`, `COPY-FR-ACTV`, `ACTIVITY`	KeyChange, Subset	Where (REORG-OR-COPY = "C")	AC01.1, AC11.1, AC110
`AUDSET3`	`NEW-LEVELS`, `ACTIVITY`, `PROCESS-DATE`, `PROCESS-TIME`, `COPY-FR-AG`, `COPY-TO-AG`, `REORG-OR-COPY`	KeyChange		AC01.1, AC10.1, AC10.5, AC11.1, AC110, AC120, AC50.1, AC500
`AUDSET4`	`RUN-GROUP`, `REORG-OR-COPY`, `NEW-LEVELS`, `ACTIVITY`, `COPY-TO-AG`, `COPY-FR-AG`, `PROCESS-TIME`	KeyChange		AC10.5, AC11.1, AC110, AC120
`AUDSET6`	`MOVE-TOP-LVL`, `MOVE-FR-ACTV`, `MOVE-TO-AG`, `MOVE-TO-ACTV`	KeyChange, Subset	Where MOVE-TOP-LVL = "Y"	AC00.1, AC00.3, AC10.1, AC10.5

Programs

Updated by (11)

AC00.1 Activity Group
AC00.3 Activity Group Purge Status
AC01.1 Mass Activity Copy
AC10.1 Activity
AC10.5 Mass Activity Move
AC11.1 Copy Activities
AC110 Activity Copy
AC120 Level Reorganization
AC300 Activity Group Purge
AC50.1 Activity Interface Adjustment
AC500 Activity Interface

Referenced by (3)

AC19.1 Multiple Activity Speed Add
AC56.1 Setup Interface Adjustment
AC560 Setup Interface