ACCATGRP – Account Category Group

System
Activity Management (AC)
Prefix
CGP
Primary key
CAT-GROUP
Fields
3
Updated by
1 program
Referenced by
466 programs

ACCATGRP is the Account Category Group table in Lawson Activity Management (prefix CGP). It is indexed by CAT-GROUP (CGPSET1). It is related 1:M to ACCATGRPX. It is updated by AC05.2 and referenced by AC00.1, AC00.2, AC00.3, AC02.1, AC08.1, AC08.2, AC08.3, AC08.4 and 458 more. The table has 3 fields, 1 index and 1 documented relation.

About ACCATGRP

The Account Category Group Header file stores account category group names and descriptions. It also stores an All flag which indicates if the group consists of all account categories. Account Category Groups are defined on AC08.1.

Fields (3)

Column = COBOL field name without the CGP- 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
#CGP-CAT-GROUP PK
CAT_GROUP
Alpha 15—AC05.2
#CGP-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This field displays the description.AC05.2
#CGP-ALL-FLAG
ALL_FLAG
Alpha 1—
  • Y Yes
  • N No
AC05.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
CGPSET1
  1. CAT-GROUP
PrimaryAC00.1, AC00.2, AC00.3, AC02.1, AC05.2, AC05.3, AC08.1, AC08.2 +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)
ACCATGRPXACCATGRP

One to many (1) — child tables

RelationTableRulesConditionField map
AccatgrpxACCATGRPX
CGP-CAT-GROUP→CGX-CAT-GROUP
—→CGX-ACCT-CATEGORY

Programs

Updated by (1)

Referenced by (466)