GO /****** Object: View [dbo].[wsSysMobileArticulos] Script Date: 11/03/2020 12:53:31 ******/ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[wsSysMobileArticulos]')) DROP VIEW [dbo].[wsSysMobileArticulos] GO GO /****** Object: View [dbo].[wsSysMobileArticulos] Script Date: 11/03/2020 12:53:31 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO /*AND (SUSPENDIDOGM = 0)*/ CREATE VIEW [dbo].[wsSysMobileArticulos] AS SELECT LTRIM(IDARTICULO) AS idArticulo, DESCRIPCION, LTRIM(ISNULL(IDRUBRO, N'')) AS IdRubro, ISNULL(IMPUESTOS, 0) AS Impuestos, TasaIVA, EXENTO, ISNULL(CONVERT(DECIMAL(10, 4), ISNULL(PRECIO1, 0) * 1), 0) AS PRECIO1, ISNULL(CONVERT(DECIMAL(10, 4), ISNULL(PRECIO2, 0) * 1), 0) AS PRECIO2, ISNULL(CONVERT(DECIMAL(10, 4), ISNULL(PRECIO3, 0) * 1), 0) AS PRECIO3, ISNULL(CONVERT(DECIMAL(10, 4), ISNULL(PRECIO1, 0) * 1), 0) AS PRECIO4, ISNULL(CONVERT(DECIMAL(10, 4), ISNULL(PRECIO5, 0) * 1), 0) AS PRECIO5, ISNULL(CONVERT(DECIMAL(10, 4), ISNULL(PRECIO6, 0) * 1), 0) AS PRECIO6, ISNULL(CONVERT(DECIMAL(10, 4), ISNULL(PRECIO7, 0) * 1), 0) AS PRECIO7, ISNULL(CONVERT(DECIMAL(10, 4), ISNULL(PRECIO1, 0) * 1), 0) AS PRECIO8, ISNULL(PRECIO8, 0) * 0 AS PRECIO9, ISNULL(PRECIO8, 0) * 0 AS PRECIO10, LTRIM(ISNULL(IdFamilia, N'')) AS idfamilia FROM dbo.V_MA_ARTICULOS WHERE (SuspendidoC = 0) AND (SuspendidoV = 0) AND (SUSPENDIDO = 0) GO