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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#RSH-ACTIVITY-GRP SET2 SET3 SET4
ACTIVITY_GRP		Alpha 15—AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7
#RSH-ACTIVITY SET2 SET3
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.AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7
#RSH-RESOURCE-TYPE SET2 SET3 SET4
RESOURCE_TYPE		Alpha 1The type of resource. Valid values include: P - AC Person Q - Equipment E - Employee V - Vendor A - AssetAC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7
#RSH-RESOURCE-CODE SET2 SET3 SET4
RESOURCE_CODE		Alpha 10The 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 SET2 SET3 SET4
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.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7
#RSH-ROLE SET2
ROLE		Alpha 12The 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 6A 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 10This 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 1This 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 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
RSHSET1
  1. FIELD-ID
  2. SEQ-NUMBER ↓
PrimaryAC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7
RSHSET2
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. RESOURCE-TYPE
  4. RESOURCE-CODE
  5. COMPANY
  6. ROLE
  7. FIELD-ID
  8. SEQ-NUMBER
KeyChangeAC00.1, AC10.1, AC200, AC203, AC210, AC300
RSHSET3
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. RESOURCE-TYPE
  4. FIELD-ID
  5. COMPANY
  6. RESOURCE-CODE
  7. SEQ-NUMBER
—
RSHSET4
  1. ACTIVITY-GRP
  2. RESOURCE-TYPE
  3. FIELD-ID
  4. COMPANY
  5. RESOURCE-CODE
  6. SEQ-NUMBER
—

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AcactgrpACACTGRPRequired
RSH-ACTIVITY-GRP→AGP-ACTIVITY-GRP (AGPSET1)
AcactivityACACTIVITYRequired
RSH-ACTIVITY→ACV-ACTIVITY
AcassignACASSIGNRequired
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)

Referenced by (3)