Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCNTRCMTX


                            ACCNTRCMTX FILE

The ACCNTRCMTX file stores comments for a contract at both the product header
and product detail levels. The data in this file is primarily updated by
Contract Comments (BR31.1) and Product Comments (BR31.2). The ACCNTRCMTX file
has relationships with the ACPRODHDR, ACPRODDTL, ACCNTRACT, ACMNTHDR,
ACMNTSCH, ACCNTRCMT, and ACCMTTYPE files.

REFERENCED BY

AC09.1    BR252     BR251

UPDATED BY

BR31.1    BR31.2    BR31.3    BR31.4    BR52.1    BR52.2
BR51.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CXM-CONTRACT           Alpha 10                                  BR31.1  BR31.2
Element: Contract                                                BR31.3  BR31.4

CXM-MAINT-SCHEDULE     Alpha 15                                  BR31.1  BR31.2
Element: Maint Schedule                                          BR31.3  BR31.4

CXM-OBJ-ID             Numeric 12                                BR31.1  BR31.2
Object                 This is the object identifier. It is      BR31.3  BR31.4
Identification         used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

CXM-PRODUCT            Alpha 15                                  BR31.1  BR31.2
Element: Product                                                 BR31.3  BR31.4

CXM-PROD-VERSION       Alpha 10                                  BR31.1  BR31.2
Element: Prod Version                                            BR31.3  BR31.4

CXM-COMMENT-TYPE       Alpha 2                                   BR31.1  BR31.2
Element: Comment Type                                            BR31.3  BR31.4

CXM-SEQ-NBR            Numeric 4                                 BR31.1  BR31.2
Element: Sequence NumbeAn automatically assigned sequence        BR31.3  BR31.4
                       number.

CXM-CMT-TEXT           Alpha 60  (Lower Case)                    BR31.1  BR31.2
Element: Comment Text  The text associated with the sequence     BR31.3  BR31.4
                       number.

CXM-DATE               Numeric 8  (yyyymmdd)                     BR31.1  BR31.2
Element: Date          This field displays the system date       BR31.3  BR31.4
                       when this was created.

CXM-OPERATOR           Alpha 10                                  BR31.1  BR31.2
Element: Operator Code This field is used to store the login     BR31.3  BR31.4
                       id of the person who entered the record.


CXM-DATE-STAMP         Numeric 8  (yyyymmdd)                     BR31.1  BR31.2
Element: Date Stamp    This field contains the server date       BR31.3  BR31.4
                       (month, date, and year) of the last
                       change to this record.

CXM-TIME-STAMP         Numeric 6  (hhmmss)                       BR31.1  BR31.2
Element: Time Stamp    Contains the server time (hour, minute,   BR31.3  BR31.4
                       and second) when the record was last
                       changed.

                         ACCNTRCMTX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CXMSET1   CONTRACT                                               AC09.1  BR252
          MAINT-SCHEDULE                                         BR31.1  BR31.2
          OBJ-ID                                                 BR31.3  BR31.4
          COMMENT-TYPE                                           BR52.1  BR52.2
          SEQ-NBR

CXMSET2   CONTRACT      KeyChange                                BR251   BR31.1
          MAINT-SCHEDULE                                         BR31.2  BR31.3
          PRODUCT                                                BR31.4
          PROD-VERSION
          OBJ-ID
          COMMENT-TYPE
          DATE*
          SEQ-NBR

CXMSET3   CONTRACT      KeyChange                                BR252   BR51.1
          MAINT-SCHEDULE                                         BR51.2
          PRODUCT
          PROD-VERSION
          OBJ-ID
          COMMENT-TYPE
          SEQ-NBR

CXMSET4   CONTRACT                                               BR31.1  BR31.2
          MAINT-SCHEDULE                                         BR31.3  BR31.4
          OBJ-ID
          SEQ-NBR*
          COMMENT-TYPE*

                         ACCNTRCMTX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accmttype      ACCMTTYPE    Required

                            CXM-COMMENT-TYPE      -> CMN-COMMENT-TYPE

Accntract      ACCNTRACT    Required

                            CXM-CONTRACT          -> CNT-CONTRACT

Acmnthdr       ACMNTHDR     Not Required
                            Valid When (CXM-PRODUCT        =  Spaces
                                  And   CXM-PROD-VERSION   =  Spaces
                                  And   CXM-MAINT-SCHEDULE != Spaces )

                            CXM-CONTRACT          -> MSE-CONTRACT
                            CXM-MAINT-SCHEDULE    -> MSE-MAINT-SCHEDULE

Acmntsch       ACMNTSCH     Required
                            When CXM-MAINT-SCHEDULE != Spaces
                            And  CXM-PRODUCT        != Spaces
                            And  CXM-PROD-VERSION   != Spaces

                            CXM-CONTRACT          -> MSC-CONTRACT
                            CXM-MAINT-SCHEDULE    -> MSC-MAINT-SCHEDULE
                            CXM-PRODUCT           -> MSC-PRODUCT
                            CXM-PROD-VERSION      -> MSC-PROD-VERSION
                            CXM-OBJ-ID            -> MSC-OBJ-ID

Acproddtl      ACPRODDTL    Required
                            When CXM-MAINT-SCHEDULE = Spaces

                            CXM-CONTRACT          -> AHD-CONTRACT
                            CXM-PRODUCT           -> AHD-PRODUCT
                            CXM-PROD-VERSION      -> AHD-PROD-VERSION
                            CXM-OBJ-ID            -> AHD-OBJ-ID

Acprodhdr      ACPRODHDR    Not Required
                            Valid When (CXM-MAINT-SCHEDULE = Spaces
                                  And   CXM-PRODUCT        = Spaces
                                  And   CXM-PROD-VERSION   = Spaces )

                            CXM-CONTRACT          -> AHR-CONTRACT