INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030411','2022-04-30 19:30:11','042022','CO','1003378879','ANA','BENJUMEA','',' 000','1555','DAINIS PATRICIA','DIAZ BOTELLO','','TERCERO','VARIOS','','','','','','4','19400','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 19:30:11','19400','87','BOD. FARMANORTE 87','2','2800','5600','5600','0','5600','0','2','0','','30/04/2022','',19400,0,0,'7702057841256','BONFIEST PLUS *32 SOBRES','382','TECNOQUIMICAS','2022-04-30 19:30:11',  81272, 43283, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030412','2022-04-30 19:38:58','042022','CO','100435025','ROBERTO ','AGUIRRE','NO DIO',' 3125245252','1555','DAINIS PATRICIA','DIAZ BOTELLO','','TERCERO','VARIOS','','','','','','8','9984.873949579833','415.12605042016776','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 19:38:58','10400','87','BOD. FARMANORTE 87','6','1300','7800','7800','0','7800','0','6','0','','30/04/2022','',10400,0,0,'7702870070888','SEVEDOL EXTRAFUERTE *60 TAB','633','ABBOTT CONSUMER HEALTH CARE','2022-04-30 19:38:58',  49500, 31759, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030412','2022-04-30 19:38:58','042022','CO','100435025','ROBERTO ','AGUIRRE','NO DIO',' 3125245252','1555','DAINIS PATRICIA','DIAZ BOTELLO','','TERCERO','VARIOS','','','','','','8','9984.873949579833','415.12605042016776','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 19:38:58','10400','87','BOD. FARMANORTE 87','2','1300','2600','2184.8739495798','415.12605042017','2600','2','0','0','','30/04/2022','',10400,0,0,'7702402202503','PALETA ALOHA AGUA NARANJA X 65 GR','296','MEALS DE COLOMBIA','2022-04-30 19:38:58',  856.52, 32693, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030413','2022-04-30 19:44:19','042022','CO','1085167484','MARIA FERNANDA','OLIVEROS','KRA 21C  N 29G11 VILLA BELLA',' 3195365194','1555','DAINIS PATRICIA','DIAZ BOTELLO','','TERCERO','VARIOS','','','','','','1','35000','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 19:44:19','35000','87','BOD. FARMANORTE 87','1','35000','35000','35000','0','35000','1','0','0','','30/04/2022','',35000,0,0,'7707263003535','TRIDAR CREMA * 40 GR TRIDEX','387','TRIDEX FARMACEUTICA','2022-04-30 19:44:19',  16250, 32734, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030414','2022-04-30 19:47:45','042022','CO','15700316','YAMILE','ANGULO','',' NO DIO','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','2','6806.72268907563','1293.2773109243697','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 19:47:45','8100','87','BOD. FARMANORTE 87','1','6500','6500','5462.1848739496','1037.8151260504','6500','1','0','0','','30/04/2022','',8100,0,0,'7702189046673','DETODITO NATURAL *165 GR','762','FRITO LAY','2022-04-30 19:47:45',  4629, 48238, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030414','2022-04-30 19:47:45','042022','CO','15700316','YAMILE','ANGULO','',' NO DIO','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','2','6806.72268907563','1293.2773109243697','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 19:47:45','8100','87','BOD. FARMANORTE 87','1','1600','1600','1344.5378151261','255.46218487395','1600','1','0','0','','30/04/2022','',8100,0,0,'7702189054708','CHEETOS HORNEADOS MAXI *44 GR','762','FRITO LAY','2022-04-30 19:47:45',  1087, 55427, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030415','2022-04-30 19:51:14','042022','CO','100435028','SANDRA','CASTRO','CR 21 A 3 N 29 F 92 LOS FAROLE','   3125625412','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','5','2100.840336134454','399.159663865546','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 19:51:14','2500','87','BOD. FARMANORTE 87','5','500','2500','2100.8403361345','399.15966386555','2500','0','5','0','','30/04/2022','',2500,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2022-04-30 19:51:14',  10400, 46328, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030416','2022-04-30 20:05:31','042022','CO','1124061581','DANIELA','HERNANDEZ','',' NO DIO','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','1','16900','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 20:05:31','16900','87','BOD. FARMANORTE 87','1','16900','16900','16900','0','16900','1','0','0','','30/04/2022','',16900,0,0,'736085278507','MANZANILLA SOLUCION OFT *15ML','636','SOPHIA DE COLOMBIA OTC','2022-04-30 20:05:31',  17993.9483, 31131, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030417','2022-04-30 20:18:16','042022','CO','19611982','MAURICIO','MELENDEZ MENDOZA','',' 0 ','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','5','39273.94957983193','926.0504201680669','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 20:18:16','40200','87','BOD. FARMANORTE 87','1','12400','12400','12400','0','12400','1','0','0','','30/04/2022','',40200,0,0,'7702132019938','TODAY MUTUAL SENSATION X 3 PRESERVATIVOS  ','616','GLAXOSMITHKLINE OTC','2022-04-30 20:18:16',  12053.15, 48067, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030417','2022-04-30 20:18:16','042022','CO','19611982','MAURICIO','MELENDEZ MENDOZA','',' 0 ','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','5','39273.94957983193','926.0504201680669','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 20:18:16','40200','87','BOD. FARMANORTE 87','1','20000','20000','20000','0','20000','0','1','0','','30/04/2022','',40200,0,0,'7702870071731','DURAX 20MG *4 TAB','696','ABBOTT FARMA CONVENIO','2022-04-30 20:18:16',  81359, 33405, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030417','2022-04-30 20:18:16','042022','CO','19611982','MAURICIO','MELENDEZ MENDOZA','',' 0 ','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','5','39273.94957983193','926.0504201680669','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 20:18:16','40200','87','BOD. FARMANORTE 87','2','2900','5800','4873.9495798319','926.05042016807','5800','2','0','0','','30/04/2022','',40200,0,0,'7702004110596','CERVEZA BUDWEISER LATA *269 ML','119','BAVARIA S.A.','2022-04-30 20:18:16',  1211.1, 53531, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030417','2022-04-30 20:18:16','042022','CO','19611982','MAURICIO','MELENDEZ MENDOZA','',' 0 ','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','5','39273.94957983193','926.0504201680669','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 20:18:16','40200','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/04/2022','',40200,0,0,'7702090020847','GASEOSA BRETANA *300 ML','192','GASEOSAS HIPINTO','2022-04-30 20:18:16',  1691.6666, 35287, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030418','2022-04-30 20:18:47','042022','CO','1062807870','CESAR ','COSTA','BOTICA APARTAMENTO','  3156984985','1555','DAINIS PATRICIA','DIAZ BOTELLO','1442','LUIS ALFREDO','DE LA CRUZ ROZO','','','','','','3','16500','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 20:18:47','16500','87','BOD. FARMANORTE 87','1','8500','8500','8500','0','8500','1','0','0','','30/04/2022','',0,16500,0,'7702184010259','SULFATO FERROSO 200 MG X 100 TABLS  ECAR','249','ECAR','2022-04-30 20:18:47',  6800, 29759, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030418','2022-04-30 20:18:47','042022','CO','1062807870','CESAR ','COSTA','BOTICA APARTAMENTO','  3156984985','1555','DAINIS PATRICIA','DIAZ BOTELLO','1442','LUIS ALFREDO','DE LA CRUZ ROZO','','','','','','3','16500','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 20:18:47','16500','87','BOD. FARMANORTE 87','1','7000','7000','7000','0','7000','1','0','0','','30/04/2022','',0,16500,0,'6937579900339','PRUEBA DE EMBARAZO CASSETTE ','750','DIAGNOSTICOS BIOMEDICOS','2022-04-30 20:18:47',  1000, 52920, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030418','2022-04-30 20:18:47','042022','CO','1062807870','CESAR ','COSTA','BOTICA APARTAMENTO','  3156984985','1555','DAINIS PATRICIA','DIAZ BOTELLO','1442','LUIS ALFREDO','DE LA CRUZ ROZO','','','','','','3','16500','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 20:18:47','16500','87','BOD. FARMANORTE 87','1','1000','1000','1000','0','1000','0','0','0','','30/04/2022','',0,16500,0,'DO','DOMICILIO','00','VARIOS','2022-04-30 20:18:47',  500, 44348, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030419','2022-04-30 20:19:54','042022','CO','1004370921','JHONN','ALDIS','',' 3002960920','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','1','12400','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 20:19:55','12400','87','BOD. FARMANORTE 87','1','12400','12400','12400','0','12400','1','0','0','','30/04/2022','',12400,0,0,'7702132009557','TODAY TRIPLE PLEASURE *3 PRESERVATIVOS','616','GLAXOSMITHKLINE OTC','2022-04-30 20:19:54',  12053.14, 39158, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030420','2022-04-30 20:36:47','042022','CO','1082478401','NATALI','ALARCON','',' 3186286207','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','10','6000','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 20:36:47','6000','87','BOD. FARMANORTE 87','10','600','6000','6000','0','6000','0','10','0','','30/04/2022','',6000,0,0,'7703363005554','DOLEX 500MG *100 TAB','616','GLAXOSMITHKLINE OTC','2022-04-30 20:36:47',  55518.01, 33555, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030421','2022-04-30 20:37:19','042022','CO','39046919','LIJIA','BOTELLO','VILLA BELLA',' 3016615146','1555','DAINIS PATRICIA','DIAZ BOTELLO','','TERCERO','VARIOS','','','','','','1','2000','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 20:37:19','2000','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/04/2022','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2022-04-30 20:37:19',  662.5, 48019, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030422','2022-04-30 20:39:36','042022','CO','1004346174','JULIANA','OROZCO','',' NO DIO','1555','DAINIS PATRICIA','DIAZ BOTELLO','','TERCERO','VARIOS','','','','','','6','12550','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 20:39:36','12550','87','BOD. FARMANORTE 87','4','1500','6000','6000','0','6000','0','4','0','','30/04/2022','',12550,0,0,'7702132009656','ADVIL MAX *72 CAPS','616','GLAXOSMITHKLINE OTC','2022-04-30 20:39:36',  97884.5, 51646, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030422','2022-04-30 20:39:36','042022','CO','1004346174','JULIANA','OROZCO','',' NO DIO','1555','DAINIS PATRICIA','DIAZ BOTELLO','','TERCERO','VARIOS','','','','','','6','12550','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 20:39:36','12550','87','BOD. FARMANORTE 87','1','2300','2300','2300','0','2300','0','1','0','','30/04/2022','',12550,0,0,'7702057160999','NORAVER GRIPA BEBIDA NOCHE *24 SOBRES','382','TECNOQUIMICAS','2022-04-30 20:39:36',  46110.078, 33743, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030422','2022-04-30 20:39:36','042022','CO','1004346174','JULIANA','OROZCO','',' NO DIO','1555','DAINIS PATRICIA','DIAZ BOTELLO','','TERCERO','VARIOS','','','','','','6','12550','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 20:39:36','12550','87','BOD. FARMANORTE 87','1','4250','4250','4250','0','4250','0','1','0','','30/04/2022','',12550,0,0,'7500435107020','VICK VAPORUB 12GR *12 LATAS','336','PROCTER & GAMBLE COLOMBIA','2022-04-30 20:39:36',  48181, 40253, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030423','2022-04-30 20:41:32','042022','CO','1082927231','CRISTIAN','MARRUMO','',' 3012886670','1555','DAINIS PATRICIA','DIAZ BOTELLO','','TERCERO','VARIOS','','','','','','1','9800','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 20:41:33','9800','87','BOD. FARMANORTE 87','1','9800','9800','9800','0','9800','1','0','0','','30/04/2022','',9800,0,0,'5411834414546','PREVENTOR SUPER DUPER X 3 PRESERVATIVOS ','387','TRIDEX FARMACEUTICA','2022-04-30 20:41:32',  6291.7, 43566, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030424','2022-04-30 20:46:49','042022','CO','1082926682','ANGELINA','FUENTES','',' 3015716390','1555','DAINIS PATRICIA','DIAZ BOTELLO','','TERCERO','VARIOS','','','','','','1','8900','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 20:46:50','8900','87','BOD. FARMANORTE 87','1','8900','8900','8900','0','8900','1','0','0','','30/04/2022','',8900,0,0,'7702057061265','OXIMETAZOLINA 0.05% NASAL X 15 ML ADULTOS MK','654','MK ETICOS CONVENIO','2022-04-30 20:46:49',  8615.84, 43203, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030425','2022-04-30 20:53:32','042022','CO','7631745','MARCOS','PIMIENTA','BOLEVAR DE LA ROSA',' 3004760341','1555','DAINIS PATRICIA','DIAZ BOTELLO','','TERCERO','VARIOS','','','','','','2','4000','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 20:53:32','4000','87','BOD. FARMANORTE 87','2','2000','4000','4000','0','4000','0','2','0','','30/04/2022','',4000,0,0,'7702870071502','LUMBAL FORTE CJA * 36 TB','633','ABBOTT CONSUMER HEALTH CARE','2022-04-30 20:53:32',  43200, 37241, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030426','2022-04-30 20:59:52','042022','CO','1152942618','DANIEL','THOMAS','',' 3245498142','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','3','4537.81512605042','862.1848739495799','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 20:59:52','5400','87','BOD. FARMANORTE 87','2','1800','3600','3025.2100840336','574.78991596639','3600','2','0','0','','30/04/2022','',5400,0,0,'7702402056304','GALLETA CON HELADO VAINILLA PASAS * 65 GR','296','MEALS DE COLOMBIA','2022-04-30 20:59:52',  1113.815, 60390, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030426','2022-04-30 20:59:52','042022','CO','1152942618','DANIEL','THOMAS','',' 3245498142','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','3','4537.81512605042','862.1848739495799','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 20:59:52','5400','87','BOD. FARMANORTE 87','1','1800','1800','1512.6050420168','287.39495798319','1800','1','0','0','','30/04/2022','',5400,0,0,'7702402056328','GALLETA CON HELADO NAPOLITANO * 65 GR','296','MEALS DE COLOMBIA','2022-04-30 20:59:52',  1114.26, 60339, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030427','2022-04-30 21:03:19','042022','CO','39046919','LIJIA','BOTELLO','VILLA BELLA',' 3016615146','1555','DAINIS PATRICIA','DIAZ BOTELLO','','TERCERO','VARIOS','','','','','','6','15282.35294117647','1117.6470588235293','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 21:03:19','16400','87','BOD. FARMANORTE 87','1','500','500','420.16806722689','79.831932773109','500','0','1','0','','30/04/2022','',16400,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2022-04-30 21:03:19',  10400, 46328, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030427','2022-04-30 21:03:19','042022','CO','39046919','LIJIA','BOTELLO','VILLA BELLA',' 3016615146','1555','DAINIS PATRICIA','DIAZ BOTELLO','','TERCERO','VARIOS','','','','','','6','15282.35294117647','1117.6470588235293','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 21:03:19','16400','87','BOD. FARMANORTE 87','1','3900','3900','3900','0','3900','1','0','0','','30/04/2022','',16400,0,0,'7706569000781','ENALAPRIL 5 MG X 30 TABLS  A.G.','614','A.G. MEDICAMENTOS','2022-04-30 21:03:19',  3794, 31378, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030427','2022-04-30 21:03:19','042022','CO','39046919','LIJIA','BOTELLO','VILLA BELLA',' 3016615146','1555','DAINIS PATRICIA','DIAZ BOTELLO','','TERCERO','VARIOS','','','','','','6','15282.35294117647','1117.6470588235293','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 21:03:19','16400','87','BOD. FARMANORTE 87','1','6500','6500','5462.1848739496','1037.8151260504','6500','1','0','0','','30/04/2022','',16400,0,0,'7702186021758','NAILEN POLVO COMPACTO N 3 X 14 GR','370','SMART LABORATORIOS','2022-04-30 21:03:19',  4793.8992, 42403, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030427','2022-04-30 21:03:19','042022','CO','39046919','LIJIA','BOTELLO','VILLA BELLA',' 3016615146','1555','DAINIS PATRICIA','DIAZ BOTELLO','','TERCERO','VARIOS','','','','','','6','15282.35294117647','1117.6470588235293','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 21:03:19','16400','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/04/2022','',16400,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2022-04-30 21:03:19',  662.5, 48019, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030427','2022-04-30 21:03:19','042022','CO','39046919','LIJIA','BOTELLO','VILLA BELLA',' 3016615146','1555','DAINIS PATRICIA','DIAZ BOTELLO','','TERCERO','VARIOS','','','','','','6','15282.35294117647','1117.6470588235293','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 21:03:19','16400','87','BOD. FARMANORTE 87','2','1750','3500','3500','0','3500','0','2','0','','30/04/2022','',16400,0,0,'7702057092757','IBUFLASH MIGRAN *30 TAB','382','TECNOQUIMICAS','2022-04-30 21:03:19',  45968.958, 58898, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030428','2022-04-30 21:04:11','042022','CO','1003409511','KARINA','GOMEZ','',' 3012612141','1555','DAINIS PATRICIA','DIAZ BOTELLO','','TERCERO','VARIOS','','','','','','2','17000','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 21:04:11','17000','87','BOD. FARMANORTE 87','2','8500','17000','17000','0','17000','2','0','0','','30/04/2022','',17000,0,0,'7707019332605','FUNGISTEROL 200 MG TAB. CAJA * 10 BIOQUIFAR','130','LABQUIFAR PHARMACEUTICA','2022-04-30 21:04:11',  4548, 45853, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030429','2022-04-30 21:18:34','042022','CO','1082998678','CESAR','LOPEZ','PANADERIA FAMILIARTE',' 3195249062','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','3','5025.210084033613','574.7899159663866','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 21:18:34','5600','87','BOD. FARMANORTE 87','2','1800','3600','3025.2100840336','574.78991596639','3600','2','0','0','','30/04/2022','',5600,0,0,'7702402052412','HELADO ARTESANAL TRES LECHES * 70 GR','296','MEALS DE COLOMBIA','2022-04-30 21:18:34',  1179.26, 54650, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030429','2022-04-30 21:18:34','042022','CO','1082998678','CESAR','LOPEZ','PANADERIA FAMILIARTE',' 3195249062','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','3','5025.210084033613','574.7899159663866','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 21:18:34','5600','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','0','1','0','','30/04/2022','',5600,0,0,'7707232095769','MIELTERTOS PASTILLAS MASTICABLES *12 S/S','271','NATURAL FRESHLY','2022-04-30 21:18:34',  13210.776, 46200, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030430','2022-04-30 21:20:48','042022','CO','1193214188','ROSA','PARRA','',' 3122272583','1555','DAINIS PATRICIA','DIAZ BOTELLO','','TERCERO','VARIOS','','','','','','2','7600.8403361344535','399.159663865546','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 21:20:48','8000','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','30/04/2022','',8000,0,0,'6910021007206','COLGATE CEPILLO PREMIER CLEAN MEDIO','145','COLGATE PALMOLIVE COMPANIA','2022-04-30 21:20:48',  1822.8, 47117, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030430','2022-04-30 21:20:48','042022','CO','1193214188','ROSA','PARRA','',' 3122272583','1555','DAINIS PATRICIA','DIAZ BOTELLO','','TERCERO','VARIOS','','','','','','2','7600.8403361344535','399.159663865546','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 21:20:48','8000','87','BOD. FARMANORTE 87','1','5500','5500','5500','0','5500','1','0','0','','30/04/2022','',8000,0,0,'7702026177874','NOSOTRAS INVISIBLE RAPIGEL * 10 GTS 5 DIAS LARGOS','337','FAMILIA SANCELA','2022-04-30 21:20:48',  4613.5, 50903, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030431','2022-04-30 21:29:32','042022','CO','1083024218','KELY','CHARRIS','KRA 21C2 # 29F - 22 VILLA BELL','   3104850731','1555','DAINIS PATRICIA','DIAZ BOTELLO','1442','LUIS ALFREDO','DE LA CRUZ ROZO','','','','','','2','17000','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 21:29:32','17000','87','BOD. FARMANORTE 87','1','16000','16000','16000','0','16000','1','0','0','','30/04/2022','',17000,0,0,'7707019413908','TRICLIMBAC SOLUCION OTICA *10 ML','130','LABQUIFAR PHARMACEUTICA','2022-04-30 21:29:32',  7200, 45901, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030431','2022-04-30 21:29:32','042022','CO','1083024218','KELY','CHARRIS','KRA 21C2 # 29F - 22 VILLA BELL','   3104850731','1555','DAINIS PATRICIA','DIAZ BOTELLO','1442','LUIS ALFREDO','DE LA CRUZ ROZO','','','','','','2','17000','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 21:29:32','17000','87','BOD. FARMANORTE 87','1','1000','1000','1000','0','1000','0','0','0','','30/04/2022','',17000,0,0,'DO','DOMICILIO','00','VARIOS','2022-04-30 21:29:32',  500, 44348, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030432','2022-04-30 21:36:08','042022','CO','1143116483','CARLOS','FLORES','CRA 23 N.29C-137',' 3008534749','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','1','1512.6050420168067','287.3949579831933','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 21:36:08','1800','87','BOD. FARMANORTE 87','1','1800','1800','1512.6050420168','287.39495798319','1800','1','0','0','','30/04/2022','',1800,0,0,'7702402054508','VASO HELADINO KIDS LLUVIA DE COLORES * 54 GR','296','MEALS DE COLOMBIA','2022-04-30 21:36:08',  1186.7647, 58851, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030433','2022-04-30 21:38:10','042022','CO','20147993','ROSA','ACURERO','carrera 29d  29g - 12   villa ','  3007031239','2129','DEIVIS ABAD','BARRANCO SALAS','1442','LUIS ALFREDO','DE LA CRUZ ROZO','','','','','','12','24980','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 21:38:11','24980','87','BOD. FARMANORTE 87','10','798','7980','7980','0','7980','0','10','0','','30/04/2022','',24980,0,0,'7707232091600','UROVITAL CRANBERRY *60 CAPS','271','NATURAL FRESHLY','2022-04-30 21:38:10',  25174.8, 50162, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030433','2022-04-30 21:38:10','042022','CO','20147993','ROSA','ACURERO','carrera 29d  29g - 12   villa ','  3007031239','2129','DEIVIS ABAD','BARRANCO SALAS','1442','LUIS ALFREDO','DE LA CRUZ ROZO','','','','','','12','24980','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 21:38:11','24980','87','BOD. FARMANORTE 87','1','16000','16000','16000','0','16000','1','0','0','','30/04/2022','',24980,0,0,'7707274722715','PROCATEC 500 MG * 10 TB (CIPROFLOXACINO)','181','FAES FARMA','2022-04-30 21:38:10',  2818, 40629, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030433','2022-04-30 21:38:10','042022','CO','20147993','ROSA','ACURERO','carrera 29d  29g - 12   villa ','  3007031239','2129','DEIVIS ABAD','BARRANCO SALAS','1442','LUIS ALFREDO','DE LA CRUZ ROZO','','','','','','12','24980','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 21:38:11','24980','87','BOD. FARMANORTE 87','1','1000','1000','1000','0','1000','0','0','0','','30/04/2022','',24980,0,0,'DO','DOMICILIO','00','VARIOS','2022-04-30 21:38:10',  500, 44348, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030434','2022-04-30 21:52:30','042022','CO','1082964795','KEVIN','TRON','',' 000','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','1','16000','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 21:52:30','16000','87','BOD. FARMANORTE 87','1','16000','16000','16000','0','16000','1','0','0','','30/04/2022','',16000,0,0,'7707274722715','PROCATEC 500 MG * 10 TB (CIPROFLOXACINO)','181','FAES FARMA','2022-04-30 21:52:30',  2818, 40629, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030435','2022-04-30 22:00:54','042022','CO','39026441','LIDA ','BARROS','MANZ 96 CASA 3 CUIDADELA',' 3017572097 ','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','10','7980','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:00:54','7980','87','BOD. FARMANORTE 87','10','798','7980','7980','0','7980','0','10','0','','30/04/2022','',7980,0,0,'7707232091600','UROVITAL CRANBERRY *60 CAPS','271','NATURAL FRESHLY','2022-04-30 22:00:54',  25174.8, 50162, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030436','2022-04-30 22:03:13','042022','CO','1152942618','DANIEL','THOMAS','',' 3245498142','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','1','1092.4369747899161','207.56302521008388','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:03:13','1300','87','BOD. FARMANORTE 87','1','1300','1300','1092.4369747899','207.56302521008','1300','1','0','0','','30/04/2022','',1300,0,0,'7702402054171','PALETA CHOCOLISTO * 50 GR','296','MEALS DE COLOMBIA','2022-04-30 22:03:13',  798.711, 55601, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030437','2022-04-30 22:12:18','042022','CO','36696727','EMIRITH','BARRIOS','',' 3016509880','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','1','420.1680672268908','79.8319327731092','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:12:18','500','87','BOD. FARMANORTE 87','1','500','500','420.16806722689','79.831932773109','500','0','1','0','','30/04/2022','',500,0,0,'D1611','TAPABOCAS NEGRO EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2022-04-30 22:12:18',  10400, 59522, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030438','2022-04-30 22:16:18','042022','CO','57429750','ANA ','CASTILLO','',' 3013557703','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','1','3000','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:16:18','3000','87','BOD. FARMANORTE 87','1','3000','3000','3000','0','3000','1','0','0','','30/04/2022','',3000,0,0,'7702605101634','LORATADINA 10 MG X 10 TBS GENFAR','715','GENFAR CONVENIO','2022-04-30 22:16:18',  2669.29, 26098, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030439','2022-04-30 22:18:32','042022','CO','36560249','GLEDYS','PACHECO','KRA21A N 29F71 LOS FAROLES',' 3147163126','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','1','3000','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:18:32','3000','87','BOD. FARMANORTE 87','1','3000','3000','3000','0','3000','1','0','0','','30/04/2022','',3000,0,0,'7703038065630','ACETAMINOFEN JARABE *90 ML','275','LAPROFF','2022-04-30 22:18:32',  2200, 46646, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030440','2022-04-30 22:20:59','042022','CO','1082874172','MARCELA','RIVERA','',' 3003767026','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','3','10136.134453781513','63.865546218487395','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:20:59','10200','87','BOD. FARMANORTE 87','1','6000','6000','6000','0','6000','0','1','0','','30/04/2022','',10200,0,0,'7709990733716','NORIFLAM 75MG/3ML CJA * 6 AMP','698','MED-LINE CONVENIO','2022-04-30 22:20:59',  8900, 48643, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030440','2022-04-30 22:20:59','042022','CO','1082874172','MARCELA','RIVERA','',' 3003767026','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','3','10136.134453781513','63.865546218487395','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:20:59','10200','87','BOD. FARMANORTE 87','1','3800','3800','3800','0','3800','0','1','0','','30/04/2022','',10200,0,0,'7702896001231','DEXABLAS  8 MG X 5 AMP (DEXAMETASONA) BLASKOV','132','BLASKOV','2022-04-30 22:20:59',  13038.5167, 23704, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030440','2022-04-30 22:20:59','042022','CO','1082874172','MARCELA','RIVERA','',' 3003767026','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','3','10136.134453781513','63.865546218487395','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:20:59','10200','87','BOD. FARMANORTE 87','1','400','400','336.13445378151','63.865546218487','400','1','0','0','','30/04/2022','',10200,0,0,'7706634001699','JERINGA 5 ML LOCK 21 * 1 1/2 RYMCO','283','RYMCO','2022-04-30 22:20:59',  159.6638, 33717, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030441','2022-04-30 22:23:41','042022','CO','36696727','EMIRITH','BARRIOS','',' 3016509880','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','1','1596.638655462185','303.36134453781506','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:23:41','1900','87','BOD. FARMANORTE 87','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','0','','30/04/2022','',1900,0,0,'7702535012079','GASEOSA QUATRO X 400 ML','144','COCA COLA','2022-04-30 22:23:41',  1172.9167, 37036, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030442','2022-04-30 22:28:48','042022','CO','1004356343','NELSON','GUTIERRE','',' 3206053278','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','1','5000','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:28:48','5000','87','BOD. FARMANORTE 87','1','5000','5000','5000','0','5000','1','0','0','','30/04/2022','',5000,0,0,'5411834400068','PREVENTOR RIBBED *3 PRESERVATIVOS','387','TRIDEX FARMACEUTICA','2022-04-30 22:28:48',  6291.7, 43565, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030443','2022-04-30 22:37:00','042022','CO','1082953925','KEYVIN XAVIER','PERTUZ ARCON','CRA 21A NO.29G-32 LOS FAROLES',' 3023180125','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','3','6806.722689075631','1293.2773109243692','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:37:00','8100','87','BOD. FARMANORTE 87','2','3000','6000','5042.0168067227','957.98319327731','6000','2','0','0','','30/04/2022','',0,8100,0,'7702090052039','CERVEZA HEINEKEN LATA * 269 CM','192','GASEOSAS HIPINTO','2022-04-30 22:37:00',  1444.405, 56235, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030443','2022-04-30 22:37:00','042022','CO','1082953925','KEYVIN XAVIER','PERTUZ ARCON','CRA 21A NO.29G-32 LOS FAROLES',' 3023180125','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','3','6806.722689075631','1293.2773109243692','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:37:00','8100','87','BOD. FARMANORTE 87','1','2100','2100','1764.7058823529','335.29411764706','2100','1','0','0','','30/04/2022','',0,8100,0,'7702535011089,7','COCA COLA 400ML','144','COCA COLA','2022-04-30 22:37:00',  1444.291, 34397, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030444','2022-04-30 22:38:14','042022','CO','1081927658','TATIANA','ORTIZ PEREZ','',' 3046626465','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','1','2000','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:38:14','2000','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','0','1','0','','30/04/2022','',2000,0,0,'7707232095769','MIELTERTOS PASTILLAS MASTICABLES *12 S/S','271','NATURAL FRESHLY','2022-04-30 22:38:14',  13210.776, 46200, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030445','2022-04-30 22:39:57','042022','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','1','7000','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:39:58','7000','87','BOD. FARMANORTE 87','1','7000','7000','7000','0','7000','1','0','0','','30/04/2022','',7000,0,0,'7501033957376','PEDIALYTE ZINC 60 UVA X 500 ML','659','ABBOTT NUTRICION','2022-04-30 22:39:57',  5768, 22278, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030446','2022-04-30 22:44:01','042022','CO','1082986518','LUZ','SOTO','',' 2 ','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','5','10190.756302521007','1309.2436974789916','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:44:02','11500','87','BOD. FARMANORTE 87','1','1300','1300','1300','0','1300','0','1','0','','30/04/2022','',11500,0,0,'7702870070888','SEVEDOL EXTRAFUERTE *60 TAB','633','ABBOTT CONSUMER HEALTH CARE','2022-04-30 22:44:01',  49500, 31759, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030446','2022-04-30 22:44:01','042022','CO','1082986518','LUZ','SOTO','',' 2 ','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','5','10190.756302521007','1309.2436974789916','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:44:02','11500','87','BOD. FARMANORTE 87','1','500','500','420.16806722689','79.831932773109','500','0','1','0','','30/04/2022','',11500,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2022-04-30 22:44:01',  10400, 46328, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030446','2022-04-30 22:44:01','042022','CO','1082986518','LUZ','SOTO','',' 2 ','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','5','10190.756302521007','1309.2436974789916','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:44:02','11500','87','BOD. FARMANORTE 87','1','3100','3100','2605.0420168067','494.95798319328','3100','1','0','0','','30/04/2022','',11500,0,0,'7702189057525','DETODITO NATURAL SUPER MEGA *75 GR ','762','FRITO LAY','2022-04-30 22:44:01',  2173, 60143, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030446','2022-04-30 22:44:01','042022','CO','1082986518','LUZ','SOTO','',' 2 ','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','5','10190.756302521007','1309.2436974789916','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:44:02','11500','87','BOD. FARMANORTE 87','1','4600','4600','3865.5462184874','734.45378151261','4600','1','0','0','','30/04/2022','',11500,0,0,'7702535024423','COCA COLA 1.5 LT','144','COCA COLA','2022-04-30 22:44:01',  3179.812, 56142, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030446','2022-04-30 22:44:01','042022','CO','1082986518','LUZ','SOTO','',' 2 ','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','5','10190.756302521007','1309.2436974789916','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:44:02','11500','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/04/2022','',11500,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2022-04-30 22:44:01',  662.5, 48019, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030447','2022-04-30 22:46:09','042022','CO','1004367936','EMELIN','MENDOZA','',' 3136912585','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','3','20000','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:46:09','20000','87','BOD. FARMANORTE 87','1','2500','2500','2500','0','2500','0','1','0','','30/04/2022','',20000,0,0,'7707210530114','FORZ CREMA * 24 SOBRES ','256','GERCO','2022-04-30 22:46:09',  61852, 46090, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030447','2022-04-30 22:46:09','042022','CO','1004367936','EMELIN','MENDOZA','',' 3136912585','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','3','20000','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:46:09','20000','87','BOD. FARMANORTE 87','1','15500','15500','15500','0','15500','1','0','0','','30/04/2022','',20000,0,0,'7702870003589','POSTDAY X 1 TAB ','696','ABBOTT FARMA CONVENIO','2022-04-30 22:46:09',  11094, 31697, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030447','2022-04-30 22:46:09','042022','CO','1004367936','EMELIN','MENDOZA','',' 3136912585','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','3','20000','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:46:09','20000','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/04/2022','',20000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2022-04-30 22:46:09',  662.5, 48019, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030448','2022-04-30 22:55:09','042022','CO','49689575','ALIRIS','ARTEAGA','CLL 2 N 14-95 BARRIO PAZ DEL R',' 3007319225 ','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','14','100680.42016806723','4949.579831932773','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:55:09','105630','87','BOD. FARMANORTE 87','1','31000','31000','26050.420168067','4949.5798319328','31000','1','0','0','','30/04/2022','',105630,0,0,'7702425801615','HUGGIES ACTIVE SEC ET 4 *30 UNI','141','COLOMBIANA KIMBERLY COLPAPEL','2022-04-30 22:55:09',  25591.9828, 47512, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030448','2022-04-30 22:55:09','042022','CO','49689575','ALIRIS','ARTEAGA','CLL 2 N 14-95 BARRIO PAZ DEL R',' 3007319225 ','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','14','100680.42016806723','4949.579831932773','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:55:09','105630','87','BOD. FARMANORTE 87','1','27500','27500','27500','0','27500','1','0','0','','30/04/2022','',105630,0,0,'7709990770827','RETAXONID 500 MG CJA * 6 TB','642','GFC','2022-04-30 22:55:09',  7000, 51112, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030448','2022-04-30 22:55:09','042022','CO','49689575','ALIRIS','ARTEAGA','CLL 2 N 14-95 BARRIO PAZ DEL R',' 3007319225 ','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','14','100680.42016806723','4949.579831932773','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:55:09','105630','87','BOD. FARMANORTE 87','2','19900','39800','39800','0','39800','2','0','0','','30/04/2022','',105630,0,0,'7703712080409','PIRAXTEL SUSP * 15 ML','387','TRIDEX FARMACEUTICA','2022-04-30 22:55:09',  12400, 57026, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030448','2022-04-30 22:55:09','042022','CO','49689575','ALIRIS','ARTEAGA','CLL 2 N 14-95 BARRIO PAZ DEL R',' 3007319225 ','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','14','100680.42016806723','4949.579831932773','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 22:55:09','105630','87','BOD. FARMANORTE 87','10','733','7330','7330','0','7330','0','10','0','','30/04/2022','',105630,0,0,'7709012750028','DREPACTIL X 30 CAP','642','GFC','2022-04-30 22:55:09',  22900, 48303, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030449','2022-04-30 23:02:04','042022','CO','1082981521','STEVAN ','GILLOT','',' NO DIO','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','1','5900','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 23:02:04','5900','87','BOD. FARMANORTE 87','1','5900','5900','5900','0','5900','0','1','0','','30/04/2022','',5900,0,0,'3582910009900','ENTEROGERMINA *10 AMP','772','SANOFI OTC CONVENIO','2022-04-30 23:02:04',  52300, 41855, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030450','2022-04-30 23:04:19','042022','CO','1010104874','DAIDER','EBRAC','',' 3002407708','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','3','4285.714285714286','814.2857142857138','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 23:04:19','5100','87','BOD. FARMANORTE 87','3','1700','5100','4285.7142857143','814.28571428571','5100','3','0','0','','30/04/2022','',5100,0,0,'7702402054416','CONO CHOCOCONO * 90 GR','296','MEALS DE COLOMBIA','2022-04-30 23:04:19',  1113.305, 56307, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030451','2022-04-30 23:06:21','042022','CO','1004367936','EMELIN','MENDOZA','',' 3136912585','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','1','2000','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 23:06:21','2000','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/04/2022','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2022-04-30 23:06:21',  662.5, 48019, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030452','2022-04-30 23:09:15','042022','CO','1082948084','ALBIS','MERI Ntilde O','',' 000','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','1','2300','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 23:09:15','2300','87','BOD. FARMANORTE 87','1','2300','2300','2300','0','2300','0','1','0','','30/04/2022','',2300,0,0,'7702057160999','NORAVER GRIPA BEBIDA NOCHE *24 SOBRES','382','TECNOQUIMICAS','2022-04-30 23:09:15',  46110.078, 33743, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030453','2022-04-30 23:12:00','042022','CO','1083019853','YESICA','VALAGUERA','',' 3013818754','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','11','9000','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 23:12:00','9000','87','BOD. FARMANORTE 87','1','4500','4500','4500','0','4500','1','0','0','','30/04/2022','',9000,0,0,'7702184020258','CLORFENIRAMINA *120 ML','249','ECAR','2022-04-30 23:12:00',  2300, 48626, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030453','2022-04-30 23:12:00','042022','CO','1083019853','YESICA','VALAGUERA','',' 3013818754','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','11','9000','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 23:12:00','9000','87','BOD. FARMANORTE 87','10','450','4500','4500','0','4500','0','10','0','','30/04/2022','',9000,0,0,'7709492276681','KEOPS VIT NARANJA *100 TAB','811','KEOPS FARMACEUTICA','2022-04-30 23:12:00',  15000, 56792, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030454','2022-04-30 23:16:28','042022','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','13','8069.7478991596645','830.2521008403357','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 23:16:28','8900','87','BOD. FARMANORTE 87','1','3000','3000','2521.0084033613','478.99159663866','3000','1','0','0','','30/04/2022','',8900,0,0,'7702192422051','GATORADE TROPICAL FRUIT *500 ML','192','GASEOSAS HIPINTO','2022-04-30 23:16:28',  2100.84, 25826, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030454','2022-04-30 23:16:28','042022','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','13','8069.7478991596645','830.2521008403357','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 23:16:28','8900','87','BOD. FARMANORTE 87','10','170','1700','1700','0','1700','0','10','0','','30/04/2022','',8900,0,0,'7702605100019','ACETAMINOFEN 500 MG X 100 TBS GENFAR-WINTHROP','715','GENFAR CONVENIO','2022-04-30 23:16:28',  12141.1, 25866, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030454','2022-04-30 23:16:28','042022','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','13','8069.7478991596645','830.2521008403357','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 23:16:28','8900','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/04/2022','',8900,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2022-04-30 23:16:28',  662.5, 48019, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030454','2022-04-30 23:16:28','042022','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','13','8069.7478991596645','830.2521008403357','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 23:16:28','8900','87','BOD. FARMANORTE 87','1','2200','2200','1848.7394957983','351.26050420168','2200','1','0','0','','30/04/2022','',8900,0,0,'7702090029871','HIT JUGO NARANJA PINA * 500ML','192','GASEOSAS HIPINTO','2022-04-30 23:16:28',  1540.6158, 35521, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030455','2022-04-30 23:19:10','042022','CO','1083027622','MARIA ALEJANDRA','ALVEAR','CALLE5A KR21',' 3043483908 ','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','1','25900','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 23:19:10','25900','87','BOD. FARMANORTE 87','1','25900','25900','25900','0','25900','1','0','0','','30/04/2022','',25900,0,0,'650240027543','LOMECAN V CREMA VAG 2% X 20 G','194','GENOMMA LABORATORIO COLOMBIA','2022-04-30 23:19:10',  25809.28, 47499, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030456','2022-04-30 23:26:16','042022','CO','1004367936','EMELIN','MENDOZA','',' 3136912585','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','2','13800','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 23:26:16','13800','87','BOD. FARMANORTE 87','2','6900','13800','13800','0','13800','2','0','0','','30/04/2022','',13800,0,0,'7501125184864','ELECTROLIT MARACUYA * 625 ML','780','PISA (SUEROS LIQUIDOS)','2022-04-30 23:26:16',  5120, 54196, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030457','2022-04-30 23:30:38','042022','CO','23701885','MIGUEL','GONSALEZ','',' 3188030403','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','1','127523.80952380951','6376.190476190488','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 23:30:38','133900','87','BOD. FARMANORTE 87','1','133900','133900','127523.80952381','6376.1904761905','133900','1','0','0','','30/04/2022','',133900,0,0,'5000281003160','WHISKY OLD PARR 12 AÑOS *750 ML','827','MEICO LICORES','2022-04-30 23:30:38',  83194, 32788, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030458','2022-04-30 23:35:49','042022','CO','1004371746','HARRINSON','JAIME','',' NO DIO','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','2','9700','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 23:35:50','9700','87','BOD. FARMANORTE 87','1','2800','2800','2800','0','2800','0','1','0','','30/04/2022','',9700,0,0,'7702057841256','BONFIEST PLUS *32 SOBRES','382','TECNOQUIMICAS','2022-04-30 23:35:49',  81272, 43283, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030458','2022-04-30 23:35:49','042022','CO','1004371746','HARRINSON','JAIME','',' NO DIO','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','2','9700','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 23:35:50','9700','87','BOD. FARMANORTE 87','1','6900','6900','6900','0','6900','1','0','0','','30/04/2022','',9700,0,0,'7501125104343','ELECTROLIT MANZANA SUERO * 625 ML','780','PISA (SUEROS LIQUIDOS)','2022-04-30 23:35:49',  5120, 47211, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030459','2022-04-30 23:40:29','042022','CO','57430714','MONICA','ROJAS','',' 3017273154','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','1','4250','0','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 23:40:29','4250','87','BOD. FARMANORTE 87','1','4250','4250','4250','0','4250','0','1','0','','30/04/2022','',4250,0,0,'7500435107020','VICK VAPORUB 12GR *12 LATAS','336','PROCTER & GAMBLE COLOMBIA','2022-04-30 23:40:29',  48181, 40253, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FN87','030460','2022-04-30 23:43:07','042022','CO','19618005','LUIS','CRESPO','',' 3145768058','2129','DEIVIS ABAD','BARRANCO SALAS','','TERCERO','VARIOS','','','','','','1','2100.840336134454','399.159663865546','87','FARMANORTE 87','ADMINISTRADOR','2022-04-30 23:43:07','2500','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','30/04/2022','',2500,0,0,'7702090050974','SPEED MAX * 1 LT','192','GASEOSAS HIPINTO','2022-04-30 23:43:07',  1750.7, 53555, 223, 99);
UPDATE consolida1 SET DEVALPAR  = DEVALUNI*DECANTIDAD WHERE DEVALPAR = 0 AND PERIODODOC = '042022' AND DECODBOD='87';
UPDATE consolida1 SET DEVALBASE = DEVALTOTAL*DEVALIVA WHERE DEVALBASE = 0 AND PERIODODOC = '042022' AND DECODBOD='87';
UPDATE consolida1 SET DEVALIVA  = DEVALTOTAL-DEVALBASE WHERE PERIODODOC = '042022' AND DECODBOD='87';
UPDATE consolida1 SET VRBASEDOC = TOTALDOC-VRIVADOC WHERE VRBASEDOC = 0 AND VRIVADOC = 0 AND PERIODODOC = '042022' AND DECODBOD='87';
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '19694';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '19694' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '761194';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '761194' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '761444';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '761444' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '761835';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '761835' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'F87' AND numero = '00041';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'F87' AND numero = '00041' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '761848';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '761848' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '760706';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '760706' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '760705';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '760705' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '19496';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '19496' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '19493';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '19493' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '760111';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '760111' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '760079';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '760079' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '759955';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '759955' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '759632';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '759632' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '759628';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '759628' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '759627';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '759627' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '759626';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '759626' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '759259';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '759259' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '759249';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '759249' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '759014';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '759014' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '758651';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '758651' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '758499';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '758499' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '758428';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '758428' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '758381';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '758381' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '758201';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '758201' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '758043';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '758043' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '758033';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '758033' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '452778';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '452778' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '758031';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '758031' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '452788';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '452788' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '757836';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '757836' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '757664';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '757664' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '757581';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '757581' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '757578';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '757578' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '756849';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '756849' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '452407';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '452407' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '757639';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '757639' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '452266';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '452266' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '756604';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '756604' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '19114';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '19114' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '756363';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '756363' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '756107';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '756107' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '756079';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '756079' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '756054';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '756054' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '755977';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '755977' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '755948';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '755948' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '755915';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '755915' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'F87' AND numero = '00040';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'F87' AND numero = '00040' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '755375';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '755375' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '755194';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '755194' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '754345';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '754345' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '451339';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '451339' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '451308';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '451308' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '451113';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '451113' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '451087';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '451087' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '754080';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '754080' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '753955';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '753955' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '753917';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '753917' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '753652';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '753652' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '753392';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '753392' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '753303';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '753303' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '753302';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '753302' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '753178';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '753178' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '753039';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '753039' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '753036';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '753036' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '753783';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '753783' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'F87' AND numero = '00039';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'F87' AND numero = '00039' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '753410';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '753410' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '18433';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '18433' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '752578';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '752578' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '450133';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '450133' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '450388';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '450388' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '752693';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '752693' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '18187';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '18187' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '751166';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '751166' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '751586';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '751586' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '751023';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '751023' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '750996';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '750996' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '750742';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '750742' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '750225';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '750225' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '449601';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '449601' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '749887';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '749887' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '17939';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '17939' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '749542';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '749542' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '749018';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '749018' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '449423';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '449423' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '749747';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '749747' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '749679';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '749679' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'F87' AND numero = '00038';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'F87' AND numero = '00038' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '749772';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '749772' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '748891';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '748891' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '748809';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '748809' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '17739';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '17739' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '17732';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '17732' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '748275';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '748275' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '748265';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '748265' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '748254';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '748254' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '748192';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '748192' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '748030';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '748030' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '448785';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '448785' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '448216';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '448216' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '448566';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '448566' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '448272';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '448272' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '747670';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '747670' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '747663';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '747663' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '17391';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '17391' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '747266';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '747266' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '747150';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '747150' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '447362';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '447362' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '447729';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '447729' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '447648';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '447648' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '746788';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '746788' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '747434';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '747434' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '746359';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '746359' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '746346';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '746346' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '745460';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '745460' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '17027';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '17027' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '745295';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '745295' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '17025';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '17025' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '744694';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '744694' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '744464';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '744464' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '744422';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '744422' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '744005';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '744005' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '16739';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '16739' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '16736';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '16736' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '743883';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '743883' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '743877';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '743877' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '446598';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '446598' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '446595';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '446595' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '743616';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '743616' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '743016';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '743016' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '742338';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '742338' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '743100';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '743100' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '741846';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '741846' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '741294';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '741294' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '741281';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '741281' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '741003';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '741003' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '740954';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '740954' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '740945';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '740945' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '740518';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '740518' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '740504';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '740504' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '16382';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '16382' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '740207';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '740207' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '739825';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '739825' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '739571';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '739571' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '739822';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '739822' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '446029';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '446029' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '739804';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '739804' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '739956';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '739956' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '445514';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '445514' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '739859';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '739859' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '739301';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '739301' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '738954';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '738954' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '738796';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '738796' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '738653';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '738653' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '738600';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '738600' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '444834';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '444834' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '445068';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '445068' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '737664';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '737664' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '737661';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '737661' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '15810';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '15810' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '15707';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '15707' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '444558';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '444558' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '736821';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '736821' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '736660';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '736660' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '736564';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '736564' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '736327';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '736327' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '736145';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '736145' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '736004';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '736004' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '15548';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '15548' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '735369';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '735369' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '15422';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '15422' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '735059';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '735059' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '734897';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '734897' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '443310';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '443310' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '443210';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '443210' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '443314';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '443314' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '443698';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '443698' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '443556';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '443556' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'F87' AND numero = '00037';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'F87' AND numero = '00037' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'F87' AND numero = '-54397';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'F87' AND numero = '-54397' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '15198';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '15198' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '734006';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '734006' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '733996';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '733996' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '733813';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '733813' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '733881';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '733881' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '442793';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '442793' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '733843';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '733843' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '733854';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '733854' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '-52262';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '-52262' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '14958';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '14958' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '733164';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '733164' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '733110';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '733110' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '14808';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '14808' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '441983';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '441983' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '441985';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '441985' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '442338';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '442338' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '732232';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '732232' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '732216';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '732216' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '732206';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '732206' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '732192';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '732192' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '732109';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '732109' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '732108';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '732108' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '732106';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '732106' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '732068';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '732068' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '732066';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '732066' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '731872';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '731872' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '731732';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '731732' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '731688';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '731688' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '731447';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '731447' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '731377';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '731377' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '731363';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '731363' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '731039';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '731039' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '730832';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '730832' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '14419';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '14419' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '730814';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '730814' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '730811';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '730811' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '14309';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '14309' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '730315';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '730315' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '440969';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '440969' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '730941';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '730941' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '441195';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '441195' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '440929';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '440929' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '729762';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '729762' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '729646';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '729646' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '729602';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '729602' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '729715';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '729715' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '729363';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '729363' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '729303';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '729303' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '14255';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '14255' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '729170';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '729170' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '729165';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '729165' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '728993';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '728993' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '728967';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '728967' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '729168';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '729168' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '439872';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '439872' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '440102';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '440102' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '440295';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '440295' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '728421';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '728421' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '727657';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '727657' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '727513';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '727513' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '439580';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '439580' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '727189';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '727189' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '727151';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '727151' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '726910';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '726910' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '726758';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '726758' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '726435';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '726435' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '726290';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '726290' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '438694';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '438694' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '438889';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '438889' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '726736';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '726736' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '439026';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '439026' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '438512';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '438512' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '725468';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '725468' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '437948';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '437948' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '437980';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '437980' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '437757';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '437757' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '438007';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '438007' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '437766';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '437766' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '725032';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '725032' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724818';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724818' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724811';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724811' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724626';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724626' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724607';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724607' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724537';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724537' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724535';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724535' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724269';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724269' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724008';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724008' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724797';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724797' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724616';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724616' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '437193';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '437193' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724589';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724589' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724551';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724551' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724657';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724657' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724634';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724634' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724883';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724883' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '436757';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '436757' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724625';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724625' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724620';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724620' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724647';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724647' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '437225';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '437225' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '437019';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '437019' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '436736';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '436736' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724707';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724707' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724689';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '724689' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '723676';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '723676' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '13566';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CODC' AND numero = '13566' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '723053';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '723053' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '436310';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '436310' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '722235';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '722235' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '722164';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '722164' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '722011';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '722011' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '721996';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '721996' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '721483';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '721483' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '435794';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'REM' AND numero = '435794' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '721332';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '721332' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '721111';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '721111' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '721099';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '721099' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '721098';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '721098' AND bodegaid = 87;
DELETE FROM kardextransito WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '721096';
DELETE FROM kardex WHERE tipodoc = 'TRB' AND prefijo = 'CRU' AND numero = '721096' AND bodegaid = 87;
INSERT INTO cargaarchivossucursal(sucursalid) VALUES(99);
