Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACACRESRTX


                            ACACRESRTX 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 detail information including activity group,
 activity, resource type, resource company, resource, effective date,
currency, standard cost rate, billable rate, unit of measure and status.



REFERENCED BY

AC218     AC190     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

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CRX-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

CRX-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
                       performing the activity.


CRX-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
                       E - Employee
                       V - Vendor
                       A - Asset
                       P = Person
                       E = Employee
                       V = Vendor
                       Q = Equipment
                       A = Asset

CRX-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

CRX-EMPLOYEE-ASSET     Numeric 10                                AC110   AC18.2
Element: Employee Asset                                          AC18.4  AC500
                                                                 AC520

CRX-EFFECTIVE-DATE     Numeric 8  (yyyymmdd)                     AC110   AC18.1
Element: Effective DateThe date a vendor's prices will be in     AC18.2  AC18.3
                       effect.                                   AC18.4  AC18.5
                                                                 AC500   AC520

CRX-STD-RATE           Signed 13.5                               AC110   AC18.1
Element: Standard Rate                                           AC18.2  AC18.3
                                                                 AC18.4  AC18.5
                                                                 AC500   AC520

CRX-UNIT-MEASURE       Alpha 12                                  AC110   AC18.1
Element: Unit Measure                                            AC18.2  AC18.3
                                                                 AC18.4  AC18.5
                                                                 AC500   AC520

CRX-CURRENCY-CODE      Alpha 5                                   AC110   AC18.1
Element: Currency Code This field contains the company base      AC18.2  AC18.3
                       currency code established in Company      AC18.4  AC18.5
                       (GL10.1 ).                                AC500   AC520

CRX-BILL-RATE          Signed 13.4                               AC110   AC18.1
Element: Bill Rate     The billing rate that is set up for a     AC18.2  AC18.3
                       resource for a specific activity.         AC18.4  AC18.5
                                                                 AC500   AC520

CRX-ACTIVE-FLAG        Alpha 1                                   AC110   AC18.1
Element: Active Flag   The Active flag of the credit card        AC18.2  AC18.3
                       type.                                     AC18.4  AC18.5
                       A = Active                                AC500   AC520
                       I = Inactive

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

                         ACACRESRTX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CRXSET1   ACTIVITY-GRP                                           AC110   AC18.1
          ACTIVITY                                               AC18.2  AC18.3
          RESOURCE-TYPE                                          AC18.4  AC18.5
          RESOURCE-CODE                                          AC218   AC300
          COMPANY                                                AC310   AC500
          EFFECTIVE-DATE

CRXSET2   ACTIVE-FLAG   KeyChange                                AC18.3  AC190
          ACTIVITY-GRP                                           AC40.1  AC40.4
          ACTIVITY                                               AC41.1  AC41.4
          RESOURCE-TYPE                                          AC42.1  AC46.1
          RESOURCE-CODE                                          AC54.1  AC540
          COMPANY                                                ACAC.1  BR190
          EFFECTIVE-DATE*                                        BR20.6  BR40.3
                                                                 BR43.1  BR46.1
                                                                 BR46.2  BR46.4

CRXSET3   RESOURCE-TYPE KeyChange
          EMPLOYEE-ASSET
          COMPANY
          ACTIVITY-GRP
          ACTIVITY
          EFFECTIVE-DATE
          RESOURCE-CODE

CRXSET4   RESOURCE-TYPE
          RESOURCE-CODE
          ACTIVITY-GRP
          ACTIVITY
          COMPANY
          EFFECTIVE-DATE

                         ACACRESRTX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactgrp       ACACTGRP     Required

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

Acactivity     ACACTIVITY   Required

                            CRX-ACTIVITY          -> ACV-ACTIVITY

Acresource     ACRESOURCE   Required

                            CRX-RESOURCE-CODE     -> RSC-RESOURCE-CODE
                            CRX-RESOURCE-TYPE     -> RSC-RESOURCE-TYPE

Employee       EMPLOYEE     Required

                            CRX-COMPANY           -> EMP-COMPANY
                            CRX-EMPLOYEE-ASSET    -> EMP-EMPLOYEE