USE [master]
GO
/****** Object:  Database [SMSEngine]    Script Date: 2/6/2022 17:05:54 ******/
CREATE DATABASE [SMSEngine] ON  PRIMARY 
( NAME = N'SMSEngine', FILENAME = N'D:\z-BACKUP\MSSQL10 2008\SMSEngine.mdf' , SIZE = 13312KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'SMSEngine_log', FILENAME = N'D:\z-BACKUP\MSSQL10 2008\SMSEngine_log.ldf' , SIZE = 5184KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [SMSEngine] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [SMSEngine].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [SMSEngine] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [SMSEngine] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [SMSEngine] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [SMSEngine] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [SMSEngine] SET ARITHABORT OFF 
GO
ALTER DATABASE [SMSEngine] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [SMSEngine] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [SMSEngine] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [SMSEngine] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [SMSEngine] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [SMSEngine] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [SMSEngine] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [SMSEngine] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [SMSEngine] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [SMSEngine] SET  DISABLE_BROKER 
GO
ALTER DATABASE [SMSEngine] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [SMSEngine] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [SMSEngine] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [SMSEngine] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [SMSEngine] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [SMSEngine] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [SMSEngine] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [SMSEngine] SET RECOVERY SIMPLE 
GO
ALTER DATABASE [SMSEngine] SET  MULTI_USER 
GO
ALTER DATABASE [SMSEngine] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [SMSEngine] SET DB_CHAINING OFF 
GO
EXEC sys.sp_db_vardecimal_storage_format N'SMSEngine', N'ON'
GO
USE [SMSEngine]
GO
/****** Object:  Table [dbo].[config]    Script Date: 2/6/2022 17:05:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[config](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[ibarakisoft_email] [nvarchar](150) NULL,
	[ibarakisoft_celular] [nvarchar](50) NULL,
	[empresa] [nvarchar](250) NULL,
	[idcliente] [nvarchar](250) NULL,
	[licencia_clave] [nvarchar](50) NULL,
	[licencia_version] [nvarchar](50) NULL,
	[licencia_perpetua] [bit] NULL,
	[licencia_instalacion] [date] NULL,
	[licencia_vencimiento] [date] NULL,
	[soporte_vencimiento] [date] NULL,
	[soporte_clave] [nvarchar](250) NULL,
	[email_credito] [nvarchar](150) NULL,
	[email_smsrecibidos] [nvarchar](150) NULL,
	[email_reportes] [nvarchar](150) NULL,
	[email_notificar_licencia] [nvarchar](150) NULL,
	[celular_notificar_licencia] [nvarchar](50) NULL,
	[fecha] [datetime] NULL,
 CONSTRAINT [PK_config] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[EnviosProgramados]    Script Date: 2/6/2022 17:05:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[EnviosProgramados](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[descripcion] [nvarchar](150) NULL,
	[fecha] [datetime] NULL,
	[usuario] [nvarchar](50) NULL,
	[habilitado] [bit] NULL,
 CONSTRAINT [PK_EnviosProgramados] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[lista_numeros]    Script Date: 2/6/2022 17:05:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[lista_numeros](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[idlista] [int] NULL,
	[telefono] [nvarchar](50) NULL,
	[fecha] [datetime] NULL,
 CONSTRAINT [PK_lista_numeros] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[listas]    Script Date: 2/6/2022 17:05:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[listas](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[nombre] [nvarchar](250) NULL,
	[idusuario] [int] NULL,
	[fecha] [date] NULL,
	[tipo] [nvarchar](50) NULL,
 CONSTRAINT [PK_listas] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[logCargadeDatos]    Script Date: 2/6/2022 17:05:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[logCargadeDatos](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[fecha] [datetime] NULL,
	[tipo] [nvarchar](50) NULL,
	[mensajes] [int] NULL,
	[usuario] [nvarchar](50) NULL,
	[comentarios] [nvarchar](500) NULL,
	[fechaCuotas] [datetime] NULL,
	[tiporecordatorio] [int] NULL,
	[cuotas] [int] NULL,
 CONSTRAINT [PK_logCargasAutomaticas] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[messages]    Script Date: 2/6/2022 17:05:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[messages](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[referenceid] [nvarchar](50) NULL,
	[status] [nvarchar](20) NULL,
	[channel] [nvarchar](20) NULL,
	[sent] [datetime] NULL,
	[received] [datetime] NULL,
	[scheduled] [datetime] NULL,
	[lastupdate] [datetime] NULL,
	[sender] [nvarchar](20) NULL,
	[recepient] [nvarchar](20) NULL,
	[body] [nvarchar](320) NULL,
	[isalert] [bit] NULL,
	[result] [nvarchar](250) NULL,
	[type] [nvarchar](50) NULL,
	[idcarga] [int] NULL,
	[idenvio] [int] NULL,
	[priority] [smallint] NULL,
	[codigo] [bigint] NULL,
	[messagekey] [nvarchar](50) NULL,
	[queued] [datetime] NULL,
	[delivered] [datetime] NULL,
	[usuario] [nvarchar](50) NULL,
 CONSTRAINT [PK_messages] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[messagesIn]    Script Date: 2/6/2022 17:05:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[messagesIn](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[channel] [nvarchar](20) NULL,
	[lastupdated] [datetime] NULL,
	[type] [nvarchar](20) NULL,
	[sender] [nvarchar](20) NULL,
	[body] [nvarchar](320) NULL,
 CONSTRAINT [PK_messagesIn] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[parametros]    Script Date: 2/6/2022 17:05:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[parametros](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[parametro] [nvarchar](50) NULL,
	[valor] [nvarchar](50) NULL,
	[orden] [smallint] NULL,
	[habilitado] [bit] NULL,
 CONSTRAINT [PK_parametros] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[plantillas]    Script Date: 2/6/2022 17:05:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[plantillas](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[texto] [nvarchar](max) NULL,
	[fecha] [datetime] NULL,
	[tipo] [nvarchar](50) NULL,
	[idusuario] [int] NULL,
 CONSTRAINT [PK_plantillas] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SMS_limpio]    Script Date: 2/6/2022 17:05:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SMS_limpio](
	[telefono] [varchar](50) NULL,
	[mensaje] [varchar](50) NULL,
	[fechaenvio] [varchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[tarjetasCargadas]    Script Date: 2/6/2022 17:05:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tarjetasCargadas](
	[id] [int] NOT NULL,
	[fecha] [datetime] NULL,
	[credito] [decimal](18, 0) NULL,
	[costo] [decimal](18, 0) NULL,
	[idultimomensaje] [int] NULL,
 CONSTRAINT [PK_tarjetasCargadas] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[temp_messages]    Script Date: 2/6/2022 17:05:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[temp_messages](
	[referenceid] [nvarchar](50) NULL,
	[status] [nvarchar](20) NULL,
	[channel] [nvarchar](20) NULL,
	[sent] [datetime] NULL,
	[received] [datetime] NULL,
	[scheduled] [datetime] NULL,
	[lastupdate] [datetime] NULL,
	[sender] [nvarchar](20) NULL,
	[recepient] [nvarchar](20) NULL,
	[body] [nvarchar](320) NULL,
	[isalert] [bit] NULL,
	[result] [nvarchar](250) NULL,
	[type] [nvarchar](50) NULL,
	[idcarga] [int] NULL,
	[idenvio] [int] NULL,
	[priority] [smallint] NULL,
	[codigo] [bigint] NULL,
	[messagekey] [nvarchar](50) NULL,
	[queued] [datetime] NULL,
	[delivered] [datetime] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[usuarios]    Script Date: 2/6/2022 17:05:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[usuarios](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[nombre] [nvarchar](250) NULL,
	[registrado] [datetime] NULL,
	[habilitado] [bit] NULL,
	[usuario] [nvarchar](50) NULL,
	[password] [nvarchar](50) NULL,
	[modulos] [nvarchar](250) NULL,
 CONSTRAINT [PK_usuarios] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[config] ON 

INSERT [dbo].[config] ([id], [ibarakisoft_email], [ibarakisoft_celular], [empresa], [idcliente], [licencia_clave], [licencia_version], [licencia_perpetua], [licencia_instalacion], [licencia_vencimiento], [soporte_vencimiento], [soporte_clave], [email_credito], [email_smsrecibidos], [email_reportes], [email_notificar_licencia], [celular_notificar_licencia], [fecha]) VALUES (1, N'soporte@ibarakisoft.com', N'70000288', N'COOP FATIMA', NULL, NULL, N'EMPRESARIAL', 0, NULL, CAST(N'2022-04-01' AS Date), CAST(N'2022-04-01' AS Date), NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2022-05-11T15:46:30.033' AS DateTime))
SET IDENTITY_INSERT [dbo].[config] OFF
GO
SET IDENTITY_INSERT [dbo].[logCargadeDatos] ON 

INSERT [dbo].[logCargadeDatos] ([id], [fecha], [tipo], [mensajes], [usuario], [comentarios], [fechaCuotas], [tiporecordatorio], [cuotas]) VALUES (1, CAST(N'2022-05-12T13:36:49.027' AS DateTime), N'CARGA EXCEL', 29, N'1', N'Encontrados:30, Mensajes generados:29, Errores:1', NULL, NULL, NULL)
INSERT [dbo].[logCargadeDatos] ([id], [fecha], [tipo], [mensajes], [usuario], [comentarios], [fechaCuotas], [tiporecordatorio], [cuotas]) VALUES (2, CAST(N'2022-05-12T13:44:30.893' AS DateTime), N'CARGA EXCEL', 0, N'1', N'Encontrados:30, Mensajes generados:0, Errores:1', NULL, NULL, NULL)
INSERT [dbo].[logCargadeDatos] ([id], [fecha], [tipo], [mensajes], [usuario], [comentarios], [fechaCuotas], [tiporecordatorio], [cuotas]) VALUES (3, CAST(N'2022-05-12T13:49:29.123' AS DateTime), N'CARGA EXCEL', 0, N'1', N'Encontrados:30, Mensajes generados:0, Errores:1', NULL, NULL, NULL)
INSERT [dbo].[logCargadeDatos] ([id], [fecha], [tipo], [mensajes], [usuario], [comentarios], [fechaCuotas], [tiporecordatorio], [cuotas]) VALUES (4, CAST(N'2022-05-12T13:54:11.813' AS DateTime), N'CARGA EXCEL', 29, N'1', N'Encontrados:30, Mensajes cargados:28, Errores:1', NULL, NULL, NULL)
INSERT [dbo].[logCargadeDatos] ([id], [fecha], [tipo], [mensajes], [usuario], [comentarios], [fechaCuotas], [tiporecordatorio], [cuotas]) VALUES (5, CAST(N'2022-05-16T14:50:29.790' AS DateTime), N'CARGA EXCEL', 5, N'1', N'Encontrados:6, Mensajes cargados:5, Errores:1', NULL, NULL, NULL)
INSERT [dbo].[logCargadeDatos] ([id], [fecha], [tipo], [mensajes], [usuario], [comentarios], [fechaCuotas], [tiporecordatorio], [cuotas]) VALUES (6, CAST(N'2022-05-16T20:40:51.070' AS DateTime), N'CARGA EXCEL', 4, N'1', N'Encontrados:4, Mensajes cargados:4, Errores:0', NULL, NULL, NULL)
INSERT [dbo].[logCargadeDatos] ([id], [fecha], [tipo], [mensajes], [usuario], [comentarios], [fechaCuotas], [tiporecordatorio], [cuotas]) VALUES (7, CAST(N'2022-05-16T22:01:08.093' AS DateTime), N'CARGA EXCEL', 28, N'1', N'Encontrados:28, Mensajes cargados:28, Errores:0', NULL, NULL, NULL)
INSERT [dbo].[logCargadeDatos] ([id], [fecha], [tipo], [mensajes], [usuario], [comentarios], [fechaCuotas], [tiporecordatorio], [cuotas]) VALUES (8, CAST(N'2022-05-16T22:09:57.260' AS DateTime), N'CARGA EXCEL', 8, N'1', N'Encontrados:8, Mensajes cargados:8, Errores:0', NULL, NULL, NULL)
INSERT [dbo].[logCargadeDatos] ([id], [fecha], [tipo], [mensajes], [usuario], [comentarios], [fechaCuotas], [tiporecordatorio], [cuotas]) VALUES (9, CAST(N'2022-05-16T22:16:54.500' AS DateTime), N'CARGA EXCEL', 4, N'1', N'Encontrados:4, Mensajes cargados:4, Errores:0', NULL, NULL, NULL)
INSERT [dbo].[logCargadeDatos] ([id], [fecha], [tipo], [mensajes], [usuario], [comentarios], [fechaCuotas], [tiporecordatorio], [cuotas]) VALUES (10, CAST(N'2022-05-16T22:25:05.870' AS DateTime), N'CARGA EXCEL', 1, N'1', N'Encontrados:1, Mensajes cargados:1, Errores:0', NULL, NULL, NULL)
INSERT [dbo].[logCargadeDatos] ([id], [fecha], [tipo], [mensajes], [usuario], [comentarios], [fechaCuotas], [tiporecordatorio], [cuotas]) VALUES (11, CAST(N'2022-05-17T19:17:46.960' AS DateTime), N'CARGA EXCEL', 40, N'1', N'Encontrados:40, Mensajes cargados:40, Errores:0', NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[logCargadeDatos] OFF
GO
SET IDENTITY_INSERT [dbo].[messages] ON 

INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (1, N'7B725DF5223B3CAA826321205D74BB1A', N'ENVIADO', NULL, CAST(N'2022-05-12T14:03:42.140' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000289', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (2, N'3E1202A67E9570FF212D756E23E0AD85', N'ENVIADO', NULL, CAST(N'2022-05-12T14:04:17.230' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000290', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (3, N'33704B49E95ABDC1DA3A455A436AB009', N'ENVIADO', NULL, CAST(N'2022-05-12T14:04:24.090' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000291', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (4, N'7AA27539F5F95527994C9B5C1A2BFD5E', N'ENVIADO', NULL, CAST(N'2022-05-12T14:04:38.107' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000292', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (5, N'9DD4B5601BA524808E463492883D78B9', N'ENVIADO', NULL, CAST(N'2022-05-12T14:04:44.253' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000293', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (6, N'CD7BD1AE638D25B30B2BFEDD4530D6E1', N'ENVIADO', NULL, CAST(N'2022-05-12T14:04:51.093' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000294', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (7, N'16C11E83B954F456C8F7DA665B14DA8A', N'ENVIADO', NULL, CAST(N'2022-05-12T14:04:57.940' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000295', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (8, N'751501C2E250D30E31758061DD24415D', N'ENVIADO', NULL, CAST(N'2022-05-12T14:05:04.787' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000296', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (9, N'9C1E2B11A5D9E45331E8C5BF3EFB2A57', N'ENVIADO', NULL, CAST(N'2022-05-12T14:05:11.633' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000297', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (10, N'02F03AB43F8285F756BD1EFA328B8473', N'ENVIADO', NULL, CAST(N'2022-05-12T14:05:20.440' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000298', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (11, N'03D8193EB15DD340D36AEDB5F47E7E97', N'ENVIADO', NULL, CAST(N'2022-05-12T14:05:26.577' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000299', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (12, N'C5F0FCA216BF794D02C309D1738DADB7', N'ENVIADO', NULL, CAST(N'2022-05-12T14:05:32.723' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000300', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (13, N'B8B82C4A8DD87E30FDB5CE878FEF6E02', N'ENVIADO', NULL, CAST(N'2022-05-12T14:05:38.860' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000301', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (14, N'EE73FEE5E82D9348B9B39B318EFBE753', N'ENVIADO', NULL, CAST(N'2022-05-12T14:05:47.357' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000302', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (15, N'6C0D229E1451361066ADAD6D17C37891', N'ENVIADO', NULL, CAST(N'2022-05-12T14:05:53.953' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000303', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (16, N'9EEDCA0659C99365FD1AD087308935E0', N'ENVIADO', NULL, CAST(N'2022-05-12T14:06:00.800' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000304', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (17, N'83DA26A3323D84DFCE6D408845E59AC4', N'ENVIADO', NULL, CAST(N'2022-05-12T14:06:07.650' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000305', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (18, N'A46AE27EF9FF9F6A48E4EACEBAFF9AC8', N'ENVIADO', NULL, CAST(N'2022-05-12T14:06:13.880' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000306', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (19, N'1E94AA86A3F1070F52BBDEF4410D6553', N'ENVIADO', NULL, CAST(N'2022-05-12T14:06:19.793' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000307', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (20, N'D6BAF4EDBB4648DEF55E351C7BB2E66E', N'ENVIADO', NULL, CAST(N'2022-05-12T14:06:28.530' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000308', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (21, N'5B9A27245E1DB1F7E217C915FDC7ECE0', N'ENVIADO', NULL, CAST(N'2022-05-12T14:06:35.373' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000309', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (22, N'5B956EFAAEF57924DE14407845D66AD9', N'ENVIADO', NULL, CAST(N'2022-05-12T14:06:42.217' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000310', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (23, N'591C69CE8E106486681968BFADC049DD', N'ENVIADO', NULL, CAST(N'2022-05-12T14:06:49.997' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000311', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (24, N'8D2A8B966B4628F4CECA2A31A2919875', N'ENVIADO', NULL, CAST(N'2022-05-12T14:06:56.843' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000312', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (25, N'CCDBCE289F5E7ECE6789D0F005F3DAB2', N'ENVIADO', NULL, CAST(N'2022-05-12T14:07:03.083' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000313', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (26, N'CC6F77A561BCBB5F6FE0AA20A803C19D', N'ENVIADO', NULL, CAST(N'2022-05-12T14:07:09.230' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000314', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (27, N'9459F20553DAE26868386B6A35696D10', N'ENVIADO', NULL, CAST(N'2022-05-12T14:07:17.503' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000315', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (28, N'097B8B970DA8EE6E57B23D1795027CD2', N'ENVIADO', NULL, CAST(N'2022-05-12T14:07:24.383' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000316', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (29, N'5659BE976F5CC14DBEFA86E0EF9BB35D', N'ENVIADO', NULL, CAST(N'2022-05-12T14:07:30.610' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000317', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 1, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (30, N'3DDA8F0915A6C7EA99E7D13AFFD2A679', N'ENVIADO', NULL, CAST(N'2022-05-12T14:19:30.480' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000289', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (31, N'C3FBF7EFAEF66B232EB9F089050B7651', N'ENVIADO', NULL, CAST(N'2022-05-12T14:20:01.987' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000290', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (32, N'6FFF3BE7045394C5EECE6E6B4782EA54', N'ENVIADO', NULL, CAST(N'2022-05-12T14:20:08.850' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000291', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (33, N'7CFD3BA2C0170CDDAEDD9CB2317A988D', N'ENVIADO', NULL, CAST(N'2022-05-12T14:20:15.703' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000292', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (34, N'EF6F0B6068ADD05EEE74F8A31E3E6629', N'ENVIADO', NULL, CAST(N'2022-05-12T14:20:22.313' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000293', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (35, N'0872D5A7DAEA1BD985CD5587F8E041E4', N'ENVIADO', NULL, CAST(N'2022-05-12T14:20:28.550' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000294', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (36, N'6A13D3605033ADCB340278D434FA00A6', N'ENVIADO', NULL, CAST(N'2022-05-12T14:20:36.797' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000295', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (37, N'2B27606490DA2C0C0AD00BCE21B5307B', N'ENVIADO', NULL, CAST(N'2022-05-12T14:20:42.953' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000296', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (38, N'519B6D290F357E249C78EFA0A6F77640', N'ENVIADO', NULL, CAST(N'2022-05-12T14:20:49.800' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000297', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (39, N'326A5B00A0F31244B606F7BB813854BC', N'ENVIADO', NULL, CAST(N'2022-05-12T14:20:56.650' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000298', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (40, N'2C23D5C40F5F71E982F45CFC7A75B3E5', N'ENVIADO', NULL, CAST(N'2022-05-12T14:21:03.487' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000299', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (41, N'F4FBAE0EE6C3F6CFC2F2B6AB316266F2', N'ENVIADO', NULL, CAST(N'2022-05-12T14:21:12.450' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000300', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (42, N'648394C7DDCCFAECCC34E9CB21A63792', N'ENVIADO', NULL, CAST(N'2022-05-12T14:21:18.703' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000301', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (43, N'86031963C47C2CA058CF86D2CB2E3EBE', N'ENVIADO', NULL, CAST(N'2022-05-12T14:21:25.330' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000302', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (44, N'6D3E9EAEB242F17859C8D0D153BD76EB', N'ENVIADO', NULL, CAST(N'2022-05-12T14:21:32.167' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000303', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (45, N'B03BD03F0E723B6EBA167D99485CDFF2', N'ENVIADO', NULL, CAST(N'2022-05-12T14:21:39.977' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000304', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (46, N'68F976DBE9ECF968D04AEE193EDDEFE7', N'ENVIADO', NULL, CAST(N'2022-05-12T14:21:46.823' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000305', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (47, N'59B5B836C1F7DC18393444E6A563F404', N'ENVIADO', NULL, CAST(N'2022-05-12T14:21:53.047' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000306', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (48, N'893C19BE2DB7EE9BD14392D4903A2C34', N'ENVIADO', NULL, CAST(N'2022-05-12T14:21:57.990' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000307', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (49, N'F051AAA245F389A2BC2A4792F7FB7C21', N'ENVIADO', NULL, CAST(N'2022-05-12T14:22:06.497' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000308', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (50, N'C52EAE6A714A027DE5208B53688DEC9B', N'ENVIADO', NULL, CAST(N'2022-05-12T14:22:12.640' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000309', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (51, N'749460382379E8AFBDE11576D0153D9D', N'ENVIADO', NULL, CAST(N'2022-05-12T14:22:19.487' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000310', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (52, N'DC96DA09BF9A527DDEC04F44E0B2DA09', N'ENVIADO', NULL, CAST(N'2022-05-12T14:22:26.320' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000311', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (53, N'B12B4E13873333FB50145E32BBFFEF09', N'ENVIADO', NULL, CAST(N'2022-05-12T14:22:34.587' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000312', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (54, N'491B427E94E1A147D9828346C5D4D4DA', N'ENVIADO', NULL, CAST(N'2022-05-12T14:22:40.600' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000313', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (55, N'80C7558410825DA16712A2D60B4D939B', N'ENVIADO', NULL, CAST(N'2022-05-12T14:22:46.730' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000314', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (56, N'9866BC1F9007F5D8A84D780584E7410E', N'ENVIADO', NULL, CAST(N'2022-05-12T14:22:53.110' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000315', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (57, N'677BB8B879785F2322E3271076CC8421', N'ENVIADO', NULL, CAST(N'2022-05-12T14:22:59.003' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000316', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (58, N'904DEE8A5558A1022A222C7473C5775E', N'ENVIADO', NULL, CAST(N'2022-05-12T14:23:08.467' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-12T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'70000317', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 4, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (59, N'2BFD1E17BB64111D187C38606260C26C', N'ENVIADO', NULL, CAST(N'2022-05-16T14:50:44.423' AS DateTime), CAST(N'2022-05-17T19:19:09.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:19:09.683' AS DateTime), NULL, N'72189594', N'Motoclub Embarrados comunica que tenes 5 cuotas pendientes equivalente a 500 bs y vencen este 17-5-2022 esperamos tu contacto. Atte La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:19:09', N'CARGA EXCEL', 5, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (60, N'21AA1696BA49EE39EC9EB24402B50961', N'ENVIADO', NULL, CAST(N'2022-05-16T14:50:48.773' AS DateTime), CAST(N'2022-05-17T19:18:46.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:18:51.090' AS DateTime), NULL, N'77095975', N'Motoclub Embarrados comunica que tenes 5 cuotas pendientes equivalente a 500 bs y vencen este 17-5-2022 esperamos tu contacto. Atte La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:18:46', N'CARGA EXCEL', 5, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (61, N'EFFDC8DFD904BC806F9C91A38F714A08', N'ENVIADO', NULL, CAST(N'2022-05-16T14:50:53.080' AS DateTime), CAST(N'2022-05-16T14:51:02.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-16T14:51:11.340' AS DateTime), NULL, N'60852722', N'Motoclub Embarrados comunica que tenes 5 cuotas pendientes equivalente a 500 bs y vencen este 17-5-2022 esperamos tu contacto. Atte La Directiva', NULL, N'ENTREGADO: 16/5/2022 14:51:02', N'CARGA EXCEL', 5, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (62, N'8E4E1B86DE95A3AEA85DBF771EF679F7', N'ENVIADO', NULL, CAST(N'2022-05-16T14:51:05.760' AS DateTime), CAST(N'2022-05-17T19:19:58.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:09.420' AS DateTime), NULL, N'72150961', N'Motoclub Embarrados comunica que tenes 5 cuotas pendientes equivalente a 500 bs y vencen este 17-5-2022 esperamos tu contacto. Atte La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:19:58', N'CARGA EXCEL', 5, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (63, N'DF3B735B4C72677EF7A565EB5599640F', N'ENVIADO', NULL, CAST(N'2022-05-16T14:51:09.990' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'Motoclub Embarrados comunica que tenes 5 cuotas pendientes equivalente a 500 bs y vencen este 17-5-2022 esperamos tu contacto. Atte La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 5, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (64, N'4A294B5D6BA3E33A0FEB2029CE24F11F', N'ENVIANDO', NULL, NULL, CAST(N'2022-05-17T19:18:46.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:18:51.090' AS DateTime), NULL, N'77095975', N'David Motoclub Embarrados comunica tu deuda en aportes es 0 bs, saldo para prox cuota 300 bs. La fecha de vecimiento es 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:18:46', N'CARGA EXCEL', 6, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (65, N'5651D387A6966C4A7665F23E2CADDEF0', N'ENVIADO', NULL, CAST(N'2022-05-16T22:12:39.537' AS DateTime), CAST(N'2022-05-17T19:19:09.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:19:09.683' AS DateTime), NULL, N'72189594', N'Erwin Motoclub Embarrados comunica tu deuda en aportes es 0 bs, saldo para prox cuota 500 bs. La fecha de vecimiento es 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:19:09', N'CARGA EXCEL', 6, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (66, N'2826C402E7F2A31B509252E347559AB7', N'ENVIADO', NULL, CAST(N'2022-05-16T22:12:47.337' AS DateTime), CAST(N'2022-05-17T19:19:58.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:09.420' AS DateTime), NULL, N'72150961', N'J Rodrigo Motoclub Embarrados comunica tu deuda en aportes es 0 bs, saldo para prox cuota 500 bs. La fecha de vecimiento es 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:19:58', N'CARGA EXCEL', 6, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (67, N'AEF42539BEBAA7820351F4251CD46E72', N'ENVIADO', NULL, CAST(N'2022-05-16T22:12:55.357' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'Rodrigo I Motoclub Embarrados comunica tu deuda en aportes es 0 bs, saldo para prox cuota 0 bs. La fecha de vecimiento es 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 6, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (68, N'D2227E2BA8DA8B20EBC3F0C078D5146A', N'ENVIADO', NULL, CAST(N'2022-05-16T22:13:03.370' AS DateTime), CAST(N'2022-05-17T19:18:28.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:18:48.780' AS DateTime), NULL, N'76338922', N'Roger  MotoclubEmbarrados comunica tu deuda en aportes es 500 bs, saldo a favor para prox cuotas 50 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:18:28', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (69, N'D95CF52415C55E297FC646DC24B87D1F', N'ENVIADO', NULL, CAST(N'2022-05-16T22:13:13.277' AS DateTime), CAST(N'2022-05-17T19:18:34.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:18:49.353' AS DateTime), NULL, N'61557932', N'Aroldo MotoclubEmbarrados comunica tu deuda en aportes es 0 bs, saldo a favor para prox cuotas 550 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:18:34', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (70, N'239342382E2A90D9F0D850F4A9A08B2A', N'ENVIADO', NULL, CAST(N'2022-05-16T22:13:21.303' AS DateTime), CAST(N'2022-05-17T19:18:37.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:18:49.930' AS DateTime), NULL, N'68920000', N'Carlos MotoclubEmbarrados comunica tu deuda en aportes es 0 bs, saldo a favor para prox cuotas 50 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:18:37', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (71, N'E1625B46B3356ABF7A071AC30B265275', N'ENVIADO', NULL, CAST(N'2022-05-16T22:13:29.173' AS DateTime), CAST(N'2022-05-17T19:18:42.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:18:50.510' AS DateTime), NULL, N'77199860', N'Mauricio MotoclubEmbarrados comunica tu deuda en aportes es 0 bs, saldo a favor para prox cuotas 500 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:18:42', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (72, N'08468B9172C49A17816A63DBDAC6304F', N'ENVIADO', NULL, CAST(N'2022-05-16T22:13:36.497' AS DateTime), CAST(N'2022-05-17T19:18:46.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:18:51.090' AS DateTime), NULL, N'77095975', N'David MotoclubEmbarrados comunica tu deuda en aportes es 0 bs, saldo a favor para prox cuotas 300 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:18:46', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (73, N'2CDBDDD27FB788AAE782B24E1B559DAA', N'ENVIADO', NULL, CAST(N'2022-05-16T22:13:45.450' AS DateTime), CAST(N'2022-05-17T19:18:52.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:18:51.670' AS DateTime), NULL, N'70906640', N'Diego A MotoclubEmbarrados comunica tu deuda en aportes es 0 bs, saldo a favor para prox cuotas 150 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:18:52', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (74, N'91E6A8DFAB7DBB09312170E59C5A5F68', N'ENVIADO', NULL, CAST(N'2022-05-16T22:13:53.020' AS DateTime), CAST(N'2022-05-17T19:18:56.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:18:52.250' AS DateTime), NULL, N'78192692', N'Dorian MotoclubEmbarrados comunica tu deuda en aportes es 0 bs, saldo a favor para prox cuotas 500 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:18:56', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (75, N'FBA93AF8C6AD8FCAE821CF418B6AC8A9', N'ENVIADO', NULL, CAST(N'2022-05-16T22:14:00.827' AS DateTime), CAST(N'2022-05-17T19:19:05.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:19:09.010' AS DateTime), NULL, N'75371046', N'Erick MotoclubEmbarrados comunica tu deuda en aportes es 0 bs, saldo a favor para prox cuotas 300 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:19:05', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (76, N'21E8772D7CB3BE466742A81412DD805B', N'ENVIADO', NULL, CAST(N'2022-05-16T22:14:08.807' AS DateTime), CAST(N'2022-05-17T19:19:09.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:19:09.683' AS DateTime), NULL, N'72189594', N'Erwin MotoclubEmbarrados comunica tu deuda en aportes es 0 bs, saldo a favor para prox cuotas 500 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:19:09', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (77, N'75F26BD3AA23C79123D2F30FE0A10D07', N'ENVIADO', NULL, CAST(N'2022-05-16T22:14:18.243' AS DateTime), CAST(N'2022-05-17T19:19:14.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:19:10.310' AS DateTime), NULL, N'72879442', N'Herberth MotoclubEmbarrados comunica tu deuda en aportes es 0 bs, saldo a favor para prox cuotas 600 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:19:14', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (78, N'86BDA634C5F27F855098DB2A19C053C7', N'ENVIADO', NULL, CAST(N'2022-05-16T22:14:26.260' AS DateTime), CAST(N'2022-05-17T19:19:24.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:19:39.007' AS DateTime), NULL, N'70999011', N'Herland MotoclubEmbarrados comunica tu deuda en aportes es 0 bs, saldo a favor para prox cuotas 500 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:19:24', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (79, N'8C6DC9B46DA5A4BA08B5A43901302EE2', N'ENVIADO', NULL, CAST(N'2022-05-16T22:14:33.903' AS DateTime), CAST(N'2022-05-17T19:19:58.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:09.420' AS DateTime), NULL, N'72150961', N'J Rodrigo MotoclubEmbarrados comunica tu deuda en aportes es 0 bs, saldo a favor para prox cuotas 500 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:19:58', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (80, N'9A2389C48E885803F3AF3C469EA7FD9D', N'ENVIADO', NULL, CAST(N'2022-05-16T22:14:42.400' AS DateTime), CAST(N'2022-05-17T19:20:03.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:10.007' AS DateTime), NULL, N'78520886', N'Landy MotoclubEmbarrados comunica tu deuda en aportes es 0 bs, saldo a favor para prox cuotas 300 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:20:03', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (81, N'FABF9C050E5F990A9FB71191AB3EA839', N'ENVIADO', NULL, CAST(N'2022-05-16T22:14:49.960' AS DateTime), CAST(N'2022-05-17T19:20:07.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:10.587' AS DateTime), NULL, N'70095592', N'Fernando MotoclubEmbarrados comunica tu deuda en aportes es 0 bs, saldo a favor para prox cuotas 500 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:20:07', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (82, N'F3EEE6E48BDA239F45E2BDF66826B0E9', N'ENVIADO', NULL, CAST(N'2022-05-16T22:14:57.500' AS DateTime), CAST(N'2022-05-17T19:20:12.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:11.163' AS DateTime), NULL, N'75025341', N'Juan P MotoclubEmbarrados comunica tu deuda en aportes es 0 bs, saldo a favor para prox cuotas 600 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:20:12', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (83, N'306E43D1B61916AFCC8EC757039936D5', N'ENVIADO', NULL, CAST(N'2022-05-16T22:15:05.290' AS DateTime), CAST(N'2022-05-17T19:21:26.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:21:41.320' AS DateTime), NULL, N'75350665', N'L Alfredo MotoclubEmbarrados comunica tu deuda en aportes es 0 bs, saldo a favor para prox cuotas 500 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:21:26', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (84, N'D9F9A4590BFF2138138CD06F8D592C2C', N'ENVIADO', NULL, CAST(N'2022-05-16T22:15:14.947' AS DateTime), CAST(N'2022-05-17T19:20:25.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:50.560' AS DateTime), NULL, N'78030471', N'Luis E  MotoclubEmbarrados comunica tu deuda en aportes es 0 bs, saldo a favor para prox cuotas 400 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:20:25', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (85, N'67AC50BC2BEE7BA4417AD9E3B3B55B7B', N'ENVIADO', NULL, CAST(N'2022-05-16T22:15:22.730' AS DateTime), CAST(N'2022-05-17T19:20:30.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:51.133' AS DateTime), NULL, N'75354642', N'Marco B MotoclubEmbarrados comunica tu deuda en aportes es 0 bs, saldo a favor para prox cuotas 0 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:20:30', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (86, N'50FFA3D7DD95D1E36A3656EB98214E58', N'ENVIADO', NULL, CAST(N'2022-05-16T22:15:30.523' AS DateTime), CAST(N'2022-05-17T19:20:34.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:51.710' AS DateTime), NULL, N'76314567', N'Marco R MotoclubEmbarrados comunica tu deuda en aportes es 0 bs, saldo a favor para prox cuotas 300 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:20:34', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (87, N'CFDF295A3983ADC3E5F246EE426CC576', N'ENVIADO', NULL, CAST(N'2022-05-16T22:15:38.163' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'Rodrigo I MotoclubEmbarrados comunica tu deuda en aportes es 0 bs, saldo a favor para prox cuotas 0 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (88, N'1619BA9F816729699A3A53EB40A775D1', N'ENVIADO', NULL, CAST(N'2022-05-16T22:15:46.650' AS DateTime), CAST(N'2022-05-17T19:20:44.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.867' AS DateTime), NULL, N'75000089', N'Rodrigo V MotoclubEmbarrados comunica tu deuda en aportes es 0 bs, saldo a favor para prox cuotas 500 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:20:44', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (89, N'77EAB9880103A4FA193BA99F2CF09EA6', N'ENVIADO', NULL, CAST(N'2022-05-16T22:15:54.230' AS DateTime), CAST(N'2022-05-17T19:20:48.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:53.443' AS DateTime), NULL, N'76005633', N'Luis F MotoclubEmbarrados comunica tu deuda en aportes es -200 bs, saldo a favor para prox cuotas 0 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:20:48', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (90, N'951996C93DE811C43D9CFC8BFE879DC0', N'ENVIADO', NULL, CAST(N'2022-05-16T22:16:02.007' AS DateTime), CAST(N'2022-05-17T19:20:53.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:54.020' AS DateTime), NULL, N'72673600', N'Roy MotoclubEmbarrados comunica tu deuda en aportes es -200 bs, saldo a favor para prox cuotas 0 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:20:53', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (91, N'93C6F313530E76A6424747FC886822C1', N'ENVIADO', NULL, CAST(N'2022-05-16T22:16:10.503' AS DateTime), CAST(N'2022-05-17T19:20:58.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:54.597' AS DateTime), NULL, N'77086361', N'Wilman  MotoclubEmbarrados comunica tu deuda en aportes es -200 bs, saldo a favor para prox cuotas 0 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:20:58', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (92, N'83F078BD4285F2CEB07F2D664BEBF968', N'ENVIADO', NULL, CAST(N'2022-05-16T22:16:20.307' AS DateTime), CAST(N'2022-05-17T19:21:07.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:21:09.340' AS DateTime), NULL, N'77025639', N'Roberto J MotoclubEmbarrados comunica tu deuda en aportes es -200 bs, saldo a favor para prox cuotas 0 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:21:07', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (93, N'AFD41F33DC8E8FEBCC89F72AE830A1F7', N'ENVIADO', NULL, CAST(N'2022-05-16T22:16:27.847' AS DateTime), CAST(N'2022-05-17T19:21:12.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:21:09.920' AS DateTime), NULL, N'67701069', N'Alexis MotoclubEmbarrados comunica tu deuda en aportes es -400 bs, saldo a favor para prox cuotas 0 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:21:12', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (94, N'E79ED8B7132FF48EA33D4B6A2E102B7F', N'ENVIADO', NULL, CAST(N'2022-05-16T22:16:35.630' AS DateTime), CAST(N'2022-05-17T19:21:26.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:21:41.320' AS DateTime), NULL, N'75350665', N'Alfredo MotoclubEmbarrados comunica tu deuda en aportes es -400 bs, saldo a favor para prox cuotas 0 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:21:26', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (95, N'E2765D60F8462B6ED04EB5A50C15AD24', N'ENVIADO', NULL, CAST(N'2022-05-16T22:16:44.130' AS DateTime), CAST(N'2022-05-17T19:21:30.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:21:41.890' AS DateTime), NULL, N'78146001', N' Toledo MotoclubEmbarrados comunica tu deuda en aportes es -500 bs, saldo a favor para prox cuotas 0 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:21:30', N'CARGA EXCEL', 7, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (96, N'F92FAAC7D6A41701BABBCEAACFB9C644', N'ENVIADO', NULL, CAST(N'2022-05-16T22:16:52.153' AS DateTime), CAST(N'2022-05-17T19:21:35.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:21:42.467' AS DateTime), NULL, N'75333342', N'Alberto MotoclubEmbarrados comunica tu deuda en aportes es -900 bs, con el perdonazo estaras al dia con un pago de 700 bs Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:21:35', N'CARGA EXCEL', 8, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (97, N'37095CF424648715C3C42CB8328A5098', N'ENVIADO', NULL, CAST(N'2022-05-16T22:16:58.973' AS DateTime), CAST(N'2022-05-17T19:21:40.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:21:43.047' AS DateTime), NULL, N'76018777', N'Liders MotoclubEmbarrados comunica tu deuda en aportes es -900 bs, con el perdonazo estaras al dia con un pago de 700 bs Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:21:40', N'CARGA EXCEL', 8, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (98, N'D89B2D618D049E24A83C9961A8E78685', N'ENVIADO', NULL, CAST(N'2022-05-16T22:17:07.020' AS DateTime), CAST(N'2022-05-17T19:21:44.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:21:43.620' AS DateTime), NULL, N'65035588', N'Jorge F MotoclubEmbarrados comunica tu deuda en aportes es -1000 bs, con el perdonazo estaras al dia con un pago de 700 bs Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:21:44', N'CARGA EXCEL', 8, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (99, N'0924F91EB01F9520F0AD6ADD4C935C8D', N'ENVIADO', NULL, CAST(N'2022-05-16T22:17:16.690' AS DateTime), CAST(N'2022-05-17T19:21:49.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:21:44.203' AS DateTime), NULL, N'75377351', N'David L MotoclubEmbarrados comunica tu deuda en aportes es -1100 bs, con el perdonazo estaras al dia con un pago de 700 bs Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:21:49', N'CARGA EXCEL', 8, NULL, 2, NULL, NULL, NULL, NULL, N'1')
GO
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (100, N'0254BBC41F6DFC147F952FD95F072D6A', N'ENVIADO', NULL, CAST(N'2022-05-16T22:17:24.800' AS DateTime), CAST(N'2022-05-17T19:22:21.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:22:30.290' AS DateTime), NULL, N'74675592', N'Antonio MotoclubEmbarrados comunica tu deuda en aportes es -1500 bs, con el perdonazo estaras al dia con un pago de 700 bs Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:22:21', N'CARGA EXCEL', 8, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (101, N'FA49B3940CD78B3DAE5C6EC0847DA397', N'ENVIADO', NULL, CAST(N'2022-05-16T22:17:32.810' AS DateTime), CAST(N'2022-05-16T22:17:40.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-16T22:17:43.607' AS DateTime), NULL, N'69261654', N'Antonio MotoclubEmbarrados comunica tu deuda en aportes es -1700 bs, con el perdonazo estaras al dia con un pago de 700 bs Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 16/5/2022 22:17:40', N'CARGA EXCEL', 8, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (102, N'B5F2C9F9143A8146F5F64F35BF63C498', N'ENVIADO', NULL, CAST(N'2022-05-16T22:17:40.843' AS DateTime), CAST(N'2022-05-17T19:22:37.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:22:31.463' AS DateTime), NULL, N'77824313', N'Jose E MotoclubEmbarrados comunica tu deuda en aportes es -1700 bs, con el perdonazo estaras al dia con un pago de 700 bs Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:22:37', N'CARGA EXCEL', 8, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (103, N'D9A1C6CD550ABE97540917E45048BE20', N'ENVIADO', NULL, CAST(N'2022-05-16T22:17:50.513' AS DateTime), CAST(N'2022-05-17T19:22:46.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:23:08.980' AS DateTime), NULL, N'78494539', N'Diego MotoclubEmbarrados comunica tu deuda en aportes es -1900 bs, con el perdonazo estaras al dia con un pago de 700 bs Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:22:46', N'CARGA EXCEL', 8, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (104, N'D2DFD0A57655B1CA63EF21F8580F1C12', N'ENVIADO', NULL, CAST(N'2022-05-16T22:17:58.757' AS DateTime), CAST(N'2022-05-17T19:22:55.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:23:09.550' AS DateTime), NULL, N'71860728', N'Guillermo  MotoclubEmbarrados comunica tu deuda en aportes es 0 bs, saldo a favor para prox cuotas 50 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:22:55', N'CARGA EXCEL', 9, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (105, N'11048C635DB67E5A5D570E820997F8D6', N'ENVIADO', NULL, CAST(N'2022-05-16T22:18:07.030' AS DateTime), CAST(N'2022-05-17T19:23:01.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:23:10.133' AS DateTime), NULL, N'68881646', N'Nicolas MotoclubEmbarrados comunica tu deuda en aportes es 700 bs, saldo a favor para prox cuotas 0 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:23:01', N'CARGA EXCEL', 9, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (106, N'EF4673F97A40EBAE54F4F7BAA185BB96', N'ENVIADO', NULL, CAST(N'2022-05-16T22:18:16.230' AS DateTime), CAST(N'2022-05-17T19:23:08.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:23:10.717' AS DateTime), NULL, N'76849540', N'Orlando MotoclubEmbarrados comunica tu deuda en aportes es 700 bs, saldo a favor para prox cuotas 0 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:23:08', N'CARGA EXCEL', 9, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (107, N'8F8AF514BBF5476CFCE17D2DE79ED552', N'ENVIADO', NULL, CAST(N'2022-05-16T22:18:23.877' AS DateTime), CAST(N'2022-05-17T19:23:15.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:23:11.300' AS DateTime), NULL, N'75038716', N'Said MotoclubEmbarrados comunica tu deuda en aportes es 0 bs, saldo a favor para prox cuotas 0 bs. Vecimiento 17/05/2022. La Directiva', NULL, N'ENTREGADO: 17/5/2022 19:23:15', N'CARGA EXCEL', 9, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (108, N'13BEF28BAB06B43DB21C247BBB9A889E', N'ENVIADO', NULL, CAST(N'2022-05-16T23:06:22.807' AS DateTime), CAST(N'2022-05-17T19:22:29.000' AS DateTime), CAST(N'2022-05-16T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:22:30.877' AS DateTime), NULL, N'76395733', N'Antonio MotoclubEmbarrados comunica tu deuda en aportes es 1700 bs, con el perdonazo estaras al dia con un pago de 700 bs Vecimiento 17/05/2022. La Dir', NULL, N'ENTREGADO: 17/5/2022 19:22:29', N'CARGA EXCEL', 10, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (109, N'D9923182B0BA7F0ADDF10DE854029744', N'ENVIADO', NULL, CAST(N'2022-05-17T19:18:19.430' AS DateTime), CAST(N'2022-05-17T19:18:28.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:18:48.780' AS DateTime), NULL, N'76338922', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:18:28', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (110, N'9B06C5DF2EA5D149D9753D71FF962390', N'ENVIADO', NULL, CAST(N'2022-05-17T19:18:24.033' AS DateTime), CAST(N'2022-05-17T19:18:34.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:18:49.353' AS DateTime), NULL, N'61557932', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:18:34', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (111, N'EAAFA3E8302F70FCA0BF064EA4A4C740', N'ENVIADO', NULL, CAST(N'2022-05-17T19:18:28.520' AS DateTime), CAST(N'2022-05-17T19:18:37.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:18:49.930' AS DateTime), NULL, N'68920000', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:18:37', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (112, N'091378F303E05A57DA96EBAF0A4D80A1', N'ENVIADO', NULL, CAST(N'2022-05-17T19:18:33.153' AS DateTime), CAST(N'2022-05-17T19:18:42.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:18:50.510' AS DateTime), NULL, N'77199860', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:18:42', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (113, N'5C21C0220EF7C9D158FBC33C2A59CF29', N'ENVIADO', NULL, CAST(N'2022-05-17T19:18:37.677' AS DateTime), CAST(N'2022-05-17T19:18:46.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:18:51.090' AS DateTime), NULL, N'77095975', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:18:46', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (114, N'9E2507C6D54B62CEDD3DDA99FE5AD3FD', N'ENVIADO', NULL, CAST(N'2022-05-17T19:18:42.230' AS DateTime), CAST(N'2022-05-17T19:18:52.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:18:51.670' AS DateTime), NULL, N'70906640', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:18:52', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (115, N'7E7C62502C6DE80FED15AD02A7754915', N'ENVIADO', NULL, CAST(N'2022-05-17T19:18:47.193' AS DateTime), CAST(N'2022-05-17T19:18:56.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:18:52.250' AS DateTime), NULL, N'78192692', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:18:56', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (116, N'DD75AD3E7D9E93010D8DD8BDCDA0E741', N'ENVIADO', NULL, CAST(N'2022-05-17T19:18:56.240' AS DateTime), CAST(N'2022-05-17T19:19:05.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:19:09.010' AS DateTime), NULL, N'75371046', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:19:05', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (117, N'FCC4ECE7B8545CC5564D7867D153C545', N'ENVIADO', NULL, CAST(N'2022-05-17T19:19:00.843' AS DateTime), CAST(N'2022-05-17T19:19:09.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:19:09.683' AS DateTime), NULL, N'72189594', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:19:09', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (118, N'59E012AAF81F35B141562765C5B90145', N'EN COLA', NULL, NULL, CAST(N'2022-05-17T19:19:14.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:19:10.310' AS DateTime), NULL, N'72879442', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:19:14', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (119, N'E69AC3ADA5F2286A22027704B5E21C33', N'ENVIADO', NULL, CAST(N'2022-05-17T19:19:15.267' AS DateTime), CAST(N'2022-05-17T19:19:24.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:19:39.007' AS DateTime), NULL, N'70999011', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:19:24', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (120, N'9A0B6E129D4053FDFD8861E0E6B2A6EF', N'ENVIADO', NULL, CAST(N'2022-05-17T19:19:49.373' AS DateTime), CAST(N'2022-05-17T19:19:58.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:09.420' AS DateTime), NULL, N'72150961', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:19:58', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (121, N'7DAEEFC6BF21D755AF5D1C2E8385C39F', N'ENVIADO', NULL, CAST(N'2022-05-17T19:19:54.010' AS DateTime), CAST(N'2022-05-17T19:20:03.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:10.007' AS DateTime), NULL, N'78520886', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:20:03', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (122, N'F0B6EC78A5D14C21FEBA03FF958F2D9D', N'ENVIADO', NULL, CAST(N'2022-05-17T19:19:58.527' AS DateTime), CAST(N'2022-05-17T19:20:07.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:10.587' AS DateTime), NULL, N'70095592', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:20:07', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (123, N'D3FAFE5A6C8238BC2BEF641A979F4AF6', N'ENVIADO', NULL, CAST(N'2022-05-17T19:20:03.210' AS DateTime), CAST(N'2022-05-17T19:20:12.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:11.163' AS DateTime), NULL, N'75025341', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:20:12', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (124, N'C690EC9608083DE2356D650EB61D0F9B', N'EN COLA', NULL, NULL, CAST(N'2022-05-17T19:21:26.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:21:41.320' AS DateTime), NULL, N'75350665', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:21:26', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (125, N'8C84C379A9B46975199FBE70CB01CA2F', N'ENVIADO', NULL, CAST(N'2022-05-17T19:20:16.437' AS DateTime), CAST(N'2022-05-17T19:20:25.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:50.560' AS DateTime), NULL, N'78030471', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:20:25', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (126, N'2C4E4BE2C46D06D04B7BD76744EA39FE', N'ENVIADO', NULL, CAST(N'2022-05-17T19:20:21.053' AS DateTime), CAST(N'2022-05-17T19:20:30.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:51.133' AS DateTime), NULL, N'75354642', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:20:30', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (127, N'57903EBCBA71506E6325064F279BEA88', N'ENVIADO', NULL, CAST(N'2022-05-17T19:20:25.860' AS DateTime), CAST(N'2022-05-17T19:20:34.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:51.710' AS DateTime), NULL, N'76314567', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:20:34', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (128, N'A0A9B2208280E4D378FC2BAE231F6A86', N'ENVIADO', NULL, CAST(N'2022-05-17T19:20:30.740' AS DateTime), CAST(N'2022-05-17T19:20:40.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.290' AS DateTime), NULL, N'70000288', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:20:40', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (129, N'A49ADA189CFAA8F94E0CDC293EF19803', N'ENVIADO', NULL, CAST(N'2022-05-17T19:20:35.170' AS DateTime), CAST(N'2022-05-17T19:20:44.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:52.867' AS DateTime), NULL, N'75000089', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:20:44', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (130, N'0EA47B134BDD3201FEE9796487495D35', N'ENVIADO', NULL, CAST(N'2022-05-17T19:20:39.813' AS DateTime), CAST(N'2022-05-17T19:20:48.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:53.443' AS DateTime), NULL, N'76005633', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:20:48', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (131, N'4F547DE113ADE71F16E1C35F38ED82E3', N'ENVIADO', NULL, CAST(N'2022-05-17T19:20:44.250' AS DateTime), CAST(N'2022-05-17T19:20:53.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:54.020' AS DateTime), NULL, N'72673600', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:20:53', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (132, N'7F5E8A9BA1E0AD4A9BDF5FFD07A39348', N'ENVIADO', NULL, CAST(N'2022-05-17T19:20:49.020' AS DateTime), CAST(N'2022-05-17T19:20:58.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:20:54.597' AS DateTime), NULL, N'77086361', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:20:58', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (133, N'09E745A9C8E7EB9CB8C65A08A3EDAC2E', N'ENVIADO', NULL, CAST(N'2022-05-17T19:20:58.720' AS DateTime), CAST(N'2022-05-17T19:21:07.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:21:09.340' AS DateTime), NULL, N'77025639', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:21:07', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (134, N'F377D3A7B7D93E96F79186C29A480702', N'EN COLA', NULL, NULL, CAST(N'2022-05-17T19:21:12.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:21:09.920' AS DateTime), NULL, N'67701069', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:21:12', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (135, N'1DB842EB66063C62185B5F86C690F8FC', N'ENVIADO', NULL, CAST(N'2022-05-17T19:21:17.047' AS DateTime), CAST(N'2022-05-17T19:21:26.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:21:41.320' AS DateTime), NULL, N'75350665', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:21:26', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (136, N'5194EB683688D4A5835AF6ADAFBC6E0E', N'ENVIADO', NULL, CAST(N'2022-05-17T19:21:21.773' AS DateTime), CAST(N'2022-05-17T19:21:30.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:21:41.890' AS DateTime), NULL, N'78146001', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:21:30', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (137, N'342BB029E7B0D645C822EC61F87900C3', N'ENVIADO', NULL, CAST(N'2022-05-17T19:21:26.390' AS DateTime), CAST(N'2022-05-17T19:21:35.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:21:42.467' AS DateTime), NULL, N'75333342', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:21:35', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (138, N'5AD66F937813182DC94D55162A619A52', N'ENVIADO', NULL, CAST(N'2022-05-17T19:21:31.043' AS DateTime), CAST(N'2022-05-17T19:21:40.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:21:43.047' AS DateTime), NULL, N'76018777', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:21:40', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (139, N'C974ECB8E2B4A820711B9273E39E9641', N'ENVIADO', NULL, CAST(N'2022-05-17T19:21:35.517' AS DateTime), CAST(N'2022-05-17T19:21:44.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:21:43.620' AS DateTime), NULL, N'65035588', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:21:44', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (140, N'BB548FBE9FDCFEAC8724FDE4BEE2AB24', N'ENVIADO', NULL, CAST(N'2022-05-17T19:21:39.960' AS DateTime), CAST(N'2022-05-17T19:21:49.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:21:44.203' AS DateTime), NULL, N'75377351', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:21:49', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (141, N'7355D20713810FEADDEA80D83950DE16', N'ENVIADO', NULL, CAST(N'2022-05-17T19:22:12.233' AS DateTime), CAST(N'2022-05-17T19:22:21.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:22:30.290' AS DateTime), NULL, N'74675592', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:22:21', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (142, N'1890A21218ABA7A3CFCC44A9EE3FA659', N'ENVIADO', NULL, CAST(N'2022-05-17T19:22:20.493' AS DateTime), CAST(N'2022-05-17T19:22:29.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:22:30.877' AS DateTime), NULL, N'76395733', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:22:29', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (143, N'06F23E328757F9E543F3DF760DE5C658', N'ENVIADO', NULL, CAST(N'2022-05-17T19:22:28.740' AS DateTime), CAST(N'2022-05-17T19:22:37.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:22:31.463' AS DateTime), NULL, N'77824313', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:22:37', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (144, N'BB42B419884355A7129AFA41C9239567', N'ENVIADO', NULL, CAST(N'2022-05-17T19:22:37.953' AS DateTime), CAST(N'2022-05-17T19:22:46.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:23:08.980' AS DateTime), NULL, N'78494539', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:22:46', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (145, N'6AAE6D2F5E5248BFBA3FD8BA8404034C', N'ENVIADO', NULL, CAST(N'2022-05-17T19:22:45.847' AS DateTime), CAST(N'2022-05-17T19:22:55.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:23:09.550' AS DateTime), NULL, N'71860728', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:22:55', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (146, N'95B5FD4B1C1E0C9295E34647B72BB0FF', N'ENVIADO', NULL, CAST(N'2022-05-17T19:22:52.437' AS DateTime), CAST(N'2022-05-17T19:23:01.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:23:10.133' AS DateTime), NULL, N'68881646', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:23:01', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (147, N'D2E4D6942866343D70D07397E8DAE947', N'ENVIADO', NULL, CAST(N'2022-05-17T19:22:59.253' AS DateTime), CAST(N'2022-05-17T19:23:08.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:23:10.717' AS DateTime), NULL, N'76849540', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:23:08', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
INSERT [dbo].[messages] ([id], [referenceid], [status], [channel], [sent], [received], [scheduled], [lastupdate], [sender], [recepient], [body], [isalert], [result], [type], [idcarga], [idenvio], [priority], [codigo], [messagekey], [queued], [delivered], [usuario]) VALUES (148, N'BFABE5346B4DC186302E58AB0AA82449', N'ENVIADO', NULL, CAST(N'2022-05-17T19:23:05.850' AS DateTime), CAST(N'2022-05-17T19:23:15.000' AS DateTime), CAST(N'2022-05-17T00:00:00.000' AS DateTime), CAST(N'2022-05-17T19:23:11.300' AS DateTime), NULL, N'75038716', N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', NULL, N'ENTREGADO: 17/5/2022 19:23:15', N'CARGA EXCEL', 11, NULL, 2, NULL, NULL, NULL, NULL, N'1')
SET IDENTITY_INSERT [dbo].[messages] OFF
GO
SET IDENTITY_INSERT [dbo].[messagesIn] ON 

INSERT [dbo].[messagesIn] ([id], [channel], [lastupdated], [type], [sender], [body]) VALUES (1, N'', CAST(N'2022-05-12T06:24:54.000' AS DateTime), N'SMS', N'105', N'S.Actual:0.00
V.:30-03-2022
S.Min:40:00
Datos:24000.00MB
V.:31 dic 23:59
Msj: 1884.00
Salvavivas:5
')
INSERT [dbo].[messagesIn] ([id], [channel], [lastupdated], [type], [sender], [body]) VALUES (2, N'', CAST(N'2022-05-16T14:45:03.000' AS DateTime), N'SMS', N'9101', N'Su PLAN INTERNET MOVIL cuenta con: 24.000MB, vigente hasta el 01-06-22 00:00. Usted cuenta con un saldo total(plan+bolsas) de 24.000MB.+Info en: bit.ly/PadIG')
INSERT [dbo].[messagesIn] ([id], [channel], [lastupdated], [type], [sender], [body]) VALUES (3, N'', CAST(N'2022-05-16T14:45:03.000' AS DateTime), N'SMS', N'106', N'Tienes 9 nuevos mensajes de voz. Para escuchar tus mensajes de voz llama al 106. Para mayor informacion ingresa a www.viva.com.bo Mensaje enviado por VIVA.')
INSERT [dbo].[messagesIn] ([id], [channel], [lastupdated], [type], [sender], [body]) VALUES (4, N'', CAST(N'2022-05-16T14:45:03.000' AS DateTime), N'SMS', N'105', N'S.Actual:0.00
V.:28-08-2022
S.Min:40:00
Datos:24000.00MB
V.:31 may 23:59
Msj: 1880.00
Salvavivas:5
')
INSERT [dbo].[messagesIn] ([id], [channel], [lastupdated], [type], [sender], [body]) VALUES (5, N'', CAST(N'2022-05-16T14:45:03.000' AS DateTime), N'SMS', N'105', N'S.Actual:0.00
V.:28-08-2022
S.Min:40:00
Datos:24000.00MB
V.:31 may 23:59
Msj: 1853.00
Salvavivas:5
')
INSERT [dbo].[messagesIn] ([id], [channel], [lastupdated], [type], [sender], [body]) VALUES (6, N'', CAST(N'2022-05-16T14:45:03.000' AS DateTime), N'SMS', N'9101', N'Su PLAN INTERNET MOVIL cuenta con: 24.000MB, vigente hasta el 01-06-22 00:00. Usted cuenta con un saldo total(plan+bolsas) de 24.000MB.+Info en: bit.ly/PadIG')
INSERT [dbo].[messagesIn] ([id], [channel], [lastupdated], [type], [sender], [body]) VALUES (7, N'', CAST(N'2022-05-16T14:45:03.000' AS DateTime), N'SMS', N'9101', N'Su PLAN INTERNET MOVIL cuenta con: 24.000MB, vigente hasta el 01-06-22 00:00. Usted cuenta con un saldo total(plan+bolsas) de 24.000MB.+Info en: bit.ly/PadIG')
INSERT [dbo].[messagesIn] ([id], [channel], [lastupdated], [type], [sender], [body]) VALUES (8, N'', CAST(N'2022-05-16T14:45:03.000' AS DateTime), N'SMS', N'111', N'Paga tu factura de 03/2022 con tarjeta de credito/debito desde Viva App y evita el corte de llamadas salientes de tu linea el 19/05.')
INSERT [dbo].[messagesIn] ([id], [channel], [lastupdated], [type], [sender], [body]) VALUES (9, N'', CAST(N'2022-05-16T14:45:03.000' AS DateTime), N'SMS', N'9101', N'Su PLAN INTERNET MOVIL cuenta con: 24.000MB, vigente hasta el 01-06-22 00:00. Usted cuenta con un saldo total(plan+bolsas) de 24.000MB.+Info en: bit.ly/PadIG')
INSERT [dbo].[messagesIn] ([id], [channel], [lastupdated], [type], [sender], [body]) VALUES (10, N'', CAST(N'2022-05-16T14:45:03.000' AS DateTime), N'SMS', N'111', N'Paga tu factura de 03/2022 con tarjeta de credito/debito desde Viva App y evita el corte de llamadas salientes de tu linea el 19/05.')
INSERT [dbo].[messagesIn] ([id], [channel], [lastupdated], [type], [sender], [body]) VALUES (11, N'', CAST(N'2022-05-16T14:45:03.000' AS DateTime), N'SMS', N'106', N'Tienes 9 nuevos mensajes de voz. Para escuchar tus mensajes de voz llama al 106. Para mayor informacion ingresa a www.viva.com.bo Mensaje enviado por VIVA.')
INSERT [dbo].[messagesIn] ([id], [channel], [lastupdated], [type], [sender], [body]) VALUES (12, N'', CAST(N'2022-05-16T14:46:03.000' AS DateTime), N'SMS', N'105', N'S.Actual:0.00
V.:28-08-2022
S.Min:40:00
Datos:24000.00MB
V.:31 may 23:59
Msj: 1825.00
Salvavivas:5
')
INSERT [dbo].[messagesIn] ([id], [channel], [lastupdated], [type], [sender], [body]) VALUES (13, N'', CAST(N'2022-05-16T23:12:18.000' AS DateTime), N'SMS', N'75371046', N'Por favor anotarlas a mis cuotas correspondientes, gracias')
INSERT [dbo].[messagesIn] ([id], [channel], [lastupdated], [type], [sender], [body]) VALUES (14, N'', CAST(N'2022-05-17T18:41:18.000' AS DateTime), N'SMS', N'105', N'S.Actual:0.00
V.:28-08-2022
S.Min:40:00
Datos:24000.00MB
V.:31 may 23:59
Msj: 1769.00
Salvavivas:5
')
INSERT [dbo].[messagesIn] ([id], [channel], [lastupdated], [type], [sender], [body]) VALUES (15, N'', CAST(N'2022-05-17T19:21:44.000' AS DateTime), N'SMS', N'78030471', N'Cuando tengo que pagar ? De nuevo ')
INSERT [dbo].[messagesIn] ([id], [channel], [lastupdated], [type], [sender], [body]) VALUES (16, N'', CAST(N'2022-05-17T19:22:32.000' AS DateTime), N'SMS', N'78030471', N'Pudiste hablar con Toqo ')
INSERT [dbo].[messagesIn] ([id], [channel], [lastupdated], [type], [sender], [body]) VALUES (17, N'', CAST(N'2022-05-17T19:23:39.000' AS DateTime), N'SMS', N'68881646', N'Ya le pague a Ibaraki 2 veces, gracias')
SET IDENTITY_INSERT [dbo].[messagesIn] OFF
GO
SET IDENTITY_INSERT [dbo].[parametros] ON 

INSERT [dbo].[parametros] ([id], [parametro], [valor], [orden], [habilitado]) VALUES (1, N'MODULOS', N'OPERADORES', 1, 1)
INSERT [dbo].[parametros] ([id], [parametro], [valor], [orden], [habilitado]) VALUES (2, N'MODULOS', N'REPORTES', 2, 1)
INSERT [dbo].[parametros] ([id], [parametro], [valor], [orden], [habilitado]) VALUES (3, N'MODULOS', N'DASHBOARD', 3, 1)
INSERT [dbo].[parametros] ([id], [parametro], [valor], [orden], [habilitado]) VALUES (4, N'AUT_WINDOWS', N'FALSE', 1, 1)
INSERT [dbo].[parametros] ([id], [parametro], [valor], [orden], [habilitado]) VALUES (5, N'AUT_ROL', N'SMS', 1, 1)
INSERT [dbo].[parametros] ([id], [parametro], [valor], [orden], [habilitado]) VALUES (6, N'', NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[parametros] OFF
GO
SET IDENTITY_INSERT [dbo].[plantillas] ON 

INSERT [dbo].[plantillas] ([id], [texto], [fecha], [tipo], [idusuario]) VALUES (1, N'<columna1> Motoclub Embarrados comunica tu deuda en aportes es <columna2> bs, saldo para prox cuota <columna3> bs. La fecha de vecimiento es 17/05/2022. La Dire', CAST(N'2022-05-16T19:37:59.793' AS DateTime), N'Excel', 1)
INSERT [dbo].[plantillas] ([id], [texto], [fecha], [tipo], [idusuario]) VALUES (2, N'Estimado <columna3>, Cooperativa le recuerda que su cuota #<columna4> por <columna6> <columna7> vence en fecha <columna5>. Contactenos al 355-5555', CAST(N'2022-05-16T20:34:25.440' AS DateTime), N'Excel', 1)
INSERT [dbo].[plantillas] ([id], [texto], [fecha], [tipo], [idusuario]) VALUES (3, N'Estimado <columna3>, Cooperativa le recuerda que su cuota #<columna4> por <columna6> <columna7> vence en fecha <columna5>. Contactenos al 355-5555', CAST(N'2022-05-16T20:38:11.923' AS DateTime), N'Excel', 1)
INSERT [dbo].[plantillas] ([id], [texto], [fecha], [tipo], [idusuario]) VALUES (4, N'<columna1> Motoclub Embarrados comunica tu deuda en aportes es <columna3> bs, saldo para prox cuota <columna4> bs. La fecha de vecimiento es 17/05/2022. La Dire', CAST(N'2022-05-16T20:40:14.203' AS DateTime), N'Excel', 1)
INSERT [dbo].[plantillas] ([id], [texto], [fecha], [tipo], [idusuario]) VALUES (5, N'<columna1> MotoclubEmbarrados comunica tu deuda en aportes es <columna3> bs, saldo a favor para prox cuotas <columna4> bs. Vecimiento 17/05/2022. La Directiva', CAST(N'2022-05-16T22:02:40.203' AS DateTime), N'Excel', 1)
INSERT [dbo].[plantillas] ([id], [texto], [fecha], [tipo], [idusuario]) VALUES (6, N'<columna1> MotoclubEmbarrados comunica tu deuda en aportes es <columna3> bs, con el perdonazo estaras al dia con un pago de 700 bs Vecimiento 17/05/2022. La Dir', CAST(N'2022-05-16T22:16:27.740' AS DateTime), N'Excel', 1)
INSERT [dbo].[plantillas] ([id], [texto], [fecha], [tipo], [idusuario]) VALUES (7, N'MotoclubEmbarrados te recuerda la asamblea definio p hoy el limite p regularizar la situacion de aportes afirma tu compromiso con el club la directiva te espera', CAST(N'2022-05-17T19:18:12.657' AS DateTime), N'Excel', 1)
SET IDENTITY_INSERT [dbo].[plantillas] OFF
GO
SET IDENTITY_INSERT [dbo].[usuarios] ON 

INSERT [dbo].[usuarios] ([id], [nombre], [registrado], [habilitado], [usuario], [password], [modulos]) VALUES (1, N'Marketing', NULL, 1, N'mark', N'123', N'OPERADORES,REPORTES,WEB')
INSERT [dbo].[usuarios] ([id], [nombre], [registrado], [habilitado], [usuario], [password], [modulos]) VALUES (3, N'cobranzas', NULL, 1, N'cobros', N'123', N'OPERADORES,REPORTES,WEB')
INSERT [dbo].[usuarios] ([id], [nombre], [registrado], [habilitado], [usuario], [password], [modulos]) VALUES (4, N'sistemas', CAST(N'2021-11-30T09:24:33.563' AS DateTime), 1, N'sistemas', N'123', N'OPERADORES,REPORTES,WEB')
INSERT [dbo].[usuarios] ([id], [nombre], [registrado], [habilitado], [usuario], [password], [modulos]) VALUES (5, N'test', NULL, 1, N'test', N'123', N'OPERADORES,REPORTES,WEB')
SET IDENTITY_INSERT [dbo].[usuarios] OFF
GO
ALTER TABLE [dbo].[config] ADD  CONSTRAINT [DF_config_fecha]  DEFAULT (getdate()) FOR [fecha]
GO
ALTER TABLE [dbo].[lista_numeros] ADD  CONSTRAINT [DF_lista_numeros_fecha]  DEFAULT (getdate()) FOR [fecha]
GO
ALTER TABLE [dbo].[listas] ADD  CONSTRAINT [DF_listas_fecha]  DEFAULT (getdate()) FOR [fecha]
GO
ALTER TABLE [dbo].[logCargadeDatos] ADD  CONSTRAINT [DF_logCargasAutomaticas_fecha]  DEFAULT (getdate()) FOR [fecha]
GO
ALTER TABLE [dbo].[messages] ADD  CONSTRAINT [DF_messages_lastupdate]  DEFAULT (getdate()) FOR [lastupdate]
GO
ALTER TABLE [dbo].[messages] ADD  CONSTRAINT [DF_messages_priority]  DEFAULT ((2)) FOR [priority]
GO
ALTER TABLE [dbo].[messagesIn] ADD  CONSTRAINT [DF_messagesIn_lastupdated]  DEFAULT (getdate()) FOR [lastupdated]
GO
ALTER TABLE [dbo].[plantillas] ADD  CONSTRAINT [DF_plantillas_fecha]  DEFAULT (getdate()) FOR [fecha]
GO
ALTER TABLE [dbo].[plantillas] ADD  CONSTRAINT [DF_plantillas_tipo]  DEFAULT (N'EXCEL') FOR [tipo]
GO
ALTER TABLE [dbo].[plantillas] ADD  CONSTRAINT [DF_plantillas_idusuario]  DEFAULT ((1)) FOR [idusuario]
GO
ALTER TABLE [dbo].[tarjetasCargadas] ADD  CONSTRAINT [DF_tarjetasCargadas_fecha]  DEFAULT (getdate()) FOR [fecha]
GO
ALTER TABLE [dbo].[usuarios] ADD  CONSTRAINT [DF_usuarios_registrado]  DEFAULT (getdate()) FOR [registrado]
GO
ALTER TABLE [dbo].[usuarios] ADD  CONSTRAINT [DF_usuarios_mod_operador]  DEFAULT ((0)) FOR [modulos]
GO
/****** Object:  StoredProcedure [dbo].[dashboardContadores]    Script Date: 2/6/2022 17:05:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[dashboardContadores]
@totalFechas float out,
@totalProcesando float out,
@totalEnviados float out
as 
DECLARE @fechaini date
declare @fechafin date

set @fechaini = cast(getdate() as date)
set @fechafin= dateadd(DAY, 1,cast(getdate() as date))
set @totalFechas=(select count(*) as total from messages where scheduled between @fechaini and @fechafin)

set @totalProcesando= (select count(*) as TotalProcesando
from messages  where status in ('PENDIENTE','EN COLA','ENVIANDO') and scheduled between @fechaini and @fechafin)

set @totalEnviados= (select count(*) as totalEnviados
from messages  where status in ('ENVIADO','ERROR') and sent between @fechaini and @fechafin)
GO
/****** Object:  StoredProcedure [dbo].[dashboardGrafTotalesxFecha]    Script Date: 2/6/2022 17:05:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[dashboardGrafTotalesxFecha]
@fechaini date,
@fechafin date,
@totalFechas float out,
@totalProcesando float out,
@totalEnviados float out
as 
set @fechaini = cast(@fechaini as date)
set @fechafin= dateadd(DAY, 1,cast(@fechafin as date))

select top 10 cast(scheduled as date) as fecha, count(*) as totalFecha
from messages where scheduled between @fechaini and @fechafin group by cast(scheduled as date) order by cast(scheduled as date) desc
GO
/****** Object:  StoredProcedure [dbo].[spCancelarMensaje]    Script Date: 2/6/2022 17:05:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[spCancelarMensaje] 
	-- Add the parameters for the stored procedure here
	@rowscount int out,
	@errorcode int out,
	@id as int
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT OFF;

UPDATE [messages] 
SET status='CANCELADO', lastupdate=GETDATE() WHERE id= @id;
select @rowscount=@@ROWCOUNT, @errorcode = @@ERROR
END
GO
/****** Object:  StoredProcedure [dbo].[spCargarMensajes]    Script Date: 2/6/2022 17:05:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[spCargarMensajes] 
  @dia datetime
AS
BEGIN
	SET NOCOUNT ON;

-- CAMPOS Y ALIAS OBLIGATORIOS: FECHA, TELEFONO, MENSAJE
-- para pruebas
select  CAST(GETDATE() as date) as FECHA, 70000288 as TELEFONO, 'Estimado Bart Simpson le recordamos que su cuota #123 por 99Bs vence hoy contactenos al telef: 3456789 - EMPRESA SRL' as MENSAJE
--para produccion
	--select fechaenvio as FECHA, telefono as TELEFONO, mensaje as MENSAJE
	--from prestamos.dbo.cuotas 
	--where fechaenvio = @dia
END
GO
/****** Object:  StoredProcedure [dbo].[spTraerCuotas]    Script Date: 2/6/2022 17:05:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[spTraerCuotas] 
  @dia nvarchar(10)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
-- nombre, fechapago, numerodeuda,montocuota, moneda, numerocuota, telefono1, telefono2, telefono3
 select 'Bart Simpson' as nombre, CAST(GETDATE() as date) as fechapago,CAST(GETDATE() as date) as fechaenvio, 0 as numerodeuda, 99.00 as montocuota, 123 as numerocuota, 'Bs' as moneda, 70000288 as telefono1, '' as telefono2, '' as telefono3
	--select nombre as nombre, vencimiento as fechapago,0 as numerodeuda,monto as montocuota, nrocuota as numerocuota, moneda as moneda, telefono as telefono1, '' as telefono2, '' as telefono3
	--from prestamos.dbo.cuotas 
	--where vencimiento = @dia
END
GO
/****** Object:  StoredProcedure [dbo].[spWsEliminarMensaje]    Script Date: 2/6/2022 17:05:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[spWsEliminarMensaje]
	-- Add the parameters for the stored procedure here
	@rowscount int out,
	@errorcode int out,
	@id as int
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT off;
	  
DELETE FROM [messages]
      WHERE id= @id;
select @rowscount=@@ROWCOUNT, @errorcode = @@ERROR
END
GO
/****** Object:  StoredProcedure [dbo].[spWsEnviarMensaje]    Script Date: 2/6/2022 17:05:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[spWsEnviarMensaje]
	-- Add the parameters for the stored procedure here
	@fecha_envio date,
	@telefono nvarchar(10),
	@mensaje nvarchar(250),
	@prioridad smallint,
	@rowscount int out,
	@errorcode int out,
	@codigo bigint
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT OFF;

 insert into messages(status,scheduled,recepient,body, type, priority,codigo) 
values ('PENDIENTE', @fecha_envio, @telefono ,@mensaje , 'WEBSERVICE', @prioridad,@codigo);
select @rowscount=@@ROWCOUNT, @errorcode = @@ERROR
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'3=LOW, 2=NORMAL,1=HIGH' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'messages', @level2type=N'COLUMN',@level2name=N'priority'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'3 LOW, 2 NORMAL, 1 HIGH' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'messages'
GO
USE [master]
GO
ALTER DATABASE [SMSEngine] SET  READ_WRITE 
GO
