CREATE TABLE ANEXOLANCBOL
   (	
    NRANEXOLANCBOL 		NUMBER 				NOT NULL, 
	NRLANBOLPAG 		NUMBER, 
	NRLANBOLREC 		NUMBER, 
	CDTELA 				VARCHAR2(20) 		NOT NULL, 
	CDFILIAL 			VARCHAR2(2), 
	DTANEXOLANCBOL 		DATE 				NOT NULL, 
	NMANEXOLANCBOL 		VARCHAR2(200) 		NOT NULL, 
	NMPATHANEXO 		VARCHAR2(200) 		NOT NULL, 
	DSANEXOLANCBOL 		VARCHAR2(1000) 		NOT NULL, 
	DSINFOANEXO 		VARCHAR2(4000),
	NRORG 				NUMBER 				DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL, 
	DTINCLUSAO        	DATE                NULL,
    DTULTATU          	DATE                NULL,
	NRORGINCLUSAO     	NUMBER          	DEFAULT 1 			NULL,
    CDOPERINCLUSAO    	VARCHAR2(12)    	DEFAULT '1' 		NULL,
    NRORGULTATU       	NUMBER          	DEFAULT 1 			NULL,
    CDOPERULTATU      	VARCHAR2(12)    	DEFAULT '1',
	IDATIVO 			VARCHAR2(1) 		DEFAULT 'S' 		NOT NULL , 
		CONSTRAINT CKC_IDATIVO_ANEXOLANCBOL CHECK (IDATIVO IN ('S','N')), 
		CONSTRAINT PK_ANEXOLANCBOL PRIMARY KEY (NRANEXOLANCBOL)
)