Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACMNTSCHX


                             ACMNTSCHX FILE

REFERENCED BY

BR252

UPDATED BY

BR154     BR51.1    BR52.1    BR52.3    BRIP.1    BR02.3
BR120     BR121     BR122     BR123     BR140     BR151
BR152     BR156     BR157     BR20.1    BR20.2    BR20.3
BR20.4    BR20.5    BR420     BR521

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MSD-CONTRACT           Alpha 15                                  BR51.1  BR52.1
Element: Contract      Activity Management contract.             BR52.3  BRIP.1

MSD-MAINT-SCHEDULE     Alpha 15                                  BR51.1  BR52.1
Element: Maint Schedule                                          BR52.3  BRIP.1

MSD-OBJ-ID             Numeric 12                                BR51.1  BR52.1
Element: Obj Id        This is the object identifier. It is      BR52.3  BRIP.1
                       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.

MSD-PRODUCT            Alpha 15                                  BR51.1  BR52.1
Element: Product                                                 BR52.3  BRIP.1

MSD-PROD-VERSION       Alpha 10                                  BR51.1  BR52.1
Element: Prod Version                                            BR52.3  BRIP.1

MSD-TRAN-DATE          Numeric 8  (yyyymmdd)                     BR51.1  BR52.1
Element: Tran Date                                               BR52.3  BRIP.1

MSD-GLT-OBJ-ID         Numeric 12                                BR154   BR51.1
Element: Obj Id        This is the object identifier. It is      BR52.1  BRIP.1
                       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.

MSD-ATN-OBJ-ID         Numeric 12                                BR154   BR51.1
Element: Obj Id        This is the object identifier. It is      BR52.1  BRIP.1
                       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.

MSD-REVENUE-AMT        Signed 18.2                               BR51.1  BR52.1
Element: Intl Amt                                                BR52.3  BRIP.1

MSD-STATUS             Numeric 1                                 BR154   BR51.1
Element: Status        This field displays the status of the     BR52.1  BR52.3
                       transaction.                              BRIP.1
                       1 = To Process
                       2 = Processed
                       3 = Hold

MSD-SITE-LOCATION      Numeric 2                                 BR51.1  BR52.1
Element: Site Location                                           BR52.3  BRIP.1

                         ACMNTSCHX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MSDSET1   CONTRACT                                               BR02.3  BR120
          MAINT-SCHEDULE                                         BR121   BR122
          OBJ-ID                                                 BR123   BR140
          TRAN-DATE                                              BR151   BR152
                                                                 BR156   BR157
                                                                 BR20.1  BR20.2
                                                                 BR20.3  BR20.4
                                                                 BR20.5  BR252
                                                                 BR420   BR51.1
                                                                 BR52.1  BR52.3
                                                                 BR52.7  BR521
                                                                 BRIP.1

MSDSET2   GLT-OBJ-ID    KeyChange
          ATN-OBJ-ID
          CONTRACT
          MAINT-SCHEDULE
          PRODUCT
          PROD-VERSION
          OBJ-ID
          TRAN-DATE

MSDSET3   CONTRACT      KeyChange                                BR154   BR52.3
          MAINT-SCHEDULE
          PRODUCT
          PROD-VERSION
          OBJ-ID
          TRAN-DATE

                         ACMNTSCHX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accntract      ACCNTRACT    Required

                            MSD-CONTRACT          -> CNT-CONTRACT

Acmnthdr       ACMNTHDR     Required

                            MSD-CONTRACT          -> MSE-CONTRACT
                            MSD-MAINT-SCHEDULE    -> MSE-MAINT-SCHEDULE

Acmntsch       ACMNTSCH     Required

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

Acproddtl      ACPRODDTL    Required

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

Actrans        ACTRANS      Not Required

                            MSD-ATN-OBJ-ID        -> ATN-OBJ-ID

Gltrans        GLTRANS      Not Required

                            MSD-GLT-OBJ-ID        -> GLT-OBJ-ID

                         ACMNTSCHX FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acproduser     ACPRODUSER

                            MSE-PRODUCT-LIST      -> BRU-PRODUCT-LIST
                            MSD-PRODUCT           -> BRU-PRODUCT
                            MSD-PROD-VERSION      -> BRU-PROD-VERSION
                            MSC-EFFECTIVE-DT      -> BRU-EFFECTIVE-DT
                                                     BRU-RECORD-TYPE
                                                     BRU-MAX-USERS