if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsAcuAnticipos_Nit]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsAcuAnticipos_Nit]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsAcuFisCuentasAge_Uni]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsAcuFisCuentasAge_Uni]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsAcuFisCuentasNit_Uni]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsAcuFisCuentasNit_Uni]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsAcuFisCuentasVeh_Uni]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsAcuFisCuentasVeh_Uni]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsAcuNiifCuentasAge_Uni]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsAcuNiifCuentasAge_Uni]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsAcuNiifCuentasNit_Uni]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsAcuNiifCuentasNit_Uni]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsAcuNiifCuentasVeh_Uni]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsAcuNiifCuentasVeh_Uni]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsFinClieSaldos_Uni]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsFinClieSaldos_Uni]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsFinClieSaldosLin_Uni]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsFinClieSaldosLin_Uni]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsMttoConceptos]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsMttoConceptos]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsMttoControles]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsMttoControles]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsMttoOrdenDet]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsMttoOrdenDet]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsMttoTrabajos]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsMttoTrabajos]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInstm_MttoDetalle]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInstm_MttoDetalle]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInstm_MttoDetalle_Sel]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInstm_MttoDetalle_Sel]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsVehPartes]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsVehPartes]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsVehRemolq]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsVehRemolq]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryMttoConceptos]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryMttoConceptos]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryMttoConceptosLta]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryMttoConceptosLta]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryMttoControles]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryMttoControles]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryMttoControlesLta]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryMttoControlesLta]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryMttoOrdenDet]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryMttoOrdenDet]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryMttoOrdenFmt]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryMttoOrdenFmt]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryVehPartes]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryVehPartes]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryVehPartesLta]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryVehPartesLta]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryVehRemolq]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryVehRemolq]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryVehRemolqLta]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryVehRemolqLta]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paUpMttoConceptos]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paUpMttoConceptos]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paUpMttoControles]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paUpMttoControles]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paUpMttoOrdenDet]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paUpMttoOrdenDet]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paUpVehPartes]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paUpVehPartes]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paUpVehRemolq]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paUpVehRemolq]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryMttoOrdenFmt] @pmTipDoc VARCHAR(3),@pmNumOrdenIni INT,@pmNumOrdenFin INT,@pmIdCia CHAR(2) 
AS 
 SELECT O.TipDoc AS IdTipDoc,TipoDoc,O.NumOrden,O.IdCia AS CdCia,Compania,Fecha,FechaOrden,FechaVence,O.IdVehiculo,NumVeh,kmVehiculo,nRemolque,kmRemolque,O.IdTipoOdt AS CdTipoOdt,TipoOrden,O.IdCenSer AS CdCenSer,CentroServ
,O.IdConductor AS CedConductor,CDT.RazonSocial AS NomConductor,O.IdOperario AS NitOperario,T.RazonSocial AS NomOperario,IdSupervisor,NSU.RazonSocial AS Supervisor,O.Modalidad
,VrServicios,VrRepuestos,VrManoObra,VrOtros,FechaCierre,NitCenSer,O.CdEstadoVeh,EV.Estado AS EstadoVeh,EV.NColor AS EdvNColor,EV.OutDemand,O.IdEstado AS CdEstado,ED.Estado AS EstadoDoc,ED.NColor AS EdNumColor
,O.Anulado,NumDev,FecDev,O.Observacion AS Observ,O.TimeSys AS FechaCrea,O.FecUpdate AS FecActualiza,O.IdCiaCrea AS CdCIaCrea,O.OrigenAdd,O.IdUsuario AS CdUsuario,Usuario
,D.Item,FechaServ,D.IdConc,D.Descripcion,Concepto,D.Cantidad,D.VrUnitario,UndMed,D.CdMtto,TipoMtto,D.IdEstado AS DetIdEstado,ESV.Estado AS DetEstado,ESV.NColor AS DetNumColor
,D.IdOperario AS DetNitOperario,NOD.RazonSocial AS DetOperario,NumVehic,NumParte,Req_Rep,Req_MO,D.FechaCrea AS DetFecCrea,D.IdUsuario AS DetCdUsuario,TipoServ,CO.IdSistema AS CdSistema,Sistema 
,T.TipoId AS TercTipId,T.Dv AS TercDv,T.Codigo AS TercCodigo,T.NomCial AS TercNomCial,T.Direccion AS TercDireccion,T.IdLocal AS TercCdCiudad,L.Localidad AS NomCiudad
,T.Telefono AS TercTelefono,T.e_mail AS TercEmail
,V.IdTipoVeh AS CdTipVeh,TipoVehiculo,V.IdMarca AS CdMarca,M.Marca AS MarcaVeh,V.IdLinea AS CdLinVeh,LineaVeh,V.IdColor AS CdColor,NomColor,V.IdCrceria AS CdCarr,TipoCar,Modelo,Config
,PesoVacio,NumMotor,SerieChasis,NumSerie,CdRemque,NitEmpresa,NE.RazonSocial AS VehNomEmpresa,V.IdPoseedor AS NitPoseedor,NPO.RazonSocial AS Poseedor
,V.IdPpd AS CdTipProp,TipoProp,VehPropio,TipoAfil,NumSoat,FecSoat,VigSoat,NitEmpSoat,NS.RazonSocial AS CiaAsegurdora,V.Descripcion AS VehDescripcion,KmInicial,KmActual,Km2Actual,V.Ubicacion
,V.IdEstado AS VehCdEstado,EVH.Estado AS VehEstado,EVH.NColor AS VehEstColor,EVH.OutDemand AS VehNoDisponible,V.Inactivo AS VehInactivo
,Licencia,CatLicencia,CT.IdLugar AS CdLugar,LugarLic,FecLicencia,VigLicencia
 FROM Trn_MttoOrden AS O INNER JOIN Companias AS CN ON O.IdCia=CN.IdCia INNER JOIN EstadoDoc AS ED ON O.IdEstado=ED.IdEstado
 INNER JOIN MttoTiposOdt AS TOT ON O.IdTipoOdt=TOT.IdTipoOdt INNER JOIN CentrosServ AS CS ON O.IdCenSer=CS.IdCenSer
 INNER JOIN Terceros AS T ON O.IdOperario=T.IdTercero INNER JOIN Terceros AS CDT ON O.IdConductor=CDT.IdTercero INNER JOIN Terceros AS NSU ON O.IdSupervisor=NSU.IdTercero
 INNER JOIN adm_Usuarios AS U ON O.IdUsuario=U.IdUsuario INNER JOIN Sys_TiposDoc AS TD ON O.TipDoc=TD.IdDoc
 INNER JOIN Localidades AS L ON T.IdLocal=L.IdLocal
 INNER JOIN Trn_MttoOrdenDet AS D ON O.TipDoc=D.TipOdt AND O.NumOrden=D.NumOrden AND O.IdCia=D.IdCia
 INNER JOIN MttoConceptos AS CO ON D.IdConc=CO.IdConc INNER JOIN MttoSistemas AS S ON CO.IdSistema=S.IdSistema
 LEFT JOIN Terceros AS NOD ON D.IdOperario=NOD.IdTercero LEFT JOIN MttoTipos AS TM ON D.CdMtto=TM.IdMtto
 LEFT JOIN MttoEstados AS ESV ON D.IdEstado=ESV.IdEstado
 LEFT JOIN EstadoVeh AS EV ON O.CdEstadoVeh=EV.IdEstado 
 LEFT JOIN Vehiculos AS V ON O.IdVehiculo=V.IdVehiculo LEFT JOIN TiposVeh AS TV ON V.IdTipoVeh=TV.IdTipoVeh 
 LEFT JOIN Marcas AS M ON V.IdMarca=M.IdMarca LEFT JOIN TiposCol AS CL ON V.IdColor=CL.IdColor 
 LEFT JOIN TiposCar AS TC ON V.IdCrceria=TC.IdCrceria LEFT JOIN Terceros AS NPO ON V.IdPoseedor=NPO.IdTercero
 LEFT JOIN TiposPpt AS TPR ON V.IdPpd=TPR.IdPpd LEFT JOIN MarcasLin AS LV ON V.IdLinea=LV.IdLinea 
 LEFT JOIN Terceros AS NE ON  V.NitEmpresa=NE.IdTercero LEFT JOIN Terceros AS NS ON V.NitEmpSoat=NS.IdTercero
 LEFT JOIN TercCndtores AS CT ON O.IdConductor=CT.IdConductor LEFT JOIN ExpLicencias AS EL ON CT.IdLugar=EL.IdLugar
 LEFT JOIN EstadoVeh AS EVH ON V.IdEstado=EVH.IdEstado
 WHERE O.TipDoc=@pmTipDoc AND O.NumOrden BETWEEN @pmNumOrdenIni AND @pmNumOrdenFin AND O.IdCia=@pmIdCia
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryVehRemolqLta] @pmIdMarca VARCHAR(4)=Null,@pmIdCrceria VARCHAR(4)=Null,@pmModelo VARCHAR(4)=Null
,@pmIdPropietario VARCHAR(16)=Null,@pmIdEstado VARCHAR(4)=Null,@pmInactivo BIT=Null
,@pmFecComIni SMALLDATETIME=Null,@pmFecComFin SMALLDATETIME=Null
 AS 
 SELECT IdRemque,R.IdMarca AS CdMarca,Marca,R.IdColor AS CodColor,NomColor,R.IdCrceria AS CodCarr,TipoCar,Modelo,ConfEjes,NEjes,nLlantas,Altura,Ancho,Largo,Vlumen
