ACCNTRACTX – Activity Contract Detail
- System
- AC Billing Revenue (BR)
- Prefix
CNX- Primary key
CONTRACT,ACTIVITY- Fields
- 4
- Updated by
- 9 programs
- Referenced by
- 36 programs
ACCNTRACTX is the Activity Contract Detail table in Lawson AC Billing Revenue (prefix CNX). It is indexed by CONTRACT, ACTIVITY (CNXSET1); alternate indexes: CNXSET2. It is related 1:1 to ACACTIVITY and ACCNTRACT. It is updated by AC10.1, AC110, AC120, AC300, AC500, BR10.1, BR10.2, BR10.9 and 1 more and referenced by AC19.1, AC473, AC493, AC50.1, AC56.1, AC560, AC93.4, AC93.5 and 28 more. The table has 4 fields, 2 indexes and 2 documented relations.
About ACCNTRACTX
The ACCNTRACTX file maintains all the posting level activities under a contract and their contract amount.
Fields (4)
Column = COBOL field name without the CNX- 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 |
|---|---|---|---|
#CNX-CONTRACT PKCONTRACT | Alpha 15 | Activity Management contract. | AC10.1, AC110, AC120, AC500, BR10.1, BR10.9 |
#CNX-ACTIVITY PKACTIVITY | Alpha 15 | Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. | AC10.1, AC110, AC120, AC500, BR10.1, BR10.9 |
#CNX-CONTRACT-AMTCONTRACT_AMT | Signed 18.2 | — | AC10.1, AC110, AC120, AC500, BR10.1, BR10.2, BR10.9, BR22.1 |
#CNX-CONTRACT-FLAGCONTRACT_FLAG | Alpha 1 | — | AC10.1, AC110, AC120, AC500, BR10.1, BR10.2, BR10.9 |
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 |
|---|---|---|---|---|
CNXSET1 |
| Primary | AC10.1, AC10.5, AC300, BR10.1, BR10.2, BR10.9, BR12.2, BR130 +12 more | |
CNXSET2 |
| AC10.1, AC120, AC19.1, AC473, AC493, AC50.1, AC500, AC56.1 +19 more |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||
|---|---|---|---|---|---|---|---|
| Acactivity | ACACTIVITY | Required |
| ||||
| Accntract | ACCNTRACT | Required |
|
Programs
Updated by (9)
- AC10.1 Activity
- AC110 Activity Copy
- AC120 Level Reorganization
- AC300 Activity Group Purge
- AC500 Activity Interface
- BR10.1 Contract Parameters
- BR10.2 Contract Detail
- BR10.9 Product Contract Parameters
- BR22.1 Contract Change Orders
Referenced by (36)
- AC19.1 Multiple Activity Speed Add
- AC473 Profit and Loss Statement
- AC493 Output Measure Analysis
- AC50.1 Activity Interface Adjustment
- AC56.1 Setup Interface Adjustment
- AC560 Setup Interface
- AC93.4 Activity Output Measure Analysis
- AC93.5 Activity Output Measure Analysis Totals
- ARLL.1 AR Transaction Interface
- BR02.2 Retainer Detail
- BR05.1 Milestones
- BR05.2 Days Milestones
- BR05.3 Date Milestones
- BR05.4 Percent Complete Milestones
- BR05.5 Manual Milestones
- BR12.2 Contract Account Category Detail
- BR130 Revenue Calculation
- BR131 Revenue Realization
- BR140 Billing and Revenue Backout
- BR153 Product Revenue Calculation
- BR154 Maintenance Revenue Calculation
- BR165 Percent Complete Calculation
- BR210 Contract Listing
- BR43.1 Revenue Adjustment
- BR430 Revenue History
- BR44.1 Mass Transaction Transfer
- BR51.1 Product Contract
- BR515 Fee Code Recalculation
- BR516 Fee Code Rebuild
- BR530 Revenue Import
- BR570 Product Contract Interface
- BR65.1 Percent Complete by Contract
- BR65.2 Percent Complete by Activity
- BR65.3 Percent Complete by Account Category
- BR70.1 Product Contract Interface Adjustment
- BRIP.1 Invoice Print Program