Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICMANFCODE


                            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

IC11.1    IC12.1    IC330     PD21.1    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    RQ10.1    RQ10.3    RQ11.1    RQ35.1    RQ500
RQIF.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: Manuf Code    This field contains a user defined code   IC812   PO813
                       that indicates the  manufacturer of an
                       item.

IMC-MANUF-DIVISION     Alpha 4                                   IC14.1  IC811
Element: Manuf DivisionThis is a user defined code that          IC812   PO813
                       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 Flag     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                                             IC11.1  IC12.1
          MANUF-CODE                                             IC14.1  IC330
          MANUF-DIVISION                                         IC811   IC812
                                                                 PD21.1  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  RQ10.1
                                                                 RQ10.3  RQ11.1
                                                                 RQ35.1  RQ500
                                                                 RQIF.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