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.

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
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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
HSTSET1ACTIVITY, DATE-STAMP, SEQ-NBR*PrimaryAC00.1, AC10.1, AC10.3, AC110, AC112, AC113, AC12.1, AC120 +22 more (list truncated in source)
HSTSET2ACTIVITY, FIELD-ID, DATE-STAMP, SEQ-NBR*KeyChange—
HSTSET3ACTIVITY, DATE-STAMP, OPERATOR, SEQ-NBRAC210, AC305, AC88.2

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AcactivityACACTIVITYRequiredHST-ACTIVITY → ACV-ACTIVITY

Programs

Updated by (34)

Referenced by (2)