if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paDelTraDecAduana]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paDelTraDecAduana]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paDelTraManifInt]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paDelTraManifInt]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paDelTraPorteInt]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paDelTraPorteInt]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsAduanas]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsAduanas]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsTraDecAduana]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsTraDecAduana]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsTraDecMcia]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsTraDecMcia]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsTraManifInt]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsTraManifInt]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsTraManifIntMcia]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsTraManifIntMcia]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsTraPorteInt]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsTraPorteInt]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paInsTraPorteIntMcia]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paInsTraPorteIntMcia]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryLocalidadesPais]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryLocalidadesPais]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryTraDecAduana]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryTraDecAduana]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryTraDecAduana_Cr]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryTraDecAduana_Cr]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryTraDecAduanaLta]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryTraDecAduanaLta]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryTraManifInt]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryTraManifInt]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryTraManifInt_Cr]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryTraManifInt_Cr]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryTraManifIntCon_Cr]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryTraManifIntCon_Cr]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryTraManifIntLta]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryTraManifIntLta]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryTraPorteInt]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryTraPorteInt]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryTraPorteInt_Cr]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryTraPorteInt_Cr]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryTraPorteIntGas_Cr]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryTraPorteIntGas_Cr]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQryTraPorteIntLta]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQryTraPorteIntLta]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paUpAduanas]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paUpAduanas]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paUpTraDecAduana]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paUpTraDecAduana]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paUpTraManifInt]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paUpTraManifInt]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paUpTraPorteInt]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paUpTraPorteInt]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryTraManifIntCon_Cr] @pmTipDoc VARCHAR(3),@pmManifiestoIni INT,@pmManifiestoFin INT,@pmIdCia CHAR(2)
 AS 
 SELECT C.TipDoc,C.Manifiesto,C.IdCia AS CdCia,C.Item,C.IdTipoCon,TipoContndor,C.NumCont,C.PesoCont
,C.IdTipoPre,Precinto,C.NumPrecinto,C.ColorPrecinto
FROM Trn_TraManifIntCon AS C INNER JOIN TiposCnd AS TC ON C.IdTipoCon=TC.IdTipoCon
LEFT JOIN TiposPcnto AS P ON C.IdTipoPre=P.IdTipoPre 
WHERE C.TipDoc=@pmTipDoc AND C.Manifiesto BETWEEN @pmManifiestoIni AND @pmManifiestoFin AND C.IdCia=@pmIdCia
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryTraPorteInt_Cr] @pmTipDoc VARCHAR(3),@pmNumOrdenIni INT,@pmNumOrdenFin INT,@pmIdCia CHAR(2)
 AS 
 SELECT O.TipDoc,TipoDoc,O.NumOrden,O.IdCia AS CdCia,Compania,O.Fecha,O.FecEmision,O.FecCargue,O.FecEntrega,DPO.IdPais AS CdPaisOrig,POR.NombrePais AS PaisOrig,LO.IdDep AS CdDepOrig,DPO.Departamento AS DptoOrigen,O.IdOrigen,LO.Localidad AS DescOrigen
,DPD.IdPais AS CdPaisDest,PDE.NombrePais AS PaisDestino,LD.IdDep AS CdDepDest,DPD.Departamento AS DptoDestino,O.IdDestino,LD.Localidad AS DescDestino,O.IdNotificado,O.Notificado,O.IdRemitente,O.Remitente,O.DirOrigen
,O.IdDestinatario,O.Destinatario,O.DirDestino,O.IdConsig,O.Consignatario,O.DirConsig,O.InsTransporte,O.DocRemitente,O.ValorTotal,M.Simbolo,O.IdMoneda AS CdMoneda,M.Mneda AS Moneda,O.PesoTotal,O.Manifiesto,O.CdCiaManif
,O.Anulado,O.FecDev,O.Observacion AS Observ,O.IdEstado AS CdEstado,Estado,O.TimeSys AS FechaCrea,O.FecUpdate,O.IdCiaCrea,O.OrigenAdd,O.IdUsuario AS CdUsuario,Usuario
,D.Item,D.CdMercancia,D.DescripMcias,D.Cantidad,D.PesoNeto,D.PesoBruto,D.Volumen,D.ValorMcia,D.IdMoneda AS DetIdMoneda,MN.Mneda AS DetMoneda,MN.Simbolo AS DetMonSimb,D.IdUnd AS CdUnd,UM.Unidad,D.IdEmp AS CdEmp,Empaque
,D.IdNat AS CdNat,Natlzaprod,D.UndMed,UP.Unidad AS DesUndPeso,D.UndVol,UV.Unidad AS DesUndVol,D.Bultos,D.Observacion AS DetObservacion
 FROM Trn_TraPorteInt AS O INNER JOIN Companias AS C ON O.IdCia=C.IdCia INNER JOIN Sys_TiposDoc AS TD ON O.TipDoc=TD.IdDoc
 INNER JOIN Trn_TraPorteIntMcia AS D ON O.TipDoc=D.TipDoc AND O.NumOrden=D.NumOrden AND O.IdCia=D.IdCia
 INNER JOIN Localidades AS LO ON O.IdOrigen=LO.IdLocal INNER JOIN Departamentos AS DPO ON LO.IdDep=DPO.IdDep INNER JOIN adm_Paises AS POR ON DPO.IdPais=POR.IdPais
 INNER JOIN Localidades AS LD ON O.IdDestino=LD.IdLocal INNER JOIN Departamentos AS DPD ON LD.IdDep=DPD.IdDep INNER JOIN adm_Paises AS PDE ON DPD.IdPais=PDE.IdPais
 INNER JOIN adm_Usuarios AS U ON O.IdUsuario=U.IdUsuario INNER JOIN EstadoDoc AS E ON O.IdEstado=E.IdEstado
 INNER JOIN UndMed AS UM ON D.IdUnd=UM.IdUnd INNER JOIN adm_monedas AS MN ON D.IdMoneda=MN.IdMneda  
 INNER JOIN TiposNat AS NZ ON D.IdNat=NZ.IdNat
 LEFT JOIN Sys_Um AS UP ON D.UndMed=UP.UndMed LEFT JOIN Sys_Um AS UV ON D.UndVol=UV.UndMed
 LEFT JOIN adm_monedas AS M ON O.IdMoneda=M.IdMneda LEFT JOIN Empaques AS EP ON D.IdEmp=EP.IdEmp
 WHERE O.TipDoc=@pmTipDoc AND O.NumOrden BETWEEN @pmNumOrdenIni AND @pmNumOrdenFin AND O.IdCia=@pmIdCia
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paInsTraPorteIntMcia] @pmTipDoc VARCHAR(3),@pmNumOrden INT,@pmIdCia CHAR(2),@pmItem INT,@pmCdMercancia VARCHAR(16),@pmDescripMcias VARCHAR(500),@pmCantidad DECIMAL(14,4),@pmPesoNeto DECIMAL(14,4),@pmPesoBruto DECIMAL(14,4),@pmVolumen DECIMAL(14,4),@pmValorMcia MONEY
,@pmIdMoneda VARCHAR(5),@pmIdUnd VARCHAR(4),@pmIdEmp VARCHAR(4),@pmIdNat VARCHAR(4),@pmUndMed VARCHAR(10),@pmUndVol VARCHAR(10),@pmBultos VARCHAR(150),@pmObservacion VARCHAR(1000)
 AS 
 INSERT INTO Trn_TraPorteIntMcia (TipDoc,NumOrden,IdCia,Item,CdMercancia,DescripMcias,Cantidad,PesoNeto,PesoBruto,Volumen,ValorMcia,IdMoneda,IdUnd,IdEmp,IdNat,UndMed,UndVol,Bultos,Observacion)
 VALUES (@pmTipDoc,@pmNumOrden,@pmIdCia,@pmItem,@pmCdMercancia,@pmDescripMcias,@pmCantidad,@pmPesoNeto,@pmPesoBruto,@pmVolumen,@pmValorMcia,@pmIdMoneda,@pmIdUnd,@pmIdEmp,@pmIdNat,@pmUndMed,@pmUndVol,@pmBultos,@pmObservacion)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paInsTraDecMcia] @pmTipDoc VARCHAR(3),@pmNumDeclara INT,@pmIdCia CHAR(2),@pmItem INT,@pmTipOrd VARCHAR(3),@pmNumOrden INT,@pmIdCiaOrd CHAR(2),@pmCdMercancia VARCHAR(16),@pmDescripMcias VARCHAR(500),@pmCantidad DECIMAL(14,4),@pmPesoNeto DECIMAL(14,4)
