ALTER TABLE ITCOMANDAEST ADD IDIMPPRGRPROMO VARCHAR2(1) DEFAULT 'N' NOT NULL
   CONSTRAINT CKC_IDIMPPRGRPROMO_ITCOMANDAES CHECK (IDIMPPRGRPROMO IN ('S','N')) NOVALIDATE
/

ALTER TABLE ITCOMANDAEST ADD VRACRITCOMEST FLOAT DEFAULT 0 NOT NULL
/

ALTER TABLE ITEMVENDAEST ADD IDIMPPRGRPROMO VARCHAR2(1) DEFAULT 'N' NOT NULL
   CONSTRAINT CKC_IDIMPPRGRPROMO_ITEMVENDAES CHECK (IDIMPPRGRPROMO IN ('S','N')) NOVALIDATE
/

ALTER TABLE ITEMVENDAEST ADD VRACRITVENDAEST FLOAT DEFAULT 0 NOT NULL
/

ALTER TABLE ITCOMANDAVEN ADD IDIMPPRGRPROMO VARCHAR2(1) DEFAULT 'N' NOT NULL
   CONSTRAINT CKC_IDIMPPRGRPROMO_ITCOMANDAVE CHECK (IDIMPPRGRPROMO IN ('S','N')) NOVALIDATE
/

ALTER TABLE ITEMVENDA ADD IDIMPPRGRPROMO VARCHAR2(1) DEFAULT 'N' NOT NULL
   CONSTRAINT CKC_IDIMPPRGRPROMO_ITEMVENDA CHECK (IDIMPPRGRPROMO IN ('S','N')) NOVALIDATE
/