 |
Lawson Insight Technical Documentation |
|
ACACRESRTX FILE
REFERENCED BY
AC218 AC170 AC190 AC40.1 AC40.4 AC41.1
AC41.4 AC42.1 AC530 AC54.1 AC540 AC70.1
AC70.4 ACAC.1 BR40.3
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
Activity Group AC18.2 AC18.3
AC18.4 AC18.5
AC500 AC520
CRX-ACTIVITY Alpha 15 AC110 AC18.1
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
Resource Type P = Person AC18.2 AC18.3
E = Employee AC18.4 AC18.5
V = Vendor AC500 AC520
Q = Equipment
A = Asset
CRX-RESOURCE-CODE Alpha 10 AC110 AC18.1
Resource Code AC18.2 AC18.3
AC18.4 AC18.5
AC500 AC520
CRX-EMPLOYEE-ASSET Numeric 10 AC110 AC18.2
Employee Asset AC18.4 AC500
AC520
CRX-EFFECTIVE-DATE Numeric 8 (yyyymmdd) AC110 AC18.1
Effective Date The 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
Std Rate AC18.2 AC18.3
AC18.4 AC18.5
AC500 AC520
CRX-UNIT-MEASURE Alpha 12 AC110 AC18.1
Unit Measure AC18.2 AC18.3
AC18.4 AC18.5
AC500 AC520
CRX-CURRENCY-CODE Alpha 5 AC110 AC18.1
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
Bill Rate AC18.2 AC18.3
AC18.4 AC18.5
AC500 AC520
CRX-ACTIVE-FLAG Alpha 1 AC110 AC18.1
Status 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
Company The company number represents an AC18.3 AC500
established company and is entered on AC520
all function codes.
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
EFFECTIVE-DATE
CRXSET2 ACTIVE-FLAG KeyChange AC170 AC190
ACTIVITY-GRP AC40.1 AC40.4
ACTIVITY AC41.1 AC41.4
RESOURCE-TYPE AC42.1 AC530
RESOURCE-CODE AC54.1 AC540
COMPANY AC70.1 AC70.4
EFFECTIVE-DATE* ACAC.1 BR40.3
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
|