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.

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
OPERATOR		Alpha 10—AC02.1
ASU-DATE
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ASUSET1USR-STATUS, UNIQUE-I-DPrimaryAC202, AC305, AC88.3
ASUSET2USR-STATUS, DATE, OPERATOR, UNIQUE-I-DAC202, AC305, AC88.3
ASUUIDUNIQUE-I-D—

Relations

One to one (2) — lookups and parents

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

Programs

Updated by (2)

Referenced by (2)