Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             SLTRANVAL FILE

                          SL Transaction Value

The Strategic Ledger Transaction Value (SLTRANVAL) file

UPDATED BY

SLTV.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

TRL-SEGMENT          Alpha 15                                    SLTV.1
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.




TRL-SEGMENT-VALUE    Alpha 32                                    SLTV.1
User Analysis Value  The value for the user analysis.

TRL-OBJ-ID           Numeric 12                                  SLTV.1
Object ID            This is the object identifier. It is
                     used to relate commitments or posted
                     transactions back to the originating
                     subsystems. Each subsystem record that
                     is updated as a commitment or posted
                     transaction is assigned an object
                     identifier. The object identifier is
                     maintained in the subsystem files and in
                     the Activity Commitments Detail and
                     Activity Transaction files. The object
                     identifier is a unique key used to drill
                     back from Activity Management to the
                     subsystems.

                         SLTRANVAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TRLSET1   SEGMENT                                                SLTV.1
          SEGMENT-VALUE

                         SLTRANVAL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Slsegvalue     SLSEGVALUE   Required

                            TRL-SEGMENT          -> SVL-SEGMENT
                            TRL-SEGMENT-VALUE    -> SVL-SEGMENT-VALUE