,@pmPesoBruto DECIMAL(14,4),@pmVolumen DECIMAL(14,4),@pmValorMcia MONEY,@pmIdMoneda VARCHAR(5),@pmIdUnd VARCHAR(4),@pmIdEmp VARCHAR(4),@pmIdNat VARCHAR(4),@pmUndMed VARCHAR(10),@pmUndVol VARCHAR(10),@pmBultos VARCHAR(150)
 AS 
 INSERT INTO Trn_TraDecMcia (TipDoc,NumDeclara,IdCia,Item,TipOrd,NumOrden,IdCiaOrd,CdMercancia,DescripMcias,Cantidad,PesoNeto,PesoBruto,Volumen,ValorMcia,IdMoneda,IdUnd,IdEmp,IdNat,UndMed,UndVol,Bultos)
 VALUES (@pmTipDoc,@pmNumDeclara,@pmIdCia,@pmItem,@pmTipOrd,@pmNumOrden,@pmIdCiaOrd,@pmCdMercancia,@pmDescripMcias,@pmCantidad,@pmPesoNeto,@pmPesoBruto,@pmVolumen,@pmValorMcia,@pmIdMoneda,@pmIdUnd,@pmIdEmp,@pmIdNat,@pmUndMed,@pmUndVol,@pmBultos)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryTraDecAduana_Cr] @pmTipDoc VARCHAR(3),@pmNumDeclaraIni INT,@pmNumDeclaraFin INT,@pmIdCia CHAR(2)
 AS 
 SELECT O.TipDoc,TipoDoc,O.NumDeclara,O.IdCia AS CdCia,Compania,O.Fecha,O.FecEmision,DPO.IdPais AS CdPaisOrig,POR.NombrePais AS PaisOrig,LO.IdDep AS CdDepOrig,DPO.Departamento AS DptoOrigen,O.IdOrigen,LO.Localidad AS DescOrigen
,DPD.IdPais AS CdPaisDest,PDE.NombrePais AS PaisDestino,LD.IdDep AS CdDepDest,DPD.Departamento AS DptoDestino,O.IdDestino,LD.Localidad AS DescDestino
,O.IdAduCarga,AC.NomAduana AS AduanaCargo,PAC.NombrePais AS PaisAduCargo,O.IdAduOrigen,AP.NomAduana AS AduanaOrigen,PAP.NombrePais AS PaisAduOrigen,O.IdAduDestino,AD.NomAduana AS AduanaDestino,PAD.NombrePais AS PaisAduDestino
,O.IdAduFrontera,AF.NomAduana AS AduanaFrontera,PAF.NombrePais AS PaisAduFront,O.IdDeclarante,Declarante,DirDeclara,CdLocalDec,LDC.Localidad AS CiudadDec,O.IdRemitente,O.Remitente,DirOrigen,CdLocalRem,LRM.Localidad AS CiudadRemite
,O.IdDestinatario,Destinatario,DirDestino,CdLocalDest,LDT.Localidad AS CiudadDest,O.IdConsig,Consignatario,DirConsig,CdLocalConsig,LCN.Localidad AS CiudadConsig,O.IdMoneda AS CdMoneda,M.Simbolo,M.Mneda AS Moneda
,O.ValorTotal,O.PesoTotal,O.DocAnexos,O.Vehiculos,O.Remolques,O.Manifiestos,O.Contenedores,O.Precintos,O.Anulado,O.FecDev,O.Observacion AS Observ,O.IdEstado AS CdEstado,Estado
,O.OrigenAdd,O.TimeSys AS FechaCrea,O.FecUpdate,O.IdCiaCrea,O.IdUsuario AS CdUsuario,Usuario
--detalles
,D.Item,D.TipOrd,D.NumOrden,D.IdCiaOrd,D.CdMercancia,D.DescripMcias,D.Cantidad,D.PesoNeto,D.PesoBruto,D.Volumen,D.ValorMcia,D.IdMoneda AS DetIdMoneda,MN.Mneda AS DetMoneda,MN.Simbolo AS DetMonSimb,D.IdUnd AS CdUnd,UM.Unidad
,D.IdEmp AS CdEmp,Empaque,D.IdNat AS CdNat,Natlzaprod,D.UndMed,UP.Unidad AS DesUndPeso,D.UndVol,UV.Unidad AS DesUndVol,D.Bultos
 FROM Trn_TraDecAduana AS O INNER JOIN Companias AS C ON O.IdCia=C.IdCia INNER JOIN adm_Usuarios AS U ON O.IdUsuario=U.IdUsuario 
 INNER JOIN EstadoDoc AS E ON O.IdEstado=E.IdEstado INNER JOIN Sys_TiposDoc AS TD ON O.TipDoc=TD.IdDoc
 INNER JOIN Localidades AS LO ON O.IdOrigen=LO.IdLocal INNER JOIN Departamentos AS DPO ON LO.IdDep=DPO.IdDep INNER JOIN adm_Paises AS POR ON DPO.IdPais=POR.IdPais
 INNER JOIN Localidades AS LD ON O.IdDestino=LD.IdLocal INNER JOIN Departamentos AS DPD ON LD.IdDep=DPD.IdDep INNER JOIN adm_Paises AS PDE ON DPD.IdPais=PDE.IdPais
 INNER JOIN Trn_TraDecMcia AS D ON O.TipDoc=D.TipDoc AND O.NumDeclara=D.NumDeclara AND O.IdCia=D.IdCia
 INNER JOIN Aduanas AS AC ON O.IdAduCarga=AC.IdAduana INNER JOIN adm_Paises AS PAC ON AC.IdPais=PAC.IdPais
 INNER JOIN Aduanas AS AP ON O.IdAduOrigen=AP.IdAduana INNER JOIN adm_Paises AS PAP ON AP.IdPais=PAP.IdPais
 INNER JOIN Aduanas AS AD ON O.IdAduDestino=AD.IdAduana INNER JOIN adm_Paises AS PAD ON AD.IdPais=PAD.IdPais
 INNER JOIN UndMed AS UM ON D.IdUnd=UM.IdUnd INNER JOIN adm_monedas AS MN ON D.IdMoneda=MN.IdMneda  
 INNER JOIN TiposNat AS NZ ON D.IdNat=NZ.IdNat
 LEFT JOIN adm_monedas AS M ON O.IdMoneda=M.IdMneda
 LEFT JOIN Aduanas AS AF ON O.IdAduFrontera=AF.IdAduana LEFT JOIN adm_Paises AS PAF ON AF.IdPais=PAF.IdPais
 LEFT JOIN Localidades AS LDC ON O.CdLocalDec=LDC.IdLocal LEFT JOIN Localidades AS LRM ON O.CdLocalRem=LRM.IdLocal
 LEFT JOIN Localidades AS LDT ON O.CdLocalDest=LDT.IdLocal LEFT JOIN Localidades AS LCN ON O.CdLocalConsig=LCN.IdLocal
 LEFT JOIN Sys_Um AS UP ON D.UndMed=UP.UndMed LEFT JOIN Sys_Um AS UV ON D.UndVol=UV.UndMed
 LEFT JOIN Empaques AS EP ON D.IdEmp=EP.IdEmp
 WHERE O.TipDoc=@pmTipDoc AND O.NumDeclara BETWEEN @pmNumDeclaraIni AND @pmNumDeclaraFin AND O.IdCia=@pmIdCia
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryTraManifIntLta] @pmTipDoc VARCHAR(3),@pmFechaIni SMALLDATETIME,@pmFechaFin SMALLDATETIME,@pmIdCia CHAR(2)=Null
 AS 
 SELECT M.Manifiesto,M.IdCia AS CdCia,Compania,M.Fecha,M.FecEmision,DPO.IdPais AS CdPaisOrig,POR.NombrePais AS PaisOrig,LO.IdDep AS CdDepOrig,DPO.Departamento AS DptoOrigen,M.IdOrigen,LO.Localidad AS DescOrigen
