Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            SLRELATDTL FILE

                          SL Relations Detail

The Strategic Ledger Relations Detail (SLRELATDTL) file stores user analysis
relation information defined in SL02.1 (User Analysis Value Relations),
including the user analysis group name defined in SL01.1 (User Analysis
Group), user analysis relation name SL02.2 (Define Relation), and the rule
codes associated with the user analysis defined in SL00.1 (User Analysis
Values).

Before you can define a user analysis relation, valid relation information
must exist in the Strategic Ledger Relations Header (SLRELATHDR) file. The
user analysis group associated with the relation must be valid in the
SLGROUPDTL file.

You use a user analysis relation to assign specific user analysis values to
accounts in the General Ledger system in GL00.4 (Account Information) and
GL00.5 (Summary Account Information). You cannot delete a user analysis
relation assigned to an account and transactions exist in the General Ledger
Transaction (GLTRANS) file.

REFERENCED BY

SL01.1    SL00.4    SLSE.1

UPDATED BY

SL02.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


SRD-RELATION         Alpha 15                                    SL02.1
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).



SRD-SEQ-NUMBER       Numeric 6                                   SL02.1
Sequence Number      A unique number assigned to each
                     transaction to be transferred into the
                     Lawson system.

SRD-SEGMENT-RULE-1   Alpha 5                                     SL02.1
Class 1              The first relation identified in SL02.1.

SRD-SEGMENT-RULE-2   Alpha 5                                     SL02.1
Class 2              The second relation defined in SL02.1.

SRD-SEGMENT-RULE-3   Alpha 5                                     SL02.1
Class 3              The third relation identified in SL02.1.

SRD-SEGMENT-RULE-4   Alpha 5                                     SL02.1
Class 4              The last relation identified in SL02.1.

                         SLRELATDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SRDSET1   SEGMENT-GROUP                                          SL01.1  SL02.1
          RELATION                                               SL02.2
          SEQ-NUMBER

SRDSET2   SEGMENT-GROUP                                          SL02.1
          RELATION
          SEQ-NUMBER*

SRDSET3   SEGMENT-GROUP KeyChange                                SL00.4  SL02.1
          RELATION                                               SLSE.1
          SEGMENT-RULE-1
          SEGMENT-RULE-2
          SEGMENT-RULE-3
          SEGMENT-RULE-4
          SEQ-NUMBER