/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspOrdenPagoLta]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paWcfSeLisTrn_TraEspOrdenPagoLta]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[paWcfSeLisTrn_TraEspOrdenPagoLta]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspLogProgramaLta]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paWcfSeLisTrn_TraEspLogProgramaLta]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[paWcfSeLisTrn_TraEspLogProgramaLta]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspLogLiquidaLta]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paWcfSeLisTrn_TraEspLogLiquidaLta]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[paWcfSeLisTrn_TraEspLogLiquidaLta]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspLogFUECLta]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paWcfSeLisTrn_TraEspLogFUECLta]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[paWcfSeLisTrn_TraEspLogFUECLta]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeInsLogTraEspSys]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paWcfSeInsLogTraEspSys]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[paWcfSeInsLogTraEspSys]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeInsLogTraEspPrograma]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paWcfSeInsLogTraEspPrograma]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[paWcfSeInsLogTraEspPrograma]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeInsLogTraEspPro]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paWcfSeInsLogTraEspPro]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[paWcfSeInsLogTraEspPro]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeInsLogTraEspOrden]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paWcfSeInsLogTraEspOrden]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[paWcfSeInsLogTraEspOrden]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeInsLogTraEspLiquida]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paWcfSeInsLogTraEspLiquida]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[paWcfSeInsLogTraEspLiquida]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeInsLogTraEspInOut]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paWcfSeInsLogTraEspInOut]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[paWcfSeInsLogTraEspInOut]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeInsLogTraEspFuec]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paWcfSeInsLogTraEspFuec]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[paWcfSeInsLogTraEspFuec]
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraTarifas]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'dataTypeLogTraTarifas' AND ss.name = N'dbo')
DROP TYPE [dbo].[dataTypeLogTraTarifas]
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspTarifas]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'dataTypeLogTraEspTarifas' AND ss.name = N'dbo')
DROP TYPE [dbo].[dataTypeLogTraEspTarifas]
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspSys]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'dataTypeLogTraEspSys' AND ss.name = N'dbo')
DROP TYPE [dbo].[dataTypeLogTraEspSys]
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspProgramaDet]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'dataTypeLogTraEspProgramaDet' AND ss.name = N'dbo')
DROP TYPE [dbo].[dataTypeLogTraEspProgramaDet]
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspPrograma]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'dataTypeLogTraEspPrograma' AND ss.name = N'dbo')
DROP TYPE [dbo].[dataTypeLogTraEspPrograma]
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspPro]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'dataTypeLogTraEspPro' AND ss.name = N'dbo')
DROP TYPE [dbo].[dataTypeLogTraEspPro]
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspOrdPagoDet]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'dataTypeLogTraEspOrdPagoDet' AND ss.name = N'dbo')
DROP TYPE [dbo].[dataTypeLogTraEspOrdPagoDet]
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspOrdenPago]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'dataTypeLogTraEspOrdenPago' AND ss.name = N'dbo')
DROP TYPE [dbo].[dataTypeLogTraEspOrdenPago]
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspLiquidaDet]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'dataTypeLogTraEspLiquidaDet' AND ss.name = N'dbo')
DROP TYPE [dbo].[dataTypeLogTraEspLiquidaDet]
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspLiquida]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'dataTypeLogTraEspLiquida' AND ss.name = N'dbo')
DROP TYPE [dbo].[dataTypeLogTraEspLiquida]
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspInOut]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'dataTypeLogTraEspInOut' AND ss.name = N'dbo')
DROP TYPE [dbo].[dataTypeLogTraEspInOut]
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspFuecDet]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'dataTypeLogTraEspFuecDet' AND ss.name = N'dbo')
DROP TYPE [dbo].[dataTypeLogTraEspFuecDet]
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspFuec]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'dataTypeLogTraEspFuec' AND ss.name = N'dbo')
DROP TYPE [dbo].[dataTypeLogTraEspFuec]
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogSys]    Script Date: 13/05/2019 14:57:46 ******/
IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'dataTypeLogSys' AND ss.name = N'dbo')
DROP TYPE [dbo].[dataTypeLogSys]
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogSys]    Script Date: 13/05/2019 14:57:46 ******/
CREATE TYPE [dbo].[dataTypeLogSys] AS TABLE(
	[IdLog] [int] NOT NULL DEFAULT ((0)),
	[TipDoc] [varchar](3) NOT NULL,
	[Documento] [int] NOT NULL DEFAULT ((0)),
	[IdCia] [char](2) NOT NULL DEFAULT ('01'),
	[Fecha] [smalldatetime] NOT NULL,
	[TimeSys] [smalldatetime] NOT NULL,
	[IdUsuario] [varchar](11) NOT NULL,
	[Nombre] [varchar](50) NOT NULL,
	[Observacion] [varchar](250) NOT NULL,
	[IdTercero] [varchar](16) NULL,
	[IdVehiculo] [varchar](10) NULL,
	[EsCom] [bit] NOT NULL DEFAULT ((0)),
	[Eliminado] [bit] NOT NULL DEFAULT ((0)),
	[Modificado] [bit] NOT NULL DEFAULT ((0)),
	[nModulo] [varchar](20) NOT NULL,
	[Dsname] [varchar](20) NULL
)
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspFuec]    Script Date: 13/05/2019 14:57:46 ******/
CREATE TYPE [dbo].[dataTypeLogTraEspFuec] AS TABLE(
	[Numero] [int] NULL,
	[Fecha] [smalldatetime] NULL,
	[TipDocPgr] [varchar](3) NULL,
	[Programa] [int] NULL,
	[IdCiaPgr] [char](2) NULL,
	[EstadoProc] [int] NULL,
	[Observacion] [varchar](250) NULL,
	[TimeSys] [smalldatetime] NULL,
	[IdUsuario] [varchar](11) NULL,
	[Nombre] [varchar](50) NULL
)
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspFuecDet]    Script Date: 13/05/2019 14:57:46 ******/
CREATE TYPE [dbo].[dataTypeLogTraEspFuecDet] AS TABLE(
	[Numero] [int] NULL,
	[Item] [int] NULL,
	[TipDocFuec] [varchar](3) NULL,
	[Fuec] [int] NULL,
	[IdCiaFuec] [char](2) NULL,
	[IdVehiculo] [varchar](10) NULL,
	[TipDocRes] [varchar](3) NULL,
	[Reservas] [int] NULL,
	[IdCiaRes] [char](2) NULL,
	[ItemRes] [int] NULL,
	[Comentarios] [varchar](max) NULL
)
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspInOut]    Script Date: 13/05/2019 14:57:46 ******/
CREATE TYPE [dbo].[dataTypeLogTraEspInOut] AS TABLE(
	[IdLog] [int] NULL,
	[IdCia] [char](2) NULL,
	[IdUsuario] [varchar](11) NULL,
	[Fecha] [smalldatetime] NULL,
	[HoraEntrada] [smalldatetime] NULL,
	[HoraSalida] [smalldatetime] NULL,
	[Finalizo] [bit] NULL,
	[Nombre] [varchar](50) NULL,
	[Dsname] [varchar](20) NULL
)
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspLiquida]    Script Date: 13/05/2019 14:57:46 ******/
CREATE TYPE [dbo].[dataTypeLogTraEspLiquida] AS TABLE(
	[Numero] [int] NULL,
	[Fecha] [smalldatetime] NULL,
	[EstadoProc] [int] NULL,
	[Observacion] [varchar](250) NULL,
	[TimeSys] [smalldatetime] NULL,
	[IdUsuario] [varchar](11) NULL,
	[Nombre] [varchar](50) NULL
)
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspLiquidaDet]    Script Date: 13/05/2019 14:57:46 ******/
CREATE TYPE [dbo].[dataTypeLogTraEspLiquidaDet] AS TABLE(
	[Numero] [int] NULL,
	[Item] [int] NULL,
	[TipDoc] [varchar](3) NULL,
	[Liquidacion] [int] NULL,
	[IdCia] [char](2) NULL,
	[FechaLiq] [smalldatetime] NULL,
	[FechaDed] [smalldatetime] NULL,
	[FechaIniOdp] [smalldatetime] NULL,
	[FechaFinOdp] [smalldatetime] NULL,
	[IdConcepto] [varchar](4) NULL,
	[CXP] [bit] NULL,
	[TipoCom] [varchar](3) NULL,
	[Comprobante] [int] NULL,
	[IdVehiculo] [varchar](10) NULL,
	[IdConductor] [varchar](16) NULL,
	[IdPoseedor] [varchar](16) NULL,
	[Causaciones] [varchar](max) NULL,
	[IdCiaCaus] [varchar](max) NULL,
	[ItemCaus] [varchar](max) NULL,
	[Odps] [varchar](max) NULL,
	[IdCiaOdps] [varchar](max) NULL,
	[OtrPagos] [varchar](max) NULL,
	[IdCiaOtrpagos] [varchar](max) NULL,
	[ItemOtros] [varchar](max) NULL,
	[VrTotalLiq] [money] NULL,
	[Comentarios] [varchar](1000) NULL
)
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspOrdenPago]    Script Date: 13/05/2019 14:57:46 ******/
CREATE TYPE [dbo].[dataTypeLogTraEspOrdenPago] AS TABLE(
	[Numero] [int] NULL,
	[Fecha] [smalldatetime] NULL,
	[EstadoProc] [int] NULL,
	[Observacion] [varchar](1000) NULL,
	[TimeSys] [smalldatetime] NULL,
	[IdUsuario] [varchar](11) NULL,
	[Nombre] [varchar](50) NULL
)
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspOrdPagoDet]    Script Date: 13/05/2019 14:57:46 ******/
CREATE TYPE [dbo].[dataTypeLogTraEspOrdPagoDet] AS TABLE(
	[Numero] [int] NULL,
	[Item] [int] NULL,
	[TipDoc] [varchar](3) NULL,
	[Orden] [int] NULL,
	[IdCia] [char](2) NULL,
	[Fecha] [smalldatetime] NULL,
	[IdConcepto] [varchar](4) NULL,
	[TipoCom] [varchar](3) NULL,
	[Comprobante] [int] NULL,
	[TipRes] [varchar](3) NULL,
	[Reserva] [int] NULL,
	[IdCiaRes] [char](2) NULL,
	[ItemRes] [int] NULL,
	[IdOrigen] [varchar](8) NULL,
	[CiuOrigen] [varchar](50) NULL,
	[IdDestino] [varchar](8) NULL,
	[CiuDestino] [varchar](50) NULL,
	[IdRuta] [varchar](4) NULL,
	[Ruta] [varchar](100) NULL,
	[IdVehiculo] [varchar](10) NULL,
	[IdConductor] [varchar](16) NULL,
	[IdPropietario] [varchar](16) NULL,
	[IdPoseedor] [varchar](16) NULL,
	[Cumplido] [int] NULL,
	[IdCiaCum] [varchar](2) NULL,
	[EstadoReg] [int] NULL,
	[VrServicio] [money] NULL,
	[VrDescuento] [money] NULL,
	[VrRetencion] [money] NULL,
	[VrReteIca] [money] NULL,
	[VrReteCREE] [money] NULL,
	[VrAnticipos] [money] NULL,
	[VrOtrosDctos] [money] NULL,
	[VrImpuestos] [money] NULL,
	[VrOtrosPagos] [money] NULL,
	[VrNeto] [money] NULL,
	[TarifaRet] [decimal](14, 4) NULL,
	[TarifaIca] [decimal](14, 4) NULL,
	[TarifaRtc] [decimal](14, 4) NULL,
	[CodTarRet] [varchar](4) NULL,
	[CodTarIca] [varchar](4) NULL,
	[CodTarRtc] [varchar](4) NULL,
	[VrConcPagos] [money] NULL,
	[VrConcDctos] [money] NULL,
	[VrConcFondo] [money] NULL,
	[VrConcSeguro] [money] NULL,
	[VrConcAporte] [money] NULL,
	[VrConcImpuesto] [money] NULL,
	[VrRecCaja] [money] NULL,
	[CdForma] [varchar](4) NULL,
	[IdCCosto] [varchar](16) NULL,
	[IdSubCos] [varchar](16) NULL,
	[VrSeguros] [money] NULL,
	[VrFondos] [money] NULL,
	[VrAportes] [money] NULL,
	[Comentarios] [varchar](1000) NULL
)
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspPro]    Script Date: 13/05/2019 14:57:46 ******/
CREATE TYPE [dbo].[dataTypeLogTraEspPro] AS TABLE(
	[IdLog] [int] NULL,
	[IdPro] [varchar](20) NULL,
	[IdCia] [char](2) NULL,
	[Fecha] [smalldatetime] NULL,
	[TimeSys] [smalldatetime] NULL,
	[IdUsuario] [varchar](11) NULL,
	[Nombre] [varchar](50) NULL,
	[NomTabla] [varchar](20) NULL,
	[Observacion] [varchar](250) NULL,
	[nModulo] [varchar](20) NULL,
	[Dsname] [varchar](20) NULL
)
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspPrograma]    Script Date: 13/05/2019 14:57:46 ******/
CREATE TYPE [dbo].[dataTypeLogTraEspPrograma] AS TABLE(
	[Numero] [int] NULL,
	[Fecha] [smalldatetime] NULL,
	[EstadoProc] [int] NULL,
	[Observacion] [varchar](250) NULL,
	[TimeSys] [smalldatetime] NULL,
	[IdUsuario] [varchar](11) NULL,
	[Nombre] [varchar](50) NULL
)
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspProgramaDet]    Script Date: 13/05/2019 14:57:46 ******/
CREATE TYPE [dbo].[dataTypeLogTraEspProgramaDet] AS TABLE(
	[Numero] [int] NULL,
	[Item] [int] NULL,
	[TipDoc] [varchar](3) NULL,
	[Programa] [int] NULL,
	[IdCia] [char](2) NULL,
	[FechaIni] [smalldatetime] NULL,
	[FechaFin] [smalldatetime] NULL,
	[IdVehiculo] [varchar](10) NULL,
	[Reservas] [int] NULL,
	[IdCiaRes] [char](2) NULL,
	[ItemRes] [int] NULL,
	[Comentarios] [varchar](max) NULL
)
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspSys]    Script Date: 13/05/2019 14:57:46 ******/
CREATE TYPE [dbo].[dataTypeLogTraEspSys] AS TABLE(
	[IdLog] [int] NULL,
	[TipDoc] [varchar](3) NULL,
	[Documento] [int] NULL,
	[IdCia] [char](2) NULL,
	[Fecha] [smalldatetime] NULL,
	[TimeSys] [smalldatetime] NULL,
	[IdUsuario] [varchar](11) NULL,
	[Nombre] [varchar](50) NULL,
	[Observacion] [varchar](250) NULL,
	[IdTercero] [varchar](16) NULL,
	[IdVehiculo] [varchar](10) NULL,
	[EsCom] [bit] NULL DEFAULT ((0)),
	[Eliminado] [bit] NULL,
	[Modificado] [bit] NULL,
	[nModulo] [varchar](20) NULL,
	[Dsname] [varchar](20) NULL
)
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraEspTarifas]    Script Date: 13/05/2019 14:57:46 ******/
CREATE TYPE [dbo].[dataTypeLogTraEspTarifas] AS TABLE(
	[TipDoc] [varchar](3) NULL,
	[Numero] [int] NULL,
	[IdCia] [char](2) NULL,
	[Item] [int] NULL,
	[Fecha] [smalldatetime] NULL,
	[CdCarga] [varchar](16) NULL,
	[DescripCarga] [varchar](250) NULL,
	[Cantidad] [decimal](14, 4) NULL,
	[PesoNeto] [decimal](14, 4) NULL,
	[TarifClie] [money] NULL,
	[TarifPago] [money] NULL,
	[VrTotal] [money] NULL,
	[IdUsuario] [varchar](11) NULL,
	[Nombre] [varchar](50) NULL
)
GO
/****** Object:  UserDefinedTableType [dbo].[dataTypeLogTraTarifas]    Script Date: 13/05/2019 14:57:46 ******/
CREATE TYPE [dbo].[dataTypeLogTraTarifas] AS TABLE(
	[TipDoc] [varchar](3) NOT NULL,
	[Numero] [int] NOT NULL,
	[IdCia] [char](2) NOT NULL,
	[Item] [int] NOT NULL,
	[Fecha] [smalldatetime] NOT NULL,
	[IdMercancia] [varchar](16) NOT NULL,
	[DescripMcias] [varchar](250) NOT NULL,
	[Cantidad] [decimal](14, 4) NOT NULL,
	[PesoNeto] [decimal](14, 4) NOT NULL,
	[Volumen] [decimal](14, 4) NOT NULL,
	[Cases] [int] NOT NULL,
	[Cajas] [int] NOT NULL,
	[Palets] [int] NOT NULL,
	[TarifClie] [money] NOT NULL,
	[TarifPago] [money] NOT NULL,
	[TarifTabla] [money] NOT NULL,
	[VrDeclarado] [money] NOT NULL,
	[VrSeguro] [money] NOT NULL,
	[TarifSeguro] [decimal](14, 4) NOT NULL,
	[UndTarifa] [varchar](10) NOT NULL,
	[TipoTarifa] [varchar](10) NOT NULL,
	[UndTarPago] [varchar](10) NOT NULL,
	[IdUsuario] [varchar](11) NOT NULL,
	[Nombre] [varchar](50) NOT NULL
)
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeInsLogTraEspFuec]    Script Date: 13/05/2019 14:57:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:	Yaqueline Lizarazo Diaz, John Jairo Roa
-- Create date(dd/MM/yyyy): 07/05/2019
-- Description:	Guardar Log de Masivo de Fuec
-- =============================================
CREATE PROCEDURE [dbo].[paWcfSeInsLogTraEspFuec]
	@LogTraEspFuec dataTypeLogTraEspFuec READONLY, --Tipo de dato definido por el usuario que representa la tabla LogTraEspFuec
	@LogTraEspFuecDet dataTypeLogTraEspFuecDet READONLY, --Tipo de dato definido por el usuario que representa la tabla LogTraEspFuecDet
	@operacion varchar(1)
