ACRESRTX – No description in the Lawson data dictionary

System
Activity Management (AC)
Prefix
RRX
Primary key
RESOURCE-TYPE, RESOURCE-CODE, COMPANY, EFFECTIVE-DATE
Fields
10
Updated by
5 programs
Referenced by
19 programs

ACRESRTX is a Lawson Activity Management table (prefix RRX); no description in the lawson data dictionary. It is indexed by RESOURCE-TYPE, RESOURCE-CODE, COMPANY, EFFECTIVE-DATE (RRXSET1); alternate indexes: RRXSET2 and RRXSET3. It is updated by AC17.2, AC17.3, AC17.4, AC17.5 and AC17.6 and referenced by AC190, AC217, AC40.1, AC40.4, AC41.1, AC41.4, AC42.1, AC46.1 and 11 more. The table has 10 fields, 3 indexes and 0 documented relations.

About ACRESRTX

No description in the Lawson data dictionary.

Fields (10)

Column = COBOL field name without the RRX- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
RRX-RESOURCE-TYPE PK
RESOURCE_TYPE		Alpha 1The 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
AC17.2, AC17.3, AC17.4, AC17.5, AC17.6
RRX-RESOURCE-CODE PK
RESOURCE_CODE		Alpha 10The code identifying the resource assigned to the activity or activity group.AC17.2, AC17.3, AC17.4, AC17.5, AC17.6
RRX-COMPANY PK
COMPANY		Numeric 4Identifies 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.AC17.3, AC17.4
RRX-EMPLOYEE-ASSET
EMPLOYEE_ASSET		Numeric 10The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.AC17.3, AC17.5
RRX-EFFECTIVE-DATE PK
EFFECTIVE_DATE		Numeric 8 (yyyymmdd)The date a vendor's prices will be in effect.AC17.2, AC17.3, AC17.4, AC17.5, AC17.6
RRX-STD-RATE
STD_RATE		Signed 13.5—AC17.2, AC17.3, AC17.4, AC17.5, AC17.6
RRX-UNIT-MEASURE
UNIT_MEASURE		Alpha 12—AC17.2, AC17.3, AC17.4, AC17.5, AC17.6
RRX-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).AC17.2, AC17.3, AC17.4, AC17.5, AC17.6
RRX-BILL-RATE
BILL_RATE		Signed 13.4The billing rate that is set up for a resource for a specific activity.AC17.2, AC17.3, AC17.4, AC17.5, AC17.6
RRX-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1The Active flag of the credit card type.
  • A Active
  • I Inactive
AC17.2, AC17.3, AC17.4, AC17.5, AC17.6

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RRXSET1RESOURCE-TYPE, RESOURCE-CODE, COMPANY, EFFECTIVE-DATEPrimaryAC17.2, AC17.3, AC17.4, AC17.5, AC17.6, AC217
RRXSET2ACTIVE-FLAG, RESOURCE-TYPE, RESOURCE-CODE, COMPANY, EFFECTIVE-DATE*KeyChangeAC190, AC40.1, AC40.4, AC41.1, AC41.4, AC42.1, AC46.1, AC54.1 +10 more
RRXSET3RESOURCE-TYPE, EMPLOYEE-ASSET, COMPANY, EFFECTIVE-DATE, RESOURCE-CODEKeyChange—

Programs

Updated by (5)

Referenced by (19)