Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICVALUOM


                             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

AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP23.1    AP25.1    AP25.2
AP26.1    AP27.1    AP30.4    API1.1    DR100     IC10.1
IC10.2    IC11.1    IC11.2    IC11.3    IC11.4    IC11.5
IC138     IC141     IC142     IC15.1    IC200     IC28.1
IC44.1    IC62.1    IC63.1    IC811     IC83.1    MA180
MA41.2    MA41.7    MA43.1    MA43.2    MA43.3    MA43.9
MA530     MA531     MA60.2    MA60.3    MA60.5    MA61.1
MA65.1    MA66.2    MA66.3    MA67.1    MA67.2    MA70.1
MA75.1    MA80.1    MAI1.1    PHI3.1    PO100     PO101
PO115     PO122     PO131     PO15.1    PO15.2    PO150
PO16.1    PO16.2    PO20.1    PO21.1    PO21.2    PO21.3
PO21.4    PO21.5    PO216     PO22.1    PO23.1    PO25.1
PO25.5    PO25.6    PO25.7    PO27.2    PO29.1    PO30.1
PO30.2    PO30.3    PO300     PO31.1    PO31.2    PO32.2
PO33.1    PO34.1    PO35.1    PO36.1    PO36.2    PO38.1
PO39.1    PO39.2    PO44.1    PO50.1    PO52.1    PO520
PO536     PO560     POI3.1    POII.1    POIJ.1    RQ10.1
RQ10.2    RQ10.3    RQ11.1    RQ35.1    RQ500     RQIA.1
RQIB.1    RQID.1    RQIE.1    RQIF.1    RQII.1    RQIJ.1
WH20.2    WH20.7

UPDATED BY

IC00.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ICV-ITEM-GROUP         Alpha 5                                   IC00.1
Element: 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
Element: Unit of MeasurThis is a valid unit of measure for
                       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
Element: 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                                             AP125   AP126
          VALID-UOM                                              AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 DR100   IC00.1
                                                                 IC10.1  IC10.2
                                                                 IC11.1  IC11.2
                                                                 IC11.3  IC11.4
                                                                 IC11.5  IC138
                                                                 IC141   IC142
                                                                 IC15.1  IC200
                                                                 ...

                         ICVALUOM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemgroup      ITEMGROUP    Required

                            ICV-ITEM-GROUP    -> ITG-ITEM-GROUP