,PesoKg,Capneta,UndCapc,NumComp,CapcComp,NumSerial,IdPropietario,NP.RazonSocial AS Propietario,NitProv,NPV.RazonSocial AS Proveedor,FecCompra,VidaUtil
,VrComercial,VrAvaludo,VrAsegurado,Kilmetraje,kmRuta,kmOtro,EquipoAdic,Descripcion,CdCenSer,CentroServ,CdLocal,LU.Localidad AS CiuUbicacion
,LU.IdDep AS CodDpto,Departamento,Ubicacion,R.Observacion AS Observ,R.IdEstado AS CodEstado,Estado,R.Inactivo AS Inactiv,R.IdUsuario AS IdUsuari,Usuario
,FecAdd,FecUpdate,EV.NColor AS NumColor,OutDemand,TarjetaProp,FecTarjProp,VigTarjProp,Hidrostatica,FecPruebaHid,VigPruebaHid
 FROM VehRemolq AS R INNER JOIN Marcas AS M ON R.IdMarca=M.IdMarca  INNER JOIN TiposCol AS CL ON R.IdColor=CL.IdColor
 INNER JOIN TiposCar AS TC ON R.IdCrceria=TC.IdCrceria  INNER JOIN Terceros AS NP ON  R.IdPropietario=NP.IdTercero
 INNER JOIN EstadoVeh AS EV ON R.IdEstado=EV.IdEstado  INNER JOIN adm_Usuarios AS U ON R.IdUsuario=U.IdUsuario
 LEFT JOIN Terceros AS NPV ON R.NitProv=NPV.IdTercero
 LEFT JOIN CentrosServ AS CS ON R.CdCenSer =CS.IdCenSer 
 LEFT JOIN Localidades AS LU ON R.CdLocal=LU.IdLocal LEFT JOIN Departamentos AS DU ON LU.IdDep=DU.IdDep
 WHERE R.IdMarca LIKE ISNULL(@pmIdMarca,'%')  AND R.IdCrceria LIKE ISNULL(@pmIdCrceria,'%')
 AND Modelo LIKE ISNULL(@pmModelo,'%')  AND IdPropietario LIKE ISNULL(@pmIdPropietario,'%')
 AND R.IdEstado LIKE ISNULL(@pmIdEstado,'%')
 AND (R.Inactivo=ISNULL(@pmInactivo,0) or R.Inactivo=ISNULL(@pmInactivo,1))
 AND (FecCompra>=ISNULL(@pmFecComIni,CAST('19100101' AS SMALLDATETIME)) AND FecCompra<=ISNULL(@pmFecComFin,CAST('20781230' AS SMALLDATETIME)))
ORDER BY  IdRemque
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryMttoOrdenDet] @pmTipOdt VARCHAR(3),@pmNumOrden INT,@pmIdCia CHAR(2),@pmItem INT
 AS 
 SELECT TipOdt,NumOrden,IdCia,Item,FechaServ,IdConc,Descripcion,Cantidad,VrUnitario,UndMed,CdMtto
,IdEstado,IdOperario,NumVehic,NumParte,Req_Rep,Req_MO,TipoServ,FechaCrea,IdUsuario
 FROM Trn_MttoOrdenDet
 WHERE TipOdt=@pmTipOdt AND NumOrden=@pmNumOrden AND IdCia=@pmIdCia AND Item=@pmItem
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paInstm_MttoDetalle_Sel] @pmtmNumero VARCHAR(5),@pmTipOdt VARCHAR(3),@pmNumOrden INT,@pmIdCia CHAR(2)
 AS 
 INSERT INTO tm_MttoDetalle (tmNumero,tmItem,tmFecha,tmIdConc,tmDescripcion,tmCantidad,tmVrUnitario,tmUndMed,tmCdMtto,tmIdEstado,tmIdOperario,tmNumVehic,tmNumParte,tmReqRep,tmReqMO,tmTipoServ)
 SELECT @pmtmNumero,Item,FechaServ,IdConc,Descripcion,Cantidad,VrUnitario,UndMed,CdMtto,IdEstado,IdOperario,NumVehic,NumParte,Req_Rep,Req_MO,TipoServ
 FROM Trn_MttoOrdenDet
 WHERE TipOdt=@pmTipOdt AND NumOrden=@pmNumOrden AND IdCia=@pmIdCia
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paUpMttoOrdenDet] @pmTipOdt VARCHAR(3),@pmNumOrden INT,@pmIdCia CHAR(2),@pmItem INT,@pmFechaServ SMALLDATETIME,@pmIdConc VARCHAR(4),@pmDescripcion VARCHAR(1000)
,@pmCantidad DECIMAL(14,4),@pmVrUnitario DECIMAL(16,6),@pmUndMed VARCHAR(50),@pmCdMtto VARCHAR(4),@pmIdEstado VARCHAR(4)
,@pmIdOperario VARCHAR(16),@pmNumVehic VARCHAR(10),@pmNumParte VARCHAR(20),@pmReq_Rep BIT,@pmReq_MO BIT,@pmTipoServ VARCHAR(10) 
 AS 
 UPDATE Trn_MttoOrdenDet SET FechaServ=@pmFechaServ,IdConc=@pmIdConc,Descripcion=@pmDescripcion,Cantidad=@pmCantidad,VrUnitario=@pmVrUnitario,UndMed=@pmUndMed
