Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

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

IC10.2    IC11.1    IC12.1    IC330     IC522     IC525
IC526     IC527     PO04.1    PO13.1    PO550     POA2.3
POI7.1    POIJ.1

UPDATED BY

IC14.1    IC811     IC812

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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

IMC-LIC-CODE         Alpha 4                                     IC14.1
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
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   IC522
                                                                 IC525   IC526
                                                                 IC527   IC811
                                                                 IC812   PO04.1
                                                                 PO13.1  PO550
                                                                 POA2.3  POI7.1
                                                                 POIJ.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