Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MAMATCHTBL


                            MAMATCHTBL FILE

                              Match Table

The Match Table file contains the definition of a match table and its
associated processing rules. Match tables are defined in MA00.1 (Match Table).

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    MA168     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     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    MA69.1    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.1    MA999

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MAM-MATCH-TABLE        Alpha 10                                  MA00.1
Element: Match Table   A code representing the matching table.

MAM-DESCRIPTION        Alpha 30  (Lower Case)                    MA00.1
Match Table            A description of the matching table.
Description

MAM-MATCH-TYPE         Alpha 1                                   MA00.1
Element: Match Table TyIndicates which at which level
                       (company, vendor, or both) the record is
                       available for matching. Valid values
                       are:

                       C = Company
                       V = Vendor
                       B = Both

MAM-RULE-1             Alpha 10                                  MA00.1
Element: Rule 1

MAM-RULE-2             Alpha 10                                  MA00.1
Element: Rule 2

MAM-RULE-3             Alpha 10                                  MA00.1
Element: Rule 3

MAM-CB-TYPE            Alpha 1                                   MA00.1  MA999
Element: Cb Type       N = Net
                       O = Overbill

                         MAMATCHTBL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MAMSET1   MATCH-TABLE                                            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
                                                                 ...