USE [dbsyscomSantur]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspOtrosPagosConSaldo]    Script Date: 02/06/2026 16:03:53 ******/
DROP PROCEDURE IF EXISTS [dbo].[paWcfSeLisTrn_TraEspOtrosPagosConSaldo]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspOrdPagoLiqViajesManual]    Script Date: 02/06/2026 16:03:53 ******/
DROP PROCEDURE IF EXISTS [dbo].[paWcfSeLisTrn_TraEspOrdPagoLiqViajesManual]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspOrdPagoConSaldo]    Script Date: 02/06/2026 16:03:53 ******/
DROP PROCEDURE IF EXISTS [dbo].[paWcfSeLisTrn_TraEspOrdPagoConSaldo]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspHeaderLiqViajesManual]    Script Date: 02/06/2026 16:03:53 ******/
DROP PROCEDURE IF EXISTS [dbo].[paWcfSeLisTrn_TraEspHeaderLiqViajesManual]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspFacturasCausaciones]    Script Date: 02/06/2026 16:03:53 ******/
DROP PROCEDURE IF EXISTS [dbo].[paWcfSeLisTrn_TraEspFacturasCausaciones]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspFacturaCausacion]    Script Date: 02/06/2026 16:03:53 ******/
DROP PROCEDURE IF EXISTS [dbo].[paWcfSeLisTrn_TraEspFacturaCausacion]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspFactcausacionFmt]    Script Date: 02/06/2026 16:03:53 ******/
DROP PROCEDURE IF EXISTS [dbo].[paWcfSeLisTrn_TraEspFactcausacionFmt]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspFactcausacionDataFmt]    Script Date: 02/06/2026 16:03:53 ******/
DROP PROCEDURE IF EXISTS [dbo].[paWcfSeLisTrn_TraEspFactcausacionDataFmt]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspDevFactcausacionFmt]    Script Date: 02/06/2026 16:03:53 ******/
DROP PROCEDURE IF EXISTS [dbo].[paWcfSeLisTrn_TraEspDevFactcausacionFmt]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspConsecutivosFacturaElectronica]    Script Date: 02/06/2026 16:03:53 ******/
DROP PROCEDURE IF EXISTS [dbo].[paWcfSeLisTrn_TraEspConsecutivosFacturaElectronica]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspCausacionesLiqViajesManual]    Script Date: 02/06/2026 16:03:53 ******/
DROP PROCEDURE IF EXISTS [dbo].[paWcfSeLisTrn_TraEspCausacionesLiqViajesManual]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspCausacionesFacturaElectronica]    Script Date: 02/06/2026 16:03:53 ******/
DROP PROCEDURE IF EXISTS [dbo].[paWcfSeLisTrn_TraEspCausacionesFacturaElectronica]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspCausacionesByFechaHasta]    Script Date: 02/06/2026 16:03:53 ******/
DROP PROCEDURE IF EXISTS [dbo].[paWcfSeLisTrn_TraEspCausacionesByFechaHasta]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspAplicacionCausacionesLiqViajesManual]    Script Date: 02/06/2026 16:03:53 ******/
DROP PROCEDURE IF EXISTS [dbo].[paWcfSeLisTrn_TraEspAplicacionCausacionesLiqViajesManual]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTm_TraEspTempCargarDetCons]    Script Date: 02/06/2026 16:03:53 ******/
DROP PROCEDURE IF EXISTS [dbo].[paWcfSeLisTm_TraEspTempCargarDetCons]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeInsTrn_TraEspFactcausacion]    Script Date: 02/06/2026 16:03:53 ******/
DROP PROCEDURE IF EXISTS [dbo].[paWcfSeInsTrn_TraEspFactcausacion]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeInsTrn_TraEspDevFactcausacion]    Script Date: 02/06/2026 16:03:53 ******/
DROP PROCEDURE IF EXISTS [dbo].[paWcfSeInsTrn_TraEspDevFactcausacion]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeInsTrn_TraEspCausacion]    Script Date: 02/06/2026 16:03:53 ******/
DROP PROCEDURE IF EXISTS [dbo].[paWcfSeInsTrn_TraEspCausacion]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeInsTrn_TraEspAnulacionFactcausacion]    Script Date: 02/06/2026 16:03:53 ******/
DROP PROCEDURE IF EXISTS [dbo].[paWcfSeInsTrn_TraEspAnulacionFactcausacion]
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeInsTrn_TraEspAnulacionFactcausacion]    Script Date: 02/06/2026 16:03:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[paWcfSeInsTrn_TraEspAnulacionFactcausacion]
(
    @TipDoc VARCHAR(3),
    @Factura INT,
    @IdCia CHAR(2)
)
AS
BEGIN
    SET NOCOUNT ON;

    BEGIN TRY
        BEGIN TRAN;

        UPDATE
            Trn_Facturas
        SET
            Anulado     = 1,
            NumDev      = 199999999,
            FecDev      = GETDATE(),
            IdEstado    = '9999',
            Observacion = 'DEV FACTURA DE CAUSACION'
        WHERE
            TipDoc = @TipDoc
            AND Factura = @Factura
            AND IdCia = @IdCia;

        UPDATE Trn_TraEspCauDetalle
        SET TipDocRef = NULL,
            DocRef = 0
        WHERE TipDocRef = @TipDoc
            AND DocRef = CONCAT(@Factura, @IdCia);

        COMMIT TRAN;
    END TRY
    BEGIN CATCH
        IF @@TRANCOUNT > 0
            ROLLBACK TRAN;

        DECLARE @ErrorMensaje NVARCHAR(4000) = ERROR_MESSAGE();
        DECLARE @ErrorNumero INT = ERROR_NUMBER();

        RAISERROR(@ErrorMensaje, 16, 1);
    END CATCH
END
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeInsTrn_TraEspCausacion]    Script Date: 02/06/2026 16:03:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[paWcfSeInsTrn_TraEspCausacion]
	@Trn_TraEspCausacion [dbo].[dataTypeTrn_TraEspCausacion] READONLY,
	@Trn_TraEspCauDetalle [dbo].[dataTypeTrn_TraEspCauDetalle] READONLY,
	@Trn_ComFactura [dbo].[dataTypeTrn_ComFactura] READONLY,
	@Trn_Comprobantes [dbo].[dataTypeTrn_Comprobantes] READONLY,
	@Trn_ComDetalle [dbo].[dataTypeTrn_ComDetalle] READONLY,
	@Trn_NiifComp [dbo].[dataTypeTrn_NiifComp] READONLY,
	@Trn_NiifDetalle [dbo].[dataTypeNiifDetalle] READONLY,
	@operacion [varchar](1)
