ACACRESRTX

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.
UPDATED BY
AC110 AC18.1 AC18.2 AC18.3 AC18.4 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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CRX-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
CRX-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
CRX-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
CRX-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
CRX-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
CRX-EFFECTIVE-DATE
Element: Effective Date
Numeric 8 (yyyymmdd)
The date a vendor's prices will be in effect.
AC110 AC18.1
AC18.2 AC18.3
AC18.4 AC18.5
AC500 AC520
CRX-STD-RATE
Element: Standard Rate
Signed 13.5
AC110 AC18.1
AC18.2 AC18.3
AC18.4 AC18.5
AC500 AC520
CRX-UNIT-MEASURE
Element: Unit Measure
Alpha 12
AC110 AC18.1
AC18.2 AC18.3
AC18.4 AC18.5
AC500 AC520
CRX-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
AC110 AC18.1
AC18.2 AC18.3
AC18.4 AC18.5
AC500 AC520
CRX-BILL-RATE
Element: Bill Rate
Signed 13.4
The billing rate that is set up for a resource for a specific activity.
AC110 AC18.1
AC18.2 AC18.3
AC18.4 AC18.5
AC500 AC520
CRX-ACTIVE-FLAG
Element: Active Flag
Alpha 1
The Active flag of the credit card type.
A = Active
I = Inactive
AC110 AC18.1
AC18.2 AC18.3
AC18.4 AC18.5
AC500 AC520
CRX-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


ACACRESRTX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CRXSET1 ACTIVITY-GRP
ACTIVITY
RESOURCE-TYPE
RESOURCE-CODE
COMPANY
EFFECTIVE-DATE
AC110 AC18.1
AC18.2 AC18.3
AC18.4 AC18.5
AC218 AC300
AC500
CRXSET2 ACTIVE-FLAG
ACTIVITY-GRP
ACTIVITY
RESOURCE-TYPE
RESOURCE-CODE
COMPANY
EFFECTIVE-DATE*
KeyChange
AC18.3 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
CRXSET3 RESOURCE-TYPE
EMPLOYEE-ASSET
COMPANY
ACTIVITY-GRP
ACTIVITY
EFFECTIVE-DATE
RESOURCE-CODE
KeyChange
CRXSET4 RESOURCE-TYPE
RESOURCE-CODE
ACTIVITY-GRP
ACTIVITY
COMPANY
EFFECTIVE-DATE


ACACRESRTX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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 Not Required
CRX-COMPANY->EMP-COMPANY
CRX-EMPLOYEE-ASSET->EMP-EMPLOYEE


File created: Thu Jun 09 11:03:35 2016

Home
Contact Us



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