ACACRESRT – Resource Standard Cost

System
Activity Management (AC)
Prefix
CRR
Primary key
ACTIVITY-GRP, ACTIVITY, RESOURCE-TYPE, RESOURCE-CODE, COMPANY
Fields
6
Updated by
9 programs
Referenced by
24 programs

ACACRESRT is the Resource Standard Cost table in Lawson Activity Management (prefix CRR). It is indexed by ACTIVITY-GRP, ACTIVITY, RESOURCE-TYPE, RESOURCE-CODE, COMPANY (CRRSET1); alternate indexes: CRRSET2. It is related 1:M to ACACRESRTX. It is updated by AC110, AC18.1, AC18.2, AC18.3, AC18.4, AC18.5, AC300, AC500 and 1 more and referenced by AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC190, AC218, AC40.1 and 16 more. The table has 6 fields, 2 indexes and 1 documented relation.

About ACACRESRT

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.

Fields (6)

Column = COBOL field name without the CRR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
CRR-ACTIVITY-GRP PK
ACTIVITY_GRP		Alpha 15The activity group is the overall project.AC110, AC18.1, AC18.2, AC18.3, AC18.4, AC18.5, AC500, AC520
CRR-ACTIVITY PK
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.AC110, AC18.1, AC18.2, AC18.3, AC18.4, AC18.5, AC500, AC520
CRR-RESOURCE-TYPE PK
RESOURCE_TYPE		Alpha 1The type of resource. Valid values include: P - AC Person Q - Equipment E - Employee V - Vendor A - Asset
  • P Person
  • E Employee
  • V Vendor
  • Q Equipment
  • A Asset
AC110, AC18.1, AC18.2, AC18.3, AC18.4, AC18.5, AC500, AC520
CRR-RESOURCE-CODE PK
RESOURCE_CODE		Alpha 10The code identifying the resource assigned to the activity or activity group.AC110, AC18.1, AC18.2, AC18.3, AC18.4, AC18.5, AC500, AC520
CRR-EMPLOYEE-ASSET
EMPLOYEE_ASSET		Numeric 10The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.AC110, AC18.2, AC18.4, AC500, AC520
CRR-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AC110, AC18.2, AC18.3, AC500, AC520

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CRRSET1ACTIVITY-GRP, ACTIVITY, RESOURCE-TYPE, RESOURCE-CODE, COMPANYPrimaryAC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC110, AC18.5, AC190 +21 more
CRRSET2RESOURCE-TYPE, ACTIVITY-GRP, ACTIVITY, RESOURCE-CODE, COMPANYAC18.1, AC18.2, AC18.3, AC18.4, AC18.5

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
AcacresrtxACACRESRTXCRR-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

Programs

Updated by (9)

Referenced by (24)