if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paDelOilMediciones]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paDelOilMediciones]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsOilEntrada]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsOilEntrada]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsOilEntradaProd]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsOilEntradaProd]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsOilMediciones]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsOilMediciones]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsOilMedicionesTq]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsOilMedicionesTq]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsProdPrecCrudo]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsProdPrecCrudo]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsTurnos]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsTurnos]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryOilEntrada]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryOilEntrada]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryOilEntradaFmt]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryOilEntradaFmt]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryOilMediciones]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryOilMediciones]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryTurnos]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryTurnos]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paUpOilEntrada]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paUpOilEntrada]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paUpOilMediciones]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paUpOilMediciones]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paUpProdMciasSal]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paUpProdMciasSal]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paUpProdPrecCrudo]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paUpProdPrecCrudo]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paUpTanquesSal]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paUpTanquesSal]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paUpTurnos]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paUpTurnos]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paUpProdPrecCrudo] @pmTipoTarif VARCHAR(3),@pmNumero INT,@pmIdCia CHAR(2),@pmIdProducto VARCHAR(16),@pmIdTercero VARCHAR(16),@pmDuracion VARCHAR(10),@pmFecInicio SMALLDATETIME,@pmFecFinal SMALLDATETIME
,@pmTarifa DECIMAL(16,6),@pmIdMoneda VARCHAR(5),@pmUndMed VARCHAR(10),@pmInactivo BIT
 AS 
 UPDATE ProdPrecCrudo SET IdCia=@pmIdCia,IdProducto=@pmIdProducto,IdTercero=@pmIdTercero,Duracion=@pmDuracion,FecInicio=@pmFecInicio,FecFinal=@pmFecFinal,Tarifa=@pmTarifa,IdMoneda=@pmIdMoneda,UndMed=@pmUndMed,Inactivo=@pmInactivo
 WHERE TipoTarif=@pmTipoTarif AND Numero=@pmNumero
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paInsProdPrecCrudo] @pmTipoTarif VARCHAR(3),@pmNumero INT,@pmIdCia CHAR(2),@pmIdProducto VARCHAR(16),@pmIdTercero VARCHAR(16),@pmDuracion VARCHAR(10),@pmFecInicio SMALLDATETIME,@pmFecFinal SMALLDATETIME,@pmTarifa DECIMAL(16,6)
,@pmIdMoneda VARCHAR(5),@pmUndMed VARCHAR(10),@pmInactivo BIT
 AS 
 INSERT INTO ProdPrecCrudo (TipoTarif,Numero,IdCia,IdProducto,IdTercero,Duracion,FecInicio,FecFinal,Tarifa,IdMoneda,UndMed,Inactivo)
 VALUES (@pmTipoTarif,@pmNumero,@pmIdCia,@pmIdProducto,@pmIdTercero,@pmDuracion,@pmFecInicio,@pmFecFinal,@pmTarifa,@pmIdMoneda,@pmUndMed,@pmInactivo)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paInsOilEntrada] @pmTipEnt VARCHAR(3),@pmNumEntrada INT,@pmIdCia CHAR(2),@pmFecha SMALLDATETIME,@pmNumGuia INT,@pmIdCiaGuia CHAR(2),@pmFecDespacho SMALLDATETIME,@pmFecDescargue SMALLDATETIME,@pmIdProveedor VARCHAR(16),@pmIdVehiculo VARCHAR(10),@pmIdConductor VARCHAR(16),@pmNitEmpTrans VARCHAR(16),@pmNomEmpTrans VARCHAR(150),@pmRemolque VARCHAR(10),@pmValorTotal DECIMAL(16,6),@pmCtaPagar BIT,@pmTipFactCxp VARCHAR(3),@pmNumFactura INT,@pmIdCiaCxp CHAR(2),@pmEstContable INT,@pmCdConcepto VARCHAR(4),@pmTipCom VARCHAR(3),@pmComprobante INT,@pmIdCiaCom CHAR(2),@pmAnulado BIT,@pmFecDev SMALLDATETIME
