Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SIRDLEVEL


                             SIRDLEVEL FILE

REFERENCED BY

RD96.1    RD96.2

UPDATED BY

RD97.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SLV-LEVEL              Alpha 20                                  RD97.1
Element: Level

SLV-ID-TYPE            Alpha 15  (Lower Case)                    RD97.1
Element: Id Type

SLV-DESCRIPTION        Alpha 50  (Lower Case)                    RD97.1
Element: Description   This field contains the description.

SLV-PICTURE            Alpha 99  (Lower Case)                    RD97.1
Element: Picture

SLV-ASSISTANT          Alpha 1                                   RD97.1
Element: Assistant     N = No
                       Y = Yes

SLV-DIRECTION          Alpha 1                                   RD97.1
Element: Direction     This field will let the system know if
                       the API is being used for Inbound
                       purposes or Outbound Purposes.
                       L = Left
                       R = Right
                       T = Top
                       B = Bottom
                       C = Center

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

SLV-TIME               Numeric 6  (hhmmss)                       RD97.1
Element: Time

SLV-TYPE-RECORD        Derived
Element: Type Record

                         SIRDLEVEL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SLVSET1   LEVEL                                                  RD96.1  RD96.2
                                                                 RD97.1  RD97.2
                                                                 RD97.3

SLVSET2   ID-TYPE       KeyChange
          LEVEL

                         SIRDLEVEL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sirdtype       SIRDTYPE     Required

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

                         SIRDLEVEL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sirdgrploc     SIRDGRPLOC

                            SLV-LEVEL      -> GRL-LEVEL
                                              GRL-GROUP

Sirdidhdr      SIRDIDHDR

                            SLV-ID-TYPE    -> IDH-ID-TYPE
                                              IDH-ID

Sirdlevpar     SIRDLEVPAR

                            SLV-LEVEL      -> SLP-LEVEL
                                              SLP-LEVEL-PARENT

Sirdlocate     SIRDIDLOC

                            SLV-LEVEL      -> SLO-LEVEL
                                              SLO-ID