Lawson Insight Technical Documentation

                            ICMANFCODE FILE

                          Manufacturer's Code

The Manufacturer's Code file is a user-defined list of codes that identify
the manufacturers of items.

REFERENCED BY

IC10.2    IC11.1    IC12.1    IC330     IC34.1    IC46.1
IC522     IC525     IC526     IC527     PO04.1    PO100
PO13.1    PO150     PO23.5    PO25.1    PO25.6    PO25.7
PO30.1    PO36.2    PO536     PO550     POA2.3    POI7.1
POIJ.1

UPDATED BY

IC14.1    IC811     IC812     PO813

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IMC-ITEM-GROUP         Alpha 5                                   IC14.1  IC811
Element: Item Group    This field contains the identifier for    IC812   PO813
                       a group of items that can be shared by
                       one or more companies.

IMC-MANUF-CODE         Alpha 4                                   IC14.1  IC811
Element: Manufacturer'sThis field contains a user defined code   IC812   PO813
                       that indicates the  manufacturer of an
                       item.

IMC-MANUF-DIVISION     Alpha 4                                   IC14.1  IC811
Manufacturer's         This is a user defined code that          IC812   PO813
Division               indicates which division of a
                       manufacturer is tied to an item.

IMC-DESCRIPTION        Alpha 30  (Lower Case)                    IC14.1
Element: Description   This field displays the description.

IMC-LIC-CODE           Alpha 4                                   IC14.1  PO813
Element: Lic Code      The Labeler Identification Code (LIC)
                       is assigned to any organization in the
                       healthcare industry.  The LIC is used
                       with bar code technology to identify the
                       company that put the label on the
                       product.

IMC-USED-FLAG          Alpha 1
Element: Used          Indicates if the record has been
                       accessed by some source after creation.


                         ICMANFCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IMCSET1   ITEM-GROUP                                             IC10.2  IC11.1
          MANUF-CODE                                             IC12.1  IC14.1
          MANUF-DIVISION                                         IC330   IC34.1
                                                                 IC46.1  IC522
                                                                 IC525   IC526
                                                                 IC527   IC811
                                                                 IC812   PO04.1
                                                                 PO100   PO13.1
                                                                 PO150   PO23.5
                                                                 PO25.1  PO25.6
                                                                 PO25.7  PO30.1
                                                                 PO36.2  PO536
                                                                 PO550   PO813
                                                                 POA2.3  POI7.1
                                                                 POIJ.1

IMCSET2   ITEM-GROUP    Subset                                   PO150   PO25.6
          LIC-CODE      Where (LIC-CODE != Spaces )              PO25.7  PO36.2
                                                                 PO536

                         ICMANFCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemgroup      ITEMGROUP    Required

                            IMC-ITEM-GROUP    -> ITG-ITEM-GROUP