Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IACUSTUSRS


                            IACUSTUSRS FILE

REFERENCED BY

IA99.1

UPDATED BY

IA90.3    IA90.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IUU-LOGIN              Alpha 30  (Lower Case)                    IA90.3
Element: Login

IUU-OLAP-PASSWORD      Alpha 25  (Lower Case)                    IA90.3
Element: Olap Password

IUU-USER-TYPE          Alpha 1                                   IA90.3
Element: User Type     A = Administrator
                       D = Designer
                       U = User

IUU-E-MAIL-ADDRESS     Alpha 60  (Lower Case)
Element: Email Address

IUU-ASP-CUSTOMER       Numeric 9                                 IA90.3
Element: Asp Customer

                         IACUSTUSRS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IUUSET1   LOGIN         KeyChange                                IA90.3  IA99.1

IUUSET2   ASP-CUSTOMER  KeyChange                                IA90.1  IA90.3
          LOGIN                                                  IA90.4

                         IACUSTUSRS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iacustomer     IACUSTOMER   Required

                            IUU-ASP-CUSTOMER    -> ICE-ASP-CUSTOMER

                         IACUSTUSRS FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iacustmart     IACUSTMART

                            IUU-LOGIN           -> IUM-LOGIN
                                                   IUM-ASP-CUSTOMER
                                                   IUM-DATA-MART-NAME