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

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 SET2
OPERATOR		Alpha 10—AC06.1, AC06.2, AC105
#AVU-DATE SET2
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 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
AVUSET1
  1. ACTIVITY
  2. ACCT-CATEGORY
  3. UNIQUE-I-D
PrimaryAC206, AC305, AC88.5
AVUSET2
  1. ACTIVITY
  2. ACCT-CATEGORY
  3. DATE
  4. OPERATOR
  5. UNIQUE-I-D
AC88.5
AVUUID
  1. UNIQUE-I-D
—

Programs

Updated by (4)

Referenced by (2)