--------------------------------------------------------------------------
-- Play this script in PRUEBAS@VISANY to make it look like DESA@VISMAR
--                                                                      --
-- Please review the script before using it to make sure it won't       --
-- cause any unacceptable data loss.                                    --
--                                                                      --
-- PRUEBAS@VISANY Schema Extracted by User PRUEBAS 
-- DESA@VISMAR Schema Extracted by User DESA 
ALTER TABLE BANHIS
MODIFY(SALDO_INI NUMBER(14,2));

ALTER TABLE BANHIS
MODIFY(DEBMES NUMBER(14,2));

ALTER TABLE BANHIS
MODIFY(CREMES NUMBER(14,2));

ALTER TABLE BANHIS
MODIFY(INGPEN NUMBER(14,2));

ALTER TABLE BANHIS
MODIFY(EGRPEN NUMBER(14,2));

ALTER TABLE BANHIS
MODIFY(LIMITE NUMBER(14,2));

ALTER TABLE BANHIS
MODIFY(SALBAN NUMBER(14,2));

ALTER TABLE BANHIS
MODIFY(DEBBAN NUMBER(14,2));

ALTER TABLE BANHIS
MODIFY(CREBAN NUMBER(14,2));

ALTER TABLE BANMAE
MODIFY(SALDO_INI NUMBER(14,2));

ALTER TABLE BANMAE
MODIFY(DEBMES NUMBER(14,2));

ALTER TABLE BANMAE
MODIFY(CREMES NUMBER(14,2));

ALTER TABLE BANMAE
MODIFY(INGPEN NUMBER(14,2));

ALTER TABLE BANMAE
MODIFY(EGRPEN NUMBER(14,2));

ALTER TABLE BANMAE
MODIFY(LIMITE NUMBER(14,2));

ALTER TABLE BANMAE
MODIFY(SOBREGIRO NUMBER(14,2));

ALTER TABLE BANMAE
MODIFY(SALBAN NUMBER(14,2));

ALTER TABLE BANMAE
MODIFY(DEBBAN NUMBER(14,2));

ALTER TABLE BANMAE
MODIFY(CREBAN NUMBER(14,2));

ALTER TABLE BANCON
MODIFY(DEBITO NUMBER(14,2));

ALTER TABLE BANCON
MODIFY(CREDITO NUMBER(14,2));

ALTER TABLE BANEST
MODIFY(SALBAN NUMBER(14,2));

ALTER TABLE BANEST
MODIFY(DEBBAN NUMBER(14,2));

ALTER TABLE BANEST
MODIFY(CREBAN NUMBER(14,2));

ALTER TABLE BANESTDET
MODIFY(MONTO NUMBER(14,2));

ALTER TABLE BANFAC
MODIFY(MONTO NUMBER(14,2));

ALTER TABLE BANFAC
MODIFY(INTERES NUMBER(14,2));

ALTER TABLE BANFAC
MODIFY(INT_MORA NUMBER(14,2));

ALTER TABLE BANLIN
 ADD CONSTRAINT BANLIN_TIPO_CK CHECK (TIPO IN ('BAN','CNT','FEC','FLN','BEN','LET','MON','DBC','CRC','LUG','DET','DCN','COD','HEC','REV','CHE','CON','ROT','CCO'));