ICVALUOM – Valid Units Of Measure

System
Inventory Control (IC)
Prefix
ICV
Primary key
ITEM-GROUP, VALID-UOM
Fields
3
Updated by
1 program
Referenced by
251 programs

ICVALUOM is the Valid Units Of Measure table in Lawson Inventory Control (prefix ICV). It is indexed by ITEM-GROUP, VALID-UOM (ICVSET1). It is related 1:1 to ITEMGROUP. It is updated by IC00.1 and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 243 more. The table has 3 fields, 1 index and 1 documented relation.

About ICVALUOM

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.

Fields (3)

Column = COBOL field name without the ICV- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ICV-ITEM-GROUP PK
ITEM_GROUP
Alpha 5This field contains the identifier for a group of items that can be shared by one or more companies.IC00.1
ICV-VALID-UOM PK
VALID_UOM
Alpha 4This 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.IC00.1
ICV-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This field contains the description of the unit of measure.IC00.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ICVSET1ITEM-GROUP, VALID-UOMPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ItemgroupITEMGROUPRequiredICV-ITEM-GROUPITG-ITEM-GROUP

Programs

Updated by (1)

Referenced by (251)