
/*------ ATD 376376 ------*/
-- COLUNA ICMS_MEDIO_SUPORTADO
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'RESSARCIMENTO_ST' AND COLUMN_NAME = 'ICMS_MEDIO_SUPORTADO')
BEGIN
ALTER TABLE RESSARCIMENTO_ST ADD ICMS_MEDIO_SUPORTADO NUMERIC(18,5)
END
GO 

-- COLUNA BASEST_MEDIA
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'RESSARCIMENTO_ST' AND COLUMN_NAME = 'BASEST_MEDIA')
BEGIN
ALTER TABLE RESSARCIMENTO_ST ADD BASEST_MEDIA NUMERIC(18,5)
END
GO 
