ADD_UOMS_SQLServer script

Add_UOMs_SQLServer.sql

Add Unit of Measure Script

Table 3 Unit of measure server script

Category	Script name	Conditional, Optional, or Required	Conditions/Notes
Unit of Measure (UOM)	Add_UOM_SQLServer.sql	Required	Adds UOMs after the UOM Generator is removed and creates stored procedures.

The Add_UOMs_SQLServer.sql post-upgrade script adds a list of common Unit of Measures (UOMs) to IEE. The script creates the following stored procedures:

• UOM_CreateStructure. Creates UOMs, and adds and updates the following database tables:

  • UnitOfMeasureClass

  • UnitOfMeasure

  • UnitOfMeasureFormula

  • UOMAttributeValue

• Unit_Create. Creates any new units needed for UOMs and adds and updates the following database tables:

  • Unit

  • CommodityTypeUnit

Related topics:

• Defining the unit of measure (UOM) mappings

• ADD_UOMS_Oracle scripts

• Mapping the units of measure (UOM)