INSERT IGNORE INTO terceros(terid,codigo,dni,cedulade,naturalezater,nomtributario,tipodoc,apellidos,nombres,fecnaci,genero,direccion,telfijo,telmovil,ciudadid,zonaterid,gruposperid) VALUES('79709','222222222222','222222222222','','NAT','', 'CEC','FINAL','CONSUMIDOR','0000-00-00','M','', '0 ','3000000000','694','1','1') ,('74320','','','','NAT','', 'CED','','','0000-00-00','','', '','3002692042','694','1','1') ,('79709','222222222222','222222222222','','NAT','', 'CEC','FINAL','CONSUMIDOR','0000-00-00','M','', '0 ','3000000000','694','1','1') ,('74320','','','','NAT','', 'CED','','','0000-00-00','','', '','3002692042','694','1','1') ,('73264','22584486','22584486','','NAT','', 'CEC','ALBOR VARGAS','NINI JOHANA','1980-11-08','M','CALLE 45E NO.1C-27', '','3016781616','1021','1','1') ,('79709','222222222222','222222222222','','NAT','', 'CEC','FINAL','CONSUMIDOR','0000-00-00','M','', '0 ','3000000000','694','1','1') ,('368501','1234888543','1234888543','','NAT','', 'CED','QUINTERO MEJIA','BRAYAN ANDRES','0000-00-00','M','', '','3052848639','694','1','1') ,('79709','222222222222','222222222222','','NAT','', 'CEC','FINAL','CONSUMIDOR','0000-00-00','M','', '0 ','3000000000','694','1','1') ,('261099','1001937779','1001937779','','NAT','', 'CEC','ARROYO','ARIEL','0000-00-00','M','', '','3012897581','695','1','1') ,('79709','222222222222','222222222222','','NAT','', 'CEC','FINAL','CONSUMIDOR','0000-00-00','M','', '0 ','3000000000','694','1','1') ,('320834','72260140','72260140','','NAT','', 'CED','AGUILAR HERNáNDEZ ','DONALDO ANTONIO ','0000-00-00','M','', '','3043466830','694','1','1') ,('320834','72260140','72260140','','NAT','', 'CED','AGUILAR HERNáNDEZ ','DONALDO ANTONIO ','0000-00-00','M','', '','3043466830','694','1','1') ,('79709','222222222222','222222222222','','NAT','', 'CEC','FINAL','CONSUMIDOR','0000-00-00','M','', '0 ','3000000000','694','1','1') ,('140935','1129536178','1129536178','','NAT','', 'CC','MONTENEGRO ARIAS ','STEFANY PAOLA ','0000-00-00','M','CARRERA 46 H # 1 C - 22 SEGUNDO PISO BARRIO C/ 20 DE JULIO ', ' 3015099877','3015099877','694','1','1') ,('74320','','','','NAT','', 'CED','','','0000-00-00','','', '','3002692042','694','1','1') ,('79709','222222222222','222222222222','','NAT','', 'CEC','FINAL','CONSUMIDOR','0000-00-00','M','', '0 ','3000000000','694','1','1') ,('142075','72240684','72240684','','NAT','', 'CEC',' ARIZA','JIMMY ','0000-00-00','M','BLOQUE 185 APT 102', '','3160427699','695','1','1') ,('74320','','','','NAT','', 'CED','','','0000-00-00','','', '','3002692042','694','1','1') ,('79709','222222222222','222222222222','','NAT','', 'CEC','FINAL','CONSUMIDOR','0000-00-00','M','', '0 ','3000000000','694','1','1') ,('368487','1193484039','1193484039','','NAT','', 'CEC','MARIOTIS ','EDWIN ','0000-00-00','M','CRA 7 SUR # 46-51', '','3003663502','695','1','1') ,('79709','222222222222','222222222222','','NAT','', 'CEC','FINAL','CONSUMIDOR','0000-00-00','M','', '0 ','3000000000','694','1','1') ,('120195','1143134851','1143134851','','NAT','', 'CEC','MANRRIQUE','ANGIE','0000-00-00','M','CALLE 48 N 1A 4- 51 ciudadela piso 2', '','3212601236','695','1','1') ,('79709','222222222222','222222222222','','NAT','', 'CEC','FINAL','CONSUMIDOR','0000-00-00','M','', '0 ','3000000000','694','1','1') ,('79709','222222222222','222222222222','','NAT','', 'CEC','FINAL','CONSUMIDOR','0000-00-00','M','', '0 ','3000000000','694','1','1') ,('267132','32889737','32889737','','NAT','', 'CEC','GOMEZ','MARYORIS','0000-00-00','M','CRA 2 A **50 D - 32 CARRIZAL DETRAS DE LA CAPILLA', '','3008262313','695','1','1') ,('170368','1143170197','1143170197','','NAT','', 'CEC','ARIZA','EDUARDO ','0000-00-00','M','', '','3013273250','695','1','1') ,('74320','','','','NAT','', 'CED','','','0000-00-00','','', '','3002692042','694','1','1') ,('79709','222222222222','222222222222','','NAT','', 'CEC','FINAL','CONSUMIDOR','0000-00-00','M','', '0 ','3000000000','694','1','1') ,('294447','1044606417','1044606417','','NAT','', 'CEC','CAMACHO','CARLOS ','0000-00-00','M','', '','3023774707','695','1','1') ,('79709','222222222222','222222222222','','NAT','', 'CEC','FINAL','CONSUMIDOR','0000-00-00','M','', '0 ','3000000000','694','1','1') ,('338978','55246139','55246139','','NAT','', 'CEC','CASTILLO','YULIETH','0000-00-00','M','CALLE 45 D 3 - 55 CIUDADELA 20 JULIO', '','3246216985','695','1','1') ,('115547','26812413','26812413','','NAT','', 'CEC','SALA','TERESA','0000-00-00','M','calle 46 g n 1 c - 81', '','3114063131','695','1','1') ,('79709','222222222222','222222222222','','NAT','', 'CEC','FINAL','CONSUMIDOR','0000-00-00','M','', '0 ','3000000000','694','1','1')