if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryGatAdicionalesLta]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryGatAdicionalesLta]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryGatAjustesLta]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryGatAjustesLta]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryGatAjustesProrLta]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryGatAjustesProrLta]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryGatAportesFmt]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryGatAportesFmt]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryGatLiquidaLta]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryGatLiquidaLta]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryGatProrrateosFmt]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryGatProrrateosFmt]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryGatProrrateosLta]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryGatProrrateosLta]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryGatRetirosLta]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryGatRetirosLta]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryGatTrasladosFmt]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryGatTrasladosFmt]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryGatTrasladosLta]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryGatTrasladosLta]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryGatVinculaLta]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryGatVinculaLta]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryGatVinculaRecFmt]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryGatVinculaRecFmt]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryJurActasLta]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryJurActasLta]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryGatVinculaRecFmt] @pmTipDoc VARCHAR(3),@pmFechaIni SMALLDATETIME=Null,@pmFechaFin SMALLDATETIME=Null
,@pmNumRegIni INT=Null,@pmNumRegFin INT=Null,@pmIdCia CHAR(2)=Null
 AS 
 SELECT VR.TipDoc,VR.NumRegistro,VR.IdCia,VR.Item,VR.TipRec,VR.Recibo,VR.IdCiaRec,VR.ItemRec,VR.VrAbono AS TotalAbonos,VR.Descripcion
,R.VrIngreso,R.VrDevolucion,R.VrAbonos,R.TipDocRef,R.NumDocRef,R.CiaDocRef,R.CodCuenta,R.EstadoReg
 FROM Trn_GatVinculaRec AS VR INNER JOIN Trn_GatVincula AS V ON VR.TipDoc=V.TipDoc AND VR.NumRegistro=V.NumRegistro AND VR.IdCia=V.IdCia
 INNER JOIN (SELECT TipDoc,Recibo,IdCia,Item,Fecha,TipoConc,Descripcion,VrIngreso,VrDevolucion,VrAbonos,TipDocRef,NumDocRef,CiaDocRef,CodCuenta,ItemDet,EstadoReg
 FROM Trn_GatIngresos
 UNION ALL
 SELECT TipDoc,NumTraslado,IdCia,0,Fecha,Modalidad,Observacion,VrTraslado,CASE WHEN Anulado=1 THEN VrTraslado ELSE 0 END,VrAbonos,TipDocRef,NumDocRef,CiaDocRef,'',0,NumDocRef
 FROM Trn_GatTraslados WHERE TipDoc='TAA') AS R ON VR.TipRec=R.TipDoc AND VR.Recibo=R.Recibo AND VR.IdCiaRec=R.IdCia AND VR.ItemRec=R.Item
 WHERE VR.TipDoc=@pmTipDoc AND V.Fecha BETWEEN ISNULL(@pmFechaIni,CAST('19900101' AS SMALLDATETIME)) AND ISNULL(@pmFechaFin,CAST('20781230' AS SMALLDATETIME))
 AND VR.NumRegistro BETWEEN ISNULL(@pmNumRegIni,0) AND ISNULL(@pmNumRegFin,2147483647)
 AND (@pmIdCia IS NULL OR VR.IdCia=@pmIdCia)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryJurActasLta] @pmTipDoc VARCHAR(3),@pmFechaIni SMALLDATETIME=Null,@pmFechaFin SMALLDATETIME=Null,@pmIdCia CHAR(2)=Null
 AS 
 SELECT A.TipDoc,A.NumProceso,A.IdCia,Compania,A.Fecha,A.NumActa,A.FechaActa,A.Modalidad,A.ValorTotal,A.Referencia,A.EstadoPror,A.TipPror,A.NumPror,A.IdCiaPror,A.Anulado,A.NumDev,A.FechaDev,A.Observacion,A.IdUsuario,Usuario,A.FechaCrea,A.IdCiaCrea,A.ModuloCrea,TD.TipoDoc
 ,D.Item,D.IdAsociado,T.RazonSocial AS NomAsociado,D.UndVehiculo,D.IdVehiculo,D.Descripcion,D.Importe,D.TipDocJur,D.NumCasoJur,D.IdCiaJur,S.Fecha AS SinFecha,S.TipCar AS TipMuc,S.Cartulina AS NumManif,S.IdCiaCar AS IdCiaManif,S.FechaSuc AS FechaSuceso
,S.IdTipoPro,JT.TipoProceso,S.IdClase AS IdClaseProc,ClaseAccdte,S.IdCalifica,CalificaCaso,S.LugarAcc,S.CausaAcc,S.Comentario AS Sin_Comentarios,S.Observacion AS Sin_Observacion,S.IdEstado AS SinIdEstado,JE.Estado AS SinEstado,S.Anulado AS SinAnulado
,QV.NumVeh,QV.IdTipoVeh,TipoVehiculo,QV.IdMarca,Marca,QV.IdColor,NomColor,QV.IdCrceria,TipoCar,QV.Modelo,QV.IdPoseedor,NP.RazonSocial AS NomPoseedor,QV.IdPpd,TipoProp,QV.TipoAfil,QV.SerieChasis,QV.VrAvaludo AS VrAvaluoAct
,QV.EdoVincula,QV.FecIngreso,QV.FecVigencia,QV.FecRetiro,QV.IdEstado,EV.Estado,QV.Inactivo
 FROM Trn_JurActas AS A INNER JOIN Trn_JurActasVeh AS D ON A.TipDoc=D.TipDoc AND A.NumProceso=D.NumProceso AND A.IdCia=D.IdCia
 INNER JOIN adm_Usuarios AS U ON A.IdUsuario=U.IdUsuario INNER JOIN Companias AS CI ON A.IdCia=CI.IdCia INNER JOIN Sys_TiposDoc AS TD ON A.TipDoc=TD.IdDoc
 LEFT JOIN Terceros AS T ON D.IdAsociado=T.IdTercero 
 LEFT JOIN QryVehiculosGat AS QV ON D.IdVehiculo=QV.IdVehiculo LEFT JOIN Marcas AS M ON QV.IdMarca=M.IdMarca
 LEFT JOIN TiposCar AS TC ON QV.IdCrceria=TC.IdCrceria LEFT JOIN Terceros AS NP ON QV.IdPoseedor=NP.IdTercero
 LEFT JOIN TiposCol AS CL ON QV.IdColor=CL.IdColor LEFT JOIN TiposVeh AS TV ON QV.IdTipoVeh=TV.IdTipoVeh
 LEFT JOIN TiposPpt AS TP ON QV.IdPpd=TP.IdPpd LEFT JOIN EstadoVeh AS EV ON QV.IdEstado=EV.IdEstado
 LEFT JOIN Trn_JurCasos AS S ON D.TipDocJur=S.TipDoc AND D.NumCasoJur=S.CasoID AND D.IdCiaJur=S.IdCia
 LEFT JOIN JurTipos AS JT ON S.IdTipoPro=JT.IdTipoPro LEFT JOIN JurEstados AS JE ON S.IdEstado=JE.IdEstado
 LEFT JOIN JurClaseAcc AS CA ON S.IdClase=CA.IdClase LEFT JOIN JurCalifica AS JC ON S.IdCalifica=JC.IdCalifica
 WHERE A.TipDoc=@pmTipDoc AND A.Fecha BETWEEN ISNULL(@pmFechaIni,CAST('19900101' AS SMALLDATETIME)) AND ISNULL(@pmFechaFin,CAST('20781230' AS SMALLDATETIME))
 AND (@pmIdCia IS NULL OR A.IdCia=@pmIdCia)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryGatProrrateosFmt] @pmTipDoc VARCHAR(3),@pmNumProcesoIni INT,@pmNumProcesoFin INT,@pmIdCia CHAR(2)
 AS 
 SELECT P.TipDoc,P.NumProceso,P.IdCia,Compania,P.Fecha,P.IdConcepto,CN.Concepto,P.Modalidad,P.TipDocActa,P.NumDocActa,P.IdCiaActa,P.FecSuceso,P.IdAsociado,T.RazonSocial AS NomAsociado,P.UndVehiculo,P.IdVehiculo