,@pmObservacion VARCHAR(2000),@pmIdEstado VARCHAR(4),@pmTipoAju VARCHAR(3),@pmNumAjuInv INT,@pmIdCiaAju CHAR(2),@pmCantAjuste DECIMAL(16,6),@pmFechaCrea SMALLDATETIME,@pmIdCiaCrea CHAR(2),@pmOrigenAdd VARCHAR(10),@pmIdUsuario VARCHAR(11)
 AS 
 INSERT INTO Trn_OilEntrada (TipEnt,NumEntrada,IdCia,Fecha,NumGuia,IdCiaGuia,FecDespacho,FecDescargue,IdProveedor,IdVehiculo,IdConductor,NitEmpTrans,NomEmpTrans,Remolque,ValorTotal,CtaPagar,TipFactCxp,NumFactura,IdCiaCxp,TipoAju,NumAjuInv,IdCiaAju,CantAjuste,EstContable,CdConcepto,TipCom,Comprobante,IdCiaCom,Anulado,FecDev,Observacion,IdEstado,FechaCrea,IdCiaCrea,OrigenAdd,IdUsuario)
 VALUES (@pmTipEnt,@pmNumEntrada,@pmIdCia,@pmFecha,@pmNumGuia,@pmIdCiaGuia,@pmFecDespacho,@pmFecDescargue,@pmIdProveedor,@pmIdVehiculo,@pmIdConductor,@pmNitEmpTrans,@pmNomEmpTrans,@pmRemolque,@pmValorTotal,@pmCtaPagar,@pmTipFactCxp,@pmNumFactura,@pmIdCiaCxp,@pmTipoAju,@pmNumAjuInv,@pmIdCiaAju,@pmCantAjuste,@pmEstContable,@pmCdConcepto,@pmTipCom,@pmComprobante,@pmIdCiaCom,@pmAnulado,@pmFecDev,@pmObservacion,@pmIdEstado,@pmFechaCrea,@pmIdCiaCrea,@pmOrigenAdd,@pmIdUsuario)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paUpOilEntrada] @pmTipEnt VARCHAR(3),@pmNumEntrada INT,@pmIdCia CHAR(2),@pmFecha SMALLDATETIME,@pmNumGuia INT,@pmIdCiaGuia CHAR(2),@pmFecDespacho SMALLDATETIME,@pmFecDescargue SMALLDATETIME,@pmIdProveedor VARCHAR(16),@pmIdVehiculo VARCHAR(10),@pmIdConductor VARCHAR(16),@pmNitEmpTrans VARCHAR(16),@pmNomEmpTrans VARCHAR(150),@pmRemolque VARCHAR(10),@pmValorTotal DECIMAL(16,6),@pmCtaPagar BIT,@pmTipFactCxp VARCHAR(3),@pmNumFactura INT,@pmIdCiaCxp CHAR(2),@pmEstContable INT,@pmCdConcepto VARCHAR(4),@pmTipCom VARCHAR(3),@pmComprobante INT,@pmIdCiaCom CHAR(2),@pmAnulado BIT,@pmFecDev SMALLDATETIME
,@pmObservacion VARCHAR(2000),@pmIdEstado VARCHAR(4),@pmTipoAju VARCHAR(3),@pmNumAjuInv INT,@pmIdCiaAju CHAR(2),@pmCantAjuste DECIMAL(16,6)
 AS 
 UPDATE Trn_OilEntrada SET Fecha=@pmFecha,NumGuia=@pmNumGuia,IdCiaGuia=@pmIdCiaGuia,FecDespacho=@pmFecDespacho,FecDescargue=@pmFecDescargue,IdProveedor=@pmIdProveedor,IdVehiculo=@pmIdVehiculo,IdConductor=@pmIdConductor,NitEmpTrans=@pmNitEmpTrans,NomEmpTrans=@pmNomEmpTrans,Remolque=@pmRemolque,ValorTotal=@pmValorTotal,CtaPagar=@pmCtaPagar,TipFactCxp=@pmTipFactCxp,NumFactura=@pmNumFactura,IdCiaCxp=@pmIdCiaCxp,EstContable=@pmEstContable,CdConcepto=@pmCdConcepto,TipCom=@pmTipCom,Comprobante=@pmComprobante,IdCiaCom=@pmIdCiaCom,Anulado=@pmAnulado,FecDev=@pmFecDev,Observacion=@pmObservacion