,DPD.IdPais AS CdPaisDest,PDE.NombrePais AS PaisDestino,LD.IdDep AS CdDepDest,DPD.Departamento AS DptoDestino,M.IdDestino,LD.Localidad AS DescDestino
,M.IdVehiculo AS PlacaVeh,M.nRemolque,M.IdConductor AS CdConductor,NC.RazonSocial AS CondTitula,M.IdCondRelev,NCA.RazonSocial AS CondAuxiliar,NatCarga,M.CdAduana,AF.NomAduana AS AduanaFront,M.CdAduanaDest,AD.NomAduana AS AduanaDest
,M.IdMoneda AS CdMoneda,MN.Simbolo,MN.Mneda AS Moneda,M.ValorTotal,M.PesoTotal,M.NumMuc,M.CdCiaMuc,M.Anulado,M.FecDev
,M.Observacion AS Observ,M.IdEstado AS CdEstado,Estado,M.OrigenAdd,M.TimeSys AS FechaCrea,M.FecUpdate,M.IdCiaCrea AS CdCiaCrea,M.IdUsuario AS CdUsuario,Usuario
 FROM Trn_TraManifInt AS M INNER JOIN Companias AS C ON M.IdCia=C.IdCia INNER JOIN Vehiculos AS V ON M.IdVehiculo=V.IdVehiculo
 INNER JOIN Localidades AS LO ON M.IdOrigen=LO.IdLocal INNER JOIN Departamentos AS DPO ON LO.IdDep=DPO.IdDep INNER JOIN adm_Paises AS POR ON DPO.IdPais=POR.IdPais
 INNER JOIN Localidades AS LD ON M.IdDestino=LD.IdLocal INNER JOIN Departamentos AS DPD ON LD.IdDep=DPD.IdDep INNER JOIN adm_Paises AS PDE ON DPD.IdPais=PDE.IdPais
 INNER JOIN Terceros AS NC ON M.IdConductor=NC.IdTercero
 INNER JOIN adm_Usuarios AS U ON M.IdUsuario=U.IdUsuario INNER JOIN EstadoDoc AS E ON M.IdEstado=E.IdEstado
 LEFT JOIN Terceros AS NCA ON M.IdCondRelev=NCA.IdTercero LEFT JOIN Aduanas AS AF ON M.CdAduana=AF.IdAduana LEFT JOIN Aduanas AS AD ON M.CdAduanaDest=AD.IdAduana
 LEFT JOIN adm_monedas AS MN ON M.IdMoneda=MN.IdMneda 
 WHERE M.TipDoc=@pmTipDoc AND M.FecEmision BETWEEN @pmFechaIni AND @pmFechaFin AND M.IdCia LIKE ISNULL(@pmIdCia,'%%')
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryTraManifInt_Cr] @pmTipDoc VARCHAR(3),@pmManifiestoIni INT,@pmManifiestoFin INT,@pmIdCia CHAR(2)
 AS 
 SELECT M.TipDoc,TipoDoc,M.Manifiesto,M.IdCia AS CdCia,Compania,M.Fecha,M.FecEmision,DPO.IdPais AS CdPaisOrig,POR.NombrePais AS PaisOrig,LO.IdDep AS CdDepOrig,DPO.Departamento AS DptoOrigen,M.IdOrigen,LO.Localidad AS DescOrigen
