Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACHISTORY


                             ACHISTORY FILE

REFERENCED BY

AC200     AC210

UPDATED BY

AC10.1    AC10.3    AC112     AC12.1    AC13.1    AC13.2
AC300     AC310     AC500     BR00.1    BR00.2    BR00.3
BR01.1    BR01.2    BR01.3    BR02.1    BR02.2    BR03.1
BR03.2    BR03.3    BR05.2    BR05.3    BR05.4    BR05.5
BR10.1    BR10.2    BR10.3    BR15.1    BR15.2    BR54.2
BR54.3    BR54.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HST-ACTIVITY           Alpha 15                                  AC10.1  AC10.3
Element: Activity      Activities are the processes or           AC112   AC12.1
                       procedures that produce work. Cost        AC13.1  AC13.2
                       objects (products, services, customers,   AC500   BR00.1
                       and so on) are the reasons for            BR00.2  BR00.3
                       performing the activity.                  BR01.1  BR01.2
                                                                 BR01.3  BR02.1
                                                                 BR02.2  BR03.1
                                                                 BR03.2  BR03.3
                                                                 BR05.2  BR05.3
                                                                 BR05.4  BR05.5
                                                                 BR10.1  BR10.2
                                                                 BR10.3  BR15.1
                                                                 BR15.2  BR54.2
                                                                 BR54.3  BR54.4

HST-SEQ-NBR            Numeric 4                                 AC10.1  AC10.3
Element: Sequence NumbeAn automatically assigned sequence        AC112   AC12.1
                       number.                                   AC13.1  AC13.2
                                                                 AC500   BR00.1
                                                                 BR00.2  BR00.3
                                                                 BR01.1  BR01.2
                                                                 BR01.3  BR02.1
                                                                 BR02.2  BR03.1
                                                                 BR03.2  BR03.3
                                                                 BR05.2  BR05.3
                                                                 BR05.4  BR05.5
                                                                 BR10.1  BR10.2
                                                                 BR10.3  BR15.1
                                                                 BR15.2  BR54.2
                                                                 BR54.3  BR54.4

HST-OPERATOR           Alpha 10                                  AC10.1  AC10.3
Element: Operator Code This field is used to store the login     AC112   AC12.1
                       id of the person who entered the record.  AC13.1  AC13.2
                                                                 AC500   BR00.1
                                                                 BR00.2  BR00.3
                                                                 BR01.1  BR01.2
                                                                 BR01.3  BR02.1
                                                                 BR02.2  BR03.1
                                                                 BR03.2  BR03.3
                                                                 BR05.2  BR05.3
                                                                 BR05.4  BR05.5
                                                                 BR10.1  BR10.2
                                                                 BR10.3  BR15.1
                                                                 BR15.2  BR54.2
                                                                 BR54.3  BR54.4

HST-DATE-STAMP         Numeric 8  (yyyymmdd)                     AC10.1  AC10.3
Element: Date Stamp    This field contains the server date       AC112   AC12.1
                       (month, date, and year) of the last       AC13.1  AC13.2
                       change to this record.                    AC500   BR00.1
                                                                 BR00.2  BR00.3
                                                                 BR01.1  BR01.2
                                                                 BR01.3  BR02.1
                                                                 BR02.2  BR03.1
                                                                 BR03.2  BR03.3
                                                                 BR05.2  BR05.3
                                                                 BR05.4  BR05.5
                                                                 BR10.1  BR10.2
                                                                 BR10.3  BR15.1
                                                                 BR15.2  BR54.2
                                                                 BR54.3  BR54.4

