ALTER TABLE PARAMESTSPED ADD IDCALCICMSSTRJ VARCHAR2(1)  DEFAULT 'N' NOT NULL
		CONSTRAINT CKC_IDCALCICMSSTRJ_PARAM CHECK (IDCALCICMSSTRJ IN ('S','N'))
/

 ALTER TABLE PARAMESTSPED ADD CDAJCREDSTRJ  VARCHAR2(10)  NULL                         
/

ALTER TABLE PARAMESTSPED ADD DSAJCREDSTRJ VARCHAR2(250)   NULL                      
/

ALTER TABLE PARAMESTSPED ADD CDRATPADSTRJTPEN VARCHAR2(4)   NULL   
/            

CREATE INDEX FIS00869_FK ON PARAMESTSPED (CDRATPADSTRJTPEN ASC)
/

ALTER TABLE PARAMESTSPED 
   ADD CONSTRAINT FKFIS00869RATEIOPA  FOREIGN KEY (CDRATPADSTRJTPEN)
       REFERENCES RATEIOPADRAOFIS (CDRATEIOPADRAO)
/  

ALTER TABLE PARAMESTSPED ADD  CDRATPADSTRJFIL VARCHAR2(4)  NULL                     
/

CREATE INDEX FIS00870_FK ON PARAMESTSPED (CDRATPADSTRJFIL  ASC)
/

ALTER TABLE PARAMESTSPED 
   ADD CONSTRAINT FKFIS00870RATEIOPA  FOREIGN KEY (CDRATPADSTRJFIL)
       REFERENCES RATEIOPADRAOFIS (CDRATEIOPADRAO)
/  

ALTER TABLE PARAMESTSPED ADD CDRATPADSTRJCFOPE VARCHAR2(4)  NULL              
/

CREATE INDEX FIS00871_FK ON PARAMESTSPED (CDRATPADSTRJCFOPE ASC)
/

ALTER TABLE PARAMESTSPED 
   ADD CONSTRAINT FKFIS00871RATEIOPA  FOREIGN KEY (CDRATPADSTRJCFOPE)
       REFERENCES RATEIOPADRAOFIS (CDRATEIOPADRAO)
/  

ALTER TABLE PARAMESTSPED ADD CDRATPADSTRJCFOPS VARCHAR2(4) NULL               
/

CREATE INDEX FIS00872_FK ON PARAMESTSPED (CDRATPADSTRJCFOPS ASC)
/

ALTER TABLE PARAMESTSPED 
   ADD CONSTRAINT FKFIS00872RATEIOPA  FOREIGN KEY (CDRATPADSTRJCFOPS)
       REFERENCES RATEIOPADRAOFIS (CDRATEIOPADRAO)
/  

ALTER TABLE PARAMESTSPED ADD CDRATPADSTRJNCMS VARCHAR2(4)  NULL              
/

CREATE INDEX FIS00873_FK ON PARAMESTSPED (CDRATPADSTRJNCMS ASC)
/

ALTER TABLE PARAMESTSPED 
   ADD CONSTRAINT FKFIS00873RATEIOPA  FOREIGN KEY (CDRATPADSTRJNCMS)
       REFERENCES RATEIOPADRAOFIS (CDRATEIOPADRAO)
/

ALTER TABLE PARAMESTSPED ADD IDCALCICMSSTMG VARCHAR2(1)  DEFAULT 'N' NOT NULL
		CONSTRAINT CKC_IDCALCICMSSTMG_PARAM CHECK (IDCALCICMSSTMG IN ('S','N'))
/

ALTER TABLE PARAMESTSPED ADD CDRATPADSTMGTPEN VARCHAR2(4)     NULL       
/

CREATE INDEX FIS00874_FK ON PARAMESTSPED (CDRATPADSTMGTPEN ASC)
/

ALTER TABLE PARAMESTSPED 
   ADD CONSTRAINT FKFIS00874RATEIOPA  FOREIGN KEY (CDRATPADSTMGTPEN)
       REFERENCES RATEIOPADRAOFIS (CDRATEIOPADRAO)
/  

ALTER TABLE PARAMESTSPED ADD CDRATPADSTMGPROD VARCHAR2(4)  NULL           
/

CREATE INDEX FIS00875_FK ON PARAMESTSPED (CDRATPADSTMGPROD ASC)
/

ALTER TABLE PARAMESTSPED
   ADD CONSTRAINT FKFIS00875RATEIOPA  FOREIGN KEY (CDRATPADSTMGPROD)
       REFERENCES RATEIOPADRAOFIS (CDRATEIOPADRAO)
/