
/*------ ATD 300890 ------*/
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'ITNFSAICOMPLEMENTO' and column_name = 'VALORDESCONTOPISCOFINS')
	ALTER TABLE ITNFSAICOMPLEMENTO ADD VALORDESCONTOPISCOFINS numeric(15,2) NULL
GO
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'ITNFSAICOMPLEMENTO' and column_name = 'VALORDESCONTOICMS')
	ALTER TABLE ITNFSAICOMPLEMENTO ADD VALORDESCONTOICMS numeric(15,2) NULL
GO
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'ITEMCLICOMPLEMENTO' and column_name = 'DESCONTOGERAL')
	ALTER TABLE ITEMCLICOMPLEMENTO ADD DESCONTOGERAL numeric(15,2) NULL
GO