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     AP25.1    AP25.2    AP26.1
AP27.1    AP30.4    BL120     BL122     BL130     BL20.1
BL20.3    BL21.2    BL21.5    BL29.1    BL29.2    BL520
BL820     BL92.1    IC28.1    MA180     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    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     PO150     PO20.1    PO21.1    PO21.2
PO21.3    PO21.4    PO21.5    PO22.1    PO23.1    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.2    PO38.1    PO39.1    PO39.2    PO44.1
PO50.1    PO52.1    PO520     PO536     POI3.1    POIE.1
POII.1    POIJ.1    RQ10.1    RQ10.2    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 Grp 1

MGR-ELEMENT-GRP-2      Alpha 1                                   MA00.7
Element: Element Grp 2

MGR-ELEMENT-GRP-3      Alpha 10                                  MA00.7
Element: Element Grp 3

MGR-ELEMENT-GRP-4      Alpha 10                                  MA00.7
Element: Element Grp 4

MGR-ELEMENT-GRP-5      Alpha 10                                  MA00.7
Element: Element Grp 5

MGR-ELEMENT-GRP-6      Alpha 10                                  MA00.7
Element: Element Grp 6

MGR-ELEMENT-GRP-7      Alpha 10                                  MA00.7
Element: Element Grp 7

MGR-ELEMENT-GRP-8      Alpha 10                                  MA00.7
Element: Element Grp 8

MGR-ELEMENT-GRP-9      Alpha 10                                  MA00.7
Element: Element Grp 9

MGR-ELEMENT-GRP-10     Alpha 10                                  MA00.7
Element: Element Grp 10

                         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   AP25.1
          ELEMENT-GRP-2                                          AP25.2  AP26.1
          ELEMENT-GRP-3                                          AP27.1  AP30.4
          ELEMENT-GRP-4                                          BL120   BL122
          ELEMENT-GRP-5                                          BL130   BL20.1
          ELEMENT-GRP-6                                          BL20.3  BL21.2
          ELEMENT-GRP-7                                          BL21.5  BL29.1
          ELEMENT-GRP-8                                          BL29.2  BL520
          SEQ-TRNS-NBR                                           BL820   BL92.1
                                                                 IC28.1  MA180
                                                                 MA53.1  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA65.1
                                                                 ...

                         MAELMGPREL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Matchclass     MATCHCLASS   Required

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