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','F237','01278','012025','2025-01-15 00:00:00','CO','SUGERIDO',1,1,1,'PEDIDOSUGERIDOFECHAULTIMOPEDIDO',20606009697.73196,0,-3198128573.0557,'N',565426,255,'ADMINISTRADOR','2025-01-15 07:59:54');
|SELECTUNO|SELECT docuid FROM documentos WHERE CONCAT(tipodoc,prefijo,numero)='PVPF23701278'
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48019,443,28,2200,0,-2197800,0,-2197800,0,-2197800);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,62932,443,15,10500,0,-10489500,0,-10489500,0,-10489500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,40591,443,31,3300,0,-3296700,0,-3296700,0,-3296700);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31223,443,13,12900,0,-12887100,0,-12887100,0,-12887100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31293,443,2,5900,0,-5894100,0,-5894100,0,-5894100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31151,443,2,25000,0,-24975000,0,-24975000,0,-24975000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55720,443,3,9600,0,-9590400,0,-9590400,0,-9590400);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,56917,443,19,9900,0,-9890100,0,-9890100,0,-9890100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43224,443,1,42900,0,-42857100,0,-42857100,0,-42857100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,30936,443,1,15100,0,-15084900,0,-15084900,0,-15084900);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63778,443,29,22500,0,-22477500,0,-22477500,0,-22477500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,47206,443,7,9000,0,-8991000,0,-8991000,0,-8991000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48361,443,1,4700,0,-4695300,0,-4695300,0,-4695300);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,26537,443,1,16200,0,-16183800,0,-16183800,0,-16183800);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,62082,443,16,2000,0,-1998000,0,-1998000,0,-1998000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53417,443,23,30000,0,-29970000,0,-29970000,0,-29970000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,22277,443,9,9600,0,-9590400,0,-9590400,0,-9590400);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33749,443,3,12500,0,-12487500,0,-12487500,0,-12487500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55727,443,2,42900,0,-42857100,0,-42857100,0,-42857100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31629,443,2,5500,0,-5494500,0,-5494500,0,-5494500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,47117,443,1,3500,0,-3496500,0,-3496500,0,-3496500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,58552,443,2,16000,0,-15984000,0,-15984000,0,-15984000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,64548,443,10,18000,0,-17982000,0,-17982000,0,-17982000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,49200,443,13,18000,0,-17982000,0,-17982000,0,-17982000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,59529,443,2,31500,0,-31468500,0,-31468500,0,-31468500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63339,443,21,9000,0,-8991000,0,-8991000,0,-8991000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,42905,443,2,2000,0,-1998000,0,-1998000,0,-1998000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,45904,443,5,10000,0,-9990000,0,-9990000,0,-9990000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,42931,443,2,19700,0,-19680300,0,-19680300,0,-19680300);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,46914,443,3,10900,0,-10889100,0,-10889100,0,-10889100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,22275,443,6,9600,0,-9590400,0,-9590400,0,-9590400);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54476,443,11,34500,0,-34465500,0,-34465500,0,-34465500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,52526,443,3,9000,0,-8991000,0,-8991000,0,-8991000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,26149,443,12,4500,0,-4495500,0,-4495500,0,-4495500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33646,443,7,18300,0,-18281700,0,-18281700,0,-18281700);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43316,443,5,4000,0,-3996000,0,-3996000,0,-3996000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,23600,443,6,10000,0,-9990000,0,-9990000,0,-9990000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55211,443,2,8500,0,-8491500,0,-8491500,0,-8491500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54056,443,1,46000,0,-45954000,0,-45954000,0,-45954000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31300,443,2,8500,0,-8491500,0,-8491500,0,-8491500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31567,443,1,16400,0,-16383600,0,-16383600,0,-16383600);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,57265,443,3,19500,0,-19480500,0,-19480500,0,-19480500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43523,443,5,19900,0,-19880100,0,-19880100,0,-19880100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,38369,443,2,28900,0,-28871100,0,-28871100,0,-28871100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,40383,443,5,3800,0,-3796200,0,-3796200,0,-3796200);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53264,443,3,4500,0,-4495500,0,-4495500,0,-4495500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,57132,443,6,5900,0,-5894100,0,-5894100,0,-5894100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,24361,443,1,8500,0,-8491500,0,-8491500,0,-8491500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,50903,443,11,6900,0,-6893100,0,-6893100,0,-6893100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54055,443,8,41000,0,-40959000,0,-40959000,0,-40959000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31773,443,4,6500,0,-6493500,0,-6493500,0,-6493500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,34273,443,3,24500,0,-24475500,0,-24475500,0,-24475500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,40614,443,6,35000,0,-34965000,0,-34965000,0,-34965000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43226,443,3,47100,0,-47052900,0,-47052900,0,-47052900);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,44961,443,3,3500,0,-3496500,0,-3496500,0,-3496500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,59332,443,8,24900,0,-24875100,0,-24875100,0,-24875100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33276,443,3,29500,0,-29470500,0,-29470500,0,-29470500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,28686,443,1,13500,0,-13486500,0,-13486500,0,-13486500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,45911,443,1,22500,0,-22477500,0,-22477500,0,-22477500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63738,443,3,10500,0,-10489500,0,-10489500,0,-10489500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54754,443,1,12200,0,-12187800,0,-12187800,0,-12187800);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55304,443,4,90000,0,-89910000,0,-89910000,0,-89910000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,40282,443,3,3400,0,-3396600,0,-3396600,0,-3396600);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33960,443,9,5900,0,-5894100,0,-5894100,0,-5894100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,42902,443,4,9800,0,-9790200,0,-9790200,0,-9790200);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,57023,443,3,25200,0,-25174800,0,-25174800,0,-25174800);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,45889,443,5,15500,0,-15484500,0,-15484500,0,-15484500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,49419,443,1,4800,0,-4795200,0,-4795200,0,-4795200);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,60549,443,3,7300,0,-7292700,0,-7292700,0,-7292700);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48906,443,1,71500,0,-71428500,0,-71428500,0,-71428500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31232,443,3,13900,0,-13886100,0,-13886100,0,-13886100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48067,443,2,17100,0,-17082900,0,-17082900,0,-17082900);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,51245,443,1,1700,0,-1698300,0,-1698300,0,-1698300);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,57026,443,5,22900,0,-22877100,0,-22877100,0,-22877100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,40629,443,2,16000,0,-15984000,0,-15984000,0,-15984000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53453,443,2,16200,0,-16183800,0,-16183800,0,-16183800);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,40564,443,2,7000,0,-6993000,0,-6993000,0,-6993000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,58868,443,2,14500,0,-14485500,0,-14485500,0,-14485500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43118,443,3,8500,0,-8491500,0,-8491500,0,-8491500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,60314,443,5,10700,0,-10689300,0,-10689300,0,-10689300);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,40264,443,2,14700,0,-14685300,0,-14685300,0,-14685300);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,60971,443,3,12000,0,-11988000,0,-11988000,0,-11988000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,57659,443,1,26300,0,-26273700,0,-26273700,0,-26273700);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,23810,443,1,12100,0,-12087900,0,-12087900,0,-12087900);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54769,443,1,34500,0,-34465500,0,-34465500,0,-34465500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,49874,443,2,19300,0,-19280700,0,-19280700,0,-19280700);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48228,443,6,31000,0,-30969000,0,-30969000,0,-30969000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48931,443,1,3000,0,-2997000,0,-2997000,0,-2997000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48567,443,1,4500,0,-4495500,0,-4495500,0,-4495500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,27772,443,2,2900,0,-2897100,0,-2897100,0,-2897100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,47596,443,1,3700,0,-3696300,0,-3696300,0,-3696300);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48112,443,1,98500,0,-98401500,0,-98401500,0,-98401500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,27765,443,1,9400,0,-9390600,0,-9390600,0,-9390600);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48351,443,1,10000,0,-9990000,0,-9990000,0,-9990000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,46472,443,2,23500,0,-23476500,0,-23476500,0,-23476500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43524,443,3,138000,0,-137862000,0,-137862000,0,-137862000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,60273,443,1,20900,0,-20879100,0,-20879100,0,-20879100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,52165,443,4,16900,0,-16883100,0,-16883100,0,-16883100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,50088,443,1,2000,0,-1998000,0,-1998000,0,-1998000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,56017,443,3,13900,0,-13886100,0,-13886100,0,-13886100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54112,443,3,7600,0,-7592400,0,-7592400,0,-7592400);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53650,443,1,18500,0,-18481500,0,-18481500,0,-18481500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,26067,443,1,4500,0,-4495500,0,-4495500,0,-4495500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,23835,443,1,12500,0,-12487500,0,-12487500,0,-12487500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43298,443,2,8500,0,-8491500,0,-8491500,0,-8491500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,42153,443,2,19000,0,-18981000,0,-18981000,0,-18981000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,26243,443,2,28000,0,-27972000,0,-27972000,0,-27972000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,39150,443,2,17100,0,-17082900,0,-17082900,0,-17082900);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54910,443,2,17300,0,-17282700,0,-17282700,0,-17282700);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,40272,443,2,1900,0,-1898100,0,-1898100,0,-1898100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,45895,443,1,30500,0,-30469500,0,-30469500,0,-30469500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,23820,443,2,15500,0,-15484500,0,-15484500,0,-15484500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,60937,443,1,14900,0,-14885100,0,-14885100,0,-14885100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53527,443,2,15300,0,-15284700,0,-15284700,0,-15284700);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,44821,443,1,12300,0,-12287700,0,-12287700,0,-12287700);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,46789,443,2,10400,0,-10389600,0,-10389600,0,-10389600);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,62609,443,2,17800,0,-17782200,0,-17782200,0,-17782200);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53652,443,1,57000,0,-56943000,0,-56943000,0,-56943000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,25099,443,2,34900,0,-34865100,0,-34865100,0,-34865100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,42901,443,2,41700,0,-41658300,0,-41658300,0,-41658300);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,44215,443,2,9800,0,-9790200,0,-9790200,0,-9790200);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,40842,443,2,22800,0,-22777200,0,-22777200,0,-22777200);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,46696,443,1,83000,0,-82917000,0,-82917000,0,-82917000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43183,443,1,21300,0,-21278700,0,-21278700,0,-21278700);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,41780,443,1,23500,0,-23476500,0,-23476500,0,-23476500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,22304,443,1,89900,0,-89810100,0,-89810100,0,-89810100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,61607,443,1,88000,0,-87912000,0,-87912000,0,-87912000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54673,443,2,67500,0,-67432500,0,-67432500,0,-67432500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33409,443,2,11900,0,-11888100,0,-11888100,0,-11888100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,49164,443,1,41400,0,-41358600,0,-41358600,0,-41358600);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,26593,443,1,46900,0,-46853100,0,-46853100,0,-46853100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54066,443,1,10100,0,-10089900,0,-10089900,0,-10089900);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63960,443,1,24800,0,-24775200,0,-24775200,0,-24775200);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48369,443,1,53500,0,-53446500,0,-53446500,0,-53446500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,22278,443,3,9600,0,28800,0,28800,0,28800);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55721,443,6,9600,0,57600,0,57600,0,57600);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,52291,443,2,9100,0,18200,0,18200,0,18200);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,51643,443,1,13200,0,13200,0,13200,0,13200);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31190,443,0.19999999701946,35000,0,6999.999895681,0,6999.999895681,0,6999.999895681);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,44839,443,1,9900,0,9900,0,9900,0,9900);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33555,443,0.1,76700,0,7670.0000000001,0,7670.0000000001,0,7670.0000000001);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,25785,443,0.041666666666671,63500,0,2645.8333333336,0,2645.8333333336,0,2645.8333333336);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,29739,443,4.4408920985006e-16,45000,0,0.000000000019984014443253,0,0.000000000019984014443253,0,0.000000000019984014443253);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,45764,443,0.083333333333373,55200,0,4600.0000000022,0,4600.0000000022,0,4600.0000000022);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,62346,443,0.041666666666669,60000,0,2500.0000000002,0,2500.0000000002,0,2500.0000000002);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55782,443,0.066666666666666,127400,0,8493.3333333332,0,8493.3333333332,0,8493.3333333332);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,51646,443,0.055555555555554,138200,0,7677.7777777776,0,7677.7777777776,0,7677.7777777776);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63440,443,0.0000000000000049404924595819,60000,0,0.00000000029642954757492,0,0.00000000029642954757492,0,0.00000000029642954757492);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63438,443,8.8817841970013e-16,60000,0,0.000000000053290705182008,0,0.000000000053290705182008,0,0.000000000053290705182008);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63439,443,0.0000000000000026645352591004,60000,0,0.00000000015987211554602,0,0.00000000015987211554602,0,0.00000000015987211554602);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,61315,443,0.15,72000,0,10800,0,10800,0,10800);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,58465,443,2,22900,0,45800,0,45800,0,45800);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,23554,443,1,20000,0,20000,0,20000,0,20000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43290,443,0.12,149500,0,17939.999999999,0,17939.999999999,0,17939.999999999);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33743,443,0.000000000000010214051826551,69900,0,0.00000000071396222267595,0,0.00000000071396222267595,0,0.00000000071396222267595);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,41154,443,1,14000,0,14000,0,14000,0,14000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55891,443,0.000000000000029976021664879,32000,0,0.00000000095923269327614,0,0.00000000095923269327614,0,0.00000000095923269327614);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,61904,443,1,45000,0,45000,0,45000,0,45000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,46874,443,7,6500,0,45500,0,45500,0,45500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,24463,443,1,2400,0,2400,0,2400,0,2400);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33629,443,0.0000000000000021094237467878,72000,0,0.00000000015187850976872,0,0.00000000015187850976872,0,0.00000000015187850976872);