,CdMtto=@pmCdMtto,IdEstado=@pmIdEstado,IdOperario=@pmIdOperario,NumVehic=@pmNumVehic,NumParte=@pmNumParte,Req_Rep=@pmReq_Rep,Req_MO=@pmReq_MO,TipoServ=@pmTipoServ
 WHERE TipOdt=@pmTipOdt AND NumOrden=@pmNumOrden AND IdCia=@pmIdCia AND Item=@pmItem
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paInsMttoOrdenDet] @pmTipOdt VARCHAR(3),@pmNumOrden INT,@pmIdCia CHAR(2),@pmItem INT,@pmFechaServ SMALLDATETIME,@pmIdConc VARCHAR(4),@pmDescripcion VARCHAR(1000),@pmCantidad DECIMAL(14,4)
,@pmVrUnitario DECIMAL(16,6),@pmUndMed VARCHAR(50),@pmCdMtto VARCHAR(4),@pmIdEstado VARCHAR(4),@pmIdOperario VARCHAR(16),@pmNumVehic VARCHAR(10),@pmNumParte VARCHAR(20)
,@pmReq_Rep BIT,@pmReq_MO BIT,@pmTipoServ VARCHAR(10),@pmFechaCrea SMALLDATETIME,@pmIdUsuario VARCHAR(11)
 AS 
 INSERT INTO Trn_MttoOrdenDet (TipOdt,NumOrden,IdCia,Item,FechaServ,IdConc,Descripcion,Cantidad,VrUnitario,UndMed,CdMtto,IdEstado,IdOperario,NumVehic,NumParte,Req_Rep,Req_MO,FechaCrea,IdUsuario,TipoServ)
 VALUES (@pmTipOdt,@pmNumOrden,@pmIdCia,@pmItem,@pmFechaServ,@pmIdConc,@pmDescripcion,@pmCantidad,@pmVrUnitario,@pmUndMed,@pmCdMtto,@pmIdEstado,@pmIdOperario,@pmNumVehic,@pmNumParte
,@pmReq_Rep,@pmReq_MO,@pmFechaCrea,@pmIdUsuario,@pmTipoServ)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryVehPartesLta] @pmIdVehiculo VARCHAR(10)=Null,@pmIdSistema VARCHAR(4)=Null
 AS 
 SELECT TipoUnidad,P.IdVehiculo AS PlacaVeh,NumParte,DescripParte,P.IdSistema AS CdSistema,Sistema,TipoParte,TipoControl
,Intervalo_km,Intervalo_dias,Intervalo_Horas,P.kmActual,kmManual,kmSat,P.kmCambio,kmCambioMan,kmCambioSat,FechaCambio,HorasTrab,HsUltCambio,CdProdRep,DescripProd
,P.IdEstado AS CdEstado,E.Estado,E.NColor,P.Inactivo,FechaRetiro,P.FechaCrea,P.IdUsuario AS CdUsuario,Usuario
--datos del vehículo
,NumVeh,V.IdTipoVeh AS CdTipo,TipoVehiculo,V.IdMarca AS CdMarca,MV.Marca AS MarcaVeh,V.IdColor AS CdColor,CL.NomColor AS Color
,V.IdLinea AS CdLinea,V.Modelo,FecRep,SerieChasis,CdRemque,V.IdPropietario,NP.RazonSocial AS Propietario,FecIngreso,V.KmInicial,V.KmActual AS kmsActual
,V.Km2Actual,NumSoat,FecSoat,VigSoat,V.Descripcion,V.IdEstado AS VehCodEstado,EV.Estado AS VehEstado,EV.NColor AS VehEdoColor,V.Inactivo AS VehInactivo
 FROM VehPartes AS P INNER JOIN MttoSistemas AS S ON P.IdSistema=S.IdSistema
 INNER JOIN EstadoSer AS E ON P.IdEstado=E.IdEstado INNER JOIN adm_Usuarios AS U ON P.IdUsuario=U.IdUsuario
 LEFT JOIN ProdMcias AS M ON P.CdProdRep=M.IdProducto
 LEFT JOIN Vehiculos AS V ON P.IdVehiculo=V.IdVehiculo LEFT JOIN TiposVeh AS TV ON V.IdTipoVeh=TV.IdTipoVeh
 LEFT JOIN Marcas AS MV ON V.IdMarca=MV.IdMarca LEFT JOIN TiposCol AS CL ON V.IdColor=CL.IdColor
 LEFT JOIN Terceros AS NP ON V.IdPropietario=NP.IdTercero LEFT JOIN EstadoVeh AS EV ON V.IdEstado=EV.IdEstado
 WHERE P.IdVehiculo LIKE ISNULL(@pmIdVehiculo,'%') AND P.IdSistema LIKE ISNULL(@pmIdSistema,'%')
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryMttoControlesLta] @pmNumUnidad VARCHAR(10)=Null,@pmIdConc VARCHAR(4)=Null
 AS 
 SELECT M.TipoUnidad,M.NumUnidad AS IdVehiculo,M.IdConc AS CodConc,Concepto,C.IdSistema AS CdSistema,Sistema,C.IdMtto AS CdMtto,TipoMtto
