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

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     AP131     AP25.1    AP25.2    AP26.1    AP27.1
AP30.4    AP510     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
IC28.1    IC840     MA01.1    MA180     MA205     MA310
MA530     MA531     MA540     MA60.2    MA60.3    MA60.5
MA61.1    MA66.2    MA66.3    MA67.1    MA67.2    MA70.1
MA700     MA75.1    MA80.1    MAI1.1    OE10.1    OE10.2
OE10.3    OE10.4    OE10.5    OE10.6    OE10.7    OE10.8
OE11.1    OE11.4    OE11.8    OE11.9    OE110     OE111
OE113     OE114     OE116     OE129     OE13.2    OE13.3
OE13.5    OE13.6    OE14.4    OE30.1    OE30.2    OE30.3
OE30.4    OE30.5    OE30.6    OE30.7    OE30.9    OE510
OE530     OE81.1    OE810     OE830     OE90.1    OE90.2
PO100     PO101     PO122     PO131     PO20.1    PO21.2
PO21.3    PO21.4    PO21.5    PO22.1    PO23.1    PO29.1
PO30.1    PO30.2    PO30.3    PO300     PO31.1    PO31.2
PO32.2    PO33.1    PO34.1    PO35.1    PO38.1    PO39.1
PO39.2    PO44.1    PO50.1    PO52.1    PO520     POI3.1
POIE.1    POII.1    POIJ.1    PR05.1    PR05.3    PR226
PR247     PR26.1    PR47.1    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: Invoice Amount

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: Invoice Amount

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

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

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                                             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   AP131
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  AP510
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 ...

                         MAMTCHRULE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mamsgtol       MAMSGTOL     Required

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