Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MAMSGTOL


                             MAMSGTOL FILE

REFERENCED BY

AM115     AM117     AM15.1    AM15.2    AM15.3    AM15.4
AM20.1    AM20.3    AM21.1    AM21.3    AM500     AM51.1
AM551     AM97.1    AP00.3    AP10.1    AP110     AP125
AP126     AP25.1    AP25.2    AP26.1    AP27.1    AP510
API1.1    API2.1    API3.1    API4.1    IC840     MA205
MA540     PR05.1    PR05.3    PR226     PR247     PR26.1
PR47.1    UK47.1

UPDATED BY

MA00.4    MA700

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MGT-MATCH-RULE         Alpha 10                                  MA00.4  MA700
Element: Match Rule

MGT-PO-OVER-CST        Signed 18.2 Occurs 6 Times                MA00.4
Element: Intl Amt

MGT-PO-OVER-COND       Alpha 3 Occurs 6 Times                    MA00.4
Element: Po Over Cond

MGT-PO-OVER-PCT        Percent 7.5  (Percent) Occurs 6 Times     MA00.4
Element: Po Over Pct

MGT-PO-UNDER-CST       Signed 18.2 Occurs 6 Times                MA00.4
Element: Intl Amt

MGT-PO-UNDER-COND      Alpha 3 Occurs 6 Times                    MA00.4
Element: Po Over Cond

MGT-PO-UNDER-PCT       Percent 7.5  (Percent) Occurs 6 Times     MA00.4
Element: Po Over Pct

MGT-DR-OV-COST-AMT     Signed 18.2 Occurs 6 Times                MA00.4
Element: Intl Amt

MGT-DR-OV-COST-CND     Alpha 3 Occurs 6 Times                    MA00.4
Element: Po Over Cond

MGT-DR-OV-COST-PCT     Percent 7.5  (Percent) Occurs 6 Times     MA00.4
Element: Po Over Pct

MGT-DR-UN-COST-AMT     Signed 18.2 Occurs 6 Times                MA00.4
Element: Intl Amt

MGT-DR-UN-COST-CND     Alpha 3 Occurs 6 Times                    MA00.4
Element: Po Over Cond

MGT-DR-UN-COST-PCT     Percent 7.5  (Percent) Occurs 6 Times     MA00.4
Element: Po Over Pct

MGT-DR-OV-QTY-AMT      Signed 15.2 Occurs 6 Times                MA00.4
Element: Invoice Amount

MGT-DR-OV-QTY-CND      Alpha 3 Occurs 6 Times                    MA00.4
Element: Po Over Cond

MGT-DR-OV-QTY-PCT      Percent 7.5  (Percent) Occurs 6 Times     MA00.4
Element: Po Over Pct

MGT-DR-UN-QTY-AMT      Signed 15.2 Occurs 6 Times                MA00.4
Element: Invoice Amount

MGT-DR-UN-QTY-CND      Alpha 3 Occurs 6 Times                    MA00.4
Element: Po Over Cond

MGT-DR-UN-QTY-PCT      Percent 7.5  (Percent) Occurs 6 Times     MA00.4
Element: Po Over Pct

MGT-SV-OV-COST-AMT     Signed 18.2 Occurs 6 Times                MA00.4
Element: Intl Amt

MGT-SV-OV-COST-CND     Alpha 3 Occurs 6 Times                    MA00.4
Element: Po Over Cond

MGT-SV-OV-COST-PCT     Percent 7.5  (Percent) Occurs 6 Times     MA00.4
Element: Po Over Pct

MGT-SV-UN-COST-AMT     Signed 18.2 Occurs 6 Times
Element: Intl Amt

MGT-SV-UN-COST-CND     Alpha 3 Occurs 6 Times
Element: Po Over Cond

MGT-SV-UN-COST-PCT     Percent 7.5  (Percent) Occurs 6 Times
Element: Po Over Pct

                         MAMSGTOL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MGTSET1   MATCH-RULE                                             AM115   AM117
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM20.1  AM20.3
                                                                 AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP00.3  AP10.1
                                                                 AP110   AP125
                                                                 AP126   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP510
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 IC840   MA00.1
                                                                 ...

                         MAMSGTOL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mamtchrule     MAMTCHRULE   Required

                            MGT-MATCH-RULE    -> MAU-MATCH-RULE