
/*------ ATD 409317 ------*/
-- Alteracao da estrutura da tabela ITNFSAICOMPLEMENTO
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ITNFSAICOMPLEMENTO' AND COLUMN_NAME = 'pDIF') 
alter TABLE ITNFSAICOMPLEMENTO add pDIF NUMERIC(5,2)
go

-- Alteracao da estrutura da tabela ITNFSAICOMPLEMENTO
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ITNFSAICOMPLEMENTO' AND COLUMN_NAME = 'vICMSDif') 
alter TABLE ITNFSAICOMPLEMENTO add vICMSDif NUMERIC(15,2)
go

-- Alteracao da estrutura da tabela CFOSAIDCAD
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'CFOSAIDCAD' AND COLUMN_NAME = 'vICMSDif') 
alter TABLE CFOSAIDCAD add vICMSDif NUMERIC(15,2)
go

-- Alteracao da estrutura da tabela ITNFENTCOMPLEMENTO
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ITNFENTCOMPLEMENTO' AND COLUMN_NAME = 'pDIF') 
alter TABLE ITNFENTCOMPLEMENTO add pDIF NUMERIC(5,2)
go

-- Alteracao da estrutura da tabela ITNFENTCOMPLEMENTO
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ITNFENTCOMPLEMENTO' AND COLUMN_NAME = 'vICMSDif') 
alter TABLE ITNFENTCOMPLEMENTO add vICMSDif NUMERIC(15,2)
go

-- Alteracao da estrutura da tabela CFOENTRCAD
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'CFOENTRCAD' AND COLUMN_NAME = 'vICMSDif') 
alter TABLE CFOENTRCAD add vICMSDif NUMERIC(15,2)
go

-- Alteracao da estrutura da tabela CFOENTRCAD
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'CFOENTRCAD' AND COLUMN_NAME = 'ValTribDif') 
alter TABLE CFOENTRCAD add ValTribDif NUMERIC(15,2)
go


