Quantity and Invoice Price with Product UOM Conversion

Data Source Fields

Data Source – Material Analytics

Datamart Fields

Datamart – Product UOM Material Analytics

Import & Export Definition

JSON

{
            "name": "Quantity",
            "label": "Quantity",
            "labelTranslations": {},
            "rank": 6,
            "measureType": "EXTENDED",
            "functionalType": "PERUNITBASIS",
            "visibility": 1,
            "source": "DMDS.Material_Analytics",
            "sourceField": "Quantity",
            "expression": "",
            "conversion": {
                "skuField": "ProductID",
                "uomField": "UOM",
                "ccyField": "Currency",
                "qtyField": "Quantity",
                "void": false
            },
            "defaultConversion": {
                "uomField": "UOM",
                "void": false
            },

JSON

{
            "name": "InvoicePrice",
            "label": "Invoice Price",
            "labelTranslations": {},
            "rank": 9,
            "measureType": "PERUNIT",
            "visibility": 1,
            "source": "DMDS.Material_Analytics",
            "sourceField": "InvoicePrice",
            "expression": "",
            "conversion": {
                "skuField": "ProductID",
                "uomField": "UOM",
                "ccyField": "Currency",
                "qtyField": "Quantity",
                "void": false
            },
            "defaultConversion": {
                "uomField": "UOM",
                "ccyField": "Currency",
                "qtyField": "Quantity",
                "void": false
            },

Product UOM

ProductID	UOM From	UOM To	UOM Conversion Factor
B-0025	EA	PK	0.167

Data Source UOM

UOM From	UOM To	UOM Conversion Factor
EA	PK	1.5

Conversion Breakdown

Data Source – Product UOM
UomConversionFactor = 0.16667 (for B-0025 product only)

Data Source – Material Analytics
Quantity = 21

Datamart – Product UOM Material Analytics
Quantity = 21 * 0.16667 = 3.5

Data Samples