,IdEstado=@pmIdEstado,TipoAju=@pmTipoAju,NumAjuInv=@pmNumAjuInv,IdCiaAju=@pmIdCiaAju,CantAjuste=@pmCantAjuste
 WHERE TipEnt=@pmTipEnt AND NumEntrada=@pmNumEntrada AND IdCia=@pmIdCia
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryOilEntrada] @pmTipEnt VARCHAR(3),@pmNumEntrada INT,@pmIdCia CHAR(2)
 AS 
 SELECT TipEnt,NumEntrada,IdCia,Fecha,NumGuia,IdCiaGuia,FecDespacho,FecDescargue,IdProveedor,IdVehiculo,IdConductor,NitEmpTrans,NomEmpTrans,Remolque,ValorTotal,CtaPagar,TipFactCxp,NumFactura,IdCiaCxp
,TipoAju,NumAjuInv,IdCiaAju,CantAjuste,EstContable,CdConcepto,TipCom,Comprobante,IdCiaCom,Anulado,FecDev,Observacion,IdEstado,FechaCrea,IdCiaCrea,OrigenAdd,IdUsuario
 FROM Trn_OilEntrada
 WHERE TipEnt=@pmTipEnt AND NumEntrada=@pmNumEntrada AND IdCia=@pmIdCia
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryOilEntradaFmt] @pmTipEnt VARCHAR(3),@pmNumEntradaIni INT,@pmNumEntradaFin INT,@pmIdCia CHAR(2)
AS 
 SELECT E.TipEnt,E.NumEntrada,E.IdCia,Compania,E.Fecha,E.NumGuia,E.IdCiaGuia,E.FecDespacho,E.FecDescargue,E.IdProveedor,T.RazonSocial AS NomProveedor,E.IdVehiculo,E.IdConductor,CD.RazonSocial AS NomConductor
