ALTER TABLE TarifAnticipos ADD NitPropietario VARCHAR(16) DEFAULT('0') NOT NULL
GO
ALTER TABLE VehRemolq ADD Kingpin VARCHAR(50),FecKingpin SMALLDATETIME,VigKingpin SMALLDATETIME
GO
CREATE TABLE Trn_TraLiquidaOtr ( 
TipDoc VARCHAR(3) DEFAULT ('LIQ') NOT NULL,
Liquidacion INT DEFAULT ((0)) NOT NULL,
IdCia CHAR(2) DEFAULT ('01') NOT NULL,
Item INT DEFAULT ((0)) NOT NULL,
TipCau VARCHAR(3) DEFAULT ('CCD') NOT NULL,
Causacion INT DEFAULT ((0)) NOT NULL,
IdCiaCau CHAR(2) DEFAULT ('01') NOT NULL,
ItemCau INT DEFAULT ((0)) NOT NULL,
Factura VARCHAR(15),
ItemFac INT DEFAULT ((0)) NOT NULL,
IdProveedor VARCHAR(16) NOT NULL,
pVehiculo VARCHAR(10),
VrAbono MONEY DEFAULT ((0)) NOT NULL
 CONSTRAINT PK_Trn_TraLiquidaOtr PRIMARY KEY CLUSTERED (TipDoc,Liquidacion,IdCia,Item),
 CONSTRAINT CK_Trn_TraLiquidaOtrIdCia CHECK ((len([IdCia])>(0))),
 CONSTRAINT CK_Trn_TraLiquidaOtrIdCiaCau CHECK ((len([IdCiaCau])>(0))),
 CONSTRAINT CK_Trn_TraLiquidaOtrIdProveedor CHECK ((len([IdProveedor])>(0))),
 CONSTRAINT CK_Trn_TraLiquidaOtrTipCau CHECK ((len([TipCau])>(0))),
 CONSTRAINT CK_Trn_TraLiquidaOtrTipDoc CHECK ((len([TipDoc])>(0))))
GO
ALTER TABLE Trn_TraLiquidaOtr ADD 
 CONSTRAINT FK_Trn_TraLiquidaOtr_Trn_TraLiquida FOREIGN KEY (TipDoc,Liquidacion,IdCia) REFERENCES [dbo].[Trn_TraLiquida] (TipDoc,Liquidacion,IdCia)
 CREATE NONCLUSTERED INDEX IX_Trn_TraLiquidaOtr ON Trn_TraLiquidaOtr(TipCau,Causacion,IdCiaCau)

INSERT INTO Sys_Roles (IdObj,IdRole,Funcion)
 VALUES ('FRMDCMP','ING','Modificar Comprobante de Reclasificación de ingresos')