if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryGatDevAdicionalLta]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryGatDevAdicionalLta]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryGatDevAjuProrLta]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryGatDevAjuProrLta]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryGatDevAjustesLta]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryGatDevAjustesLta]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryGatDevLiquidaLta]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryGatDevLiquidaLta]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryGatDevProrrFmt]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryGatDevProrrFmt]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryGatDevRetirosLta]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryGatDevRetirosLta]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryGatDevTrasladoFmt]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryGatDevTrasladoFmt]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryGatDevVincLta]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryGatDevVincLta]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryGatDevVincLta] @pmTipDev VARCHAR(3),@pmFechaIni SMALLDATETIME=Null,@pmFechaFin SMALLDATETIME=Null,@pmIdCia CHAR(2)=Null
 AS 
 SELECT D.TipDev,D.Devolucion,D.IdCia,Compania,D.Fecha,D.IdConcepto,CN.Concepto,D.TipDoc,D.NumDocVinc,D.IdCiaDoc,D.FecDoc,V.FechaIngreso,D.IdAsociado,T.RazonSocial AS NomAsociado,D.UndVehiculo,D.IdVehiculo,D.nRemolque
,D.VrIngresos,D.VrTraslados,V.TarifaVinc,V.VrVinculacion,V.VrAvaluo,V.VrComercial,V.VrAsegurado,V.TipoBaseLiq,V.TipoAfiVeh,V.Referencia,V.CdTarifVinc,V.FecUltLiqApo
,D.TipCom,TipoCom,D.Comprobante,D.IdCiaCom,D.ModdDev,D.Observacion,D.IdUsuario,Usuario,D.FechaCrea,D.IdCiaCrea,D.ModuloCrea,TD.TipoDoc
--detalle aportes
,DA.Item,DA.FecVence,DA.Concepto AS ApoConcepto,DA.Importe,DA.VrDevolucion AS VrDeduccion,DA.Cantidad,DA.TarifaApo,DA.Descripcion AS ApoDescripcion,DA.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_GatDevVinc AS D INNER JOIN Trn_GatVincula AS V ON D.TipDoc=V.TipDoc AND D.NumDocVinc=V.NumRegistro AND D.IdCiaDoc=V.IdCia
INNER JOIN Terceros AS T ON D.IdAsociado=T.IdTercero INNER JOIN adm_Usuarios AS U ON D.IdUsuario=U.IdUsuario
INNER JOIN Companias AS CI ON D.IdCia=CI.IdCia INNER JOIN Sys_TiposDoc AS TD ON D.TipDev=TD.IdDoc
INNER JOIN Conceptos AS CN ON D.IdConcepto=CN.IdConcepto
INNER JOIN Trn_GatAportes AS DA ON D.TipDev=DA.TipDoc AND D.Devolucion=DA.NumRegistro AND D.IdCia=DA.IdCia
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 D.TipCom=TCO.IdCom
WHERE D.TipDev=@pmTipDev AND D.Fecha BETWEEN ISNULL(@pmFechaIni,CAST('19900101' AS SMALLDATETIME)) AND ISNULL(@pmFechaFin,CAST('20781230' AS SMALLDATETIME))
AND (@pmIdCia IS NULL OR D.IdCia=@pmIdCia)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryGatDevRetirosLta] @pmTipDev VARCHAR(3),@pmFechaIni SMALLDATETIME=Null,@pmFechaFin SMALLDATETIME=Null,@pmIdCia CHAR(2)=Null
 AS 
 SELECT D.TipDev,D.Devolucion,D.IdCia,Compania,D.Fecha,D.IdConcepto,CN.Concepto,D.TipDoc,D.NumRetiro,D.IdCiaDoc,D.FecDoc,R.FechaRetiro,D.TipoRetiro,D.Modalidad,D.IdAsociado,T.RazonSocial AS NomAsociado,D.UndVehiculo,D.IdVehiculo,D.nRemolque
