ALTER TABLE TIPORECEFILIAL ADD (
  IDGERABAIXAUTO VARCHAR2(2) DEFAULT 'S' NULL
)
/
ALTER TABLE TIPORECEFILIAL ADD CONSTRAINT CKC_TIPORECEFIL_IDGERABAIXAUTO CHECK (IDGERABAIXAUTO IN ('S','N'))
/
ALTER TABLE PARAVEND ADD (
  IDCONTTXSERVSEP VARCHAR2(1) DEFAULT 'N' NULL, 
  CDTPAJTXSERV VARCHAR2(4) NOT NULL, 
  VRTAXAADMISERV DOUBLE PRECISION NOT NULL, 
  CDTPAJTXADMSERV VARCHAR2(4) NOT NULL
)
/
ALTER TABLE PARAVEND ADD CONSTRAINT FKFIS00644TIPOAJRECEBER FOREIGN KEY (CDTPAJTXSERV, NRORG) REFERENCES TIPOAJRECEBER (CDAJUCTREC, NRORG)
/
ALTER TABLE PARAVEND ADD CONSTRAINT FKFIS00645TIPOAJRECEBER FOREIGN KEY (CDTPAJTXADMSERV, NRORG) REFERENCES TIPOAJRECEBER (CDAJUCTREC, NRORG)
/
ALTER TABLE PARAVEND ADD CONSTRAINT CKC_IDCONTTXSERVSEP_PARAVEND CHECK (IDCONTTXSERVSEP  IN ('S','N'))
/
ALTER TABLE TIPORECE ADD (
  IDGERABAIXAUTO VARCHAR2(1) DEFAULT 'S' NULL, 
  CDTPAJUSANGRRED VARCHAR2(4) NOT NULL, 
  CDTPAJUSANGRACR VARCHAR2(4) NOT NULL
)
/
ALTER TABLE TIPORECE ADD CONSTRAINT FKFIS00646TIPOAJRECEBER FOREIGN KEY (CDTPAJUSANGRRED, NRORG) REFERENCES TIPOAJRECEBER (CDAJUCTREC, NRORG)
/
ALTER TABLE TIPORECE ADD CONSTRAINT FKFIS00647TIPOAJRECEBER FOREIGN KEY (CDTPAJUSANGRACR, NRORG) REFERENCES TIPOAJRECEBER (CDAJUCTREC, NRORG)
/
ALTER TABLE TIPORECE ADD CONSTRAINT CKC_TIPORECE_IDGERABAIXAUTO CHECK (IDGERABAIXAUTO IN ('S','N'))