Lawson Insight Technical Documentation |
|
ACACRESRTX
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
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
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
PW110 PW510
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 PW110 PW510
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 PW110 PW510
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
PW110 PW510
CRX-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.
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
PW110 PW510
CRX-STD-RATE Signed 13.5 AC110 AC18.1
Element: Standard Rate AC18.2 AC18.3
AC18.4 AC18.5
AC500 AC520
PW110 PW510
CRX-UNIT-MEASURE Alpha 12 AC110 AC18.1
Element: Unit Measure AC18.2 AC18.3
AC18.4 AC18.5
AC500 AC520
PW110 PW510
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
PW110 PW510
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
PW110 PW510
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 PW110 PW510
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 PW110
company if the resource type = E. It is PW510
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
ET530 ET540
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 Not Required
CRX-COMPANY -> EMP-COMPANY
CRX-EMPLOYEE-ASSET -> EMP-EMPLOYEE
|