Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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

SLSE.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


SRD-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).

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


SRD-SEGMENT-RULE     Alpha 5 Occurs 52 Times
Class                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                                          SLSE.1
          RELATION
          SEQ-NUMBER

SRDSET2   SEGMENT-GROUP
          RELATION
          SEQ-NUMBER*