ACRESHIST

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

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 AC210
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: Wed Jun 08 20:46:56 2016

Home
Contact Us



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