WITH EXECUTE AS CALLER
AS
	DECLARE @Comprobante INT = 0 --Esta variable guarda el número consecutivo del comprobante
	DECLARE @TipComp VARCHAR(3) = '0' --Esta variable guarda el tipo de comprobante
	DECLARE @IdCiaComp VARCHAR(4) = '00' --Esta variable guarda la compañia del comprobante

	DECLARE @CompNiif INT = 0 --Esta variable guarda el número consecutivo del comprobante Niif
	DECLARE @TipCompNiif VARCHAR(3) = '0' --Esta variable guarda el tipo de comprobante Niif
	DECLARE @IdCiaCompNiif VARCHAR(4) = '00'--Esta variable guarda la compañia del comprobante Niif

	DECLARE @CompFis INT = 0 --Esta variable guarda el número consecutivo de comprobante Fiscal
	DECLARE @TipCompFis VARCHAR(3)  = '0' --Esta variable guarda el tipo de comprobante Fiscal
	DECLARE @IdCiaCompFis VARCHAR(4) = '00' --Esta variable guarda la compañia del comprobante Fiscal

	DECLARE @TipDoc VARCHAR(3) --En esta variable se guarda el consecutivo del documento aprobación
	DECLARE @Cia VARCHAR(2) --En esta variable se guarda el consecutivo del documento aprobación
	DECLARE @Numero INT --En esta variable se guarda el consecutivo del documento aprobación
	
	BEGIN TRAN
	BEGIN TRY		 
		
		IF(@operacion = 'i')
		BEGIN
		SELECT TOP 1 @TipDoc = TipDoc, @Cia = IdCia, @IdCiaComp = IdCia, @IdCiaCompNiif = IdCia, @IdCiaCompFis = IdCia FROM @Trn_TraEspCausacion
		SELECT @Numero = Numero + 1  FROM TiposDocCons where IdDoc = @TipDoc AND IdCia = @Cia

		IF(@Numero > 0)
			UPDATE TiposDocCons SET Numero = @Numero WHERE IdDoc = @TipDoc AND IdCia = @Cia
		ELSE
		BEGIN
			SELECT @Numero = 1
			INSERT INTO TiposDocCons VALUES (@TipDoc,@Cia,0,0,0,0,NULL,'',@Numero,0,0,'','',1,1,1,0,1,CURRENT_TIMESTAMP,null,null,null,null)
		END

		IF(EXISTS(SELECT * FROM @Trn_Comprobantes))
		BEGIN
			SELECT TOP 1 @TipComp = TipCom FROM @Trn_Comprobantes
			SELECT @Comprobante = Numero + 1  FROM TiposComCons where IdCom  = @TipComp AND IdCia = @IdCiaComp
			--UPDATE TiposComCons SET Numero = @Comprobante WHERE IdCom = @TipComp AND IdCia = @IdCiaComp
			IF(@Comprobante <> '')
				UPDATE TiposComCons SET Numero = @Comprobante WHERE IdCom = @TipComp and IdCia = @IdCiaComp
			ELSE
			BEGIN
				SELECT @Comprobante = 1
				INSERT INTO TiposComCons VALUES (@TipComp,@IdCiaComp,0,0,@Comprobante,0,'','',1,1,1,0,1,CURRENT_TIMESTAMP,null,null)
			END
		END

		IF(EXISTS(SELECT * FROM @Trn_NiifComp WHERE TipoNiif = 'NIIF'))
		BEGIN
			SELECT TOP 1 @TipCompNiif = TipCom FROM @Trn_NiifComp WHERE TipoNiif = 'NIIF'
			SELECT @CompNiif = Numero + 1  FROM TiposComCons where IdCom  = @TipCompNiif AND IdCia = @IdCiaCompNiif
			--UPDATE TiposComCons SET Numero = @CompNiif WHERE IdCom = @TipCompNiif AND IdCia = @IdCiaCompNiif
			IF(@CompNiif <> '')
				UPDATE TiposComCons SET Numero = @CompNiif WHERE IdCom = @TipCompNiif and IdCia = @IdCiaCompNiif
			ELSE
			BEGIN
				SELECT @CompNiif = 1
				INSERT INTO TiposComCons VALUES (@TipCompNiif,@IdCiaCompNiif,0,0,@CompNiif,0,'','',1,1,1,0,1,CURRENT_TIMESTAMP,null,null)
			END
		END

		IF(EXISTS(SELECT * FROM @Trn_NiifComp WHERE TipoNiif = 'FISCAL'))
		BEGIN
			SELECT TOP 1 @TipCompFis = TipCom FROM @Trn_NiifComp WHERE TipoNiif = 'FISCAL'
			SELECT @CompFis = Numero + 1  FROM TiposComCons where IdCom  = @TipCompFis AND IdCia = @IdCiaCompFis
			--UPDATE TiposComCons SET Numero = @CompFis WHERE IdCom = @TipCompFis AND IdCia = @IdCiaCompFis
			IF(@CompNiif <> '')
				UPDATE TiposComCons SET Numero = @CompFis WHERE IdCom = @TipCompFis and IdCia = @IdCiaCompFis
			ELSE
			BEGIN
				SELECT @CompFis = 1
				INSERT INTO TiposComCons VALUES (@TipCompFis,@IdCiaCompFis,0,0,@CompFis,0,'','',1,1,1,0,1,CURRENT_TIMESTAMP,null,null)
			END
		END
		END

		IF(@operacion = 'i')
		begin
			IF(EXISTS(SELECT * FROM @Trn_TraEspCausacion))
			BEGIN
			INSERT INTO Trn_TraEspCausacion(
			TipDoc,Causacion,IdCia,Fecha,IdConcepto,IdProv,Factura,VrTotal,VrOtros,VrNeto,
			TipCom,Comprobante,IdCiaCom,Anulado,NumDev,FecDev,Observacion,IdEstado,OrigenAdd,
			TimeSys,FecUpdate,IdCiaCrea,IdUsuario
			)
			SELECT 
			@TipDoc,@Numero,@Cia,Fecha,IdConcepto,IdProv,Factura,VrTotal,VrOtros,VrNeto,
			@TipComp, @Comprobante, @IdCiaComp,Anulado,NumDev,FecDev,Observacion,IdEstado,OrigenAdd,
			TimeSys,FecUpdate,IdCiaCrea,IdUsuario
			FROM @Trn_TraEspCausacion
			END 

			IF(EXISTS(SELECT * FROM @Trn_TraEspCauDetalle))
			BEGIN
			INSERT INTO Trn_TraEspCauDetalle(
			TipDoc,Causacion,IdCia,Item,IdConcepto,Descripcion,TipoConc,VrDebito,VrCredito,CdCuenta,
			NitTercero,CdCCosto,CdSubCos,pVehiculo,TipoAfiVehic,VrBase,TarifBase,Referencia,TipDocRef,DocRef,
			TipFac,Factura,IdCiaFac,ItemFac,FecVence,EstadoReg,TipoLiq,NumLiquida,CiaLiquida,VrAbonado, FactElec
			)
			SELECT 
			@TipDoc,@Numero,@Cia,Item,IdConcepto,Descripcion,TipoConc,VrDebito,VrCredito,CdCuenta,
			NitTercero,CdCCosto,CdSubCos,pVehiculo,TipoAfiVehic,VrBase,TarifBase,Referencia,TipDocRef,DocRef,
			TipFac,Factura,IdCiaFac,ItemFac,FecVence,EstadoReg,TipoLiq,NumLiquida,CiaLiquida,VrAbonado, FactElec
			FROM @Trn_TraEspCauDetalle
			END 

			IF(EXISTS(SELECT * FROM @Trn_ComFactura))
			BEGIN
			INSERT INTO Trn_ComFactura(
			TipFac,Factura,IdCia,Item,IdProveedor,IdCuenta,TipDoc,Documento,IdCiaDoc,FecEmision,FecVence,
			VrFactura,VrAbonado,TipCom,Comprobante,ItemCom,Referencia,Detalle,pVehiculo,VehPropio,TipRef,
			DocRef,IdCiaRef,EstadoApr,MontoAProb
			)
			SELECT 
			TipFac,Factura,@Cia,Item,IdProveedor,IdCuenta,@TipDoc,@Numero,@Cia,FecEmision,FecVence,
			VrFactura,VrAbonado,@TipComp,@Comprobante,ItemCom,Referencia,Detalle,pVehiculo,VehPropio,TipRef,
			DocRef,IdCiaRef,EstadoApr,MontoAprob
			FROM @Trn_ComFactura
			END

			IF(EXISTS(SELECT * FROM @Trn_Comprobantes))
			BEGIN
			INSERT INTO Trn_Comprobantes(
			TipCom, Comprobante, IdCia, Fecha, IdTercero, VrTotal, IdCta, EnEfectivo,
			NumCheque, FecCheque, TipDoc, Documento, IdCiaDoc, Anulado, NumDev, FecDev,
			TipEgr, NEgreso, pVehiculo, VehPropio, CedCondtor, CodConce, Beneficiario, VrDivisa1,
			VrDivisa2, VrDivisa3, PermEditar, Integrado, EsEgreso, Anticipo, Observacion, IdEstado,
			Propddes, TimeSys, FecUpdate, IdCiaCrea, IdUsuario, CdSustento, Tipo_Pago, Establec,
			PEmision, Autorizac, FechaAut, NiifTipo, NiifNumero, FisTipo, FisNumero, DocSoporte,
			CodRes, DescServicio
			)
			SELECT 
			@TipComp, @Comprobante, @IdCiaComp, Fecha, IdTercero, VrTotal, IdCta, EnEfectivo,
			NumCheque, FecCheque, @TipDoc, @Numero, @Cia, Anulado, NumDev, FecDev,
			TipEgr, NEgreso, pVehiculo, VehPropio, CedCondtor, CodConce, Beneficiario, VrDivisa1,
			VrDivisa2, VrDivisa3, PermEditar, Integrado, EsEgreso, Anticipo, Observacion, IdEstado,
			Propddes, TimeSys, FecUpdate, IdCiaCrea, IdUsuario, CdSustento, Tipo_Pago, Establec,
			PEmision, Autorizac, FechaAut, @TipCompNiif, @CompNiif, @TipCompFis, @CompFis, DocSoporte,
			CodRes, DescServicio
			FROM @Trn_Comprobantes
			END

			IF(EXISTS(SELECT * FROM @Trn_ComDetalle))
			BEGIN
			INSERT INTO Trn_ComDetalle(
			TipCom, Comprobante, IdCia, Item, Fecha, IdCuenta, Detalle, VrDebito, VrCredito,
			IdTercero, IdVehiculo, IdCCosto, IdSubCos, VrBase, TarifaBase, TipDoc, Documento,IdCiaDoc, 
			CodConce, NitDoc, TipFac, Factura, IdCiaFac, ItemFac, FecVence, CodCta,
			NumCheque, Integrado, TipoAplica, Consolida, CodCargo, NitOtros, CodSubgpo, CiuOrigen, 
			CodAgncia, VehPropio, Referncia, TipDocRef, DocRef, IdCiaRef, TimeSys, FecUpdate, IdCiaCrea, 
			IdUsuario, CdConcTrib, CdTarifTrib, NumEstablec, PtoEmision, Num_Autoriza, FechAutoriza,CdCuentaNiif
			)
			SELECT 
			@TipComp, @Comprobante, @IdCiaComp, cd.Item, cd.Fecha, cd.IdCuenta, cd.Detalle, cd.VrDebito, cd.VrCredito,
			cd.IdTercero, cd.IdVehiculo, cd.IdCCosto,cd.IdSubCos, cd.VrBase , cd.TarifaBase, @TipDoc, @Numero, @Cia,
			cd.CodConce, cd.NitDoc, cd.TipFac, cd.Factura, cd.IdCiaFac, cd.ItemFac, cd.FecVence, cd.CodCta,
			cd.NumCheque, cd.Integrado, cd.TipoAplica, cd.Consolida, cd.CodCargo, cd.NitOtros, cd.CodSubgpo, cd.CiuOrigen, 
			cd.CodAgncia, cd.VehPropio, cd.Referncia, cd.TipDocRef, cd.DocRef, cd.IdCiaRef, cd.TimeSys, cd.FecUpdate, cd.IdCiaCrea, 
			cd.IdUsuario, cd.CdConcTrib, cd.CdTarifTrib, cd.NumEstablec, cd.PtoEmision, cd.Num_Autoriza, cd.FechAutoriza,cd.CdCuentaNiif
			FROM @Trn_ComDetalle cd
			END

			IF(EXISTS(SELECT * FROM @Trn_NiifComp))
			BEGIN
			INSERT INTO Trn_NiifComp(
			TipCom, Comprobante, IdCia, Fecha, IdTercero, VrTotal, IdCta,
			EnEfectivo, NumCheque, FecCheque, TipDoc, Documento, IdCiaDoc, Anulado, NumDev,
			FecDev, TipEgr, NEgreso, pVehiculo, VehPropio, CedCondtor, CodConce, Beneficiario,
			VrDivisa1, VrDivisa2, VrDivisa3, PermEditar, Integrado, EsEgreso, Anticipo, Observacion,
			IdEstado, Propddes, TimeSys, FecUpdate, IdCiaCrea, IdUsuario, TipoNiif, CdSustento,
			Tipo_Pago, Establec, PEmision, Autorizac,FechaAut,
			CtbTipo, CtbNumero,
			FisTipo, FisNumero 
			)
			SELECT 
			CASE N.TipoNiif WHEN 'NIIF' THEN @TipCompNiif ELSE @TipCompFis END, 
			CASE N.TipoNiif WHEN 'NIIF' THEN @CompNiif ELSE @CompFis END, 
			@Cia, 
			C.Fecha, C.IdTercero, C.VrTotal, C.IdCta,
			C.EnEfectivo, C.NumCheque, C.FecCheque, @TipDoc, @Numero, @Cia, C.Anulado, C.NumDev,
			C.FecDev, C.TipEgr, C.NEgreso, C.pVehiculo, C.VehPropio, C.CedCondtor, C.CodConce, C.Beneficiario,
			C.VrDivisa1, C.VrDivisa2, C.VrDivisa3, C.PermEditar, C.Integrado, C.EsEgreso, C.Anticipo, C.Observacion,
			C.IdEstado, C.Propddes, C.TimeSys, C.FecUpdate, C.IdCiaCrea, C.IdUsuario, N.TipoNiif, C.CdSustento,
			C.Tipo_Pago, C.Establec, C.PEmision, C.Autorizac, C.FechaAut,
			CASE N.TipoNiif WHEN 'NIIF' THEN @TipCompNiif ELSE NULL END, CASE N.TipoNiif WHEN 'NIIF' THEN @CompNiif ELSE 0 END,
			CASE N.TipoNiif WHEN 'FISCAL' THEN @TipCompFis ELSE NULL END, CASE N.TipoNiif WHEN 'FISCAL' THEN @CompFis ELSE 0 END
			FROM @Trn_Comprobantes AS C JOIN @Trn_NiifComp AS N ON C.TipCom = N.TipComCont AND C.Comprobante = N.ComprobanteCont
			END

			IF(EXISTS(SELECT * FROM @Trn_NiifDetalle))
			BEGIN
			INSERT INTO Trn_NiifDetalle(
			TipCom, Comprobante, IdCia, Item, Fecha, IdCuenta, Detalle,
			VrDebito, VrCredito, IdTercero, IdVehiculo,IdCCosto, IdSubCos,
			VrBase, TarifaBase, TipDoc, Documento, IdCiaDoc, CodConce,
			NitDoc, TipFac, Factura, IdCiaFac, ItemFac, FecVence, CodCta, 
			NumCheque, Integrado, TipoAplica, Consolida, CodCargo, NitOtros,
			CodSubgpo, CiuOrigen, CodAgncia, VehPropio, Referncia, TipDocRef,
			DocRef, IdCiaRef, TimeSys, FecUpdate, IdCiaCrea, IdUsuario,
			CdConcTrib, CdTarifTrib, NumEstablec, PtoEmision, Num_Autoriza,
			FechAutoriza, CodCuentaCG
			)
			SELECT 
			CASE NC.TipoNiif WHEN 'NIIF' THEN @TipCompNiif ELSE @TipCompFis END, 
			CASE NC.TipoNiif WHEN 'NIIF' THEN @CompNiif ELSE @CompFis END, 
			@Cia,
			N.Item, N.Fecha, N.IdCuenta, N.Detalle,
			N.VrDebito, N.VrCredito, N.IdTercero, N.IdVehiculo,N.IdCCosto, N.IdSubCos,
			N.VrBase, N.TarifaBase, @TipDoc, @Numero, @Cia, N.CodConce,
			N.NitDoc, N.TipFac, N.Factura, N.IdCiaFac, N.ItemFac, N.FecVence, N.CodCta, 
			N.NumCheque, N.Integrado, N.TipoAplica, N.Consolida, N.CodCargo, N.NitOtros,
			N.CodSubgpo, N.CiuOrigen, N.CodAgncia, N.VehPropio, N.Referncia, N.TipDocRef,
			N.DocRef, N.IdCiaRef, N.TimeSys, N.FecUpdate, N.IdCiaCrea, N.IdUsuario,
			N.CdConcTrib, N.CdTarifTrib, N.NumEstablec, N.PtoEmision ,N.Num_Autoriza,
			N.FechAutoriza, N.CodCuentaCG
			FROM @Trn_NiifDetalle as N
			JOIN @Trn_NiifComp AS NC ON N.TipCom = NC.TipCom AND N.Comprobante = NC.Comprobante
			END
		end
					
		IF(@operacion = 'a')
		begin
			update Trn_TraEspCausacion 
			set  Anulado = '1', FecUpdate = GETDATE() 
			from  Trn_TraEspCausacion t1, @Trn_TraEspCausacion t2
			where t1.TipDoc = t2.TipDoc  and t1.Causacion = t2.Causacion and t1.IdCia = t2.IdCia
			select @Numero = (select Causacion from @Trn_TraEspCausacion)
		end

		if(@operacion = 's')
		begin
			update Trn_TraEspCauDetalle 
			set  
			VrAbonado = (t2.VrDebito + t2.VrCredito), EstadoReg = 1, 
			TipoLiq = t2.TipDoc, NumLiquida = t2.Causacion, CiaLiquida = t2.IdCia 
			from Trn_TraEspCauDetalle t1, @Trn_TraEspCauDetalle t2
			where t1.TipDoc = t2.TipDoc  and t1.Causacion = t2.Causacion and t1.IdCia = t2.IdCia  and t1.Item = t2.Item

			select @Numero = (select top 1 Causacion from @Trn_TraEspCauDetalle)
		end

		SELECT @Numero,@Comprobante

		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].[paWcfSeInsTrn_TraEspDevFactcausacion]    Script Date: 02/06/2026 16:03:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[paWcfSeInsTrn_TraEspDevFactcausacion]
    @Trn_DevFcr [dbo].[dataTypeTrn_DevFcr] READONLY,
    @TipDocFac VARCHAR(3),
    @Factura INT,
    @IdCia CHAR(2),
    @Operacion VARCHAR(1)
