CREATE TABLE ETLAJUSTECONS (
  NRETLAJUSTECONS NUMBER(10) NOT NULL, 
  CDFILIAL VARCHAR2(4) DEFAULT NULL NULL, 
  NMFILIAL VARCHAR2(30) DEFAULT NULL NULL, 
  VRRETIRADA DOUBLE PRECISION DEFAULT NULL NULL, 
  VRAJUSTE DOUBLE PRECISION DEFAULT NULL NULL, 
  DTINICIAL DATE DEFAULT NULL NULL, 
  DTFINAL DATE DEFAULT NULL NULL, 
  DTULTAPUR DATE DEFAULT NULL NULL, 
  NRORG NUMBER(10) DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL, 
  IDATIVO VARCHAR2(1) DEFAULT 'S' NOT NULL, 
  DTINCLUSAO DATE DEFAULT NULL NULL, 
  DTULTATU DATE DEFAULT NULL NULL, 
  NRORGINCLUSAO NUMBER(10) DEFAULT 1 NULL, 
  NRORGULTATU NUMBER(10) DEFAULT 1 NULL, 
  CDOPERINCLUSAO VARCHAR2(12) DEFAULT '1' NULL, 
  CDOPERULTATU VARCHAR2(12) DEFAULT '1' NULL,
  CONSTRAINT PK_ETLAJUSTECONS PRIMARY KEY(NRETLAJUSTECONS)
)
/
ALTER TABLE ETLAJUSTECONS ADD CONSTRAINT CKC_IDATIVO_ETLAJUSTECONS CHECK (IDATIVO IN ('S','N'))