ICGENERIC FILE

                              Generic Name

The Generic Name file is a master file of generic names. When generic names
are entered on Item Master, they are verified against this file.

REFERENCED BY

IC10.1    IC10.2    IC11.1    IC208     IC811

UPDATED BY

IC08.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ICG-ITEM-GROUP       Alpha 5                                     IC08.1
Item Group           This field contains the identifier for
                     a group of items that can be shared by
                     one or more companies.

ICG-GENERIC          Alpha 10                                    IC08.1
Generic Name         This field contains a user-defined
                     general name for an item. This name is
                     used for searching for an item.

ICG-ACTIVE-STATUS    Alpha 1                                     IC08.1
Status               This field prevents the use of a
                     generic name.
                     A = Active
                     I = Inactive

                         ICGENERIC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ICGSET1   ITEM-GROUP                                             IC08.1  IC10.1
          GENERIC                                                IC10.2  IC11.1
                                                                 IC208   IC811

                         ICGENERIC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemgroup      ITEMGROUP    Required

                            ICG-ITEM-GROUP    -> ITG-ITEM-GROUP