
/*------ ATD 386477 ------*/
-- SQLSERVER
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ITNFSAICOMPLEMENTO' AND COLUMN_NAME = 'DESCONTOOFERTA') 
ALTER TABLE dbo.ITNFSAICOMPLEMENTO add DESCONTOOFERTA NUMERIC (15,2)
GO

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ITNFENTCOMPLEMENTO' AND COLUMN_NAME = 'DESCONTOOFERTA') 
ALTER TABLE dbo.ITNFENTCOMPLEMENTO add DESCONTOOFERTA NUMERIC (15,2)
GO
