ACCTRCATGX – Contract Category Group Dtl

System
AC Billing Revenue (BR)
Prefix
BCX
Primary key
CONTRACT, ACCT-CATEGORY
Fields
3
Updated by
6 programs
Referenced by
141 programs

ACCTRCATGX is the Contract Category Group Dtl table in Lawson AC Billing Revenue (prefix BCX). It is indexed by CONTRACT, ACCT-CATEGORY (BCXSET1); alternate indexes: BCXSET3. It is related 1:1 to ACACCTCAT, ACCNTRACT and ACCTRCATG. It is updated by AC10.1, AC300, BR10.1, BR18.1, BR18.2 and BR18.3 and referenced by AC112, AC113, AC12.1, AC120, AC121, AC123, AC128, AC135 and 133 more. The table has 3 fields, 2 indexes and 3 documented relations.

About ACCTRCATGX

No description in the Lawson data dictionary.

Fields (3)

Column = COBOL field name without the BCX- 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
#BCX-CONTRACT PK
CONTRACT		Alpha 15Activity Management contract.BR18.1, BR18.2, BR18.3
#BCX-CTR-CAT-GRP SET3
CTR_CAT_GRP		Alpha 5—BR120, BR121, BR122, BR123, BR140, BR151, BR152, BR156 +10 more
#BCX-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 thruBR18.1, BR18.2

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
BCXSET1
  1. CONTRACT
  2. ACCT-CATEGORY
PrimaryAC10.1, AC112, AC113, AC12.1, AC120, AC121, AC123, AC128 +22 more (list truncated in source)
BCXSET3
  1. CONTRACT
  2. CTR-CAT-GRP
  3. ACCT-CATEGORY
KeyChangeBR120, BR121, BR122, BR123, BR140, BR151, BR152, BR156 +12 more

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATRequired
BCX-ACCT-CATEGORY→AAX-ACCT-CATEGORY
AccntractACCNTRACTRequired
BCX-CONTRACT→CNT-CONTRACT
AcctrcatgACCTRCATGRequired
BCX-CTR-CAT-GRP→BCG-CTR-CAT-GRP
BCX-CONTRACT→BCG-CONTRACT

Programs

Updated by (6)

Referenced by (141)