CREATE TABLE PRODFILIDEST
(
	NRPAGINA VARCHAR2(4),
	CDFILIAL VARCHAR2(4),
	NMFILIAL VARCHAR2(30),
	CDPRODUTO VARCHAR2(10),
	CDARVPROD VARCHAR2(20),
	NMPRODUTO VARCHAR2(50),
	DTENTITPED DATE,
	VRPREUNITPED FLOAT,
	CDFILIALPED_1 VARCHAR2(4),
	QTPED_1 FLOAT,
	CDFILIALPED_2 VARCHAR2(4),
	QTPED_2 FLOAT,
	CDFILIALPED_3 VARCHAR2(4),
	QTPED_3 FLOAT,
	CDFILIALPED_4 VARCHAR2(4),
	QTPED_4 FLOAT,
	CDFILIALPED_5 VARCHAR2(4),
	QTPED_5 FLOAT,
	CDFILIALPED_6 VARCHAR2(4),
	QTPED_6 FLOAT,
	CDFILIALPED_7 VARCHAR2(4),
	QTPED_7 FLOAT,
	CDFILIALPED_8 VARCHAR2(4),
	QTPED_8 FLOAT,
	CDFILIALPED_9 VARCHAR2(4),
	QTPED_9 FLOAT,
	CDFILIALPED_10 VARCHAR2(4),
	QTPED_10 FLOAT,
	NRORG NUMBER DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
	IDATIVO VARCHAR2(1) DEFAULT 'S' NOT NULL
		CONSTRAINT CKC_IDATIVO_PRODFILIDEST 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'
)
/