|
|
SLRELATDTL FILE
SL Relations Detail
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.
REFERENCED BY
SL01.1 SL00.4 SLSE.1
UPDATED BY
SL02.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SRD-SEGMENT-GROUP Alpha 15 SL02.1
User Analysis Group A user analysis group is a combination
of up to four user analysis for reports
and analysis.
SRD-RELATION Alpha 15 SL02.1
User Analysis The user analysis value relation
Relation assigned to the detail or summary
account.
The relation must exist in SL02.1 (User
Analysis Value Relation).
SRD-SEQ-NUMBER Numeric 6 SL02.1
Sequence Number A unique number assigned to each
transaction to be transferred into the
Lawson system.
SRD-SEGMENT-RULE-1 Alpha 5 SL02.1
Class 1 The first relation identified in SL02.1.
SRD-SEGMENT-RULE-2 Alpha 5 SL02.1
Class 2 The second relation defined in SL02.1.
SRD-SEGMENT-RULE-3 Alpha 5 SL02.1
Class 3 The third relation identified in SL02.1.
SRD-SEGMENT-RULE-4 Alpha 5 SL02.1
Class 4 The last relation identified in SL02.1.
SLRELATDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SRDSET1 SEGMENT-GROUP SL01.1 SL02.1
RELATION SL02.2
SEQ-NUMBER
SRDSET2 SEGMENT-GROUP SL02.1
RELATION
SEQ-NUMBER*
SRDSET3 SEGMENT-GROUP KeyChange SL00.4 SL02.1
RELATION SLSE.1
SEGMENT-RULE-1
SEGMENT-RULE-2
SEGMENT-RULE-3
SEGMENT-RULE-4
SEQ-NUMBER
|