ALTER TABLE CTB_TEMP_CREDPRES ADD CDLOTE  VARCHAR2(16)
/

ALTER TABLE CTB_TEMP_CREDPRES ADD CDEMPRESA  VARCHAR2(02)
/

CREATE INDEX FIS00823_FK ON CTB_TEMP_CREDPRES ( CDEMPRESA, CDLOTE )
/

ALTER TABLE CTB_TEMP_CREDPRES 
   ADD CONSTRAINT FKFIS00823_CAPALOTE FOREIGN KEY (CDEMPRESA, CDLOTE)
      REFERENCES CAPALOTE (CDEMPRESA, CDLOTE) ON DELETE CASCADE
/   

ALTER TABLE AJUSTEAPURCONTR 
   ADD IDCONTABILIZADO  VARCHAR2(01) DEFAULT 'N' NOT NULL
      CONSTRAINT CKC_IDCONT_AJU CHECK(IDCONTABILIZADO  IN ('S','N'))
/

ALTER TABLE ITDETAPUCONTR 
   ADD IDCONTABILIZADO  VARCHAR2(01) DEFAULT 'N' NOT NULL
      CONSTRAINT CKC_IDCONT_TAPU CHECK(IDCONTABILIZADO  IN ('S','N'))
/

ALTER TABLE ITMAPARECUP 
   ADD IDCONTABILIZADO  VARCHAR2(01) DEFAULT 'N' NOT NULL
      CONSTRAINT CKC_IDCONT_MAPA CHECK(IDCONTABILIZADO  IN ('S','N'))
/