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','F406','00225','122024','2024-12-18 00:00:00','CO','SUGERIDO',1,1,1,'PEDIDOSUGERIDOFECHAULTIMOPEDIDO',20795435493.02,0,-1212803614.3943,'N',531175,397,'ADMINISTRADOR','2024-12-18 16:42:29'); |SELECTUNO|SELECT docuid FROM documentos WHERE CONCAT(tipodoc,prefijo,numero)='PVPF40600225' **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,46100,776,8,500,0,-499500,0,-499500,0,-499500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,39236,776,2,800,0,-799200,0,-799200,0,-799200); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,47205,776,2,9000,0,-8991000,0,-8991000,0,-8991000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33981,776,1,9000,0,-8991000,0,-8991000,0,-8991000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31223,776,8,12900,0,-12887100,0,-12887100,0,-12887100); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,22278,776,4,9600,0,-9590400,0,-9590400,0,-9590400); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31770,776,1,6500,0,-6493500,0,-6493500,0,-6493500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54335,776,2,3500,0,-3496500,0,-3496500,0,-3496500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31562,776,2,6900,0,-6893100,0,-6893100,0,-6893100); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,24463,776,3,2400,0,-2397600,0,-2397600,0,-2397600); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63778,776,5,22500,0,-22477500,0,-22477500,0,-22477500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,39152,776,1,14000,0,-13986000,0,-13986000,0,-13986000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,22277,776,5,9600,0,-9590400,0,-9590400,0,-9590400); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,22275,776,3,9600,0,-9590400,0,-9590400,0,-9590400); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31133,776,1,19900,0,-19880100,0,-19880100,0,-19880100); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31567,776,1,16400,0,-16383600,0,-16383600,0,-16383600); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,60970,776,3,18000,0,-17982000,0,-17982000,0,-17982000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43203,776,3,15500,0,-15484500,0,-15484500,0,-15484500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,24819,776,4,16500,0,-16483500,0,-16483500,0,-16483500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,33273,776,6,13400,0,-13386600,0,-13386600,0,-13386600); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,47372,776,1,3700,0,-3696300,0,-3696300,0,-3696300); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,27603,776,2,28900,0,-28871100,0,-28871100,0,-28871100); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,39820,776,1,14500,0,-14485500,0,-14485500,0,-14485500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,24465,776,2,5300,0,-5294700,0,-5294700,0,-5294700); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,61643,776,2,15000,0,-14985000,0,-14985000,0,-14985000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,25778,776,3,8500,0,-8491500,0,-8491500,0,-8491500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31391,776,2,18600,0,-18581400,0,-18581400,0,-18581400); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,31131,776,4,20900,0,-20879100,0,-20879100,0,-20879100); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,58141,776,2,17000,0,-16983000,0,-16983000,0,-16983000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,59364,776,1,3600,0,-3596400,0,-3596400,0,-3596400); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,58075,776,3,14900,0,-14885100,0,-14885100,0,-14885100); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,38457,776,2,72300,0,-72227700,0,-72227700,0,-72227700); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,32976,776,1,131700,0,-131568300,0,-131568300,0,-131568300); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,58647,776,1,10400,0,-10389600,0,-10389600,0,-10389600); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43120,776,2,15300,0,-15284700,0,-15284700,0,-15284700); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,56653,776,2,43000,0,-42957000,0,-42957000,0,-42957000); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,25355,776,1,66400,0,-66333600,0,-66333600,0,-66333600); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53241,776,1,175300,0,-175124700,0,-175124700,0,-175124700); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,22285,776,1,112500,0,-112387500,0,-112387500,0,-112387500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,42957,776,1,26200,0,-26173800,0,-26173800,0,-26173800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,59240,776,1,22500,0,-22477500,0,-22477500,0,-22477500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,49065,776,1,9500,0,-9490500,0,-9490500,0,-9490500); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,22880,776,0.04,49800,0,1992,0,1992,0,1992); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,46716,776,0.066666666666666,49800,0,3319.999999999967,0,3319.999999999967,0,3319.999999999967); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,54625,776,5.2735593669695e-16,49800,0,0.000000000026262325647508114,0,0.000000000026262325647508114,0,0.000000000026262325647508114); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,51946,776,1,49800,0,49800,0,49800,0,49800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,37241,776,0.055555555555571,49800,0,2766.666666667436,0,2766.666666667436,0,2766.666666667436); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,52030,776,0.2,49800,0,9960,0,9960,0,9960); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,63956,776,0.1,49800,0,4980,0,4980,0,4980); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,48112,776,1,49800,0,49800,0,49800,0,49800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,29739,776,0.5,49800,0,24900,0,24900,0,24900); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,38577,776,0.4,49800,0,19920,0,19920,0,19920); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,53651,776,0.16666666666667,49800,0,8300.000000000166,0,8300.000000000166,0,8300.000000000166); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,46090,776,0.041666646798445,49800,0,2074.999010562561,0,2074.999010562561,0,2074.999010562561); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,26533,776,0.039999999999998,49800,0,1991.9999999999004,0,1991.9999999999004,0,1991.9999999999004); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,39002,776,0.11111111111111,49800,0,5533.333333333278,0,5533.333333333278,0,5533.333333333278); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,51646,776,0.45833333333333,49800,0,22824.999999999833,0,22824.999999999833,0,22824.999999999833); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,61315,776,0.45,49800,0,22410,0,22410,0,22410); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,44302,776,0.33333333333333,49800,0,16599.999999999833,0,16599.999999999833,0,16599.999999999833); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43290,776,0.22,49800,0,10956,0,10956,0,10956); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,43182,776,0.375,49800,0,18675,0,18675,0,18675); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,26221,776,3.885780586188e-16,49800,0,0.00000000001935118731921624,0,0.00000000001935118731921624,0,0.00000000001935118731921624); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,26707,776,0.33333333333333,49800,0,16599.999999999833,0,16599.999999999833,0,16599.999999999833); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,32429,776,3,49800,0,149400,0,149400,0,149400); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,46772,776,1,49800,0,49800,0,49800,0,49800); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,64933,776,3,49800,0,149400,0,149400,0,149400); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,64954,776,3,49800,0,149400,0,149400,0,149400); **INSERT INTO dedocumentos(docuid,productoid,bodegaid,cantidad,valunitario,valdescuento,valparcial,porciva,valbase,valiva,valtotal) VALUES(|||||,62506,776,0.11111111111112,49800,0,5533.333333333776,0,5533.333333333776,0,5533.333333333776);