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

Field / column	Type	Description & values	Updated by
#`AGX-ALLOC-GROUP` PK ALLOC_GROUP	Alpha 12	This is the allocation group defined in AC37.1 (Allocation Group).	AC37.1, AC37.2
#`AGX-ALLOC-NAME` PK ALLOC_NAME	Alpha 12	The allocation name represents an allocation as defined in AC30.1 (Allocation) or AC30.2 (Multiple Pool Allocation).	AC37.1, AC37.2
#`AGX-STEP` SET2 STEP	Numeric 3	This 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`AGXSET1`	`ALLOC-GROUP` `ALLOC-NAME`	Primary		AC130, AC131, AC230, AC37.1, AC37.2
`AGXSET2`	`ALLOC-GROUP` `STEP` `ALLOC-NAME`	KeyChange		AC130, AC131, AC230, AC30.1, AC30.2, AC30.3, AC30.4, AC37.2

Relations

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

One to one (2) — lookups and parents

Relation Table Rules Condition Field map

Acalloc

ACALLOC

Required

AGX-ALLOC-NAME → AOC-ALLOC-NAME

Acallocgp

ACALLOCGP

Required

AGX-ALLOC-GROUP → ALG-ALLOC-GROUP

Programs

Updated by (3)

AC131 Allocation Update
AC37.1 Allocation Group
AC37.2 Allocation Group by Step

Referenced by (6)

AC130 Allocation Calculation
AC230 Allocation Listing
AC30.1 Allocation
AC30.2 Multiple Pool Allocation
AC30.3 List Allocation
AC30.4 New Allocation

ACALLOCGPX – Activity Allocation Grp Detail

About ACALLOCGPX

Fields (7) Copy as SQL

Indexes (2)

Relations

One to one (2) — lookups and parents

Programs

Updated by (3)

Referenced by (6)

Fields (7)