Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             SLSLVALUE FILE

                          PL Value Validation

The Strategic Ledger Value Validation (SLSLVALUE) is used by OLAP reporting
environment to verify user analysis values exist.


FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

SLV-LEDGER           Alpha 15
Ledger               The name that identifies the strategic
                     ledger.

                     The Ledger information is used to post
                     Strategic ledger data using SL190
                     (Strategic Ledger Posting) or used for
                     reporting in the OLAP environment using
                     SL87 (Strategic Ledger Data Mart Setup).


SLV-SEGMENT          Alpha 15
User Analysis        The name that identifies the user
                     analysis.

                     A user analysis is a flexible,
                     user-defined element, much like an
                     accounting unit, account, or attribute,
                     that stores transaction information you
                     can use for reports and analysis.

                     You can use a user analysis to track
                     multiple elements of business data.




SLV-SEGMENT-VALUE    Alpha 32
User Analysis Value  The value for the user analysis.

SLV-SEGMENT-VAL-ID   Numeric 12
Segment Val Id       The user analysis value identification.

                         SLSLVALUE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SLVSET1   LEDGER
          SEGMENT
          SEGMENT-VALUE

SLVSET2   LEDGER
          SEGMENT
          SEGMENT-VAL-ID

                         SLSLVALUE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Slledger       SLLEDGER     Required

                            SLV-LEDGER    -> SLL-LEDGER  (SLLSET1)