
--
-- Table structure for table `pagos_producciones`
--

CREATE TABLE `pagos_producciones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `efectivo` float(19,2) NOT NULL,
  `cheque` float(19,2) NOT NULL,
  `tarjeta` float(19,2) NOT NULL,
  `monto` float(19,2) NOT NULL,
  `fecha` date NOT NULL,
  `hora` datetime NOT NULL,
  `numero_cheque` text NOT NULL,
  `usuario` text NOT NULL,
  `productor` text NOT NULL,
  `id_compra` int(11) NOT NULL,
  `folio` text NOT NULL,
  `secuencia` text NOT NULL,
  `folio_egreso` text NOT NULL,
  `estado_caja` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_german2_ci;

--
-- Dumping data for table `pagos_producciones`
--


--
-- Table structure for table `parametros`
--

CREATE TABLE `parametros` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `folio_ventas` int(11) NOT NULL,
  `folio_compra` int(11) NOT NULL,
  `folio_compra_factoria` int(11) NOT NULL,
  `folio_ingreso` int(11) NOT NULL,
  `folio_egreso` int(11) NOT NULL,
  `mostrar_menu_pos` int(11) NOT NULL,
  `default_menu_pos` text NOT NULL,
  `impuestos_no_incluido` int(11) NOT NULL,
  `moneda_local` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish2_ci;

--
-- Dumping data for table `parametros`
--

INSERT INTO `parametros` VALUES (1,0,0,0,0,0,0,'',0,''),(2,0,0,0,0,0,0,'complete',0,'');

--
-- Table structure for table `pedidos`
--

CREATE TABLE `pedidos` (
  `numero` int(11) NOT NULL AUTO_INCREMENT,
  `cliente` text NOT NULL,
  `telefono` text NOT NULL,
  `direccion` text NOT NULL,
  `correo` text NOT NULL,
  `fecha` date NOT NULL,
  `hora` text NOT NULL,
  `fecha_para_entregar` date NOT NULL,
  `estado` text NOT NULL,
  `procesos` int(11) NOT NULL,
  `recibida_por` text NOT NULL,
  `fecha_entregado` date NOT NULL,
  `fecha_recibido` date NOT NULL,
  `hora_recibido` text NOT NULL,
  `total` float(19,2) NOT NULL,
  `asignado_a` text NOT NULL,
  `nombre_logo` text NOT NULL,
  `fecha_anterior` date NOT NULL,
  `facturado` int(11) NOT NULL,
  `usuario` text NOT NULL,
  `grabado` int(11) NOT NULL,
  `id_cliemte` int(11) NOT NULL,
  `fecha_para_iniciar` date NOT NULL,
  `rnc` text NOT NULL,
  `total_costo` float(19,2) NOT NULL,
  PRIMARY KEY (`numero`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `pedidos`
--


--
-- Table structure for table `prestamos`
--

CREATE TABLE `prestamos` (
  `id_solicitud` int(11) NOT NULL,
  `fecha_prestamo` date NOT NULL,
  `monto_prestado` float(19,2) NOT NULL,
  `monto_desembolsado` float(19,2) NOT NULL,
  `balance` float(19,2) NOT NULL,
  `c_cuotas` int(11) NOT NULL,
  `tasa` float(19,2) NOT NULL,
  `tipo` text NOT NULL,
  `usuario` text NOT NULL,
  `estado_prestamo` text NOT NULL,
  `condicion_prestamo` text NOT NULL,
  `total` float(19,2) NOT NULL,
  `balance_capital` float(19,2) NOT NULL,
  `balance_interes` float(19,2) NOT NULL,
  `monto_cuota` float(19,2) NOT NULL,
  `capital_pagado` float(19,2) NOT NULL,
  `interes_pagado` float(19,2) NOT NULL,
  `mora_pagada` float(19,2) NOT NULL,
  `id_cliente` int(11) NOT NULL,
  `id_prestamo` int(11) NOT NULL AUTO_INCREMENT,
  `cantidad_aprobada` float(19,2) NOT NULL,
  `cartera` text NOT NULL,
  `cliente` text NOT NULL,
  `ruta` text NOT NULL,
  `cobrador` text NOT NULL,
  `creado_por` text NOT NULL,
  `hora` text NOT NULL,
  `cuenta` text NOT NULL,
  `estado_caja` text NOT NULL,
  PRIMARY KEY (`id_prestamo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish2_ci;

