AC Resource Standard Cost Dtl
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 | BR44.1 | BR46.1 | BR46.2 |
BR46.4 |
AC110 | AC18.1 | AC18.2 | AC18.3 | AC18.4 | AC18.5 |
AC300 | AC500 | AC520 |
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. |
|
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* |
|
| ||||||||||||||||||||||||||
CRXSET3 |
RESOURCE-TYPE EMPLOYEE-ASSET COMPANY ACTIVITY-GRP ACTIVITY EFFECTIVE-DATE RESOURCE-CODE |
|
|||||||||||||||||||||||||||
CRXSET4 |
RESOURCE-TYPE RESOURCE-CODE ACTIVITY-GRP ACTIVITY COMPANY EFFECTIVE-DATE |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Acactgrp | ACACTGRP |
Required
| ||||||
Acactivity | ACACTIVITY |
Required
| ||||||
Acresource | ACRESOURCE |
Required
| ||||||
Employee | EMPLOYEE |
Not Required
|
All trademarks and registered trademarks are the property of their
respective owners.