Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

LOWDGTATTR


                            LOWDGTATTR FILE

UPDATED BY

LO60.1    LO61.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

LWA-WIDGET-ID          Alpha 30  (Lower Case)                    LO61.1
Element: Widget Id

LWA-WEB-USER           Alpha 80  (Lower Case)                    LO61.1
Element: Web User

LWA-MATRIX-CAT         Alpha 14                                  LO61.1
Element: Matrix Cat

LWA-MX-VALUE           Alpha 55  (Lower Case)                    LO61.1
Element: Mx Value

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

LWA-TIME               Numeric 6  (hhmmss)                       LO61.1
Element: Time

                         LOWDGTATTR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

LWASET1   WIDGET-ID                                              LO60.1  LO61.1
          WEB-USER
          MATRIX-CAT

LWASET2   WEB-USER
          WIDGET-ID
          MATRIX-CAT

LWASET3   MATRIX-CAT
          WIDGET-ID
          WEB-USER

LWASET4   MATRIX-CAT
          WEB-USER
          WIDGET-ID

                         LOWDGTATTR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Lowdgt         LOWDGT       Required

                            LWA-WIDGET-ID     -> LAW-WIDGET-ID  (LAWSET1)

Lowdgtdfat     LOWDGTDFAT   Not Required

                            LWA-MATRIX-CAT    -> LDA-MATRIX-CAT
                            LWA-WIDGET-ID     -> LDA-WIDGET-ID

Mxcatdef       MXCATDEF     Required

                            LWA-MATRIX-CAT    -> MXC-MATRIX-CAT

Webuser        WEBUSER      Required

                            LWA-WEB-USER      -> WUR-WEB-USER