ACALLOCGPX – Activity Allocation Grp Detail

System
Activity Management (AC)
Prefix
AGX
Primary key
ALLOC-GROUP, ALLOC-NAME
Fields
7
Updated by
3 programs
Referenced by
6 programs

ACALLOCGPX is the Activity Allocation Grp Detail table in Lawson Activity Management (prefix AGX). It is indexed by ALLOC-GROUP, ALLOC-NAME (AGXSET1); alternate indexes: AGXSET2. It is related 1:1 to ACALLOC and ACALLOCGP. It is updated by AC131, AC37.1 and AC37.2 and referenced by AC130, AC230, AC30.1, AC30.2, AC30.3 and AC30.4. The table has 7 fields, 2 indexes and 2 documented relations.

About ACALLOCGPX

This file contains detailed information about allocation groups, as defined in AC37.1 (Allocation Group).

Fields (7)

Column = COBOL field name without the AGX- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
AGX-ALLOC-GROUP PK
ALLOC_GROUP		Alpha 12This is the allocation group defined in AC37.1 (Allocation Group).AC37.1, AC37.2
AGX-ALLOC-NAME PK
ALLOC_NAME		Alpha 12The allocation name represents an allocation as defined in AC30.1 (Allocation) or AC30.2 (Multiple Pool Allocation).AC37.1, AC37.2
AGX-STEP
STEP		Numeric 3This field determines when an allocation detail line gets processed. All lower steps are processed before processing higher steps.AC37.1, AC37.2
AGX-RUN-DATE
RUN_DATE		Numeric 8 (yyyymmdd)This is the date component of the AC131 (Allocation Update) timestamp on transactions produced for this allocation by the most recent run of AC131.—
AGX-RUN-TIME
RUN_TIME		Numeric 6 (hhmmss)This is the time component of the AC131 (Allocation Update) timestamp on transactions produced for this allocation by the most recent run of AC131.—
AGX-ALLOCATED-DATE
ALLOCATED_DATE		Numeric 8 (yyyymmdd)This is the date this allocation was last processed by AC131 (Allocation Update).AC131
AGX-ALLOCATED-TIME
ALLOCATED_TIME		Numeric 6 (hhmmss)This is the time this allocation was last processed by AC131 (Allocation Update).AC131

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AGXSET1ALLOC-GROUP, ALLOC-NAMEPrimaryAC130, AC131, AC230, AC37.1, AC37.2
AGXSET2ALLOC-GROUP, STEP, ALLOC-NAMEKeyChangeAC130, AC131, AC230, AC30.1, AC30.2, AC30.3, AC30.4, AC37.2

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AcallocACALLOCRequiredAGX-ALLOC-NAME → AOC-ALLOC-NAME
AcallocgpACALLOCGPRequiredAGX-ALLOC-GROUP → ALG-ALLOC-GROUP

Programs

Updated by (3)

Referenced by (6)