AS
BEGIN
    SET NOCOUNT ON;

    DECLARE
        @TipDocDev VARCHAR(3),
        @Consecutivo INT,
        @FecCia SMALLDATETIME;

    BEGIN TRY
        BEGIN TRAN;

        SELECT TOP 1
            @TipDocDev = TipDev,
            @Consecutivo = Devolucion,
            @FecCia = Fecha
        FROM @Trn_DevFcr

        IF NOT EXISTS (
            SELECT 1
            FROM TiposDocCons
            WHERE IdDoc = @TipDocDev
                AND IdCia = @IdCia
        )
        BEGIN
            INSERT INTO TiposDocCons (
                IdDoc, IdCia, LDesde,
                LHasta, Numero, NumManual,
                IntLotes, TipoPapel, Orientacion,
                VistaPrevia, VerSetup, NumCopias,
                FechaAdd
            )
            VALUES (
                @TipDocDev, @IdCia, 0,
                0, 1, 0,
                0, 1, 1,
                1, 0, 1,
                GETDATE()
            )
        END
        ELSE
            UPDATE TiposDocCons
            SET Numero = @Consecutivo
            WHERE IdDoc = @TipDocDev
                AND IdCia = @IdCia;

        INSERT INTO Trn_DevFcr
        (
            TipDev,         Devolucion,    IdCia,
            Fecha,          IdConcepto,    TipDoc,
            Factura,        IdCiaDoc,      FecDoc,
            IdCliente,      IdAgencia,     VrSubTotal,
            VrDescuento,    VrImpuesto,    VrRetencion,
            VrReteICA,      VrReteIVA,     VrFletes,
            VrOtros,        VrCargos,      VrOtrDcto,
            VrCostos,       VrSobretasa,   VrImpGlobal,
            VrFaltantes,    VrAnticipos,   VrNeto,
            Cantidad,       CantPuntos,    BaseImp,
            BaseRet,        IdCCosto,      IdSubCos,
            IdVend,         TarifaCom,     CodTarCom,
            IdLocEnv,       Pedido,        IdCiaPed,
            Remision,       IdCiaRem,      Cotizacion,
            IdCiaCot,       FecPedido,     Modalidad,
            ModdDev,        PlacaVehic,    KmtVehic,
            ZonaFrontera,   OrigenAdd,     TipCom,
            Comprobante,    IdCiaCom,      Observacion,
            IdEstado,       TimeSys,       FecUpdate,
            IdCiaCrea,      IdUsuario,     VrImpCons,
            VrReteCREE,     TarifaRtc,     CodTarRtc,
            BaseIvaObsq,    VrIvaObsequio, VrImpCarbono,
            DevMasivo,      NumRecibo,     CdCiaRec,
            CdMotDev,       BaseIvaIgp,    VrIvaIngProd,
            TarifaArf,      VrAutRetFte,   TarifaAri,
            VrAutRetIca,    VrImpuBA,      VrImpuCUP,
            ImpAviTab,      TarifaAvta,    VrBomberil,
            TarifaBom,      VrAutRetIat,   VrAutRetBom
        )
        SELECT
            TipDev,         Devolucion,    IdCia,
            Fecha,          IdConcepto,    TipDoc,
            Factura,        IdCiaDoc,      FecDoc,
            IdCliente,      IdAgencia,     VrSubTotal,
            VrDescuento,    VrImpuesto,    VrRetencion,
            VrReteICA,      VrReteIVA,     VrFletes,
            VrOtros,        VrCargos,      VrOtrDcto,
            VrCostos,       VrSobretasa,   VrImpGlobal,
            VrFaltantes,    VrAnticipos,   VrNeto,
            Cantidad,       CantPuntos,    BaseImp,
            BaseRet,        IdCCosto,      IdSubCos,
            IdVend,         TarifaCom,     CodTarCom,
            IdLocEnv,       Pedido,        IdCiaPed,
            Remision,       IdCiaRem,      Cotizacion,
            IdCiaCot,       FecPedido,     Modalidad,
            ModdDev,        PlacaVehic,    KmtVehic,
            ZonaFrontera,   OrigenAdd,     TipCom,
            Comprobante,    IdCiaCom,      Observacion,
            IdEstado,       TimeSys,       FecUpdate,
            IdCiaCrea,      IdUsuario,     VrImpCons,
            VrReteCREE,     TarifaRtc,     CodTarRtc,
            BaseIvaObsq,    VrIvaObsequio, VrImpCarbono,
            DevMasivo,      NumRecibo,     CdCiaRec,
            CdMotDev,       BaseIvaIgp,    VrIvaIngProd,
            TarifaArf,      VrAutRetFte,   0,
            VrAutRetIca,    VrImpuBA,      VrImpuCUP,
            0, 0, 0,
            0, 0, 0
        FROM @Trn_DevFcr

        UPDATE Trn_TraEspCauDetalle
        SET TipDocRef = NULL,
            DocRef = 0
        WHERE
            TipDocRef = @TipDocFac
            AND DocRef = CONCAT(@Factura, @IdCia)

        UPDATE Trn_Facturas 
        SET Anulado = 1,
            NumDev = @Consecutivo,
            FecDev = @FecCia
        WHERE
            TipDoc = @TipDocFac
            AND Factura = @Factura
            AND IdCia = @IdCia

        COMMIT TRAN;
    END TRY
    BEGIN CATCH
        IF @@TRANCOUNT > 0
            ROLLBACK TRAN;

        DECLARE @ErrorMensaje NVARCHAR(4000) = ERROR_MESSAGE();
        DECLARE @ErrorNumero INT = ERROR_NUMBER();

        RAISERROR(@ErrorMensaje, 16, 1);
    END CATCH
