-- --------------------------------------------------------
-- Versión del servidor:         8.0.30 - MySQL Community Server - GPL
-- SO del servidor:              Win64
-- HeidiSQL Versión:             12.1.0.6537
-- --------------------------------------------------------


-- Volcando estructura para tabla api_davivienda.davivienda_api_errores_api
CREATE TABLE IF NOT EXISTS `davivienda_api_errores_api` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `proceso` varchar(20) NOT NULL,
  `descripcion` varchar(255) NOT NULL,
  `status_code` varchar(5) NOT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish_ci;

-- Volcando estructura para tabla api_davivienda.davivienda_api_transacciones
CREATE TABLE IF NOT EXISTS `davivienda_api_transacciones` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `comercio` varchar(255) NOT NULL,
  `telefonoDestino` varchar(20) NOT NULL,
  `identificacion` varchar(20) NOT NULL,
  `idenficacion_limpio` varchar(20) NOT NULL COMMENT 'Lo guardamos sin espacios en blanco y sin guiones',
  `cliente` varchar(255) NOT NULL,
  `telefonoOrigen` varchar(20) DEFAULT NULL,
  `fechaRecibido` datetime NOT NULL,
  `monto` decimal(10,2) NOT NULL,
  `numReferencia` varchar(50) NOT NULL,
  `numReferenciaBanco` varchar(50) NOT NULL,
  `clienteId` varchar(20) NOT NULL,
  `estado` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci NOT NULL,
  `descripcion` text CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci,
  `vdp_leido` int DEFAULT '0' COMMENT '0 Defecto ',
  `vdp_leido_fecha` datetime DEFAULT NULL,
  `vdp_sincronizado_resultado` int DEFAULT NULL COMMENT '0 Defecto 1 Bien 2 Mal',
  `vdp_sincronizado_resultado_fecha` datetime DEFAULT NULL,
  `vdp_comentario_vinculacion` text CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci,
  `vdp_recibo` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci DEFAULT NULL COMMENT 'Aqui se pone el recibe si el pago procedio,de lo contrario no se rellena, este dato se envia adavivienda',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish_ci;

