Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            MAELMGPREL FILE

REFERENCED BY

MA65.1    PO85.1    POIJ.1

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                                            MA65.1  PO85.1
          ELEMENT-GRP-1                                          POIJ.1
          ELEMENT-GRP-2
          ELEMENT-GRP-3
          ELEMENT-GRP-4
          ELEMENT-GRP-5
          ELEMENT-GRP-6
          ELEMENT-GRP-7
          ELEMENT-GRP-8
          SEQ-TRNS-NBR

                         MAELMGPREL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Matchclass     MATCHCLASS   Required

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