CREATE TABLE CONFIGSITECASHBACK
( 
    CORPRIMARIA                 VARCHAR2(10),
    CORSECUNDARIA               VARCHAR2(10),
    CORBOTAO                    VARCHAR2(10),
    CORRODAPE                   VARCHAR2(10),
    LOGOPRINCIPAL               CLOB,
    LOGORODAPE                  CLOB,
    TEXTOSUCESSO                VARCHAR2(500),
    TEXTOJACADASTRADO           VARCHAR2(500),
    TEXTOVENDASNAOENCONTRADO    VARCHAR2(500),
    APPPROPRIO                  VARCHAR2(1),
    LINKPLAYSTORE               VARCHAR2(120),
    LINKAPPSTORE                VARCHAR2(120),
    ENVIOSMS                    VARCHAR2(1),
    URLSMS                      VARCHAR2(120),
    TOKENTELE                   VARCHAR2(120),
    NMLOJASMS                   VARCHAR2(120),
    MENSASALDOSMS               VARCHAR2(120),
    MENSACREDGERA               VARCHAR2(120),
    MENSACADCONSUMIDOR          VARCHAR2(120),
    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_CONFIGSITECASHBACK  CHECK (IDATIVO IN ('S','N'))
)
/