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 AC190
AC40.1 AC40.4 AC41.1 AC41.4 AC42.1 AC46.1
AC54.1 AC540 ACAC.1 BR190 BR20.6 BR40.3
BR43.1 BR44.1 BR46.1 BR46.2 BR46.4


UPDATED BY
AC110 AC18.1 AC18.2 AC18.3 AC18.4 AC18.5
AC218 AC300 AC500 AC520

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CRR-ACTIVITY-GRP
Element: Activity Group
Alpha 15
The activity group is the overall project.
AC110 AC18.1
AC18.2 AC18.3
AC18.4 AC18.5
AC500 AC520
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.
AC110 AC18.1
AC18.2 AC18.3
AC18.4 AC18.5
AC500 AC520
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
AC110 AC18.1
AC18.2 AC18.3
AC18.4 AC18.5
AC500 AC520
CRR-RESOURCE-CODE
Element: Resource Code
Alpha 10
The code identifying the resource assigned to the activity or activity group.
AC110 AC18.1
AC18.2 AC18.3
AC18.4 AC18.5
AC500 AC520
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.
AC110 AC18.2
AC18.4 AC500
AC520
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.
AC110 AC18.2
AC18.3 AC500
AC520


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 AC110
AC18.5 AC190
AC218 AC300
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC46.1
AC500 AC520
AC54.1 AC540
ACAC.1 BR190
BR20.6 BR40.3
BR43.1 BR44.1
BR46.1 BR46.2
BR46.4
CRRSET2 RESOURCE-TYPE
ACTIVITY-GRP
ACTIVITY
RESOURCE-CODE
COMPANY
AC18.1 AC18.2
AC18.3 AC18.4
AC18.5


ACACRESRT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acacresrtx ACACRESRTX
CRR-ACTIVITY-GRP->CRX-ACTIVITY-GRP
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: Thu Jun 09 11:03:35 2016

Home
Contact Us



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