GO
-- =============================================
-- Author:	John Jairo Roa
-- Create date(dd/MM/yyyy): 01/08/2017
-- Description:	Imprimir Formato de Liquidaciones de Especial
-- =============================================
ALTER PROCEDURE [dbo].[paWcfSeLisTrn_TraEspLiquidaFmt]
AS
BEGIN
DECLARE @VrDef VARCHAR(1) = '1'
SELECT 
'' AS TipDoc, CAST('' AS INT) AS Liquidacion, '' AS IdCia, '' AS Compania, CAST('' AS DATETIME) AS Fecha, '' AS IdConcepto, '' AS Concepto, '' AS IdVehiculo, '' AS IdPoseedor,
''  AS Poseedor, '' AS IdConductor, '' AS NomConductor, CAST('' AS MONEY) AS VrTotal, CAST('' AS BIT) AS CxPagar, '' AS TipCom, CAST('' AS INT) AS Comprobante, '' AS IdCiaCom,
CAST('' AS BIT) AS Anulado, CAST('' AS INT) AS NumDev, CAST('' AS DATETIME) AS FecDev, '' AS Observacion, '' AS IdEstado, '' AS Estado,
CAST('' AS DATETIME) AS FecIniCau, CAST('' AS DATETIME) AS FecFinCau, CAST('' AS DATETIME) AS FecIniOdp, CAST('' AS DATETIME) AS FecFinOdp, '' AS ModLiquida,
CAST('' AS DATETIME) AS TimeSys, CAST('' AS DATETIME) AS FecUpdate, '' AS IdCiaCrea, '' AS IdUsuario, '' AS Usuario,
--datos de la orden
'' AS TipOdp, CAST('' AS INT) AS OrdPago, '' AS IdCiaOdp, '' AS NomCiaOrden, CAST('' AS DATETIME)  AS FechaOdp, '' AS TipRes, CAST('' AS INT) AS Reserva, '' AS IdCiaRes, CAST('' AS INT) AS ItemRes,
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 VrAportes,  CAST('' AS MONEY) AS VrFondos, CAST('' AS MONEY) AS VrOtrosPagos, CAST('' AS MONEY) AS VrNeto,
CAST('' AS MONEY) AS  BaseRet, CAST('' AS MONEY) AS  BaseIca, CAST('' AS MONEY) AS  BaseCree, 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 BIT) AS  CxPagar, CAST('' AS MONEY) MulPlazos, '' AS  IdPlazo, '' AS Plazo,
CAST('' AS INT) AS NVmto, CAST('' AS DATETIME) AS FechaVence, 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, CAST('' AS MONEY) AS VrReteCREE, '' AS NumCheque, '' AS Referencia,
'' AS CdCiuOrigen, '' AS  CiuOrigen, '' AS CodDepOrigen, '' AS DptoOrigen, '' AS CdCiuDestino, '' AS CiuDestino, ''  AS CodDepDestino, '' AS DptoDestino,  '' AS IdRuta, '' AS Ruta,
--datos del poseedor
'' AS TercTipId, ''  AS TercDv, ''  AS TercCodigo, '' AS TercNomCial, '' AS TercDireccion, '' AS TercCdCiudad, '' AS NomCiudad, '' AS TercTelefono, '' AS TercEmail,
'' AS NumVeh, '' AS CdTipVeh, '' AS TipoVehiculo, '' AS CdMarca, '' AS MarcaVeh, '' AS CdLinVeh, '' AS LineaVeh, '' AS CdColor, '' AS NomColor, '' AS CdCarr, '' AS TipoCar, '' AS Modelo,
'' AS Config, CAST(@VrDef AS DECIMAL(14,4)) AS PesoVacio, CAST(@VrDef AS DECIMAL(14,4)) PesoMax, ''AS NumMotor, '' AS SerieChasis, '' AS NumSerie, '' AS CdRemque, '' AS NitEmpresa, 
'' AS VehNomEmpresa, '' AS CdTipProp, '' AS TipoProp, '' AS VehPropio, '' AS TipoAfil, '' AS NumSoat, CAST('' AS DATETIME) FecSoat, CAST('' AS DATETIME) AS VigSoat,
'' AS NitEmpSoat, '' AS CertGases,  CAST('' AS DATETIME) FecCertGas,  CAST('' AS DATETIME) AS VigCertGas, '' AS VehDescripcion,  CAST('' AS DATETIME) AS FecRes, '' AS NumCtaProveedor,
'' AS ClaseCuenta,  '' AS NitContac, '' AS NomContac, '' AS Banco,
--Datos del cliente la factura
'' AS IdCliente,  '' AS RazonSocialCli
 END
 GO