Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACRESHIST


                             ACRESHIST FILE

REFERENCED BY

AC200     AC203     AC210

UPDATED BY

AC03.2    AC03.3    AC03.4    AC03.5    AC03.6    AC03.7
AC300     AC310     AC00.1    AC10.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RSH-ACTIVITY-GRP       Alpha 15                                  AC03.2  AC03.3
Element: Group                                                   AC03.4  AC03.5
                                                                 AC03.6  AC03.7

RSH-ACTIVITY           Alpha 15                                  AC03.2  AC03.3
Element: Activity      Activities are the processes or           AC03.4  AC03.5
                       procedures that produce work. Cost        AC03.6  AC03.7
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


RSH-RESOURCE-TYPE      Alpha 1                                   AC03.2  AC03.3
Element: Resource Type The type of resource.  Valid values       AC03.4  AC03.5
                       include:                                  AC03.6  AC03.7
                       P - AC Person
                       Q - Equipment
                       E - Employee
                       V - Vendor
                       A - Asset

RSH-RESOURCE-CODE      Alpha 10                                  AC03.2  AC03.3
Element: Resource Code The code identifying the resource         AC03.4  AC03.5
                       assigned to the activity or activity      AC03.6  AC03.7
                       group.

RSH-COMPANY            Numeric 4                                 AC03.2  AC03.3
Element: Company       Identifies the AP company if the          AC03.4  AC03.5
                       resource type = V.  Identifies the HR     AC03.6  AC03.7
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

RSH-ROLE               Alpha 12                                  AC03.2  AC03.3
Element: Role          The code that identifies a role that a    AC03.4  AC03.5
                       resource has in relation to activities.   AC03.6  AC03.7

RSH-FIELD-ID           Numeric 3                                 AC03.2  AC03.3
Element: Field Id                                                AC03.4  AC03.5
                                                                 AC03.6  AC03.7

RSH-SEQ-NUMBER         Numeric 6                                 AC03.2  AC03.3
Element: Seq Number    A unique number assigned to each          AC03.4  AC03.5
                       transaction to be interfaced into the     AC03.6  AC03.7
                       Lawson system.

RSH-ALPHA-IMAGE        Alpha 30
Element: Alpha Image

RSH-NUMERIC-IMAGE      Signed 15.5
Element: Numeric Image

RSH-BDATE-IMAGE        Numeric 8  (yyyymmdd)
Element: Bdate Image

RSH-EDATE-IMAGE        Numeric 8  (yyyymmdd)
Element: Edate Image

RSH-OPERATOR           Alpha 10                                  AC03.2  AC03.3
Element: Operator      This field is used to store the login     AC03.4  AC03.5
                       id of the person who entered the record.  AC03.6  AC03.7


RSH-DATE-STAMP         Numeric 8  (yyyymmdd)                     AC03.2  AC03.3
Element: Date Stamp    This field contains the server date       AC03.4  AC03.5
                       (month, date, and year) of the last       AC03.6  AC03.7
                       change to this record.

RSH-TIME-STAMP         Numeric 6  (hhmmss)                       AC03.2  AC03.3
Element: Time Stamp    Contains the server time (hour, minute,   AC03.4  AC03.5
                       and second) when the record was last      AC03.6  AC03.7
                       changed.

RSH-RECORD-TYPE        Alpha 1                                   AC03.2  AC03.3
Element: Record Type   This field identifies the type of         AC03.4  AC03.5
                       record defined.                           AC03.6  AC03.7

                       Valid values are:
                       S = Summary
                       D = Detail

                         ACRESHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RSHSET1   FIELD-ID                                               AC03.2  AC03.3
          SEQ-NUMBER*                                            AC03.4  AC03.5
                                                                 AC03.6  AC03.7

RSHSET2   ACTIVITY-GRP  KeyChange                                AC00.1  AC10.1
          ACTIVITY                                               AC200   AC203
          RESOURCE-TYPE                                          AC210   AC300
          RESOURCE-CODE                                          AC310
          COMPANY
          ROLE
          FIELD-ID
          SEQ-NUMBER

RSHSET3   ACTIVITY-GRP
          ACTIVITY
          RESOURCE-TYPE
          FIELD-ID
          COMPANY
          RESOURCE-CODE
          SEQ-NUMBER

RSHSET4   ACTIVITY-GRP
          RESOURCE-TYPE
          FIELD-ID
          COMPANY
          RESOURCE-CODE
          SEQ-NUMBER

                         ACRESHIST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactgrp       ACACTGRP     Required

                            RSH-ACTIVITY-GRP     -> AGP-ACTIVITY-GRP  (AGPSET1)

Acactivity     ACACTIVITY   Required

                            RSH-ACTIVITY         -> ACV-ACTIVITY

Acassign       ACASSIGN     Required

                            RSH-ACTIVITY-GRP     -> AAN-ACTIVITY-GRP
                            RSH-ACTIVITY         -> AAN-ACTIVITY
                            RSH-COMPANY          -> AAN-COMPANY
                            RSH-RESOURCE-TYPE    -> AAN-RESOURCE-TYPE
                            RSH-RESOURCE-CODE    -> AAN-RESOURCE-CODE