,P.nRemolque,P.VrAprobado,P.VrAvaluo,P.TipoAfiVeh,P.Referencia,P.TipCom,TipoCom,P.Comprobante,P.IdCiaCom,P.Anulado,P.NumDev,P.FechaDev,P.Observacion,P.IdUsuario,Usuario,P.FechaCrea,P.IdCiaCrea,P.ModuloCrea,TD.TipoDoc
,D.Item,D.IdAsociado AS DetNitAsociado,NA.RazonSocial AS DetNomAsociado,D.UndVehiculo AS DetUndVehic,D.IdVehiculo AS DetIdVehiculo,D.VrAvaluo AS DetVrAvaluo,D.TipoBaseLiq,D.TarifaLiq,D.VrAportes,D.Importe,D.VrRetiros,D.CodTarifa
,D.Observacion AS DetObservacion,D.FecLiquida,D.FecIngreso AS DetFecIngreso,D.FecRetiro AS DetFecRetiro,D.EdoVincula AS DetEdoVincula
,A.NumActa,A.FechaActa AS ActFecha,A.ValorTotal AS ActVrAprobado,A.Observacion AS ActObservacion
,QV.NumVeh,QV.IdTipoVeh,TipoVehiculo,QV.IdMarca,Marca,QV.IdColor,NomColor,QV.IdCrceria,TipoCar,QV.Modelo,QV.IdPoseedor,NP.RazonSocial AS NomPoseedor,QV.IdPpd,TipoProp,QV.TipoAfil,QV.SerieChasis,QV.VrAvaludo AS VrAvaluoAct
,QV.EdoVincula,QV.FecIngreso,QV.FecVigencia,QV.FecRetiro,QV.IdEstado,EV.Estado,QV.Inactivo
FROM Trn_GatProrrateos AS P INNER JOIN Trn_GatProrratVeh AS D ON P.TipDoc=D.TipDoc AND P.NumProceso=D.NumProceso AND P.IdCia=D.IdCia
INNER JOIN Trn_JurActas AS A ON P.TipDocActa=A.TipDoc AND P.NumDocActa=A.NumProceso AND P.IdCiaActa=A.IdCia
INNER JOIN adm_Usuarios AS U ON P.IdUsuario=U.IdUsuario
INNER JOIN Companias AS CI ON P.IdCia=CI.IdCia INNER JOIN Sys_TiposDoc AS TD ON P.TipDoc=TD.IdDoc
INNER JOIN Conceptos AS CN ON P.IdConcepto=CN.IdConcepto INNER JOIN Terceros AS T ON P.IdAsociado=T.IdTercero
INNER JOIN Terceros AS NA ON D.IdAsociado=NA.IdTercero
LEFT JOIN QryVehiculosGat AS QV ON D.IdVehiculo=QV.IdVehiculo LEFT JOIN Marcas AS M ON QV.IdMarca=M.IdMarca
LEFT JOIN TiposCar AS TC ON QV.IdCrceria=TC.IdCrceria LEFT JOIN Terceros AS NP ON QV.IdPoseedor=NP.IdTercero
LEFT JOIN TiposCol AS CL ON QV.IdColor=CL.IdColor LEFT JOIN TiposVeh AS TV ON QV.IdTipoVeh=TV.IdTipoVeh
LEFT JOIN TiposPpt AS TP ON QV.IdPpd=TP.IdPpd LEFT JOIN EstadoVeh AS EV ON QV.IdEstado=EV.IdEstado
LEFT JOIN TiposCom AS TCO ON P.TipCom=TCO.IdCom
WHERE P.TipDoc=@pmTipDoc AND P.NumProceso BETWEEN @pmNumProcesoIni AND @pmNumProcesoFin AND P.IdCia=@pmIdCia
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryGatTrasladosLta] @pmTipDoc VARCHAR(3),@pmFechaIni SMALLDATETIME=Null,@pmFechaFin SMALLDATETIME=Null,@pmIdCia CHAR(2)=Null
 AS 
 SELECT T.TipDoc,T.NumTraslado,T.IdCia,Compania,T.Fecha,T.IdConcepto,CN.Concepto,T.Modalidad,T.IdAsociado,A.RazonSocial AS NomAsociado,T.UndVehiculo,T.IdVehiculo,T.nRemolque,T.IdAsociadoDtn,T.UndVehicDtn,T.IdVehiculoDtn,T.VrTraslado,T.VrAportes,T.VrVinculacion,T.VrSaldoVinc,T.VrGarantia
