/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspOrdenPagoLta]    Script Date: 04/12/2018 7:23:49 ******/
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: 04/12/2018 7:23:49 ******/
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: 04/12/2018 7:23:49 ******/
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].[paWcfSeInsLogTraEspSys]    Script Date: 04/12/2018 7:23:49 ******/
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: 04/12/2018 7:23:49 ******/
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: 04/12/2018 7:23:49 ******/
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: 04/12/2018 7:23:49 ******/
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: 04/12/2018 7:23:49 ******/
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: 04/12/2018 7:23:49 ******/
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:  UserDefinedTableType [dbo].[dataTypeLogTraTarifas]    Script Date: 04/12/2018 7:23:49 ******/
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: 04/12/2018 7:23:49 ******/
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: 04/12/2018 7:23:49 ******/
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: 04/12/2018 7:23:49 ******/
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: 04/12/2018 7:23:49 ******/
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: 04/12/2018 7:23:49 ******/
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: 04/12/2018 7:23:49 ******/
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: 04/12/2018 7:23:49 ******/
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: 04/12/2018 7:23:49 ******/
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: 04/12/2018 7:23:49 ******/
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: 04/12/2018 7:23:49 ******/
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].[dataTypeLogSys]    Script Date: 04/12/2018 7:23:49 ******/
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: 04/12/2018 7:23:49 ******/
IF NOT 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')
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].[dataTypeLogTraEspInOut]    Script Date: 04/12/2018 7:23:49 ******/
IF NOT 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')
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: 04/12/2018 7:23:49 ******/
IF NOT 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')
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: 04/12/2018 7:23:49 ******/
IF NOT 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')
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: 04/12/2018 7:23:49 ******/
IF NOT 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')
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: 04/12/2018 7:23:49 ******/
IF NOT 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')
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: 04/12/2018 7:23:49 ******/
IF NOT 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')
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: 04/12/2018 7:23:49 ******/
IF NOT 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')
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: 04/12/2018 7:23:49 ******/
IF NOT 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')
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: 04/12/2018 7:23:49 ******/
IF NOT 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')
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: 04/12/2018 7:23:49 ******/
IF NOT 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')
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: 04/12/2018 7:23:49 ******/
IF NOT 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')
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].[paWcfSeInsLogTraEspInOut]    Script Date: 04/12/2018 7:23:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paWcfSeInsLogTraEspInOut]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[paWcfSeInsLogTraEspInOut] AS' 
END
GO
-- =============================================
-- Author:	Joe Alexander Núñez Yaguna
-- Create date(dd/MM/yyyy): 27/10/2016
-- Description:	Guardar LogTraEspInOut
-- =============================================
ALTER 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: 04/12/2018 7:23:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paWcfSeInsLogTraEspLiquida]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[paWcfSeInsLogTraEspLiquida] AS' 
END
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
-- =============================================
ALTER 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: 04/12/2018 7:23:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paWcfSeInsLogTraEspOrden]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[paWcfSeInsLogTraEspOrden] AS' 
END
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
-- =============================================
ALTER 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: 04/12/2018 7:23:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paWcfSeInsLogTraEspPro]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[paWcfSeInsLogTraEspPro] AS' 
END
GO
-- =============================================
-- Author:	Joe Alexander Núñez Yaguna
-- Create date(dd/MM/yyyy): 28/10/2016
-- Description:	Guardar LogTraEspPro
-- =============================================
ALTER 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: 04/12/2018 7:23:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paWcfSeInsLogTraEspPrograma]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[paWcfSeInsLogTraEspPrograma] AS' 
END
GO
-- =============================================
-- Author:	Joe Alexander Núñez Yaguna
-- Create date(dd/MM/yyyy): 21/12/2017
-- Description:	Guardar Log de Masivo de Programa de Vehiculos
-- =============================================
ALTER 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: 04/12/2018 7:23:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paWcfSeInsLogTraEspSys]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[paWcfSeInsLogTraEspSys] AS' 
END
GO
-- =============================================
-- Author:	Joe Alexander Núñez Yaguna
-- Create date(dd/MM/yyyy): 26/10/2016
-- Description:	Guardar LogTraEspSys
-- =============================================
ALTER 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_TraEspLogLiquidaLta]    Script Date: 04/12/2018 7:23:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paWcfSeLisTrn_TraEspLogLiquidaLta]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[paWcfSeLisTrn_TraEspLogLiquidaLta] AS' 
END
GO
-- =============================================
-- Author:	John Jairo Roa
-- Create date(dd/MM/yyyy): 15/11/2017
-- Description:	Imprimir log de liquidaciones de viajes masivas para informes
-- =============================================
ALTER 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: 04/12/2018 7:23:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paWcfSeLisTrn_TraEspLogProgramaLta]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[paWcfSeLisTrn_TraEspLogProgramaLta] AS' 
END
GO
-- =============================================
-- Author:	John Jairo Roa
-- Create date(dd/MM/yyyy): 26/12/2017
-- Description:	Imprimir log de programaciones de viajes masivas para informes
-- =============================================
ALTER 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: 04/12/2018 7:23:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paWcfSeLisTrn_TraEspOrdenPagoLta]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[paWcfSeLisTrn_TraEspOrdenPagoLta] AS' 
END
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
-- =============================================
ALTER 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