,M.TipoControl,M.Intervalo_km,M.Intervalo_dias,M.Intervalo_Horas,M.kmUltMtto,M.kmUltMttoRuta,M.kmUltMttoSat,M.FecUltMtto,HsUltMtto
,C.TipoControl AS ConcControl,C.Intervalo_km AS ConcKm,C.Intervalo_dias AS ConcDias,C.Intervalo_Horas AS ConcHoras,C.Req_Parte,C.CantHoras,C.TarifaCosto
,M.Comentarios,M.Inactivo,M.FechaCrea,M.IdUsuario AS CdUsuario,Usuario
--campos de subconsulta vehiculos
,CdTipoVeh,TipoVehiculo,CdMarca,Marca,CdColor,NomColor,Modelo,Config,CdComb,TipoComb,SerieChasis,IdPropietario,NP.RazonSocial AS Propietario
,VigSoat,VigRCivil,VigRegNal,VigTecMec,KmInicial,VehKmActual,VehKmRuta,VehKmOtro,VH.Descripcion,VehInactivo
,VehEstado,Estado,EV.NColor AS EdoNumColor,EV.OutDemand AS EdoDisponible,HR.CantHoras AS AcumHoras
FROM MttoControles AS M INNER JOIN MttoConceptos AS C ON M.IdConc=C.IdConc INNER JOIN MttoSistemas AS S ON C.IdSistema=S.IdSistema
INNER JOIN MttoTipos AS TM ON C.IdMtto=TM.IdMtto INNER JOIN adm_Usuarios AS U ON M.IdUsuario=U.IdUsuario
--subconsulta vehiculos
LEFT JOIN (SELECT IdVehiculo AS VehPlaca,NumVeh,IdTipoVeh AS CdTipoVeh,IdMarca AS CdMarca,IdLinea AS CdLinea,IdColor AS CdColor,Modelo,Config,IdCom AS CdComb
,NumMotor,SerieChasis,CdRemque,NitEmpresa,IdPropietario,IdPoseedor,IdConductor,TipoAfil,FecCompra,FecIngreso,NumSoat,VigSoat,VigRCivil,VigRegNal,VigTecMec
,KmInicial,KmActual AS VehKmActual,Km2Actual AS VehKmRuta,CentFinal AS VehKmOtro,Descripcion,Inactivo AS VehInactivo,IdEstado AS VehEstado
FROM Vehiculos UNION ALL SELECT IdRemque,'0','0',IdMarca,'0',IdColor,Modelo,ConfEjes,'0','',NumSerial,'',NitProv,IdPropietario,IdPropietario,'0','',FecCompra
,FecAdd,'',Null,Null,Null,VigPruebaHid,0,Kilmetraje,kmRuta,kmOtro,Descripcion,Inactivo,IdEstado FROM VehRemolq) AS VH ON M.NumUnidad=VH.VehPlaca
LEFT JOIN TiposVeh AS TV ON VH.CdTipoVeh=TV.IdTipoVeh LEFT JOIN Marcas AS MV ON VH.CdMarca=MV.IdMarca
LEFT JOIN TiposCol AS CL ON VH.CdColor=CL.IdColor LEFT JOIN TiposFuel AS TC ON VH.CdComb=TC.IdCom
LEFT JOIN Terceros AS NP ON VH.IdPropietario=NP.IdTercero LEFT JOIN EstadoVeh AS EV ON VH.VehEstado=EV.IdEstado
LEFT JOIN VehHoras AS HR ON M.TipoUnidad=HR.TipoUnidad AND M.NumUnidad=HR.NumUnidad
WHERE M.NumUnidad LIKE ISNULL(@pmNumUnidad,'%') AND M.IdConc LIKE ISNULL(@pmIdConc,'%')
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[paInsFinClieSaldosLin_Uni] @pmIdClie VARCHAR(16),@pmIdClieDos VARCHAR(16),@pmNewClie VARCHAR(16)
 AS 
 IF EXISTS (SELECT IdClie FROM FinClieSaldosLin WHERE IdClie=@pmIdClie OR IdClie=@pmIdClieDos)
  INSERT INTO FinClieSaldosLin (IdClie,CdAgencia,IdLinea,IdCia,VrSaldoCap,VrSaldoInt,VrSaldoOtro)
  SELECT @pmNewClie,CdAgencia,IdLinea,IdCia,SUM(VrSaldoCap),SUM(VrSaldoInt),SUM(VrSaldoOtro)
  FROM FinClieSaldosLin 
  WHERE  IdClie=@pmIdClie OR IdClie=@pmIdClieDos
  GROUP BY CdAgencia,IdLinea,IdCia
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paInsMttoTrabajos] @pmFecha SMALLDATETIME,@pmIdConc VARCHAR(4),@pmTipoMtto INT,@pmTipoUnidad CHAR(1),@pmIdVehiculo VARCHAR(10),@pmnRemolque VARCHAR(10),@pmTipDoc VARCHAR(3)
,@pmNumOrden INT,@pmIdCia CHAR(2),@pmNumParte VARCHAR(20),@pmCantHoras INT,@pmkmActual INT,@pmKmRuta INT,@pmkmOtro INT,@pmkmAntMtto INT,@pmKmAntMtto2 INT,@pmkmAntMtto3 INT,@pmFecAntMtto SMALLDATETIME
 AS 
 INSERT INTO Trn_MttoTrabajos (Fecha,IdConc,TipoMtto,TipoUnidad,IdVehiculo,nRemolque,TipDoc,NumOrden,IdCia,NumParte,CantHoras,kmActual,KmRuta,kmOtro,kmAntMtto,KmAntMtto2,kmAntMtto3,FecAntMtto)
 VALUES (@pmFecha,@pmIdConc,@pmTipoMtto,@pmTipoUnidad,@pmIdVehiculo,@pmnRemolque,@pmTipDoc,@pmNumOrden,@pmIdCia,@pmNumParte,@pmCantHoras,@pmkmActual,@pmKmRuta,@pmkmOtro,@pmkmAntMtto,@pmKmAntMtto2,@pmkmAntMtto3,@pmFecAntMtto)
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[paInsAcuAnticipos_Nit] @pmIdPoseedor VARCHAR(16),@pmIdPoseedorDos VARCHAR(16),@pmNewIdPoseedor VARCHAR(16)
 AS 
 IF EXISTS (SELECT * FROM AcuAnticipos WHERE IdPoseedor=@pmIdPoseedor OR IdPoseedor=@pmIdPoseedorDos)
  INSERT INTO AcuAnticipos (nAnno,nMes,IdCia,IdPoseedor,IdVehiculo,SaldoAnt,VrAnticipos,VrPagos)
  SELECT nAnno,nMes,IdCia,@pmNewIdPoseedor,IdVehiculo,SUM(SaldoAnt),SUM(VrAnticipos),SUM(VrPagos)
  FROM AcuAnticipos WHERE IdPoseedor=@pmIdPoseedor OR IdPoseedor=@pmIdPoseedorDos
  GROUP BY nAnno,nMes,IdCia,IdVehiculo
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[paInsAcuFisCuentasAge_Uni] @pmIdTercero VARCHAR(16),@pmIdTerceroDos VARCHAR(16),@pmNewTercero VARCHAR(16)
 AS 
 IF EXISTS (SELECT IdTercero FROM AcuFisCuentasAge WHERE IdTercero=@pmIdTercero OR IdTercero=@pmIdTerceroDos)
  INSERT INTO AcuFisCuentasAge (nAnno,nMes,IdCia,IdCuenta,IdTercero,CodAgncia,TipoAcum,SaldoAnterior,TotalDebitos,TotalCreditos)
 SELECT nAnno,nMes,IdCia,IdCuenta,@pmNewTercero,CodAgncia,TipoAcum,SUM(SaldoAnterior),SUM(TotalDebitos),SUM(TotalCreditos)
 FROM AcuFisCuentasAge WHERE IdTercero=@pmIdTercero OR IdTercero=@pmIdTerceroDos
 GROUP BY nAnno,nMes,IdCia,IdCuenta,CodAgncia,TipoAcum
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paInsVehPartes] @pmIdVehiculo VARCHAR(10),@pmNumParte VARCHAR(20),@pmDescripParte VARCHAR(250),@pmIdSistema VARCHAR(4),@pmTipoControl INT,@pmIntervalo_km INT,@pmIntervalo_dias INT,@pmkmActual INT,@pmkmCambio INT
,@pmFechaCambio SMALLDATETIME,@pmCdProdRep VARCHAR(16),@pmTipoUnidad CHAR(1),@pmTipoParte VARCHAR(10),@pmIdEstado VARCHAR(4),@pmInactivo BIT,@pmFechaRetiro SMALLDATETIME,@pmIntervalo_Horas INT
,@pmkmManual INT,@pmkmSat INT,@pmkmCambioMan INT,@pmkmCambioSat INT,@pmHorasTrab INT,@pmHsUltCambio INT,@pmFechaCrea SMALLDATETIME,@pmIdUsuario VARCHAR(11)
 AS 
 INSERT INTO VehPartes (IdVehiculo,NumParte,DescripParte,IdSistema,TipoControl,Intervalo_km,Intervalo_dias,Intervalo_Horas,kmActual,kmManual,kmSat,kmCambio,kmCambioMan,kmCambioSat,FechaCambio,CdProdRep,TipoUnidad,TipoParte
,IdEstado,Inactivo,FechaRetiro,FechaCrea,IdUsuario,HorasTrab,HsUltCambio)
 VALUES (@pmIdVehiculo,@pmNumParte,@pmDescripParte,@pmIdSistema,@pmTipoControl,@pmIntervalo_km,@pmIntervalo_dias,@pmIntervalo_Horas,@pmkmActual,@pmkmManual,@pmkmSat,@pmkmCambio,@pmkmCambioMan,@pmkmCambioSat,@pmFechaCambio
,@pmCdProdRep,@pmTipoUnidad,@pmTipoParte,@pmIdEstado,@pmInactivo,@pmFechaRetiro,@pmFechaCrea,@pmIdUsuario,@pmHorasTrab,@pmHsUltCambio)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryVehPartes] @pmIdVehiculo VARCHAR(10),@pmNumParte VARCHAR(20)
 AS 
 SELECT IdVehiculo,NumParte,DescripParte,IdSistema,TipoControl,Intervalo_km,Intervalo_dias,Intervalo_Horas,kmActual
