
/*------ ATD 356962 ------*/
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'COMPLEMENTOPRODUTO' AND COLUMN_NAME = 'UTRIB')
alter TABLE dbo.COMPLEMENTOPRODUTO add UTRIB CHAR(6)
go
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'COMPLEMENTOPRODUTO' AND COLUMN_NAME = 'FACONV_UTRIB')
alter TABLE dbo.COMPLEMENTOPRODUTO add FACONV_UTRIB Decimal(15,8)
go
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'CODIGONCM' AND COLUMN_NAME = 'FACONV_UTRIB')
alter TABLE dbo.CODIGONCM add FACONV_UTRIB Decimal(15,8)
go