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
ACAC.1

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


ACACRESRTX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CRXSET1 ACTIVITY-GRP
ACTIVITY
RESOURCE-TYPE
RESOURCE-CODE
COMPANY
EFFECTIVE-DATE
CRXSET2 ACTIVE-FLAG
ACTIVITY-GRP
ACTIVITY
RESOURCE-TYPE
RESOURCE-CODE
COMPANY
EFFECTIVE-DATE*
KeyChange
ACAC.1
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: Wed Jun 08 20:46:51 2016

Home
Contact Us



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