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    AP21.1    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    AP30.4    API1.1    BL120
BL122     BL130     BL20.1    BL20.3    BL21.2    BL21.5
BL29.1    BL29.2    BL520     BL820     BL92.1    IC11.1
IC11.2    IC11.3    IC11.4    IC11.5    IC11.6    IC15.1
IC200     IC330     IC811     MA180     MA41.1    MA41.2
MA41.4    MA41.7    MA43.1    MA43.2    MA43.3    MA43.7
MA530     MA531     MA540     MA60.2    MA60.3    MA60.5
MA61.1    MA65.1    MA66.2    MA66.3    MA67.2    MA67.3
MA68.2    MA68.3    MA68.5    MA70.1    MA75.1    MA80.1
MAI1.1    PD10.1    PD10.2    PD130     PD20.1    PD20.2
PD20.3    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    PO24.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    PO32.4    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    POID.1    POII.1    POIJ.1    RQ10.1
RQ10.2    RQ10.3    RQ11.1    RQ13.2    RQ35.1    RQ500
RQIA.1    RQIB.1    RQID.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: Uom           This 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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC00.1
                                                                 ...

                         ICVALUOM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemgroup      ITEMGROUP    Required

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