END
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeInsTrn_TraEspFactcausacion]    Script Date: 02/06/2026 16:03:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[paWcfSeInsTrn_TraEspFactcausacion]
(
    @Trn_Facturas [dbo].[dataTypeTrn_Facturas] READONLY,
    @Trn_TraEspFactcausacion [dbo].[dataTypeTrn_TraEspFactcausacion] READONLY,
    @Trn_TraEspCauFactura [dbo].[dataTypeTrn_TraEspCauFactura] READONLY,
    @Operacion VARCHAR(1)
)
AS
BEGIN
    SET NOCOUNT ON;

    DECLARE
        @TipDoc      VARCHAR(3),
        @IdCia       CHAR(2),
        @Consecutivo INT;

    BEGIN TRY
        BEGIN TRAN;

        SELECT TOP 1
            @TipDoc = TipDoc,
            @IdCia = IdCia
        FROM @Trn_Facturas;

        SELECT @Consecutivo = MAX(Factura)
        FROM @Trn_Facturas;

        IF NOT EXISTS (
            SELECT 1
            FROM TiposDocCons
            WHERE IdDoc = @TipDoc
                AND IdCia = @IdCia
        )
        BEGIN
            INSERT INTO TiposDocCons (
                IdDoc, IdCia, LDesde,
                LHasta, Numero, NumManual,
                IntLotes, TipoPapel, Orientacion,
                VistaPrevia, VerSetup, NumCopias,
                FechaAdd
            )
            VALUES (
                @TipDoc, @IdCia, 0,
                0, @Consecutivo, 0,
                0, 1, 1,
                1, 0, 1,
                GETDATE()
            )
        END
        ELSE
            UPDATE TiposDocCons
            SET Numero = @Consecutivo
            WHERE IdDoc = @TipDoc
                AND IdCia = @IdCia;
        

        INSERT INTO Trn_Facturas (
            TipDoc         , Factura       , IdCia
          , Fecha          , IdConcepto    , IdCliente
          , IdAgencia      , FechaVence    , VrSubTotal
          , VrDescuento    , VrImpuesto    , VrRetencion
          , VrReteICA      , VrReteIVA     , VrFletes
          , VrOtros        , VrCargos      , VrOtrDcto
          , VrCostos       , VrSobretasa   , VrImpGlobal
          , VrFaltantes    , VrAnticipos   , VrNeto
          , VrAplicado     , Cantidad      , CantPuntos
          , PuntosAcum     , BaseImp       , BaseRet
          , BaseIca        , BaseRiv       , TarifaIva
          , TarifaRet      , TarifaIca     , TarifaRiv
          , CodTarIva      , CodTarRet     , CodTarIca
          , CodTarRiv      , IdCCosto      , IdSubCos
          , IdVend         , TarifaCom     , CodTarCom
          , DirEnvio       , IdLocEnv      , DiasEntraga
          , NitContac      , NomContac     , TelContac
          , emlContac      , CargoContac   , IdForma
          , DetallePago    , MulPlazos     , IdPlazo
          , CdMney         , NitEmpTrans   , EmpTrans
          , pVehiculo      , CdConductor   , CdRuta
          , TipPed         , Pedido        , IdCiaPed
          , TipRem         , Remision      , IdCiaRem
          , TipCot         , Cotizacion    , IdCiaCot
          , FecPedido      , AutzaMora     , AutzaCupo
          , Modalidad      , KmtVehic      , ZonaFrontera
          , PesoTotal      , UnidTotal     , VolTotal
          , CantFalt       , VrCostoRem    , VrCostoAfi
          , CodAutoRet     , OrigenAdd     , TipCom
          , Comprobante    , IdCiaCom      , Anulado
          , NumDev         , FecDev        , Observacion
          , IdEstado       , TimeSys       , FecUpdate
          , IdCiaCrea      , IdUsuario     , VrImpCons
          , VrReteCREE     , TarifaRtc     , CodTarRtc
          , Parqueadero    , FecCuotaParq  , BaseIvaObsq
          , VrIvaObsequio  , VrImpCarbono  , TipoFE
          , FechaFE        , BaseIvaIgp    , VrIvaIngProd
          , CodTarArf      , TarifaArf     , VrAutRetFte
          , CodTarAri      , TarifaAri     , VrAutRetIca
          , CodTarifAvta   , CodTarifBom   , TipoOperTra
        )
        SELECT
            TipDoc         , Factura       , IdCia
          , Fecha          , IdConcepto    , IdCliente
          , IdAgencia      , FechaVence    , VrSubTotal
          , VrDescuento    , VrImpuesto    , VrRetencion
          , VrReteICA      , VrReteIVA     , VrFletes
          , VrOtros        , VrCargos      , VrOtrDcto
          , VrCostos       , VrSobretasa   , VrImpGlobal
          , VrFaltantes    , VrAnticipos   , VrNeto
          , VrAplicado     , Cantidad      , CantPuntos
          , CantPuntos     , BaseImp       , BaseRet
          , BaseIca        , BaseRiv       , TarifaIva
          , TarifaRet      , TarifaIca     , TarifaRiv
          , CodTarIva      , CodTarRet     , CodTarIca
          , CodTarRiv      , IdCCosto      , IdSubCos
          , IdVend         , TarifaCom     , CodTarCom
          , DirEnvio       , IdLocEnv      , DiasEntraga
          , NitContac      , NomContac     , TelContac
          , emlContac      , CargoContac   , IdForma
          , DetallePago    , MulPlazos     , IdPlazo
          , CdMney         , NitEmpTrans   , EmpTrans
          , pVehiculo      , CdConductor   , CdRuta
          , TipPed         , Pedido        , IdCiaPed
          , TipRem         , Remision      , IdCiaRem
          , TipCot         , Cotizacion    , IdCiaCot
          , FecPedido      , AutzaMora     , AutzaCupo
          , Modalidad      , KmtVehic      , ZonaFrontera
          , PesoTotal      , UnidTotal     , VolTotal
          , CantFalt       , VrCostoRem    , VrCostoAfi
          , CodAutoRet     , OrigenAdd     , TipCom
          , Comprobante    , IdCiaCom      , Anulado
          , NumDev         , FecDev        , Observacion
          , IdEstado       , TimeSys       , FecUpdate
          , IdCiaCrea      , IdUsuario     , VrImpCons
          , VrReteCREE     , TarifaRtc     , CodTarRtc
          , Parqueadero    , FecCuotaParq  , BaseIvaObsq
          , VrIvaObsequio  , VrImpCarbono  , TipoFE
          , FechaFE        , BaseIvaIgp    , VrIvaIngProd
          , ''             , TarifaArf     , VrAutRetFte
          , ''             , TarifaAri     , VrAutRetIca
          , ''             , ''            , ''
        FROM @Trn_Facturas;

        INSERT INTO Trn_TraEspFactcausacion (
            TipDoc , Factura    , IdCia
          , Item   , IdConcepto , Descripcion
          , Valor  , IdCiaCau   , IdVehiculo
        )
        SELECT
            TipDoc , Factura    , IdCia
          , Item   , IdConcepto , Descripcion
          , Valor  , IdCiaCau   , IdVehiculo
        FROM @Trn_TraEspFactcausacion;

        UPDATE CD
        SET CD.TipDocRef = TTCD.TipDocFac,
            CD.DocRef    = CAST(CONCAT(TTCD.Factura, TTCD.IdCia) AS INT)
        FROM @Trn_TraEspCauFactura AS TTCD
        INNER JOIN Trn_TraEspCauDetalle AS CD
            ON CD.TipDoc = TTCD.TipDoc
            AND CD.Causacion = TTCD.Causacion
            AND CD.IdCia = TTCD.IdCia
            AND CD.Item = TTCD.Item
            AND CD.TipoConc = 'CTACOBRAR';

        COMMIT TRAN;
    END TRY
    BEGIN CATCH
        IF @@TRANCOUNT > 0
            ROLLBACK TRAN;

        DECLARE @ErrorMensaje NVARCHAR(4000) = ERROR_MESSAGE();
        DECLARE @ErrorNumero INT = ERROR_NUMBER();

        RAISERROR(@ErrorMensaje, 16, 1);
    END CATCH
END
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTm_TraEspTempCargarDetCons]    Script Date: 02/06/2026 16:03:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Cesar Fernando Carre?o 
-- Create date: 04/01/2024
-- Description:	Metodo para cargar tabla temporal 
-- =============================================
CREATE PROCEDURE [dbo].[paWcfSeLisTm_TraEspTempCargarDetCons]	
	@Usuario varchar(20)
AS
	set @Usuario = (
		select 'CCD' + IdEstacion as Estacion 
		from adm_Usuarios 
		where IdUsuario = @Usuario
	)
BEGIN
	select 
		[TipDoc],
		[Causacion],
		[IdCia],
		[Item],
		[IdConcepto],
		[Descripcion],
		[TipoConc],
		[VrDebito],
		[VrCredito],
		[CdCuenta],
		[NitTercero],
		[RazonSocial],
		[CdCCosto],
		[CCosto],
		[CdSubCos],
		[SubCosto],
		[pVehiculo],
		[NumVeh],
		[ClaseMat],
		[TipoAfiVehic],
		[VrBase],
		[TarifBase],
		[Referencia],
		[TipDocRef],
		[DocRef],
		[TipFac],
		[Factura],
		[IdCiaFac],
		[ItemFac],
		[FecVence],
		[EstadoReg],
		[TipoLiq],
		[NumLiquida],
		[CiaLiquida],
		[VrAbonado],
		[FactElec]
	from 
		tm_TraEsDetConc 
	where 
		TmNumero = @Usuario
	 
	DELETE FROM [dbo].[tm_TraEsDetConc]
	WHERE TmNumero = @Usuario

END
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspAplicacionCausacionesLiqViajesManual]    Script Date: 02/06/2026 16:03:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[paWcfSeLisTrn_TraEspAplicacionCausacionesLiqViajesManual]
	@TipDoc VARCHAR(3),
    @Liquidacion INT,
    @IdCia CHAR(2)
AS
BEGIN
	SET NOCOUNT ON;

    SELECT
        TipOdp,
        OrdenPago AS OrdPago,
        IdCiaOdp,
        LD.VrSaldoOrden AS VrSaldo,
        Causacion,
        FechaCau,
        IdCiaCau,
        ItemCau,
        IdConcepto,
        Descripcion AS Concepto,
        pVehiculo AS Vehiculo,
        NitPoseedor AS NitTercero,
        T.RazonSocial AS Tercero,
        0 AS VrTotal,
        0 AS VrAbonado,
        0 AS VrSaldo,
        LD.VrAbono AS Vraplicar
    FROM Trn_TraEspLiquidaDed AS LD
    INNER JOIN Terceros AS T ON T.IdTercero = LD.NitPoseedor
    WHERE LD.TipDoc = @TipDoc
        AND LD.Liquidacion = @Liquidacion
        AND LD.IdCia = @IdCia;

END
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspCausacionesByFechaHasta]    Script Date: 02/06/2026 16:03:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[paWcfSeLisTrn_TraEspCausacionesByFechaHasta]
	@IdCia CHAR(2),
	@FechaDeduccionesHasta DATE,
	@IdPoseedor VARCHAR(16) = NULL,
	@IdVehiculo VARCHAR(10) = NULL
