ACSTATUSAU – Activity Status Audit

System
Activity Management (AC)
Prefix
ASU
Primary key
USR-STATUS, UNIQUE-I-D
Fields
11
Updated by
2 programs
Referenced by
2 programs

ACSTATUSAU is the Activity Status Audit table in Lawson Activity Management (prefix ASU). It is indexed by USR-STATUS, UNIQUE-I-D (ASUSET1); alternate indexes: ASUSET2 and ASUUID. It is related 1:1 to ACDICT and ACSTATUS. It is updated by AC02.1 and AC305 and referenced by AC202 and AC88.3. The table has 11 fields, 3 indexes and 2 documented relations.

About ACSTATUSAU

No description in the Lawson data dictionary.

Fields (11)

Column = COBOL field name without the ASU- 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
#ASU-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
#ASU-USR-STATUS PK
USR_STATUS		Alpha 2—AC02.1
#ASU-ACTION
ACTION		Alpha 1—AC02.1
#ASU-OPERATOR SET2
OPERATOR		Alpha 10—AC02.1
#ASU-DATE SET2
DATE		Numeric 8 (yyyymmdd)—AC02.1
#ASU-TIME
TIME		Numeric 6 (hhmmss)—AC02.1
#ASU-PROGRAM
PROGRAM		Alpha 5—AC02.1
#ASU-FIELD-NAME
FIELD_NAME		Alpha 15—AC02.1
#ASU-FIELD-ID
FIELD_ID		Numeric 4—AC02.1
#ASU-OLD-VALUE
OLD_VALUE		Alpha 30 (Lower Case)—AC02.1
#ASU-NEW-VALUE
NEW_VALUE		Alpha 30 (Lower Case)—AC02.1

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.

IndexKeysFlagsConditionUsed in
ASUSET1
  1. USR-STATUS
  2. UNIQUE-I-D
PrimaryAC202, AC305, AC88.3
ASUSET2
  1. USR-STATUS
  2. DATE
  3. OPERATOR
  4. UNIQUE-I-D
AC202, AC305, AC88.3
ASUUID
  1. UNIQUE-I-D
—

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AcdictACDICTRequired
"ASU"→AUT-DB-FILE-PFX (AUTSET1)
ASU-FIELD-ID→AUT-FLD-NBR
AcstatusACSTATUSRequired
ASU-USR-STATUS→STS-USR-STATUS

Programs

Updated by (2)

Referenced by (2)