|
|
ACACRESRTX 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 detail information including activity group,
activity, resource type, resource company, resource, effective date,
currency, standard cost rate, billable rate, unit of measure and status.
REFERENCED BY
AC218 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 BR46.1 BR46.2 BR46.4
UPDATED BY
AC110 AC18.1 AC18.2 AC18.3 AC18.4 AC18.5
AC300 AC310 AC500 AC520
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CRX-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
CRX-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
performing the activity.
CRX-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
E - Employee
V - Vendor
A - Asset
P = Person
E = Employee
V = Vendor
Q = Equipment
A = Asset
CRX-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
CRX-EMPLOYEE-ASSET Numeric 10 AC110 AC18.2
Element: Employee Asset AC18.4 AC500
AC520
CRX-EFFECTIVE-DATE Numeric 8 (yyyymmdd) AC110 AC18.1
Element: Effective DateThe date a vendor's prices will be in AC18.2 AC18.3
effect. AC18.4 AC18.5
AC500 AC520
CRX-STD-RATE Signed 13.5 AC110 AC18.1
Element: Standard Rate AC18.2 AC18.3
AC18.4 AC18.5
AC500 AC520
CRX-UNIT-MEASURE Alpha 12 AC110 AC18.1
Element: Unit Measure AC18.2 AC18.3
AC18.4 AC18.5
AC500 AC520
CRX-CURRENCY-CODE Alpha 5 AC110 AC18.1
Element: Currency Code This field contains the company base AC18.2 AC18.3
currency code established in Company AC18.4 AC18.5
(GL10.1 ). AC500 AC520
CRX-BILL-RATE Signed 13.4 AC110 AC18.1
Element: Bill Rate The billing rate that is set up for a AC18.2 AC18.3
resource for a specific activity. AC18.4 AC18.5
AC500 AC520
CRX-ACTIVE-FLAG Alpha 1 AC110 AC18.1
Element: Active Flag The Active flag of the credit card AC18.2 AC18.3
type. AC18.4 AC18.5
A = Active AC500 AC520
I = Inactive
CRX-COMPANY Numeric 4 AC110 AC18.2
Element: Company Identifies the AP company if the AC18.3 AC500
resource type = V. Identifies the HR AC520
company if the resource type = E. It is
blank for type A, P or Q resources.
ACACRESRTX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CRXSET1 ACTIVITY-GRP AC110 AC18.1
ACTIVITY AC18.2 AC18.3
RESOURCE-TYPE AC18.4 AC18.5
RESOURCE-CODE AC218 AC300
COMPANY AC310 AC500
EFFECTIVE-DATE
CRXSET2 ACTIVE-FLAG KeyChange AC18.3 AC190
ACTIVITY-GRP AC40.1 AC40.4
ACTIVITY AC41.1 AC41.4
RESOURCE-TYPE AC42.1 AC46.1
RESOURCE-CODE AC54.1 AC540
COMPANY ACAC.1 BR190
EFFECTIVE-DATE* BR20.6 BR40.3
BR43.1 BR46.1
BR46.2 BR46.4
CRXSET3 RESOURCE-TYPE KeyChange
EMPLOYEE-ASSET
COMPANY
ACTIVITY-GRP
ACTIVITY
EFFECTIVE-DATE
RESOURCE-CODE
CRXSET4 RESOURCE-TYPE
RESOURCE-CODE
ACTIVITY-GRP
ACTIVITY
COMPANY
EFFECTIVE-DATE
ACACRESRTX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactgrp ACACTGRP Required
CRX-ACTIVITY-GRP -> AGP-ACTIVITY-GRP (AGPSET1)
Acactivity ACACTIVITY Required
CRX-ACTIVITY -> ACV-ACTIVITY
Acresource ACRESOURCE Required
CRX-RESOURCE-CODE -> RSC-RESOURCE-CODE
CRX-RESOURCE-TYPE -> RSC-RESOURCE-TYPE
Employee EMPLOYEE Required
CRX-COMPANY -> EMP-COMPANY
CRX-EMPLOYEE-ASSET -> EMP-EMPLOYEE
|
