ACCNTADX – The contract attribute modification file contains the contract modification information for attributes from Contract…
- System
- AC Billing Revenue (BR)
- Prefix
CMA- Primary key
CONTRACT,MOD-NBR,MATRIX-CAT- Fields
- 5
- Updated by
- 4 programs
- Referenced by
- 1 program
ACCNTADX is the The contract attribute modification file contains the contract modification information for attributes from Contract… table in Lawson AC Billing Revenue (prefix CMA). It is indexed by CONTRACT, MOD-NBR, MATRIX-CAT (CMASET1). It is related 1:1 to ACCNTRACT. It is updated by BR10.1, BR10.4, BR10.5 and BR10.7 and referenced by BR212. The table has 5 fields, 1 index and 1 documented relation.
About ACCNTADX
The contract attribute modification file contains the contract modification information for attributes from Contract Modification (BR10.5) and Contract Attribute Modification (BR10.7). Additional Information (BR10.4) must exist for the contract prior to creating a modification. The fields include the contract, the modification number, the previous attribute and the new attribute. The file maintains contract modification to all the user to track these changes to the attributes. Once the modification is approved the ACACTMXVAL is updated.
Fields (5)
Column = COBOL field name without the CMA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
CMA-CONTRACT PKCONTRACT | Alpha 15 | The contract on which the attribute modification is performed. | BR10.7 |
CMA-MOD-NBR PKMOD_NBR | Alpha 15 (Lower Case) | The user-defined Contract Modification Number created on Contract Modification (BR10.5). | BR10.7 |
CMA-MATRIX-CAT PKMATRIX_CAT | Alpha 12 | The attribute name assigned to the contract activity (AC13). | BR10.7 |
CMA-MX-VALUEMX_VALUE | Alpha 32 | The previous attribute value. | BR10.7 |
CMA-NEW-MX-VALUENEW_MX_VALUE | Alpha 32 | The new attribute value | BR10.7 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
CMASET1 | CONTRACT, MOD-NBR, MATRIX-CAT | Primary | BR10.1, BR10.4, BR10.5, BR10.7, BR10.8, BR212 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Accntract | ACCNTRACT | Required | CMA-CONTRACT → CNT-CONTRACT |
Programs
Updated by (4)
- BR10.1 Contract Parameters
- BR10.4 Additional Contract Information
- BR10.5 Contract Modification
- BR10.7 Contract Attribute Modifications
Referenced by (1)
- BR212 Contract Modification Listing