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

Field / columnTypeDescription & valuesUpdated by
#ALG-ALLOC-GROUP PK
ALLOC_GROUP		Alpha 12Required. This field defines an allocation group.AC37.1, AC37.2
#ALG-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This is the allocation group description.AC37.1, AC37.2
#ALG-STATUS
STATUS		Numeric 1This field indicates whether the allocation group is active or inactive.
  • 1 Active
  • 9 Inactive
AC37.1, AC37.2
#ALG-LAST-DATE-PROC
LAST_DATE_PROC		Numeric 8 (yyyymmdd)This is the date the allocation group was last processed by AC131 (Allocation Update).AC131
#ALG-LAST-TIME-PROC
LAST_TIME_PROC		Numeric 6 (hhmmss)This is the time the allocation group was last processed by AC131 (Allocation Update).AC131

Indexes (1)

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
ALGSET1
  1. ALLOC-GROUP
PrimaryAC130, AC131, AC230, AC37.1, AC37.2

Relations

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

One to many (1) — child tables

RelationTableRulesConditionField map
AcallocgpxACALLOCGPX
ALG-ALLOC-GROUP→AGX-ALLOC-GROUP
—→AGX-ALLOC-NAME

Programs

Updated by (3)

Referenced by (2)