ACACTAU – Activity Acct Category Audit

System
Activity Management (AC)
Prefix
AVU
Primary key
ACTIVITY, ACCT-CATEGORY, UNIQUE-I-D
Fields
12
Updated by
4 programs
Referenced by
2 programs

ACACTAU is the Activity Acct Category Audit table in Lawson Activity Management (prefix AVU). It is indexed by ACTIVITY, ACCT-CATEGORY, UNIQUE-I-D (AVUSET1); alternate indexes: AVUSET2 and AVUUID. It is updated by AC06.1, AC06.2, AC105 and AC305 and referenced by AC206 and AC88.5. The table has 12 fields, 3 indexes and 0 documented relations.

About ACACTAU

No description in the Lawson data dictionary.

Fields (12)

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

Field / columnTypeDescription & valuesUpdated by
AVU-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
AVU-ACTIVITY PK
ACTIVITY		Alpha 15—AC06.1, AC06.2, AC105
AVU-ACCT-CATEGORY PK
ACCT_CATEGORY		Alpha 5—AC06.1, AC06.2, AC105
AVU-ACTION
ACTION		Alpha 1—AC06.1, AC06.2, AC105
AVU-OPERATOR
OPERATOR		Alpha 10—AC06.1, AC06.2, AC105
AVU-DATE
DATE		Numeric 8 (yyyymmdd)—AC06.1, AC06.2, AC105
AVU-TIME
TIME		Numeric 6 (hhmmss)—AC06.1, AC06.2, AC105
AVU-PROGRAM
PROGRAM		Alpha 5—AC06.1, AC06.2, AC105
AVU-FIELD-NAME
FIELD_NAME		Alpha 15—AC06.1, AC06.2, AC105
AVU-FIELD-ID
FIELD_ID		Numeric 4—AC06.1, AC06.2, AC105
AVU-OLD-VALUE
OLD_VALUE		Alpha 30 (Lower Case)—AC06.1, AC06.2, AC105
AVU-NEW-VALUE
NEW_VALUE		Alpha 30 (Lower Case)—AC06.1, AC06.2, AC105

Indexes (3)

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

IndexKeysFlagsConditionUsed in
AVUSET1ACTIVITY, ACCT-CATEGORY, UNIQUE-I-DPrimaryAC206, AC305, AC88.5
AVUSET2ACTIVITY, ACCT-CATEGORY, DATE, OPERATOR, UNIQUE-I-DAC88.5
AVUUIDUNIQUE-I-D—

Programs

Updated by (4)

Referenced by (2)