SLTRANDTL – No description in the Lawson data dictionary

System
Strategic Ledger (SL)
Prefix
STD
Primary key
SLT-OBJ-ID, SEGMENT-ORDER
Fields
3
Updated by
16 programs
Referenced by
0 programs

SLTRANDTL is a Lawson Strategic Ledger table (prefix STD); no description in the lawson data dictionary. It is indexed by SLT-OBJ-ID, SEGMENT-ORDER (STDSET1). It is related 1:1 to SLTRANS. It is updated by AC45.1, GL146, GL190, GL191, GL197, GL199, GL40.1, GL40.2 and 8 more. The table has 3 fields, 1 index and 1 documented relation.

About SLTRANDTL

No description in the Lawson data dictionary.

Fields (3)

Column = COBOL field name without the STD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#STD-SLT-OBJ-ID PK
SLT_OBJ_ID		Numeric 12—AC45.1, GL146, GL190, GL191, GL197, GL199, GL40.1, GL40.2 +8 more
#STD-SEGMENT-ORDER PK
SEGMENT_ORDER		Numeric 2The order the user analysis are used in subsystems.AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +6 more
#STD-SEGMENT-VALUE
SEGMENT_VALUE		Alpha 32The value for the user analysis.AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +6 more

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
STDSET1
  1. SLT-OBJ-ID
  2. SEGMENT-ORDER
PrimaryGL146, GL190, GL197, GL199, GL40.1, GL40.2, GL40.3, GL40.6 +4 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
SLTRANSSLTRANDTL

One to one (1) — lookups and parents

RelationTableRulesConditionField map
SltransSLTRANSRequired
STD-SLT-OBJ-ID→SLT-OBJ-ID

Programs

Updated by (16)