,D.VrDevolucion,R.VrRetiro,R.VrAportes,R.VrVinculacion,R.VrSaldoVinc,R.VrGarantia,R.VrSaldoApo,R.VrTotalApo,R.VrAvaluo,R.TipoBaseLiq,R.TipoAfiVeh,R.Referencia,R.FechaCorte,D.TipCom,TipoCom,D.Comprobante,D.IdCiaCom,D.ModdDev
,D.Observacion,D.IdUsuario,Usuario,D.FechaCrea,D.IdCiaCrea,D.ModuloCrea,TD.TipoDoc
,DA.Item,DA.UndVehiculo AS DetUndVehic,DA.IdVehiculo AS DetVehiculo,DA.VrRetiro AS DetVrRetio,DA.VrAportes AS DetVrAportes,DA.VrVinculacion AS DetVrVincula,DA.VrSaldoVinc AS DetVrSaldoVinc
,DA.VrGarantia AS DetVrGarantia,DA.VrSaldoApo AS DetVrSaldoApo,DA.VrTotalApo AS DetVrTotalApo,DA.VrAvaluo AS DetVrAvaluo,DA.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_GatDevRetiros AS D INNER JOIN Trn_GatRetiros AS R ON D.TipDoc=R.TipDoc AND D.NumRetiro=R.NumRegistro AND D.IdCiaDoc=R.IdCia
 INNER JOIN adm_Usuarios AS U ON D.IdUsuario=U.IdUsuario INNER JOIN Companias AS CI ON D.IdCia=CI.IdCia INNER JOIN Sys_TiposDoc AS TD ON D.TipDev=TD.IdDoc
 INNER JOIN Conceptos AS CN ON D.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 D.TipCom=TCO.IdCom
LEFT JOIN Trn_GatRetirosDet AS DA ON D.TipDoc=DA.TipDoc AND D.NumRetiro=DA.NumRegistro AND D.IdCiaDoc=DA.IdCia
WHERE D.TipDev=@pmTipDev AND D.Fecha BETWEEN ISNULL(@pmFechaIni,CAST('19900101' AS SMALLDATETIME)) AND ISNULL(@pmFechaFin,CAST('20781230' AS SMALLDATETIME))
AND (@pmIdCia IS NULL OR D.IdCia=@pmIdCia)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryGatDevTrasladoFmt] @pmTipDev VARCHAR(3),@pmFechaIni SMALLDATETIME=Null,@pmFechaFin SMALLDATETIME=Null,@pmIdCia CHAR(2)=Null
 AS 
 SELECT D.TipDev,D.Devolucion,D.IdCia,Compania,D.Fecha,D.IdConcepto,CN.Concepto,D.Modalidad,D.TipDoc,D.NumTraslado,D.IdCiaDoc,D.FecDoc