AS
	BEGIN TRAN
		BEGIN TRY
			
			DECLARE @num INT
			SELECT @num = Count(*) + 1 FROM LogTraEspFuec

			IF(@operacion = 'i')
			BEGIN
				IF(EXISTS(SELECT TOP 1 * FROM @LogTraEspFuec))
				BEGIN 
					INSERT INTO LogTraEspFuec(
					Numero, Fecha, TipDocPgr, Programa, IdCiaPgr, EstadoProc, Observacion, TimeSys, IdUsuario, Nombre
					)
					SELECT			
					@num,Fecha, TipDocPgr, Programa, IdCiaPgr, EstadoProc, Observacion, TimeSys, IdUsuario, Nombre
					FROM @LogTraEspFuec
				END

				IF(EXISTS(SELECT TOP 1 * FROM @LogTraEspFuecDet))
				BEGIN 
					INSERT INTO LogTraEspFuecDet(
					Numero, Item, TipDocFuec, Fuec, IdCiaFuec, IdVehiculo, TipDocRes, Reservas, IdCiaRes, ItemRes, Comentarios
					)
					SELECT			
					@num,Item, TipDocFuec, Fuec, IdCiaFuec, IdVehiculo, TipDocRes, Reservas, IdCiaRes, ItemRes, Comentarios
					FROM @LogTraEspFuecDet 
				END
			END

			SELECT '1'

		COMMIT TRAN
		END TRY
		BEGIN CATCH
		ROLLBACK TRAN
		DECLARE @ErrorMessage NVARCHAR(4000);
        DECLARE @ErrorSeverity INT;
        DECLARE @ErrorState INT;

		SELECT 
		@ErrorMessage = ERROR_MESSAGE(),
		@ErrorSeverity = ERROR_SEVERITY(),
		@ErrorState = ERROR_STATE();
		RAISERROR (
		@ErrorMessage, -- Message text.
		@ErrorSeverity, -- Severity.
		@ErrorState -- State.
		);
		END CATCH
