ALTER TABLE PARAVEND ADD (
  CDCLIENTEPADFIS VARCHAR2(21) DEFAULT NULL NULL, 
  IDGERAMRNUMREDZ VARCHAR2(1) DEFAULT NULL NULL
)
/
ALTER TABLE PARAVEND ADD CONSTRAINT FKFIS00654CLIENTE FOREIGN KEY (CDCLIENTEPADFIS, NRORG) REFERENCES CLIENTE (CDCLIENTE, NRORG)
/
ALTER TABLE PARAVEND ADD CONSTRAINT CKC_IDGERAMRNUMREDZ_PARAVEND CHECK (IDGERAMRNUMREDZ IN ('S','N'))
/
ALTER TABLE TIPORECEFILIAL ADD (
  CDCLIENTE VARCHAR2(21) DEFAULT NULL NULL, 
  CDTPCTRECEB VARCHAR2(6) DEFAULT NULL NULL, 
  CDAJTXADMREC VARCHAR2(4) DEFAULT NULL NULL, 
  CDTPAJUSANGRRED VARCHAR2(4) DEFAULT NULL NULL, 
  CDTPAJUSANGRACR VARCHAR2(4) DEFAULT NULL NULL
)
/
ALTER TABLE TIPORECEFILIAL ADD CONSTRAINT FKFIS00655CLIENTE FOREIGN KEY (CDCLIENTE, NRORG) REFERENCES CLIENTE (CDCLIENTE, NRORG)
/
ALTER TABLE TIPORECEFILIAL ADD CONSTRAINT FKFIS00656CLIENTE FOREIGN KEY (CDTPCTRECEB, NRORG) REFERENCES TIPOCTRECEBER (CDTPCTRECEB, NRORG)
/
ALTER TABLE TIPORECEFILIAL ADD CONSTRAINT FKFIS00657TIPOAJRECEBER FOREIGN KEY (CDAJTXADMREC, NRORG) REFERENCES TIPOAJRECEBER (CDAJUCTREC, NRORG)
/
ALTER TABLE TIPORECEFILIAL ADD CONSTRAINT FKFIS00658TIPOAJRECEBER FOREIGN KEY (CDTPAJUSANGRRED, NRORG) REFERENCES TIPOAJRECEBER (CDAJUCTREC, NRORG)
/
ALTER TABLE TIPORECEFILIAL ADD CONSTRAINT FKFIS00659TIPOAJRECEBER FOREIGN KEY (CDTPAJUSANGRACR, NRORG) REFERENCES TIPOAJRECEBER (CDAJUCTREC, NRORG)