|
ACACRESRT FILE
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
AC218 AC40.1 AC40.4 AC41.1 AC41.4 AC42.1
AC46.1 AC54.1 AC540 ACAC.1 BR190 BR20.6
BR40.3 BR43.1 BR46.1 BR46.2 BR46.4 ET530
ET540
UPDATED BY
AC110 AC18.1 AC18.2 AC18.3 AC18.4 AC18.5
AC300 AC310 AC500 AC520 PW110 PW510
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CRR-ACTIVITY-GRP Alpha 15 AC110 AC18.1
Element: Activity GroupThe activity group is the overall AC18.2 AC18.3
project. AC18.4 AC18.5
AC500 AC520
PW110 PW510
CRR-ACTIVITY Alpha 15 AC110 AC18.1
Element: Activity Activities are the processes or AC18.2 AC18.3
procedures that produce work. Cost AC18.4 AC18.5
objects (products, services, customers, AC500 AC520
and so on) are the reasons for PW110 PW510
performing the activity.
CRR-RESOURCE-TYPE Alpha 1 AC110 AC18.1
Element: Resource Type The type of resource. Valid values AC18.2 AC18.3
include: AC18.4 AC18.5
P - AC Person AC500 AC520
Q - Equipment PW110 PW510
E - Employee
V - Vendor
A - Asset
P = Person
E = Employee
V = Vendor
Q = Equipment
A = Asset
CRR-RESOURCE-CODE Alpha 10 AC110 AC18.1
Element: Resource Code The code identifying the resource AC18.2 AC18.3
assigned to the activity or activity AC18.4 AC18.5
group. AC500 AC520
PW110 PW510
CRR-EMPLOYEE-ASSET Numeric 10 AC110 AC18.2
Element: Employee AssetThe asset number contains up to ten AC18.4 AC500
numeric characters that uniquely AC520 PW110
identify an asset. Assets are PW510
automatically numbered system-wide.
CRR-COMPANY Numeric 4 AC110 AC18.2
Element: Company Identifies the AP company if the AC18.3 AC500
resource type = V. Identifies the HR AC520 PW110
company if the resource type = E. It is PW510
blank for type A, P or Q resources.
ACACRESRT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CRRSET1 ACTIVITY-GRP AC03.2 AC03.3
ACTIVITY AC03.4 AC03.5
RESOURCE-TYPE AC03.6 AC110
RESOURCE-CODE AC18.5 AC190
COMPANY AC218 AC300
AC310 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
BR46.1 BR46.2
BR46.4 ET530
...
CRRSET2 RESOURCE-TYPE AC18.1 AC18.2
ACTIVITY-GRP AC18.3 AC18.4
ACTIVITY AC18.5
RESOURCE-CODE
COMPANY
ACACRESRT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|