,DPD.IdPais AS CdPaisDest,PDE.NombrePais AS PaisDestino,LD.IdDep AS CdDepDest,DPD.Departamento AS DptoDestino,M.IdDestino,LD.Localidad AS DescDestino
,M.IdVehiculo AS PlacaVeh,M.nRemolque,M.IdConductor AS CdConductor,NC.RazonSocial AS CondTitula,M.IdCondRelev,NCA.RazonSocial AS CondAuxiliar,NatCarga,M.CdAduana,AF.NomAduana AS AduanaFront,AF.IdPais AS CdPaisAdu,PAF.NombrePais AS PaisAduFront
,M.CdAduanaDest,AD.NomAduana AS AduanaDest,AD.IdPais AS CdPaisAduDest,PAD.NombrePais AS PaisAduDestino,M.IdMoneda AS CdMoneda,MN.Simbolo,MN.Mneda AS Moneda,M.ValorTotal,M.PesoTotal,M.NumMuc,M.CdCiaMuc
,M.Anulado,M.FecDev,M.Observacion AS Observ,M.IdEstado AS CdEstado,Estado,M.OrigenAdd,M.TimeSys AS FechaCrea,M.FecUpdate,M.IdCiaCrea AS CdCiaCrea,M.IdUsuario AS CdUsuario,Usuario
--detalles
,D.Item,D.TipOrd,D.NumOrden,D.IdCiaOrd,D.CdMercancia,D.DescripMcias,D.Cantidad,D.PesoNeto,D.PesoBruto,D.Volumen,D.ValorMcia,D.IdMoneda AS DetIdMoneda,MD.Mneda AS DetMoneda,MD.Simbolo AS DetMonSimb,D.IdUnd AS CdUnd,UM.Unidad
,D.IdEmp AS CdEmp,Empaque,D.IdNat AS CdNat,Natlzaprod,D.UndMed,UP.Unidad AS DesUndPeso,D.UndVol,UV.Unidad AS DesUndVol,D.Bultos
--datos del vehículo
,V.IdMarca AS CdMarca,MV.Marca,V.Modelo,V.SerieChasis,V.NumSerie,V.IdPoseedor AS CdPoseedor,T.RazonSocial AS Poseedor
,V.NumSoat,VigSoat,TarjProp,VigTProp,RevTecMec,VigTecMec,V.TarjOper,VigTarjOper,V.Descripcion AS VehDescripcion,V.CertMovilizacion,VigCertMovil
,RQ.IdMarca AS CdMarcaRmq,MR.Marca AS MarcaRmq,RQ.Modelo AS ModeloRmq,RQ.NumSerial AS NumSerieRmq
,NC.IdLugarCed AS CondIdLugar,LC.Localidad AS CondLugarCed,DLC.IdPais AS CdPaisLugar,PLC.NombrePais AS CondPaisLugar
,CDT.TipoSangre,CDT.FactorRh,CDT.Pasporte,CDT.VigPaspte,CDT.Licencia AS NumLicencia,CDT.CatLicencia,CDT.VigLicencia,CDT.NumTarjeta,CDT.VigTarjeta,CDT.PasSeguridad,CDT.VigPasSeg
,NCA.IdLugarCed AS AuxIdLugar,LCA.Localidad AS AuxLugarCed,DLA.IdPais AS AuxCdPais,PLA.NombrePais AS AuxPaisLugar
,CDA.TipoSangre AS AuxTipoSangre,CDA.FactorRh AS AuxFactorRh,CDA.Pasporte AS AuxPasaporte,CDA.VigPaspte AS AuxVigPaspte,CDA.Licencia AS AuxNumLicencia
,CDA.CatLicencia AS AuxCategLic,CDA.VigLicencia AS AuxVigLicencia,CDA.NumTarjeta AS AuxNumTarjeta,CDA.VigTarjeta AS AuxVigTarjeta,CDA.PasSeguridad AS AuxPasSeguridad,CDA.VigPasSeg AS AuxVigPasSeg
 FROM Trn_TraManifInt AS M INNER JOIN Companias AS C ON M.IdCia=C.IdCia INNER JOIN Vehiculos AS V ON M.IdVehiculo=V.IdVehiculo
 INNER JOIN Localidades AS LO ON M.IdOrigen=LO.IdLocal INNER JOIN Departamentos AS DPO ON LO.IdDep=DPO.IdDep INNER JOIN adm_Paises AS POR ON DPO.IdPais=POR.IdPais
 INNER JOIN Localidades AS LD ON M.IdDestino=LD.IdLocal INNER JOIN Departamentos AS DPD ON LD.IdDep=DPD.IdDep INNER JOIN adm_Paises AS PDE ON DPD.IdPais=PDE.IdPais
 INNER JOIN adm_Usuarios AS U ON M.IdUsuario=U.IdUsuario INNER JOIN EstadoDoc AS E ON M.IdEstado=E.IdEstado INNER JOIN Sys_TiposDoc AS TD ON M.TipDoc=TD.IdDoc
 INNER JOIN Terceros AS NC ON M.IdConductor=NC.IdTercero INNER JOIN TercCndtores AS CDT ON M.IdConductor=CDT.IdConductor 
 INNER JOIN Terceros AS T ON V.IdPoseedor=T.IdTercero  INNER JOIN Marcas AS MV ON V.IdMarca=MV.IdMarca
 INNER JOIN Trn_TraManifIntMcia AS D ON M.TipDoc=D.TipDoc AND M.Manifiesto=D.Manifiesto AND M.IdCia=D.IdCia
 INNER JOIN UndMed AS UM ON D.IdUnd=UM.IdUnd INNER JOIN adm_monedas AS MD ON D.IdMoneda=MD.IdMneda
 INNER JOIN TiposNat AS NZ ON D.IdNat=NZ.IdNat 
 LEFT JOIN VehRemolq AS RQ ON M.nRemolque=RQ.IdRemque LEFT JOIN Marcas AS MR ON RQ.IdMarca=MR.IdMarca
 LEFT JOIN Sys_Um AS UP ON D.UndMed=UP.UndMed LEFT JOIN Sys_Um AS UV ON D.UndVol=UV.UndMed LEFT JOIN Empaques AS EP ON D.IdEmp=EP.IdEmp
 LEFT JOIN Terceros AS NCA ON M.IdCondRelev=NCA.IdTercero LEFT JOIN TercCndtores AS CDA ON M.IdCondRelev=CDA.IdConductor
 LEFT JOIN Aduanas AS AF ON M.CdAduana=AF.IdAduana LEFT JOIN Aduanas AS AD ON M.CdAduanaDest=AD.IdAduana
 LEFT JOIN adm_Paises AS PAF ON AF.IdPais=PAF.IdPais LEFT JOIN adm_Paises AS PAD ON AD.IdPais=PAD.IdPais
 LEFT JOIN adm_monedas AS MN ON M.IdMoneda=MN.IdMneda 
 LEFT JOIN Localidades AS LC ON NC.IdLugarCed=LC.IdLocal LEFT JOIN Departamentos AS DLC ON LC.IdDep=DLC.IdDep LEFT JOIN adm_Paises AS PLC ON DLC.IdPais=PLC.IdPais
 LEFT JOIN Localidades AS LCA ON NCA.IdLugarCed=LCA.IdLocal LEFT JOIN Departamentos AS DLA ON LCA.IdDep=DLA.IdDep LEFT JOIN adm_Paises AS PLA ON DLA.IdPais=PLA.IdPais
 WHERE M.TipDoc=@pmTipDoc AND M.Manifiesto BETWEEN @pmManifiestoIni AND @pmManifiestoFin AND M.IdCia=@pmIdCia
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paInsTraManifIntMcia] @pmTipDoc VARCHAR(3),@pmManifiesto INT,@pmIdCia CHAR(2),@pmItem INT,@pmTipOrd VARCHAR(3),@pmNumOrden INT,@pmIdCiaOrd CHAR(2),@pmCdMercancia VARCHAR(16),@pmDescripMcias VARCHAR(500),@pmCantidad DECIMAL(14,4)
,@pmPesoNeto DECIMAL(14,4),@pmPesoBruto DECIMAL(14,4),@pmVolumen DECIMAL(14,4),@pmValorMcia MONEY,@pmIdMoneda VARCHAR(5),@pmIdUnd VARCHAR(4),@pmIdEmp VARCHAR(4),@pmIdNat VARCHAR(4),@pmUndMed VARCHAR(10),@pmUndVol VARCHAR(10),@pmBultos VARCHAR(150)
 AS 
 INSERT INTO Trn_TraManifIntMcia (TipDoc,Manifiesto,IdCia,Item,TipOrd,NumOrden,IdCiaOrd,CdMercancia,DescripMcias,Cantidad,PesoNeto,PesoBruto,Volumen,ValorMcia,IdMoneda,IdUnd,IdEmp,IdNat,UndMed,UndVol,Bultos)
 VALUES (@pmTipDoc,@pmManifiesto,@pmIdCia,@pmItem,@pmTipOrd,@pmNumOrden,@pmIdCiaOrd,@pmCdMercancia,@pmDescripMcias,@pmCantidad,@pmPesoNeto,@pmPesoBruto,@pmVolumen,@pmValorMcia,@pmIdMoneda,@pmIdUnd,@pmIdEmp,@pmIdNat,@pmUndMed,@pmUndVol,@pmBultos)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryTraDecAduanaLta] @pmTipDoc VARCHAR(3),@pmFechaIni SMALLDATETIME,@pmFechaFin SMALLDATETIME,@pmIdCia CHAR(2)=Null
 AS 
 SELECT O.NumDeclara,O.IdCia AS CdCia,Compania,O.Fecha,O.FecEmision,DPO.IdPais AS CdPaisOrig,POR.NombrePais AS PaisOrig,LO.IdDep AS CdDepOrig,DPO.Departamento AS DptoOrigen,O.IdOrigen,LO.Localidad AS DescOrigen