,T.VrSaldoApo,T.VrTotalApo,T.VrAvaluo,T.TipoBaseLiq,T.TipoAfiVeh,T.Referencia,T.FechaCorte,T.VrAbonos,T.TipDocRef,T.NumDocRef,T.CiaDocRef,T.TarifaGar,T.UndTarifGar
,T.TipCom,TipoCom,T.Comprobante,T.IdCiaCom,T.Anulado,T.NumDev,T.FechaDev,T.Observacion,T.ComentarioGar,T.IdUsuario,Usuario,T.FechaCrea,T.IdCiaCrea,T.ModuloCrea,TD.TipoDoc
,QV.NumVeh,QV.IdTipoVeh,TipoVehiculo,QV.IdMarca,Marca,QV.IdColor,NomColor,QV.IdCrceria,TipoCar,QV.Modelo,QV.IdPoseedor,NP.RazonSocial AS NomPoseedor,QV.IdPpd,TipoProp,QV.TipoAfil,QV.SerieChasis,QV.VrAvaludo AS VrAvaluoAct
,QV.EdoVincula,QV.FecIngreso,QV.FecVigencia,QV.FecRetiro,QV.IdEstado,EV.Estado,QV.Inactivo
 FROM Trn_GatTraslados AS T INNER JOIN Terceros AS A ON T.IdAsociado=A.IdTercero INNER JOIN adm_Usuarios AS U ON T.IdUsuario=U.IdUsuario
INNER JOIN Companias AS CI ON T.IdCia=CI.IdCia INNER JOIN Sys_TiposDoc AS TD ON T.TipDoc=TD.IdDoc
INNER JOIN Conceptos AS CN ON T.IdConcepto=CN.IdConcepto
INNER JOIN QryVehiculosGat AS QV ON T.IdVehiculo=QV.IdVehiculo INNER JOIN Marcas AS M ON QV.IdMarca=M.IdMarca
INNER JOIN TiposCar AS TC ON QV.IdCrceria=TC.IdCrceria INNER JOIN Terceros AS NP ON QV.IdPoseedor=NP.IdTercero
LEFT JOIN TiposCol AS CL ON QV.IdColor=CL.IdColor LEFT JOIN TiposVeh AS TV ON QV.IdTipoVeh=TV.IdTipoVeh
LEFT JOIN TiposPpt AS TP ON QV.IdPpd=TP.IdPpd LEFT JOIN EstadoVeh AS EV ON QV.IdEstado=EV.IdEstado
LEFT JOIN TiposCom AS TCO ON T.TipCom=TCO.IdCom
 WHERE T.TipDoc=@pmTipDoc AND T.Fecha BETWEEN ISNULL(@pmFechaIni,CAST('19900101' AS SMALLDATETIME)) AND ISNULL(@pmFechaFin,CAST('20781230' AS SMALLDATETIME))
AND (@pmIdCia IS NULL OR T.IdCia=@pmIdCia)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryGatTrasladosFmt] @pmTipDoc VARCHAR(3),@pmFechaIni SMALLDATETIME=Null,@pmFechaFin SMALLDATETIME=Null,@pmIdCia CHAR(2)=Null
 AS 
 SELECT T.TipDoc,T.NumTraslado,T.IdCia,Compania,T.Fecha,T.IdConcepto,CN.Concepto,T.Modalidad,T.IdAsociadoDtn,T.UndVehicDtn,T.IdVehiculoDtn,T.VrTraslado,T.VrAportes,T.VrVinculacion,T.VrSaldoVinc,T.VrGarantia
,T.VrSaldoApo,T.VrTotalApo,T.VrAvaluo,T.TipoBaseLiq,T.TipoAfiVeh,T.Referencia,T.FechaCorte,T.VrAbonos,T.TipDocRef,T.NumDocRef,T.CiaDocRef,T.TarifaGar,T.UndTarifGar
,T.TipCom,TipoCom,T.Comprobante,T.IdCiaCom,T.Anulado,T.NumDev,T.FechaDev,T.Observacion,T.ComentarioGar,T.IdUsuario,Usuario,T.FechaCrea,T.IdCiaCrea,T.ModuloCrea,TD.TipoDoc
,D.Item,D.FecEmision,D.FecVence,D.Concepto AS ApoConcepto,D.IdAsociado,A.RazonSocial AS NomAsociado,D.UndVehiculo,D.IdVehiculo,D.nRemolque,D.Importe,D.VrComercial,D.VrAsegurado,D.Cantidad,D.TarifaApo,D.CodTarifApo
,D.CantDiasAnt,D.VrDiasAnt,D.VrDevolucion,D.Descripcion AS ApoDescripcion,D.Referencia AS ApoReferencia,D.TipDocRef AS ApoDocRef,D.NumDocRef AS ApoNumDocRef,D.FecLiqApo
,QV.NumVeh,QV.IdTipoVeh,TipoVehiculo,QV.IdMarca,Marca,QV.IdColor,NomColor,QV.IdCrceria,TipoCar,QV.Modelo,QV.IdPoseedor,NP.RazonSocial AS NomPoseedor,QV.IdPpd,TipoProp,QV.TipoAfil,QV.SerieChasis,QV.VrAvaludo AS VrAvaluoAct
,QV.EdoVincula,QV.FecIngreso,QV.FecVigencia,QV.FecRetiro,QV.IdEstado,EV.Estado,QV.Inactivo
 FROM Trn_GatTraslados AS T INNER JOIN adm_Usuarios AS U ON T.IdUsuario=U.IdUsuario
INNER JOIN Companias AS CI ON T.IdCia=CI.IdCia INNER JOIN Sys_TiposDoc AS TD ON T.TipDoc=TD.IdDoc
INNER JOIN Conceptos AS CN ON T.IdConcepto=CN.IdConcepto
INNER JOIN Trn_GatAportes AS D ON T.TipDoc=D.TipDoc AND T.NumTraslado=D.NumRegistro AND T.IdCia=D.IdCia
INNER JOIN Terceros AS A ON D.IdAsociado=A.IdTercero
INNER JOIN QryVehiculosGat AS QV ON D.IdVehiculo=QV.IdVehiculo INNER JOIN Marcas AS M ON QV.IdMarca=M.IdMarca
INNER JOIN TiposCar AS TC ON QV.IdCrceria=TC.IdCrceria INNER JOIN Terceros AS NP ON QV.IdPoseedor=NP.IdTercero
LEFT JOIN TiposCol AS CL ON QV.IdColor=CL.IdColor LEFT JOIN TiposVeh AS TV ON QV.IdTipoVeh=TV.IdTipoVeh
LEFT JOIN TiposPpt AS TP ON QV.IdPpd=TP.IdPpd LEFT JOIN EstadoVeh AS EV ON QV.IdEstado=EV.IdEstado
LEFT JOIN TiposCom AS TCO ON T.TipCom=TCO.IdCom
 WHERE T.TipDoc=@pmTipDoc AND T.Fecha BETWEEN ISNULL(@pmFechaIni,CAST('19900101' AS SMALLDATETIME)) AND ISNULL(@pmFechaFin,CAST('20781230' AS SMALLDATETIME))
