| 
 | 
                            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
Sltrans        SLTRANS
                            GRD-SEGMENT-GROUP    -> SLT-SEGMENT-GROUP
                                                    SLT-POSTING-DATE
                                                    SLT-OBJ-ID
 |