CREATE TABLE RATCTPAGARCLI 
( 
    CDFILIAL            VARCHAR2(4)            NOT NULL,
    NRLANCTONF          VARCHAR2(10)           NOT NULL,
    NRSEQVENPAG         VARCHAR2(2)            NOT NULL,
    NRPARCELAPAG        VARCHAR2(2)            NOT NULL,
    CDCLIENTE           VARCHAR2(20)           NOT NULL,
    CDFIRATCTPAG        VARCHAR2(4)            NOT NULL,
    VRRATCCCTPAG        FLOAT                  NOT NULL,
    NRORG               NUMBER 	        DEFAULT         SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
    IDATIVO             VARCHAR2(1)     DEFAULT 'S' NOT NULL
      CONSTRAINT CKC_IDATIVO_RATCTPAGARCLI CHECK (IDATIVO IN ('S','N')),
    DTINCLUSAO          DATE                  			NULL, 
    DTULTATU            DATE                  			NULL,
    NRORGINCLUSAO       NUMBER          				NULL,
    CDOPERINCLUSAO      VARCHAR2(12)    DEFAULT '1' 	NULL,
    NRORGULTATU         NUMBER          				NULL,
    CDOPERULTATU        VARCHAR2(12)    DEFAULT '1',
        CONSTRAINT PK_RATCTPAGARCLI PRIMARY KEY (CDFILIAL, NRLANCTONF, NRSEQVENPAG, NRPARCELAPAG, CDCLIENTE, CDFIRATCTPAG)
)
/