AND (@pmIdCia IS NULL OR T.IdCia=@pmIdCia)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryGatAjustesProrLta] @pmTipDoc VARCHAR(3),@pmFechaIni SMALLDATETIME=Null,@pmFechaFin SMALLDATETIME=Null,@pmIdCia CHAR(2)=Null
 AS 
 SELECT A.TipDoc,A.NumAjuste,A.IdCia,Compania,A.Fecha,A.IdConcepto,CN.Concepto,A.Modalidad,A.TipPror,A.NumProceso,A.IdCiaPror,A.VrAjustes,A.Referencia
,A.TipCom,TipoCom,A.Comprobante,A.IdCiaCom,A.Anulado,A.NumDev,A.FechaDev,A.Observacion,A.IdUsuario,Usuario,A.FechaCrea,A.IdCiaCrea,A.ModuloCrea,TD.TipoDoc
,D.Item,D.FecVence,D.IdAsociado,T.RazonSocial AS NomAsociado,D.UndVehiculo,D.IdVehiculo,D.nRemolque,D.Concepto AS ApoConcepto,D.Importe,D.VrAvaluo,D.VrComercial,D.VrAsegurado,D.TipoBaseLiq,D.VrDevolucion,D.Cantidad
,D.TarifaApo,D.CodTarifApo,D.CantDiasAnt,D.VrDiasAnt,D.Descripcion AS ApoDescripcion,D.Referencia AS ApoReferencia,D.TipDocRef AS ApoTipRef,D.NumDocRef AS ApoNumRef,D.TipoAfiVeh,D.FecLiqApo
,P.Modalidad AS ProrModalidad,P.TipDocActa,P.NumDocActa,P.IdCiaActa,AJ.NumActa,AJ.FechaActa,P.FecSuceso,P.VrAprobado,P.Observacion AS ProrObservacion,AJ.Observacion AS ActaObservacion
,QV.NumVeh,QV.IdTipoVeh,TipoVehiculo,QV.IdMarca,Marca,QV.IdColor,NomColor,QV.IdCrceria,TipoCar,QV.Modelo,QV.IdPoseedor,NP.RazonSocial AS NomPoseedor,QV.IdPpd,TipoProp,QV.TipoAfil,QV.SerieChasis,QV.VrAvaludo AS VrAvaluoAct
,QV.EdoVincula,QV.FecIngreso,QV.FecVigencia,QV.FecRetiro,QV.IdEstado,EV.Estado,QV.Inactivo
 FROM Trn_GatAjustesPror AS A INNER JOIN Trn_GatAportes AS D ON A.TipDoc=D.TipDoc AND A.NumAjuste=D.NumRegistro AND A.IdCia=D.IdCia 
 INNER JOIN Trn_GatProrrateos AS P ON A.TipPror=P.TipDoc AND A.NumProceso=P.NumProceso AND A.IdCiaPror=P.IdCia
 INNER JOIN adm_Usuarios AS U ON A.IdUsuario=U.IdUsuario INNER JOIN Companias AS CI ON A.IdCia=CI.IdCia 
 INNER JOIN Sys_TiposDoc AS TD ON A.TipDoc=TD.IdDoc INNER JOIN Conceptos AS CN ON A.IdConcepto=CN.IdConcepto
 INNER JOIN Terceros AS T ON D.IdAsociado=T.IdTercero
 INNER JOIN QryVehiculosGat AS QV ON D.IdVehiculo=QV.IdVehiculo INNER JOIN Marcas AS M ON QV.IdMarca=M.IdMarca
 INNER JOIN TiposCar AS TC ON QV.IdCrceria=TC.IdCrceria INNER JOIN Terceros AS NP ON QV.IdPoseedor=NP.IdTercero
 LEFT JOIN TiposCol AS CL ON QV.IdColor=CL.IdColor LEFT JOIN TiposVeh AS TV ON QV.IdTipoVeh=TV.IdTipoVeh
 LEFT JOIN TiposPpt AS TP ON QV.IdPpd=TP.IdPpd LEFT JOIN EstadoVeh AS EV ON QV.IdEstado=EV.IdEstado
 LEFT JOIN TiposCom AS TCO ON A.TipCom=TCO.IdCom
 LEFT JOIN Trn_JurActas AS AJ ON P.TipDocActa=AJ.TipDoc AND P.NumDocActa=AJ.NumProceso AND P.IdCiaActa=AJ.IdCia
 WHERE A.TipDoc=@pmTipDoc AND A.Fecha BETWEEN ISNULL(@pmFechaIni,CAST('19900101' AS SMALLDATETIME)) AND ISNULL(@pmFechaFin,CAST('20781230' AS SMALLDATETIME))
 AND (@pmIdCia IS NULL OR A.IdCia=@pmIdCia)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryGatAportesFmt] @pmTipDoc VARCHAR(3),@pmNumRegistroIni INT,@pmNumRegistroFin INT,@pmIdCia CHAR(2)
 AS 
 SELECT A.Id,A.TipDoc,TD.TipoDoc,A.NumRegistro,A.IdCia,Compania,A.Item,A.FecEmision,A.FecVence,A.IdAsociado,T.RazonSocial AS NomAsociado,A.UndVehiculo,A.IdVehiculo,A.nRemolque,A.Concepto,A.Importe
