SLSEGRULE – Profitability Ledger Class

System
Strategic Ledger (SL)
Prefix
SGR
Primary key
SEGMENT, SEGMENT-RULE
Fields
4
Updated by
2 programs
Referenced by
1 program

SLSEGRULE is the Profitability Ledger Class table in Lawson Strategic Ledger (prefix SGR). It is indexed by SEGMENT, SEGMENT-RULE (SGRSET1). It is related 1:M to SLSEGVALUE. It is updated by SL00.2 and SL00.4 and referenced by SL02.1. The table has 4 fields, 1 index and 1 documented relation.

About SLSEGRULE

The Strategic Ledger Class (SLSEGRULE) file stores classes assigned to a user analysis defined in SL00.4 (Define Value Class). The user analysis must be a valid user analysis in the Strategic Ledger User Analysis (SLSEGMENT) file. You cannot delete a class assigned to a user analysis that is associated with a user analysis group.

Fields (4)

Column = COBOL field name without the SGR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
SGR-SEGMENT PK
SEGMENT		Alpha 15The 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.SL00.4
SGR-SEGMENT-RULE PK
SEGMENT_RULE		Alpha 5Type or select a class that identifies the user analysis value. Use a class to group user analysis values and to assign specific user analysis values to an account number. You can associate the same user analysis values in different user analysis by defining the same class. Use the Define feature to open SL00.4 (Define Value Class). Use this subform to associate multiple classes with a user analysis.SL00.4
SGR-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The description of the class.SL00.4
SGR-BLANKAM
BLANKAM		DerivedThis field consists of blank spaces. It is used to provide column headings on Drill Arounds.—

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
SGRSET1SEGMENT, SEGMENT-RULEPrimarySL00.1, SL00.2, SL00.3, SL00.4, SL02.1

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
SlsegvalueSLSEGVALUESGR-SEGMENT-RULE → SVL-SEGMENT-RULE, SGR-SEGMENT → SVL-SEGMENT, → SVL-SEGMENT-VALUE

Programs

Updated by (2)

Referenced by (1)