-- Table structure for table `saldostes`
--

CREATE TABLE `saldostes` (
  `salt_fecha` date NOT NULL,
  `salt_codcta` char(12) NOT NULL,
  `salt_salant` double(15,2) DEFAULT NULL,
  `salt_ingresos` double(15,2) DEFAULT NULL,
  `salt_egresos` double(15,2) DEFAULT NULL,
  `salt_nuesal` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`salt_fecha`,`salt_codcta`),
  KEY `salt_codcta` (`salt_codcta`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `saldostes`
--

INSERT INTO `saldostes` (`salt_fecha`, `salt_codcta`, `salt_salant`, `salt_ingresos`, `salt_egresos`, `salt_nuesal`) VALUES ('2021-08-24','0',0.00,0.00,0.00,0.00),('2021-08-24','110502',0.00,0.00,0.00,0.00),('2021-08-24','1110050101',0.00,177780.22,0.00,177780.22),('2021-08-24','1110050102',0.00,2719291.02,17349550.00,-14630258.98),('2021-08-24','1110050103',0.00,56170.25,1437900.00,-1381729.75),('2021-08-24','1110050104',0.00,879658.51,70983.00,808675.51),('2021-08-24','1110050105',0.00,0.00,0.00,0.00),('2021-08-24','1110050106',0.00,0.00,0.00,0.00),('2021-08-24','1110050107',0.00,0.00,0.00,0.00),('2021-08-24','1110050201',0.00,0.00,0.00,0.00),('2021-08-24','1110050202',0.00,5630266.00,0.00,5630266.00),('2021-08-24','1110050209',0.00,710913.00,9634055.00,-8923142.00),('2021-08-24','1110050210',0.00,461375.00,0.00,461375.00),('2021-08-24','1110050211',0.00,749187.00,0.00,749187.00),('2021-08-24','1110060106',0.00,0.00,0.00,0.00),('2021-08-24','1110060107',0.00,0.00,0.00,0.00),('2021-08-24','1110060202',0.00,0.00,0.00,0.00),('2021-08-24','1110060301',0.00,0.00,0.00,0.00),('2021-08-24','11330802',0.00,0.00,0.00,0.00),('2021-08-24','19060301',0.00,3098330.00,0.00,3098330.00),('2021-08-24','19060401',0.00,1437900.00,0.00,1437900.00),('2021-08-24','29010101',0.00,0.00,0.00,0.00),('2021-08-31','0',0.00,0.00,0.00,0.00),('2021-08-31','110502',0.00,0.00,0.00,0.00),('2021-08-31','1110050101',0.00,49935.28,77734.00,-27798.72),('2021-08-31','1110050102',0.00,140400.00,1508418.51,-1368018.51),('2021-08-31','1110050103',0.00,489194.21,370108.00,119086.21),('2021-08-31','1110050104',0.00,2630891.70,137544.00,2493347.70),('2021-08-31','1110050105',0.00,0.00,0.00,0.00),('2021-08-31','1110050106',0.00,0.00,0.00,0.00),('2021-08-31','1110050107',0.00,0.00,0.00,0.00),('2021-08-31','1110050201',0.00,0.00,399016.19,-399016.19),('2021-08-31','1110050202',0.00,20632591.28,30972922.99,-10340331.71),('2021-08-31','1110050209',0.00,48197905.00,34510.00,48163395.00),('2021-08-31','1110050210',0.00,12356248.00,6902.00,12349346.00),('2021-08-31','1110050211',0.00,32183488.00,0.00,32183488.00),('2021-08-31','1110060106',0.00,0.00,0.00,0.00),('2021-08-31','1110060107',0.00,0.00,0.00,0.00),('2021-08-31','1110060202',0.00,0.00,0.00,0.00),('2021-08-31','1110060301',0.00,0.00,0.00,0.00),('2021-08-31','11330802',0.00,0.00,0.00,0.00),('2021-08-31','19060301',0.00,0.00,0.00,0.00),('2021-08-31','19060401',0.00,0.00,0.00,0.00),('2021-08-31','29010101',0.00,0.00,19330522.00,-19330522.00),('2021-09-01','0',0.00,0.00,0.00,0.00),('2021-09-01','110502',0.00,0.00,0.00,0.00),('2021-09-01','1110050101',-27798.72,0.00,0.00,-27798.72),('2021-09-01','1110050102',-1368018.51,0.00,1338400.00,-2706418.51),('2021-09-01','1110050103',119086.21,0.00,0.00,119086.21),('2021-09-01','1110050104',2493347.70,0.00,1817052.00,676295.70),('2021-09-01','1110050105',0.00,0.00,0.00,0.00),('2021-09-01','1110050106',0.00,0.00,0.00,0.00),('2021-09-01','1110050107',0.00,0.00,0.00,0.00),('2021-09-01','1110050201',-399016.19,0.00,0.00,-399016.19),('2021-09-01','1110050202',-10340331.71,624500.00,0.00,-9715831.71),('2021-09-01','1110050209',48163395.00,0.00,0.00,48163395.00),('2021-09-01','1110050210',12349346.00,0.00,0.00,12349346.00),('2021-09-01','1110050211',32183488.00,0.00,0.00,32183488.00),('2021-09-01','1110060106',0.00,0.00,0.00,0.00),('2021-09-01','1110060107',0.00,0.00,0.00,0.00),('2021-09-01','1110060202',0.00,0.00,0.00,0.00),('2021-09-01','1110060301',0.00,0.00,0.00,0.00),('2021-09-01','11330802',0.00,0.00,0.00,0.00),('2021-09-01','19060301',0.00,330000.00,440000.00,-110000.00),('2021-09-01','19060401',0.00,0.00,0.00,0.00),('2021-09-01','29010101',-19330522.00,3873200.00,0.00,-15457322.00),('2021-09-02','0',0.00,0.00,0.00,0.00),('2021-09-02','110502',0.00,0.00,0.00,0.00),('2021-09-02','1110050101',-27798.72,1031406.98,0.00,1003608.26),('2021-09-02','1110050102',-2706418.51,18090365.42,0.00,15383946.91),('2021-09-02','1110050103',119086.21,2587369.93,0.00,2706456.14),('2021-09-02','1110050104',676295.70,2715579.69,0.00,3391875.39),('2021-09-02','1110050105',0.00,0.00,0.00,0.00),('2021-09-02','1110050106',0.00,0.00,0.00,0.00),('2021-09-02','1110050107',0.00,0.00,0.00,0.00),('2021-09-02','1110050201',-399016.19,0.00,0.00,-399016.19),('2021-09-02','1110050202',-9715831.71,373020.00,170924.00,-9513735.71),('2021-09-02','1110050209',48163395.00,0.00,0.00,48163395.00),('2021-09-02','1110050210',12349346.00,0.00,10700000.00,1649346.00),('2021-09-02','1110050211',32183488.00,0.00,0.00,32183488.00),('2021-09-02','1110060106',0.00,0.00,0.00,0.00),('2021-09-02','1110060107',0.00,0.00,0.00,0.00),('2021-09-02','1110060202',0.00,0.00,0.00,0.00),('2021-09-02','1110060301',0.00,0.00,0.00,0.00),('2021-09-02','11330802',0.00,0.00,0.00,0.00),('2021-09-02','19060301',-110000.00,0.00,2986880.00,-3096880.00),('2021-09-02','19060401',0.00,0.00,0.00,0.00),('2021-09-02','29010101',-15457322.00,251586.74,0.00,-15205735.26),('2021-09-03','0',0.00,0.00,0.00,0.00),('2021-09-03','110502',0.00,0.00,0.00,0.00),('2021-09-03','1110050101',1003608.26,0.00,0.00,1003608.26),('2021-09-03','1110050102',15383946.91,111450.00,0.00,15495396.91),('2021-09-03','1110050103',2706456.14,1600000.00,0.00,4306456.14),('2021-09-03','1110050104',3391875.39,3000000.00,0.00,6391875.39),('2021-09-03','1110050105',0.00,0.00,0.00,0.00),('2021-09-03','1110050106',0.00,0.00,0.00,0.00),('2021-09-03','1110050107',0.00,0.00,0.00,0.00),('2021-09-03','1110050201',-399016.19,0.00,0.00,-399016.19),('2021-09-03','1110050202',-9513735.71,0.00,0.00,-9513735.71),('2021-09-03','1110050209',48163395.00,0.00,0.00,48163395.00),('2021-09-03','1110050210',1649346.00,0.00,0.00,1649346.00),('2021-09-03','1110050211',32183488.00,0.00,0.00,32183488.00),('2021-09-03','1110060106',0.00,0.00,0.00,0.00),('2021-09-03','1110060107',0.00,0.00,0.00,0.00),('2021-09-03','1110060202',0.00,0.00,0.00,0.00),('2021-09-03','1110060301',0.00,0.00,0.00,0.00),('2021-09-03','11330802',0.00,0.00,0.00,0.00),('2021-09-03','19060301',-3096880.00,0.00,111450.00,-3208330.00),('2021-09-03','19060401',0.00,0.00,0.00,0.00),('2021-09-03','29010101',-15205735.26,0.00,0.00,-15205735.26),('2021-09-04','0',0.00,0.00,0.00,0.00),('2021-09-04','110502',0.00,0.00,0.00,0.00),('2021-09-04','1110050101',1003608.26,0.00,0.00,1003608.26),('2021-09-04','1110050102',15495396.91,0.00,0.00,15495396.91),('2021-09-04','1110050103',4306456.14,0.00,0.00,4306456.14),('2021-09-04','1110050104',6391875.39,0.00,0.00,6391875.39),('2021-09-04','1110050105',0.00,0.00,0.00,0.00),('2021-09-04','1110050106',0.00,0.00,0.00,0.00),('2021-09-04','1110050107',0.00,0.00,0.00,0.00),('2021-09-04','1110050201',-399016.19,0.00,0.00,-399016.19),('2021-09-04','1110050202',-9513735.71,0.00,0.00,-9513735.71),('2021-09-04','1110050209',48163395.00,0.00,0.00,48163395.00),('2021-09-04','1110050210',1649346.00,0.00,0.00,1649346.00),('2021-09-04','1110050211',32183488.00,0.00,0.00,32183488.00),('2021-09-04','1110060106',0.00,0.00,0.00,0.00),('2021-09-04','1110060107',0.00,0.00,0.00,0.00),('2021-09-04','1110060202',0.00,0.00,0.00,0.00),('2021-09-04','1110060301',0.00,0.00,0.00,0.00),('2021-09-04','11330802',0.00,0.00,0.00,0.00),('2021-09-04','19060301',-3208330.00,0.00,0.00,-3208330.00),('2021-09-04','19060401',0.00,0.00,0.00,0.00),('2021-09-04','29010101',-15205735.26,0.00,0.00,-15205735.26),('2021-09-05','0',0.00,0.00,0.00,0.00),('2021-09-05','110502',0.00,0.00,0.00,0.00),('2021-09-05','1110050101',1003608.26,0.00,0.00,1003608.26),('2021-09-05','1110050102',15495396.91,0.00,0.00,15495396.91),('2021-09-05','1110050103',4306456.14,0.00,0.00,4306456.14),('2021-09-05','1110050104',6391875.39,0.00,0.00,6391875.39),('2021-09-05','1110050105',0.00,0.00,0.00,0.00),('2021-09-05','1110050106',0.00,0.00,0.00,0.00),('2021-09-05','1110050107',0.00,0.00,0.00,0.00),('2021-09-05','1110050201',-399016.19,0.00,0.00,-399016.19),('2021-09-05','1110050202',-9513735.71,0.00,0.00,-9513735.71),('2021-09-05','1110050209',48163395.00,0.00,0.00,48163395.00),('2021-09-05','1110050210',1649346.00,0.00,0.00,1649346.00),('2021-09-05','1110050211',32183488.00,0.00,0.00,32183488.00),('2021-09-05','1110060106',0.00,0.00,0.00,0.00),('2021-09-05','1110060107',0.00,0.00,0.00,0.00),('2021-09-05','1110060202',0.00,0.00,0.00,0.00),('2021-09-05','1110060301',0.00,0.00,0.00,0.00),('2021-09-05','11330802',0.00,0.00,0.00,0.00),('2021-09-05','19060301',-3208330.00,0.00,0.00,-3208330.00),('2021-09-05','19060401',0.00,0.00,0.00,0.00),('2021-09-05','29010101',-15205735.26,0.00,0.00,-15205735.26),('2021-09-06','0',0.00,0.00,0.00,0.00),('2021-09-06','110502',0.00,0.00,0.00,0.00),('2021-09-06','1110050101',1003608.26,1128488.97,0.00,2132097.23),('2021-09-06','1110050102',15495396.91,8235091.43,1657500.00,22072988.34),('2021-09-06','1110050103',4306456.14,1892934.20,0.00,6199390.34),('2021-09-06','1110050104',6391875.39,2492585.40,6488614.00,2395846.79),('2021-09-06','1110050105',0.00,0.00,0.00,0.00),('2021-09-06','1110050106',0.00,0.00,0.00,0.00),('2021-09-06','1110050107',0.00,0.00,0.00,0.00),('2021-09-06','1110050201',-399016.19,0.00,0.00,-399016.19),('2021-09-06','1110050202',-9513735.71,0.00,0.00,-9513735.71),('2021-09-06','1110050209',48163395.00,0.00,9442084.00,38721311.00),('2021-09-06','1110050210',1649346.00,0.00,0.00,1649346.00),('2021-09-06','1110050211',32183488.00,0.00,0.00,32183488.00),('2021-09-06','1110060106',0.00,0.00,0.00,0.00),('2021-09-06','1110060107',0.00,0.00,0.00,0.00),('2021-09-06','1110060202',0.00,0.00,0.00,0.00),('2021-09-06','1110060301',0.00,0.00,0.00,0.00),('2021-09-06','11330802',0.00,0.00,0.00,0.00),('2021-09-06','19060301',-3208330.00,0.00,0.00,-3208330.00),('2021-09-06','19060401',0.00,0.00,0.00,0.00),('2021-09-06','29010101',-15205735.26,0.00,0.00,-15205735.26),('2021-09-07','0',0.00,0.00,0.00,0.00),('2021-09-07','110502',0.00,0.00,0.00,0.00),('2021-09-07','1110050101',2132097.23,2870466.97,0.00,5002564.20),('2021-09-07','1110050102',22072988.34,23069836.03,1314335.00,43828489.37),('2021-09-07','1110050103',6199390.34,6508452.92,3966917.00,8740926.26),('2021-09-07','1110050104',2395846.79,10680580.19,2778219.00,10298207.98),('2021-09-07','1110050105',0.00,0.00,0.00,0.00),('2021-09-07','1110050106',0.00,0.00,0.00,0.00),('2021-09-07','1110050107',0.00,0.00,0.00,0.00),('2021-09-07','1110050201',-399016.19,0.00,0.00,-399016.19),('2021-09-07','1110050202',-9513735.71,9439613.00,0.00,-74122.71),('2021-09-07','1110050209',38721311.00,2320153.00,0.00,41041464.00),('2021-09-07','1110050210',1649346.00,1094517.00,0.00,2743863.00),('2021-09-07','1110050211',32183488.00,2094284.00,0.00,34277772.00),('2021-09-07','1110060106',0.00,0.00,0.00,0.00),('2021-09-07','1110060107',0.00,0.00,0.00,0.00),('2021-09-07','1110060202',0.00,0.00,0.00,0.00),('2021-09-07','1110060301',0.00,0.00,0.00,0.00),('2021-09-07','11330802',0.00,0.00,0.00,0.00),('2021-09-07','19060301',-3208330.00,250000.00,0.00,-2958330.00),('2021-09-07','19060401',0.00,0.00,0.00,0.00),('2021-09-07','29010101',-15205735.26,4004466.98,0.00,-11201268.28),('2021-09-08','0',0.00,0.00,0.00,0.00),('2021-09-08','110502',0.00,0.00,0.00,0.00),('2021-09-08','1110050101',5002564.20,1795720.70,0.00,6798284.90),('2021-09-08','1110050102',43828489.37,13040910.46,70350000.00,-13480600.17),('2021-09-08','1110050103',8740926.26,3593924.27,2290062.00,10044788.53),('2021-09-08','1110050104',10298207.98,55444.57,12922345.00,-2568692.45),('2021-09-08','1110050105',0.00,0.00,0.00,0.00),('2021-09-08','1110050106',0.00,0.00,0.00,0.00),('2021-09-08','1110050107',0.00,0.00,0.00,0.00),('2021-09-08','1110050201',-399016.19,0.00,33000000.00,-33399016.19),('2021-09-08','1110050202',-74122.71,226747.00,47000000.00,-46847375.71),('2021-09-08','1110050209',41041464.00,0.00,0.00,41041464.00),('2021-09-08','1110050210',2743863.00,0.00,0.00,2743863.00),('2021-09-08','1110050211',34277772.00,0.00,0.00,34277772.00),('2021-09-08','1110060106',0.00,0.00,0.00,0.00),('2021-09-08','1110060107',0.00,0.00,0.00,0.00),('2021-09-08','1110060202',0.00,0.00,0.00,0.00),('2021-09-08','1110060301',0.00,0.00,0.00,0.00),('2021-09-08','11330802',0.00,0.00,0.00,0.00),('2021-09-08','19060301',-2958330.00,130000.00,220000.00,-3048330.00),('2021-09-08','19060401',0.00,0.00,0.00,0.00),('2021-09-08','29010101',-11201268.28,1060400.01,0.00,-10140868.27),('2021-09-09','0',0.00,0.00,0.00,0.00),('2021-09-09','110502',0.00,0.00,0.00,0.00),('2021-09-09','1110050101',6798284.90,0.00,70983.00,6727301.90),('2021-09-09','1110050102',-13480600.17,0.00,1120398.00,-14600998.17),('2021-09-09','1110050103',10044788.53,0.00,3565000.00,6479788.53),('2021-09-09','1110050104',-2568692.45,0.00,12759844.00,-15328536.45),('2021-09-09','1110050105',0.00,0.00,0.00,0.00),('2021-09-09','1110050106',0.00,0.00,0.00,0.00),('2021-09-09','1110050107',0.00,0.00,0.00,0.00),('2021-09-09','1110050201',-33399016.19,0.00,0.00,-33399016.19),('2021-09-09','1110050202',-46847375.71,12545290.79,15000000.00,-49302084.92),('2021-09-09','1110050209',41041464.00,0.00,0.00,41041464.00),('2021-09-09','1110050210',2743863.00,0.00,0.00,2743863.00),('2021-09-09','1110050211',34277772.00,0.00,0.00,34277772.00),('2021-09-09','1110060106',0.00,0.00,0.00,0.00),('2021-09-09','1110060107',0.00,0.00,0.00,0.00),('2021-09-09','1110060202',0.00,0.00,0.00,0.00),('2021-09-09','1110060301',0.00,0.00,0.00,0.00),('2021-09-09','11330802',0.00,0.00,0.00,0.00),('2021-09-09','19060301',-3048330.00,1292065.00,144657.00,-1900922.00),('2021-09-09','19060401',0.00,0.00,0.00,0.00),('2021-09-09','29010101',-10140868.27,290250.00,0.00,-9850618.27),('2021-09-10','0',0.00,0.00,0.00,0.00),('2021-09-10','110502',0.00,0.00,0.00,0.00),('2021-09-10','1110050101',6727301.90,2373644.15,3500000.00,5600946.05),('2021-09-10','1110050102',-14600998.17,17852355.19,31608859.00,-28357501.98),('2021-09-10','1110050103',6479788.53,5069559.53,2109690.00,9439658.06),('2021-09-10','1110050104',-15328536.45,4770597.13,4928000.00,-15485939.32),('2021-09-10','1110050105',0.00,0.00,0.00,0.00),('2021-09-10','1110050106',0.00,0.00,0.00,0.00),('2021-09-10','1110050107',0.00,0.00,0.00,0.00),('2021-09-10','1110050201',-33399016.19,0.00,0.00,-33399016.19),('2021-09-10','1110050202',-49302084.92,0.00,0.00,-49302084.92),('2021-09-10','1110050209',41041464.00,0.00,0.00,41041464.00),('2021-09-10','1110050210',2743863.00,0.00,0.00,2743863.00),('2021-09-10','1110050211',34277772.00,0.00,0.00,34277772.00),('2021-09-10','1110060106',0.00,0.00,0.00,0.00),('2021-09-10','1110060107',0.00,0.00,0.00,0.00),('2021-09-10','1110060202',0.00,0.00,0.00,0.00),('2021-09-10','1110060301',0.00,0.00,0.00,0.00),('2021-09-10','11330802',0.00,0.00,0.00,0.00),('2021-09-10','19060301',-1900922.00,160000.00,0.00,-1740922.00),('2021-09-10','19060401',0.00,34950.00,0.00,34950.00),('2021-09-10','29010101',-9850618.27,182400.00,0.00,-9668218.27),('2021-09-11','0',0.00,0.00,0.00,0.00),('2021-09-11','110502',0.00,0.00,0.00,0.00),('2021-09-11','1110050101',5600946.05,0.00,0.00,5600946.05),('2021-09-11','1110050102',-28357501.98,0.00,0.00,-28357501.98),('2021-09-11','1110050103',9439658.06,0.00,0.00,9439658.06),('2021-09-11','1110050104',-15485939.32,0.00,0.00,-15485939.32),('2021-09-11','1110050105',0.00,0.00,0.00,0.00),('2021-09-11','1110050106',0.00,0.00,0.00,0.00),('2021-09-11','1110050107',0.00,0.00,0.00,0.00),('2021-09-11','1110050201',-33399016.19,0.00,0.00,-33399016.19),('2021-09-11','1110050202',-49302084.92,2608209.99,0.00,-46693874.93),('2021-09-11','1110050209',41041464.00,0.00,0.00,41041464.00),('2021-09-11','1110050210',2743863.00,0.00,0.00,2743863.00),('2021-09-11','1110050211',34277772.00,0.00,0.00,34277772.00),('2021-09-11','1110060106',0.00,0.00,0.00,0.00),('2021-09-11','1110060107',0.00,0.00,0.00,0.00),('2021-09-11','1110060202',0.00,0.00,0.00,0.00),('2021-09-11','1110060301',0.00,0.00,0.00,0.00),('2021-09-11','11330802',0.00,0.00,0.00,0.00),('2021-09-11','19060301',-1740922.00,0.00,0.00,-1740922.00),('2021-09-11','19060401',34950.00,0.00,0.00,34950.00),('2021-09-11','29010101',-9668218.27,0.00,0.00,-9668218.27),('2021-09-12','0',0.00,0.00,0.00,0.00),('2021-09-12','110502',0.00,0.00,0.00,0.00),('2021-09-12','1110050101',5600946.05,0.00,0.00,5600946.05),('2021-09-12','1110050102',-28357501.98,0.00,0.00,-28357501.98),('2021-09-12','1110050103',9439658.06,0.00,0.00,9439658.06),('2021-09-12','1110050104',-15485939.32,0.00,0.00,-15485939.32),('2021-09-12','1110050105',0.00,0.00,0.00,0.00),('2021-09-12','1110050106',0.00,0.00,0.00,0.00),('2021-09-12','1110050107',0.00,0.00,0.00,0.00),('2021-09-12','1110050201',-33399016.19,0.00,0.00,-33399016.19),('2021-09-12','1110050202',-46693874.93,0.00,0.00,-46693874.93),('2021-09-12','1110050209',41041464.00,0.00,0.00,41041464.00),('2021-09-12','1110050210',2743863.00,0.00,0.00,2743863.00),('2021-09-12','1110050211',34277772.00,0.00,0.00,34277772.00),('2021-09-12','1110060106',0.00,0.00,0.00,0.00),('2021-09-12','1110060107',0.00,0.00,0.00,0.00),('2021-09-12','1110060202',0.00,0.00,0.00,0.00),('2021-09-12','1110060301',0.00,0.00,0.00,0.00),('2021-09-12','11330802',0.00,0.00,0.00,0.00),('2021-09-12','19060301',-1740922.00,0.00,0.00,-1740922.00),('2021-09-12','19060401',34950.00,0.00,0.00,34950.00),('2021-09-12','29010101',-9668218.27,0.00,0.00,-9668218.27),('2021-09-13','0',0.00,0.00,0.00,0.00),('2021-09-13','110502',0.00,0.00,0.00,0.00),('2021-09-13','1110050101',5600946.05,1289434.53,0.00,6890380.58),('2021-09-13','1110050102',-28357501.98,12275802.47,0.00,-16081699.51),('2021-09-13','1110050103',9439658.06,2086624.29,1111664.00,10414618.35),('2021-09-13','1110050104',-15485939.32,2618138.71,7083320.00,-19951120.61),('2021-09-13','1110050105',0.00,0.00,0.00,0.00),('2021-09-13','1110050106',0.00,0.00,0.00,0.00),('2021-09-13','1110050107',0.00,0.00,0.00,0.00),('2021-09-13','1110050201',-33399016.19,0.00,0.00,-33399016.19),('2021-09-13','1110050202',-46693874.93,15784305.00,0.00,-30909569.93),('2021-09-13','1110050209',41041464.00,3830177.00,0.00,44871641.00),('2021-09-13','1110050210',2743863.00,2353743.00,0.00,5097606.00),('2021-09-13','1110050211',34277772.00,4933174.00,0.00,39210946.00),('2021-09-13','1110060106',0.00,0.00,0.00,0.00),('2021-09-13','1110060107',0.00,0.00,0.00,0.00),('2021-09-13','1110060202',0.00,0.00,0.00,0.00),('2021-09-13','1110060301',0.00,0.00,0.00,0.00),('2021-09-13','11330802',0.00,0.00,0.00,0.00),('2021-09-13','19060301',-1740922.00,661664.00,0.00,-1079258.00),('2021-09-13','19060401',34950.00,450000.00,0.00,484950.00),('2021-09-13','29010101',-9668218.27,0.00,0.00,-9668218.27),('2021-09-14','0',0.00,0.00,0.00,0.00),('2021-09-14','110502',0.00,0.00,0.00,0.00),('2021-09-14','1110050101',6890380.58,1334850.03,0.00,8225230.61),('2021-09-14','1110050102',-16081699.51,16337526.13,59454573.00,-59198746.38),('2021-09-14','1110050103',10414618.35,2686393.96,0.00,13101012.31),('2021-09-14','1110050104',-19951120.61,3537229.88,0.00,-16413890.73),('2021-09-14','1110050105',0.00,0.00,0.00,0.00),('2021-09-14','1110050106',0.00,0.00,0.00,0.00),('2021-09-14','1110050107',0.00,0.00,0.00,0.00),('2021-09-14','1110050201',-33399016.19,0.00,0.00,-33399016.19),('2021-09-14','1110050202',-30909569.93,13787007.00,0.00,-17122562.93),('2021-09-14','1110050209',44871641.00,1861883.00,0.00,46733524.00),('2021-09-14','1110050210',5097606.00,1511541.00,0.00,6609147.00),('2021-09-14','1110050211',39210946.00,1278512.00,0.00,40489458.00),('2021-09-14','1110060106',0.00,0.00,0.00,0.00),('2021-09-14','1110060107',0.00,0.00,0.00,0.00),('2021-09-14','1110060202',0.00,0.00,0.00,0.00),('2021-09-14','1110060301',0.00,0.00,0.00,0.00),('2021-09-14','11330802',0.00,0.00,0.00,0.00),('2021-09-14','19060301',-1079258.00,320000.00,0.00,-759258.00),('2021-09-14','19060401',484950.00,0.00,0.00,484950.00),('2021-09-14','29010101',-9668218.27,291996150.00,0.00,282327931.73),('2021-09-15','0',0.00,0.00,0.00,0.00),('2021-09-15','110502',0.00,0.00,0.00,0.00),('2021-09-15','1110050101',8225230.61,3415407.56,0.00,11640638.17),('2021-09-15','1110050102',-59198746.38,53873359.25,0.00,-5325387.13),('2021-09-15','1110050103',13101012.31,5226992.94,0.00,18328005.25),('2021-09-15','1110050104',-16413890.73,3899606.78,0.00,-12514283.95),('2021-09-15','1110050105',0.00,0.00,0.00,0.00),('2021-09-15','1110050106',0.00,0.00,0.00,0.00),('2021-09-15','1110050107',0.00,0.00,0.00,0.00),('2021-09-15','1110050201',-33399016.19,0.00,0.00,-33399016.19),('2021-09-15','1110050202',-17122562.93,124799.99,2997185.00,-19994947.94),('2021-09-15','1110050209',46733524.00,0.00,0.00,46733524.00),('2021-09-15','1110050210',6609147.00,0.00,0.00,6609147.00),('2021-09-15','1110050211',40489458.00,0.00,0.00,40489458.00),('2021-09-15','1110060106',0.00,0.00,0.00,0.00),('2021-09-15','1110060107',0.00,0.00,0.00,0.00),('2021-09-15','1110060202',0.00,0.00,0.00,0.00),('2021-09-15','1110060301',0.00,0.00,0.00,0.00),('2021-09-15','11330802',0.00,0.00,0.00,0.00),('2021-09-15','19060301',-759258.00,0.00,0.00,-759258.00),('2021-09-15','19060401',484950.00,0.00,0.00,484950.00),('2021-09-15','29010101',282327931.73,0.00,290987802.00,-8659870.27),('2021-09-16','0',0.00,0.00,0.00,0.00),('2021-09-16','110502',0.00,0.00,0.00,0.00),('2021-09-16','1110050101',11640638.17,2413295.22,2262500.00,11791433.39),('2021-09-16','1110050102',-5325387.13,19698639.53,39814360.00,-25441107.60),('2021-09-16','1110050103',18328005.25,4129689.04,895950.00,21561744.29),('2021-09-16','1110050104',-12514283.95,4274591.21,8409878.00,-16649570.74),('2021-09-16','1110050105',0.00,0.00,0.00,0.00),('2021-09-16','1110050106',0.00,0.00,0.00,0.00),('2021-09-16','1110050107',0.00,0.00,0.00,0.00),('2021-09-16','1110050201',-33399016.19,0.00,0.00,-33399016.19),('2021-09-16','1110050202',-19994947.94,10924914.98,60333812.00,-69403844.96),('2021-09-16','1110050209',46733524.00,3825444.00,1734280.00,48824688.00),('2021-09-16','1110050210',6609147.00,838635.00,0.00,7447782.00),('2021-09-16','1110050211',40489458.00,2759231.00,11799800.00,31448889.00),('2021-09-16','1110060106',0.00,0.00,0.00,0.00),('2021-09-16','1110060107',0.00,0.00,0.00,0.00),('2021-09-16','1110060202',0.00,0.00,0.00,0.00),('2021-09-16','1110060301',0.00,0.00,0.00,0.00),('2021-09-16','11330802',0.00,0.00,1541.68,-1541.68),('2021-09-16','19060301',-759258.00,0.00,250000.00,-1009258.00),('2021-09-16','19060401',484950.00,0.00,0.00,484950.00),('2021-09-16','29010101',-8659870.27,2937449.00,0.00,-5722421.27),('2021-09-17','0',0.00,0.00,0.00,0.00),('2021-09-17','110502',0.00,0.00,0.00,0.00),('2021-09-17','1110050101',11791433.39,1070374.88,0.00,12861808.27),('2021-09-17','1110050102',-25441107.60,15697826.88,0.00,-9743280.72),('2021-09-17','1110050103',21561744.29,1331758.63,0.00,22893502.92),('2021-09-17','1110050104',-16649570.74,3018842.70,0.00,-13630728.04),('2021-09-17','1110050105',0.00,0.00,0.00,0.00),('2021-09-17','1110050106',0.00,0.00,0.00,0.00),('2021-09-17','1110050107',0.00,0.00,0.00,0.00),('2021-09-17','1110050201',-33399016.19,0.00,0.00,-33399016.19),('2021-09-17','1110050202',-69403844.96,6901375.00,0.00,-62502469.96),('2021-09-17','1110050209',48824688.00,950973.00,0.00,49775661.00),('2021-09-17','1110050210',7447782.00,891720.00,0.00,8339502.00),('2021-09-17','1110050211',31448889.00,1079063.00,0.00,32527952.00),('2021-09-17','1110060106',0.00,0.00,0.00,0.00),('2021-09-17','1110060107',0.00,0.00,0.00,0.00),('2021-09-17','1110060202',0.00,0.00,0.00,0.00),('2021-09-17','1110060301',0.00,0.00,0.00,0.00),('2021-09-17','11330802',-1541.68,0.00,0.00,-1541.68),('2021-09-17','19060301',-1009258.00,0.00,0.00,-1009258.00),('2021-09-17','19060401',484950.00,0.00,0.00,484950.00),('2021-09-17','29010101',-5722421.27,0.00,0.00,-5722421.27),('2021-09-18','0',0.00,0.00,0.00,0.00),('2021-09-18','110502',0.00,0.00,0.00,0.00),('2021-09-18','1110050101',12861808.27,0.00,0.00,12861808.27),('2021-09-18','1110050102',-9743280.72,0.00,0.00,-9743280.72),('2021-09-18','1110050103',22893502.92,0.00,0.00,22893502.92),('2021-09-18','1110050104',-13630728.04,0.00,0.00,-13630728.04),('2021-09-18','1110050105',0.00,0.00,0.00,0.00),('2021-09-18','1110050106',0.00,0.00,0.00,0.00),('2021-09-18','1110050107',0.00,0.00,0.00,0.00),('2021-09-18','1110050201',-33399016.19,0.00,0.00,-33399016.19),('2021-09-18','1110050202',-62502469.96,155600.00,0.00,-62346869.96),('2021-09-18','1110050209',49775661.00,0.00,0.00,49775661.00),('2021-09-18','1110050210',8339502.00,0.00,0.00,8339502.00),('2021-09-18','1110050211',32527952.00,0.00,0.00,32527952.00),('2021-09-18','1110060106',0.00,0.00,0.00,0.00),('2021-09-18','1110060107',0.00,0.00,0.00,0.00),('2021-09-18','1110060202',0.00,0.00,0.00,0.00),('2021-09-18','1110060301',0.00,0.00,0.00,0.00),('2021-09-18','11330802',-1541.68,0.00,0.00,-1541.68),('2021-09-18','19060301',-1009258.00,0.00,0.00,-1009258.00),('2021-09-18','19060401',484950.00,0.00,0.00,484950.00),('2021-09-18','29010101',-5722421.27,83519.14,0.00,-5638902.13),('2021-09-19','0',0.00,0.00,0.00,0.00),('2021-09-19','110502',0.00,0.00,0.00,0.00),('2021-09-19','1110050101',12861808.27,0.00,0.00,12861808.27),('2021-09-19','1110050102',-9743280.72,0.00,0.00,-9743280.72),('2021-09-19','1110050103',22893502.92,0.00,0.00,22893502.92),('2021-09-19','1110050104',-13630728.04,0.00,0.00,-13630728.04),('2021-09-19','1110050105',0.00,0.00,0.00,0.00),('2021-09-19','1110050106',0.00,0.00,0.00,0.00),('2021-09-19','1110050107',0.00,0.00,0.00,0.00),('2021-09-19','1110050201',-33399016.19,0.00,0.00,-33399016.19),('2021-09-19','1110050202',-62346869.96,0.00,0.00,-62346869.96),('2021-09-19','1110050209',49775661.00,0.00,0.00,49775661.00),('2021-09-19','1110050210',8339502.00,0.00,0.00,8339502.00),('2021-09-19','1110050211',32527952.00,0.00,0.00,32527952.00),('2021-09-19','1110060106',0.00,0.00,0.00,0.00),('2021-09-19','1110060107',0.00,0.00,0.00,0.00),('2021-09-19','1110060202',0.00,0.00,0.00,0.00),('2021-09-19','1110060301',0.00,0.00,0.00,0.00),('2021-09-19','11330802',-1541.68,0.00,0.00,-1541.68),('2021-09-19','19060301',-1009258.00,0.00,0.00,-1009258.00),('2021-09-19','19060401',484950.00,0.00,0.00,484950.00),('2021-09-19','29010101',-5638902.13,0.00,0.00,-5638902.13),('2021-09-20','0',0.00,0.00,0.00,0.00),('2021-09-20','110502',0.00,0.00,0.00,0.00),('2021-09-20','1110050101',12861808.27,1969522.07,11779112.00,3052218.34),('2021-09-20','1110050102',-9743280.72,18362748.26,1800000.00,6819467.54),('2021-09-20','1110050103',22893502.92,2318687.75,2992000.00,22220190.67),('2021-09-20','1110050104',-13630728.04,2899671.16,7022416.00,-17753472.88),('2021-09-20','1110050105',0.00,0.00,0.00,0.00),('2021-09-20','1110050106',0.00,0.00,0.00,0.00),('2021-09-20','1110050107',0.00,0.00,0.00,0.00),('2021-09-20','1110050201',-33399016.19,0.00,0.00,-33399016.19),('2021-09-20','1110050202',-62346869.96,0.00,0.00,-62346869.96),('2021-09-20','1110050209',49775661.00,0.00,0.00,49775661.00),('2021-09-20','1110050210',8339502.00,0.00,0.00,8339502.00),('2021-09-20','1110050211',32527952.00,0.00,0.00,32527952.00),('2021-09-20','1110060106',0.00,0.00,0.00,0.00),('2021-09-20','1110060107',0.00,0.00,0.00,0.00),('2021-09-20','1110060202',0.00,0.00,0.00,0.00),('2021-09-20','1110060301',0.00,0.00,0.00,0.00),('2021-09-20','11330802',-1541.68,0.00,0.00,-1541.68),('2021-09-20','19060301',-1009258.00,1079112.00,1422065.00,-1352211.00),('2021-09-20','19060401',484950.00,1800000.00,0.00,2284950.00),('2021-09-20','29010101',-5638902.13,0.00,0.00,-5638902.13),('2021-09-21','0',0.00,0.00,0.00,0.00),('2021-09-21','110502',0.00,0.00,0.00,0.00),('2021-09-21','1110050101',3052218.34,664555.07,22935500.00,-19218726.59),('2021-09-21','1110050102',6819467.54,7151408.72,1901124.00,12069752.26),('2021-09-21','1110050103',22220190.67,0.00,0.00,22220190.67),('2021-09-21','1110050104',-17753472.88,2060219.62,0.00,-15693253.26),('2021-09-21','1110050105',0.00,0.00,0.00,0.00),('2021-09-21','1110050106',0.00,0.00,0.00,0.00),('2021-09-21','1110050107',0.00,0.00,0.00,0.00),('2021-09-21','1110050201',-33399016.19,0.00,0.00,-33399016.19),('2021-09-21','1110050202',-62346869.96,61157848.00,16504017.00,-17693038.96),('2021-09-21','1110050209',49775661.00,0.00,0.00,49775661.00),('2021-09-21','1110050210',8339502.00,0.00,0.00,8339502.00),('2021-09-21','1110050211',32527952.00,0.00,0.00,32527952.00),('2021-09-21','1110060106',0.00,0.00,0.00,0.00),('2021-09-21','1110060107',0.00,0.00,0.00,0.00),('2021-09-21','1110060202',0.00,0.00,0.00,0.00),('2021-09-21','1110060301',0.00,0.00,0.00,0.00),('2021-09-21','11330802',-1541.68,0.00,29904.00,-31445.68),('2021-09-21','19060301',-1352211.00,0.00,160000.00,-1512211.00),('2021-09-21','19060401',2284950.00,0.00,0.00,2284950.00),('2021-09-21','29010101',-5638902.13,457538.00,0.00,-5181364.13),('2021-09-22','0',0.00,0.00,0.00,0.00),('2021-09-22','110502',0.00,0.00,0.00,0.00),('2021-09-22','1110050101',-19218726.59,556167.14,0.00,-18662559.45),('2021-09-22','1110050102',12069752.26,20055984.39,32156300.00,-30563.35),('2021-09-22','1110050103',22220190.67,2298020.67,0.00,24518211.34),('2021-09-22','1110050104',-15693253.26,959328.04,0.00,-14733925.22),('2021-09-22','1110050105',0.00,0.00,0.00,0.00),('2021-09-22','1110050106',0.00,0.00,0.00,0.00),('2021-09-22','1110050107',0.00,0.00,0.00,0.00),('2021-09-22','1110050201',-33399016.19,0.00,0.00,-33399016.19),('2021-09-22','1110050202',-17693038.96,11994208.48,0.00,-5698830.48),('2021-09-22','1110050209',49775661.00,49274390.00,0.00,99050051.00),('2021-09-22','1110050210',8339502.00,12659624.00,0.00,20999126.00),('2021-09-22','1110050211',32527952.00,34507429.00,0.00,67035381.00),('2021-09-22','1110060106',0.00,0.00,0.00,0.00),('2021-09-22','1110060107',0.00,0.00,0.00,0.00),('2021-09-22','1110060202',0.00,0.00,0.00,0.00),('2021-09-22','1110060301',0.00,0.00,0.00,0.00),('2021-09-22','11330802',-31445.68,0.00,0.00,-31445.68),('2021-09-22','19060301',-1512211.00,0.00,0.00,-1512211.00),('2021-09-22','19060401',2284950.00,0.00,34950.00,2250000.00),('2021-09-22','29010101',-5181364.13,0.00,0.00,-5181364.13),('2021-09-23','0',0.00,0.00,0.00,0.00),('2021-09-23','110502',0.00,0.00,0.00,0.00),('2021-09-23','1110050101',-18662559.45,416159.77,0.00,-18246399.68),('2021-09-23','1110050102',-30563.35,17905387.63,0.00,17874824.28),('2021-09-23','1110050103',24518211.34,647248.40,0.00,25165459.74),('2021-09-23','1110050104',-14733925.22,775992.19,0.00,-13957933.03),('2021-09-23','1110050105',0.00,0.00,0.00,0.00),('2021-09-23','1110050106',0.00,0.00,0.00,0.00),('2021-09-23','1110050107',0.00,0.00,0.00,0.00),('2021-09-23','1110050201',-33399016.19,0.00,0.00,-33399016.19),('2021-09-23','1110050202',-5698830.48,2948209.45,0.00,-2750621.03),('2021-09-23','1110050209',99050051.00,0.00,0.00,99050051.00),('2021-09-23','1110050210',20999126.00,0.00,0.00,20999126.00),('2021-09-23','1110050211',67035381.00,0.00,0.00,67035381.00),('2021-09-23','1110060106',0.00,0.00,0.00,0.00),('2021-09-23','1110060107',0.00,0.00,0.00,0.00),('2021-09-23','1110060202',0.00,0.00,0.00,0.00),('2021-09-23','1110060301',0.00,0.00,0.00,0.00),('2021-09-23','11330802',-31445.68,0.00,0.00,-31445.68),('2021-09-23','19060301',-1512211.00,0.00,0.00,-1512211.00),('2021-09-23','19060401',2250000.00,0.00,0.00,2250000.00),('2021-09-23','29010101',-5181364.13,0.00,0.00,-5181364.13),('2021-09-24','0',0.00,0.00,0.00,0.00),('2021-09-24','110502',0.00,0.00,0.00,0.00),('2021-09-24','1110050101',-18246399.68,0.00,0.00,-18246399.68),('2021-09-24','1110050102',17874824.28,0.00,353979.00,17520845.28),('2021-09-24','1110050103',25165459.74,0.00,0.00,25165459.74),('2021-09-24','1110050104',-13957933.03,0.00,0.00,-13957933.03),('2021-09-24','1110050105',0.00,0.00,0.00,0.00),('2021-09-24','1110050106',0.00,0.00,0.00,0.00),('2021-09-24','1110050107',0.00,0.00,0.00,0.00),('2021-09-24','1110050201',-33399016.19,0.00,0.00,-33399016.19),('2021-09-24','1110050202',-2750621.03,573395.00,13357831.00,-15535057.03),('2021-09-24','1110050209',99050051.00,124585.00,0.00,99174636.00),('2021-09-24','1110050210',20999126.00,69434.00,0.00,21068560.00),('2021-09-24','1110050211',67035381.00,212886.00,0.00,67248267.00),('2021-09-24','1110060106',0.00,0.00,0.00,0.00),('2021-09-24','1110060107',0.00,0.00,0.00,0.00),('2021-09-24','1110060202',0.00,0.00,0.00,0.00),('2021-09-24','1110060301',0.00,0.00,0.00,0.00),('2021-09-24','11330802',-31445.68,0.00,0.00,-31445.68),('2021-09-24','19060301',-1512211.00,0.00,965806.00,-2478017.00),('2021-09-24','19060401',2250000.00,0.00,0.00,2250000.00),('2021-09-24','29010101',-5181364.13,0.00,0.00,-5181364.13),('2021-09-25','0',0.00,0.00,0.00,0.00),('2021-09-25','110502',0.00,0.00,0.00,0.00),('2021-09-25','1110050101',-18246399.68,0.00,0.00,-18246399.68),('2021-09-25','1110050102',17520845.28,0.00,0.00,17520845.28),('2021-09-25','1110050103',25165459.74,0.00,0.00,25165459.74),('2021-09-25','1110050104',-13957933.03,0.00,0.00,-13957933.03),('2021-09-25','1110050105',0.00,0.00,0.00,0.00),('2021-09-25','1110050106',0.00,0.00,0.00,0.00),('2021-09-25','1110050107',0.00,0.00,0.00,0.00),('2021-09-25','1110050201',-33399016.19,0.00,0.00,-33399016.19),('2021-09-25','1110050202',-15535057.03,0.00,0.00,-15535057.03),('2021-09-25','1110050209',99174636.00,0.00,0.00,99174636.00),('2021-09-25','1110050210',21068560.00,0.00,0.00,21068560.00),('2021-09-25','1110050211',67248267.00,0.00,0.00,67248267.00),('2021-09-25','1110060106',0.00,0.00,0.00,0.00),('2021-09-25','1110060107',0.00,0.00,0.00,0.00),('2021-09-25','1110060202',0.00,0.00,0.00,0.00),('2021-09-25','1110060301',0.00,0.00,0.00,0.00),('2021-09-25','11330802',-31445.68,0.00,0.00,-31445.68),('2021-09-25','19060301',-2478017.00,0.00,0.00,-2478017.00),('2021-09-25','19060401',2250000.00,0.00,0.00,2250000.00),('2021-09-25','29010101',-5181364.13,0.00,0.00,-5181364.13),('2021-09-26','0',0.00,0.00,0.00,0.00),('2021-09-26','110502',0.00,0.00,0.00,0.00),('2021-09-26','1110050101',-18246399.68,0.00,0.00,-18246399.68),('2021-09-26','1110050102',17520845.28,0.00,0.00,17520845.28),('2021-09-26','1110050103',25165459.74,0.00,0.00,25165459.74),('2021-09-26','1110050104',-13957933.03,0.00,0.00,-13957933.03),('2021-09-26','1110050105',0.00,0.00,0.00,0.00),('2021-09-26','1110050106',0.00,0.00,0.00,0.00),('2021-09-26','1110050107',0.00,0.00,0.00,0.00),('2021-09-26','1110050201',-33399016.19,0.00,0.00,-33399016.19),('2021-09-26','1110050202',-15535057.03,0.00,0.00,-15535057.03),('2021-09-26','1110050209',99174636.00,0.00,0.00,99174636.00),('2021-09-26','1110050210',21068560.00,0.00,0.00,21068560.00),('2021-09-26','1110050211',67248267.00,0.00,0.00,67248267.00),('2021-09-26','1110060106',0.00,0.00,0.00,0.00),('2021-09-26','1110060107',0.00,0.00,0.00,0.00),('2021-09-26','1110060202',0.00,0.00,0.00,0.00),('2021-09-26','1110060301',0.00,0.00,0.00,0.00),('2021-09-26','11330802',-31445.68,0.00,0.00,-31445.68),('2021-09-26','19060301',-2478017.00,0.00,0.00,-2478017.00),('2021-09-26','19060401',2250000.00,0.00,0.00,2250000.00),('2021-09-26','29010101',-5181364.13,0.00,0.00,-5181364.13),('2021-09-27','0',0.00,0.00,0.00,0.00),('2021-09-27','110502',0.00,0.00,0.00,0.00),('2021-09-27','1110050101',-18246399.68,717053.52,0.00,-17529346.16),('2021-09-27','1110050102',17520845.28,4904642.47,290000.00,22135487.75),('2021-09-27','1110050103',25165459.74,989515.11,0.00,26154974.85),('2021-09-27','1110050104',-13957933.03,1096213.98,258761.00,-13120480.05),('2021-09-27','1110050105',0.00,0.00,0.00,0.00),('2021-09-27','1110050106',0.00,0.00,0.00,0.00),('2021-09-27','1110050107',0.00,0.00,0.00,0.00),('2021-09-27','1110050201',-33399016.19,0.00,0.00,-33399016.19),('2021-09-27','1110050202',-15535057.03,12177068.82,38521741.72,-41879729.93),('2021-09-27','1110050209',99174636.00,0.00,14721010.00,84453626.00),('2021-09-27','1110050210',21068560.00,0.00,0.00,21068560.00),('2021-09-27','1110050211',67248267.00,0.00,0.00,67248267.00),('2021-09-27','1110060106',0.00,0.00,0.00,0.00),('2021-09-27','1110060107',0.00,0.00,0.00,0.00),('2021-09-27','1110060202',0.00,0.00,0.00,0.00),('2021-09-27','1110060301',0.00,0.00,0.00,0.00),('2021-09-27','11330802',-31445.68,0.00,0.00,-31445.68),('2021-09-27','19060301',-2478017.00,290000.00,1094970.00,-3282987.00),('2021-09-27','19060401',2250000.00,0.00,0.00,2250000.00),('2021-09-27','29010101',-5181364.13,8406021.93,0.00,3224657.80),('2021-09-28','0',0.00,0.00,0.00,0.00),('2021-09-28','110502',0.00,0.00,0.00,0.00),('2021-09-28','1110050101',-17529346.16,417015.28,426915.00,-17539245.88),('2021-09-28','1110050102',22135487.75,3110787.74,0.00,25246275.49),('2021-09-28','1110050103',26154974.85,631956.78,661664.00,26125267.63),('2021-09-28','1110050104',-13120480.05,992962.73,0.00,-12127517.32),('2021-09-28','1110050105',0.00,0.00,0.00,0.00),('2021-09-28','1110050106',0.00,0.00,0.00,0.00),('2021-09-28','1110050107',0.00,0.00,0.00,0.00),('2021-09-28','1110050201',-33399016.19,0.00,0.00,-33399016.19),('2021-09-28','1110050202',-41879729.93,5543080.00,0.00,-36336649.93),('2021-09-28','1110050209',84453626.00,362219.00,0.00,84815845.00),('2021-09-28','1110050210',21068560.00,80237.00,0.00,21148797.00),('2021-09-28','1110050211',67248267.00,197340.00,0.00,67445607.00),('2021-09-28','1110060106',0.00,0.00,0.00,0.00),('2021-09-28','1110060107',0.00,0.00,0.00,0.00),('2021-09-28','1110060202',0.00,0.00,0.00,0.00),('2021-09-28','1110060301',0.00,0.00,0.00,0.00),('2021-09-28','11330802',-31445.68,0.00,0.00,-31445.68),('2021-09-28','19060301',-3282987.00,1088579.00,0.00,-2194408.00),('2021-09-28','19060401',2250000.00,0.00,0.00,2250000.00),('2021-09-28','29010101',3224657.80,0.00,14484421.00,-11259763.20),('2021-09-29','0',0.00,0.00,0.00,0.00),('2021-09-29','110502',0.00,0.00,0.00,0.00),('2021-09-29','1110050101',-17539245.88,53171.03,0.00,-17486074.85),('2021-09-29','1110050102',25246275.49,441484.59,0.00,25687760.08),('2021-09-29','1110050103',26125267.63,76411.93,0.00,26201679.56),('2021-09-29','1110050104',-12127517.32,94879.98,1217307.00,-13249944.34),('2021-09-29','1110050105',0.00,0.00,0.00,0.00),('2021-09-29','1110050106',0.00,0.00,0.00,0.00),('2021-09-29','1110050107',0.00,0.00,0.00,0.00),('2021-09-29','1110050201',-33399016.19,0.00,0.00,-33399016.19),('2021-09-29','1110050202',-36336649.93,167345.00,7213196.00,-43382500.93),('2021-09-29','1110050209',84815845.00,16000.00,32017058.00,52814787.00),('2021-09-29','1110050210',21148797.00,19827.00,0.00,21168624.00),('2021-09-29','1110050211',67445607.00,52128.00,5713968.00,61783767.00),('2021-09-29','1110060106',0.00,0.00,0.00,0.00),('2021-09-29','1110060107',0.00,0.00,0.00,0.00),('2021-09-29','1110060202',0.00,0.00,0.00,0.00),('2021-09-29','1110060301',0.00,0.00,0.00,0.00),('2021-09-29','11330802',-31445.68,0.00,42465.16,-73910.84),('2021-09-29','19060301',-2194408.00,0.00,0.00,-2194408.00),('2021-09-29','19060401',2250000.00,450000.00,0.00,2700000.00),('2021-09-29','29010101',-11259763.20,0.00,0.00,-11259763.20),('2021-09-30','0',0.00,0.00,0.00,0.00),('2021-09-30','110502',0.00,0.00,0.00,0.00),('2021-09-30','1110050101',-17486074.85,25575.30,2793755.00,-20254254.55),('2021-09-30','1110050102',25687760.08,4860781.99,25221787.33,5326754.74),('2021-09-30','1110050103',26201679.56,1590292.61,140003.00,27651969.17),('2021-09-30','1110050104',-13249944.34,1734257.74,402065.00,-11917751.60),('2021-09-30','1110050105',0.00,0.00,0.00,0.00),('2021-09-30','1110050106',0.00,0.00,0.00,0.00),('2021-09-30','1110050107',0.00,0.00,0.00,0.00),('2021-09-30','1110050201',-33399016.19,50183965.00,178595.64,16606353.17),('2021-09-30','1110050202',-43382500.93,6421337.50,2263815.03,-39224978.46),('2021-09-30','1110050209',52814787.00,15400.00,205037.00,52625150.00),('2021-09-30','1110050210',21168624.00,85476.00,1972223.00,19281877.00),('2021-09-30','1110050211',61783767.00,39878.00,55216.00,61768429.00),('2021-09-30','1110060106',0.00,0.00,0.00,0.00),('2021-09-30','1110060107',0.00,0.00,0.00,0.00),('2021-09-30','1110060202',0.00,0.00,0.00,0.00),('2021-09-30','1110060301',0.00,0.00,0.00,0.00),('2021-09-30','11330802',-73910.84,0.00,0.00,-73910.84),('2021-09-30','19060301',-2194408.00,0.00,0.00,-2194408.00),('2021-09-30','19060401',2700000.00,0.00,0.00,2700000.00),('2021-09-30','29010101',-11259763.20,0.00,0.00,-11259763.20),('2021-11-01','0',0.00,0.00,0.00,0.00),('2021-11-01','110502',0.00,0.00,0.00,0.00),('2021-11-01','1110050101',0.00,0.00,0.00,0.00),('2021-11-01','1110050102',0.00,0.00,0.00,0.00),('2021-11-01','1110050103',0.00,0.00,0.00,0.00),('2021-11-01','1110050104',0.00,0.00,0.00,0.00),('2021-11-01','1110050105',0.00,0.00,0.00,0.00),('2021-11-01','1110050106',0.00,0.00,0.00,0.00),('2021-11-01','1110050107',0.00,0.00,0.00,0.00),('2021-11-01','1110050201',0.00,0.00,0.00,0.00),('2021-11-01','1110050202',0.00,0.00,0.00,0.00),('2021-11-01','1110050209',0.00,0.00,0.00,0.00),('2021-11-01','1110050210',0.00,0.00,0.00,0.00),('2021-11-01','1110050211',0.00,0.00,0.00,0.00),('2021-11-01','1110060106',0.00,0.00,0.00,0.00),('2021-11-01','1110060107',0.00,0.00,0.00,0.00),('2021-11-01','1110060202',0.00,0.00,0.00,0.00),('2021-11-01','1110060301',0.00,0.00,0.00,0.00),('2021-11-01','11330802',0.00,0.00,0.00,0.00),('2021-11-01','19060301',0.00,0.00,0.00,0.00),('2021-11-01','19060401',0.00,0.00,0.00,0.00),('2021-11-01','29010101',0.00,0.00,0.00,0.00);

--
-- Table structure for table `saldosx`
--

CREATE TABLE `saldosx` (
  `salx_ano` int(4) NOT NULL DEFAULT '0',
  `salx_mes` int(2) NOT NULL DEFAULT '0',
  `salx_codcta` char(12) NOT NULL DEFAULT '',
  `salx_salant` double(15,2) DEFAULT NULL,
  `salx_debmes` double(15,2) DEFAULT NULL,
  `salx_cremes` double(15,2) DEFAULT NULL,
  `salx_debacu` double(15,2) DEFAULT NULL,
  `salx_creacu` double(15,2) DEFAULT NULL,
  `salx_nuesal` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`salx_ano`,`salx_mes`,`salx_codcta`),
  KEY `salx_codcta` (`salx_codcta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `saldosx`
--


--
-- Table structure for table `saldosxt`
--

CREATE TABLE `saldosxt` (
  `salx_ano` int(4) NOT NULL DEFAULT '0',
  `salx_mes` int(2) NOT NULL DEFAULT '0',
  `salx_codcta` char(12) NOT NULL DEFAULT '',
  `salx_salant` double(15,2) DEFAULT NULL,
  `salx_debmes` double(15,2) DEFAULT NULL,
  `salx_cremes` double(15,2) DEFAULT NULL,
  `salx_debacu` double(15,2) DEFAULT NULL,
  `salx_creacu` double(15,2) DEFAULT NULL,
  `salx_nuesal` double(15,2) DEFAULT NULL,
  `salx_cor` double(15,2) NOT NULL,
  `salx_ncor` double(15,2) NOT NULL,
  PRIMARY KEY (`salx_ano`,`salx_mes`,`salx_codcta`),
  KEY `salx_codcta` (`salx_codcta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `saldosxt`
--


--
-- Table structure for table `salidas`
--

CREATE TABLE `salidas` (
  `sa_tipo_sa` int(1) NOT NULL DEFAULT '1' COMMENT '1.Normal, 2. Almacen',
  `sa_numero` int(9) NOT NULL,
  `sa_codcli` varchar(12) NOT NULL,
  `sa_fecreg` date DEFAULT NULL,
  `sa_horreg` time NOT NULL DEFAULT '00:00:00',
  `sa_vlrtot` double(15,2) DEFAULT NULL,
  `sa_vlriva` double(15,2) DEFAULT NULL,
  `sa_apagar` double(15,2) DEFAULT NULL,
  `sa_estado` char(1) NOT NULL,
  `sa_codcen` varchar(6) NOT NULL,
  `sa_codaux` varchar(70) NOT NULL,
  `sa_usuario` varchar(15) NOT NULL,
  `sa_tipo` varchar(1) NOT NULL,
  `sa_ccosto` varchar(6) NOT NULL,
  `descripcion` text NOT NULL,
  `sa_clase` varchar(1) NOT NULL DEFAULT 'B' COMMENT 'Salidas Buenas o Malas',
  `sa_solicitud` int(11) NOT NULL,
  PRIMARY KEY (`sa_numero`,`sa_tipo_sa`),
  KEY `sa_codcli` (`sa_codcli`),
  KEY `sa_codcen` (`sa_codcen`),
  KEY `sa_codaux` (`sa_codaux`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salidas`
--


--
-- Table structure for table `salidasdev`
--

CREATE TABLE `salidasdev` (
  `sa_tipo_sa` int(1) NOT NULL DEFAULT '1' COMMENT '1.Normal, 2. Almacen',
  `sa_numero` int(9) NOT NULL,
  `sa_codcli` varchar(12) NOT NULL,
  `sa_fecreg` date DEFAULT NULL,
  `sa_horreg` time NOT NULL DEFAULT '00:00:00',
  `sa_vlrtot` double(15,2) DEFAULT NULL,
  `sa_vlriva` double(15,2) DEFAULT NULL,
  `sa_apagar` double(15,2) DEFAULT NULL,
  `sa_estado` char(1) NOT NULL,
  `sa_codcen` varchar(6) NOT NULL,
  `sa_codaux` varchar(70) NOT NULL,
  `sa_usuario` varchar(15) NOT NULL,
  `sa_tipo` varchar(1) NOT NULL,
  `sa_ccosto` varchar(6) NOT NULL,
  `descripcion` text NOT NULL,
  `sa_clase` varchar(1) NOT NULL DEFAULT 'B' COMMENT 'Salidas Buenas o Malas',
  `sa_solicitud` int(11) NOT NULL,
  `sa_resori` varchar(12) NOT NULL,
  `sa_resdes` varchar(12) NOT NULL,
  PRIMARY KEY (`sa_numero`,`sa_tipo_sa`),
  KEY `sa_codcli` (`sa_codcli`),
  KEY `sa_codcen` (`sa_codcen`),
  KEY `sa_codaux` (`sa_codaux`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salidasdev`
--

INSERT INTO `salidasdev` (`sa_tipo_sa`, `sa_numero`, `sa_codcli`, `sa_fecreg`, `sa_horreg`, `sa_vlrtot`, `sa_vlriva`, `sa_apagar`, `sa_estado`, `sa_codcen`, `sa_codaux`, `sa_usuario`, `sa_tipo`, `sa_ccosto`, `descripcion`, `sa_clase`, `sa_solicitud`, `sa_resori`, `sa_resdes`) VALUES (2,1,'1117508778','2021-02-23','06:23:06',2608242.00,0.00,2608242.00,'F','1003','','1117508778','P','1003',' SE REALIZA LA ENTREGA EN CALIDAD DE DEVOLUTIVO DE GUADAÑA CON YOYO Y SUS ACCESORIOS PARA REALIZAR PODA DE CÉSPED Y LIMPIEZA EN LAS CALLES DE CARTAGENA DEL CHAIRA ','B',0,'1','17641358'),(2,2,'1','2021-04-12','04:09:05',9535000.00,0.00,9535000.00,'F','1004','','jmorales','E','1004','traslado de posteria para adecuacion, mejoramiento y expansión en las redes de energía en los barrios ciudadela, la cabaña, invasion 15 de junio, gaitan y comuneros.','B',0,'1','79201571'),(2,3,'1','2021-10-29','09:49:28',13187875.50,0.00,13187875.50,'F','1004','','1117508778','E','1004',' CAMBIO DE TRANSFORMADORES EN EL BARRIO GAITAN FRENTE A NESTLE Y BELLA VISTA PORQUE SE QUEMARON LOS ANTIGUOS','B',0,'1','79201571'),(2,4,'1','2021-10-29','10:06:43',229664.05,0.00,229664.05,'F','1004','','1117508778','P','1004',' ENTREGA DE HERRAMIENTAS PARA ENERGIA ','B',0,'1','1006526995'),(2,5,'1','2021-10-29','10:08:15',229664.05,0.00,229664.05,'F','1004','','1117508778','P','1004',' ENTREGA DE HERRAMIENTAS','B',0,'1','17710656'),(2,6,'1','2021-10-29','10:09:07',229664.05,0.00,229664.05,'F','1004','','1117508778','P','1004',' ENTREGA DE HERRAMIENTAS ','B',0,'1','1117497550'),(2,7,'1','2021-10-29','10:10:05',229664.05,0.00,229664.05,'F','1004','','1117508778','P','1004',' ENTREGA DE HERRAMIENTAS ','B',0,'1','17710093'),(2,8,'1','2021-10-29','10:10:49',229664.05,0.00,229664.05,'F','1004','','1117508778','P','1004',' ENTREGA DE HERRAMIENTAS ','B',0,'1','1117508268'),(2,9,'1','2021-12-14','05:21:36',15515100.50,0.00,15515100.50,'F','1004','','1117535344','E','1004',' SE HACE ENTREGA A BODEGA DE ENERGIA AL RESPONSABLE RAFAEL CAMPOS','B',0,'1','79201571');

--
-- Table structure for table `secciones`
--

CREATE TABLE `secciones` (
  `se_codsec` int(4) NOT NULL DEFAULT '0',
  `se_descri` char(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`se_codsec`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `secciones`
--

INSERT INTO `secciones` (`se_codsec`, `se_descri`) VALUES (0,'NO APLICA'),(1001,'BODEGA ACUEDUCTO'),(1002,'BODEGA ALCANTARILLADO'),(1000,'BODEGA PRINCIPAL'),(1,'REDES'),(2,'DEPARTAMENTO OPERATIVO'),(3,'DEPARTAMENTO ADMINISTRATIVA'),(4,'GERENCIA'),(5,'QUEJAS Y RECLAMOS'),(6,'OFICINA CONTROL INTERNO'),(7,'DEPENDENCIA DE SISTEMAS'),(8,'DIVISION FINANCIERA'),(9,'OFICINA ALMACEN'),(10,'SERVICIOS GENERALES'),(14,'FACTURACION'),(15,'SECRETARIA GENERAL'),(16,'PLANTA BOMBEO'),(17,'PLANTA TRATAMIENTO'),(18,'PLANTA SUR'),(19,'JEFE RELLENO SANITARIO'),(20,'CELADURIA'),(21,'OPERARIO'),(22,'JEFATURA COMERCIAL'),(24,'ARCHIVO GENERAL'),(25,'FUNCIONARIA ADMINISTRATIVA'),(27,'LABORATORIO'),(28,'ASESOR JURIDICO'),(1004,'BODEGA ENERGIA'),(9902,'BODEGA DE RESPONSABILIDADES FISCALES'),(9999,'BODEGA DE INSERVIBLES'),(1003,'BODEGA ASEO');

--
-- Table structure for table `secuencia`
--

CREATE TABLE `secuencia` (
  `se_tipsec` char(3) NOT NULL,
  `se_descri` char(40) DEFAULT NULL,
  `se_numero` int(9) DEFAULT NULL,
  PRIMARY KEY (`se_tipsec`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `secuencia`
--

INSERT INTO `secuencia` (`se_tipsec`, `se_descri`, `se_numero`) VALUES ('C','Compras',220000),('D','Descuentos',220000),('E','Factura Equivalente',220000),('F','Facturas',220000),('N','Recibos de pago Nomina',220000),('P','Recibos de Pago',220000),('R','Recibos de Caja',220000),('S','Salidas de Inventario',220000),('X','Cuentas Por Pagar',220000),('I','Disponibilidades',220016),('G','Registros Presupuestales',220016),('GP','Giro Presupuestal',0),('CS','Consignaciones',220000),('PE','Pedidos Entradas',220000),('OR','Ordenes de Compra',220000),('PS','Pedidos Salidas',220000),('A','Adiciones Presupuestales',220000),('DP','Disminucion Presupuestal',220000),('TP','Traslado Presupuestal',220000),('OP','Orden de pago',220016),('EP','Egresos ordenes de pago',220017),('NB','Notas bancarias',220000),('CD','Cambios Disponibilidad',220000),('CR','Cambios Registros',220000),('RC','Recaudos Presupuestales',220000),('LC','Liquidacion Contrato',220000),('CN','Liquidacion Contrato',220000),('PC','Pagos directo por cuenta',220000),('SD','Solicitud de Disponibilidad',220016),('LA','Avances',220000),('TB','Traslados Bancarios',220000),('CM1','Caja menor 1',220000),('CO','Cambios ordenes de pago',220002),('NE','Nomina \r\nElectronica',220000);

--
-- Table structure for table `solicitud`
--

CREATE TABLE `solicitud` (
  `sol_numero` int(9) NOT NULL,
  `sol_codcli` bigint(12) DEFAULT NULL,
  `sol_codres` char(12) NOT NULL,
  `sol_fecreg` date DEFAULT NULL,
  `sol_horreg` time NOT NULL DEFAULT '00:00:00',
  `sol_estado` char(1) NOT NULL,
  `sol_vigencia` int(9) NOT NULL,
  `sol_vlrtot` double(15,2) DEFAULT NULL,
  `sol_detalle` text NOT NULL,
  `sol_codsec` int(9) NOT NULL,
  `sol_codare` int(9) NOT NULL,
  PRIMARY KEY (`sol_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `solicitud`
--

INSERT INTO `solicitud` (`sol_numero`, `sol_codcli`, `sol_codres`, `sol_fecreg`, `sol_horreg`, `sol_estado`, `sol_vigencia`, `sol_vlrtot`, `sol_detalle`, `sol_codsec`, `sol_codare`) VALUES (220001,41250731,'1117535344','2022-01-04','03:01:07','C',2022,1789532.00,'  CONSTITUCION DE CUENTAS POR PAGAR DEL AÑO 2021 - CANCELAMOS LIQUIDACION A UN EX FUNCIONARIO DE EMSERPUCAR ESP SEGUN RESOLUCION ADMINISTRATIVA N 367-2021',2,4),(220002,41250731,'1117535344','2022-01-04','04:45:07','C',2022,3026457.00,' CONSTITUCION DE CUENTAS POR PAGAR DEL AÑO 2021 - CANCELAMOS LIQUIDACION A UN EX FUNCIONARIO DE EMSERPUCAR ESP SEGUN RESOLUCION ADMINISTRATIVA N 369-2021',3,6),(220003,41250731,'1117535344','2022-01-04','05:00:18','C',2022,3879711.00,'  CONSTITUCION DE CUENTAS POR PAGAR DEL AÑO 2021 - CANCELAMOS LIQUIDACION A UN EX FUNCIONARIO DE EMSERPUCAR ESP SEGUN RESOLUCION ADMINISTRATIVA N 365-2021',2,4),(220004,41250731,'1117535344','2022-01-04','05:05:04','C',2022,2248893.00,'    CONSTITUCION DE CUENTAS POR PAGAR DEL AÑO 2021 - CANCELAMOS LIQUIDACION A UN EX FUNCIONARIO DE EMSERPUCAR ESP SEGUN RESOLUCION ADMINISTRATIVA N 368-2021',2,3),(220005,41250731,'1117535344','2022-01-04','05:09:13','C',2022,907751.00,' CUENTAS POR PAGAR 2021 - Cancelamos liquidación a empleado de EMSERPUCAR ESP prestaciones sociales vigencia 2021',3,6),(220006,41250731,'1117535344','2022-01-04','05:31:14','C',2022,7313804.00,'CUENTAS POR PAGAR 2021 - CANCELAMOS LIQUIDACION A UN EX FUNCIONARIO DE EMSERPUCAR ESP SEGUN RESOLUCION ADMINISTRATIVA N 364-2021\r\n',2,6),(220007,41250731,'1117535344','2022-01-04','05:37:10','C',156073971,156073970.78,' CUENTAS POR PAGAR - CONVENIO INTERADMINISTRATIVO No 156 REHABILITACION DEL SISTEMA DE CAPTACION DE AGUA CRUDA EN LA PTAP EL MIRADOR',2,1),(220008,41250731,'1117535344','2022-01-04','05:47:35','C',0,4134929.00,'CANCELAMOS LIQUIDACION A UN EX FUNCIONARIO DE EMSERPUCAR ESP SEGUN RESOLUCION ADMINISTRATIVA N 366-2021',2,1),(220009,41250731,'1117535344','2022-01-04','05:50:45','C',2022,2846991.00,' CUENTAS POR PAGAR 2021 - Cancelamos liquidacion a empleado de EMSERPUCAR ESP prestaciones sociales vigencia 2021 Maria Consuelo Ninco vargas',3,6),(220010,41250731,'1117535344','2022-01-04','05:58:30','C',2022,56479725.00,'CUENTAS POR PAGAR 2021 - CESANTIAS CONSOLIDADAS VIGENCIA 2021 SECCION ADMINISTRATIVA Y FINANCIERA',2,6),(220011,41250731,'1117535344','2022-01-04','06:09:20','C',0,6700301.00,'CONSTITUCION DE CUENTAS POR PAGAR DEL AÑO 2021 - INTERESES SOBRE CESANTIAS VIGENCIA 2021 SECCION COMERCIAL',2,6),(220012,41250731,'1117535344','2022-01-04','06:15:04','C',2022,16190168.00,'CONSTITUCION DE CUENTAS POR PAGAR DEL AÑO 2021 - Cancelamos factura FEV2503 - Suministro de materiales para repotenciacion de red electrica de baja tension y montaje de planta electrica de 200 kw en la bocatoma de la PTAP EL MIRADOR.',2,4),(220013,41250731,'1117535344','2022-01-04','06:16:38','C',2021,12900000.00,'CONSTITUCIÓN DE CUENTAS POR PAGAR DEL AÑO 2020 DEL SERVICIO DE ENERGÍA, ACUEDUCTO, ALCANTARILLADO Y ASEO DE LA EMPRESA MUNICIPAL DE SERVICIOS PÚBLICOS EMSERPUCAR ESP',2,4),(220014,41250731,'1117535344','2022-01-04','06:20:49','C',2021,48132792.68,'Cancelamos excedente de factura N.117 a GENERCOMERCIAL S.A.S E.S.P. por compra de energía en generador con EMSERPUCAR ESP VIGENCIAS ANTERIORES',2,4),(220015,41250731,'1117535344','2022-01-04','06:22:02','C',2021,12245858.00,'CONSTITUCION DE CUENTAS POR PAGAR 2021 - Cancelamos Factura FS 549 - Contrato de Prestación de servicios de Mantenimiento correctivo, reparación e instalación de equipos y accesorios a todo costo incluye (caja compactadora, motor) para el vehículo compactador de placas OZD432 para la sección operativa de recolección de residuos solidos de aseo de EMSERPUCAR ESP ',2,3),(220016,41250731,'1117535344','2022-01-04','06:24:39','C',2021,20846630.00,'CONSTITUCION CUENTAS POR PAGAR 2021 - CONVENIO INTERAMINISTRATIVO 156 REHABILITACION DEL SISTEMA DE CAPTACION DE AGUA CRUDA EN LA PTAP EL MIRADOR DE EMSERPUCAR ESP ',2,1);

--
-- Table structure for table `suspennom_liq`
--

CREATE TABLE `suspennom_liq` (
  `sp_periodo` int(7) NOT NULL DEFAULT '0',
  `sp_cedula` bigint(12) NOT NULL DEFAULT '0',
  `sp_falta` char(2) NOT NULL,
  `sp_fecini` date DEFAULT NULL,
  `sp_valor` int(9) DEFAULT NULL,
  `sp_fecreg` date DEFAULT NULL,
  `sp_usuari` char(12) NOT NULL,
  `sp_detalle` text,
  PRIMARY KEY (`sp_periodo`,`sp_cedula`,`sp_falta`),
  KEY `sp_cedula` (`sp_cedula`),
  KEY `sp_falta` (`sp_falta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `suspennom_liq`
--


--
-- Table structure for table `tarifas`
--

CREATE TABLE `tarifas` (
  `tar_codigo` int(11) NOT NULL DEFAULT '0',
  `tar_minima` int(11) NOT NULL,
  `tar_banderazo` int(11) NOT NULL,
  `tar_caidamts` int(11) NOT NULL,
  `tar_caidaseg` int(11) NOT NULL,
  `tar_recargo` int(11) NOT NULL,
  `tar_radio` int(11) NOT NULL,
  `tar_aeropuerto` int(11) NOT NULL,
  `tar_porhoras` int(11) NOT NULL,
  PRIMARY KEY (`tar_codigo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tarifas`
--


--
-- Table structure for table `temmovto`
--

CREATE TABLE `temmovto` (
  `tem_tipcom` int(3) NOT NULL,
  `tem_numero` int(9) NOT NULL,
  `tem_codcta` char(12) NOT NULL,
  `tem_tercer` bigint(12) NOT NULL DEFAULT '0',
  `tem_tipmov` int(1) NOT NULL DEFAULT '0',
  `tem_auxili` int(9) DEFAULT NULL,
  `tem_codtic` char(3) NOT NULL,
  `tem_detall` char(50) DEFAULT NULL,
  `tem_cheque` char(12) DEFAULT NULL,
  `tem_codcen` int(6) NOT NULL DEFAULT '0',
  `tem_vlrmov` double(15,2) DEFAULT NULL,
  `tem_fecreg` date DEFAULT NULL,
  `tem_codemp` char(8) DEFAULT NULL,
  PRIMARY KEY (`tem_tipcom`,`tem_numero`,`tem_codcta`,`tem_tercer`,`tem_tipmov`,`tem_codcen`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `temmovto`
--


--
-- Table structure for table `terceros`
--

CREATE TABLE `terceros` (
  `te_codcli` bigint(12) NOT NULL DEFAULT '0',
  `te_nombre` char(200) NOT NULL,
  `te_direcc` char(50) NOT NULL DEFAULT '',
  `te_telefo` char(12) NOT NULL DEFAULT '',
  `te_porcen` int(2) DEFAULT NULL,
  `te_nombr1` char(10) DEFAULT NULL,
  `te_nombr2` char(10) DEFAULT NULL,
  `te_apell1` char(20) DEFAULT NULL,
  `te_apell2` char(10) DEFAULT NULL,
  `te_codact` int(6) DEFAULT NULL,
  `te_codciu` int(3) DEFAULT NULL,
  `te_tipo` char(1) NOT NULL,
  `te_tipter` char(1) NOT NULL,
  `te_tipdoc` char(2) NOT NULL,
  `te_autore` char(1) NOT NULL,
  `te_gran` char(1) NOT NULL,
  `te_ent_publica` enum('S','N') NOT NULL,
  `te_regimen` varchar(1) NOT NULL,
  `te_estado` varchar(1) NOT NULL,
  `te_correo` varchar(70) NOT NULL,
  PRIMARY KEY (`te_codcli`),
  KEY `te_codact` (`te_codact`),
  KEY `te_codciu` (`te_codciu`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `terceros`
--

INSERT INTO `terceros` (`te_codcli`, `te_nombre`, `te_direcc`, `te_telefo`, `te_porcen`, `te_nombr1`, `te_nombr2`, `te_apell1`, `te_apell2`, `te_codact`, `te_codciu`, `te_tipo`, `te_tipter`, `te_tipdoc`, `te_autore`, `te_gran`, `te_ent_publica`, `te_regimen`, `te_estado`, `te_correo`) VALUES (1676391,'FLOREZ CABRERA LUIS HUMBERTO','CALLE 4 NRO 7-5 BARRIO COMUNERO DE CARTAGENA DEL L','0',0,'LUIS','HUMBERTO','FLOREZ','CABRERA',9609,86573,'','','CC','N','N','N','N','A','florezhumberto912@gmail,com'),(3107938,'BERNAL MAHECHA JOSE RAUL','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(4020044,'LIZCANO PANIAGUA FERNANDO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(4344762,'MACIAS OTALVARO HECTOR','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(4429639,'HOYOS MUÑOZ URIEL JESUS','CL 4 6 36','0',3,'URIEL','JESUS','HOYOS','MUÑOZ',9609,18150,'N','P','CC','N','N','N','N','A',''),(4430457,'MU?OZ SILVIO DE JESUS','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(4464570,'BEDOYA JULIO CESAR','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(4465332,'ALDEMAR SEPULVEDA RESTREPO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(4548517,'GA?AN HERNAN DE JESUS','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(4925301,'VARGAS MARIN ISMAEL','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(4968615,'SANCHEZ TRUJILLO LUIS EVELIO','VRD LA CHIPA CARTAGENA DEL CHAIRA','',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(6349025,'GARSES ELBECIO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(6442161,'ANDRADE CARLOS ALFONSO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(6460813,'CARDONA VILLAREAL DIEGO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(6481218,'HOYOS GOMEZ JULIO CESAR','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(6513060,'RIOS CARLOS ALBERTO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(6681729,'GARZON RIVEROS LUIS ANTONIO','CARRERA 1B ESTE No. 16-25 VISTA HERMOSA','4646407',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(6802008,'EL TORO BRAVO PUBLICIDAD','','',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(6802181,'PLAZAS VARGAS JHON GERARDO','CRA 14 N?11F-44 BARRIO LA BOCANA','3103367749',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(6803305,'CASAS CLAROS OLIBERIO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(6803414,'PALOMAREZ SUAREZ FABIO','CALL11 16D 19','4360947',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(7320256,'CARDONA GIRALDO MIGUEL ANTONIO','Barrio antioquia','3123323401',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(7544889,'OCASIONES LLANOS ALBERTO LUNA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(7628636,'RUIZ LUIS FRANCISCO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(7687157,'LOPEZ GONZALEZ JHON JAIRO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(7694699,'ARISTIZABAL CALDERON OSCAR FERNANDO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(7733882,'SOLANO GONZALEZ JUAN MIGUEL','CALLE 22 NO. 1C-36','3153058351',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(8675169,'PEREZ CUERVO ALBERTO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(8742332,'BARRETO FERNANDEZ LORENZO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(8762475,'BASTOS CARVAJAL EDUARDO','CL 29 D 1E 17 BRR CUNDUY','3108582509',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(9999999,'CLIENTES PUNTO POS','MANIZALES','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(10009128,'HOYOS AGUDELO HUGO ALEJANDRO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(10094328,'CASTA?O CARDONA CARLOS ALBERTO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(10133969,'GONZALEZ JOSE VICENTE','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(10176310,'LOPEZ GAVIRIA CARLOS ALBERTO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(10194324,'RODRIGUEZ MIRIAN DE JESUS','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(10593683,'PALADINES PABLO EMILIO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(10881302,'RODRIGUEZ PEREZ CESAR OMAR','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(11201180,'PRIETO AREVALO IGOR ALEXIS','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(11314528,'LANCHEROS VELASQUEZ URIEL','CR 9 15 61','0',0,'URIEL','','LANCHEROS','VELASQUEZ',9609,18150,'N','P','CC','N','N','N','N','A',''),(11379809,'GAMEZ ROZO BENIGNO','CALLE 6 NRO3 51 BARRIO COMUNERO DE CARTAGENA','0',0,'BENIGNO','','GAMEZ','ROZO',9609,25290,'','','CC','N','N','N','N','A','benigamez59@gmail,com'),(12107914,'NAVARRO OSPINA FRANK JAMES','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(12108861,'CUENCA GUTIERREZ HUMBERTO','BARRIO CAMILO TORRES CARTAGENA DEL CHAIRA CAQUETA','0',0,'HUMBERTO','','CUENCA','',9609,41001,'','','CC','N','N','N','N','A','hcuencas786@gmail,com'),(12114080,'ROJAS GONZALEZ ARNULFO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(12117966,'MORA LUIS ANGEL','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(12119585,'CORDOBA ESPINOSA HECTOR MARIO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(12123056,'ROJAS ROJAS JORGE ARMANDO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(12124694,'GUTIERREZ GENTIL','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(12137281,'GUTIERREZ CASTA?EDA MILLER ARLED','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(12177966,'MORA LUIS ANGEL','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(12192159,'DIAZ DIAZ JAVIER','CARRERA 15A 4A-A4','3134091091',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(12197281,'GUTIERREZ CASTA?EDA MILLER ARLED','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(12199423,'RAMIREZ VALDERRAMA JAVIER','CRA 5 N? 9-64 BARRIO CANELOS','3108735497',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(12227862,'MONTENEGRO OSCAR','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(12231836,'GASCA POLANIA JAVIER','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(12236696,'CHAVARRO TEJADA ORLANDO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(12264225,'SIERRA VARGAS JUAN PABLO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(14237276,'BARRIOS DIAZ JAIRO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(14259921,'SANCHEZ AREBALO JAIME','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(14638842,'AGUDELO GARCIA EDUAR MAURICIO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(14887557,'IBA?ES CHACON SANTOS MANUEL','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(15669328,'MERLANO SUAREZ ARMANDO AGUSTO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(16076032,'ZAPATA GARCIA JULIAN FELIPE','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(16186270,'SANTAMARIA OSPINA JUAN CARLOS','CALLE 9 N?9-39 BARRIO CAMILO TORRESCARTAGENA DEL F','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(16187894,'DIAZ VALENCIA JAMES','CALLE 1 NRO 2 - 26 BARRIO EL CENTRO DE CARTAGENA D','0',0,'JAMES','','DIAZ','VALENCIA',9609,18001,'N','E','CC','N','N','N','N','A','jd9954850@gmail,com'),(16188168,'OVIEDO NAVARES CESAR AUGUSTO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(16189128,'GUTIERREZ ZAMBRANO EDILMER','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(16189820,'DIEGO MAURICIO ORTIZ GARCIA','CALLE 26 No. 4-16 B/ HERNANDO TURBAY','4344416',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(16227436,'TORRES PALACIOS WILMAR','CALLE2 N?20-03 BARRIO CIUDADELA DE CARTAGENA DELC','0',0,'WILMAR','','TORRES','PALACIO',9609,76147,'','','CC','N','N','N','N','A','recursosh@emserpucar-esp,gov,co'),(16227496,'WILMAR TORRES PALACIOS','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17547014,'LOPEZ LUIS CARLOS','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17620331,'ANGEL MAHECHA RAFAEL MANUEL','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17622321,'ALVARO VARGAS CARVAJAL','BARRIO PRIMAVERA','3203543015',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17626762,'ESCALANTE QUINTERO HELIODORO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17628011,'VARGAS TIMOTE ELVER','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17628762,'LOPEZ GALDEZ NORBERTO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17630160,'CHACON LOSADA LUIS ALBERTO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17631942,'RAMIREZ VARGAS JAIME','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17632331,'CARVAJAL RAMOS HECTOR JULIO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17632409,'ORDO?EZ OSPINA TELMO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17632757,'OLARTE PIMENTEL JAIRO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17634946,'FRANCISCO JAVIER ENCISO CARDONA','CRA 3 NRO 4 -53 BARRIO CENTRO DE CARTAGENA DELCHA','0',0,'FRANCISCO','JAVIER','ENCIZO','CARDONA',9609,18001,'','','CC','N','N','N','N','A','fjavierenciso62@gmail,com'),(17636455,'ARIAS COLLAZOS BERNARDO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17636596,'NARVAEZ LOZADA FELIX MARIA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17637628,'AMADOR MOSQUERA AIMER','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17637763,'GARCIA CALDERON HUMBERTO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17637953,'MURCIA ARANZALEZ ABRAHAM','CL 17 9 17 BRR CENTRO','0',0,'','','','',9609,18001,'J','P','CC','N','N','N','N','A',''),(17639667,'GALLEGO BUSTAMANTE JORGE IVAN','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17640213,'QUINTERO ZAPATA LIBARDO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17641597,'VINASCO JORGE','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17642265,'OSORIO PENNA JOSE JADER / DOTACIONES ASVAR','CL 20 10 03 BRR LA CONSOLATA','4342588',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17643426,'RAMIREZ BAHAMON LUIS ALFONSO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17647026,'PAJOY MEDINA VIRGILIO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17647042,'HERNANDEZ CUELLAR JHON JAIRO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17648293,'NARVAEZ LOSADA JHON FREDY','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17649474,'HURTADO RODOLFO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17650987,'EMERSON CASTA?EDA SALAZAR','CALLE 8 No. 9-26 BARRIO LA ESTRELLA','3102474506',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17651677,'CARVALLO PALADINEZ ISRAEL','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17652070,'RODRIGUEZ ARIAS VLADIMIR','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17652184,'HERSON ALEXANDER ORTIZ DIAZ','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17652205,'MASABEL OCAMPO FERNANDO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17652212,'ROMERO NELSON AUGUSTO','CRA 2 NRO 3A 24 BARRIO EL CENTRO DE CARTAGENA DEL','0',0,'NELSON','AUGUSTO','ROMERO','',9609,18001,'','','CC','N','N','N','N','A','romeronelsonaugusto@gmail,com'),(17653656,'JAVIER HERNANDO GUZMAN RODRIGUEZ','CALLE 20 No.13-32','3107859036',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17655077,'POLANIA RAMIREZ CESAR AUGUSTO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17655109,'ORTIZ POLANIA ROBINSON','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17655507,'HURTADO GIRALDO LIBARDO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17656065,'MALAGON EDWIN GUSTAVO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17656506,'CASTANO VELANDIA RICARDO','CL 5 CR 7 BRR ANTIOQUIA','0',0,'RICARDO','','CASTAÑO','VELANDIA',9609,18150,'N','P','CC','N','N','N','N','A',''),(17657537,'SEFAIR CALDERON JUAN CARLOS','CARTAGENA DE CHAIRA','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17658074,'CHAVARRO HIDALGO NORVEY','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17658512,'RUIZ SALAS JHON WILSON','CL PRINCIPAL CARTAGENA CARTAGENA DEL CHAIRA','3102408275',0,'JHON','WILSON','RUIZ','SALAS',9609,18150,'N','P','CC','N','N','N','N','A',''),(17658624,'RIOS FLOREZ JHON FREDDY','CALLE 1EBIS 7 - 69 BARRIO TOVAR ZAMBRANO FLORENCIA','',0,'','','','',9609,18001,'','','CC','N','N','N','N','A',''),(17658626,'VARGAS GUTIERREZ LORENZO ANDRES','CR 1 N?26B -14 IN BALCONES DEL CUNDUY','3138795886',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17658892,'VARGAS BARRERO JAROL','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17659119,'TRUJILLO CUBILLOS FERNANDO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17659820,'SEPULVEDA URBANO JOSUE','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17667423,'LOPEZ CHAVARRO REINERIO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17669648,'CALDERON PERDOMO LIBARDO','CL 33C 8 20 BARRIO LA PAZ EL DONCELLO','4372927',0,'','','','',9609,18247,'','','CC','N','N','N','N','A',''),(17669962,'MARTINEZ ARMANDO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17673806,'GUTIERREZ IQUIRA JAMES','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17682071,'SALINAS JOSE EUFRACIO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17688349,'CABRERA CHARRY ANDERSON','CRA 6 N?1-15 BARRIO PRIMAVERA CARTAGENA DELCHAIR C','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17688777,'BOCANEGRA TORRES WILLINTONG','CR 2 2-25 BARRIO CENTRO','3112225334',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17689079,'MOLINA MURCIA GERMAN ARTURO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17690644,'OSPINA VARGAS CARLOS ANDRES','CR 1 CL 1 VIA PUERTO MADERA','3134405702',4,'CARLOS','ANDRES','OSPINA','VARGAS',9609,18150,'N','P','CC','N','N','N','N','A',''),(17690729,'NARANJO GOMEZ JORGR ELIECER','CR 3 ESTE 15 21 BRR VENTILADOR','3214644230',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17691013,'RODRIGUEZ VALENCIA ROGER ALEXI','CL 70 18 C 06 BRR VISTA HERMOSA SUR','3112979062',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17691201,'CHRISTIAN CAMILO LUGO MENESES - ELECTRO CABLES MYC','CALLE 4 14 A 37 Barrio 7 de agosto','4353387',0,'CHRISTIAN','CAMILO','LUGO','MENESES',9609,18150,'N','P','CC','N','N','N','N','A',''),(17701685,'ROA CAMARGO FARIT','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17708665,'CABRERA HECTOR','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17708708,'MU?OZ CALDERON EDIN','CARTAGENA DEL CHAIRA','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17708734,'NARVAEZ JHONY','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17708871,'ASCENCIO JOSE JAMIR','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17709143,'JARA ROBAYO ESAU','CALLE 3B N?15-30 BARRIO PRIMERO DE AGOSTO DE CART','0',0,'ESAUC','','JARA','ROBAYO',9609,18150,'','','CC','N','N','N','N','A','recursosh@emserpucar-esp,gov,co'),(17709220,'PINEDA MARIN GUSTAVO ADOLFO','CR 4 9 61 BRR COMUNEROS CARTAGENA DEL CHAIRA','3118307696',0,'GUSTAVO','ADOLFO','PINEDA','MARIN',9609,18150,'N','E','CC','N','N','N','N','A',''),(17709400,'MUÑOZ CEBALLOS NELSON DE JESUS','CRA7 CALLE 9 -101 BARRIO CAMILO TORRES DE CARTAGEN','0',0,'NELSON','DE JESUS','MUÑOZ','CEBALLOS',9609,18150,'N','E','CC','N','N','N','N','A','nelsonceballos1964@gmail,com'),(17709602,'MUÑOZ GALEANO JORGE HUMBERTO','CALLE 10 NRO4 14 BARRIO QUINCE DE JUNIO DE CARTAGE','0',0,'JORGE','HUMBERTO','MUÑOZ','GALEANO',9609,18150,'N','','CC','N','N','N','N','A','recursosh@emserpucar-esp,gov,co'),(17709633,'ESCOBAR RUBIO FABIO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17709813,'VARGAS ESGUERRA DIOMEDES','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17710062,'ORTIZ SANCHEZ JOHN JAIRO','CALLE 10 CRA 11 BARRIO ANTIOQUIA DE CARTAGENA DEL','0',0,'JOHN','JAIRO','ORTIZ','SANCHEZ',9609,18150,'','','CC','N','N','N','N','A','johnortizcart75@gmail,com'),(17710093,'TOVAR BERGAÑO CARLOS ALBERTO','CL 9  11A 09 VILLAS DELCHAIRA CARTAGENA DELCH','0',0,'CARLOS','ALBERTO','TOVAR','VERGAÑO',9609,18150,'','','CC','N','N','N','N','A','caltober123@gmail,com'),(17710135,'OLAYA JIMENEZ ALEXANDER - TODOMOTOS DEL CHAIRA','CR 7 4 48 BRR ANTIOQUIA','0',0,'ALEXANDER','','OLAYA','JIMENEZ',9609,18150,'N','P','CC','N','N','N','N','A',''),(17710322,'QUINTANA ANDRADE ABDENAGO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17710613,'VELASQUEZ DANIEL','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17710656,'GARCIA RAMIREZ JHONNIER','CL 5A 7 76 BRR ANTIOQUIA','3123101197',1,'JHONNIER','','GARCIA','RAMIREZ',9609,18150,'N','P','CC','N','N','N','N','A','jhonniergarcia652@gmail,com'),(17711101,'CANO CUELLAR SISNEL ANTONIO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17711151,'GRISALES RUBEN DARIO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17788004,'ESPA?A RAMIREZ ERASMO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(18394332,'HURTADO GUILLERMO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(18467702,'ALEGRIA ROCERO EDUIN','CRA 4 CALE 5 -38 BARRIO ANTIOQUIA CARTAGENA DELCHA','0',0,'EDUIN','','ALEGRIA','ROSERO',9609,63594,'N','E','CC','N','N','N','N','A','adrianaparrapolania,@gmail,com'),(18469089,'RESTREPO AGUDELO CARLOS ANDRES','CR 9 9 09 15 BRR ANTIOQUIA CARTAGENA DEL CHAIRA','',0,'CARLOS','ANDRES','RESTREPO','AGUDELO',9609,18150,'N','P','CC','N','N','N','N','A',''),(18509673,'PINEDA QUINTERO RUBIEL','CARRERA 11 N? 9-04','4357324',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(18609664,'MONTOYA TAMAYO LEONARDO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(19283028,'VALENCIA RAMON ALVARO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(24340777,'MARTINEZ VARGAS ROSALBINA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(26428020,'MOLANO RIVEROS LUZ ELENA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(26631955,'VERJAN BURBANO MARIA / DISTRIBUIDORA J.L.A','CL 34 A 1H 56 BRR SINAI II ETAPA','3115592660',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(26634415,'BOLAÑOS NARVAEZ YANIT ROCIO','CL 2 CR  3 10 BRR RODRIGO TURBAY','3116060386',9,'YANIT','ROCIO','BOLAÑOS','NARVAEZ',6920,18150,'N','P','CC','N','N','N','N','A','YRBJUANESHOTMAIL.COM'),(26643846,'MESA MENDIETA MARIA INES','VEREDA LAURELES FINCA LAS ILUSIONES','3168127691',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(26648942,'GOMEZ GRAJALES GLORIA CONSUELO','SAN VICENTE DEL CAGUAN','',0,'','','','',9609,18753,'','','CC','N','N','N','N','A',''),(30508522,'FAJARDO OVIEDO LUZ MILA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(30517673,'LASSO GONZALEZ GINET','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(36289835,'CUELLAR VALDERRAMA CLAUDIA JIMENA','CR BIS 5 A 06 BRR LAS AVENIDAS PITALITO','4355669',5,'CLAUDIA','JIMENA','CUELLAR','VALDERRAMA',4530,41551,'N','P','CC','N','N','N','N','A','CLAUDIAJIMENAC300@HOTMAIL.COM'),(40076026,'SANDRA MYLENA FLOREZ UCLUE','BARRIO EL CENTRO','3144858393',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40078863,'RAMIREZ MARIA RUTH','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40086071,'VALDERRAMA MARTHA CECILIA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40086863,'CASTRO CORREA MARISOL','CR 6 3 52 BRR EL CENTRO CARTAGENA DEL CHAIRA','',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40447254,'VALENCIA JARAMILLO ANA MERCEDES','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40611555,'FRANCY HELENA SANCHEZ CAVIEDES','','3125235404',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40611575,'GARCIA CEDE?O ADELA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40613743,'NOVOA COTACIO ADRIANA','CARTAGENA DE CHAIRA','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40614277,'MILLERLAN PUENTES MONTILLA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40614846,'MU?OZ FARFAN MU?OZ FARFAN \"MERKAPLASTICOS\"','LC 108 ED COREVISA CENTRO CL 13 11 48','4346886',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40625377,'BOLIVAR MARTHA PIEDAD','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40625532,'NINCO VARGAS MARIA CONSUELO','CARTAGENA DEL CHAIRA','',0,'MARIA','CONSUELO','NINCO','VARGAS',9609,18150,'','','CC','N','N','N','N','A','consueloninco26@hotmail,es'),(40625847,'SUAREZ BLANCA CECILIA','CL 4 4 59 BRR CENTRO','3118096327',1,'BLANCA','CECILIA','SUAREZ','',4752,18150,'N','P','CC','N','N','N','S','A','FERRETODOCARTAGENA1986@HOTMAIL.COM'),(40625884,'ARIAS TABARES MARIA NILSA - CONSTRUTODO DEL CHAIRA','CALLE 4 NO. 6-44 CENTRO CARTAGENA DEL CHAIRA','3107885172',0,'MARIA','NILSA','ARIAS','TABARES',9609,18150,'','P','CC','N','N','N','N','A',''),(40625899,'ZUNCE LUCERO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40626007,'FAJARDO YOLANDA','CRA 3N?4-53 BARRIO EL CENTRO DE CARTAGENA DEL CHA','0',0,'YOLANDA','','FAJARDO','',9609,18150,'','','CC','N','N','N','N','A','yoly19722009@hotmail,com'),(40626099,'ECHEVERRY CENELIA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40626164,'BARRERO ORFILIA','CALLE 3 NRO3- 49 BARRIO EL CENTRO CARTAGENA DL CH','0',0,'ORFILIA','','BARRERO','',9609,18150,'','','CC','N','N','N','N','A','barreroorfilia@gmail,com'),(40626607,'RODRIGUEZ NIVIA YOLANDA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40626652,'CASTAÑEDA IQUINA LUZ MERY','CL 9 9 39 BARRIO CAMILO TORRES CARTAGENA DEL CHAIR','3123133737',0,'LUZ','MERY','CASTAÑEDA','IQUINA',9609,18150,'','','CC','N','N','N','N','A',''),(40626885,'MARTINEZ MARGOTH','CALLE 3 N?4-22 BARRIO EL CENTRO CARTAGENA DELCHAI','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40627729,'MONTA?O KERLY LORENA','CARRERA 9 N. 5-46 B/ANTIOQUIA CARTAGENA DEL CHAIRA','3104761232',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40670418,'MANCHOLA LILIANA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40670772,'VALDERRAMA CEDIEL EVELYN LIZETHE','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40676925,'TRUJILLO MARIA ELENA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40755574,'MONSALVE CASTA?O FLOR MARIA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40757966,'SANCHEZ PERDOMO BELEN','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40762251,'CASTRO URQUINA NELSA MARIA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40765793,'POLANCA MARIA DEL SOCORRO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40766088,'GOMEZ MONTES LUZ MARINA','CL 17 10 06 BRR CENTRO','4353387',0,'LUZ','MARINA','GOMEZ','MONTES',4663,18001,'N','P','CC','N','N','N','N','A','LUZMARINAGOMEZMONTES@GMAIL.COM'),(40768435,'RAMIREZ DANNY','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40770297,'BARRERO CONDE GLEIDEN','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40771653,'HURTATIZ HURLAY','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40775742,'ZU?IGA LIZCANO NURY','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40778680,'CASTRILLON HERNANDEZ MERCEDES','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40778807,'MU?OZ PALECHOR CRISTINA (DISTRIBUCIONES M & C)','CRR 10 18 21BARRIO CENTRO','3203005334',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40780871,'BARRETO MORA LUZ MARY','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40781522,'CEDIEL RUIZ NORMA XIOMARA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40781989,'ROSANA BUITRAGO GRAJALES','CRA 7 N?8-26 BARRIO CAMILO TORRES CARTAGENA DEL C','0',0,'','','','',9609,18001,'','','CC','N','N','N','N','A',''),(40784370,'ORTIZ BARRERA CLARA ISABEL','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40784395,'BENAVIDES MAVESOY EYDA AMELIA','CRA 12 A N? 19-57','3138149377',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40784747,'AVENDA?O LUZ ANGELA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40887307,'GUERRERO IVONNE','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(41250731,'PEREZ JIMENEZ DEGNIS YILENA','BARRIO DIVINO NI?O CARTAGENA DELCHAIRA CAQUETA LA','3108715677',0,'DEGNIS','YILENA','PEREZ','JIMENEZ',9609,99524,'','','CC','N','N','N','N','A','degnisyilenaperez@gmail,com'),(41896789,'VALBUENA ZABALA MARIBEL','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(41923356,'SERRANO MENDOZA MARTHA ROCIO','BARRIO CENTRO','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(45502555,'ANAYA GONZALEZ CARMEN SOFIA','CALLE 25 7B 24 BARRIO VILLA NUEVA CARTAGENA','3008760300',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(48572976,'VELASCO OSORIO BENILDA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(52430291,'PAPELERIA MEDELLIN','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(52804507,'MACIAS GARZON PAOLA ANDREA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(55152751,'FLOREZ OSSA ROSE MARY','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(55159352,'LOPEZ GONSALEZ AUZARIS','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(55166712,'PIRAGAUTA GUZMAN MARIA IVONNE','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(55173318,'VELASQUEZ SABOGAL LUZ ENITH','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(63492910,'DURAN MARITZA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(65759455,'FERNANDEZ OLGA LUCIA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(66873421,'MAYORGA BETANCURT ADRIANA','CALLE 4 CRA 16 ESQ BARRIO 1 DE AGOSTO DE CARTAGENA','0',0,'ADRIANA','','MAYORGA','BETANCOURT',9609,76622,'','','CC','N','N','N','N','A','adriana-11mabe@hotmail,com'),(71576321,'JUAN PASTOR OCHOA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(74242089,'TORRES BELTRAN YOYLAN','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(75038275,'MARIN LOAIZA JUAN ALBERTO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(78748875,'HERRERA ARGEL DAMARIO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(79128500,'GONZALEZ SIDNEY','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(79201571,'CAMPOS CRUZ RAFAEL','BARRIO ANTIOQUIA CARTAGENA DELCHAIRA SOACHA','0',0,'RAFAEL','','CAMPOS','CRUZ',9609,25754,'','','CC','N','N','N','N','A','rafitacc79@gmail,com'),(79489023,'GONZALES CABRERA NELSON','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(79600259,'CAMACHO CAVIEDES JORGE RENE','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(80176320,'CAMPOS CLAROS JAMIT JULIAN','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(83087976,'RODRIGUEZ ANDRES','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(83090184,'TAMBIMBA LUIS CARLOS','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(83211694,'SILVA COLLAZOS HENRY','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(85154481,'MARTINEZ JIMENEZ HAIDER SAMIR','CR 7 852 BRR LA ESTRELLA SANTA MARTA','3133447358',0,'HAIDER','SAMIR','MARTINEZ','JIMENEZ',9609,47001,'N','E','CC','N','N','N','N','A',''),(91210294,'MERCHAN SUAREZ HILMON','','0',0,'','','','',9609,18150,'N','P','CC','N','N','N','N','A',''),(91275728,'EDWIN ANCIZAR PEREZ RUEDA','CRA 32A 2E-96 CASA 27 ALAMOS','3112297771',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(91430776,'ENNIS OTERO JAMES','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(93120622,'RAMIREZ QUI?ONEZ LUIS ALFONSO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(93236486,'CARDOZO PADILLA EDWARD HERNANDO ISASOFT STUDIO','CL 83 ENTRE CR 2 Y 3 TO B AO 501 CON MIRAFLORES','2780627',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(93341366,'RODRIGUEZ PENA ALEXANDER','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(94294148,'VARGAS FLOREZ GUSTAVO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(94392704,'CASTA?O VELANDIA LUIS HERNANDO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(96329707,'JOSE DAVID GARZON RIVEROS','CARRERA 22B No. 3-53 SUR YAPURA','3105774770',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(96331784,'YUCUMA GAVIRIA CARLOS','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(96332258,'MAYA PEREZ REINALDO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(96332313,'ORDOÑEZ ROJAS ARTURO','CRA 12 N? 3A -27 BARRIO VILLA ADRIANA DE CARTAGE E','0',0,'ARTURO','','ORDOÑEZ','ROJAS',9609,18256,'N','E','CC','N','N','N','N','A',''),(96333592,'OSORIO GAONA EFREN','CALLE 2 NRO 12A -03 BARRIO BELLA VISTA DE CARTAGEN','0',0,'EFREN','','OSORIO','GAONA',9609,18150,'','','CC','N','N','N','N','A','efrenosorio143@gmail,con'),(96350743,'PE?A EFREN','BRR CIUDADELA','',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(96352639,'CALDERON WILLIAN','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(96352643,'CALDERON PERDOMO RIGOBERTO','CALLE 11# 103 BUENOS AIRES','4328121',0,'RIGOBERTO','','CALDERON','PERDOMO',9609,18150,'N','','CC','N','N','N','N','A',''),(96353434,'MORALES JOSE JAVIER','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(96353517,'JIMENEZ MORALES EDIXON','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(96353827,'EUDOR GONZALEZ WILSON','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(96354337,'ARANGO MAURICIO','DG IGLESIA BRR CIUDADELA','3192031889',5,'MAURICIO','','ARANGO','',2511,18150,'N','P','CC','N','N','N','N','A','ARANGOMAURICIO1977@GMAIL.COM'),(96354688,'RAMOS DIAZ NAVAR','CLL 6 NO. 4-68 BARRIO CENTRO CARTAGENA DEL CHAIRA','3118110536',0,'NAVAR','','DIAZ','RAMOS',9609,18150,'N','P','CC','N','N','N','N','A',''),(96361170,'VANEGAS RAMIREZ ERNESTO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(98639914,'WALTER CUELLAR ATEHORTUA','DG 65 B 41 50 AP 201','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(800031876,'FERRETERIA JARAMILLO','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(800052640,'ENERGIA DEL QUINDIO SA ESP','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(800078640,'QUIMICA INTEGRADA SA','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(800091594,'GOBERNACION DEL CAQUETA','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(800142383,'ENERTOLIMA FIDUBOGOTA SA','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(800169470,'EMPRESA DE SERVICIOS DE FLORENCIA S.A. E.S.P SERVAF','CR 12 6 24 BRR JUAN XXIII','038 4351690',7,'','','','',9609,18150,'J','P','NI','N','N','N','S','A','SERVAFSAESP@SERVAFSAESP.COM.CO'),(800189529,'HORIZONTE PENSIONES Y CESANTIAS','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(800213336,'ICBF REGIONAL CAQUETA','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(800220327,'EDITORIAL SURCOLOMBIANA S.A EL LIDER DIARIO CAQUETE?O','CALLE 11No. 13-20','4341212',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(800249860,'EMPRESA DE ENERGIA DEL PACIFICO SA ESP','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(800250984,'SUPERINTENDENCIA DE SERVICIOS PUBLICOS DOMICILIARIOS','CR 18 84 35','0',0,'','','','',9609,11001,'J','N','NI','N','N','N','N','A',''),(800255496,'YAMAHA MOTOS LTDA','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(815000896,'DISTRIBUIDORA Y COMERCIALIZADORA DE ENERGIA ELECTRICA S.A ESP','CRA 69 25B-44 OF 615','4926974',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(816002019,'EMPRESA DE ENERGIA DE PEREIRA','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(818001629,'DISTRIBUIDORA DEL PACIFICO S.A.E.S.P','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(828000812,'COMITE DE SERVICIOS PUBLICOS DE REMOLINOS DEL CAGUAN','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(828001058,'CON ELECTRICAS LTDA','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(828001731,'COMITE DE SERVICIOS DOMICILIARIOS PUERTO CAMELIAS','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(828001982,'MAXILLANTAS LIMITADA (MARIA DEL PILAR AVILA LEAL)','CR 10 16 66 B/ CENTRO','4354954',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(828002095,'COMITE DE SERVICIOS PUBLICOS DOMICILIARIOS DE MONSERRATE BAJO CAGUAN','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(828002342,'COMITE DE SERVICIOS PUBLICOS DOMICILIARIOS DE LA INSPECCION DE SAN JOS','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(828002709,'COMITE EMPRESARIAL DE SERVICIOS PUBLICOS DE CRISTALES DEL CAGUAN','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(828002714,'COMITE DE SERVICIOS PUBLICOS DOMICILIARIOS SANTA FE DEL CAGUAN','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(828002725,'COMITE DE SERVICIOS PUBLICOS DOMICILIARIOS DE SANTO DOMINGO','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(830000212,'COMISION DE REGULACION DE AGUA POTABLE Y SANEAMIENTO BASICO - CRA','','0',0,'','','','',9609,18150,'J','','NI','N','N','N','N','A',''),(830037248,'CODENSA S.A. E.S.P','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(830042687,'TECNIAGUAS INDUSTRIAL','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(830048145,'INFORMATICA Y GESTION S.A','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(830084433,'CERTICAMARA SA','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(830102500,'BIOSCIENCES LTDA','CR 19 58A 15','0',0,'','','','',9609,11001,'J','P','NI','N','N','N','N','A',''),(830114609,'FUNDACION TEMAS DE ESTADO','','5233133',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(830122566,'COLOMBIA TELECOMUNICACIONES','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(844004576,'EMPRESA DE ENERGIA DE CASANARE','','0',0,'','','','',9609,41797,'J','P','NI','N','N','N','N','A',''),(846000241,'EMPRESA DE ENERGIA DEL PUTUMAYO','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(846000553,'EMPRESA DE ENERGIA DEL BAJO PUTUMAYO','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(860002400,'LA PREVISORA','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(860007638,'EMPRESA DE ENERGIA DE CUNDINAMARCA SA ESP','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(860351432,'PRODUCEL INGENIEROS SAS','CALLE 123 47 55','6050101',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(860524654,'ASEGURADORA SOLIDARIA DE COLOMBIA','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(860534740,'COOPERATIVA AUDIOCOLOR','CL 16 9 37','',0,'','','','',9609,11001,'J','P','NI','N','N','N','N','A',''),(890201230,'ELECTRIFICADORA DE SANTANDER SA ESP','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(890500514,'CENTRALES ELECTRICAS DEL NORTE DE SANTANDER SA ESP','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(890800128,'CENTRAL HIDROELECTRICA DE CALDAS S.A.E.S.P','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(890904996,'EMPRESA PUBLICAS DE MEDELLIN ESP','CL  78B 69 240 TORRE A  PS 1','0313078333',0,'','','','',0,5001,'J','N','NI','N','N','N','N','A',''),(891180001,'ELECTROHUILA SA ESP','','0',0,'','','','',9609,41001,'','','NI','N','N','N','N','A',''),(891190047,'CAJA DE COMPENSACION FAMILIAR DEL CAQUETA','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(891190127,'ELECTRIFICADORA DEL CAQUETA S.A. E.S.P','','0',0,'','','','',9609,18001,'','','NI','N','N','N','N','A',''),(891190246,'CONTRALORIA DEPARTAMENTAL DEL CAQUETA','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(891200200,'CEDENAR CENTRALES ELECTRICAS DE NARIÑO','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(891500025,'CENTRALES ELECTRICAS DEL CAUCA','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(891800219,'EMPRESA DE ENERGIA DE BOYACA','','0',0,'','','','',9609,15001,'','','NI','N','N','N','N','A',''),(892002210,'ELECTRIFICADORA DEL META S.A.E.S.P','','0',0,'','','','',9609,50001,'J','N','NI','N','N','N','N','A',''),(892099499,'EMPRESA DE ENERGIA DE ARAUCA ENELAR E.S.P','','0',0,'','','','',9609,81001,'','','NI','N','N','N','N','A',''),(900015791,'GRUPO ASOCIATIVO RECUPERADORES DE RESIDUOS SOLIDOS LA ESPERANZA','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900034534,'MEDIOS Y MARKETING DE COLOMBIA E.U','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900034993,'CREG COMISION DE ENERGIA Y GAS','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900042857,'XM COMPAÑIA EXPERTOS EN MERCADOS','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900064112,'IGD MEDIOS & COMUNICACIONES E.U','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900159701,'LEO PART E.U','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900169179,'GRUPO EDITORIAL EL PERIODICO SAS','CL 4847 160 BRR TOROBAJO','4310048',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900173397,'SERVIAGRO YAMAHA LTDA','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900177263,'INVERSIONES ARPES LTDA','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900244467,'COMPA?IA DE ELECTRICIDAD DEL CAUCA SA ESP','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900282370,'ENDECAR SA E.S.P','CLL 3 5 16 5 BARRIO CENTRO','3112643171',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900291204,'ACTUALIZACIONES Y CAPASITACIONES JURIDICO ADMINISTRATIVAS','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900295736,'F Y C CONSULTORES SAS','CR 46 22B 20 OF 602','3163861932',2,'','','','',8551,11001,'J','P','NI','N','N','N','S','A','CONTACTENOS@FYCCONSULTORES.COM'),(900296582,'TECNIELECTRICOS CAQUETA','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900312757,'FONDO DE BIENESTAR SOCIAL Y ESTIMULOS DE LA CONTRALORIA DEPARTAMENTALD','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900316662,'MASO CONSTRUCIONES LTDA','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900332071,'INTEGRASOFT S.A.S','CALLE 11# 5-78 OFICINA CENTRO','8742814',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900337383,'ATLANTA SEGUROS COMPA?IA LTDA','CL 17 65 BRR SIETE DE AGOSTO','4354724',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900355114,'ASOCIACION DE ESCOBITAS DE CARTAGENA DEL CHAIRA','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900366010,'COMPAÑIA ENERGETICA DE OCCIDENTE CEO SAS ESP','CR 7 1 N 28 ED NEGRET P 4 BRR CENTRO','8301000',0,'','','','',3513,19001,'J','N','NI','N','N','N','N','A','cia.energetica@ceoesp.com'),(900413406,'COMUNICACIONES INSTITUCIONALES DE COLOMBIA','','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900457954,'SEFAIR Y ROJAS ASOCIADOS','CARTAGENA DE CHAIRA','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900522503,'ARGMAN SOLUCIONES INTEGRALES S.A.S','CRA 433 55LC 01','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900527797,'FORTALEZA LEGAL S.A.S','CAR 13 13 50 BRR CENTRO','4353904',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900588504,'MULTISERVICIOS CAQUETA S.A.S','CR 12 # 4-45 BRR SANTA FE','3132880576',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900589902,'AQUACHEMINC S.A.S','CR 70 A 54 AP 302','3166921559',0,'','','','',9609,11001,'','','NI','N','N','N','N','A',''),(900610775,'CV&S CONSTRUCTORES S.A S','CRA 13 CALLE 13 ESQUINA PISO 3','4346120',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900706506,'EMTEK SAS','CLL152 72 35 OF 1 501','3051967',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900720531,'CONSTRUAMBIENTAL SOLUTIONS S.A.S','DG 15 2E 26 BRR ABBAS TURBAY','3114529073',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900884892,'LIBRE Y DIGITAL COLOMBIA TELECOMUNICACIONES S.A.S','CRA 4 # 3-51 BRR CENTRO','3115131666',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(1003810911,'MORENO ROSERO ERICA TATIANA','CALLE 7A NO. 4A-09 NEIVA','3229390343',0,'','','','',9609,41001,'','','CC','N','N','N','N','A',''),(1004159150,'AUDOR CUELLAR DANILO','D 10 A 9 63 BRR EL GUAMAL FLORENCIA','3125059203',0,'','','','',9609,18001,'','','CC','N','N','N','N','A',''),(1006526334,'BOCANEGRA HERRERA VIVIANA','CALLE 6 6 13 BARRIO ANTIOQUIA','3115355366',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1007447779,'GONZALEZ QUINTERO VIVIANA','CALLE 4 # 1-20','3114772935',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1010165902,'VANEGAS BELTRAN DIANA LORENA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1019003637,'OROCAMENDEZ YESID MAURICIO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1019004069,'ZU?IGA SILVA CARLOS EDUARDO','CRA 13A NO. 3A-05 APTO 202','3118485812',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1032427890,'CASTILLO JORGE ANDRES','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1067524170,'RAMOS VARGAS LUIS JONATHAN','CRA 6 N? 5 - 19 BARRIO EL CENTRO DE CARTAGENA DEL','0',0,'','','','',9609,19821,'','','CC','N','N','N','N','A',''),(1075216860,'SOTO FORONDA EFRAIN','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1075219476,'ESTUPIÑAN ARISTIZABAL DANIEL','CRA 9 2 36 BR PRIMAVERA FLORENCIA','4318117',0,'DANIEL','','ESTUPIÑAN','ARISTIZABA',9609,18001,'N','P','CC','N','N','N','N','A',''),(1075226711,'YANGUAS PACHON MARCELO','NEIVA','1234',0,'MARCELO','','YANGUAS','PACHON',9609,41001,'','','CC','N','N','N','N','A','marceloyanguaspachon@hotmail,com'),(1075249739,'PASCUAS NATALIA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1075289482,'RAMIREZ CASANOV DIANA MILENA','CR 13 3A BRR URB VILLA ADRIANA CARTAGENA DEL CHAIR','3164342405',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1075303495,'SOTO SALINAS PAULA ALEJANDRA','CALLE 15 A N 33A 59 BARRIO LA ORQUIDEA NEIVA','3133078030',0,'','','','',9609,41001,'','','CC','N','N','N','N','A',''),(1077841414,'ARIAS DEICY LORENA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1077854219,'CLAROS PACHECO DIANA MILENA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1079408079,'PERDOMO ESCOBAR NELSON','CARRERA 10 NO 18-29 BARRIO CENTRO TESALIA','4355853',0,'NELSON','','PERDOMO','ESCOBAR',9609,41797,'N','P','CC','N','N','N','N','A','EPPCAQUETA@GMAIL.COM'),(1081156113,'VARGAS CALDERON MONICA ALEJANDRA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1081517022,'PALACIO CARDOZO JAYLLIBER','CL 4 25 31 BRR CENTRO','3132600362',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1088274099,'LERMA MENDEZ EDWIN JAVIER','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1098627459,'VELASQUEZ PEREZ HENRY','TRANVERSAL 5 B #7A-36','3115454181',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1109492696,'CASTAÑEDA IQUINA DEICY JAZMIN','CRA 8 N?9-79 BARRIO CAMILO TORRES CARTAGENA DEL C','0',0,'DEICY','JAZMIN','CASTAÑEDA','IQUINA',9609,73671,'','','CC','N','N','N','N','A','dejascasy_04@hotmail,com'),(1110449163,'QUIMBAYO MARULANDA ANGELICA LUCIA','CL 24 A 9 36 BRR LA ESPERANZA','2780627',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1114060476,'BETANCOURT CORT LEONARDO','CR 40 28 72 SAN PEDRO','3185160457',0,'','','','',9609,76670,'','','CC','N','N','N','N','A',''),(1115950121,'PENAGOS GAITAN RAUL ESNEIDER','CRA 7 NRO 5-34 BARRIO ANTIOQUIA DE CARTAGENA DEL C','4318230',0,'','','','',9609,18592,'','','CC','N','N','N','N','A',''),(1116205528,'LEAL GASCA IDELFONSO','CURILLO','',0,'','','','',9609,18205,'','','CC','N','N','N','N','A',''),(1116915723,'CUELLAR PARRA JARVEN FERNEY','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117485497,'ARGOTE PENAGOS LIDA ANDREA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117485529,'PEREZ NU?EZ FELIPE ANDRES','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117486836,'ECHEVERRY ARDILA ELSY','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117488024,'HENRY ALEXANDER PE?A','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117489407,'VARGAS LINA PAOLA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117491913,'VASQUEZ BURGOS FLORENTINO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117493603,'QUINTERO CAMPOS MARICELA','CALLE 10 N? 3B-30 B/ DIVINO NI?O. CARTAGENA DEL FL','0',0,'','','','',9609,18001,'','','CC','N','N','N','N','A',''),(1117496228,'MARTINEZ ROJAS ELIANA YULIET','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117497550,'ZABALA DIAZ JOSE MANUEL','CRA 4 NRO7-36 BARRIO COMUNERO DE CARTAGENA DELCH F','0',0,'JOSE','MANUEL','ZABALA','DIAZ',9609,18001,'N','E','CC','N','N','N','N','A','jomazadi@gmail,com'),(1117497941,'BENAVIDEZ TAMAYO ENNA PAOLA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117498341,'CUBILLOS CERQUERA OSCAR','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117498385,'FLOREZ VARGAS PABLO CESAR','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117501637,'GASCA ENDO LEIDY COSTANZA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117504954,'SALINAS JURADO JOSE ANDRES','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117505106,'PARDO VERU JAIRO ANTONIO','CL 2 10B 35 BARRIO BRISAS BAJAS','3144784002',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117508778,'POLANCO CEDIEL GENNY KATHERINE','CRA 7 N?4-36 BARRIO ANTIOQUIA CARTAGENA DELCHAIRA','0',0,'GENNY','KATHERINE','POLANCO','CEDIEL',9609,18001,'','','CC','N','N','N','N','A','katica_poce@hotmail,com'),(1117509634,'GARCIA SUAREZ JULIAN ESTEBAN','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117522611,'SANCHEZ GUTIERREZ DIANA JUDITH','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117522905,'MORALES PEREZ LEIDY JOHANA','CR 25 1 C 63 BRR LAS AMERICAS','3132146299',6,'LEIDY','JOHANA','MORALES','PEREZ',9200,18001,'N','P','CC','N','N','N','N','A','JOHANIT101601@HOTMAIL.COM'),(1117529994,'MARTINEZ VALENCIA JESSICA PAOLA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117535344,'RAMIREZ GALEANO MAYERLY','CRA 5 N?13-53 BARRIO15 DE JUNIO CARTAGENA DEL CHA','3135833864',0,'MAYERLY','','RAMIREZ','GALEANO',9609,18001,'','','CC','N','N','N','N','A','princessmaye_95@hotmail,com'),(1117543133,'BOLA?OS BERMUDEZ ANGEL DAVID','CARTAGENA DEL CHAIRA','',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117543211,'MARIN MARIN PEDRO','SC F MZ 1 CS 13 BRR NUEVA COLOMBIA','3209240510',0,'PEDRO','','MARIN','MARIN',9609,18001,'N','P','CC','N','N','N','N','A','pemarinmar@gmail,com'),(1117790098,'URUE?A CORDOBA PAOLA ANDREA','CLL 2 N? 9-34','3143493464',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117960283,'MENDOZA SANDRA LILIANA','CARRERA 9 CALLE 3 ESQUINA B ANTIOQUIA CARTAGENA DE','3118136926',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117964100,'GASCA CORREA MARTHA ADRIANA','CALLE 2 N? 6 -59 BARRIO PRIMAVERA CARTAGENA DEL C','3143693946',0,'MARTHA','ADRIANA','GASCA','CORREA',9609,18150,'N','P','CC','N','N','N','N','A','adriana30031@hotmail,com'),(1117964672,'MU?OZ PENAGOS EDYN ANDRES','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117966548,'VIVAS COLLAZOS JARLY','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117969419,'RAMIREZ REYES GERMAN EDUARDO','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117969422,'SUAREZ HERRERA CRISTIAN CAMILO','CL 1 15A 60 BRR CIUDADELA','0',0,'CRISTIAN','CAMILO','SUAREZ','HERRERA',9609,18150,'N','P','CC','N','N','N','N','A','KRISS29051992@GMAIL.COM'),(1117970634,'RAMIREZ GALEANO MIREYA','CLL 5 13 53 BRR 15 DE JUNIO','3112032306',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117972837,'SUAREZ MONTA?A JAIME','CL 7 1 38 BRR BUENOS AIRES','3118255933',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117973586,'GASCA ALVAREZ YULY TATIANA','CR 5 ESTE # 12A 3 BRR ALTOS DE LA PRADERA CARTAGEN','',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117974172,'EUDOR MONTOYA EDUARS ANDRES','CL 2 15 A 17 BRR VILLA CENTRO','3134034079',3,'EDUARS','ANDRES','EUDOR','MONTOYA',9609,18150,'N','P','CC','N','N','N','N','A',''),(1117975381,'MORENO MARIN KAROL DANIELA','CALLE 13 4 44','3208016623',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1118021926,'MORENO MARIN MAYERLY ALEJANDRA','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1175044121,'GALINDO JUAN CARLOS','','0',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1192720331,'REYES MORA CRISTIAN ANDRES','CL 7A A 09 BARR COMUNEROS','',0,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1006404091,'CALA BEGIA YORLAY','CRA 5 9-05 BARRIO LOS COMUNERO','3144373609',8,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1006526995,'RAFAEL ANTONIO BOCANEGRA LOZADA','CL 4 5 32 CARTAGENA DEL CHAIRA','',4,'RAFAEL','ANTONIO','BOCANEGRA','LOZADA',9609,18150,'','','NI','N','N','N','N','A','rbocanegralozada@gmail,com'),(1006957355,'DOMINIO EMPRESARIAL','CL 20 NRO 13 33 BARRIO CONSOLATA','3133764451',1,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(1007383949,'COLLAZOS HENAO LIDY ANDREA','CL 4 8 66 BRR ANTIOQUIA CARTAGENA DEL CHAIRA','',3,'LIDY','ANDREA','COLLAZOS','HENAO',9609,18150,'N','P','CC','N','N','N','N','A',''),(1007447850,'JHON JAIDER TRUJILLO POLANIA','CL 3 8 27 BRR PRIMAVERA CARTAGENA DEL CHAIRA','',1,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(1010145709,'RAMIREZ MARIN LILI JOHANA','CR 4 15 11 BRR PORVENIR','3108857498',3,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1020782401,'GALARZA CAMACHO DIEGO ARMANDO','CR 11 A C 57 BRR VILLA MADRIGAL','3202524895',9,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1026258569,'SILVA GALINDO LINA MARCELA','CL 29 19 31 AP 101 BRR ACOLSURE','3168731699',2,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1053784314,'MURILLO PIEDRAHITA ALEJANDRO','CR 29 39 BRR SAN JOAQUIN','0',5,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1054925497,'VILLADA OSPINA EDINSON ANDRES','CR 4 12 BRR DIVINO NI?O','3207306375',4,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1076624699,'BRICEÑO GUANA DIEGO ARMANDO','VEREDA JUAICACARRON SEC SALON COMUNAL','3107810581',3,'DIEGO','ARMANDO','BRICEÑO','GUANA',9609,18150,'','','CC','N','N','N','N','A',''),(1078246968,'GONZALEZ LOMELIN NELLY CAROLINA','CRA 11A 3A 46 BARRIO DIVINO NI?O','3217836615',5,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1088328270,'GRANADA GIRALDO VALENTINA','RUB BILLA DE CARMEN MZ CA 21 PUERTO CARREÑO','3118612632',2,'VALENTINA','','GRANADA','GIRALDO',9609,18150,'N','P','CC','N','N','N','N','A',''),(1110517176,'ESCOBAR MENDEZ IDALY','CL 7 5 34 BUENOS AIRES','0',8,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1110571758,'GONZALEZ LOZADA  LAURA ISABEL','CL 4 8 05 BRR ANTIOQUIA','3176464440',3,'LAURA','ISABEL','GONZALEZ','LOZADA',4752,18150,'N','P','CC','N','N','N','N','A','bodegaferreterajs@hotmail.com'),(1112778349,'MEJIA CASTRO JESUS ALBEIRO','CL 15 12 40 BRR CENTRO CARTAGENA DEL CHAIRA','3157236231',1,'JESUS','ALBEIRO','MEJIA','CASTRO',4771,18150,'N','P','CC','N','N','N','N','A','REMATESCHAIRA@GMAIL.COM'),(1116802155,'ANGIE KATHERINE','BRR CENTRO CARTAGENA DEL','',7,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(1117490977,'DUSSAN SEPULVEDA YAMILETH','CR3 / 09 BARRIO COMUNEROS','3212618686',7,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117491480,'ANACONA TOLEDO JONNY JAVIER','CLL 19 2B 53 BRR LOS ALPES','3244914695',3,'JONNY','JAVIER','ANACONA','TOLEDO',9511,18001,'N','P','CC','N','N','N','N','A','JN8688@HOTMAIL.COM'),(1117495872,'EVER DEINER','BARRIO CENTRO FLORENCIA','',5,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(1117504527,'JHON JAIRO','CRA 7 3 19 BRR ANTIOQUIA CARTAGENA DEL CHAIRA','',9,'','','','',9609,18150,'','','NI','N','N','N','N','A','gutierrezjhon@gmail.com'),(1117508654,'HURTADO ESCANDON LYDA XIMENA','','4363123',4,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117517991,'JUAN CARLOS','CALLE 15 #15-45 CC DUBAI PLAZA LOCAL 104 FLORENCIA','',1,'','','','',9609,18150,'','','NI','N','N','N','N','A','gamas@gmail.com'),(1117518899,'MORENO CRUZ LEIDY LORENA','MZ D CA 2 BRR HORIZONTE','3213085632',4,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117526317,'PARRA VILLADA GINA ANDREA','CR 4 14 48 BARRIO COMUNEROS','3164828361',3,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117533249,'BARRERO NAVARRO YINA MARCELA','CALLE 3 4 22 BRR CENTRO','3207705702',1,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117534618,'MATEUS RODRIGUEZ OSMAN EFREN','CL 4 9 24 CARTAGENA DEL CHAIRA','3102553354',9,'OSMAN','EFREN','MATEUS','RODRIGUEZ',9609,18150,'N','P','CC','N','N','N','N','A','tornilleriacartagena@hotmail.com'),(1117544262,'SUAREZ VILLADA MARIANA','CRR 5 1216 BRR RAICERO','3143959638',3,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117549819,'KAREN ADRIANA CALDERON ARIZA','CR 11 6 66 BRR CAMILO TORRES CARTAGENA DEL CHAIRA','',8,'KAREN','ADRIANA','CALDERON','ARIZA',9609,18150,'','','NI','N','N','N','N','A','calderonka3@gmail.com'),(1117967184,'ALVIS PEREZ DIANA MARCELA','CLL 5 #9-36 BARRIO ANTIOQUIA','3224179446',2,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117967547,'FORERO HERNANDEZ YESSICA FERNANDA','CALLE 4 13A BARRIO GAITAN CARTAGENA DEL CHAIRA','3224018039',2,'YESSICA','FERNANDA','FORERO','HERNANDEZ',9609,18150,'N','','CC','N','N','N','N','A',''),(1117967581,'ESTRADA AYALA SANDRA MILENA','CL 4 2 4 2 46 BARRR CENTRO','3204849827',3,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117967733,'MUÑOZ HOYOS EWEIMAR','CL 11 2 43 BRR BUENOS AIRES CARTAGENA DEL CHAIRA','3213168112',6,'EWEIMAR','','HOYOS','HOYOS',9609,18150,'N','P','CC','N','N','N','N','A',''),(1117974000,'RAMOS RODRIGUEZ CRISTIAN CAMILO','CR 4 3 36 BRR BUENOS AIRES','31660271753',5,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117974473,'CABRERA FAJARDO LUISA FERNANDA','CR 3 4 53 BRR CENTRO','3209272702',5,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(1117976172,'SANCHEZ ERAZO JOSE ALEJANDRO','BRR CIUDADELA','0',2,'JOSE','ALEJANDRO','SANCHEZ','ERAZO',9609,18150,'N','P','CC','N','N','N','N','A',''),(1119215830,'OSORIO MU?OZ LILIANA Y/O ELECTROSUR FLORENCIA','CL 13A 7 33 BRR VISTA HERMOSA','3108733545',3,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(11192805738,'MARIO','BILLA CENTRO CARTAGENA DEL CHAIRA','',8,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(1192894992,'MEJIA DUQUE YIRLEDY','CRA 4 4-15 BARRIO CENTRO','3115592506',5,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(12115995,'RODRIGUEZ IBA?EZ GUSTAVO','CR 6 # 2-56','8713621',1,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(12119287,'SALAZAR POLANIA HERNAN','CL B 2 E BARR ENTRE RIOS','4344220',3,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(12171472,'YEISON JAIR','CL 4 3 52 BRR CENTRO CARTAGENA DEL CHAIRA','',1,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(12201419,'CERQUERA SANTOFIMIO CARLOS EDUARDO','CL 9 50 LC 412','3214273550',9,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(12645895,'ROSADO GALINDO ESNEIDER ALBERTO','CL 56 1W 99 AP 503','30055512502',7,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(16187062,'GONZALEZ POLO OSIRIS','','0',8,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(16187262,'SANCHEZ FIGUEROA SERGIO ALEJANDRO / DVS PUBLICIDAD DIGITAL/','CRA 6 N? 17-37','321491107',4,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(16188267,'MAGON MUÑOZ LUIS ENRIQUE','CL 21 1E 46 BRR ACACIAS FLORENCIA','',5,'LUIS','ENRIQUE','MAGON','MUÑOZ',9609,18150,'N','P','CC','N','N','N','N','A','fumiplagas2017@gmail.com'),(16188365,'RIVERA OSORIO ROBINSON','CR 2 E 10 18 BARRIO PANORAMA','3123658946',9,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(16285207,'GUZMAN LEMOS CESAR JAVIER','CL 15 12 06 BRR LAS VILLAS','4371985',9,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17636807,'ALVAREZ RAMOS HENRY/ CACHARRERIA LAS 3H DEL CAQUETA','CR 13 13 72 BRR CENTRO','4354655',9,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17641396,'FABIO LOSADA/ COMERCIALIZADORA Y FERRETERIA FLORENCIA','TV 6 A 6 45','3115146185',3,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17642590,'JOSE ALBERTO','CL 13 7 49 BRR RAICERO FLORENCIA','',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(17646668,'WILLIAM','DG 10 E 17 16 BRR CIRCACA FLORENCIA','3142970547',4,'','','','',9609,18150,'','','NI','N','N','N','N','A','IMBANA@HOTMAIL.COM'),(17646723,'RIVERA FIGUEROA WILLIAM','SEC E 3 MZ 3 LT 13 BRR NUEVA COLOMBIA','3202392862',1,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17646850,'ROJAS VARGAS JORGE ALBERTO','CR 16 13 35 BRR CENTRO - LA VEGA','3133462928',9,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17647120,'LOZANO CRUZ RAUL','CL 24 10 36 BRR TORASO FLORENCIA','3115199215',5,'RAUL','','LOZANO','CRUZ',9609,18150,'N','P','CC','N','N','N','N','A','gladyscumbervargas@hotmailcom'),(17653920,'OCHOA GARCIA ROBINSON','CR 8 13 BRR LA ESTRELLA','3107873856',5,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17674099,'BENITEZ ROJAS EMIGDIO JACOB','CLL 6 # 8-21','3108576122',2,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17701719,'TORRES SANCHEZ JOSE LIBARDO','','0',3,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17709890,'VARGAS BARRERO FRANKOY','CR 7 5-42 BARRIO ANTIOQUIA','3507211870',5,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(17710205,'JORGE ELIECER MENDEZ MONTOYA','CL 4 # 8 - 36 BRR ANTIOQUIA CARTAGENA DEL CHAIRA','',1,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(17783534,'ACOSTA CANO JOSE RAMON','CL 4 8 32 33 35 37','3112117511',2,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(18125225,'CHAVES CADENA JAIRO LEON','CRA 10 16 34 BARRIO EL CENTRO','0',3,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(26632226,'MARINELA','CRA 8 3 03 BRR ANTIOQUIA CARTAGENA DEL CHAIRA','',4,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(30505446,'AGROINSUMOS CARTAGENA','CALLE 4 DIAGONAL 4A NO. 4-41-44 CARTAGENA DEL CHAI','3107994528',9,'','','','',9609,18150,'','','U','N','N','N','N','A',''),(31974934,'PROFAMILIAS CHAIRA','CALL 4 NO 7-35 CARTAGENA DEL CHAIRA','3168597526',6,'','','','',9609,18150,'','','NI','N','N','N','N','A','profamilia@hotmail.com'),(32208642,'ALONDRA DEL MAR','CALLE 6 NO. 4-34 BARRIO CENTROP CARTAGENA DEL CHAI','3206316899',1,'','','','',9609,18150,'','','NI','N','N','N','N','A','alondra@gmail.com'),(36292197,'CLAUDIA MIREYA','CALLE 4 CON CRA 5 CENTRO CARTAGENA DEL CHAIRA','3144841776',5,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(39626240,'ARIZA PENAGOS BETTY','CRA 11 6 66 B CAMILO TORRES','3168888960',0,'','','','',9609,18150,'N','P','CC','N','N','N','N','A','graficartchaira@gmail.com'),(40077672,'GARZON SANTOS YERLY PIEDAD','CL 29 A 29 40 BRR VILLA DEL PRADO','3118797550',6,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40612216,'NUÑEZ BARAHONA YENNY PAOLA','CALLE 27 NRO 12 -01 BARRIO ATALAYA FLORENCIA CAQ F','3153529215',6,'YENNY','PAOLA','NUÑEZ','BARAHONA',9609,18001,'','','CC','N','N','N','N','A',''),(40626020,'MARIA ANGELICA','CL 4 PRINCIPAL CARTAGENA DEL CHAIRA','',0,'','','','',9609,18150,'','','NI','N','N','N','N','A','NA'),(40627630,'MEDINA FIERRO NELSY','CARRERA 4 # 07A-15','3133680377',8,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40733065,'NEILA','CRA 6 # 4 - 59 CARTAGENA DEL CHAIRA','',1,'','','','',9609,18150,'','','NI','N','N','N','N','A','jaramillo.ana@gmail.com'),(40757195,'MORENO CASTRO JUDITH','CR 3B 15-75 BARRIO PORVENIR','4353936',2,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40775436,'VARGAS ZAPATA ASTRYD','CLL 11 9 06 BRR LA ESTRELLA','4357001',9,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(40778719,'LOZADA CABALLERO HILDA LILIANA','CR 3 A ESTE 12 76 BRR RINCON DE LA ESTRELLA II','3208035657',1,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(4960027,'TRUJILLO PERDOMO LUCAS','CL 1 CR1 PUERTO MADERA','3202153296',1,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(49672028,'GALAN CONTRERAS LEIDY','CL 10 10 04 BRR SAN BERNARDO','3186055844',7,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(52739647,'CARDOSO ARAGONEZ PAULA ANDREA','CL 7 9 25 BRR LAS DAMAS FLORENCIA','',7,'PAULA','ANDREA','CARDOZO','ARAGONEZ',9609,18150,'','','NI','N','N','N','N','A',''),(52972613,'CRUZ ORTEGA LUZ ALEXANDRA','','0',4,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(53040689,'VARGAS NELSY','CL 5 10 27','3142847127',8,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(6259345,'ALVAREZ ALVAREZ ALBERTO','CRA 7 NO. 6-45 CENTRO CARTAGENA DEL CHAIRA','3144270403',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(65764351,'ALMANZA FORERO FRANCY','CRA 6 N. 3-44 BARRIO CENTRO CARTAGENA DEL CHAIRA','3108413076',5,'FRANCY','','ALMANZA','FORERO',9609,18150,'J','P','CC','N','N','N','N','A','www.francyalmaza@gmail.com'),(700119444,'CAMPO FUEREZ LUIS ENRIQUE','CALLE 4 NO. 4-24 BARRIO CENTRO CARTAGENA DEL CHAIR','3168964789',9,'LUIS','ENRIQUE','CAMPO','FUEREZ',9609,18150,'N','P','CC','N','N','N','N','A','luisecampo@gmail.com'),(7177364,'TRUJILLO CASTRILLO LEONARDO','CL 4 2C 33  BRR VILLA MILEIDY','3188043890',1,'','','','',9609,18150,'N','P','CC','N','N','N','N','A',''),(78324797,'GONZALEZ MARMOLEJO MARIO ELIECER','CR 13 5B 30 BARRIO JUAN XXIII','3015159573',6,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(800037800,'BANCO AGRARIO DE COLOMBIA','Carrera 8 N? 15 -43 BOGOTA','091-3821400',8,'','','','',9609,11001,'','','NI','N','N','N','N','A','gercontabilidad@banagrario.gov.co'),(800071708,'CONSTRUCSUELOS SUMINISTROS LTDA','CRA 4 15 44','0',1,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(800095754,'MUNICIPIO DE CARTAGENA DEL CHAIRA','CR 4 2-77 BRR CENTRO','4318432',4,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(800140607,'POLICIA NACIONAL','CRA 3 N 3 80 CARTAGENA DEL CHAIRA','na',2,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(800149496,'COLFONDOS S.A. PENSIONES Y CESANTIAS NO USAR','AV. CDAD. DE QUITO #85 - 58 BOGOTA','7484888',2,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(800149923,'BANCO DE COMERCIO EXTERIOR DE COLOMBIA S.A','CL 28 13 A 15 P 40 BOGOTA','4863000',6,'','','','',9609,11001,'','','NI','N','N','N','N','A','JOSE.GARZON@BANCOLDEX'),(800153993,'COMCEL S.A','BOGOTA BOGOTA','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(800165866,'JUZGADO','CALLE 4 CARTAGENA DEL CHAIRA','4318230',1,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(800197268,'DIRECCION DE IMPUESTOS Y ADUANAS NACIONALES','BOGOTA BOGOTA','4341700',4,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(800224808,'PORVENIR','X BOGOTA','x',8,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(800231969,'SERVICIO NANCIONAL DE APRENDIZAJE SENA','BOGOTA BOGOTA','00000000',4,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(800251440,'ENTIDAD PROMOTORA DE SALUD SANITAS S.A.S','AVENIDA CARRERA 45 NO. 106 - 76 BOGOTA','3759000',6,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(800252844,'CORPORACION PARA EL DESARROLLO SOSTENIBLE DEL SUR DE LA AMAZONIA','FLORENCIA CAQUETA FLORENCIA','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(805009741,'NO USAR NO USAR','CARRERA 15 15 05 FLORENCIA','3132716374',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(80503123,'FIERRO FIGUEROA CHRISTIAN LEONARDO/ SYSTEM KLASSE-MODA USA IMPORTACIONES SK','CL 16 6 45 LC 4 BRR 7 DE AGOSTO','4357315',8,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(80772323,'CASTA?O PUENTES JOHN EDISON / NEXT LEVEL TECNOLOGY','CR 3 A 12 BIS 17 BRR PABLO SEXTO','3134673363',7,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(80881322,'HERLEY HERNAN','CL 1 5 38 BRR PRIMAVERA CARTAGENA DEL CHAIRA','',7,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(809011444,'ENERTOLIMA S.A ESP','CENTRO IBAGUE','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(811012739,'CENTRO NACIONAL PARA EL DESARROLLO DE LA ADMINISTRACION PUBLICA \"CEN','CRA 4 A N? 8 SUR 15 TORRE OVIEDO','3139097',8,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(815001046,'INGENIERIA ASESORIAS SUMINISTROS Y EVENTOS DEL VALLE','CL 15 7 81 GUADALAJARA DE BUGA','',1,'','','','',9499,76111,'J','P','NI','N','N','N','N','A','INGEASESORIASVALLE1@GMAIL.COM'),(817000248,'ASMET SALUD NO USAR TERCERO MAL','','',3,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(822004680,'EMPRESA DE ENERGIA ELECTRICA DEL DEPARTAMENTO DEL GUAVIARE S.A ESP','CLLAE 8 # 23-55 CENTRO SAN JOSE DEL GUAVIARE','0',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(828000191,'EMPRESA MUNICIPAL DE SERVICIOS PUBLICOS','CRA 4 N?5-32','4318230',1,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(828001682,'TEVECAGUAN LIMITADA','BRR CENTRO CARTAGENA DEL CHAIRA','',1,'','','','',9609,18150,'','','NI','N','N','N','N','A','MILE42010@HOTMAIL.COM'),(830031182,'BISMARK COLOMBIA S.A.S','CR 7 84A 29 OF 301 BOGOTA','7432828',6,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(830052998,'FIDEICOMISOS BBVA ASSET MANAGEMENT S.A','CR 9 72 21 PS 3','3123711',9,'','','','',9609,11001,'J','P','NI','N','N','N','N','A',''),(830068148,'CHAVEZ INGENIERIA E U','CR 64 96 04 BOGOTA','0312532274',5,'','','','',9609,18150,'J','P','NI','N','N','N','S','A','CHAVEZIE@YAHOO.COM'),(830097543,'DESAROLLO INGENIERIA MONTAJES Y CONSTRUCCIONES DIMCO SAS','CR 63 98 56 URB LOS ANDES','5333218',5,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(830105145,'MILENIO EDITORES IMPRESORES EU','CR 60 5A 09','5634781',2,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(830504013,'PLAY TECHNOLOGIES S.A.S','CR 83 C 17 52 CALI','4854805',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(860002503,'COMPA?IA DE SEGUROS BOLIVAR S.A','AVENIDA EL DORADO NRO 68B-31 PISO 10 BOGOTA','3410077',2,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(860003020,'BBVA BANCO GANADERO','','',1,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(860009578,'SEGUROS DEL ESTADO','BOGTA BOGOTA','111',6,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(860009759,'EDITORIAL EL GLOBO DIARIO LA REPUBLICA','CALI VALLE DEL CAUCA','6616657',2,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(860011153,'ARP POSITIVA','','',6,'','','','',9609,11001,'','','NI','N','N','N','N','A',''),(860034313,'DAVIVIENDA RED BANCAFE','','',7,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(860034921,'MEGABANCO','','',5,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(860037013,'MUNDIAL DE SEGUROS S.A.','BOGOTA D.C. BOGOTA','',6,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(860074186,'DISICO SA','CR 25 24A 47','7868198',9,'','','','',4659,11001,'J','P','NI','N','N','N','N','A','disico@disico.com.co'),(89000525,'MU?OZ CARDONA ALVARO JOSE','CL 4 9 40 BRR ANTIOQUIA','3106717002',9,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(890300279,'BANCO DE OCCIDENTE','CL 15 44 11 BRR CENTRO','',4,'','','','',9609,18001,'J','P','NI','N','N','N','N','A',''),(890399003,'EMPRESAS MUNICIPALES DE CALI ESP','CALI CALI','0',0,'','','','',9609,76001,'','','NI','N','N','N','N','A',''),(891190012,'CAMARA DE COMERCIO DE FLORENCIA CAQUETA','CL 17 8 72 BARRIO SIETE DE AGOSTO','4353939',5,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(891190346,'UNIVERSIDAD DE LA AMAZONIA','CL 17 DG 17 CR 3 F BRR PROVENIR','4358231',1,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(800141686,'BASE NAVAL N 3 ARC LEGUIZAMO','CR 1 CL 1  BASE NAVAL N 3 PUERTO LEGUIZAMO','5 6 3 4 3 4',9,'','','','',8422,86573,'J','C','NI','N','N','S','S','A','alvaro.polo@armada.mil.co'),(899999022,'MINISTERIO DE MINAS Y ENERGIA','CALLE 4 CUCUNUBA','4318230',1,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(899999239,'INSTITUTO DE BIENESTAR FAMILIAR (ICBF)','BOGOTA BOGOTA','00000000',2,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(899999284,'FONDO NACIONAL DEL AHORRO','BOGOTA','0',4,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900002345,'BOMBEROS VOLUNTARIOS DE CARTAGENA DEL CHAIRA','BARRIO CENTRO CARTAGENA DEL CHAIRA','3229048763',1,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900010878,'GRUPO METRO Y CIA LTDA.','Cl 82A # 37 A - 34','8740573',7,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900038276,'GRUPO EMPRESARIAL COLOMBIA E U','CL15 15 60 P 2 BRR CENTRO','4347847',5,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900084777,'SUPERGIROS SA','NA BOGOTA','NA',9,'','','','',9609,18150,'','','U','N','N','N','N','A',''),(900127670,'AQUATEKNICA LTDA','CL 34 26 42 BRR SANTA CLARA','31173547573',6,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900154912,'GALAXO & CIA LTDA','CR 96A 25 G 21','3002068290',8,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900156264,'NUEVA EPS','CRA 85K 46 A 66 BOGOTA','',2,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900220147,'MUNICPIO DE TUCHIN','CLL 12 # 7A - 171','7799103',2,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900266807,'AGREMIACION DE PROFESIONALES DE LA SALUD OCUPACIONAL DEL HUILA','CRA 4 10 SEGUNDO PISO','3144079912',3,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900280691,'AGUAS Y ACUEDUCTOS LA SIERRA S.A.S','CR 10 N?6-81 SOACHA','',4,'','','','',9609,25754,'','','NI','N','N','N','N','A',''),(900335279,'UNIGAS','CALLE PRINCIPAL CARTAGENA DEL CHAIRA CARTAGENA DEL','3118084447',0,'','','','',9609,18150,'','','NI','N','N','N','N','A','www.unigas.com.co'),(900336004,'COLPENSIONES','X BOGOTA','X',7,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900341483,'PROFESIONALES EN ENERGIA SA ESP','','0',1,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900393058,'CENTRAL AUTOMOTRIZ EUROVANS SAS','DG 7 14 62 BOGOTA','3108780842',7,'','','','',4530,11001,'J','P','NI','N','N','N','N','A','crautopartes@hotmail.com'),(900400181,'NEGOCIOS FAMILIARES INTEGRADOS S.A.S','CL 17 7 19 BRR SIETE DE AGOSTO','4353258',6,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900405154,'SERVIHOGAR Y EMPRESARIAL SAS','CL 15 # 9-54 BARRIO CENTRO','3102897686',1,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900409163,'PROINTURES S.A.S','CALLE 21 NO. 4B-32 B/LIBERTAD','4356106',4,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900448072,'CBC CONCULTORES S.A.S','CR 21 187 39','6718820',9,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900474762,'TV AZTECA COLOMBIA','CRA 9 A 99 - 02 BOGOTA','4894555',2,'','','','',9609,18150,'','','NI','N','N','N','N','A','TTQUIA@AZTECA-COMUNICACIONES.COM'),(900481871,'SINDICATO UNITARIO NACIONAL DE TRABAJADORES DEL ESTADO','','',6,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900493012,'ASOCIACION DE VICTIMAS DEL CONFLICTO ARMADO ASENTADOS EN EL MUNICIPIO','CALLE 7 N 1 77 1 85 BARRIO CENTRO','0',8,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900513649,'ASOMAQUINAS EXTRACTORES DE MATERIAL DE ARRASTRE Y DESARROLLO VIAL DEL','CRA 13 N?4-10 BARRO SANTAFE','0',6,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900522245,'CONSTRUCTORA CARVAJAL SAS','CRR 11 9062 BRR LA COOPERATIVA','4345690',2,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900523451,'PALACIO VIAS Y CONSTRUCCIONES SAS','CR 3 BIS 21A 14 FLORENCIA','4364005',8,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900540933,'ASESORIAS SOLUCIONES SUMINISTROS EMPRESARIALES EFICIENTES SAS','CALLE 7 No 8-26 B/ CAMILO TORRES','0',8,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900552815,'ASOCIACION DE EXPOSITORES ESPOCHAIRA','CR2 2 13 17 BARRIO CENTRO','304437403',9,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900572467,'CAMPOLIDER S.A.S.','CRA 1 4A 51 BRR CENTRO CARTAGENA DEL CHAIRA','',4,'','','','',9609,18150,'','','NI','N','N','N','N','A','campolidersas@hotmail.com'),(900619537,'COMAK CONTRUCTORES S.A.S','CL 32 BIS 2 E 95 URB LOS ALAMOS FLORENCIA','4377226',6,'','','','',9609,18150,'','','NI','N','N','N','N','A','comakconstructorescontabilidad@yahoo.com'),(900687712,'FUNERALES LA BASILICA','CARTAGENA CARTAGENA','00000',9,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900718645,'CABLE DVR SAS','CL 1 4 36 BRR PRIMAVERA','3102099574',8,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900749357,'LABOREMOS SSA SAS','CL 16 A 6 55 BARR SIETE DE AGOSTO','3118891942',4,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900753546,'SENSORICA E INGERNIERIA SAS','CR 1958 A 15','2121661',5,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900763513,'GRUPO HEMERCO S.A.S','CL 17 1148 BARRIO CENTRO','3103055861',5,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900764056,'INVERSIONES TQR SAS','CR 11 3 14 P 1 BRR JORGE ELIECER GAITAN FLORENCIA','4352512',5,'','','','',9609,18150,'','','NI','N','N','N','N','A','CRCFUNDADORES@GMAIL.COM'),(900832413,'GENERCOMERCIAL SA ESP','CR 48 # 48-12 P 3','3006529898',3,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900841097,'ALTA BIOTECNOLOGIA COLOMBIANA S.A.S','CR 4 15 40','8746886',7,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900874103,'GLOBAL REDES DE COLOMBIA S.A.S','CR 21 13 A 41 BRR ABBAS TURBAY','3214692695',5,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900935697,'PROYECTO VISION CAQUETA','CALLE 4 5 32','',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(900936010,'LA ASCENSION S.A.','CR 11 9 60','00000',6,'','','','',9609,18001,'J','P','NI','N','N','N','N','A',''),(901017183,'EDITORIAL LA REPUBLICA SAS','CL 77 8 31','6503600',2,'','','','',9609,11001,'','','NI','N','N','N','N','A',''),(901028281,'GRUPO EMPRESARIAL CHIARA STERO SAS','CR 3 32 46 BARRIO CENTRO','3138852037',3,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(901080795,'FORTALEZA DIGITAL S.A.S','TV 6 12 58 BRR PORVENIR','3188271629',7,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(901086786,'CONSULTORIAS Y ASESORIAS DE LOS COLOMBIANOS SAS','TV 60 49A SUR 08','5107357',8,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(901097473,'MEDIMAS EPS SAS','BOGOTA','',5,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(901137150,'WTD COMERCIALIZADORA ZOMAC SAS','CL 5A 6 41B BRR CENTRO','',4,'','','','',9609,18150,'J','P','NI','N','N','N','N','A','comercializadorawdt@gmail.com'),(901162494,'PROYECTOVISION CLICK ZOMAC SAS','CR 2 CL 3 ESQ CA 1 BRR CENTRO CARTAGENA DEL CHAIRA','3156890560',8,'','','','',9609,18150,'','','NI','N','N','N','N','A','rubens-t@hotmail.com'),(901249805,'IMPORTADORA TRACTOMULAS INTERNATIONAL ZOMAC S.A.S','CL 16 8 60 BRR CENTRO FLORENCIA','',0,'','','','',9609,18150,'','','NI','N','N','N','N','A','importadoratractomulas@hotmail.com'),(901285961,'AGROFER CAQUETA S.A.S','CL 5 59 61 65 67 71 BRR CENTRO CARTAGENA DEL CHAIR','',4,'','','','',9609,18150,'','','NI','N','N','N','N','A','NA'),(901321464,'TRIANGLE S.A.S','CR 26 M 1 96 18 CALI','',1,'','','','',9609,18150,'J','P','NI','N','N','N','N','A',''),(901372717,'DISTRIBUIDORA EL PUNTO DE LA ECONOMIA ZOMAC S.A.S','CL 4 6 36 BRR CENTRO CARTAGENA DEL CHAIRA','',6,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(901392137,'INVERSIONES Y SONIDO DEXTA ZOMAC S.A.S','CRA 10 NO. 2-36 CARTAGENA DEL CHAIRA','3186976683',1,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(91011617,'PARDO CAVANZO LUIS ARCADIO','CR 3 32 46 BARRIO CENTRO','3204356640',2,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(91012694,'ANGEL MARIA','CALLE 4 NO. 4-30BARRIO CENTRO CARTAGENA DEL CHAIRA','3214660558',4,'','','','',9609,18150,'','','NI','N','N','N','N','A','FERREVARIEDADES@GMAIL.COM'),(93180177,'CARDOZO ALDANA ABDONY','CR 3 4 35 CARTAGENA DEL CHAIRA','3174185311',4,'ALDONY','','CARDOZO','ALDANA',9609,18150,'N','P','CC','N','N','N','N','A',''),(94074784,'HECTOR HERNANDO JIMENEZ MORALES -  DISTRITODO HJ','CL 10 10 74 BRR COOPERATIVA','3134234441',5,'HECTOR','HERNANDO','JIMENEZ','MORALES',9609,18150,'N','','NI','N','N','N','N','A',''),(96353189,'LEDESMA MONTILLA ORLANDO','CALLE 4 NO 8-57 BARIO ANTIOQUIA','3134721043',7,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(96354336,'ANDERZON TRUJILLO GOMEZ','CL 2 4 56 BRR CENTRO','3144148105',8,'','','','',9609,18150,'','','CC','N','N','N','N','A',''),(963564688,'NAVAR NO USAR MAL NIT','CALLE 6 NO. 4-68 CARTAGENA DEL CHAIRA','3118110536',0,'','','','',9609,18150,'','','NI','N','N','N','N','A',''),(96359899,'MARTINEZ SALDARRIAGA VICTOR AUGUSTO','CALLE 4 NO. 8-65 BARRIO ANTIOQUIA CARTAGENA DEL CH','3132636167',5,'VICTR','AUGUSTO','MARTINEZ','SALDARRIAG',9609,18150,'N','P','CC','N','N','N','N','A','ferreelectricosm1@gmail.com'),(0,'No Aplica','','',0,'','','','',0,0,'','','','','','N','','',''),(9999,'VIgencia Anterior','cartagena de Chaira','',0,'','','','',9609,18150,'J','P','NI','N','N','N','N','A',''),(17690805,'JUAN CARLOS MORENO PEREZ','CR 6 14 44 BRR CENTRO','3008404716',0,'JUAN','CARLOS','MORENO','PREZ',0,18001,'N','P','CC','N','N','N','N','A',''),(1117974637,'NINFA JAZMIN CARVAJAL SANCHEZ','CL 7 11A 30 BRR VILLA DEL CHAIRA','3106777336',0,'NINFA','JAZMIN','CARVAJAL','SANCHEZ',0,18150,'N','E','CC','N','N','N','N','A','NINASANCHEZ191980@GMAIL.COM'),(40188828,'MARIANELA AVILA GONZALEZ','CR 31 ESTE 3470 TO 5 AP 802','3162738144',0,'MARIANELA','','AVILA','GONZALEZ',0,50001,'N','P','CC','N','N','N','N','A','mavilag28@hotmail.com'),(900301855,'ASESORES EXPERTOS EN INGENIERIA Y SOLUCIONES SAS','CL 45 11 BRR CALARCA','3006113606',7,'','','','',0,73001,'J','P','NI','N','N','N','S','A','ASEXIS_SAS@HOTMAIL.COM'),(10690095,'SALOMON TRUJILLO NOGUERA','CL 3 8 27','3143830152',0,'SALOMON','','TRUJILLO','NOGUERA',0,19532,'N','P','CC','N','N','N','N','A',''),(17689516,'HAROLD IVAN GARCIA SALINAS','CL 3E 7 81 BRR LA PRIMAVERA','3132676300',8,'HAROLD','IVAN','GARCIA','SALINAS',7310,18001,'N','P','CE','N','N','N','N','A','DJHAROLDMIXING@GMAIL.COM'),(33750812,'RUIZ TOVAR JESSICA ANDREA','CL 17 22 43','3163156606',0,'JESSICA','ANDREA','RUIZ','TOVAR',0,41001,'N','P','CC','N','N','N','N','A','JESANDRUIZ@HOTMAIL.COM'),(40730932,'LIANA MARIA MOLINA JARAMILLO - PLANOS Y PUBLICIDAD','CL 16 5 6 ESQ SIETE DE AGOSTO','3125114588',7,'LIANA','MARIA','MOLINA','JARAMILLO',0,18001,'N','P','CC','N','N','N','N','',''),(899999004,'INSTITUTO GEOGRAFICO AGUSTIN CODAZZI','CL 4 5 32 BRR CENTRO','4351154',9,'','','','',0,18001,'J','N','NI','N','N','S','N','A',''),(1007447792,'KAREN YULIANA JIMENEZ GASCA','CR 7 4 48 BRR ANTIOQUIA','3174249510',0,'KAREN','YULIANA','JIMENEZ','GASCA',1011,18150,'N','P','CC','N','N','N','N','A','karenjimenezgasca@gmail,com'),(1006459097,'GRESLI JASBLEIDY NOREÑA CHALA','CR 2D 33 3 7 BBR AMAZONIA','3114516544',8,'GRESLI','JASBLEIDY','NOREÑA','CHALA',4664,18001,'N','P','CC','N','N','N','N','A','comercializadorayserviciosmyj@gmail.com'),(16189593,'OIDEN LOZADA','BARRIO CENTRO CARTAGENA DEL CHAIRA','3175686075',0,'OIDEN','','LOZADA','',0,18150,'N','E','CC','N','N','N','N','A','oiden_lozada@hotmail,com'),(17641358,'ARIAS VALENCIA EDUCARDO','CR 3 5 54 BRR SAN FERNANDO','3102078138',3,'EDUCARDO','','ARIAS','VALENCIA',9609,18592,'N','P','CC','N','N','N','N','A','herlindachica@hotmail.com'),(900488748,'ASOCIACION DE TRANSPORTADORES FLUVIALES DEL CHAIRA','CL 3 1 17 BRR CENTRO','3106730267',1,'','','','',9499,0,'J','P','NI','N','N','N','N','A','ASOTRANSCHAIRA@HOTMAIL.COM'),(900613138,'LUCATHO SAS','CR 57 18 SUR 47','4944450',3,'','','','',4663,11001,'J','P','NI','N','N','N','S','A','CLAUDIALARAMO@YAHOO.COM'),(96331758,'GONZALEZ GONZALEZ JOSE ALIRIO','BRR ANTIOQUIA','3224777983',0,'JOSE','ALIRIO','GONZALEZ','GONZALEZ',0,18150,'N','P','CC','N','N','N','N','A',''),(93415831,'ARIAS VASQUEZ ALVARO','BRR ANTIOQUIA','3213701363',4,'ALVARO','','ARIAS','VASQUEZ',0,18150,'N','N','CC','N','N','N','N','A',''),(222222222,'CUANTIAS MENORES','CL 4 5 32 BRR EL CENTRO','3204938248',0,'','','','',0,18150,'J','P','NI','N','N','N','N','A',''),(900471164,'ASOCIACION DE MUJERES TEJEDORAS DE SUEÑOS','CR 6 CL 3 4 Y CL 3','3144582103',4,'','','','',9499,18150,'J','P','NI','N','N','N','N','A','JARAMILLO.ANA@GMAIL.COM'),(800157190,'Fiscalia del Ibague','cra 10 sur n 46 80','',0,'fiscalia','','','',9609,73001,'J','C','NI','N','N','N','N','A',''),(40626647,'LUZ STELLA GOMEZ JARAMILLO','BRR CENTRO','3135833864',8,'LUZ','STELLA','GOMEZ','JARAMILLO',8129,18150,'N','P','CC','N','N','N','N','A','PRINCESSMAYE_95@HOTMAIL.COM'),(1117962091,'YADI MILENA ARIAS OSPITIA','CR 3 CL 8','3118847279',3,'YADI','MILENA','ARIAS','OSPITIA',8129,18150,'N','P','CC','N','N','N','N','A','ARIASOSPITIAYADILIMILENA@GMAIL.COM'),(29881265,'MARIN MAGNOLIA','CR 1 BRR PRIMERO ENERO','3172868963',1,'MAGNOLIA','','MARIN','',8129,18150,'N','P','CC','N','N','N','N','A','PRINCESSMAYE_95@HOTMAIL.COM'),(40781958,'PUENTES COLLAZOS RUBIELA','BRR COMUNEROS','3123967708',6,'RUBIELA','','PUENTES','COLLAZOS',8129,18150,'N','P','CC','N','N','N','N','A','PRINCESSMAYE_95@HOTMAIL.COM'),(40626523,'BOLIVAR MARTINEZ MARIA SENEIDA','CR 8 9 53 BRR CAMILO TORRES','3124965710',3,'MARIA','SENEIDA','BOLIVAR','MARTINEZ',8129,18150,'N','P','CC','N','N','N','N','A','OSITAHERMOSA.1997@HOTMAIL.COM'),(26638784,'GUTIERREZ ROJAS FANNY','CR 3B 2842 BRR PRADOS DEL NORTE','320424825',1,'FANNY','','GUTIERREZ','ROJAS',8129,18150,'N','P','CC','N','N','N','N','A','PRINCESSMAYE_95@HOTMAIL.COM'),(1117265965,'MORENO SANABRIA LUZ MARINA','CL 18 11 31 BRR CENTRO','3041334024',5,'LUZ','MARINA','MORENO','SANABRIA',0,18001,'N','P','CC','N','N','N','N','A',''),(830087666,'SEGURO FUNERARIO LA ASCENCION','','',1,'','','','',6512,0,'J','P','NI','','','N','','A','jennyc0413@gmail.com'),(40627807,'CASTRO NAYASO CAROLINA DEL PILAR','CR 10 9 26 BRR ANTIOQUIA','3117553300',4,'CAROLINA','DEL PILAR','CASTRO','NAYASO',1410,18150,'N','P','CC','N','N','N','N','A','ALEXAFERNANDA18@HOTMAIL.COM'),(40088958,'GRANADA GARNICA NORLANDY','CL 2 6 39 BRR PRIMAVERA','3223793521',4,'NORLANDY','','GRANADA','GARNICA',8129,18150,'N','P','CC','N','N','N','N','A','NORLANDYG94@GMAIL.COM'),(808001433,'CENTRAL ADMINISTRATIVA Y CONTABLE  CENAC FLORENCIA','cr 3a cl 11a','0',0,'','','','',0,18001,'J','N','NI','N','N','N','N','A',''),(899999143,'SERVICIO AEREO A TERRITORIOS NACIONALES SA','AV EL DORADO','0314292300',4,'','','','',0,11001,'J','P','NI','N','N','N','N','A',''),(900447980,'ALCOMAX SAS','CL 9 SUR 52 92','3175737658',7,'','','','',4659,18150,'J','P','NI','N','N','N','S','A','ALCOMAX@HOTMAIL.COM'),(901211097,'COMERCIALIZADORA LA CASA DEL AGRO ZOMAC SAS','CL 17 11 29 BRR CENTRO','3133863528',8,'','','','',4653,18001,'J','P','NI','N','N','N','S','A',''),(40626556,'MUÑETON VALDERRAMA MARITZA','EMSERPUCAR','0',0,'MARITZA','','MUÑETON','VALDERRAMA',4799,18150,'N','P','CC','N','N','N','N','A','MARITZAMUNETON@GMAIL.COM'),(6110433,'CASTRO VARELA LUIS ALFONSO','CL 4 9 29 BRR CENTRO','3235837206',1,'LUIS','ALFONSO','CASTRO','VARELA',0,18150,'N','P','CC','N','N','N','N','A',''),(55061970,'RODRIGUEZ GONZALEZ NURY','CRA 2 2 46 BARRIO CENTRO','3108553052',0,'NURY','','RODRIGUEZ','GONZALEZ',8129,18150,'N','P','CC','N','N','N','N','A','NURYR746@GMAIL.COM'),(800227940,'FONDO DE PENSIONES OBLIGATORIAS COLFONDOS MODERADO','CALLE 67 7 94 BOGOTA','',6,'','','','',0,11001,'J','N','NI','N','N','N','N','A',''),(900935126,'ASMET SALUD EPS SAS','CR 8B 6  53 BRR LAS AVENIDAS','4352160',7,'','','','',0,18001,'J','N','NI','N','N','N','N','A',''),(900504821,'SOLUCIONES ORGANIZACIONALES Y TERRITORIALES SAS','CR 4 16 04 OFC 812','3132891852',9,'','','','',7020,11001,'J','P','NI','N','N','N','S','A','JAAR8330@GMAIL.COM'),(800229739,'FONDO DE PENSIONES OBLIGATORIAS PROTECCION','CL 13 65 21','0317444464',0,'','','','',0,11001,'','N','NI','N','N','N','N','A',''),(805000427,'COOMEVA ENTIDAD PROMOTORA DE SALUD S.A.','CR 13 12 48','0317292647',1,'','','','',0,18001,'J','P','NI','N','N','N','N','A',''),(900147238,'APORTES EN LINEA SA','CR14A 101 47 PS 4','0180005102',2,'','','','',0,18150,'J','P','NI','N','N','N','N','A',''),(800251569,'INTER RAPIDISIMO SA','CR 30 7 45','3232554455',7,'','','','',0,11001,'J','P','NI','N','N','N','N','A',''),(1119213849,'RAMON AGUDELO ALBERTO','BRR LA PRIMAVERA','3223062789',3,'ALBERTO','','RAMON','AGUDELO',0,18150,'N','P','CC','N','N','N','N','A',''),(12225611,'NUÑEZ MUÑOZ GUSTAVO','CL 17 9 02 BRR CENTRO','4354445',0,'GUSTAVO','','NUÑEZ','MUÑOZ',0,18001,'N','P','CC','N','N','N','S','',''),(1117528597,'CASTRO ROJAS ALEXANDRA','CR 11 16 62 BRR CENTRO','3204683451',8,'ALEXANDRA','','CASTRO','ROJAS',0,18001,'N','P','CC','N','N','N','N','A',''),(899999007,'SUPERINTENDENCIA DE NOTARIADO Y REGISTRO','CL 26 13 49 201','3282121',0,'','','','',0,11001,'J','P','','N','N','N','N','A',''),(17690035,'GOMEZ MOTTA CESAR ANDRES','CL 4 4 70','3214325240',9,'CESAR','ANDRES','GOMEZ','MOTTA',0,18150,'N','P','CC','N','N','N','N','A',''),(1117517181,'GALLEGO PEREZ LILIANA','BRR CENTRO','3222341145',0,'LILIANA','','GALLEGO','PEREZ',0,18150,'N','P','CC','N','N','N','N','A',''),(1117549101,'MONTES MEDES GUSTAVO ADOLFO','CR 3 5 39 BRR BUENOS AIRES','3178749473',9,'GUSTAVO','ADOLFO','MONTES','MENDEZ',0,18150,'N','P','CC','N','N','N','N','A',''),(40765327,'CEDIEL RAMIREZ LUZ STELLA','CR 7 3 27 BRR ANTIOQUIA','3173787625',0,'LUZ','STELLA','CEDIEL','RAMIREZ',0,18150,'N','P','CC','N','N','N','N','A',''),(1117960105,'LOPEZ AMEZQUITA OCTAVIO','BRR CINCO DE JUNIO','3213701359',0,'OCTAVIO','','LOPEZ','AMEZQUITA',0,18150,'N','P','CC','N','N','N','N','A',''),(1116917361,'ARIAS MARTINEZ ROYLSON','CR 6 5 04 BRR CENTRO','3218313075',2,'ROYLSON','','ARIAS','MARTINEZ',4542,18150,'N','P','CC','N','N','N','N','A','ROYLSON-361@HOTMAIL.COM'),(1117963223,'LUZ ADRIANA ALVAREZ SANTANA','BRR DIVINO NIÑO','3207153002',0,'LUZ','ADRIANA','ALVAREZ','SANTANA',0,0,'N','P','','N','N','N','N','A','nanita,8720@gmail,com'),(900815399,'ROCA MINERALES SAS','CL 1A 224 131 BRR EL CHAMON','3123062185',6,'','','','',7110,18150,'J','P','NI','N','N','N','N','A','rocaminerales1@hotmail.com'),(800216125,'RAMONERRE SA','CL 15 5 43','0318258134',2,'','','','',2829,25286,'J','P','NI','N','N','N','S','A','ADMINISTRACION@RAMONERRE.COM'),(30506231,'BIBIANA GONZALEZ ESPAÑA','CR 8 7 45 BRR LA ESTRELLA','3204421166',0,'','','','',6621,18001,'N','P','','N','N','N','N','A',''),(890310455,'FUNERALES LOS OLIVOS','','',0,'','','','',0,0,'J','P','','N','N','N','N','A',''),(1117975847,'RAMIREZ GALEANO YULEIDY ALEJANDRA','CR 5 13 53 BARRIO 15 DE JUNIO','3142746335',0,'YULEIDY','ALEJANDRA','RAMIREZ','GALEANO',7490,18150,'N','P','CC','N','N','N','N','A',''),(1116913799,'DIAZ ORTIZ SANDRO FABIAN','CL 5 CR 9 BRR SANTA FE','3132399455',6,'SANDRO','FABIAN','DIAZ','ORTIZ',4741,18592,'N','P','CC','N','N','N','N','A','SANDROFDIAZORTIZ@GMAIL.COM'),(79003870,'RODRIGUEZ RAMIREZ EDGAR EDUARDO','MZ D CS 18 BRR MIRADOR','3152356260',2,'EDGAR','EDUARDO','RODIGUEZ','RAMIREZ',0,73001,'N','P','CC','N','N','N','N','A',''),(1117962729,'BERMUDEZ VANEGAS MILADI','CR 4 3 32 BRR CENTRO','3118901451',3,'MILADI','','BERMUDEZ','VANEGAS',0,18150,'N','P','CC','N','N','N','N','A',''),(6802738,'CASTILLO GOMEZ JORGE ARMANDO','CL 16 8 60 BRR CENTRO','3115671003',0,'JOGE','ARMANDO','CASTILLO','GOMEZ',0,18001,'N','P','','N','N','N','S','A',''),(83235033,'CASANOVA DIAZ JHON MARLIO','CL PRINCIPAL VIA AL PUERTO','3106280361',4,'JHON','MARLIO','CASANOVA','DIAZ',0,18150,'N','P','CC','N','N','N','S','A',''),(1117968322,'NIÑO FERNANDEZ EVELIO ANDRES','BRR CENTRO','3184267524',7,'EVELIO','ANDRES','NIÑO','FERNANDEZ',0,18150,'N','P','CC','N','N','N','N','A',''),(16547315,'DIEGO FERNANDO RAMIREZ FRANCO','','',0,'','','','',0,0,'N','P','','N','N','N','N','A',''),(900392455,'INGENIERÍA PARA LA PROTECCIÓN DEL MEDIO AMBIENTE SAS','CALLE 13 N°10-67 OF 2020 BARRIO CENTRO - FLORENCIA','',3,'','','','',0,0,'J','P','','N','N','N','S','A',''),(900239302,'MEDICAL P-DROZ FLORENCIA SAS','CL 10 9 A 13 LC 103 ED EL PRADO','3155764059',1,'','','','',0,18001,'J','P','NI','N','N','N','S','A',''),(1006419867,'MENDOZA MUÑETON YEISON','QUINCE DE JUNIO','',0,'YEISON','','MENDOZA','MUÑETON',0,18150,'N','P','CC','N','N','N','N','A',''),(1007447876,'ARAGONEZ CALDERON OLGA LUCIA','CR 9 2 26 BRR PRIMAVERA','3103205209',0,'','','','',0,18150,'N','P','CC','N','N','N','N','A',''),(1116722914,'RIOS SUNCE CARLOS ALBERTO','CL 4 4 33','3127873690',7,'CARLOS','ALBERTO','RIOS','SUNCE',4771,18150,'N','P','CC','N','N','N','S','A','CAFE-007@HOTMAIL.COM'),(40078584,'BETANCOURT TORRES SANDRA GLEIDIS','CL 5 8 33 BRR ANTIOQUIA','3103019686',0,'SANDRA','GLEIDIS','BETANCOURT','TORRES',0,18150,'N','E','CC','N','N','N','N','A',''),(40755220,'CUTIVA MARTHA','BRR CENTRO','',0,'MARTHA','','CUTIVA','',0,18150,'N','C','CC','N','N','N','N','A',''),(17631111,'CASTRO VARGAS OTONIEL','CL 15A 8 35 BRR CENTRO','3107659660',9,'OTONIEL','','CASTRO','VARGAS',4530,18001,'N','P','CC','N','N','N','N','A','SCASTROV@SENA.EDU.CO'),(1117975514,'ESPAÑA IQUINA JUAN DE JESUS','CL 7 3 34 BRR COMUNEROS','3115030582',3,'JUAN','DE JESUS','ESPAÑA','IQUINA',0,18150,'N','E','CC','N','N','N','N','A','espanaiquinajuandejesus@gmail,com'),(17775614,'ALDANA MUÑOZ FERNEY','CR 9 1 05 BRR PRIMAVERA','3207640240',1,'FERNEY','','ALDANA','MUÑOZ',0,18150,'N','E','CC','N','N','N','N','A','ferneymunoz291@gmail,com'),(93403068,'VIVAS CASTAÑEDA HECTOR FABIO','CR 11 25 10 BRR CIUDADELA','3185497678',9,'HECTOR','FABIO','VIVAS','CASTAÑEDA',4520,18150,'N','P','CC','N','N','N','N','A','HECTORFABIOVIVAS6@GMAIL.COM'),(900939540,'CSH INGENIERIA SAS','CL 66 2W 95','3165768333',1,'','','','',8020,41001,'J','P','CC','N','N','N','S','A','CSHINGENIERIASAS@GMAIL.COM'),(79617412,'ROMERO LEITON MILLER','CR 6 04 22 B','3144057348',8,'MILLER','','ROMERO','LEITON',8129,18001,'N','P','CC','N','N','N','N','A','FUMIGACIONES_MILLER9@HOTMAIL.COM'),(1006909066,'CAICEDO CARABALI YORLADY','CL 4 7 24 BRR ANTIOQUIA','3105738543',1,'YORLADY','','CAICEDO','CARABALI',0,18150,'N','P','CC','N','N','N','N','A',''),(1115794042,'MOSQUERA COLLAZOS SANDRO','CL 4 50 135 BRR PRADOS','3118433385',4,'SANDRO','','MOSQUERA','COLLAZOS',0,18150,'N','P','CC','N','N','N','N','A',''),(1094247822,'VELANDIA MARTINEZ YOHANA DANITZA','CR 28 CL 26 41 SUR TO O 4 AP 1 O 2 BRR CONJUNTO RE','3166212999',1,'YOHANA','DANITZA','VELANDIA','MARTINEZ',4799,41001,'N','P','CC','N','N','N','N','A','ECOSOLUCIONESGLOBL@GMAIL.COM'),(860512330,'SERVIENTREGA SA','AV 6 34A 11','',3,'','','','',0,11001,'J','P','NI','N','N','N','N','A',''),(7715414,'ACHIPIZ  OSSA JHON WILSON','CR 7   SUR ZN INDUSTRIAL','3133986251',0,'JHON','JAIRO','ACHIPIZ','OSSA',4520,41001,'N','P','CC','N','N','N','N','A','ACHIPIZ1380@GMAIL.COM'),(30339796,'GARCIA MORALES MARIA ELZA','CR 2G 12A 21 BRR ABBAS TURBAY','3118992217',1,'MARIA','ELZA','GARCIA','MORALES',7490,18001,'N','P','CC','N','N','N','N','A','ELZAGARCIA76@YAHOO.COM'),(901025736,'INGENIERIA Y GESTION DE MANTENIMIENTO COLOMBIA SAS','CR 10 SUR 06 21 ZN INDUSTRIAL','3175134031',9,'','','','',3312,41001,'J','P','NI','N','N','N','S','A','CONTABILIDAD@IGMCOLOMBIA.COM'),(4688884,'GUEVARA HULE JOSE OSIMIDIO','CL 4 3 44 BRR CENTRO','3123903798',1,'JOSE','OSIMIDIO','GUEVARA','HULE',0,18150,'N','P','CC','N','N','N','N','A',''),(76322566,'LATORRE BOLAÑOS DIEGO ALEXANDER','CR 6 13 A 34','4340114',5,'DIEGO','ALEXANDER','LATORRE','BOLAÑOS',0,18001,'N','P','CC','N','N','N','S','A',''),(17650112,'ARTUNDUAGA LUIS EMILIO','AV LA PLAZA','3143511748',7,'LUIS','EMILIO','ARTUNDUAGA','',0,18001,'N','P','CC','N','N','N','N','A',''),(17651322,'MAZZO LUIS EVELIO','CL 3A 3B 20 BRR GALERIA CENTRAL','3134470867',1,'LUIS','EVELIO','MAZZO','',0,18150,'N','P','CC','N','N','N','N','A',''),(79382507,'FLOREZ DAVILA DIVIER','CL 3 BRR CENTRO','3102299371',8,'DIVIER','','FLOREZ','DAVILA',0,18150,'N','P','CC','N','N','N','N','A',''),(7711505,'SANCHEZ MOTTA FERNEY','CL 17 8 68 BRR SIETE DE AGOSTO','3204274592',4,'FERNEY','','SANCHEZ','MOTTA',0,18001,'N','P','CC','N','N','N','S','A',''),(96352082,'ROMERO MARIN IVAN DARIO','CR 4 4 46','3186128842',3,'IVAN','DARIO','ROMERO','MARIN',0,18150,'N','P','CC','N','N','N','N','A',''),(94481216,'DEAZA ORDOÑEZ JAIDER','CR 7 4 32','3143471424',9,'JAIDER','','DEAZA','ORDOÑEZ',8299,18150,'N','P','CC','N','N','N','N','A','JAIDERDEAZA628@GMAIL.COM'),(110525060,'','','',0,'','','','',0,0,'','','','','','N','','',''),(1110525060,'LISLIE ANDREA DURAN ALMANZA','BRR CENTRO','',6,'LISLIE','ANDREA','DURAN','ALMANZA',0,18150,'N','P','CC','N','N','N','N','A',''),(1075320448,'PANIAGUA AMAYA YULIANA','CR 7 4-48 BRR ANTIOQUIA','3174249510',0,'YULIANA','','PANIAGUA','AMAYA',9609,18150,'N','E','CC','N','N','N','S','A','yulianapaniagua2708@gmail.com'),(1117508268,'GONZALEZ IBAÑEZ CARLOS MAYKE','CL 18 A 4 07 BRR BUENOS AIRES','3115784016',4,'CARLOS','MAYKE','GONZALEZ','IBAÑEZ',4321,18150,'N','P','CC','N','N','N','N','A','CARLOSMAYKEY89@HOTMAIL.COM'),(30508891,'PERDOMO MARILUZ','BRR SIETE DE AGOSTO','3224124463',7,'MARILUZ','','PERDOMO','',4669,18001,'N','P','CC','N','N','N','N','A',''),(17709810,'ANDRADE OYOLA MARCO ANTONIO','CR 3 16 24 BRR MIRAFLORES','3145515751',6,'MARCO','ANTONIO','ANDRADE','OYOLA',8299,18150,'N','P','CC','N','N','N','N','A','MARCOANDRADE75MA@GMAIL.COM'),(1117522005,'HURTADO CABRERA WILLIAM CAMILO','CR 13 10 B 28','3214844383',2,'WILLIAM','CAMILO','HURTADO','CABRERA',4321,18001,'N','P','CC','N','N','N','N','A','WILLIAMHURTADO70@GMAIL.COM'),(16215907,'ESQUIVEL JORGE EDUARDO','CR 1 B BIS 32 31 BRR LOS PINOS','3168780462',7,'JORGE','EDUARDO','ESQUIVEL','',4321,18001,'N','P','CC','N','N','N','N','A','H_LOSADA@HOTMAIL.COM'),(900655200,'NOGAMI SAS','CR 3 6 73 BRR GUADALUPE','3203469720',2,'','','','',3011,50573,'J','P','NI','N','N','N','S','A','NOGAMISAS@GMAIL.COM'),(900462285,'JM MULTISISTEMAS SAS','AV 30 DE AGOSTO 48 60','3171312',9,'','','','',0,11001,'J','P','NI','S','N','N','S','A',''),(1117975672,'PRIETO RODRIGUEZ SOLANLLY','CR 9 34 38 BRR ANTIOQUIA','3228951963',9,'SOLANLLY','','PRIETO','RODRIGUEZ',8299,18029,'N','P','CC','N','N','N','N','A','SOLANLLYRODRIGUEZPRIETO@GMAIL.COM'),(1117485055,'QUINTERO MENDOZA BRAYAR FABIAN','CL 6 4 31 BRR ANTIOQUIA','3157236231',1,'QUINTERO','MENDOZA','BRAYAR','FABIAN',141,18150,'N','P','NI','N','N','N','N','A','JARAMILLO.ANA@GMAIL.COM'),(1117501257,'CUELLAR MONTOYA CARLOS JULIO','CR 12 19 43 BRR CENTRO','3188775490',1,'CARLOS','JULIO','CUELLAR','MONTOYA',7310,18150,'J','P','NI','N','N','N','N','A','ECKO_PUBLICIDAD@HOTMAIL.COM'),(1117974292,'PARRA MARTINEZ JOSE ARLINSON','CL 11 A N 3 A 62 BRR DIVINO NIÑO','3188265494',9,'JOSE','ARLINSON','PARRA','MARTINEZ',9900,18150,'N','E','CC','N','N','N','N','A','MARTINEZARLINSON@GMAIL.COM'),(96353058,'DURAN POVEDA ENRRIQUE','CR 1 2 32 BRR CENTRO','',0,'ENRRIQUE','','DURAN','POVEDA',0,18150,'N','C','CC','N','N','N','N','A',''),(891190322,'TRANSPORTES DEL YARI SA','OF PPAL TERMINAL DE TRANSPORTE','6084358353',3,'','','','',9609,18001,'J','P','CE','N','N','N','N','A',''),(800252518,'RED MULTISERVICIOS DE COLOMBIA SA','CR 11 14 08 BRR CENTRO FLORENCIA','4357048',6,'','','','',9609,18001,'J','P','CC','N','N','N','S','A','JURIDICO.MC@SUPERSERVICIOSCAQUETA.CO'),(17659953,'MARLES MONTES ALVARO JOSE','CL 6 4 66 BRR LA PISTA','3138714062',5,'ALVARO','JOSE','MARLES','MONTES',9609,18150,'N','P','CC','N','N','N','N','A','ARQUIACEROSCOLOMBIA@HOTMAIL.COM'),(17627886,'RESTREPO MEJIA LIBORIO','CR 11 15 56 BRR FLORENCIA','3124383458',2,'LIBORIO','','RESTREPO','MEJIA',9609,18150,'J','P','CC','N','N','N','N','A',''),(17689975,'GRAJALES QUIBANO ELIBERTO','PTO PRINCIPAL','3212660296',5,'ELIBERTO','','GRAJALES','QUIBANO',9609,18150,'J','P','CC','N','N','N','N','A',''),(1004862622,'SANCHEZ CATAÑO DUBY YESENIA','CL 4 5 33 BRR CENTRO','3213701359',5,'DUBY','YESENIA','SANCHEZ','CATAÑO',9609,18150,'J','P','CC','N','N','N','N','A',''),(1117969369,'CHARRES VALBUENA ESTEFANIA','CR 7 3 BRR ANTIOQUIA','3143154291',7,'ESTEFANIA','','CHARRES','VALBUENA',9609,18150,'N','P','CC','N','N','N','N','A',''),(1117969443,'GONZALEZ PEREZ CARMEN ELISA','BRR CENTRO','3224641031',0,'CARMEN','ELISA','GONZALEZ','PEREZ',9609,18150,'N','P','CC','N','N','N','N','A',''),(7705260,'TOVAR GUEVARA EDWIN ORLANDO','CR 7 1 12','3112034271',0,'EDWIN','ORLANDO','TOVAR','GUEVARA',9609,41001,'J','P','CC','N','N','N','N','A',''),(96329680,'GONZALEZ MORENO JOSE LUPERSI','BRR CENTRO','3173530050',0,'JOSE','LUPERSI','GONZALEZ','MORENO',9609,18150,'N','P','CC','N','N','N','N','A',''),(40780335,'PARRA REY ALBA LEONOR','CR 6 2 05','3103064774',3,'ALBA','LEONOR','PARRA','REY',4754,18150,'N','P','CC','N','N','N','N','A','HOGARDEALBASA4@GMAIL.COM'),(17637929,'RAMOS CORDOBA JAIME','TV 5B 9 54 BRR COMUNEROS ALTO','3124662053',3,'JAIME','','RAMOS','CORDOBA',9609,18150,'N','P','CC','N','N','N','N','A',''),(1117546197,'CARMONA ORTIZ JOSE FABIAN','CL 6 4 34 BRR CENTRO','3222703036',1,'JOSE','FABIAN','CARMONA','ORTIZ',9609,18150,'N','P','CC','N','','N','N','A',''),(7708346,'HERRERA CORREA DIEGO JULIO','CR 7 6 32 SUR ZONA INDUSTRIAL','3143826788',9,'DIEGO','JULIO','HERRERA','CORREA',9609,41001,'N','P','CC','N','N','N','N','A',''),(1080935838,'OROZCO IMBACHI JOSE JONATHAN','CR 7 18 47 SUR ZONA INDUSTRIAL','3186497374',1,'JOSE','JONATHAN','OROZCO','IMBACHI',9609,41001,'N','P','CC','N','N','N','N','A',''),(1075319268,'PINTO CUEVAS DIEGO ALEXANDER','CR 10 6A 11 SUR ZONA INDUSTRIAL','3204889438',1,'DIEGO','ALEXANDER','PINTO','CUEVAS',9609,41001,'N','P','CC','N','N','N','N','A',''),(17657424,'LOZADA RUIZ GILBERTO','TERMINAL DE TRANSPORTE','3103172707',1,'GILBERTO','','LOZADA','RUIZ',9609,18150,'N','P','CC','N','N','N','N','A',''),(96342391,'LOSADA TANGARIFE LUIS ALBERTO','BRR CIUDADELA','3212576375',0,'LUIS','ALBERTO','LOSADA','TANGARIFE',9609,18150,'N','P','CC','N','N','N','N','A',''),(1117522066,'VALDERRAMA CASTRILLON CRISTIAN','BRR PORVENIR','3137501256',0,'CRISTIAN','','VALDERRAMA','CASTRILLON',9609,18001,'N','P','CC','N','N','N','N','A',''),(12134102,'CANO BERNAL ARNETH','CL 14 A 1 13','3118380837',2,'ARNETH','','CANO','BERNAL',7490,18001,'N','P','CC','N','N','N','N','A','ARNETHCANO@YAHOO.ES'),(860007701,'COMPAÑIA DE TAXIA VERDES SA','CL 18 15 28','4111152',7,'','','','',9609,11001,'J','P','CC','N','N','N','N','A',''),(900897653,'3INNOVA SAS','CL 23 74 B 03','3124786719',3,'','','','',8230,11001,'J','P','NI','N','N','N','S','A','INFO@3INNOVA.CO'),(1122728578,'SERGIO ALEXIS LAISECA CONTA','BRR VILLA REAL','3026810218',0,'','','','',0,18150,'N','P','CC','N','N','N','N','A',''),(901140175,'ALMACEN Y TALLER AGROMOTORES SAN VICENTE ZOMAC SAS','TV 4 6 25 27 BRR EL CENTRO','3162710862',9,'','','','',0,0,'J','P','','N','N','N','S','A',''),(860014918,'FUNDACION UNIVERSIDAD EXTERNADO DE COLOMBIA','CL 12 1 17 ESTE BL A','3419900',7,'','','','',0,0,'J','P','NI','N','N','N','N','A',''),(901211874,'GRUPO EMPRESARIAL ZOMAC SAS','','3203014473',4,'','','','',0,0,'J','P','','N','N','N','N','A',''),(1117966844,'JEFFERSON ANDRES TORRES','CL 4 7 63 BRR ANTIOQUIA','3186748080',0,'','','','',0,0,'N','P','','N','N','N','N','A',''),(40771515,'ELSA ROJAS ALVIS','CL 4 23 25','3222429818',4,'','','','',0,0,'N','P','CC','N','N','N','N','A',''),(55161891,'LIBIA PRECIADO TOVAR','CR 6 11 45 BRR SAN JUDAS','312978045',6,'','','','',0,0,'N','P','','N','N','N','N','A',''),(860451569,'FYR INGENIEROS LTDA','CR 23 2B 16','2800260',3,'','','','',0,0,'J','P','NI','N','N','N','N','A',''),(1115952949,'PEDRO ALBERTO CRIOLLO CHUQUI','','',0,'','','','',0,0,'N','P','','N','N','N','N','A',''),(17649284,'RUBIEL CRUZ','','',0,'','','','',0,0,'N','P','','N','N','N','N','A',''),(1117486461,'JOSE ARNULFO BARRAGAN','','',0,'','','','',0,0,'N','P','','N','N','N','N','A',''),(1117553956,'VARQUEZ VELASQUEZ WILSON EDUARDO','CR 19 13 19 BRR LA FLORESTA','3102168428',0,'','','','',0,0,'N','P','','N','N','N','N','A',''),(17688930,'GONZALEZ RAMOS NARCISO','BRR CATALINA MUÑOZ','',0,'','','','',0,0,'N','P','CC','N','N','N','N','A',''),(1085101153,'CHEDRAGUI SANTANA KEVIN DAVID','','',0,'','','','',0,0,'N','P','','N','N','N','N','A',''),(5879791,'MENDOZA CARVAJAL MISAEL','','',0,'','','','',0,0,'N','P','CC','N','N','N','N','A',''),(1117507511,'SALDAÑA BERMEO JHONAN ANDRES','CR 17 4 35 BRR OBRERO','3102233943',5,'JHONAN','ANDRES','SALDAÑA','BERMEO',9609,18001,'N','P','CC','N','N','N','N','A','ANDRESSAL20@HOTMAIL.COM'),(6283648,'HERRERA SALAZAR JOSE DAGNOVER','','',0,'','','','',0,0,'N','P','CC','N','N','N','N','A',''),(17643960,'ANGEL HURTADO ROBERTH','CL 3 12 25 BRR EL ROSAL','3107946362',0,'','','','',0,18001,'N','P','CC','N','N','N','N','A',''),(79003112,'MARTINEZ CASTIBLANCO JAIME WILLIAM','BRR CENTRO','',0,'','','','',0,0,'N','E','','N','N','N','N','A',''),(1112464928,'EDWIN BRAVO SEPULVEDA','CRA 2 9 72','',0,'','','','',0,0,'N','E','CC','N','N','N','N','A',''),(17669269,'GONZALEZ GONZALEZ NELSON','BRR LIMONAR','',0,'','','','',0,0,'N','P','CC','N','N','N','N','A',''),(96360138,'RODRIGUEZ SERNA IVAN DARIO','','',0,'','','','',0,0,'N','P','CC','N','N','N','N','A',''),(1077873534,'BOHORQUEZ RIVERA LUISA FERNANDA','','',0,'','','','',0,0,'N','P','CC','N','N','N','N','A',''),(31478317,'ESPERANZA YATE GLORIA','','',0,'','','','',0,0,'N','P','CC','N','N','N','N','A',''),(1117964836,'MENDOZA GARAVITO CESAR AUGUSTO','','',0,'','','','',0,0,'N','P','CC','N','N','N','N','A',''),(12118655,'VARGAS BAUTISTA AZAEL','CR 10 14 08 BRR CENTRO','3107791995',0,'','','','',0,0,'N','P','CC','N','N','N','N','A',''),(800095728,'MUNICIPIO DE FLORENCIA','CL 14 12 15 BRR CENTRO','0684357663',2,'','','','',0,18001,'J','','NI','N','N','S','N','A','tesoreria@florencia-caqueta.gov.co'),(1075222419,'ENCISO PEREZ ARNOLD JAVIER','','',0,'','','','',0,0,'N','P','CC','N','N','N','N','A',''),(800095785,'MUNICIPIO DE SANVICENTE DEL CAGUAN','CLL 4 65 ESQUINA BARRIO CENTRO','8 464 4757',2,'','','','',0,18753,'J','N','','N','N','S','N','A','hacienda@sanvicentedelcaguan-caqueta.gov.co'),(1075259011,'HERMES MAURICIO CASTILLO CERQUERA','CR 7 4 66 68','8741978',0,'HERMES','MAURICIO','CASTILLO','CERQUERA',9609,41615,'N','C','CC','N','N','N','S','A','maury_1229@hotmail.com');

--
-- Table structure for table `tico`
--

CREATE TABLE `tico` (
  `ti_codtip` int(3) NOT NULL,
  `ti_descri` char(40) DEFAULT NULL,
  `ti_numero` int(9) DEFAULT NULL,
  PRIMARY KEY (`ti_codtip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tico`
--

INSERT INTO `tico` (`ti_codtip`, `ti_descri`, `ti_numero`) VALUES (100,'Saldo Inicial',220000),(101,'Facturas Servicios Publicos',220000),(102,'Recibos de Recaudo',220000),(103,'Entradas',220000),(104,'Salidas de Inventario',220000),(105,'Notas Bancarias',220000),(106,'Consignaciones',220000),(107,'Notas Contables',220000),(108,'Descuentos de Facturas',220000),(109,'Cuentas Por pagar',220000),(110,'Recibos de Pago',220000),(111,'Compras y Ctas x Pagar',220000),(112,'Comprobante de Egreso Adicional',220000),(113,'Comprobante de Egreso',220000),(116,'Comprobante de Depreciacion',220000),(118,'Nomina',220000),(119,'Pago de Nomina',220000),(200,'Cierre de Año',220000),(115,'Notas Debito Facturacion',220000),(114,'Notas Credito Facturacion',220000),(117,'Comprobante de Ingreso',220000),(120,'Entrada Medidores OC',220000),(121,'Entrada Devolutivos OC',220000),(131,'Facturas de Portafolio',220000),(132,'Recibos de Pago',220000),(122,'Traslados Bancarios',220000),(133,'Notas Credito Facturacion Saldo A favor',220000),(140,'Pago Directos por cuenta',220000),(129,'Avances',220000),(170,'Depreciacion',220000),(171,'Bajas de Inventario',220000),(134,'Ajustes de Nomina',220000);

--
-- Table structure for table `tico_niif`
--

CREATE TABLE `tico_niif` (
  `ti_codtip` int(3) NOT NULL,
  `ti_descri` char(40) DEFAULT NULL,
  `ti_numero` int(9) DEFAULT NULL,
  PRIMARY KEY (`ti_codtip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tico_niif`
--

INSERT INTO `tico_niif` (`ti_codtip`, `ti_descri`, `ti_numero`) VALUES (100,'Saldo Inicial',0),(101,'Facturas',0),(102,'Recibos de Recaudo',0),(103,'Entradas',0),(104,'Salidas de Inventario',0),(105,'Notas Bancarias',0),(106,'Consignaciones',0),(107,'Notas Contables',0),(108,'Descuentos de Facturas',0),(109,'Cuentas Por pagar',0),(110,'Recibos de Pago',0),(111,'Comprobante de Causacion',1),(112,'Comprobante de Ingreso',0),(113,'Comprobante de Egreso',0),(116,'Comprobante de Depreciacion',0),(118,'Nomina',0),(119,'Pago de Nomina',0),(200,'Cierre de Año',0),(115,'Notas Debito Facturacion',0),(114,'Notas Credito Facturacion',0);

--
-- Table structure for table `tidocu`
--

CREATE TABLE `tidocu` (
  `td_tidocu` char(2) NOT NULL,
  `td_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`td_tidocu`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tidocu`
--

INSERT INTO `tidocu` (`td_tidocu`, `td_descri`) VALUES ('CC','Cedula de Ciudadania'),('CE','Cedula de Extranjeria'),('NI','NIT');

--
-- Table structure for table `timovto`
--

CREATE TABLE `timovto` (
  `tm_timovto` int(2) NOT NULL,
  `tm_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`tm_timovto`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `timovto`
--

INSERT INTO `timovto` (`tm_timovto`, `tm_descri`) VALUES (131,'Facturas Servicios Especiales'),(132,'Recibos de Caja Servicios especiales'),(103,'Entradas de Inventario'),(104,'Salidas de Inventario'),(108,'Descuentos de Facturas'),(109,'Cuentas Por Pagar'),(110,'Recibos de Pago'),(105,'Notas Bancarias'),(0,'Sin Definir'),(129,'Avances y Anticipos'),(170,'Depreciacion'),(171,'Bajas de Inventario');

--
-- Table structure for table `tipcon`
--

CREATE TABLE `tipcon` (
  `tc_codtic` char(3) NOT NULL,
  `tc_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`tc_codtic`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tipcon`
--

INSERT INTO `tipcon` (`tc_codtic`, `tc_descri`) VALUES ('CAU','Causacion'),('CIE','Cierre-Año'),('CON','Consignaciones'),('CXP','Cuenta Por Pagar'),('EIN','Entradas de Inventario'),('FAC','Segun Factura'),('NOB','Nota Bancaria'),('NOC','Nota Contable'),('NOF','Nota Facturacion'),('PT','Pago a Terceros'),('RC','Recibo de Caja No.'),('REC','Recaudos'),('REI','Segun Reintegro No.'),('SI','Saldo Inicial'),('SIN','Salida de Inventario');

--
-- Table structure for table `tipveh`
--

CREATE TABLE `tipveh` (
  `tv_tipveh` int(3) NOT NULL DEFAULT '0',
  `tv_descri` char(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`tv_tipveh`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tipveh`
--

INSERT INTO `tipveh` (`tv_tipveh`, `tv_descri`) VALUES (0,'No Aplica');

--
-- Table structure for table `tmprevmovto_niif`
--

CREATE TABLE `tmprevmovto_niif` (
  `tmo_tipcom` int(3) NOT NULL,
  `tmo_numero` int(9) NOT NULL,
  `tmo_secuen` int(5) NOT NULL,
  `tmo_revela` text,
  PRIMARY KEY (`tmo_tipcom`,`tmo_numero`,`tmo_secuen`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tmprevmovto_niif`
--

INSERT INTO `tmprevmovto_niif` (`tmo_tipcom`, `tmo_numero`, `tmo_secuen`, `tmo_revela`) VALUES (111,220007,8,' '),(111,220007,9,' ');

--
-- Table structure for table `tramites`
--

CREATE TABLE `tramites` (
  `tm_numero` int(9) NOT NULL,
  `tm_codare` int(3) NOT NULL,
  `tm_tidano` int(3) NOT NULL,
  `tm_fecreg` date DEFAULT NULL,
  `tm_horreg` time NOT NULL DEFAULT '00:00:00',
  `tm_codcli` bigint(12) NOT NULL,
  `tm_estado` char(1) NOT NULL,
  `tm_califi` char(1) DEFAULT NULL,
  `tm_feccon` date DEFAULT NULL,
  `tm_horcon` time NOT NULL DEFAULT '00:00:00',
  `tm_origen` char(1) NOT NULL,
  `tm_codres` char(12) NOT NULL,
  `tm_admin` double(12,2) NOT NULL,
  `tm_impre` double(12,2) NOT NULL,
  `tm_utilid` double(12,2) NOT NULL,
  `tm_ivauti` double(12,2) NOT NULL,
  PRIMARY KEY (`tm_numero`),
  KEY `tm_tidano` (`tm_tidano`),
  KEY `tm_codcli` (`tm_codcli`),
  KEY `tm_codare` (`tm_codare`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tramites`
--

INSERT INTO `tramites` (`tm_numero`, `tm_codare`, `tm_tidano`, `tm_fecreg`, `tm_horreg`, `tm_codcli`, `tm_estado`, `tm_califi`, `tm_feccon`, `tm_horcon`, `tm_origen`, `tm_codres`, `tm_admin`, `tm_impre`, `tm_utilid`, `tm_ivauti`) VALUES (1,0,0,'2013-03-01','10:46:16',0,'P','','0000-00-00','00:00:00','1','0',0.00,0.00,0.00,0.00);

--
-- Table structure for table `traslado`
--

CREATE TABLE `traslado` (
  `tra_numero` int(9) NOT NULL,
  `tra_codres` char(12) NOT NULL,
  `tra_fecreg` date DEFAULT NULL,
  `tra_horreg` time NOT NULL DEFAULT '00:00:00',
  `tra_estado` char(1) NOT NULL,
  `tra_tippag` char(1) NOT NULL,
  `tra_vlrtot` double(15,2) DEFAULT NULL,
  `tra_detalle` text NOT NULL,
  `tra_feccre` date NOT NULL,
  `tra_anopre` int(4) NOT NULL,
  PRIMARY KEY (`tra_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `traslado`
--


--
-- Table structure for table `traslados`
--

CREATE TABLE `traslados` (
  `tr_numero` int(9) NOT NULL,
  `tr_cuenta_ori` char(12) DEFAULT NULL,
  `tr_cuenta_des` char(12) DEFAULT NULL,
  `tr_codres` char(12) NOT NULL,
  `tr_fecreg` date DEFAULT NULL,
  `tr_horreg` time NOT NULL DEFAULT '00:00:00',
  `tr_vlrtot` double(15,2) DEFAULT NULL,
  `tr_estado` char(1) NOT NULL,
  `tr_observa` text NOT NULL,
  `tr_codcli` bigint(12) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tr_numero`),
  KEY `tr_cuenta_ori` (`tr_cuenta_ori`),
  KEY `tr_cuenta_des` (`tr_cuenta_des`),
  KEY `tr_codcli` (`tr_codcli`),
  KEY `tr_codres` (`tr_codres`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `traslados`
--

INSERT INTO `traslados` (`tr_numero`, `tr_cuenta_ori`, `tr_cuenta_des`, `tr_codres`, `tr_fecreg`, `tr_horreg`, `tr_vlrtot`, `tr_estado`, `tr_observa`, `tr_codcli`) VALUES (210001,'1110050201','1110050104','1117964100','2021-01-05','04:02:44',40000000.00,'C',' REGISTRO DE DEVOLUCION DE PRESTAMO INERNO SEGUN RESOLUCION ADMINISTRATIVA N° 286 DE 2020 ',828000191),(210002,'1110050201','1110060107','1117964100','2021-01-05','04:06:48',75000000.00,'C','REGISTRO DE DEVOLUCION DE PRESTAMO INTERNO SEGUN RESOLUCION ADMINISTRATIVA N° 296 Y 287 DE 2020  ',828000191),(210003,'1110050201','1110050211','1117964100','2021-01-12','04:28:08',20000000.00,'C','REGISTRO DE DEVOLUCION DE PRESTAMO INTERNO SEGUN RESOLUCION ADMINISTRATIVA N° 245 DE 2020',828000191),(210004,'1110050104','1110050102','1117964100','2021-01-22','07:17:50',26181378.00,'C','TRASLADO PAGO DE CONTRATOS Y OBLIGACIONES DE DICIEMBRE 2020  ',828000191),(210005,'1110050101','1110050102','1117964100','2021-01-22','07:18:49',11195134.30,'C',' TRASLADO PAGO DE CONTRATOS Y OBLIGACIONES DE DICIEMBRE DE 2020 ',828000191),(210006,'1110050103','1110050102','1117964100','2021-01-22','07:20:06',9380613.14,'C','TRASLADO PAGO DE CONTRATOS Y OBLIGACIONES DE DICIEMBRE DE 2020',828000191),(210007,'1110050104','1110050101','1117964100','2021-01-29','01:46:48',5454702.00,'C','TRASLADO PAGO DE NOMINA ADMINISTRATIVA Y COMERCIAL DE ENERO 2021',800037800),(210008,'1110050102','1110050101','1117964100','2021-01-29','01:47:55',10909405.00,'C',' TRASLADO PAGO DE NOMINA ADMINISTRATIVA Y COMERCIAL DE ENERO DEL 2021 ',800037800),(210009,'1110050103','1110050101','1117964100','2021-01-29','01:48:54',3272821.00,'C',' TRASLADO PAGO DE NOMINA ADMINISTRATIVA Y COMERCIAL DE ENERO DEL 2021   ',800037800),(210010,'29010101','1110050202','1117964100','2021-01-30','11:38:42',265671.25,'C','   TRASLADO PAGO DE SERVICIOS EMSERPUCAR   ',800037800),(210011,'1110050101','1110050102','1117964100','2021-02-01','11:46:05',19000000.00,'C','TRASLADO PRESTAMO INTERNO DE TESORERIA SEGUN RESOLUCION ADMINISTRATIVA N 032 DEL 01 DE FEBRERO DE 2021',800037800),(210012,'1110050103','1110050102','1117964100','2021-02-01','09:27:12',7000000.00,'C','  TRASLADO PRESTAMO INTERNO DE TESORERIA SEGUN RESOLUCION ADMINISTRATIVA N 032 DEL 01 DE FEBRERO 2021',800037800),(210013,'1110050104','1110050103','1117964100','2021-02-17','02:59:42',1008000.00,'C','  REGISTRO DE TRASLADO PAGO DE CONTRATOS DE PS Y PASANTAES SENA',800037800),(210014,'1110050102','1110050103','1117964100','2021-02-17','03:00:38',1797005.00,'C','REGISTRO DE TRASLADO PAGO DE CONTARTOS DE PRESTACION DE SERVICIOS Y PASANTES DE SENA',800037800),(210015,'1110050101','1110050103','1117964100','2021-02-17','03:01:01',464183.00,'C','  REGISTRO DE TRASLADO PAGO DE CONTARTOS DE PRESTACION DE SERVICIOS Y PASANTES DE SENA  ',800037800),(210016,'1110050104','1110050102','1117964100','2021-02-17','03:02:31',17580451.00,'C',' TRASLADO PAGO DE CESANTIAS DE PORVENIR Y FONDO NACIONAL DEL AHORRO DE 2020 ',800037800),(210017,'1110050103','1110050102','1117964100','2021-02-17','03:03:22',10934550.00,'C','TRASLADO PAGO DE CESANTIAS DE PORVENIR Y FONDO NACIONAL DEL AHORRO DE 2020 ',800037800),(210018,'1110050101','1110050102','1117964100','2021-02-17','03:04:14',5492293.00,'C','  TRASLADO PAGO DE CESANTIAS DE PORVENIR Y FONDO NACIONAL DEL AHORRO DE 2020 ',800037800),(210019,'1110050202','1110050209','1117964100','2021-02-22','07:33:18',74805821.00,'C','RESGITRO DE TRASLADO DE RECURSOS DE MINIMO VITAL DEL MES DE DICIEMBRE Y ENERO 2021',890300279),(210020,'1110050202','1110050209','1117964100','2021-02-22','07:35:17',19423983.45,'C',' REGISTRO DE TRASLAD0 DE SUBSIDIOS DE TRIPLE A DE ACUEDUCTO DE DICIEMBRE Y ENERO DE 2021',890300279),(210021,'1110050202','1110050211','1117964100','2021-02-22','07:37:34',44123782.00,'C','REGISTRO DE TRASLADO DE SUBSIDIOS DE TRIPLE A DE ASEO DE DICIEMBRE  Y ENERO DE 2021  ',890300279),(210022,'1110050202','1110050210','1117964100','2021-02-22','08:01:38',20804668.00,'C','  REGISTRO DE TRASLAD0 DE SUBSIDIOS DE TRIPLE A DE ALCANTARILLADO DE DICIEMBRE Y ENERO DE 2021',890300279),(210023,'1110050202','1110050102','1117964100','2021-02-24','10:31:12',19000000.00,'C',' TRASLADO PAGO DE NOMINA DE FEBRERO DE 2021',890300279),(210024,'1110050209','1110050104','1117964100','2021-02-24','10:31:22',10000000.00,'C','  TRASLADO PAGO DE NOMINA DE FEBRERO DE 2021 ',890300279),(210025,'1110050211','1110050103','1117964100','2021-02-24','10:45:52',8000000.00,'C','  TRASLADO PAGO DE NOMINA DE FEBRERO DE 2021',0),(210026,'1110050102','1110050101','1117964100','2021-02-24','11:10:56',11359615.00,'C','TRASLADO PAGO DE NOMINA ADMINISTRATIVA Y COMERCIAL DEL FEBRERO DE 2021',800037800),(210027,'1110050104','1110050101','1117964100','2021-02-24','11:12:23',5679807.00,'C','TRASLADO PAGO DE NOMINA ADMINISTRATIVA Y COMERCIAL DEL MES DE FEBRERO DE 2021',800037800),(210028,'1110050103','1110050101','1117964100','2021-02-24','11:14:16',3407884.00,'C','TRASLADO PAGO DE NOMINA ADMINISTRATIVA Y COMERCIAL DE FEBRERO DE 2021 ',800037800),(210029,'1110050210','1110050202','1117964100','2021-03-01','07:18:00',21000000.00,'C','REGISTRO DE TRASLADO PRESTAMO INTERNO SEGUN RESOLUCION ADMON N° 058 DE 2021',890300279),(210030,'1110050211','1110050202','1117964100','2021-03-01','07:18:59',23000000.00,'C','REGISTRO DE TRASLADO PRESTAMO INTERNO SEGUN RESOLUCION ADMON N° 058 DE 2021',890300279),(210031,'1110050201','1110050202','1117964100','2021-03-01','07:19:50',4000000.00,'C','REGISTRO DE TRASLADO PAG0 DE FACTURA DEL MES DE FEBRERO DE DICEL',890300279),(210032,'1110050101','1110050104','1117964100','2021-03-02','10:12:19',810773.00,'C','REGISTRO DE TRASLADO PAGO DE CONTRATO S DE PASANTIAS Y PRESTACION DE SERVICIOS DE 2021',800037800),(210033,'1110050103','1110050104','1117964100','2021-03-02','10:13:11',1034528.00,'C','  REGISTRO DE TRASLADO PAGO DE CONTRATO S DE PASANTIAS Y PRESTACION DE SERVICIOS DE 2021',800037800),(210034,'1110050102','1110050104','1117964100','2021-03-02','10:13:55',2104193.00,'C','  REGISTRO DE TRASLADO PAGO DE CONTRATO S DE PASANTIAS Y PRESTACION DE SERVICIOS DE 2021',800037800),(210035,'1110050102','1110050104','1117964100','2021-03-08','11:06:32',20000000.00,'C',' TRASLADO DVOLUCION PRESTAMOS INTERNOS ',800037800),(210036,'1110050104','1110050102','1117964100','2021-03-18','05:18:12',12582481.00,'C','TRASLADO PARA PAGO DE CONTRATOS DE PRESTACION DE SERVICIOS, LIBRANZAS DE FEBRERO, CAJA MENOR DE MARZO, BIENESTAR SOCIAL, LIQUIDACION DE PRESTACIONES DE IDELFONSO',800037800),(210037,'1110050101','1110050102','1117964100','2021-03-18','05:18:52',4543145.00,'C','TRASLADO PARA PAGO DE CONTRATOS DE PRESTACION DE SERVICIOS, LIBRANZAS DE FEBRERO, CAJA MENOR DE MARZO, BIENESTAR SOCIAL, LIQUIDACION DE PRESTACIONES DE IDELFONSO',800037800),(210038,'1110050103','1110050102','1117964100','2021-03-18','05:19:33',5127723.00,'C','  TRASLADO PARA PAGO DE CONTRATOS DE PRESTACION DE SERVICIOS, LIBRANZAS DE FEBRERO, CAJA MENOR DE MARZO, BIENESTAR SOCIAL, LIQUIDACION DE PRESTACIONES DE IDELFONSO',800037800),(210039,'1110050210','1110050202','1117964100','2021-03-29','03:02:42',5500000.00,'C','REGISTRO DE TRASLADO COMO PRESTAMO INTERNO SEGUN RESOLUCION ADMINISTRATIVA N° 093 DE 2021 ',890300279),(210040,'1110050211','1110050202','1117964100','2021-03-29','03:03:37',18500000.00,'C',' REGISTRO DE TRASLADO COMO PRESTAMO INTERNO SEGUN RESOLUCION ADMINISTRATIVA N° 093 DE 2021 ',890300279),(210041,'1110050209','1110050202','1117964100','2021-03-29','03:04:12',27000000.00,'C','  REGISTRO DE TRASLADO COMO PRESTAMO INTERNO SEGUN RESOLUCION ADMINISTRATIVA N° 093 DE 2021',890300279),(210042,'1110050101','1110050102','1117964100','2021-03-29','04:00:06',20000000.00,'C',' REGISTRO DE TRASLADO COMO PRESTAMO INTERNO SEGUN RESOLUCION ADMINISTRATIVA N° 093 DE 2021',800037800),(210043,'1110050103','1110050102','1117964100','2021-03-29','04:00:48',12000000.00,'C','REGISTRO DE TRASLADO COMO PRESTAMO INTERNO SEGUN RESOLUCION ADMINISTRATIVA N° 093 DE 2021',800037800),(210044,'1110050104','1110050102','1117964100','2021-03-29','04:01:34',6000000.00,'C',' REGISTRO DE TRASLADO COMO PRESTAMO INTERNO SEGUN RESOLUCION ADMINISTRATIVA N° 093 DE 2021 ',800037800),(210045,'1110050104','1110050102','1117964100','2021-03-30','07:14:11',5485535.00,'C',' REGISTRO DE TRASLADO PAGO DE NOMINA ADMINISTRATIVA Y COMERCIAL',800037800),(210046,'1110050101','1110050102','1117964100','2021-03-30','07:16:52',2194214.00,'C',' REGISTRO DE TRASLADO PAGO DE NOMINA ADMINISTRATIVA Y COMERCIAL ',800037800),(210047,'1110050103','1110050102','1117964100','2021-03-30','07:17:43',3291321.00,'C','  REGISTRO DE TRASLADO PAGO DE NOMINA ADMINISTRATIVA Y COMERCIAL ',800037800),(210048,'1110050102','1110050104','1117964100','2021-03-31','07:18:49',2000000.00,'C','REGISTRO DE TRASLADO DEVOLUCION PRESTAMO INTERNO DE ENERGIA ',800037800),(210049,'1110050103','1110050102','1117964100','2021-04-09','04:38:48',15000000.00,'C','REGISTRO DE TRASLADO BANCARIO PARA PRESTAMO INTERNO SEGUN RESOLUCION ADMINISTRATIVO N° 103 DE 2021 ',800037800),(210050,'1110050104','1110050102','1117964100','2021-04-09','04:39:16',25000000.00,'C','REGISTRO DE TRASLADO BANCARIO PARA PRESTAMO INTERNO SEGUN RESOLUCION ADMINISTRATIVO N° 103 DE 2021  ',800037800),(210051,'1110050104','1110050102','1117964100','2021-03-31','11:35:11',186529.00,'C','TRASLADO PAGO DE CONTRATOS ',800037800),(210052,'1110050103','1110050101','1117964100','2021-04-29','01:33:54',2902496.00,'C','  TRASLADO PAGO DE NOMINA ADMINISTRATIVA Y COMERCIAL DE ABRIL   ',800037800),(210053,'1110050104','1110050101','1117964100','2021-04-29','01:39:53',4837493.00,'C','  TRASLADO PAGO DE NOMINA ADMINISTRATIVA Y COMERCIAL DE ABRIL  ',890300279),(210054,'1110050209','1110050202','1117543211','2021-04-29','03:48:54',35000000.00,'C','    TRASLADO DE RECURSOS SEGUN RESOLUCION ADMON N° 116 de 2021 ',800037800),(210055,'1110050104','1110050102','1117543211','2021-05-04','03:49:31',8662202.00,'C','  TRASLADO DE RECURSOS DE PAGOS DE CONTRATOS POR SERVICIOS DEL MES DE ABRIL 2021',800037800),(210056,'1110060107','1110050102','1117543211','2021-05-04','03:51:46',9492153.00,'C','  TRASLADO DE RETENCIONES Y RETEICA DE CONTRATO DE OBRA N003 DE 2020 CONVENIO DE ALCANTARILLADO',800037800),(210057,'1110050103','1110050102','1117964100','2021-05-04','04:49:54',5626407.00,'C',' TRASLADO DE RECURSOS DE PAGOS DE CONTRATOS POR SERVICIOS DEL MES DE ABRIL DE 2021 ',800037800),(210058,'1110050209','1110050202','1117964100','2021-05-04','04:52:31',5000000.00,'C','REGISTRO DE TRASLADO SEGUN RESOLUCION ADMINISTRATIVA N° 126 DE 2021 PRESTAMO INTERNO',890300279),(210059,'1110050210','1110050202','1117964100','2021-05-04','04:53:11',11000000.00,'C',' REGISTRO DE TRASLADO SEGUN RESOLUCION ADMINISTRATIVA N° 126 DE 2021 PRESTAMO INTERNO  ',890300279),(210060,'1110050211','1110050202','1117964100','2021-05-04','04:53:55',6000000.00,'C','  REGISTRO DE TRASLADO SEGUN RESOLUCION ADMINISTRATIVA N° 126 DE 2021 PRESTAMO INTERNO ',890300279),(210061,'1110050103','1110050102','1117964100','2021-05-10','10:27:10',1985983.00,'C','TRASLADO PAGO DE RETENCIONES DE LA DIAN  DEL MES DE ABRIL DE 2021',800037800),(210062,'1110050104','1110050102','1117964100','2021-05-10','10:27:39',1510530.00,'C','TRASLADO PAGO DE RETENCIONES DIAN DEL MES DE ABRIL DE 2021',800037800),(210063,'1110050101','1110050102','1117964100','2021-05-10','10:42:23',7058607.00,'C','TRASLADO PAGO DE RETENCIONES DIAN DEL MES DE ABRIL DE 2021 ',800037800),(210064,'1110050102','1110050202','1117964100','2021-05-11','11:08:31',19000000.00,'C',' REGISTRO DE TRASLADO ENTRE CUENTAS PARA PAGO DE RETENCIONES DE LA DIAN DE ABRIL DE 2021 ',800037800),(210065,'1110050101','1110050104','1117964100','2021-05-28','09:41:44',2172210.00,'C','TRASLADO PAGO DE NOMINA ADMINISTRATIVA Y COMERCIAL DE MAYO DE 2021 ',800037800),(210066,'1110050102','1110050104','1117964100','2021-05-28','07:40:27',10861052.00,'C','  TRASLADO PAGO DE NOMINA ADMINISTRATIVA Y COMERCIAL DE MAYO DE 2021',800037800),(210067,'1110050103','1110050104','1117964100','2021-05-28','07:44:30',3258315.00,'C','  TRASLADO PAGO DE NOMINA ADMINISTRATIVA Y COMERCIAL DE MAYO DE 2021',800037800),(210068,'1110050102','1110050101','1117964100','2021-05-28','07:46:01',6133550.00,'C',' TRASLADO PAGO DE CONTRATOS X SERVICIOS DE MAYO GIRADOS POR ALCANTARILLADO ',800037800),(210069,'1110050103','1110050101','1117964100','2021-05-28','07:46:29',4494350.00,'C','TRASLADO PAGO DE CONTRATOS X SERVICIOS DE MAYO GIRADOS POR ALCANTARILLADO   ',800037800),(210070,'1110050104','1110050101','1117964100','2021-05-28','07:46:56',4195578.00,'C','   TRASLADO PAGO DE CONTRATOS X SERVICIOS DE MAYO GIRADOS POR ALCANTARILLADO    ',800037800),(210071,'1110050103','1110050104','1117964100','2021-06-09','10:47:54',2298190.00,'C','TRASLADO PAGO DE CONTRATOS DE Y OBLIGACIONES A CORTE DE 09 DE JUNIO 2021',800037800),(210072,'1110050101','1110050104','1117964100','2021-06-09','10:48:42',1793487.00,'C','TRASLADO PAGO DE CONTRATOS Y OBLIGACIONES A CORTE DE 09 DE JUNIO DE 2021 ',800037800),(210073,'1110050102','1110050104','1117964100','2021-06-09','10:49:22',6322429.00,'C',' TRASLADO PAGO DE CONTRATOS Y OBLIGACIONES A CORTE DE 09 DE JUNIO DE 2021   ',800037800),(210074,'1110050202','1110050209','1117964100','2021-06-23','09:31:56',46432272.00,'C','REGISTRO DE TRASLADO DE RECURSOS DE TRIPLE A DEL MES DE MAYO DE 2021',890300279),(210075,'1110050202','1110050210','1117964100','2021-06-23','09:32:34',11931541.00,'C',' REGISTRO DE TRASLADO DE RECURSOS DE TRIPLE A DEL MES DE MAYO DE 2021   ',890300279),(210076,'1110050202','1110050211','1117964100','2021-06-23','09:33:07',31278793.00,'C',' REGISTRO DE TRASLADO DE RECURSOS DE TRIPLE A DEL MES DE MAYO DE 2021 ',890300279),(210077,'1110050202','1110050211','1117964100','2021-06-23','04:21:25',31278793.00,'C','DEVOLUCION DE RECUSROS DE PRESTAMOS INTERNOS',890300279),(210078,'1110050102','1110050101','1117964100','2021-06-25','04:22:27',10833675.00,'C','TRASLADO DE RECURSOS PARA PAGO DE CONTRATOS Y SEGURIDAD SOCIAL',800037800),(210079,'1110050104','1110050101','1117964100','2021-06-25','04:23:06',6092538.00,'C','TRASLADO DE RECURSOS PARA PAGO DE CONTRATOS Y SEGURIDAD SOCIAL  ',800037800),(210080,'1110050103','1110050101','1117964100','2021-06-25','04:23:40',3565639.00,'C','TRASLADO DE RECURSOS PARA PAGO DE CONTRATOS Y SEGURIDAD SOCIAL  ',800037800),(210081,'1110050211','1110050202','1117964100','2021-07-02','09:28:31',50000000.00,'C','TRASLADO PRESTAMO INTERNO ',890300279),(210082,'1110050209','1110050202','1117964100','2021-07-02','09:31:48',36000000.00,'C','REGISTRO DE PRETAMO INTERNO  ',890300279),(210083,'1110050210','1110050202','1117964100','2021-07-02','09:38:30',26000000.00,'C','TRASLADO PAGO PRESTAMO INTERNO  ',890300279),(210084,'1110050104','1110050102','1117964100','2021-07-01','09:41:28',8180046.00,'C','TRASLADO PAGO DE PRIMA DE SERVICIOS Y NOMINA DE JUNIO  ',800037800),(210085,'1110050101','1110050102','1117964100','2021-07-01','09:42:54',3392018.00,'C',' REGISTRO DE PAGO DE PRIMA DE SERVICIOS Y NOMINA DE JUNIO ',800037800),(210086,'1110050103','1110050102','1117964100','2021-07-01','09:44:07',5088028.00,'C','REGISTRO DE TRASLADO PAGO DE PRIMA DE SERVICIOS Y NOMINA DE JUNIO ',800037800),(210087,'1110050210','1110050202','1117964100','2021-07-08','11:43:57',1600000.00,'C','REGISTRO DE TRASLADO PARA PAGO DE RETENCIONES DIAN ',890300279),(210088,'1110050211','1110050202','1117964100','2021-07-08','11:44:46',2100000.00,'C','REGISRO DE TRASLADO PAGO DE RETENCIONES DIAN  ',890300279),(210089,'1110050209','1110050202','1117964100','2021-07-08','11:46:40',1900000.00,'C',' REGISTRO DE TRASLADO  PAGO DE RETENCIONES DIAN ',890300279),(210090,'1110050201','1110050202','1117964100','2021-07-08','11:55:41',3000000.00,'C',' REGISTRO DE TRASLADO PARA PAGOS OBLIGACIONES DE ENERGIA  ',890300279),(210091,'1110050101','1110050103','1117964100','2021-07-12','08:32:19',1599007.00,'C','REGISTRO DE TRASLADO PAGOS DE JULIO DE OBLIGACIONES Y CONTRATOS POR SERVICIOS',800037800),(210092,'1110050104','1110050103','1117964100','2021-07-12','08:32:51',3718212.00,'C','  REGISTRO DE TRASLADO PAGOS DE JULIO DE OBLIGACIONES Y CONTRATOS POR SERVICIOS',800037800),(210093,'1110050102','1110050103','1117964100','2021-07-12','08:33:18',5991893.00,'C','REGISTRO DE TRASLADO PAGOS DE JULIO DE OBLIGACIONES Y CONTRATOS POR SERVICIOS  ',800037800),(210094,'1110050103','1110050101','1117964100','2021-07-28','05:26:26',3463869.00,'C','REGISTRO DE TRASLADO PAGO DE NOMINA DE JULIO ADMINISTRATIVA Y COMERCIAL ',800037800),(210095,'1110050104','1110050101','1117964100','2021-07-28','05:26:53',5773116.00,'C','  REGISTRO DE TRASLADO PAGO DE NOMINA DE JULIO ADMINISTRATIVA Y COMERCIAL ',800037800),(210096,'1110050102','1110050101','1117964100','2021-07-28','05:27:11',11546233.00,'C','  REGISTRO DE TRASLADO PAGO DE NOMINA DE JULIO ADMINISTRATIVA Y COMERCIAL ',800037800),(210097,'1110050104','1110050104','1117964100','2021-08-06','03:45:42',0.00,'C','    ',800037800),(210098,'1110050210','1110050202','16189593','2021-08-23','11:21:52',1648860.00,'A','REGISTRO TRASLADO PAGO DE SEGURIDAD SOCIAL MES DE JULIO DE 2021',890300279),(210099,'1110050211','1110050202','16189593','2021-08-23','11:24:57',2473290.00,'A','REGISTRO TRASLADO POR PAGO DE LA SEGURIDAD SOCIAL DEL MES DE JULIO DE 2021',890300279),(210100,'1110050209','1110050202','16189593','2021-08-23','11:27:06',4122150.00,'A','  REGISTRO TRASLADO POR PAGO DE SEGURIDAD SOCIAL DEL MES DE JULIO DE 2021',890300279),(210101,'1110050101','1110050103','16189593','2021-08-23','04:49:34',779965.00,'C','TRASLADOS  POR VARIOS PAGOS REALIZADOS DESDE LA CUENTA DE ASEO ',0),(210102,'1110050104','1110050103','16189593','2021-08-23','04:51:33',1949914.25,'C','  REGISTRO DE TRASLADO POR VARIOS PAGOS REALIZADOS DESDE LA CUENTA DE ASEO ',0),(210103,'1110050102','1110050103','16189593','2021-08-23','04:53:21',6697577.50,'C','  REGISTRO DE TRASLADOS POR VARIOS PAGOS DE ENERGIA REALIZADOS DESDE LA CUENTA DE ASEO ',0),(210104,'1110050103','1110050102','1117964100','2021-10-06','04:28:50',10000000.00,'C','REGISTRO DE TRASLADO  ',800037800),(210105,'1110050104','1110050102','1117964100','2021-10-15','05:14:53',17200000.00,'C','REGISTRO DE TRASLADO PAGO DE FACTURA DE XM  ',800037800),(210106,'1110060107','1110050101','1117964100','2021-10-29','02:40:54',2165743.00,'C','REGISTRO DE TRASLADO DE RECURSOS DE RETENCIONY RETEICA  ',800037800),(210107,'1110060107','1110050101','1117964100','2021-10-29','01:31:27',219832.00,'C','REGISTRO DE TRASLADO DE RECURSOS DE ALCANTARILLADO ',800037800),(210108,'1110050209','1110050202','1117964100','2021-12-14','03:13:53',7444845.00,'C','REGISTRO DE TRASLADO PARA PAGO DE PRIMA ADMINISTRATIVA Y COMERCIAL',890300279),(210109,'1110050211','1110050202','1117964100','2021-12-14','03:14:36',4466907.00,'C','   REGISTRO DE TRASLADO PARA PAGO DE PRIMA ADMINISTRATIVA Y COMERCIAL ',890300279),(210110,'1110050210','1110050202','1117964100','2021-12-14','03:16:31',2977938.00,'C','  REGISTRO DE TRASLADO PARA PAGO DE PRIMA ADMINISTRATIVA Y COMERCIAL',890300279),(210111,'1110050209','1110050202','1117964100','2021-12-16','02:20:14',17000000.00,'C','REGISTRO DE TRASLADO PARA PAGO DE DICEL',890300279),(210112,'1110050211','1110050202','1117964100','2021-12-16','02:21:07',59000000.00,'C',' REGISTRO DE TRASLADO PARA PAGO DE DICEL ',890300279),(210113,'1110050210','1110050202','1117964100','2021-12-16','02:21:58',52000000.00,'C','REGISTRO DE TRASLADO PARA PAGO DE DICEL',890300279),(210114,'1110050104','1110050102','1117964100','2021-12-17','10:17:52',8500000.00,'C','REGISTRO DE TRASLADO DE PAGOS DE CONTRATOS PS Y LIBRANZAS ',800037800),(210115,'1110050102','11330802','1117964100','2021-12-24','08:59:37',22544500.00,'C','REGISTRO DE GARANTIA PROYECCION DEL MES DE ENERO 2022',800037800),(210116,'1110050201','11330802','1117964100','2021-12-28','01:43:12',57069260.00,'C','REGISTRO DE GARANTIA MENSUAL CON VENCIMIENTO A 28 DICIEMBRE',890300279),(220001,'1110050102','110502','1117964100','2022-01-07','05:03:33',4000000.00,'C','DESEMBOLSO DE CAJA MENOR DE ENERO 2022 ',800037800),(220002,'1110050202','1110060205','1117964100','2022-01-12','10:43:36',27804112.00,'C','REGISTRO DE TRASLADO DEVOLUCION DE RETENCIONES DIAN  ',890300279),(220003,'1110050209','1110050202','1117964100','2022-01-17','04:38:15',14000000.00,'C','REGISTRO DE TRASLADO PARA PAGO DE SERVICIOS BOCATOMA ',890300279),(220004,'1110050101','1110050102','1117964100','2022-01-17','04:39:58',20000000.00,'C','REGISTRO DE TRASLADO DE PRESTAMO DE ALCANTARILLADO PARA PAGO DE FACTURA DE DE XM  ',800037800),(220005,'1110060203','1110050202','1117964100','2022-01-17','04:41:03',9703143.64,'C','REGISTRO DE TRASLADO RECURSOS DE RETENCIONES  ',890300279),(220006,'1110050102','1110050202','1117964100','2022-01-20','11:03:37',5000000.00,'C','REGISTRO DE TRASLADO ENTRE CUENTAS DE ENERGIA PARA SUPLIR PAGO DE CONTRIBUCION DE ENERGIA SSPD  ',800037800);

--
-- Table structure for table `vehiculo`
--

CREATE TABLE `vehiculo` (
  `vh_nropla` char(6) NOT NULL DEFAULT '',
  `vh_codmar` int(3) NOT NULL DEFAULT '0',
  `vh_tipveh` int(3) NOT NULL DEFAULT '0',
  `vh_descri` char(40) NOT NULL DEFAULT '',
  `vh_modelo` int(4) NOT NULL DEFAULT '0',
  `vh_nromot` char(20) DEFAULT NULL,
  `vh_nrocha` char(20) DEFAULT NULL,
  `vh_nrotra` char(20) DEFAULT NULL,
  `vh_nrocol` char(20) DEFAULT NULL,
  `vh_nroint` char(6) NOT NULL DEFAULT '0',
  `vh_combus` char(1) NOT NULL DEFAULT '',
  `vh_kmact` decimal(8,2) DEFAULT NULL,
  `vh_hmact` decimal(8,2) DEFAULT NULL,
  `vh_codcli` bigint(12) NOT NULL DEFAULT '0',
  `vh_pasaje` int(3) NOT NULL,
  `vh_cermov` int(10) DEFAULT NULL,
  `vh_feccer` date DEFAULT NULL,
  `vh_segobl` char(10) DEFAULT NULL,
  `vh_fecseg` date DEFAULT NULL,
  `vh_estado` char(1) NOT NULL DEFAULT '',
  `vh_afilia` char(1) NOT NULL,
  `vh_base` char(1) NOT NULL,
  PRIMARY KEY (`vh_nropla`),
  KEY `vh_tipveh` (`vh_tipveh`),
  KEY `vh_codcli` (`vh_codcli`),
  KEY `vh_codmar` (`vh_codmar`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vehiculo`
--

INSERT INTO `vehiculo` (`vh_nropla`, `vh_codmar`, `vh_tipveh`, `vh_descri`, `vh_modelo`, `vh_nromot`, `vh_nrocha`, `vh_nrotra`, `vh_nrocol`, `vh_nroint`, `vh_combus`, `vh_kmact`, `vh_hmact`, `vh_codcli`, `vh_pasaje`, `vh_cermov`, `vh_feccer`, `vh_segobl`, `vh_fecseg`, `vh_estado`, `vh_afilia`, `vh_base`) VALUES ('-',1,0,'No Aplica',0,'1','1','1','1','0','',1.00,1.00,0,0,1,'2011-11-01','1','2011-11-01','I','I','I'),('3001',0,0,'CAJA MENOR - GESTION ADMINISTRATIVA',0,NULL,NULL,NULL,NULL,'0','',NULL,NULL,0,0,NULL,NULL,NULL,NULL,'','',''),('3002',0,0,'CAJA MENOR - TECNICA',0,NULL,NULL,NULL,NULL,'0','',NULL,NULL,0,0,NULL,NULL,NULL,NULL,'','','');

--
-- Dumping events for database 'antsoftw_chaira_contable2022_vigant'
--

--
-- Dumping routines for database 'antsoftw_chaira_contable2022_vigant'
--