HST-TIME-STAMP         Numeric 6  (hhmmss)                       AC10.1  AC10.3
Element: Time Stamp    Contains the server time (hour, minute,   AC112   AC12.1
                       and second) when the record was last      AC13.1  AC13.2
                       changed.                                  AC500   BR00.1
                                                                 BR00.2  BR00.3
                                                                 BR01.1  BR01.2
                                                                 BR01.3  BR02.1
                                                                 BR02.2  BR03.1
                                                                 BR03.2  BR03.3
                                                                 BR05.2  BR05.3
                                                                 BR05.4  BR05.5
                                                                 BR10.1  BR10.2
                                                                 BR10.3  BR15.1
                                                                 BR15.2  BR54.2
                                                                 BR54.3  BR54.4

HST-FIELD-ID           Numeric 3                                 AC10.1  AC10.3
Element: Field ID                                                AC112   AC12.1
                                                                 AC13.1  AC13.2
                                                                 AC500   BR00.1
                                                                 BR00.2  BR00.3
                                                                 BR01.1  BR01.2
                                                                 BR01.3  BR02.1
                                                                 BR02.2  BR03.1
                                                                 BR03.2  BR03.3
                                                                 BR05.2  BR05.3
                                                                 BR05.4  BR05.5
                                                                 BR10.1  BR10.2
                                                                 BR10.3  BR15.1
                                                                 BR15.2  BR54.2
                                                                 BR54.3  BR54.4

HST-ALPHA-IMAGE        Alpha 30                                  AC10.1  AC10.3
Element: Alpha Image                                             AC112   AC12.1
                                                                 AC13.1  AC13.2
                                                                 AC500   BR00.1
                                                                 BR00.2  BR00.3
                                                                 BR01.1  BR01.2
                                                                 BR01.3  BR02.1
                                                                 BR02.2  BR03.1
                                                                 BR03.2  BR03.3
                                                                 BR05.2  BR05.3
                                                                 BR05.4  BR05.5
                                                                 BR10.1  BR10.2
                                                                 BR10.3  BR15.1
                                                                 BR15.2  BR54.2
                                                                 BR54.3  BR54.4

HST-NUMERIC-IMAGE      Signed 15.5                               AC10.1  AC10.3
Element: Numeric Image                                           AC112   AC12.1
                                                                 AC13.1  AC13.2
                                                                 AC500   BR00.1
                                                                 BR00.2  BR00.3
                                                                 BR01.1  BR01.2
                                                                 BR01.3  BR02.1
                                                                 BR02.2  BR03.1
                                                                 BR03.2  BR03.3
                                                                 BR05.2  BR05.3
                                                                 BR05.4  BR05.5
                                                                 BR10.1  BR10.2
                                                                 BR10.3  BR15.1
                                                                 BR15.2  BR54.2
                                                                 BR54.3  BR54.4

HST-DATE-IMAGE         Numeric 8  (yyyymmdd)                     AC10.1  AC10.3
Element: Date Image                                              AC112   AC12.1
                                                                 AC13.1  AC13.2
                                                                 AC500   BR00.1
                                                                 BR00.2  BR00.3
                                                                 BR01.1  BR01.2
                                                                 BR01.3  BR02.1
                                                                 BR02.2  BR03.1
                                                                 BR03.2  BR03.3
                                                                 BR05.2  BR05.3
                                                                 BR05.4  BR05.5
                                                                 BR10.1  BR10.2
                                                                 BR10.3  BR15.1
                                                                 BR15.2  BR54.2
                                                                 BR54.3  BR54.4

                         ACHISTORY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HSTSET1   ACTIVITY                                               AC10.1  AC10.3
          DATE-STAMP                                             AC112   AC12.1
          SEQ-NBR*                                               AC13.1  AC13.2
                                                                 AC200   AC210
                                                                 AC300   AC310
                                                                 AC500   BR00.1
                                                                 BR00.2  BR00.3
                                                                 BR01.1  BR01.2
                                                                 BR01.3  BR02.1
                                                                 BR02.2  BR03.1
                                                                 BR03.2  BR03.3
                                                                 BR05.2  BR05.3
                                                                 BR05.4  BR05.5
                                                                 BR10.1  BR10.2
                                                                 BR10.3  BR15.1
                                                                 ...