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

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 SET8
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 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
AANSET1
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. COMPANY
  4. RESOURCE-TYPE
  5. RESOURCE-CODE
PrimaryAC01.1, AC03.7, AC105, AC112, AC113, AC120, AC121, AC123 +22 more (list truncated in source)
AANSET3
  1. COMPANY
  2. RESOURCE-CODE
  3. RESOURCE-TYPE
  4. ACTIVITY-GRP
  5. ACTIVITY
AC03.1, AC203, AC520, ACDL.1, BR96.1
AANSET5
  1. ACTIVITY
  2. ACTIVITY-GRP
  3. COMPANY
  4. RESOURCE-CODE
  5. RESOURCE-TYPE
AC10.1, AC110, AC203
AANSET7
  1. RESOURCE-TYPE
  2. ACTIVITY-GRP
  3. ACTIVITY
  4. COMPANY
  5. RESOURCE-CODE
AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC50.1, AC500, ACBR.1
AANSET8
  1. COMPANY
  2. EMPLOYEE-ASSET
  3. ACTIVITY-GRP
  4. ACTIVITY
  5. RESOURCE-TYPE
  6. RESOURCE-CODE
KeyChange, SubsetWhere RESOURCE-TYPE = "E"—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACTGRPACACTIVITYACRESOURCEAMASSETAPCOMPANYAPVENMASTEMPLOYEEACASNROLEACCOMMITXACRESHISTACASSIGN

One to one (7) — lookups and parents

RelationTableRulesConditionField map
AcactgrpACACTGRPNot Required
AAN-ACTIVITY-GRP→AGP-ACTIVITY-GRP (AGPSET1)
AcactivityACACTIVITYNot Required
AAN-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
AcasnroleACASNROLE
AAN-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
AccommitxACCOMMITX
AAN-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
AcreshistACRESHIST
AAN-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
HistastasgnACRESHIST
AAN-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
HistastroleACRESHIST
AAN-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
HistempasgnACRESHIST
AAN-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
HistemproleACRESHIST
AAN-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
HisteqpasgnACRESHIST
AAN-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
HisteqproleACRESHIST
AAN-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
HistperasgnACRESHIST
AAN-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
HistperroleACRESHIST
AAN-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
HistvenasgnACRESHIST
AAN-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
HistvenroleACRESHIST
AAN-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)