ACASSIGN – Activity Resource Assignment

System
Activity Management (AC)
Prefix
AAN
Primary key
ACTIVITY-GRP, ACTIVITY, COMPANY, RESOURCE-TYPE, RESOURCE-CODE
Fields
16
Updated by
12 programs
Referenced by
144 programs

ACASSIGN is the Activity Resource Assignment table in Lawson Activity Management (prefix AAN). It is indexed by ACTIVITY-GRP, ACTIVITY, COMPANY, RESOURCE-TYPE, RESOURCE-CODE (AANSET1); alternate indexes: AANSET3, AANSET5, AANSET7 and AANSET8. It is related 1:1 to ACACTGRP, ACACTIVITY, ACRESOURCE, AMASSET, APCOMPANY, APVENMAST and EMPLOYEE and 1:M to ACASNROLE, ACCOMMITX and ACRESHIST. It is updated by AC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC10.1, AC110 and 4 more and referenced by AC01.1, AC105, AC112, AC113, AC121, AC123, AC128, AC13.3 and 136 more. The table has 16 fields, 5 indexes and 20 documented relations.

About ACASSIGN

This file contains resource assignment information from AC03.2 (AC Person Assignment), AC03.3 (HR Employee Assignment), AC03.4 (Vendor Assignment), AC03.5 (Asset Assignment), and AC03.6 (Equipment Assignment). It includes resource codes, their descriptions, and the assignment of resources to activities and activity groups. The resources must have been defined already in AC03.1 (Resource), HR11.1 (Employee), AM20.2 (Additions and Adjustments), or AP10.1 (Vendor).

Fields (16)

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

Field / columnTypeDescription & valuesUpdated by
AAN-ACTIVITY-GRP PK
ACTIVITY_GRP		Alpha 15Required key. This is the activity group to which the resource is assigned.AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC110, AC120, AC500 +1 more
AAN-ACTIVITY PK
ACTIVITY		Alpha 15Required key. This is the activity to which the resource is assigned.AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC110, AC500, AC520
AAN-RESOURCE-TYPE PK
RESOURCE_TYPE		Alpha 1Key field. This field indicates the type of resource this is. Valid values include:
  • Q Equipment
  • P Person
  • E Payroll Employee
  • A Asset
  • V AP/EE Vendor
AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC110, AC500, AC520
AAN-RESOURCE-CODE PK
RESOURCE_CODE		Alpha 10Required key. This code identifies a resource assigned to an activity. The resource must first be defined in HR11.1 (Employee), AM20.2 (Additions and Adjustments), AP10.1 (Vendor), or AC03.1 (Resource).AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC110, AC500, AC520
AAN-COMPANY PK
COMPANY		Numeric 4Key field. Required for resource types Employee and Vendor. This is the company number for this assignment. If you leave this field blank, it defaults to the activity responsible company.AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC110, AC500, AC520
AAN-EMPLOYEE-ASSET
EMPLOYEE_ASSET		Numeric 10This field is required for Employee and Asset resource types. It allows you to establish a relationship with the Employee and Asset files for Drill Around and selects.AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC110, AC500, AC520
AAN-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)Required. This is the description of the resource. If you leave this field blank, the description defaults from the Resource Source file.AC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC110, AC500 +1 more
AAN-TO-COMPANY
TO_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.AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC110, AC500, AC520
AAN-ACCT-UNIT
ACCT_UNIT		Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC110, AC500, AC520
AAN-ACCOUNT
ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC110, AC500, AC520
AAN-SUB-ACCT
SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC110, AC500, AC520
AAN-MATRIX-CAT
MATRIX_CAT		Alpha 12Attribute name assigned to an object (like accounting unit) to track additional information. Attribute values may then be used in selection and sorting for report and analysis.AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC500, AC520
AAN-MX-VALUE
MX_VALUE		Alpha 32The attribute value.AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC500, AC520
AAN-BEGIN-DATE
BEGIN_DATE		Numeric 8 (yyyymmdd)The begin date for this effort period.AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC500, AC520
AAN-END-DATE
END_DATE		Numeric 8 (yyyymmdd)The end date for this effort period.AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC500, AC520
AAN-BILL-RATE
BILL_RATE		Signed 13.4The billing rate that is set up for a resource for a specific activity.—

