ACCTRCATG – Contract Category Group

System
AC Billing Revenue (BR)
Prefix
BCG
Primary key
CTR-CAT-GRP, CONTRACT
Fields
3
Updated by
6 programs
Referenced by
28 programs

ACCTRCATG is the Contract Category Group table in Lawson AC Billing Revenue (prefix BCG). It is indexed by CTR-CAT-GRP, CONTRACT (BCGSET1); alternate indexes: BCGSET2. It is related 1:1 to ACCNTRACT and 1:M to ACCTRCATGX. It is updated by AC10.1, AC300, BR10.1, BR18.1, BR18.2 and BR18.3 and referenced by BR00.2, BR00.3, BR01.1, BR01.2, BR02.3, BR03.1, BR03.2, BR03.3 and 20 more. The table has 3 fields, 2 indexes and 2 documented relations.

About ACCTRCATG

No description in the Lawson data dictionary.

Fields (3)

Column = COBOL field name without the BCG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
BCG-CONTRACT PK
CONTRACT		Alpha 15Activity Management contract.BR18.1, BR18.2, BR18.3
BCG-CTR-CAT-GRP PK
CTR_CAT_GRP		Alpha 5—BR18.1, BR18.2, BR18.3
BCG-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.BR18.1, BR18.2, BR18.3

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BCGSET1CTR-CAT-GRP, CONTRACTPrimaryBR00.2, BR00.3, BR01.1, BR01.2, BR02.3, BR03.1, BR03.2, BR03.3 +21 more
BCGSET2CONTRACT, CTR-CAT-GRPAC10.1, AC300, BR10.1, BR18.1, BR18.2, BR18.3, BR218

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AccntractACCNTRACTRequiredBCG-CONTRACT → CNT-CONTRACT

One to many (1) — child tables

RelationTableRulesConditionField map
AcctrcatgxACCTRCATGXBCG-CONTRACT → BCX-CONTRACT, BCG-CTR-CAT-GRP → BCX-CTR-CAT-GRP, → BCX-ACCT-CATEGORY

Programs

Updated by (6)

Referenced by (28)