,DPD.IdPais AS CdPaisDest,PDE.NombrePais AS PaisDestino,LD.IdDep AS CdDepDest,DPD.Departamento AS DptoDestino,O.IdDestino,LD.Localidad AS DescDestino
,O.IdAduCarga,AC.NomAduana AS AduanaCargo,PAC.NombrePais AS PaisAduCargo,O.IdAduOrigen,AP.NomAduana AS AduanaOrigen,PAP.NombrePais AS PaisAduOrigen,O.IdAduDestino,AD.NomAduana AS AduanaDestino,PAD.NombrePais AS PaisAduDestino
,O.IdAduFrontera,AF.NomAduana AS AduanaFrontera,PAF.NombrePais AS PaisAduFront,O.IdDeclarante,Declarante,DirDeclara,CdLocalDec,LDC.Localidad AS CiudadDec,O.IdRemitente,O.Remitente,DirOrigen,CdLocalRem,LRM.Localidad AS CiudadRemite
,O.IdDestinatario,Destinatario,DirDestino,CdLocalDest,LDT.Localidad AS CiudadDest,O.IdConsig,Consignatario,DirConsig,CdLocalConsig,LCN.Localidad AS CiudadConsig,O.IdMoneda AS CdMoneda,M.Simbolo,M.Mneda AS Moneda
,O.ValorTotal,O.PesoTotal,O.DocAnexos,O.Vehiculos,O.Remolques,O.Manifiestos,O.Contenedores,O.Precintos,O.Anulado,O.FecDev,O.Observacion AS Observ,O.IdEstado AS CdEstado,Estado
,O.OrigenAdd,O.TimeSys AS FechaCrea,O.FecUpdate,O.IdCiaCrea,O.IdUsuario AS CdUsuario,Usuario
 FROM Trn_TraDecAduana AS O INNER JOIN Companias AS C ON O.IdCia=C.IdCia
 INNER JOIN Localidades AS LO ON O.IdOrigen=LO.IdLocal INNER JOIN Departamentos AS DPO ON LO.IdDep=DPO.IdDep INNER JOIN adm_Paises AS POR ON DPO.IdPais=POR.IdPais
 INNER JOIN Localidades AS LD ON O.IdDestino=LD.IdLocal INNER JOIN Departamentos AS DPD ON LD.IdDep=DPD.IdDep INNER JOIN adm_Paises AS PDE ON DPD.IdPais=PDE.IdPais
 INNER JOIN adm_Usuarios AS U ON O.IdUsuario=U.IdUsuario INNER JOIN EstadoDoc AS E ON O.IdEstado=E.IdEstado
 INNER JOIN Aduanas AS AC ON O.IdAduCarga=AC.IdAduana INNER JOIN adm_Paises AS PAC ON AC.IdPais=PAC.IdPais
 INNER JOIN Aduanas AS AP ON O.IdAduOrigen=AP.IdAduana INNER JOIN adm_Paises AS PAP ON AP.IdPais=PAP.IdPais
 INNER JOIN Aduanas AS AD ON O.IdAduDestino=AD.IdAduana INNER JOIN adm_Paises AS PAD ON AD.IdPais=PAD.IdPais
 LEFT JOIN adm_monedas AS M ON O.IdMoneda=M.IdMneda
 LEFT JOIN Aduanas AS AF ON O.IdAduFrontera=AF.IdAduana LEFT JOIN adm_Paises AS PAF ON AF.IdPais=PAF.IdPais
 LEFT JOIN Localidades AS LDC ON O.CdLocalDec=LDC.IdLocal LEFT JOIN Localidades AS LRM ON O.CdLocalRem=LRM.IdLocal
 LEFT JOIN Localidades AS LDT ON O.CdLocalDest=LDT.IdLocal LEFT JOIN Localidades AS LCN ON O.CdLocalConsig=LCN.IdLocal
 WHERE O.TipDoc=@pmTipDoc AND O.FecEmision BETWEEN @pmFechaIni AND @pmFechaFin AND O.IdCia LIKE ISNULL(@pmIdCia,'%%')
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryTraPorteIntLta] @pmTipDoc VARCHAR(3),@pmFechaIni SMALLDATETIME,@pmFechaFin SMALLDATETIME,@pmIdCia CHAR(2)=Null
 AS 
 SELECT O.NumOrden,O.IdCia AS CdCia,Compania,O.Fecha,O.FecEmision,O.FecCargue,O.FecEntrega,DPO.IdPais AS CdPaisOrig,POR.NombrePais AS PaisOrig,LO.IdDep AS CdDepOrig,DPO.Departamento AS DptoOrigen,O.IdOrigen,LO.Localidad AS DescOrigen
,DPD.IdPais AS CdPaisDest,PDE.NombrePais AS PaisDestino,LD.IdDep AS CdDepDest,DPD.Departamento AS DptoDestino,O.IdDestino,LD.Localidad AS DescDestino,O.IdNotificado,O.Notificado,O.IdRemitente,O.Remitente,O.DirOrigen
,O.IdDestinatario,O.Destinatario,O.DirDestino,O.IdConsig,O.Consignatario,O.DirConsig,O.InsTransporte,O.DocRemitente,O.ValorTotal,M.Simbolo,O.IdMoneda AS CdMoneda,M.Mneda AS Moneda,O.PesoTotal,O.Manifiesto,O.CdCiaManif
,O.Anulado,O.FecDev,O.Observacion AS Observ,O.IdEstado AS CdEstado,Estado,O.TimeSys AS FechaCrea,O.FecUpdate,O.IdCiaCrea,O.OrigenAdd,O.IdUsuario AS CdUsuario,Usuario
 FROM Trn_TraPorteInt AS O INNER JOIN Companias AS C ON O.IdCia=C.IdCia
 INNER JOIN Localidades AS LO ON O.IdOrigen=LO.IdLocal INNER JOIN Departamentos AS DPO ON LO.IdDep=DPO.IdDep INNER JOIN adm_Paises AS POR ON DPO.IdPais=POR.IdPais
 INNER JOIN Localidades AS LD ON O.IdDestino=LD.IdLocal INNER JOIN Departamentos AS DPD ON LD.IdDep=DPD.IdDep INNER JOIN adm_Paises AS PDE ON DPD.IdPais=PDE.IdPais
 INNER JOIN adm_Usuarios AS U ON O.IdUsuario=U.IdUsuario INNER JOIN EstadoDoc AS E ON O.IdEstado=E.IdEstado
 LEFT JOIN adm_monedas AS M ON O.IdMoneda=M.IdMneda 
 WHERE O.TipDoc=@pmTipDoc AND O.FecEmision BETWEEN @pmFechaIni AND @pmFechaFin AND O.IdCia LIKE ISNULL(@pmIdCia,'%%')
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paUpAduanas] @pmIdAduana VARCHAR(4),@pmNomAduana VARCHAR(150),@pmIdPais VARCHAR(8),@pmInactivo BIT
 AS 
 UPDATE Aduanas SET NomAduana=@pmNomAduana,IdPais=@pmIdPais,Inactivo=@pmInactivo
 WHERE IdAduana=@pmIdAduana
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paInsAduanas] @pmIdAduana VARCHAR(4),@pmNomAduana VARCHAR(150),@pmIdPais VARCHAR(8),@pmInactivo BIT
 AS 
 INSERT INTO Aduanas (IdAduana,NomAduana,IdPais,Inactivo)
 VALUES (@pmIdAduana,@pmNomAduana,@pmIdPais,@pmInactivo)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryTraPorteIntGas_Cr] @pmTipDoc VARCHAR(3),@pmNumOrdenIni INT,@pmNumOrdenFin INT,@pmIdCia CHAR(2)
 AS 
 SELECT D.TipDoc,D.NumOrden,D.IdCia AS CdCia,D.Item,D.IdConcepto AS CdConcepto,Concepto,D.MontoRem,D.IdMonRem AS CdMonRem,MR.Mneda AS MonedaRem,MR.Simbolo AS MonSimbRem
