Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            IACUSTOMER FILE

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ICE-ASP-CUSTOMER     Numeric 9
Asp Customer

ICE-NAME             Alpha 30  (Lower Case)
Name                 Displays the company description.

ICE-DATABASE-TYPE    Alpha 1
Database Type

ICE-NBR-OF-MARTS     Numeric 4
Nbr Of Marts

ICE-NBR-OF-USERS     Numeric 4
Nbr Of Users

ICE-SERVER-NAME      Alpha 40  (Lower Case)
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
Maximum Values

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


ICE-HOME-DIRECTORY   Alpha 100  (Lower Case)
Home Directory

ICE-ASP-GROUP        Alpha 10
Asp Group

                         IACUSTOMER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ICESET1   ASP-CUSTOMER  KeyChange

ICESET2   ASP-GROUP     KeyChange
          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  (IAGSET1)

                         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