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','F230','01294','012025','2025-01-15 00:00:00','CO','SUGERIDO',1,1,1,'PEDIDOSUGERIDOFECHAULTIMOPEDIDO',29727310099.17289,0,-3752579815.9918,'N',745813,245,'ADMINISTRADOR','2025-01-15 08:05:38');
|SELECTUNO|SELECT docuid FROM documentos WHERE CONCAT(tipodoc,prefijo,numero)='PVPF23001294'
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48019,422,3,2200,0,-2197800,0,-2197800,0,-2197800);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,58629,422,12,1000,0,-999000,0,-999000,0,-999000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,58667,422,1,500,0,-499500,0,-499500,0,-499500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33916,422,2,9000,0,-8991000,0,-8991000,0,-8991000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33981,422,2,9000,0,-8991000,0,-8991000,0,-8991000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,42905,422,2,2000,0,-1998000,0,-1998000,0,-1998000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,45306,422,3,7000,0,-6993000,0,-6993000,0,-6993000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31632,422,4,10900,0,-10889100,0,-10889100,0,-10889100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,58552,422,4,16000,0,-15984000,0,-15984000,0,-15984000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,59848,422,2,9000,0,-8991000,0,-8991000,0,-8991000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,62932,422,8,10500,0,-10489500,0,-10489500,0,-10489500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31151,422,3,25000,0,-24975000,0,-24975000,0,-24975000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48626,422,10,6500,0,-6493500,0,-6493500,0,-6493500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,56917,422,8,9900,0,-9890100,0,-9890100,0,-9890100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,47117,422,2,3500,0,-3496500,0,-3496500,0,-3496500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,56887,422,2,29900,0,-29870100,0,-29870100,0,-29870100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,40145,422,4,5000,0,-4995000,0,-4995000,0,-4995000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,49673,422,6,22500,0,-22477500,0,-22477500,0,-22477500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,62671,422,3,32000,0,-31968000,0,-31968000,0,-31968000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,52526,422,4,9000,0,-8991000,0,-8991000,0,-8991000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53417,422,8,30000,0,-29970000,0,-29970000,0,-29970000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,62082,422,2,2000,0,-1998000,0,-1998000,0,-1998000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,64514,422,6,14400,0,-14385600,0,-14385600,0,-14385600);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53074,422,10,26100,0,-26073900,0,-26073900,0,-26073900);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,49200,422,7,18000,0,-17982000,0,-17982000,0,-17982000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,62083,422,2,2000,0,-1998000,0,-1998000,0,-1998000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54455,422,3,13400,0,-13386600,0,-13386600,0,-13386600);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,45904,422,2,10000,0,-9990000,0,-9990000,0,-9990000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48643,422,1,36000,0,-35964000,0,-35964000,0,-35964000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,40629,422,2,16000,0,-15984000,0,-15984000,0,-15984000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53096,422,3,2000,0,-1998000,0,-1998000,0,-1998000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31446,422,1,12900,0,-12887100,0,-12887100,0,-12887100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,40591,422,2,3300,0,-3296700,0,-3296700,0,-3296700);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,62513,422,1,10500,0,-10489500,0,-10489500,0,-10489500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,50903,422,3,6900,0,-6893100,0,-6893100,0,-6893100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,56535,422,1,47000,0,-46953000,0,-46953000,0,-46953000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,23597,422,3,16500,0,-16483500,0,-16483500,0,-16483500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,30324,422,4,14300,0,-14285700,0,-14285700,0,-14285700);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,42930,422,1,7900,0,-7892100,0,-7892100,0,-7892100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,62806,422,1,36900,0,-36863100,0,-36863100,0,-36863100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,61909,422,7,75000,0,-74925000,0,-74925000,0,-74925000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,23600,422,1,10000,0,-9990000,0,-9990000,0,-9990000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53897,422,1,12500,0,-12487500,0,-12487500,0,-12487500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54754,422,2,12200,0,-12187800,0,-12187800,0,-12187800);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,45850,422,2,15500,0,-15484500,0,-15484500,0,-15484500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,42902,422,1,9800,0,-9790200,0,-9790200,0,-9790200);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43283,422,2,117300,0,-117182700,0,-117182700,0,-117182700);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,44317,422,2,20100,0,-20079900,0,-20079900,0,-20079900);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,24273,422,1,14500,0,-14485500,0,-14485500,0,-14485500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54107,422,3,29900,0,-29870100,0,-29870100,0,-29870100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,51483,422,2,14000,0,-13986000,0,-13986000,0,-13986000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,23598,422,1,24800,0,-24775200,0,-24775200,0,-24775200);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63582,422,2,18000,0,-17982000,0,-17982000,0,-17982000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,24361,422,2,8500,0,-8491500,0,-8491500,0,-8491500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,42970,422,1,25500,0,-25474500,0,-25474500,0,-25474500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,39126,422,1,20100,0,-20079900,0,-20079900,0,-20079900);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31564,422,2,9000,0,-8991000,0,-8991000,0,-8991000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,29860,422,2,6800,0,-6793200,0,-6793200,0,-6793200);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55891,422,1,32000,0,-31968000,0,-31968000,0,-31968000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43129,422,1,24500,0,-24475500,0,-24475500,0,-24475500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54285,422,2,51900,0,-51848100,0,-51848100,0,-51848100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,45860,422,1,15000,0,-14985000,0,-14985000,0,-14985000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31133,422,1,19900,0,-19880100,0,-19880100,0,-19880100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33371,422,2,7300,0,-7292700,0,-7292700,0,-7292700);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,42561,422,4,1900,0,-1898100,0,-1898100,0,-1898100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53653,422,1,25000,0,-24975000,0,-24975000,0,-24975000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63616,422,1,18100,0,-18081900,0,-18081900,0,-18081900);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,28031,422,2,11800,0,-11788200,0,-11788200,0,-11788200);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55214,422,1,11200,0,-11188800,0,-11188800,0,-11188800);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,28686,422,2,13500,0,-13486500,0,-13486500,0,-13486500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,51777,422,2,16900,0,-16883100,0,-16883100,0,-16883100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,39697,422,6,14100,0,-14085900,0,-14085900,0,-14085900);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,50634,422,1,23500,0,-23476500,0,-23476500,0,-23476500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,23110,422,5,16500,0,-16483500,0,-16483500,0,-16483500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,41708,422,1,11200,0,-11188800,0,-11188800,0,-11188800);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,37243,422,2,47500,0,-47452500,0,-47452500,0,-47452500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,39793,422,2,150000,0,-149850000,0,-149850000,0,-149850000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,22843,422,1,10200,0,-10189800,0,-10189800,0,-10189800);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,51568,422,1,5117,0,-5111883,0,-5111883,0,-5111883);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,49748,422,1,28200,0,-28171800,0,-28171800,0,-28171800);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43181,422,4,21300,0,-21278700,0,-21278700,0,-21278700);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,57409,422,1,40900,0,-40859100,0,-40859100,0,-40859100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53836,422,1,20700,0,-20679300,0,-20679300,0,-20679300);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,38852,422,2,74500,0,-74425500,0,-74425500,0,-74425500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,32926,422,2,66200,0,-66133800,0,-66133800,0,-66133800);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,50104,422,1,2200,0,-2197800,0,-2197800,0,-2197800);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43298,422,2,8500,0,-8491500,0,-8491500,0,-8491500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,57501,422,2,7200,0,-7192800,0,-7192800,0,-7192800);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,60656,422,1,41500,0,-41458500,0,-41458500,0,-41458500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,51004,422,1,3900,0,-3896100,0,-3896100,0,-3896100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,45862,422,1,15000,0,-14985000,0,-14985000,0,-14985000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43331,422,2,30400,0,-30369600,0,-30369600,0,-30369600);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,37236,422,4,85000,0,-84915000,0,-84915000,0,-84915000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31240,422,2,106400,0,-106293600,0,-106293600,0,-106293600);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,25916,422,2,12900,0,-12887100,0,-12887100,0,-12887100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,30597,422,2,25500,0,-25474500,0,-25474500,0,-25474500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53477,422,2,6900,0,-6893100,0,-6893100,0,-6893100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,47587,422,2,34400,0,-34365600,0,-34365600,0,-34365600);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55330,422,1,8000,0,-7992000,0,-7992000,0,-7992000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,46738,422,1,33700,0,-33666300,0,-33666300,0,-33666300);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,42809,422,2,14900,0,-14885100,0,-14885100,0,-14885100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,42858,422,2,11000,0,-10989000,0,-10989000,0,-10989000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,27348,422,1,14100,0,-14085900,0,-14085900,0,-14085900);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63360,422,2,35000,0,-34965000,0,-34965000,0,-34965000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,56939,422,1,71400,0,-71328600,0,-71328600,0,-71328600);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,23486,422,1,35000,0,-34965000,0,-34965000,0,-34965000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,30335,422,2,27999.51,0,-27971510.49,0,-27971510.49,0,-27971510.49);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,61544,422,2,20600,0,-20579400,0,-20579400,0,-20579400);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,38588,422,2,68500,0,-68431500,0,-68431500,0,-68431500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,25455,422,1,117700,0,-117582300,0,-117582300,0,-117582300);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,56441,422,2,79500,0,-79420500,0,-79420500,0,-79420500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,52188,422,1,38500,0,-38461500,0,-38461500,0,-38461500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,44354,422,1,15000,0,-14985000,0,-14985000,0,-14985000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,61271,422,1,10900,0,-10889100,0,-10889100,0,-10889100);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43162,422,1,32700,0,-32667300,0,-32667300,0,-32667300);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,25645,422,1,17500,0,-17482500,0,-17482500,0,-17482500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,61358,422,1,71500,0,-71428500,0,-71428500,0,-71428500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31052,422,1,30000,0,-29970000,0,-29970000,0,-29970000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,23533,422,1,46500,0,-46453500,0,-46453500,0,-46453500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55895,422,1,63000,0,-62937000,0,-62937000,0,-62937000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,39789,422,1,158500,0,-158341500,0,-158341500,0,-158341500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,22873,422,1,17200,0,17200,0,17200,0,17200);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,22870,422,0.09999998569488,110000,0,10999.998426437,0,10999.998426437,0,10999.998426437);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55624,422,1,4000,0,4000,0,4000,0,4000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,22275,422,1,9600,0,9600,0,9600,0,9600);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55721,422,1,9600,0,9600,0,9600,0,9600);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,46638,422,1,21400,0,21400,0,21400,0,21400);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31190,422,0.6,35000,0,21000,0,21000,0,21000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,45304,422,1,15000,0,15000,0,15000,0,15000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43430,422,1,17900,0,17900,0,17900,0,17900);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54056,422,4.4408920985006e-16,46000,0,0.000000000020428103653103,0,0.000000000020428103653103,0,0.000000000020428103653103);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,38992,422,3.3306690738755e-16,19200,0,0.0000000000063948846218409,0,0.0000000000063948846218409,0,0.0000000000063948846218409);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,37241,422,0.000000000000010436096431476,91000,0,0.00000000094968477526436,0,0.00000000094968477526436,0,0.00000000094968477526436);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33555,422,7.4940054162198e-16,76700,0,0.000000000057479021542406,0,0.000000000057479021542406,0,0.000000000057479021542406);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,38541,422,0.066666666666661,82500,0,5499.9999999995,0,5499.9999999995,0,5499.9999999995);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53652,422,3.3306690738755e-16,57000,0,0.00000000001898481372109,0,0.00000000001898481372109,0,0.00000000001898481372109);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53776,422,0.16666666666667,57600,0,9600.0000000004,0,9600.0000000004,0,9600.0000000004);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53654,422,1,32200,0,32200,0,32200,0,32200);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,25785,422,0.12500000000005,63500,0,7937.500000003,0,7937.500000003,0,7937.500000003);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,60937,422,1,14900,0,14900,0,14900,0,14900);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,60998,422,0.000000000000011102230246252,63000,0,0.00000000069944050551385,0,0.00000000069944050551385,0,0.00000000069944050551385);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48571,422,0.6,75800,0,45480,0,45480,0,45480);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,45764,422,0.16666666666667,55200,0,9200.0000000004,0,9200.0000000004,0,9200.0000000004);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43524,422,0.15,138000,0,20700,0,20700,0,20700);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,62346,422,5.5511151231258e-16,60000,0,0.000000000033306690738755,0,0.000000000033306690738755,0,0.000000000033306690738755);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,62772,422,0.000000000000048627768478582,91200,0,0.0000000044348524852467,0,0.0000000044348524852467,0,0.0000000044348524852467);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,55782,422,0.066666666666663,127400,0,8493.3333333328,0,8493.3333333328,0,8493.3333333328);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,62763,422,0.13333333333338,90000,0,12000.000000004,0,12000.000000004,0,12000.000000004);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63445,422,0.000000000000018651746813703,169000,0,0.0000000031521452115157,0,0.0000000031521452115157,0,0.0000000031521452115157);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63439,422,0.0000000000000022759572004816,60000,0,0.00000000013655743202889,0,0.00000000013655743202889,0,0.00000000013655743202889);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,61315,422,8.8817841970013e-16,72000,0,0.000000000063948846218409,0,0.000000000063948846218409,0,0.000000000063948846218409);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,58540,422,0.0000000000000013322676295502,47000,0,0.000000000062616578588859,0,0.000000000062616578588859,0,0.000000000062616578588859);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,44302,422,1,86900,0,86900,0,86900,0,86900);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,23570,422,1,8000,0,8000,0,8000,0,8000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43290,422,0.0000000000000025535129566379,149500,0,0.00000000038175018701736,0,0.00000000038175018701736,0,0.00000000038175018701736);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33743,422,0.00000000000003841371665203,69900,0,0.0000000026851187939769,0,0.0000000026851187939769,0,0.0000000026851187939769);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43182,422,0.0625,172800,0,10800,0,10800,0,10800);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,26243,422,1,28000,0,28000,0,28000,0,28000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,64548,422,1,18000,0,18000,0,18000,0,18000);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,22930,422,0.033333333333334,41000,0,1366.6666666667,0,1366.6666666667,0,1366.6666666667);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,46874,422,1,6500,0,6500,0,6500,0,6500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33629,422,0.09999999701977,72000,0,7199.9997854234,0,7199.9997854234,0,7199.9997854234);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,24473,422,1,15500,0,15500,0,15500,0,15500);
**INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,56126,422,1,4900,0,4900,0,4900,0,4900);