Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SIRDSTRUCT


                            SIRDSTRUCT FILE

                               Structure

This file defines organization structures and whether they are group
structures or id structures.

REFERENCED BY

RD87.1    RD87.2

UPDATED BY

RD88.3    RD88.5

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

STR-STRUCTURE          Alpha 10  (Lower Case)                    RD88.3  RD88.5
Element: Structure

STR-ID-TYPE            Alpha 15  (Lower Case)                    RD88.3
Element: Id Type

STR-MAIN               Alpha 1                                   RD88.3
Element: Main          N = No
                       Y = Yes

STR-DESCRIPTION        Alpha 50  (Lower Case)                    RD88.3  RD88.5
Element: Description   This field contains the description.

STR-DATE               Numeric 8  (yyyymmdd)                     RD88.3
Element: Date          This field contains the system date
                       when this was created.

STR-TIME               Numeric 6  (hhmmss)                       RD88.3
Element: Time

STR-TYPE-RECORD        Derived
Element: Type Record

                         SIRDSTRUCT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

STRSET1   STRUCTURE                                              RD87.1  RD87.2
                                                                 RD88.1  RD88.2
                                                                 RD88.3  RD88.4
                                                                 RD88.5

STRSET2   ID-TYPE       KeyChange
          STRUCTURE

                         SIRDSTRUCT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sirdtype       SIRDTYPE     Required

                            STR-ID-TYPE      -> IDT-ID-TYPE  (IDTSET1)

                         SIRDSTRUCT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Rdgrpstrty     SIRDGRPSTT

                            STR-STRUCTURE    -> RST-STRUCTURE
                                                RST-GROUP

Sirdidhdr      SIRDIDHDR

                            STR-ID-TYPE      -> IDH-ID-TYPE
                                                IDH-ID

Sirdidstt      SIRDIDSTT

                            STR-STRUCTURE    -> IDS-STRUCTURE
                                                IDS-ID

Sirdstrdtl     SIRDSTRDTL

                            STR-STRUCTURE    -> STD-STRUCTURE
                                                STD-LEVEL