|
|
ACRESHIST FILE
REFERENCED BY
AC200 AC203 AC210
UPDATED BY
AC03.2 AC03.3 AC03.4 AC03.5 AC03.6 AC03.7
AC300 AC310 AC00.1 AC10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RSH-ACTIVITY-GRP Alpha 15 AC03.2 AC03.3
Element: Group The activity group is the overall AC03.4 AC03.5
project. AC03.6 AC03.7
RSH-ACTIVITY Alpha 15 AC03.2 AC03.3
Element: Activity Activities are the processes or AC03.4 AC03.5
procedures that produce work. Cost AC03.6 AC03.7
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
RSH-RESOURCE-TYPE Alpha 1 AC03.2 AC03.3
Element: Resource Type The type of resource. Valid values AC03.4 AC03.5
include: AC03.6 AC03.7
P - AC Person
Q - Equipment
E - Employee
V - Vendor
A - Asset
RSH-RESOURCE-CODE Alpha 10 AC03.2 AC03.3
Element: Resource Code The code identifying the resource AC03.4 AC03.5
assigned to the activity or activity AC03.6 AC03.7
group.
RSH-COMPANY Numeric 4 AC03.2 AC03.3
Element: Company Identifies the AP company if the AC03.4 AC03.5
resource type = V. Identifies the HR AC03.6 AC03.7
company if the resource type = E. It is
blank for type A, P or Q resources.
RSH-ROLE Alpha 12 AC03.2 AC03.3
Element: Role The code that identifies a role that a AC03.4 AC03.5
resource has in relation to activities. AC03.6 AC03.7
RSH-FIELD-ID Numeric 3 AC03.2 AC03.3
Element: Field ID AC03.4 AC03.5
AC03.6 AC03.7
RSH-SEQ-NUMBER Numeric 6 AC03.2 AC03.3
Record Sequence A unique number assigned to each AC03.4 AC03.5
Number transaction to be interfaced into the AC03.6 AC03.7
Lawson system.
RSH-ALPHA-IMAGE Alpha 30
Element: Alpha Image
RSH-NUMERIC-IMAGE Signed 15.5
Element: Numeric Image
RSH-BDATE-IMAGE Numeric 8 (yyyymmdd)
Element: Bdate Image
RSH-EDATE-IMAGE Numeric 8 (yyyymmdd)
Element: Edate Image
RSH-OPERATOR Alpha 10 AC03.2 AC03.3
Element: Operator Code This field is used to store the login AC03.4 AC03.5
id of the person who entered the record. AC03.6 AC03.7
RSH-DATE-STAMP Numeric 8 (yyyymmdd) AC03.2 AC03.3
Element: Date Stamp This field contains the server date AC03.4 AC03.5
(month, date, and year) of the last AC03.6 AC03.7
change to this record.
RSH-TIME-STAMP Numeric 6 (hhmmss) AC03.2 AC03.3
Element: Time Stamp Contains the server time (hour, minute, AC03.4 AC03.5
and second) when the record was last AC03.6 AC03.7
changed.
RSH-RECORD-TYPE Alpha 1 AC03.2 AC03.3
Element: Record Type This field identifies the type of AC03.4 AC03.5
record defined. AC03.6 AC03.7
Valid values are:
S = Summary
D = Detail
ACRESHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RSHSET1 FIELD-ID AC03.2 AC03.3
SEQ-NUMBER* AC03.4 AC03.5
AC03.6 AC03.7
RSHSET2 ACTIVITY-GRP KeyChange AC00.1 AC10.1
ACTIVITY AC200 AC203
RESOURCE-TYPE AC210 AC300
RESOURCE-CODE AC310
COMPANY
ROLE
FIELD-ID
SEQ-NUMBER
RSHSET3 ACTIVITY-GRP Solely used to for drill downs
ACTIVITY providing role and resource assignment
RESOURCE-TYPE history.
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 RELATED
NAME 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
|
