ACSTRUCTAU – Activity Structure Audit

System: Activity Management (AC)
Prefix: ATU
Primary key: STRUCTURE, UNIQUE-I-D
Fields: 14
Updated by: 10 programs
Referenced by: 2 programs

ACSTRUCTAU is the Activity Structure Audit table in Lawson Activity Management (prefix ATU). It is indexed by STRUCTURE, UNIQUE-I-D (ATUSET1); alternate indexes: ATUSET2, ATUSET3 and ATUUID. It is related 1:1 to ACCATSUM. It is updated by AC08.1, AC08.2, AC08.3, AC08.4, AC08.5, AC08.6, AC08.7, AC108 and 2 more and referenced by AC208 and AC88.4. The table has 14 fields, 4 indexes and 2 documented relations.

About ACSTRUCTAU

No description in the Lawson data dictionary.

Fields (14)

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

Field / column	Type	Description & values	Updated by
`ATU-UNIQUE-I-D` PK UNIQUE_I_D	Bad Type 36	—	—
`ATU-STRUCTURE` PK STRUCTURE	Alpha 15	—	AC08.1, AC08.2, AC08.3, AC08.4, AC08.5, AC08.6, AC08.7, AC108 +1 more
`ATU-CATEGORY-TYPE` CATEGORY_TYPE	Alpha 1	—	AC08.1, AC08.2, AC08.3, AC08.4, AC08.5, AC08.6, AC08.7, AC108 +1 more
`ATU-SUM-ACCT-CAT` SUM_ACCT_CAT	Alpha 5	—	AC08.1, AC08.2, AC08.3, AC08.4, AC08.5, AC08.6, AC08.7, AC108 +1 more
`ATU-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	—	AC08.2, AC08.3, AC08.4, AC08.5, AC08.7, AC108, AC558
`ATU-ACTION` ACTION	Alpha 1	—	AC08.1, AC08.2, AC08.3, AC08.4, AC08.5, AC08.6, AC08.7, AC108 +1 more
`ATU-OPERATOR` OPERATOR	Alpha 10	—	AC08.1, AC08.2, AC08.3, AC08.4, AC08.5, AC08.6, AC08.7, AC108 +1 more
`ATU-DATE` DATE	Numeric 8 (yyyymmdd)	—	AC08.1, AC08.2, AC08.3, AC08.4, AC08.5, AC08.6, AC08.7, AC108 +1 more
`ATU-TIME` TIME	Numeric 6 (hhmmss)	—	AC08.1, AC08.2, AC08.3, AC08.4, AC08.5, AC08.6, AC08.7, AC108 +1 more
`ATU-PROGRAM` PROGRAM	Alpha 5	—	AC08.1, AC08.2, AC08.3, AC08.4, AC08.5, AC08.6, AC08.7, AC108 +1 more
`ATU-FIELD-NAME` FIELD_NAME	Alpha 15	—	AC08.1, AC08.2, AC08.3, AC08.4, AC08.5, AC08.6, AC08.7, AC108 +1 more
`ATU-FIELD-ID` FIELD_ID	Numeric 4	—	AC08.1, AC08.2, AC08.3, AC08.4, AC08.5, AC08.6, AC08.7, AC108 +1 more
`ATU-OLD-VALUE` OLD_VALUE	Alpha 30 (Lower Case)	—	AC08.1, AC08.2, AC08.3, AC08.4, AC08.5, AC08.6, AC08.7, AC108 +1 more
`ATU-NEW-VALUE` NEW_VALUE	Alpha 30 (Lower Case)	—	AC08.1, AC08.2, AC08.3, AC08.4, AC08.5, AC08.6, AC08.7, AC108 +1 more

Indexes (4)

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

Index	Keys	Flags	Used in
`ATUSET1`	`STRUCTURE`, `UNIQUE-I-D`	Primary	AC305, AC88.4
`ATUSET2`	`STRUCTURE`, `DATE`, `OPERATOR`, `UNIQUE-I-D`		AC208, AC305, AC88.4
`ATUSET3`	`STRUCTURE`, `SUM-ACCT-CAT`, `DATE`, `OPERATOR`, `UNIQUE-I-D`		AC88.4
`ATUUID`	`UNIQUE-I-D`		—

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Accatsum	ACCATSUM	Required		`ATU-STRUCTURE` → `SRS-STRUCTURE (SRSSET1)`, `ATU-SUM-ACCT-CAT` → `SRS-SUM-ACCT-CAT`
Accatsumx	ACCATSUM	Required		`ATU-STRUCTURE` → `SRS-STRUCTURE`, `ATU-SUM-ACCT-CAT` → `SRS-SUM-ACCT-CAT`

Programs

Updated by (10)

AC08.1 Category Structure
AC08.2 Define Category Structure
AC08.3 Account Category Detail
AC08.4 Copy Category Structure
AC08.5 Account Category Load
AC08.6 Move Summary Account Category
AC08.7 Move Detail Account Category
AC108 Structure Reorganization
AC305 Activity Audit Analysis Purge
AC558 Structure Interface

Referenced by (2)

AC208 Structure Listing and Audit
AC88.4 Structure Audit Analysis