CREATE TABLE CONSUMOREAL (
  CDOPERULTATU VARCHAR2(12) DEFAULT '1' NULL, 
  CDFILIAL VARCHAR2(4) NOT NULL, 
  DTCONSUMO DATE NOT NULL, 
  CDPRODUTO VARCHAR2(10) NOT NULL, 
  VRTOTCONSUMO DOUBLE PRECISION NOT NULL, 
  IDSTATCONSU VARCHAR2(1) DEFAULT 'N' NOT NULL, 
  IDATIVO VARCHAR2(1) DEFAULT 'S' NOT NULL, 
  DTULTATU DATE DEFAULT NULL NULL, 
  NRORGINCLUSAO NUMBER(10) DEFAULT 1 NULL, 
  CDOPERINCLUSAO VARCHAR2(255) DEFAULT '1' NULL, 
  QTCONSUMO DOUBLE PRECISION NOT NULL, 
  VRCONSUMO DOUBLE PRECISION NOT NULL, 
  NRORG NUMBER(10) DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL, 
  DTINCLUSAO DATE DEFAULT NULL NULL, 
  NRORGULTATU NUMBER(10) DEFAULT 1 NULL
)