Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             SLACCOUNT FILE

                               PL Account

The Strategic Ledger Account (SLACCOUNT) file stores ledger information.

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


SLA-LEDGER-ACCOUNT   Numeric 12
Ledger Account       The General Ledger account number
                     associated with a strategic ledger
                     defined in SL50.1.


SLA-SEGMENT-KEY      Alpha 72
Segment Key          The segment key.

SLA-SEG-VALUE-1      Alpha 32
Profitability        Strategic ledger value.
Ledger Value

SLA-SEG-VALUE-2      Alpha 32
Profitability        Strategic ledger value.
Ledger Value

SLA-SEG-VALUE-3      Alpha 32
Profitability        Strategic ledger value.
Ledger Value

SLA-SEG-VALUE-4      Alpha 32
Profitability        Strategic ledger value.
Ledger Value

SLA-SEG-VALUE-5      Alpha 32
Profitability        Strategic ledger value.
Ledger Value

SLA-SEG-VALUE-6      Alpha 32
Profitability        Strategic ledger value.
Ledger Value

SLA-SEG-VALUE-7      Alpha 32
Profitability        Strategic ledger value.
Ledger Value

SLA-SEG-VALUE-8      Alpha 32
Profitability        Strategic ledger value.
Ledger Value

SLA-SEG-VALUE-9      Alpha 32
Profitability        Strategic ledger value.
Ledger Value

SLA-SEG-VALUE-10     Alpha 32
Profitability        Strategic ledger value.
Ledger Value

                         SLACCOUNT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SLASET1   LEDGER
          LEDGER-ACCOUNT

SLASET2   LEDGER
          SEGMENT-KEY

                         SLACCOUNT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Slledger       SLLEDGER     Required

                            SLA-LEDGER            -> SLL-LEDGER  (SLLSET1)

                         SLACCOUNT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Slamounts      SLAMOUNTS    Delete Cascades

                            SLA-LEDGER            -> SAM-LEDGER
                            SLA-LEDGER-ACCOUNT    -> SAM-LEDGER-ACCOUNT
                                                     SAM-FISCAL-YEAR
                                                     SAM-CAL-PERIOD