CREATE TABLE KDSPRODENTRADA
(
    CDKDSPRODENTRADA 	VARCHAR2(5) NOT NULL PRIMARY KEY,
    CDFILIAL 			VARCHAR2(4) NOT NULL,
    CDLOJA 				VARCHAR2(10) NOT NULL,
    CDPRODUTO 			VARCHAR2(10) NOT 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_KDSPRODENTRADA CHECK (IDATIVO IN ('S','N'))
)
/

CREATE TABLE KDSPRODEXCECAO
(    
    CDKDSPRODEXCECAO 	VARCHAR2 (5) NOT NULL PRIMARY KEY,
    CDFILIAL 			VARCHAR2(4) NOT NULL,
    CDLOJA 				VARCHAR2(10) NOT NULL,
    CDPRODUTO 			VARCHAR2(10) NOT 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_KDSPRODEXCECAO CHECK (IDATIVO IN ('S','N'))
)
/

ALTER TABLE TAG ADD NMTAGESPANHOL VARCHAR2(30)
/