Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ACHISTORY FILE

REFERENCED BY

AC200     AC210

UPDATED BY

AC10.1    AC10.3    AC13.1    AC13.2    AC300     AC310
BR00.1    BR00.2    BR00.3    BR01.1    BR01.2    BR01.3
BR02.1    BR02.2    BR03.1    BR03.2    BR03.3    BR05.1
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
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  BR01.3
                     performing the activity.                    BR02.1  BR02.2
                                                                 BR03.1  BR03.2
                                                                 BR03.3  BR05.1
                                                                 BR05.2  BR05.3
                                                                 BR05.4  BR05.5
                                                                 BR10.1  BR10.2
                                                                 BR10.3

HST-SEQ-NBR          Numeric 4                                   AC10.1  AC10.3
Sequence Number      An automatically assigned sequence          AC13.1  AC13.2
                     number.                                     BR00.1  BR00.2
                                                                 BR00.3  BR01.1
                                                                 BR01.2  BR01.3
                                                                 BR02.1  BR02.2
                                                                 BR03.1  BR03.2
                                                                 BR03.3  BR05.1
                                                                 BR05.2  BR05.3
                                                                 BR05.4  BR05.5
                                                                 BR10.1  BR10.2
                                                                 BR10.3

HST-OPERATOR         Alpha 10                                    AC10.1  AC10.3
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  BR01.3
                                                                 BR02.1  BR02.2
                                                                 BR03.1  BR03.2
                                                                 BR03.3  BR05.1
                                                                 BR05.2  BR05.3
                                                                 BR05.4  BR05.5
                                                                 BR10.1  BR10.2
                                                                 BR10.3

HST-DATE-STAMP       Numeric 8  (yyyymmdd)                       AC10.1  AC10.3
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  BR01.3
                                                                 BR02.1  BR02.2
                                                                 BR03.1  BR03.2
                                                                 BR03.3  BR05.1
                                                                 BR05.2  BR05.3
                                                                 BR05.4  BR05.5
                                                                 BR10.1  BR10.2
                                                                 BR10.3

HST-TIME-STAMP       Numeric 6  (hhmmss)                         AC10.1  AC10.3
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  BR01.3
                                                                 BR02.1  BR02.2
                                                                 BR03.1  BR03.2
                                                                 BR03.3  BR05.1
                                                                 BR05.2  BR05.3
                                                                 BR05.4  BR05.5
                                                                 BR10.1  BR10.2
                                                                 BR10.3

HST-FIELD-ID         Numeric 3                                   AC10.1  AC10.3
Field ID                                                         AC13.1  AC13.2
                                                                 BR00.1  BR00.2
                                                                 BR00.3  BR01.1
                                                                 BR01.2  BR01.3
                                                                 BR02.1  BR02.2
                                                                 BR03.1  BR03.2
                                                                 BR03.3  BR05.1
                                                                 BR05.2  BR05.3
                                                                 BR05.4  BR05.5
                                                                 BR10.1  BR10.2
                                                                 BR10.3

HST-ALPHA-IMAGE      Alpha 30                                    AC10.1  AC10.3
Alpha Image                                                      AC13.1  AC13.2
                                                                 BR00.1  BR00.2
                                                                 BR00.3  BR01.1
                                                                 BR01.2  BR01.3
                                                                 BR02.1  BR02.2
                                                                 BR03.1  BR03.2
                                                                 BR03.3  BR05.1
                                                                 BR05.2  BR05.3
                                                                 BR05.4  BR05.5
                                                                 BR10.1  BR10.2
                                                                 BR10.3

HST-NUMERIC-IMAGE    Signed 15.5                                 AC10.1  AC10.3
Numeric Image                                                    AC13.1  AC13.2
                                                                 BR00.1  BR00.2
                                                                 BR00.3  BR01.1
                                                                 BR01.2  BR01.3
                                                                 BR02.1  BR02.2
                                                                 BR03.1  BR03.2
                                                                 BR03.3  BR05.1
                                                                 BR05.2  BR05.3
                                                                 BR05.4  BR05.5
                                                                 BR10.1  BR10.2
                                                                 BR10.3

HST-DATE-IMAGE       Numeric 8  (yyyymmdd)                       AC10.1  AC10.3
Date Image                                                       AC13.1  AC13.2
                                                                 BR00.1  BR00.2
                                                                 BR00.3  BR01.1
                                                                 BR01.2  BR01.3
                                                                 BR02.1  BR02.2
                                                                 BR03.1  BR03.2
                                                                 BR03.3  BR05.1
                                                                 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*                                               AC200   AC210
                                                                 AC300   AC310
                                                                 BR00.1  BR00.2
                                                                 BR00.3  BR01.1
                                                                 BR01.2  BR01.3
                                                                 BR02.1  BR02.2
                                                                 BR03.1  BR03.2
                                                                 BR03.3  BR05.1
                                                                 BR05.2  BR05.3
                                                                 BR05.4  BR05.5
                                                                 BR10.1  BR10.2
                                                                 BR10.3