,D.IdAsociado,NA.RazonSocial AS NomAsociado,D.UndVehiculo,D.IdVehiculo,D.nRemolque,D.IdAsociadoDtn,ND.RazonSocial AS NomAsociadoDtn,D.UndVehicDtn,D.IdVehiculoDtn,D.VrDevolucion,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
,D.TipCom,TipoCom,D.Comprobante,D.IdCiaCom,D.ModdDev,D.Observacion,D.IdUsuario,Usuario,D.FechaCrea,D.IdCiaCrea,D.ModuloCrea,TD.TipoDoc
,DA.Item,DA.FecEmision,DA.FecVence,DA.Concepto AS ApoConcepto,DA.IdAsociado AS ApoIdAsociado,A.RazonSocial AS ApoNomAsociado,DA.UndVehiculo AS ApoUndVehic,DA.IdVehiculo AS ApoIdVehiculo,DA.nRemolque AS ApoRemolque,DA.Importe,DA.VrComercial,DA.VrAsegurado,DA.Cantidad,DA.TarifaApo,DA.CodTarifApo
,DA.CantDiasAnt,DA.VrDiasAnt,DA.VrDevolucion AS VrDeduccion,DA.Descripcion AS ApoDescripcion,DA.Referencia AS ApoReferencia,DA.TipDocRef AS ApoDocRef,DA.NumDocRef AS ApoNumDocRef,DA.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_GatDevTraslado AS D INNER JOIN Trn_GatTraslados AS T ON D.TipDoc=T.TipDoc AND D.NumTraslado=T.NumTraslado AND D.IdCiaDoc=T.IdCia
INNER JOIN adm_Usuarios AS U ON D.IdUsuario=U.IdUsuario INNER JOIN Companias AS CI ON D.IdCia=CI.IdCia INNER JOIN Sys_TiposDoc AS TD ON D.TipDev=TD.IdDoc
INNER JOIN Conceptos AS CN ON D.IdConcepto=CN.IdConcepto INNER JOIN Terceros AS NA ON D.IdAsociado=NA.IdTercero
INNER JOIN Trn_GatAportes AS DA ON D.TipDev=DA.TipDoc AND D.Devolucion=DA.NumRegistro AND D.IdCia=DA.IdCia
INNER JOIN Terceros AS A ON DA.IdAsociado=A.IdTercero
INNER JOIN QryVehiculosGat AS QV ON DA.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 D.TipCom=TCO.IdCom LEFT JOIN Terceros AS ND ON D.IdAsociadoDtn=ND.IdTercero
WHERE D.TipDev=@pmTipDev AND D.Fecha BETWEEN ISNULL(@pmFechaIni,CAST('19900101' AS SMALLDATETIME)) AND ISNULL(@pmFechaFin,CAST('20781230' AS SMALLDATETIME))
AND (@pmIdCia IS NULL OR D.IdCia=@pmIdCia)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryGatDevAdicionalLta] @pmTipDev VARCHAR(3),@pmFechaIni SMALLDATETIME=Null,@pmFechaFin SMALLDATETIME=Null,@pmIdCia CHAR(2)=Null
 AS 
 SELECT D.TipDev,D.Devolucion,D.IdCia,Compania,D.Fecha,D.IdConcepto,CN.Concepto,D.TipDoc,D.NumRegistro,D.IdCiaDoc,D.FecDoc,D.IdAsociado,T.RazonSocial AS NomAsociado
,D.UndVehiculo,D.IdVehiculo,D.nRemolque,D.VrDevolucion,A.VrSaldo,A.VrAvaluo,A.TipoBaseLiq,A.TipoAfiVeh,A.Referencia,D.TipCom,TipoCom,D.Comprobante,D.IdCiaCom,D.ModdDev,D.Observacion,D.IdUsuario,Usuario,D.FechaCrea,D.IdCiaCrea,D.ModuloCrea,TD.TipoDoc
--recibos
,DR.Item,DR.TipRec,DR.Recibo,DR.IdCiaRec,DR.ItemRec,DR.VrAbono,DR.Descripcion,R.Fecha AS FecRecibo,R.TipoConc,R.Descripcion AS RecDescripcion,R.VrIngreso,R.VrDevolucion AS RecVrDev,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_GatDevAdicional AS D INNER JOIN Trn_GatAdicionales AS A ON D.TipDoc=A.TipDoc AND D.NumRegistro=A.NumRegistro AND D.IdCiaDoc=A.IdCia
INNER JOIN Trn_GatAdicionalRec AS DR ON D.TipDoc=DR.TipDoc AND D.NumRegistro=DR.NumRegistro AND D.IdCiaDoc=DR.IdCia
INNER JOIN Terceros AS T ON D.IdAsociado=T.IdTercero INNER JOIN adm_Usuarios AS U ON D.IdUsuario=U.IdUsuario
INNER JOIN Companias AS CI ON D.IdCia=CI.IdCia INNER JOIN Sys_TiposDoc AS TD ON D.TipDev=TD.IdDoc
INNER JOIN Conceptos AS CN ON D.IdConcepto=CN.IdConcepto
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 D.TipCom=TCO.IdCom
LEFT JOIN Trn_GatIngresos AS R ON DR.TipRec=R.TipDoc AND DR.Recibo=R.Recibo AND DR.IdCiaRec=R.IdCia AND DR.ItemRec=R.Item
WHERE D.TipDev=@pmTipDev AND D.Fecha BETWEEN ISNULL(@pmFechaIni,CAST('19900101' AS SMALLDATETIME)) AND ISNULL(@pmFechaFin,CAST('20781230' AS SMALLDATETIME))
AND (@pmIdCia IS NULL OR D.IdCia=@pmIdCia)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryGatDevAjuProrLta] @pmTipDev VARCHAR(3),@pmFechaIni SMALLDATETIME=Null,@pmFechaFin SMALLDATETIME=Null,@pmIdCia CHAR(2)=Null
 AS 
 SELECT D.TipDev,D.Devolucion,D.IdCia,Compania,D.Fecha,D.IdConcepto,CN.Concepto,D.Modalidad,D.TipDoc,D.NumAjuste,D.IdCiaDoc,D.FecDoc,D.VrDevolucion
