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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#BCG-CONTRACT PKCONTRACT | Alpha 15 | Activity Management contract. | BR18.1, BR18.2, BR18.3 |
#BCG-CTR-CAT-GRP PKCTR_CAT_GRP | Alpha 5 | — | BR18.1, BR18.2, BR18.3 |
#BCG-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field displays the description. | BR18.1, BR18.2, BR18.3 |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
BCGSET1 |
| Primary | BR00.2, BR00.3, BR01.1, BR01.2, BR02.3, BR03.1, BR03.2, BR03.3 +21 more | |
BCGSET2 |
| AC10.1, AC300, BR10.1, BR18.1, BR18.2, BR18.3, BR218 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||
|---|---|---|---|---|---|---|---|
| Accntract | ACCNTRACT | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Acctrcatgx | ACCTRCATGX |
|
Programs
Updated by (6)
- AC10.1 Activity
- AC300 Activity Group Purge
- BR10.1 Contract Parameters
- BR18.1 Contract Category Group
- BR18.2 Contract Category Group Mass Addition
- BR18.3 Contract Category Group Copy
Referenced by (28)
- BR00.2 Billing Detail
- BR00.3 Ceiling Levels
- BR01.1 Retention and Unbilled
- BR01.2 Bill Retention
- BR02.3 Retainer Invoice Entry
- BR03.1 Billing Category Rates
- BR03.2 Units of Production Rates
- BR03.3 Cost Plus Billing Labor Category Assignment
- BR120 Invoice Calculation
- BR121 Invoice Print and Interface
- BR122 Online batch invoice process
- BR123 Product Invoice Cancel
- BR140 Billing and Revenue Backout
- BR151 Product Invoicing
- BR152 Maintenance Invoicing
- BR156 Maintenance Quote
- BR19.2 Filter
- BR190 Billing and Revenue Recalculation
- BR20.1 Invoice Edit Contract
- BR20.2 Invoice Edit Line
- BR20.3 Invoice Edit Activity
- BR20.4 Invoice Edit Activity and Account Category
- BR20.5 Invoice Edit Transaction
- BR218 Contract Category Grp Listing
- BR420 Billing Invoice Report
- BR450 Activity Aging
- BR521 Billing Import
- BRIP.1 Invoice Print Program