Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IACUSTOMER


                            IACUSTOMER FILE

REFERENCED BY

IA99.1    IA199

UPDATED BY

IA90.1    IA90.3    IA90.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ICE-ASP-CUSTOMER       Numeric 9                                 IA90.1
Element: Asp Customer

ICE-NAME               Alpha 30  (Lower Case)                    IA90.1
Element: Name          Displays the company description.

ICE-DATABASE-TYPE      Alpha 1
Element: Database Type

ICE-NBR-OF-MARTS       Numeric 4                                 IA90.1
Element: Nbr Of Marts

ICE-NBR-OF-USERS       Numeric 4                                 IA90.1
Element: Nbr Of Users

ICE-SERVER-NAME        Alpha 40  (Lower Case)                    IA90.1
Element: Server Name   The Server Name field contains the IP
                       address of the server to which you are
                       connecting. You can also specify a name
                       that has been associated with the server
                       (DNS name).

ICE-MAXIMUM-VALUES     Numeric 15
Element: Maximum Values

ICE-ACTIVE-STATUS      Alpha 1                                   IA90.1
Element: Active Status The status of the account. If Inactive,
                       no posting can be done to the account.


ICE-HOME-DIRECTORY     Alpha 100  (Lower Case)                   IA90.1
Element: Home Directory

ICE-ASP-GROUP          Alpha 10                                  IA90.1
Element: Asp Group

                         IACUSTOMER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ICESET1   ASP-CUSTOMER  KeyChange                                IA90.1  IA90.3
                                                                 IA90.4  IA99.1

ICESET2   ASP-GROUP     KeyChange                                IA199   IA90.2
          ASP-CUSTOMER

                         IACUSTOMER FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iaaspgroup     IAASPGROUP   Required

                            ICE-ASP-GROUP       -> IAG-ASP-GROUP

                         IACUSTOMER FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iacustmart     IACUSTMART

                            ICE-ASP-CUSTOMER    -> IUM-ASP-CUSTOMER
                                                   IUM-DATA-MART-NAME

Iacustusrs     IACUSTUSRS

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