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.

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
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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CRXSET1ACTIVITY-GRP, ACTIVITY, RESOURCE-TYPE, RESOURCE-CODE, COMPANY, EFFECTIVE-DATEPrimaryAC110, AC18.1, AC18.2, AC18.3, AC18.4, AC18.5, AC218, AC300 +1 more
CRXSET2ACTIVE-FLAG, ACTIVITY-GRP, ACTIVITY, RESOURCE-TYPE, RESOURCE-CODE, COMPANY, EFFECTIVE-DATE*KeyChangeAC18.3, AC190, AC40.1, AC40.4, AC41.1, AC41.4, AC42.1, AC46.1 +11 more
CRXSET3RESOURCE-TYPE, EMPLOYEE-ASSET, COMPANY, ACTIVITY-GRP, ACTIVITY, EFFECTIVE-DATE, RESOURCE-CODEKeyChange—
CRXSET4RESOURCE-TYPE, RESOURCE-CODE, ACTIVITY-GRP, ACTIVITY, COMPANY, EFFECTIVE-DATE—

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
AcactgrpACACTGRPRequiredCRX-ACTIVITY-GRP → AGP-ACTIVITY-GRP (AGPSET1)
AcactivityACACTIVITYRequiredCRX-ACTIVITY → ACV-ACTIVITY
AcresourceACRESOURCERequiredCRX-RESOURCE-CODE → RSC-RESOURCE-CODE, CRX-RESOURCE-TYPE → RSC-RESOURCE-TYPE
EmployeeEMPLOYEENot RequiredCRX-COMPANY → EMP-COMPANY, CRX-EMPLOYEE-ASSET → EMP-EMPLOYEE

Programs

Updated by (9)

Referenced by (19)