CREATE TABLE CURVAABCCLITEMP
(
   NRSEQCURVAABCCLI NUMBER           NOT NULL,
   CDEMPRESA        VARCHAR2(02)     NOT NULL,
   CDCLIENTE        VARCHAR2(21)     NOT NULL,
   NRSEQCURVAABC    NUMBER           NOT NULL,
   IDCURVAGERAL     VARCHAR2(01)     NULL,
   NRINSJURCLIE     VARCHAR2(20)     NULL,
   IDTPIJURCLIE     VARCHAR2(01)     NULL,
   NMRAZSOCCLIE     VARCHAR2(100)    NULL,
   NMEMPRESA        VARCHAR2(40)     NULL,
   CDFILIEMIT       VARCHAR2(04)     NULL,
   NMFILIAL         VARCHAR2(30)     NULL,
   DTBAIXAREC       DATE             NULL,
   DSCONTAREC       VARCHAR2(400)    NULL,
   DTATUAVENREC     DATE             NULL,
   VRATUAREC        FLOAT            NULL,
   VRFINALBREC      FLOAT            NULL,
   IDSTATREC        VARCHAR2(01)     NULL,
   NRNOTAFISC       VARCHAR2(20)     NULL,
   CDSERIE          VARCHAR2(05)     NULL,
   DTEMISSAO        DATE             NULL,
   VRPERC           FLOAT            NULL,
   VRTOTAL          FLOAT            NULL,
   VRTOTCLIE        FLOAT            NULL,
   NRTOTCLIE        NUMBER           NULL,
   VRPERCCLIE       FLOAT            NULL,
   VRPERCANT        FLOAT            NULL,
   IDTPCURVAABC     VARCHAR2(01)     NULL,
   CDTPCTRECEB      VARCHAR2(6)      NULL,
   DSTPCTRECEB      VARCHAR2(40)     NULL,
   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_NOMETABELA CHECK (IDATIVO IN ('S','N')),
	CONSTRAINT PK_CURVAABCCLITEMP PRIMARY KEY(NRSEQCURVAABCCLI, CDEMPRESA, CDCLIENTE, NRSEQCURVAABC)
)
/