ACRESHIST – No description in the Lawson data dictionary

System: Activity Management (AC)
Prefix: RSH
Primary key: FIELD-ID, SEQ-NUMBER
Fields: 16
Updated by: 9 programs
Referenced by: 3 programs

ACRESHIST is a Lawson Activity Management table (prefix RSH); no description in the lawson data dictionary. It is indexed by FIELD-ID, SEQ-NUMBER (RSHSET1); alternate indexes: RSHSET2, RSHSET3 and RSHSET4. It is related 1:1 to ACACTGRP, ACACTIVITY and ACASSIGN. It is updated by AC00.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 and 1 more and referenced by AC200, AC203 and AC210. The table has 16 fields, 4 indexes and 3 documented relations.

About ACRESHIST

No description in the Lawson data dictionary.

Fields (16)

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

Field / column	Type	Description & values	Updated by
`RSH-ACTIVITY-GRP` ACTIVITY_GRP	Alpha 15	—	AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7
`RSH-ACTIVITY` ACTIVITY	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7
`RSH-RESOURCE-TYPE` RESOURCE_TYPE	Alpha 1	The type of resource. Valid values include: P - AC Person Q - Equipment E - Employee V - Vendor A - Asset	AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7
`RSH-RESOURCE-CODE` RESOURCE_CODE	Alpha 10	The code identifying the resource assigned to the activity or activity group.	AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7
`RSH-COMPANY` COMPANY	Numeric 4	Identifies 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.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7
`RSH-ROLE` ROLE	Alpha 12	The code that identifies a role that a resource has in relation to activities.	AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7
`RSH-FIELD-ID` PK FIELD_ID	Numeric 3	—	AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7
`RSH-SEQ-NUMBER` PK SEQ_NUMBER	Numeric 6	A unique number assigned to each transaction to be interfaced into the Lawson system.	AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7
`RSH-ALPHA-IMAGE` ALPHA_IMAGE	Alpha 30	—	—
`RSH-NUMERIC-IMAGE` NUMERIC_IMAGE	Signed 15.5	—	—
`RSH-BDATE-IMAGE` BDATE_IMAGE	Numeric 8 (yyyymmdd)	—	—
`RSH-EDATE-IMAGE` EDATE_IMAGE	Numeric 8 (yyyymmdd)	—	—
`RSH-OPERATOR` OPERATOR	Alpha 10	This field is used to store the login id of the person who entered the record.	AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7
`RSH-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7
`RSH-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7
`RSH-RECORD-TYPE` RECORD_TYPE	Alpha 1	This field identifies the type of record defined. Valid values are: `S` Summary `D` Detail	AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7

Indexes (4)

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

Index	Keys	Flags	Used in
`RSHSET1`	`FIELD-ID`, `SEQ-NUMBER*`	Primary	AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7
`RSHSET2`	`ACTIVITY-GRP`, `ACTIVITY`, `RESOURCE-TYPE`, `RESOURCE-CODE`, `COMPANY`, `ROLE`, `FIELD-ID`, `SEQ-NUMBER`	KeyChange	AC00.1, AC10.1, AC200, AC203, AC210, AC300
`RSHSET3`	`ACTIVITY-GRP`, `ACTIVITY`, `RESOURCE-TYPE`, `FIELD-ID`, `COMPANY`, `RESOURCE-CODE`, `SEQ-NUMBER`		—
`RSHSET4`	`ACTIVITY-GRP`, `RESOURCE-TYPE`, `FIELD-ID`, `COMPANY`, `RESOURCE-CODE`, `SEQ-NUMBER`		—

Relations

One to one (3) — lookups and parents

Relation	Table	Rules	Field map
Acactgrp	ACACTGRP	Required	`RSH-ACTIVITY-GRP` → `AGP-ACTIVITY-GRP (AGPSET1)`
Acactivity	ACACTIVITY	Required	`RSH-ACTIVITY` → `ACV-ACTIVITY`
Acassign	ACASSIGN	Required	`RSH-ACTIVITY-GRP` → `AAN-ACTIVITY-GRP`, `RSH-ACTIVITY` → `AAN-ACTIVITY`, `RSH-COMPANY` → `AAN-COMPANY`, `RSH-RESOURCE-TYPE` → `AAN-RESOURCE-TYPE`, `RSH-RESOURCE-CODE` → `AAN-RESOURCE-CODE`

Programs

Updated by (9)

AC00.1 Activity Group
AC03.2 AC Person Assignment
AC03.3 HR Employee Assignment
AC03.4 Vendor Assignment
AC03.5 Asset Assignment
AC03.6 Equipment Assignment
AC03.7 Role Assignment
AC10.1 Activity
AC300 Activity Group Purge

Referenced by (3)

AC200 Activity Grp Listing and Audit
AC203 Resource Assignment Listing
AC210 Activity Listing and Audit