CREATE TABLE ORCAFINACENTCUST (
   CDCENTCUST        VARCHAR2(6) NOT NULL , 
	CDEMPRESA         VARCHAR2(2) NOT NULL , 
	CDFILIAL          VARCHAR2(4) NOT NULL , 
	DTORCAFINA        DATE NOT NULL , 
	VRORCAFINA        FLOAT, 
	VRREALORCA        FLOAT, 
	VREXTOLEORCA      FLOAT, 
	NRORG             NUMBER 	     DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') 		NOT NULL,
   IDATIVO           VARCHAR2(1)     DEFAULT 'S'					NOT NULL,
   DTINCLUSAO        DATE            DEFAULT SYSDATE,
   DTULTATU          DATE            DEFAULT SYSDATE,
   NRORGINCLUSAO     NUMBER          DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg')		NULL,
   CDOPERINCLUSAO    VARCHAR2(12)    DEFAULT '1' 					NULL,
   NRORGULTATU       NUMBER          DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg')		NULL,
   CDOPERULTATU      VARCHAR2(12)    DEFAULT '1',
	   CONSTRAINT CKC_IDATIVO_ORCAFINACENTCUST CHECK (IDATIVO IN ('S','N')),
	   CONSTRAINT PK_ORCAFINACENTCUST PRIMARY KEY (CDCENTCUST, CDEMPRESA, CDFILIAL, DTORCAFINA)
) 
/