Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            SLRELATHDR FILE

                          PL Relations Header

The Strategic Ledger User Analysis Relation Header (SLRELATHDR) file stores
user analysis relation header information (the user analysis group and
relation name) defined in SL02.1 (User Analysis Value Relations).

The Strategic Ledger User Analysis Relation Detail (SLRELATDTL) file stores
the user analysis group, relation, and rule codes.



REFERENCED BY

GL100     GL00.1    GL00.3    GL02.1    GL02.2    GL02.3

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

SRH-SEGMENT-GROUP    Alpha 15
User Analysis Group  A user analysis group is a combination
                     of up to four user analysis for reports
                     and analysis.


SRH-RELATION         Alpha 15
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).

SRH-DESCRIPTION      Alpha 30  (Lower Case)
User Analysis        This is the user analysis relation
Relation Desc        description.


                         SLRELATHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SRHSET1   SEGMENT-GROUP                                          GL100   GL00.1
          RELATION                                               GL00.3  GL02.1
                                                                 GL02.2  GL02.3

                         SLRELATHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glchart Acct   GLCHARTDTL

                            SRH-RELATION    -> GDT-CHART-NAME
                                               GDT-SUMRY-ACCT-ID
                                               GDT-ACCOUNT
                                               GDT-SUB-ACCOUNT