,kmManual,kmSat,kmCambio,kmCambioMan,kmCambioSat,FechaCambio,CdProdRep
,TipoUnidad,TipoParte,IdEstado,Inactivo,FechaRetiro,HorasTrab,HsUltCambio,FechaCrea,IdUsuario
 FROM VehPartes
 WHERE IdVehiculo=@pmIdVehiculo AND NumParte=@pmNumParte
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paUpVehPartes] @pmIdVehiculo VARCHAR(10),@pmNumParte VARCHAR(20),@pmDescripParte VARCHAR(250),@pmIdSistema VARCHAR(4),@pmTipoControl INT,@pmIntervalo_km INT,@pmIntervalo_dias INT,@pmkmActual INT,@pmkmCambio INT
,@pmFechaCambio SMALLDATETIME,@pmCdProdRep VARCHAR(16),@pmTipoUnidad CHAR(1),@pmTipoParte VARCHAR(10),@pmIdEstado VARCHAR(4),@pmInactivo BIT,@pmFechaRetiro SMALLDATETIME,@pmIntervalo_Horas INT
,@pmkmManual INT,@pmkmSat INT,@pmkmCambioMan INT,@pmkmCambioSat INT,@pmHorasTrab INT,@pmHsUltCambio INT
 AS 
 UPDATE VehPartes SET DescripParte=@pmDescripParte,IdSistema=@pmIdSistema,TipoControl=@pmTipoControl,Intervalo_km=@pmIntervalo_km,Intervalo_dias=@pmIntervalo_dias,kmActual=@pmkmActual,kmCambio=@pmkmCambio,FechaCambio=@pmFechaCambio,CdProdRep=@pmCdProdRep
