ALTER TABLE CONSMOVCAIXA ADD CDLOTECTB VARCHAR2(20)
/
CREATE INDEX LOGOPERFOS_02 ON LOGOPERFOS (CDFILIAL, CDCAIXA, IDOPERFOS, CDOPERRESPOP, DTHROPERFOS)
/
ALTER TABLE CONTOPECTBL ADD IDCTBSINTETICO VARCHAR2(01) DEFAULT 'S' NOT NULL
/
ALTER TABLE CONTOPECTBL ADD CONSTRAINT CKC_IDCTBSINTETICO CHECK (IDCTBSINTETICO IN ('N', 'S'))
/
ALTER TABLE DIVCONCILIACAO MODIFY VRESPERADO NULL