Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            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

CX05.1    CX05.2    CX805     IC10.2    IC11.1    IC12.1
IC522     IC525     IC526     IC527     PO120     PO121
PO123     PO13.1    PO150     PO20.1    PO22.3    PO31.1
PO550     POA2.1

UPDATED BY

IC14.1    IC811     IC812     PO813     PO821

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

IMC-MANUF-CODE       Alpha 4                                     IC14.1  IC811
Manufacturer's Code  This field contains a user defined code     IC812   PO813
                     that indicates the manufacturer of an       PO821
                     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               PO821
                     manufacturer is tied to an item.

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

IMC-LIC-CODE         Alpha 4                                     IC14.1  PO813
Lic Code             The Labeler Identification Code (LIC)       PO821
                     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
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                                             CX05.1  CX05.2
          MANUF-CODE                                             CX805   IC10.2
          MANUF-DIVISION                                         IC11.1  IC12.1
                                                                 IC14.1  IC522
                                                                 IC525   IC526
                                                                 IC527   IC811
                                                                 IC812   PO120
                                                                 PO121   PO123
                                                                 PO13.1  PO150
                                                                 PO20.1  PO22.3
                                                                 PO31.1  PO550
                                                                 PO813   PO821
                                                                 POA2.1

                         ICMANFCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemgroup      ITEMGROUP    Required

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