Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICGENERIC


                             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