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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET3
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 SET2
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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RRXSET1
  1. RESOURCE-TYPE
  2. RESOURCE-CODE
  3. COMPANY
  4. EFFECTIVE-DATE
PrimaryAC17.2, AC17.3, AC17.4, AC17.5, AC17.6, AC217
RRXSET2
  1. ACTIVE-FLAG
  2. RESOURCE-TYPE
  3. RESOURCE-CODE
  4. COMPANY
  5. EFFECTIVE-DATE ↓
KeyChangeAC190, AC40.1, AC40.4, AC41.1, AC41.4, AC42.1, AC46.1, AC54.1 +10 more
RRXSET3
  1. RESOURCE-TYPE
  2. EMPLOYEE-ASSET
  3. COMPANY
  4. EFFECTIVE-DATE
  5. RESOURCE-CODE
KeyChange—

Programs

Updated by (5)

Referenced by (19)