ACRESOURCE – Activity Resource

System
Activity Management (AC)
Prefix
RSC
Primary key
RESOURCE-CODE, RESOURCE-TYPE
Fields
16
Updated by
2 programs
Referenced by
30 programs

ACRESOURCE is the Activity Resource table in Lawson Activity Management (prefix RSC). It is indexed by RESOURCE-CODE, RESOURCE-TYPE (RSCSET1); alternate indexes: RSCSET2. It is related 1:1 to ACRSRCBOD and 1:M to ACASSIGN and ACRESRTX. It is updated by AC03.1 and AC520 and referenced by AC145, AC17.2, AC17.6, AC18.1, AC18.5, AC210, AC217, AC218 and 22 more. The table has 16 fields, 2 indexes and 3 documented relations.

About ACRESOURCE

This file contains resource definition information from AC03.1 (Resource). It includes resource code, type, description, standard cost, resource class, as well as resource names, title, telephone number, and E-mail address.

Fields (16)

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

Field / columnTypeDescription & valuesUpdated by
RSC-RESOURCE-CODE PK
RESOURCE_CODE		Alpha 10Required key. This code identifies a personnel or equipment resource assigned to an activity. The resource must first be defined in HR11 (Employee) or AC03.1 (Resource).AC03.1, AC520
RSC-RESOURCE-TYPE PK
RESOURCE_TYPE		Alpha 1This is the resource type, indicating whether the resource is equipment or a person.
  • Q Equipment
  • P Person
AC03.1, AC520
RSC-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)Required. This is the description of the resource.AC03.1, AC217, AC218, AC520
RSC-LAST-NAME
LAST_NAME		Alpha 30 (Lower Case)Required. This is the last name of the personnel resource.AC03.1, AC217, AC218, AC520
RSC-FIRST-NAME
FIRST_NAME		Alpha 15 (Lower Case)Required. This is the first name of the personnel resource.AC03.1, AC217, AC218, AC520
RSC-MIDDLE-INIT
MIDDLE_INIT		Alpha 1Optional. This is the middle initial of the personnel resource.AC03.1, AC520
RSC-TITLE
TITLE		Alpha 30 (Lower Case)Optional. This is the title of the personnel resource.AC03.1, AC520
RSC-PHONE-COUNTRY
PHONE_COUNTRY		Alpha 6Optional. This is the prefix of the telephone number for the resource. For example, the country or city telephone code.AC03.1, AC520
RSC-PHONE
PHONE		Alpha 15This is the telephone number.AC03.1, AC520
RSC-PHONE-EXT
PHONE_EXT		Alpha 5Optional. This is the telephone extension for the resource.AC03.1, AC520
RSC-E-MAIL-ADDR
E_MAIL_ADDR		Alpha 60This is the E-mail address for the resource.AC03.1, AC520
RSC-COMPANY
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.AC03.1, AC520
RSC-ACCT-UNIT
ACCT_UNIT		Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.AC03.1, AC520
RSC-ACCOUNT
ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.AC03.1, AC520
RSC-SUB-ACCT
SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.AC03.1, AC520
RSC-ROLE
ROLE		Alpha 12The code that identifies a role that a resource has in relation to activities.AC03.1

Indexes (2)

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

IndexKeysFlagsConditionUsed in
RSCSET1RESOURCE-CODE, RESOURCE-TYPEPrimaryAC03.1, AC03.2, AC03.6, AC03.7, AC145, AC17.2, AC17.6, AC18.1 +22 more (list truncated in source)
RSCSET2LAST-NAME, FIRST-NAME, MIDDLE-INIT, RESOURCE-CODE, RESOURCE-TYPEKeyChangeAC03.1

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AcrsrcbodACRSRCBODNot Required, Delete CascadesRSC-RESOURCE-CODE → YAN-RESOURCE-CODE, RSC-RESOURCE-TYPE → YAN-RESOURCE-TYPE

One to many (2) — child tables

RelationTableRulesConditionField map
AcassignACASSIGNZeroes → AAN-COMPANY, RSC-RESOURCE-CODE → AAN-RESOURCE-CODE, RSC-RESOURCE-TYPE → AAN-RESOURCE-TYPE, → AAN-ACTIVITY-GRP, → AAN-ACTIVITY
AcresrtxACRESRTXRSC-RESOURCE-TYPE → RRX-RESOURCE-TYPE, RSC-RESOURCE-CODE → RRX-RESOURCE-CODE, → RRX-COMPANY, → RRX-EFFECTIVE-DATE

Programs

Updated by (2)

Referenced by (30)