SLRELATDTL – User Analysis Value Relation

System
Strategic Ledger (SL)
Prefix
SRD
Primary key
SEGMENT-GROUP, RELATION, SEQ-NUMBER
Fields
4
Updated by
1 program
Referenced by
2 programs

SLRELATDTL is the User Analysis Value Relation table in Lawson Strategic Ledger (prefix SRD). It is indexed by SEGMENT-GROUP, RELATION, SEQ-NUMBER (SRDSET1); alternate indexes: SRDSET2. It is updated by SL02.1 and referenced by SL01.1 and SLSE.1. The table has 4 fields, 2 indexes and 0 documented relations.

About SLRELATDTL

The Strategic Ledger Relations Detail (SLRELATDTL) file stores user analysis relation information defined in SL02.1 (User Analysis Value Relations), including the user analysis group name defined in SL01.1 (User Analysis Group), user analysis relation name SL02.2 (Define Relation), and the rule codes associated with the user analysis defined in SL00.1 (User Analysis Values). Before you can define a user analysis relation, valid relation information must exist in the Strategic Ledger Relations Header (SLRELATHDR) file. The user analysis group associated with the relation must be valid in the SLGROUPDTL file. You use a user analysis relation to assign specific user analysis values to accounts in the General Ledger system in GL00.4 (Account Information) and GL00.5 (Summary Account Information). You cannot delete a user analysis relation assigned to an account and transactions exist in the General Ledger Transaction (GLTRANS) file.

Fields (4)

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

Field / columnTypeDescription & valuesUpdated by
SRD-SEGMENT-GROUP PK
SEGMENT_GROUP		Alpha 15A user analysis group is a combination of up to four user analysis for reports and analysis.SL02.1
SRD-RELATION PK
RELATION		Alpha 15The user analysis value relation assigned to the detail or summary account. The relation must exist in SL02.1 (User Analysis Value Relation).SL02.1
SRD-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6A unique number assigned to each transaction to be interfaced into the Lawson system.SL02.1
SRD-SEGMENT-RULE
SEGMENT_RULE		Alpha 5 Occurs 52 Times ×52Type 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.SL02.1

Indexes (2)

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

IndexKeysFlagsConditionUsed in
SRDSET1SEGMENT-GROUP, RELATION, SEQ-NUMBERPrimarySL01.1, SL02.1, SL02.2, SLSE.1
SRDSET2SEGMENT-GROUP, RELATION, SEQ-NUMBER*SL02.1

Programs

Updated by (1)

Referenced by (2)