Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MAMSGTOL


                             MAMSGTOL FILE

REFERENCED BY

AC160     AM115     AM117     AM15.1    AM15.2    AM15.3
AM15.4    AM19.1    AM19.2    AM20.1    AM20.3    AM21.1
AM21.3    AM500     AM51.1    AM551     AM97.1    AP00.3
AP03.3    AP10.1    AP110     AP115     AP125     AP126
AP131     AP20.1    AP20.2    AP20.3    AP20.4    AP20.5
AP20.7    AP21.1    AP210     AP220     AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    AP30.2    AP30.4    AP305
AP510     AP90.1    AP91.1    API1.1    API2.1    API3.1
API4.1    BL120     BL122     BL130     BL20.1    BL20.3
BL21.2    BL21.5    BL29.1    BL29.2    BL520     BL820
BL92.1    MX123     MX500     MA180     MA205     MA279
MA41.1    MA41.2    MA41.4    MA41.7    MA43.1    MA43.2
MA43.3    MA43.4    MA43.6    MA43.7    MA530     MA531
MA540     MA60.2    MA60.3    MA60.5    MA61.1    MA63.1
MA65.1    MA66.2    MA66.3    MA67.2    MA67.3    MA68.2
MA68.3    MA68.5    MA70.1    MA75.1    MA80.1    MAI1.1
PD10.1    PD10.2    PD130     PD20.1    PD20.2    PD20.3
PD235     PO10.1    PO100     PO101     PO120     PO122
PO131     PO20.1    PO21.1    PO21.2    PO21.3    PO21.4
PO21.5    PO22.1    PO220     PO223     PO23.1    PO233
PO24.1    PO25.1    PO25.5    PO25.6    PO25.7    PO253
PO254     PO27.2    PO278     PO29.1    PO30.1    PO30.2
PO30.3    PO300     PO31.1    PO31.2    PO32.2    PO32.4
PO33.1    PO34.1    PO35.1    PO36.1    PO36.2    PO38.1
PO39.1    PO39.2    PO44.1    PO50.1    PO52.1    PO520
PO536     PO54.1    PO54.2    PO54.3    PO54.4    POI3.1
POID.1    POII.1    POIJ.1    PR05.1    PR05.3    PR226
PR247     PR26.1    PR47.1    PR514     UK47.1    RQ10.1
RQ10.2    WH20.2    WH20.7

UPDATED BY

MA00.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MGT-MATCH-RULE         Alpha 10                                  MA00.4
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: Tran Inv Amt

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: Tran Inv Amt

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                                             AC160   AM115
                                                                 AM117   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP00.3
                                                                 AP03.3  AP10.1
                                                                 AP110   AP115
                                                                 AP125   AP126
                                                                 AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 ...

                         MAMSGTOL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mamtchrule     MAMTCHRULE   Required

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