Lawson Insight Technical Documentation

                            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    IC28.1    MA180     MA41.2    MA43.2
MA43.9    MA530     MA531     MA60.2    MA60.3    MA60.5
MA61.1    MA65.1    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
PO27.3    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     PO85.1    POI3.1    POIE.1    POII.1    POIJ.1
RQ10.1    RQ10.2    RQ10.3    WH20.2    WH20.7

UPDATED BY

MA00.7

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MGR-MATCH-CLASS      Alpha 10                                    MA00.7
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
Seq Trns Nbr

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

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

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

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

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

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

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

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

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

MGR-ELEMENT-GRP-10   Alpha 10                                    MA00.7
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  AP23.1
          ELEMENT-GRP-5                                          AP25.1  AP25.2
          ELEMENT-GRP-6                                          AP26.1  AP27.1
          ELEMENT-GRP-7                                          IC28.1  MA180
          ELEMENT-GRP-8                                          MA41.2  MA43.2
          SEQ-TRNS-NBR                                           MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA65.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.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