CREATE PROCEDURE [dbo].[paQrytm_MovCueFp] @pmtmEst CHAR(2),@pmIdCia CHAR(2)=Null,@pmIdCuenta VARCHAR(16)=Null,@pmIdTercero VARCHAR(16)=Null
,@pmIdCCosto VARCHAR(16)=Null
 AS 
 SELECT C.IdCuenta AS CdCuenta,NomCuenta,C.TipCom,TipoCom,C.Comprobante,C.IdCia AS CdCia,Compania,C.Item,C.Fecha,C.Detalle,C.VrDebito,C.VrCredito,C.IdTercero AS NitTercero,T.RazonSocial AS RaznSocial
,C.IdVehiculo,C.IdCCosto AS CdCenCosto,CCosto,C.IdSubCos AS CdSubcentro,SubCosto,C.VrBase,C.TarifaBase,C.TipDoc,TipoDoc,C.Documento,C.IdCiaDoc,C.CodConce,Concepto
,C.NitDoc,ND.RazonSocial AS NomNitDoc,C.TipFac,C.Factura,C.IdCiaFac,C.ItemFac,C.FecVence ,C.CodCta,NumeroCta,CTE.IdBanco AS CodBanco,Banco
,C.NumCheque,C.Integrado,C.TipoAplica,C.Consolida,C.CodCargo,C.NitOtros,NIO.RazonSocial AS NomNitOtros,C.CodSubgpo,Subgrupo,C.CiuOrigen,LD.Localidad AS NomCiudad
,C.CodAgncia,A.Agencia AS NomAgencia,C.VehPropio,C.Referncia,C.TipDocRef,C.DocRef,C.IdCiaRef,VrSanCue,VrSanCueCia,VrSanNit,VrSanNitCia,VrSanVeh,VrSanVehCia
,VrSanCc,VrSanCcCia,VrSanCcSub,VrSanCcSubCia,VrSanNitCc,VrSanNitCcCia,VrSanNitCcSub,VrSanNitCcSubCia,VrSanNitAge,VrSanNitAgeCia
,VrSanNitAgeCc,VrSanNitAgeCcCia,VrSanNitAgeCcSub,VrSanNitAgeCcSubCia,VrSanNitVeh
,VrSanNitVehCia,VrSanNitVehCc,VrSanNitVehCcCia,VrSanVehCc,VrSanVehCcCia,VrSanVehCcSub,VrSanVehCcSubCia,tmEst,EsEgreso 
,TC.IdDiario AS CdDiario,Diario,FechaCons
--Información del tercero
,T.TipoId AS TercTipo,T.Dv AS TercDv,T.NomCial AS TercNomCial,T.SiglaRaz AS TercSigal,T.Direccion AS TercDireccion
,T.IdLocal AS TercCdCiudad,L.Localidad AS TercCiudad,L.IdDep AS CdDep,Departamento,T.Telefono AS TercTelefono,T.TipEnte AS TercTipEnte
,CodAgencia,DirAgncia,Referencia, DOC.FechaPag ,doc.NumDev,CM.IdTercero,CM.Beneficiario,ISNULL(CM.Anulado ,'0') AS ComDev 
,CO.Anulado AS ConAnu
 FROM tm_MovCue AS C  INNER JOIN Terceros AS T ON C.IdTercero=T.IdTercero
  INNER JOIN Localidades AS L ON T.IdLocal=L.IdLocal  INNER JOIN Departamentos AS DP ON L.IdDep=DP.IdDep 
 INNER JOIN Puc AS P ON C.IdCuenta=P.IdCuenta
 INNER JOIN CentroCosto AS O ON C.IdCCosto=O.IdCCosto
 LEFT JOIN  TiposCom AS TC ON C.TipCom=TC.IdCom LEFT JOIN Diarios AS DR ON TC.IdDiario=DR.IdDiario
 LEFT JOIN Companias AS CI ON C.IdCia=CI.IdCia
 LEFT JOIN SubCentros AS SC ON C.IdSubCos=SC.IdSubCos
 LEFT JOIN Terceros AS NIO ON C.NitOtros=NIO.IdTercero
 LEFT JOIN Terceros AS ND ON C.NitDoc=ND.IdTercero
 LEFT JOIN Conceptos AS CN ON C.CodConce=CN.IdConcepto
 LEFT JOIN Localidades AS LD ON C.CiuOrigen=LD.IdLocal
 LEFT JOIN SubGrupos AS SG ON  C.CodSubgpo=SG.IdSubgrupo
 LEFT JOIN Agencias AS A ON C.CodAgncia=A.IdAgencia
 LEFT JOIN Sys_TiposDoc AS TD ON C.TipDoc=TD.IdDoc
LEFT JOIN CtasCorrientes AS CTE ON C.CodCta=CTE.IdCta LEFT JOIN Bancos AS B ON CTE.IdBanco=B.IdBanco
LEFT JOIN (select TipDoc,Recibo ,IdCia AS IdciaDoc,NumDev,isnull(MAX(FecPago) ,max(Fecha) )as FechaPag from Trn_Recibos  group by TipDoc,Recibo ,IdCia,NumDev
union all select TipDoc,Recibo ,IdCia AS IdciaDoc,NumDev,isnull(MAX(FecPago) ,max(Fecha) )as FechaPag from Trn_FinRecibos  group by TipDoc,Recibo ,IdCia,NumDev)
 AS Doc ON C.Tipdoc=DOC.TipDoc and C.Documento=DOC.Recibo  and C.idciaDoc=DOC.IdciaDoc
 LEFT JOIN (SELECT TipCom ,Comprobante,idcia,Beneficiario,IdTercero,Anulado FRom Trn_Comprobantes )  AS CM
  ON C.TipCom =CM.TipCom AND C.Comprobante =CM.Comprobante AND C.IdCia =CM.IdCia  
  --Información de la consignación
LEFT JOIN (SELECT TipDoc AS TipDocCO ,Consignacion,Idcia AS IdCiaCO,Anulado,isnull(MAX(FecConsig),MAX (FECHA)) AS FechaCons, MAX(Fecha)AS FechDoc
FROM Trn_Consigna group by TipDoc,Consignacion,IdCia,Anulado)as CO on C.TipDoc = CO.TipDocCO AND C.Documento = CO.Consignacion AND C.IdCiaDoc = CO.IdCiaCO 
 WHERE tmEst=@pmtmEst AND C.IdCia LIKE ISNULL(@pmIdCia,'%%') AND C.IdCuenta LIKE ISNULL(@pmIdCuenta,'%')
 AND C.IdTercero LIKE ISNULL(@pmIdTercero ,'%') AND C.IdCCosto LIKE ISNULL(@pmIdCCosto,'%')
 ORDER BY C.IdCuenta,C.Fecha,C.IdCia,TipCom