
/*------ ATD 403772 ------*/
DECLARE v_count NUMBER(1) := 0; 
BEGIN 
SELECT Count(1) INTO v_count FROM USER_TAB_COLUMNS WHERE Upper(table_name) = DADOSNOTANFE Upper(column_name) = 'NFSIMPLESFATURAMENTO'; 
IF v_count = 0 THEN
BEGIN
EXECUTE IMMEDIATE 'ALTER TABLE DadosNotaNFE ADD NFSimplesFaturamento Number(9) default 0 not null '; 
END;
END;
