Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SLRELATHDR


                            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
SL01.2

UPDATED BY

SL02.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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


SRH-RELATION           Alpha 15                                  SL02.2
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)                    SL02.2
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
                                                                 SL01.2  SL02.1
                                                                 SL02.2

                         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