CREATE VIEW dbo.v_QuoteFull_Q AS SELECT Vers , QuoteType , CodQuote , QuoteRev , IdxQState , CodClient , ClientName , CodItem , CodItemGroup , RawMat , UnitWeight , BatchQty , CodInco , TranspZone , KeyAM , Note , PriceOff , CodClientAssoc , ClientNameAssoc , ItemDescr , CodifProfilo , ClasseMerc , TipoDies , CodDiesGroup , DiamDies , HoleNumDies , DiesPrice , DiesExpLife , DiesEOLife , DiesByClass , NumDiesInList , NumDiesExaust , CodPlant , KeyAMIL , KgTeo , NumSMED , QuotaMan , PRMWeight , PWeight , PTare , LivPackage , LivPackageDett , RawMatCost , RawMatExtraCost , RawMatFullCost , CodPackag , PkgDesc , FSR , ProvvCost , EECost , GasCost , DiesCost , PackCost , TranspCost , SellCost01 , RefCost01 , SellCost04 , RefCost04 , WSR01 , MSR01 , NetProd01 , FC4UG01 , VC4UG01 , OH4UG01 , SC4UG01 , DSR , NetProd04 , FC4UG04 , VC4UG04 , FVC , Charge , FVC + RawMatFullCost AS P_FVC , FC4UG01 + OH4UG01 AS CPS , FC4UG01 + OH4UG01 + FVC + RawMatFullCost AS P_CPS , FC4UG04 + FVC + RawMatFullCost AS P_FC4UG04 , FVC + FC4UG01 + OH4UG01 + FC4UG04 AS FullCost , FVC + FC4UG01 + OH4UG01 + FC4UG04 + RawMatFullCost AS P_FullCost , Charge * (FVC + FC4UG01 + OH4UG01 + FC4UG04) AS MinPrice , Charge * (FVC + FC4UG01 + OH4UG01 + FC4UG04) + RawMatFullCost AS P_MinPrice , PriceOff + RawMatFullCost AS P_PriceOff , PriceOff - (FVC + FC4UG01 + OH4UG01 + FC4UG04) AS NetMar , CASE WHEN (FC4UG01 + OH4UG01 + FC4UG04) = 0 THEN 0 ELSE (PriceOff - FVC) / (FC4UG01 + OH4UG01 + FC4UG04) END AS FCShield , CASE WHEN PWeight = 0 THEN 0 ELSE (PRMWeight - PTare) * (PriceOff + RawMatFullCost) / PWeight END AS PckSur , valid , errorScore , DiesPrice_sim , SamplePrice , DiesFullCost , DiesPriceClientQuote , DiesTecLife , DiesCommLife , MonthSalesPrev , SalesPrevCost , DiesFinCost , ClientQuoteReven , ExtraDiscountDies , WSR01_sim , MSR01_sim , NetProd01_sim , NetProd04_sim , DSR_sim , PriceOff - (FVC + FC4UG01 + OH4UG01 + FC4UG04) - ExtraDiscountDies AS NetMar_sim , CASE WHEN (FC4UG01 + OH4UG01 + FC4UG04) = 0 THEN 0 ELSE (PriceOff - FVC - ExtraDiscountDies) / (FC4UG01 + OH4UG01 + FC4UG04) END AS FCShield_sim , Charge * (FVC + FC4UG01 + OH4UG01 + FC4UG04) + ExtraDiscountDies AS MinPrice_sim , Charge * (FVC + FC4UG01 + OH4UG01 + FC4UG04) + RawMatFullCost + ExtraDiscountDies AS P_MinPrice_sim FROM dbo.QuoteFull_S UNION SELECT Vers , QuoteType , CodQuote , QuoteRev , IdxQState , CodClient , ClientName , CodItem , CodItemGroup , RawMat , UnitWeight , BatchQty , CodInco , TranspZone , KeyAM , Note , PriceOff , CodClientAssoc , ClientNameAssoc , ItemDescr , CodifProfilo , ClasseMerc , TipoDies , CodDiesGroup , DiamDies , HoleNumDies , DiesPrice , DiesExpLife , DiesEOLife , DiesByClass , NumDiesInList , NumDiesExaust , CodPlant , KeyAMIL , KgTeo , NumSMED , QuotaMan , PRMWeight , PWeight , PTare , LivPackage , LivPackageDett , RawMatCost , RawMatExtraCost , RawMatFullCost , CodPackag , PkgDesc , FSR , ProvvCost , EECost , GasCost , DiesCost , PackCost , TranspCost , SellCost01 , RefCost01 , SellCost04 , RefCost04 , WSR01 , MSR01 , NetProd01 , FC4UG01 , VC4UG01 , OH4UG01 , SC4UG01 , DSR , NetProd04 , FC4UG04 , VC4UG04 , FVC , Charge , FVC + RawMatFullCost AS P_FVC , FC4UG01 + OH4UG01 AS CPS , FC4UG01 + OH4UG01 + FVC + RawMatFullCost AS P_CPS , FC4UG04 + FVC + RawMatFullCost AS P_FC4UG04 , FVC + FC4UG01 + OH4UG01 + FC4UG04 AS FullCost , FVC + FC4UG01 + OH4UG01 + FC4UG04 + RawMatFullCost AS P_FullCost , Charge * (FVC + FC4UG01 + OH4UG01 + FC4UG04) AS MinPrice , Charge * (FVC + FC4UG01 + OH4UG01 + FC4UG04) + RawMatFullCost AS P_MinPrice , PriceOff + RawMatFullCost AS P_PriceOff , PriceOff - (FVC + FC4UG01 + OH4UG01 + FC4UG04) AS NetMar , CASE WHEN (FC4UG01 + OH4UG01 + FC4UG04) = 0 THEN 0 ELSE (PriceOff - FVC) / (FC4UG01 + OH4UG01 + FC4UG04) END AS FCShield , CASE WHEN PWeight = 0 THEN 0 ELSE (PRMWeight - PTare) * (PriceOff + RawMatFullCost) / PWeight END AS PckSur , valid , errorScore , 0.0 AS DiesPrice_sim , 0.0 AS SamplePrice , 0.0 AS DiesFullCost , 0.0 AS DiesPriceClientQuote , 0.0 AS DiesTecLife , 0.0 AS DiesCommLife , 0.0 AS MonthSalesPrev , 0.0 AS SalesPrevCost , 0.0 AS DiesFinCost , 0.0 AS ClientQuoteReven , 0.0 AS ExtraDiscountDies , 0.0 AS WSR01_sim , 0.0 AS MSR01_sim , 0.0 AS NetProd01_sim , 0.0 AS NetProd04_sim , 0.0 AS DSR_sim , 0.0 AS NetMar_sim , 0.0 AS FCShield_sim , 0.0 AS MinPrice_sim , 0.0 AS P_MinPrice_sim FROM dbo.QuoteFull_Q GO EXECUTE sp_addextendedproperty @name = N'MS_DiagramPane1', @value = N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00] Begin DesignProperties = Begin PaneConfigurations = Begin PaneConfiguration = 0 NumPanes = 4 Configuration = "(H (1[40] 4[20] 2[20] 3) )" End Begin PaneConfiguration = 1 NumPanes = 3 Configuration = "(H (1 [50] 4 [25] 3))" End Begin PaneConfiguration = 2 NumPanes = 3 Configuration = "(H (1 [50] 2 [25] 3))" End Begin PaneConfiguration = 3 NumPanes = 3 Configuration = "(H (4 [30] 2 [40] 3))" End Begin PaneConfiguration = 4 NumPanes = 2 Configuration = "(H (1 [56] 3))" End Begin PaneConfiguration = 5 NumPanes = 2 Configuration = "(H (2 [66] 3))" End Begin PaneConfiguration = 6 NumPanes = 2 Configuration = "(H (4 [50] 3))" End Begin PaneConfiguration = 7 NumPanes = 1 Configuration = "(V (3))" End Begin PaneConfiguration = 8 NumPanes = 3 Configuration = "(H (1[56] 4[18] 2) )" End Begin PaneConfiguration = 9 NumPanes = 2 Configuration = "(H (1 [75] 4))" End Begin PaneConfiguration = 10 NumPanes = 2 Configuration = "(H (1[66] 2) )" End Begin PaneConfiguration = 11 NumPanes = 2 Configuration = "(H (4 [60] 2))" End Begin PaneConfiguration = 12 NumPanes = 1 Configuration = "(H (1) )" End Begin PaneConfiguration = 13 NumPanes = 1 Configuration = "(V (4))" End Begin PaneConfiguration = 14 NumPanes = 1 Configuration = "(V (2))" End ActivePaneConfig = 0 End Begin DiagramPane = Begin Origin = Top = -672 Left = 0 End Begin Tables = End End Begin SQLPane = End Begin DataPane = Begin ParameterDefaults = "" End Begin ColumnWidths = 101 Width = 284 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 ', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'VIEW', @level1name = N'v_QuoteFull_Q'; GO EXECUTE sp_addextendedproperty @name = N'MS_DiagramPaneCount', @value = 2, @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'VIEW', @level1name = N'v_QuoteFull_Q'; GO EXECUTE sp_addextendedproperty @name = N'MS_DiagramPane2', @value = N' Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 End End Begin CriteriaPane = Begin ColumnWidths = 11 Column = 1440 Alias = 900 Table = 1170 Output = 720 Append = 1400 NewValue = 1170 SortType = 1350 SortOrder = 1410 GroupBy = 1350 Filter = 1350 Or = 1350 Or = 1350 Or = 1350 End End End ', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'VIEW', @level1name = N'v_QuoteFull_Q';