ACADDASSGN – Activity Address Assignment
- System
- Activity Management (AC)
- Prefix
AAS- Primary key
ACTIVITY,ADDRESS-CODE- Fields
- 3
- Updated by
- 4 programs
- Referenced by
- 0 programs
ACADDASSGN is the Activity Address Assignment table in Lawson Activity Management (prefix AAS). It is indexed by ACTIVITY, ADDRESS-CODE (AASSET1). It is related 1:1 to ACACTIVITY and ACADDRESS. It is updated by AC10.1, AC10.2, AC300 and AC500. The table has 3 fields, 1 index and 2 documented relations.
About ACADDASSGN
No description in the Lawson data dictionary.
Fields (3)
Column = COBOL field name without the AAS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
AAS-ACTIVITY PKACTIVITY | Alpha 15 | Required key. This is the activity for the address. | AC10.2, AC500 |
AAS-ADDRESS-CODE PKADDRESS_CODE | Alpha 9 | Required key. This is the address code used to assign a location to an activity. Address codes are defined in AC10.4 (Location). | AC10.2, AC500 |
AAS-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This is the address code description. | AC10.2, AC500 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
AASSET1 | ACTIVITY, ADDRESS-CODE | Primary | AC10.1, AC10.2, AC300, AC500 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Acactivity | ACACTIVITY | Not Required | AAS-ACTIVITY → ACV-ACTIVITY | |
| Acaddress | ACADDRESS | Required | AAS-ADDRESS-CODE → ADD-ADDRESS-CODE |