
/*------ ATD 256081 ------*/
IF NOT EXISTS (SELECT 1 FROM SYSCOLUMNS WHERE name = 'vICMSDeson' and syscolumns.id IN (SELECT ID FROM SYSOBJECTS WHERE xtype='U' AND name='DadosItemNfe')) 
ALTER TABLE DadosNotaNfe ADD vICMSDeson NUMERIC(15,2)
go

IF NOT EXISTS (SELECT 1 FROM SYSCOLUMNS WHERE name = 'vICMSDeson' and syscolumns.id IN (SELECT ID FROM SYSOBJECTS WHERE xtype='U' AND name='DadosItemNfe')) 
ALTER TABLE DadosItemNfe ADD vICMSDeson NUMERIC(15,2)
go
/*------ ATD 265574 ------*/
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'COMPLEMENTOPRODUTO' AND COLUMN_NAME = 'FABRICACAOPROPRIA') 
alter table complementoproduto add FABRICACAOPROPRIA NUMERIC(1,0) DEFAULT 0
go