,D.MontoDest,D.IdMonDest AS CdMonDest,MD.Mneda AS MonedaDest,MD.Simbolo AS MonSimbDest
 FROM Trn_TraPorteIntGas AS D INNER JOIN ConcDiversos AS C ON D.IdConcepto=C.IdConcepto
 LEFT JOIN adm_monedas AS MR ON D.IdMonRem=MR.IdMneda LEFT JOIN adm_monedas AS MD ON D.IdMonDest=MD.IdMneda
 WHERE D.TipDoc=@pmTipDoc AND D.NumOrden BETWEEN @pmNumOrdenIni AND @pmNumOrdenFin AND D.IdCia=@pmIdCia
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[paQryLocalidadesPais] @pmIdPais VARCHAR(8)
 AS 
 SELECT L.IdLocal,L.Localidad,L.IdDep AS CodDep,D.Departamento,L.TipLocal
,L.Localidad+ ' ('+ D.Departamento +' '+P.CodISO+')' AS NomCiudad 
 FROM Localidades AS L INNER JOIN Departamentos AS D ON L.IdDep=D.IdDep
 INNER JOIN adm_Paises AS P ON D.IdPais=P.IdPais
 WHERE D.IdPais=@pmIdPais AND L.Inactivo=0
 ORDER BY Localidad
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryTraManifInt] @pmTipDoc VARCHAR(3),@pmManifiesto INT,@pmIdCia CHAR(2)
 AS 
 SELECT TipDoc,Manifiesto,IdCia,Fecha,FecEmision,IdOrigen,IdDestino,IdVehiculo,nRemolque,IdConductor,IdCondRelev,NatCarga,CdAduana,CdAduanaDest,IdMoneda,ValorTotal,PesoTotal,NumMuc,CdCiaMuc,OrigenAdd,Anulado,FecDev,Observacion,IdEstado,TimeSys,FecUpdate,IdCiaCrea,IdUsuario
 FROM Trn_TraManifInt
 WHERE TipDoc=@pmTipDoc AND Manifiesto=@pmManifiesto AND IdCia=@pmIdCia
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paDelTraManifInt] @pmTipDoc VARCHAR(3),@pmManifiesto INT,@pmIdCia CHAR(2)
 AS 
 DELETE FROM Trn_TraManifInt
 WHERE TipDoc=@pmTipDoc AND Manifiesto=@pmManifiesto AND IdCia=@pmIdCia
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paUpTraManifInt] @pmTipDoc VARCHAR(3),@pmManifiesto INT,@pmIdCia CHAR(2),@pmFecha SMALLDATETIME,@pmFecEmision SMALLDATETIME,@pmIdOrigen VARCHAR(8),@pmIdDestino VARCHAR(8),@pmIdVehiculo VARCHAR(10),@pmnRemolque VARCHAR(10),@pmIdConductor VARCHAR(16),@pmIdCondRelev VARCHAR(16),@pmNatCarga VARCHAR(50),@pmCdAduana VARCHAR(4),@pmCdAduanaDest VARCHAR(4)
,@pmIdMoneda VARCHAR(5),@pmValorTotal MONEY,@pmPesoTotal DECIMAL(14,4),@pmNumMuc INT,@pmCdCiaMuc CHAR(2),@pmAnulado BIT,@pmFecDev SMALLDATETIME,@pmObservacion VARCHAR(2500),@pmIdEstado VARCHAR(4),@pmFecUpdate SMALLDATETIME
 AS 
 UPDATE Trn_TraManifInt SET Fecha=@pmFecha,FecEmision=@pmFecEmision,IdOrigen=@pmIdOrigen,IdDestino=@pmIdDestino,IdVehiculo=@pmIdVehiculo,nRemolque=@pmnRemolque,IdConductor=@pmIdConductor,IdCondRelev=@pmIdCondRelev,NatCarga=@pmNatCarga,CdAduana=@pmCdAduana,CdAduanaDest=@pmCdAduanaDest,IdMoneda=@pmIdMoneda,ValorTotal=@pmValorTotal,PesoTotal=@pmPesoTotal
