Lawson Insight Technical Documentation

                            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

AP10.1    AP110     AP115     AP125     AP126     AP131
AP20.1    AP20.2    AP20.3    AP20.4    AP20.5    AP20.7
AP23.1    AP25.1    AP25.2    AP26.1    AP27.1    AP30.2
AP30.4    AP305     AP510     API1.1    API2.1    API3.1
API4.1    IC28.1    IC840     MA01.1    MA126     MA180
MA205     MA310     MA41.1    MA41.2    MA43.1    MA43.2
MA43.3    MA43.4    MA43.5    MA43.7    MA43.8    MA43.9
MA530     MA531     MA60.2    MA60.3    MA60.5    MA61.1
MA63.1    MA65.1    MA66.2    MA66.3    MA67.1    MA67.2
MA70.1    MAI1.1    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    RQ10.1
RQ10.2    WH20.2    WH20.7

UPDATED BY

MA00.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MAM-MATCH-TABLE      Alpha 10                                    MA00.1
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
Match Table Type     Indicates 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
Rule 1

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

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

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

                         MAMATCHTBL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MAMSET1   MATCH-TABLE                                            AP10.1  AP110
                                                                 AP115   AP125
                                                                 AP126   AP131
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 AP510   API1.1
                                                                 API2.1  API3.1
                                                                 API4.1  IC28.1
                                                                 IC840   MA00.1
                                                                 MA01.1  MA126
                                                                 ...