SLSEGVALUE – PL User Analysis Value

System
Strategic Ledger (SL)
Prefix
SVL
Primary key
SEGMENT, SEGMENT-VALUE
Fields
6
Updated by
3 programs
Referenced by
21 programs

SLSEGVALUE is the PL User Analysis Value table in Lawson Strategic Ledger (prefix SVL). It is indexed by SEGMENT, SEGMENT-VALUE (SVLSET1); alternate indexes: SVLSET2 and SVLSET3. It is related 1:1 to SLSEGMENT. It is updated by SL00.1, SL00.2 and SL00.3 and referenced by DR100, IC141, IC142, IC83.1, MX202, MX223, RQ10.1, RQ10.3 and 13 more. The table has 6 fields, 3 indexes and 1 documented relation.

About SLSEGVALUE

The Strategic Ledger User Analysis Value (SLSEGVALUE) file stores user analysis values defined in SL00.1 (User Analysis Values). This stores the user analysis name and description the value is defined for, the class associated with the user analysis value, and the status. If you delete a user analysis value, the existing user analysis record is deleted. You can delete user analysis values using the Change form and Delete line actions in SL00.1 or change the Allow Blank field in SL00.2 (Define User Analysis) from Yes to No.

Fields (6)

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

Field / columnTypeDescription & valuesUpdated by
SVL-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.1, SL00.3
SVL-SEGMENT-VALUE PK
SEGMENT_VALUE		Alpha 32The value for the user analysis.SL00.1, SL00.3
SVL-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The user analysis value description. If left blank, the user analysis value identifier defaults.SL00.1, SL00.3
SVL-SEGMENT-RULE
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.1, SL00.3
SVL-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1This field determines the status of the user analysis. If you leave this field blank, Active defaults which lets you use this value in transactions. You can select Inactive, which does not let you use this value.
  • A Active
  • I Inactive
SL00.1, SL00.3
SVL-OBJ-ID
OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.SL00.1, SL00.3

Indexes (3)

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

IndexKeysFlagsConditionUsed in
SVLSET1SEGMENT, SEGMENT-VALUEPrimaryDR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ11.1, RQ13.2 +15 more
SVLSET2SEGMENT-RULE, SEGMENT, SEGMENT-VALUEKeyChangeSL00.4
SVLSET3OBJ-IDMX202, MX223, SLBL.1, SLVW.1

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
SlsegmentSLSEGMENTRequiredSVL-SEGMENT → SEG-SEGMENT

Programs

Updated by (3)

Referenced by (21)