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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CRRSET1
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. RESOURCE-TYPE
  4. RESOURCE-CODE
  5. COMPANY
PrimaryAC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC110, AC18.5, AC190 +21 more
CRRSET2
  1. RESOURCE-TYPE
  2. ACTIVITY-GRP
  3. ACTIVITY
  4. RESOURCE-CODE
  5. COMPANY
AC18.1, AC18.2, AC18.3, AC18.4, AC18.5

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACRESRTXACACRESRT

One to many (1) — child tables

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

Programs

Updated by (9)

Referenced by (24)