ACHISTORY – Activity Audit

System
Activity Management (AC)
Prefix
HST
Primary key
ACTIVITY, DATE-STAMP, SEQ-NBR
Fields
15
Updated by
34 programs
Referenced by
2 programs

ACHISTORY is the Activity Audit table in Lawson Activity Management (prefix HST). It is indexed by ACTIVITY, DATE-STAMP, SEQ-NBR (HSTSET1); alternate indexes: HSTSET2 and HSTSET3. It is related 1:1 to ACACTIVITY. It is updated by AC00.1, AC10.1, AC10.3, AC110, AC112, AC113, AC12.1, AC120 and 26 more and referenced by AC210 and AC88.2. The table has 15 fields, 3 indexes and 1 documented relation.

About ACHISTORY

No description in the Lawson data dictionary.

Fields (15)

Column = COBOL field name without the HST- 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
#HST-ACTIVITY PK
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.AC00.1, AC10.1, AC10.3, AC110, AC112, AC113, AC12.1, AC120 +25 more
#HST-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.AC00.1, AC10.1, AC10.3, AC110, AC112, AC113, AC12.1, AC120 +25 more
#HST-OPERATOR SET3
OPERATOR		Alpha 10This field is used to store the login id of the person who entered the record.AC00.1, AC10.1, AC10.3, AC110, AC112, AC113, AC12.1, AC120 +25 more
#HST-DATE-STAMP PK
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.AC00.1, AC10.1, AC10.3, AC110, AC112, AC113, AC12.1, AC120 +25 more
#HST-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.AC00.1, AC10.1, AC10.3, AC110, AC112, AC113, AC12.1, AC120 +25 more
#HST-FIELD-ID SET2
FIELD_ID		Numeric 3—
  • 014 Previous Begin Date
  • 015 Previous End Date
AC00.1, AC10.1, AC10.3, AC110, AC112, AC113, AC12.1, AC120 +25 more
#HST-ALPHA-IMAGE
ALPHA_IMAGE		Alpha 30—AC00.1, AC10.1, AC10.3, AC110, AC112, AC113, AC12.1, AC120 +25 more
#HST-NUMERIC-IMAGE
NUMERIC_IMAGE		Signed 18.5—AC00.1, AC10.1, AC10.3, AC110, AC112, AC113, AC12.1, AC120 +25 more
#HST-DATE-IMAGE
DATE_IMAGE		Numeric 8 (yyyymmdd)—AC00.1, AC10.1, AC10.3, AC110, AC112, AC113, AC12.1, AC120 +25 more
#HST-ACTION
ACTION		Alpha 1—AC00.1, AC10.1, AC10.3, AC110, AC112, AC113, AC12.1, AC120 +25 more
#HST-PROGRAM
PROGRAM		Alpha 5—AC00.1, AC10.1, AC10.3, AC110, AC112, AC113, AC12.1, AC120 +25 more
#HST-FIELD-NAME
FIELD_NAME		Alpha 15—AC00.1, AC10.1, AC10.3, AC110, AC112, AC113, AC12.1, AC120 +25 more
#HST-ALPHA-NEW
ALPHA_NEW		Alpha 30—AC00.1, AC10.1, AC10.3, AC110, AC112, AC113, AC12.1, AC120 +25 more
#HST-NUMERIC-NEW
NUMERIC_NEW		Signed 18.5—AC00.1, AC10.1, AC10.3, AC110, AC112, AC113, AC12.1, AC120 +25 more
#HST-DATE-NEW
DATE_NEW		Numeric 8 (yyyymmdd)—AC00.1, AC10.1, AC10.3, AC110, AC112, AC113, AC12.1, AC120 +25 more

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
HSTSET1
  1. ACTIVITY
  2. DATE-STAMP
  3. SEQ-NBR ↓
PrimaryAC00.1, AC10.1, AC10.3, AC110, AC112, AC113, AC12.1, AC120 +22 more (list truncated in source)
HSTSET2
  1. ACTIVITY
  2. FIELD-ID
  3. DATE-STAMP
  4. SEQ-NBR ↓
KeyChange—
HSTSET3
  1. ACTIVITY
  2. DATE-STAMP
  3. OPERATOR
  4. SEQ-NBR
AC210, AC305, AC88.2

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AcactivityACACTIVITYRequired
HST-ACTIVITY→ACV-ACTIVITY

Programs

Updated by (34)

Referenced by (2)