ACRESHIST

REFERENCED BY
AC200 AC203 AC210


UPDATED BY
AC03.2 AC03.3 AC03.4 AC03.5 AC03.6 AC03.7
AC300 AC00.1 AC10.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RSH-ACTIVITY-GRP
Element: Group		Alpha 15
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6 AC03.7
RSH-ACTIVITY
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Field Id		Numeric 3
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6 AC03.7
RSH-SEQ-NUMBER
Element: 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
Element: Alpha Image		Alpha 30
RSH-NUMERIC-IMAGE
Element: Numeric Image		Signed 15.5
RSH-BDATE-IMAGE
Element: Bdate Image		Numeric 8 (yyyymmdd)
RSH-EDATE-IMAGE
Element: Edate Image		Numeric 8 (yyyymmdd)
RSH-OPERATOR
Element: 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
Element: 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
Element: 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
Element: 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


ACRESHIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RSHSET1 FIELD-ID
SEQ-NUMBER*
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


ACRESHIST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
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

File created: Thu Jun 09 02:03:12 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.