CREATE TABLE CADBIOMETRIA
( 
	CDCADBIOMETRIA 			VARCHAR2(20) 					NOT NULL,
	CDFILIAL 				VARCHAR2(4) 						NULL,
	CDCONSUMIDOR 			VARCHAR2(21) 						NULL,
	CDLOJA 					VARCHAR2(10) 						NULL,
	CDCAIXA 				VARCHAR2(3) 						NULL,
	DTULTATUCADBIO 			DATE 								NULL,
		CONSTRAINT PK_CADBIOMETRIA PRIMARY KEY (CDCADBIOMETRIA),
	NRORG             		NUMBER 	     	DEFAULT         SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
    IDATIVO           		VARCHAR2(1)     DEFAULT 'S' 	NOT NULL
		CONSTRAINT CKC_IDATIVO_CADBIOMETRIA CHECK (IDATIVO IN ('S','N')),
    DTINCLUSAO        		DATE                  				NULL,
    DTULTATU          		DATE                  				NULL,
    NRORGINCLUSAO     		NUMBER          					NULL,
    CDOPERINCLUSAO    		VARCHAR2(12)    DEFAULT '1' 		NULL,
    NRORGULTATU       		NUMBER          					NULL,
    CDOPERULTATU      		VARCHAR2(12)    DEFAULT '1'	
)
/