
/*------ ATD 341655 ------*/
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'COMPLEMENTOPRODUTO' AND COLUMN_NAME = 'pGLP') 
alter TABLE dbo.COMPLEMENTOPRODUTO add pGLP NUMERIC (5,2)
go

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'COMPLEMENTOPRODUTO' AND COLUMN_NAME = 'pGNN') 
alter TABLE dbo.COMPLEMENTOPRODUTO add pGNN NUMERIC (5,2)
go

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'COMPLEMENTOPRODUTO' AND COLUMN_NAME = 'pGNI') 
alter TABLE dbo.COMPLEMENTOPRODUTO add pGNI NUMERIC (5,2)
go

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'COMPLEMENTOPRODUTO' AND COLUMN_NAME = 'VPARTIDA') 
alter TABLE dbo.COMPLEMENTOPRODUTO add VPARTIDA NUMERIC (15,2)
go



IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DADOSITEMNFE' AND COLUMN_NAME = 'pGLP') 
alter TABLE dbo.DADOSITEMNFE add pGLP NUMERIC (5,2)
go

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DADOSITEMNFE' AND COLUMN_NAME = 'pGNN') 
alter TABLE dbo.DADOSITEMNFE add pGNN NUMERIC (5,2)
go

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DADOSITEMNFE' AND COLUMN_NAME = 'pGNI') 
alter TABLE dbo.DADOSITEMNFE add pGNI NUMERIC (5,2)
go

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DADOSITEMNFE' AND COLUMN_NAME = 'vPart') 
alter TABLE dbo.DADOSITEMNFE add vPart NUMERIC (15,2)
go