[ { "actionUUID": "CalculationTask-eaONA", "calculationConfig": { "feederInputParams": [], "formulaName": "Plasma_Transactions_Enrichment", "inputParams": [ { "label": "Dem_Year", "name": "Dem_Year", "parameterConfig": { "dataType": "text" }, "type": "STRINGUSERENTRY" }, { "label": "Dem_Month", "name": "Dem_Month", "parameterConfig": { "dataType": "text" }, "type": "STRINGUSERENTRY" }, { "label": "Dem_Quarter", "name": "Dem_Quarter", "parameterConfig": { "dataType": "text" }, "type": "STRINGUSERENTRY" }, { "label": "Dem_Region_Selling_To", "name": "Dem_Region_Selling_To", "parameterConfig": { "dataType": "text" }, "type": "STRINGUSERENTRY" }, { "label": "Dem_Region_Selling_From", "name": "Dem_Region_Selling_From", "parameterConfig": { "dataType": "text" }, "type": "STRINGUSERENTRY" } ], "mappingParams": [ { "label": "Dem_Year", "name": "Dem_Year", "parameterConfig": {}, "type": "" }, { "label": "Dem_Month", "name": "Dem_Month", "parameterConfig": {}, "type": "" }, { "label": "Dem_Quarter", "name": "Dem_Quarter", "parameterConfig": {}, "type": "" }, { "label": "Dem_Region_Selling_To", "name": "Dem_Region_Selling_To", "parameterConfig": {}, "type": "" }, { "label": "Dem_Region_Selling_From", "name": "Dem_Region_Selling_From", "parameterConfig": {}, "type": "" } ], "outputElements": [ { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Region Selling From", "elementName": "Dem_Region_Selling_From", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Customers_60_Revenue_Decile", "elementName": "Number_Customers_60_Revenue_Decile", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Customer_Percentiles_Calculation", "elementName": "Customer_Percentiles_Calculation", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Products_10_Revenue_Decile", "elementName": "Number_Products_10_Revenue_Decile", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "PriceChanges_Query", "elementName": "PriceChanges_Query", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Customers_90_Revenue_Decile", "elementName": "Number_Customers_90_Revenue_Decile", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Annual_Size_Change_Per_Unit_Margin", "elementName": "Annual_Size_Change_Per_Unit_Margin", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Sum_Revenue_Account_Negative_Margin", "elementName": "Sum_Revenue_Account_Negative_Margin", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Customers_30_Revenue_Decile", "elementName": "Number_Customers_30_Revenue_Decile", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Product_Negative_Margin", "elementName": "Number_Product_Negative_Margin", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Sum_Revenue_Transaction_Positive_Margin", "elementName": "Sum_Revenue_Transaction_Positive_Margin", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Do we have a full 12 trailing months", "elementName": "Data12Months", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Total_Accounts_This_Month_Region", "elementName": "Total_Accounts_This_Month_Region", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Total_Products_This_Quarter_Region", "elementName": "Total_Products_This_Quarter_Region", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Total_Number_Transaction", "elementName": "Total_Number_Transaction", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "YearQuarter", "elementName": "YearQuarter", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Annual_Percent_Change_Per_Unit_Margin", "elementName": "Annual_Percent_Change_Per_Unit_Margin", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "YearMonth", "elementName": "YearMonth", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Total_Sales_HC_This_Month", "elementName": "Total_Sales_HC_This_Month", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Total_Products_This_Month_Region", "elementName": "Total_Products_This_Month_Region", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Region Selling To", "elementName": "Dem_Region_Selling_To", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Products_50_Revenue_Decile", "elementName": "Number_Products_50_Revenue_Decile", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Products_80_Revenue_Decile", "elementName": "Number_Products_80_Revenue_Decile", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Quarter", "elementName": "Dem_Quarter", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Annual_Size_Change_Per_Unit_Invoice_Price", "elementName": "Annual_Size_Change_Per_Unit_Invoice_Price", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Account_Negative_Margin", "elementName": "Number_Account_Negative_Margin", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "ProductsManager", "elementName": "ProductsManager", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Customers_70_Revenue_Decile", "elementName": "Number_Customers_70_Revenue_Decile", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Annual_Percent_Change_Per_Unit_Realized_Price", "elementName": "Annual_Percent_Change_Per_Unit_Realized_Price", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Annual_Size_Change_Per_Unit_Realized_Price", "elementName": "Annual_Size_Change_Per_Unit_Realized_Price", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "init" ], "elementLabel": "GlobalCache", "elementName": "GlobalCache", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Annual_Percent_Change_Per_Unit_Net_Price", "elementName": "Annual_Percent_Change_Per_Unit_Net_Price", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Total_Sales_HC_Annual_Region", "elementName": "Total_Sales_HC_Annual_Region", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Total_Sales_HC_Available_Annual_Region", "elementName": "Total_Sales_HC_Available_Annual_Region", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Customers_40_Revenue_Decile", "elementName": "Number_Customers_40_Revenue_Decile", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Customers_10_Revenue_Decile", "elementName": "Number_Customers_10_Revenue_Decile", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Products_30_Revenue_Decile", "elementName": "Number_Products_30_Revenue_Decile", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Total_Products_Annual", "elementName": "Total_Products_Annual", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Total_Products_Available_Annual", "elementName": "Total_Products_Available_Annual", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Total_Sales_HC_Annual", "elementName": "Total_Sales_HC_Annual", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Total_Sales_HC_Available_Annual", "elementName": "Total_Sales_HC_Available_Annual", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Products_90_Revenue_Decile", "elementName": "Number_Products_90_Revenue_Decile", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Products_60_Revenue_Decile", "elementName": "Number_Products_60_Revenue_Decile", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Total_Accounts_This_Month", "elementName": "Total_Accounts_This_Month", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Sum_Revenue_Product_Positive_Margin", "elementName": "Sum_Revenue_Product_Positive_Margin", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Total_Products_This_Quarter", "elementName": "Total_Products_This_Quarter", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Total_Accounts_Annual_Region", "elementName": "Total_Accounts_Annual_Region", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Total_Accounts_Available_Annual_Region", "elementName": "Total_Accounts_Available_Annual_Region", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Transaction_Positive_Margin", "elementName": "Number_Transaction_Positive_Margin", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Customers_80_Revenue_Decile", "elementName": "Number_Customers_80_Revenue_Decile", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Total_Products_This_Month", "elementName": "Total_Products_This_Month", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "init" ], "elementLabel": "Cache", "elementName": "Cache", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Sum_Revenue_Transaction_Negative_Margin", "elementName": "Sum_Revenue_Transaction_Negative_Margin", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Annual_Size_Change_Per_Unit_List_Price", "elementName": "Annual_Size_Change_Per_Unit_List_Price", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Customers_20_Revenue_Decile", "elementName": "Number_Customers_20_Revenue_Decile", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Customers_50_Revenue_Decile", "elementName": "Number_Customers_50_Revenue_Decile", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Annual_Percent_Change_Per_Unit_List_Price", "elementName": "Annual_Percent_Change_Per_Unit_List_Price", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Sum_Revenue_Account_Positive_Margin", "elementName": "Sum_Revenue_Account_Positive_Margin", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Products_20_Revenue_Decile", "elementName": "Number_Products_20_Revenue_Decile", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Total_Sales_HC_This_Month_Region", "elementName": "Total_Sales_HC_This_Month_Region", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Product_Positive_Margin", "elementName": "Number_Product_Positive_Margin", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Sum_Revenue_Product_Negative_Margin", "elementName": "Sum_Revenue_Product_Negative_Margin", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Transaction_Negative_Margin", "elementName": "Number_Transaction_Negative_Margin", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Year", "elementName": "Dem_Year", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Transaction_Query", "elementName": "Transaction_Query", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Annual_Size_Change_Per_Unit_Net_Price", "elementName": "Annual_Size_Change_Per_Unit_Net_Price", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Account_Query_Month_RegionTo", "elementName": "Account_Query_Month_RegionTo", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Total_Products_Annual_Region", "elementName": "Total_Products_Annual_Region", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Total_Products_Available_Annual_Region", "elementName": "Total_Products_Available_Annual_Region", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Products_40_Revenue_Decile", "elementName": "Number_Products_40_Revenue_Decile", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Products_70_Revenue_Decile", "elementName": "Number_Products_70_Revenue_Decile", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Month", "elementName": "Dem_Month", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Number_Account_Positive_Margin", "elementName": "Number_Account_Positive_Margin", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Total_Accounts_Annual", "elementName": "Total_Accounts_Annual", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Total_Accounts_Available_Annual", "elementName": "Total_Accounts_Available_Annual", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Annual_Percent_Change_Per_Unit_Invoice_Price", "elementName": "Annual_Percent_Change_Per_Unit_Invoice_Price", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": true }, { "displayedInPriceShop": false, "elementGroups": [ "row" ], "elementLabel": "Product_Percentiles Calculation", "elementName": "Product_Percentiles_Calculation", "formulaDate": "2019-03-02", "formulaName": "Plasma_Transactions_Enrichment", "key": false, "selected": false } ], "targetDate": "2019-09-03" }, "continuous": false, "distributed": false, "incremental": true, "isDefault": false, "isPlasma": false, "label": "Plasma_Output_Enrichment", "targetDate": "2019-09-03", "targetName": "DM.Plasma_Output_Transactions", "type": "CALCULATION", "valid": true, "withTargetSnapshot": false }, { "actionUUID": "CalculationTask-kOCIy", "allowBatching": true, "calculationConfig": { "feederInputParams": [], "formulaName": "Plasma_Transactions_Exchange", "inputParams": [ { "formattingOptions" : { }, "label" : "PreviousCurrency", "name" : "PreviousCurrency", "parameterConfig" : { "dataType" : "text" }, "type" : "STRINGUSERENTRY" } ], "mappingParams": [ { "formattingOptions" : { }, "label" : "PreviousCurrency", "name" : "PreviousCurrency", "parameterConfig" : { "dataType" : "text" }, "type" : "STRINGUSERENTRY", "value": "PreviousCurrency" } ], "outputElements": [ { "displayedInPriceShop": true, "elementGroups": ["row"], "elementLabel": "SellingTo", "elementName": "SellingTo", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop": true, "elementGroups" : [ "row" ], "elementLabel": "BusinessUnit", "elementName": "BusinessUnit", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "Rebates", "elementName" : "Rebates", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "Warranty", "elementName" : "Warranty", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "CustomerNegotiatedDiscounts", "elementName" : "CustomerNegotiatedDiscounts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "Quantity", "elementName" : "Quantity", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "OtherCOGS", "elementName" : "OtherCOGS", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "OtherOnInvoicePromotions", "elementName" : "OtherOnInvoicePromotions", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "Customer_Charge_Installation", "elementName" : "Customer_Charge_Installation", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "VolumeBonus", "elementName" : "VolumeBonus", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "PreviousPricingDate", "elementName" : "PreviousPricingDate", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "UOM", "elementName" : "UOM", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "RealizedPrice", "elementName" : "RealizedPrice", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "NetPrice", "elementName" : "NetPrice", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "InvoicePrice", "elementName" : "InvoicePrice", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "DeltaNetPrice", "elementName" : "DeltaNetPrice", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "ListPriceUpliftCounter", "elementName" : "ListPriceUpliftCounter", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "EarlyPaymentDiscounts", "elementName" : "EarlyPaymentDiscounts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "RawMaterials", "elementName" : "RawMaterials", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "DocumentLineId", "elementName" : "DocumentLineId", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "Corrections", "elementName" : "Corrections", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "ForeignExchangeAdjustment", "elementName" : "ForeignExchangeAdjustment", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "InstantRebates", "elementName" : "InstantRebates", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "SalesChannelDiscounts", "elementName" : "SalesChannelDiscounts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "ProductId", "elementName" : "ProductId", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "DeltaLocalListPrice", "elementName" : "DeltaLocalListPrice", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementLabel" : "Global", "elementName" : "Global", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : false }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "CompetitiveDiscounts", "elementName" : "CompetitiveDiscounts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "FreightCharges", "elementName" : "FreightCharges", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "SupportCost", "elementName" : "SupportCost", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "OtherTransactionCosts", "elementName" : "OtherTransactionCosts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "Production", "elementName" : "Production", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "MarketingDevelopmentPromotions", "elementName" : "MarketingDevelopmentPromotions", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "CustomizationCharges", "elementName" : "CustomizationCharges", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "Product_or_Service", "elementName" : "Product_or_Service", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "CustomerLoyaltyProgram", "elementName" : "CustomerLoyaltyProgram", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "EndCustomerOnInvoiceDiscounts", "elementName" : "EndCustomerOnInvoiceDiscounts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "OtherOffInvoiceDiscounts", "elementName" : "OtherOffInvoiceDiscounts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "PreviousNetPricePU", "elementName" : "PreviousNetPricePU", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "VolumeDiscounts", "elementName" : "VolumeDiscounts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "PreviousInvoicePricePU", "elementName" : "PreviousInvoicePricePU", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "StockingAllowance", "elementName" : "StockingAllowance", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "CustomizationCosts", "elementName" : "CustomizationCosts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "GrossMargin", "elementName" : "GrossMargin", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "UniqueId", "elementName" : "UniqueId", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "FreeGiveaways", "elementName" : "FreeGiveaways", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "SeasonalDiscounts", "elementName" : "SeasonalDiscounts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "CustomerId", "elementName" : "CustomerId", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "DeltaMargin", "elementName" : "DeltaMargin", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "ExpeditedShipping", "elementName" : "ExpeditedShipping", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "InstallationCharges", "elementName" : "InstallationCharges", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "DeltaRealizedPrice", "elementName" : "DeltaRealizedPrice", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "PricingDate", "elementName" : "PricingDate", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "OffInvoicePromotions", "elementName" : "OffInvoicePromotions", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "PreviousRealizedPricePU", "elementName" : "PreviousRealizedPricePU", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "LocalAdjustment", "elementName" : "LocalAdjustment", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "RushOrders", "elementName" : "RushOrders", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "Customer_Charge_Customization", "elementName" : "Customer_Charge_Customization", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "DeltaInvoicePrice", "elementName" : "DeltaInvoicePrice", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "InventoryMaintenance", "elementName" : "InventoryMaintenance", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "GlobalListPrice", "elementName" : "GlobalListPrice", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "CustomerPickupAllowance", "elementName" : "CustomerPickupAllowance", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "PreviousLocalListPricePU", "elementName" : "PreviousLocalListPricePU", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "PreviousMarginPU", "elementName" : "PreviousMarginPU", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "ConsignmentCost", "elementName" : "ConsignmentCost", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "QuickCashPaymentDiscounts", "elementName" : "QuickCashPaymentDiscounts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "TradeSpend", "elementName" : "TradeSpend", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "DocumentId", "elementName" : "DocumentId", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "Labor", "elementName" : "Labor", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "SellingFrom", "elementName" : "SellingFrom", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "InstallationCosts", "elementName" : "InstallationCosts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "Currency", "elementName" : "Currency", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "ReceivablesCarrying", "elementName" : "ReceivablesCarrying", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "EndCustomerOffInvoiceDiscounts", "elementName" : "EndCustomerOffInvoiceDiscounts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "LocalListPrice", "elementName" : "LocalListPrice", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "SlottingAllowance", "elementName" : "SlottingAllowance", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "ListPriceChangeCounter", "elementName" : "ListPriceChangeCounter", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "SalesRep", "elementName" : "SalesRep", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "Freight", "elementName" : "Freight", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true } ], "targetDate" : "2020-05-15" }, "continuous" : false, "distributed" : false, "dtoSourceFilter" : { "_constructor" : "AdvancedCriteria", "criteria" : [ ], "operator" : "and" }, "incremental" : true, "isDefault" : false, "isPlasma" : false, "label" : "Plasma_Transactions_Exchange", "sourceName" : "DMDS.Plasma_Transactions", "targetDate" : "2020-05-15", "targetName" : "DM.Plasma_Transactions", "type" : "CALCULATION", "valid" : true, "withTargetSnapshot" : false }, { "actionUUID": "CalculationTask-kOCIy", "allowBatching": true, "calculationConfig": { "feederInputParams": [], "formulaName": "Plasma_Transactions_Exchange", "inputParams": [], "mappingParams": [], "outputElements": [ { "displayedInPriceShop": true, "elementGroups": ["row"], "elementLabel": "SellingTo", "elementName": "SellingTo", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop": true, "elementGroups" : [ "row" ], "elementLabel": "BusinessUnit", "elementName": "BusinessUnit", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "Rebates", "elementName" : "Rebates", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "Warranty", "elementName" : "Warranty", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "CustomerNegotiatedDiscounts", "elementName" : "CustomerNegotiatedDiscounts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "Quantity", "elementName" : "Quantity", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "OtherCOGS", "elementName" : "OtherCOGS", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "OtherOnInvoicePromotions", "elementName" : "OtherOnInvoicePromotions", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "Customer_Charge_Installation", "elementName" : "Customer_Charge_Installation", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "VolumeBonus", "elementName" : "VolumeBonus", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "PreviousPricingDate", "elementName" : "PreviousPricingDate", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "UOM", "elementName" : "UOM", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "RealizedPrice", "elementName" : "RealizedPrice", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "NetPrice", "elementName" : "NetPrice", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "InvoicePrice", "elementName" : "InvoicePrice", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "DeltaNetPrice", "elementName" : "DeltaNetPrice", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "ListPriceUpliftCounter", "elementName" : "ListPriceUpliftCounter", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "EarlyPaymentDiscounts", "elementName" : "EarlyPaymentDiscounts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "RawMaterials", "elementName" : "RawMaterials", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "DocumentLineId", "elementName" : "DocumentLineId", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "Corrections", "elementName" : "Corrections", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "ForeignExchangeAdjustment", "elementName" : "ForeignExchangeAdjustment", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "InstantRebates", "elementName" : "InstantRebates", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "SalesChannelDiscounts", "elementName" : "SalesChannelDiscounts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "ProductId", "elementName" : "ProductId", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "DeltaLocalListPrice", "elementName" : "DeltaLocalListPrice", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementLabel" : "Global", "elementName" : "Global", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : false }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "CompetitiveDiscounts", "elementName" : "CompetitiveDiscounts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "FreightCharges", "elementName" : "FreightCharges", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "SupportCost", "elementName" : "SupportCost", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "OtherTransactionCosts", "elementName" : "OtherTransactionCosts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "Production", "elementName" : "Production", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "MarketingDevelopmentPromotions", "elementName" : "MarketingDevelopmentPromotions", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "CustomizationCharges", "elementName" : "CustomizationCharges", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "Product_or_Service", "elementName" : "Product_or_Service", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "CustomerLoyaltyProgram", "elementName" : "CustomerLoyaltyProgram", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "EndCustomerOnInvoiceDiscounts", "elementName" : "EndCustomerOnInvoiceDiscounts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "OtherOffInvoiceDiscounts", "elementName" : "OtherOffInvoiceDiscounts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "PreviousNetPricePU", "elementName" : "PreviousNetPricePU", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "VolumeDiscounts", "elementName" : "VolumeDiscounts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "PreviousInvoicePricePU", "elementName" : "PreviousInvoicePricePU", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "StockingAllowance", "elementName" : "StockingAllowance", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "CustomizationCosts", "elementName" : "CustomizationCosts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "GrossMargin", "elementName" : "GrossMargin", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "UniqueId", "elementName" : "UniqueId", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "FreeGiveaways", "elementName" : "FreeGiveaways", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "SeasonalDiscounts", "elementName" : "SeasonalDiscounts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "CustomerId", "elementName" : "CustomerId", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "DeltaMargin", "elementName" : "DeltaMargin", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "ExpeditedShipping", "elementName" : "ExpeditedShipping", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "InstallationCharges", "elementName" : "InstallationCharges", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "DeltaRealizedPrice", "elementName" : "DeltaRealizedPrice", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "PricingDate", "elementName" : "PricingDate", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "OffInvoicePromotions", "elementName" : "OffInvoicePromotions", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "PreviousRealizedPricePU", "elementName" : "PreviousRealizedPricePU", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "LocalAdjustment", "elementName" : "LocalAdjustment", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "RushOrders", "elementName" : "RushOrders", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "Customer_Charge_Customization", "elementName" : "Customer_Charge_Customization", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "DeltaInvoicePrice", "elementName" : "DeltaInvoicePrice", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "InventoryMaintenance", "elementName" : "InventoryMaintenance", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "GlobalListPrice", "elementName" : "GlobalListPrice", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "CustomerPickupAllowance", "elementName" : "CustomerPickupAllowance", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "PreviousLocalListPricePU", "elementName" : "PreviousLocalListPricePU", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "PreviousMarginPU", "elementName" : "PreviousMarginPU", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "ConsignmentCost", "elementName" : "ConsignmentCost", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "QuickCashPaymentDiscounts", "elementName" : "QuickCashPaymentDiscounts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "TradeSpend", "elementName" : "TradeSpend", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "DocumentId", "elementName" : "DocumentId", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "Labor", "elementName" : "Labor", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "SellingFrom", "elementName" : "SellingFrom", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "InstallationCosts", "elementName" : "InstallationCosts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "Currency", "elementName" : "Currency", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "ReceivablesCarrying", "elementName" : "ReceivablesCarrying", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "EndCustomerOffInvoiceDiscounts", "elementName" : "EndCustomerOffInvoiceDiscounts", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "LocalListPrice", "elementName" : "LocalListPrice", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "SlottingAllowance", "elementName" : "SlottingAllowance", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "ListPriceChangeCounter", "elementName" : "ListPriceChangeCounter", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "SalesRep", "elementName" : "SalesRep", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true }, { "displayedInPriceShop" : true, "elementGroups" : [ "row" ], "elementLabel" : "Freight", "elementName" : "Freight", "formulaDate" : "2016-01-01", "formulaName" : "Plasma_Transactions_Exchange", "key" : false, "selected" : true } ], "targetDate" : "2020-05-15" }, "continuous" : false, "distributed" : false, "dtoSourceFilter" : { "_constructor" : "AdvancedCriteria", "criteria" : [ ], "operator" : "and" }, "incremental" : true, "isDefault" : false, "isPlasma" : false, "label" : "Plasma_Transactions_Exchange", "sourceName" : "DMDS.Plasma_TX", "targetDate" : "2020-05-15", "targetName" : "DM.Plasma_Transactions", "type" : "CALCULATION", "valid" : true, "withTargetSnapshot" : false }, { "actionUUID" : "CalculationTask-zRsxS", "calculationConfig" : { "feederInputParams": [], "formulaName": "Plasma_Data_Extractor", "inputParams": [ { "label": "Extractor Name", "name": "Extractor Name", "parameterConfig": { "dataType": "text" }, "type": "STRINGUSERENTRY", "value": "Transactions" } ], "mappingParams": [ { "label" : "Extractor Name", "name" : "Extractor Name", "parameterConfig" : { }, "type" : "" } ], "outputElements" : [ { "displayedInPriceShop": false, "elementGroups": [ "init" ], "elementLabel": "From Date", "elementName": "FromDate", "formulaDate": "2019-01-03", "formulaName": "PlasmaDataExtractor", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "init" ], "elementLabel": "PrimarySourceType", "elementName": "PrimarySourceType", "formulaDate": "2019-01-03", "formulaName": "PlasmaDataExtractor", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "init" ], "elementLabel": "PrimarySource", "elementName": "PrimarySource", "formulaDate": "2019-01-03", "formulaName": "PlasmaDataExtractor", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "init" ], "elementLabel": "DataPartitionValue", "elementName": "DataPartitionValue", "formulaDate": "2019-01-03", "formulaName": "PlasmaDataExtractor", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "init" ], "elementLabel": "PrimarySourceAlias", "elementName": "PrimarySourceAlias", "formulaDate": "2019-01-03", "formulaName": "PlasmaDataExtractor", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "init" ], "elementLabel": "To Date", "elementName": "ToDate", "formulaDate": "2019-01-03", "formulaName": "PlasmaDataExtractor", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "init" ], "elementLabel": "Extractor", "elementName": "Extractor", "formulaDate": "2019-01-03", "formulaName": "PlasmaDataExtractor", "key": false, "selected": false } ] }, "continuous": false, "distributed": false, "dtoFilter": { "_constructor": "AdvancedCriteria", "criteria": [ { "fieldName": "UniqueId", "operator": "isNull" } ], "operator": "and" }, "incremental": true, "isDefault": false, "isPlasma": false, "label": "Plasma_Transactions", "targetName": "DMDS.Plasma_Transactions", "type": "CALCULATION", "valid": true, "withTargetSnapshot": false }, { "actionUUID": "CalculationTask-UqtTI", "allowBatching": true, "calculationConfig": { "feederInputParams": [], "formulaName": "Plasma_Transactions_PreviousPrice", "inputParams": [ { "formattingOptions": {}, "label": "ProductId", "name": "ProductId", "parameterConfig": { "dataType": "text" }, "type": "STRINGUSERENTRY" }, { "formattingOptions": {}, "label": "CustomerId", "name": "CustomerId", "parameterConfig": { "dataType": "text" }, "type": "STRINGUSERENTRY" }, { "formattingOptions": {}, "label": "BusinessUnit", "name": "BusinessUnit", "parameterConfig": { "dataType": "text" }, "type": "STRINGUSERENTRY" }, { "formattingOptions": {}, "label": "PricingDate", "name": "PricingDate", "parameterConfig": { "dataType": "text" }, "type": "STRINGUSERENTRY" }, { "formattingOptions": {}, "label": "LocalListPricePU", "name": "LocalListPricePU", "parameterConfig": { "dataType": "float" }, "type": "USERENTRY" }, { "formattingOptions": {}, "label": "InvoicePricePU", "name": "InvoicePricePU", "parameterConfig": { "dataType": "float" }, "type": "USERENTRY" }, { "formattingOptions": {}, "label": "NetPricePU", "name": "NetPricePU", "parameterConfig": { "dataType": "float" }, "type": "USERENTRY" }, { "formattingOptions": {}, "label": "RealizedPricePU", "name": "RealizedPricePU", "parameterConfig": { "dataType": "float" }, "type": "USERENTRY" }, { "formattingOptions": {}, "label": "MarginPU", "name": "MarginPU", "parameterConfig": { "dataType": "float" }, "type": "USERENTRY" } ], "mappingParams": [ { "formattingOptions": {}, "label": "ProductId", "name": "ProductId", "parameterConfig": {}, "type": "", "value": "ProductId" }, { "formattingOptions": {}, "label": "CustomerId", "name": "CustomerId", "parameterConfig": {}, "type": "", "value": "CustomerId" }, { "formattingOptions": {}, "label": "PricingDate", "name": "PricingDate", "parameterConfig": {}, "type": "", "value": "PricingDate" }, { "formattingOptions": {}, "label": "LocalListPricePU", "name": "LocalListPricePU", "parameterConfig": {}, "type": "" }, { "formattingOptions": {}, "label": "InvoicePricePU", "name": "InvoicePricePU", "parameterConfig": {}, "type": "" }, { "formattingOptions": {}, "label": "NetPricePU", "name": "NetPricePU", "parameterConfig": {}, "type": "" }, { "formattingOptions": {}, "label": "RealizedPricePU", "name": "RealizedPricePU", "parameterConfig": {}, "type": "" }, { "formattingOptions": {}, "label": "MarginPU", "name": "MarginPU", "parameterConfig": {}, "type": "" }, { "formattingOptions": {}, "label": "Currency", "name": "Currency", "parameterConfig": { "dataType": "text" }, "type": "USERENTRY" } ], "outputElements": [ { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "PreviousInvoicePricePU", "elementName": "PreviousInvoicePricePU", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "PreviousLocalListPricePU", "elementName": "PreviousLocalListPricePU", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "PreviousMarginPU", "elementName": "PreviousMarginPU", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "ProductId", "elementName": "ProductId", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": false }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "CustomerId", "elementName": "CustomerId", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": false }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "DeltaMargin", "elementName": "DeltaMargin", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "DeltaLocalListPrice", "elementName": "DeltaLocalListPrice", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "DeltaRealizedPrice", "elementName": "DeltaRealizedPrice", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "PricingDate", "elementName": "PricingDate", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": false }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementName": "RealizedPrice", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": false }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "PreviousCurrency", "elementName": "PreviousCurrency", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "PreviousPricingDate", "elementName": "PreviousPricingDate", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementName": "NetPrice", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": false }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementName": "InvoicePrice", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": false }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "PreviousRealizedPricePU", "elementName": "PreviousRealizedPricePU", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "init", "row" ], "elementLabel": "PreviousRow", "elementName": "PreviousRow", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": false }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "DeltaNetPrice", "elementName": "DeltaNetPrice", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "ListPriceUpliftCounter", "elementName": "ListPriceUpliftCounter", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementName": "LocalListPrice", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": false }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementName": "Margin", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": false }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "ListPriceChangeCounter", "elementName": "ListPriceChangeCounter", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "DeltaInvoicePrice", "elementName": "DeltaInvoicePrice", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "PreviousNetPricePU", "elementName": "PreviousNetPricePU", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true } ], "targetDate": "2019-08-29" }, "continuous": false, "distributed": false, "dtoFilter": { "_constructor": "AdvancedCriteria", "criteria": [ { "_constructor": "AdvancedCriteria", "fieldName": "PreviousPricingDate", "operator": "isNull" } ], "operator": "and" }, "incLoadDate": "2021-04-06T16:08:22", "incremental": false, "isDefault": false, "isPlasma": false, "label": "Plasma_Transactions_PreviousPrice", "sortBy": "PricingDate", "targetDate": "2019-08-29", "targetName": "DMDS.Plasma_Transactions", "type": "CALCULATION", "valid": true, "withTargetSnapshot": false }, { "actionUUID": "CalculationTask-UqtTI", "allowBatching": true, "calculationConfig": { "feederInputParams": [], "formulaName": "Plasma_Transactions_PreviousPrice", "inputParams": [ { "formattingOptions": {}, "label": "ProductId", "name": "ProductId", "parameterConfig": { "dataType": "text" }, "type": "STRINGUSERENTRY" }, { "formattingOptions": {}, "label": "CustomerId", "name": "CustomerId", "parameterConfig": { "dataType": "text" }, "type": "STRINGUSERENTRY" }, { "formattingOptions": {}, "label" : "BusinessUnit", "name" : "BusinessUnit", "parameterConfig" : { "dataType" : "text" }, "type" : "STRINGUSERENTRY" }, { "formattingOptions": {}, "label": "PricingDate", "name": "PricingDate", "parameterConfig": { "dataType": "text" }, "type": "STRINGUSERENTRY" }, { "formattingOptions": {}, "label": "LocalListPricePU", "name": "LocalListPricePU", "parameterConfig": { "dataType": "float" }, "type": "USERENTRY" }, { "formattingOptions": {}, "label": "InvoicePricePU", "name": "InvoicePricePU", "parameterConfig": { "dataType": "float" }, "type": "USERENTRY" }, { "formattingOptions": {}, "label": "NetPricePU", "name": "NetPricePU", "parameterConfig": { "dataType": "float" }, "type": "USERENTRY" }, { "formattingOptions": {}, "label": "RealizedPricePU", "name": "RealizedPricePU", "parameterConfig": { "dataType": "float" }, "type": "USERENTRY" }, { "formattingOptions": {}, "label": "MarginPU", "name": "MarginPU", "parameterConfig": { "dataType": "float" }, "type": "USERENTRY" } ], "mappingParams": [ { "formattingOptions": {}, "label": "ProductId", "name": "ProductId", "parameterConfig": {}, "type": "", "value": "ProductId" }, { "formattingOptions": {}, "label": "CustomerId", "name": "CustomerId", "parameterConfig": {}, "type": "", "value": "CustomerId" }, { "formattingOptions": {}, "label": "PricingDate", "name": "PricingDate", "parameterConfig": {}, "type": "", "value": "PricingDate" }, { "formattingOptions": {}, "label": "LocalListPricePU", "name": "LocalListPricePU", "parameterConfig": {}, "type": "" }, { "formattingOptions": {}, "label": "InvoicePricePU", "name": "InvoicePricePU", "parameterConfig": {}, "type": "" }, { "formattingOptions": {}, "label": "NetPricePU", "name": "NetPricePU", "parameterConfig": {}, "type": "" }, { "formattingOptions": {}, "label": "RealizedPricePU", "name": "RealizedPricePU", "parameterConfig": {}, "type": "" }, { "formattingOptions": {}, "label": "MarginPU", "name": "MarginPU", "parameterConfig": {}, "type": "" } ], "outputElements": [ { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "PreviousInvoicePricePU", "elementName": "PreviousInvoicePricePU", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "PreviousLocalListPricePU", "elementName": "PreviousLocalListPricePU", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "PreviousMarginPU", "elementName": "PreviousMarginPU", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "ProductId", "elementName": "ProductId", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": false }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "CustomerId", "elementName": "CustomerId", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": false }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "DeltaMargin", "elementName": "DeltaMargin", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "DeltaLocalListPrice", "elementName": "DeltaLocalListPrice", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "DeltaRealizedPrice", "elementName": "DeltaRealizedPrice", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "PricingDate", "elementName": "PricingDate", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": false }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementName": "RealizedPrice", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": false }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "PreviousPricingDate", "elementName": "PreviousPricingDate", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementName": "NetPrice", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": false }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementName": "InvoicePrice", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": false }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "PreviousRealizedPricePU", "elementName": "PreviousRealizedPricePU", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "init", "row" ], "elementLabel": "PreviousRow", "elementName": "PreviousRow", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": false }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "DeltaNetPrice", "elementName": "DeltaNetPrice", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "ListPriceUpliftCounter", "elementName": "ListPriceUpliftCounter", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementName": "LocalListPrice", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": false }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementName": "Margin", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": false }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "ListPriceChangeCounter", "elementName": "ListPriceChangeCounter", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "DeltaInvoicePrice", "elementName": "DeltaInvoicePrice", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true }, { "displayedInPriceShop": true, "elementGroups": [ "row" ], "elementLabel": "PreviousNetPricePU", "elementName": "PreviousNetPricePU", "formulaDate": "2016-01-01", "formulaName": "Plasma_Transactions_PreviousPrice", "key": false, "selected": true } ], "targetDate": "2019-08-29" }, "continuous": false, "distributed": false, "dtoFilter": { "_constructor": "AdvancedCriteria", "criteria": [ { "_constructor": "AdvancedCriteria", "fieldName": "PreviousPricingDate", "operator": "isNull" } ], "operator": "and" }, "incLoadDate": "2021-04-06T16:08:22", "incremental": false, "isDefault": false, "isPlasma": false, "label": "Plasma_TransactionsPreviousPrice", "sortBy": "PricingDate", "targetDate": "2019-08-29", "targetName": "DMDS.Plasma_TX", "type": "CALCULATION", "valid": true, "withTargetSnapshot": false }, { "actionUUID" : "CalculationTask-zRsxS", "calculationConfig" : { "feederInputParams": [], "formulaName": "Plasma_Transactions_Extractor", "inputParams": [ { "label": "Extractor Name", "name": "Extractor Name", "parameterConfig": { "dataType": "text" }, "type": "STRINGUSERENTRY", "value": "Transactions" } ], "mappingParams": [ { "label" : "Extractor Name", "name" : "Extractor Name", "parameterConfig" : { }, "type" : "" } ], "outputElements" : [ { "displayedInPriceShop": false, "elementGroups": [ "init" ], "elementLabel": "From Date", "elementName": "FromDate", "formulaDate": "2019-01-03", "formulaName": "PlasmaDataExtractor", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "init" ], "elementLabel": "PrimarySourceType", "elementName": "PrimarySourceType", "formulaDate": "2019-01-03", "formulaName": "PlasmaDataExtractor", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "init" ], "elementLabel": "PrimarySource", "elementName": "PrimarySource", "formulaDate": "2019-01-03", "formulaName": "PlasmaDataExtractor", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "init" ], "elementLabel": "DataPartitionValue", "elementName": "DataPartitionValue", "formulaDate": "2019-01-03", "formulaName": "PlasmaDataExtractor", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "init" ], "elementLabel": "PrimarySourceAlias", "elementName": "PrimarySourceAlias", "formulaDate": "2019-01-03", "formulaName": "PlasmaDataExtractor", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "init" ], "elementLabel": "To Date", "elementName": "ToDate", "formulaDate": "2019-01-03", "formulaName": "PlasmaDataExtractor", "key": false, "selected": false }, { "displayedInPriceShop": false, "elementGroups": [ "init" ], "elementLabel": "Extractor", "elementName": "Extractor", "formulaDate": "2019-01-03", "formulaName": "PlasmaDataExtractor", "key": false, "selected": false } ] }, "continuous": false, "distributed": false, "dtoFilter": { "_constructor": "AdvancedCriteria", "criteria": [ { "fieldName": "UniqueId", "operator": "isNull" } ], "operator": "and" }, "incremental": true, "isDefault": false, "isPlasma": false, "label": "Plasma_Transactions", "targetName": "DMDS.Plasma_TX", "type": "CALCULATION", "valid": true, "withTargetSnapshot": false } ]