Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MAMSGTOL


                             MAMSGTOL FILE

REFERENCED BY

AP125     AP126     AP20.1    AP20.2    AP20.3    AP20.4
AP20.5    AP20.7    AP23.1    AP25.1    AP25.2    AP26.1
AP27.1    MA205     MA41.2    MA43.1    MA43.2    MA43.3
MA540

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 15.2 Occurs 6 Times                MA00.4
Element: Invoice AmountAdd dollar amount which will be used as
                       the match tolerance.  If the receipt and
                       invoice match within this dollar amount
                       the match will be successful.

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   Enter a specifi percent.  If the
                       difference between the receipt and the
                       invoice fall within that percent the
                       message will not be created.

MGT-PO-UNDER-CST       Signed 15.2 Occurs 6 Times                MA00.4
Element: Invoice AmountAdd a dollar amount which will be used
                       as the match tolerance.  If the receipt
                       and the invoice match within this dollar
                       amount no message will be created.

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   Enter a specific percent tolerance.  If
                       the difference between the receipt and
                       the invoice fall within that percent the
                       message will not be created.

MGT-DR-OV-COST-AMT     Signed 15.2 Occurs 6 Times                MA00.4
Element: Invoice AmountAdd a dollar amount which will be used
                       as the match tolerance.  If the receipt
                       and invoice match within this dollar
                       amount the message will not be created.

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   Enter a specific percent tolerance.  If
                       the difference between the receipt and
                       invoice fall within the percent the
                       message will not be created.

MGT-DR-UN-COST-AMT     Signed 15.2 Occurs 6 Times                MA00.4
Element: Invoice AmountAdd a dollar amount which will be used
                       as the match tolerance.  If the receipt
                       and invoice match within this dollar
                       amount the message will not be created.

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   Enter a specific percent.  If the
                       difference between the receipt and
                       invoice fall within that percent the
                       message will not be created.

MGT-DR-OV-QTY-AMT      Signed 15.2 Occurs 6 Times                MA00.4
Element: Invoice AmountAdd a dollar amount which will be used
                       as the match tolerance.  If the receipt
                       and invoice match within the dollar
                       amount the message will not be created

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   Enter a specific percent tolerance.  If
                       the difference between the receipt and
                       invoice fall within that percent the
                       message will not be created.

MGT-DR-UN-QTY-AMT      Signed 15.2 Occurs 6 Times                MA00.4
Element: Invoice AmountAdd a dollar amount which will be used
                       as the match tolerance.  If the receipt
                       and invoice match within this dollar
                       amount the message will not be created.

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   Enter a specific percent tolerance.  If
                       the differnece between the receipt and
                       invoice fall within that percent the
                       message will not be created.

MGT-SV-OV-COST-AMT     Signed 15.2 Occurs 6 Times                MA00.4
Element: Invoice AmountAdd a dollar amount which will be used
                       as the match tolerance.  If the receipt
                       and invoice match within this dollar
                       amount the message will not be created.

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   Enter a specific percent tolerance.  If
                       the difference between the receipt and
                       invoice fall within that percent the
                       message will not be created.

MGT-SV-UN-COST-AMT     Signed 15.2 Occurs 6 Times
Element: Invoice AmountAdd a dollar amount which will be used
                       as the match tolerance.  If the receipt
                       and invoice match within this dollar
                       amount the message will not be created.

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   Enter a specific percent tolerance.  If
                       the difference between the receipt and
                       invoice fall within the percent a
                       message will not be created.

                         MAMSGTOL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MGTSET1   MATCH-RULE                                             AP125   AP126
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  MA00.1
                                                                 MA00.4  MA205
                                                                 MA41.2  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA540

                         MAMSGTOL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mamtchrule     MAMTCHRULE   Required

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