,A.TipPror,A.NumProceso,A.IdCiaPror,A.VrAjustes,A.Referencia,D.TipCom,TipoCom,D.Comprobante,D.IdCiaCom,D.ModdDev,D.Observacion,D.IdUsuario,Usuario,D.FechaCrea,D.IdCiaCrea,D.ModuloCrea,TD.TipoDoc
,DA.Item,DA.FecVence,DA.IdAsociado,T.RazonSocial AS NomAsociado,DA.UndVehiculo,DA.IdVehiculo,DA.nRemolque,DA.Concepto AS ApoConcepto,DA.Importe,DA.VrAvaluo,DA.VrComercial,DA.VrAsegurado,DA.TipoBaseLiq,DA.VrDevolucion AS VrDeduccion,DA.Cantidad
,DA.TarifaApo,DA.CodTarifApo,DA.CantDiasAnt,DA.VrDiasAnt,DA.Descripcion AS ApoDescripcion,DA.Referencia AS ApoReferencia,DA.TipDocRef AS ApoTipRef,DA.NumDocRef AS ApoNumRef,DA.TipoAfiVeh,DA.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_GatDevAjuPror AS D INNER JOIN Trn_GatAjustesPror AS A ON D.TipDoc=A.TipDoc AND D.NumAjuste=A.NumAjuste AND D.IdCiaDoc=A.IdCia
 INNER JOIN Trn_GatAportes AS DA ON D.TipDev=DA.TipDoc AND D.Devolucion=DA.NumRegistro AND D.IdCia=DA.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 D.IdUsuario=U.IdUsuario INNER JOIN Companias AS CI ON D.IdCia=CI.IdCia 
 INNER JOIN Sys_TiposDoc AS TD ON D.TipDev=TD.IdDoc INNER JOIN Conceptos AS CN ON D.IdConcepto=CN.IdConcepto
 INNER JOIN Terceros AS T ON DA.IdAsociado=T.IdTercero
 INNER JOIN QryVehiculosGat AS QV ON DA.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 D.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 D.TipDev=@pmTipDev AND D.Fecha BETWEEN ISNULL(@pmFechaIni,CAST('19900101' AS SMALLDATETIME)) AND ISNULL(@pmFechaFin,CAST('20781230' AS SMALLDATETIME))
 AND (@pmIdCia IS NULL OR D.IdCia=@pmIdCia)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryGatDevAjustesLta] @pmTipDev VARCHAR(3),@pmFechaIni SMALLDATETIME=Null,@pmFechaFin SMALLDATETIME=Null,@pmIdCia CHAR(2)=Null