Indexes (5)

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

IndexKeysFlagsConditionUsed in
AANSET1ACTIVITY-GRP, ACTIVITY, COMPANY, RESOURCE-TYPE, RESOURCE-CODEPrimaryAC01.1, AC03.7, AC105, AC112, AC113, AC120, AC121, AC123 +22 more (list truncated in source)
AANSET3COMPANY, RESOURCE-CODE, RESOURCE-TYPE, ACTIVITY-GRP, ACTIVITYAC03.1, AC203, AC520, ACDL.1, BR96.1
AANSET5ACTIVITY, ACTIVITY-GRP, COMPANY, RESOURCE-CODE, RESOURCE-TYPEAC10.1, AC110, AC203
AANSET7RESOURCE-TYPE, ACTIVITY-GRP, ACTIVITY, COMPANY, RESOURCE-CODEAC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC50.1, AC500, ACBR.1
AANSET8COMPANY, EMPLOYEE-ASSET, ACTIVITY-GRP, ACTIVITY, RESOURCE-TYPE, RESOURCE-CODEKeyChange, SubsetWhere RESOURCE-TYPE = "E"—

Relations

One to one (7) — lookups and parents

RelationTableRulesConditionField map
AcactgrpACACTGRPNot RequiredAAN-ACTIVITY-GRP → AGP-ACTIVITY-GRP (AGPSET1)
AcactivityACACTIVITYNot RequiredAAN-ACTIVITY → ACV-ACTIVITY
AcresourceACRESOURCENot RequiredValid When AAN-RESOURCE-TYPE = "P" Or AAN-RESOURCE-TYPE = "Q"AAN-RESOURCE-CODE → RSC-RESOURCE-CODE, AAN-RESOURCE-TYPE → RSC-RESOURCE-TYPE
AmassetAMASSETNot RequiredValid When AAN-RESOURCE-TYPE = "A"AAN-EMPLOYEE-ASSET → AST-ASSET
ApcompanyAPCOMPANYNot RequiredValid When AAN-RESOURCE-TYPE = "V"AAN-COMPANY → CPY-COMPANY
ApvenmastAPVENMASTNot RequiredValid When AAN-RESOURCE-TYPE = "V"CPY-VENDOR-GROUP → VEN-VENDOR-GROUP, AAN-RESOURCE-CODE → VEN-VENDOR
EmployeeEMPLOYEENot RequiredValid When AAN-RESOURCE-TYPE = "E"AAN-COMPANY → EMP-COMPANY, AAN-EMPLOYEE-ASSET → EMP-EMPLOYEE

One to many (13) — child tables

