
/*------ ATD 456447 ------*/
-- Adicionando coluna vRetPIS na tabela DADOSNOTANFE
IF NOT EXISTS (SELECT 1 FROM SYSCOLUMNS WHERE name = 'vRetPIS' and syscolumns.id IN (SELECT ID FROM SYSOBJECTS WHERE xtype='U' AND name='DADOSNOTANFE')) 
ALTER TABLE DADOSNOTANFE ADD vRetPIS DECIMAL(15,2)
go

-- Adicionando coluna vRetCOFINS na tabela DADOSNOTANFE
IF NOT EXISTS (SELECT 1 FROM SYSCOLUMNS WHERE name = 'vRetCOFINS' and syscolumns.id IN (SELECT ID FROM SYSOBJECTS WHERE xtype='U' AND name='DADOSNOTANFE')) 
ALTER TABLE DADOSNOTANFE ADD vRetCOFINS DECIMAL(15,2)
go

-- Adicionando coluna vRetCSLL na tabela DADOSNOTANFE
IF NOT EXISTS (SELECT 1 FROM SYSCOLUMNS WHERE name = 'vRetCSLL' and syscolumns.id IN (SELECT ID FROM SYSOBJECTS WHERE xtype='U' AND name='DADOSNOTANFE')) 
ALTER TABLE DADOSNOTANFE ADD vRetCSLL DECIMAL(15,2)
go