-- Volcando datos para la tabla api_davivienda.davivienda_api_transacciones: ~75 rows (aproximadamente)
INSERT INTO `davivienda_api_transacciones` (`rowid`, `comercio`, `telefonoDestino`, `identificacion`, `idenficacion_limpio`, `cliente`, `telefonoOrigen`, `fechaRecibido`, `monto`, `numReferencia`, `numReferenciaBanco`, `clienteId`, `estado`, `descripcion`, `vdp_leido`, `vdp_leido_fecha`, `vdp_sincronizado_resultado`, `vdp_sincronizado_resultado_fecha`, `vdp_comentario_vinculacion`, `vdp_recibo`) VALUES
	(1, 'FUNERARIA VALLE DE PAZ', '89206518', '01-1157-0102', '', 'Roberto Jimenez', '00000000', '2024-05-15 16:36:35', 1000.00, '2024051516363478068862681', '8068862681', '01-1157-0102', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(2, 'FUNERARIA VALLE DE PAZ', '89206518', '01-1157-0102', '', 'Roberto Jimenez', '00000000', '2024-05-15 16:36:35', 2500.00, '2024051516363478092731600', '8092731600', '01-1157-0102', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(3, 'FUNERARIA VALLE DE PAZ', '89206518', '01-1157-0102', '', 'Roberto Jimenez', '00000000', '2024-05-15 16:36:35', 8800.00, '2024051516363478036311811', '8036311811', '01-1157-0102', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(4, 'FUNERARIA VALLE DE PAZ', '89206518', '01-1258-0692', '', 'Adrian Carmona', '00000000', '2024-05-15 16:36:35', 1500.00, '2024051516363478020186506', '8020186506', '01-1258-0692', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(5, 'FUNERARIA VALLE DE PAZ', '89206518', '01-1258-0692', '', 'Adrian Carmona', '00000000', '2024-05-15 16:36:35', 2500.00, '2024051516363478057482540', '8057482540', '01-1258-0692', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(6, 'FUNERARIA VALLE DE PAZ', '89206518', '01-1258-0692', '', 'Adrian Carmona', '00000000', '2024-05-15 16:36:35', 3500.00, '2024051516363478010620069', '8010620069', '01-1258-0692', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(7, 'FUNERARIA VALLE DE PAZ', '89206518', '02-0562-3698', '', 'Ana Marín', '00000000', '2024-05-15 16:36:35', 5820.00, '2024051516363478023652233', '8023652233', '02-0562-3698', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(8, 'FUNERARIA VALLE DE PAZ', '89206518', '02-0562-3698', '', 'Ana Marín', '00000000', '2024-05-15 16:36:35', 6360.00, '2024051516363478045177966', '8045177966', '02-0562-3698', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(9, 'FUNERARIA VALLE DE PAZ', '89206518', '02-0562-3698', '', 'Ana Marín', '00000000', '2024-05-15 16:36:35', 6930.00, '2024051516363478027089962', '8027089962', '02-0562-3698', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(10, 'FUNERARIA VALLE DE PAZ', '89206518', '05-3610-0074', '', 'Juliana Barrantes', '00000000', '2024-05-15 16:36:35', 5500.00, '2024051516363478024382264', '8024382264', '05-3610-0074', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(11, 'FUNERARIA VALLE DE PAZ', '89206518', '05-3610-0074', '', 'Juliana Barrantes', '00000000', '2024-05-15 16:36:35', 6520.00, '2024051516363478043906156', '8043906156', '05-3610-0074', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(12, 'FUNERARIA VALLE DE PAZ', '89206518', '06-1237-0692', '', 'Ariel Beita', '00000000', '2024-05-15 16:36:35', 2500.00, '2024051516363478097974935', '8097974935', '06-1237-0692', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(13, 'FUNERARIA VALLE DE PAZ', '89206518', '06-1237-0692', '', 'Ariel Beita', '00000000', '2024-05-15 16:36:35', 6930.00, '2024051516363478074040941', '8074040941', '06-1237-0692', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(14, 'FUNERARIA VALLE DE PAZ', '89206518', '06-1237-0692', '', 'Ariel Beita', '00000000', '2024-05-15 16:36:35', 7930.00, '2024051516363478010455840', '8010455840', '06-1237-0692', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(15, 'FUNERARIA VALLE DE PAZ', '89206518', '155828455034', '', 'Denia Zamora Ruiz', '00000000', '2024-05-15 16:36:35', 5820.00, '2024051516363478084710017', '8084710017', '155828455034', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(16, 'FUNERARIA VALLE DE PAZ', '89206518', '155828455034', '', 'Denia Zamora Ruiz', '00000000', '2024-05-15 16:36:35', 7500.00, '2024051516363478021138467', '8021138467', '155828455034', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(17, 'FUNERARIA VALLE DE PAZ', '89206518', '155834181515', '', 'Adony González Mendoza', '00000000', '2024-05-15 16:36:35', 1000.00, '2024051516363478084729940', '8084729940', '155834181515', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(18, 'FUNERARIA VALLE DE PAZ', '89206518', '3-004-000000', '', 'TIENDA SUR URUCA', '00000000', '2024-05-15 16:36:35', 6930.00, '2024051516363478046527032', '8046527032', '3-004-000000', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(19, 'FUNERARIA VALLE DE PAZ', '89206518', '3-102-022435', '', 'TIENDA SUR PIRRO ', '00000000', '2024-05-15 16:36:35', 200.92, '2024051516363478010143835', '8010143835', '3-102-022435', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(20, 'FUNERARIA VALLE DE PAZ', '89206518', '3-102-022435', '', 'TIENDA SUR PIRRO ', '00000000', '2024-05-15 16:36:35', 2000.00, '2024051516363478029564303', '8029564303', '3-102-022435', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(21, 'FUNERARIA VALLE DE PAZ', '89206518', '578963666545', '', 'Adony González Mendoza', '00000000', '2024-05-15 16:36:35', 1000.00, '2024051516363478010402644', '8010402644', '578963666545', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(22, 'FUNERARIA VALLE DE PAZ', '89206518', '578963666545', '', 'Adony González Mendoza', '00000000', '2024-05-15 16:36:35', 2000.00, '2024051516363478023167264', '8023167264', '578963666545', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(23, 'FUNERARIA VALLE DE PAZ', '89206518', '599632541222', '', 'Denia Zamora Ruiz', '00000000', '2024-05-15 16:36:35', 5820.00, '2024051516363478010830202', '8010830202', '599632541222', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(24, 'FUNERARIA VALLE DE PAZ', '89206518', 'AB12502600036950012', '', 'Maria Carrillo', '00000000', '2024-05-15 16:36:35', 5820.00, '2024051516363478057671804', '8057671804', 'AB12502600036950012', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(25, 'FUNERARIA VALLE DE PAZ', '89206518', 'AB12502600036950012', '', 'Maria Carrillo', '00000000', '2024-05-15 16:36:35', 6500.00, '2024051516363478010236187', '8010236187', 'AB12502600036950012', 'No vinculado', 'Pago de prueba', NULL, NULL, NULL, NULL, NULL, NULL),
	(26, 'FUNERARIA VALLE DE PAZ', '89206518', '01-1157-0102', '', 'Roberto Jimenez', '00000000', '2024-05-15 16:36:35', 1000.00, '2024051516363478068862681', '8068862681', '01-1157-0102', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(27, 'FUNERARIA VALLE DE PAZ', '89206518', '01-1157-0102', '', 'Roberto Jimenez', '00000000', '2024-05-15 16:36:35', 2500.00, '2024051516363478092731600', '8092731600', '01-1157-0102', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(28, 'FUNERARIA VALLE DE PAZ', '89206518', '01-1157-0102', '', 'Roberto Jimenez', '00000000', '2024-05-15 16:36:35', 8800.00, '2024051516363478036311811', '8036311811', '01-1157-0102', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(29, 'FUNERARIA VALLE DE PAZ', '89206518', '01-1258-0692', '', 'Adrian Carmona', '00000000', '2024-05-15 16:36:35', 1500.00, '2024051516363478020186506', '8020186506', '01-1258-0692', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(30, 'FUNERARIA VALLE DE PAZ', '89206518', '01-1258-0692', '', 'Adrian Carmona', '00000000', '2024-05-15 16:36:35', 2500.00, '2024051516363478057482540', '8057482540', '01-1258-0692', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(31, 'FUNERARIA VALLE DE PAZ', '89206518', '01-1258-0692', '', 'Adrian Carmona', '00000000', '2024-05-15 16:36:35', 3500.00, '2024051516363478010620069', '8010620069', '01-1258-0692', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(32, 'FUNERARIA VALLE DE PAZ', '89206518', '02-0562-3698', '', 'Ana Marín', '00000000', '2024-05-15 16:36:35', 5820.00, '2024051516363478023652233', '8023652233', '02-0562-3698', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(33, 'FUNERARIA VALLE DE PAZ', '89206518', '02-0562-3698', '', 'Ana Marín', '00000000', '2024-05-15 16:36:35', 6360.00, '2024051516363478045177966', '8045177966', '02-0562-3698', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(34, 'FUNERARIA VALLE DE PAZ', '89206518', '02-0562-3698', '', 'Ana Marín', '00000000', '2024-05-15 16:36:35', 6930.00, '2024051516363478027089962', '8027089962', '02-0562-3698', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(35, 'FUNERARIA VALLE DE PAZ', '89206518', '05-3610-0074', '', 'Juliana Barrantes', '00000000', '2024-05-15 16:36:35', 5500.00, '2024051516363478024382264', '8024382264', '05-3610-0074', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(36, 'FUNERARIA VALLE DE PAZ', '89206518', '05-3610-0074', '', 'Juliana Barrantes', '00000000', '2024-05-15 16:36:35', 6520.00, '2024051516363478043906156', '8043906156', '05-3610-0074', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(37, 'FUNERARIA VALLE DE PAZ', '89206518', '06-1237-0692', '', 'Ariel Beita', '00000000', '2024-05-15 16:36:35', 2500.00, '2024051516363478097974935', '8097974935', '06-1237-0692', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(38, 'FUNERARIA VALLE DE PAZ', '89206518', '06-1237-0692', '', 'Ariel Beita', '00000000', '2024-05-15 16:36:35', 6930.00, '2024051516363478074040941', '8074040941', '06-1237-0692', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(39, 'FUNERARIA VALLE DE PAZ', '89206518', '06-1237-0692', '', 'Ariel Beita', '00000000', '2024-05-15 16:36:35', 7930.00, '2024051516363478010455840', '8010455840', '06-1237-0692', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(40, 'FUNERARIA VALLE DE PAZ', '89206518', '155828455034', '', 'Denia Zamora Ruiz', '00000000', '2024-05-15 16:36:35', 5820.00, '2024051516363478084710017', '8084710017', '155828455034', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(41, 'FUNERARIA VALLE DE PAZ', '89206518', '155828455034', '', 'Denia Zamora Ruiz', '00000000', '2024-05-15 16:36:35', 7500.00, '2024051516363478021138467', '8021138467', '155828455034', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(42, 'FUNERARIA VALLE DE PAZ', '89206518', '155834181515', '', 'Adony González Mendoza', '00000000', '2024-05-15 16:36:35', 1000.00, '2024051516363478084729940', '8084729940', '155834181515', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(43, 'FUNERARIA VALLE DE PAZ', '89206518', '3-004-000000', '', 'TIENDA SUR URUCA', '00000000', '2024-05-15 16:36:35', 6930.00, '2024051516363478046527032', '8046527032', '3-004-000000', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(44, 'FUNERARIA VALLE DE PAZ', '89206518', '3-102-022435', '', 'TIENDA SUR PIRRO ', '00000000', '2024-05-15 16:36:35', 200.92, '2024051516363478010143835', '8010143835', '3-102-022435', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(45, 'FUNERARIA VALLE DE PAZ', '89206518', '3-102-022435', '', 'TIENDA SUR PIRRO ', '00000000', '2024-05-15 16:36:35', 2000.00, '2024051516363478029564303', '8029564303', '3-102-022435', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(46, 'FUNERARIA VALLE DE PAZ', '89206518', '578963666545', '', 'Adony González Mendoza', '00000000', '2024-05-15 16:36:35', 1000.00, '2024051516363478010402644', '8010402644', '578963666545', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(47, 'FUNERARIA VALLE DE PAZ', '89206518', '578963666545', '', 'Adony González Mendoza', '00000000', '2024-05-15 16:36:35', 2000.00, '2024051516363478023167264', '8023167264', '578963666545', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(48, 'FUNERARIA VALLE DE PAZ', '89206518', '599632541222', '', 'Denia Zamora Ruiz', '00000000', '2024-05-15 16:36:35', 5820.00, '2024051516363478010830202', '8010830202', '599632541222', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(49, 'FUNERARIA VALLE DE PAZ', '89206518', 'AB12502600036950012', '', 'Maria Carrillo', '00000000', '2024-05-15 16:36:35', 5820.00, '2024051516363478057671804', '8057671804', 'AB12502600036950012', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(50, 'FUNERARIA VALLE DE PAZ', '89206518', 'AB12502600036950012', '', 'Maria Carrillo', '00000000', '2024-05-15 16:36:35', 6500.00, '2024051516363478010236187', '8010236187', 'AB12502600036950012', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(51, 'FUNERARIA VALLE DE PAZ', '89206518', '01-1157-0102', '', 'Roberto Jimenez', '00000000', '2024-05-15 16:36:35', 1000.00, '2024051516363478068862681', '8068862681', '01-1157-0102', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(52, 'FUNERARIA VALLE DE PAZ', '89206518', '01-1157-0102', '', 'Roberto Jimenez', '00000000', '2024-05-15 16:36:35', 2500.00, '2024051516363478092731600', '8092731600', '01-1157-0102', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(53, 'FUNERARIA VALLE DE PAZ', '89206518', '01-1157-0102', '', 'Roberto Jimenez', '00000000', '2024-05-15 16:36:35', 8800.00, '2024051516363478036311811', '8036311811', '01-1157-0102', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(54, 'FUNERARIA VALLE DE PAZ', '89206518', '01-1258-0692', '', 'Adrian Carmona', '00000000', '2024-05-15 16:36:35', 1500.00, '2024051516363478020186506', '8020186506', '01-1258-0692', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(55, 'FUNERARIA VALLE DE PAZ', '89206518', '01-1258-0692', '', 'Adrian Carmona', '00000000', '2024-05-15 16:36:35', 2500.00, '2024051516363478057482540', '8057482540', '01-1258-0692', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(56, 'FUNERARIA VALLE DE PAZ', '89206518', '01-1258-0692', '', 'Adrian Carmona', '00000000', '2024-05-15 16:36:35', 3500.00, '2024051516363478010620069', '8010620069', '01-1258-0692', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(57, 'FUNERARIA VALLE DE PAZ', '89206518', '02-0562-3698', '', 'Ana Marín', '00000000', '2024-05-15 16:36:35', 5820.00, '2024051516363478023652233', '8023652233', '02-0562-3698', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(58, 'FUNERARIA VALLE DE PAZ', '89206518', '02-0562-3698', '', 'Ana Marín', '00000000', '2024-05-15 16:36:35', 6360.00, '2024051516363478045177966', '8045177966', '02-0562-3698', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(59, 'FUNERARIA VALLE DE PAZ', '89206518', '02-0562-3698', '', 'Ana Marín', '00000000', '2024-05-15 16:36:35', 6930.00, '2024051516363478027089962', '8027089962', '02-0562-3698', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(60, 'FUNERARIA VALLE DE PAZ', '89206518', '05-3610-0074', '', 'Juliana Barrantes', '00000000', '2024-05-15 16:36:35', 5500.00, '2024051516363478024382264', '8024382264', '05-3610-0074', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(61, 'FUNERARIA VALLE DE PAZ', '89206518', '05-3610-0074', '', 'Juliana Barrantes', '00000000', '2024-05-15 16:36:35', 6520.00, '2024051516363478043906156', '8043906156', '05-3610-0074', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(62, 'FUNERARIA VALLE DE PAZ', '89206518', '06-1237-0692', '', 'Ariel Beita', '00000000', '2024-05-15 16:36:35', 2500.00, '2024051516363478097974935', '8097974935', '06-1237-0692', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(63, 'FUNERARIA VALLE DE PAZ', '89206518', '06-1237-0692', '', 'Ariel Beita', '00000000', '2024-05-15 16:36:35', 6930.00, '2024051516363478074040941', '8074040941', '06-1237-0692', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(64, 'FUNERARIA VALLE DE PAZ', '89206518', '06-1237-0692', '', 'Ariel Beita', '00000000', '2024-05-15 16:36:35', 7930.00, '2024051516363478010455840', '8010455840', '06-1237-0692', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(65, 'FUNERARIA VALLE DE PAZ', '89206518', '155828455034', '', 'Denia Zamora Ruiz', '00000000', '2024-05-15 16:36:35', 5820.00, '2024051516363478084710017', '8084710017', '155828455034', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(66, 'FUNERARIA VALLE DE PAZ', '89206518', '155828455034', '', 'Denia Zamora Ruiz', '00000000', '2024-05-15 16:36:35', 7500.00, '2024051516363478021138467', '8021138467', '155828455034', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(67, 'FUNERARIA VALLE DE PAZ', '89206518', '155834181515', '', 'Adony González Mendoza', '00000000', '2024-05-15 16:36:35', 1000.00, '2024051516363478084729940', '8084729940', '155834181515', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(68, 'FUNERARIA VALLE DE PAZ', '89206518', '3-004-000000', '', 'TIENDA SUR URUCA', '00000000', '2024-05-15 16:36:35', 6930.00, '2024051516363478046527032', '8046527032', '3-004-000000', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(69, 'FUNERARIA VALLE DE PAZ', '89206518', '3-102-022435', '', 'TIENDA SUR PIRRO ', '00000000', '2024-05-15 16:36:35', 200.92, '2024051516363478010143835', '8010143835', '3-102-022435', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(70, 'FUNERARIA VALLE DE PAZ', '89206518', '3-102-022435', '', 'TIENDA SUR PIRRO ', '00000000', '2024-05-15 16:36:35', 2000.00, '2024051516363478029564303', '8029564303', '3-102-022435', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(71, 'FUNERARIA VALLE DE PAZ', '89206518', '578963666545', '', 'Adony González Mendoza', '00000000', '2024-05-15 16:36:35', 1000.00, '2024051516363478010402644', '8010402644', '578963666545', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(72, 'FUNERARIA VALLE DE PAZ', '89206518', '578963666545', '', 'Adony González Mendoza', '00000000', '2024-05-15 16:36:35', 2000.00, '2024051516363478023167264', '8023167264', '578963666545', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(73, 'FUNERARIA VALLE DE PAZ', '89206518', '599632541222', '', 'Denia Zamora Ruiz', '00000000', '2024-05-15 16:36:35', 5820.00, '2024051516363478010830202', '8010830202', '599632541222', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(74, 'FUNERARIA VALLE DE PAZ', '89206518', 'AB12502600036950012', '', 'Maria Carrillo', '00000000', '2024-05-15 16:36:35', 5820.00, '2024051516363478057671804', '8057671804', 'AB12502600036950012', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL),
	(75, 'FUNERARIA VALLE DE PAZ', '89206518', 'AB12502600036950012', '', 'Maria Carrillo', '00000000', '2024-05-15 16:36:35', 6500.00, '2024051516363478010236187', '8010236187', 'AB12502600036950012', 'No vinculado', 'Pago de prueba', 0, NULL, NULL, NULL, NULL, NULL);

