Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

LOWDGTUSR


                             LOWDGTUSR FILE

UPDATED BY

LO60.1    LO63.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

LWU-WIDGET-ID          Alpha 30  (Lower Case)                    LO63.1
Element: Widget Id

LWU-WEB-USER           Alpha 80  (Lower Case)                    LO63.1
Element: Web User

LWU-STATUS             Numeric 1                                 LO63.1
Element: Status        This field contains the status of the
                       transaction.
                       1 = Active
                       2 = Inactive

LWU-ACCESS             Alpha 1                                   LO63.1
Element: Access        E = Edit
                       V = View

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

LWU-TIME               Numeric 6  (hhmmss)                       LO63.1
Element: Time

                         LOWDGTUSR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

LWUSET1   WIDGET-ID                                              LO60.1  LO63.1
          WEB-USER

LWUSET2   WEB-USER
          WIDGET-ID

                         LOWDGTUSR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Lowdgt         LOWDGT       Required

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

Sirdidhdr      SIRDIDHDR    Required

                            LWU-WEB-USER     -> IDH-WEB-USER

Webuser        WEBUSER      Required

                            LWU-WEB-USER     -> WUR-WEB-USER