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

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     AP115
AP125     AP126     AP131     AP25.1    AP25.2    AP26.1
AP27.1    AP30.2    AP30.4    AP305     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
MA126     MA180     MA205     MA310     MA530     MA531
MA60.2    MA60.3    MA60.5    MA61.1    MA65.1    MA66.2
MA66.3    MA67.1    MA67.2    MA70.1    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.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                                            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   AP115
                                                                 AP125   AP126
                                                                 AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 AP510   API1.1
                                                                 ...