SLRELATHDR – PL Relations Header
- System
- Strategic Ledger (SL)
- Prefix
SRH- Primary key
SEGMENT-GROUP,RELATION- Fields
- 3
- Updated by
- 1 program
- Referenced by
- 7 programs
SLRELATHDR is the PL Relations Header table in Lawson Strategic Ledger (prefix SRH). It is indexed by SEGMENT-GROUP, RELATION (SRHSET1). It is related 1:M to GLCHARTDTL. It is updated by SL02.2 and referenced by GL00.1, GL00.3, GL02.1, GL02.2, GL02.3, GL100 and SL01.2. The table has 3 fields, 1 index and 1 documented relation.
About SLRELATHDR
The Strategic Ledger User Analysis Relation Header (SLRELATHDR) file stores user analysis relation header information (the user analysis group and relation name) defined in SL02.1 (User Analysis Value Relations). The Strategic Ledger User Analysis Relation Detail (SLRELATDTL) file stores the user analysis group, relation, and rule codes.
Fields (3)
Column = COBOL field name without the SRH- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#SRH-SEGMENT-GROUP PKSEGMENT_GROUP | Alpha 15 | A user analysis group is a combination of up to four user analysis for reports and analysis. | SL02.2 |
#SRH-RELATION PKRELATION | Alpha 15 | The user analysis value relation assigned to the detail or summary account. The relation must exist in SL02.1 (User Analysis Value Relation). | SL02.2 |
#SRH-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This is the user analysis relation description. | SL02.2 |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
SRHSET1 |
| Primary | GL100, GL00.1, GL00.3, GL02.1, GL02.2, GL02.3, SL01.2, SL02.1 +1 more |
Relations
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Glchart Acct | GLCHARTDTL |
|
Programs
Updated by (1)
- SL02.2 Define User Analysis Relation