Lawson Insight Technical Documentation |
|
ACHISTORY
ACHISTORY FILE
REFERENCED BY
AC210
UPDATED BY
AC10.1 AC10.3 AC13.1 AC13.2 AC300 AC310
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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HST-ACTIVITY Alpha 15 AC10.1 AC10.3
Element: Activity Activities are the processes or AC13.1 AC13.2
procedures that produce work. Cost BR00.1 BR00.2
objects (products, services, customers, BR00.3 BR01.1
and so on) are the reasons for BR01.2 BR02.1
performing the activity. BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3
HST-SEQ-NBR Numeric 4 AC10.1 AC10.3
Element: Sequence NumbeAn automatically assigned sequence AC13.1 AC13.2
number. 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
HST-OPERATOR Alpha 10 AC10.1 AC10.3
Element: Operator Code This field is used to store the login AC13.1 AC13.2
id of the person who entered the record. 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
HST-DATE-STAMP Numeric 8 (yyyymmdd) AC10.1 AC10.3
Element: Date Stamp This field contains the server date AC13.1 AC13.2
(month, date, and year) of the last BR00.1 BR00.2
change to this record. 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
HST-TIME-STAMP Numeric 6 (hhmmss) AC10.1 AC10.3
Element: Time Stamp Contains the server time (hour, minute, AC13.1 AC13.2
and second) when the record was last BR00.1 BR00.2
changed. 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
HST-FIELD-ID Numeric 3 AC10.1 AC10.3
Element: Field ID AC13.1 AC13.2
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
HST-ALPHA-IMAGE Alpha 30 AC10.1 AC10.3
Element: Alpha Image AC13.1 AC13.2
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
HST-NUMERIC-IMAGE Signed 18.5 AC10.1 AC10.3
Element: Intl Cost AC13.1 AC13.2
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
HST-DATE-IMAGE Numeric 8 (yyyymmdd) AC10.1 AC10.3
Element: Date Image AC13.1 AC13.2
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
ACHISTORY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HSTSET1 ACTIVITY AC10.1 AC10.3
DATE-STAMP AC13.1 AC13.2
SEQ-NBR* AC210 AC300
AC310 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
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)
|