INSERT IGNORE INTO terceros(codigo,dni,tipodoc,apellidos,nombres,telfijo,telmovil,ciudadid,zonaterid,gruposperid,escliente,creador,momento) VALUES('98','####98','CEC','VARIOS','TERCERO','','',1,1,1,'S','','2018-10-23 07:48:24'); *INSERT IGNORE INTO documentos(tipodoc,prefijo,numero,periodo,fechadoc,formapago,nrodocref,terid1,terid2,terid3,observacion,base,iva,total,impreso,totalitems,sucursalid,creador,momento) VALUES('PVP','F137','01305','122024','2024-12-11 00:00:00','CO','SUGERIDO',1,1,1,'PEDIDOSUGERIDOFECHAULTIMOPEDIDO',21056284157.34774,0,-2631490727.0216,'N',583691,149,'ADMINISTRADOR','2024-12-11 16:11:02'); |SELECTUNO|SELECT docuid FROM documentos WHERE CONCAT(tipodoc,prefijo,numero)='PVPF13701305' **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48019,317,47,2000,0,-1998000,0,-1998000,0,-1998000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,47205,317,4,9000,0,-8991000,0,-8991000,0,-8991000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33916,317,2,9000,0,-8991000,0,-8991000,0,-8991000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31632,317,20,10900,0,-10889100,0,-10889100,0,-10889100); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31223,317,1,12900,0,-12887100,0,-12887100,0,-12887100); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,52291,317,19,9100,0,-9090900,0,-9090900,0,-9090900); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48626,317,1,6300,0,-6293700,0,-6293700,0,-6293700); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,52184,317,4,2600,0,-2597400,0,-2597400,0,-2597400); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,45305,317,18,4000,0,-3996000,0,-3996000,0,-3996000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43221,317,1,35700,0,-35664300,0,-35664300,0,-35664300); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,26149,317,1,4500,0,-4495500,0,-4495500,0,-4495500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,40577,317,1,8900,0,-8891100,0,-8891100,0,-8891100); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,64548,317,13,18000,0,-17982000,0,-17982000,0,-17982000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,59529,317,4,31500,0,-31468500,0,-31468500,0,-31468500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,58101,317,2,51200,0,-51148800,0,-51148800,0,-51148800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,27762,317,1,3800,0,-3796200,0,-3796200,0,-3796200); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,58552,317,13,16000,0,-15984000,0,-15984000,0,-15984000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,40254,317,1,20600,0,-20579400,0,-20579400,0,-20579400); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55727,317,4,42900,0,-42857100,0,-42857100,0,-42857100); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,52774,317,9,4500,0,-4495500,0,-4495500,0,-4495500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63246,317,6,18900,0,-18881100,0,-18881100,0,-18881100); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,23598,317,4,24800,0,-24775200,0,-24775200,0,-24775200); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63582,317,5,18000,0,-17982000,0,-17982000,0,-17982000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,58459,317,2,8000,0,-7992000,0,-7992000,0,-7992000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,40411,317,3,4600,0,-4595400,0,-4595400,0,-4595400); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,23704,317,1,19500,0,-19480500,0,-19480500,0,-19480500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,47206,317,3,9000,0,-8991000,0,-8991000,0,-8991000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,49898,317,1,15500,0,-15484500,0,-15484500,0,-15484500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,62082,317,5,2000,0,-1998000,0,-1998000,0,-1998000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,42930,317,1,7900,0,-7892100,0,-7892100,0,-7892100); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,38407,317,4,1200,0,-1198800,0,-1198800,0,-1198800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,29928,317,1,10600,0,-10589400,0,-10589400,0,-10589400); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,50903,317,5,6900,0,-6893100,0,-6893100,0,-6893100); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,45901,317,8,16000,0,-15984000,0,-15984000,0,-15984000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,34317,317,1,24500,0,-24475500,0,-24475500,0,-24475500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,24361,317,4,8500,0,-8491500,0,-8491500,0,-8491500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63745,317,3,9600,0,-9590400,0,-9590400,0,-9590400); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54055,317,2,41000,0,-40959000,0,-40959000,0,-40959000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55214,317,4,11200,0,-11188800,0,-11188800,0,-11188800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,51245,317,4,1700,0,-1698300,0,-1698300,0,-1698300); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54712,317,2,8600,0,-8591400,0,-8591400,0,-8591400); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,39998,317,4,15300,0,-15284700,0,-15284700,0,-15284700); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54477,317,2,27500,0,-27472500,0,-27472500,0,-27472500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,49879,317,2,14900,0,-14885100,0,-14885100,0,-14885100); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,40253,317,2,63400,0,-63336600,0,-63336600,0,-63336600); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,49673,317,1,22500,0,-22477500,0,-22477500,0,-22477500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31567,317,2,16400,0,-16383600,0,-16383600,0,-16383600); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,39156,317,3,17100,0,-17082900,0,-17082900,0,-17082900); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,23810,317,2,12100,0,-12087900,0,-12087900,0,-12087900); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63593,317,2,25000,0,-24975000,0,-24975000,0,-24975000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,64514,317,2,14400,0,-14385600,0,-14385600,0,-14385600); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43283,317,3,114400,0,-114285600,0,-114285600,0,-114285600); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43430,317,1,17900,0,-17882100,0,-17882100,0,-17882100); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,44821,317,3,12300,0,-12287700,0,-12287700,0,-12287700); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53948,317,2,33000,0,-32967000,0,-32967000,0,-32967000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,30324,317,1,14300,0,-14285700,0,-14285700,0,-14285700); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,42561,317,2,1900,0,-1898100,0,-1898100,0,-1898100); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,58109,317,2,48800,0,-48751200,0,-48751200,0,-48751200); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,46328,317,2,25000,0,-24975000,0,-24975000,0,-24975000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,40145,317,2,5000,0,-4995000,0,-4995000,0,-4995000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,42897,317,2,18800,0,-18781200,0,-18781200,0,-18781200); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54769,317,4,34500,0,-34465500,0,-34465500,0,-34465500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,62566,317,3,35000,0,-34965000,0,-34965000,0,-34965000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48567,317,1,4500,0,-4495500,0,-4495500,0,-4495500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,45621,317,1,18500,0,-18481500,0,-18481500,0,-18481500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,41552,317,1,23200,0,-23176800,0,-23176800,0,-23176800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33371,317,3,7300,0,-7292700,0,-7292700,0,-7292700); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48303,317,1,30000,0,-29970000,0,-29970000,0,-29970000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,51290,317,1,18900,0,-18881100,0,-18881100,0,-18881100); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,61819,317,2,5000,0,-4995000,0,-4995000,0,-4995000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,51304,317,1,33100,0,-33066900,0,-33066900,0,-33066900); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,26023,317,2,9200,0,-9190800,0,-9190800,0,-9190800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,40264,317,1,14700,0,-14685300,0,-14685300,0,-14685300); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54346,317,2,6100,0,-6093900,0,-6093900,0,-6093900); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,27248,317,1,12000,0,-11988000,0,-11988000,0,-11988000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53092,317,3,22800,0,-22777200,0,-22777200,0,-22777200); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,57023,317,1,25200,0,-25174800,0,-25174800,0,-25174800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,32981,317,2,48200,0,-48151800,0,-48151800,0,-48151800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31233,317,2,10600,0,-10589400,0,-10589400,0,-10589400); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,45848,317,3,12100,0,-12087900,0,-12087900,0,-12087900); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,56752,317,2,78600,0,-78521400,0,-78521400,0,-78521400); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48228,317,2,31000,0,-30969000,0,-30969000,0,-30969000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,28062,317,3,11900,0,-11888100,0,-11888100,0,-11888100); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,52361,317,2,83000,0,-82917000,0,-82917000,0,-82917000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,40129,317,2,5000,0,-4995000,0,-4995000,0,-4995000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,56126,317,2,4900,0,-4895100,0,-4895100,0,-4895100); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,25929,317,1,36500,0,-36463500,0,-36463500,0,-36463500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55210,317,1,8200,0,-8191800,0,-8191800,0,-8191800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,56561,317,2,14900,0,-14885100,0,-14885100,0,-14885100); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33251,317,1,19000,0,-18981000,0,-18981000,0,-18981000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,51308,317,1,13400,0,-13386600,0,-13386600,0,-13386600); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,52312,317,1,5200,0,-5194800,0,-5194800,0,-5194800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,41708,317,2,11200,0,-11188800,0,-11188800,0,-11188800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,64634,317,2,3200,0,-3196800,0,-3196800,0,-3196800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,46912,317,3,11900,0,-11888100,0,-11888100,0,-11888100); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,32586,317,1,78300,0,-78221700,0,-78221700,0,-78221700); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,57267,317,1,26200,0,-26173800,0,-26173800,0,-26173800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,28134,317,2,23300,0,-23276700,0,-23276700,0,-23276700); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,49748,317,1,28200,0,-28171800,0,-28171800,0,-28171800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,61831,317,1,149000,0,-148851000,0,-148851000,0,-148851000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,64088,317,1,2200,0,-2197800,0,-2197800,0,-2197800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55878,317,1,27500,0,-27472500,0,-27472500,0,-27472500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,41317,317,1,20000,0,-19980000,0,-19980000,0,-19980000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,28153,317,2,45000,0,-44955000,0,-44955000,0,-44955000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,46879,317,1,17500,0,-17482500,0,-17482500,0,-17482500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,24460,317,2,10200,0,-10189800,0,-10189800,0,-10189800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,29934,317,1,26500,0,-26473500,0,-26473500,0,-26473500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53723,317,1,3500,0,-3496500,0,-3496500,0,-3496500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,30597,317,1,25500,0,-25474500,0,-25474500,0,-25474500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,59650,317,2,51200,0,-51148800,0,-51148800,0,-51148800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,45830,317,2,66000,0,-65934000,0,-65934000,0,-65934000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,30756,317,1,12500,0,-12487500,0,-12487500,0,-12487500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,42082,317,1,74000,0,-73926000,0,-73926000,0,-73926000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,56802,317,1,23800,0,-23776200,0,-23776200,0,-23776200); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,30332,317,1,26200,0,-26173800,0,-26173800,0,-26173800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54174,317,1,11500,0,-11488500,0,-11488500,0,-11488500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,57224,317,1,16900,0,-16883100,0,-16883100,0,-16883100); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,44301,317,1,29300,0,-29270700,0,-29270700,0,-29270700); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33925,317,1,26000,0,-25974000,0,-25974000,0,-25974000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,60273,317,1,20900,0,20900,0,20900,0,20900); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,56390,317,0.5,36100,0,18050,0,18050,0,18050); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55624,317,4,4000,0,16000,0,16000,0,16000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,51593,317,1.3333333333334,25000,0,33333.333333336,0,33333.333333336,0,33333.333333336); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,22277,317,1,9600,0,9600,0,9600,0,9600); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,22283,317,2,10100,0,20200,0,20200,0,20200); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33849,317,2,11900,0,23800,0,23800,0,23800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,45306,317,2,7000,0,14000,0,14000,0,14000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53074,317,1.375,26100,0,35887.5,0,35887.5,0,35887.5); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31151,317,0.099999999999997,25000,0,2499.9999999999,0,2499.9999999999,0,2499.9999999999); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,41855,317,1.8,80000,0,144000,0,144000,0,144000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,40279,317,2,2400,0,4800,0,4800,0,4800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,47968,317,3,19100,0,57300,0,57300,0,57300); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,51483,317,1,14000,0,14000,0,14000,0,14000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,46638,317,1,21400,0,21400,0,21400,0,21400); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,46776,317,1.3333333333334,34200,0,45600.000000003,0,45600.000000003,0,45600.000000003); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,49874,317,0.5,17900,0,8950,0,8950,0,8950); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53835,317,1.5,23000,0,34499.999999999,0,34499.999999999,0,34499.999999999); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31190,317,0.59999999999996,35000,0,20999.999999998,0,20999.999999998,0,20999.999999998); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31189,317,1,9000,0,9000,0,9000,0,9000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,27603,317,1,28900,0,28900,0,28900,0,28900); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55176,317,1,6700,0,6700,0,6700,0,6700); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,51922,317,1,16500,0,16500,0,16500,0,16500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,36528,317,1,5800,0,5800,0,5800,0,5800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53718,317,1,29900,0,29900,0,29900,0,29900); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54056,317,0.7,46000,0,32200,0,32200,0,32200); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,58075,317,2,14900,0,29800,0,29800,0,29800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63957,317,2,2900,0,5800,0,5800,0,5800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48643,317,1.5,36000,0,54000.000000001,0,54000.000000001,0,54000.000000001); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,46744,317,1,8000,0,8000,0,8000,0,8000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,40346,317,1,10900,0,10900,0,10900,0,10900); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31759,317,0.84999999205261,94000,0,79899.999252945,0,79899.999252945,0,79899.999252945); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,37241,317,0.9444444212649,91000,0,85944.442335106,0,85944.442335106,0,85944.442335106); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55343,317,0.0000000000000039968028886506,73400,0,0.00000000029336533202695,0,0.00000000029336533202695,0,0.00000000029336533202695); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53836,317,1,20700,0,20700,0,20700,0,20700); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53652,317,0.66666666666672,57000,0,38000.000000003,0,38000.000000003,0,38000.000000003); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,58217,317,1,28900,0,28900,0,28900,0,28900); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54285,317,0.0000000000000018596235662471,51900,0,0.000000000096514463088226,0,0.000000000096514463088226,0,0.000000000096514463088226); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53776,317,0.37500000000001,57600,0,21600.000000001,0,21600.000000001,0,21600.000000001); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31350,317,1,38500,0,38500,0,38500,0,38500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31597,317,0.33333333333334,15500,0,5166.6666666668,0,5166.6666666668,0,5166.6666666668); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,25785,317,0.45833333333335,63500,0,29104.166666668,0,29104.166666668,0,29104.166666668); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33638,317,0.75000000000001,33000,0,24750,0,24750,0,24750); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,52030,317,1.0000000059605,120000,0,120000.00071526,0,120000.00071526,0,120000.00071526); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,58014,317,0.02,140000,0,2800,0,2800,0,2800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,46495,317,1,39900,0,39900,0,39900,0,39900); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55995,317,0.16666667163396,68000,0,11333.333671109,0,11333.333671109,0,11333.333671109); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,49672,317,1.2916666716338,87000,0,112375.00043214,0,112375.00043214,0,112375.00043214); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63956,317,0.2,27000,0,5400,0,5400,0,5400); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,29739,317,0.70000000149012,36000,0,25200.000053644,0,25200.000053644,0,25200.000053644); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,38852,317,0.60000000298023,74500,0,44700.000222027,0,44700.000222027,0,44700.000222027); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48571,317,0.4,75800,0,30320,0,30320,0,30320); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,38577,317,0.56666666666665,90000,0,50999.999999999,0,50999.999999999,0,50999.999999999); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,46090,317,0.70833333333334,102500,0,72604.166666667,0,72604.166666667,0,72604.166666667); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43524,317,0.30999999999999,138000,0,42779.999999998,0,42779.999999998,0,42779.999999998); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,62346,317,0.83333341280624,60000,0,50000.004768374,0,50000.004768374,0,50000.004768374); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55782,317,0.73333336065179,127400,0,93426.670147038,0,93426.670147038,0,93426.670147038); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55996,317,0.99999999999998,67500,0,67499.999999998,0,67499.999999998,0,67499.999999998); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,62763,317,0.46666666666668,90000,0,42000.000000002,0,42000.000000002,0,42000.000000002); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,42788,317,0.000000000000029976021664879,16100,0,0.00000000048261394880456,0,0.00000000048261394880456,0,0.00000000048261394880456); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,42804,317,0.7,30000,0,21000,0,21000,0,21000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43254,317,0.66666666666666,18100,0,12066.666666667,0,12066.666666667,0,12066.666666667); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43255,317,0.10000000149012,397700,0,39770.000592619,0,39770.000592619,0,39770.000592619); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43299,317,1,16300,0,16300,0,16300,0,16300); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43331,317,0.5,30400,0,15200,0,15200,0,15200); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,40282,317,1,3400,0,3400,0,3400,0,3400); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,26533,317,0.44,122000,0,53680,0,53680,0,53680); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63445,317,0.79,169000,0,133510,0,133510,0,133510); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,39002,317,0.88888888888889,143100,0,127200,0,127200,0,127200); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,51646,317,0.83333333333333,138200,0,115166.66666667,0,115166.66666667,0,115166.66666667); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33960,317,1,5900,0,5900,0,5900,0,5900); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,49253,317,0.000000000000025091040356529,49800,0,0.0000000012495338097551,0,0.0000000012495338097551,0,0.0000000012495338097551); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31060,317,0.33333333333333,49800,0,16600,0,16600,0,16600); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,59982,317,0.083333333333333,33500,0,2791.6666666667,0,2791.6666666667,0,2791.6666666667); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,58519,317,0.46153846153846,77000,0,35538.461538461,0,35538.461538461,0,35538.461538461); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,49428,317,0.75,13600,0,10200,0,10200,0,10200); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,47984,317,0.083333333333333,89800,0,7483.3333333333,0,7483.3333333333,0,7483.3333333333); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43244,317,0.23999999731779,215500,0,51719.999421984,0,51719.999421984,0,51719.999421984); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,42818,317,0.50000000596046,123000,0,61500.000733137,0,61500.000733137,0,61500.000733137); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33778,317,0.000000000000019706458687097,31200,0,0.00000000061484151103741,0,0.00000000061484151103741,0,0.00000000061484151103741); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,42994,317,0.24,160000,0,38400,0,38400,0,38400); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54483,317,0.99999999999999,79500,0,79499.999999999,0,79499.999999999,0,79499.999999999); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54384,317,1.3333333333334,48000,0,64000.000000004,0,64000.000000004,0,64000.000000004); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33646,317,1,17500,0,17500,0,17500,0,17500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63441,317,0.37500000000001,60000,0,22500.000000001,0,22500.000000001,0,22500.000000001); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63438,317,0.12500000000001,60000,0,7500.0000000003,0,7500.0000000003,0,7500.0000000003); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63439,317,0.000000000000042854608750531,60000,0,0.0000000025712765250319,0,0.0000000025712765250319,0,0.0000000025712765250319); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,61315,317,1.5,72000,0,108000,0,108000,0,108000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48941,317,0.000000000000027977620220554,30000,0,0.00000000083932860661662,0,0.00000000083932860661662,0,0.00000000083932860661662); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,58540,317,0.6,47000,0,28200,0,28200,0,28200); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54448,317,0.33333333333333,64900,0,21633.333333333,0,21633.333333333,0,21633.333333333); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43550,317,0.52,170000,0,88400,0,88400,0,88400); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,44302,317,0.50000000298023,86900,0,43450.000258982,0,43450.000258982,0,43450.000258982); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,23597,317,1,16500,0,16500,0,16500,0,16500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,23587,317,0.22222222222226,24100,0,5355.5555555564,0,5355.5555555564,0,5355.5555555564); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,27599,317,1.6,36300,0,58080,0,58080,0,58080); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,23590,317,0.99999999999999,15000,0,15000,0,15000,0,15000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,23616,317,0.35,29000,0,10150,0,10150,0,10150); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43118,317,1,8500,0,8500,0,8500,0,8500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,42970,317,1,25500,0,25500,0,25500,0,25500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43290,317,0.040000000000003,135000,0,5400.0000000005,0,5400.0000000005,0,5400.0000000005); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,61384,317,0.81818181818181,63800,0,52200,0,52200,0,52200); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,52086,317,0.25,13000,0,3250,0,3250,0,3250); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,26221,317,0.33333335320151,69600,0,23200.001382825,0,23200.001382825,0,23200.001382825); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,59285,317,1,18000,0,18000,0,18000,0,18000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,58546,317,0.75,21000,0,15750,0,15750,0,15750); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,59286,317,0.3333333333334,45000,0,15000.000000003,0,15000.000000003,0,15000.000000003); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,28973,317,0.25,91500,0,22875,0,22875,0,22875); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,41900,317,0.50000000000001,55200,0,27600,0,27600,0,27600); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,26707,317,0.58333333333334,92400,0,53900,0,53900,0,53900); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43765,317,1,4000,0,4000,0,4000,0,4000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,42934,317,1,28500,0,28500,0,28500,0,28500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,61606,317,1,45000,0,45000,0,45000,0,45000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43180,317,0.031250000000003,172800,0,5400.0000000005,0,5400.0000000005,0,5400.0000000005); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33743,317,0.58333333333334,69900,0,40775,0,40775,0,40775); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43182,317,0.031249999999967,172800,0,5399.9999999943,0,5399.9999999943,0,5399.9999999943); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,46626,317,0.89999999999999,151500,0,136350,0,136350,0,136350); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,47982,317,0.125,64800,0,8100.0000000001,0,8100.0000000001,0,8100.0000000001); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,58898,317,1.2666666666667,64500,0,81700.000000002,0,81700.000000002,0,81700.000000002); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53109,317,0.5,17900,0,8950,0,8950,0,8950); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43398,317,1,14500,0,14500,0,14500,0,14500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,22930,317,0.69999999999999,41000,0,28700,0,28700,0,28700); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,25501,317,1,4600,0,4600,0,4600,0,4600); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,59322,317,7,18000,0,126000,0,126000,0,126000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48361,317,1,4700,0,4700,0,4700,0,4700); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,47117,317,3,3500,0,10500,0,10500,0,10500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,60600,317,1,13000,0,13000,0,13000,0,13000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,61312,317,3,18900,0,56700,0,56700,0,56700); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,22941,317,1,44100,0,44100,0,44100,0,44100); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,46895,317,0.26666666666666,66600,0,17760,0,17760,0,17760); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,22880,317,0.52,60100,0,31252,0,31252,0,31252); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,23577,317,1.6,34000,0,54400,0,54400,0,54400); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,45886,317,1,24800,0,24800,0,24800,0,24800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,27765,317,1,9400,0,9400,0,9400,0,9400); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,59893,317,1,12600,0,12600,0,12600,0,12600); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,46696,317,0.70000009536744,81200,0,56840.007743836,0,56840.007743836,0,56840.007743836); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,22858,317,0.375,23600,0,8850,0,8850,0,8850); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,38414,317,1,118900,0,118900,0,118900,0,118900); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,41897,317,0.041666666666667,55200,0,2300,0,2300,0,2300); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,61483,317,1,88000,0,88000,0,88000,0,88000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,64954,317,3,10000,0,30000,0,30000,0,30000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,64959,317,5,37500,0,187500,0,187500,0,187500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,52526,317,1.3333333333333,9000,0,11999.999999999,0,11999.999999999,0,11999.999999999); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,62506,317,0.49999999337727,75600,0,37799.999499321,0,37799.999499321,0,37799.999499321); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,52330,317,1,126900,0,126900,0,126900,0,126900); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,22870,317,0.76000000089407,110000,0,83600.000098348,0,83600.000098348,0,83600.000098348); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63339,317,1,8500,0,8500,0,8500,0,8500);