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.

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

IndexKeysFlagsConditionUsed in
CAGSET1ALLOCATION-GRPPrimaryAP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyGLSYSTEMRequiredCAG-COMPANY → GLS-COMPANY
GlcpygrpGLCPYGRPRequiredCAG-COMPANY-GROUP → GCG-COMPANY-GROUP

One to many (2) — child tables

RelationTableRulesConditionField map
CaalocgpauCAALOCGPAUCAG-ALLOCATION-GRP → CGA-ALLOCATION-GRP, → CGA-ACTION, → CGA-DATE, → CGA-TIME, → CGA-UNIQUE-I-D
CaheaderCAHEADERCAG-ALLOCATION-GRP → CAH-ALLOCATION-GRP, → CAH-ALLOC-TYPE, → CAH-COMPANY, → CAH-ALLOC-NAME

Programs

Updated by (2)

Referenced by (68)