
/*------ ATD 418858 ------*/
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'PEDICLICOMPLEMENTO' and column_name = 'DESCONTONACIONAIS')
begin
	alter table PEDICLICOMPLEMENTO add DESCONTONACIONAIS numeric(17,5) default 0
end
go

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'PEDICLICOMPLEMENTO' and column_name = 'PERCDESCONTONACIONAIS')
begin
	alter table PEDICLICOMPLEMENTO add PERCDESCONTONACIONAIS numeric(6,2) default 0
end
go