AS 
SELECT D.TipDev,D.Devolucion,D.IdCia,D.Fecha,D.IdConcepto,CN.Concepto,D.TipDoc,D.NumAjuste,D.IdCiaDoc,D.FecDoc,D.Modalidad,D.VrDevolucion,A.VrAjustes,A.FechaVence,A.Referencia,A.TipDocRef,A.NumDocRef,A.CiaDocRef,A.TipCau,A.Causacion,A.IdCiaCau
,D.TipCom,TipoCom,D.Comprobante,D.IdCiaCom,D.ModdDev,D.Observacion,D.IdUsuario,Usuario,D.FechaCrea,D.IdCiaCrea,D.ModuloCrea,TD.TipoDoc
,DA.Item,DA.FecVence,DA.IdAsociado,T.RazonSocial AS NomAsociado,DA.UndVehiculo,DA.IdVehiculo,DA.nRemolque,DA.Concepto AS ApoConcepto,DA.Importe,DA.VrAvaluo,DA.VrComercial,DA.VrAsegurado,DA.TipoBaseLiq,DA.VrDevolucion AS VrDeduccion,DA.Cantidad
,DA.TarifaApo,DA.CodTarifApo,DA.CantDiasAnt,DA.VrDiasAnt,DA.Descripcion AS ApoDescripcion,DA.Referencia AS ApoReferencia,DA.TipDocRef AS ApoTipRef,DA.NumDocRef AS ApoNumRef,DA.TipoAfiVeh,DA.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_GatDevAjustes AS D INNER JOIN Trn_GatAjustes AS A ON D.TipDoc=A.TipDoc AND D.NumAjuste=A.NumAjuste AND D.IdCiaDoc=A.IdCia
 INNER JOIN Trn_GatAportes AS DA ON D.TipDev=DA.TipDoc AND D.Devolucion=DA.NumRegistro AND D.IdCia=DA.IdCia
 INNER JOIN adm_Usuarios AS U ON D.IdUsuario=U.IdUsuario INNER JOIN Companias AS CI ON D.IdCia=CI.IdCia 
 INNER JOIN Sys_TiposDoc AS TD ON D.TipDev=TD.IdDoc INNER JOIN Conceptos AS CN ON D.IdConcepto=CN.IdConcepto
 INNER JOIN Terceros AS T ON DA.IdAsociado=T.IdTercero
 INNER JOIN QryVehiculosGat AS QV ON DA.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 D.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 D.TipDev=@pmTipDev AND D.Fecha BETWEEN ISNULL(@pmFechaIni,CAST('19900101' AS SMALLDATETIME)) AND ISNULL(@pmFechaFin,CAST('20781230' AS SMALLDATETIME))
 AND (@pmIdCia IS NULL OR D.IdCia=@pmIdCia)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryGatDevLiquidaLta] @pmTipDev VARCHAR(3),@pmFechaIni SMALLDATETIME=Null,@pmFechaFin SMALLDATETIME=Null,@pmIdCia CHAR(2)=Null
 AS 
 SELECT D.TipDev,D.Devolucion,D.IdCia,Compania,D.Fecha,D.IdConcepto,CN.Concepto,D.TipDoc,D.NumLiquida,D.IdCiaDoc,D.FecDoc,L.FechaLiquida,L.FechaVence,D.Modalidad,L.Periodos,L.TarifaLiq,L.VrAportes,D.VrDevolucion,D.VrBaseLiq