AS
BEGIN
	SET NOCOUNT ON;

	DECLARE @TipDocCce VARCHAR(3) = 'CCE';

	SELECT 
		-- Identificación
		d.TipDoc,
		d.Causacion,
		d.IdCia,
		d.Item,

		-- Concepto
		d.IdConcepto,
		d.Descripcion,
		d.TipoConc,

		-- Valores
		d.VrDebito,
		d.VrCredito,
		d.VrAbonado,
		(d.VrDebito - d.VrAbonado) AS VrSaldo,

		-- Cuenta / Tercero
		d.CdCuenta,
		d.NitTercero,
		t.RazonSocial,

		-- Centro de costo
		d.CdCCosto,
		CC.CCosto,
		d.CdSubCos,
		SC.SubCosto,

		-- Vehículo
		d.pVehiculo,
		v.NumVeh,
		v.ClaseMat,
		d.TipoAfiVehic,

		-- Base / tarifas
		d.VrBase,
		d.TarifBase,

		-- Referencias
		d.Referencia,
		d.TipDocRef,
		d.DocRef,

		-- Factura
		d.TipFac,
		d.Factura,
		d.IdCiaFac,
		d.ItemFac,

		-- Fechas / estado
		d.FecVence,
		d.EstadoReg,

		-- Liquidación
		d.TipoLiq,
		d.NumLiquida,
		d.CiaLiquida

	FROM 
		Trn_TraEspCauDetalle AS d
	INNER JOIN 
		Trn_TraEspCausacion AS ca 
		ON  d.TipDoc = ca.TipDoc 
		AND d.Causacion = ca.Causacion 
		AND d.IdCia = ca.IdCia
	LEFT JOIN 
		Terceros AS t 
		ON d.NitTercero = t.IdTercero
	INNER JOIN 
		Vehiculos AS v 
		ON d.pVehiculo = v.IdVehiculo
	LEFT JOIN 
		CentroCosto AS CC 
		ON  d.CdCCosto = CC.IdCCosto 
		AND CC.Inactivo = 0  
	LEFT JOIN 
		SubCentros AS SC 
		ON  d.CdSubCos = SC.IdSubCos 
		AND SC.Inactivo = 0
	WHERE 
		d.TipDoc = @TipDocCce
		AND d.IdCia = @IdCia
		AND d.TipoConc = 'CTACOBRAR'
		AND d.VrDebito > 0
		AND (d.VrDebito - d.VrAbonado) > 0
		AND ca.Anulado = 0
		AND d.NitTercero = V.IdPoseedor
		AND d.FecVence <= @FechaDeduccionesHasta
		AND (ISNULL(@IdPoseedor, '') = '' OR d.NitTercero = @IdPoseedor)
		AND (ISNULL(@IdVehiculo, '') = '' OR d.pVehiculo = @IdVehiculo);

	-- SELECT
	-- 	C.TipDoc AS TipCau,
	-- 	C.Causacion,
	-- 	C.IdCia AS IdCiaCau,
	-- 	CD.Item AS ItemCau,
	-- 	C.Fecha AS FechaCau,
	-- 	C.IdConcepto,
	-- 	CP.Concepto,
	-- 	CD.pVehiculo AS IdVehiculo,
	-- 	CD.VrDebito AS VrTotal,
	-- 	CD.VrAbonado,
	-- 	CD.VrDebito - CD.VrAbonado AS VrSaldo,
    --     CD.NitTercero,
    --     T.RazonSocial AS Tercero,
	-- 	CD.CdCuenta,
	-- 	CD.TipFac,
	-- 	CD.Factura,
	-- 	CD.ItemFac,
	-- 	CD.TipoConc,
	-- 	CD.VrDebito,
	-- 	CD.VrCredito,
	-- 	CD.TipoAfiVehic,
	-- 	CD.VrBase,
	-- 	CD.TarifBase,
	-- 	CD.Referencia,
	-- 	CD.TipDocRef,
	-- 	CD.DocRef,
	-- 	CD.IdCiaFac,
	-- 	CD.FecVence
	-- FROM
	-- 	Trn_TraEspCausacion AS C
	-- INNER JOIN
	-- 	Trn_TraEspCauDetalle AS CD
	-- 	ON CD.TipDoc = C.TipDoc
	-- 	AND CD.Causacion = C.Causacion
	-- 	AND CD.IdCia = C.IdCia
	-- INNER JOIN
	-- 	Conceptos AS CP
	-- 	ON CP.IdConcepto = C.IdConcepto
    -- INNER JOIN
	-- 	Vehiculos AS V
    --     ON V.IdVehiculo = CD.pVehiculo
    -- INNER JOIN
	-- 	Terceros AS T
    --     ON T.IdTercero = CD.NitTercero
	-- WHERE
	-- 	C.Anulado = 0
	-- 	AND CD.VrDebito - CD.VrAbonado > 0
	-- 	AND CD.TipoConc = 'CTACOBRAR'
	-- 	AND CD.FecVence <= @FechaDeduccionesHasta
	-- 	AND (ISNULL(@IdPoseedor, '') = '' OR V.IdPoseedor = @IdPoseedor AND V.IdPoseedor = CD.NitTercero)
	-- 	AND (ISNULL(@IdVehiculo, '') = '' OR (CD.pVehiculo = @IdVehiculo AND V.IdPoseedor = CD.NitTercero))

END
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspCausacionesFacturaElectronica]    Script Date: 02/06/2026 16:03:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[paWcfSeLisTrn_TraEspCausacionesFacturaElectronica]
    @IdCia CHAR(2) = NULL,
    @MesEspecifico DATE = NULL,
    @FechaInicial DATE = NULL,
    @FechaFinal DATE = NULL
AS
BEGIN
	SET NOCOUNT ON;

    DECLARE @EmpTrans VARCHAR(MAX);

    SELECT @EmpTrans = NitEmpresa
    FROM adm_Registro

	SELECT
        C.TipDoc, C.Causacion,   C.IdCia,                  C.Fecha,
        CD.IdConcepto, CD.Descripcion,           CD.Item,
        CD.pVehiculo,  CD.VrDebito Valor,        CD.NitTercero IdPoseedor,
        C.Observacion, C.TipCom,                 C.Comprobante,
        C.IdCiaCom,    TP.IdLocal IdLocPoseedor, @EmpTrans IdEnv,
        TP.RazonSocial AS Poseedor, V.IdConductor
    FROM
        Trn_TraEspCausacion AS C
    INNER JOIN
        Trn_TraEspCauDetalle AS CD
            ON CD.TipDoc = C.TipDoc
            AND CD.Causacion = C.Causacion
            AND CD.IdCia = C.IdCia
    LEFT JOIN
        Terceros AS TP
            ON TP.IdTercero = CD.NitTercero
    LEFT JOIN
        Vehiculos AS V
        ON V.IdVehiculo = CD.pVehiculo
    WHERE
        C.Anulado = 0
        AND CD.EstadoReg = 0
        AND CD.DocRef = 0
        AND CD.FactElec = 1
        AND (ISNULL(@IdCia, '') = '' OR C.IdCia = @IdCia)
        AND (
            (@MesEspecifico IS NOT NULL AND 
                YEAR(C.Fecha) = YEAR(@MesEspecifico) AND 
                MONTH(C.Fecha) = MONTH(@MesEspecifico)
            )
            OR
            (@MesEspecifico IS NULL AND 
                @FechaInicial IS NOT NULL AND 
                @FechaFinal IS NOT NULL AND
                C.Fecha BETWEEN @FechaInicial AND @FechaFinal
            )
        );	

END
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspCausacionesLiqViajesManual]    Script Date: 02/06/2026 16:03:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[paWcfSeLisTrn_TraEspCausacionesLiqViajesManual]
	@TipDoc VARCHAR(3),
    @Liquidacion INT,
    @IdCia CHAR(2)
AS
BEGIN
	SET NOCOUNT ON;

    WITH LiquidacionCausaciones_CTE AS (
        SELECT DISTINCT
            TipCau, Causacion, IdCiaCau
        FROM Trn_TraEspLiquidaDed
        WHERE TipDoc = @TipDoc
            AND Liquidacion = @Liquidacion
            AND IdCia = @IdCia
    ),
    SaldoCausaciones_CTE AS (
        SELECT 
            LD.TipCau,
            LD.Causacion,
            LD.IdCiaCau,
            SUM(LD.VrAbono) AS VrAbonado
        FROM 
            Trn_TraEspLiquidaDed AS LD
        INNER JOIN 
            Trn_TraEspLiquida AS L
            ON L.TipDoc = LD.TipDoc
            AND L.Liquidacion = LD.Liquidacion
            AND L.IdCia = LD.IdCia
            AND L.Anulado = 0
            AND L.Liquidacion <= @Liquidacion
        GROUP BY
            LD.TipCau, LD.Causacion, LD.IdCiaCau
    )
    SELECT 
        -- Identificación
        d.TipDoc,
        d.Causacion,
        d.IdCia,
        d.Item,

        -- Concepto
        d.IdConcepto,
        d.Descripcion,
        d.TipoConc,

        -- Valores
        d.VrDebito,
        d.VrCredito,
        SCCTE.VrAbonado,
        (d.VrDebito - SCCTE.VrAbonado) AS VrSaldo,

        -- Cuenta / Tercero
        d.CdCuenta,
        d.NitTercero,
        t.RazonSocial,

        -- Centro de costo
        d.CdCCosto,
        CC.CCosto,
        d.CdSubCos,
        SC.SubCosto,

        -- Vehículo
        d.pVehiculo,
        v.NumVeh,
        v.ClaseMat,
        d.TipoAfiVehic,

        -- Base / tarifas
        d.VrBase,
        d.TarifBase,

        -- Referencias
        d.Referencia,
        d.TipDocRef,
        d.DocRef,

        -- Factura
        d.TipFac,
        d.Factura,
        d.IdCiaFac,
        d.ItemFac,

        -- Fechas / estado
        d.FecVence,
        d.EstadoReg,

        -- Liquidación
        d.TipoLiq,
        d.NumLiquida,
        d.CiaLiquida

    FROM
        LiquidacionCausaciones_CTE AS LC
    INNER JOIN
        Trn_TraEspCauDetalle AS d
        ON d.TipDoc = LC.TipCau
        AND d.Causacion = LC.Causacion
        AND d.IdCia = LC.IdCiaCau
    INNER JOIN
        SaldoCausaciones_CTE AS SCCTE
        ON SCCTE.TipCau = LC.TipCau
        AND SCCTE.Causacion = LC.Causacion
        AND SCCTE.IdCiaCau = LC.IdCiaCau
    INNER JOIN 
        Trn_TraEspCausacion AS ca 
        ON  d.TipDoc = ca.TipDoc 
        AND d.Causacion = ca.Causacion 
        AND d.IdCia = ca.IdCia
    LEFT JOIN 
        Terceros AS t 
        ON d.NitTercero = t.IdTercero
    INNER JOIN 
        Vehiculos AS v 
        ON d.pVehiculo = v.IdVehiculo
    LEFT JOIN 
        CentroCosto AS CC 
        ON  d.CdCCosto = CC.IdCCosto 
        AND CC.Inactivo = 0  
    LEFT JOIN 
        SubCentros AS SC 
        ON  d.CdSubCos = SC.IdSubCos 
        AND SC.Inactivo = 0
    WHERE
        d.TipoConc = 'CTACOBRAR';