,D.IdTanque,D.IdProducto,D.Cantidad,D.UndMed,D.Temperatura,D.UnidTemp,D.ValorAPI,D.ValorVCW,D.API_Corregido,D.Densidad
,D.CantCargue,D.UMCargue,D.TempCargue,D.API_Cargue,D.VCW_Cargue,D.PesoNeto,D.VrUnitario
,E.NitEmpTrans,E.NomEmpTrans,E.Remolque,E.ValorTotal,E.CtaPagar,E.TipFactCxp,E.NumFactura,E.IdCiaCxp,E.TipoAju,E.NumAjuInv,E.IdCiaAju,E.CantAjuste,E.EstContable,E.CdConcepto,Concepto
,E.TipCom,E.Comprobante,E.IdCiaCom,E.Anulado,E.FecDev,E.Observacion,E.IdEstado,Estado,E.FechaCrea,E.IdCiaCrea,E.OrigenAdd,E.IdUsuario,Usuario,TipoDoc
--Datos del proveedor
,T.TipoId AS TercTipoId,T.Dv AS TercDv,T.Direccion AS TercDireccion,T.IdLocal AS TercIdCiu,L.Localidad AS TercCiudad,L.IdDep AS TercIdDep,DP.Departamento AS TercDpto,T.Telefono AS TercTelefono,T.TelMovil AS TercCelular,T.e_mail AS TercEmail
 FROM Trn_OilEntrada AS E INNER JOIN Trn_OilEntradaProd AS D ON E.TipEnt=D.TipEnt AND E.NumEntrada=D.NumEntrada AND E.IdCia=D.IdCia
 INNER JOIN Sys_TiposDoc AS TD ON E.TipEnt=TD.IdDoc INNER JOIN EstadoDoc AS ED ON E.IdEstado=ED.IdEstado
 INNER JOIN Companias AS CN ON E.IdCia=CN.IdCia INNER JOIN Terceros AS T ON E.IdProveedor=T.IdTercero
 INNER JOIN ProdMcias AS P ON D.IdProducto=P.IdProducto INNER JOIN Sys_Um AS UM ON D.UndMed=UM.UndMed
 INNER JOIN Terceros AS CD ON E.IdConductor=CD.IdTercero INNER JOIN adm_Usuarios AS U ON E.IdUsuario=U.IdUsuario
 INNER JOIN Localidades AS L ON T.IdLocal=L.IdLocal INNER JOIN Departamentos AS DP ON L.IdDep=DP.IdDep 
 LEFT JOIN Conceptos AS CT ON E.CdConcepto=CT.IdConcepto
 WHERE E.TipEnt=@pmTipEnt AND E.NumEntrada BETWEEN @pmNumEntradaIni AND @pmNumEntradaFin AND E.IdCia=@pmIdCia
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[paUpTanquesSal] @pmIdProducto VARCHAR(16)=Null,@pmIdTanque VARCHAR(4)=Null
 AS 
 IF @pmIdProducto IS NULL AND @pmIdTanque IS NULL
  BEGIN 
   UPDATE Tanques SET SaldoActual=(SELECT ISNULL(SUM(SaldoActual),0) FROM TanqSaldos WHERE Tanques.IdTanque=TanqSaldos.IdTanque)
  END
 ELSE
  BEGIN
   IF @pmIdProducto IS NULL
    BEGIN
     UPDATE Tanques SET SaldoActual=(SELECT ISNULL(SUM(SaldoActual),0) FROM TanqSaldos WHERE Tanques.IdTanque=TanqSaldos.IdTanque)
     WHERE IdTanque=@pmIdTanque
    END
   ELSE
    BEGIN
     UPDATE Tanques SET SaldoActual=(SELECT ISNULL(SUM(SaldoActual),0) FROM TanqSaldos WHERE Tanques.IdTanque=TanqSaldos.IdTanque)
     WHERE IdProducto=@pmIdProducto AND (IdTanque=@pmIdTanque OR @pmIdTanque IS NULL)
    END
   END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paInsTurnos] @pmIdTurno VARCHAR(4),@pmTurno VARCHAR(50),@pmHoraInicial VARCHAR(10),@pmHoraFinal VARCHAR(10),@pmInactivo BIT
 AS 
 INSERT INTO Turnos (IdTurno,Turno,HoraInicial,HoraFinal,Inactivo)
 VALUES (@pmIdTurno,@pmTurno,@pmHoraInicial,@pmHoraFinal,@pmInactivo)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paUpTurnos] @pmIdTurno VARCHAR(4),@pmTurno VARCHAR(50),@pmHoraInicial VARCHAR(10),@pmHoraFinal VARCHAR(10),@pmInactivo BIT
 AS 
 UPDATE Turnos SET Turno=@pmTurno,HoraInicial=@pmHoraInicial,HoraFinal=@pmHoraFinal,Inactivo=@pmInactivo
 WHERE IdTurno=@pmIdTurno
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryTurnos] @pmIdTurno VARCHAR(4)
 AS 
 SELECT IdTurno,Turno,HoraInicial,HoraFinal,Inactivo
 FROM Turnos
 WHERE IdTurno=@pmIdTurno
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[paUpProdMciasSal] @pmIdProducto VARCHAR(16)=Null
 AS 
 IF @pmIdProducto IS NULL
  BEGIN
   UPDATE ProdMcias 
   SET ExtciaAct=(SELECT ISNULL(SUM(SaldoActual),0) FROM ProdSaldos WHERE ProdSaldos.IdProducto=ProdMcias.IdProducto)
   WHERE TipoRef<>'SERVICIO'
  END
 ELSE
  BEGIN
   UPDATE ProdMcias 
   SET ExtciaAct=(SELECT ISNULL(SUM(SaldoActual),0) FROM ProdSaldos WHERE ProdSaldos.IdProducto=ProdMcias.IdProducto)
   WHERE IdProducto=@pmIdProducto
  END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paInsOilMediciones] @pmTipDoc VARCHAR(3),@pmNumInvent INT,@pmIdCia CHAR(2),@pmFecha SMALLDATETIME,@pmFecProceso SMALLDATETIME,@pmIdTurno VARCHAR(4),@pmIdOperario VARCHAR(16),@pmNomOperario VARCHAR(150),@pmAjuInvSob INT,@pmAjuInvFal INT,@pmIdCiaAin CHAR(2),@pmAnulado BIT,@pmNumDev INT,@pmFecDev SMALLDATETIME
