Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCNTMOD


                             ACCNTMOD FILE

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.

REFERENCED BY

BR212     BR90.1

UPDATED BY

AC300     BR10.5    BR10.8

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CMD-CONTRACT           Alpha 10                                  BR10.5
Element: Contract      The contract that is being modified. The
                       contract is created on BR10.1 and
                       modified on BR10.5.

CMD-ACTIVITY-GRP       Alpha 15                                  BR10.5
Element: Activity GroupThe activity group associated with the
                       contract related to this record.

CMD-MOD-NBR            Alpha 15  (Lower Case)                    BR10.5
Element: Mod Nbr       The user defined Contract Modification
                       Number created in Contract Modification
                       (BR10.5).

CMD-MOD-DATE           Numeric 8  (yyyymmdd)                     BR10.5
Element: Mod Date      The date the contract was modified. The
                       date will default to the system date if
                       left blank.

CMD-CRT-CREATOR        Alpha 30                                  BR10.5
Element: Crt Creator   The user who created the modification.

CMD-APPROVAL-DESC      Alpha 30  (Lower Case)                    BR10.8
Element: Approval DescrThe status description.
                       The translations are:
                       Unapproved
                       Approved

CMD-LONG-DESC          Alpha 60  (Lower Case)                    BR10.5
Element: Long DescriptiThe Long description of the modification
                       maintained in Contract Modification
                       (BR10.5).

CMD-APPROVAL-DATE      Numeric 8  (yyyymmdd)                     BR10.8
Element: Approval Date The date of the approval.  This is
                       system generated.

CMD-STATUS-CD          Alpha 1                                   BR10.5  BR10.8
Element: Status Cd     The Status Code.
                       The values are:
                       A = Approved
                       U = Unapproved

CMD-PR-CNT-COST        Signed 18.2                               BR10.5
Element: Intl Amt      Previous contract cost amount maintained
                       in Additional information (BR10.4).

CMD-PR-CNT-VAL         Signed 18.2
Element: Intl Amt      The previous Contract Value which is
                       derived from the cost amount and the fee
                       amount.

CMD-PR-CNT-FEE         Signed 18.2                               BR10.5
Element: Intl Amt      The previous Contract Fee maintained in
                       Additional Information (BR10.4)

CMD-ENTR-CNT-COST      Signed 18.2                               BR10.5
Element: Intl Amt      The entered contract cost amount
                       maintained in Contract Modification
                       (BR10.5).

CMD-ENTR-CNT-VALUE     Signed 18.2
Element: Intl Amt      The sum of the entered contract cost and
                       the entered contract fee amounts.

CMD-ENTR-CNT-FEE       Signed 18.2                               BR10.5
Element: Intl Amt      The entered Contract Fee Amount
                       maintained on Contract Modification
                       (BR10.5).

CMD-NEW-CNT-COST       Signed 18.2                               BR10.5
Element: Intl Amt      The new Contract Cost Amount.

CMD-NEW-CNT-FEE        Signed 18.2                               BR10.5
Element: Intl Amt      New Contract Fee Amount.

CMD-NEW-CNT-VAL        Signed 18.2                               BR10.5
Element: Intl Amt      New Contract Value Amount. Sum of new
                       contract cost and new contract fee
                       amounts.

CMD-PR-AWD-COST        Signed 18.2                               BR10.5
Element: Intl Amt      Previous Award Cost Amount.

CMD-PR-AWD-VAL         Signed 18.2
Element: Intl Amt      Previous Award Value.

CMD-PR-AWD-FEE         Signed 18.2                               BR10.5
Element: Intl Amt      Previous Award Fee.

CMD-ENTR-AWD-COST      Signed 18.2                               BR10.5
Element: Intl Amt      Entered Award Cost Amount.

CMD-ENTR-AWARD-VAL     Signed 18.2
Element: Intl Amt      Entered Award Value. Sum of entered
                       award cost and entered award fee
                       amounts.

CMD-ENTR-AWARD-FEE     Signed 18.2                               BR10.5
Element: Intl Amt      Entered Award Fee.

CMD-NEW-AWARD-COST     Signed 18.2                               BR10.5
Element: Intl Amt      New Award Cost.

CMD-NEW-AWARD-FEE      Signed 18.2                               BR10.5
Element: Intl Amt      New Award Fee.

CMD-NEW-AWD-VAL        Signed 18.2                               BR10.5
Element: Intl Amt      New Award Value. Sum of new award cost
                       and new award fee amounts.

CMD-PR-FUND-COST       Signed 18.2                               BR10.5
Element: Intl Amt      Previous Fund Cost.

CMD-PR-FUND-VAL        Signed 18.2
Element: Intl Amt      Previous Fund Value.

CMD-PR-FUND-FEE        Signed 18.2                               BR10.5
Element: Intl Amt      Previous Fund Fee.

CMD-ENTR-FUND-COST     Signed 18.2                               BR10.5
Element: Intl Amt      Entered Fund Cost.

CMD-ENTR-FUND-VAL      Signed 18.2
Element: Intl Amt      Entered Fund Value.  Sum of entered fund
                       cost and entered fund fee amounts.

CMD-ENTR-FUND-FEE      Signed 18.2                               BR10.5
Element: Intl Amt      Entered Fund Fee.

