Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SIRDIDSTT


                             SIRDIDSTT FILE

UPDATED BY

RD87.1    RD87.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IDS-ID                 Alpha 20  (Lower Case)                    RD87.1  RD87.2
Element: Id

IDS-STRUCTURE          Alpha 10  (Lower Case)                    RD87.1  RD87.2
Element: Structure

IDS-DATE               Numeric 8  (yyyymmdd)                     RD87.1  RD87.2
Element: Date          This field contains the system date
                       when this was created.

IDS-TIME               Numeric 6  (hhmmss)                       RD87.1  RD87.2
Element: Time

IDS-ID-RECORD          Derived
Element: Id Record

                         SIRDIDSTT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IDSSET1   ID                                                     RD87.1  RD87.2
          STRUCTURE

IDSSET2   STRUCTURE
          ID

                         SIRDIDSTT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sirdidhdr      SIRDIDHDR    Required

                            IDS-ID           -> IDH-ID  (IDHSET1)

Sirdstruct     SIRDSTRUCT   Required

                            IDS-STRUCTURE    -> STR-STRUCTURE

                         SIRDIDSTT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sirdgrpid      SIRDGRPID

                            IDS-ID           -> GID-ID
                                                GID-ROLE
                                                GID-GROUP

Sirdidgrp      SIRDIDGRP

                            IDS-ID           -> WDG-ID
                                                WDG-GROUP

Sirdstrdtl     SIRDSTRDTL

                            IDS-STRUCTURE    -> STD-STRUCTURE
                                                STD-LEVEL