,@pmObservacion VARCHAR(2000),@pmIdEstado VARCHAR(4),@pmFechaCrea SMALLDATETIME,@pmIdCiaCrea CHAR(2),@pmOrigenAdd VARCHAR(10),@pmIdUsuario VARCHAR(11)
 AS 
 INSERT INTO Trn_OilMediciones (TipDoc,NumInvent,IdCia,Fecha,FecProceso,IdTurno,IdOperario,NomOperario,AjuInvSob,AjuInvFal,IdCiaAin,Anulado,NumDev,FecDev,Observacion,IdEstado,FechaCrea,IdCiaCrea,OrigenAdd,IdUsuario)
 VALUES (@pmTipDoc,@pmNumInvent,@pmIdCia,@pmFecha,@pmFecProceso,@pmIdTurno,@pmIdOperario,@pmNomOperario,@pmAjuInvSob,@pmAjuInvFal,@pmIdCiaAin,@pmAnulado,@pmNumDev,@pmFecDev,@pmObservacion,@pmIdEstado,@pmFechaCrea,@pmIdCiaCrea,@pmOrigenAdd,@pmIdUsuario)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paUpOilMediciones] @pmTipDoc VARCHAR(3),@pmNumInvent INT,@pmIdCia CHAR(2),@pmFecha SMALLDATETIME,@pmFecProceso SMALLDATETIME,@pmIdTurno VARCHAR(4),@pmIdOperario VARCHAR(16),@pmNomOperario VARCHAR(150),@pmAjuInvSob INT,@pmAjuInvFal INT,@pmIdCiaAin CHAR(2),@pmAnulado BIT,@pmNumDev INT,@pmFecDev SMALLDATETIME
