ACCTLGRPHD – Activity Control Group Header

System
Activity Management (AC)
Prefix
CGH
Primary key
CONTROL-GROUP
Fields
11
Updated by
8 programs
Referenced by
3 programs

ACCTLGRPHD is the Activity Control Group Header table in Lawson Activity Management (prefix CGH). It is indexed by CONTROL-GROUP (CGHSET1); alternate indexes: CGHSET2. It is related 1:1 to GLSYSTEM and 1:M to ACTRANS. It is updated by AC40.1, AC40.4, AC41.1, AC41.4, AC45.4, BR41.1, BR41.4 and BR43.1 and referenced by AC240, AC256 and AC290. The table has 11 fields, 2 indexes and 2 documented relations.

About ACCTLGRPHD

This file contains header information about activity control groups from AC40.1 (Journal Entry) and AC41.1 (Resource Journal Entry).

Fields (11)

Column = COBOL field name without the CGH- 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
#CGH-TRANS-TYPE SET2
TRANS_TYPE		Alpha 1Required key. This field determines if the transaction processes amounts or units.
  • A AC Only
  • B Both AC & GL
  • T Time Entry
  • R Resource AC Only
  • G Resource AC & GL
  • C Contract Only
  • D Contract & GL
  • E Revenue Only
  • F Revenue & GL
AC40.1, AC40.4, AC41.1, AC41.4, BR41.1, BR41.4, BR43.1
#CGH-CONTROL-GROUP PK
CONTROL_GROUP		Numeric 8Required key. This field contains the control group number used for process control of the journal entry detail.AC40.1, AC40.4, AC41.1, AC41.4, BR41.1, BR41.4, BR43.1
#CGH-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This is the control group description.AC40.1, AC40.4, AC41.1, AC41.4, BR41.1, BR41.4, BR43.1
#CGH-BATCH-DATE
BATCH_DATE		Numeric 8 (yyyymmdd)This is the date the batch of transactions for the control group was processed.AC40.1, AC40.4, AC41.1, AC41.4, BR41.1, BR41.4, BR43.1
#CGH-COMPANY
COMPANY		Numeric 4This is the responsible company.AC40.1, AC40.4, AC41.1, AC41.4, BR41.1, BR41.4, BR43.1
#CGH-BASE-ND
BASE_ND		Numeric 1This is the number of decimal positions defined for the activity group currency.AC40.1, AC40.4, AC41.1, AC41.4, BR41.1, BR41.4, BR43.1
#CGH-DEBIT-TOTAL
DEBIT_TOTAL		Signed 18.2This is the total debit amount for this batch of transactions. The debit amount must equal the credit amount.AC40.1, AC40.4, AC41.1, AC41.4, BR41.1, BR41.4, BR43.1
#CGH-CREDIT-TOTAL
CREDIT_TOTAL		Signed 18.2This is the total credit amount for this batch of transactions. The credit amount must equal the debit amount.AC40.1, AC40.4, AC41.1, AC41.4, BR41.1, BR41.4, BR43.1
#CGH-UNIT-DEBITS
UNIT_DEBITS		Signed 15.2This is the total of unit debits.AC40.1, AC40.4, AC41.1, AC41.4, BR41.1, BR41.4, BR43.1
#CGH-UNIT-CREDITS
UNIT_CREDITS		Signed 15.2This is the total of unit credits.AC40.1, AC40.4, AC41.1, AC41.4, BR41.1, BR41.4, BR43.1
#CGH-LAST-REC-SEQ
LAST_REC_SEQ		Numeric 6This is the sequence number of the last record processed.AC40.1, AC40.4, AC41.1, AC41.4, BR41.1, BR41.4, BR43.1

Indexes (2)

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
CGHSET1
  1. CONTROL-GROUP
PrimaryAC240, AC256, AC290, AC40.1, AC40.3, AC40.4, AC40.6, AC41.1 +6 more
CGHSET2
  1. TRANS-TYPE
  2. CONTROL-GROUP
KeyChangeAC40.1, AC40.3, AC40.4, AC40.6, AC41.1, AC41.3, AC41.4, AC41.6 +3 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLSYSTEMACTRANSACCTLGRPHD

One to one (1) — lookups and parents

RelationTableRulesConditionField map
GlsystemGLSYSTEMRequired
CGH-COMPANY→GLS-COMPANY

One to many (1) — child tables

RelationTableRulesConditionField map
ActransACTRANS
CGH-CONTROL-GROUP→ATN-CONTROL-GROUP
—→ATN-SEQUENCE-NBR
—→ATN-TRAN-CURRENCY
—→ATN-OBJ-ID
—→ATN-ACTIVITY-GRP

Programs

Updated by (8)

Referenced by (3)