,A.VrAvaluo,A.VrComercial,A.VrAsegurado,A.TipoBaseLiq,A.Cantidad,A.TarifaApo,A.CodTarifApo,A.CantDiasAnt,A.VrDiasAnt,A.VrDevolucion,A.Descripcion
,A.Referencia,A.TipDocRef,A.NumDocRef,A.TipCom,A.Comprobante,A.TipoAfiVeh,A.FecLiqApo,A.FechaCrea
,QV.NumVeh,QV.IdTipoVeh,TipoVehiculo,QV.IdMarca,Marca,QV.IdColor,NomColor,QV.IdCrceria,TipoCar,QV.Modelo,QV.IdPoseedor,NP.RazonSocial AS NomPoseedor,QV.IdPpd,TipoProp,QV.TipoAfil,QV.SerieChasis,QV.VrAvaludo AS VrAvaluoAct
,QV.EdoVincula,QV.FecIngreso,QV.FecVigencia,QV.FecRetiro,QV.IdEstado,EV.Estado,QV.Inactivo
 FROM Trn_GatAportes AS A INNER JOIN Sys_TiposDoc AS TD ON A.TipDoc=TD.IdDoc INNER JOIN Companias AS CI ON A.IdCia=CI.IdCia
 INNER JOIN Terceros AS T ON A.IdAsociado=T.IdTercero
 INNER JOIN QryVehiculosGat AS QV ON A.IdVehiculo=QV.IdVehiculo INNER JOIN Marcas AS M ON QV.IdMarca=M.IdMarca
 INNER JOIN TiposCar AS TC ON QV.IdCrceria=TC.IdCrceria INNER JOIN Terceros AS NP ON QV.IdPoseedor=NP.IdTercero
 LEFT JOIN TiposCol AS CL ON QV.IdColor=CL.IdColor LEFT JOIN TiposVeh AS TV ON QV.IdTipoVeh=TV.IdTipoVeh
 LEFT JOIN TiposPpt AS TP ON QV.IdPpd=TP.IdPpd LEFT JOIN EstadoVeh AS EV ON QV.IdEstado=EV.IdEstado
 WHERE A.TipDoc=@pmTipDoc AND A.NumRegistro BETWEEN @pmNumRegistroIni AND @pmNumRegistroFin AND A.IdCia=@pmIdCia
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryGatRetirosLta] @pmTipDoc VARCHAR(3),@pmFechaIni SMALLDATETIME=Null,@pmFechaFin SMALLDATETIME=Null,@pmIdCia CHAR(2)=Null
 AS 
 SELECT R.TipDoc,R.NumRegistro,R.IdCia,Compania,R.Fecha,R.FechaRetiro,R.IdConcepto,CN.Concepto,R.TipoRetiro,R.Modalidad,R.IdAsociado,T.RazonSocial AS NomAsociado,R.UndVehiculo,R.IdVehiculo,R.nRemolque,R.VrRetiro,R.VrAportes
,R.VrVinculacion,R.VrSaldoVinc,R.VrGarantia,R.VrSaldoApo,R.VrTotalApo,R.VrAvaluo,R.TipoBaseLiq,R.TipoAfiVeh,R.Referencia,R.FechaCorte
,R.TipCom,TipoCom,R.Comprobante,R.IdCiaCom,R.Anulado,R.NumDev,R.FechaDev,R.Observacion,R.IdUsuario,Usuario,R.FechaCrea,R.IdCiaCrea,R.ModuloCrea,TD.TipoDoc
,D.Item,D.UndVehiculo AS DetUndVehic,D.IdVehiculo AS DetVehiculo,D.VrRetiro AS DetVrRetio,D.VrAportes AS DetVrAportes,D.VrVinculacion AS DetVrVincula,D.VrSaldoVinc AS DetVrSaldoVinc
,D.VrGarantia AS DetVrGarantia,D.VrSaldoApo AS DetVrSaldoApo,D.VrTotalApo AS DetVrTotalApo,D.VrAvaluo AS DetVrAvaluo,D.TipoBaseLiq AS DetTipoBaseLiq
,QV.NumVeh,QV.IdTipoVeh,TipoVehiculo,QV.IdMarca,Marca,QV.IdColor,NomColor,QV.IdCrceria,TipoCar,QV.Modelo,QV.IdPoseedor,NP.RazonSocial AS NomPoseedor,QV.IdPpd,TipoProp,QV.TipoAfil,QV.SerieChasis,QV.VrAvaludo AS VrAvaluoAct
,QV.EdoVincula,QV.FecIngreso,QV.FecVigencia,QV.FecRetiro,QV.IdEstado,EV.Estado,QV.Inactivo
 FROM Trn_GatRetiros AS R INNER JOIN adm_Usuarios AS U ON R.IdUsuario=U.IdUsuario
INNER JOIN Companias AS CI ON R.IdCia=CI.IdCia INNER JOIN Sys_TiposDoc AS TD ON R.TipDoc=TD.IdDoc
INNER JOIN Conceptos AS CN ON R.IdConcepto=CN.IdConcepto INNER JOIN Terceros AS T ON R.IdAsociado=T.IdTercero
INNER JOIN QryVehiculosGat AS QV ON R.IdVehiculo=QV.IdVehiculo INNER JOIN Marcas AS M ON QV.IdMarca=M.IdMarca
INNER JOIN TiposCar AS TC ON QV.IdCrceria=TC.IdCrceria INNER JOIN Terceros AS NP ON QV.IdPoseedor=NP.IdTercero
LEFT JOIN TiposCol AS CL ON QV.IdColor=CL.IdColor LEFT JOIN TiposVeh AS TV ON QV.IdTipoVeh=TV.IdTipoVeh
LEFT JOIN TiposPpt AS TP ON QV.IdPpd=TP.IdPpd LEFT JOIN EstadoVeh AS EV ON QV.IdEstado=EV.IdEstado
LEFT JOIN TiposCom AS TCO ON R.TipCom=TCO.IdCom
LEFT JOIN Trn_GatRetirosDet AS D ON R.TipDoc=D.TipDoc AND R.NumRegistro=D.NumRegistro AND R.IdCia=D.IdCia
WHERE R.TipDoc=@pmTipDoc AND R.Fecha BETWEEN ISNULL(@pmFechaIni,CAST('19900101' AS SMALLDATETIME)) AND ISNULL(@pmFechaFin,CAST('20781230' AS SMALLDATETIME))
AND (@pmIdCia IS NULL OR R.IdCia=@pmIdCia)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryGatProrrateosLta] @pmTipDoc VARCHAR(3),@pmFechaIni SMALLDATETIME=Null,@pmFechaFin SMALLDATETIME=Null,@pmIdCia CHAR(2)=Null
 AS 
 SELECT P.TipDoc,P.NumProceso,P.IdCia,Compania,P.Fecha,P.IdConcepto,CN.Concepto,P.Modalidad,P.TipDocActa,P.NumDocActa,P.IdCiaActa,P.FecSuceso,P.IdAsociado,T.RazonSocial AS NomAsociado,P.UndVehiculo,P.IdVehiculo
