ALTER TABLE Trn_MayBonif DROP CONSTRAINT [CK_Trn_MayBonifTipoTarifa]
GO
ALTER TABLE Trn_MayBonif ADD TipoMargen CHAR(1) DEFAULT('B'),IntvExcluido BIT DEFAULT(0) NOT NULL
,IntvGlobal BIT DEFAULT(0) NOT NULL
GO
ALTER TABLE Trn_MayLiqDetalle ADD CantExcluido DECIMAL(14,4) DEFAULT(0),MgnNeto DECIMAL(14,4) DEFAULT(0)
,TipoMargen CHAR(1) DEFAULT('B')
GO
INSERT INTO ClaseTar (IdClase,NomClase,Inactivo) VALUES ('MGN','MARGEN MAYORISTA NETO',0)
GO