--
-- Dumping data for table `prestamos`
--


--
-- Table structure for table `procesos_pedidos`
--

CREATE TABLE `procesos_pedidos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `descripcion` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `procesos_pedidos`
--


--
-- Table structure for table `productos`
--

CREATE TABLE `productos` (
  `id_producto` int(11) NOT NULL AUTO_INCREMENT,
  `descripcion` text NOT NULL,
  `codigo` text NOT NULL,
  `costo` float(19,2) NOT NULL,
  `precio` float(19,2) NOT NULL,
  `proveedor` text NOT NULL,
  `stock` float(19,2) NOT NULL,
  `pxp` int(11) NOT NULL,
  `usuario` text DEFAULT NULL,
  `fecha` date DEFAULT NULL,
  `tipo_impuestos` varchar(25) NOT NULL,
  `valor_impuestos` float(19,2) NOT NULL,
  `variedad` text NOT NULL,
  `unidad` text NOT NULL,
  `relacion_detalle` varchar(25) NOT NULL,
  `precio2` float(19,2) NOT NULL,
  `color` text NOT NULL,
  `size` text NOT NULL,
  `marca` text NOT NULL,
  `tipo_producto` text NOT NULL,
  `precio3` float(19,2) NOT NULL,
  `precio4` float(19,2) NOT NULL,
  `tasa_venta` float(19,2) NOT NULL,
  PRIMARY KEY (`id_producto`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish2_ci;

--
-- Dumping data for table `productos`
--

INSERT INTO `productos` VALUES (1,'NATCOM','1',0.00,0.00,'null',0.00,0,NULL,NULL,'null',0.00,'null','UNIDAD','',0.00,'','','','Fisico',0.00,0.00,2.05),(2,'DIGICEL','2',0.00,2.30,'null',0.00,0,NULL,NULL,'null',0.00,'null','UNIDAD','',2.30,'','','','Fisico',0.00,0.00,2.05),(3,'OTROS','3',0.00,2.30,'null',0.00,0,NULL,NULL,'null',0.00,'null','UNIDAD','',2.30,'','','','Fisico',0.00,0.00,0.00),(6,'MONCASH','MONCASH',0.00,0.00,'null',0.00,0,NULL,NULL,'null',0.00,'null','null','',0.00,'','','','Fisico',0.00,0.00,0.00),(7,'NATCASH','NATCASH',94420.50,0.00,'null',95320.50,0,NULL,NULL,'null',0.00,'null','null','',0.00,'','','','Fisico',0.00,0.00,0.00);

--
-- Table structure for table `proveedores`
--

CREATE TABLE `proveedores` (
  `id_proveedor` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` text NOT NULL,
  `cedula` text NOT NULL,
  `telefono` text NOT NULL,
  `direccion` text NOT NULL,
  `tipo` text NOT NULL,
  PRIMARY KEY (`id_proveedor`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish2_ci;

--
-- Dumping data for table `proveedores`
--

INSERT INTO `proveedores` VALUES (1,'CHAROLI','','','','Suplidor'),(2,'CASA DE CAMBIO','','','','Suplidor'),(3,'MORELIA','','809-353-2351','DAJABON','null'),(4,'ROSA','','809-715-1132','SANTIAGO','Productor'),(5,'IVAN','','829-704-9191','SANTO DOMINGO','null'),(6,'MERY','','829-694-6066','PUERTO PLATA','null'),(7,'ANDREA','','809-677-8508','DAJABON','null'),(8,'DELIUS','','849-392-8792','DAJABON','null'),(9,'MONCASH','00','00','0','Suplidor'),(10,'NATCASH','OOOO','','','null'),(11,'MONCASH','','','','null');

--
-- Table structure for table `recargas`
--

CREATE TABLE `recargas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usuario` text NOT NULL,
  `telefono` text NOT NULL,
  `monto` float(19,2) NOT NULL,
  `moneda` text NOT NULL,
  `hora` text NOT NULL,
  `fecha` date NOT NULL,
  `estado` text NOT NULL,
  `actualizacion` text NOT NULL,
  `nota` text NOT NULL,
  `compania` text NOT NULL,
  `vendedor` text NOT NULL,
  `tipo` text NOT NULL,
  `comision_remesa` float(19,2) NOT NULL,
  `beneficio` float(19,2) NOT NULL,
  `recibe` double(9,2) NOT NULL,
  `comision_remesa_gourde` double NOT NULL,
  `total` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `recargas`
--

INSERT INTO `recargas` VALUES (1,'valestin','Directo',1000.00,'PESOS','07:55:51','2026-07-08','Anulada','Venta declinada por anulacion de factura','','natcash','JAYSON','Remesa',0.00,0.00,2000.00,0,0),(2,'valestin','Directo',2000.00,'PESOS','09:45:18','2026-07-08','Realizada','','','natcash','RODNEY','Remesa',0.00,0.00,4100.00,0,0),(3,'valestin','Directo',1000.00,'PESOS','08:57:27','2026-07-09','Realizada','','','natcash','JAYSON','Remesa',0.00,0.00,2100.00,0,0),(4,'valestin','Directo',4000.00,'PESOS','08:58:22','2026-07-09','Realizada','','','natcash','JAYSON','Remesa',0.00,0.00,8400.00,0,0),(5,'valestin','Directo',1000.00,'PESOS','08:58:50','2026-07-09','Realizada','','','natcash','JAYSON','Remesa',0.00,0.00,2100.00,0,0),(6,'valestin','Directo',1000.00,'PESOS','08:59:17','2026-07-09','Realizada','','','natcash','JAYSON','Remesa',0.00,0.00,2100.00,0,0),(7,'valestin','Directo',1500.00,'PESOS','08:59:39','2026-07-09','Realizada','','','natcash','JAYSON','Remesa',0.00,0.00,3150.00,0,0),(8,'valestin','Directo',500.00,'PESOS','09:00:08','2026-07-09','Realizada','','','natcash','JAYSON','Remesa',0.00,0.00,1025.00,0,0),(9,'valestin','Directo',1000.00,'PESOS','09:02:40','2026-07-09','Realizada','','','natcash','RODNEY','Remesa',0.00,0.00,2050.00,0,0),(10,'valestin','Directo',2450.00,'PESOS','09:33:48','2026-07-09','Realizada','','','natcash','TOPDO','Remesa',0.00,0.00,5022.50,0,0);

--
-- Table structure for table `recibos`
--

CREATE TABLE `recibos` (
  `id_recibo` int(11) NOT NULL AUTO_INCREMENT,
  `datos` text NOT NULL,
  `cliente` text NOT NULL,
  `usuario` text NOT NULL,
  `monto` float(19,2) NOT NULL,
  `fecha` date NOT NULL,
  PRIMARY KEY (`id_recibo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish2_ci;

--
-- Dumping data for table `recibos`
--


--
-- Table structure for table `rentas`
--

CREATE TABLE `rentas` (
  `idrentas` int(11) NOT NULL AUTO_INCREMENT,
  `fecha` date NOT NULL,
  `id_cliente` int(11) NOT NULL,
  `cliente` text NOT NULL,
  `monto` float(19,2) NOT NULL,
  `pagado` float(19,2) NOT NULL,
  `balance` float(19,2) NOT NULL,
  `vence` date NOT NULL,
  `estado` varchar(45) NOT NULL,
  PRIMARY KEY (`idrentas`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish2_ci;

--
-- Dumping data for table `rentas`
--


--
-- Table structure for table `rutas`
--

CREATE TABLE `rutas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` text NOT NULL,
  `zona` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish2_ci;

--
-- Dumping data for table `rutas`
--

INSERT INTO `rutas` VALUES (1,'punta cana','verron1'),(2,'VOLTAIRE','LAS VEGAS');

--
-- Table structure for table `rutas_cobrador`
--

CREATE TABLE `rutas_cobrador` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ruta` text NOT NULL,
  `cobrador` text NOT NULL,
  `zona` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `rutas_cobrador`
--

INSERT INTO `rutas_cobrador` VALUES (1,'punta cana','williams','verron1');

--
-- Table structure for table `tasas`
--

CREATE TABLE `tasas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `compra` float(19,2) NOT NULL,
  `venta` float(19,2) NOT NULL,
  `moneda` text NOT NULL,
  `remesa` float(19,2) NOT NULL,
  `ganancia` float(19,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `tasas`
--

INSERT INTO `tasas` VALUES (1,2.25,2.05,'GOURDE',2.05,0.00);

--
-- Table structure for table `tasas2`
--

CREATE TABLE `tasas2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `compra` float(19,2) NOT NULL,
  `venta` float(19,2) NOT NULL,
  `moneda` text NOT NULL,
  `remesa` float(19,2) NOT NULL,
  `ganancia` float(19,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `tasas2`
--

INSERT INTO `tasas2` VALUES (1,2.23,2.18,'GOURDE',2.05,0.00),(2,59.70,60.60,'DOLAR',0.00,0.00);

--
-- Table structure for table `transferencias_almacen`
--

CREATE TABLE `transferencias_almacen` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fecha` date NOT NULL,
  `hora` datetime NOT NULL,
  `mercancia` text NOT NULL,
  `desde` text NOT NULL,
  `hasta` text NOT NULL,
  `cantidad` float(19,2) NOT NULL,
  `usuario` text NOT NULL,
  `estado` text NOT NULL,
  `enviada_por` text NOT NULL,
  `hora_enviada` text NOT NULL,
  `fecha_enviada` date NOT NULL,
  `fecha_recibida` date NOT NULL,
  `hora_recibida` text NOT NULL,
  `recibida_por` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_german2_ci;

--
-- Dumping data for table `transferencias_almacen`
--


--
-- Table structure for table `variedad_productos`
--

CREATE TABLE `variedad_productos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `variedad` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_german2_ci;

--
-- Dumping data for table `variedad_productos`
--


--
-- Table structure for table `vencimiento`
--

CREATE TABLE `vencimiento` (
  `lote` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` text NOT NULL,
  `descripcion` text NOT NULL,
  `cantidad` float(19,2) NOT NULL,
  `fecha` date NOT NULL,
  `suplidor` text NOT NULL,
  `estatus` text NOT NULL,
  PRIMARY KEY (`lote`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vencimiento`
--


--
-- Table structure for table `ventas`
--

CREATE TABLE `ventas` (
  `id_venta` int(11) NOT NULL AUTO_INCREMENT,
  `fecha` date NOT NULL,
  `hora` varchar(200) NOT NULL,
  `cliente` varchar(200) NOT NULL,
  `costo` float(19,2) NOT NULL,
  `precio` float(19,2) NOT NULL,
  `impuesto` float(19,2) NOT NULL,
  `impuesto_10` float(19,2) NOT NULL,
  `impuesto_13` float(19,2) NOT NULL,
  `impuesto_16` float(19,2) NOT NULL,
  `impuesto_exento` float(19,2) NOT NULL,
  `descuento` float(19,2) NOT NULL,
  `total` float(19,2) NOT NULL,
  `pagado` float(19,2) NOT NULL,
  `balance` float(19,2) NOT NULL,
  `usuario` varchar(200) NOT NULL,
  `folio` varchar(200) NOT NULL,
  `termino` varchar(200) NOT NULL,
  `pago_con` float(19,2) NOT NULL,
  `devuelta` float(19,2) NOT NULL,
  `ncf` varchar(200) NOT NULL,
  `tipo_ncf` varchar(200) NOT NULL,
  `nota` varchar(200) NOT NULL,
  `secuencia` varchar(200) NOT NULL,
  `fecha_pago` date NOT NULL,
  `concepto` varchar(200) NOT NULL,
  `cheque` float NOT NULL,
  `efectivo` float NOT NULL,
  `monto_tarjeta` double(19,2) NOT NULL,
  `referencia_tarjeta` varchar(200) NOT NULL,
  `numero_cheque` varchar(200) NOT NULL,
  `estado` varchar(200) NOT NULL,
  `ticket` varchar(200) NOT NULL,
  `caja` varchar(200) NOT NULL,
  `usuario_anula` varchar(25) NOT NULL,
  `fecha_anula` date NOT NULL,
  `hora_anula` text NOT NULL,
  `numero_pedido` int(11) NOT NULL,
  `vendedor` text NOT NULL,
  `motivo_anulacion` text NOT NULL,
  `vence` date DEFAULT NULL,
  `estado_caja` text NOT NULL,
  `producto` text NOT NULL,
  `moneda_origen` text NOT NULL,
  `tasa_moneda_origen` float(19,2) NOT NULL,
  `ganancias` float(19,2) NOT NULL,
  `tasa_compra` float(19,2) NOT NULL,
  `recarga` text NOT NULL,
  `total_gourde` double NOT NULL,
  `moneda` text NOT NULL,
  `ganancia` double NOT NULL,
  `inversion` double NOT NULL,
  `tasa` double DEFAULT NULL,
  `tasa_venta` double DEFAULT NULL,
  `pagado_pesos` double DEFAULT NULL,
  PRIMARY KEY (`id_venta`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish2_ci;

--
-- Dumping data for table `ventas`
--

INSERT INTO `ventas` VALUES (1,'2026-07-08','19:56:08','JAYSON',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'valestin','','Credito',0.00,0.00,'','','Venta anulada','','0000-00-00','Venta',0,0,0.00,'','','Anulada','Venta: 1 - Ticket-->N/A','','valestin','2026-07-08','07:58:00',0,'','ERROR ENVIO',NULL,'','natcash','',0.00,0.00,2.20,'1',0,'PESOS',0,0,NULL,2,NULL),(2,'2026-07-08','09:41:16','RODNEY',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,8250.00,0.00,8250.00,'','','Credito',0.00,0.00,'','','','','0000-00-00','',0,0,0.00,'','','','Venta: 2 - Ticket-->N/A','','','0000-00-00','',0,'','',NULL,'','Efectivo','',0.00,0.00,2.25,'',0,'PESOS',733.3333333333347,0,NULL,2.05,0),(3,'2026-07-08','09:44:46','JAYSON',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,52670.00,0.00,52670.00,'','','Credito',0.00,0.00,'','','','','0000-00-00','',0,0,0.00,'','','','Venta: 3 - Ticket-->N/A','','','0000-00-00','',0,'','',NULL,'','Efectivo','',0.00,0.00,2.25,'',0,'PESOS',3511.3333333333317,0,NULL,2.1,0),(4,'2026-07-08','21:45:39','RODNEY',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,2000.00,0.00,2000.00,'valestin','','Credito',0.00,0.00,'','','','','0000-00-00','Venta',0,0,0.00,'','','Cerrada','Venta: 4 - Ticket-->N/A','','','0000-00-00','',0,'','',NULL,'','natcash','',0.00,0.00,2.25,'2',0,'PESOS',177.77777777777797,0,NULL,2.05,NULL),(5,'2026-07-08','09:51:50','CHEVANA',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,38450.00,0.00,38450.00,'','','Credito',0.00,0.00,'','','','','0000-00-00','',0,0,0.00,'','','','Venta: 5 - Ticket-->N/A','','','0000-00-00','',0,'','',NULL,'','Efectivo','',0.00,0.00,2.25,'',0,'PESOS',3417.777777777774,0,NULL,2.05,0),(6,'2026-07-08','09:56:14','SIMILIEN',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1000.00,0.00,1000.00,'','','Credito',0.00,0.00,'','','','','0000-00-00','',0,0,0.00,'','','','Venta: 6 - Ticket-->N/A','','','0000-00-00','',0,'','',NULL,'','Efectivo','',0.00,0.00,2.25,'',0,'PESOS',88.88888888888899,0,NULL,2.05,0),(7,'2026-07-08','09:57:43','TOPDO',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,11750.00,0.00,11750.00,'','','Credito',0.00,0.00,'','','','','0000-00-00','',0,0,0.00,'','','','Venta: 7 - Ticket-->N/A','','','0000-00-00','',0,'','',NULL,'','Efectivo','',0.00,0.00,2.25,'',0,'PESOS',1044.4444444444441,0,NULL,2.05,0),(8,'2026-07-08','10:04:22','PATRON ARAB',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,13840.00,0.00,13840.00,'','','Credito',0.00,0.00,'','','','','0000-00-00','',0,0,0.00,'','','','Venta: 8 - Ticket-->N/A','','','0000-00-00','',0,'','',NULL,'','Efectivo','',0.00,0.00,2.25,'',0,'PESOS',1230.222222222223,0,NULL,2.05,0),(9,'2026-07-09','20:58:21','JAYSON',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1000.00,0.00,1000.00,'valestin','','Credito',0.00,0.00,'','','','','0000-00-00','Venta',0,0,0.00,'','','Cerrada','Venta: 9 - Ticket-->N/A','','','0000-00-00','',0,'','',NULL,'','natcash','',0.00,0.00,2.25,'3',0,'PESOS',88.88888888888899,0,NULL,2.05,NULL),(10,'2026-07-09','20:58:49','JAYSON',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,4000.00,0.00,4000.00,'valestin','','Credito',0.00,0.00,'','','','','0000-00-00','Venta',0,0,0.00,'','','Cerrada','Venta: 10 - Ticket-->N/A','','','0000-00-00','',0,'','',NULL,'','natcash','',0.00,0.00,2.25,'4',0,'PESOS',355.55555555555594,0,NULL,2.05,NULL),(11,'2026-07-09','20:59:17','JAYSON',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1000.00,0.00,1000.00,'valestin','','Credito',0.00,0.00,'','','','','0000-00-00','Venta',0,0,0.00,'','','Cerrada','Venta: 11 - Ticket-->N/A','','','0000-00-00','',0,'','',NULL,'','natcash','',0.00,0.00,2.25,'5',0,'PESOS',88.88888888888899,0,NULL,2.05,NULL),(12,'2026-07-09','20:59:37','JAYSON',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1000.00,0.00,1000.00,'valestin','','Credito',0.00,0.00,'','','','','0000-00-00','Venta',0,0,0.00,'','','Cerrada','Venta: 12 - Ticket-->N/A','','','0000-00-00','',0,'','',NULL,'','natcash','',0.00,0.00,2.25,'6',0,'PESOS',88.88888888888899,0,NULL,2.05,NULL),(13,'2026-07-09','21:00:08','JAYSON',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1500.00,0.00,1500.00,'valestin','','Credito',0.00,0.00,'','','','','0000-00-00','Venta',0,0,0.00,'','','Cerrada','Venta: 13 - Ticket-->N/A','','','0000-00-00','',0,'','',NULL,'','natcash','',0.00,0.00,2.25,'7',0,'PESOS',133.33333333333348,0,NULL,2.05,NULL),(14,'2026-07-09','21:00:47','JAYSON',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,500.00,0.00,500.00,'valestin','','Credito',0.00,0.00,'','','','','0000-00-00','Venta',0,0,0.00,'','','Cerrada','Venta: 14 - Ticket-->N/A','','','0000-00-00','',0,'','',NULL,'','natcash','',0.00,0.00,2.25,'8',0,'PESOS',44.44444444444449,0,NULL,2.05,NULL),(15,'2026-07-09','21:03:09','RODNEY',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1000.00,0.00,1000.00,'valestin','','Credito',0.00,0.00,'','','','','0000-00-00','Venta',0,0,0.00,'','','Cerrada','Venta: 15 - Ticket-->N/A','','','0000-00-00','',0,'','',NULL,'','natcash','',0.00,0.00,2.25,'9',0,'PESOS',88.88888888888899,0,NULL,2.05,NULL),(16,'2026-07-09','21:34:09','TOPDO',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,2450.00,0.00,2450.00,'valestin','','Credito',0.00,0.00,'','','','','0000-00-00','Venta',0,0,0.00,'','','Cerrada','Venta: 16 - Ticket-->N/A','','','0000-00-00','',0,'','',NULL,'','natcash','',0.00,0.00,2.25,'10',0,'PESOS',0,0,NULL,2.05,NULL);