CMD-NEW-FUND-COST      Signed 18.2                               BR10.5
Element: Intl Amt      New Fund Cost

CMD-NEW-FUND-FEE       Signed 18.2                               BR10.5
Element: Intl Amt      New Fund Fee

CMD-NEW-FD-VALUE       Signed 18.2                               BR10.5
Element: Intl Amt      New Fund Value.  Sum of new fund cost
                       and new fund fee amounts.

CMD-PR-CNT-HOURS       Signed 18.2                               BR10.5
Element: Intl Amt      Previous Contract Hours.

CMD-PR-AWD-HOURS       Signed 18.2                               BR10.5
Element: Intl Amt      Previous Awarded Hours.

CMD-PR-FUND-HOURS      Signed 18.2                               BR10.5
Element: Intl Amt      Previous Funded Hours.

CMD-ENTR-CNT-HOURS     Signed 18.2                               BR10.5
Element: Intl Amt      Entered Contract Hours.

CMD-ENTR-AWD-HOURS     Signed 18.2                               BR10.5
Element: Intl Amt      Entered Award Hours.

CMD-ENTR-FD-HOURS      Signed 18.2                               BR10.5
Element: Intl Amt      Entered Funded Hours.

CMD-NEW-CNT-HOURS      Signed 18.2                               BR10.5
Element: Intl Amt      New Contract Hours.

CMD-NEW-AWD-HOURS      Signed 18.2                               BR10.5
Element: Intl Amt      New Award Hours.

CMD-NEW-FD-HOURS       Signed 18.2                               BR10.5
Element: Intl Amt      New Funded Hours.

CMD-PR-TO-TOT-POP      Numeric 8  (yyyymmdd)                     BR10.5
Element: Pr To Tot Pop Previous Contract Begin Date - Contract
                       Period  of Performance Dates.
                       Informational only.

CMD-PR-FR-TOT-POP      Numeric 8  (yyyymmdd)                     BR10.5
Element: Pr Fr Tot Pop Previous Contract End Date - Period of
                       Performance Dates.  Informational only.

CMD-NEW-TO-TOT-POP     Numeric 8  (yyyymmdd)                     BR10.5
Element: New To Tot PopNew Contract Begin Date - Period of
                       Performance Dates.  Informational only.

CMD-NEW-FR-TOT-POP     Numeric 8  (yyyymmdd)                     BR10.5
Element: New Fr Tot PopNew Contract End Date - Period of
                       Performance Dates.  Informational only.

CMD-PR-TO-AWD-POP      Numeric 8  (yyyymmdd)                     BR10.5
Element: Pr To Awd Pop Previous Award Begin Date - Period of
                       Performance Dates.  Informational Only.

CMD-PR-FR-AWD-POP      Numeric 8  (yyyymmdd)                     BR10.5
Element: Pr Fr Awd Pop Previous Award End Date - Period of
                       Performance Dates.  Informational only.

CMD-NEW-TO-AWD-POP     Numeric 8  (yyyymmdd)                     BR10.5
Element: New To Awd PopNew Award Begin Date - Period of
                       Performance Dates.  Informational only.

CMD-NEW-FR-AWD-POP     Numeric 8  (yyyymmdd)                     BR10.5
Element: New Fr Awd PopNew Award End Date - Period of
                       Performance Dates.  Informational only.

CMD-PR-TO-FD-POP       Numeric 8  (yyyymmdd)                     BR10.5
Element: Pr To Fd Pop  Previous Funded Begin Date - Period of
                       Performance Dates.  Informational only.

CMD-PR-FR-FD-POP       Numeric 8  (yyyymmdd)                     BR10.5
Element: Pr Fr Fd Pop  Previous funded period of performance
                       begin date.  Informational only.

CMD-NEW-TO-FD-POP      Numeric 8  (yyyymmdd)                     BR10.5
Element: New To Fd Pop New funded period of performance begin
                       date.  Informational only.

CMD-NEW-FR-FD-POP      Numeric 8  (yyyymmdd)                     BR10.5
Element: New Fr Fd Pop New funded period of performance end
                       date.  Informational only.

CMD-TIME               Numeric 8                                 BR10.8
Element: Time          This field is updated automatically to
                       indicate the time that the record was
                       created or maintained. It is
                       system-maintained.

                         ACCNTMOD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CMDSET1   CONTRACT                                               BR10.4  BR10.5
          MOD-NBR                                                BR10.7  BR10.8
                                                                 BR212   BR90.1

CMDSET2   CONTRACT      KeyChange                                BR10.5  BR90.1
          APPROVAL-DATE
          TIME
          MOD-NBR

CMDSET4   ACTIVITY-GRP  KeyChange                                AC300   BR90.1
          CONTRACT
          MOD-NBR

CMDSET5   ACTIVITY-GRP  KeyChange                                BR90.1
          CONTRACT
          APPROVAL-DATE
          TIME
          MOD-NBR

                         ACCNTMOD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accntract      ACCNTRACT    Required

                            CMD-CONTRACT    -> CNT-CONTRACT

                         ACCNTMOD FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accntadx       ACCNTADX

                            CMD-CONTRACT    -> CMA-CONTRACT
                            CMD-MOD-NBR     -> CMA-MOD-NBR
                                               CMA-MATRIX-CAT