,NumMuc=@pmNumMuc,CdCiaMuc=@pmCdCiaMuc,Anulado=@pmAnulado,FecDev=@pmFecDev,Observacion=@pmObservacion,IdEstado=@pmIdEstado,FecUpdate=@pmFecUpdate
 WHERE TipDoc=@pmTipDoc AND Manifiesto=@pmManifiesto AND IdCia=@pmIdCia
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paInsTraManifInt] @pmTipDoc VARCHAR(3),@pmManifiesto INT,@pmIdCia CHAR(2),@pmFecha SMALLDATETIME,@pmFecEmision SMALLDATETIME,@pmIdOrigen VARCHAR(8),@pmIdDestino VARCHAR(8),@pmIdVehiculo VARCHAR(10),@pmnRemolque VARCHAR(10),@pmIdConductor VARCHAR(16),@pmIdCondRelev VARCHAR(16),@pmNatCarga VARCHAR(50),@pmCdAduana VARCHAR(4),@pmCdAduanaDest VARCHAR(4)
,@pmIdMoneda VARCHAR(5),@pmValorTotal MONEY,@pmPesoTotal DECIMAL(14,4),@pmNumMuc INT,@pmCdCiaMuc CHAR(2),@pmAnulado BIT,@pmFecDev SMALLDATETIME,@pmObservacion VARCHAR(2500),@pmIdEstado VARCHAR(4),@pmOrigenAdd VARCHAR(10),@pmTimeSys SMALLDATETIME,@pmIdCiaCrea CHAR(2),@pmIdUsuario VARCHAR(11)
 AS 
 INSERT INTO Trn_TraManifInt (TipDoc,Manifiesto,IdCia,Fecha,FecEmision,IdOrigen,IdDestino,IdVehiculo,nRemolque,IdConductor,IdCondRelev,NatCarga,CdAduana,CdAduanaDest,IdMoneda,ValorTotal,PesoTotal,NumMuc,CdCiaMuc,OrigenAdd,Anulado,FecDev,Observacion,IdEstado,TimeSys,IdCiaCrea,IdUsuario)
 VALUES (@pmTipDoc,@pmManifiesto,@pmIdCia,@pmFecha,@pmFecEmision,@pmIdOrigen,@pmIdDestino,@pmIdVehiculo,@pmnRemolque,@pmIdConductor,@pmIdCondRelev,@pmNatCarga,@pmCdAduana,@pmCdAduanaDest,@pmIdMoneda,@pmValorTotal,@pmPesoTotal,@pmNumMuc,@pmCdCiaMuc,@pmOrigenAdd,@pmAnulado,@pmFecDev,@pmObservacion,@pmIdEstado,@pmTimeSys,@pmIdCiaCrea,@pmIdUsuario)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryTraDecAduana] @pmTipDoc VARCHAR(3),@pmNumDeclara INT,@pmIdCia CHAR(2)
 AS 
 SELECT TipDoc,NumDeclara,IdCia,Fecha,FecEmision,IdOrigen,IdAduCarga,IdDestino,IdAduOrigen,IdAduDestino,IdAduFrontera,IdDeclarante,Declarante,DirDeclara,CdLocalDec,IdRemitente,Remitente,DirOrigen,CdLocalRem,IdDestinatario,Destinatario,DirDestino,CdLocalDest,IdConsig,Consignatario,DirConsig,CdLocalConsig,IdMoneda,ValorTotal,PesoTotal,DocAnexos,Vehiculos,Remolques,Manifiestos,Contenedores,Precintos,OrigenAdd,Anulado,FecDev,Observacion,IdEstado,TimeSys,FecUpdate,IdCiaCrea,IdUsuario
 FROM Trn_TraDecAduana
 WHERE TipDoc=@pmTipDoc AND NumDeclara=@pmNumDeclara AND IdCia=@pmIdCia
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paDelTraDecAduana] @pmTipDoc VARCHAR(3),@pmNumDeclara INT,@pmIdCia CHAR(2)
 AS 
 DELETE FROM Trn_TraDecAduana
 WHERE TipDoc=@pmTipDoc AND NumDeclara=@pmNumDeclara AND IdCia=@pmIdCia
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paUpTraDecAduana] @pmTipDoc VARCHAR(3),@pmNumDeclara INT,@pmIdCia CHAR(2),@pmFecha SMALLDATETIME,@pmFecEmision SMALLDATETIME,@pmIdOrigen VARCHAR(8),@pmIdAduCarga VARCHAR(4),@pmIdDestino VARCHAR(8),@pmIdAduOrigen VARCHAR(4),@pmIdAduDestino VARCHAR(4),@pmIdAduFrontera VARCHAR(4),@pmIdDeclarante VARCHAR(16),@pmDeclarante VARCHAR(150),@pmDirDeclara VARCHAR(250),@pmCdLocalDec VARCHAR(8),@pmIdRemitente VARCHAR(16),@pmRemitente VARCHAR(150),@pmDirOrigen VARCHAR(250),@pmCdLocalRem VARCHAR(8),@pmIdDestinatario VARCHAR(16),@pmDestinatario VARCHAR(150),@pmDirDestino VARCHAR(250)
,@pmCdLocalDest VARCHAR(8),@pmIdConsig VARCHAR(16),@pmConsignatario VARCHAR(150),@pmDirConsig VARCHAR(250),@pmCdLocalConsig VARCHAR(8),@pmIdMoneda VARCHAR(5),@pmValorTotal MONEY,@pmPesoTotal DECIMAL(14,4),@pmDocAnexos VARCHAR(500),@pmVehiculos VARCHAR(250),@pmRemolques VARCHAR(250),@pmManifiestos VARCHAR(100),@pmContenedores VARCHAR(500),@pmPrecintos VARCHAR(250),@pmAnulado BIT,@pmFecDev SMALLDATETIME,@pmObservacion VARCHAR(2500),@pmIdEstado VARCHAR(4),@pmFecUpdate SMALLDATETIME
 AS 
 UPDATE Trn_TraDecAduana SET Fecha=@pmFecha,FecEmision=@pmFecEmision,IdOrigen=@pmIdOrigen,IdAduCarga=@pmIdAduCarga,IdDestino=@pmIdDestino,IdAduOrigen=@pmIdAduOrigen,IdAduDestino=@pmIdAduDestino,IdAduFrontera=@pmIdAduFrontera,IdDeclarante=@pmIdDeclarante,Declarante=@pmDeclarante,DirDeclara=@pmDirDeclara,CdLocalDec=@pmCdLocalDec,IdRemitente=@pmIdRemitente,Remitente=@pmRemitente,DirOrigen=@pmDirOrigen,CdLocalRem=@pmCdLocalRem,IdDestinatario=@pmIdDestinatario,Destinatario=@pmDestinatario,DirDestino=@pmDirDestino,CdLocalDest=@pmCdLocalDest,IdConsig=@pmIdConsig,Consignatario=@pmConsignatario,DirConsig=@pmDirConsig
