-- MySQL dump 10.13  Distrib 8.0.31, for Win64 (x86_64)
--
-- Host: 35.225.233.105    Database: 2017_2018
-- ------------------------------------------------------
-- Server version	5.7.44-google-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `operaciones`
--

DROP TABLE IF EXISTS `operaciones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `operaciones` (
  `tipodecarga` varchar(255) NOT NULL DEFAULT '',
  `cliente` varchar(255) NOT NULL DEFAULT '',
  `referencia` varchar(255) NOT NULL DEFAULT '',
  `blmaster` varchar(255) NOT NULL DEFAULT '',
  `lineanaviera` varchar(255) NOT NULL DEFAULT '',
  `buque` varchar(255) NOT NULL DEFAULT '',
  `peso_peligroso` varchar(255) NOT NULL DEFAULT '',
  `puertodestino` varchar(255) NOT NULL DEFAULT '',
  `agenteaduanal` varchar(255) NOT NULL DEFAULT '',
  `rebate` varchar(255) NOT NULL DEFAULT '',
  `demoras` varchar(255) NOT NULL DEFAULT '',
  `notas` varchar(255) NOT NULL DEFAULT '',
  `aaatencionde` varchar(255) NOT NULL DEFAULT '',
  `eta` varchar(255) NOT NULL DEFAULT '',
  `nocontenedores` varchar(255) NOT NULL DEFAULT '',
  `no_partidas_peligrosas` varchar(255) NOT NULL DEFAULT '',
  `puertoorigen` varchar(255) NOT NULL DEFAULT '',
  `agentedeorigen` varchar(255) NOT NULL DEFAULT '',
  `desconsolidacion1` varchar(255) NOT NULL DEFAULT '',
  `otros1` varchar(255) NOT NULL DEFAULT '',
  `profitfee` varchar(255) NOT NULL DEFAULT '',
  `no_oficio` varchar(255) NOT NULL DEFAULT '',
  `blhouse` varchar(255) NOT NULL DEFAULT '',
  `persona_de_contacto` varchar(255) NOT NULL DEFAULT '',
  `notify` varchar(255) NOT NULL DEFAULT '',
  `mercancia` varchar(255) NOT NULL DEFAULT '',
  `marcas` varchar(255) NOT NULL DEFAULT '',
  `liberarcontra` varchar(255) NOT NULL DEFAULT '',
  `fecha_de_notificacion` varchar(255) NOT NULL DEFAULT '',
  `notificara` varchar(255) NOT NULL DEFAULT '',
  `consignatario` varchar(255) NOT NULL DEFAULT '',
  `shipper` varchar(255) NOT NULL DEFAULT '',
  `nodepaquetes` varchar(255) NOT NULL DEFAULT '',
  `destinofinal` varchar(255) NOT NULL DEFAULT '',
  `revalidacionhbl` varchar(255) NOT NULL DEFAULT '',
  `marcas_resultantes` varchar(255) NOT NULL DEFAULT '',
  `nos_resultantes` varchar(255) NOT NULL DEFAULT '',
  `pesokgs` varchar(255) NOT NULL DEFAULT '',
  `volumenm3` varchar(255) NOT NULL DEFAULT '',
  `pesototalkgs` varchar(255) NOT NULL DEFAULT '',
  `volumentotalm3` varchar(255) NOT NULL DEFAULT '',
  `moneda` varchar(255) NOT NULL DEFAULT '',
  `liberacionenpuerto` varchar(255) NOT NULL DEFAULT '',
  `canjededocumentos` varchar(255) NOT NULL DEFAULT '',
  `desconsolidacion` varchar(255) NOT NULL DEFAULT '',
  `collectfee` varchar(255) NOT NULL DEFAULT '',
  `fletemaritimo` varchar(255) NOT NULL DEFAULT '',
  `transporte_terrestre` varchar(255) NOT NULL DEFAULT '',
  `otros2` varchar(255) NOT NULL DEFAULT '',
  `iva` varchar(255) NOT NULL DEFAULT '',
  `total1` varchar(255) NOT NULL DEFAULT '',
  `container_no` varchar(255) NOT NULL DEFAULT '',
  `seal_no` varchar(255) NOT NULL DEFAULT '',
  `POL` varchar(255) NOT NULL DEFAULT '',
  `POD` varchar(255) NOT NULL DEFAULT '',
  `servicios_CFS` varchar(255) NOT NULL DEFAULT '',
  `tarjas` varchar(255) NOT NULL DEFAULT '',
  `M_V` varchar(255) NOT NULL DEFAULT '',
  `arrival_date` varchar(255) NOT NULL DEFAULT '',
  `devaning_date` varchar(255) NOT NULL DEFAULT '',
  `no_bundles` varchar(255) NOT NULL DEFAULT '',
  `gross_weight` varchar(255) NOT NULL DEFAULT '',
  `B_L_nr` varchar(255) NOT NULL DEFAULT '',
  `desensamblado` varchar(255) NOT NULL DEFAULT '',
  `bultos_golpeados` varchar(255) NOT NULL DEFAULT '',
  `bultos_abiertos` varchar(255) NOT NULL DEFAULT '',
  `bultos_faltantes` varchar(255) NOT NULL DEFAULT '',
  `mercancia_rota` varchar(255) NOT NULL DEFAULT '',
  `otros3` varchar(255) NOT NULL DEFAULT '',
  `clientes2` varchar(255) NOT NULL DEFAULT '',
  `via` varchar(255) NOT NULL DEFAULT '',
  `peso_imo` varchar(255) NOT NULL DEFAULT '',
  `entrega_del_vacio` varchar(255) NOT NULL DEFAULT '',
  `patio_de_vacio` varchar(255) NOT NULL DEFAULT '',
  `comentarios` varchar(255) NOT NULL DEFAULT '',
  `lugardeorigen` varchar(255) NOT NULL DEFAULT '',
  `recargoimco` varchar(255) NOT NULL DEFAULT '',
  `creditocontado` varchar(255) NOT NULL DEFAULT '',
  `nocheque` varchar(255) NOT NULL DEFAULT '',
  `nombredelbanco` varchar(255) NOT NULL DEFAULT '',
  `fechadedeposito` varchar(255) NOT NULL DEFAULT '',
  `fletemaritimopagado` varchar(255) NOT NULL DEFAULT '',
  `liberarelbloriginal` varchar(255) NOT NULL DEFAULT '',
  `liberarelblcopia` varchar(255) NOT NULL DEFAULT '',
  `endosadoalaa` varchar(255) NOT NULL DEFAULT '',
  `facturamexico` varchar(255) NOT NULL DEFAULT '',
  `facturapuerto` varchar(255) NOT NULL DEFAULT '',
  `referencia2` varchar(255) NOT NULL DEFAULT '',
  `notificara2` varchar(255) NOT NULL DEFAULT '',
  `revalidacionhbl2` varchar(255) NOT NULL DEFAULT '',
  `nodepaquetes2` varchar(255) NOT NULL DEFAULT '',
  `cargapeligrosa` varchar(255) NOT NULL DEFAULT '',
  `fletemaritimo2` varchar(255) NOT NULL DEFAULT '',
  `total` varchar(255) NOT NULL DEFAULT '',
  `total2` varchar(255) NOT NULL DEFAULT '',
  `reporteaimprimir` varchar(255) NOT NULL DEFAULT '',
  `liberacionenpuerto2` varchar(255) NOT NULL DEFAULT '',
  `canjededocumentos2` varchar(255) NOT NULL DEFAULT '',
  `desconsolidacion2` varchar(255) NOT NULL DEFAULT '',
  `recargoimco2` varchar(255) NOT NULL DEFAULT '',
  `collectfee2` varchar(255) NOT NULL DEFAULT '',
  `otros4` varchar(255) NOT NULL DEFAULT '',
  `otros5` varchar(255) NOT NULL DEFAULT '',
  `fletemaritimopagado2` varchar(255) NOT NULL DEFAULT '',
  `fletemaritimoprepagado` varchar(255) NOT NULL DEFAULT '',
  `idcontenedor` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `operaciones`
--

LOCK TABLES `operaciones` WRITE;
/*!40000 ALTER TABLE `operaciones` DISABLE KEYS */;
INSERT INTO `operaciones` VALUES ('','','$txtreferencia','$txtblmaster','','','','','','','','','','','','','','','','','','','$txtblhouse','','','','','','','','','','','','','','','','','','','','$txtliberacionenpuerto','$txtcanjededocumentos','$txtdesconsolidacion','$txtcollectfee','','','','$txtiva','','','','','','','','','','','','','','','','','','','','','','','','','','','$txtrecargoimco','$txtcreditocontado','$txtnocheque','$txtnombredelbanco','$txtfechadedeposito','','','','','','','','','','','','','$txttotal','','$txtreporteaimprimir','$txtliberacionenpuerto2','$txtcanjededocumentos2','$txtdesconsolidacion2','$txtrecargoimco2','$txtcollectfee2','$txtotros4','$txtotros5','','$txtfletemaritimoprepagado',''),('','','','','','','','','','','','','','','','','','','fasdf','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),('','','','','','','','','','','','','','','','','','','','','','','x','','x','','x','x','','x','x','x','','x','','','','x','x','x','x','','x','x','x','x','','','x','x','','','','','','','','','','','','','','','','','','','','','','','','','','x','x','','','','','','','','','','','','','','x','','x','x','x','','','','','','','','','','','');
/*!40000 ALTER TABLE `operaciones` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-07-25 21:50:36
