ACCATGRPX – Account Category Group Detail

System
Activity Management (AC)
Prefix
CGX
Primary key
CAT-GROUP, ACCT-CATEGORY
Fields
2
Updated by
2 programs
Referenced by
394 programs

ACCATGRPX is the Account Category Group Detail table in Lawson Activity Management (prefix CGX). It is indexed by CAT-GROUP, ACCT-CATEGORY (CGXSET1). It is related 1:1 to ACACCTCAT and ACCATGRP. It is updated by AC05.2 and AC05.3 and referenced by AC00.1, AC00.2, AC00.3, AC02.1, AC08.1, AC08.2, AC08.3, AC08.4 and 386 more. The table has 2 fields, 1 index and 2 documented relations.

About ACCATGRPX

The Account Category Group Detail file stores the specific account category names that make up a group. If the All flag is set on the Account Category Group Header file, there are no detail records. Account Category Groups are defined on AC08.1

Fields (2)

Column = COBOL field name without the CGX- 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
#CGX-CAT-GROUP PK
CAT_GROUP		Alpha 15—AC05.2, AC05.3
#CGX-ACCT-CATEGORY PK
ACCT_CATEGORY		Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thruAC05.2, AC05.3

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
CGXSET1
  1. CAT-GROUP
  2. ACCT-CATEGORY
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)
ACACCTCATACCATGRPACCATGRPX

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATNot Required
CGX-ACCT-CATEGORY→AAX-ACCT-CATEGORY
AccatgrpACCATGRPRequired
CGX-CAT-GROUP→CGP-CAT-GROUP

Programs

Updated by (2)

Referenced by (394)