Lawson Insight Technical Documentation

                             ICVALUOM FILE

                         Valid Units Of Measure

The Valid Units Of Measure file is a list of the valid units of measure for
an item group. When adding a unit of measure to an item in IC10.1 (Formats) or
in IC11.1 (Item Master), the unit of measure is validated against this file.

REFERENCED BY

DR100     IC10.1    IC10.2    IC11.1    IC11.2    IC11.3
IC11.4    IC11.5    IC138     IC141     IC142     IC15.1
IC200     IC62.1    IC63.1    IC811     IC83.1    MA65.1
PHI3.1    PO15.1    PO15.2    PO16.1    PO16.2    PO216
PO560     POIJ.1    RQ11.1

UPDATED BY

IC00.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

ICV-VALID-UOM        Alpha 4                                     IC00.1
Valid Unit of        This is a valid unit of measure for
Measure              this item group. All units of measure
                     entered on the Item Master file are
                     verified against this file.

ICV-DESCRIPTION      Alpha 30  (Lower Case)                      IC00.1
Description          This field contains the description of
                     the unit of measure.

                         ICVALUOM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ICVSET1   ITEM-GROUP                                             DR100   IC00.1
          VALID-UOM                                              IC10.1  IC10.2
                                                                 IC11.1  IC11.2
                                                                 IC11.3  IC11.4
                                                                 IC11.5  IC138
                                                                 IC141   IC142
                                                                 IC15.1  IC200
                                                                 IC62.1  IC63.1
                                                                 IC811   IC83.1
                                                                 MA65.1  PHI3.1
                                                                 PO15.1  PO15.2
                                                                 PO16.1  PO16.2
                                                                 PO216   PO560
                                                                 POIJ.1  RQ11.1

ICVSET2   VALID-UOM     Duplicates

                         ICVALUOM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemgroup      ITEMGROUP    Required

                            ICV-ITEM-GROUP    -> ITG-ITEM-GROUP  (ITGSET1)