SLGROUPDTL

User Analysis 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
Element: User Analysis Group
Alpha 15
A user analysis group is a combination of up to four user analysis for reports and analysis.
SL01.1
GRD-SEGMENT
Element: User Analysis
Alpha 15
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.
SL01.1
GRD-SEGMENT-ORDER
Element: User Analysis Order
Numeric 2
The order the user analysis are used in subsystems.
SL01.1


SLGROUPDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GRDSET1 SEGMENT-GROUP
SEGMENT
SL00.2 SL00.5
SL01.1 SL01.2
SLSE.1 SLSR.1
GRDSET2 SEGMENT-GROUP
SEGMENT-ORDER
SEGMENT
KeyChange
SL01.1 SL02.1
GRDSET3 SEGMENT
SEGMENT-GROUP
SL00.2


SLGROUPDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 02:32:36 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.