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.

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

IndexKeysFlagsConditionUsed in
CGXSET1CAT-GROUP, ACCT-CATEGORYPrimaryAC00.1, AC00.2, AC00.3, AC02.1, AC05.2, AC05.3, AC08.1, AC08.2 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATNot RequiredCGX-ACCT-CATEGORY → AAX-ACCT-CATEGORY
AccatgrpACCATGRPRequiredCGX-CAT-GROUP → CGP-CAT-GROUP

Programs

Updated by (2)

Referenced by (394)