RelationTableRulesConditionField map
AcasnroleACASNROLEAAN-ACTIVITY-GRP → ALE-ACTIVITY-GRP, AAN-ACTIVITY → ALE-ACTIVITY, AAN-RESOURCE-TYPE → ALE-RESOURCE-TYPE, AAN-COMPANY → ALE-COMPANY, AAN-RESOURCE-CODE → ALE-RESOURCE-CODE, → ALE-ROLE
AccommitxACCOMMITXAAN-COMPANY → MIX-RESOURCE-COMP, AAN-RESOURCE-TYPE → MIX-RESOURCE-TYPE, AAN-RESOURCE-CODE → MIX-RESOURCE-CODE, → MIX-SYSTEM, → MIX-TRANS-DATE, → MIX-ACTIVITY-GRP, → MIX-ACTIVITY, → MIX-ACCT-CATEGORY, → MIX-ATN-OBJ-ID
AcreshistACRESHISTAAN-ACTIVITY-GRP → RSH-ACTIVITY-GRP, AAN-ACTIVITY → RSH-ACTIVITY, AAN-RESOURCE-TYPE → RSH-RESOURCE-TYPE, → RSH-RESOURCE-CODE, → RSH-COMPANY, → RSH-ROLE, → RSH-FIELD-ID, → RSH-SEQ-NUMBER
HistastasgnACRESHISTAAN-ACTIVITY-GRP → RSH-ACTIVITY-GRP, AAN-ACTIVITY → RSH-ACTIVITY, AAN-RESOURCE-TYPE → RSH-RESOURCE-TYPE, 440 → RSH-FIELD-ID, → RSH-COMPANY, → RSH-RESOURCE-CODE, → RSH-SEQ-NUMBER
HistastroleACRESHISTAAN-ACTIVITY-GRP → RSH-ACTIVITY-GRP, AAN-ACTIVITY → RSH-ACTIVITY, AAN-RESOURCE-TYPE → RSH-RESOURCE-TYPE, 441 → RSH-FIELD-ID, → RSH-COMPANY, → RSH-RESOURCE-CODE, → RSH-SEQ-NUMBER
HistempasgnACRESHISTAAN-ACTIVITY-GRP → RSH-ACTIVITY-GRP, AAN-ACTIVITY → RSH-ACTIVITY, AAN-RESOURCE-TYPE → RSH-RESOURCE-TYPE, 420 → RSH-FIELD-ID, → RSH-COMPANY, → RSH-RESOURCE-CODE, → RSH-SEQ-NUMBER
HistemproleACRESHISTAAN-ACTIVITY-GRP → RSH-ACTIVITY-GRP, AAN-ACTIVITY → RSH-ACTIVITY, AAN-RESOURCE-TYPE → RSH-RESOURCE-TYPE, 421 → RSH-FIELD-ID, → RSH-COMPANY, → RSH-RESOURCE-CODE, → RSH-SEQ-NUMBER
HisteqpasgnACRESHISTAAN-ACTIVITY-GRP → RSH-ACTIVITY-GRP, AAN-ACTIVITY → RSH-ACTIVITY, AAN-RESOURCE-TYPE → RSH-RESOURCE-TYPE, 450 → RSH-FIELD-ID, → RSH-COMPANY, → RSH-RESOURCE-CODE, → RSH-SEQ-NUMBER
HisteqproleACRESHISTAAN-ACTIVITY-GRP → RSH-ACTIVITY-GRP, AAN-ACTIVITY → RSH-ACTIVITY, AAN-RESOURCE-TYPE → RSH-RESOURCE-TYPE, 451 → RSH-FIELD-ID, → RSH-COMPANY, → RSH-RESOURCE-CODE, → RSH-SEQ-NUMBER
HistperasgnACRESHISTAAN-ACTIVITY-GRP → RSH-ACTIVITY-GRP, AAN-ACTIVITY → RSH-ACTIVITY, AAN-RESOURCE-TYPE → RSH-RESOURCE-TYPE, 410 → RSH-FIELD-ID, → RSH-COMPANY, → RSH-RESOURCE-CODE, → RSH-SEQ-NUMBER
HistperroleACRESHISTAAN-ACTIVITY-GRP → RSH-ACTIVITY-GRP, AAN-ACTIVITY → RSH-ACTIVITY, AAN-RESOURCE-TYPE → RSH-RESOURCE-TYPE, 411 → RSH-FIELD-ID, → RSH-COMPANY, → RSH-RESOURCE-CODE, → RSH-SEQ-NUMBER
HistvenasgnACRESHISTAAN-ACTIVITY-GRP → RSH-ACTIVITY-GRP, AAN-ACTIVITY → RSH-ACTIVITY, AAN-RESOURCE-TYPE → RSH-RESOURCE-TYPE, 430 → RSH-FIELD-ID, → RSH-COMPANY, → RSH-RESOURCE-CODE, → RSH-SEQ-NUMBER
HistvenroleACRESHISTAAN-ACTIVITY-GRP → RSH-ACTIVITY-GRP, AAN-ACTIVITY → RSH-ACTIVITY, AAN-RESOURCE-TYPE → RSH-RESOURCE-TYPE, 431 → RSH-FIELD-ID, → RSH-COMPANY, → RSH-RESOURCE-CODE, → RSH-SEQ-NUMBER

Programs

Updated by (12)

Referenced by (144)