-- MySQL dump 10.13 Distrib 5.6.24, for Win64 (x86_64) -- -- Host: localhost Database: circle_k -- ------------------------------------------------------ -- Server version 5.7.10-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `clientescreditos` -- DROP TABLE IF EXISTS `clientescreditos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `clientescreditos` ( `ClientesCreditosID` varchar(50) NOT NULL, `LimiteCredito` decimal(24,6) DEFAULT '0.000000', `Saldo` decimal(24,6) DEFAULT '0.000000', `InternalVersion` int(11) DEFAULT '0', `ClientesID` varchar(50) DEFAULT NULL, `TiposCreditosID` varchar(50) DEFAULT NULL, `Activo` tinyint(4) DEFAULT '0', `ManejaEmpresa` tinyint(4) DEFAULT '0', PRIMARY KEY (`ClientesCreditosID`), KEY `WDIDX_ClientesCreditos_ClientesID` (`ClientesID`), KEY `WDIDX_ClientesCreditos_TiposCreditosID` (`TiposCreditosID`), KEY `WDIDX_ClientesCreditos_Activo` (`Activo`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `clientescreditos` -- LOCK TABLES `clientescreditos` WRITE; /*!40000 ALTER TABLE `clientescreditos` DISABLE KEYS */; INSERT INTO `clientescreditos` VALUES ('0-1',0.000000,0.000000,2,'0-50006','FLO',1,0),('0-10',50000.000000,0.000000,8,'145-19','FLO',1,0),('0-100',23040.100000,-13193.500000,91,'104-86','FLO',1,0),('0-101',10000.000000,0.000000,2,'104-120','FLO',1,0),('0-102',50000.000000,0.000000,3,'0-4','FLO',1,0),('0-103',10000.000000,0.000000,2,'0-3','FLO',1,0),('0-104',50000.000000,0.000000,3,'141-5','FLO',1,0),('0-105',50000.000000,0.000000,3,'139-16','FLO',1,0),('0-106',50000.000000,0.000000,3,'1-119','FLO',1,0),('0-107',10000.000000,0.000000,2,'1-2833','FLO',1,0),('0-108',10000.000000,0.000000,12,'138-104','FLO',1,0),('0-109',50000.000000,0.000000,3,'0-2','FLO',1,0),('0-11',50000.000000,-1900.000000,5,'145-41','FLO',1,0),('0-110',50000.000000,0.000000,4,'25-1','FLO',1,0),('0-111',10000.000000,0.000000,8,'0-124','FLO',1,0),('0-112',10000.000000,0.000000,2,'0-76','FLO',1,0),('0-113',10000.000000,0.000000,2,'0-134','FLO',1,0),('0-114',50000.000000,0.000000,5,'0-12875','FLO',1,0),('0-115',50000.000000,0.000000,3,'32-5','FLO',1,0),('0-116',10000.000000,0.000000,2,'1-1843','FLO',1,0),('0-117',10000.000000,0.000000,7,'0-35','FLO',1,0),('0-118',10000.000000,0.000000,2,'0-14','FLO',1,0),('0-119',50000.000000,0.000000,3,'0-336','FLO',1,0),('0-12',10000.000000,0.000000,17,'1-897','FLO',1,0),('0-120',10000.000000,0.000000,2,'0-6982','FLO',1,0),('0-121',50000.000000,-3000.500000,6,'1-514','FLO',1,0),('0-122',50000.000000,0.000000,3,'145-16','FLO',1,0),('0-123',50000.000000,0.000000,3,'114-130','FLO',1,0),('0-124',10000.000000,0.000000,2,'145-26','FLO',1,0),('0-125',50000.000000,0.000000,3,'0-12126','FLO',1,0),('0-126',500000.000000,-409439.270000,18,'0-50002','FLO',1,0),('0-127',50000.000000,-41391.350000,13,'1-1290','FLO',1,0),('0-128',50000.000000,0.000000,3,'1-1565','FLO',1,0),('0-129',3000000.000000,-1083840.640000,23,'154-154','FLO',1,0),('0-13',50000.000000,0.000000,26,'145-2','FLO',1,0),('0-130',70000.000000,-59980.620000,14,'0-380','FLO',1,0),('0-131',30000.000000,-22191.260000,11,'147-121','FLO',1,0),('0-132',150000.000000,-123098.620000,24,'1-3396','FLO',1,0),('0-133',150000.000000,-117503.490000,18,'154-156','FLO',1,0),('0-134',500000.000000,-432437.110000,13,'104-99','FLO',1,0),('0-135',100000.000000,-46741.420000,11,'114-806','FLO',1,0),('0-136',800000.000000,-86382.920000,11,'154-134','FLO',1,0),('0-137',50000.000000,-24010.540000,7,'0-20826','FLO',1,0),('0-138',50000.000000,0.000000,3,'62-177','FLO',1,0),('0-139',50000.000000,0.000000,3,'154-1','FLO',1,0),('0-14',50000.000000,-2000.000000,28,'1-589','FLO',1,0),('0-140',10000.000000,0.000000,2,'1-2948','FLO',1,0),('0-141',10000.000000,0.000000,2,'154-30','FLO',1,0),('0-142',10000.000000,0.000000,2,'154-169','FLO',1,0),('0-143',50000.000000,0.000000,3,'1-2056','FLO',1,0),('0-144',10000.000000,0.000000,2,'0-6073','FLO',1,0),('0-145',50000.000000,0.000000,3,'154-130','FLO',1,0),('0-146',50000.000000,0.000000,3,'1-1888','FLO',1,0),('0-147',10000.000000,0.000000,2,'1-3511','FLO',1,0),('0-148',10000.000000,0.000000,2,'154-26','FLO',1,0),('0-149',50000.000000,0.000000,3,'147-125','FLO',1,0),('0-15',10000.000000,0.000000,3,'145-30','FLO',1,0),('0-150',50000.000000,0.000000,3,'130-129','FLO',1,0),('0-151',10000.000000,0.000000,2,'1-644','FLO',1,0),('0-152',10000.000000,0.000000,2,'154-93','FLO',1,0),('0-153',50000.000000,0.000000,3,'0-10281','FLO',1,0),('0-154',10000.000000,0.000000,2,'154-13','FLO',1,0),('0-155',10000.000000,0.000000,2,'104-39','FLO',1,0),('0-156',50000.000000,0.000000,3,'114-951','FLO',1,0),('0-157',50000.000000,0.000000,4,'147-96','FLO',1,0),('0-158',10000.000000,0.000000,3,'106-119','FLO',1,0),('0-159',10000.000000,0.000000,3,'0-5741','FLO',1,0),('0-16',10000.000000,-1000.000000,8,'0-90','FLO',1,0),('0-160',10000.000000,0.000000,5,'106-56','FLO',1,0),('0-161',10000.000000,-1000.000000,8,'1-3008','FLO',1,0),('0-162',10000.000000,0.000000,5,'1-2520','FLO',1,0),('0-163',10000.000000,0.000000,5,'147-78','FLO',1,0),('0-164',30000.000000,0.000000,6,'0-5361','FLO',1,0),('0-165',22000.000000,0.000000,3,'147-88','FLO',1,0),('0-166',50000.000000,0.000000,4,'1-2379','FLO',1,0),('0-167',50000.000000,0.000000,4,'0-50004','FLO',1,0),('0-168',50000.000000,0.000000,4,'0-20394','FLO',1,0),('0-169',50000.000000,-5050.010000,8,'104-91','FLO',1,0),('0-17',50000.000000,0.000000,8,'145-46','FLO',1,0),('0-170',10000.000000,0.000000,3,'130-50','FLO',1,0),('0-171',50000.000000,0.000000,3,'1-405','FLO',1,0),('0-172',10000.000000,0.000000,2,'85-2','FLO',1,0),('0-173',120000.000000,0.000000,6,'44-6','FLO',1,0),('0-174',50000.000000,0.000000,3,'106-63','FLO',1,0),('0-175',10000.000000,0.000000,2,'106-25','FLO',1,0),('0-176',10000.000000,0.000000,2,'0-20256','FLO',1,0),('0-177',50000.000000,0.000000,3,'85-33','FLO',1,0),('0-178',50000.000000,0.000000,5,'1-2812','FLO',1,0),('0-179',50000.000000,-13177.070000,34,'104-89','FLO',1,0),('0-18',10000.000000,-6000.000000,20,'145-27','FLO',1,0),('0-180',10000.000000,0.000000,2,'0-173','FLO',1,0),('0-181',50000.000000,-35967.510000,30,'104-21','FLO',1,0),('0-182',10000.000000,-3075.610000,26,'104-121','FLO',1,0),('0-183',10000.000000,0.000000,3,'104-93','FLO',1,0),('0-184',25000.000000,-17960.830000,35,'104-5','FLO',1,0),('0-185',100000.000000,-1750.000000,23,'104-116','FLO',1,0),('0-186',20000.000000,-12425.890000,46,'104-135','FLO',1,0),('0-187',10000.000000,0.000000,2,'0-6198','FLO',1,0),('0-188',50000.000000,0.000000,3,'106-168','FLO',1,0),('0-189',50000.000000,0.000000,3,'0-6264','FLO',1,0),('0-19',50000.000000,-1191.000000,13,'0-13','FLO',1,0),('0-190',10000.000000,0.000000,2,'0-172','FLO',1,0),('0-191',10000.000000,0.000000,10,'104-16','FLO',1,0),('0-192',10000.000000,0.000000,2,'0-1241','FLO',1,0),('0-193',10000.000000,0.000000,2,'85-14','FLO',1,0),('0-194',10000.000000,0.000000,4,'147-100','FLO',1,0),('0-195',10000.000000,0.000000,2,'114-159','FLO',1,0),('0-196',10000.000000,0.000000,2,'1-1220','FLO',1,0),('0-197',50000.000000,0.000000,9,'0-744','FLO',1,0),('0-1975',5000.000000,0.000000,7,'0-55786','FLO',1,1),('0-198',10000.000000,0.000000,2,'0-6020','FLO',1,0),('0-199',50000.000000,0.000000,3,'85-30','FLO',1,0),('0-2',100000.000000,-64736.470000,629,'175-6','FLO',1,0),('0-20',50000.000000,0.000000,8,'0-21120','FLO',1,0),('0-200',50000.000000,0.000000,3,'85-246','FLO',1,0),('0-201',50000.000000,0.000000,3,'46-74','FLO',1,0),('0-202',10000.000000,0.000000,2,'0-5675','FLO',1,0),('0-203',50000.000000,0.000000,3,'0-5600','FLO',1,0),('0-204',50000.000000,0.000000,3,'114-123','FLO',1,0),('0-205',10000.000000,0.000000,2,'85-243','FLO',1,0),('0-206',10000.000000,0.000000,2,'85-220','FLO',1,0),('0-207',50000.000000,0.000000,3,'0-356','FLO',1,0),('0-208',10000.000000,0.000000,2,'0-181','FLO',1,0),('0-209',100000.000000,-45329.480000,102,'1-3422','FLO',1,0),('0-21',25000.000000,0.000000,11,'1-2575','FLO',1,0),('0-210',50000.000000,-4195.650000,58,'1-461','FLO',1,0),('0-211',5000000.000000,-2808973.170973,8408,'1-352','FLO',1,1),('0-212',80000.000000,0.000000,8,'1-2442','FLO',1,0),('0-213',83743.530000,-38809.540000,152,'1-542','FLO',1,0),('0-214',60000.000000,-10198.080000,104,'1-2157','FLO',1,0),('0-215',10000.000000,0.000000,2,'1-387','FLO',1,0),('0-216',50000.000000,-5705.300000,100,'1-730','FLO',1,0),('0-217',50000.000000,0.000000,5,'1-2419','FLO',1,0),('0-218',25000.000000,-17154.230000,122,'1-160','FLO',1,0),('0-219',60000.000000,-6361.580000,36,'1-2075','FLO',1,0),('0-22',10000.000000,0.000000,7,'0-50001','FLO',1,0),('0-220',10000.000000,0.000000,5,'1-2708','FLO',1,0),('0-221',222700.000000,-121079.310000,100,'1-1688','FLO',1,0),('0-222',50000.000000,0.000000,9,'1-921','FLO',1,0),('0-223',15000.000000,-4973.920000,33,'1-249','FLO',1,0),('0-224',200000.000000,-103851.800000,16,'1-2161','FLO',1,0),('0-225',10000.000000,-1080.120000,29,'1-3066','FLO',1,0),('0-226',31692.770000,-5239.000000,52,'1-675','FLO',1,0),('0-227',50000.000000,0.000000,3,'1-240','FLO',1,0),('0-228',50000.000000,-500.000000,29,'1-1512','FLO',1,0),('0-2284',1012402.350000,-799192.270000,1715,'0-61241','FLO',1,1),('0-229',1800000.000000,-754943.210667,5952,'1-2639','FLO',1,1),('0-23',50000.000000,0.000000,12,'0-13790','FLO',1,0),('0-230',50000.000000,-16908.000000,12,'1-1079','FLO',1,0),('0-231',36005.570000,-21001.320000,32,'1-2616','FLO',1,0),('0-232',100000.000000,-54437.210000,79,'1-425','FLO',1,0),('0-233',50000.000000,0.000000,3,'1-3331','FLO',1,0),('0-234',50000.000000,0.000000,29,'1-512','FLO',1,0),('0-235',22452.750000,0.000000,10,'1-1935','FLO',1,0),('0-236',5000.000000,-2149.950000,231,'1-2625','FLO',1,1),('0-237',10000.000000,0.000000,2,'1-1551','FLO',1,0),('0-238',15000.000000,0.000000,8,'1-774','FLO',1,0),('0-239',50000.000000,0.000000,3,'1-2295','FLO',1,0),('0-24',50000.000000,0.000000,5,'0-6721','FLO',1,0),('0-240',75516.000000,-69397.970000,28,'1-582','FLO',1,0),('0-241',10000.000000,-4150.000000,51,'1-841','FLO',1,1),('0-242',100000.000000,-20794.330000,101,'1-697','FLO',1,0),('0-243',50000.000000,-5733.100000,50,'1-2124','FLO',1,0),('0-244',50000.000000,-10254.250000,28,'1-2057','FLO',1,0),('0-245',30185.330000,-11960.400000,36,'1-3605','FLO',1,0),('0-246',50000.000000,-10000.000000,19,'1-1122','FLO',1,0),('0-247',200000.000000,-131689.160000,27,'1-70','FLO',1,0),('0-248',50000.000000,0.000000,3,'1-594','FLO',1,0),('0-249',50000.000000,-26417.850000,114,'1-1217','FLO',1,0),('0-25',10000.000000,0.000000,21,'145-28','FLO',1,0),('0-250',50000.000000,-2353.600000,67,'1-1373','FLO',1,0),('0-251',10000.000000,-2040.000000,51,'1-3392','FLO',1,0),('0-252',35500.000000,-13647.200000,45,'1-1052','FLO',1,0),('0-253',20000.000000,-8404.560000,27,'1-2902','FLO',1,0),('0-254',49600.100000,-20400.110000,51,'1-556','FLO',1,0),('0-255',50000.000000,-5142.300000,57,'1-2917','FLO',1,0),('0-256',300000.000000,-12892.400000,81,'1-619','FLO',1,0),('0-257',70000.000000,-22829.800000,35,'1-158','FLO',1,0),('0-258',150000.000000,0.000000,59,'1-149','FLO',1,0),('0-259',50000.000000,0.000000,3,'1-177','FLO',1,0),('0-26',18000.000000,-17999.850000,66,'0-18829','FLO',1,1),('0-260',24551.900000,-8432.200000,17,'1-752','FLO',1,0),('0-261',33000.000000,-21751.650000,285,'1-2792','FLO',1,1),('0-262',80536.400000,-46164.120000,470,'1-298','FLO',1,1),('0-263',45000.000000,-5355.670000,87,'1-2796','FLO',1,1),('0-264',50000.000000,0.000000,3,'1-680','FLO',1,0),('0-265',50000.000000,-1665.000000,28,'1-672','FLO',1,0),('0-266',24436.490000,0.000000,9,'1-454','FLO',1,0),('0-267',31929.050000,-18953.650000,53,'1-533','FLO',1,0),('0-268',50000.000000,0.000000,3,'1-1186','FLO',1,0),('0-269',10000.000000,0.000000,2,'138-13','FLO',1,0),('0-27',10000.000000,-3945.000000,33,'0-50','FLO',1,0),('0-270',50000.000000,0.000000,3,'138-20','FLO',1,0),('0-271',50000.000000,-12049.650000,32,'145-3','FLO',1,0),('0-272',10000.000000,0.000000,6,'139-1','FLO',1,0),('0-273',15000.000000,-8500.000000,30,'145-5','FLO',1,0),('0-274',50000.000000,-990.000000,29,'145-6','FLO',1,0),('0-275',50000.000000,-17895.020000,280,'145-7','FLO',1,1),('0-276',50000.000000,0.000000,9,'145-9','FLO',1,0),('0-277',50000.000000,-1004.310000,7,'145-11','FLO',1,0),('0-278',50000.000000,-212.800000,15,'145-12','FLO',1,0),('0-279',50000.000000,-925.000000,9,'145-13','FLO',1,0),('0-28',50000.000000,-10438.900000,151,'0-9','FLO',1,0),('0-280',50000.000000,-2150.100000,53,'145-14','FLO',1,0),('0-281',50000.000000,0.000000,3,'145-15','FLO',1,0),('0-282',50000.000000,0.000000,3,'145-17','FLO',1,0),('0-283',50000.000000,0.000000,3,'145-18','FLO',1,0),('0-284',20000.000000,-9849.000000,26,'145-21','FLO',1,0),('0-285',50000.000000,0.000000,3,'145-22','FLO',1,0),('0-286',50000.000000,-32724.430000,65,'145-24','FLO',1,0),('0-287',20000.000000,0.000000,7,'85-12','FLO',1,0),('0-288',50000.000000,0.000000,3,'144-32','FLO',1,0),('0-289',20000.000000,-9200.000000,9,'147-9','FLO',1,0),('0-29',17000.000000,-9280.300000,373,'0-6842','FLO',1,1),('0-290',10000.000000,0.000000,5,'148-23','FLO',1,0),('0-291',21129.820000,-1707.000000,3,'85-48','FLO',1,0),('0-292',400000.000000,-368004.630000,50,'162-1','FLO',1,0),('0-293',3000000.000000,-2275200.000000,29,'162-2','FLO',1,0),('0-294',50000.000000,0.000000,7,'145-33','FLO',1,0),('0-295',50000.000000,0.000000,7,'145-34','FLO',1,0),('0-296',10000.000000,-3500.000000,16,'145-35','FLO',1,0),('0-297',10000.000000,0.000000,2,'162-3','FLO',1,0),('0-298',50000.000000,0.000000,8,'0-6','FLO',1,0),('0-299',68000.000000,-18482.570000,80,'0-12','FLO',1,0),('0-3',50000.000000,0.000000,3,'0-50008','FLO',1,0),('0-30',10000.000000,-2500.000000,36,'145-29','FLO',1,0),('0-300',10000.000000,0.000000,2,'0-18','FLO',1,0),('0-301',10000.000000,0.000000,7,'0-23','FLO',1,0),('0-302',10000.000000,-1500.000000,9,'0-29','FLO',1,0),('0-303',54066.000000,-7905.900000,31,'0-41','FLO',1,0),('0-304',10000.000000,-1495.470000,16,'0-49','FLO',1,0),('0-305',10000.000000,-790.000000,41,'0-65','FLO',1,0),('0-306',59736.800000,-34130.550000,15,'0-74','FLO',1,0),('0-307',10000.000000,0.000000,2,'0-83','FLO',1,0),('0-308',10000.000000,-2850.300000,28,'0-96','FLO',1,0),('0-309',10000.000000,0.000000,2,'0-108','FLO',1,0),('0-31',10000.000000,0.000000,9,'0-95','FLO',1,0),('0-310',10000.000000,-1800.000000,16,'0-128','FLO',1,0),('0-311',100000.000000,0.000000,25,'0-154','FLO',1,0),('0-312',10000.000000,-2668.100000,35,'0-155','FLO',1,0),('0-313',10000.000000,0.000000,2,'0-209','FLO',1,0),('0-314',20000.000000,0.000000,10,'0-210','FLO',1,0),('0-315',50000.000000,0.000000,3,'0-6260','FLO',1,0),('0-316',28332.170000,-13585.840000,50,'0-9525','FLO',1,0),('0-317',50000.000000,0.000000,13,'0-11690','FLO',1,0),('0-318',619878.420000,-545491.170000,71,'0-13365','FLO',1,0),('0-319',10000.000000,0.000000,6,'0-20875','FLO',1,0),('0-32',21500.340000,-12739.900000,33,'145-47','FLO',1,0),('0-320',500000.000000,-212744.170000,16,'162-4','FLO',1,0),('0-321',10000.000000,0.000000,16,'145-36','FLO',1,0),('0-322',1000000.000000,-898000.000000,17,'162-5','FLO',1,0),('0-323',10000.000000,0.000000,2,'145-37','FLO',1,0),('0-324',50000.000000,0.000000,3,'145-38','FLO',1,0),('0-325',500000.000000,-54000.000000,5,'162-6','FLO',1,0),('0-326',10000.000000,0.000000,2,'162-7','FLO',1,0),('0-327',50000.000000,0.000000,3,'162-8','FLO',1,0),('0-328',50000.000000,0.000000,5,'145-42','FLO',1,0),('0-329',80000.000000,-54968.100000,28,'145-43','FLO',1,1),('0-33',20000.000000,-12953.990000,95,'130-5','FLO',1,1),('0-330',98274.110000,-19300.000000,17,'145-45','FLO',1,0),('0-331',50000.000000,0.000000,12,'0-1','FLO',1,0),('0-332',50000.000000,0.000000,5,'0-50003','FLO',1,0),('0-333',200000.000000,-167198.090000,16,'0-50214','FLO',1,0),('0-334',6000.000000,-3000.000000,7,'0-50216','FLO',1,1),('0-335',7500.000000,0.000000,18,'0-50218','FLO',1,1),('0-336',2000.000000,0.000000,4,'0-50219','FLO',1,0),('0-337',800.000000,0.000000,30,'0-50221','FLO',1,1),('0-338',8000.000000,0.000000,11,'0-50222','FLO',1,0),('0-339',25000.000000,0.000000,5,'0-50223','FLO',1,1),('0-34',50000.000000,0.000000,8,'1-3636','FLO',1,0),('0-340',3500.000000,0.000000,11,'0-50224','FLO',1,0),('0-341',40000.000000,-38038.950000,21,'0-50225','FLO',1,0),('0-342',2500.000000,0.000000,6,'0-50226','FLO',1,0),('0-343',5000.000000,-4000.000000,2,'0-50227','FLO',1,0),('0-344',5000.000000,0.000000,10,'0-50229','FLO',1,1),('0-345',6000.000000,0.000000,6,'0-50230','FLO',1,0),('0-346',300000.000000,-103149.700000,29,'0-50232','FLO',1,0),('0-347',30000.000000,-12600.000000,4,'0-50233','FLO',1,0),('0-348',10000.000000,0.000000,19,'0-50234','FLO',1,1),('0-349',6000.000000,0.000000,9,'0-50235','FLO',1,0),('0-35',50000.000000,-3000.010000,21,'1-41','FLO',1,0),('0-350',2500.000000,0.000000,3,'0-50237','FLO',1,1),('0-351',7200.000000,0.000000,3,'0-50238','FLO',1,0),('0-352',5000.000000,0.000000,3,'0-50239','FLO',1,1),('0-353',10000.000000,-3202.180000,5,'0-50240','FLO',1,1),('0-354',5000.000000,0.000000,1,'0-50241','FLO',1,0),('0-355',5000.000000,0.000000,1,'0-50242','FLO',1,0),('0-356',0.000000,0.000000,1,'0-50243','FLO',1,0),('0-357',5000.000000,0.000000,3,'0-50244','FLO',1,1),('0-358',5000.000000,0.000000,3,'0-50245','FLO',1,0),('0-359',123400.000000,-95156.900000,26,'0-50246','FLO',1,1),('0-36',50000.000000,-11942.950000,18,'146-41','FLO',1,0),('0-360',3300000.000000,-412883.850000,11,'0-50247','FLO',1,0),('0-361',200000.000000,-37755.690000,10,'0-50248','FLO',1,1),('0-362',20000.000000,-15000.460000,5,'0-50249','FLO',1,0),('0-363',10000.000000,0.000000,3,'0-50250','FLO',1,0),('0-364',70000.000000,-59240.190000,8,'0-50251','FLO',1,0),('0-365',5000.000000,0.000000,5,'0-50252','FLO',1,0),('0-366',136107.000000,-130123.712060,273,'0-50253','FLO',1,1),('0-367',2080.030000,-2080.030000,2938,'0-50255','FLO',1,1),('0-368',13780.000000,0.000000,15,'0-50257','FLO',1,1),('0-37',50000.000000,0.000000,25,'145-20','FLO',1,0),('0-38',300000.000000,-61100.100000,48,'32-30','FLO',1,1),('0-39',50000.000000,0.000000,15,'138-29','FLO',1,0),('0-4',50000.000000,-12725.300000,27,'1-529','FLO',1,0),('0-40',50000.000000,0.000000,25,'1-1546','FLO',1,0),('0-402',54066.000000,-39535.090000,3,'0-50298','FLO',1,0),('0-41',50000.000000,0.000000,25,'0-20458','FLO',1,0),('0-42',10000.000000,0.000000,8,'0-45','FLO',1,0),('0-43',10000.000000,0.000000,6,'1-975','FLO',1,0),('0-44',10000.000000,0.000000,12,'0-26','FLO',1,0),('0-45',10000.000000,0.000000,6,'0-164','FLO',1,0),('0-46',10000.000000,-4000.000000,11,'130-250','FLO',1,0),('0-47',10000.000000,-1000.000000,13,'145-31','FLO',1,0),('0-48',50000.000000,0.000000,18,'1-999','FLO',1,0),('0-49',50000.000000,0.000000,20,'142-7','FLO',1,0),('0-5',20000.000000,-18998.340000,6,'175-3','FLO',1,0),('0-50',50000.000000,-10000.000000,24,'138-119','FLO',1,0),('0-51',50000.000000,0.000000,13,'0-50007','FLO',1,0),('0-52',10000.000000,0.000000,10,'0-36','FLO',1,0),('0-53',20000.000000,0.000000,9,'0-11509','FLO',1,0),('0-54',10000.000000,0.000000,8,'0-24','FLO',1,0),('0-55',250000.000000,0.000000,42,'138-132','FLO',1,0),('0-56',10000.000000,0.000000,2,'114-242','FLO',1,0),('0-57',10000.000000,0.000000,6,'0-7406','FLO',1,0),('0-58',50000.000000,0.000000,7,'145-1','FLO',1,0),('0-59',10000.000000,0.000000,10,'145-44','FLO',1,0),('0-6',10000.000000,0.000000,24,'0-10739','FLO',1,0),('0-60',50000.000000,0.000000,3,'0-2998','FLO',1,0),('0-61',10000.000000,0.000000,8,'0-3521','FLO',1,0),('0-62',10000.000000,0.000000,10,'0-7436','FLO',1,0),('0-63',10000.000000,0.000000,2,'139-4','FLO',1,0),('0-64',10000.000000,0.000000,8,'1-668','FLO',1,0),('0-65',50000.000000,0.000000,21,'138-28','FLO',1,0),('0-66',10000.000000,0.000000,2,'104-131','FLO',1,0),('0-67',60000.000000,0.000000,3,'104-47','FLO',1,0),('0-68',10000.000000,-1500.000000,8,'0-98','FLO',1,0),('0-69',10000.000000,0.000000,2,'1-7','FLO',1,0),('0-7',10000.000000,-3000.010000,12,'0-8881','FLO',1,0),('0-70',50000.000000,0.000000,5,'158-2','FLO',1,0),('0-71',10000.000000,0.000000,14,'1-399','FLO',1,0),('0-72',10000.000000,0.000000,10,'0-9242','FLO',1,0),('0-73',10000.000000,0.000000,8,'0-9161','FLO',1,0),('0-74',10000.000000,0.000000,8,'0-91','FLO',1,0),('0-75',10000.000000,0.000000,6,'0-158','FLO',1,0),('0-76',50000.000000,0.000000,11,'145-40','FLO',1,0),('0-77',10000.000000,-300.000000,5,'0-13485','FLO',1,0),('0-78',10000.000000,0.000000,14,'145-48','FLO',1,0),('0-79',10000.000000,0.000000,2,'1-776','FLO',1,0),('0-8',10000.000000,-5000.000000,17,'145-49','FLO',1,0),('0-80',50000.000000,0.000000,3,'114-14','FLO',1,0),('0-81',50000.000000,0.000000,5,'138-66','FLO',1,0),('0-82',50000.000000,0.000000,11,'143-28','FLO',1,0),('0-83',10000.000000,0.000000,8,'143-22','FLO',1,0),('0-84',50000.000000,0.000000,3,'0-50005','FLO',1,0),('0-85',10000.000000,0.000000,2,'0-16953','FLO',1,0),('0-86',50000.000000,-11413.600000,6,'145-50','FLO',1,0),('0-87',50000.000000,0.000000,3,'1-802','FLO',1,0),('0-88',10000.000000,0.000000,2,'0-20262','FLO',1,0),('0-89',10000.000000,0.000000,2,'145-25','FLO',1,0),('0-9',50000.000000,-3000.010000,15,'145-23','FLO',1,0),('0-90',10000.000000,0.000000,6,'55-54','FLO',1,0),('0-91',50000.000000,0.000000,3,'1-1447','FLO',1,0),('0-92',50000.000000,0.000000,3,'144-51','FLO',1,0),('0-93',50000.000000,0.000000,7,'1-2205','FLO',1,0),('0-94',10000.000000,0.000000,2,'0-4941','FLO',1,0),('0-95',25000.000000,-10427.100000,46,'104-56','FLO',1,0),('0-96',10000.000000,0.000000,2,'104-34','FLO',1,0),('0-97',50000.000000,0.000000,3,'0-357','FLO',1,0),('0-98',10000.000000,0.000000,10,'0-42','FLO',1,0),('0-99',10000.000000,0.000000,2,'144-4','FLO',1,0),('1-1',3000000.000000,-1530188.065820,8058,'1-2887','FLO',1,1),('1-2',300000.000000,-116686.080000,427,'158-1','FLO',1,1),('1-3',100000.000000,-32461.060000,185,'1-271','FLO',1,1),('104-1',6000000.000000,-3812329.995496,6935,'1-391','FLO',1,0),('104-2',2000000.000000,-1687477.497697,4150,'104-136','FLO',1,1),('175-10',53000.000000,-17493.230000,354,'175-4','FLO',1,0),('175-11',125624.770000,-125624.770000,1052,'175-5','FLO',1,0),('175-12',50000.000000,-35505.400000,445,'175-7','FLO',1,1),('175-13',30000.000000,-12077.660957,513,'175-8','FLO',1,1),('175-4',39000.000000,-29403.490955,1283,'175-1','FLO',1,0),('175-5',100000.000000,-64550.210000,147,'1-857','FLO',1,1),('175-6',2000000.000000,-835155.311955,10226,'1-3130','FLO',1,1),('175-7',500000.000000,-32149.700000,609,'175-2','FLO',1,1),('175-8',500000.000000,-140930.479995,1448,'145-4','FLO',1,1),('175-9',80236.000000,-49608.040000,875,'1-2557','FLO',1,1),('187-1',20000.000000,-8999.990000,42,'187-1','FLO',1,1),('187-2',50000.000000,-23858.640000,86,'187-2','FLO',1,1),('187-21',80000.000000,-62665.940000,58,'187-21','FLO',1,1),('187-26',35000.000000,-1204.401000,8,'187-26','FLO',1,1),('187-4',14060.000000,-9008.310000,16,'187-4','FLO',1,0),('187-5',5300.000000,-300.000000,29,'187-5','FLO',1,1),('187-6',43800.000000,-41893.220000,93,'187-6','FLO',1,1),('187-7',215562.000000,-209648.550000,465,'187-7','FLO',1,1),('187-8',40000.000000,-27555.920000,55,'187-8','FLO',1,1),('187-9',32000.000000,-30150.070000,39,'187-9','FLO',1,1); /*!40000 ALTER TABLE `clientescreditos` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2019-12-04 6:41:35