CAALLOCGRP – Allocation Group

System
General Ledger (GL)
Prefix
CAG
Primary key
ALLOCATION-GRP
Fields
5
Updated by
2 programs
Referenced by
68 programs

CAALLOCGRP is the Allocation Group table in Lawson General Ledger (prefix CAG). It is indexed by ALLOCATION-GRP (CAGSET1). It is related 1:1 to GLSYSTEM and GLCPYGRP and 1:M to CAALOCGPAU and CAHEADER. It is updated by CA00.1 and CA00.2 and referenced by AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 and 60 more. The table has 5 fields, 1 index and 4 documented relations.

About CAALLOCGRP

This file contains the Allocation Group information.

Fields (5)

Column = COBOL field name without the CAG- 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
#CAG-ALLOCATION-GRP PK
ALLOCATION_GRP		Alpha 12The allocation group name. An allocation group is used to store allocations for a specific company or company group. The group is used in allocation calculation and allocation interface.CA00.1, CA00.2
#CAG-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The allocation group description.CA00.1, CA00.2
#CAG-COMPANY-GROUP
COMPANY_GROUP		Alpha 12The company group where allocations are stored.CA00.1, CA00.2
#CAG-COMPANY
COMPANY		Numeric 4The company number where allocations are stored.CA00.1, CA00.2
#CAG-ALLOC-TYPE
ALLOC_TYPE		Alpha 1This field determines which allocations are members of the group by allocation type. The default is 'All'. The values are: All
  • A Actual
  • C Current Year Budget
  • N Next Year Budget
CA00.1, CA00.2

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
CAGSET1
  1. ALLOCATION-GRP
PrimaryAP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyGLSYSTEMRequired
CAG-COMPANY→GLS-COMPANY
GlcpygrpGLCPYGRPRequired
CAG-COMPANY-GROUP→GCG-COMPANY-GROUP

One to many (2) — child tables

RelationTableRulesConditionField map
CaalocgpauCAALOCGPAU
CAG-ALLOCATION-GRP→CGA-ALLOCATION-GRP
—→CGA-ACTION
—→CGA-DATE
—→CGA-TIME
—→CGA-UNIQUE-I-D
CaheaderCAHEADER
CAG-ALLOCATION-GRP→CAH-ALLOCATION-GRP
—→CAH-ALLOC-TYPE
—→CAH-COMPANY
—→CAH-ALLOC-NAME

Programs

Updated by (2)

Referenced by (68)