ALTER TABLE BASECALC ADD NRORG NUMBER DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL
/

ALTER TABLE BASECALC ADD IDATIVO VARCHAR2(1) DEFAULT 'S' NOT NULL
/

ALTER TABLE BASECALC ADD CONSTRAINT CKC_IDATIVO_BASECALC CHECK (IDATIVO IN ('S', 'N'))
/

ALTER TABLE BASECALC ADD DTINCLUSAO DATE NULL
/

ALTER TABLE BASECALC ADD DTULTATU DATE NULL
/

ALTER TABLE BASECALC ADD NRORGINCLUSAO NUMBER DEFAULT 1 NULL
/

ALTER TABLE BASECALC ADD CDOPERINCLUSAO VARCHAR2(12) DEFAULT '1' NULL
/

ALTER TABLE BASECALC ADD NRORGULTATU NUMBER DEFAULT 1 NULL
/

ALTER TABLE BASECALC ADD CDOPERULTATU VARCHAR2(12) DEFAULT '1' NULL
/

ALTER TABLE BASECALCTPOPER ADD NRORG NUMBER DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL
/

ALTER TABLE BASECALCTPOPER ADD IDATIVO VARCHAR2(1) DEFAULT 'S' NOT NULL
/

ALTER TABLE BASECALCTPOPER ADD CONSTRAINT CKC_IDATIVO_BASECALCTPOPER CHECK (IDATIVO IN ('S', 'N'))
/

ALTER TABLE BASECALCTPOPER ADD DTINCLUSAO DATE NULL
/

ALTER TABLE BASECALCTPOPER ADD DTULTATU DATE NULL
/

ALTER TABLE BASECALCTPOPER ADD NRORGINCLUSAO NUMBER DEFAULT 1 NULL
/

ALTER TABLE BASECALCTPOPER ADD CDOPERINCLUSAO VARCHAR2(12) DEFAULT '1' NULL
/

ALTER TABLE BASECALCTPOPER ADD NRORGULTATU NUMBER DEFAULT 1 NULL
/

ALTER TABLE BASECALCTPOPER ADD CDOPERULTATU VARCHAR2(12) DEFAULT '1' NULL
/