| 
 | 
                             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
IC11.1    IC208     IC330     IC811     PO150     PO25.6
PO25.7    PO36.2    PO536
UPDATED BY
IC08.1
FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY
ICG-ITEM-GROUP         Alpha 5                                   IC08.1
Element: 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
Element: Generic       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
Element: Active 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  IC11.1
          GENERIC                                                IC208   IC330
                                                                 IC811   PO150
                                                                 PO25.6  PO25.7
                                                                 PO36.2  PO536
                         ICGENERIC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH
Itemgroup      ITEMGROUP    Required
                            ICG-ITEM-GROUP    -> ITG-ITEM-GROUP
 |