SLGROUPDTL FILE

                            SL 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    SL00.4    SLSE.1    SLSR.1    SL02.1
SLTV.1

UPDATED BY

SL01.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


GRD-SEGMENT          Alpha 15                                    SL01.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.




GRD-SEGMENT-ORDER    Numeric 1                                   SL01.1
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                                          SL00.2  SL00.5
          SEGMENT                                                SL01.1  SL01.2
                                                                 SLSE.1  SLSR.1

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

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