Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            SLGROUPDTL FILE

                            PL Group Detail

The Strategic Ledger Group Detail (SLGROUPDTL) file stores user analysis
group information defined in SL01.1 (User Analysis Group), including the user
analysis order and user analysis size. User Analysis Groups are used to define
a user analysis relation in SL02.1 (User Analysis Value Relation) and assign
to a chart of accounts in GL00.2 (Define Chart).

A user analysis group is a group of up to four user analysis for reports and
inquiries. User Analysis Group header information is stored in the Strategic
Ledger Group Header (SLGROUPHDR) file.

You cannot remove a user analysis group from a chart or delete a user analysis
group if transactions exist for the group in the General Ledger Transaction
(GLTRANS) file.




REFERENCED BY

SLSE.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


GRD-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.




GRD-SEGMENT-ORDER    Numeric 2
User Analysis Order  The order the user analysis are used in
                     subsystems.


                         SLGROUPDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GRDSET1   SEGMENT-GROUP                                          SLSE.1
          SEGMENT

GRDSET2   SEGMENT-GROUP KeyChange
          SEGMENT-ORDER
          SEGMENT

GRDSET3   SEGMENT
          SEGMENT-GROUP

                         SLGROUPDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Slgrouphdr     SLGROUPHDR   Required

                            GRD-SEGMENT-GROUP    -> SLH-SEGMENT-GROUP  (SLHSET1)

Slsegment      SLSEGMENT    Required

                            GRD-SEGMENT          -> SEG-SEGMENT

                         SLGROUPDTL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Slgroupdtl     SLGROUPDTL

                            GRD-SEGMENT-GROUP    -> GRD-SEGMENT-GROUP
                                                    GRD-SEGMENT

Slrelathdr     SLRELATHDR

                            GRD-SEGMENT-GROUP    -> SRH-SEGMENT-GROUP
                                                    SRH-RELATION