Lawson Insight Technical Documentation |
|
ACHISTORY
ACHISTORY FILE
REFERENCED BY
AC210
UPDATED BY
AC10.1 AC10.3 AC112 AC113 AC12.1 AC13.1
AC13.2 AC300 AC310 AC500 BR00.1 BR00.2
BR00.3 BR01.1 BR01.2 BR02.1 BR02.2 BR03.1
BR03.2 BR03.3 BR05.2 BR05.3 BR05.4 BR05.5
BR10.1 BR10.2 BR10.3 BR10.9 BR54.2 BR54.3
BR54.4 PW110
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HST-ACTIVITY Alpha 15 AC10.1 AC10.3
Element: Activity Activities are the processes or AC112 AC113
procedures that produce work. Cost AC12.1 AC13.1
objects (products, services, customers, AC13.2 AC500
and so on) are the reasons for BR00.1 BR00.2
performing the activity. BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4 PW110
HST-SEQ-NBR Numeric 4 AC10.1 AC10.3
Element: Seq Nbr An automatically assigned sequence AC112 AC113
number. AC12.1 AC13.1
AC13.2 AC500
BR00.1 BR00.2
BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4 PW110
HST-OPERATOR Alpha 10 AC10.1 AC10.3
Element: Operator This field is used to store the login AC112 AC113
id of the person who entered the record. AC12.1 AC13.1
AC13.2 AC500
BR00.1 BR00.2
BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4 PW110
HST-DATE-STAMP Numeric 8 (yyyymmdd) AC10.1 AC10.3
Element: Date Stamp This field contains the server date AC112 AC113
(month, date, and year) of the last AC12.1 AC13.1
change to this record. AC13.2 AC500
BR00.1 BR00.2
BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4 PW110
HST-TIME-STAMP Numeric 6 (hhmmss) AC10.1 AC10.3
Element: Time Stamp Contains the server time (hour, minute, AC112 AC113
and second) when the record was last AC12.1 AC13.1
changed. AC13.2 AC500
BR00.1 BR00.2
BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4 PW110
HST-FIELD-ID Numeric 3 AC10.1 AC10.3
Element: Field Id 014 = Previous Begin Date AC112 AC113
015 = Previous End Date AC12.1 AC13.1
AC13.2 AC500
BR00.1 BR00.2
BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4 PW110
HST-ALPHA-IMAGE Alpha 30 AC10.1 AC10.3
Element: Alpha Image AC112 AC113
AC12.1 AC13.1
AC13.2 AC500
BR00.1 BR00.2
BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4 PW110
HST-NUMERIC-IMAGE Signed 18.5 AC10.1 AC10.3
Element: Intl Cost AC112 AC113
AC12.1 AC13.1
AC13.2 AC500
BR00.1 BR00.2
BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4 PW110
HST-DATE-IMAGE Numeric 8 (yyyymmdd) AC10.1 AC10.3
Element: Date Image AC112 AC113
AC12.1 AC13.1
AC13.2 AC500
BR00.1 BR00.2
BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4 PW110
ACHISTORY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HSTSET1 ACTIVITY AC10.1 AC10.3
DATE-STAMP AC112 AC113
SEQ-NBR* AC12.1 AC13.1
AC13.2 AC210
AC300 AC310
AC500 BR00.1
BR00.2 BR00.3
BR01.1 BR01.2
BR02.1 BR02.2
BR03.1 BR03.2
BR03.3 BR05.2
BR05.3 BR05.4
BR05.5 BR10.1
BR10.2 BR10.3
BR10.9 BR54.2
...
HSTSET2 ACTIVITY KeyChange
FIELD-ID
DATE-STAMP
SEQ-NBR*
ACHISTORY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Required
HST-ACTIVITY -> ACV-ACTIVITY (ACVSET1)
|