Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SLGROUPDTL


                            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

SL00.2    SL00.5    SLSE.1    SLSR.1    SL02.1

UPDATED BY

SL01.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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


GRD-SEGMENT            Alpha 15                                  SL01.1
Element: 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                                 SL01.1
Element: User Analysis The order the user analysis are used in
                       subsystems.


                         SLGROUPDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GRDSET1   SEGMENT-GROUP                                          SL00.2  SL00.5
          SEGMENT                                                SL01.1  SL01.2
                                                                 SLSE.1  SLSR.1

GRDSET2   SEGMENT-GROUP KeyChange                                SL01.1  SL02.1
          SEGMENT-ORDER
          SEGMENT

GRDSET3   SEGMENT                                                SL00.2
          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

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

Slsegvalue     SLSEGVALUE

                            GRD-SEGMENT          -> SVL-SEGMENT
                                                    SVL-SEGMENT-VALUE

Sltrans        SLTRANS

                            GRD-SEGMENT-GROUP    -> SLT-SEGMENT-GROUP
                                                    SLT-POSTING-DATE
                                                    SLT-OBJ-ID