RETURN 0




GO
/****** Object:  StoredProcedure [dbo].[paWcfSeInsLogTraEspInOut]    Script Date: 13/05/2019 14:57:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:	Joe Alexander Núñez Yaguna
-- Create date(dd/MM/yyyy): 27/10/2016
-- Description:	Guardar LogTraEspInOut
-- =============================================
CREATE PROCEDURE [dbo].[paWcfSeInsLogTraEspInOut]
	@LogTraEspInOut dataTypeLogTraEspInOut READONLY, --Tipo de dato definido por el usuario que representa la tabla LogTraEspInOut
	@operacion varchar(1)
AS
	BEGIN TRAN
		BEGIN TRY

		DECLARE @num INT 
		SELECT @num = Count(*) FROM LogTraEspInOut WHERE IdUsuario = (SELECT TOP 1 IdUsuario FROM @LogTraEspInOut) AND IdCia = (SELECT TOP 1 IdCia FROM @LogTraEspInOut)

		if(@operacion = 'i')
		begin
			INSERT INTO LogTraEspInOut(
			IdLog,IdCia,IdUsuario,Fecha,HoraEntrada,HoraSalida,Finalizo,Nombre,Dsname
			)
			SELECT			
			(@num + IdLog),IdCia,IdUsuario,Fecha,HoraEntrada,HoraSalida,Finalizo,Nombre,Dsname
			FROM @LogTraEspInOut
		end

		if(@operacion = 'u')
		begin
			update LogTraEspInOut
			set 			
			HoraSalida = t2.HoraSalida,Finalizo = t2.Finalizo
			from LogTraEspInOut	t1
			join @LogTraEspInOut t2 on t1.IdLog = t2.IdLog and t1.IdCia = t2.IdCia and t1.IdUsuario = t2.IdUsuario
		end

		SELECT	(@num + (select idlog from @LogTraEspInOut)) 

		COMMIT TRAN
		END TRY
		BEGIN CATCH
		ROLLBACK TRAN
		DECLARE @ErrorMessage NVARCHAR(4000);
        DECLARE @ErrorSeverity INT;
        DECLARE @ErrorState INT;

		SELECT 
		@ErrorMessage = ERROR_MESSAGE(),
		@ErrorSeverity = ERROR_SEVERITY(),
		@ErrorState = ERROR_STATE();
		RAISERROR (
		@ErrorMessage, -- Message text.
		@ErrorSeverity, -- Severity.
		@ErrorState -- State.
		);
		END CATCH
RETURN 0

GO
/****** Object:  StoredProcedure [dbo].[paWcfSeInsLogTraEspLiquida]    Script Date: 13/05/2019 14:57:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:	Joe Alexander Núñez Yaguna
-- Create date(dd/MM/yyyy): 10/11/2017
-- Description:	Guardar Log de Masivo de Liquidación de Ordenes de Pago, se guardan la LQE
-- =============================================
CREATE PROCEDURE [dbo].[paWcfSeInsLogTraEspLiquida]
	@LogTraEspLiquida dataTypeLogTraEspLiquida READONLY, --Tipo de dato definido por el usuario que representa la tabla LogTraEspSys
	@LogTraEspLiquidaDet dataTypeLogTraEspLiquidaDet READONLY, --Tipo de dato definido por el usuario que representa la tabla LogTraEspTarifas
	@operacion varchar(1)
AS
	BEGIN TRAN
		BEGIN TRY
			
			DECLARE @num INT
			SELECT @num = Count(*) + 1 FROM LogTraEspLiquida

			IF(@operacion = 'i')
			BEGIN
				IF(EXISTS(SELECT TOP 1 * FROM @LogTraEspLiquida))
				BEGIN 
					INSERT INTO LogTraEspLiquida(
					Numero,Fecha,EstadoProc,Observacion,TimeSys,IdUsuario,Nombre
					)
					SELECT			
					@num,Fecha,EstadoProc,Observacion,TimeSys,IdUsuario,Nombre
					FROM @LogTraEspLiquida
				END

				IF(EXISTS(SELECT TOP 1 * FROM @LogTraEspLiquidaDet))
				BEGIN 
					INSERT INTO LogTraEspLiquidaDet(
					Numero,Item,TipDoc,Liquidacion,IdCia,FechaLiq,FechaDed,FechaIniOdp,FechaFinOdp,IdConcepto,
					CXP,TipoCom,Comprobante,IdVehiculo,IdConductor,IdPoseedor,Causaciones,IdCiaCaus,ItemCaus,Odps,IdCiaOdps,
					OtrPagos,IdCiaOtrpagos,ItemOtros,VrTotalLiq,Comentarios
					)
					SELECT			
					@num,Item,TipDoc,Liquidacion,IdCia,FechaLiq,FechaDed,FechaIniOdp,FechaFinOdp,IdConcepto,
					CXP,TipoCom,Comprobante,IdVehiculo,IdConductor,IdPoseedor,Causaciones,IdCiaCaus,ItemCaus,Odps,IdCiaOdps,
					OtrPagos,IdCiaOtrpagos,ItemOtros,VrTotalLiq,Comentarios
					FROM @LogTraEspLiquidaDet
				END
			END

			SELECT '1'

		COMMIT TRAN
		END TRY
		BEGIN CATCH
		ROLLBACK TRAN
		DECLARE @ErrorMessage NVARCHAR(4000);
        DECLARE @ErrorSeverity INT;
        DECLARE @ErrorState INT;

		SELECT 
		@ErrorMessage = ERROR_MESSAGE(),
		@ErrorSeverity = ERROR_SEVERITY(),
		@ErrorState = ERROR_STATE();
		RAISERROR (
		@ErrorMessage, -- Message text.
		@ErrorSeverity, -- Severity.
		@ErrorState -- State.
		);
		END CATCH
RETURN 0



GO
/****** Object:  StoredProcedure [dbo].[paWcfSeInsLogTraEspOrden]    Script Date: 13/05/2019 14:57:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:	Joe Alexander Núñez Yaguna
-- Create date(dd/MM/yyyy): 26/10/2017
-- Description:	Guardar Log de Masivo de Liquidación de Reservas, se generan las Ordenes de Pago
-- =============================================
CREATE PROCEDURE [dbo].[paWcfSeInsLogTraEspOrden]
	@LogTraEspOrden dataTypeLogTraEspOrdenPago READONLY, --Tipo de dato definido por el usuario que representa la tabla LogTraEspSys
	@LogTraEspOrdenDet dataTypeLogTraEspOrdPagoDet READONLY, --Tipo de dato definido por el usuario que representa la tabla LogTraEspTarifas
	@operacion varchar(1)
AS
	BEGIN TRAN
		BEGIN TRY
			
			DECLARE @numcursor INT
			DECLARE @num INT
			SELECT @num = Count(*) + 1 FROM LogTraEspOrdenPago
			
			DECLARE ordencursor CURSOR
			FOR SELECT Numero FROM @LogTraEspOrden
			OPEN ordencursor
			FETCH NEXT FROM ordencursor INTO @numcursor
			WHILE @@FETCH_STATUS = 0
			BEGIN

				IF(@operacion = 'i')
				BEGIN
					IF(EXISTS(SELECT TOP 1 * FROM @LogTraEspOrden))
					BEGIN 
						INSERT INTO LogTraEspOrdenPago(
						Numero, Fecha, EstadoProc, Observacion, TimeSys, IdUsuario, Nombre
						)
						SELECT			
						@num, Fecha, EstadoProc, Observacion, TimeSys, IdUsuario, Nombre
						FROM @LogTraEspOrden where Numero = @numcursor
					END

					IF(EXISTS(SELECT TOP 1 * FROM @LogTraEspOrdenDet))
					BEGIN 
						INSERT INTO LogTraEspOrdPagoDet(
						Numero,Item,TipDoc,Orden,IdCia,Fecha,IdConcepto,TipoCom,Comprobante,TipRes,Reserva,IdCiaRes,
						ItemRes,IdOrigen,CiuOrigen,IdDestino,CiuDestino,IdRuta,Ruta,IdVehiculo,IdConductor,IdPropietario,
						IdPoseedor,Cumplido,IdCiaCum,EstadoReg,VrServicio,VrDescuento,VrRetencion,VrReteIca,VrReteCREE,VrAnticipos,VrOtrosDctos,VrImpuestos,
						VrOtrosPagos,VrNeto,TarifaRet,TarifaIca,TarifaRtc,CodTarRet,CodTarIca,CodTarRtc,VrConcPagos,VrConcDctos,
						VrConcFondo,VrConcSeguro,VrConcAporte,VrConcImpuesto,VrRecCaja,CdForma,IdCCosto,IdSubCos,VrSeguros,VrFondos,
						VrAportes,Comentarios
						)
						SELECT			
						@num, Item,TipDoc,Orden,IdCia,Fecha,IdConcepto,TipoCom,Comprobante,TipRes,Reserva,IdCiaRes,
						ItemRes,IdOrigen,CiuOrigen,IdDestino,CiuDestino,IdRuta,Ruta,IdVehiculo,IdConductor,IdPropietario,
						IdPoseedor,Cumplido,IdCiaCum,1,VrServicio,VrDescuento,VrRetencion,VrReteIca,VrReteCREE,VrAnticipos,VrOtrosDctos,VrImpuestos,
						VrOtrosPagos,VrNeto,TarifaRet,TarifaIca,TarifaRtc,CodTarRet,CodTarIca,CodTarRtc,VrConcPagos,VrConcDctos,
						VrConcFondo,VrConcSeguro,VrConcAporte,VrConcImpuesto,VrRecCaja,CdForma,IdCCosto,IdSubCos,VrSeguros,VrFondos,
						VrAportes,Comentarios
						FROM @LogTraEspOrdenDet where Numero = @numcursor
					END
				END

			FETCH NEXT FROM ordencursor INTO @numcursor
			END
			CLOSE ordencursor
			DEALLOCATE ordencursor

			SELECT '1'

		COMMIT TRAN
		END TRY
		BEGIN CATCH
		ROLLBACK TRAN
		DECLARE @ErrorMessage NVARCHAR(4000);
        DECLARE @ErrorSeverity INT;
        DECLARE @ErrorState INT;

		SELECT 
		@ErrorMessage = ERROR_MESSAGE(),
		@ErrorSeverity = ERROR_SEVERITY(),
		@ErrorState = ERROR_STATE();
		RAISERROR (
		@ErrorMessage, -- Message text.
		@ErrorSeverity, -- Severity.
		@ErrorState -- State.
		);
		END CATCH
RETURN 0



GO
/****** Object:  StoredProcedure [dbo].[paWcfSeInsLogTraEspPro]    Script Date: 13/05/2019 14:57:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:	Joe Alexander Núñez Yaguna
-- Create date(dd/MM/yyyy): 28/10/2016
-- Description:	Guardar LogTraEspPro
-- =============================================
CREATE PROCEDURE [dbo].[paWcfSeInsLogTraEspPro]
	@LogTraEspPro dataTypeLogTraEspPro READONLY, --Tipo de dato definido por el usuario que representa la tabla LogTraEspPro
	@operacion varchar(1)
AS
	BEGIN TRAN
		BEGIN TRY

		DECLARE @num INT 
		SELECT @num = Count(*) FROM LogTraEspPro WHERE IdCia = (SELECT TOP 1 IdCia FROM @LogTraEspPro)
		--IdUsuario = (SELECT TOP 1 IdUsuario FROM @LogTraEspPro) AND IdCia = (SELECT TOP 1 IdCia FROM @LogTraEspPro)

		if(@operacion = 'i')
		begin
			INSERT INTO LogTraEspPro(
			IdLog,IdPro,IdCia,Fecha,TimeSys,IdUsuario,Nombre,NomTabla,Observacion,nModulo,Dsname
			)
			SELECT			
			(@num + IdLog),IdPro,IdCia,Fecha,TimeSys,IdUsuario,Nombre,NomTabla,Observacion,nModulo,Dsname
			FROM @LogTraEspPro
		end


		SELECT	(@num + (select idlog from @LogTraEspPro)) 

		COMMIT TRAN
		END TRY
		BEGIN CATCH
		ROLLBACK TRAN
		DECLARE @ErrorMessage NVARCHAR(4000);
        DECLARE @ErrorSeverity INT;
        DECLARE @ErrorState INT;

		SELECT 
		@ErrorMessage = ERROR_MESSAGE(),
		@ErrorSeverity = ERROR_SEVERITY(),
		@ErrorState = ERROR_STATE();
		RAISERROR (
		@ErrorMessage, -- Message text.
		@ErrorSeverity, -- Severity.
		@ErrorState -- State.
		);
		END CATCH
RETURN 0

GO
/****** Object:  StoredProcedure [dbo].[paWcfSeInsLogTraEspPrograma]    Script Date: 13/05/2019 14:57:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:	Joe Alexander Núñez Yaguna
-- Create date(dd/MM/yyyy): 21/12/2017
-- Description:	Guardar Log de Masivo de Programa de Vehiculos
-- =============================================
CREATE PROCEDURE [dbo].[paWcfSeInsLogTraEspPrograma]
	@LogTraEspPrograma dataTypeLogTraEspPrograma READONLY, --Tipo de dato definido por el usuario que representa la tabla LogTraEspSys
	@LogTraEspProgramaDet dataTypeLogTraEspProgramaDet READONLY, --Tipo de dato definido por el usuario que representa la tabla LogTraEspTarifas
	@operacion varchar(1)
AS
	BEGIN TRAN
		BEGIN TRY
			
			DECLARE @num INT
			SELECT @num = Count(*) + 1 FROM LogTraEspPrograma

			IF(@operacion = 'i')
			BEGIN
				IF(EXISTS(SELECT TOP 1 * FROM @LogTraEspPrograma))
				BEGIN 
					INSERT INTO LogTraEspPrograma(
					Numero,Fecha,EstadoProc,Observacion,TimeSys,IdUsuario,Nombre
					)
					SELECT			
					@num,Fecha,EstadoProc,Observacion,TimeSys,IdUsuario,Nombre
					FROM @LogTraEspPrograma
				END

				IF(EXISTS(SELECT TOP 1 * FROM @LogTraEspProgramaDet))
				BEGIN 
					INSERT INTO LogTraEspProgramaDet(
					Numero,Item,TipDoc,Programa,IdCia,FechaIni,FechaFin,IdVehiculo,Reservas,IdCiaRes,ItemRes,Comentarios
					)
					SELECT			
					@num,Item,TipDoc,Programa,IdCia,FechaIni,FechaFin,IdVehiculo,Reservas,IdCiaRes,ItemRes,Comentarios
					FROM @LogTraEspProgramaDet
				END
			END

			SELECT '1'

		COMMIT TRAN
		END TRY
		BEGIN CATCH
		ROLLBACK TRAN
		DECLARE @ErrorMessage NVARCHAR(4000);
        DECLARE @ErrorSeverity INT;
        DECLARE @ErrorState INT;

		SELECT 
		@ErrorMessage = ERROR_MESSAGE(),
		@ErrorSeverity = ERROR_SEVERITY(),
		@ErrorState = ERROR_STATE();
		RAISERROR (
		@ErrorMessage, -- Message text.
		@ErrorSeverity, -- Severity.
		@ErrorState -- State.
		);
		END CATCH
RETURN 0



GO
/****** Object:  StoredProcedure [dbo].[paWcfSeInsLogTraEspSys]    Script Date: 13/05/2019 14:57:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:	Joe Alexander Núñez Yaguna
-- Create date(dd/MM/yyyy): 26/10/2016
-- Description:	Guardar LogTraEspSys
-- =============================================
CREATE PROCEDURE [dbo].[paWcfSeInsLogTraEspSys]
	@LogTraEspSys dataTypeLogTraEspSys READONLY, --Tipo de dato definido por el usuario que representa la tabla LogTraEspSys
	@LogTraEspTarifas dataTypeLogTraEspTarifas READONLY, --Tipo de dato definido por el usuario que representa la tabla LogTraEspTarifas
	@operacion varchar(1)
AS
	BEGIN TRAN
		BEGIN TRY

		DECLARE @num INT 
		SELECT @num = Count(*) FROM LogTraEspSys WHERE TipDoc = (SELECT TOP 1 TipDoc FROM @LogTraEspSys) AND Documento = (SELECT TOP 1 Documento FROM @LogTraEspSys) AND IdCia = (SELECT TOP 1 IdCia FROM @LogTraEspSys)

		IF(@operacion = 'i')
		BEGIN
			INSERT INTO LogTraEspSys(
			IdLog,TipDoc,Documento,IdCia,Fecha,TimeSys,IdUsuario,Nombre,Observacion,IdTercero,
			IdVehiculo,EsCom,Eliminado,Modificado,nModulo,Dsname
			)
			SELECT			
			(@num + IdLog),TipDoc,Documento,IdCia,Fecha,TimeSys,IdUsuario,Nombre,Observacion,IdTercero,
			IdVehiculo,EsCom,Eliminado,Modificado,nModulo,Dsname		
			FROM @LogTraEspSys

			IF(EXISTS(SELECT TOP 1 * FROM @LogTraEspTarifas))
			BEGIN 
				INSERT INTO LogTraEspTarifas(
				TipDoc,Numero,IdCia,Item,Fecha,CdCarga,DescripCarga,Cantidad,PesoNeto,TarifClie,TarifPago,
				VrTotal,IdUsuario,Nombre
				)
				SELECT			
				TipDoc,Numero,IdCia,Item,Fecha,CdCarga,DescripCarga,Cantidad,PesoNeto,TarifClie,TarifPago,
				VrTotal,IdUsuario,Nombre	
				FROM @LogTraEspTarifas
			END
		END

		select '1'

		COMMIT TRAN
		END TRY
		BEGIN CATCH
		ROLLBACK TRAN
		DECLARE @ErrorMessage NVARCHAR(4000);
        DECLARE @ErrorSeverity INT;
        DECLARE @ErrorState INT;

		SELECT 
		@ErrorMessage = ERROR_MESSAGE(),
		@ErrorSeverity = ERROR_SEVERITY(),
		@ErrorState = ERROR_STATE();
		RAISERROR (
		@ErrorMessage, -- Message text.
		@ErrorSeverity, -- Severity.
		@ErrorState -- State.
		);
		END CATCH
RETURN 0

GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspLogFUECLta]    Script Date: 13/05/2019 14:57:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:	John Jairo Roa
-- Create date(dd/MM/yyyy): 06/05/2019
-- Description:	Imprimir log de FUECS masivos para informes
-- =============================================
create PROCEDURE [dbo].[paWcfSeLisTrn_TraEspLogFUECLta]
AS
BEGIN
DECLARE @VrDef VARCHAR(1) = '1'
--Encabezado
SELECT CAST('' AS INT) AS Numero, CAST('' AS DATETIME) AS Fecha, '' AS  TipDocPgr,  CAST('' AS INT) AS Programa, '' AS IdCiaPgr, 
CAST('' AS INT) AS EstadoProc, '' AS Observacion, CAST('' AS DATETIME) AS TimeSys, '' AS IdUsuario, '' AS Nombre, 
CAST('' AS INT) AS Item, '' AS TipDocFuec, CAST('' AS INT) AS Fuec, '' AS IdCiaFuec, '' AS IdVehiculo, 
'' AS TipDocRes, '' AS Reservas, '' AS IdCiaRes, '' AS ItemRes, '' AS Comentarios
END

GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspLogLiquidaLta]    Script Date: 13/05/2019 14:57:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:	John Jairo Roa
-- Create date(dd/MM/yyyy): 15/11/2017
-- Description:	Imprimir log de liquidaciones de viajes masivas para informes
-- =============================================
CREATE PROCEDURE [dbo].[paWcfSeLisTrn_TraEspLogLiquidaLta]
AS
BEGIN
DECLARE @VrDef VARCHAR(1) = '1'
--Encabezado
SELECT CAST('' AS INT) AS Numero, CAST('' AS DATETIME) AS Fecha, CAST('' AS INT) AS EstadoProc, '' AS Observacion, CAST('' AS DATETIME) AS TimeSys, 
'' AS IdUsuario, '' AS Nombre, CAST('' AS INT) AS Item, '' AS TipDoc, CAST('' AS INT) AS Liquidacion, '' AS IdCia, CAST('' AS DATETIME) AS FechaLiq,
CAST('' AS DATETIME) AS FechaDed, CAST('' AS DATETIME) AS FechaIniOdp, CAST('' AS DATETIME) AS FechaFinOdp, '' AS IdConcepto, CAST('' AS BIT) AS CXP,
'' AS TipoCom, CAST('' AS INT) AS Comprobante, '' AS IdVehiculo, '' AS IdConductor, '' AS IdPoseedor, '' AS Causaciones, '' AS IdCiaCaus,
'' AS ItemCaus,  '' AS Odps, '' AS IdCiaOdps,  '' AS OtrPagos, '' AS IdCiaOtrpagos, '' AS ItemOtros, CAST('' AS MONEY) AS VrTotalLiq, '' AS Comentario
END

GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspLogProgramaLta]    Script Date: 13/05/2019 14:57:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:	John Jairo Roa
-- Create date(dd/MM/yyyy): 26/12/2017
-- Description:	Imprimir log de programaciones de viajes masivas para informes
-- =============================================
CREATE PROCEDURE [dbo].[paWcfSeLisTrn_TraEspLogProgramaLta]
AS
BEGIN
DECLARE @VrDef VARCHAR(1) = '1'
--Encabezado
SELECT CAST('' AS INT) AS Numero, CAST('' AS DATETIME) AS Fecha, CAST('' AS INT) AS EstadoProc, '' AS Observacion, CAST('' AS DATETIME) AS TimeSys, 
'' AS IdUsuario, '' AS Nombre, CAST('' AS INT) AS Item, '' AS TipDoc, CAST('' AS INT) AS Programa, '' AS IdCia, CAST('' AS DATETIME) AS FechaIni,
CAST('' AS DATETIME) AS FechaFin, '' AS IdVehiculo, '' AS Reservas, '' AS IdCiaRes, '' AS ItemRes, '' AS Comentarios
END

GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspOrdenPagoLta]    Script Date: 13/05/2019 14:57:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:	John Jairo Roa
-- Create date(dd/MM/yyyy): 02/11/2017
-- Description:	Imprimir log de ordenes de pago de reservas masivo para informes
-- =============================================
CREATE PROCEDURE [dbo].[paWcfSeLisTrn_TraEspOrdenPagoLta]
AS
BEGIN
DECLARE @VrDef VARCHAR(1) = '1'
--Encabezado
SELECT CAST('' AS INT) AS Numero, CAST('' AS DATETIME) AS Fecha, CAST('' AS INT) AS EstadoProc, '' AS Observacion, CAST('' AS DATETIME) AS TimeSys, 
'' AS IdUsuario, '' AS Nombre, CAST('' AS INT) AS Item, '' AS TipDoc, CAST('' AS INT) AS Orden, '' AS IdCia, '' AS IdConcepto, '' AS TipoCom, 
CAST('' AS INT) AS Comprobante, '' AS TipRes, CAST('' AS INT) AS Reserva, '' AS IdCiaRes, CAST('' AS INT) AS ItemRes, '' AS IdOrigen, '' AS CiuOrigen, 
'' AS IdDestino, '' AS CiuDestino, '' AS IdRuta, '' AS Ruta, '' AS IdVehiculo, '' AS IdConductor, '' AS IdPropietario, '' AS IdPoseedor, 
CAST('' AS INT) AS Cumplido, '' AS IdCiaCum, CAST('' AS INT) AS EstadoReg, CAST('' AS MONEY) AS VrServicio, CAST('' AS MONEY) AS VrDescuento, 
CAST('' AS MONEY) AS VrRetencion, CAST('' AS MONEY) AS VrReteIca, CAST('' AS MONEY) AS VrReteCREE, CAST('' AS MONEY) AS VrAnticipos, CAST('' AS MONEY) AS VrOtrosDctos, 
CAST('' AS MONEY) AS VrImpuestos, CAST('' AS MONEY) AS VrOtrosPagos, CAST('' AS MONEY) AS VrNeto, CAST(@VrDef AS DECIMAL(14,4)) AS TarifaRet, 
CAST(@VrDef AS DECIMAL(14,4)) AS TarifaIca, CAST(@VrDef AS DECIMAL(14,4)) AS TarifaRtc, '' AS CodTarRet, '' AS CodTarIca, '' AS CodTarRtc, 
CAST('' AS MONEY) AS VrConcPagos, CAST('' AS MONEY) AS VrConcDctos, CAST('' AS MONEY) AS VrConcFondo, CAST('' AS MONEY) AS VrConcSeguro, 
CAST('' AS MONEY) AS VrConcAporte, CAST('' AS MONEY) AS VrConcImpuesto, CAST('' AS MONEY) AS VrRecCaja, '' AS CdForma, '' AS IdCCosto, '' AS IdSubCos,
 CAST('' AS MONEY) AS VrSeguros, CAST('' AS MONEY) AS VrFondos, CAST('' AS MONEY) AS VrAportes, '' AS Comentarios
END

GO