CREATE TABLE SERVICOPROPOSTA  
(
   NRSERVICOPROPOSTA		NUMBER 														NOT NULL,
   CDSERVICOPROPOSTA 		VARCHAR2(5) 												NOT NULL,
    NMSERVICOPROPOSTA 		VARCHAR2(50)												NOT NULL,
    CDFILIAL 				VARCHAR2(4)													NULL,
    CDSERVFILI	 			VARCHAR2(5) 												NULL,
	NRORG 					NUMBER			DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') 	NOT NULL,
	IDATIVO 				VARCHAR2(1) 	DEFAULT 'S' 								NOT NULL
		CONSTRAINT CKC_IDATIVO_SERVICOPROPOSTA 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' 								NULL,
	CONSTRAINT PK_SERVICOPROPOSTA PRIMARY KEY (NRSERVICOPROPOSTA),
	CONSTRAINT UN_SERVICOPROPOSTA UNIQUE (CDSERVICOPROPOSTA)
)