ACRESRT – No description in the Lawson data dictionary

System
Activity Management (AC)
Prefix
RRT
Primary key
RESOURCE-TYPE, RESOURCE-CODE, COMPANY
Fields
4
Updated by
5 programs
Referenced by
19 programs

ACRESRT is a Lawson Activity Management table (prefix RRT); no description in the lawson data dictionary. It is indexed by RESOURCE-TYPE, RESOURCE-CODE, COMPANY (RRTSET1). It is updated by AC17.2, AC17.3, AC17.4, AC17.5 and AC17.6 and referenced by AC190, AC217, AC40.1, AC40.4, AC41.1, AC41.4, AC42.1, AC46.1 and 11 more. The table has 4 fields, 1 index and 0 documented relations.

About ACRESRT

No description in the Lawson data dictionary.

Fields (4)

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

Field / columnTypeDescription & valuesUpdated by
RRT-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
AC17.2, AC17.3, AC17.4, AC17.5, AC17.6
RRT-RESOURCE-CODE PK
RESOURCE_CODE		Alpha 10The code identifying the resource assigned to the activity or activity group.AC17.2, AC17.3, AC17.4, AC17.5, AC17.6
RRT-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.AC17.3, AC17.4
RRT-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.AC17.3, AC17.5

Indexes (1)

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

IndexKeysFlagsConditionUsed in
RRTSET1RESOURCE-TYPE, RESOURCE-CODE, COMPANYPrimaryAC17.2, AC17.3, AC17.4, AC17.5, AC17.6, AC190, AC217, AC40.1 +16 more

Programs

Updated by (5)

Referenced by (19)