CREATE TABLE EMPRTPCTPAG
(	CDTPCTPAGAR 	VARCHAR2(6)		NOT NULL, 
	CDEMPRESA 		VARCHAR2(3) 	NOT NULL, 
	NRORG           NUMBER 			DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
	IDATIVO         VARCHAR2(1) 	DEFAULT 'S' NOT NULL
		CONSTRAINT CKC_IDATIVO_EMPRTPCTPAG CHECK (IDATIVO IN ('S','N')),
	DTINCLUSAO      DATE        	NULL,
	DTULTATU        DATE     	   	NULL,
	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 PK_EMPRTPCTPAG PRIMARY KEY (CDEMPRESA, CDTPCTPAGAR)
   )
/

CREATE INDEX FK_FIN00401 ON EMPRTPCTPAG (CDTPCTPAGAR  ASC)
/

ALTER TABLE EMPRTPCTPAG
    ADD CONSTRAINT FKFIN00401TIPOCTPAGAR  FOREIGN KEY  (CDTPCTPAGAR )
       REFERENCES TIPOCTPAGAR (CDTPCTPAGAR ) ON DELETE CASCADE