Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACACRESRT


                             ACACRESRT FILE

Resource standard cost and billing rates can be established globally or can be
overridden by activity.  This  file  maintains resource rates by activity.
This file is updated by AC18  (Assigned Resource Rates). This file maintains
the header information including activity group, activity, resource type,
resource company and resoure.  The detail file ACACRESRTX file maintains the
cost and bill rates by effective date and currency.

REFERENCED BY

AC03.2    AC03.3    AC03.4    AC03.5    AC03.6    AC190
AC218     AC40.1    AC40.4    AC41.1    AC41.4    AC42.1
AC46.1    AC54.1    AC540     ACAC.1    BR190     BR20.6
BR40.3    BR43.1    BR46.1    BR46.2    BR46.4    ET530
ET540

UPDATED BY

AC110     AC18.1    AC18.2    AC18.3    AC18.4    AC18.5
AC300     AC310     AC500     AC520     PW110     PW510


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CRR-ACTIVITY-GRP       Alpha 15                                  AC110   AC18.1
Element: Activity GroupThe activity group is the overall         AC18.2  AC18.3
                       project.                                  AC18.4  AC18.5
                                                                 AC500   AC520
                                                                 PW110   PW510

CRR-ACTIVITY           Alpha 15                                  AC110   AC18.1
Element: Activity      Activities are the processes or           AC18.2  AC18.3
                       procedures that produce work. Cost        AC18.4  AC18.5
                       objects (products, services, customers,   AC500   AC520
                       and so on) are the reasons for            PW110   PW510
                       performing the activity.


CRR-RESOURCE-TYPE      Alpha 1                                   AC110   AC18.1
Element: Resource Type The type of resource.  Valid values       AC18.2  AC18.3
                       include:                                  AC18.4  AC18.5
                       P - AC Person                             AC500   AC520
                       Q - Equipment                             PW110   PW510
                       E - Employee
                       V - Vendor
                       A - Asset
                       P = Person
                       E = Employee
                       V = Vendor
                       Q = Equipment
                       A = Asset

CRR-RESOURCE-CODE      Alpha 10                                  AC110   AC18.1
Element: Resource Code The code identifying the resource         AC18.2  AC18.3
                       assigned to the activity or activity      AC18.4  AC18.5
                       group.                                    AC500   AC520
                                                                 PW110   PW510

CRR-EMPLOYEE-ASSET     Numeric 10                                AC110   AC18.2
Element: Employee AssetThe asset number contains up to ten       AC18.4  AC500
                       numeric characters that uniquely          AC520   PW110
                       identify an asset. Assets are             PW510
                       automatically numbered system-wide.

CRR-COMPANY            Numeric 4                                 AC110   AC18.2
Element: Company       Identifies the AP company if the          AC18.3  AC500
                       resource type = V.  Identifies the HR     AC520   PW110
                       company if the resource type = E.  It is  PW510
                       blank for type A, P or Q resources.

                         ACACRESRT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CRRSET1   ACTIVITY-GRP                                           AC03.2  AC03.3
          ACTIVITY                                               AC03.4  AC03.5
          RESOURCE-TYPE                                          AC03.6  AC110
          RESOURCE-CODE                                          AC18.5  AC190
          COMPANY                                                AC218   AC300
                                                                 AC310   AC40.1
                                                                 AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC46.1  AC500
                                                                 AC520   AC54.1
                                                                 AC540   ACAC.1
                                                                 BR190   BR20.6
                                                                 BR40.3  BR43.1
                                                                 BR46.1  BR46.2
                                                                 BR46.4  ET530
                                                                 ...

CRRSET2   RESOURCE-TYPE                                          AC18.1  AC18.2
          ACTIVITY-GRP                                           AC18.3  AC18.4
          ACTIVITY                                               AC18.5
          RESOURCE-CODE
          COMPANY

                         ACACRESRT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacresrtx     ACACRESRTX

                            CRR-ACTIVITY-GRP     -> CRX-ACTIVITY-GRP
                            CRR-ACTIVITY         -> CRX-ACTIVITY
                            CRR-RESOURCE-TYPE    -> CRX-RESOURCE-TYPE
                            CRR-RESOURCE-CODE    -> CRX-RESOURCE-CODE
                            CRR-COMPANY          -> CRX-COMPANY
                                                    CRX-EFFECTIVE-DATE