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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated 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 SET3
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 SET2 SET3
OPERATOR		Alpha 10—AC08.1, AC08.2, AC08.3, AC08.4, AC08.5, AC08.6, AC08.7, AC108 +1 more
#ATU-DATE SET2 SET3
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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ATUSET1
  1. STRUCTURE
  2. UNIQUE-I-D
PrimaryAC305, AC88.4
ATUSET2
  1. STRUCTURE
  2. DATE
  3. OPERATOR
  4. UNIQUE-I-D
AC208, AC305, AC88.4
ATUSET3
  1. STRUCTURE
  2. SUM-ACCT-CAT
  3. DATE
  4. OPERATOR
  5. UNIQUE-I-D
AC88.4
ATUUID
  1. UNIQUE-I-D
—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACCATSUMACSTRUCTAU

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AccatsumACCATSUMRequired
ATU-STRUCTURE→SRS-STRUCTURE (SRSSET1)
ATU-SUM-ACCT-CAT→SRS-SUM-ACCT-CAT
AccatsumxACCATSUMRequired
ATU-STRUCTURE→SRS-STRUCTURE
ATU-SUM-ACCT-CAT→SRS-SUM-ACCT-CAT

Programs

Updated by (10)

Referenced by (2)