,@pmObservacion VARCHAR(2000),@pmIdEstado VARCHAR(4)
 AS 
 UPDATE Trn_OilMediciones SET Fecha=@pmFecha,FecProceso=@pmFecProceso,IdTurno=@pmIdTurno,IdOperario=@pmIdOperario,NomOperario=@pmNomOperario,AjuInvSob=@pmAjuInvSob,AjuInvFal=@pmAjuInvFal,IdCiaAin=@pmIdCiaAin,Anulado=@pmAnulado,NumDev=@pmNumDev,FecDev=@pmFecDev,Observacion=@pmObservacion,IdEstado=@pmIdEstado
 WHERE TipDoc=@pmTipDoc AND NumInvent=@pmNumInvent AND IdCia=@pmIdCia
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryOilMediciones] @pmTipDoc VARCHAR(3),@pmNumInvent INT,@pmIdCia CHAR(2)
 AS 
 SELECT TipDoc,NumInvent,IdCia,Fecha,FecProceso,IdTurno,IdOperario,NomOperario,AjuInvSob,AjuInvFal,IdCiaAin,Anulado,NumDev,FecDev,Observacion,IdEstado,FechaCrea,IdCiaCrea,OrigenAdd,IdUsuario
 FROM Trn_OilMediciones
 WHERE TipDoc=@pmTipDoc AND NumInvent=@pmNumInvent AND IdCia=@pmIdCia
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paDelOilMediciones] @pmTipDoc VARCHAR(3),@pmNumInvent INT,@pmIdCia CHAR(2)
 AS 
 DELETE FROM Trn_OilMediciones
 WHERE TipDoc=@pmTipDoc AND NumInvent=@pmNumInvent AND IdCia=@pmIdCia
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paInsOilMedicionesTq] @pmTipDoc VARCHAR(3),@pmNumInvent INT,@pmIdCia CHAR(2),@pmItem INT,@pmIdTanque VARCHAR(4),@pmIdProducto VARCHAR(16),@pmNivelVol DECIMAL(16,6),@pmCantidad DECIMAL(16,6),@pmUndMed VARCHAR(10),@pmTipoMed INT,@pmAlturaTq DECIMAL(16,6)
,@pmUndAforoC DECIMAL(16,6),@pmUndAforoF DECIMAL(16,6),@pmTemperatura DECIMAL(16,6),@pmUnidTemp CHAR(1),@pmValorAPI DECIMAL(16,6),@pmAPI_Corregido DECIMAL(16,6),@pmDensidad DECIMAL(16,6),@pmCantSaldo DECIMAL(16,6),@pmCantAjuste DECIMAL(16,6),@pmVrUnitario DECIMAL(16,6)
 AS 
 INSERT INTO Trn_OilMedicionesTq (TipDoc,NumInvent,IdCia,Item,IdTanque,IdProducto,NivelVol,Cantidad,UndMed,TipoMed,AlturaTq,UndAforoC,UndAforoF,Temperatura,UnidTemp,ValorAPI,API_Corregido,Densidad,CantSaldo,CantAjuste,VrUnitario)
 VALUES (@pmTipDoc,@pmNumInvent,@pmIdCia,@pmItem,@pmIdTanque,@pmIdProducto,@pmNivelVol,@pmCantidad,@pmUndMed,@pmTipoMed,@pmAlturaTq,@pmUndAforoC,@pmUndAforoF,@pmTemperatura,@pmUnidTemp,@pmValorAPI,@pmAPI_Corregido,@pmDensidad,@pmCantSaldo,@pmCantAjuste,@pmVrUnitario)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paInsOilEntradaProd] @pmTipEnt VARCHAR(3),@pmNumEntrada INT,@pmIdCia CHAR(2),@pmItem INT,@pmIdTanque VARCHAR(4),@pmIdProducto VARCHAR(16),@pmCantidad DECIMAL(16,6),@pmUndMed VARCHAR(10),@pmTemperatura DECIMAL(16,6),@pmUnidTemp CHAR(1),@pmValorAPI DECIMAL(16,6),@pmValorVCW DECIMAL(16,6),@pmAPI_Corregido DECIMAL(16,6),@pmDensidad DECIMAL(16,6),@pmCantCargue DECIMAL(16,6)
,@pmTempCargue DECIMAL(16,6),@pmAPI_Cargue DECIMAL(16,6),@pmVCW_Cargue DECIMAL(16,6),@pmPesoNeto DECIMAL(16,6),@pmVrUnitario DECIMAL(16,6),@pmUMCargue VARCHAR(10)
 AS 
 INSERT INTO Trn_OilEntradaProd (TipEnt,NumEntrada,IdCia,Item,IdTanque,IdProducto,Cantidad,UndMed,Temperatura,UnidTemp,ValorAPI,ValorVCW,API_Corregido,Densidad,CantCargue,TempCargue,API_Cargue,VCW_Cargue,PesoNeto,VrUnitario,UMCargue)
 VALUES (@pmTipEnt,@pmNumEntrada,@pmIdCia,@pmItem,@pmIdTanque,@pmIdProducto,@pmCantidad,@pmUndMed,@pmTemperatura,@pmUnidTemp,@pmValorAPI,@pmValorVCW,@pmAPI_Corregido,@pmDensidad,@pmCantCargue,@pmTempCargue,@pmAPI_Cargue,@pmVCW_Cargue,@pmPesoNeto,@pmVrUnitario,@pmUMCargue)
GO