END
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspConsecutivosFacturaElectronica]    Script Date: 02/06/2026 16:03:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[paWcfSeLisTrn_TraEspConsecutivosFacturaElectronica]
    @TipDoc VARCHAR(3),
    @IdCia CHAR(2) = NULL,
    @MesEspecifico DATE = NULL,
    @FechaInicial DATE = NULL,
    @FechaFinal DATE = NULL
AS
BEGIN
	SET NOCOUNT ON;

    SELECT MIN(Factura) Minimo,
        MAX(Factura) Maximo
    FROM Trn_Facturas
    WHERE TipDoc = @TipDoc
        AND (ISNULL(@IdCia, '') = '' OR IdCia = @IdCia)
        AND (
            (@MesEspecifico IS NOT NULL AND 
                YEAR(Fecha) = YEAR(@MesEspecifico) AND 
                MONTH(Fecha) = MONTH(@MesEspecifico)
            )
            OR
            (@MesEspecifico IS NULL AND 
                @FechaInicial IS NOT NULL AND 
                @FechaFinal IS NOT NULL AND
                Fecha BETWEEN @FechaInicial AND @FechaFinal
            )
        );	

END
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspDevFactcausacionFmt]    Script Date: 02/06/2026 16:03:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[paWcfSeLisTrn_TraEspDevFactcausacionFmt]
AS
BEGIN
	SET NOCOUNT ON;

    SELECT 
        ''              AS TipDev,
        0               AS Devolucion,
        ''              AS IdCia,
        GETDATE()       AS Fecha,
        ''              AS IdConcepto,
        ''              AS TipDoc,
        0               AS Factura,
        ''              AS IdCiaDoc,
        GETDATE()       AS FecDoc,
        ''              AS IdCliente,
        ''              AS NomCliente,
        ''              AS IdAgencia,
        0               AS VrSubTotal,
        0               AS VrDescuento,
        0               AS VrImpuesto,
        0               AS VrRetencion,
        0               AS VrReteICA,
        0               AS VrReteIVA,
        0               AS VrFletes,
        0               AS VrOtros,
        0               AS VrCargos,
        0               AS VrOtrDcto,
        0               AS VrCostos,
        0               AS VrSobretasa,
        0               AS VrImpGlobal,
        0               AS VrFaltantes,
        0               AS VrAnticipos,
        0               AS VrNeto,
        0               AS Cantidad,
        0               AS CantPuntos,
        0               AS BaseImp,
        0               AS BaseRet,
        ''              AS IdCCosto,
        ''              AS IdSubCos,
        ''              AS IdVend,
        0               AS TarifaCom,
        ''              AS CodTarCom,
        ''              AS IdLocEnv,
        0               AS Pedido,
        ''              AS IdCiaPed,
        0               AS Remision,
        ''              AS IdCiaRem,
        0               AS Cotizacion,
        ''              AS IdCiaCot,
        GETDATE()       AS FecPedido,
        ''              AS Modalidad,
        ''              AS ModdDev,
        ''              AS PlacaVehic,
        0               AS KmtVehic,
        0               AS ZonaFrontera,
        ''              AS OrigenAdd,
        ''              AS TipCom,
        0               AS Comprobante,
        ''              AS IdCiaCom,
        ''              AS Observacion,
        ''              AS IdEstado,
        GETDATE()       AS TimeSys,
        GETDATE()       AS FecUpdate,
        ''              AS IdCiaCrea,
        ''              AS IdUsuario,
        0               AS VrImpCons,
        0               AS VrReteCREE,
        0               AS TarifaRtc,
        ''              AS CodTarRtc,
        0               AS BaseIvaObsq,
        0               AS VrIvaObsequio,
        0               AS VrImpCarbono,
        0               AS DevMasivo,
        0               AS NumRecibo,
        ''              AS CdCiaRec,
        ''              AS CdMotDev,
        0               AS BaseIvaIgp,
        0               AS VrIvaIngProd,
        0               AS TarifaArf,
        0               AS VrAutRetFte,
        0               AS TarifaAri,
        0               AS VrAutRetIca,
        0               AS VrImpuBA,
        0               AS VrImpuCUP,
        0               AS ImpAviTab,
        0               AS TarifaAvta,
        0               AS VrBomberil,
        0               AS TarifaBom,
        0               AS VrAutRetIat,
        0               AS VrAutRetBom,
        0               AS ItemDet,
        ''              AS IdConceptoDet,
        ''              AS DescripcionDet,
        0               AS ValorDet,
        ''              AS IdCiaCauDet,
        ----Información del cliente
'' AS TercTipo, '' AS  TercDv, '' AS TercCodigo, '' AS TercNomCial, '' AS TercSigal, '' AS TercDireccion, '' AS TercCdCiudad, '' AS NomCiudad, '' AS CdDep, '' AS TercDpto, '' AS TercTelefono,
'' AS TercFax, '' AS TercEmail, '' AS TercSitioWeb, '' AS CdSector, '' AS SectorEco, '' AS CdRegimen, '' AS Regimen, '' AS TercTipEnte,  '' AS NitRepLeg, '' AS NomRepLeg, '' AS ClieNitContac,
'' AS ClieNomContacto, '' AS ClieTelContac, '' AS ClieEmailContac, '' AS CargContac, CAST('' AS INT) AS DiasEntga, ''  AS CdSubzona, '' AS Subzona, '' AS Zona, '' AS CdGrupoCli, '' AS GrupoClie,
CAST('' AS BIT) AS ExcIva, CAST('' AS BIT) AS LiqFletes, CAST('' AS BIT) AS Autoret, CAST('' AS MONEY) AS VrCupo, CAST('' AS MONEY) AS VrSaldo, '' AS AgeDireccion, '' AS AgeTelefono, '' AS AgeFax,
'' AS AgeIdCiudad, '' AS AgeCiudad, '' AS AgeCodDep, '' AS AgeDpto, '' AS AgeReferencia,
--FACE
'' AS EstadoFE, '' AS PrefijoFace, CAST('' AS INT) AS NumFace, '' AS CUFE, '' AS ResolucionFace, '' AS RangoNum, '' AS FecVigencia, CAST('' AS IMAGE) AS QR, CAST('' AS DATETIME) AS FechaValidacion,
--FACE Información de la factura devuelta
'' AS CUFEFac, CAST('' AS DATETIME) AS FecValidaFac, '' AS PrefijoFACEFac


END
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspFactcausacionDataFmt]    Script Date: 02/06/2026 16:03:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[paWcfSeLisTrn_TraEspFactcausacionDataFmt]
    @TipDoc VARCHAR(3),
    @NumInicio INT,
    @NumFin INT,
    @IdCia CHAR(2)
AS
BEGIN
	SET NOCOUNT ON;

    SELECT
        -- FACTURA
        TD.Resolucion Resolucion,
        CAST(TD.FechaRes AS SMALLDATETIME) FecResolucion,
        TD.LDesde NumeracionInicial,
        TD.LHasta NumeracionFinal,

        F.TipDoc,
        F.Factura NumFac,
        F.IdCia IdCiaFac,
        0 FactElect,
        '' IdCiaFacElect,
        CAST(F.Fecha AS SMALLDATETIME) FecFac,
        CAST(F.FechaVence AS SMALLDATETIME) FecVenceFac,
        PLZ.Plazo Plazo,
        F.Observacion Observaciones,
        CAST(F.VrSubTotal AS MONEY) Subtotal,
        CAST(F.VrReteIVA AS MONEY) Iva,
        CAST(F.VrRetencion AS MONEY) Retencion,
        CAST(F.VrSubTotal AS MONEY) NetoTotal,
        TF.CUFE Cufe,
        CAST(TF.CUFE_QR AS IMAGE) QR,

        -- CLIENTE
        F.IdCliente IdCliente,
        TCL.RazonSocial NombreCli,
        TCL.Direccion DireccionCli,
        TCL.Telefono TelefonoCli,
        LC.Localidad CiudadCli,

        -- DETALLE
        FC.IdConcepto CodigoDet,
        FC.Descripcion DescripcionDet,
        FC.IdVehiculo PlacaDet,
        CAST(FC.Valor AS MONEY) SubtotalDet,
        CAST('' AS MONEY) IvaDet,
        CAST('' AS MONEY) RetFteDet,
        CAST(FC.Valor AS MONEY) TotalDet,

        -- EMPRESA
        '' NitEmp,
        0 DvEmp,
        '' RazonSocialEmp,
        '' DireccionEmp,
        '' TelefonoEmp,
        '' FaxEmp,
        '' IdLocalEmp,
        '' LocalidadEmp
    FROM
        Trn_Facturas AS F
    INNER JOIN
        TiposDocCons TD
        ON TD.IdDoc = F.TipDoc
        AND TD.IdCia = F.IdCia
    INNER JOIN
        Trn_TraEspFactcausacion AS FC
        ON FC.TipDoc = F.TipDoc
        AND FC.Factura = F.Factura
        AND FC.IdCia = F.IdCia
    LEFT JOIN
        Plazos AS PLZ
        ON PLZ.IdPlazo = F.IdPlazo
    LEFT JOIN
        Terceros AS TCL
        ON TCL.IdTercero = F.IdCliente
    LEFT JOIN 
        TercCliente AS TC
        ON TC.IdClie = TC.IdClie
    LEFT JOIN
        Localidades LC
        ON LC.IdLocal = TCL.IdLocal
    LEFT JOIN
        Trn_Face AS TF
        ON TF.TipDoc = F.TipDoc
        AND TF.Documento = F.Factura
        AND TF.IdCia = F.IdCia
    WHERE
        F.TipDoc = @TipDoc
        AND F.Factura BETWEEN @NumInicio AND @NumFin
        AND F.IdCia = @IdCia;

END
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspFactcausacionFmt]    Script Date: 02/06/2026 16:03:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[paWcfSeLisTrn_TraEspFactcausacionFmt]
AS
BEGIN
	SET NOCOUNT ON;

    SELECT 
        -- FACTURA
        '' Resolucion,
        CAST('' AS SMALLDATETIME) FecResolucion,
        0 NumeracionInicial,
        0 NumeracionFinal,

        '' TipDoc,
        '' NumFac,
        '' IdCiaFac,
        0 FactElect,
        '' IdCiaFacElect,
        CAST('' AS SMALLDATETIME) FecFac,
        CAST('' AS SMALLDATETIME) FecVenceFac,
        '' Plazo,
        '' Observaciones,
        CAST('' AS MONEY) Subtotal,
        CAST('' AS MONEY) Iva,
        CAST('' AS MONEY) Retencion,
        CAST('' AS MONEY) NetoTotal,
        '' Cufe,
        CAST('' AS IMAGE) QR,

        -- CLIENTE
        '' IdCliente,
        '' NombreCli,
        '' DireccionCli,
        '' TelefonoCli,
        '' CiudadCli,

        -- DETALLE
        '' CodigoDet,
        '' DescripcionDet,
        '' PlacaDet,
        CAST('' AS MONEY) SubtotalDet,
        CAST('' AS MONEY) IvaDet,
        CAST('' AS MONEY) RetFteDet,
        CAST('' AS MONEY) TotalDet,

        -- EMPRESA
        '' NitEmp,
        0 DvEmp,
        '' RazonSocialEmp,
        '' DireccionEmp,
        '' TelefonoEmp,
        '' FaxEmp,
        '' IdLocalEmp,
        '' LocalidadEmp;