,CdLocalConsig=@pmCdLocalConsig,IdMoneda=@pmIdMoneda,ValorTotal=@pmValorTotal,PesoTotal=@pmPesoTotal,DocAnexos=@pmDocAnexos,Vehiculos=@pmVehiculos,Remolques=@pmRemolques,Manifiestos=@pmManifiestos,Contenedores=@pmContenedores,Precintos=@pmPrecintos,Anulado=@pmAnulado,FecDev=@pmFecDev,Observacion=@pmObservacion,IdEstado=@pmIdEstado,FecUpdate=@pmFecUpdate
 WHERE TipDoc=@pmTipDoc AND NumDeclara=@pmNumDeclara AND IdCia=@pmIdCia
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paInsTraDecAduana] @pmTipDoc VARCHAR(3),@pmNumDeclara INT,@pmIdCia CHAR(2),@pmFecha SMALLDATETIME,@pmFecEmision SMALLDATETIME,@pmIdOrigen VARCHAR(8),@pmIdAduCarga VARCHAR(4),@pmIdDestino VARCHAR(8),@pmIdAduOrigen VARCHAR(4),@pmIdAduDestino VARCHAR(4),@pmIdAduFrontera VARCHAR(4),@pmIdDeclarante VARCHAR(16),@pmDeclarante VARCHAR(150),@pmDirDeclara VARCHAR(250),@pmCdLocalDec VARCHAR(8),@pmIdRemitente VARCHAR(16),@pmRemitente VARCHAR(150),@pmDirOrigen VARCHAR(250),@pmCdLocalRem VARCHAR(8),@pmIdDestinatario VARCHAR(16),@pmDestinatario VARCHAR(150),@pmDirDestino VARCHAR(250)
,@pmCdLocalDest VARCHAR(8),@pmIdConsig VARCHAR(16),@pmConsignatario VARCHAR(150),@pmDirConsig VARCHAR(250),@pmCdLocalConsig VARCHAR(8),@pmIdMoneda VARCHAR(5),@pmValorTotal MONEY,@pmPesoTotal DECIMAL(14,4),@pmDocAnexos VARCHAR(500),@pmVehiculos VARCHAR(250),@pmRemolques VARCHAR(250),@pmManifiestos VARCHAR(100),@pmContenedores VARCHAR(500),@pmPrecintos VARCHAR(250),@pmAnulado BIT,@pmFecDev SMALLDATETIME,@pmObservacion VARCHAR(2500),@pmIdEstado VARCHAR(4),@pmOrigenAdd VARCHAR(10),@pmTimeSys SMALLDATETIME,@pmIdCiaCrea CHAR(2),@pmIdUsuario VARCHAR(11)
 AS 
 INSERT INTO Trn_TraDecAduana (TipDoc,NumDeclara,IdCia,Fecha,FecEmision,IdOrigen,IdAduCarga,IdDestino,IdAduOrigen,IdAduDestino,IdAduFrontera,IdDeclarante,Declarante,DirDeclara,CdLocalDec,IdRemitente,Remitente,DirOrigen,CdLocalRem,IdDestinatario,Destinatario,DirDestino,CdLocalDest,IdConsig,Consignatario,DirConsig,CdLocalConsig,IdMoneda,ValorTotal,PesoTotal,DocAnexos,Vehiculos,Remolques,Manifiestos,Contenedores,Precintos,OrigenAdd,Anulado,FecDev,Observacion,IdEstado,TimeSys,IdCiaCrea,IdUsuario)
 VALUES (@pmTipDoc,@pmNumDeclara,@pmIdCia,@pmFecha,@pmFecEmision,@pmIdOrigen,@pmIdAduCarga,@pmIdDestino,@pmIdAduOrigen,@pmIdAduDestino,@pmIdAduFrontera,@pmIdDeclarante,@pmDeclarante,@pmDirDeclara,@pmCdLocalDec,@pmIdRemitente,@pmRemitente,@pmDirOrigen,@pmCdLocalRem,@pmIdDestinatario,@pmDestinatario,@pmDirDestino,@pmCdLocalDest,@pmIdConsig,@pmConsignatario,@pmDirConsig,@pmCdLocalConsig,@pmIdMoneda,@pmValorTotal,@pmPesoTotal,@pmDocAnexos,@pmVehiculos,@pmRemolques,@pmManifiestos,@pmContenedores,@pmPrecintos,@pmOrigenAdd,@pmAnulado,@pmFecDev,@pmObservacion,@pmIdEstado,@pmTimeSys,@pmIdCiaCrea,@pmIdUsuario)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paDelTraPorteInt] @pmTipDoc VARCHAR(3),@pmNumOrden INT,@pmIdCia CHAR(2)
 AS 
 DELETE FROM Trn_TraPorteInt
 WHERE TipDoc=@pmTipDoc AND NumOrden=@pmNumOrden AND IdCia=@pmIdCia
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paInsTraPorteInt] @pmTipDoc VARCHAR(3),@pmNumOrden INT,@pmIdCia CHAR(2),@pmFecha SMALLDATETIME,@pmFecEmision SMALLDATETIME,@pmFecCargue SMALLDATETIME,@pmFecEntrega SMALLDATETIME,@pmIdOrigen VARCHAR(8),@pmIdDestino VARCHAR(8),@pmIdNotificado VARCHAR(16),@pmNotificado VARCHAR(150),@pmIdRemitente VARCHAR(16),@pmRemitente VARCHAR(150),@pmDirOrigen VARCHAR(250)
,@pmIdDestinatario VARCHAR(16),@pmDestinatario VARCHAR(150),@pmDirDestino VARCHAR(250),@pmIdConsig VARCHAR(16),@pmConsignatario VARCHAR(150),@pmDirConsig VARCHAR(250),@pmInsTransporte VARCHAR(1000),@pmDocRemitente VARCHAR(500),@pmIdMoneda VARCHAR(5),@pmValorTotal MONEY,@pmPesoTotal DECIMAL(14,4),@pmManifiesto INT,@pmCdCiaManif CHAR(2),@pmAnulado BIT,@pmFecDev SMALLDATETIME
,@pmObservacion VARCHAR(2500),@pmIdEstado VARCHAR(4),@pmOrigenAdd VARCHAR(10),@pmTimeSys SMALLDATETIME,@pmIdCiaCrea CHAR(2),@pmIdUsuario VARCHAR(11)
 AS 
 INSERT INTO Trn_TraPorteInt (TipDoc,NumOrden,IdCia,Fecha,FecEmision,FecCargue,FecEntrega,IdOrigen,IdDestino,IdNotificado,Notificado,IdRemitente,Remitente,DirOrigen,IdDestinatario,Destinatario,DirDestino,IdConsig,Consignatario,DirConsig,InsTransporte,DocRemitente,IdMoneda,ValorTotal,PesoTotal,Manifiesto,CdCiaManif,OrigenAdd,Anulado,FecDev,Observacion,IdEstado,TimeSys,IdCiaCrea,IdUsuario)
 VALUES (@pmTipDoc,@pmNumOrden,@pmIdCia,@pmFecha,@pmFecEmision,@pmFecCargue,@pmFecEntrega,@pmIdOrigen,@pmIdDestino,@pmIdNotificado,@pmNotificado,@pmIdRemitente,@pmRemitente,@pmDirOrigen,@pmIdDestinatario,@pmDestinatario,@pmDirDestino,@pmIdConsig,@pmConsignatario,@pmDirConsig,@pmInsTransporte,@pmDocRemitente,@pmIdMoneda,@pmValorTotal,@pmPesoTotal,@pmManifiesto,@pmCdCiaManif,@pmOrigenAdd
,@pmAnulado,@pmFecDev,@pmObservacion,@pmIdEstado,@pmTimeSys,@pmIdCiaCrea,@pmIdUsuario)
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paUpTraPorteInt] @pmTipDoc VARCHAR(3),@pmNumOrden INT,@pmIdCia CHAR(2),@pmFecha SMALLDATETIME,@pmFecEmision SMALLDATETIME,@pmFecCargue SMALLDATETIME,@pmFecEntrega SMALLDATETIME,@pmIdOrigen VARCHAR(8),@pmIdDestino VARCHAR(8),@pmIdNotificado VARCHAR(16),@pmNotificado VARCHAR(150),@pmIdRemitente VARCHAR(16),@pmRemitente VARCHAR(150),@pmDirOrigen VARCHAR(250)
,@pmIdDestinatario VARCHAR(16),@pmDestinatario VARCHAR(150),@pmDirDestino VARCHAR(250),@pmIdConsig VARCHAR(16),@pmConsignatario VARCHAR(150),@pmDirConsig VARCHAR(250),@pmInsTransporte VARCHAR(1000),@pmDocRemitente VARCHAR(500),@pmIdMoneda VARCHAR(5),@pmValorTotal MONEY,@pmPesoTotal DECIMAL(14,4),@pmManifiesto INT,@pmCdCiaManif CHAR(2),@pmAnulado BIT,@pmFecDev SMALLDATETIME
,@pmObservacion VARCHAR(2500),@pmIdEstado VARCHAR(4),@pmFecUpdate SMALLDATETIME
 AS 
 UPDATE Trn_TraPorteInt SET Fecha=@pmFecha,FecEmision=@pmFecEmision,FecCargue=@pmFecCargue,FecEntrega=@pmFecEntrega,IdOrigen=@pmIdOrigen,IdDestino=@pmIdDestino,IdNotificado=@pmIdNotificado,Notificado=@pmNotificado,IdRemitente=@pmIdRemitente,Remitente=@pmRemitente,DirOrigen=@pmDirOrigen,IdDestinatario=@pmIdDestinatario,Destinatario=@pmDestinatario,DirDestino=@pmDirDestino,IdConsig=@pmIdConsig
,Consignatario=@pmConsignatario,DirConsig=@pmDirConsig,InsTransporte=@pmInsTransporte,DocRemitente=@pmDocRemitente,IdMoneda=@pmIdMoneda,ValorTotal=@pmValorTotal,PesoTotal=@pmPesoTotal,Manifiesto=@pmManifiesto,CdCiaManif=@pmCdCiaManif,Anulado=@pmAnulado,FecDev=@pmFecDev,Observacion=@pmObservacion,IdEstado=@pmIdEstado,FecUpdate=@pmFecUpdate
 WHERE TipDoc=@pmTipDoc AND NumOrden=@pmNumOrden AND IdCia=@pmIdCia
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQryTraPorteInt] @pmTipDoc VARCHAR(3),@pmNumOrden INT,@pmIdCia CHAR(2)
 AS 
 SELECT TipDoc,NumOrden,IdCia,Fecha,FecEmision,FecCargue,FecEntrega,IdOrigen,IdDestino,IdNotificado,Notificado,IdRemitente,Remitente,DirOrigen,IdDestinatario,Destinatario,DirDestino,IdConsig,Consignatario,DirConsig,InsTransporte,DocRemitente,IdMoneda,ValorTotal,PesoTotal,Manifiesto,CdCiaManif,OrigenAdd,Anulado,FecDev,Observacion,IdEstado,TimeSys,FecUpdate,IdCiaCrea,IdUsuario
 FROM Trn_TraPorteInt
 WHERE TipDoc=@pmTipDoc AND NumOrden=@pmNumOrden AND IdCia=@pmIdCia
GO