Unit Conversions by Product with empties

Unit Conversions by Product with empties

Submitted by Nathan Clouse on 09/26/15.

A slightly different view of unit conversions tied to products than vw_inventItemUnitofMeasureConversion.

AX Version: 

Module: 

CREATE VIEW [dbo].[vw_sysUnitConversions] 
AS 
  SELECT erp.displayproductnumber, 
         erp.producttype, 
         'FromUnit' = fromUOM.symbol, 
         'ToUnit' = toUOM.symbol, 
         uomc.factor, 
         erp.partition 
  FROM   ecoresproduct erp 
         LEFT JOIN unitofmeasureconversion uomc 
                ON erp.recid = uomc.product 
                   AND erp.partition = uomc.partition 
         LEFT JOIN unitofmeasure fromUOM 
                ON uomc.fromunitofmeasure = fromUOM.recid 
                   AND uomc.partition = fromUOM.partition 
         LEFT JOIN unitofmeasure toUOM 
                ON uomc.tounitofmeasure = toUOM.recid 
                   AND uomc.partition = toUOM.partition 

go