Inversiones/Recursos/ACC0 antes de quitar duplicados.sql

USE [Inversiones_20190711]
GO
/****** Object:  Table [dbo].[ACC0]    Script Date: 12/7/2019 18:51:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ACC0](
	[CodInv] [varchar](20) NOT NULL,
	[OpPrefC] [varchar](1) NULL,
	[OpBolsaC] [varchar](1) NULL,
	[PrecioLimpioC] [numeric](18, 6) NOT NULL,
	[FOperC] [datetime] NOT NULL,
	[FLiqC] [datetime] NOT NULL,
	[DiasTC] [int] NULL,
	[GCapTotC] [numeric](18, 6) NULL,
	[GCapUnC] [numeric](18, 6) NULL,
	[RetAnBrC] [numeric](18, 6) NULL,
	[RetAnNetC] [numeric](18, 6) NULL,
	[UnC] [int] NOT NULL,
	[ValTransC] [numeric](18, 6) NULL,
	[MontoNetoC] [numeric](18, 6) NULL,
	[PrecSucioC] [numeric](18, 6) NULL,
	[FactDiv] [numeric](18, 6) NULL,
	[PrecioLimpioV] [numeric](18, 6) NOT NULL,
	[FOperV] [datetime] NOT NULL,
	[FLiqV] [datetime] NOT NULL,
	[DiasTV] [int] NULL,
	[GCapTotV] [numeric](18, 6) NULL,
	[GCapUnV] [numeric](18, 6) NULL,
	[RetAnBrV] [numeric](18, 6) NULL,
	[RetAnNetV] [numeric](18, 6) NULL,
	[UnV] [int] NOT NULL,
	[ValTransV] [numeric](18, 6) NULL,
	[MontoNetoV] [numeric](18, 6) NULL,
	[PrecSucioV] [numeric](18, 6) NULL,
	[IngresoBruto] [numeric](18, 6) NULL,
	[IngresoBrutoPend] [numeric](18, 6) NULL,
	[ImpSumC] [numeric](18, 6) NULL,
	[ComSumC] [numeric](18, 6) NULL,
	[ImpSumV] [numeric](18, 6) NULL,
	[ComSumV] [numeric](18, 6) NULL,
	[ISR] [numeric](18, 6) NULL,
	[ISRPend] [numeric](18, 6) NULL,
	[IngresoNeto] [numeric](18, 6) NULL,
	[IngresoNetoPend] [numeric](18, 6) NULL,
	[SumImpComCompra] [numeric](18, 6) NULL,
	[SumImpComVenta] [numeric](18, 6) NULL,
	[ComisionCompraCasa] [float] NULL,
	[ComisionCompraBolsa] [float] NULL,
	[ComisionVentaCasa] [float] NULL,
	[ComisionVentaBolsa] [float] NULL,
	[IOF] [bit] NULL,
	[Renta] [bit] NULL,
	[Tipo] [varchar](12) NULL
) ON [PRIMARY]
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GECACC00005', NULL, NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2018-03-01T00:00:00.000' AS DateTime), CAST(N'2018-03-01T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 33, CAST(165.000000 AS Numeric(18, 6)), CAST(165.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 323, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 33, CAST(165.000000 AS Numeric(18, 6)), CAST(165.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GECACC00005', NULL, NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2018-03-01T00:00:00.000' AS DateTime), CAST(N'2018-03-01T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 33, CAST(165.000000 AS Numeric(18, 6)), CAST(165.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 323, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 33, CAST(165.000000 AS Numeric(18, 6)), CAST(165.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GECACC00005', NULL, NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2018-03-01T00:00:00.000' AS DateTime), CAST(N'2018-03-01T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 33, CAST(165.000000 AS Numeric(18, 6)), CAST(165.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 323, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 33, CAST(165.000000 AS Numeric(18, 6)), CAST(165.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GNCACC00002', NULL, NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2016-02-26T00:00:00.000' AS DateTime), CAST(N'2016-02-26T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 473, CAST(2365.000000 AS Numeric(18, 6)), CAST(2365.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 1057, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(1.381268 AS Numeric(18, 6)), CAST(1.312204 AS Numeric(18, 6)), 473, CAST(2365.000000 AS Numeric(18, 6)), CAST(2365.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GNCACC00003', NULL, NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2017-02-28T00:00:00.000' AS DateTime), CAST(N'2017-02-28T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 484, CAST(2420.000000 AS Numeric(18, 6)), CAST(2420.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 689, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(1.059507 AS Numeric(18, 6)), CAST(1.006531 AS Numeric(18, 6)), 484, CAST(2420.000000 AS Numeric(18, 6)), CAST(2420.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GNCACC00005', NULL, NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2017-06-01T00:00:00.000' AS DateTime), CAST(N'2017-06-01T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 47, CAST(235.000000 AS Numeric(18, 6)), CAST(235.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 596, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 47, CAST(235.000000 AS Numeric(18, 6)), CAST(235.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GNCACC00005', NULL, NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2017-06-01T00:00:00.000' AS DateTime), CAST(N'2017-06-01T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 47, CAST(235.000000 AS Numeric(18, 6)), CAST(235.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 596, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(1.224832 AS Numeric(18, 6)), CAST(1.163591 AS Numeric(18, 6)), 47, CAST(235.000000 AS Numeric(18, 6)), CAST(235.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00018', NULL, NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2017-06-08T00:00:00.000' AS DateTime), CAST(N'2017-06-08T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 321, CAST(1605.000000 AS Numeric(18, 6)), CAST(1605.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 589, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 321, CAST(1605.000000 AS Numeric(18, 6)), CAST(1605.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00022', NULL, NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2018-03-01T00:00:00.000' AS DateTime), CAST(N'2018-03-01T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 677, CAST(3385.000000 AS Numeric(18, 6)), CAST(3385.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 323, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 677, CAST(3385.000000 AS Numeric(18, 6)), CAST(3385.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00024', NULL, NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2011-02-23T00:00:00.000' AS DateTime), CAST(N'2011-02-23T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 50000, CAST(250000.000000 AS Numeric(18, 6)), CAST(250000.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2018-12-27T00:00:00.000' AS DateTime), CAST(N'2018-12-30T00:00:00.000' AS DateTime), 2867, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 50000, CAST(250000.000000 AS Numeric(18, 6)), CAST(250000.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00025', NULL, NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2011-02-23T00:00:00.000' AS DateTime), CAST(N'2011-02-23T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 10000, CAST(50000.000000 AS Numeric(18, 6)), CAST(50000.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2018-12-27T00:00:00.000' AS DateTime), CAST(N'2018-12-30T00:00:00.000' AS DateTime), 2867, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 10000, CAST(50000.000000 AS Numeric(18, 6)), CAST(50000.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00004', NULL, NULL, CAST(2.250000 AS Numeric(18, 6)), CAST(N'2013-02-08T00:00:00.000' AS DateTime), CAST(N'2013-02-13T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 13988, CAST(31473.000000 AS Numeric(18, 6)), CAST(31473.000000 AS Numeric(18, 6)), CAST(2.250000 AS Numeric(18, 6)), NULL, CAST(2.250000 AS Numeric(18, 6)), CAST(N'2019-05-21T00:00:00.000' AS DateTime), CAST(N'2019-05-21T00:00:00.000' AS DateTime), 2288, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(2.481546 AS Numeric(18, 6)), CAST(2.357469 AS Numeric(18, 6)), 13988, CAST(31473.000000 AS Numeric(18, 6)), CAST(31473.000000 AS Numeric(18, 6)), CAST(2.250000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACCI0001', NULL, NULL, CAST(10.000000 AS Numeric(18, 6)), CAST(N'2010-12-02T00:00:00.000' AS DateTime), CAST(N'2010-12-03T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 5000, CAST(50000.000000 AS Numeric(18, 6)), CAST(50000.000000 AS Numeric(18, 6)), CAST(10.000000 AS Numeric(18, 6)), NULL, CAST(8.000000 AS Numeric(18, 6)), CAST(N'2019-05-23T00:00:00.000' AS DateTime), CAST(N'2019-05-23T00:00:00.000' AS DateTime), 3093, CAST(-10000.000000 AS Numeric(18, 6)), CAST(-2.000000 AS Numeric(18, 6)), CAST(-2.360168 AS Numeric(18, 6)), CAST(-2.360168 AS Numeric(18, 6)), 5000, CAST(40000.000000 AS Numeric(18, 6)), CAST(40000.000000 AS Numeric(18, 6)), CAST(8.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'ICACC00001', NULL, NULL, CAST(11.428600 AS Numeric(18, 6)), CAST(N'2002-01-02T00:00:00.000' AS DateTime), CAST(N'2002-01-02T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 269, CAST(3074.293400 AS Numeric(18, 6)), CAST(3074.293400 AS Numeric(18, 6)), CAST(11.428600 AS Numeric(18, 6)), NULL, CAST(11.400000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 6225, CAST(-7.693400 AS Numeric(18, 6)), CAST(-0.028600 AS Numeric(18, 6)), CAST(8.293500 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 269, CAST(3066.600000 AS Numeric(18, 6)), CAST(3066.600000 AS Numeric(18, 6)), CAST(11.400000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GECACC00006', NULL, NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2015-05-01T00:00:00.000' AS DateTime), CAST(N'2015-05-01T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 4000, CAST(20000.000000 AS Numeric(18, 6)), CAST(20000.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2022-06-29T00:00:00.000' AS DateTime), CAST(N'2022-07-02T00:00:00.000' AS DateTime), 1476, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(6.305894 AS Numeric(18, 6)), CAST(5.990600 AS Numeric(18, 6)), 4000, CAST(20000.000000 AS Numeric(18, 6)), CAST(20000.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GNCACC00004', NULL, NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2017-06-01T00:00:00.000' AS DateTime), CAST(N'2017-06-01T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 47, CAST(235.000000 AS Numeric(18, 6)), CAST(235.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 596, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(1.224832 AS Numeric(18, 6)), CAST(1.163591 AS Numeric(18, 6)), 47, CAST(235.000000 AS Numeric(18, 6)), CAST(235.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00019', N'N', N'S', CAST(2.450000 AS Numeric(18, 6)), CAST(N'2018-01-12T00:00:00.000' AS DateTime), CAST(N'2018-01-14T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 2715, CAST(6651.750000 AS Numeric(18, 6)), CAST(6651.750000 AS Numeric(18, 6)), CAST(2.450000 AS Numeric(18, 6)), CAST(1.010000 AS Numeric(18, 6)), CAST(2.450000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 369, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(12.515901 AS Numeric(18, 6)), CAST(11.890106 AS Numeric(18, 6)), 2715, CAST(6651.750000 AS Numeric(18, 6)), CAST(6651.750000 AS Numeric(18, 6)), CAST(2.450000 AS Numeric(18, 6)), CAST(841.650000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(42.082500 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(799.567500 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00020', N'N', N'S', CAST(2.400000 AS Numeric(18, 6)), CAST(N'2018-01-31T00:00:00.000' AS DateTime), CAST(N'2018-02-02T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 24349, CAST(58437.600000 AS Numeric(18, 6)), CAST(58437.600000 AS Numeric(18, 6)), CAST(2.400000 AS Numeric(18, 6)), CAST(1.010000 AS Numeric(18, 6)), CAST(2.400000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 350, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(13.470238 AS Numeric(18, 6)), CAST(12.796726 AS Numeric(18, 6)), 24349, CAST(58437.600000 AS Numeric(18, 6)), CAST(58437.600000 AS Numeric(18, 6)), CAST(2.400000 AS Numeric(18, 6)), CAST(7548.190000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(377.409500 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(7170.780500 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00021', N'N', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2018-02-28T00:00:00.000' AS DateTime), CAST(N'2018-02-28T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 3228, NULL, NULL, NULL, CAST(0.100000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 3228, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00022', N'N', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2018-03-01T00:00:00.000' AS DateTime), CAST(N'2018-03-01T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 677, NULL, NULL, NULL, CAST(0.100000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 677, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'CGCACC00001', N'N', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2016-02-28T00:00:00.000' AS DateTime), CAST(N'2016-02-28T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 196, CAST(980.000000 AS Numeric(18, 6)), CAST(982.450000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(0.100000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 1055, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(1000.000000 AS Numeric(18, 6)), CAST(950.000000 AS Numeric(18, 6)), 196, CAST(980.000000 AS Numeric(18, 6)), CAST(977.550000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(58.800000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(2.940000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(55.860000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 0, 0, 0, 0, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'CGCACC00002', N'N', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2017-02-28T00:00:00.000' AS DateTime), CAST(N'2017-02-28T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 202, CAST(1010.000000 AS Numeric(18, 6)), CAST(1010.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(0.100000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 689, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(2.119013 AS Numeric(18, 6)), CAST(2.013062 AS Numeric(18, 6)), 202, CAST(1010.000000 AS Numeric(18, 6)), CAST(1010.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(40.400000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(2.020000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(38.380000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'CGCACC00003', N'N', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2017-06-01T00:00:00.000' AS DateTime), CAST(N'2017-06-01T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 19, CAST(95.000000 AS Numeric(18, 6)), CAST(95.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(0.100000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 596, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(2.449664 AS Numeric(18, 6)), CAST(2.327181 AS Numeric(18, 6)), 19, CAST(95.000000 AS Numeric(18, 6)), CAST(95.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(3.800000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(0.190000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(3.610000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'CGCACC00004', N'N', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2018-02-28T00:00:00.000' AS DateTime), CAST(N'2018-02-28T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 201, CAST(1005.000000 AS Numeric(18, 6)), CAST(1005.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(0.100000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 324, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(2.253086 AS Numeric(18, 6)), CAST(2.140432 AS Numeric(18, 6)), 201, CAST(1005.000000 AS Numeric(18, 6)), CAST(1005.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(20.100000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(1.005000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(19.095000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'CGCACC00005', N'N', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2018-03-01T00:00:00.000' AS DateTime), CAST(N'2018-03-01T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 41, CAST(205.000000 AS Numeric(18, 6)), CAST(205.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(0.100000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 323, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(2.260062 AS Numeric(18, 6)), CAST(2.147059 AS Numeric(18, 6)), 41, CAST(205.000000 AS Numeric(18, 6)), CAST(205.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(4.100000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(0.205000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(3.895000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GECACC00001', N'N', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2016-02-28T00:00:00.000' AS DateTime), CAST(N'2016-02-28T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 157, CAST(785.000000 AS Numeric(18, 6)), CAST(785.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(0.100000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 1055, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.013839 AS Numeric(18, 6)), CAST(0.013147 AS Numeric(18, 6)), 157, CAST(785.000000 AS Numeric(18, 6)), CAST(785.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(31.400000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(1.570000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(29.830000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GECACC00002', N'N', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2017-02-28T00:00:00.000' AS DateTime), CAST(N'2017-02-28T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 161, CAST(805.000000 AS Numeric(18, 6)), CAST(805.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(0.100000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 689, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.010595 AS Numeric(18, 6)), CAST(0.010065 AS Numeric(18, 6)), 161, CAST(805.000000 AS Numeric(18, 6)), CAST(805.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(16.100000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(0.805000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(15.295000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GECACC00003', N'N', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2017-02-28T00:00:00.000' AS DateTime), CAST(N'2017-02-28T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 15, CAST(75.000000 AS Numeric(18, 6)), CAST(75.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(0.100000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 689, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(1.059507 AS Numeric(18, 6)), CAST(1.006531 AS Numeric(18, 6)), 15, CAST(75.000000 AS Numeric(18, 6)), CAST(75.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(1.500000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(0.075000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(1.425000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GECACC00004', N'N', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2018-02-28T00:00:00.000' AS DateTime), CAST(N'2018-02-28T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 161, NULL, NULL, NULL, CAST(0.100000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 161, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GECACC00005', N'N', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2018-03-01T00:00:00.000' AS DateTime), CAST(N'2018-03-01T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 33, NULL, NULL, NULL, CAST(0.100000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 33, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GNCACC00004', N'N', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2017-06-01T00:00:00.000' AS DateTime), CAST(N'2017-06-01T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 47, CAST(235.000000 AS Numeric(18, 6)), CAST(235.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(0.100000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 596, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.012248 AS Numeric(18, 6)), CAST(0.011636 AS Numeric(18, 6)), 47, CAST(235.000000 AS Numeric(18, 6)), CAST(235.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(4.700000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(0.235000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(4.465000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GNCACC00005', N'N', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2017-06-01T00:00:00.000' AS DateTime), CAST(N'2017-06-01T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 47, NULL, NULL, NULL, CAST(0.100000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 47, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GNCACC00006', N'N', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2018-02-28T00:00:00.000' AS DateTime), CAST(N'2018-02-28T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 483, CAST(2415.000000 AS Numeric(18, 6)), CAST(2415.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(0.100000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 324, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.022531 AS Numeric(18, 6)), CAST(0.021404 AS Numeric(18, 6)), 483, CAST(2415.000000 AS Numeric(18, 6)), CAST(2415.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(48.300000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(2.415000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(45.885000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GNCACC00007', N'N', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2018-03-01T00:00:00.000' AS DateTime), CAST(N'2018-03-01T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 100, CAST(500.000000 AS Numeric(18, 6)), CAST(500.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(0.100000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 323, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 100, CAST(500.000000 AS Numeric(18, 6)), CAST(500.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00023', N'S', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2012-02-10T00:00:00.000' AS DateTime), CAST(N'2017-02-10T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.050000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 20000, CAST(100000.000000 AS Numeric(18, 6)), CAST(100250.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(0.060000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2018-12-27T00:00:00.000' AS DateTime), CAST(N'2018-12-30T00:00:00.000' AS DateTime), 688, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(600.000000 AS Numeric(18, 6)), CAST(570.000000 AS Numeric(18, 6)), 20000, CAST(100000.000000 AS Numeric(18, 6)), CAST(99750.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00024', N'S', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2011-02-23T00:00:00.000' AS DateTime), CAST(N'2011-02-23T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 50000, NULL, NULL, NULL, CAST(0.060000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2018-12-27T00:00:00.000' AS DateTime), CAST(N'2018-12-30T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 50000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00025', N'S', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2011-02-23T00:00:00.000' AS DateTime), CAST(N'2011-02-23T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 10000, NULL, NULL, NULL, CAST(0.060000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2018-12-27T00:00:00.000' AS DateTime), CAST(N'2018-12-30T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 10000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00026', N'S', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2015-05-01T00:00:00.000' AS DateTime), CAST(N'2015-05-01T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 20000, NULL, NULL, NULL, CAST(0.090000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2023-02-10T00:00:00.000' AS DateTime), CAST(N'2023-02-13T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 20000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00027', N'S', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2015-03-01T00:00:00.000' AS DateTime), CAST(N'2015-03-01T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 50000, NULL, NULL, NULL, CAST(0.090000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2021-02-23T00:00:00.000' AS DateTime), CAST(N'2021-02-26T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 50000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00028', N'S', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2015-05-01T00:00:00.000' AS DateTime), CAST(N'2015-05-01T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 10000, NULL, NULL, NULL, CAST(0.090000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2022-02-23T00:00:00.000' AS DateTime), CAST(N'2022-02-26T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 10000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GNCACC00008', N'S', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2015-05-01T00:00:00.000' AS DateTime), CAST(N'2015-05-01T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 2000, NULL, NULL, NULL, CAST(0.090000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2022-06-29T00:00:00.000' AS DateTime), CAST(N'2022-07-02T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GNCACC00009', N'S', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2015-05-01T00:00:00.000' AS DateTime), CAST(N'2015-05-01T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 10000, NULL, NULL, NULL, CAST(0.090000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2023-02-10T00:00:00.000' AS DateTime), CAST(N'2023-02-13T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 10000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GECACC00006', N'S', N'N', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2015-05-01T00:00:00.000' AS DateTime), CAST(N'2015-05-01T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 4000, CAST(20000.000000 AS Numeric(18, 6)), CAST(20000.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(0.090000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2022-06-29T00:00:00.000' AS DateTime), CAST(N'2022-07-02T00:00:00.000' AS DateTime), 1398, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.066577 AS Numeric(18, 6)), CAST(0.063248 AS Numeric(18, 6)), 4000, CAST(20000.000000 AS Numeric(18, 6)), CAST(20000.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(5100.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(255.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(4845.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'CGCACC00006', N'S', N'N', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2015-05-01T00:00:00.000' AS DateTime), CAST(N'2015-05-01T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 5000, CAST(25000.000000 AS Numeric(18, 6)), CAST(25000.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(0.090000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2022-06-29T00:00:00.000' AS DateTime), CAST(N'2022-07-02T00:00:00.000' AS DateTime), 1398, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.066577 AS Numeric(18, 6)), CAST(0.063248 AS Numeric(18, 6)), 5000, CAST(25000.000000 AS Numeric(18, 6)), CAST(25000.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(6375.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(318.750000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(6056.250000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'MESVACC00001', N'S', N'S', CAST(1.000000 AS Numeric(18, 6)), CAST(N'2018-04-01T00:00:00.000' AS DateTime), CAST(N'2018-04-01T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, CAST(0.090000 AS Numeric(18, 6)), CAST(1.000000 AS Numeric(18, 6)), CAST(N'2029-03-29T00:00:00.000' AS DateTime), CAST(N'2029-04-01T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00001', NULL, NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2011-02-25T00:00:00.000' AS DateTime), CAST(N'2011-02-25T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 2045, CAST(10225.000000 AS Numeric(18, 6)), CAST(10225.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, CAST(0.000000 AS Numeric(18, 6)), CAST(N'2019-06-26T00:00:00.000' AS DateTime), CAST(N'2019-06-26T00:00:00.000' AS DateTime), 3043, CAST(-10225.000000 AS Numeric(18, 6)), CAST(-5.000000 AS Numeric(18, 6)), CAST(-3.028500 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 2045, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00002', N'N', N'N', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2011-04-16T00:00:00.000' AS DateTime), CAST(N'2011-04-16T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 1740, CAST(8700.000000 AS Numeric(18, 6)), CAST(8721.750000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(1.780000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 2834, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 1740, CAST(8700.000000 AS Numeric(18, 6)), CAST(8678.250000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(9419.686620 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(470.984331 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(8948.702289 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 0, 0, 0, 0, 1, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00003', N'N', N'N', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2011-04-18T00:00:00.000' AS DateTime), CAST(N'2011-04-18T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 543, CAST(2715.000000 AS Numeric(18, 6)), CAST(2721.787500 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(1.780000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 2832, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 543, CAST(2715.000000 AS Numeric(18, 6)), CAST(2708.212500 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(2894.934996 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(144.746750 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(2750.188246 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 0, 0, 0, 0, 1, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00005', N'N', N'S', CAST(2.500000 AS Numeric(18, 6)), CAST(N'2013-04-19T00:00:00.000' AS DateTime), CAST(N'2013-04-19T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 2286, CAST(5715.000000 AS Numeric(18, 6)), CAST(5715.000000 AS Numeric(18, 6)), CAST(2.500000 AS Numeric(18, 6)), CAST(1.210000 AS Numeric(18, 6)), CAST(2.500000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 2100, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(10.567619 AS Numeric(18, 6)), CAST(10.039238 AS Numeric(18, 6)), 2286, CAST(5715.000000 AS Numeric(18, 6)), CAST(5715.000000 AS Numeric(18, 6)), CAST(2.500000 AS Numeric(18, 6)), CAST(3474.720000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(173.736000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(3300.984000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00006', N'N', N'S', CAST(2.500000 AS Numeric(18, 6)), CAST(N'2013-04-24T00:00:00.000' AS DateTime), CAST(N'2013-04-27T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 4013, CAST(10032.500000 AS Numeric(18, 6)), CAST(10032.500000 AS Numeric(18, 6)), CAST(2.500000 AS Numeric(18, 6)), CAST(1.210000 AS Numeric(18, 6)), CAST(2.500000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 2092, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(69.789700 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 4013, CAST(10032.500000 AS Numeric(18, 6)), CAST(10032.500000 AS Numeric(18, 6)), CAST(2.500000 AS Numeric(18, 6)), CAST(6099.760000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(304.988000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(5794.772000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 0, 0, 0, 0, 0, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00007', N'N', N'S', CAST(2.500000 AS Numeric(18, 6)), CAST(N'2013-08-12T00:00:00.000' AS DateTime), CAST(N'2013-08-12T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 1143, CAST(2857.500000 AS Numeric(18, 6)), CAST(2857.500000 AS Numeric(18, 6)), CAST(2.500000 AS Numeric(18, 6)), CAST(1.210000 AS Numeric(18, 6)), CAST(2.500000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 1985, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(11.179849 AS Numeric(18, 6)), CAST(10.620856 AS Numeric(18, 6)), 1143, CAST(2857.500000 AS Numeric(18, 6)), CAST(2857.500000 AS Numeric(18, 6)), CAST(2.500000 AS Numeric(18, 6)), CAST(1737.360000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(86.868000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(1650.492000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'ICACC00001', N'N', N'S', CAST(11.428600 AS Numeric(18, 6)), CAST(N'2002-01-02T00:00:00.000' AS DateTime), CAST(N'2002-01-02T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 269, CAST(3074.293400 AS Numeric(18, 6)), CAST(3074.293400 AS Numeric(18, 6)), CAST(11.428600 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(11.400000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 6225, CAST(-7.693400 AS Numeric(18, 6)), CAST(-0.028600 AS Numeric(18, 6)), CAST(8.293500 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 269, CAST(3066.600000 AS Numeric(18, 6)), CAST(3066.600000 AS Numeric(18, 6)), CAST(11.400000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00008', N'N', N'S', CAST(2.250000 AS Numeric(18, 6)), CAST(N'2013-12-04T00:00:00.000' AS DateTime), CAST(N'2013-12-04T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 2572, CAST(5787.000000 AS Numeric(18, 6)), CAST(5787.000000 AS Numeric(18, 6)), CAST(2.250000 AS Numeric(18, 6)), CAST(1.010000 AS Numeric(18, 6)), CAST(2.250000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 1871, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(11.444860 AS Numeric(18, 6)), CAST(10.872617 AS Numeric(18, 6)), 2572, CAST(5787.000000 AS Numeric(18, 6)), CAST(5787.000000 AS Numeric(18, 6)), CAST(2.250000 AS Numeric(18, 6)), CAST(3395.040000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(169.752000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(3225.288000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00009', N'N', N'S', CAST(2.250000 AS Numeric(18, 6)), CAST(N'2013-12-27T00:00:00.000' AS DateTime), CAST(N'2013-12-27T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 1683, CAST(3786.750000 AS Numeric(18, 6)), CAST(3786.750000 AS Numeric(18, 6)), CAST(2.250000 AS Numeric(18, 6)), CAST(1.010000 AS Numeric(18, 6)), CAST(2.250000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 1848, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(11.587302 AS Numeric(18, 6)), CAST(11.007937 AS Numeric(18, 6)), 1683, CAST(3786.750000 AS Numeric(18, 6)), CAST(3786.750000 AS Numeric(18, 6)), CAST(2.250000 AS Numeric(18, 6)), CAST(2221.560000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(111.078000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(2110.482000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'ICACC00002', N'N', N'N', CAST(3.000000 AS Numeric(18, 6)), CAST(N'2010-09-06T00:00:00.000' AS DateTime), CAST(N'2010-09-06T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 2788, CAST(8364.000000 AS Numeric(18, 6)), CAST(8364.000000 AS Numeric(18, 6)), CAST(3.000000 AS Numeric(18, 6)), CAST(12.630000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 3056, CAST(-8364.000000 AS Numeric(18, 6)), CAST(-3.000000 AS Numeric(18, 6)), CAST(2.936400 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 2788, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(7731.784756 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(386.589238 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(7345.195518 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 0, 0, 0, 0, 0, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00010', N'N', N'S', CAST(2.400000 AS Numeric(18, 6)), CAST(N'2014-02-07T00:00:00.000' AS DateTime), CAST(N'2014-02-10T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 6200, CAST(14880.000000 AS Numeric(18, 6)), CAST(14880.000000 AS Numeric(18, 6)), CAST(2.400000 AS Numeric(18, 6)), CAST(1.010000 AS Numeric(18, 6)), CAST(2.400000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 1803, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(11.134221 AS Numeric(18, 6)), CAST(10.577510 AS Numeric(18, 6)), 6200, CAST(14880.000000 AS Numeric(18, 6)), CAST(14880.000000 AS Numeric(18, 6)), CAST(2.400000 AS Numeric(18, 6)), CAST(8184.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(409.200000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(7774.800000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00011', N'N', N'S', CAST(2.600000 AS Numeric(18, 6)), CAST(N'2014-06-27T00:00:00.000' AS DateTime), CAST(N'2014-06-27T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 5292, CAST(13759.200000 AS Numeric(18, 6)), CAST(13759.200000 AS Numeric(18, 6)), CAST(2.600000 AS Numeric(18, 6)), CAST(1.010000 AS Numeric(18, 6)), CAST(2.600000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 1666, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(11.122911 AS Numeric(18, 6)), CAST(10.566765 AS Numeric(18, 6)), 5292, CAST(13759.200000 AS Numeric(18, 6)), CAST(13759.200000 AS Numeric(18, 6)), CAST(2.600000 AS Numeric(18, 6)), CAST(6985.440000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(349.272000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(6636.168000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00012', N'N', N'S', CAST(2.500000 AS Numeric(18, 6)), CAST(N'2014-07-07T00:00:00.000' AS DateTime), CAST(N'2014-07-08T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 1643, CAST(4107.500000 AS Numeric(18, 6)), CAST(4107.500000 AS Numeric(18, 6)), CAST(2.500000 AS Numeric(18, 6)), CAST(1.010000 AS Numeric(18, 6)), CAST(2.500000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 1655, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(10.321450 AS Numeric(18, 6)), CAST(9.805378 AS Numeric(18, 6)), 1643, CAST(4107.500000 AS Numeric(18, 6)), CAST(4107.500000 AS Numeric(18, 6)), CAST(2.500000 AS Numeric(18, 6)), CAST(1922.310000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(96.115500 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(1826.194500 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00013', N'N', N'S', CAST(2.500000 AS Numeric(18, 6)), CAST(N'2014-07-15T00:00:00.000' AS DateTime), CAST(N'2014-07-18T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 14458, CAST(36145.000000 AS Numeric(18, 6)), CAST(36145.000000 AS Numeric(18, 6)), CAST(2.500000 AS Numeric(18, 6)), CAST(1.010000 AS Numeric(18, 6)), CAST(2.500000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 1645, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(10.384195 AS Numeric(18, 6)), CAST(9.864985 AS Numeric(18, 6)), 14458, CAST(36145.000000 AS Numeric(18, 6)), CAST(36145.000000 AS Numeric(18, 6)), CAST(2.500000 AS Numeric(18, 6)), CAST(16915.860000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(845.793000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(16070.067000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00014', N'N', N'N', CAST(2.500000 AS Numeric(18, 6)), CAST(N'2014-07-31T00:00:00.000' AS DateTime), CAST(N'2014-07-31T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 2664, CAST(6660.000000 AS Numeric(18, 6)), CAST(6660.000000 AS Numeric(18, 6)), CAST(2.500000 AS Numeric(18, 6)), CAST(1.010000 AS Numeric(18, 6)), CAST(2.500000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 1632, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(10.466912 AS Numeric(18, 6)), CAST(9.943566 AS Numeric(18, 6)), 2664, CAST(6660.000000 AS Numeric(18, 6)), CAST(6660.000000 AS Numeric(18, 6)), CAST(2.500000 AS Numeric(18, 6)), CAST(3116.880000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(155.844000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(2961.036000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00015', N'N', N'N', CAST(2.500000 AS Numeric(18, 6)), CAST(N'2014-07-31T00:00:00.000' AS DateTime), CAST(N'2014-07-31T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 26471, CAST(66177.500000 AS Numeric(18, 6)), CAST(66177.500000 AS Numeric(18, 6)), CAST(2.500000 AS Numeric(18, 6)), CAST(1.010000 AS Numeric(18, 6)), CAST(2.500000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 1632, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(10.466912 AS Numeric(18, 6)), CAST(9.943566 AS Numeric(18, 6)), 26471, CAST(66177.500000 AS Numeric(18, 6)), CAST(66177.500000 AS Numeric(18, 6)), CAST(2.500000 AS Numeric(18, 6)), CAST(30971.070000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(1548.553500 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(29422.516500 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GNCACC00001', N'N', N'N', CAST(3.000000 AS Numeric(18, 6)), CAST(N'2010-09-06T00:00:00.000' AS DateTime), CAST(N'2010-09-06T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 929, CAST(2787.000000 AS Numeric(18, 6)), CAST(2787.000000 AS Numeric(18, 6)), CAST(3.000000 AS Numeric(18, 6)), CAST(8.190000 AS Numeric(18, 6)), CAST(3.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 3056, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(14.880100 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 929, CAST(2787.000000 AS Numeric(18, 6)), CAST(2787.000000 AS Numeric(18, 6)), CAST(3.000000 AS Numeric(18, 6)), CAST(3094.984867 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(154.749244 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(2940.235624 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 0, 0, 0, 0, 0, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00016', N'N', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2016-02-26T00:00:00.000' AS DateTime), CAST(N'2016-02-26T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 3216, NULL, NULL, NULL, CAST(0.100000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 3216, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GNCACC00002', N'N', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2016-02-26T00:00:00.000' AS DateTime), CAST(N'2016-02-26T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 473, CAST(2365.000000 AS Numeric(18, 6)), CAST(2365.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(0.100000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 1057, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.013813 AS Numeric(18, 6)), CAST(0.013122 AS Numeric(18, 6)), 473, CAST(2365.000000 AS Numeric(18, 6)), CAST(2365.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(94.600000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(4.730000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(89.870000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00017', N'N', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2017-02-28T00:00:00.000' AS DateTime), CAST(N'2017-02-28T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 3237, NULL, NULL, NULL, CAST(0.100000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 3237, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GNCACC00003', N'N', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2017-02-28T00:00:00.000' AS DateTime), CAST(N'2017-02-28T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 484, CAST(2420.000000 AS Numeric(18, 6)), CAST(2420.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(0.100000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 689, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.010595 AS Numeric(18, 6)), CAST(0.010065 AS Numeric(18, 6)), 484, CAST(2420.000000 AS Numeric(18, 6)), CAST(2420.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(48.400000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, CAST(2.420000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(45.980000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00018', N'N', N'S', CAST(5.000000 AS Numeric(18, 6)), CAST(N'2017-06-08T00:00:00.000' AS DateTime), CAST(N'2017-06-08T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 321, NULL, NULL, NULL, CAST(0.100000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), NULL, NULL, NULL, NULL, NULL, 321, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00017', NULL, NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2017-02-28T00:00:00.000' AS DateTime), CAST(N'2017-02-28T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 3237, CAST(16185.000000 AS Numeric(18, 6)), CAST(16185.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 689, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 3237, CAST(16185.000000 AS Numeric(18, 6)), CAST(16185.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'GNCACC00007', NULL, NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2018-03-01T00:00:00.000' AS DateTime), CAST(N'2018-03-01T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 100, CAST(500.000000 AS Numeric(18, 6)), CAST(500.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 323, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 100, CAST(500.000000 AS Numeric(18, 6)), CAST(500.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00016', NULL, NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2016-02-26T00:00:00.000' AS DateTime), CAST(N'2016-02-26T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 3216, CAST(16080.000000 AS Numeric(18, 6)), CAST(16080.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 1057, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 3216, CAST(16080.000000 AS Numeric(18, 6)), CAST(16080.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00021', NULL, NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2018-02-28T00:00:00.000' AS DateTime), CAST(N'2018-02-28T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 3228, CAST(16140.000000 AS Numeric(18, 6)), CAST(16140.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2019-01-15T00:00:00.000' AS DateTime), CAST(N'2019-01-18T00:00:00.000' AS DateTime), 324, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 3228, CAST(16140.000000 AS Numeric(18, 6)), CAST(16140.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00023', NULL, NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2012-02-10T00:00:00.000' AS DateTime), CAST(N'2017-02-10T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.050000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 20000, CAST(100000.000000 AS Numeric(18, 6)), CAST(100250.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2018-12-27T00:00:00.000' AS DateTime), CAST(N'2018-12-30T00:00:00.000' AS DateTime), 688, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(600.000000 AS Numeric(18, 6)), CAST(570.000000 AS Numeric(18, 6)), 20000, CAST(100000.000000 AS Numeric(18, 6)), CAST(99750.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 1, 0, N'Porcentaje')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00004', NULL, NULL, CAST(2.250000 AS Numeric(18, 6)), CAST(N'2013-02-08T00:00:00.000' AS DateTime), CAST(N'2013-02-13T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 13988, CAST(31473.000000 AS Numeric(18, 6)), CAST(31473.000000 AS Numeric(18, 6)), CAST(2.250000 AS Numeric(18, 6)), NULL, CAST(2.250000 AS Numeric(18, 6)), CAST(N'2019-05-21T00:00:00.000' AS DateTime), CAST(N'2019-05-21T00:00:00.000' AS DateTime), 2288, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(1.063520 AS Numeric(18, 6)), CAST(1.010344 AS Numeric(18, 6)), 13988, CAST(31473.000000 AS Numeric(18, 6)), CAST(31473.000000 AS Numeric(18, 6)), CAST(2.250000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00004', NULL, NULL, CAST(2.250000 AS Numeric(18, 6)), CAST(N'2013-02-08T00:00:00.000' AS DateTime), CAST(N'2013-02-13T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 13988, CAST(31473.000000 AS Numeric(18, 6)), CAST(31473.000000 AS Numeric(18, 6)), CAST(2.250000 AS Numeric(18, 6)), NULL, CAST(2.250000 AS Numeric(18, 6)), CAST(N'2019-05-21T00:00:00.000' AS DateTime), CAST(N'2019-05-21T00:00:00.000' AS DateTime), 2288, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(1.063520 AS Numeric(18, 6)), CAST(1.010344 AS Numeric(18, 6)), 13988, CAST(31473.000000 AS Numeric(18, 6)), CAST(31473.000000 AS Numeric(18, 6)), CAST(2.250000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00001', NULL, NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2011-02-25T00:00:00.000' AS DateTime), CAST(N'2011-02-25T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 2045, CAST(10225.000000 AS Numeric(18, 6)), CAST(10225.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, CAST(0.000000 AS Numeric(18, 6)), CAST(N'2019-06-26T00:00:00.000' AS DateTime), CAST(N'2019-06-26T00:00:00.000' AS DateTime), 3043, CAST(-10225.000000 AS Numeric(18, 6)), CAST(-5.000000 AS Numeric(18, 6)), CAST(-3.028500 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 2045, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, N'Efectivo')
GO
INSERT [dbo].[ACC0] ([CodInv], [OpPrefC], [OpBolsaC], [PrecioLimpioC], [FOperC], [FLiqC], [DiasTC], [GCapTotC], [GCapUnC], [RetAnBrC], [RetAnNetC], [UnC], [ValTransC], [MontoNetoC], [PrecSucioC], [FactDiv], [PrecioLimpioV], [FOperV], [FLiqV], [DiasTV], [GCapTotV], [GCapUnV], [RetAnBrV], [RetAnNetV], [UnV], [ValTransV], [MontoNetoV], [PrecSucioV], [IngresoBruto], [IngresoBrutoPend], [ImpSumC], [ComSumC], [ImpSumV], [ComSumV], [ISR], [ISRPend], [IngresoNeto], [IngresoNetoPend], [SumImpComCompra], [SumImpComVenta], [ComisionCompraCasa], [ComisionCompraBolsa], [ComisionVentaCasa], [ComisionVentaBolsa], [IOF], [Renta], [Tipo]) VALUES (N'INVACC00001', NULL, NULL, CAST(5.000000 AS Numeric(18, 6)), CAST(N'2011-02-25T00:00:00.000' AS DateTime), CAST(N'2011-02-25T00:00:00.000' AS DateTime), 0, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 2045, CAST(10225.000000 AS Numeric(18, 6)), CAST(10225.000000 AS Numeric(18, 6)), CAST(5.000000 AS Numeric(18, 6)), NULL, CAST(0.000000 AS Numeric(18, 6)), CAST(N'2019-06-26T00:00:00.000' AS DateTime), CAST(N'2019-06-26T00:00:00.000' AS DateTime), 3043, CAST(-10225.000000 AS Numeric(18, 6)), CAST(-5.000000 AS Numeric(18, 6)), CAST(-3.028500 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), 2045, CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), CAST(0.000000 AS Numeric(18, 6)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, N'Efectivo')
GO
ALTER TABLE [dbo].[ACC0] ADD  CONSTRAINT [DF__ACC0__PrecioLimp__7E6CC920]  DEFAULT ((0)) FOR [PrecioLimpioC]
GO
ALTER TABLE [dbo].[ACC0] ADD  CONSTRAINT [DF__ACC0__FOperC__7F60ED59]  DEFAULT (getdate()) FOR [FOperC]
GO
ALTER TABLE [dbo].[ACC0] ADD  CONSTRAINT [DF__ACC0__FLiqC__00551192]  DEFAULT (getdate()) FOR [FLiqC]
GO
ALTER TABLE [dbo].[ACC0] ADD  CONSTRAINT [DF__ACC0__UnC__014935CB]  DEFAULT ((0)) FOR [UnC]
GO
ALTER TABLE [dbo].[ACC0] ADD  CONSTRAINT [DF__ACC0__PrecioLimp__023D5A04]  DEFAULT ((0)) FOR [PrecioLimpioV]
GO
ALTER TABLE [dbo].[ACC0] ADD  CONSTRAINT [DF__ACC0__FOperV__03317E3D]  DEFAULT (getdate()) FOR [FOperV]
GO
ALTER TABLE [dbo].[ACC0] ADD  CONSTRAINT [DF__ACC0__FLiqV__0425A276]  DEFAULT (getdate()) FOR [FLiqV]
GO
ALTER TABLE [dbo].[ACC0] ADD  CONSTRAINT [DF__ACC0__UnV__0519C6AF]  DEFAULT ((0)) FOR [UnV]
GO