Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MAMTCHRULE


                            MAMTCHRULE FILE

                             Matching Rules

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     MA01.1    MA05.1    MA180
MA205     MA279     MA310     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

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

MAU-DESCRIPTION        Alpha 30  (Lower Case)                    MA00.4
Element: Description   This field displays the description.

MAU-MATCH-LEVEL        Alpha 3 Occurs 6 Times                    MA00.4
Element: Match Level   IM = Invoice Match
                       LIM = Line Invoice Match
                       DM = Detail Match

MAU-MA-RULE-TYPE       Alpha 3 Occurs 6 Times                    MA00.4
Element: Ma Rule Type  1-1 = One to One
                       1-A = One to All
                       A-1 = All to One
                       A-A = All to All

MAU-ORDER              Numeric 2 Occurs 6 Times                  MA00.4
Element: Order

MAU-UNDER-TOL-AMT      Signed 18.2 Occurs 6 Times                MA00.4
Element: Intl Amt

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

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

MAU-OVER-TOL-AMT       Signed 18.2 Occurs 6 Times                MA00.4
Element: Intl Amt

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

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

MAU-TOLERANCE-OPT      Numeric 1 Occurs 6 Times                  MA00.4
Element: Tolerance Opt 1 = Extended Amount
                       2 = Unit Cost

MAU-QTY-OVER-AMT       Signed 15.2 Occurs 6 Times                MA00.4
Element: Tran Inv Amt

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

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

MAU-QTY-UNDER-AMT      Signed 15.2 Occurs 6 Times                MA00.4
Element: Tran Inv Amt

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

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

MAU-CHARGEBACK-FL      Alpha 1 Occurs 6 Times                    MA00.4
Element: Account Flag  N = No Chargeback
                       Y = Yes Generate Chargeback

MAU-OVER-COST-AMT      Signed 18.2 Occurs 6 Times                MA00.4
Element: Intl Amt

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

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

MAU-UNDER-COST-AMT     Signed 18.2 Occurs 6 Times                MA00.4
Element: Intl Amt

MAU-UNDER-COST-CON     Alpha 3 Occurs 6 Times                    MA00.4
Element: Po Over Cond

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

MAU-COST-OPEN-MSG      Alpha 1 Occurs 6 Times                    MA00.4
Element: Po Cost Msg Fl

MAU-COST-CLO-MSG       Alpha 1 Occurs 6 Times                    MA00.4
Element: Po Cost Msg Fl

MAU-COST-REASON-CD     Alpha 4 Occurs 6 Times                    MA00.4
Element: Reason Code   This field contains the reason code,
                       which indicates the cause for credit
                       memos.

MAU-OVER-QTY-AMT       Signed 18.2 Occurs 6 Times                MA00.4
Element: Intl Amt

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

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

MAU-UNDER-QTY-AMT      Signed 18.2 Occurs 6 Times                MA00.4
Element: Intl Amt

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

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

MAU-QTY-OPEN-MSG       Alpha 1 Occurs 6 Times                    MA00.4
Element: Po Cost Msg Fl

MAU-QTY-CLO-MSG        Alpha 1 Occurs 6 Times                    MA00.4
Element: Po Cost Msg Fl

MAU-QTY-REASON-CD      Alpha 4 Occurs 6 Times                    MA00.4
Element: Reason Code   This field contains the reason code,
                       which indicates the cause for credit
                       memos.

MAU-REASON-CODE        Alpha 4 Occurs 6 Times
Element: Reason Code   This field contains the reason code,
                       which indicates the cause for credit
                       memos.

                         MAMTCHRULE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

                         MAMTCHRULE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mamsgtol       MAMSGTOL     Required

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