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    AP21.1    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    AP30.4    API1.1    BL120
BL122     BL130     BL20.1    BL20.3    BL21.2    BL21.5
BL29.1    BL29.2    BL520     BL820     BL92.1    MA180
MA41.1    MA41.2    MA41.4    MA41.7    MA43.1    MA43.2
MA43.3    MA43.7    MA53.1    MA530     MA531     MA60.2
MA60.3    MA60.5    MA61.1    MA65.1    MA66.2    MA66.3
MA67.2    MA67.3    MA68.2    MA68.3    MA68.5    MA70.1
MA75.1    MA80.1    MAI1.1    PD10.1    PD10.2    PD130
PD20.1    PD20.2    PD20.3    PO100     PO101     PO122
PO131     PO150     PO20.1    PO21.1    PO21.2    PO21.3
PO21.4    PO21.5    PO22.1    PO23.1    PO24.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
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     POI3.1    POID.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
Element: Relation      The user analysis value 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   AP20.1
          ELEMENT-GRP-2                                          AP20.2  AP20.3
          ELEMENT-GRP-3                                          AP20.4  AP20.5
          ELEMENT-GRP-4                                          AP20.7  AP21.1
          ELEMENT-GRP-5                                          AP23.1  AP25.1
          ELEMENT-GRP-6                                          AP25.2  AP26.1
          ELEMENT-GRP-7                                          AP27.1  AP30.4
          ELEMENT-GRP-8                                          API1.1  BL120
          SEQ-TRNS-NBR                                           BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  MA180
                                                                 ...

                         MAELMGPREL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Matchclass     MATCHCLASS   Required

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