CREATE TABLE LOGINTCARDPAE(
	NRLOGINTCARDPAE NUMBER 		 NOT NULL,
	CDFILCENTPME    VARCHAR2(4)  NOT NULL,
	CDTIPOCARD      VARCHAR2(10) NULL,
	DTCARDIAPME     DATE 		 NULL,
	CDSERVFILI      VARCHAR2(5)  NULL,
	CDFILIAL        VARCHAR2(4)  NULL,
	CDPRATO         VARCHAR2(10) NULL,
	CDFILAUXPRAT    VARCHAR2(4)	 NULL,
	CDPRODUTO       VARCHAR2(10) NULL,
	NRERRO          NUMBER 		 NOT NULL,
	NRORG 		    NUMBER 		 DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
	IDATIVO 	    VARCHAR2(1)  DEFAULT 'S' 							  NOT NULL
		CONSTRAINT CKC_IDATIVO_LOGINTCARDPAE CHECK (IDATIVO IN ('S', 'N')),
	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'							  NULL
)
/