correcciones_metronorte_alex.md

select * from CAJA
WHERE DOCNUM = '5664' AND TIPODOC = 'F' AND SERIE = 'METRO2'

UPDATE CAJA SET DOCNUM = '5666' WHERE DOCNUM = '5664' AND TIPODOC = 'F' AND SERIE = 'METRO2'

select * from CAJAD WHERE DOCNUM = '5666' AND TIPODOC = 'F' AND SERIE = 'METRO2'

select * from COMVEN
WHERE DOCNUM = '5666' AND TIPODOC = 'F' AND SERIE = 'METRO2'

UPDATE CAJA SET DOCNUM = '5646' WHERE DOCNUM = '5644' AND TIPODOC = 'F' AND SERIE = 'METRO2';
select * from COMVEN
WHERE DOCNUM = '5646' AND TIPODOC = 'F' AND SERIE = 'METRO2';
```

select * from CAJA where TIPODOC = 'F' and SERIE = 'SANA2' and DOCNUM = '88575';

update caja set FECHA = '27/05/2021 17:50:08' where TIPODOC = 'F' and SERIE = 'SANA2' and DOCNUM = '88575';

update caja set FECHA = '2021-05-27 17:50:08.6170' where TIPODOC = 'F' and SERIE = 'SANA2' and DOCNUM = '88575';

update COMVEN set FECHA = '2021-05-27 17:50:08.6170' where TIPODOC = 'F' and SERIE = 'SANA2' and DOCNUM = '88575';

select * from COMVEN where TIPODOC = 'F' and SERIE = 'SANA2' and DOCNUM = '88575';

update CAJA set FECHA = '2021-05-27 17:36:39.6170' where TIPODOC = 'F' and SERIE = 'SANA2' and DOCNUM = '88573';

select * from CAJA where TIPODOC = 'F' and SERIE = 'SANA2' and DOCNUM = '88573';

update COMVEN set FECHA = '2021-05-27 17:36:39.6170' where TIPODOC = 'F' and SERIE = 'SANA2' and DOCNUM = '88573';

select * from COMVEN where TIPODOC = 'F' and SERIE = 'SANA2' and DOCNUM = '88573';

select * from CAJA
where TIPODOC = 'A' and DOCNUM = '5089'

UPDATE CAJA SET DOCNUM = '5666' WHERE DOCNUM = '5089' AND TIPODOC = 'A' AND SERIE = 'DA2'

UPDATE CAJA SET SERIE = 'GTDA2' WHERE DOCNUM = '5089' AND TIPODOC = 'A' AND SERIE = 'DA2'

UPDATE CAJA SET CODPROV = '2' WHERE DOCNUM = '5154' AND TIPODOC = 'A' AND SERIE = 'GTDA2';

select * from CAJA
where TIPODOC = 'A' and SERIE = 'GTDA2' and DOCNUM = '5154'