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 / 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ALGSET1ALLOC-GROUPPrimaryAC130, AC131, AC230, AC37.1, AC37.2

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
AcallocgpxACALLOCGPXALG-ALLOC-GROUPAGX-ALLOC-GROUP, AGX-ALLOC-NAME

Programs

Updated by (3)

Referenced by (2)