| 
 | 
                            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: 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
 |