ITEM_UNITS_CONVERSION

The item_units_conversion category holds a table of conversion factors between the systems of units described in the item_units_list category. The systems of units are identified by a from_code and a to_code, which are both children of the item _item_units_list.code. The conversion is defined in terms of an arithmetic operator and a conversion factor, _item_units_conversion.operator and _item_units_conversion.factor, respectively.

The DDL for the item_units_conversion category is given in the following section.

save_ITEM_UNITS_CONVERSION

    _category.description
;
     Conversion factors between the various units of measure defined
     in the ITEM_UNITS_LIST category.
;
    _category.id                         item_units_conversion
    _category.mandatory_code             no
     loop_
    _category_key.name                  '_item_units_conversion.from_code'
                                        '_item_units_conversion.to_code'
     loop_
    _category_group.id                  'ddl_group'
                                        'item_group'
     save_

save__item_units_conversion.from_code

    _item_description.description
;
     The unit system on which the conversion operation is applied
     to produce the unit system specified in _item_units_conversion.to_code.

         <to_code> =  <from_code> <operator> <factor>
;
     save_

save__item_units_conversion.to_code

    _item_description.description
;
     The unit system produced after an operation is applied to the unit
     system specified by  _item_units_conversion.from_code.

         <to_code> =  <from_code> <operator> <factor>
;
     save_

save__item_units_conversion.operator

    _item_description.description
;
     The arithmetic operator required to convert between the 
     unit systems:
         <to_code> =  <from_code> <operator> <factor>
;
    _item.name                         '_item_units_conversion.operator'
    _item.category_id                    item_units_conversion                
    _item.mandatory_code                 yes 
    _item_type.code                      code
     loop_
    _item_enumeration.value
    _item_enumeration.detail
                        '+'  'addition'
                        '-'  'subtraction'
                        '*'  'multiplication'
                        '/'  'division'
     save_

save__item_units_conversion.factor

    _item_description.description
;
     The arithmetic operation required to convert between the 
     unit systems:
         <to_code> =  <from_code> <operator> <factor>
;
    _item.name                         '_item_units_conversion.factor'
    _item.category_id                    item_units_conversion                
    _item.mandatory_code                 yes 
    _item_type.code                      any
     save_