
/*------ ATD 233084 ------*/
-- Adicionando coluna DESCICMSSUFRAMA na tabela ITEMCLICOMPLEMENTO
IF NOT EXISTS (SELECT 1 FROM SYSCOLUMNS WHERE name = 'DESCICMSSUFRAMA' and syscolumns.id IN (SELECT ID FROM SYSOBJECTS WHERE xtype='U' AND name='ITEMCLICOMPLEMENTO')) 
ALTER TABLE ITEMCLICOMPLEMENTO ADD DESCICMSSUFRAMA NUMERIC(15,2) not null default 0
go

-- Adicionando coluna DESCICMSSUFRAMA na tabela ITNFSAICOMPLEMENTO
IF NOT EXISTS (SELECT 1 FROM SYSCOLUMNS WHERE name = 'DESCICMSSUFRAMA' and syscolumns.id IN (SELECT ID FROM SYSOBJECTS WHERE xtype='U' AND name='ITNFSAICOMPLEMENTO')) 
ALTER TABLE ITNFSAICOMPLEMENTO ADD DESCICMSSUFRAMA NUMERIC(15,2) not null default 0
go