,TipoUnidad=@pmTipoUnidad,TipoParte=@pmTipoParte,IdEstado=@pmIdEstado,Inactivo=@pmInactivo,FechaRetiro=@pmFechaRetiro,Intervalo_Horas=@pmIntervalo_Horas
,kmManual=@pmkmManual,kmSat=@pmkmSat,kmCambioMan=@pmkmCambioMan,kmCambioSat=@pmkmCambioSat,HorasTrab=@pmHorasTrab,HsUltCambio=@pmHsUltCambio
 WHERE IdVehiculo=@pmIdVehiculo AND NumParte=@pmNumParte
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[paInsAcuNiifCuentasAge_Uni] @pmIdTercero VARCHAR(16),@pmIdTerceroDos VARCHAR(16),@pmNewTercero VARCHAR(16)
 AS 
 IF EXISTS (SELECT IdTercero FROM AcuNiifCuentasAge WHERE IdTercero=@pmIdTercero OR IdTercero=@pmIdTerceroDos)
  INSERT INTO AcuNiifCuentasAge (nAnno,nMes,IdCia,IdCuenta,IdTercero,CodAgncia,TipoAcum,SaldoAnterior,TotalDebitos,TotalCreditos)
 SELECT nAnno,nMes,IdCia,IdCuenta,@pmNewTercero,CodAgncia,TipoAcum,SUM(SaldoAnterior),SUM(TotalDebitos),SUM(TotalCreditos)
 FROM AcuNiifCuentasAge WHERE IdTercero=@pmIdTercero OR IdTercero=@pmIdTerceroDos
 GROUP BY nAnno,nMes,IdCia,IdCuenta,CodAgncia,TipoAcum
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paInsVehRemolq] @pmIdRemque VARCHAR(10),@pmIdMarca VARCHAR(4),@pmIdColor VARCHAR(4),@pmIdCrceria VARCHAR(4),@pmModelo VARCHAR(4),@pmNEjes INT,@pmnLlantas INT,@pmAltura DECIMAL(14,4)
,@pmAncho DECIMAL(14,4),@pmLargo DECIMAL(14,4),@pmVlumen DECIMAL(14,4),@pmPesoKg DECIMAL(14,4),@pmCapneta DECIMAL(14,4),@pmUndCapc VARCHAR(10),@pmNumComp INT,@pmCapcComp VARCHAR(50),@pmNumSerial VARCHAR(30)
,@pmIdPropietario VARCHAR(16),@pmNitProv VARCHAR(16),@pmFecCompra SMALLDATETIME,@pmVidaUtil INT,@pmVrComercial MONEY,@pmVrAvaludo MONEY,@pmVrAsegurado MONEY,@pmKilmetraje INT,@pmEquipoAdic VARCHAR(50)
,@pmDescripcion VARCHAR(100),@pmCdCenSer VARCHAR(4),@pmCdLocal VARCHAR(8),@pmUbicacion VARCHAR(100),@pmObservacion VARCHAR(250),@pmIdEstado VARCHAR(4),@pmInactivo BIT,@pmTarjetaProp VARCHAR(30),@pmFecTarjProp  SMALLDATETIME
,@pmVigTarjProp SMALLDATETIME,@pmConfEjes VARCHAR(5),@pmHidrostatica VARCHAR(30),@pmFecPruebaHid SMALLDATETIME,@pmVigPruebaHid SMALLDATETIME,@pmkmRuta INT,@pmkmOtro INT,@pmFecAdd SMALLDATETIME,@pmIdUsuario VARCHAR(11)
 AS 
 INSERT INTO VehRemolq (IdRemque,IdMarca,IdColor,IdCrceria,Modelo,NEjes,nLlantas,ConfEjes,Altura,Ancho,Largo,Vlumen,PesoKg,Capneta,UndCapc,NumComp,CapcComp,NumSerial,IdPropietario,NitProv,FecCompra,VidaUtil,VrComercial,VrAvaludo,VrAsegurado,Kilmetraje
,EquipoAdic,Descripcion,CdCenSer,CdLocal,Ubicacion,Observacion,IdEstado,Inactivo,FecAdd,IdUsuario,TarjetaProp,FecTarjProp,VigTarjProp,Hidrostatica,FecPruebaHid,VigPruebaHid,kmRuta,kmOtro)
 VALUES (@pmIdRemque,@pmIdMarca,@pmIdColor,@pmIdCrceria,@pmModelo,@pmNEjes,@pmnLlantas,@pmConfEjes,@pmAltura,@pmAncho,@pmLargo,@pmVlumen,@pmPesoKg,@pmCapneta,@pmUndCapc,@pmNumComp,@pmCapcComp,@pmNumSerial,@pmIdPropietario
,@pmNitProv,@pmFecCompra,@pmVidaUtil,@pmVrComercial,@pmVrAvaludo,@pmVrAsegurado,@pmKilmetraje,@pmEquipoAdic,@pmDescripcion,@pmCdCenSer,@pmCdLocal,@pmUbicacion,@pmObservacion,@pmIdEstado,@pmInactivo,@pmFecAdd,@pmIdUsuario
,@pmTarjetaProp,@pmFecTarjProp,@pmVigTarjProp,@pmHidrostatica,@pmFecPruebaHid,@pmVigPruebaHid,@pmkmRuta,@pmkmOtro)
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paUpVehRemolq] @pmIdRemque VARCHAR(10),@pmIdMarca VARCHAR(4),@pmIdColor VARCHAR(4),@pmIdCrceria VARCHAR(4),@pmModelo VARCHAR(4),@pmNEjes INT,@pmnLlantas INT,@pmAltura DECIMAL(14,4),@pmAncho DECIMAL(14,4),@pmLargo DECIMAL(14,4)
,@pmVlumen DECIMAL(14,4),@pmPesoKg DECIMAL(14,4),@pmCapneta DECIMAL(14,4),@pmUndCapc VARCHAR(10),@pmNumComp INT,@pmCapcComp VARCHAR(50),@pmNumSerial VARCHAR(30),@pmIdPropietario VARCHAR(16),@pmNitProv VARCHAR(16),@pmFecCompra SMALLDATETIME
,@pmVidaUtil INT,@pmVrComercial MONEY,@pmVrAvaludo MONEY,@pmVrAsegurado MONEY,@pmKilmetraje INT,@pmEquipoAdic VARCHAR(50),@pmDescripcion VARCHAR(100),@pmCdCenSer VARCHAR(4),@pmCdLocal VARCHAR(8),@pmUbicacion VARCHAR(100),@pmObservacion VARCHAR(250)
,@pmIdEstado VARCHAR(4),@pmInactivo BIT,@pmTarjetaProp VARCHAR(30),@pmFecTarjProp  SMALLDATETIME,@pmVigTarjProp SMALLDATETIME,@pmConfEjes VARCHAR(5),@pmHidrostatica VARCHAR(30),@pmFecPruebaHid SMALLDATETIME,@pmVigPruebaHid SMALLDATETIME,@pmkmRuta INT,@pmkmOtro INT,@pmFecUpdate SMALLDATETIME
 AS 
 UPDATE VehRemolq SET IdMarca=@pmIdMarca,IdColor=@pmIdColor,IdCrceria=@pmIdCrceria,Modelo=@pmModelo,NEjes=@pmNEjes,nLlantas=@pmnLlantas,ConfEjes=@pmConfEjes,Altura=@pmAltura,Ancho=@pmAncho,Largo=@pmLargo,Vlumen=@pmVlumen,PesoKg=@pmPesoKg,Capneta=@pmCapneta,UndCapc=@pmUndCapc
,NumComp=@pmNumComp,CapcComp=@pmCapcComp,NumSerial=@pmNumSerial,IdPropietario=@pmIdPropietario,NitProv=@pmNitProv,FecCompra=@pmFecCompra,VidaUtil=@pmVidaUtil,VrComercial=@pmVrComercial,VrAvaludo=@pmVrAvaludo,VrAsegurado=@pmVrAsegurado,Kilmetraje=@pmKilmetraje
,EquipoAdic=@pmEquipoAdic,Descripcion=@pmDescripcion,CdCenSer=@pmCdCenSer,CdLocal=@pmCdLocal,Ubicacion=@pmUbicacion,Observacion=@pmObservacion,IdEstado=@pmIdEstado,Inactivo=@pmInactivo,FecUpdate=@pmFecUpdate,TarjetaProp=@pmTarjetaProp,FecTarjProp=@pmFecTarjProp,VigTarjProp=@pmVigTarjProp
,Hidrostatica=@pmHidrostatica,FecPruebaHid=@pmFecPruebaHid,VigPruebaHid=@pmVigPruebaHid,kmRuta=@pmkmRuta,kmOtro=@pmkmOtro
 WHERE IdRemque=@pmIdRemque
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryVehRemolq] @pmIdRemque VARCHAR(10)
 AS 
 SELECT IdRemque,IdMarca,IdColor,IdCrceria,Modelo,NEjes,nLlantas,Altura,Ancho,Largo,Vlumen,PesoKg,Capneta,UndCapc,NumComp,CapcComp
