Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCNTRCMTX


                            ACCNTRCMTX FILE

REFERENCED BY

AC09.1    BR252     BR251

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CXM-CONTRACT           Alpha 15                                  BR31.1  BR31.2
Element: Contract      Activity Management contract.             BR31.3  BR31.4
                                                                 BR570

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

CXM-OBJ-ID             Numeric 12                                BR31.1  BR31.2
Element: Obj Id        This is the object identifier. It is      BR31.3  BR31.4
                       used to relate commitments or posted      BR570
                       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
                                                                 BR570

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

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

CXM-SEQ-NBR            Numeric 6                                 BR31.1  BR31.2
Element: Seq Number    A unique number assigned to each          BR31.3  BR31.4
                       transaction to be interfaced into the     BR570
                       Lawson system.

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

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.                    BR570

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


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       BR570
                       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      BR570
                       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                                                BR570

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      KeyChange                                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