ACACRESRT

Resource standard cost and billing rates can be established globally or can be overridden by activity. This file maintains resource rates by activity. This file is updated by AC18 (Assigned Resource Rates). This file maintains the header information including activity group, activity, resource type, resource company and resoure. The detail file ACACRESRTX file maintains the cost and bill rates by effective date and currency.

REFERENCED BY
AC03.2 AC03.3 AC03.4 AC03.5 AC03.6 ACAC.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CRR-ACTIVITY-GRP
Element: Activity Group
Alpha 15
The activity group is the overall project.
CRR-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.
CRR-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
P = Person
E = Employee
V = Vendor
Q = Equipment
A = Asset
CRR-RESOURCE-CODE
Element: Resource Code
Alpha 10
The code identifying the resource assigned to the activity or activity group.
CRR-EMPLOYEE-ASSET
Element: Employee Asset
Numeric 10
The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.
CRR-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.


ACACRESRT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CRRSET1 ACTIVITY-GRP
ACTIVITY
RESOURCE-TYPE
RESOURCE-CODE
COMPANY
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6 ACAC.1
CRRSET2 RESOURCE-TYPE
ACTIVITY-GRP
ACTIVITY
RESOURCE-CODE
COMPANY


ACACRESRT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acacresrtx ACACRESRTX
CRR-ACTIVITY-GRP->CRX-ACTIVITY-GRP (CRXSET1)
CRR-ACTIVITY->CRX-ACTIVITY
CRR-RESOURCE-TYPE->CRX-RESOURCE-TYPE
CRR-RESOURCE-CODE->CRX-RESOURCE-CODE
CRR-COMPANY->CRX-COMPANY
  CRX-EFFECTIVE-DATE


File created: Wed Jun 08 20:46:51 2016

Home
Contact Us



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