,NumSerial,IdPropietario,NitProv,FecCompra,VidaUtil,VrComercial,VrAvaludo,VrAsegurado,Kilmetraje,EquipoAdic,Descripcion,CdCenSer,CdLocal,Ubicacion
,Observacion,IdEstado,Inactivo,FecAdd,FecUpdate,IdUsuario,TarjetaProp,FecTarjProp,VigTarjProp,ConfEjes,Hidrostatica,FecPruebaHid,VigPruebaHid,kmRuta,kmOtro
 FROM VehRemolq
 WHERE IdRemque=@pmIdRemque
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryMttoControles] @pmTipoUnidad CHAR(1),@pmNumUnidad VARCHAR(10),@pmIdConc VARCHAR(4)
 AS 
 SELECT TipoUnidad,NumUnidad,IdConc,TipoControl,Intervalo_km,Intervalo_dias,Intervalo_Horas,kmUltMtto,kmUltMttoRuta,kmUltMttoSat
,FecUltMtto,HsUltMtto,Comentarios,Inactivo,FechaCrea,IdUsuario
 FROM MttoControles
 WHERE TipoUnidad=@pmTipoUnidad AND NumUnidad=@pmNumUnidad AND IdConc=@pmIdConc
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paInsMttoControles] @pmTipoUnidad CHAR(1),@pmNumUnidad VARCHAR(10),@pmIdConc VARCHAR(4),@pmTipoControl INT,@pmIntervalo_km INT,@pmIntervalo_dias INT,@pmIntervalo_Horas INT,@pmkmUltMtto INT,@pmkmUltMttoRuta INT
,@pmkmUltMttoSat INT,@pmFecUltMtto SMALLDATETIME,@pmComentarios VARCHAR(1000),@pmInactivo BIT,@pmHsUltMtto INT,@pmFechaCrea SMALLDATETIME,@pmIdUsuario VARCHAR(11)
 AS 
 INSERT INTO MttoControles (TipoUnidad,NumUnidad,IdConc,TipoControl,Intervalo_km,Intervalo_dias,Intervalo_Horas,kmUltMtto,kmUltMttoRuta,kmUltMttoSat,FecUltMtto,HsUltMtto,Comentarios,Inactivo,FechaCrea,IdUsuario)
 VALUES (@pmTipoUnidad,@pmNumUnidad,@pmIdConc,@pmTipoControl,@pmIntervalo_km,@pmIntervalo_dias,@pmIntervalo_Horas,@pmkmUltMtto,@pmkmUltMttoRuta,@pmkmUltMttoSat,@pmFecUltMtto,@pmHsUltMtto,@pmComentarios,@pmInactivo,@pmFechaCrea,@pmIdUsuario)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paUpMttoControles] @pmTipoUnidad CHAR(1),@pmNumUnidad VARCHAR(10),@pmIdConc VARCHAR(4),@pmTipoControl INT,@pmIntervalo_km INT,@pmIntervalo_dias INT,@pmIntervalo_Horas INT,@pmkmUltMtto INT,@pmkmUltMttoRuta INT
,@pmkmUltMttoSat INT,@pmFecUltMtto SMALLDATETIME,@pmComentarios VARCHAR(1000),@pmInactivo BIT,@pmHsUltMtto INT
 AS 
 UPDATE MttoControles SET TipoControl=@pmTipoControl,Intervalo_km=@pmIntervalo_km,Intervalo_dias=@pmIntervalo_dias,Intervalo_Horas=@pmIntervalo_Horas,kmUltMtto=@pmkmUltMtto,kmUltMttoRuta=@pmkmUltMttoRuta,kmUltMttoSat=@pmkmUltMttoSat,FecUltMtto=@pmFecUltMtto
,HsUltMtto=@pmHsUltMtto,Comentarios=@pmComentarios,Inactivo=@pmInactivo
 WHERE TipoUnidad=@pmTipoUnidad AND NumUnidad=@pmNumUnidad AND IdConc=@pmIdConc
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paInsMttoConceptos] @pmIdConc VARCHAR(4),@pmConcepto VARCHAR(150),@pmIdSistema VARCHAR(4),@pmIdMtto VARCHAR(4),@pmTipoControl INT
,@pmIntervalo_km INT,@pmIntervalo_dias INT,@pmReq_Parte BIT,@pmInactivo BIT,@pmCodigoMO VARCHAR(16),@pmIntervalo_Horas INT
,@pmCantHoras DECIMAL(14,2),@pmTarifaCosto DECIMAL(16,4),@pmFechaCrea SMALLDATETIME,@pmIdUsuario VARCHAR(11)
 AS 
 INSERT INTO MttoConceptos (IdConc,Concepto,IdSistema,IdMtto,TipoControl,Intervalo_km,Intervalo_dias,Intervalo_Horas,Req_Parte,CodigoMO,CantHoras,TarifaCosto,Inactivo,FechaCrea,IdUsuario)
 VALUES (@pmIdConc,@pmConcepto,@pmIdSistema,@pmIdMtto,@pmTipoControl,@pmIntervalo_km,@pmIntervalo_dias,@pmIntervalo_Horas,@pmReq_Parte,@pmCodigoMO,@pmCantHoras,@pmTarifaCosto,@pmInactivo,@pmFechaCrea,@pmIdUsuario)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryMttoConceptos] @pmIdConc VARCHAR(4)
 AS 
 SELECT IdConc,Concepto,IdSistema,IdMtto,TipoControl,Intervalo_km,Intervalo_dias,Req_Parte,Intervalo_Horas,CodigoMO
,CantHoras,TarifaCosto,Inactivo,FechaCrea,IdUsuario
 FROM MttoConceptos
 WHERE IdConc=@pmIdConc
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paUpMttoConceptos] @pmIdConc VARCHAR(4),@pmConcepto VARCHAR(150),@pmIdSistema VARCHAR(4),@pmIdMtto VARCHAR(4),@pmTipoControl INT
,@pmIntervalo_km INT,@pmIntervalo_dias INT,@pmReq_Parte BIT,@pmInactivo BIT,@pmCodigoMO VARCHAR(16),@pmIntervalo_Horas INT,@pmCantHoras DECIMAL(14,2),@pmTarifaCosto DECIMAL(16,4)
 AS 
 UPDATE MttoConceptos SET Concepto=@pmConcepto,IdSistema=@pmIdSistema,IdMtto=@pmIdMtto,TipoControl=@pmTipoControl,Intervalo_km=@pmIntervalo_km
,Intervalo_dias=@pmIntervalo_dias,Req_Parte=@pmReq_Parte,Inactivo=@pmInactivo,CodigoMO=@pmCodigoMO,Intervalo_Horas=@pmIntervalo_Horas 
,CantHoras=@pmCantHoras,TarifaCosto=@pmTarifaCosto
 WHERE IdConc=@pmIdConc
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryMttoConceptosLta] @pmIdSistema VARCHAR(4)=Null,@pmIdMtto VARCHAR(4)=Null
 AS 
 SELECT IdConc,Concepto,C.IdSistema AS CdSistema,Sistema,C.IdMtto AS CdMtto,TipoMtto,TipoControl
