ALTER TABLE CNFDISTCARD ADD CDFILANCTO VARCHAR2(4) NULL
/
ALTER TABLE CNFDISTCARD ADD NRLANCESTQSAID VARCHAR2(10) NULL
/
ALTER TABLE CNFDISTCARD ADD NRLANCESTQENTR VARCHAR2(10) NULL
/
ALTER TABLE CNFDISTCARD ADD NRRETIRADA VARCHAR2(10) NULL
/
ALTER TABLE CNFDISTCARD ADD IDEFETIVADA VARCHAR2(1) NULL
/
ALTER TABLE CNFDISTCARD ADD CONSTRAINT CKC_IDEFETIVADA_CNFDISTCARD CHECK (IDEFETIVADA IN ('S', 'N'))
/
ALTER TABLE PRODDISTPROD ADD IDEFETIVADA VARCHAR2(1) NULL
/
ALTER TABLE PRODDISTPROD ADD CONSTRAINT CKC_IDEFETIVADA_PRODDISTPROD CHECK (IDEFETIVADA IN ('S', 'N'))