ACACRESRTX – AC Resource Standard Cost Dtl

System
Activity Management (AC)
Prefix
CRX
Primary key
ACTIVITY-GRP, ACTIVITY, RESOURCE-TYPE, RESOURCE-CODE, COMPANY, EFFECTIVE-DATE
Fields
12
Updated by
9 programs
Referenced by
19 programs

ACACRESRTX is the AC Resource Standard Cost Dtl table in Lawson Activity Management (prefix CRX). It is indexed by ACTIVITY-GRP, ACTIVITY, RESOURCE-TYPE, RESOURCE-CODE, COMPANY, EFFECTIVE-DATE (CRXSET1); alternate indexes: CRXSET2, CRXSET3 and CRXSET4. It is related 1:1 to ACACTGRP, ACACTIVITY, ACRESOURCE and EMPLOYEE. It is updated by AC110, AC18.1, AC18.2, AC18.3, AC18.4, AC18.5, AC300, AC500 and 1 more and referenced by AC190, AC218, AC40.1, AC40.4, AC41.1, AC41.4, AC42.1, AC46.1 and 11 more. The table has 12 fields, 4 indexes and 4 documented relations.

About ACACRESRTX

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.

Fields (12)

Column = COBOL field name without the CRX- 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
#CRX-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
#CRX-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
#CRX-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
#CRX-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
#CRX-EMPLOYEE-ASSET SET3
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
#CRX-EFFECTIVE-DATE PK
EFFECTIVE_DATE		Numeric 8 (yyyymmdd)The date a vendor's prices will be in effect.AC110, AC18.1, AC18.2, AC18.3, AC18.4, AC18.5, AC500, AC520
#CRX-STD-RATE
STD_RATE		Signed 13.5—AC110, AC18.1, AC18.2, AC18.3, AC18.4, AC18.5, AC500, AC520
#CRX-UNIT-MEASURE
UNIT_MEASURE		Alpha 12—AC110, AC18.1, AC18.2, AC18.3, AC18.4, AC18.5, AC500, AC520
#CRX-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).AC110, AC18.1, AC18.2, AC18.3, AC18.4, AC18.5, AC500, AC520
#CRX-BILL-RATE
BILL_RATE		Signed 13.4The billing rate that is set up for a resource for a specific activity.AC110, AC18.1, AC18.2, AC18.3, AC18.4, AC18.5, AC500, AC520
#CRX-ACTIVE-FLAG SET2
ACTIVE_FLAG		Alpha 1The Active flag of the credit card type.
  • A Active
  • I Inactive
AC110, AC18.1, AC18.2, AC18.3, AC18.4, AC18.5, AC500, AC520
#CRX-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 (4)

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
CRXSET1
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. RESOURCE-TYPE
  4. RESOURCE-CODE
  5. COMPANY
  6. EFFECTIVE-DATE
PrimaryAC110, AC18.1, AC18.2, AC18.3, AC18.4, AC18.5, AC218, AC300 +1 more
CRXSET2
  1. ACTIVE-FLAG
  2. ACTIVITY-GRP
  3. ACTIVITY
  4. RESOURCE-TYPE
  5. RESOURCE-CODE
  6. COMPANY
  7. EFFECTIVE-DATE ↓
KeyChangeAC18.3, AC190, AC40.1, AC40.4, AC41.1, AC41.4, AC42.1, AC46.1 +11 more
CRXSET3
  1. RESOURCE-TYPE
  2. EMPLOYEE-ASSET
  3. COMPANY
  4. ACTIVITY-GRP
  5. ACTIVITY
  6. EFFECTIVE-DATE
  7. RESOURCE-CODE
KeyChange—
CRXSET4
  1. RESOURCE-TYPE
  2. RESOURCE-CODE
  3. ACTIVITY-GRP
  4. ACTIVITY
  5. COMPANY
  6. EFFECTIVE-DATE
—

Relations

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

One to one (4) — lookups and parents

RelationTableRulesConditionField map
AcactgrpACACTGRPRequired
CRX-ACTIVITY-GRP→AGP-ACTIVITY-GRP (AGPSET1)
AcactivityACACTIVITYRequired
CRX-ACTIVITY→ACV-ACTIVITY
AcresourceACRESOURCERequired
CRX-RESOURCE-CODE→RSC-RESOURCE-CODE
CRX-RESOURCE-TYPE→RSC-RESOURCE-TYPE
EmployeeEMPLOYEENot Required
CRX-COMPANY→EMP-COMPANY
CRX-EMPLOYEE-ASSET→EMP-EMPLOYEE

Programs

Updated by (9)

Referenced by (19)