ALTER TABLE PARAMPLANEJA ADD IDARMAZAMOSTRA VARCHAR2(1)NULL
/
ALTER TABLE PARAMPLANEJA ADD CONSTRAINT CKC_IDARMAZAMOSTRA CHECK (IDARMAZAMOSTRA IN ('S', 'N'))
/
ALTER TABLE PARAMPLANEJA ADD IDLOCALAMOSTRA VARCHAR2(1) NULL
/
ALTER TABLE PARAMPLANEJA ADD CONSTRAINT CKC_IDLOCALAMOSTRA CHECK (IDLOCALAMOSTRA IN ('C', 'A'))
/
ALTER TABLE PARAMPLANEJA ADD PERCACRESCPA FLOAT
/
ALTER TABLE ITEMBDISTCARD ADD QTPRATOSEMACRESC FLOAT
/

ALTER TABLE CARDACLIPLANPROD ADD QTACRESCIMO FLOAT
/
ALTER TABLE CARDACLIPLANPROD ADD QTPORPESSOA FLOAT
/ 

ALTER TABLE PLANPRODACABADO ADD QTAMOSTRA FLOAT
/

ALTER TABLE PLANPRODFILIAGREGA ADD QTAMOSTRA FLOAT
/

ALTER TABLE ETIQUETACOZ ADD QTEXTRA FLOAT
/
ALTER TABLE ETIQUETACOZ ADD QTCOMENSAIS FLOAT
/