,P.nRemolque,P.VrAprobado,P.VrAvaluo,P.TipoAfiVeh,P.Referencia,P.TipCom,TipoCom,P.Comprobante,P.IdCiaCom,P.Anulado,P.NumDev,P.FechaDev,P.Observacion,P.IdUsuario,Usuario,P.FechaCrea,P.IdCiaCrea,P.ModuloCrea,TD.TipoDoc
,D.Item,D.IdAsociado AS DetNitAsociado,NA.RazonSocial AS DetNomAsociado,D.UndVehiculo AS DetUndVehic,D.IdVehiculo AS DetIdVehiculo,D.VrAvaluo AS DetVrAvaluo,D.TipoBaseLiq,D.TarifaLiq,D.VrAportes,D.Importe,D.VrRetiros,D.CodTarifa
,D.Observacion AS DetObservacion,D.FecLiquida,D.FecIngreso AS DetFecIngreso,D.FecRetiro AS DetFecRetiro,D.EdoVincula AS DetEdoVincula
,A.NumActa,A.FechaActa AS ActFecha,A.ValorTotal AS ActVrAprobado,A.Observacion AS ActObservacion
,QV.NumVeh,QV.IdTipoVeh,TipoVehiculo,QV.IdMarca,Marca,QV.IdColor,NomColor,QV.IdCrceria,TipoCar,QV.Modelo,QV.IdPoseedor,NP.RazonSocial AS NomPoseedor,QV.IdPpd,TipoProp,QV.TipoAfil,QV.SerieChasis,QV.VrAvaludo AS VrAvaluoAct
,QV.EdoVincula,QV.FecIngreso,QV.FecVigencia,QV.FecRetiro,QV.IdEstado,EV.Estado,QV.Inactivo
FROM Trn_GatProrrateos AS P INNER JOIN Trn_GatProrratVeh AS D ON P.TipDoc=D.TipDoc AND P.NumProceso=D.NumProceso AND P.IdCia=D.IdCia
INNER JOIN Trn_JurActas AS A ON P.TipDocActa=A.TipDoc AND P.NumDocActa=A.NumProceso AND P.IdCiaActa=A.IdCia
INNER JOIN adm_Usuarios AS U ON P.IdUsuario=U.IdUsuario
INNER JOIN Companias AS CI ON P.IdCia=CI.IdCia INNER JOIN Sys_TiposDoc AS TD ON P.TipDoc=TD.IdDoc
INNER JOIN Conceptos AS CN ON P.IdConcepto=CN.IdConcepto INNER JOIN Terceros AS T ON P.IdAsociado=T.IdTercero
INNER JOIN Terceros AS NA ON D.IdAsociado=NA.IdTercero
LEFT JOIN QryVehiculosGat AS QV ON D.IdVehiculo=QV.IdVehiculo LEFT JOIN Marcas AS M ON QV.IdMarca=M.IdMarca
LEFT JOIN TiposCar AS TC ON QV.IdCrceria=TC.IdCrceria LEFT JOIN Terceros AS NP ON QV.IdPoseedor=NP.IdTercero
LEFT JOIN TiposCol AS CL ON QV.IdColor=CL.IdColor LEFT JOIN TiposVeh AS TV ON QV.IdTipoVeh=TV.IdTipoVeh
LEFT JOIN TiposPpt AS TP ON QV.IdPpd=TP.IdPpd LEFT JOIN EstadoVeh AS EV ON QV.IdEstado=EV.IdEstado
LEFT JOIN TiposCom AS TCO ON P.TipCom=TCO.IdCom
WHERE P.TipDoc=@pmTipDoc AND P.Fecha BETWEEN ISNULL(@pmFechaIni,CAST('19900101' AS SMALLDATETIME)) AND ISNULL(@pmFechaFin,CAST('20781230' AS SMALLDATETIME))
 AND (@pmIdCia IS NULL OR P.IdCia=@pmIdCia)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryGatLiquidaLta] @pmTipDoc VARCHAR(3),@pmFechaIni SMALLDATETIME=Null,@pmFechaFin SMALLDATETIME=Null,@pmIdCia CHAR(2)=Null
 AS 
 SELECT L.TipDoc,L.NumLiquida,L.IdCia,Compania,L.Fecha,L.FechaLiquida,L.FechaVence,L.IdConcepto,CN.Concepto,L.Modalidad,L.Periodos,L.TarifaLiq,L.VrAportes,L.Referencia,L.VrBaseLiq,L.CdTarifLiq
,L.TipCau,L.Causacion,L.IdCiaCau,L.TipCom,TipoCom,L.Comprobante,L.IdCiaCom,L.Anulado,L.NumDev,L.FechaDev,L.Observacion,L.IdUsuario,Usuario,L.FechaCrea,L.IdCiaCrea,L.ModuloCrea,TD.TipoDoc
,D.Item,D.FecVence,D.IdAsociado,T.RazonSocial AS NomAsociado,D.UndVehiculo,D.IdVehiculo,D.nRemolque,D.Concepto AS ApoConcepto,D.Importe,D.VrAvaluo,D.VrComercial,D.VrAsegurado,D.TipoBaseLiq,D.VrDevolucion,D.Cantidad
,D.TarifaApo,D.CodTarifApo,D.CantDiasAnt,D.VrDiasAnt,D.Descripcion AS ApoDescripcion,D.Referencia AS ApoReferencia,D.TipDocRef,D.NumDocRef,D.TipoAfiVeh,D.FecLiqApo
,QV.NumVeh,QV.IdTipoVeh,TipoVehiculo,QV.IdMarca,Marca,QV.IdColor,NomColor,QV.IdCrceria,TipoCar,QV.Modelo,QV.IdPoseedor,NP.RazonSocial AS NomPoseedor,QV.IdPpd,TipoProp,QV.TipoAfil,QV.SerieChasis,QV.VrAvaludo AS VrAvaluoAct
,QV.EdoVincula,QV.FecIngreso,QV.FecVigencia,QV.FecRetiro,QV.IdEstado,EV.Estado,QV.Inactivo
 FROM Trn_GatLiquida AS L INNER JOIN Trn_GatAportes AS D ON L.TipDoc=D.TipDoc AND L.NumLiquida=D.NumRegistro AND L.IdCia=D.IdCia
 INNER JOIN adm_Usuarios AS U ON L.IdUsuario=U.IdUsuario INNER JOIN Companias AS CI ON L.IdCia=CI.IdCia 
 INNER JOIN Sys_TiposDoc AS TD ON L.TipDoc=TD.IdDoc INNER JOIN Conceptos AS CN ON L.IdConcepto=CN.IdConcepto
 INNER JOIN Terceros AS T ON D.IdAsociado=T.IdTercero
 INNER JOIN QryVehiculosGat AS QV ON D.IdVehiculo=QV.IdVehiculo INNER JOIN Marcas AS M ON QV.IdMarca=M.IdMarca
 INNER JOIN TiposCar AS TC ON QV.IdCrceria=TC.IdCrceria INNER JOIN Terceros AS NP ON QV.IdPoseedor=NP.IdTercero
 LEFT JOIN TiposCol AS CL ON QV.IdColor=CL.IdColor LEFT JOIN TiposVeh AS TV ON QV.IdTipoVeh=TV.IdTipoVeh
 LEFT JOIN TiposPpt AS TP ON QV.IdPpd=TP.IdPpd LEFT JOIN EstadoVeh AS EV ON QV.IdEstado=EV.IdEstado
 LEFT JOIN TiposCom AS TCO ON L.TipCom=TCO.IdCom
 WHERE L.TipDoc=@pmTipDoc AND L.Fecha BETWEEN ISNULL(@pmFechaIni,CAST('19900101' AS SMALLDATETIME)) AND ISNULL(@pmFechaFin,CAST('20781230' AS SMALLDATETIME))
 AND (@pmIdCia IS NULL OR L.IdCia=@pmIdCia)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryGatVinculaLta] @pmTipDoc VARCHAR(3),@pmFechaIni SMALLDATETIME=Null,@pmFechaFin SMALLDATETIME=Null,@pmIdCia CHAR(2)=Null
 AS 
 SELECT V.TipDoc,V.NumRegistro,V.IdCia,Compania,V.Fecha,V.FechaIngreso,V.IdConcepto,CN.Concepto,V.IdAsociado,T.RazonSocial AS NomAsociado,V.UndVehiculo,V.IdVehiculo,V.nRemolque,V.TipoAfiVeh
