Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MAELMGPREL


                            MAELMGPREL FILE

REFERENCED BY

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.4    API1.1    IC28.1    MA180
MA41.2    MA41.7    MA43.1    MA43.2    MA43.3    MA43.9
MA53.1    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    PO100     PO101
PO122     PO131     PO150     PO20.1    PO21.1    PO21.2
PO21.3    PO21.4    PO21.5    PO22.1    PO23.1    PO25.1
PO25.5    PO25.6    PO25.7    PO27.2    PO29.1    PO30.1
PO30.2    PO30.3    PO300     PO31.1    PO31.2    PO32.2
PO33.1    PO34.1    PO35.1    PO36.1    PO36.2    PO38.1
PO39.1    PO39.2    PO44.1    PO50.1    PO52.1    PO520
PO536     POI3.1    POII.1    POIJ.1    RQ10.1    RQ10.2
RQ10.3    RQIE.1    WH20.2    WH20.7

UPDATED BY

MA00.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MGR-MATCH-CLASS        Alpha 10                                  MA00.7
Element: Match Class

MGR-RELATION           Alpha 15                                  MA00.7
User Analysis          The user analysis value relation
Relation               assigned to the detail or summary
                       account.

                       The relation must exist in SL02.1 (User
                       Analysis Value Relation).

MGR-SEQ-TRNS-NBR       Numeric 10                                MA00.7
Element: Seq Trns Nbr

MGR-ELEMENT-GRP-1      Alpha 10                                  MA00.7
Element: Element Group

MGR-ELEMENT-GRP-2      Alpha 10                                  MA00.7
Element: Element Group Element groups are a means to setting up
                       accounting structures or other relations
                       for interfacing PO to invocie matching
                       to accounts payable.  They can also be
                       used for data analysis.

MGR-ELEMENT-GRP-3      Alpha 10                                  MA00.7
Element: Element Group Element groups are a means to setting up
                       accounting structures or other relations
                       for interfacing PO to invoice matching
                       to accounts payable.  They can also be
                       used for data analysis.

MGR-ELEMENT-GRP-4      Alpha 10                                  MA00.7
Element: Element Group Element groups are a means to setting up
                       accounting structures or other relations
                       for interfacing PO to invoice matching
                       to accounts payable.  They can also be
                       used for data analysis.

MGR-ELEMENT-GRP-5      Alpha 10                                  MA00.7
Element: Element Group Element groups are a means to setting up
                       accounting structures or other relations
                       for interfacing PO to invoice matching
                       to accounts payable.  They can also be
                       used for data analysis.

MGR-ELEMENT-GRP-6      Alpha 10                                  MA00.7
Element: Element Group Element groups are a means to setting up
                       account structures or other relations
                       for interfacing PO to invoice matching
                       to accounts payable.  They can also be
                       used for data analysis.

MGR-ELEMENT-GRP-7      Alpha 10                                  MA00.7
Element: Element Group Element groups are a means to setting up
                       accounting structures or other relations
                       for interfacing PO to invoice matching
                       to accounts payable.  They can also be
                       used for data analysis.

MGR-ELEMENT-GRP-8      Alpha 10                                  MA00.7
Element: Element Group Element groups are a means to setting up
                       accounting structures or other relations
                       for interfacing PO to invoice matching
                       to accounts payable.  They can also be
                       used for data analysis.

MGR-ELEMENT-GRP-9      Alpha 10                                  MA00.7
Element: Element Group Element groups are a means to setting up
                       accounting structures or other relations
                       for interfacing PO to invoice matching
                       to accounts payable.  They can also be
                       used for data analysis.

MGR-ELEMENT-GRP-10     Alpha 10                                  MA00.7
Element: Element Group Element groups are a means to setting up
                       accounting structures or other relations
                       for interfacing PO to invoice matching
                       to accounts payable.  They can also be
                       used for data analysis.

                         MAELMGPREL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MGRSET1   MATCH-CLASS                                            MA00.7
          RELATION
          SEQ-TRNS-NBR

MGRSET2   MATCH-CLASS                                            AP125   AP126
          ELEMENT-GRP-1                                          AP131   AP20.1
          ELEMENT-GRP-2                                          AP20.2  AP20.3
          ELEMENT-GRP-3                                          AP20.4  AP20.5
          ELEMENT-GRP-4                                          AP20.7  AP23.1
          ELEMENT-GRP-5                                          AP25.1  AP25.2
          ELEMENT-GRP-6                                          AP26.1  AP27.1
          ELEMENT-GRP-7                                          AP30.4  API1.1
          ELEMENT-GRP-8                                          IC28.1  MA180
          SEQ-TRNS-NBR                                           MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 MA53.1  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 ...

                         MAELMGPREL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Matchclass     MATCHCLASS   Required

                            MGR-MATCH-CLASS    -> MAL-MATCH-CLASS