END
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspFacturaCausacion]    Script Date: 02/06/2026 16:03:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[paWcfSeLisTrn_TraEspFacturaCausacion]
	@TipDoc VARCHAR(3),
    @Factura INT,
    @IdCia CHAR(2)
AS
BEGIN
	SET NOCOUNT ON;

    SELECT
        F.TipDoc,                   F.Factura,                   F.IdCia,
        F.Fecha,                    F.IdCliente,                 T.RazonSocial Cliente,
        F.VrSubTotal,               F.IdUsuario,                 F.Anulado,
        F.IdConcepto,               C.Concepto,                  F.IdCCosto,
        F.IdSubCos,                 F.IdVend,                    F.IdLocEnv,
        FC.Item,                    FC.IdConcepto IdConceptoCau, FC.Descripcion ConceptoCau,
        FC.Valor,                   FC.IdCiaCau,                 FC.IdVehiculo,
        D.Devolucion,               D.IdCia IdCiaDev,            CAST(D.Fecha AS DATETIME) + CAST(D.TimeSys AS DATETIME) FechaDev
    FROM
        Trn_Facturas AS F
    INNER JOIN
        Trn_TraEspFactcausacion AS FC
            ON FC.TipDoc = F.TipDoc
            AND FC.Factura = F.Factura
            AND FC.IdCia = F.IdCia
    LEFT JOIN
        Trn_DevFcr AS D
            ON D.TipDoc = F.TipDoc
            AND D.Factura = F.Factura
            AND D.IdCiaDoc = F.IdCia
    LEFT JOIN
        Terceros AS T
            ON T.IdTercero = F.IdCliente
    LEFT JOIN
        Conceptos AS C
            ON C.IdConcepto = F.IdConcepto
    WHERE
        F.Tipdoc = @TipDoc
        AND F.Factura = @Factura
        AND F.IdCia = @IdCia;

END
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspFacturasCausaciones]    Script Date: 02/06/2026 16:03:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[paWcfSeLisTrn_TraEspFacturasCausaciones]
	@TipDoc VARCHAR(3),
    @FechaEntre DATE,
    @FechaHasta DATE
AS
BEGIN
	SET NOCOUNT ON;

    SELECT
        F.TipDoc,     F.Factura,   F.IdCia,
        F.Fecha,      F.IdCliente, T.RazonSocial Cliente,
        F.VrSubTotal, F.IdUsuario, F.Anulado,
        F.IdConcepto, C.Concepto
    FROM
        Trn_Facturas AS F
    LEFT JOIN
        Terceros AS T
            ON T.IdTercero = F.IdCliente
    LEFT JOIN
        Conceptos AS C
            ON C.IdConcepto = F.IdConcepto
    WHERE
        Tipdoc = @TipDoc
        AND CAST(F.Fecha AS DATE) BETWEEN @FechaEntre AND @FechaHasta;

END
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspHeaderLiqViajesManual]    Script Date: 02/06/2026 16:03:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[paWcfSeLisTrn_TraEspHeaderLiqViajesManual]
	@TipDoc VARCHAR(3),
    @Liquidacion INT,
    @IdCia CHAR(2)
AS
BEGIN
	SET NOCOUNT ON;

    SELECT
        L.IdVehiculo,                L.IdPoseedor,                 TPO.RazonSocial Poseedor,
        V.IdPropietario,             TPR.RazonSocial Propietario,  L.IdConductor,
        TCO.RazonSocial Conductor,   L.FecFinCau DeduccionesHasta, L.FecIniOdp PeriodoLiqInicial,
        L.FecFinOdp PeriodoLiqFinal, L.IdConcepto,                 CN.Concepto,
        L.Liquidacion,               L.IdCia,                      L.Fecha,
        L.TipCom,                    L.Comprobante,                L.ModLiquida TipoLiq,
        L.TimeSys FechaCreacion,     L.IdUsuario,                  L.CxPagar,
        L.Anulado
    FROM
        Trn_TraEspLiquida L
    INNER JOIN
        Vehiculos AS V
        ON V.IdVehiculo = L.IdVehiculo
    INNER JOIN
        Conceptos AS CN
        ON CN.IdConcepto = L.IdConcepto
    LEFT JOIN
        Terceros AS TPO
        ON TPO.IdTercero = L.IdPoseedor
    LEFT JOIN
        Terceros AS TPR
        ON TPR.IdTercero = V.IdPropietario
    LEFT JOIN
        Terceros AS TCO
        ON TCO.IdTercero = L.IdConductor
    WHERE
        L.TipDoc = @TipDoc
        AND L.Liquidacion = @Liquidacion
        AND L.IdCia = @IdCia;

END
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspOrdPagoConSaldo]    Script Date: 02/06/2026 16:03:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[paWcfSeLisTrn_TraEspOrdPagoConSaldo]
	@IdCia CHAR(2),
	@IdVehiculo VARCHAR(10),
	@IdPoseedor VARCHAR(16),
	@FechaLiqInicial DATE = NULL,
	@FechaLiqFinal DATE = NULL
AS
BEGIN
	SET NOCOUNT ON;

	DECLARE @TipDocOpe VARCHAR(3) = 'OPE';

	WITH SaldoFactura_CTE AS (
		SELECT 
			TipFac, Documento, IdCia,
			SUM(VrFactura) AS VrTotalFac,
			SUM(VrAbonado) AS VrTotalAbo,
			SUM(VrFactura - VrAbonado) AS VrSaldo
		FROM Trn_ComFactura
		WHERE TipDoc = @TipDocOpe
		GROUP BY TipFac, Documento, IdCia
		HAVING SUM(VrFactura - VrAbonado) > 0
	)
	SELECT 
		ORES.TipDoc,       ORES.OrdPago,           ORES.IdCia,
		CN.Compania,       ORES.Fecha,             ORES.TipRes,
		ORES.Reserva,      ORES.ItemRes,           ORES.IdCiaRes,
		ORES.IdPoseedor,   T.RazonSocial Poseedor, ORES.IdConductor,
		ORES.IdVehiculo,   V.NumVeh,               CDT.RazonSocial NomConductor,
		ORES.VrServicio,   ORES.VrRetencion,       ORES.VrReteIca,
		ORES.VrReteCree,   ORES.VrAnticipos,       ORES.VrFondos,
		ORES.VrAportes,    ORES.VrOtrosDctos,      ORES.VrImpuestos,
		ORES.VrOtrosPagos, ORES.VrNeto,

		-- Datos de comfactura
		VC.VrTotalAbo VrAbonado, VC.VrSaldo,

		-- Datos de la OPE
		OPE.Observacion,   OPE.CxPagar,    ORES.Referencia,
		ORES.EdoLiqCausac, ORES.TipEgr,    ORES.Egreso,
		ORES.IdCiaEgr,     ORES.NumCheque,

		-- Datos adicionales OPE
		OPE.TipCom, OPE.Comprobante, OPE.IdCiaCom,
		OPE.Anulado,ORES.TipDoc AS TipFac,
		ORES.OrdPago AS NumFac, ORES.IdCia AS IdCiaFac,
		1 AS ItemFac, CC.IdCuenta AS CdCuePagar, 0 VrFactura,
		0 AS ItemCau
	FROM 
		Trn_TraEspOrdenReservas AS ORES
	INNER JOIN 
		Trn_TraEspOrdenPago AS OPE 
		ON  OPE.TipDoc = ORES.TipDoc 
		AND OPE.OrdPago = ORES.OrdPago 
		AND OPE.IdCia = ORES.IdCia
	INNER JOIN
		ConceptosCue AS CC
		ON CC.IdConcepto = OPE.IdConcepto
		AND CC.IdClase = 2
	INNER JOIN 
		Companias AS CN 
		ON ORES.IdCia = CN.IdCia  
	INNER JOIN 
		Terceros AS T 
		ON ORES.IdPoseedor = T.IdTercero
	INNER JOIN 
		Vehiculos AS V 
		ON ORES.IdVehiculo = V.IdVehiculo
	INNER JOIN 
		Terceros AS CDT 
		ON ORES.IdConductor = CDT.IdTercero
	INNER JOIN 
		SaldoFactura_CTE AS VC 
		ON ORES.TipDoc = VC.TipFac 
		AND ORES.OrdPago = VC.Documento 
		AND ORES.IdCia = VC.IdCia
	WHERE
		ORES.IdCia = @IdCia
		AND OPE.Anulado = 0
		AND OPE.CxPagar = 1
		AND (ISNULL(@IdPoseedor, '') = '' OR ORES.IdPoseedor = @IdPoseedor)
		AND (ISNULL(@IdVehiculo, '') = '' OR ORES.IdVehiculo = @IdVehiculo)
		AND ORES.Fecha >= @FechaLiqInicial
		AND ORES.Fecha < DATEADD(DAY, 1, @FechaLiqFinal);

END
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspOrdPagoLiqViajesManual]    Script Date: 02/06/2026 16:03:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[paWcfSeLisTrn_TraEspOrdPagoLiqViajesManual]
	@TipDoc VARCHAR(3),
    @Liquidacion INT,
    @IdCia CHAR(2)
