ACCNTMOD – Activity Comment Type

System: AC Billing Revenue (BR)
Prefix: CMD
Primary key: CONTRACT, MOD-NBR
Fields: 58
Updated by: 5 programs
Referenced by: 2 programs

ACCNTMOD is the Activity Comment Type table in Lawson AC Billing Revenue (prefix CMD). It is indexed by CONTRACT, MOD-NBR (CMDSET1); alternate indexes: CMDSET2, CMDSET4 and CMDSET5. It is related 1:1 to ACCNTRACT and 1:M to ACCNTADX. It is updated by AC300, BR10.1, BR10.4, BR10.5 and BR10.8 and referenced by BR212 and BR90.1. The table has 58 fields, 4 indexes and 2 documented relations.

About ACCNTMOD

Contracts can be incrementally funded. Throughout the contract life the dollar amount, point of contact, and period of performance dates may change. The system maintains an audit trail of modifications if the modifications audit flag on the activity group is set to yes. A modification is a record of contract changes. This file maintains contract modifications to allow the user to track these changes. This file represents a map of the ACCNTMOD fields that will update the ACADDLCNTR file after approval. The "new" values will be come "current" values in the ACADLCNTR file. The primary program that updates this file is BR10.5.

Fields (58)

Column = COBOL field name without the CMD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`CMD-CONTRACT` PK CONTRACT	Alpha 15	The contract that is being modified. The contract is created on BR10.1 and modified on BR10.5.	BR10.5
`CMD-ACTIVITY-GRP` ACTIVITY_GRP	Alpha 15	The activity group associated with the contract related to this record.	BR10.5
`CMD-MOD-NBR` PK MOD_NBR	Alpha 15 (Lower Case)	The user defined Contract Modification Number created in Contract Modification (BR10.5).	BR10.5
`CMD-MOD-DATE` MOD_DATE	Numeric 8 (yyyymmdd)	The date the contract was modified. The date will default to the system date if left blank.	BR10.5
`CMD-CRT-CREATOR` CRT_CREATOR	Alpha 30	The user who created the modification.	BR10.5
`CMD-APPROVAL-DESC` APPROVAL_DESC	Alpha 30 (Lower Case)	The status description. The translations are: Unapproved Approved	BR10.8
`CMD-LONG-DESC` LONG_DESC	Alpha 60 (Lower Case)	The Long description of the modification maintained in Contract Modification (BR10.5).	BR10.5
`CMD-APPROVAL-DATE` APPROVAL_DATE	Numeric 8 (yyyymmdd)	The date of the approval. This is system generated.	BR10.8
`CMD-STATUS-CD` STATUS_CD	Alpha 1	The Status Code. The values are: `A` Approved `U` Unapproved	BR10.5, BR10.8
`CMD-PR-CNT-COST` PR_CNT_COST	Signed 18.2	Previous contract cost amount maintained in Additional information (BR10.4).	BR10.5
`CMD-PR-CNT-VAL` PR_CNT_VAL	Signed 18.2	The previous Contract Value which is derived from the cost amount and the fee amount.	—
`CMD-PR-CNT-FEE` PR_CNT_FEE	Signed 18.2	The previous Contract Fee maintained in Additional Information (BR10.4)	BR10.5
`CMD-ENTR-CNT-COST` ENTR_CNT_COST	Signed 18.2	The entered contract cost amount maintained in Contract Modification (BR10.5).	BR10.5
`CMD-ENTR-CNT-VALUE` ENTR_CNT_VALUE	Signed 18.2	The sum of the entered contract cost and the entered contract fee amounts.	—
`CMD-ENTR-CNT-FEE` ENTR_CNT_FEE	Signed 18.2	The entered Contract Fee Amount maintained on Contract Modification (BR10.5).	BR10.5
`CMD-NEW-CNT-COST` NEW_CNT_COST	Signed 18.2	The new Contract Cost Amount.	BR10.5
`CMD-NEW-CNT-FEE` NEW_CNT_FEE	Signed 18.2	—	BR10.5
`CMD-NEW-CNT-VAL` NEW_CNT_VAL	Signed 18.2	—	BR10.5
`CMD-PR-AWD-COST` PR_AWD_COST	Signed 18.2	—	BR10.5
`CMD-PR-AWD-VAL` PR_AWD_VAL	Signed 18.2	—	—
`CMD-PR-AWD-FEE` PR_AWD_FEE	Signed 18.2	—	BR10.5
`CMD-ENTR-AWD-COST` ENTR_AWD_COST	Signed 18.2	—	BR10.5
`CMD-ENTR-AWARD-VAL` ENTR_AWARD_VAL	Signed 18.2	—	—
`CMD-ENTR-AWARD-FEE` ENTR_AWARD_FEE	Signed 18.2	—	BR10.5
`CMD-NEW-AWARD-COST` NEW_AWARD_COST	Signed 18.2	—	BR10.5
`CMD-NEW-AWARD-FEE` NEW_AWARD_FEE	Signed 18.2	—	BR10.5
`CMD-NEW-AWD-VAL` NEW_AWD_VAL	Signed 18.2	—	BR10.5
`CMD-PR-FUND-COST` PR_FUND_COST	Signed 18.2	—	BR10.5
`CMD-PR-FUND-VAL` PR_FUND_VAL	Signed 18.2	—	—
`CMD-PR-FUND-FEE` PR_FUND_FEE	Signed 18.2	—	BR10.5
`CMD-ENTR-FUND-COST` ENTR_FUND_COST	Signed 18.2	—	BR10.5
`CMD-ENTR-FUND-VAL` ENTR_FUND_VAL	Signed 18.2	—	—
`CMD-ENTR-FUND-FEE` ENTR_FUND_FEE	Signed 18.2	—	BR10.5
`CMD-NEW-FUND-COST` NEW_FUND_COST	Signed 18.2	—	BR10.5
`CMD-NEW-FUND-FEE` NEW_FUND_FEE	Signed 18.2	—	BR10.5
`CMD-NEW-FD-VALUE` NEW_FD_VALUE	Signed 18.2	—	BR10.5
`CMD-PR-CNT-HOURS` PR_CNT_HOURS	Signed 18.2	—	BR10.5
`CMD-PR-AWD-HOURS` PR_AWD_HOURS	Signed 18.2	—	BR10.5
`CMD-PR-FUND-HOURS` PR_FUND_HOURS	Signed 18.2	—	BR10.5
`CMD-ENTR-CNT-HOURS` ENTR_CNT_HOURS	Signed 18.2	—	BR10.5
`CMD-ENTR-AWD-HOURS` ENTR_AWD_HOURS	Signed 18.2	—	BR10.5
`CMD-ENTR-FD-HOURS` ENTR_FD_HOURS	Signed 18.2	—	BR10.5
`CMD-NEW-CNT-HOURS` NEW_CNT_HOURS	Signed 18.2	—	BR10.5
`CMD-NEW-AWD-HOURS` NEW_AWD_HOURS	Signed 18.2	—	BR10.5
`CMD-NEW-FD-HOURS` NEW_FD_HOURS	Signed 18.2	—	BR10.5
`CMD-PR-TO-TOT-POP` PR_TO_TOT_POP	Numeric 8 (yyyymmdd)	Previous Contract Begin Date - Contract Period of Performance Dates. Informational only.	BR10.5
`CMD-PR-FR-TOT-POP` PR_FR_TOT_POP	Numeric 8 (yyyymmdd)	Previous Contract End Date - Period of Performance Dates. Informational only.	BR10.5
`CMD-NEW-TO-TOT-POP` NEW_TO_TOT_POP	Numeric 8 (yyyymmdd)	New Contract Begin Date - Period of Performance Dates. Informational only.	BR10.5
`CMD-NEW-FR-TOT-POP` NEW_FR_TOT_POP	Numeric 8 (yyyymmdd)	New Contract End Date - Period of Performance Dates. Informational only.	BR10.5
`CMD-PR-TO-AWD-POP` PR_TO_AWD_POP	Numeric 8 (yyyymmdd)	Previous Award Begin Date - Period of Performance Dates. Informational Only.	BR10.5
`CMD-PR-FR-AWD-POP` PR_FR_AWD_POP	Numeric 8 (yyyymmdd)	Previous Award End Date - Period of Performance Dates. Informational only.	BR10.5
`CMD-NEW-TO-AWD-POP` NEW_TO_AWD_POP	Numeric 8 (yyyymmdd)	New Award Begin Date - Period of Performance Dates. Informational only.	BR10.5
`CMD-NEW-FR-AWD-POP` NEW_FR_AWD_POP	Numeric 8 (yyyymmdd)	New Award End Date - Period of Performance Dates. Informational only.	BR10.5
`CMD-PR-TO-FD-POP` PR_TO_FD_POP	Numeric 8 (yyyymmdd)	Previous Funded Begin Date - Period of Performance Dates. Informational only.	BR10.5
`CMD-PR-FR-FD-POP` PR_FR_FD_POP	Numeric 8 (yyyymmdd)	Previous funded period of performance begin date. Informational only.	BR10.5
`CMD-NEW-TO-FD-POP` NEW_TO_FD_POP	Numeric 8 (yyyymmdd)	New funded period of performance begin date. Informational only.	BR10.5
`CMD-NEW-FR-FD-POP` NEW_FR_FD_POP	Numeric 8 (yyyymmdd)	New funded period of performance end date. Informational only.	BR10.5
`CMD-TIME` TIME	Numeric 8	This field is updated automatically to indicate the time that the record was created or maintained. It is system-maintained.	BR10.8

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`CMDSET1`	`CONTRACT`, `MOD-NBR`	Primary	BR10.1, BR10.4, BR10.5, BR10.7, BR10.8, BR212, BR90.1
`CMDSET2`	`CONTRACT`, `APPROVAL-DATE`, `TIME`, `MOD-NBR`	KeyChange	BR10.5, BR90.1
`CMDSET4`	`ACTIVITY-GRP`, `CONTRACT`, `MOD-NBR`	KeyChange	AC300, BR90.1
`CMDSET5`	`ACTIVITY-GRP`, `CONTRACT`, `APPROVAL-DATE`, `TIME`, `MOD-NBR`	KeyChange	BR90.1

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Accntract	ACCNTRACT	Required		`CMD-CONTRACT` → `CNT-CONTRACT`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Accntadx	ACCNTADX			`CMD-CONTRACT` → `CMA-CONTRACT`, `CMD-MOD-NBR` → `CMA-MOD-NBR`, → `CMA-MATRIX-CAT`

Programs

Updated by (5)

AC300 Activity Group Purge
BR10.1 Contract Parameters
BR10.4 Additional Contract Information
BR10.5 Contract Modification
BR10.8 Contract Modification Approval

Referenced by (2)

BR212 Contract Modification Listing
BR90.1 Contract Modification Inquiry