Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SLRELATDTL


                            SLRELATDTL FILE

                          PL 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    SLSE.1

UPDATED BY

SL02.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SRD-SEGMENT-GROUP      Alpha 15                                  SL02.1
Element: User Analysis 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
Element: Sequence NumbeA unique number assigned to each
                       transaction to be interfaced into the
                       Lawson system.

SRD-SEGMENT-RULE       Alpha 5 Occurs 52 Times                   SL02.1
Element: Segment Rule  Type or select a class that identifies
                       the user analysis value. Use a class to
                       group user analysis values and to assign
                       specific user analysis values to an
                       account number.

                       You can associate the same user
                       analysis values in different user
                       analysis by defining the same class.

                       Use the Define feature to open SL00.4
                       (Define Value Class). Use this subform
                       to associate multiple classes with a
                       user analysis.

                         SLRELATDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

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