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.

Field / columnTypeDescription & valuesUpdated by
CGP-CAT-GROUP PK
CAT_GROUP
Alpha 15AC05.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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CGPSET1CAT-GROUPPrimaryAC00.1, AC00.2, AC00.3, AC02.1, AC05.2, AC05.3, AC08.1, AC08.2 +22 more (list truncated in source)

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
AccatgrpxACCATGRPXCGP-CAT-GROUPCGX-CAT-GROUP, CGX-ACCT-CATEGORY

Programs

Updated by (1)

Referenced by (466)