,Intervalo_km,Intervalo_dias,Intervalo_Horas,Req_Parte,CodigoMO,DescripProd,CantHoras,TarifaCosto
,C.Inactivo,C.FechaCrea,C.IdUsuario AS CdUsuario,Usuario
 FROM MttoConceptos AS C INNER JOIN MttoSistemas AS S ON C.IdSistema=S.IdSistema
 INNER JOIN MttoTipos AS TM ON C.IdMtto=TM.IdMtto
 INNER JOIN adm_Usuarios AS U ON C.IdUsuario=U.IdUsuario
 LEFT JOIN ProdMcias AS P ON C.CodigoMO=P.IdProducto
 WHERE C.IdSistema LIKE ISNULL(@pmIdSistema,'%') AND C.IdMtto LIKE ISNULL(@pmIdMtto,'%')
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[paInsFinClieSaldos_Uni] @pmIdClie VARCHAR(16),@pmIdClieDos VARCHAR(16),@pmNewClie VARCHAR(16)
 AS 
 IF EXISTS (SELECT IdClie FROM FinClieSaldos WHERE IdClie=@pmIdClie OR IdClie=@pmIdClieDos)
  INSERT INTO FinClieSaldos (IdClie,CdAgencia,IdCia,VrSaldo)
  SELECT @pmNewClie,CdAgencia,IdCia,SUM(VrSaldo)
  FROM FinClieSaldos  
  WHERE  IdClie=@pmIdClie OR IdClie=@pmIdClieDos
  GROUP BY CdAgencia,IdCia
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[paInsAcuFisCuentasNit_Uni] @pmIdTercero VARCHAR(16),@pmIdTerceroDos VARCHAR(16),@pmNewTercero VARCHAR(16)
 AS 
 IF EXISTS (SELECT IdTercero FROM AcuFisCuentasNit WHERE IdTercero=@pmIdTercero OR IdTercero=@pmIdTerceroDos)
  INSERT INTO AcuFisCuentasNit (nAnno,nMes,IdCia,IdCuenta,IdTercero,SaldoAnterior,TotalDebitos,TotalCreditos)
  SELECT nAnno,nMes,IdCia,IdCuenta,@pmNewTercero,SUM(SaldoAnterior),SUM(TotalDebitos),SUM(TotalCreditos)
  FROM AcuFisCuentasNit WHERE IdTercero=@pmIdTercero OR IdTercero=@pmIdTerceroDos
  GROUP BY nAnno,nMes,IdCia,IdCuenta
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paInstm_MttoDetalle] @pmtmNumero VARCHAR(5),@pmtmItem INT,@pmtmFecha SMALLDATETIME,@pmtmIdConc VARCHAR(4),@pmtmDescripcion VARCHAR(1000),@pmtmCantidad DECIMAL(14,4),@pmtmVrUnitario DECIMAL(16,6)
,@pmtmUndMed VARCHAR(50),@pmtmCdMtto VARCHAR(4),@pmtmIdEstado VARCHAR(4),@pmtmIdOperario VARCHAR(16),@pmtmNumVehic VARCHAR(10),@pmtmNumParte VARCHAR(20),@pmtmReqRep BIT,@pmtmReqMO BIT,@pmtmTipoServ VARCHAR(10)
 AS 
 INSERT INTO tm_MttoDetalle (tmNumero,tmItem,tmFecha,tmIdConc,tmDescripcion,tmCantidad,tmVrUnitario,tmUndMed,tmCdMtto,tmIdEstado,tmIdOperario,tmNumVehic,tmNumParte,tmReqRep,tmReqMO,tmTipoServ)
 VALUES (@pmtmNumero,@pmtmItem,@pmtmFecha,@pmtmIdConc,@pmtmDescripcion,@pmtmCantidad,@pmtmVrUnitario,@pmtmUndMed,@pmtmCdMtto,@pmtmIdEstado,@pmtmIdOperario,@pmtmNumVehic,@pmtmNumParte,@pmtmReqRep,@pmtmReqMO,@pmtmTipoServ)
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[paInsAcuFisCuentasVeh_Uni] @pmIdVehiculo VARCHAR(10),@pmIdVehiculoDos VARCHAR(10),@pmNewVehiculo VARCHAR(10)
 AS 
 IF EXISTS (SELECT * FROM AcuFisCuentasVeh WHERE IdVehiculo=@pmIdVehiculo OR IdVehiculo=@pmIdVehiculoDos)
   INSERT INTO AcuFisCuentasVeh (nAnno,nMes,IdCia,IdCuenta,IdVehiculo,SaldoAnterior,TotalDebitos,TotalCreditos)
   SELECT nAnno,nMes,IdCia,IdCuenta,@pmNewVehiculo,SUM(SaldoAnterior),SUM(TotalDebitos),SUM(TotalCreditos)
   FROM AcuFisCuentasVeh WHERE IdVehiculo=@pmIdVehiculo OR IdVehiculo=@pmIdVehiculoDos
   GROUP BY nAnno,nMes,IdCia,IdCuenta
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[paInsAcuNiifCuentasNit_Uni] @pmIdTercero VARCHAR(16),@pmIdTerceroDos VARCHAR(16),@pmNewTercero VARCHAR(16)
 AS 
 IF EXISTS (SELECT IdTercero FROM AcuNiifCuentasNit WHERE IdTercero=@pmIdTercero OR IdTercero=@pmIdTerceroDos)
  INSERT INTO AcuNiifCuentasNit (nAnno,nMes,IdCia,IdCuenta,IdTercero,SaldoAnterior,TotalDebitos,TotalCreditos)
  SELECT nAnno,nMes,IdCia,IdCuenta,@pmNewTercero,SUM(SaldoAnterior),SUM(TotalDebitos),SUM(TotalCreditos)
  FROM AcuNiifCuentasNit WHERE IdTercero=@pmIdTercero OR IdTercero=@pmIdTerceroDos
  GROUP BY nAnno,nMes,IdCia,IdCuenta
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[paInsAcuNiifCuentasVeh_Uni] @pmIdVehiculo VARCHAR(10),@pmIdVehiculoDos VARCHAR(10),@pmNewVehiculo VARCHAR(10)
 AS 
 IF EXISTS (SELECT * FROM AcuNiifCuentasVeh WHERE IdVehiculo=@pmIdVehiculo OR IdVehiculo=@pmIdVehiculoDos)
   INSERT INTO AcuNiifCuentasVeh (nAnno,nMes,IdCia,IdCuenta,IdVehiculo,SaldoAnterior,TotalDebitos,TotalCreditos)
   SELECT nAnno,nMes,IdCia,IdCuenta,@pmNewVehiculo,SUM(SaldoAnterior),SUM(TotalDebitos),SUM(TotalCreditos)
   FROM AcuNiifCuentasVeh WHERE IdVehiculo=@pmIdVehiculo OR IdVehiculo=@pmIdVehiculoDos
   GROUP BY nAnno,nMes,IdCia,IdCuenta
GO