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