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.

Field / columnTypeDescription & valuesUpdated by
CGH-TRANS-TYPE
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CGHSET1CONTROL-GROUPPrimaryAC240, AC256, AC290, AC40.1, AC40.3, AC40.4, AC40.6, AC41.1 +6 more
CGHSET2TRANS-TYPE, CONTROL-GROUPKeyChangeAC40.1, AC40.3, AC40.4, AC40.6, AC41.1, AC41.3, AC41.4, AC41.6 +3 more

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
GlsystemGLSYSTEMRequiredCGH-COMPANY → GLS-COMPANY

One to many (1) — child tables

RelationTableRulesConditionField map
ActransACTRANSCGH-CONTROL-GROUP → ATN-CONTROL-GROUP, → ATN-SEQUENCE-NBR, → ATN-TRAN-CURRENCY, → ATN-OBJ-ID, → ATN-ACTIVITY-GRP

Programs

Updated by (8)

Referenced by (3)