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.

Field / columnTypeDescription & valuesUpdated by
BCX-CONTRACT PK
CONTRACT		Alpha 15Activity Management contract.BR18.1, BR18.2, BR18.3
BCX-CTR-CAT-GRP
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BCXSET1CONTRACT, ACCT-CATEGORYPrimaryAC10.1, AC112, AC113, AC12.1, AC120, AC121, AC123, AC128 +22 more (list truncated in source)
BCXSET3CONTRACT, CTR-CAT-GRP, ACCT-CATEGORYKeyChangeBR120, BR121, BR122, BR123, BR140, BR151, BR152, BR156 +12 more

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATRequiredBCX-ACCT-CATEGORY → AAX-ACCT-CATEGORY
AccntractACCNTRACTRequiredBCX-CONTRACT → CNT-CONTRACT
AcctrcatgACCTRCATGRequiredBCX-CTR-CAT-GRP → BCG-CTR-CAT-GRP, BCX-CONTRACT → BCG-CONTRACT

Programs

Updated by (6)

Referenced by (141)