AS
BEGIN
	SET NOCOUNT ON;

    WITH LiquidacionCausaciones_CTE AS (
        SELECT DISTINCT
            TipDoc, Liquidacion, IdCia,
            TipCau, Causacion, IdCiaCau
        FROM Trn_TraEspLiquidaOtr AS LO
        WHERE LO.TipDoc = @TipDoc
            AND LO.Liquidacion = @Liquidacion
            AND LO.IdCia = @IdCia
    ),
    LiquidacionOrdPago_CTE AS (
        SELECT DISTINCT
            LO.TipDoc, LO.Liquidacion, LO.IdCia,
            LO.TipOdp, LO.OrdPago, LO.IdCiaOdp
        FROM 
            Trn_TraEspLiquidaOdp AS LO
        WHERE 
            LO.TipDoc = @TipDoc
            AND LO.Liquidacion = @Liquidacion
            AND LO.IdCia = @IdCia
    ),
    LiquidacionDed_CTE AS (
        SELECT DISTINCT
            TipOdp, OrdenPago, IdCiaOdp, VrSaldoOrden
        FROM Trn_TraEspLiquidaDed
        WHERE TipDoc = @TipDoc
            AND Liquidacion = @Liquidacion
            AND IdCia = @IdCia
    )
    SELECT
        ORES.TipDoc,       ORES.OrdPago,           ORES.IdCia,
        CN.Compania,       ORES.Fecha,             ORES.TipRes,
        ORES.Reserva,      ORES.ItemRes,           ORES.IdCiaRes,
        ORES.IdPoseedor,   T.RazonSocial Poseedor, ORES.IdConductor,
        ORES.IdVehiculo,   V.NumVeh,               CDT.RazonSocial NomConductor,
        ORES.VrServicio,   ORES.VrRetencion,       ORES.VrReteIca,
        ORES.VrReteCree,   ORES.VrAnticipos,       ORES.VrFondos,
        ORES.VrAportes,    ORES.VrOtrosDctos,      ORES.VrImpuestos,
        ORES.VrOtrosPagos, ORES.VrNeto,

        -- Datos de comfactura
        (ORES.VrNeto - LD.VrSaldoOrden) VrAbonado, LD.VrSaldoOrden VrSaldo,

        -- Datos de la OPE
        OPE.Observacion,   OPE.CxPagar,    ORES.Referencia,
        ORES.EdoLiqCausac, ORES.TipEgr,    ORES.Egreso,
        ORES.IdCiaEgr,     ORES.NumCheque,

        -- Datos adicionales OPE
        OPE.TipCom, OPE.Comprobante, OPE.IdCiaCom,
        OPE.Anulado,ORES.TipDoc AS TipFac,
        ORES.OrdPago AS NumFac, ORES.IdCia AS IdCiaFac,
        1 AS ItemFac, CC.IdCuenta AS CdCuePagar, 0 VrFactura,
        0 AS ItemCau
    FROM
        LiquidacionOrdPago_CTE AS LO
    INNER JOIN
        LiquidacionDed_CTE AS LD
        ON LD.TipOdp = LO.TipOdp
        AND LD.OrdenPago = LO.OrdPago
        AND LD.IdCiaOdp = LO.IdCiaOdp
    INNER JOIN
        Trn_TraEspOrdenReservas AS ORES
        ON ORES.TipDoc = LO.TipOdp
        AND ORES.OrdPago = LO.OrdPago
        AND ORES.IdCia = LO.IdCiaOdp
    INNER JOIN 
        Trn_TraEspOrdenPago AS OPE 
        ON  OPE.TipDoc = ORES.TipDoc 
        AND OPE.OrdPago = ORES.OrdPago 
        AND OPE.IdCia = ORES.IdCia
    INNER JOIN
        ConceptosCue AS CC
        ON CC.IdConcepto = OPE.IdConcepto
        AND CC.IdClase = 2
    INNER JOIN 
        Companias AS CN 
        ON ORES.IdCia = CN.IdCia  
    INNER JOIN 
        Terceros AS T 
        ON ORES.IdPoseedor = T.IdTercero
    INNER JOIN 
        Vehiculos AS V 
        ON ORES.IdVehiculo = V.IdVehiculo
    INNER JOIN 
        Terceros AS CDT 
        ON ORES.IdConductor = CDT.IdTercero

    UNION

    SELECT 
        F.TipDoc,
        F.Documento AS OrdPago,
        F.IdCiaDoc AS IdCia,
        CF.Compania AS Compania,
        F.FecEmision AS Fecha,
        '' AS TipRes,
        0 AS Reserva,
        0 AS ItemRes,
        '' AS IdCiaRes,
        F.IdProveedor AS IdPoseedor,
        TP.RazonSocial AS Poseedor,
        V.IdConductor,
        F.pVehiculo AS IdVehiculo,
        V.NumVeh,
        TC.RazonSocial AS NomConductor,
        F.VrFactura VrServicio,
        0 VrRetencion,
        0 VrReteIca,
        0 VrReteCree,   
        0 VrAnticipos,       
        0 VrFondos,
        0 VrAportes,
        0 VrOtrosDctos,
        0 VrImpuestos,
        0 VrOtrosPagos,
        0 VrNeto,
        F.VrAbonado VrAbonado,
        (F.VrFactura - F.VrAbonado) VrSaldo,
        '' Observacion,
        1 CxPagar,
        '' Referencia,
        0 EdoLiqCausac,
        '' TipEgr,
        0 Egreso,
        '00' IdCiaEgr,
        '' NumCheque,
        F.TipCom,
        F.Comprobante,
        F.IdCia IdCiaCom,
        0 Anulado,
        F.TipFac,
        F.Factura AS NumFac,
        F.IdCia AS IdCiaFac,
        F.Item AS ItemFac,
        F.IdCuenta AS CdCuePagar,
        F.VrFactura,
        D.Item AS ItemCau
    FROM 
        LiquidacionCausaciones_CTE LC
    INNER JOIN
        Trn_ComFactura AS F
        ON F.TipDoc = LC.TipCau
        AND F.Documento = LC.Causacion
        AND F.IdCiaDoc = LC.IdCiaCau
    INNER JOIN 
        Companias AS CF 
        ON F.IdCia = CF.IdCia
    INNER JOIN 
        Vehiculos AS V 
        ON V.IdVehiculo = F.pVehiculo
    LEFT JOIN
        Terceros AS TP
        ON TP.IdTercero = V.IdPoseedor
    LEFT JOIN
        Terceros AS TC
        ON TC.IdTercero = V.IdConductor
    INNER JOIN 
        Trn_TraEspCauDetalle AS D 
        ON  F.TipDoc = D.TipDoc 
        AND F.Documento = D.Causacion 
        AND F.IdCiaDoc = D.IdCia 
        AND D.TipFac = F.TipFac 
        AND D.Factura = F.Factura 
        AND D.IdCiaFac = F.IdCia 
        AND D.ItemFac = F.Item
        AND D.NitTercero = V.IdPoseedor
    WHERE
        D.TipoConc = 'OTROSPAGOS';

END
GO
/****** Object:  StoredProcedure [dbo].[paWcfSeLisTrn_TraEspOtrosPagosConSaldo]    Script Date: 02/06/2026 16:03:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[paWcfSeLisTrn_TraEspOtrosPagosConSaldo]
	@IdCia CHAR(2),
	@IdVehiculo VARCHAR(10),
	@IdPoseedor VARCHAR(16),
	@FechaLiqInicial DATE = NULL,
	@FechaLiqFinal DATE = NULL
AS
BEGIN
	SET NOCOUNT ON;

	DECLARE @TipDocCce VARCHAR(3) = 'CCE';

	SELECT 
		F.TipDoc,
		F.Documento AS OrdPago,
		F.IdCiaDoc AS IdCia,
		CF.Compania AS Compania,
		F.FecEmision AS Fecha,
		'' AS TipRes,
		0 AS Reserva,
		0 AS ItemRes,
		'' AS IdCiaRes,
		F.IdProveedor AS IdPoseedor,
		TP.RazonSocial AS Poseedor,
		V.IdConductor,
		F.pVehiculo AS IdVehiculo,
		V.NumVeh,
		TC.RazonSocial AS NomConductor,
		F.VrFactura VrServicio,
		0 VrRetencion,
		0 VrReteIca,
		0 VrReteCree,   
		0 VrAnticipos,       
		0 VrFondos,
		0 VrAportes,
		0 VrOtrosDctos,
		0 VrImpuestos,
		0 VrOtrosPagos,
		0 VrNeto,
		F.VrAbonado VrAbonado,
		(F.VrFactura - F.VrAbonado) VrSaldo,
		'' Observacion,
		1 CxPagar,
		'' Referencia,
		0 EdoLiqCausac,
		0 TipEgr,
		0 Egreso,
		'00' IdCiaEgr,
		'' NumCheque,
		F.TipCom,
		F.Comprobante,
		F.IdCia IdCiaCom,
		0 Anulado,
		F.TipFac,
		F.Factura AS NumFac,
		F.IdCia AS IdCiaFac,
		F.Item AS ItemFac,
		F.IdCuenta AS CdCuePagar,
		F.VrFactura,
		D.Item AS ItemCau

		-- -- ComFactura
		-- F.TipFac,
		-- F.Factura,
		-- F.IdCia AS IdCiaF,
		-- CF.Compania AS CompaniaF,
		-- F.Item AS ItemF,
		-- F.Documento,
		-- F.IdCiaDoc AS IdCiaDocF,
		-- F.FecEmision,
		-- F.FecVence,
		-- F.VrFactura,
		-- F.VrAbonado,
		-- (F.VrFactura - F.VrAbonado) AS VrSaldo,
		-- F.pVehiculo,
		-- V.NumVeh,
		-- F.Referencia,
		-- F.Detalle,
		-- F.TipCom,
		-- F.Comprobante,
		-- F.TipRef,
		-- F.DocRef,
		-- F.IdCiaRef,
		-- F.IdProveedor,

		-- -- CauDetalle
		-- D.Item AS ItemCauDet,
		-- D.TipoConc,
		-- D.Descripcion,
		-- D.CdCuenta,

		-- -- LiquidaOtrosPagos
		-- O.Item,
		-- O.TipCau,
		-- O.Causacion,
		-- O.IdCiaCau,
		-- O.ItemCau,
		-- O.Factura AS FacturaO,
		-- O.VrAbono,
		-- O.pVehiculo AS pVehiculoO
	FROM 
		Trn_ComFactura AS F
	INNER JOIN 
		Companias AS CF 
		ON F.IdCia = CF.IdCia
	INNER JOIN 
		Vehiculos AS V 
		ON V.IdVehiculo = F.pVehiculo
	LEFT JOIN
		Terceros AS TP
		ON TP.IdTercero = V.IdPoseedor
	LEFT JOIN
		Terceros AS TC
		ON TC.IdTercero = V.IdConductor
	INNER JOIN 
		Trn_TraEspCauDetalle AS D 
		ON  F.TipDoc = D.TipDoc 
		AND F.Documento = D.Causacion 
		AND F.IdCiaDoc = D.IdCia 
		AND D.TipFac = F.TipFac 
		AND D.Factura = F.Factura 
		AND D.IdCiaFac = F.IdCia 
		AND D.ItemFac = F.Item
		AND D.NitTercero = V.IdPoseedor
	WHERE 
		F.TipDoc = @TipDocCce
		AND (F.VrFactura - F.VrAbonado) > 0
		AND D.TipoConc = 'OTROSPAGOS'
		AND (ISNULL(@IdPoseedor, '') = '' OR F.IdProveedor = @IdPoseedor)
		AND (ISNULL(@IdVehiculo, '') = '' OR F.pVehiculo = @IdVehiculo)
		AND F.FecEmision >= @FechaLiqInicial
		AND F.FecEmision < DATEADD(DAY, 1, @FechaLiqFinal);

END
GO