CREATE TABLE TMP_ATUPRODRECE (
    NRTMPATUPRODRECE NUMBER 		NULL, 
    NMTABLE 		VARCHAR2(10) 	NULL,
    CDFILAUXPRAT	VARCHAR2(4) 	NULL,
    CDPRATO 		VARCHAR2(10)	NULL,
    CDFILCENTPME 	VARCHAR2(4) 	NULL,
    CDTIPOCARD 		VARCHAR2(10) 	NULL,
    CDFILIAL 		VARCHAR2(4) 	NULL,
    CDSERVFILI 		VARCHAR2(5) 	NULL,
    HRTEMPPREPPR 	VARCHAR2(5) 	NULL,
    SGUNIDADE 		VARCHAR2(10) 	NULL,
    IDPRODBASEPR 	VARCHAR2(1) 	NULL, 
    CDAPRERECE 		VARCHAR2(3) 	NULL,
    SGUNIDPROD 		VARCHAR2(10) 	NULL,
    CDPRODUTO 		VARCHAR2(10) 	NULL,
    CDPRODNOVO 		VARCHAR2(10) 	NULL,
    CDPRODORIG 		VARCHAR2(10) 	NULL,
    QTPRODPRAT 		FLOAT 			NULL, 
    VRPEFATCOCPR 	FLOAT 			NULL,
    VRPEFATCORPR 	FLOAT 			NULL,
    QTUNIDESTPR 	FLOAT 			NULL,
	QTBRUTAPR 		FLOAT 			NULL,
    VRPEFATNUTPR 	FLOAT 			NULL,
    QTCALCNUTRPR 	FLOAT 			NULL,
    QTBRUTAPRUNR 	FLOAT 			NULL,
    DTULTATURECP 	DATE 			NULL,
	NRORG 			NUMBER 			DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
	IDATIVO 		VARCHAR2(1) 	DEFAULT 'S' NOT NULL,
		CONSTRAINT CKC_IDATIVO_TMP_ATUPRODRECE 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'
)