,V.TarifaVinc,V.VrVinculacion,V.VrIngresos,V.VrTraslados,V.VrAvaluo,V.VrComercial,V.VrAsegurado,V.TipoBaseLiq,V.Referencia,V.CdTarifVinc
,V.TipCom,TipoCom,V.Comprobante,V.IdCiaCom,V.FecUltLiqApo,V.Anulado,V.NumDev,V.FechaDev,V.Observacion,V.IdUsuario,Usuario,V.FechaCrea,V.IdCiaCrea,V.ModuloCrea,TD.TipoDoc
--detalle aportes
,D.Item,D.FecVence,D.Concepto AS ApoConcepto,D.Importe,D.VrDevolucion,D.Cantidad,D.TarifaApo,D.Descripcion AS ApoDescripcion,D.Referencia AS ApoReferencia
,QV.NumVeh,QV.IdTipoVeh,TipoVehiculo,QV.IdMarca,Marca,QV.IdColor,NomColor,QV.IdCrceria,TipoCar,QV.Modelo,QV.IdPoseedor,NP.RazonSocial AS NomPoseedor,QV.IdPpd,TipoProp,QV.TipoAfil,QV.SerieChasis,QV.VrAvaludo AS VrAvaluoAct
,QV.EdoVincula,QV.FecIngreso,QV.FecVigencia,QV.FecRetiro,QV.IdEstado,EV.Estado,QV.Inactivo
FROM Trn_GatVincula AS V INNER JOIN Terceros AS T ON V.IdAsociado=T.IdTercero INNER JOIN adm_Usuarios AS U ON V.IdUsuario=U.IdUsuario
INNER JOIN Companias AS CI ON V.IdCia=CI.IdCia INNER JOIN Sys_TiposDoc AS TD ON V.TipDoc=TD.IdDoc
INNER JOIN Conceptos AS CN ON V.IdConcepto=CN.IdConcepto
INNER JOIN Trn_GatAportes AS D ON V.TipDoc=D.TipDoc AND V.NumRegistro=D.NumRegistro AND V.IdCia=D.IdCia
INNER JOIN QryVehiculosGat AS QV ON V.IdVehiculo=QV.IdVehiculo INNER JOIN Marcas AS M ON QV.IdMarca=M.IdMarca
INNER JOIN TiposCar AS TC ON QV.IdCrceria=TC.IdCrceria INNER JOIN Terceros AS NP ON QV.IdPoseedor=NP.IdTercero
LEFT JOIN TiposCol AS CL ON QV.IdColor=CL.IdColor LEFT JOIN TiposVeh AS TV ON QV.IdTipoVeh=TV.IdTipoVeh
LEFT JOIN TiposPpt AS TP ON QV.IdPpd=TP.IdPpd LEFT JOIN EstadoVeh AS EV ON QV.IdEstado=EV.IdEstado
LEFT JOIN TiposCom AS TCO ON V.TipCom=TCO.IdCom
WHERE V.TipDoc=@pmTipDoc AND V.Fecha BETWEEN ISNULL(@pmFechaIni,CAST('19900101' AS SMALLDATETIME)) AND ISNULL(@pmFechaFin,CAST('20781230' AS SMALLDATETIME))
AND (@pmIdCia IS NULL OR V.IdCia=@pmIdCia)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryGatAjustesLta] @pmTipDoc VARCHAR(3),@pmFechaIni SMALLDATETIME=Null,@pmFechaFin SMALLDATETIME=Null,@pmIdCia CHAR(2)=Null
 AS 
 SELECT A.TipDoc,A.NumAjuste,A.IdCia,Compania,A.Fecha,A.FechaVence,A.IdConcepto,CN.Concepto,A.Modalidad,A.VrAjustes,A.Referencia,A.TipDocRef,A.NumDocRef,A.CiaDocRef,A.TipCau,A.Causacion,A.IdCiaCau
