-- Table structure for table `llxqa_propaldet_extrafields`
--

CREATE TABLE `llxqa_propaldet_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_propaldet_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_propaldet_extrafields`
--


--
-- Table structure for table `llxqa_reception`
--

CREATE TABLE `llxqa_reception` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `ref` varchar(30) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `fk_soc` int(11) NOT NULL,
  `fk_projet` int(11) DEFAULT NULL,
  `ref_ext` varchar(30) DEFAULT NULL,
  `ref_int` varchar(30) DEFAULT NULL,
  `ref_supplier` varchar(30) DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `date_delivery` datetime DEFAULT NULL,
  `date_reception` datetime DEFAULT NULL,
  `fk_shipping_method` int(11) DEFAULT NULL,
  `tracking_number` varchar(50) DEFAULT NULL,
  `fk_statut` smallint(6) DEFAULT 0,
  `billed` smallint(6) DEFAULT 0,
  `height` float DEFAULT NULL,
  `width` float DEFAULT NULL,
  `size_units` int(11) DEFAULT NULL,
  `size` float DEFAULT NULL,
  `weight_units` int(11) DEFAULT NULL,
  `weight` float DEFAULT NULL,
  `note_private` text DEFAULT NULL,
  `note_public` text DEFAULT NULL,
  `model_pdf` varchar(255) DEFAULT NULL,
  `fk_incoterms` int(11) DEFAULT NULL,
  `location_incoterms` varchar(255) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `idx_reception_uk_ref` (`ref`,`entity`),
  KEY `idx_reception_fk_soc` (`fk_soc`),
  KEY `idx_reception_fk_user_author` (`fk_user_author`),
  KEY `idx_reception_fk_user_valid` (`fk_user_valid`),
  KEY `idx_reception_fk_shipping_method` (`fk_shipping_method`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `llxqa_reception`
--


--
-- Table structure for table `llxqa_reception_extrafields`
--

CREATE TABLE `llxqa_reception_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_reception_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `llxqa_reception_extrafields`
--


--
-- Table structure for table `llxqa_resource`
--

CREATE TABLE `llxqa_resource` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `ref` varchar(255) DEFAULT NULL,
  `asset_number` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `fk_code_type_resource` varchar(32) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `fk_statut` smallint(6) NOT NULL DEFAULT 0,
  `note_public` text DEFAULT NULL,
  `note_private` text DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  `fk_country` int(11) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_resource_ref` (`ref`,`entity`),
  KEY `fk_code_type_resource_idx` (`fk_code_type_resource`),
  KEY `idx_resource_fk_country` (`fk_country`),
  CONSTRAINT `fk_resource_fk_country` FOREIGN KEY (`fk_country`) REFERENCES `llxqa_c_country` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_resource`
--


--
-- Table structure for table `llxqa_resource_extrafields`
--

CREATE TABLE `llxqa_resource_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_resource_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_resource_extrafields`
--


--
-- Table structure for table `llxqa_rights_def`
--

CREATE TABLE `llxqa_rights_def` (
  `id` int(11) NOT NULL,
  `libelle` varchar(255) DEFAULT NULL,
  `module` varchar(64) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `perms` varchar(50) DEFAULT NULL,
  `subperms` varchar(50) DEFAULT NULL,
  `type` varchar(1) DEFAULT NULL,
  `bydefault` tinyint(4) DEFAULT 0,
  `module_position` int(11) NOT NULL DEFAULT 0,
  `family_position` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_rights_def`
--



--
-- Table structure for table `llxqa_societe`
--

CREATE TABLE `llxqa_societe` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(128) DEFAULT NULL,
  `name_alias` varchar(128) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `ref_ext` varchar(255) DEFAULT NULL,
  `ref_int` varchar(255) DEFAULT NULL,
  `statut` tinyint(4) DEFAULT 0,
  `parent` int(11) DEFAULT NULL,
  `status` tinyint(4) DEFAULT 1,
  `code_client` varchar(24) DEFAULT NULL,
  `code_fournisseur` varchar(24) DEFAULT NULL,
  `code_compta` varchar(24) DEFAULT NULL,
  `code_compta_fournisseur` varchar(24) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `zip` varchar(25) DEFAULT NULL,
  `town` varchar(50) DEFAULT NULL,
  `fk_departement` int(11) DEFAULT 0,
  `fk_pays` int(11) DEFAULT 0,
  `fk_account` int(11) DEFAULT 0,
  `phone` varchar(20) DEFAULT NULL,
  `fax` varchar(20) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `email` varchar(128) DEFAULT NULL,
  `socialnetworks` text DEFAULT NULL,
  `skype` varchar(255) DEFAULT NULL,
  `whatsapp` varchar(255) DEFAULT NULL,
  `linkedin` varchar(255) DEFAULT NULL,
  `youtube` varchar(255) DEFAULT NULL,
  `googleplus` varchar(255) DEFAULT NULL,
  `snapchat` varchar(255) DEFAULT NULL,
  `instagram` varchar(255) DEFAULT NULL,
  `facebook` varchar(255) DEFAULT NULL,
  `twitter` varchar(255) DEFAULT NULL,
  `fk_effectif` int(11) DEFAULT 0,
  `fk_typent` int(11) DEFAULT 0,
  `fk_forme_juridique` int(11) DEFAULT 0,
  `fk_currency` varchar(3) DEFAULT NULL,
  `siren` varchar(128) DEFAULT NULL,
  `siret` varchar(128) DEFAULT NULL,
  `ape` varchar(128) DEFAULT NULL,
  `idprof4` varchar(128) DEFAULT NULL,
  `idprof5` varchar(128) DEFAULT NULL,
  `idprof6` varchar(128) DEFAULT NULL,
  `tva_intra` varchar(20) DEFAULT NULL,
  `capital` double(24,8) DEFAULT NULL,
  `fk_stcomm` int(11) NOT NULL DEFAULT 0,
  `note_private` text DEFAULT NULL,
  `note_public` text DEFAULT NULL,
  `model_pdf` varchar(255) DEFAULT NULL,
  `prefix_comm` varchar(5) DEFAULT NULL,
  `client` tinyint(4) DEFAULT 0,
  `fournisseur` tinyint(4) DEFAULT 0,
  `supplier_account` varchar(32) DEFAULT NULL,
  `fk_prospectlevel` varchar(12) DEFAULT NULL,
  `fk_incoterms` int(11) DEFAULT NULL,
  `location_incoterms` varchar(255) DEFAULT NULL,
  `customer_bad` tinyint(4) DEFAULT 0,
  `customer_rate` double DEFAULT 0,
  `supplier_rate` double DEFAULT 0,
  `remise_client` double DEFAULT 0,
  `remise_supplier` double DEFAULT 0,
  `mode_reglement` tinyint(4) DEFAULT NULL,
  `cond_reglement` tinyint(4) DEFAULT NULL,
  `mode_reglement_supplier` tinyint(4) DEFAULT NULL,
  `cond_reglement_supplier` tinyint(4) DEFAULT NULL,
  `fk_shipping_method` int(11) DEFAULT NULL,
  `tva_assuj` tinyint(4) DEFAULT 1,
  `localtax1_assuj` tinyint(4) DEFAULT 0,
  `localtax1_value` double(6,3) DEFAULT NULL,
  `localtax2_assuj` tinyint(4) DEFAULT 0,
  `localtax2_value` double(6,3) DEFAULT NULL,
  `barcode` varchar(180) DEFAULT NULL,
  `fk_barcode_type` int(11) DEFAULT 0,
  `price_level` int(11) DEFAULT NULL,
  `outstanding_limit` double(24,8) DEFAULT NULL,
  `order_min_amount` double(24,8) DEFAULT NULL,
  `supplier_order_min_amount` double(24,8) DEFAULT NULL,
  `default_lang` varchar(6) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `canvas` varchar(32) DEFAULT NULL,
  `fk_entrepot` int(11) DEFAULT 0,
  `webservices_url` varchar(255) DEFAULT NULL,
  `webservices_key` varchar(128) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `datec` datetime DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `logo_squarred` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_societe_prefix_comm` (`prefix_comm`,`entity`),
  UNIQUE KEY `uk_societe_code_client` (`code_client`,`entity`),
  UNIQUE KEY `uk_societe_code_fournisseur` (`code_fournisseur`,`entity`),
  UNIQUE KEY `uk_societe_barcode` (`barcode`,`fk_barcode_type`,`entity`),
  KEY `idx_societe_user_creat` (`fk_user_creat`),
  KEY `idx_societe_user_modif` (`fk_user_modif`)
) ENGINE=InnoDB AUTO_INCREMENT=242 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_societe`
--

INSERT INTO `llxqa_societe` VALUES (79,'Gregor Beck','Gregor Beck',1,NULL,NULL,0,NULL,1,'CU1811-0001',NULL,NULL,NULL,'',NULL,'Montevideo',0,229,0,'+598-94-143663',NULL,NULL,'gregor.beck@ligana.ch',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-11-27 19:05:45','2018-11-12 14:23:38',1,1,2,'USD',NULL,NULL),(80,'Ales S.A.','Casa Rica - España',1,NULL,NULL,0,NULL,1,'CU1811-0002',NULL,NULL,NULL,'Avda. España y Dr. Bestard',NULL,'Asuncion',0,180,0,'+595-21-607937',NULL,'www.casarica.com.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,101,NULL,'','','','','','','80003296-9',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,'images.jpg',NULL,0,NULL,NULL,'2018-11-27 19:04:48','2018-11-23 12:34:08',2,1,1,'PYG',NULL,NULL),(81,'Ales S.A.','Casa Rica - Molas Lopez',1,NULL,NULL,0,NULL,1,'CU1811-0003',NULL,NULL,NULL,'Avda. Dr. Felipe Molas López & Jasy',NULL,'Asuncion',0,180,0,'+595-21-607937',NULL,'www.casarica.com.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,101,NULL,'','','','','','','80003296-9',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,'images.jpg',NULL,0,NULL,NULL,'2018-11-27 19:02:24','2018-11-23 13:01:24',2,1,1,'PYG',NULL,NULL),(82,'4 Marchantes S.A.','La Marchante',1,NULL,NULL,0,NULL,1,'CU1811-0004',NULL,NULL,NULL,'Nuestra Señora del Carmen esq. Augusto Roa Bastos',NULL,'Asuncion',0,180,0,'+595-21-661075',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,101,NULL,'','','','','','','80091333-7',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,'la marchante logo.jpg',NULL,0,NULL,NULL,'2018-11-27 19:01:39','2018-11-23 13:08:55',2,1,1,'PYG',NULL,NULL),(83,'Don Pablo S.A.','Don Pablo',1,NULL,NULL,0,NULL,1,'CU1811-0005',NULL,NULL,NULL,'Mariscal Lopez esq. Yegros',NULL,'Aregua',0,180,0,'+595-29-1433137',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,101,NULL,'','','','','','','80033141-9',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-11-27 19:02:53','2018-11-23 13:09:57',2,1,1,'PYG',NULL,NULL),(84,'Monalisa S.R.L.','Monalisa - Asuncion',1,NULL,NULL,0,NULL,1,'CU1811-0006',NULL,NULL,NULL,'Santa Teresa c/ Aviadores del Chaco',NULL,'Asuncion',0,180,0,'+595-21-695555',NULL,'www.monalisa.com.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,102,NULL,'','','','','','','80002783-3',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,'Monalisa logo.jpg',NULL,0,NULL,NULL,'2018-11-27 19:03:36','2018-11-23 13:30:35',2,1,1,'PYG',NULL,NULL),(85,'Pro Performance S.R.L.','Pro Performance',1,NULL,NULL,0,NULL,1,'CU1811-0007',NULL,NULL,NULL,'Calle Central 100 casi Artigas',NULL,'Asuncion',0,180,0,'+595-21-292182',NULL,'www.properformancesrl.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,102,NULL,'','','','','','','80072923-4',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-12-04 17:58:16','2018-11-23 13:40:24',2,1,1,'PYG',NULL,NULL),(86,'Shopping Queen Anne','Shopping Queen Anne',1,NULL,NULL,0,NULL,1,'CU1811-0008',NULL,NULL,NULL,'Av. Paraguay',NULL,'Salto del Guairá',0,180,0,'+595-046-243133',NULL,'www.shoppingqueenanne.com','contato@shoppingqueenanne.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-11-27 13:41:45','2018-11-27 13:41:45',1,1,1,'PYG',NULL,NULL),(87,'Planet Outlet','Planet Outlet',1,NULL,NULL,0,NULL,1,'CU1811-0009',NULL,NULL,NULL,'Av. Internacional 7777',NULL,'Pedro Juan Caballero',0,180,0,'+595-336-271912',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,'','','','','','','',NULL,0,'part of Shopping China',NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-11-27 19:00:44','2018-11-27 16:32:01',1,1,1,'PYG',NULL,NULL),(88,'Studio Center','Studio Center',1,NULL,NULL,0,NULL,1,'CU1811-0010',NULL,NULL,NULL,'Av. Dr. Francia 1660',NULL,'Pedro Juan Caballero',0,180,0,'595(336)272121',NULL,'www.studiocenter.com.py','atendimento@studiocenter.com.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-11-27 19:08:25','2018-11-27 19:08:25',1,1,1,'PYG',NULL,NULL),(89,'Megashopping','Megashopping',1,NULL,NULL,0,NULL,1,'CU1811-0011',NULL,NULL,NULL,'Avda. Dr. Luis Maria Argaña',NULL,'Ciudad del Este',0,180,0,'+595-61-505411-415',NULL,'www.megashopping.com.py','contato@megashopping.com.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-11-27 19:27:29','2018-11-27 19:27:29',1,1,1,'PYG',NULL,NULL),(90,'Cellshop','Cellshop',1,NULL,NULL,0,NULL,1,'CU1811-0012',NULL,NULL,NULL,'',NULL,'Ciudad del Este',0,180,0,'+59561501474',NULL,'www.http://compras.cellshop.com.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-11-27 19:46:53','2018-11-27 19:46:53',1,1,1,'PYG',NULL,NULL),(91,'La Petisquera','La Petisquera',1,NULL,NULL,0,NULL,1,'CU1811-0013',NULL,NULL,NULL,'',NULL,'Ciudad del Este',0,180,0,'595-61-510445',NULL,'www.lapetisquera.com.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-17 19:46:41','2018-11-27 19:49:48',1,1,1,'PYG',NULL,NULL),(92,'Shopping China','Shopping China',1,NULL,NULL,0,NULL,1,'CU1811-0014',NULL,NULL,NULL,'',NULL,'Pedro Juan Caballero',0,180,0,NULL,NULL,'www.shoppingchina.com.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-03-11 11:41:23','2018-11-27 19:59:04',1,2,1,'PYG',NULL,NULL),(93,'CAFSA S.A.','Arete - Lambare',1,NULL,NULL,0,NULL,1,'CU1811-0015',NULL,NULL,NULL,'Cacique Lambaré c/ Justo Pastor Benitez',NULL,'Lambare',0,180,0,NULL,NULL,'arete.com.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,101,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-04-04 14:50:05','2018-11-28 16:55:51',2,2,1,'PYG',NULL,NULL),(94,'Todo Carne S.A.','Los Jardines',1,NULL,NULL,0,NULL,1,'CU1811-0016',NULL,NULL,NULL,'Avda. Gral. Aquino esq. Tte. Rivas',NULL,'Luque',0,180,0,'021650250',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,101,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-02-07 16:28:08','2018-11-28 17:00:44',2,2,1,'PYG',NULL,NULL),(95,'Biggie S.A.','Biggie Express',1,NULL,NULL,0,NULL,1,'CU1811-0017',NULL,NULL,NULL,'Federación Rusa y Nstra. Sra. Del Carmen',NULL,'Asuncion',0,180,2,'+595-21-615257',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,101,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,2,2,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-12-24 18:03:00','2018-11-28 17:09:55',2,1,1,'PYG',NULL,NULL),(96,'Retail S.A.','Retail',1,NULL,NULL,0,NULL,1,'CU1811-0018',NULL,NULL,NULL,'Tte 1º Sindulfo Casco',NULL,'Asuncion',0,180,0,'0214198500',NULL,'www.superseis.com.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,101,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-15 11:38:10','2018-11-28 17:26:28',2,2,1,'PYG',NULL,NULL),(98,'Grupo LBDM S.A.','La  Bodega del Mundo',1,NULL,NULL,0,NULL,1,'CU1811-0020',NULL,NULL,NULL,'Av. Brasilia 786 casi Fray Luis de Granada',NULL,'Asuncion',0,180,0,'+595-21-622860',NULL,NULL,'labodegadelmundo@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,101,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-15 16:04:28','2018-11-28 18:25:56',2,1,1,'PYG',NULL,NULL),(99,'Premium Unlimited S.A.','Bodega Boutique',1,NULL,NULL,0,NULL,1,'CU1811-0021',NULL,NULL,NULL,'Avda. España 575 c/ Dr. Bestard',NULL,'Asuncion',0,180,0,'+595-21-602996',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,101,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-08-26 13:30:45','2018-11-29 11:23:02',2,2,1,'PYG',NULL,NULL),(100,'La caoba show room S.R.L.','La Caoba',1,NULL,NULL,0,NULL,1,'CU1811-0022',NULL,NULL,NULL,'Quesada - Shopping Mariscal',NULL,'Asuncion',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,102,NULL,'','','','','','','80099111-7',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-07-18 12:47:30','2018-11-29 11:57:59',2,2,1,'PYG',NULL,NULL),(101,'Imperix S.A.','Mega Super',1,NULL,NULL,0,NULL,1,'CU1811-0023',NULL,NULL,NULL,'Avenida del Yacht entre Onofre Gomez y Manuel Gondra',NULL,'Lambare',0,180,0,'0986129090',NULL,'www.megasuper.com.py','megasupergroup@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,101,NULL,'','','','','','','80080219-5',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-24 12:24:24','2018-11-29 12:01:07',2,2,1,'PYG',NULL,NULL),(102,'Nunciata','Nunciata Emporio Gourmet',1,NULL,NULL,0,NULL,1,'CU1811-0024',NULL,NULL,NULL,'Senador Long c/ Teniente Vera',NULL,'Asuncion',0,180,0,'+595-985846324',NULL,'www.nunciata.com.py','ventas@nunciata.com.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-12-21 19:03:57','2018-11-29 12:05:53',2,2,1,'PYG',NULL,NULL),(103,'Salemma','Salemma Supermercados',1,NULL,NULL,0,NULL,1,'CU1811-0025',NULL,NULL,NULL,'Mariscal Estigarribia  2160',NULL,'San Lorenzo',0,180,0,'+595-21-505686',NULL,'www.salemmaonline.com.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-12-04 18:26:50','2018-11-29 12:09:43',2,1,1,'PYG',NULL,NULL),(104,'Galpon Criollo','Galpon Criollo',1,NULL,NULL,0,NULL,1,'CU1811-0026',NULL,NULL,NULL,'Rca. Argentina c/ Isaac Kostianovsky',NULL,'Asuncion',0,180,0,'021606128',NULL,'www.galponcriollo.com.py/','contacto@galponcriollo.com.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,236,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-11-29 12:13:01','2018-11-29 12:13:01',2,2,1,'PYG',NULL,NULL),(105,'Vari S.R.L.','Bodega Tuichaite - Trinidad',1,NULL,NULL,0,NULL,1,'CU1811-0027',NULL,NULL,NULL,'Avda. Santisima Trinidad esq. Ramon Zubizarreta',NULL,'Asuncion',0,180,0,'+595-21-226214',NULL,'www.tuichaite.com','tuichaite@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,102,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-12-04 19:43:13','2018-11-29 19:32:20',2,1,1,'PYG',NULL,NULL),(106,'Fortis','Fortis',1,NULL,NULL,0,NULL,1,'CU1811-0028',NULL,NULL,NULL,'Av. Mon­señor Rodríguez, km 4.3',NULL,'Ciudad del Este',0,180,0,'+595-336272161',NULL,'www.fortis.com.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-17 19:37:16','2018-11-29 20:01:34',2,1,1,'PYG',NULL,NULL),(107,'Britannia S.A.','Britannia Pub',1,NULL,NULL,0,NULL,1,'CU1811-0029',NULL,NULL,NULL,'Cerro Cora c/ Estados Unidos',NULL,'Asuncion',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,101,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-11-30 19:18:30','2018-11-30 19:18:30',2,2,1,'PYG',NULL,NULL),(108,'Nutritiva Store','Nutritiva Store',1,NULL,NULL,0,NULL,1,'CU1812-0030',NULL,NULL,NULL,'Charles de Gaulle y Campos Cervera',NULL,'Villa Morra, Asuncion',0,180,0,NULL,NULL,NULL,'Gerencianutritivastore@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-12-01 21:59:45','2018-12-01 21:59:45',1,1,1,'PYG',NULL,NULL),(109,'Whisky House','Whisky House',1,NULL,NULL,0,NULL,1,'CU1812-0031',NULL,NULL,NULL,'Ayolas 222  c/ Pdte. Franco',NULL,'Asuncion',0,180,0,'021440875',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-02-08 13:28:55','2018-12-04 19:37:30',2,2,1,'PYG',NULL,NULL),(110,'Mannah Duty Free','Mannah Duty Free',1,NULL,NULL,0,NULL,1,'CU1812-0032',NULL,NULL,NULL,'Aeropuerto Internacional Silvio Pettirossi',NULL,'Luque',0,180,0,'021645715',NULL,'www.mannahsrl.com.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-12-04 19:45:21','2018-12-04 19:45:21',2,2,1,'PYG',NULL,NULL),(111,'Pera Wines','',1,NULL,NULL,0,NULL,1,'CU1812-0033',NULL,NULL,NULL,'1087 Federal Road, Unit 6','06804','Brookfield',799,11,0,'+1-203-564-3546',NULL,'www.perawines.com','bjones@perawines.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-12-07 21:16:17','2018-12-07 21:16:17',1,1,2,'USD',NULL,NULL),(112,'BGT Selection sarl','',1,NULL,NULL,0,NULL,1,'CU1812-0034',NULL,NULL,NULL,'32, Quai Jean-Charles Rey','98000','MONACO',0,27,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-12-09 16:15:06','2018-12-09 16:15:06',1,1,1,'PYG',NULL,NULL),(113,'Provindus','Pallet',1,NULL,NULL,0,NULL,1,NULL,'SU1812-0001',NULL,NULL,'Puerta del sol esq. Zubizarreta',NULL,'Capiata',0,180,0,'(0228)633727',NULL,'www.pallets.com.py','pallets@pallets.com.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-12-19 12:18:52','2018-12-18 13:04:49',2,2,1,'PYG',NULL,NULL),(114,'Anthem Imports','Anthem Imports',1,NULL,NULL,0,NULL,1,'CU1812-0035',NULL,NULL,NULL,'2946 Appling Way','30341','Chamblee',802,11,0,'+1-404-202-1360',NULL,'https://anthemimports.net','contact@anthemimports.net',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-09-14 21:57:59','2018-12-19 15:01:36',1,1,1,'PYG',NULL,NULL),(115,'Astor Wines & Spirits','Astor Wines & Spirits',1,NULL,NULL,0,NULL,1,'CU1812-0036',NULL,NULL,NULL,'De Vinne Press Building\r\n399 Lafayette St. (at East 4th St.)','10003','New York',824,11,0,'+1-212-674-7500',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-12-19 19:30:29','2018-12-19 19:30:18',1,1,2,'USD',NULL,NULL),(116,'Euro Shop Beer Store','Euro Shop Beer Store',1,NULL,NULL,0,NULL,1,'CU1812-0037',NULL,NULL,NULL,'',NULL,NULL,0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-12-23 21:59:24','2018-12-23 21:59:24',1,1,1,'PYG',NULL,NULL),(117,'Palo Santo Brewing Company','Palo Santo Brewing Company',1,NULL,NULL,0,NULL,1,'CU1812-0038',NULL,NULL,NULL,'',NULL,'Asuncion',0,180,0,'+595-972234336',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-15 16:08:07','2018-12-23 22:10:28',1,1,1,'PYG',NULL,NULL),(118,'Sacramento Brewing Co.','Sacramento Brewing Co.',1,NULL,NULL,0,NULL,1,'CU1812-0039',NULL,NULL,NULL,'',NULL,'Asuncion',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,236,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-15 16:05:53','2018-12-23 22:10:52',1,1,1,'PYG',NULL,NULL),(119,'Comercial El Cacique','Comercial El Cacique',1,NULL,NULL,0,NULL,1,'CU1812-0040','SU1812-0002',NULL,NULL,'',NULL,'Aregua',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-14 19:56:44','2018-12-23 22:36:29',1,2,1,'PYG',NULL,NULL),(120,'Morel Brothers Supermarket','',1,NULL,NULL,0,NULL,1,'CU1812-0041',NULL,NULL,NULL,'',NULL,'Itaugua',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-12-23 22:42:20','2018-12-23 22:42:20',1,1,1,'PYG',NULL,NULL),(121,'Supermercado Edward','Supermercado Edward',1,NULL,NULL,0,NULL,1,'CU1812-0042',NULL,NULL,NULL,'',NULL,'Capiata',0,180,0,'+595-228-631338',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-12-23 22:45:04','2018-12-23 22:44:05',1,1,1,'PYG',NULL,NULL),(122,'Real chain S.A.','Real chain S.A.',1,NULL,NULL,0,NULL,1,'CU1812-0043',NULL,NULL,NULL,'',NULL,'Asuncion',0,180,0,'021520704',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-15 16:05:01','2018-12-23 22:45:53',1,1,1,'PYG',NULL,NULL),(123,'Saporiti Flavors','Saporiti Flavors',1,NULL,NULL,0,NULL,1,NULL,'SU1812-0003',NULL,NULL,'',NULL,'Luque',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-12-29 23:20:02','2018-12-29 23:17:52',1,1,1,'PYG',NULL,NULL),(124,'OTISA Sugar Mill','',1,NULL,NULL,0,NULL,1,NULL,'SU1812-0004',NULL,NULL,'',NULL,'Arroyos y Esteros',0,180,0,NULL,NULL,'www.otisa.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,101,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2018-12-29 23:28:21','2018-12-29 23:28:21',1,1,1,'PYG',NULL,NULL),(125,'Bruni Glass','',1,NULL,NULL,0,NULL,1,NULL,'SU1812-0005',NULL,NULL,'',NULL,'Milano',180,3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-15 16:04:03','2018-12-30 04:03:19',1,1,3,'EUR',NULL,NULL),(126,'Formugrafica S.A.','Primo Digital',1,NULL,NULL,0,NULL,1,NULL,'SU1901-0006',NULL,NULL,'Avda. Cacique Lambare 4209',NULL,'Lambare',0,180,0,NULL,NULL,'www.primodigital.com.py','comercial@formugrafica.com.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,101,NULL,'','','','','','','80003768-5',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-02 16:53:51','2019-01-02 16:53:51',2,2,1,'PYG',NULL,NULL),(127,'Herrero Supermarket 2','Herrero Supermarket 2',1,NULL,NULL,0,NULL,1,'CU1901-0044',NULL,NULL,NULL,'Pte Franco, Beato Roque Gonzalez',NULL,'Villarrica',0,180,0,'+595-42-142587',NULL,'www.herrero.com.py','recepcion@herrero.com.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-07 20:58:15','2019-01-07 18:02:34',1,1,1,'PYG',NULL,NULL),(128,'Ser Sano - Almacén Saludable','Ser Sano - Almacén Saludable',1,NULL,NULL,0,NULL,1,'CU1901-0045',NULL,NULL,NULL,'Federación Rusa 1240 - Bo. Carmelitas',NULL,'Asuncion',0,180,0,'+595-981977213',NULL,'www.sersano.com.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-15 16:03:09','2019-01-09 11:58:52',1,1,1,'PYG',NULL,NULL),(129,'Cerbaco','Cerbaco',1,NULL,NULL,0,NULL,1,'CU1901-0046',NULL,NULL,NULL,'',NULL,NULL,0,28,0,NULL,NULL,'https://cerbaco.com.au/','cerbaco@cerbaco.com.au',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-13 22:18:03','2019-01-13 22:18:03',1,1,1,'PYG',NULL,NULL),(130,'Box Mayorista','',1,NULL,NULL,0,NULL,1,'CU1901-0047',NULL,NULL,NULL,'',NULL,'Asucion',0,180,0,'0972101020',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-15 12:14:50','2019-01-15 12:14:50',2,2,1,'PYG',NULL,NULL),(131,'12 Leñas - Pizzeria','12 Leñas - Pizzeria',1,NULL,NULL,0,NULL,1,'CU1901-0048',NULL,NULL,NULL,'Rca. Dominicana Nº 948 e/ Amistad y Libertad',NULL,'Asunción',0,180,0,'+595-971-511992',NULL,NULL,'majo.centurionmonnin@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,236,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-17 19:38:58','2019-01-15 17:27:27',1,1,1,'PYG',NULL,NULL),(132,'Bodega Ayolas','Bodega Ayolas',1,NULL,NULL,0,NULL,1,'CU1901-0049',NULL,NULL,NULL,'Ayolas z Lugano',NULL,'Asuncion',0,180,0,'+595-992-431386',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-15 18:21:02','2019-01-15 18:21:02',1,1,1,'PYG',NULL,NULL),(133,'Citymarket','Citymarket',1,NULL,NULL,0,NULL,1,'CU1901-0050',NULL,NULL,NULL,'Avda. Aviadores del Chaco',NULL,'Asuncion',0,180,0,'0214199820',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-15 18:27:07','2019-01-15 18:27:07',2,2,1,'PYG',NULL,NULL),(134,'El Templo Bodega','',1,NULL,NULL,0,NULL,1,'CU1901-0051',NULL,NULL,NULL,'',NULL,'Asuncion',0,180,0,'+595-983-793000',NULL,NULL,'eltemplobodega@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-15 18:31:03','2019-01-15 18:28:45',1,1,1,'PYG',NULL,NULL),(135,'La Cachamba','La Cachamba',1,NULL,NULL,0,NULL,1,'CU1901-0052',NULL,NULL,NULL,'',NULL,'Asuncion',0,180,0,'+595-021-441000',NULL,NULL,'info@lacachamba.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,236,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-15 18:34:08','2019-01-15 18:34:08',1,1,1,'PYG',NULL,NULL),(136,'Bodega - Bar Centenario','Bodega - Bar Centenario',1,NULL,NULL,0,NULL,1,'CU1901-0053',NULL,NULL,NULL,'Centenario',NULL,'Asuncion',0,180,0,'+595-984404416',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-15 19:09:19','2019-01-15 19:09:18',1,1,1,'PYG',NULL,NULL),(137,'Bodega San Patricio','Bodega San Patricio',1,NULL,NULL,0,NULL,1,'CU1901-0054',NULL,NULL,NULL,'independencia nacional casi monseñor wissen',NULL,'Encarnación',0,180,0,'+595-71-201435',NULL,'https://www.facebook.com/Bodega-San-Patricio-467303253466210/',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-15 19:27:24','2019-01-15 19:26:47',1,1,1,'PYG',NULL,NULL),(138,'Bodega San Martin','Bodega San Martin',1,NULL,NULL,0,NULL,1,'CU1901-0055',NULL,NULL,NULL,'San Martin 575 C/ Sucre',NULL,'Asuncion',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-15 19:28:32','2019-01-15 19:28:32',1,1,1,'PYG',NULL,NULL),(139,'Bodega Juancho','Bodega Juancho',1,NULL,NULL,0,NULL,1,'CU1901-0056',NULL,NULL,NULL,'Dr. Pellón casi Jamaica',NULL,'San Lorenzo',0,180,0,NULL,NULL,'https://www.facebook.com/juanchobodega/',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-15 19:31:26','2019-01-15 19:31:26',1,1,1,'PYG',NULL,NULL),(140,'Bodega Donato','Bodega Donato',1,NULL,NULL,0,NULL,1,'CU1901-0057',NULL,NULL,NULL,'Mecánicos de Aviación 966',NULL,'Asuncion',0,180,0,'+595-983561445',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-15 19:33:34','2019-01-15 19:33:34',1,1,1,'PYG',NULL,NULL),(141,'Bodega Drink King','Bodega Drink King',1,NULL,NULL,0,NULL,1,'CU1901-0058',NULL,NULL,NULL,'España 487',NULL,'San Lorenzo',0,180,0,'+595-972-992094',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-15 19:36:18','2019-01-15 19:36:18',1,1,1,'PYG',NULL,NULL),(142,'Bodega Nanu','Bodega Nanu',1,NULL,NULL,0,NULL,1,'CU1901-0059',NULL,NULL,NULL,'Avda Zavala cue esq San Francisco',NULL,'Fernando de la Mora',0,180,0,'+595-994280685',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-15 19:38:17','2019-01-15 19:38:17',1,1,1,'PYG',NULL,NULL),(143,'Dia Paraguay','Dia Paraguay',1,NULL,NULL,0,NULL,1,'CU1901-0060',NULL,NULL,NULL,'',NULL,'Asuncion',0,180,0,'021584555',NULL,NULL,'info@dipasa.com.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-17 12:24:31','2019-01-17 12:24:31',2,2,1,'PYG',NULL,NULL),(144,'Supermercado Guarani S.R.L.','Supermercado Guarani',1,NULL,NULL,0,NULL,1,'CU1901-0061',NULL,NULL,NULL,'Avenida Mariscal Estigarribia\r\n3450',NULL,'Fernando de la Mora',0,180,0,'021500747',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','80002449-4',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-02-05 14:58:53','2019-01-17 12:59:35',2,2,1,'PYG',NULL,NULL),(145,'Gran Via','Gran Via',1,NULL,NULL,0,NULL,1,'CU1901-0062',NULL,NULL,NULL,'Av. Mcal. López c/ Madame Lynch',NULL,'Asuncion',0,180,0,'021615413',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-17 13:27:11','2019-01-17 13:27:11',2,2,1,'PYG',NULL,NULL),(146,'Supermercados Kingo','Supermercados Kingo',1,NULL,NULL,0,NULL,1,'CU1901-0063',NULL,NULL,NULL,'',NULL,'San Lorenzo',0,180,0,'0212376698',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-17 18:15:13','2019-01-17 18:15:01',2,2,1,'PYG',NULL,NULL),(147,'Cebre S.A.','Super Pacifico',1,NULL,NULL,0,NULL,1,'CU1901-0064',NULL,NULL,NULL,'Avda. Carlos A. Lopez 1765',NULL,'Asuncion',0,180,0,'021423548',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-02-04 19:56:59','2019-01-18 13:11:40',2,2,1,'PYG',NULL,NULL),(148,'Bodega 360 PCC','Bodega 360 PCC',1,NULL,NULL,0,NULL,1,'CU1901-0065',NULL,NULL,NULL,'Paraná Country Club',NULL,'Ciudad del Este',0,180,0,'+595-0974300360',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-28 11:37:46','2019-01-28 11:37:45',1,1,1,'PYG',NULL,NULL),(149,'The Growler Bar Bodega','The Growler Bar Bodega',1,NULL,NULL,0,NULL,1,'CU1901-0066',NULL,NULL,NULL,'',NULL,'Ciudad del Este',0,180,0,'+595-061-578120',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,6,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-28 11:40:17','2019-01-28 11:40:17',1,1,1,'PYG',NULL,NULL),(150,'Caminos del Vino','Caminos del Vino',1,NULL,NULL,0,NULL,1,'CU1901-0067',NULL,NULL,NULL,'',NULL,'Ciudad del Este',0,180,0,'+595-061-578866',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-28 11:41:53','2019-01-28 11:41:53',1,1,1,'PYG',NULL,NULL),(151,'San Cayetano','',1,NULL,NULL,0,NULL,1,'CU1901-0068',NULL,NULL,NULL,'',NULL,'Luque',0,180,0,'021641488',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-30 12:33:12','2019-01-30 12:33:12',2,2,1,'PYG',NULL,NULL),(152,'Sibol SAC','Bolsi',1,NULL,NULL,0,NULL,1,'CU1901-0069',NULL,NULL,NULL,'Estrella 399',NULL,'Asuncion',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-31 18:39:22','2019-01-31 18:39:22',2,2,1,'PYG',NULL,NULL),(153,'Mapy','Mapy Shopping',1,NULL,NULL,0,NULL,1,'CU1902-0070',NULL,NULL,NULL,'',NULL,'Salto del Guairá',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-02-15 12:47:51','2019-02-15 12:47:51',2,2,1,'PYG',NULL,NULL),(154,'Casa Tower\'s','Casa Tower\'s',1,NULL,NULL,0,NULL,1,'CU1902-0071',NULL,NULL,NULL,'',NULL,'Salto del Guairá',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-02-20 14:01:00','2019-02-20 14:01:00',2,2,1,'PYG',NULL,NULL),(155,'Hiper Luisito','Hiper Luisito',1,NULL,NULL,0,NULL,1,'CU1902-0072',NULL,NULL,NULL,'Ceferino Ruíz esq. Algodonal',NULL,'Fernando de la Mora',0,180,0,'021523260',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-02-27 17:18:25','2019-02-27 17:18:25',2,2,1,'PYG',NULL,NULL),(156,'Maxi Hipermercado','Maxi Hipermercado',1,NULL,NULL,0,NULL,1,'CU1902-0073',NULL,NULL,NULL,'Av. Mcal López c/ Julia M. C',NULL,'Pedro Juan Caballero',0,180,0,'0336274888',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-02-27 18:56:38','2019-02-27 18:56:38',2,2,1,'PYG',NULL,NULL),(157,'Philip Baumann','',1,NULL,NULL,0,NULL,1,'CU1903-0074',NULL,NULL,NULL,'',NULL,'Hanoi',0,233,0,'+84865356006',NULL,NULL,'Baumann.philip@googlemail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,234,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-03-10 13:55:23','2019-03-10 13:55:23',1,1,1,'PYG',NULL,NULL),(158,'Karl Zander','',1,NULL,NULL,0,NULL,1,'CU1903-0075',NULL,NULL,NULL,'',NULL,'Johannesburg',0,205,0,NULL,NULL,NULL,'karl@imdynamics.co.za',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-03-11 16:36:55','2019-03-11 16:36:08',1,1,3,'EUR',NULL,NULL),(160,'Rapidito','Rapidito - Gas Station',1,NULL,NULL,0,NULL,1,'CU1903-0077',NULL,NULL,NULL,'',NULL,'Luque',0,180,0,'0214175000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-03-12 18:44:58','2019-03-12 18:44:58',2,2,1,'PYG',NULL,NULL),(161,'Hotel Palma Roga','Palma Roga',1,NULL,NULL,0,NULL,1,'CU1903-0078',NULL,NULL,NULL,'Palma c/ Montevideo',NULL,'Asuncion',0,180,0,'021441441',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-11-14 19:41:09','2019-03-14 12:58:00',2,2,1,'PYG',NULL,NULL),(162,'Mercado Villa Sofia','Mercado Villa Sofia',1,NULL,NULL,0,NULL,1,'CU1903-0079',NULL,NULL,NULL,'Avda. Carlos A. Lopez e/ Diaz',NULL,'Asuncion',0,180,0,'0984118692',NULL,NULL,'htorres.vsofia@hotmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-03-18 12:00:39','2019-03-18 12:00:39',2,2,1,'PYG',NULL,NULL),(163,'Monalisa S.R.L.','Monalisa',1,NULL,NULL,0,NULL,1,'CU1903-0080',NULL,NULL,NULL,'',NULL,'Ciudad del Este',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-03-21 18:27:52','2019-03-21 18:27:52',2,2,1,'PYG',NULL,NULL),(164,'CAFSA S.A.','Arete - Pinedo Shopping',1,NULL,NULL,0,NULL,1,'CU1904-0081',NULL,NULL,NULL,'Pinedo Shopping\r\nAvda. Mcal. López y 26 de Febrero',NULL,'San Lorenzo',0,180,0,NULL,NULL,'arete.com.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-04-02 16:17:10','2019-04-02 16:17:10',2,2,1,'PYG',NULL,NULL),(165,'Maria Victoria Velazquez Avalos','',1,NULL,NULL,0,NULL,1,'CU1904-0082',NULL,NULL,NULL,'',NULL,'itaugua',0,180,0,'0986711721',NULL,'https://www.facebook.com/profile.php?id=100010078817242',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,239,NULL,NULL,'','','','','','','5.382.916',NULL,0,NULL,'<p><span style=\"font-size:14px\">Debo y Pagaré incondicionalmente por el presente PAGARÉ al señor Timm Hogerzeil, el día: ____________________________ en el domicilio de la empresa Hogerzeil Destileria Paraguay , la cantidad de Gs. ___________________________________ . Valor recibido a mi entera conformidad. Obligándome a pagar para el caso de mora un interés equivalente al ____ mensual durante todo el tiempo que permanezca insoluto.</span></p>\r\n\r\n<p><span style=\"font-size:14px\">Datos del Deudor:<br />\r\nNombre:<br />\r\nDomicilio:<br />\r\nTeléfono: <br />\r\nFirma:</span></p>\r\n',NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-04-08 18:04:50','2019-04-05 19:06:08',1,2,1,'PYG',NULL,NULL),(166,'Adrian Abel Roa Romero','',1,NULL,NULL,0,NULL,1,'CU1904-0083',NULL,NULL,NULL,'',NULL,'Luque',0,180,0,'0986781336',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,239,NULL,NULL,'','','','','','','4983095',NULL,0,NULL,'<p><span style=\"font-size:16px\">Debo y Pagaré incondicionalmente por el presente PAGARÉ al señor Timm Hogerzeil, el día: ____________________________ en el domicilio de la empresa Hogerzeil Destileria Paraguay , la cantidad de Gs. ___________________________________ . Valor recibido a mi entera conformidad. Obligándome a pagar para el caso de mora un interés equivalente al ____ mensual durante todo el tiempo que permanezca insoluto.</span></p>\r\n\r\n<p><span style=\"font-size:16px\">Datos del Deudor:<br />\r\nNombre:<br />\r\nDomicilio:<br />\r\nTeléfono: <br />\r\nFirma:</span></p>\r\n',NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-04-08 18:15:31','2019-04-08 14:11:15',2,2,1,'PYG',NULL,NULL),(167,'Gabriel Rodriguez Enciso','',1,NULL,NULL,0,NULL,1,'CU1904-0084',NULL,NULL,NULL,'',NULL,'Aregua',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,239,NULL,NULL,'','','','','','','4188671',NULL,0,NULL,'<p><span style=\"font-size:14px\">Debo y Pagaré incondicionalmente por el presente PAGARÉ al señor Timm Hogerzeil, el día: ____________________________ en el domicilio de la empresa Hogerzeil Destileria Paraguay , la cantidad de Gs. ___________________________________ . Valor recibido a mi entera conformidad. Obligándome a pagar para el caso de mora un interés equivalente al ____ mensual durante todo el tiempo que permanezca insoluto.</span></p>\r\n\r\n<p><span style=\"font-size:14px\">Datos del Deudor:<br />\r\nNombre:<br />\r\nDomicilio:<br />\r\nTeléfono: <br />\r\nFirma:</span></p>\r\n',NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-04-08 18:03:47','2019-04-08 18:02:30',2,2,1,'PYG',NULL,NULL),(168,'Edgar Jose Thompson Nuñez','',1,NULL,NULL,0,NULL,1,'CU1904-0085',NULL,NULL,NULL,'',NULL,'Luque',0,180,0,NULL,NULL,NULL,'comunicacionmktpy@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','807667',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-04-11 12:11:11','2019-04-11 12:11:11',2,2,1,'PYG',NULL,NULL),(169,'Comercial','',1,NULL,NULL,0,NULL,1,'CU1904-0086',NULL,NULL,NULL,'',NULL,NULL,0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-04-11 12:44:34','2019-04-11 12:44:34',2,2,1,'PYG',NULL,NULL),(170,'Marlin Store','Marlin Store',1,NULL,NULL,0,NULL,1,'CU1904-0087',NULL,NULL,NULL,'12 de Octubre',NULL,'Alberdi',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-04-11 15:01:48','2019-04-11 15:01:48',2,2,1,'PYG',NULL,NULL),(171,'Mario Cersar Rodriguez','',1,NULL,NULL,0,NULL,1,'CU1904-0088',NULL,NULL,NULL,'',NULL,'Capiata',0,180,0,'0991804464',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,239,NULL,NULL,'','','','','','','5276227',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-04-22 13:37:51','2019-04-22 13:37:51',2,2,1,'PYG',NULL,NULL),(172,'Distribuidara Fortaleza','',1,NULL,NULL,0,NULL,1,NULL,NULL,NULL,NULL,'',NULL,'Asuncion',0,180,0,NULL,NULL,NULL,'distribuidorafortalezasa@hotmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-08-12 14:26:33','2019-07-04 19:13:14',2,2,1,'PYG',NULL,NULL),(173,'Distribuidora Leon','',1,NULL,NULL,0,NULL,1,NULL,NULL,NULL,NULL,'',NULL,'Asuncion',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-08-12 14:27:32','2019-07-04 20:31:27',2,2,1,'PYG',NULL,NULL),(174,'Arquipelago, LLC, DBA: Barbera Imports','',1,NULL,NULL,0,NULL,1,'CU1907-0089',NULL,NULL,NULL,'16558 N.109th St.;','85255','Scottsdale',795,11,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-10-15 12:17:36','2019-07-23 14:29:15',2,2,1,'PYG',NULL,NULL),(175,'MVP Bros S.R.L.','Alcala Piano Bar',1,NULL,NULL,0,NULL,1,'CU1907-0090',NULL,NULL,NULL,'Dr. Francisco Morra 1395 esq. Lillo',NULL,'Asuncion',0,180,0,'0981814369',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,102,NULL,'','','','','','','80099336-5',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-07-24 20:30:02','2019-07-24 20:30:02',2,2,1,'PYG',NULL,NULL),(176,'Astrid & Solveig OÜ','Astrid & Solveig',1,NULL,NULL,0,NULL,1,'CU1907-0091',NULL,NULL,NULL,'Sakala 7-2','10141','Tallinn',0,89,0,'+595-971-297010',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-07-26 18:30:50','2019-07-26 14:41:37',2,1,3,'EUR',NULL,NULL),(177,'Webb James Srl','',1,NULL,NULL,0,NULL,1,NULL,'SU1907-0007',NULL,NULL,'Via delle Cateratte, 84 int.11','57122','LIVORNO',0,3,0,'+390586884282',NULL,'www.webbjames.com','info@webbjames.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,305,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-07-29 20:02:29','2019-07-29 20:02:29',1,1,1,'PYG',NULL,NULL),(178,'Organic Juniper Ltd.','',1,NULL,NULL,0,NULL,1,NULL,'SU1907-00008',NULL,NULL,'Žiča 157','36221','Kraljevo',0,180,0,'+381365817770',NULL,'www.organic-juniper.com','office@organic-juniper.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-07-30 18:51:57','2019-07-30 18:51:57',1,1,1,'PYG',NULL,NULL),(179,'Andres Fernandez','',1,NULL,NULL,0,NULL,1,'CU1908-00092',NULL,NULL,NULL,'Capitan Carpinelli 3490',NULL,NULL,0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,8,NULL,NULL,'','','','','','','3701159-6',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-08-08 16:15:25','2019-08-08 16:15:25',2,2,1,'PYG',NULL,NULL),(180,'AJ S.A.','AJ Vierci',1,NULL,NULL,0,NULL,1,NULL,NULL,NULL,NULL,'',NULL,'Asuncion',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,101,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-08-09 18:13:02','2019-08-09 18:13:02',2,2,1,'PYG',NULL,NULL),(181,'El Imperio S.A.','El Imperio',1,NULL,NULL,0,NULL,1,'CU1911-00124',NULL,NULL,NULL,'',NULL,'Luque',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-11-04 11:50:14','2019-08-09 18:19:13',2,2,1,'PYG',NULL,NULL),(182,'Comida S.A.','',1,NULL,NULL,0,NULL,1,'CU1911-00123',NULL,NULL,NULL,'',NULL,NULL,0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,101,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-11-04 11:30:58','2019-08-09 18:22:34',2,2,1,'PYG',NULL,NULL),(183,'Casa Modiga','',1,NULL,NULL,0,NULL,1,'CU1911-00127',NULL,NULL,NULL,'',NULL,'Asuncion',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-11-04 13:20:15','2019-08-09 18:25:41',2,2,1,'PYG',NULL,NULL),(184,'La Caoba','La Caoba',1,NULL,NULL,0,NULL,1,NULL,NULL,NULL,NULL,'',NULL,'Mariano Roque Alonso',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-08-09 18:29:05','2019-08-09 18:29:05',2,2,1,'PYG',NULL,NULL),(185,'Vascol','Vascol',1,NULL,NULL,0,NULL,1,'CU1911-00128',NULL,NULL,NULL,'',NULL,NULL,0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-11-04 13:30:56','2019-08-09 18:32:08',2,2,1,'PYG',NULL,NULL),(186,'MG S.R.L.','MG',1,NULL,NULL,0,NULL,1,'CU1911-00121',NULL,NULL,NULL,'',NULL,'Luque',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-11-01 17:48:41','2019-08-09 18:34:56',2,2,1,'PYG',NULL,NULL),(187,'Brumado S.A.','Brumado',1,NULL,NULL,0,NULL,1,'CU1911-00125',NULL,NULL,NULL,'',NULL,'Ciudad del Este',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,101,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-11-04 12:40:01','2019-08-09 18:36:53',2,2,1,'PYG',NULL,NULL),(188,'AC S.A.','ACSA',1,NULL,NULL,0,NULL,1,'CU1911-00122',NULL,NULL,NULL,'',NULL,'Asuncion',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,101,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-11-01 19:59:57','2019-08-09 18:47:50',2,2,1,'PYG',NULL,NULL),(189,'Ramirez Diaz de Espada','RDE',1,NULL,NULL,0,NULL,1,'CU1911-00126',NULL,NULL,NULL,'',NULL,NULL,0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-11-04 13:14:45','2019-08-09 19:31:35',2,2,1,'PYG',NULL,NULL),(190,'La Mercantil Guarani S.A.','Merantil Guarani',1,NULL,NULL,0,NULL,1,NULL,NULL,NULL,NULL,'',NULL,'Asuncion',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,101,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-08-09 19:34:22','2019-08-09 19:34:22',2,2,1,'PYG',NULL,NULL),(191,'London Import S.A.','London Import',1,NULL,NULL,0,NULL,1,NULL,NULL,NULL,NULL,'',NULL,'Asuncion',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,101,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-08-09 19:36:30','2019-08-09 19:36:30',2,2,1,'PYG',NULL,NULL),(192,'CODISA','Codisa',1,NULL,NULL,0,NULL,1,'CU1911-00130',NULL,NULL,NULL,'',NULL,'Asuncion',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,101,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-11-04 14:14:41','2019-08-09 19:40:28',2,2,1,'PYG',NULL,NULL),(193,'Sigma S.A.','',1,NULL,NULL,0,NULL,1,'CU1911-00129',NULL,NULL,NULL,'',NULL,'Ciudad del Este',0,180,0,NULL,NULL,NULL,'secretaria@sigma.com.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,101,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-11-04 13:44:55','2019-08-09 19:42:19',2,2,1,'PYG',NULL,NULL),(194,'Galfor S.A.','Galfor',1,NULL,NULL,0,NULL,1,NULL,NULL,NULL,NULL,'',NULL,'Fernando de la Mora',0,180,0,NULL,NULL,NULL,'info@freshup.com.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,101,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-08-12 14:52:40','2019-08-12 13:34:28',2,2,1,'PYG',NULL,NULL),(195,'Superk S.R.L.','Kchiporos',1,NULL,NULL,0,NULL,1,'CU1908-00093',NULL,NULL,NULL,'',NULL,'Asuncion',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,102,NULL,'','','','','','','80064548-0',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-08-26 19:24:53','2019-08-14 17:37:13',2,2,1,'PYG',NULL,NULL),(196,'Michael Huang','Michael Huang',1,NULL,NULL,0,NULL,1,'CU1908-00094',NULL,NULL,NULL,'Eienmidori -Taiwan R.O.C./ Platform Asian Market',NULL,NULL,0,213,0,'+886975187923',NULL,NULL,'eienmidori@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,238,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-08-14 21:57:04','2019-08-14 21:57:04',1,1,1,'PYG',NULL,NULL),(197,'Maahsa','Maahsa',1,NULL,NULL,0,NULL,1,'CU1910-00120',NULL,NULL,NULL,'Ruta 2 Mcal. Estigarribia - Km.27,5',NULL,'Itaugua',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,101,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-10-31 17:43:19','2019-08-16 18:52:45',2,2,1,'PYG',NULL,NULL),(198,'SBB Trading','SBB Trading',1,NULL,NULL,0,NULL,1,'CU1908-00095',NULL,NULL,NULL,'Rua Estudante Alexandre G. Sarmento, 23',NULL,'Maceio',0,56,0,'+5582999270580',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,238,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-08-30 19:40:01','2019-08-30 19:40:01',2,2,1,'PYG',NULL,NULL),(199,'Siqueira Campos Importacao e Distribuicao','Siqueira Campos Importacao e Distribuicao',1,NULL,NULL,0,NULL,1,'CU1909-00096',NULL,NULL,NULL,'Polo JK',NULL,'Brasilia',0,56,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-09-02 20:22:20','2019-09-02 20:22:20',2,2,1,'PYG',NULL,NULL),(200,'Branch Trade Comercio Exterior Ltda.','Branch Trade Comercio Exterior Ltda.',1,NULL,NULL,0,NULL,1,'CU1909-00097',NULL,NULL,NULL,'Rua Bras Cubas 222',NULL,'Guarulhos',0,56,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,238,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-09-02 20:33:42','2019-09-02 20:33:42',2,2,1,'PYG',NULL,NULL),(202,'Zona Sul Supermercados','Zona Sul Supermercados',1,NULL,NULL,0,NULL,1,'CU1909-00099',NULL,NULL,NULL,'Rua Comandante Vergueiro da Cruz, 226','21021-020','Olaria',0,56,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,238,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-09-02 21:00:50','2019-09-02 21:00:50',2,2,1,'PYG',NULL,NULL),(203,'Uniland','Uniland',1,NULL,NULL,0,NULL,1,'CU1909-00100',NULL,NULL,NULL,'R. dos Macunis, 482',NULL,'Sao Paulo',0,56,0,NULL,NULL,NULL,'uniland@uniland.com.br',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,238,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-09-03 19:55:29','2019-09-03 18:42:24',2,2,1,'PYG',NULL,NULL),(204,'Proenca Importadora','Proenca Importadora',1,NULL,NULL,0,NULL,1,'CU1909-00101',NULL,NULL,NULL,'Rua Fernandes Portalegre, 322 – Jd. Maringá',NULL,'Sao Paulo',0,56,0,NULL,NULL,NULL,'contato@proencaimport.com.br',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,238,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-09-05 14:51:28','2019-09-03 20:56:40',2,2,1,'PYG',NULL,NULL),(205,'Globalbev','Globalbev',1,NULL,NULL,0,NULL,1,'CU1909-00102',NULL,NULL,NULL,'R. Min. Orozimbo Nonato, 102',NULL,'Bello Horizonte',0,56,0,NULL,NULL,'www.globalbev.com.br','export@globalbev.com.br',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,238,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-09-04 13:50:06','2019-09-04 13:50:06',2,2,1,'PYG',NULL,NULL),(206,'Cantu Importadora','Cantu Importadora',1,NULL,NULL,0,NULL,1,'CU1909-00103',NULL,NULL,NULL,'Rua Passo da Pátria, 1689',NULL,'São Paulo',0,56,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,238,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-09-04 14:06:41','2019-09-04 14:00:56',2,2,1,'PYG',NULL,NULL),(207,'Fox Importadora','Fox Importadora',1,NULL,NULL,0,NULL,1,'CU1909-00104',NULL,NULL,NULL,'SCLS 113 BL. A LJ. 34',NULL,'Brasilia',0,56,0,NULL,NULL,'www.foximportadora.com','foximportadora@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,238,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-09-04 14:05:23','2019-09-04 14:05:23',2,2,1,'PYG',NULL,NULL),(208,'Aurora','Aurora',1,NULL,NULL,0,NULL,1,'CU1909-00105',NULL,NULL,NULL,'R. Gomes de Carvalho, 1329',NULL,'Sao Paulo',0,56,0,NULL,NULL,NULL,'sac@aurora.com.br',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,238,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-09-04 14:32:14','2019-09-04 14:32:13',2,2,1,'PYG',NULL,NULL),(209,'Domno Importadora','Domno Importadora',1,NULL,NULL,0,NULL,1,'CU1909-00106',NULL,NULL,NULL,'Rodovia BR 470',NULL,'Garibaldi',0,56,0,NULL,NULL,'www.domno.com.br','domno@domno.com.br',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,238,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-09-04 14:41:46','2019-09-04 14:41:46',2,2,1,'PYG',NULL,NULL),(210,'Menimport','Menimport',1,NULL,NULL,0,NULL,1,'CU1909-00107',NULL,NULL,NULL,'Rua Sebastião Fabiano Dias, 210',NULL,NULL,0,56,0,NULL,NULL,'www.menimport.com.br','atendimento@menimport.com.br',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,'menimport@menimport.com.br<br />\r\natendimento1@menimport.com.br',NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-09-04 15:17:20','2019-09-04 15:08:57',2,2,1,'PYG',NULL,NULL),(211,'Porto a Porto','Porto a Porto',1,NULL,NULL,0,NULL,1,'CU1909-00108',NULL,NULL,NULL,'Av. Nossa Senhora Aparecida, 381',NULL,'Curitiba',0,56,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,238,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-09-04 16:40:13','2019-09-04 16:40:13',2,2,1,'PYG',NULL,NULL),(212,'Meara','Meara',1,NULL,NULL,0,NULL,1,'CU1909-00109',NULL,NULL,NULL,'R. João de Souza Coelho, 295',NULL,'Sao Paulo',0,56,0,NULL,NULL,NULL,'contato@meara.com.br',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,238,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-09-04 20:31:02','2019-09-04 20:31:02',2,2,1,'PYG',NULL,NULL),(213,'Casa Flora Importadora','Casa Flora Importadora',1,NULL,NULL,0,NULL,1,'CU1909-00110',NULL,NULL,NULL,'Rua Sampaio Moreira, 139',NULL,'Sao Paulo',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-09-09 12:42:59','2019-09-09 12:42:59',2,2,1,'PYG',NULL,NULL),(214,'Interfood','Interfood',1,NULL,NULL,0,NULL,1,'CU1909-00111',NULL,NULL,NULL,'R. Cacique Tibiriçá, 320',NULL,'São Bernardo do Campo',930,56,0,NULL,NULL,'www.interfood.com.br','info@interfood.com.br',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,238,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-09-10 15:19:04','2019-09-10 15:15:57',2,2,4,'BRL',NULL,NULL),(215,'Mr. Man','Mr. Man',1,NULL,NULL,0,NULL,1,'CU1909-00112',NULL,NULL,NULL,'R. Atos Ribeiro, 77','02275-180','Sao Paulo',930,56,0,'+551122499000',NULL,NULL,'sac@mrman.com.br',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,238,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-09-17 16:33:01','2019-09-10 15:29:45',2,2,4,'BRL',NULL,NULL),(216,'Franco-Suissa','Franco-Suissa',1,NULL,NULL,0,NULL,1,'CU1909-00113',NULL,NULL,NULL,'Rua Machado Bittencourt, 392',NULL,'Sao Paulo',930,56,0,NULL,NULL,NULL,'contato@francosuissa.com.br',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,238,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-09-10 17:35:56','2019-09-10 17:35:56',2,2,4,'BRL',NULL,NULL),(217,'Raul Bejar','',1,NULL,NULL,0,NULL,1,'CU1909-00114',NULL,NULL,NULL,'',NULL,'Guayaquil',0,84,0,NULL,NULL,NULL,'raulbejar@segumedik.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-09-16 19:45:31','2019-09-16 19:45:31',2,2,1,'PYG',NULL,NULL),(218,'JJ Premium Spirits','JJ Premium Spirits',1,NULL,NULL,0,NULL,1,'CU1909-00115',NULL,NULL,NULL,'Calle Emiliano R. Fernandez, 144',NULL,'Ciudad del Este',0,180,0,NULL,NULL,'www.jjpspirits.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-09-17 15:09:47','2019-09-17 15:09:47',2,2,1,'PYG',NULL,NULL),(219,'Juan Ignacio Soria','Juan Ignacio Soria',1,NULL,NULL,0,NULL,1,'CU1909-00116',NULL,NULL,NULL,'',NULL,NULL,0,229,0,NULL,NULL,NULL,'crsoria@smestudiocontable.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-09-28 21:14:01','2019-09-28 21:13:43',1,1,1,'PYG',NULL,NULL),(220,'Worldwide Libations, LLC','Worldwide Libations, LLC',1,NULL,NULL,0,NULL,1,'CU1910-00117',NULL,NULL,NULL,'139 South Main Street\r\nSuite 101','07601','Hackensack',0,11,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-10-06 01:07:44','2019-10-06 01:07:44',1,1,1,'PYG',NULL,NULL),(221,'First National Wine & Spirits','First National Wine & Spirits',1,NULL,NULL,0,NULL,1,'CU1910-00118',NULL,NULL,NULL,'7700 Medowbrook Drive\r\nTX','76112','Fort Worth',0,11,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,239,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-10-06 01:27:20','2019-10-06 01:27:20',1,1,1,'PYG',NULL,NULL),(222,'Nanto Liquor Corporation','Nanto Liquor Corporation',1,NULL,NULL,0,NULL,1,'CU1910-00119',NULL,NULL,NULL,'277 Kaneku\r\nNishihara','903-0104','Okinawa',0,123,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,238,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-10-06 01:49:32','2019-10-06 01:48:53',1,1,2,'USD',NULL,NULL),(223,'Rover Pompe','Rover Pompe',1,NULL,NULL,0,NULL,1,NULL,'SU1910-00009',NULL,NULL,'Via dell\'Artigianato, 4 z.a.',NULL,'Polverara',0,3,0,NULL,NULL,NULL,'info@roverpompe.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-10-30 18:18:30','2019-10-30 18:18:30',2,2,1,'PYG',NULL,NULL),(225,'Nova S.R.L.','Nova',1,NULL,NULL,0,NULL,1,'CU1911-00131',NULL,NULL,NULL,'Cristo Rey N°6299',NULL,'Lambare',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-11-04 15:32:22','2019-11-04 15:32:00',2,2,1,'PYG',NULL,NULL),(226,'Paraguay Trading S.A.','Paraguay Trading',1,NULL,NULL,0,NULL,1,'CU1911-00132',NULL,NULL,NULL,'Avda. Gabriel Pellon',NULL,'San Lorenzo',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-11-04 15:39:05','2019-11-04 15:39:05',2,2,1,'PYG',NULL,NULL),(227,'Adendo S.A.','Adendo',1,NULL,NULL,0,NULL,1,'CU1911-00133',NULL,NULL,NULL,'Gadioso Nuñez',NULL,'Asucion',0,180,0,'(021)211485',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,50,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2020-06-17 16:04:13','2019-11-07 12:43:32',2,2,1,'PYG',NULL,NULL),(228,'Bebidas Nativas del Paraguay S.A.','Bebidas Nativas',1,NULL,NULL,0,NULL,1,'CU1911-00134',NULL,NULL,NULL,'',NULL,'San Antonio',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-11-07 13:09:14','2019-11-07 13:09:14',2,2,1,'PYG',NULL,NULL),(229,'Tomas Patiño','',1,NULL,NULL,0,NULL,1,'CU1912-00135',NULL,NULL,NULL,'',NULL,NULL,0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-12-18 19:25:49','2019-12-18 19:25:49',2,2,1,'PYG',NULL,NULL),(230,'Knows Import','Knows Import',1,NULL,NULL,0,NULL,1,'CU1912-00136',NULL,NULL,NULL,'7700 Meadowbrook Dr.','76112','Fort Worth',835,11,0,NULL,NULL,'knowsimports.net',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,238,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-12-18 19:48:18','2019-12-18 19:48:18',2,2,2,'USD',NULL,NULL),(231,'Griscelda Isabel Sanchez Paez','Bodega Rodas',1,NULL,NULL,0,NULL,1,'CU2001-00137',NULL,NULL,NULL,'Mayor Lorenzo Medina, esq. Tte. Cabrera',NULL,'Concepcion',0,180,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2020-01-08 18:47:57','2020-01-08 18:47:57',2,2,1,'PYG',NULL,NULL),(232,'El sabor de la joya','El sabor de la joya',1,NULL,NULL,0,NULL,1,'CU2001-00138',NULL,NULL,NULL,'',NULL,NULL,0,180,0,NULL,NULL,NULL,'sabor@lajoya.info',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','8101716-2',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2020-01-09 14:06:14','2020-01-09 13:31:01',2,2,1,'PYG',NULL,NULL),(233,'ANDE','Administración Nacional de Electricidad',1,NULL,NULL,0,NULL,1,NULL,'SU2002-00010',NULL,NULL,'',NULL,NULL,0,180,0,NULL,NULL,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2020-02-21 18:15:39','2020-02-21 18:15:39',2,2,1,'PYG',NULL,NULL),(234,'Diego Diaz Ortiz','Diego Diaz Ortiz',1,NULL,NULL,0,NULL,1,'CU2004-00139',NULL,NULL,NULL,'Avda. Campo via y Monday Norte,\r\nArea 4, manzana 18 lote 15',NULL,'Ciudad del Este',0,180,0,'0973573292',NULL,'https://www.facebook.com/profile.php?id=710135606','diegodiazglk220@gmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2020-05-08 21:35:31','2020-04-27 18:49:40',2,2,1,'PYG',NULL,NULL),(235,'Bodega Tercer Tiempo','Bodega Tercer Tiempo',1,NULL,NULL,0,NULL,1,'CU2005-00140',NULL,NULL,NULL,'',NULL,'Asuncion',0,180,0,NULL,NULL,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2020-05-25 13:21:47','2020-05-25 13:21:47',2,2,1,'PYG',NULL,NULL),(236,'Masel srl','La Quesería',1,NULL,NULL,0,NULL,1,'CU2006-00141',NULL,NULL,NULL,'Aviadores del Chaco',NULL,'Asuncion',0,180,0,'+595-971-297010',NULL,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,236,NULL,NULL,'','','','','','','80000324-1',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,3,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2020-06-03 18:22:20','2020-06-03 17:05:16',1,1,1,'PYG',NULL,NULL),(237,'Sabores de mi tierra S.A.','SDMT',1,NULL,NULL,0,NULL,1,'CU2006-00142',NULL,NULL,NULL,'',NULL,'Asuncion',0,180,0,NULL,NULL,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,101,NULL,'','','','','','','80071830-5',NULL,2,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,50,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2020-07-03 17:51:44','2020-06-30 18:54:53',2,2,1,'PYG',NULL,NULL),(238,'Lopy','Lopy',1,NULL,NULL,0,NULL,1,'CU2006-00143',NULL,NULL,NULL,'Andrade 1254 esq. O\'higgins',NULL,'Asuncion',0,180,0,NULL,NULL,NULL,'info@lopy.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2020-06-30 20:06:06','2020-06-30 20:06:06',2,2,1,'PYG',NULL,NULL),(239,'Mundo Pizza','Mundo Pizza',1,NULL,NULL,0,NULL,1,'CU2007-00144',NULL,NULL,NULL,'',NULL,'Aregua',0,180,0,NULL,NULL,'https://www.facebook.com/Mundo-Pizza-560422917315031',NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,236,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2020-07-06 20:13:57','2020-07-06 20:13:57',2,2,1,'PYG',NULL,NULL),(240,'Audo Valenzuela Diaz','Audo Valenzuela Diaz',1,NULL,NULL,0,NULL,1,'CU2008-00145',NULL,NULL,NULL,'Avda. 13 yakare, Paraná Country Club',NULL,'Hernandarias',0,180,0,'0985343000',NULL,NULL,'audo_valenzuela@outlook.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2020-09-04 21:52:20','2020-08-13 15:22:01',2,2,1,'PYG',NULL,NULL),(241,'CBC Import & Export','CBC Import & Export',1,NULL,NULL,0,NULL,1,'CU2010-00146',NULL,NULL,NULL,'Antolín Irala esq. Coronel Escurra. - Paraguay',NULL,'Asunción',0,180,0,'+595994490073',NULL,NULL,'cbc.impexp@gmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,239,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,2,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2020-10-13 19:33:10','2020-10-13 19:08:33',1,1,1,'PYG',NULL,NULL);

--
-- Table structure for table `llxqa_societe_account`
--

CREATE TABLE `llxqa_societe_account` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) DEFAULT 1,
  `key_account` varchar(128) DEFAULT NULL,
  `login` varchar(128) NOT NULL,
  `pass_encoding` varchar(24) DEFAULT NULL,
  `pass_crypted` varchar(128) DEFAULT NULL,
  `pass_temp` varchar(128) DEFAULT NULL,
  `fk_soc` int(11) DEFAULT NULL,
  `site` varchar(128) DEFAULT NULL,
  `fk_website` int(11) DEFAULT NULL,
  `note_private` text DEFAULT NULL,
  `date_last_login` datetime DEFAULT NULL,
  `date_previous_login` datetime DEFAULT NULL,
  `date_creation` datetime NOT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_user_creat` int(11) NOT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `site_account` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_societe_account_login_website_soc` (`entity`,`fk_soc`,`login`,`site`,`fk_website`),
  UNIQUE KEY `uk_societe_account_key_account_soc` (`entity`,`fk_soc`,`key_account`,`site`,`fk_website`),
  KEY `idx_societe_account_rowid` (`rowid`),
  KEY `idx_societe_account_login` (`login`),
  KEY `idx_societe_account_status` (`status`),
  KEY `idx_societe_account_fk_website` (`fk_website`),
  KEY `idx_societe_account_fk_soc` (`fk_soc`),
  CONSTRAINT `llxqa_societe_account_fk_societe` FOREIGN KEY (`fk_soc`) REFERENCES `llxqa_societe` (`rowid`),
  CONSTRAINT `llxqa_societe_account_fk_website` FOREIGN KEY (`fk_website`) REFERENCES `llxqa_website` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_societe_account`
--


--
-- Table structure for table `llxqa_societe_address`
--

CREATE TABLE `llxqa_societe_address` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `label` varchar(30) DEFAULT NULL,
  `fk_soc` int(11) DEFAULT 0,
  `name` varchar(60) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `zip` varchar(10) DEFAULT NULL,
  `town` varchar(50) DEFAULT NULL,
  `fk_pays` int(11) DEFAULT 0,
  `phone` varchar(20) DEFAULT NULL,
  `fax` varchar(20) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_societe_address`
--


--
-- Table structure for table `llxqa_societe_commerciaux`
--

CREATE TABLE `llxqa_societe_commerciaux` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_soc` int(11) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_societe_commerciaux` (`fk_soc`,`fk_user`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_societe_commerciaux`
--

INSERT INTO `llxqa_societe_commerciaux` VALUES (1,80,2,NULL),(2,81,2,NULL),(3,82,2,NULL),(4,84,2,NULL);

--
-- Table structure for table `llxqa_societe_contacts`
--

CREATE TABLE `llxqa_societe_contacts` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `date_creation` datetime NOT NULL,
  `fk_soc` int(11) NOT NULL,
  `fk_c_type_contact` int(11) NOT NULL,
  `fk_socpeople` int(11) NOT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `idx_societe_contacts_idx1` (`entity`,`fk_soc`,`fk_c_type_contact`,`fk_socpeople`),
  KEY `fk_societe_contacts_fk_c_type_contact` (`fk_c_type_contact`),
  KEY `fk_societe_contacts_fk_soc` (`fk_soc`),
  KEY `fk_societe_contacts_fk_socpeople` (`fk_socpeople`),
  CONSTRAINT `fk_societe_contacts_fk_c_type_contact` FOREIGN KEY (`fk_c_type_contact`) REFERENCES `llxqa_c_type_contact` (`rowid`),
  CONSTRAINT `fk_societe_contacts_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llxqa_societe` (`rowid`),
  CONSTRAINT `fk_societe_contacts_fk_socpeople` FOREIGN KEY (`fk_socpeople`) REFERENCES `llxqa_socpeople` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `llxqa_societe_contacts`
--


--
-- Table structure for table `llxqa_societe_extrafields`
--

CREATE TABLE `llxqa_societe_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_societe_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_societe_extrafields`
--


--
-- Table structure for table `llxqa_societe_log`
--

CREATE TABLE `llxqa_societe_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `datel` datetime DEFAULT NULL,
  `fk_soc` int(11) DEFAULT NULL,
  `fk_statut` int(11) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `author` varchar(30) DEFAULT NULL,
  `label` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_societe_log`
--


--
-- Table structure for table `llxqa_societe_prices`
--

CREATE TABLE `llxqa_societe_prices` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_soc` int(11) DEFAULT 0,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `datec` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `price_level` tinyint(4) DEFAULT 1,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_societe_prices`
--

INSERT INTO `llxqa_societe_prices` VALUES (1,236,'2020-06-03 17:28:05','2020-06-03 17:28:05',1,3),(2,227,'2020-06-17 13:12:39','2020-06-17 13:12:39',2,2),(3,237,'2020-07-02 13:04:36','2020-07-02 13:04:36',2,2),(4,240,'2020-08-13 15:23:50','2020-08-13 15:23:50',2,1);

--
-- Table structure for table `llxqa_societe_remise`
--

CREATE TABLE `llxqa_societe_remise` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `fk_soc` int(11) NOT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `datec` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `remise_client` double(6,3) NOT NULL DEFAULT 0.000,
  `note` text DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_societe_remise`
--

INSERT INTO `llxqa_societe_remise` VALUES (1,1,227,'2020-06-17 16:04:13','2020-06-17 16:04:13',2,50.000,'Lulu Moonshine Launch'),(2,1,237,'2020-07-02 13:11:37','2020-07-02 13:11:37',2,50.000,'Lulu Moonshine Launch promo');

--
-- Table structure for table `llxqa_societe_remise_except`
--

CREATE TABLE `llxqa_societe_remise_except` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `fk_soc` int(11) NOT NULL,
  `discount_type` int(11) NOT NULL DEFAULT 0,
  `datec` datetime DEFAULT NULL,
  `amount_ht` double(24,8) NOT NULL,
  `amount_tva` double(24,8) NOT NULL DEFAULT 0.00000000,
  `amount_ttc` double(24,8) NOT NULL DEFAULT 0.00000000,
  `tva_tx` double(6,3) NOT NULL DEFAULT 0.000,
  `fk_user` int(11) NOT NULL,
  `fk_facture_line` int(11) DEFAULT NULL,
  `fk_facture` int(11) DEFAULT NULL,
  `fk_facture_source` int(11) DEFAULT NULL,
  `fk_invoice_supplier_line` int(11) DEFAULT NULL,
  `fk_invoice_supplier` int(11) DEFAULT NULL,
  `fk_invoice_supplier_source` int(11) DEFAULT NULL,
  `description` text NOT NULL,
  `multicurrency_amount_ht` double(24,8) NOT NULL DEFAULT 0.00000000,
  `multicurrency_amount_tva` double(24,8) NOT NULL DEFAULT 0.00000000,
  `multicurrency_amount_ttc` double(24,8) NOT NULL DEFAULT 0.00000000,
  PRIMARY KEY (`rowid`),
  KEY `idx_societe_remise_except_fk_user` (`fk_user`),
  KEY `idx_societe_remise_except_fk_soc` (`fk_soc`),
  KEY `idx_societe_remise_except_fk_facture_line` (`fk_facture_line`),
  KEY `idx_societe_remise_except_fk_facture` (`fk_facture`),
  KEY `idx_societe_remise_except_fk_facture_source` (`fk_facture_source`),
  KEY `idx_societe_remise_except_discount_type` (`discount_type`),
  KEY `fk_soc_remise_fk_invoice_supplier_line` (`fk_invoice_supplier_line`),
  KEY `fk_societe_remise_fk_invoice_supplier_source` (`fk_invoice_supplier`),
  CONSTRAINT `fk_soc_remise_fk_facture_line` FOREIGN KEY (`fk_facture_line`) REFERENCES `llxqa_facturedet` (`rowid`),
  CONSTRAINT `fk_soc_remise_fk_invoice_supplier_line` FOREIGN KEY (`fk_invoice_supplier_line`) REFERENCES `llxqa_facture_fourn_det` (`rowid`),
  CONSTRAINT `fk_soc_remise_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llxqa_societe` (`rowid`),
  CONSTRAINT `fk_societe_remise_fk_facture` FOREIGN KEY (`fk_facture`) REFERENCES `llxqa_facture` (`rowid`),
  CONSTRAINT `fk_societe_remise_fk_facture_source` FOREIGN KEY (`fk_facture_source`) REFERENCES `llxqa_facture` (`rowid`),
  CONSTRAINT `fk_societe_remise_fk_invoice_supplier` FOREIGN KEY (`fk_invoice_supplier`) REFERENCES `llxqa_facture_fourn` (`rowid`),
  CONSTRAINT `fk_societe_remise_fk_invoice_supplier_source` FOREIGN KEY (`fk_invoice_supplier`) REFERENCES `llxqa_facture_fourn` (`rowid`),
  CONSTRAINT `fk_societe_remise_fk_user` FOREIGN KEY (`fk_user`) REFERENCES `llxqa_user` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_societe_remise_except`
--

INSERT INTO `llxqa_societe_remise_except` VALUES (1,1,144,0,'2019-07-18 13:00:58',1083000.00000000,108300.00000000,1191300.00000000,10.000,2,NULL,20,37,NULL,NULL,NULL,'(CREDIT_NOTE)',1083000.00000000,108300.00000000,1191300.00000000),(2,1,99,0,'2020-06-25 17:21:43',1097600.00000000,109760.00000000,1207360.00000000,10.000,2,NULL,16,55,NULL,NULL,NULL,'(CREDIT_NOTE)',1097600.00000000,109760.00000000,1207360.00000000);

--
-- Table structure for table `llxqa_societe_remise_supplier`
--

CREATE TABLE `llxqa_societe_remise_supplier` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `fk_soc` int(11) NOT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `datec` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `remise_supplier` double(6,3) NOT NULL DEFAULT 0.000,
  `note` text DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_societe_remise_supplier`
--


--
-- Table structure for table `llxqa_societe_rib`
--

CREATE TABLE `llxqa_societe_rib` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(32) NOT NULL,
  `label` varchar(200) DEFAULT NULL,
  `fk_soc` int(11) NOT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `bank` varchar(255) DEFAULT NULL,
  `code_banque` varchar(128) DEFAULT NULL,
  `code_guichet` varchar(6) DEFAULT NULL,
  `number` varchar(255) DEFAULT NULL,
  `cle_rib` varchar(5) DEFAULT NULL,
  `bic` varchar(20) DEFAULT NULL,
  `iban_prefix` varchar(34) DEFAULT NULL,
  `domiciliation` varchar(255) DEFAULT NULL,
  `proprio` varchar(60) DEFAULT NULL,
  `owner_address` varchar(255) DEFAULT NULL,
  `default_rib` smallint(6) NOT NULL DEFAULT 0,
  `rum` varchar(32) DEFAULT NULL,
  `date_rum` date DEFAULT NULL,
  `frstrecur` varchar(16) DEFAULT 'FRST',
  `last_four` varchar(4) DEFAULT NULL,
  `card_type` varchar(255) DEFAULT NULL,
  `cvn` varchar(255) DEFAULT NULL,
  `exp_date_month` int(11) DEFAULT NULL,
  `exp_date_year` int(11) DEFAULT NULL,
  `country_code` varchar(10) DEFAULT NULL,
  `approved` int(11) DEFAULT 0,
  `email` varchar(255) DEFAULT NULL,
  `ending_date` date DEFAULT NULL,
  `max_total_amount_of_all_payments` double(24,8) DEFAULT NULL,
  `preapproval_key` varchar(255) DEFAULT NULL,
  `starting_date` date DEFAULT NULL,
  `total_amount_of_all_payments` double(24,8) DEFAULT NULL,
  `stripe_card_ref` varchar(128) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `import_key` varchar(14) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `ipaddress` varchar(68) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_societe_rib` (`label`,`fk_soc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_societe_rib`
--


--
-- Table structure for table `llxqa_socpeople`
--

CREATE TABLE `llxqa_socpeople` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_soc` int(11) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `ref_ext` varchar(255) DEFAULT NULL,
  `civility` varchar(6) DEFAULT NULL,
  `lastname` varchar(50) DEFAULT NULL,
  `firstname` varchar(50) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `zip` varchar(25) DEFAULT NULL,
  `town` varchar(255) DEFAULT NULL,
  `fk_departement` int(11) DEFAULT NULL,
  `fk_pays` int(11) DEFAULT 0,
  `birthday` date DEFAULT NULL,
  `poste` varchar(80) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `phone_perso` varchar(30) DEFAULT NULL,
  `phone_mobile` varchar(30) DEFAULT NULL,
  `fax` varchar(30) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `socialnetworks` text DEFAULT NULL,
  `jabberid` varchar(255) DEFAULT NULL,
  `skype` varchar(255) DEFAULT NULL,
  `whatsapp` varchar(255) DEFAULT NULL,
  `linkedin` varchar(255) DEFAULT NULL,
  `youtube` varchar(255) DEFAULT NULL,
  `googleplus` varchar(255) DEFAULT NULL,
  `snapchat` varchar(255) DEFAULT NULL,
  `instagram` varchar(255) DEFAULT NULL,
  `facebook` varchar(255) DEFAULT NULL,
  `twitter` varchar(255) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `no_email` smallint(6) NOT NULL DEFAULT 0,
  `priv` smallint(6) NOT NULL DEFAULT 0,
  `fk_user_creat` int(11) DEFAULT 0,
  `fk_user_modif` int(11) DEFAULT NULL,
  `note_private` text DEFAULT NULL,
  `note_public` text DEFAULT NULL,
  `default_lang` varchar(6) DEFAULT NULL,
  `canvas` varchar(32) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `statut` tinyint(4) NOT NULL DEFAULT 1,
  PRIMARY KEY (`rowid`),
  KEY `idx_socpeople_fk_soc` (`fk_soc`),
  KEY `idx_socpeople_fk_user_creat` (`fk_user_creat`),
  CONSTRAINT `fk_socpeople_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llxqa_societe` (`rowid`),
  CONSTRAINT `fk_socpeople_user_creat_user_rowid` FOREIGN KEY (`fk_user_creat`) REFERENCES `llxqa_user` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_socpeople`
--

INSERT INTO `llxqa_socpeople` VALUES (1,'2018-12-04 19:50:29','2020-02-15 13:00:43',110,1,'','MR','Vergara','Pedro','','','',NULL,180,NULL,'','','0981 7744889','','','pedrovergara244@hotmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(2,'2018-12-09 14:44:08','2020-02-15 13:00:43',80,1,'','MME','Cardozo','Raquel','','','',NULL,180,NULL,'buyer','','','','','raquel@casarica.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,'','',NULL,NULL,NULL,1),(3,'2018-12-09 16:17:28','2020-02-15 13:00:43',112,1,'','','BGT','Alessia','','','',NULL,27,NULL,'','','','','','bgtselection@gmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,'','',NULL,NULL,NULL,1),(4,'2018-12-09 16:17:50','2020-02-15 13:00:43',112,1,'','MR','Guth','Thierry','','','',NULL,27,NULL,'','','','','','bgtselection1@gmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,1,1,'','',NULL,NULL,NULL,1),(5,'2018-12-19 15:02:32','2020-02-15 13:00:43',114,1,'','','Barnet','Fred','','','',NULL,11,NULL,'','','','','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,'','',NULL,NULL,NULL,1),(6,'2018-12-19 19:31:14','2020-02-15 13:00:43',115,1,'','MME','Ascencios','Lorena','','','',NULL,11,NULL,'buyer','','','','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,'','',NULL,NULL,NULL,1),(7,'2018-12-19 20:01:18','2020-02-15 13:00:43',93,1,'','MR','Corrales','Hugo','','','',NULL,180,NULL,'Gerente Comercial','','','0981144147','','hugo.corrales@cafsa.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(8,'2018-12-19 20:02:44','2020-02-15 13:00:43',94,1,'','MR','Morra','Miguel','','','',NULL,180,NULL,'','','','','','miguelmorra@todocarne.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(9,'2018-12-19 20:04:54','2020-02-15 13:00:43',98,1,'','','Administracion','','','','',NULL,180,NULL,'','','','','','administracion@grupolbdm.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(11,'2018-12-27 12:07:45','2020-02-15 13:00:43',93,1,'','MR','Carrillo','Justo','','','',NULL,180,NULL,'','','0972 139322','','','justo.carrillo@cafsa.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(12,'2018-12-27 12:42:26','2020-02-15 13:00:43',99,1,'','MR','Avila','Leonardo','','','',NULL,180,NULL,'','','','','','leonardoavilabbp@gmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(13,'2018-12-27 12:51:03','2020-02-15 13:00:43',100,1,'','','Martinez','Perla','','','',NULL,180,NULL,'','','','','','tiendamlopez@lacaoba.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,2,2,'','',NULL,NULL,NULL,1),(14,'2018-12-29 23:19:22','2020-02-15 13:00:43',123,1,'','','Szwako','Tatiana','','','',NULL,180,NULL,'','','','0983-564028','','tszwako@saporitidelparaguay.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,'','',NULL,NULL,NULL,1),(15,'2019-01-07 20:00:09','2020-02-15 13:00:43',122,1,'','MME','Quevedo','Maria Gloria','','','',NULL,180,NULL,'','','','0981210400','','mariagloria_quevedo@cadenareal.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(16,'2019-01-09 14:53:27','2020-02-15 13:00:43',128,1,'','MLE','Centurion','Rocio','','','',NULL,180,NULL,'','','','0981 977213','','sersano.py@gmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(17,'2019-01-10 17:39:24','2020-02-15 13:00:43',101,1,'','MR','Busto','Cayo','','','',NULL,180,NULL,'','','','0971686906','','cayobusto502@gmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,2,2,'','',NULL,NULL,NULL,1),(18,'2019-01-11 13:44:38','2020-02-15 13:00:43',105,1,'','','Ledezma','Diego','','','',NULL,180,NULL,'','','','0992268660','','tuichaite.pedidos@gmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(19,'2019-01-13 22:18:36','2020-02-15 13:00:43',129,1,'','','Lastname','Valery - Gabriel','','','',NULL,28,NULL,'','','','','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,'','',NULL,NULL,NULL,1),(20,'2019-01-14 19:40:38','2020-02-15 13:00:43',119,1,'','MLE','Roa','Perla','','','',NULL,180,NULL,'','','','0991389804','','perlaroa@elcacique.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,2,2,'','',NULL,NULL,NULL,1),(21,'2019-01-15 11:25:43','2020-02-15 13:00:43',101,1,'','MR','Gomez','Federico','','','',NULL,180,NULL,'','','','0981229643','','federicogomezmega@gmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(22,'2019-01-15 11:36:43','2020-02-15 13:00:43',96,1,'','MLE','Cabañas','Emilse','','','',NULL,180,NULL,'','','','','','emilse-cabanas@aj.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(23,'2019-01-15 11:57:49','2020-02-15 13:00:43',103,1,'','MLE','Cano','Villalba','','','',NULL,180,NULL,'','','','0985695120','','viviana.salemma@gmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(24,'2019-01-15 12:17:08','2020-02-15 13:00:43',130,1,'','MLE','Lopez','Josefina','','','',NULL,180,NULL,'','','','0972 165902','','comprastradicional@boxmayorista.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(25,'2019-01-15 12:21:29','2020-02-15 13:00:43',130,1,'','MLE','Paola','','','','',NULL,180,NULL,'','','','0972 165903','','compras@boxmayorista.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(26,'2019-01-15 16:10:01','2020-02-15 13:00:43',95,1,'','','Gonzalez','Joaco','','','',NULL,180,NULL,'','','','','','Joaquin.Gonzalez@biggie.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,'','',NULL,NULL,NULL,1),(27,'2019-01-15 17:06:07','2020-02-15 13:00:43',121,1,'','MR','Lopez','Alcides','','','',NULL,180,NULL,'','','','0985374083','','alcides.lopez24@gmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(28,'2019-01-15 18:33:12','2020-02-15 13:00:43',133,1,'','MR','Semidei','Eduardo','','','',NULL,180,NULL,'','','','0984302050','','esemidei@prv.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(29,'2019-01-15 18:33:12','2020-02-15 13:00:43',133,1,'','MR','Semidei','Eduardo','','','',NULL,180,NULL,'','','','0984302050','','esemidei@prv.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(30,'2019-01-16 13:40:08','2020-02-15 13:00:43',99,1,'','MR','Nuñez','Alcibiades','','','',NULL,180,NULL,'','','','0962 150713','','alcimaidana@hotmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(31,'2019-01-17 12:26:14','2020-02-15 13:00:43',143,1,'','MR','Coronel','Nelson','','','',NULL,180,NULL,'','','','0985 131269','','nelson.coronel@dipasa.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(32,'2019-01-17 13:00:21','2020-02-15 13:00:43',144,1,'','MR','Gonzalez','Ever','','','',NULL,180,NULL,'','','','','','sguarani@tigo.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(33,'2019-01-17 13:28:16','2020-02-15 13:00:43',145,1,'','MLE','Romero','Vilma','','','',NULL,180,NULL,'','','','','','vilmaromero@granviaelid.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(34,'2019-01-17 18:34:09','2020-02-15 13:00:43',146,1,'','MLE','Rodas','Laura','','','',NULL,180,NULL,'','','','','','laura.rodas@mundialt.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,2,2,'','',NULL,NULL,NULL,1),(35,'2019-01-18 13:13:45','2020-02-15 13:00:43',147,1,'','MR','Celia','Gustavo','','','',NULL,180,NULL,'','','','','','superpacifico@hotmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(36,'2019-01-28 16:33:14','2020-02-15 13:00:43',91,1,'','MR','Roberto','','','','',NULL,180,NULL,'','','','','','roberto@lapetisquera.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(37,'2019-01-28 16:44:36','2020-02-15 13:00:43',92,1,'','MLE','Villalba','Felicia','','','',NULL,180,NULL,'','','','','','bebidas@shoppingchina.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(38,'2019-01-28 16:50:18','2020-02-15 13:00:43',106,1,'','MLE','Dos Santos','Beatriz','','','',NULL,180,NULL,'','','','','','bebidas@fortis.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(39,'2019-01-30 12:34:02','2020-02-15 13:00:43',151,1,'','MLE','Diaz','Susana','','','',NULL,180,NULL,'','','','','','susanad@sancayetano.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(40,'2019-01-30 14:23:57','2020-02-15 13:00:43',90,1,'','MLE','Ortega','Rosa','','','',NULL,180,NULL,'','0973564807','','','','adega@cellshop.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(41,'2019-01-30 16:12:23','2020-02-15 13:00:43',86,1,'','MLE','Simone','','','','',NULL,180,NULL,'','0985902126','','0983712090','','queen_anne_bebidas@hotmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(42,'2019-01-31 18:44:07','2020-02-15 13:00:43',152,1,'','MR','Valiente','Pedro','','','',NULL,180,NULL,'','','','0971 780643','','krocme@yahoo.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,2,2,'','',NULL,NULL,NULL,1),(43,'2019-02-20 13:56:44','2020-02-15 13:00:43',153,1,'','MR','Caceres','Claudio','','','',NULL,180,NULL,'','','','0985 734886','','bebidas@mapy.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(44,'2019-02-20 14:12:34','2020-02-15 13:00:43',154,1,'','MR','Colman','Eder','','','',NULL,180,NULL,'','','','0973 565755','','edrcolman2015@gmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(45,'2019-02-27 17:21:13','2020-02-15 13:00:43',155,1,'','MLE','Rojas','Carmen','','','',NULL,180,NULL,'','','','','','gcia.comercial@luisito.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(46,'2019-02-27 18:57:42','2020-02-15 13:00:43',156,1,'','MLE','Ruiz','Celia','','','',NULL,180,NULL,'','','','0985788036','','tradicional@maxi.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(47,'2019-03-05 18:23:17','2020-02-15 13:00:43',87,1,'','MLE','Arevalos','Zuny','','','',NULL,180,NULL,'','','','0971 831453','','comestibles@planet-outlet.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,2,2,'','',NULL,NULL,NULL,1),(48,'2019-03-11 20:32:29','2020-02-15 13:00:43',114,1,'','','Barnet','Fred','','','',NULL,11,NULL,'','','','','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,'','',NULL,NULL,NULL,1),(49,'2019-03-12 18:53:58','2020-02-15 13:00:43',160,1,'','MLE','De Gasperi','Carolina','','','',NULL,180,NULL,'','','','','','cdegasperi@rapidito.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(50,'2019-03-14 12:59:11','2020-02-15 13:00:43',161,1,'','MR','Roa','Ricardo','','','',NULL,180,NULL,'','','','','','ricardo.roa@palmaroga.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(51,'2019-03-18 12:09:31','2020-02-15 13:00:43',162,1,'','MR','Torres','Humberto','','','',NULL,180,NULL,'','','','0984 118692','','htorres.vsofia@hotmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(52,'2019-03-21 18:28:41','2020-02-15 13:00:43',163,1,'','MLE','Martinez','Paola','','','',NULL,180,NULL,'','','','','','paola.martinez@monalisa.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(53,'2019-03-21 19:25:52','2020-02-15 13:00:43',89,1,'','','Lezcano','Joel','','','',NULL,180,NULL,'','','','','','bebidas@megashopping.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(54,'2019-04-11 15:02:42','2020-02-15 13:00:43',170,1,'','','Willi','','','','',NULL,180,NULL,'','','','0962 261255','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(55,'2019-07-04 19:14:21','2020-02-15 13:00:43',172,1,'','MR','Villar','Dario','','','',NULL,180,NULL,'','','','0982 315610','','cci-consultores@hotmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(56,'2019-07-04 20:33:24','2020-02-15 13:00:43',173,1,'','MR','Escobar','Nestor','','','',NULL,180,NULL,'','','','0971 323255','','nescobar@distribuidoraleon.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(57,'2019-07-23 14:30:24','2020-02-15 13:00:43',174,1,'','MR','Barbera','Jerry','','','',NULL,11,NULL,'President','','','','','azjb@icloud.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,2,2,'','',NULL,NULL,NULL,1),(58,'2019-08-09 18:14:41','2020-02-15 13:00:43',180,1,'','','Luis Felipe','Figueredo Vierci','','','',NULL,180,NULL,'','','0984 487776','','','ffigueredo@aj.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(59,'2019-08-09 18:20:53','2020-02-15 13:00:43',181,1,'','MLE','Cristaldo','Gilda','','','',NULL,180,NULL,'','','','','','compras@lti.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(60,'2019-08-09 18:24:31','2020-02-15 13:00:43',182,1,'','MLE','Marti','Nathalia','','','',NULL,180,NULL,'','','0986 516800','','','nathalia@comidasa.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(61,'2019-08-09 18:27:32','2020-02-15 13:00:43',183,1,'','','Mendieta','Sol','','','',NULL,180,NULL,'','021 2376787','0981 420757','','','smendieta@modiga.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(62,'2019-08-09 18:30:40','2020-02-15 13:00:43',184,1,'','MR','Oddone','Milko','','','',NULL,180,NULL,'','021-754-621','','0981 404 717','','milko@lacaoba.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(63,'2019-08-09 18:33:20','2020-02-15 13:00:43',185,1,'','MR','Belloto','Derlis','','','',NULL,180,NULL,'','','','','','derlisbelotto@vascol.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(64,'2019-08-09 18:34:04','2020-02-15 13:00:43',185,1,'','MR','Yaluff','Kevin','','','',NULL,180,NULL,'','','0985 249435','','','kevinyaluff@vascol.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,2,2,'','',NULL,NULL,NULL,1),(65,'2019-08-09 18:36:06','2020-02-15 13:00:43',186,1,'','MR','Avalos','Marcos','','','',NULL,180,NULL,'','','','','','mavalos@mgsrl.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(66,'2019-08-09 18:41:59','2020-02-15 13:00:43',187,1,'','MR','Osorio','Lucas','','','',NULL,180,NULL,'','','','','','lucas.osorio@brumado.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(67,'2019-08-09 18:46:17','2020-02-15 13:00:43',187,1,'','MR','Martinez','Cristobal','','','',NULL,180,NULL,'','','','','','asis.diroperativo@brumado.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(68,'2019-08-09 19:23:01','2020-02-15 13:00:43',188,1,'','MLE','Alcaraz','Estefania','','','',NULL,180,NULL,'','','','','','ealcaraz@grupo-acsa.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,2,2,'','',NULL,NULL,NULL,1),(69,'2019-08-09 19:32:51','2020-02-15 13:00:43',189,1,'','MR','Gonzalez','Juan de Rosa','','','',NULL,180,NULL,'','','','0982 225 948','','jgonzalez@rde.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(70,'2019-08-09 19:35:16','2020-02-15 13:00:43',190,1,'','MR','Daher','Omar','','','',NULL,180,NULL,'','','','','','omardaher@mguarani.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,2,2,'','',NULL,NULL,NULL,1),(71,'2019-08-09 19:38:38','2020-02-15 13:00:43',191,1,'','MR','Kennedy','Douglas','','','',NULL,180,NULL,'','','','','','dkennedy@londonimport.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(72,'2019-08-09 19:39:20','2020-02-15 13:00:43',191,1,'','MR','Kennedy','Christian','','','',NULL,180,NULL,'','','','','','ckennedy@londonimport.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(73,'2019-08-09 19:41:04','2020-02-15 13:00:43',192,1,'','MR','Mauroni','Luciano','','','',NULL,180,NULL,'','','','','','luciano_mauroni@codisa.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(74,'2019-08-09 19:54:02','2020-02-15 13:00:43',193,1,'','MLE','Reichardt','Sulema','','','',NULL,180,NULL,'','','','','','sulemarei@sigma.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(75,'2019-08-12 13:51:22','2020-02-15 13:00:43',194,1,'','MR','Gallo','Jorge','','','',NULL,180,NULL,'','','','0982152232','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(76,'2019-08-16 18:53:39','2020-02-15 13:00:43',197,1,'','MLE','Morabito','Franca','','','',NULL,180,NULL,'','','','','','franca@maahsa.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(77,'2019-08-30 19:41:25','2020-02-15 13:00:43',198,1,'','MR','Schlemper','Murilo','','','',NULL,56,NULL,'','','','','','muriloschlemper@sbbtrading.com.br','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(78,'2019-09-02 20:24:53','2020-02-15 13:00:43',199,1,'','MR','Siqueira Campos','Rinaldo','','','',NULL,56,NULL,'','','','','','siqueiracampos@siqueiracamppos.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,2,2,'','',NULL,NULL,NULL,1),(79,'2019-09-02 20:43:54','2020-02-15 13:00:43',200,1,'','MR','Rodrigo','Rodrigo','','','',930,56,NULL,'','','','','','ro_delfino@hotmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(81,'2019-09-04 14:01:31','2020-02-15 13:00:43',206,1,'','MR','Vargas','Julio','','','',NULL,56,NULL,'','','','','','julio.vargas@cantuimportadora.com.br','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(82,'2019-09-04 16:44:25','2020-02-15 13:00:43',211,1,'','','Irineu','Luz','','','',NULL,56,NULL,'','','','','','irineu@portoaporto.com.br','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(83,'2019-09-04 16:45:57','2020-02-15 13:00:43',211,1,'','','Podolak','Camila','','','',NULL,56,NULL,'','','','','','camila@portoaporto.com.br','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(84,'2019-09-05 14:50:12','2020-02-15 13:00:43',204,1,'','','Eduardo','','','','',NULL,56,NULL,'','','','','','eduardo@proencaimport.com.br','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(85,'2019-09-09 12:44:27','2020-02-15 13:00:43',213,1,'','MR','Martins de Almeida','Eloi','','','',NULL,180,NULL,'','','','','','eloi@casaflora.com.br','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(86,'2019-09-09 12:47:58','2020-02-15 13:00:43',213,1,'','MR','Lorio','Andre','','','',NULL,180,NULL,'','','','','','andre.lorio@casaflora.com.br','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,2,2,'','',NULL,NULL,NULL,1),(87,'2019-09-17 15:11:44','2020-02-15 13:00:43',218,1,'','MR','Tavares','Thiago','','','',NULL,180,NULL,'','','','0983690255','','thiago.tavares@jjpspirits.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(88,'2019-09-17 16:33:56','2020-02-15 13:00:43',215,1,'','','Diego','','','','',NULL,56,NULL,'','','','','','diego@mrman.com.br','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(89,'2019-10-06 01:09:05','2020-02-15 13:00:43',220,1,'','MR','Lasner','Dan','','','',NULL,11,NULL,'CEO','','','','','dan@worldwidelibations.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,'','',NULL,NULL,NULL,1),(91,'2019-11-01 17:47:44','2020-02-15 13:00:43',186,1,'','MLE','Flores','Nancy','','','',NULL,180,NULL,'','','','','','nflores@mgsrl.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(92,'2019-11-04 15:36:59','2020-02-15 13:00:43',225,1,'','MR','Ovando','Christian','','','',NULL,180,NULL,'','','','','','nova.srl.py@gmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(93,'2019-11-04 16:01:27','2020-02-15 13:00:43',226,1,'','MR','Bendlin','Roland','','','',NULL,180,NULL,'','','','','','r.bendlin@paraguaytrading.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(94,'2019-11-07 12:55:03','2020-02-15 13:00:43',227,1,'','MR','Galeano','Mauro','','','',NULL,180,NULL,'','','','','','mgaleano@purifru.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,2,2,'','',NULL,NULL,NULL,1),(95,'2019-11-07 13:09:50','2020-02-15 13:00:43',228,1,'','MR','Peters','Luis','','','',NULL,180,NULL,'','','','','','info@bebidasnativas.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,2,2,'','',NULL,NULL,NULL,1),(96,'2019-11-11 18:38:15','2020-02-15 13:00:43',223,1,'','','Amministrazione','','','','',NULL,3,NULL,'','','','','','amministrazione@roverpompe.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(97,'2019-11-26 13:45:57','2020-02-15 13:00:43',225,1,'','MR','Cardozo','Carlos','','','',NULL,180,NULL,'','','','0981751315','','karlosluis04@gmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(98,'2019-12-18 19:52:13','2020-02-15 13:00:43',230,1,'','MR','Bronstein','Dale','','','',NULL,11,NULL,'','','','','','polestar1@ymail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(99,'2020-05-25 13:23:24','2020-05-25 13:23:24',235,1,'','MR','Monges','Jose','','','',NULL,180,NULL,'','','','0985 800197','','jose.monges@tigo.net.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(100,'2020-06-03 17:06:11','2020-06-03 18:57:46',236,1,'','MR','Rojas','Pablo','','','',NULL,180,NULL,'','','','+595-986 655548','','Pablo.f.rojas@gmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,1,1,'','',NULL,NULL,NULL,1),(101,'2020-06-08 21:18:21','2020-06-08 21:18:21',95,1,'','','Macarena','Santacruz','','','',NULL,180,NULL,'Buyer','+595 982 259595','','','','macarena.santacruz@biggie.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,'','',NULL,NULL,NULL,1),(102,'2020-06-30 18:56:38','2020-06-30 18:56:38',237,1,'','MR','Torrents','Rafa','','','',NULL,180,NULL,'','','','','','raf.torrents@gmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(103,'2020-06-30 18:57:22','2020-06-30 18:57:22',237,1,'','MR','Torrents','Guillermo','','','',NULL,180,NULL,'','','','','','guille.torrents@gmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(104,'2020-06-30 18:58:44','2020-06-30 18:58:44',237,1,'','','Schmidt','Sebastian','','','',NULL,180,NULL,'','','','','','seba@sdmt.com.py','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(105,'2020-06-30 20:06:59','2020-06-30 20:06:59',238,1,'','MLE','Scavone','Ximena','','','',NULL,180,NULL,'','','','','','Ximena Scavone','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,2,2,'','',NULL,NULL,NULL,1),(106,'2020-10-13 19:09:06','2020-10-13 19:09:06',241,1,'','MR','Cañete','Pablo','','','',NULL,180,NULL,'CEO','','','','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,'','',NULL,NULL,NULL,1);

--
-- Table structure for table `llxqa_socpeople_extrafields`
--

CREATE TABLE `llxqa_socpeople_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_socpeople_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_socpeople_extrafields`
--


--
-- Table structure for table `llxqa_stock_mouvement`
--

CREATE TABLE `llxqa_stock_mouvement` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `datem` datetime DEFAULT NULL,
  `fk_product` int(11) NOT NULL,
  `batch` varchar(30) DEFAULT NULL,
  `eatby` date DEFAULT NULL,
  `sellby` date DEFAULT NULL,
  `fk_entrepot` int(11) NOT NULL,
  `value` double DEFAULT NULL,
  `price` double(24,8) DEFAULT 0.00000000,
  `type_mouvement` smallint(6) DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `inventorycode` varchar(128) DEFAULT NULL,
  `fk_origin` int(11) DEFAULT NULL,
  `origintype` varchar(32) DEFAULT NULL,
  `model_pdf` varchar(255) DEFAULT NULL,
  `fk_projet` int(11) NOT NULL DEFAULT 0,
  `fk_project` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_stock_mouvement_fk_product` (`fk_product`),
  KEY `idx_stock_mouvement_fk_entrepot` (`fk_entrepot`)
) ENGINE=InnoDB AUTO_INCREMENT=259 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_stock_mouvement`
--

INSERT INTO `llxqa_stock_mouvement` VALUES (1,'2018-12-19 14:09:57','2018-12-19 14:09:57',14,'MT1812/01',NULL,NULL,1,1848,0.00000000,0,2,'Stock correction for product Mango_Tropstler','181219140911',0,'',NULL,0,NULL),(2,'2018-12-26 17:40:47','2018-12-26 17:40:47',1,'LL-TL-1812-01',NULL,NULL,1,900,0.00000000,0,2,'Stock correction for product Lulu_Moonshine_-_Thorn_of_Love','181226173559',1,'project',NULL,0,NULL),(3,'2018-12-29 20:42:59','2018-12-29 20:42:59',4,'LL-LL-18-12-01','2020-12-31','2020-08-31',1,1200,6800.00000000,0,1,'Stock correction for product Lulu_Moonshine_-_Lemon_Lick','181229203744',0,'',NULL,0,NULL),(4,'2018-12-30 00:10:36','2018-12-30 00:10:36',1,'LL-TL-1812-01',NULL,NULL,1,-900,0.00000000,0,1,'Stock correction for product Lulu_Moonshine_-_Thorn_of_Love','181230000951',0,'',NULL,0,NULL),(5,'2018-12-30 01:07:23','2018-12-30 01:07:23',4,'LL-LL-18-12-01','2020-12-31','2020-08-31',1,1200,0.00000000,1,1,'Stock correction for product Lulu_Moonshine_-_Lemon_Lick','181230010703',1,'project',NULL,0,NULL),(6,'2018-12-30 01:09:03','2018-12-30 01:09:03',4,'LL-LL-18-12-01','2020-12-31','2020-08-31',1,-2400,0.00000000,0,1,'Stock correction for product Lulu_Moonshine_-_Lemon_Lick','181230010838',0,'',NULL,0,NULL),(7,'2018-12-30 01:23:52','2018-12-30 01:23:52',18,NULL,NULL,NULL,1,250,3800.00000000,3,1,'Receiving supplier order PO1812-0002',NULL,5,'order_supplier',NULL,0,NULL),(8,'2018-12-30 01:26:41','2018-12-30 01:26:41',18,NULL,NULL,NULL,1,-250,0.00000000,0,1,'Stock correction for product sugar_wht','181230012622',0,'',NULL,0,NULL),(9,'2018-12-30 01:27:28','2018-12-30 01:27:28',20,NULL,NULL,NULL,1,1000,4545.00000000,3,1,'Receiving supplier order PO1812-0003',NULL,6,'order_supplier',NULL,0,NULL),(10,'2018-12-30 01:27:28','2018-12-30 01:27:28',18,NULL,NULL,NULL,1,250,4545.00000000,3,1,'Receiving supplier order PO1812-0003',NULL,6,'order_supplier',NULL,0,NULL),(11,'2018-12-30 01:27:57','2018-12-30 01:27:57',18,NULL,NULL,NULL,1,250,3800.00000000,3,1,'Receiving supplier order PO1812-0002',NULL,5,'order_supplier',NULL,0,NULL),(12,'2018-12-30 01:28:56','2018-12-30 01:28:56',18,NULL,NULL,NULL,1,-250,0.00000000,0,1,'Stock correction for product sugar_wht','181230012845',0,'',NULL,0,NULL),(13,'2018-12-30 01:29:29','2018-12-30 01:29:29',18,NULL,NULL,NULL,1,250,3800.00000000,3,1,'Receiving supplier order PO1812-0002',NULL,5,'order_supplier',NULL,0,NULL),(14,'2018-12-30 01:32:29','2018-12-30 01:32:29',19,NULL,NULL,NULL,1,8000,739.00000000,3,1,'Receiving supplier order PO1812-0004',NULL,7,'order_supplier',NULL,0,NULL),(15,'2018-12-30 01:32:29','2018-12-30 01:32:29',21,NULL,NULL,NULL,1,8000,739.00000000,3,1,'Receiving supplier order PO1812-0004',NULL,7,'order_supplier',NULL,0,NULL),(16,'2018-12-30 01:36:14','2018-12-30 01:36:14',20,NULL,NULL,NULL,1,-125,0.00000000,1,1,'Product used for Direct production\r',NULL,0,'',NULL,0,NULL),(17,'2018-12-30 01:36:14','2018-12-30 01:36:14',21,NULL,NULL,NULL,1,-1000,1400.00000000,1,1,'Product used for Direct production\r',NULL,0,'',NULL,0,NULL),(18,'2018-12-30 01:36:14','2018-12-30 01:36:14',18,NULL,NULL,NULL,1,-125,6000.00000000,1,1,'Product used for Direct production\r',NULL,0,'',NULL,0,NULL),(19,'2018-12-30 01:40:54','2018-12-30 01:40:54',20,NULL,NULL,NULL,1,125,0.00000000,0,1,'Stock correction for product alcohol_95%','181230014047',0,'',NULL,0,NULL),(20,'2018-12-30 01:41:30','2018-12-30 01:41:30',18,NULL,NULL,NULL,1,125,0.00000000,0,1,'Stock correction for product sugar_wht','181230014114',0,'',NULL,0,NULL),(21,'2018-12-30 01:56:14','2018-12-30 01:56:14',21,NULL,NULL,NULL,1,1000,0.00000000,0,1,'Stock correction for product Aroma_Thron_of_Love','181230015607',0,'',NULL,0,NULL),(22,'2018-12-30 02:16:15','2018-12-17 23:59:59',20,NULL,NULL,NULL,1,-0.125,0.00000000,2,1,'Used Product(s) by Factory OF1812-00001\r',NULL,1,'factory',NULL,0,NULL),(23,'2018-12-30 02:16:15','2018-12-17 23:59:59',21,NULL,NULL,NULL,1,-1,0.00000000,2,1,'Used Product(s) by Factory OF1812-00001\r',NULL,1,'factory',NULL,0,NULL),(24,'2018-12-30 02:16:15','2018-12-17 23:59:59',18,NULL,NULL,NULL,1,-0.25,0.00000000,2,1,'Used Product(s) by Factory OF1812-00001\r',NULL,1,'factory',NULL,0,NULL),(25,'2018-12-30 02:19:39','2018-12-30 02:19:39',21,NULL,NULL,NULL,1,1,0.00000000,0,1,'Stock correction for product Aroma_Thron_of_Love','181230021930',0,'',NULL,0,NULL),(26,'2018-12-30 02:24:50','2018-12-30 02:24:50',20,NULL,NULL,NULL,1,0.125,0.00000000,0,1,'Stock correction for product alcohol_95%','181230022431',0,'',NULL,0,NULL),(27,'2018-12-30 02:25:19','2018-12-30 02:25:19',18,NULL,NULL,NULL,1,0.25,0.00000000,0,1,'Stock correction for product sugar_wht','181230022512',0,'',NULL,0,NULL),(28,'2018-12-30 02:29:47','2018-12-26 23:59:59',20,NULL,NULL,NULL,1,-0.125,0.00000000,2,1,'Used Product(s) by Factory OF1812-00002\r',NULL,2,'factory',NULL,0,NULL),(29,'2018-12-30 02:29:47','2018-12-26 23:59:59',19,NULL,NULL,NULL,1,-2000,0.00000000,2,1,'Used Product(s) by Factory OF1812-00002\r',NULL,2,'factory',NULL,0,NULL),(30,'2018-12-30 02:29:47','2018-12-26 23:59:59',18,NULL,NULL,NULL,1,-0.25,0.00000000,2,1,'Used Product(s) by Factory OF1812-00002\r',NULL,2,'factory',NULL,0,NULL),(31,'2018-12-30 02:36:15','2018-12-30 02:36:15',20,NULL,NULL,NULL,1,0.125,0.00000000,0,1,'Stock correction for product alcohol_95%','181230023601',0,'',NULL,0,NULL),(32,'2018-12-30 02:36:37','2018-12-30 02:36:37',19,NULL,NULL,NULL,1,2000,0.00000000,0,1,'Stock correction for product Aroma_Lemon_Lick','181230023631',0,'',NULL,0,NULL),(33,'2018-12-30 02:37:49','2018-12-30 02:37:49',18,NULL,NULL,NULL,1,0.25,0.00000000,0,1,'Stock correction for product sugar_wht','181230023742',0,'',NULL,0,NULL),(34,'2018-12-30 02:45:52','2018-12-12 23:59:59',18,NULL,NULL,NULL,1,-0.25,0.00000000,2,1,'Used Product(s) by Factory OF1812-00003\r',NULL,3,'factory',NULL,0,NULL),(35,'2018-12-30 02:45:52','2018-12-12 23:59:59',20,NULL,NULL,NULL,1,-0.125,0.00000000,2,1,'Used Product(s) by Factory OF1812-00003\r',NULL,3,'factory',NULL,0,NULL),(36,'2018-12-30 02:45:52','2018-12-12 23:59:59',21,NULL,NULL,NULL,1,-1,0.00000000,2,1,'Used Product(s) by Factory OF1812-00003\r',NULL,3,'factory',NULL,0,NULL),(37,'2018-12-30 02:47:23','2018-12-30 02:47:23',21,NULL,NULL,NULL,1,1,0.00000000,0,1,'Stock correction for product Aroma_Thron_of_Love','181230024718',0,'',NULL,0,NULL),(38,'2018-12-30 02:47:42','2018-12-30 02:47:42',20,NULL,NULL,NULL,1,0.25,0.00000000,0,1,'Stock correction for product alcohol_95%','181230024734',0,'',NULL,0,NULL),(39,'2018-12-30 02:48:07','2018-12-30 02:48:07',20,NULL,NULL,NULL,1,-0.125,0.00000000,0,1,'Stock correction for product alcohol_95%','181230024800',0,'',NULL,0,NULL),(40,'2018-12-30 02:48:36','2018-12-30 02:48:36',18,NULL,NULL,NULL,1,0.25,0.00000000,0,1,'Stock correction for product sugar_wht','181230024829',0,'',NULL,0,NULL),(41,'2018-12-30 02:51:22','2018-12-12 23:59:59',18,NULL,NULL,NULL,1,-0.25,0.00000000,2,1,'Used Product(s) by Factory OF1812-00004\r',NULL,4,'factory',NULL,0,NULL),(42,'2018-12-30 02:51:22','2018-12-12 23:59:59',20,NULL,NULL,NULL,1,-0.125,0.00000000,2,1,'Used Product(s) by Factory OF1812-00004\r',NULL,4,'factory',NULL,0,NULL),(43,'2018-12-30 02:51:22','2018-12-12 23:59:59',21,NULL,NULL,NULL,1,-1,0.00000000,2,1,'Used Product(s) by Factory OF1812-00004\r',NULL,4,'factory',NULL,0,NULL),(44,'2018-12-30 02:52:45','2018-12-30 02:52:45',20,NULL,NULL,NULL,1,0.125,0.00000000,0,1,'Stock correction for product alcohol_95%','181230025227',0,'',NULL,0,NULL),(45,'2018-12-30 02:53:01','2018-12-30 02:53:01',21,NULL,NULL,NULL,1,1,0.00000000,0,1,'Stock correction for product Aroma_Thron_of_Love','181230025257',0,'',NULL,0,NULL),(46,'2018-12-30 02:53:20','2018-12-30 02:53:20',18,NULL,NULL,NULL,1,0.25,0.00000000,0,1,'Stock correction for product sugar_wht','181230025313',0,'',NULL,0,NULL),(47,'2018-12-30 03:08:52','2018-12-30 03:08:52',24,NULL,NULL,NULL,1,16500,0.00000000,0,1,'Stock correction for product flip_top_bottle','181230030833',1,'project',NULL,0,NULL),(48,'2018-12-30 03:18:07','2018-12-30 03:18:07',20,NULL,NULL,NULL,1,7000,0.00000000,0,1,'Stock correction for product alcohol_20%','181230031746',0,'',NULL,0,NULL),(49,'2018-12-30 03:25:09','2018-12-12 23:59:59',18,NULL,NULL,NULL,1,-300,0.00000000,2,1,'Used Product(s) by Factory OF1812-00005\r',NULL,5,'factory',NULL,0,NULL),(50,'2018-12-30 03:25:09','2018-12-12 23:59:59',20,NULL,NULL,NULL,1,-1200,0.00000000,2,1,'Used Product(s) by Factory OF1812-00005\r',NULL,5,'factory',NULL,0,NULL),(51,'2018-12-30 03:25:09','2018-12-12 23:59:59',21,NULL,NULL,NULL,1,-1200,0.00000000,2,1,'Used Product(s) by Factory OF1812-00005\r',NULL,5,'factory',NULL,0,NULL),(52,'2018-12-30 03:25:09','2018-12-12 23:59:59',24,NULL,NULL,NULL,1,-1200,0.00000000,2,1,'Used Product(s) by Factory OF1812-00005\r',NULL,5,'factory',NULL,0,NULL),(53,'2018-12-30 03:29:55','2018-12-30 03:29:55',18,NULL,NULL,NULL,1,50,0.00000000,0,1,'Stock correction for product sugar_wht','181230032948',0,'',NULL,0,NULL),(54,'2018-12-30 03:30:56','2018-12-30 03:30:56',21,NULL,NULL,NULL,1,200,0.00000000,0,1,'Stock correction for product Aroma_Thron_of_Love','181230033049',0,'',NULL,0,NULL),(55,'2018-12-30 03:31:26','2018-12-30 03:31:26',20,NULL,NULL,NULL,1,200,0.00000000,0,1,'Stock correction for product 500ml_alcohol_20%','181230033121',0,'',NULL,0,NULL),(56,'2018-12-30 03:32:36','2018-12-30 03:32:36',21,NULL,NULL,NULL,1,1000,0.00000000,0,1,'Stock correction for product Aroma_Thron_of_Love','181230033230',0,'',NULL,0,NULL),(57,'2018-12-30 03:32:54','2018-12-30 03:32:54',20,NULL,NULL,NULL,1,1000,0.00000000,0,1,'Stock correction for product 500ml_alcohol_20%','181230033247',0,'',NULL,0,NULL),(58,'2018-12-30 03:33:21','2018-12-30 03:33:21',24,NULL,NULL,NULL,1,1200,0.00000000,0,1,'Stock correction for product flip_top_bottle','181230033311',0,'',NULL,0,NULL),(59,'2018-12-30 03:35:02','2018-12-12 23:59:59',18,NULL,NULL,NULL,1,-250,0.00000000,2,1,'Used Product(s) by Factory OF1812-00006\r',NULL,6,'factory',NULL,0,NULL),(60,'2018-12-30 03:35:02','2018-12-12 23:59:59',20,NULL,NULL,NULL,1,-1000,0.00000000,2,1,'Used Product(s) by Factory OF1812-00006\r',NULL,6,'factory',NULL,0,NULL),(61,'2018-12-30 03:35:02','2018-12-12 23:59:59',21,NULL,NULL,NULL,1,-1000,0.00000000,2,1,'Used Product(s) by Factory OF1812-00006\r',NULL,6,'factory',NULL,0,NULL),(62,'2018-12-30 03:35:02','2018-12-12 23:59:59',24,NULL,NULL,NULL,1,-1000,0.00000000,2,1,'Used Product(s) by Factory OF1812-00006\r',NULL,6,'factory',NULL,0,NULL),(63,'2018-12-30 03:41:19','2018-12-30 03:41:19',20,NULL,NULL,NULL,1,1000,0.00000000,0,1,'Stock correction for product 500ml_alcohol_20%','181230034110',0,'',NULL,0,NULL),(64,'2018-12-30 03:41:45','2018-12-30 03:41:45',21,NULL,NULL,NULL,1,1000,0.00000000,0,1,'Stock correction for product Aroma_Thron_of_Love','181230034139',0,'',NULL,0,NULL),(65,'2018-12-30 03:42:05','2018-12-30 03:42:05',24,NULL,NULL,NULL,1,1000,0.00000000,0,1,'Stock correction for product flip_top_bottle','181230034200',0,'',NULL,0,NULL),(66,'2018-12-30 03:42:35','2018-12-30 03:42:35',18,NULL,NULL,NULL,1,500,0.00000000,0,1,'Stock correction for product sugar_wht','181230034228',0,'',NULL,0,NULL),(67,'2018-12-30 03:44:48','2018-12-30 03:44:48',20,NULL,NULL,NULL,1,-125,0.00000000,1,1,'Product used for Direct production\r',NULL,0,'',NULL,0,NULL),(68,'2018-12-30 03:44:48','2018-12-30 03:44:48',19,NULL,NULL,NULL,1,-1000,1400.00000000,1,1,'Product used for Direct production\r',NULL,0,'',NULL,0,NULL),(69,'2018-12-30 03:44:48','2018-12-30 03:44:48',24,NULL,NULL,NULL,1,-1000,0.00000000,1,1,'Product used for Direct production\r',NULL,0,'',NULL,0,NULL),(70,'2018-12-30 03:44:48','2018-12-30 03:44:48',18,NULL,NULL,NULL,1,-250,6000.00000000,1,1,'Product used for Direct production\r',NULL,0,'',NULL,0,NULL),(71,'2018-12-30 03:45:16','2018-12-30 03:45:16',18,NULL,NULL,NULL,1,250,0.00000000,0,1,'Stock correction for product sugar_wht','181230034509',0,'',NULL,0,NULL),(72,'2018-12-30 03:45:35','2018-12-30 03:45:35',19,NULL,NULL,NULL,1,1000,0.00000000,0,1,'Stock correction for product Aroma_Lemon_Lick','181230034526',0,'',NULL,0,NULL),(73,'2018-12-30 03:45:58','2018-12-30 03:45:58',20,NULL,NULL,NULL,1,125,0.00000000,0,1,'Stock correction for product 500ml_alcohol_20%','181230034548',0,'',NULL,0,NULL),(74,'2018-12-30 03:47:41','2018-12-30 03:47:41',20,NULL,NULL,NULL,1,-7000,0.00000000,0,1,'Stock correction for product 500ml_alcohol_20%','181230034735',0,'',NULL,0,NULL),(75,'2018-12-30 03:48:19','2018-12-30 03:48:19',24,NULL,NULL,NULL,1,1000,0.00000000,0,1,'Stock correction for product flip_top_bottle','181230034814',0,'',NULL,0,NULL),(76,'2018-12-30 03:55:38','2018-12-12 23:59:59',18,NULL,NULL,NULL,1,-0.25,0.00000000,2,1,'Used Product(s) by Factory OF1812-00007\r',NULL,7,'factory',NULL,0,NULL),(77,'2018-12-30 03:55:38','2018-12-12 23:59:59',19,NULL,NULL,NULL,1,-1,0.00000000,2,1,'Used Product(s) by Factory OF1812-00007\r',NULL,7,'factory',NULL,0,NULL),(78,'2018-12-30 03:55:38','2018-12-12 23:59:59',20,NULL,NULL,NULL,1,-0.125,0.00000000,2,1,'Used Product(s) by Factory OF1812-00007\r',NULL,7,'factory',NULL,0,NULL),(79,'2018-12-30 03:55:38','2018-12-12 23:59:59',24,NULL,NULL,NULL,1,-1,0.00000000,2,1,'Used Product(s) by Factory OF1812-00007\r',NULL,7,'factory',NULL,0,NULL),(80,'2018-12-30 03:57:02','2018-12-30 03:57:02',20,NULL,NULL,NULL,1,1,0.00000000,0,1,'Stock correction for product 500ml_alcohol_20%','181230035658',0,'',NULL,0,NULL),(81,'2018-12-30 03:57:26','2018-12-30 03:57:26',20,NULL,NULL,NULL,1,-0.875,0.00000000,0,1,'Stock correction for product 500ml_alcohol_20%','181230035717',0,'',NULL,0,NULL),(82,'2018-12-30 03:57:42','2018-12-30 03:57:42',19,NULL,NULL,NULL,1,1,0.00000000,0,1,'Stock correction for product Aroma_Lemon_Lick','181230035738',0,'',NULL,0,NULL),(83,'2018-12-30 03:58:06','2018-12-30 03:58:06',24,NULL,NULL,NULL,1,1,0.00000000,0,1,'Stock correction for product flip_top_bottle','181230035759',0,'',NULL,0,NULL),(84,'2018-12-30 03:58:07','2018-12-30 03:58:07',24,NULL,NULL,NULL,1,1,0.00000000,0,1,'Stock correction for product flip_top_bottle','181230035759',0,'',NULL,0,NULL),(85,'2018-12-30 03:58:17','2018-12-30 03:58:17',24,NULL,NULL,NULL,1,-1,0.00000000,0,1,'Stock correction for product flip_top_bottle','181230035811',0,'',NULL,0,NULL),(86,'2018-12-30 03:58:39','2018-12-30 03:58:39',18,NULL,NULL,NULL,1,1,0.00000000,0,1,'Stock correction for product sugar_wht','181230035834',0,'',NULL,0,NULL),(87,'2018-12-30 03:59:50','2018-12-30 03:59:50',18,NULL,NULL,NULL,1,-0.75,0.00000000,0,1,'Stock correction for product sugar_wht','181230035934',0,'',NULL,0,NULL),(88,'2018-12-30 04:23:45','2018-12-30 04:23:45',20,NULL,NULL,NULL,1,-125,0.00000000,1,1,'Product used for Direct production\r',NULL,0,'',NULL,0,NULL),(89,'2018-12-30 04:23:45','2018-12-30 04:23:45',21,NULL,NULL,NULL,1,-1000,1400.00000000,1,1,'Product used for Direct production\r',NULL,0,'',NULL,0,NULL),(90,'2018-12-30 04:23:45','2018-12-30 04:23:45',24,NULL,NULL,NULL,1,-1000,0.00000000,1,1,'Product used for Direct production\r',NULL,0,'',NULL,0,NULL),(91,'2018-12-30 04:23:45','2018-12-30 04:23:45',18,NULL,NULL,NULL,1,-250,0.00000000,1,1,'Product used for Direct production\r',NULL,0,'',NULL,0,NULL),(92,'2018-12-30 04:25:05','2018-12-30 04:25:05',20,NULL,NULL,NULL,1,-125,0.00000000,1,1,'Product used for Direct production\r',NULL,0,'',NULL,0,NULL),(93,'2018-12-30 04:25:05','2018-12-30 04:25:05',21,NULL,NULL,NULL,1,-1000,1400.00000000,1,1,'Product used for Direct production\r',NULL,0,'',NULL,0,NULL),(94,'2018-12-30 04:25:05','2018-12-30 04:25:05',24,NULL,NULL,NULL,1,-1000,0.00000000,1,1,'Product used for Direct production\r',NULL,0,'',NULL,0,NULL),(95,'2018-12-30 04:25:05','2018-12-30 04:25:05',18,NULL,NULL,NULL,1,-250,0.00000000,1,1,'Product used for Direct production\r',NULL,0,'',NULL,0,NULL),(96,'2018-12-30 04:27:23','2018-12-30 04:27:23',18,NULL,NULL,NULL,1,500,0.00000000,0,1,'Stock correction for product sugar_wht','181230042715',0,'',NULL,0,NULL),(97,'2018-12-30 04:28:02','2018-12-30 04:28:02',21,NULL,NULL,NULL,1,2000,0.00000000,0,1,'Stock correction for product Aroma_Thron_of_Love','181230042751',0,'',NULL,0,NULL),(98,'2018-12-30 04:28:21','2018-12-30 04:28:21',20,NULL,NULL,NULL,1,250,0.00000000,0,1,'Stock correction for product 500ml_alcohol_20%','181230042814',0,'',NULL,0,NULL),(99,'2018-12-30 04:28:39','2018-12-30 04:28:39',24,NULL,NULL,NULL,1,2000,0.00000000,0,1,'Stock correction for product flip_top_bottle','181230042832',0,'',NULL,0,NULL),(100,'2018-12-30 04:32:28','2018-12-21 23:59:59',18,NULL,NULL,NULL,1,-250,0.00000000,2,1,'Used Product(s) by Factory OF1812-00008\r',NULL,8,'factory',NULL,0,NULL),(101,'2018-12-30 04:32:28','2018-12-21 23:59:59',20,NULL,NULL,NULL,1,-125,0.00000000,2,1,'Used Product(s) by Factory OF1812-00008\r',NULL,8,'factory',NULL,0,NULL),(102,'2018-12-30 04:32:28','2018-12-21 23:59:59',21,NULL,NULL,NULL,1,-1000,0.00000000,2,1,'Used Product(s) by Factory OF1812-00008\r',NULL,8,'factory',NULL,0,NULL),(103,'2018-12-30 04:32:28','2018-12-21 23:59:59',24,NULL,NULL,NULL,1,-1000,0.00000000,2,1,'Used Product(s) by Factory OF1812-00008\r',NULL,8,'factory',NULL,0,NULL),(104,'2018-12-30 04:45:47','2018-12-30 04:45:47',4,NULL,'2018-12-21',NULL,1,1000,0.00000000,3,1,'Built Product(s) by Factory OF1812-00007\r',NULL,7,'factory',NULL,0,NULL),(105,'2018-12-30 15:57:29','2018-12-30 15:57:29',20,NULL,NULL,NULL,1,125,0.00000000,0,1,'Stock correction for product 500ml_alcohol_20%','181230155720',0,'',NULL,0,NULL),(106,'2018-12-30 15:58:24','2018-12-30 15:58:24',20,NULL,NULL,NULL,1,7000,0.00000000,0,1,'Stock correction for product 500ml_alcohol_20%','181230155818',0,'',NULL,0,NULL),(107,'2018-12-30 15:59:17','2018-12-30 15:59:17',21,NULL,NULL,NULL,1,1000,0.00000000,0,1,'Stock correction for product Aroma_Thron_of_Love','181230155912',0,'',NULL,0,NULL),(108,'2018-12-30 15:59:39','2018-12-30 15:59:39',18,NULL,NULL,NULL,1,250,0.00000000,0,1,'Stock correction for product sugar_wht','181230155933',0,'',NULL,0,NULL),(109,'2018-12-30 16:31:17','2018-12-30 16:31:17',26,NULL,NULL,NULL,1,1000,0.00000000,0,1,'Stock correction for product alcohol_95%','181230163111',0,'',NULL,0,NULL),(110,'2018-12-30 16:32:28','2018-12-30 16:32:28',20,NULL,NULL,NULL,1,-8000,0.00000000,0,1,'Stock correction for product 500ml_alcohol_20%','181230163222',0,'',NULL,0,NULL),(111,'2018-12-30 16:34:15','2018-12-30 16:34:15',26,NULL,NULL,NULL,1,-1000,0.00000000,1,1,'Product used for Direct production\r',NULL,0,'',NULL,0,NULL),(112,'2018-12-30 16:34:15','2018-12-30 16:34:15',27,NULL,NULL,NULL,1,8000,0.00000000,0,1,'produced from a direct production\r',NULL,0,'',NULL,0,NULL),(113,'2018-12-30 16:37:42','2018-12-30 16:37:42',24,NULL,NULL,NULL,1,1000,0.00000000,0,1,'Stock correction for product flip_top_bottle','181230163734',0,'',NULL,0,NULL),(114,'2018-12-30 16:38:12','2018-12-30 16:38:12',4,NULL,NULL,NULL,1,-1000,0.00000000,0,1,'Stock correction for product Lulu_Moonshine_-_Lemon_Lick','181230163800',0,'',NULL,0,NULL),(115,'2018-12-30 16:52:16','2018-12-30 16:52:16',27,NULL,NULL,NULL,1,-1000,0.00000000,1,1,'Product used for Direct production\r',NULL,0,'',NULL,0,NULL),(116,'2018-12-30 16:52:16','2018-12-30 16:52:16',21,NULL,NULL,NULL,1,-1000,0.00000000,1,1,'Product used for Direct production\r',NULL,0,'',NULL,0,NULL),(117,'2018-12-30 16:52:16','2018-12-30 16:52:16',24,NULL,NULL,NULL,1,-1000,0.00000000,1,1,'Product used for Direct production\r',NULL,0,'',NULL,0,NULL),(118,'2018-12-30 16:52:16','2018-12-30 16:52:16',18,NULL,NULL,NULL,1,-250,0.00000000,1,1,'Product used for Direct production\r',NULL,0,'',NULL,0,NULL),(119,'2018-12-30 16:52:16','2018-12-30 16:52:16',1,NULL,NULL,NULL,1,1000,1735.75000000,0,1,'produced from a direct production\r',NULL,0,'',NULL,0,NULL),(120,'2018-12-30 16:54:56','2018-12-27 23:59:59',18,NULL,NULL,NULL,1,-0.25,0.00000000,2,1,'Used Product(s) by Factory OF1812-00010\r',NULL,10,'factory',NULL,0,NULL),(121,'2018-12-30 16:54:56','2018-12-27 23:59:59',19,NULL,NULL,NULL,1,-1,1400.00000000,2,1,'Used Product(s) by Factory OF1812-00010\r',NULL,10,'factory',NULL,0,NULL),(122,'2018-12-30 16:54:56','2018-12-27 23:59:59',24,NULL,NULL,NULL,1,-1,0.00000000,2,1,'Used Product(s) by Factory OF1812-00010\r',NULL,10,'factory',NULL,0,NULL),(123,'2018-12-30 16:54:56','2018-12-27 23:59:59',27,NULL,NULL,NULL,1,-1,0.00000000,2,1,'Used Product(s) by Factory OF1812-00010\r',NULL,10,'factory',NULL,0,NULL),(124,'2018-12-30 16:55:17','2018-12-30 16:55:17',4,NULL,'2019-01-11',NULL,1,1000,1.73575000,3,1,'Built Product(s) by Factory OF1812-00010\r',NULL,10,'factory',NULL,0,NULL),(125,'2018-12-30 16:55:57','2018-12-30 16:55:57',18,NULL,NULL,NULL,1,-249,0.00000000,0,1,'Stock correction for product sugar_wht','181230165551',0,'',NULL,0,NULL),(126,'2018-12-30 16:56:52','2018-12-30 16:56:52',18,NULL,NULL,NULL,1,-0.75,0.00000000,0,1,'Stock correction for product sugar_wht','181230165642',0,'',NULL,0,NULL),(127,'2019-01-10 13:06:51','2019-01-10 13:06:51',16,NULL,NULL,NULL,1,408,0.00000000,0,2,'Stock correction for product Sesame_oil','190110130434',0,'',NULL,0,NULL),(128,'2019-01-10 13:09:14','2019-01-10 13:09:14',7,NULL,NULL,NULL,1,594,0.00000000,0,2,'Stock correction for product Tahini_320_gr.','190110130903',0,'',NULL,0,NULL),(129,'2019-01-10 13:15:35','2019-01-10 13:15:35',8,NULL,NULL,NULL,1,606,0.00000000,0,2,'Stock correction for product Marianne_750ml','190110131458',0,'',NULL,0,NULL),(130,'2019-01-10 14:25:24','2019-01-10 14:25:24',9,NULL,NULL,NULL,1,186,0.00000000,0,2,'Stock correction for product Agricole_750_ml','190110142452',0,'',NULL,0,NULL),(131,'2019-01-16 17:53:58','2019-01-16 17:53:58',15,NULL,NULL,NULL,1,504,0.00000000,0,2,'Stock correction for product Bierschnaps','190116173723',0,'',NULL,0,NULL),(132,'2019-02-05 17:00:11','2019-02-05 17:00:11',10,NULL,NULL,NULL,1,618,0.00000000,0,2,'Stock correction for product Gold_750_ml','190205165929',0,'',NULL,0,NULL),(133,'2020-05-16 21:09:11','2020-05-16 21:09:11',1,'LL-TL-1812-01',NULL,NULL,1,-3,20000.00000000,2,1,'Shipment SH2005-0024 validated',NULL,31,'shipping',NULL,0,NULL),(134,'2020-05-16 21:09:12','2020-05-16 21:09:11',8,NULL,NULL,NULL,1,-1,120000.00000000,2,1,'Shipment SH2005-0024 validated',NULL,31,'shipping',NULL,0,NULL),(135,'2020-05-16 21:09:12','2020-05-16 21:09:12',9,NULL,NULL,NULL,1,-1,110000.00000000,2,1,'Shipment SH2005-0024 validated',NULL,31,'shipping',NULL,0,NULL),(136,'2020-05-16 21:09:12','2020-05-16 21:09:12',4,NULL,NULL,NULL,1,-3,20000.00000000,2,1,'Shipment SH2005-0024 validated',NULL,31,'shipping',NULL,0,NULL),(137,'2020-05-16 21:09:12','2020-05-16 21:09:12',15,NULL,NULL,NULL,1,-1,0.00000000,2,1,'Shipment SH2005-0024 validated',NULL,31,'shipping',NULL,0,NULL),(138,'2020-06-22 19:09:05','2020-06-22 19:09:05',3,'001',NULL,NULL,1,2000,0.00000000,0,2,'momentary correction - needs to be corrected','200622190629',0,'',NULL,0,NULL),(139,'2020-06-22 19:10:27','2020-06-22 19:10:27',2,'001',NULL,NULL,1,2000,0.00000000,0,2,'momentary correction - needs to be corrected','200622191012',0,'',NULL,0,NULL),(140,'2020-06-22 19:12:12','2020-06-22 19:12:12',10,'001',NULL,NULL,1,720,0.00000000,0,2,'momentary correction - needs to be corrected','200622191140',0,'',NULL,0,NULL),(141,'2020-06-22 19:12:44','2020-06-22 19:12:44',2,'001',NULL,NULL,1,-408,15000.00000000,2,2,'Shipment SH2006-0025 validated',NULL,34,'shipping',NULL,0,NULL),(142,'2020-06-22 19:12:44','2020-06-22 19:12:44',3,'001',NULL,NULL,1,-408,15000.00000000,2,2,'Shipment SH2006-0025 validated',NULL,34,'shipping',NULL,0,NULL),(143,'2020-06-22 19:12:44','2020-06-22 19:12:44',1,'LL-TL-1812-01',NULL,NULL,1,-408,15000.00000000,2,2,'Shipment SH2006-0025 validated',NULL,34,'shipping',NULL,0,NULL),(144,'2020-06-22 19:12:44','2020-06-22 19:12:44',10,'001',NULL,NULL,1,-36,110000.00000000,2,2,'Shipment SH2006-0025 validated',NULL,34,'shipping',NULL,0,NULL),(145,'2020-06-22 19:12:44','2020-06-22 19:12:44',4,NULL,NULL,NULL,1,-408,15000.00000000,2,2,'Shipment SH2006-0025 validated',NULL,34,'shipping',NULL,0,NULL),(146,'2020-06-22 19:12:44','2020-06-22 19:12:44',9,NULL,NULL,NULL,1,-48,110000.00000000,2,2,'Shipment SH2006-0025 validated',NULL,34,'shipping',NULL,0,NULL),(147,'2020-06-22 19:12:44','2020-06-22 19:12:44',8,NULL,NULL,NULL,1,-72,120000.00000000,2,2,'Shipment SH2006-0025 validated',NULL,34,'shipping',NULL,0,NULL),(148,'2020-06-23 13:32:26','2020-06-23 13:32:26',40,NULL,NULL,NULL,1,10944,0.00000000,0,2,'import 02/2020','200623133152',0,'',NULL,0,NULL),(149,'2020-06-23 13:33:49','2020-06-23 13:33:49',42,NULL,NULL,NULL,1,11000,0.00000000,0,2,'import 02/2020','200623133330',0,'',NULL,0,NULL),(150,'2020-06-23 13:36:15','2020-06-23 13:36:15',48,NULL,NULL,NULL,1,2760,0.00000000,0,2,'Stock correction for product Label_Marianne_40%_700_ml','200623133546',0,'',NULL,0,NULL),(151,'2020-06-23 13:37:23','2020-06-23 13:37:23',48,NULL,NULL,NULL,1,-560,0.00000000,1,2,'Stock correction for product Label_Marianne_40%_700_ml','200623133656',0,'',NULL,0,NULL),(152,'2020-06-23 13:38:03','2020-06-23 13:38:03',49,NULL,NULL,NULL,1,2200,0.00000000,0,2,'Stock correction for product back_label_marianne_40%_700_ml','200623133753',0,'',NULL,0,NULL),(153,'2020-06-23 13:39:49','2020-06-23 13:39:49',52,NULL,NULL,NULL,1,2700,0.00000000,0,2,'Stock correction for product back_label_marianne_54%_700_ml','200623133941',0,'',NULL,0,NULL),(154,'2020-06-23 13:40:34','2020-06-23 13:40:34',51,NULL,NULL,NULL,1,2100,0.00000000,0,2,'Stock correction for product Label_Marianne_54%_700_ml','200623134014',0,'',NULL,0,NULL),(155,'2020-06-23 14:20:26','2020-06-23 14:20:26',40,NULL,NULL,NULL,1,1238,0.00000000,0,2,'First import 2016','200623141528',0,'',NULL,0,NULL),(156,'2020-06-23 14:22:42','2020-06-23 14:22:42',39,NULL,NULL,NULL,1,2754,0.00000000,0,2,'import 2015','200623142209',0,'',NULL,0,NULL),(157,'2020-06-23 19:21:23','2020-06-23 19:21:23',41,NULL,NULL,NULL,1,22000,0.00000000,0,2,'Import 2019','200623192052',0,'',NULL,0,NULL),(158,'2020-06-23 19:25:05','2020-06-23 19:25:05',53,NULL,NULL,NULL,1,4224,0.00000000,0,2,'Import 2019','200623192337',0,'',NULL,0,NULL),(159,'2020-06-23 19:35:41','2020-06-23 19:35:41',41,NULL,NULL,NULL,1,-2448,0.00000000,1,2,'Export 2019','200623193516',0,'',NULL,0,NULL),(160,'2020-06-23 19:48:03','2020-06-23 19:48:03',47,NULL,NULL,NULL,1,1900,0.00000000,0,2,'Yaguarete 06/2019','200623194437',0,'',NULL,0,NULL),(161,'2020-06-23 19:48:50','2020-06-23 19:48:50',47,NULL,NULL,NULL,1,-204,0.00000000,1,2,'export 2019','200623194820',0,'',NULL,0,NULL),(162,'2020-06-26 12:48:46','2020-06-26 12:48:46',2,'001',NULL,NULL,1,408,0.00000000,3,2,'Shipment SH2006-0025 deleted',NULL,0,'',NULL,0,NULL),(163,'2020-06-26 12:48:46','2020-06-26 12:48:46',3,'001',NULL,NULL,1,408,0.00000000,3,2,'Shipment SH2006-0025 deleted',NULL,0,'',NULL,0,NULL),(164,'2020-06-26 12:48:46','2020-06-26 12:48:46',4,NULL,NULL,NULL,1,408,0.00000000,3,2,'Shipment SH2006-0025 deleted',NULL,0,'',NULL,0,NULL),(165,'2020-06-26 12:48:46','2020-06-26 12:48:46',1,'LL-TL-1812-01',NULL,NULL,1,408,0.00000000,3,2,'Shipment SH2006-0025 deleted',NULL,0,'',NULL,0,NULL),(166,'2020-06-26 12:48:46','2020-06-26 12:48:46',10,'001',NULL,NULL,1,36,0.00000000,3,2,'Shipment SH2006-0025 deleted',NULL,0,'',NULL,0,NULL),(167,'2020-06-26 12:48:46','2020-06-26 12:48:46',9,NULL,NULL,NULL,1,48,0.00000000,3,2,'Shipment SH2006-0025 deleted',NULL,0,'',NULL,0,NULL),(168,'2020-06-26 12:48:46','2020-06-26 12:48:46',8,NULL,NULL,NULL,1,72,0.00000000,3,2,'Shipment SH2006-0025 deleted',NULL,0,'',NULL,0,NULL),(169,'2020-07-01 16:14:13','2020-07-01 16:14:13',4,'Milk bottles',NULL,NULL,1,1392,0.00000000,0,2,'Stock correction for product Lulu_Moonshine_-_Lemon_Lick','200701160912',0,'',NULL,0,NULL),(170,'2020-07-01 16:22:39','2020-07-01 16:22:39',3,'001',NULL,NULL,1,-2000,0.00000000,1,2,'Stock correction for product Lulu_Moonshine_-_Strawberry_Nights','200701162152',0,'',NULL,0,NULL),(171,'2020-07-01 16:23:43','2020-07-01 16:23:43',3,'Milk bottles',NULL,NULL,1,1296,0.00000000,0,2,'Stock correction for product Lulu_Moonshine_-_Strawberry_Nights','200701162252',0,'',NULL,0,NULL),(172,'2020-07-01 16:24:12','2020-07-01 16:24:12',3,'Flip top bottles',NULL,NULL,1,1908,0.00000000,0,2,'Stock correction for product Lulu_Moonshine_-_Strawberry_Nights','200701162352',0,'',NULL,0,NULL),(173,'2020-07-01 16:58:43','2020-07-01 16:58:43',2,'001',NULL,NULL,1,-2000,0.00000000,1,2,'Stock correction for product Lulu_Moonshine_-_Chocolate_Lust','200701165820',0,'',NULL,0,NULL),(174,'2020-07-01 16:59:21','2020-07-01 16:59:21',2,'Flip top bottles',NULL,NULL,1,1836,0.00000000,0,2,'Stock correction for product Lulu_Moonshine_-_Chocolate_Lust','200701165848',0,'',NULL,0,NULL),(175,'2020-07-01 16:59:57','2020-07-01 16:59:57',2,'Milk bottles',NULL,NULL,1,1020,0.00000000,0,2,'Stock correction for product Lulu_Moonshine_-_Chocolate_Lust','200701165927',0,'',NULL,0,NULL),(176,'2020-07-01 17:01:31','2020-07-01 17:01:31',4,'001',NULL,NULL,1,-2389,0.00000000,1,2,'Stock correction for product Lulu_Moonshine_-_Lemon_Lick','200701170120',0,'',NULL,0,NULL),(177,'2020-07-01 17:01:54','2020-07-01 17:01:54',4,'Milk bottles',NULL,NULL,1,1393,0.00000000,0,2,'Stock correction for product Lulu_Moonshine_-_Lemon_Lick','200701170136',0,'',NULL,0,NULL),(178,'2020-07-01 17:03:52','2020-07-01 17:03:52',4,'Flip top bottles',NULL,NULL,1,3504,0.00000000,0,2,'Stock correction for product Lulu_Moonshine_-_Lemon_Lick','200701170316',0,'',NULL,0,NULL),(179,'2020-07-01 17:05:59','2020-07-01 17:05:59',1,'001',NULL,NULL,1,-997,0.00000000,1,2,'Stock correction for product Lulu_Moonshine_-_Thorn_of_Love','200701170534',0,'',NULL,0,NULL),(180,'2020-07-01 17:06:45','2020-07-01 17:06:45',1,'Flip top bottles',NULL,NULL,1,3612,0.00000000,0,2,'Stock correction for product Lulu_Moonshine_-_Thorn_of_Love','200701170604',0,'',NULL,0,NULL),(181,'2020-07-01 17:57:08','2020-07-01 17:57:08',1,'Milk bottles',NULL,NULL,1,1490,0.00000000,0,2,'Stock correction for product Lulu_Moonshine_-_Thorn_of_Love','200701175604',0,'',NULL,0,NULL),(182,'2020-07-03 12:13:03','2020-07-03 12:13:03',10,'001',NULL,NULL,1,-516,0.00000000,1,2,'Stock correction for product Gold_750_ml','200703121231',0,'',NULL,0,NULL),(183,'2020-07-03 12:16:53','2020-07-03 12:16:53',9,NULL,NULL,NULL,1,-125,0.00000000,1,2,'Stock correction for product Agricole_750_ml','200703121522',0,'',NULL,0,NULL),(184,'2020-07-03 12:19:56','2020-07-03 12:19:56',8,NULL,NULL,NULL,1,-173,0.00000000,1,2,'Stock correction for product Marianne_750_ml','200703121939',0,'',NULL,0,NULL),(185,'2020-07-03 12:23:00','2020-07-03 12:23:00',41,NULL,NULL,NULL,1,-5300,0.00000000,1,2,'production 2019','200703122159',0,'',NULL,0,NULL),(186,'2020-07-03 12:57:09','2020-07-03 12:57:09',24,NULL,NULL,NULL,1,-13171,0.00000000,1,2,'Stock correction for product flip_top_bottle','200703125606',0,'',NULL,0,NULL),(187,'2020-07-03 12:59:19','2020-07-03 12:59:19',54,NULL,NULL,NULL,1,1894,0.00000000,0,2,'Stock correction for product 390_ml_Jar','200703125910',0,'',NULL,0,NULL),(188,'2020-07-03 17:53:23','2020-07-03 17:53:23',2,'Milk bottles',NULL,NULL,1,-408,15000.00000000,2,2,'Shipment SH2007-0025 validated',NULL,37,'shipping',NULL,0,NULL),(189,'2020-07-03 17:53:23','2020-07-03 17:53:23',3,'Milk bottles',NULL,NULL,1,-408,15000.00000000,2,2,'Shipment SH2007-0025 validated',NULL,37,'shipping',NULL,0,NULL),(190,'2020-07-03 17:53:23','2020-07-03 17:53:23',4,'Milk bottles',NULL,NULL,1,-408,15000.00000000,2,2,'Shipment SH2007-0025 validated',NULL,37,'shipping',NULL,0,NULL),(191,'2020-07-03 18:21:11','2020-07-03 18:21:11',1,'Milk bottles',NULL,NULL,1,-408,15000.00000000,2,2,'Shipment SH2007-0026 validated',NULL,38,'shipping',NULL,0,NULL),(192,'2020-07-03 18:21:11','2020-07-03 18:21:11',10,'001',NULL,NULL,1,-36,110000.00000000,2,2,'Shipment SH2007-0026 validated',NULL,38,'shipping',NULL,0,NULL),(193,'2020-07-03 18:21:11','2020-07-03 18:21:11',9,NULL,NULL,NULL,1,-48,110000.00000000,2,2,'Shipment SH2007-0026 validated',NULL,38,'shipping',NULL,0,NULL),(194,'2020-07-03 18:21:11','2020-07-03 18:21:11',8,NULL,NULL,NULL,1,-72,120000.00000000,2,2,'Shipment SH2007-0026 validated',NULL,38,'shipping',NULL,0,NULL),(195,'2020-07-06 16:04:57','2020-07-06 16:04:57',7,NULL,NULL,NULL,1,-594,0.00000000,1,2,'Stock correction for product Tahini_320_gr.','200706160445',0,'',NULL,0,NULL),(196,'2020-07-06 16:08:17','2020-07-06 16:08:17',16,NULL,NULL,NULL,1,-408,0.00000000,1,2,'Stock correction for product Sesame_oil','200706160749',0,'',NULL,0,NULL),(197,'2020-07-06 20:17:22','2020-07-06 20:17:22',4,'Flip top bottles',NULL,NULL,1,-12,12000.00000000,2,2,'Shipment SH2007-0027 validated',NULL,39,'shipping',NULL,0,NULL),(198,'2020-07-06 20:17:22','2020-07-06 20:17:22',1,'Flip top bottles',NULL,NULL,1,-12,12000.00000000,2,2,'Shipment SH2007-0027 validated',NULL,39,'shipping',NULL,0,NULL),(199,'2020-07-30 20:22:52','2020-07-30 20:22:52',52,NULL,NULL,NULL,1,400,95.00000000,0,2,'Stock correction for product back_label_marianne_54%_700_ml','200730202203',0,'',NULL,0,NULL),(200,'2020-07-30 20:24:31','2020-07-30 20:24:31',49,NULL,NULL,NULL,1,1890,95.00000000,0,2,'Stock correction for product back_label_marianne_40%_700_ml','200730202349',0,'',NULL,0,NULL),(201,'2020-07-30 20:25:59','2020-07-30 20:25:59',48,NULL,NULL,NULL,1,2120,565.00000000,0,2,'Stock correction for product Label_Marianne_40%_700_ml','200730202533',0,'',NULL,0,NULL),(202,'2020-07-30 20:29:49','2020-07-30 20:29:49',55,NULL,NULL,NULL,1,3620,95.00000000,0,2,'Stock correction for product back_label_armadillo_700_ml','200730202912',0,'',NULL,0,NULL),(203,'2020-07-30 20:32:02','2020-07-30 20:32:02',56,NULL,NULL,NULL,1,3570,380.00000000,0,2,'Stock correction for product Label_Armadillo_spiced_rum_700_ml','200730203135',0,'',NULL,0,NULL),(204,'2020-08-13 15:41:27','2020-08-13 15:41:27',30,'AD1905/01',NULL,NULL,1,32,0.00000000,0,2,'Stock correction for product Armadillo_french_oak_700_ml','200813154026',0,'',NULL,0,NULL),(205,'2020-08-13 15:49:34','2020-08-13 15:49:34',50,NULL,NULL,NULL,1,3000,0.00000000,0,2,'Stock correction for product lote_neckband_sticker','200813154914',0,'',NULL,0,NULL),(206,'2020-08-13 16:02:01','2020-08-13 16:02:01',43,NULL,NULL,NULL,1,36000,20.00000000,0,2,'Stock correction for product Shrink_top_plastic_01','200813160058',0,'',NULL,0,NULL),(207,'2020-08-13 16:05:24','2020-08-13 16:05:24',45,NULL,NULL,NULL,1,1080,0.00000000,0,2,'Stock correction for product cardboard_box_01','200813160514',0,'',NULL,0,NULL),(208,'2020-08-13 16:07:10','2020-08-13 16:07:10',40,NULL,NULL,NULL,1,-1440,0.00000000,1,2,'Product used for Direct production',NULL,0,'',NULL,0,NULL),(209,'2020-08-13 16:07:10','2020-08-13 16:07:10',52,NULL,NULL,NULL,1,-1680.000000048,0.00000000,1,2,'Product used for Direct production',NULL,0,'',NULL,0,NULL),(210,'2020-08-13 16:07:10','2020-08-13 16:07:10',45,NULL,NULL,NULL,1,-239.99999904,0.00000000,1,2,'Product used for Direct production',NULL,0,'',NULL,0,NULL),(211,'2020-08-13 16:07:10','2020-08-13 16:07:10',42,NULL,NULL,NULL,1,-1440,0.00000000,1,2,'Product used for Direct production',NULL,0,'',NULL,0,NULL),(212,'2020-08-13 16:07:10','2020-08-13 16:07:10',51,NULL,NULL,NULL,1,-1680.000000048,0.00000000,1,2,'Product used for Direct production',NULL,0,'',NULL,0,NULL),(213,'2020-08-13 16:07:10','2020-08-13 16:07:10',50,NULL,NULL,NULL,1,-1440,0.00000000,1,2,'Product used for Direct production',NULL,0,'',NULL,0,NULL),(214,'2020-08-13 16:07:10','2020-08-13 16:07:10',43,NULL,NULL,NULL,1,-1440,0.00000000,1,2,'Product used for Direct production',NULL,0,'',NULL,0,NULL),(215,'2020-08-13 16:07:10','2020-08-13 16:07:10',31,NULL,NULL,NULL,1,1440,130.83333334,0,2,'produced from a direct production',NULL,0,'',NULL,0,NULL),(216,'2020-08-13 18:25:17','2020-08-13 18:25:17',54,NULL,NULL,NULL,1,-306,0.00000000,1,2,'306 jars sold 13/07/2020','200813182437',0,'',NULL,0,NULL),(217,'2020-08-19 12:41:09','2020-08-19 12:41:09',38,NULL,NULL,NULL,1,4,0.00000000,0,2,'Stock correction for product Kchiporro_Py_40%','200819124059',0,'',NULL,0,NULL),(218,'2020-08-19 12:44:06','2020-08-19 12:44:06',9,NULL,NULL,NULL,1,-6,110000.00000000,2,2,'Shipment SH2008-0028 validated',NULL,40,'shipping',NULL,0,NULL),(219,'2020-08-19 12:44:06','2020-08-19 12:44:06',10,'001',NULL,NULL,1,-6,110000.00000000,2,2,'Shipment SH2008-0028 validated',NULL,40,'shipping',NULL,0,NULL),(220,'2020-08-19 12:44:06','2020-08-19 12:44:06',8,NULL,NULL,NULL,1,-6,120000.00000000,2,2,'Shipment SH2008-0028 validated',NULL,40,'shipping',NULL,0,NULL),(221,'2020-08-19 12:44:06','2020-08-19 12:44:06',30,'AD1905/01',NULL,NULL,1,-9,90000.00000000,2,2,'Shipment SH2008-0028 validated',NULL,40,'shipping',NULL,0,NULL),(222,'2020-08-19 12:44:06','2020-08-19 12:44:06',2,'Milk bottles',NULL,NULL,1,-12,20000.00000000,2,2,'Shipment SH2008-0028 validated',NULL,40,'shipping',NULL,0,NULL),(223,'2020-08-19 12:44:06','2020-08-19 12:44:06',4,'Milk bottles',NULL,NULL,1,-12,20000.00000000,2,2,'Shipment SH2008-0028 validated',NULL,40,'shipping',NULL,0,NULL),(224,'2020-08-19 12:44:06','2020-08-19 12:44:06',3,'Milk bottles',NULL,NULL,1,-12,20000.00000000,2,2,'Shipment SH2008-0028 validated',NULL,40,'shipping',NULL,0,NULL),(225,'2020-08-19 12:44:06','2020-08-19 12:44:06',1,'Milk bottles',NULL,NULL,1,-12,20000.00000000,2,2,'Shipment SH2008-0028 validated',NULL,40,'shipping',NULL,0,NULL),(226,'2020-08-19 12:44:06','2020-08-19 12:44:06',38,NULL,NULL,NULL,1,-3,120000.00000000,2,2,'Shipment SH2008-0028 validated',NULL,40,'shipping',NULL,0,NULL),(227,'2020-08-24 13:48:16','2020-08-24 13:48:16',50,NULL,NULL,NULL,1,30000,40.00000000,0,2,'Stock correction for product lote_neckband_sticker','200824134730',0,'',NULL,0,NULL),(228,'2020-09-09 19:16:48','2020-09-09 19:16:48',40,NULL,NULL,NULL,1,-1461,0.00000000,1,2,'Product used for Direct production',NULL,0,'',NULL,0,NULL),(229,'2020-09-09 19:16:48','2020-09-09 19:16:48',55,NULL,NULL,NULL,1,-1704.5000000487,0.00000000,1,2,'Product used for Direct production',NULL,0,'',NULL,0,NULL),(230,'2020-09-09 19:16:48','2020-09-09 19:16:48',45,NULL,NULL,NULL,1,-243.499999026,0.00000000,1,2,'Product used for Direct production',NULL,0,'',NULL,0,NULL),(231,'2020-09-09 19:16:48','2020-09-09 19:16:48',42,NULL,NULL,NULL,1,-1461,0.00000000,1,2,'Product used for Direct production',NULL,0,'',NULL,0,NULL),(232,'2020-09-09 19:16:48','2020-09-09 19:16:48',56,NULL,NULL,NULL,1,-1704.5000000487,0.00000000,1,2,'Product used for Direct production',NULL,0,'',NULL,0,NULL),(233,'2020-09-09 19:16:48','2020-09-09 19:16:48',50,NULL,NULL,NULL,1,-1461,0.00000000,1,2,'Product used for Direct production',NULL,0,'',NULL,0,NULL),(234,'2020-09-09 19:16:48','2020-09-09 19:16:48',43,NULL,NULL,NULL,1,-1461,0.00000000,1,2,'Product used for Direct production',NULL,0,'',NULL,0,NULL),(235,'2020-09-09 19:16:48','2020-09-09 19:16:48',57,NULL,NULL,NULL,1,1461,614.16666668,0,2,'produced from a direct production',NULL,0,'',NULL,0,NULL),(236,'2020-09-09 20:00:00','2020-09-09 20:00:00',40,NULL,NULL,NULL,1,-2929,0.00000000,1,2,'Product used for Direct production',NULL,0,'',NULL,0,NULL),(237,'2020-09-09 20:00:00','2020-09-09 20:00:00',49,NULL,NULL,NULL,1,-3417.166664714,0.00000000,1,2,'Product used for Direct production',NULL,0,'',NULL,0,NULL),(238,'2020-09-09 20:00:00','2020-09-09 20:00:00',45,NULL,NULL,NULL,1,-488.166664714,0.00000000,1,2,'Product used for Direct production',NULL,0,'',NULL,0,NULL),(239,'2020-09-09 20:00:00','2020-09-09 20:00:00',42,NULL,NULL,NULL,1,-2929,0.00000000,1,2,'Product used for Direct production',NULL,0,'',NULL,0,NULL),(240,'2020-09-09 20:00:00','2020-09-09 20:00:00',48,NULL,NULL,NULL,1,-3417.166664714,0.00000000,1,2,'Product used for Direct production',NULL,0,'',NULL,0,NULL),(241,'2020-09-09 20:00:00','2020-09-09 20:00:00',50,NULL,NULL,NULL,1,-2929,0.00000000,1,2,'Product used for Direct production',NULL,0,'',NULL,0,NULL),(242,'2020-09-09 20:00:00','2020-09-09 20:00:00',43,NULL,NULL,NULL,1,-2929,0.00000000,1,2,'Product used for Direct production',NULL,0,'',NULL,0,NULL),(243,'2020-09-10 19:13:20','2020-09-10 19:13:20',11,'MP2008/01',NULL,NULL,1,2929,0.00000000,0,2,'Stock correction for product Marianne_700_ml','200910191221',0,'',NULL,0,NULL),(244,'2020-09-10 19:15:10','2020-09-10 19:15:10',54,NULL,NULL,NULL,1,-300,0.00000000,1,2,'300 jars sold 02/08/2020','200910191408',0,'',NULL,0,NULL),(245,'2020-09-10 19:16:56','2020-09-10 19:16:56',54,NULL,NULL,NULL,1,-100,0.00000000,1,2,'100 jars sold 29/07/2020','200910191533',0,'',NULL,0,NULL),(246,'2020-09-15 17:22:12','2020-09-15 17:22:12',4,'Milk bottles',NULL,NULL,1,-60,15000.00000000,2,2,'Shipment SH2009-0029 validated',NULL,41,'shipping',NULL,0,NULL),(247,'2020-09-15 17:22:12','2020-09-15 17:22:12',3,'Milk bottles',NULL,NULL,1,-60,15000.00000000,2,2,'Shipment SH2009-0029 validated',NULL,41,'shipping',NULL,0,NULL),(248,'2020-09-15 17:22:12','2020-09-15 17:22:12',9,NULL,NULL,NULL,1,-6,110000.00000000,2,2,'Shipment SH2009-0029 validated',NULL,41,'shipping',NULL,0,NULL),(249,'2020-09-15 17:22:12','2020-09-15 17:22:12',10,'001',NULL,NULL,1,-36,110000.00000000,2,2,'Shipment SH2009-0029 validated',NULL,41,'shipping',NULL,0,NULL),(250,'2020-09-15 17:22:12','2020-09-15 17:22:12',8,NULL,NULL,NULL,1,-18,120000.00000000,2,2,'Shipment SH2009-0029 validated',NULL,41,'shipping',NULL,0,NULL),(251,'2020-09-28 12:23:59','2020-09-28 12:23:59',15,NULL,NULL,NULL,1,-95,0.00000000,1,2,'Stock correction for product Bierschnaps','200928122335',0,'',NULL,0,NULL),(252,'2020-09-28 12:43:21','2020-09-28 12:43:21',12,NULL,NULL,NULL,1,96,0.00000000,0,2,'Stock correction for product Gold_700_ml','200928124253',0,'',NULL,0,NULL),(253,'2020-10-20 19:22:09','2020-10-20 19:22:09',10,'001',NULL,NULL,1,-60,110000.00000000,2,2,'Shipment SH2010-0030 validated',NULL,42,'shipping',NULL,0,NULL),(254,'2020-10-20 19:22:09','2020-10-20 19:22:09',8,NULL,NULL,NULL,1,-18,120000.00000000,2,2,'Shipment SH2010-0030 validated',NULL,42,'shipping',NULL,0,NULL),(255,'2020-10-20 19:22:09','2020-10-20 19:22:09',1,'Milk bottles',NULL,NULL,1,-60,15000.00000000,2,2,'Shipment SH2010-0030 validated',NULL,42,'shipping',NULL,0,NULL),(256,'2020-10-20 19:22:09','2020-10-20 19:22:09',4,'Milk bottles',NULL,NULL,1,-84,15000.00000000,2,2,'Shipment SH2010-0030 validated',NULL,42,'shipping',NULL,0,NULL),(257,'2020-10-20 19:22:09','2020-10-20 19:22:09',3,'Milk bottles',NULL,NULL,1,-144,15000.00000000,2,2,'Shipment SH2010-0030 validated',NULL,42,'shipping',NULL,0,NULL),(258,'2020-10-20 19:22:09','2020-10-20 19:22:09',15,NULL,NULL,NULL,1,-120,31818.00000000,2,2,'Shipment SH2010-0030 validated',NULL,42,'shipping',NULL,0,NULL);

--
-- Table structure for table `llxqa_subscription`
--

CREATE TABLE `llxqa_subscription` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `datec` datetime DEFAULT NULL,
  `fk_adherent` int(11) DEFAULT NULL,
  `dateadh` datetime DEFAULT NULL,
  `datef` date DEFAULT NULL,
  `subscription` double(24,8) DEFAULT NULL,
  `fk_bank` int(11) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `fk_type` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_subscription` (`fk_adherent`,`dateadh`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_subscription`
--


--
-- Table structure for table `llxqa_supplier_proposal`
--

CREATE TABLE `llxqa_supplier_proposal` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `ref_ext` varchar(255) DEFAULT NULL,
  `ref_int` varchar(255) DEFAULT NULL,
  `fk_soc` int(11) DEFAULT NULL,
  `fk_projet` int(11) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `datec` datetime DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `date_cloture` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `fk_user_cloture` int(11) DEFAULT NULL,
  `fk_statut` smallint(6) NOT NULL DEFAULT 0,
  `price` double DEFAULT 0,
  `remise_percent` double DEFAULT 0,
  `remise_absolue` double DEFAULT 0,
  `remise` double DEFAULT 0,
  `total_ht` double(24,8) DEFAULT 0.00000000,
  `tva` double(24,8) DEFAULT 0.00000000,
  `localtax1` double(24,8) DEFAULT 0.00000000,
  `localtax2` double(24,8) DEFAULT 0.00000000,
  `total` double(24,8) DEFAULT 0.00000000,
  `fk_account` int(11) DEFAULT NULL,
  `fk_currency` varchar(3) DEFAULT NULL,
  `fk_cond_reglement` int(11) DEFAULT NULL,
  `fk_mode_reglement` int(11) DEFAULT NULL,
  `note_private` text DEFAULT NULL,
  `note_public` text DEFAULT NULL,
  `model_pdf` varchar(255) DEFAULT NULL,
  `last_main_doc` varchar(255) DEFAULT NULL,
  `date_livraison` date DEFAULT NULL,
  `fk_shipping_method` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT 1.00000000,
  `multicurrency_total_ht` double(24,8) DEFAULT 0.00000000,
  `multicurrency_total_tva` double(24,8) DEFAULT 0.00000000,
  `multicurrency_total_ttc` double(24,8) DEFAULT 0.00000000,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_supplier_proposal`
--


--
-- Table structure for table `llxqa_supplier_proposal_extrafields`
--

CREATE TABLE `llxqa_supplier_proposal_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_supplier_proposal_extrafields`
--


--
-- Table structure for table `llxqa_supplier_proposaldet`
--

CREATE TABLE `llxqa_supplier_proposaldet` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_supplier_proposal` int(11) NOT NULL,
  `fk_parent_line` int(11) DEFAULT NULL,
  `fk_product` int(11) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `fk_remise_except` int(11) DEFAULT NULL,
  `vat_src_code` varchar(10) DEFAULT '',
  `tva_tx` double(6,3) DEFAULT 0.000,
  `localtax1_tx` double(6,3) DEFAULT 0.000,
  `localtax1_type` varchar(10) DEFAULT NULL,
  `localtax2_tx` double(6,3) DEFAULT 0.000,
  `localtax2_type` varchar(10) DEFAULT NULL,
  `qty` double DEFAULT NULL,
  `remise_percent` double DEFAULT 0,
  `remise` double DEFAULT 0,
  `price` double DEFAULT NULL,
  `subprice` double(24,8) DEFAULT 0.00000000,
  `total_ht` double(24,8) DEFAULT 0.00000000,
  `total_tva` double(24,8) DEFAULT 0.00000000,
  `total_localtax1` double(24,8) DEFAULT 0.00000000,
  `total_localtax2` double(24,8) DEFAULT 0.00000000,
  `total_ttc` double(24,8) DEFAULT 0.00000000,
  `product_type` int(11) DEFAULT 0,
  `info_bits` int(11) DEFAULT 0,
  `buy_price_ht` double(24,8) DEFAULT 0.00000000,
  `fk_product_fournisseur_price` int(11) DEFAULT NULL,
  `special_code` int(11) DEFAULT 0,
  `rang` int(11) DEFAULT 0,
  `ref_fourn` varchar(30) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_subprice` double(24,8) DEFAULT 0.00000000,
  `multicurrency_total_ht` double(24,8) DEFAULT 0.00000000,
  `multicurrency_total_tva` double(24,8) DEFAULT 0.00000000,
  `multicurrency_total_ttc` double(24,8) DEFAULT 0.00000000,
  `fk_unit` int(11) DEFAULT NULL,
  `date_start` datetime DEFAULT NULL,
  `date_end` datetime DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_supplier_proposaldet_fk_supplier_proposal` (`fk_supplier_proposal`),
  KEY `idx_supplier_proposaldet_fk_product` (`fk_product`),
  KEY `fk_supplier_proposaldet_fk_unit` (`fk_unit`),
  CONSTRAINT `fk_supplier_proposaldet_fk_supplier_proposal` FOREIGN KEY (`fk_supplier_proposal`) REFERENCES `llxqa_supplier_proposal` (`rowid`),
  CONSTRAINT `fk_supplier_proposaldet_fk_unit` FOREIGN KEY (`fk_unit`) REFERENCES `llxqa_c_units` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_supplier_proposaldet`
--


--
-- Table structure for table `llxqa_supplier_proposaldet_extrafields`
--

CREATE TABLE `llxqa_supplier_proposaldet_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_supplier_proposaldet_extrafields`
--


--
-- Table structure for table `llxqa_takepos_floor_tables`
--

CREATE TABLE `llxqa_takepos_floor_tables` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `label` varchar(255) DEFAULT NULL,
  `leftpos` float DEFAULT NULL,
  `toppos` float DEFAULT NULL,
  `floor` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `llxqa_takepos_floor_tables`
--


--
-- Table structure for table `llxqa_ticket`
--

CREATE TABLE `llxqa_ticket` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) DEFAULT 1,
  `ref` varchar(128) NOT NULL,
  `track_id` varchar(128) NOT NULL,
  `fk_soc` int(11) DEFAULT 0,
  `fk_project` int(11) DEFAULT 0,
  `origin_email` varchar(128) DEFAULT NULL,
  `fk_user_create` int(11) DEFAULT NULL,
  `fk_user_assign` int(11) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `fk_statut` int(11) DEFAULT NULL,
  `resolution` int(11) DEFAULT NULL,
  `progress` varchar(100) DEFAULT NULL,
  `timing` varchar(20) DEFAULT NULL,
  `type_code` varchar(32) DEFAULT NULL,
  `category_code` varchar(32) DEFAULT NULL,
  `severity_code` varchar(32) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `date_read` datetime DEFAULT NULL,
  `date_close` datetime DEFAULT NULL,
  `notify_tiers_at_create` tinyint(4) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_ticket_track_id` (`track_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_ticket`
--


--
-- Table structure for table `llxqa_ticket_extrafields`
--

CREATE TABLE `llxqa_ticket_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_ticket_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_ticket_extrafields`
--


--
-- Table structure for table `llxqa_tva`
--

CREATE TABLE `llxqa_tva` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `datec` datetime DEFAULT NULL,
  `datep` date DEFAULT NULL,
  `datev` date DEFAULT NULL,
  `amount` double(24,8) NOT NULL DEFAULT 0.00000000,
  `fk_typepayment` int(11) DEFAULT NULL,
  `num_payment` varchar(50) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `note` text DEFAULT NULL,
  `fk_bank` int(11) DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_tva`
--


--
-- Table structure for table `llxqa_user_alert`
--

CREATE TABLE `llxqa_user_alert` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(11) DEFAULT NULL,
  `fk_contact` int(11) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_user_alert`
--


--
-- Table structure for table `llxqa_user_clicktodial`
--

CREATE TABLE `llxqa_user_clicktodial` (
  `fk_user` int(11) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `login` varchar(32) DEFAULT NULL,
  `pass` varchar(64) DEFAULT NULL,
  `poste` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`fk_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_user_clicktodial`
--


--
-- Table structure for table `llxqa_user_employment`
--

CREATE TABLE `llxqa_user_employment` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `ref` varchar(50) DEFAULT NULL,
  `ref_ext` varchar(50) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `job` varchar(128) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `salary` double(24,8) DEFAULT NULL,
  `salaryextra` double(24,8) DEFAULT NULL,
  `weeklyhours` double(16,8) DEFAULT NULL,
  `dateemployment` date DEFAULT NULL,
  `dateemploymentend` date DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_user_employment` (`ref`,`entity`),
  KEY `fk_user_employment_fk_user` (`fk_user`),
  CONSTRAINT `fk_user_employment_fk_user` FOREIGN KEY (`fk_user`) REFERENCES `llxqa_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_user_employment`
--


--
-- Table structure for table `llxqa_user_extrafields`
--

CREATE TABLE `llxqa_user_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_user_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_user_extrafields`
--


--
-- Table structure for table `llxqa_user_param`
--

CREATE TABLE `llxqa_user_param` (
  `fk_user` int(11) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `param` varchar(180) NOT NULL,
  `value` text NOT NULL,
  UNIQUE KEY `uk_user_param` (`fk_user`,`param`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_user_param`
--

INSERT INTO `llxqa_user_param` VALUES (1,1,'MAIN_SELECTEDFIELDS_orderlist','country.code_iso,c.ref,s.nom,c.date_commande,c.total_ht,c.fk_statut,c.facture,'),(1,1,'MAIN_SELECTEDFIELDS_proposallist','country.code_iso,p.ref,s.nom,p.date,p.fin_validite,p.total_ht,p.fk_statut,'),(1,1,'MAIN_SELECTEDFIELDS_tasklist','t.label,t.dateo,t.datee,p.fk_statut,t.duration_effective,t.progress,'),(1,1,'MAIN_SELECTEDFIELDS_thirdpartylist','s.nom,s.name_alias,country.code_iso,typent.code,s.status,'),(2,1,'MAIN_SELECTEDFIELDS_invoicelist','f.total_ttc,f.facnumber,f.ref_client,f.date,f.date_lim_reglement,s.nom,s.town,s.zip,f.fk_mode_reglement,f.total_ht,f.fk_statut,'),(2,1,'MAIN_SELECTEDFIELDS_thirdpartylist','country.code_iso,s.nom,s.name_alias,s.barcode,s.code_client,s.town,s.zip,s.phone,typent.code,customerorsupplier,s.status,');

--
-- Table structure for table `llxqa_user_rib`
--

CREATE TABLE `llxqa_user_rib` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_user` int(11) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `label` varchar(30) DEFAULT NULL,
  `bank` varchar(255) DEFAULT NULL,
  `code_banque` varchar(128) DEFAULT NULL,
  `code_guichet` varchar(6) DEFAULT NULL,
  `number` varchar(255) DEFAULT NULL,
  `cle_rib` varchar(5) DEFAULT NULL,
  `bic` varchar(11) DEFAULT NULL,
  `iban_prefix` varchar(34) DEFAULT NULL,
  `domiciliation` varchar(255) DEFAULT NULL,
  `proprio` varchar(60) DEFAULT NULL,
  `owner_address` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_user_rib`
--


--
-- Table structure for table `llxqa_user_rights`
--

CREATE TABLE `llxqa_user_rights` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `fk_user` int(11) NOT NULL,
  `fk_id` int(11) NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_user_rights` (`entity`,`fk_user`,`fk_id`),
  KEY `fk_user_rights_fk_user_user` (`fk_user`),
  CONSTRAINT `fk_user_rights_fk_user_user` FOREIGN KEY (`fk_user`) REFERENCES `llxqa_user` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=2428 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_user_rights`
--

INSERT INTO `llxqa_user_rights` VALUES (2254,1,1,11),(2241,1,1,12),(2244,1,1,13),(2246,1,1,14),(2248,1,1,15),(2251,1,1,16),(2255,1,1,19),(25,1,1,21),(18,1,1,22),(19,1,1,24),(20,1,1,25),(22,1,1,26),(24,1,1,27),(26,1,1,28),(101,1,1,31),(98,1,1,32),(100,1,1,34),(102,1,1,38),(253,1,1,41),(246,1,1,42),(250,1,1,44),(254,1,1,45),(2232,1,1,81),(2219,1,1,82),(2222,1,1,84),(2224,1,1,86),(2227,1,1,87),(2230,1,1,88),(2233,1,1,89),(94,1,1,91),(91,1,1,92),(93,1,1,93),(95,1,1,94),(1844,1,1,95),(44,1,1,101),(40,1,1,102),(41,1,1,104),(42,1,1,105),(43,1,1,106),(45,1,1,109),(239,1,1,111),(220,1,1,112),(224,1,1,113),(228,1,1,114),(232,1,1,115),(236,1,1,116),(240,1,1,117),(2350,1,1,121),(2343,1,1,122),(2347,1,1,125),(2351,1,1,126),(263,1,1,141),(260,1,1,142),(264,1,1,144),(2424,1,1,251),(2386,1,1,252),(2389,1,1,253),(2392,1,1,254),(2395,1,1,255),(2399,1,1,256),(2354,1,1,262),(2366,1,1,281),(2359,1,1,282),(2363,1,1,283),(2367,1,1,286),(2198,1,1,300),(2200,1,1,301),(2402,1,1,341),(2404,1,1,342),(2406,1,1,343),(2408,1,1,344),(2420,1,1,351),(2413,1,1,352),(2417,1,1,353),(2421,1,1,354),(2425,1,1,358),(2336,1,1,511),(2329,1,1,512),(2333,1,1,514),(2337,1,1,517),(2380,1,1,531),(2373,1,1,532),(2377,1,1,534),(2381,1,1,538),(307,1,1,771),(284,1,1,772),(288,1,1,773),(292,1,1,775),(296,1,1,776),(300,1,1,777),(304,1,1,778),(308,1,1,779),(113,1,1,1001),(112,1,1,1002),(114,1,1,1003),(116,1,1,1004),(117,1,1,1005),(50,1,1,1101),(48,1,1,1102),(49,1,1,1104),(51,1,1,1109),(2262,1,1,1181),(2290,1,1,1182),(2267,1,1,1183),(2270,1,1,1184),(2273,1,1,1185),(2277,1,1,1186),(2281,1,1,1187),(2287,1,1,1188),(2284,1,1,1189),(2291,1,1,1191),(2308,1,1,1231),(2297,1,1,1232),(2300,1,1,1233),(2303,1,1,1234),(2306,1,1,1235),(2309,1,1,1236),(118,1,1,1251),(2258,1,1,1321),(2260,1,1,1322),(2236,1,1,1421),(2182,1,1,2401),(2179,1,1,2402),(2183,1,1,2403),(2192,1,1,2411),(2189,1,1,2412),(2193,1,1,2413),(2196,1,1,2414),(393,1,1,2501),(390,1,1,2503),(394,1,1,2515),(2212,1,1,23001),(2205,1,1,23002),(2209,1,1,23003),(2213,1,1,23004),(2152,1,1,50401),(2168,1,1,50411),(2157,1,1,50412),(2161,1,1,50414),(2165,1,1,50415),(2169,1,1,50418),(2172,1,1,50420),(2174,1,1,50430),(2150,1,1,50440),(2322,1,1,63001),(2315,1,1,63002),(2319,1,1,63003),(2323,1,1,63004),(383,1,1,160310),(364,1,1,160311),(368,1,1,160312),(372,1,1,160313),(376,1,1,160314),(380,1,1,160315),(384,1,1,160316),(2256,1,2,11),(2243,1,2,12),(2245,1,2,13),(2247,1,2,14),(2249,1,2,15),(2253,1,2,16),(2257,1,2,19),(175,1,2,21),(176,1,2,22),(177,1,2,24),(178,1,2,25),(179,1,2,26),(180,1,2,27),(181,1,2,28),(171,1,2,31),(172,1,2,32),(173,1,2,34),(174,1,2,38),(255,1,2,41),(248,1,2,42),(252,1,2,44),(256,1,2,45),(2234,1,2,81),(2221,1,2,82),(2223,1,2,84),(2225,1,2,86),(2229,1,2,87),(2231,1,2,88),(2235,1,2,89),(200,1,2,91),(201,1,2,92),(202,1,2,93),(203,1,2,94),(1845,1,2,95),(135,1,2,101),(136,1,2,102),(137,1,2,104),(138,1,2,105),(139,1,2,106),(140,1,2,109),(241,1,2,111),(222,1,2,112),(226,1,2,113),(230,1,2,114),(234,1,2,115),(238,1,2,116),(242,1,2,117),(2352,1,2,121),(2345,1,2,122),(2349,1,2,125),(2353,1,2,126),(265,1,2,141),(262,1,2,142),(266,1,2,144),(2426,1,2,251),(2387,1,2,252),(2391,1,2,253),(2393,1,2,254),(2397,1,2,255),(2401,1,2,256),(2355,1,2,262),(2368,1,2,281),(2361,1,2,282),(2365,1,2,283),(2369,1,2,286),(2199,1,2,300),(2201,1,2,301),(2403,1,2,341),(2405,1,2,342),(2407,1,2,343),(2409,1,2,344),(2422,1,2,351),(2415,1,2,352),(2419,1,2,353),(2423,1,2,354),(2427,1,2,358),(2338,1,2,511),(2331,1,2,512),(2335,1,2,514),(2339,1,2,517),(2382,1,2,531),(2375,1,2,532),(2379,1,2,534),(2383,1,2,538),(309,1,2,771),(286,1,2,772),(290,1,2,773),(294,1,2,775),(298,1,2,776),(302,1,2,777),(306,1,2,778),(310,1,2,779),(195,1,2,1001),(196,1,2,1002),(197,1,2,1003),(198,1,2,1004),(199,1,2,1005),(141,1,2,1101),(142,1,2,1102),(143,1,2,1104),(144,1,2,1109),(2263,1,2,1181),(2292,1,2,1182),(2269,1,2,1183),(2271,1,2,1184),(2275,1,2,1185),(2279,1,2,1186),(2283,1,2,1187),(2289,1,2,1188),(2285,1,2,1189),(2293,1,2,1191),(2310,1,2,1231),(2299,1,2,1232),(2301,1,2,1233),(2305,1,2,1234),(2307,1,2,1235),(2311,1,2,1236),(2259,1,2,1321),(2261,1,2,1322),(2237,1,2,1421),(2184,1,2,2401),(2181,1,2,2402),(2185,1,2,2403),(2194,1,2,2411),(2191,1,2,2412),(2195,1,2,2413),(2197,1,2,2414),(395,1,2,2501),(392,1,2,2503),(396,1,2,2515),(2214,1,2,23001),(2207,1,2,23002),(2211,1,2,23003),(2215,1,2,23004),(2153,1,2,50401),(2170,1,2,50411),(2159,1,2,50412),(2163,1,2,50414),(2167,1,2,50415),(2171,1,2,50418),(2173,1,2,50420),(2175,1,2,50430),(2151,1,2,50440),(2324,1,2,63001),(2317,1,2,63002),(2321,1,2,63003),(2325,1,2,63004),(385,1,2,160310),(366,1,2,160311),(370,1,2,160312),(374,1,2,160313),(378,1,2,160314),(382,1,2,160315),(386,1,2,160316);

--
-- Table structure for table `llxqa_usergroup`
--

CREATE TABLE `llxqa_usergroup` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(180) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `note` text DEFAULT NULL,
  `model_pdf` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_usergroup_name` (`nom`,`entity`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_usergroup`
--

INSERT INTO `llxqa_usergroup` VALUES (1,'driver - promo',1,'2018-12-29 20:03:53','2018-12-29 20:04:38','',NULL);

--
-- Table structure for table `llxqa_usergroup_extrafields`
--

CREATE TABLE `llxqa_usergroup_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_usergroup_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_usergroup_extrafields`
--


--
-- Table structure for table `llxqa_usergroup_rights`
--

CREATE TABLE `llxqa_usergroup_rights` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `fk_usergroup` int(11) NOT NULL,
  `fk_id` int(11) NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_usergroup_rights` (`entity`,`fk_usergroup`,`fk_id`),
  KEY `fk_usergroup_rights_fk_usergroup` (`fk_usergroup`),
  CONSTRAINT `fk_usergroup_rights_fk_usergroup` FOREIGN KEY (`fk_usergroup`) REFERENCES `llxqa_usergroup` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_usergroup_rights`
--


--
-- Table structure for table `llxqa_usergroup_user`
--

CREATE TABLE `llxqa_usergroup_user` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `fk_user` int(11) NOT NULL,
  `fk_usergroup` int(11) NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_usergroup_user` (`entity`,`fk_user`,`fk_usergroup`),
  KEY `fk_usergroup_user_fk_user` (`fk_user`),
  KEY `fk_usergroup_user_fk_usergroup` (`fk_usergroup`),
  CONSTRAINT `fk_usergroup_user_fk_user` FOREIGN KEY (`fk_user`) REFERENCES `llxqa_user` (`rowid`),
  CONSTRAINT `fk_usergroup_user_fk_usergroup` FOREIGN KEY (`fk_usergroup`) REFERENCES `llxqa_usergroup` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_usergroup_user`
--


--
-- Table structure for table `llxqa_website`
--

CREATE TABLE `llxqa_website` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `type_container` varchar(16) NOT NULL DEFAULT 'page',
  `entity` int(11) NOT NULL DEFAULT 1,
  `ref` varchar(128) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `fk_default_home` int(11) DEFAULT NULL,
  `virtualhost` varchar(255) DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `import_key` varchar(14) DEFAULT NULL,
  `maincolor` varchar(16) DEFAULT NULL,
  `maincolorbis` varchar(16) DEFAULT NULL,
  `use_manifest` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_website_ref` (`ref`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_website`
--


--
-- Table structure for table `llxqa_website_extrafields`
--

CREATE TABLE `llxqa_website_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_website_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_website_extrafields`
--


--
-- Table structure for table `llxqa_website_page`
--

CREATE TABLE `llxqa_website_page` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_website` int(11) NOT NULL,
  `type_container` varchar(16) NOT NULL DEFAULT 'page',
  `pageurl` varchar(255) NOT NULL,
  `aliasalt` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `keywords` varchar(255) DEFAULT NULL,
  `lang` varchar(6) DEFAULT NULL,
  `fk_page` int(11) DEFAULT NULL,
  `htmlheader` text DEFAULT NULL,
  `content` mediumtext DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `grabbed_from` varchar(255) DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `import_key` varchar(14) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_website_page_url` (`fk_website`,`pageurl`),
  CONSTRAINT `fk_website_page_website` FOREIGN KEY (`fk_website`) REFERENCES `llxqa_website` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llxqa_website_page`
--


--
-- Table structure for table `tmp_llxqa_accouting_account`
--

CREATE TABLE `tmp_llxqa_accouting_account` (
  `MINID` int(11) DEFAULT NULL,
  `MAXID` int(11) DEFAULT NULL,
  `account_number` varchar(32) CHARACTER SET utf8 NOT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `fk_pcg_version` varchar(32) CHARACTER SET utf8 NOT NULL,
  `NB` bigint(21) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tmp_llxqa_accouting_account`
--



