ACALLOCGP – Activity Allocation Group
- System
- Activity Management (AC)
- Prefix
ALG- Primary key
ALLOC-GROUP- Fields
- 5
- Updated by
- 3 programs
- Referenced by
- 2 programs
ACALLOCGP is the Activity Allocation Group table in Lawson Activity Management (prefix ALG). It is indexed by ALLOC-GROUP (ALGSET1). It is related 1:M to ACALLOCGPX. It is updated by AC131, AC37.1 and AC37.2 and referenced by AC130 and AC230. The table has 5 fields, 1 index and 1 documented relation.
About ACALLOCGP
The Allocation Group file contains information on the allocation group, as defined in AC37.1 (Allocation Group).
Fields (5)
Column = COBOL field name without the ALG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ALG-ALLOC-GROUP PKALLOC_GROUP | Alpha 12 | Required. This field defines an allocation group. | AC37.1, AC37.2 |
ALG-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This is the allocation group description. | AC37.1, AC37.2 |
ALG-STATUSSTATUS | Numeric 1 | This field indicates whether the allocation group is active or inactive.
| AC37.1, AC37.2 |
ALG-LAST-DATE-PROCLAST_DATE_PROC | Numeric 8 (yyyymmdd) | This is the date the allocation group was last processed by AC131 (Allocation Update). | AC131 |
ALG-LAST-TIME-PROCLAST_TIME_PROC | Numeric 6 (hhmmss) | This is the time the allocation group was last processed by AC131 (Allocation Update). | AC131 |
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 |
|---|---|---|---|---|
ALGSET1 | ALLOC-GROUP | Primary | AC130, AC131, AC230, AC37.1, AC37.2 |
Relations
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Acallocgpx | ACALLOCGPX | ALG-ALLOC-GROUP → AGX-ALLOC-GROUP, → AGX-ALLOC-NAME |