,A.TipCom,TipoCom,A.Comprobante,A.IdCiaCom,A.Anulado,A.NumDev,A.FechaDev,A.Observacion,A.IdUsuario,Usuario,A.FechaCrea,A.IdCiaCrea,A.ModuloCrea,TD.TipoDoc
,D.Item,D.FecVence,D.IdAsociado,T.RazonSocial AS NomAsociado,D.UndVehiculo,D.IdVehiculo,D.nRemolque,D.Concepto AS ApoConcepto,D.Importe,D.VrAvaluo,D.VrComercial,D.VrAsegurado,D.TipoBaseLiq,D.VrDevolucion,D.Cantidad
,D.TarifaApo,D.CodTarifApo,D.CantDiasAnt,D.VrDiasAnt,D.Descripcion AS ApoDescripcion,D.Referencia AS ApoReferencia,D.TipDocRef AS ApoTipRef,D.NumDocRef AS ApoNumRef,D.TipoAfiVeh,D.FecLiqApo
,L.FechaLiquida,L.VrAportes AS TotalLiquida,L.Anulado AS LiqAnulado
,QV.NumVeh,QV.IdTipoVeh,TipoVehiculo,QV.IdMarca,Marca,QV.IdColor,NomColor,QV.IdCrceria,TipoCar,QV.Modelo,QV.IdPoseedor,NP.RazonSocial AS NomPoseedor,QV.IdPpd,TipoProp,QV.TipoAfil,QV.SerieChasis,QV.VrAvaludo AS VrAvaluoAct
,QV.EdoVincula,QV.FecIngreso,QV.FecVigencia,QV.FecRetiro,QV.IdEstado,EV.Estado,QV.Inactivo
 FROM Trn_GatAjustes AS A INNER JOIN Trn_GatAportes AS D ON A.TipDoc=D.TipDoc AND A.NumAjuste=D.NumRegistro AND A.IdCia=D.IdCia 
 INNER JOIN adm_Usuarios AS U ON A.IdUsuario=U.IdUsuario INNER JOIN Companias AS CI ON A.IdCia=CI.IdCia 
 INNER JOIN Sys_TiposDoc AS TD ON A.TipDoc=TD.IdDoc INNER JOIN Conceptos AS CN ON A.IdConcepto=CN.IdConcepto
 INNER JOIN Terceros AS T ON D.IdAsociado=T.IdTercero
 INNER JOIN QryVehiculosGat AS QV ON D.IdVehiculo=QV.IdVehiculo INNER JOIN Marcas AS M ON QV.IdMarca=M.IdMarca
 INNER JOIN TiposCar AS TC ON QV.IdCrceria=TC.IdCrceria INNER JOIN Terceros AS NP ON QV.IdPoseedor=NP.IdTercero
 LEFT JOIN TiposCol AS CL ON QV.IdColor=CL.IdColor LEFT JOIN TiposVeh AS TV ON QV.IdTipoVeh=TV.IdTipoVeh
 LEFT JOIN TiposPpt AS TP ON QV.IdPpd=TP.IdPpd LEFT JOIN EstadoVeh AS EV ON QV.IdEstado=EV.IdEstado
 LEFT JOIN TiposCom AS TCO ON A.TipCom=TCO.IdCom
 LEFT JOIN Trn_GatLiquida AS L ON A.TipDocRef=L.TipDoc AND A.NumDocRef=L.NumLiquida AND A.CiaDocRef=L.IdCia
 WHERE A.TipDoc=@pmTipDoc AND A.Fecha BETWEEN ISNULL(@pmFechaIni,CAST('19900101' AS SMALLDATETIME)) AND ISNULL(@pmFechaFin,CAST('20781230' AS SMALLDATETIME))
 AND (@pmIdCia IS NULL OR A.IdCia=@pmIdCia)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryGatAdicionalesLta] @pmTipDoc VARCHAR(3),@pmFechaIni SMALLDATETIME=Null,@pmFechaFin SMALLDATETIME=Null,@pmIdCia CHAR(2)=Null
 AS 
 SELECT A.TipDoc,A.NumRegistro,A.IdCia,Compania,A.Fecha,A.IdConcepto,CN.Concepto,A.IdAsociado,T.RazonSocial AS NomAsociado,A.UndVehiculo,A.IdVehiculo,A.nRemolque,A.VrAporte,A.VrSaldo,A.VrAvaluo,A.TipoBaseLiq
,A.TipoAfiVeh,A.Referencia,A.TipCom,TipoCom,A.Comprobante,A.IdCiaCom,A.Anulado,A.NumDev,A.FechaDev,A.Observacion,A.IdUsuario,Usuario,A.FechaCrea,A.IdCiaCrea,A.ModuloCrea,TD.TipoDoc
--recibos
,D.Item,D.TipRec,D.Recibo,D.IdCiaRec,D.ItemRec,D.VrAbono,D.Descripcion,R.Fecha AS FecRecibo,R.TipoConc,R.Descripcion AS RecDescripcion,R.VrIngreso,R.VrDevolucion,R.VrAbonos AS TotalAbonos,R.TipDocRef,R.NumDocRef,R.CiaDocRef,R.CodCuenta,R.ItemDet,R.EstadoReg
,QV.NumVeh,QV.IdTipoVeh,TipoVehiculo,QV.IdMarca,Marca,QV.IdColor,NomColor,QV.IdCrceria,TipoCar,QV.Modelo,QV.IdPoseedor,NP.RazonSocial AS NomPoseedor,QV.IdPpd,TipoProp,QV.TipoAfil,QV.SerieChasis,QV.VrAvaludo AS VrAvaluoAct
,QV.EdoVincula,QV.FecIngreso,QV.FecVigencia,QV.FecRetiro,QV.IdEstado,EV.Estado,QV.Inactivo
FROM Trn_GatAdicionales AS A INNER JOIN Trn_GatAdicionalRec AS D ON A.TipDoc=D.TipDoc AND A.NumRegistro=D.NumRegistro AND A.IdCia=D.IdCia
INNER JOIN Terceros AS T ON A.IdAsociado=T.IdTercero INNER JOIN adm_Usuarios AS U ON A.IdUsuario=U.IdUsuario
INNER JOIN Companias AS CI ON A.IdCia=CI.IdCia INNER JOIN Sys_TiposDoc AS TD ON A.TipDoc=TD.IdDoc
INNER JOIN Conceptos AS CN ON A.IdConcepto=CN.IdConcepto
INNER JOIN QryVehiculosGat AS QV ON A.IdVehiculo=QV.IdVehiculo INNER JOIN Marcas AS M ON QV.IdMarca=M.IdMarca
INNER JOIN TiposCar AS TC ON QV.IdCrceria=TC.IdCrceria INNER JOIN Terceros AS NP ON QV.IdPoseedor=NP.IdTercero
LEFT JOIN TiposCol AS CL ON QV.IdColor=CL.IdColor LEFT JOIN TiposVeh AS TV ON QV.IdTipoVeh=TV.IdTipoVeh
LEFT JOIN TiposPpt AS TP ON QV.IdPpd=TP.IdPpd LEFT JOIN EstadoVeh AS EV ON QV.IdEstado=EV.IdEstado
LEFT JOIN TiposCom AS TCO ON A.TipCom=TCO.IdCom
LEFT JOIN Trn_GatIngresos AS R ON D.TipRec=R.TipDoc AND D.Recibo=R.Recibo AND D.IdCiaRec=R.IdCia AND D.ItemRec=R.Item
WHERE A.TipDoc=@pmTipDoc AND A.Fecha BETWEEN ISNULL(@pmFechaIni,CAST('19900101' AS SMALLDATETIME)) AND ISNULL(@pmFechaFin,CAST('20781230' AS SMALLDATETIME))
AND (@pmIdCia IS NULL OR A.IdCia=@pmIdCia)
GO