,L.Referencia,L.TipCau,L.Causacion,L.IdCiaCau,L.CdTarifLiq,D.TipCom,TipoCom,D.Comprobante,D.IdCiaCom,D.ModdDev,D.Observacion,D.IdUsuario,Usuario,D.FechaCrea,D.IdCiaCrea,D.ModuloCrea,TD.TipoDoc
,DA.Item,DA.FecVence,DA.IdAsociado,T.RazonSocial AS NomAsociado,DA.UndVehiculo,DA.IdVehiculo,DA.nRemolque,DA.Concepto AS ApoConcepto,DA.Importe,DA.VrAvaluo,DA.VrComercial,DA.VrAsegurado,DA.TipoBaseLiq,DA.VrDevolucion AS VrDeduccion,DA.Cantidad
,DA.TarifaApo,DA.CodTarifApo,DA.CantDiasAnt,DA.VrDiasAnt,DA.Descripcion AS ApoDescripcion,DA.Referencia AS ApoReferencia,DA.TipDocRef,DA.NumDocRef,DA.TipoAfiVeh,DA.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_GatDevLiquida AS D INNER JOIN Trn_GatLiquida AS L ON D.TipDoc=L.TipDoc AND D.NumLiquida=L.NumLiquida AND D.IdCiaDoc=L.IdCia
 INNER JOIN Trn_GatAportes AS DA ON D.TipDev=DA.TipDoc AND D.Devolucion=DA.NumRegistro AND D.IdCia=DA.IdCia
 INNER JOIN adm_Usuarios AS U ON D.IdUsuario=U.IdUsuario INNER JOIN Companias AS CI ON D.IdCia=CI.IdCia 
 INNER JOIN Sys_TiposDoc AS TD ON D.TipDev=TD.IdDoc INNER JOIN Conceptos AS CN ON D.IdConcepto=CN.IdConcepto
 INNER JOIN Terceros AS T ON DA.IdAsociado=T.IdTercero
 INNER JOIN QryVehiculosGat AS QV ON DA.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 D.TipCom=TCO.IdCom
 WHERE D.TipDev=@pmTipDev AND D.Fecha BETWEEN ISNULL(@pmFechaIni,CAST('19900101' AS SMALLDATETIME)) AND ISNULL(@pmFechaFin,CAST('20781230' AS SMALLDATETIME))
 AND (@pmIdCia IS NULL OR D.IdCia=@pmIdCia)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryGatDevProrrFmt] @pmTipDev VARCHAR(3),@pmDevolucionIni INT,@pmDevolucionFin INT,@pmIdCia CHAR(2)
 AS 
 SELECT D.TipDev,D.Devolucion,D.IdCia,Compania,D.Fecha,D.IdConcepto,CN.Concepto,D.TipDoc,D.NumProceso,D.IdCiaDoc,D.FecDoc,D.Modalidad
,D.IdAsociado,T.RazonSocial AS NomAsociado,D.UndVehiculo,D.IdVehiculo,D.nRemolque,D.VrDevolucion,P.VrAprobado,P.VrAvaluo
,P.TipDocActa,P.NumDocActa,P.IdCiaActa,P.FecSuceso,P.TipoAfiVeh,P.Referencia,D.TipCom,TipoCom,D.Comprobante,D.IdCiaCom
,D.ModdDev,D.Observacion,D.IdUsuario,Usuario,D.FechaCrea,D.IdCiaCrea,D.ModuloCrea,TD.TipoDoc
,DA.Item,DA.IdAsociado AS DetNitAsociado,NA.RazonSocial AS DetNomAsociado,DA.UndVehiculo AS DetUndVehic,DA.IdVehiculo AS DetIdVehiculo,DA.VrAvaluo AS DetVrAvaluo,DA.TipoBaseLiq,DA.TarifaLiq,DA.VrAportes,DA.Importe,DA.VrRetiros,DA.CodTarifa
,DA.Observacion AS DetObservacion,DA.FecLiquida,DA.FecIngreso AS DetFecIngreso,DA.FecRetiro AS DetFecRetiro,DA.EdoVincula AS DetEdoVincula,DA.Num_CasoSin,DA.Cia_CasoSin,DA.VrAprobActa,DA.Estado_Reg
,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_GatDevProrr AS D INNER JOIN Trn_GatProrrateos AS P ON D.TipDoc=P.TipDoc AND D.NumProceso=P.NumProceso AND D.IdCiaDoc=P.IdCia
INNER JOIN Trn_GatProrratVeh AS DA ON D.TipDoc=DA.TipDoc AND D.NumProceso=DA.NumProceso AND D.IdCiaDoc=DA.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 D.IdUsuario=U.IdUsuario
INNER JOIN Companias AS CI ON D.IdCia=CI.IdCia INNER JOIN Sys_TiposDoc AS TD ON D.TipDev=TD.IdDoc
INNER JOIN Conceptos AS CN ON D.IdConcepto=CN.IdConcepto INNER JOIN Terceros AS T ON D.IdAsociado=T.IdTercero
INNER JOIN Terceros AS NA ON DA.IdAsociado=NA.IdTercero
LEFT JOIN QryVehiculosGat AS QV ON DA.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 D.TipCom=TCO.IdCom
WHERE D.TipDev=@pmTipDev AND D.Devolucion BETWEEN @pmDevolucionIni AND @pmDevolucionFin AND D.IdCia=@pmIdCia
GO