Lawson Insight Technical Documentation
Generated by:
Documentation generated by Decision Analytics
ERDs Tables Conditions Elements Libraries APIs Forms

SIRDTYPE


                             SIRDTYPE FILE

REFERENCED BY

LX00.2    LX90.2    LX90.3    LX90.4    LX90.5    RD30.1
RD30.2    RD50.1    RD50.2    RD70.1    RD70.2    RD88.3
RD97.1

UPDATED BY

LO900     LX60.3    LX65.3    RD20.1    RD20.2    RD20.3
RD20.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IDT-ID-TYPE            Alpha 15  (Lower Case)                    LO900   LX60.3
Element: Id Type                                                 LX65.3  RD20.1
                                                                 RD20.2  RD20.3
                                                                 RD20.4

IDT-PARENT-TYPE        Alpha 15  (Lower Case)                    LX60.3  LX65.3
Element: Parent Type                                             RD20.1  RD20.2
                                                                 RD20.3  RD20.4

IDT-RECORD-TYPE        Numeric 2                                 LO900   LX60.3
Element: Record Type   This field identifies the type of         LX65.3  RD20.1
                       record defined.                           RD20.2  RD20.3
                                                                 RD20.4
                       Valid values are:
                       S=Summary
                       D=Detail
                       01 = People
                       02 = Organizations
                       03 = Things
                       09 = Universal

IDT-DESCRIPTION        Alpha 50  (Lower Case)                    LO900   RD20.1
Element: Description   This field contains the description.      RD20.2  RD20.3
                                                                 RD20.4

IDT-OBJ-ID             Numeric 12                                LX60.3  LX65.3
Element: Obj Id

IDT-DATE               Numeric 8  (yyyymmdd)                     LX60.3  LX65.3
Element: Date          This field contains the system date       RD20.1  RD20.2
                       when this was created.                    RD20.3  RD20.4

IDT-TIME               Numeric 6  (hhmmss)                       LX60.3  LX65.3
Element: Time                                                    RD20.1  RD20.2
                                                                 RD20.3  RD20.4

                         SIRDTYPE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IDTSET1   ID-TYPE                                                LO900   LX00.2
                                                                 LX60.1  LX60.2
                                                                 LX60.3  LX65.1
                                                                 LX65.2  LX65.3
                                                                 LX90.2  LX90.3
                                                                 LX90.4  LX90.5
                                                                 RD20.1  RD20.2
                                                                 RD20.3  RD20.4
                                                                 RD30.1  RD30.2
                                                                 RD50.1  RD50.2
                                                                 RD70.1  RD70.2
                                                                 RD88.3  RD97.1

IDTSET2   PARENT-TYPE   KeyChange
          ID-TYPE

IDTSET3   OBJ-ID        KeyChange, Subset                        LX60.3  LX65.3
                        Where OBJ-ID != Zeroes

IDTSET4   RECORD-TYPE   KeyChange                                LX60.3  RD20.1
          ID-TYPE                                                RD20.2  RD20.3
                                                                 RD20.4

                         SIRDTYPE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Lomxvalue      LOMXVALUE

                            IDT-ID-TYPE    -> LMV-ID-TYPE
                            IDT-OBJ-ID     -> LMV-OBJ-ID
                                              LMV-MATRIX-TYPE
                                              LMV-MATRIX-CAT

Mxidobjcat     MXIDOBJCAT

                            IDT-ID-TYPE    -> IOC-ID-TYPE
                                              IOC-MATRIX-TYPE
                                              IOC-MATRIX-CAT

Mxobjcat       MXOBJCAT

                            IDT-ID-TYPE    -> MOC-ID-TYPE
                                              MOC-MATRIX-TYPE

Sirdidhdr      SIRDIDHDR

                            IDT-ID-TYPE    -> IDH-ID-TYPE
                                              IDH-ID

Sirdlevel      SIRDLEVEL

                            IDT-ID-TYPE    -> SLV-ID-TYPE
                                              SLV-LEVEL

Sirdstruct     SIRDSTRUCT

                            IDT-ID-TYPE    -> STR-ID-TYPE
                                              STR-STRUCTURE