CREATE TABLE INFPRODDANFE 
(
	NRSEQUENCIAL 		NUMBER 						NOT NULL,
	IDENVINFPROD 		VARCHAR2(01),
	DSTAGINFPROD 		VARCHAR2(40),
	DSEMISINFPROD 		VARCHAR2(255),
	IDPERMALTREG  		VARCHAR2(01) 	DEFAULT 'S' NOT NULL,
	NRORG             	NUMBER 	     	DEFAULT     SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
    IDATIVO           	VARCHAR2(1)     DEFAULT 'S' NOT NULL
			CONSTRAINT CKC_IDATIVO_INFPRODDANFE 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'
)
/

INSERT INTO INFPRODDANFE (NRSEQUENCIAL,  IDENVINFPROD, DSTAGINFPROD, DSEMISINFPROD)
VALUES (1, 'S', 'vBCFCP', 'BcFcp')
/
INSERT INTO INFPRODDANFE (NRSEQUENCIAL,  IDENVINFPROD, DSTAGINFPROD, DSEMISINFPROD)
VALUES (2, 'S', 'pFCP', 'pFcp')
/
INSERT INTO INFPRODDANFE (NRSEQUENCIAL,  IDENVINFPROD, DSTAGINFPROD, DSEMISINFPROD)
VALUES (3, 'S', 'vFCP', 'vFcp')
/
INSERT INTO INFPRODDANFE (NRSEQUENCIAL,  IDENVINFPROD, DSTAGINFPROD, DSEMISINFPROD)
VALUES (4, 'S', 'pRedBC', 'pRedBC')
/
INSERT INTO INFPRODDANFE (NRSEQUENCIAL,  IDENVINFPROD, DSTAGINFPROD, DSEMISINFPROD)
VALUES (5, 'S', 'pMAVST', 'IVA/MVA')
/
INSERT INTO INFPRODDANFE (NRSEQUENCIAL,  IDENVINFPROD, DSTAGINFPROD, DSEMISINFPROD)
VALUES (6, 'S', 'pICMSST', 'pIcmsSt')
/
INSERT INTO INFPRODDANFE (NRSEQUENCIAL,  IDENVINFPROD, DSTAGINFPROD, DSEMISINFPROD)
VALUES (7, 'S', 'vBCST', 'BcICMSSt')
/
INSERT INTO INFPRODDANFE (NRSEQUENCIAL,  IDENVINFPROD, DSTAGINFPROD, DSEMISINFPROD)
VALUES (8, 'S', 'vICMSST', 'vICMSSt')
/
INSERT INTO INFPRODDANFE (NRSEQUENCIAL,  IDENVINFPROD, DSTAGINFPROD, DSEMISINFPROD)
VALUES (9, 'S', 'vBCFCPST', 'BcFCPSt')
/
INSERT INTO INFPRODDANFE (NRSEQUENCIAL,  IDENVINFPROD, DSTAGINFPROD, DSEMISINFPROD)
VALUES (10, 'S', 'pFCPST', 'pFCPSt')
/
INSERT INTO INFPRODDANFE (NRSEQUENCIAL,  IDENVINFPROD, DSTAGINFPROD, DSEMISINFPROD)
VALUES (11, 'S', 'vFCPST', 'vFCPSt')
/
INSERT INTO INFPRODDANFE (NRSEQUENCIAL,  IDENVINFPROD, DSTAGINFPROD, DSEMISINFPROD)
VALUES (12, 'S', 'pFCPUFDest', 'pFCPUFDest')
/
INSERT INTO INFPRODDANFE (NRSEQUENCIAL,  IDENVINFPROD, DSTAGINFPROD, DSEMISINFPROD)
VALUES (13, 'S', 'pICMSUFDest', 'pICMSUFDest')
/
INSERT INTO INFPRODDANFE (NRSEQUENCIAL,  IDENVINFPROD, DSTAGINFPROD, DSEMISINFPROD)
VALUES (14, 'S', 'pICMSInterPart', 'pICMSInterPart')
/
INSERT INTO INFPRODDANFE (NRSEQUENCIAL,  IDENVINFPROD, DSTAGINFPROD, DSEMISINFPROD)
VALUES (15, 'S', 'vFCPUFDest', 'vFCPUFDest')
/
INSERT INTO INFPRODDANFE (NRSEQUENCIAL,  IDENVINFPROD, DSTAGINFPROD, DSEMISINFPROD)
VALUES (16, 'S', 'vICMSUFDest', 'vICMSUFDest')
/
INSERT INTO INFPRODDANFE (NRSEQUENCIAL,  IDENVINFPROD, DSTAGINFPROD, DSEMISINFPROD)
VALUES (17, 'S', 'vICMSUFRemet', 'vICMSUFRemet')
/
INSERT INTO INFPRODDANFE (NRSEQUENCIAL,  IDENVINFPROD, DSTAGINFPROD, DSEMISINFPROD)
VALUES (18, 'S', 'cEAN', 'cEAN')
/
INSERT INTO INFPRODDANFE (NRSEQUENCIAL,  IDENVINFPROD, DSTAGINFPROD, DSEMISINFPROD)
VALUES (19, 'S', 'cEANTrib', 'cEANTrib')
/
INSERT INTO INFPRODDANFE (NRSEQUENCIAL,  IDENVINFPROD, DSTAGINFPROD, DSEMISINFPROD)
VALUES (20, 'S', 'vUnTrib', 'vUnTrib')
/
INSERT INTO INFPRODDANFE (NRSEQUENCIAL,  IDENVINFPROD, DSTAGINFPROD, DSEMISINFPROD)
VALUES (21, 'S', 'qTrib', 'qTrib')
/
INSERT INTO INFPRODDANFE (NRSEQUENCIAL,  IDENVINFPROD, DSTAGINFPROD, DSEMISINFPROD)
VALUES (22, 'S', 'uTrib', 'uTrib')
/
COMMIT
/