<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="cgmv_inf_cuenta_pagar" language="groovy" pageWidth="2080" pageHeight="612" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="2040" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.5"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/radicacionvirtualcuentas/cgmv_inf_cuenta_pagar"/>
	<property name="ireport.jasperserver.url" value="http://3.22.202.200:8080/jasperserver/services/repository"/>
	<parameter name="fecha_ini" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="fecha_fin" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereIdContratista" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereIdContrato" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereIdNumeroPago" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTipoRecurso" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="entidad_cliente" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select
case when tipo_recurso = 0 then dat.CODIGO_SIIF else dat.CODIGO_SPGR end as PCIConexion,
case when tipo_recurso = 0 then nvl(tab0.rp_anm,tab0.rp_sgr) else nvl(tab0.rp_sgr,tab0.rp_anm) end as ConsecutivoCompromiso,
/*case when tipo_recurso = 0
      then case when tab0.declarante_renta = 1 then '31' else '64' end
      else case when tab0.declarante_renta = 1 then '053' else '054' end end as TipoCuentaPorPagar,*/
case when tipo_recurso = 0
      then case when tab0.RESPONSABLE_FACT_ELECT = 1 then '93' else '103' end
      else case when tab0.RESPONSABLE_FACT_ELECT = 1 then '93' else '28' end end as TipoCuentaPorPagar,
rownum as Consecutivo,
tab0.*,

case when tipo_recurso = 0 then nvl(tab0.rubro_anm,tab0.rubro_sgr) else nvl(tab0.rubro_sgr,tab0.rubro_anm) end as rubro_inf,
case when tipo_recurso = 0 then nvl(tab0.descripcion_anm,tab0.descripcion_sgr) else nvl(tab0.descripcion_sgr,tab0.descripcion_anm) end as fuente_inf

from(

    select

    case
        when cont.tipo_recurso is not null then cont.tipo_recurso
        when INSTR(cont.num_contrato,'SGR') = 1 then 1
    else 0 end as tipo_recurso,
    cont.rp_anm,
      replace( (clapre.tipo_gasto || ' ' || rub.rubro) ,' ','-') as rubro_anm,
      clapre.tipo_gasto,
      rub.rubro,
      rub.descripcion as descripcion_rub,
      agrurec.id as id_fuente,
      agrurec.descripcion as descripcion_anm,
      agrurec.abreviatura as abreviatura_fuente,
    cont.rp_sgr,
      replace( ( 'I' || ' ' || rubsgr.rubro) ,' ','-') as rubro_sgr,
      clapresgr.tipo_gasto as tipo_gastosgr,
      rubsgr.rubro as rubrosgr,
      rubsgr.descripcion as descripcion_rubsgr,
      agrurecsgr.id as id_fuentesgr,
      agrurecsgr.descripcion as descripcion_sgr,
      agrurecsgr.abreviatura as abreviatura_fuentesgr,
    contra.declarante_renta,
    contra.num_cuenta,
    tc.descripcion as tipo_cuenta,

    to_char(sysdate,'yyyy-mm-dd') as FechaRegistro,
    '03' as TipoDocumentoIdentidad,
    contra.num_doc as NumeroDocumentoTercero,
    forpag.valor_mensual as ValorPesos,
    0 as TasaCambio,
    forpag.valor_iva as ValorIVA,
    'RADICADO No '|| forpag.numero_radicado || ' - ' || num.descripcion || ' PAGO CONTRATO ' || cont.num_contrato as TextoCreacion,
    'RVC '|| forpag.numero_radicado || ' CTO ' || cont.num_contrato || num.descripcion || ' PAGO PAGO - PERIODO ' || TO_CHAR(forpag.fecha_ini_pago,'yyyy-mm-dd') || ' A ' || TO_CHAR(forpag.fecha_fin_pago,'yyyy-mm-dd') || ' ASIG ' || forpag.razon_soc_usu_asigna as TextoCreacionSGC,
    11 as TipoDocSoporte,
    cont.num_contrato as NumeroDocSoporte,
    to_char(sysdate,'yyyy-mm-dd') as FechaSolicitud,
    11 as Expedidor,
    cont.razon_soc_sup as NombreFuncionario,
    'SUPERVISOR' as CargoFuncionario,
    contra.profesion,

    forpag.*

    from rvc_formato_pago_v forpag

    left join rvc_contrato_v cont
    on forpag.id_contrato = cont.id_contrato

    left join rvc_contratista_v contra
    on forpag.id_contratista = contra.id_contratista

    left join ts_tc tc
    on tc.id = contra.tipo_cuenta

    left join rvc_numero_pago num
    on num.id_numero_pago = forpag.id_numero_pago

    /*ANM*/
    left join (
      SELECT
       aut.*,
       ROW_NUMBER() OVER (
        partition by aut.vigencia, aut.id_rp
        ORDER BY aut.vigencia desc, aut.id_rp, aut.valor desc, aut.id desc
       ) AS rn
      from pr_rp_compromiso aut
    )rpanm
    on cont.rp_anm = rpanm.id_rp and EXTRACT(year FROM cont.fecha_rp) = rpanm.vigencia and 1 = rpanm.id_vigencia
    and rpanm.rn = 1

    left join pr_asig_presup asig
    on rpanm.id_asign = asig.id
    left join pr_apropiacion apro
    on asig.id_apropiacion = apro.id

    left join pr_tipo_rec tiprec
    on tiprec.id = apro.id_tipo_rec
    left join pr_agrup_rec agrurec
    on tiprec.id_agrup = agrurec.id

    left join pr_rubro_presup_v rub
    on apro.id_rubro = rub.id_rubro

    left join pr_codif_presup cod
    on apro.id_rubro = cod.id_rubro
    left join pr_clases_presup clapre
    on clapre.id = cod.id_clase_presup

    /*SGR*/
    left join (
      SELECT
       aut.*,
       ROW_NUMBER() OVER (
        partition by aut.vigencia, aut.id_rp
        ORDER BY aut.vigencia desc, aut.id_rp, aut.valor desc, aut.id desc
       ) AS rn
      from pr_rp_compromiso@PNG_SGR aut
    )rpsgr
    on cont.rp_sgr = rpsgr.id_rp and EXTRACT(year FROM cont.fecha_rp) = rpsgr.vigencia and 1 = rpsgr.id_vigencia
    and rpsgr.rn = 1

    left join pr_asig_presup@PNG_SGR asigsgr
    on rpsgr.id_asign = asigsgr.id
    left join pr_apropiacion@PNG_SGR aprosgr
    on asigsgr.id_apropiacion = aprosgr.id

    left join pr_tipo_rec@PNG_SGR tiprecsgr
    on tiprecsgr.id = aprosgr.id_tipo_rec
    left join pr_agrup_rec@PNG_SGR agrurecsgr
    on tiprecsgr.id_agrup = agrurecsgr.id

    left join pr_rubro_presup_v@PNG_SGR rubsgr
    on aprosgr.id_rubro = rubsgr.id_rubro

    left join pr_codif_presup@PNG_SGR codsgr
    on aprosgr.id_rubro = codsgr.id_rubro
    left join pr_clases_presup@PNG_SGR clapresgr
    on clapresgr.id = codsgr.id_clase_presup

    where
    forpag.estado = 1
    and (($P{entidad_cliente} = 2 and forpag.aprobado = 1) or ( $P{entidad_cliente} = 1 and forpag.asignado = 1 and forpag.obligado = 0))

    order by
    forpag.fecha_radicado,
    forpag.radicado

)tab0

left join datos_compania dat
on dat.id = 1

where
(
    (($P{entidad_cliente} = 2 and trunc(tab0.FECHA_APROBADO) between to_date($P{fecha_ini},'dd/mm/yyyy') and to_date($P{fecha_fin},'dd/mm/yyyy'))
 or ( $P{entidad_cliente} = 1 and trunc(tab0.FECHA_ASIGNADO) between to_date($P{fecha_ini},'dd/mm/yyyy') and to_date($P{fecha_fin},'dd/mm/yyyy')))
)

$P!{whereIdContratista}
$P!{whereIdContrato}
$P!{whereIdNumeroPago}
$P!{whereTipoRecurso}]]>
	</queryString>
	<field name="PCICONEXION" class="java.lang.String"/>
	<field name="CONSECUTIVOCOMPROMISO" class="java.math.BigDecimal"/>
	<field name="TIPOCUENTAPORPAGAR" class="java.lang.String"/>
	<field name="CONSECUTIVO" class="java.math.BigDecimal"/>
	<field name="TIPO_RECURSO" class="java.math.BigDecimal"/>
	<field name="RP_ANM" class="java.math.BigDecimal"/>
	<field name="RUBRO_ANM" class="java.lang.String"/>
	<field name="TIPO_GASTO" class="java.lang.String"/>
	<field name="RUBRO" class="java.lang.String"/>
	<field name="DESCRIPCION_RUB" class="java.lang.String"/>
	<field name="ID_FUENTE" class="java.math.BigDecimal"/>
	<field name="DESCRIPCION_ANM" class="java.lang.String"/>
	<field name="ABREVIATURA_FUENTE" class="java.lang.String"/>
	<field name="RP_SGR" class="java.math.BigDecimal"/>
	<field name="RUBRO_SGR" class="java.lang.String"/>
	<field name="TIPO_GASTOSGR" class="java.lang.String"/>
	<field name="RUBROSGR" class="java.lang.String"/>
	<field name="DESCRIPCION_RUBSGR" class="java.lang.String"/>
	<field name="ID_FUENTESGR" class="java.math.BigDecimal"/>
	<field name="DESCRIPCION_SGR" class="java.lang.String"/>
	<field name="ABREVIATURA_FUENTESGR" class="java.lang.String"/>
	<field name="DECLARANTE_RENTA" class="java.math.BigDecimal"/>
	<field name="NUM_CUENTA" class="java.lang.String"/>
	<field name="TIPO_CUENTA" class="java.lang.String"/>
	<field name="FECHAREGISTRO" class="java.lang.String"/>
	<field name="TIPODOCUMENTOIDENTIDAD" class="java.lang.String"/>
	<field name="NUMERODOCUMENTOTERCERO" class="java.lang.String"/>
	<field name="VALORPESOS" class="java.math.BigDecimal"/>
	<field name="TASACAMBIO" class="java.math.BigDecimal"/>
	<field name="VALORIVA" class="java.math.BigDecimal"/>
	<field name="TEXTOCREACION" class="java.lang.String"/>
	<field name="TEXTOCREACIONSGC" class="java.lang.String"/>
	<field name="TIPODOCSOPORTE" class="java.math.BigDecimal"/>
	<field name="NUMERODOCSOPORTE" class="java.lang.String"/>
	<field name="FECHASOLICITUD" class="java.lang.String"/>
	<field name="EXPEDIDOR" class="java.math.BigDecimal"/>
	<field name="NOMBREFUNCIONARIO" class="java.lang.String"/>
	<field name="CARGOFUNCIONARIO" class="java.lang.String"/>
	<field name="PROFESION" class="java.lang.String"/>
	<field name="ID_FORMATO_PAGO" class="java.math.BigDecimal"/>
	<field name="ID_ANHOS" class="java.math.BigDecimal"/>
	<field name="ID_CONTRATISTA" class="java.math.BigDecimal"/>
	<field name="ID_CONTRATO" class="java.math.BigDecimal"/>
	<field name="ID_NUMERO_PAGO" class="java.math.BigDecimal"/>
	<field name="FECHA_INI_PAGO" class="java.sql.Timestamp"/>
	<field name="FECHA_FIN_PAGO" class="java.sql.Timestamp"/>
	<field name="FECHA_LOG" class="java.sql.Timestamp"/>
	<field name="FECHA_CREACION" class="java.sql.Timestamp"/>
	<field name="USUARIO_LOG" class="java.lang.String"/>
	<field name="VALOR_CONTRATO" class="java.math.BigDecimal"/>
	<field name="VALOR_MENSUAL" class="java.math.BigDecimal"/>
	<field name="VALOR_COMISIONES" class="java.math.BigDecimal"/>
	<field name="VALOR_INGRESOS" class="java.math.BigDecimal"/>
	<field name="VALOR_IVA" class="java.math.BigDecimal"/>
	<field name="VALOR_ING_COMISIONES" class="java.math.BigDecimal"/>
	<field name="VALOR_PAGAR" class="java.math.BigDecimal"/>
	<field name="VALOR_A_PAGAR" class="java.math.BigDecimal"/>
	<field name="VALOR_RETENCION" class="java.math.BigDecimal"/>
	<field name="VALOR_IVA_REG" class="java.math.BigDecimal"/>
	<field name="VALOR_ICA" class="java.math.BigDecimal"/>
	<field name="VALOR_ICA_EXTRA" class="java.math.BigDecimal"/>
	<field name="VALOR_TOTAL_RETEN" class="java.math.BigDecimal"/>
	<field name="NUMERO_PLANILLA" class="java.math.BigDecimal"/>
	<field name="ID_FONDO_SALUD" class="java.math.BigDecimal"/>
	<field name="CODIGO_FONDO_SALUD" class="java.lang.String"/>
	<field name="NIT_FONDO_SALUD" class="java.math.BigDecimal"/>
	<field name="RAZON_SOCIAL_FONDO_SALUD" class="java.lang.String"/>
	<field name="ID_FONDO_PENSION" class="java.math.BigDecimal"/>
	<field name="CODIGO_FONDO_PENSION" class="java.lang.String"/>
	<field name="NIT_FONDO_PENSION" class="java.math.BigDecimal"/>
	<field name="RAZON_SOCIAL_FONDO_PENSION" class="java.lang.String"/>
	<field name="ID_CAJA_COMP" class="java.math.BigDecimal"/>
	<field name="CODIGO_CAJA_COMP" class="java.lang.String"/>
	<field name="NIT_FONDO_CAJA_COMP" class="java.math.BigDecimal"/>
	<field name="RAZON_SOCIAL_CAJA_COMP" class="java.lang.String"/>
	<field name="ID_FONDO_ARL" class="java.math.BigDecimal"/>
	<field name="CODIGO_FONDO_ARL" class="java.lang.String"/>
	<field name="NIT_FONDO_ARL" class="java.math.BigDecimal"/>
	<field name="RAZON_SOCIAL_FONDO_ARL" class="java.lang.String"/>
	<field name="ID_TIPO_RIESGO" class="java.math.BigDecimal"/>
	<field name="DIAS_LIQ" class="java.math.BigDecimal"/>
	<field name="TARIFA_RETEN" class="java.math.BigDecimal"/>
	<field name="TARIFA_IVA" class="java.math.BigDecimal"/>
	<field name="TARIFA_ICA" class="java.math.BigDecimal"/>
	<field name="VALOR_BASE_RETEN" class="java.math.BigDecimal"/>
	<field name="VALOR_BASE_ICA" class="java.math.BigDecimal"/>
	<field name="APORTE_SALUD" class="java.math.BigDecimal"/>
	<field name="APORTE_PENSION" class="java.math.BigDecimal"/>
	<field name="APORTE_FSP" class="java.math.BigDecimal"/>
	<field name="APORTE_ARL" class="java.math.BigDecimal"/>
	<field name="APORTE_VOLUN_AFC" class="java.math.BigDecimal"/>
	<field name="APORTE_VOLUN_PEN" class="java.math.BigDecimal"/>
	<field name="VALOR_INTERESES_VIVIENDA" class="java.math.BigDecimal"/>
	<field name="VALOR_DEPENDIENTES" class="java.math.BigDecimal"/>
	<field name="VALOR_MEDICINA" class="java.math.BigDecimal"/>
	<field name="VALOR_EMBARGO" class="java.math.BigDecimal"/>
	<field name="ADJUNTO_SALUD" class="java.lang.String"/>
	<field name="ADJUNTO_PENSION" class="java.lang.String"/>
	<field name="ADJUNTO_FSP" class="java.lang.String"/>
	<field name="ADJUNTO_ARL" class="java.lang.String"/>
	<field name="ADJUNTO_AFC" class="java.lang.String"/>
	<field name="ADJUNTO_VOLUNT" class="java.lang.String"/>
	<field name="ADJUNTO_VIVIENDA" class="java.lang.String"/>
	<field name="ADJUNTO_DEPEN" class="java.lang.String"/>
	<field name="ADJUNTO_MEDICINA" class="java.lang.String"/>
	<field name="ESTADO" class="java.math.BigDecimal"/>
	<field name="FECHA_ESTADO" class="java.sql.Timestamp"/>
	<field name="USUARIO_ESTADO" class="java.lang.String"/>
	<field name="OBSERVACIONES_ESTADO" class="java.lang.String"/>
	<field name="NIVEL_RECHAZO" class="java.math.BigDecimal"/>
	<field name="FIRMADO" class="java.math.BigDecimal"/>
	<field name="FECHA_FIRMADO" class="java.sql.Timestamp"/>
	<field name="REVISADO" class="java.math.BigDecimal"/>
	<field name="FECHA_REVISADO" class="java.sql.Timestamp"/>
	<field name="USUARIO_REVISADO" class="java.math.BigDecimal"/>
	<field name="OBSERVACION_REV" class="java.lang.String"/>
	<field name="AUTORIZADO" class="java.math.BigDecimal"/>
	<field name="FECHA_AUTORIZADO" class="java.sql.Timestamp"/>
	<field name="USUARIO_AUTORIZADO" class="java.math.BigDecimal"/>
	<field name="OBSERVACION_AUT" class="java.lang.String"/>
	<field name="RADICADO" class="java.math.BigDecimal"/>
	<field name="NUMERO_RADICADO" class="java.math.BigDecimal"/>
	<field name="FECHA_RADICADO" class="java.sql.Timestamp"/>
	<field name="FECHA_RADICADO_TRUNC" class="java.sql.Timestamp"/>
	<field name="ADJUNTO_FACTURA" class="java.lang.String"/>
	<field name="APROBADO" class="java.math.BigDecimal"/>
	<field name="FECHA_APROBADO" class="java.sql.Timestamp"/>
	<field name="USUARIO_APROBADO" class="java.lang.String"/>
	<field name="OBSERVACIONES_APROB" class="java.lang.String"/>
	<field name="ASIGNADO" class="java.math.BigDecimal"/>
	<field name="FECHA_ASIGNADO" class="java.sql.Timestamp"/>
	<field name="USUARIO_ASIGNADO" class="java.lang.String"/>
	<field name="OBLIGADO" class="java.math.BigDecimal"/>
	<field name="FECHA_OBLIGADO" class="java.sql.Timestamp"/>
	<field name="USUARIO_OBLIGADO" class="java.lang.String"/>
	<field name="CARGASIIF" class="java.math.BigDecimal"/>
	<field name="FECHA_CARGASIIF" class="java.sql.Timestamp"/>
	<field name="USUARIO_CARGASIIF" class="java.lang.String"/>
	<field name="VALOR_DEDUCCION" class="java.math.BigDecimal"/>
	<field name="ADJUNTO_PLANILLA_OPCIONAL" class="java.lang.String"/>
	<field name="ADJUNTO_CERT_SALUD" class="java.lang.String"/>
	<field name="ESTADO_GENERAL" class="java.math.BigDecimal"/>
	<field name="DESC_ESTADO_GENERAL" class="java.lang.String"/>
	<field name="OBS_ESTADO_GENERAL" class="java.lang.String"/>
	<field name="FECHA_ESTADO_GENERAL" class="java.sql.Timestamp"/>
	<field name="USUARIO_ESTADO_GENERAL" class="java.lang.String"/>
	<field name="NUM_DOC_USU_LOG" class="java.lang.String"/>
	<field name="RAZON_SOC_USU_LOG" class="java.lang.String"/>
	<field name="NUM_DOC_USU_ESTADO" class="java.lang.String"/>
	<field name="RAZON_SOC_USU_ESTADO" class="java.lang.String"/>
	<field name="EMAIL_USU_ESTADO" class="java.lang.String"/>
	<field name="NUM_DOC_USU_APROBO" class="java.lang.String"/>
	<field name="RAZON_SOC_USU_APROBO" class="java.lang.String"/>
	<field name="NUM_DOC_USU_ASIGNA" class="java.lang.String"/>
	<field name="RAZON_SOC_USU_ASIGNA" class="java.lang.String"/>
	<field name="NUM_DOC_USU_OBLIGO" class="java.lang.String"/>
	<field name="RAZON_SOC_USU_OBLIGO" class="java.lang.String"/>
	<field name="RAZON_SOC_USU_AUTORIZO" class="java.lang.String"/>
	<field name="RAZON_SOC_USU_REVISADO" class="java.lang.String"/>
	<field name="ADJUNTOS_ACTIVIDADES" class="java.lang.String"/>
	<field name="ADJUNTO_ACTA_INICIO" class="java.lang.String"/>
	<field name="APLICA_PLANILLA_APORTES" class="java.math.BigDecimal"/>
	<field name="FECHA_EXP_MEDICINA" class="java.sql.Timestamp"/>
	<field name="FECHA_EXP_INT_VIVIENDA" class="java.sql.Timestamp"/>
	<field name="VALOR_RP_ANM_CONT" class="java.math.BigDecimal"/>
	<field name="VALOR_RP_SGR_CONT" class="java.math.BigDecimal"/>
	<field name="VALOR_RP_ANM_DOBLE" class="java.math.BigDecimal"/>
	<field name="VALOR_RP_SGR_DOBLE" class="java.math.BigDecimal"/>
	<field name="COTIZA_IBC_DIF" class="java.math.BigDecimal"/>
	<field name="VALOR_COTIZA_IBC" class="java.math.BigDecimal"/>
	<field name="VALOR_CAJA_COMP" class="java.math.BigDecimal"/>
	<field name="TARIFA_CAJA_COMP" class="java.math.BigDecimal"/>
	<field name="PAGADO" class="java.math.BigDecimal"/>
	<field name="IDS_PAGADO" class="java.lang.String"/>
	<field name="ID_PAGO_OBL_FORM_PAGO" class="java.math.BigDecimal"/>
	<field name="SGR_PAGO" class="java.math.BigDecimal"/>
	<field name="FECHA_PROC_PAGO" class="java.sql.Timestamp"/>
	<field name="USUARIO_PAGO" class="java.lang.String"/>
	<field name="OBSERVACIONES_PAGO" class="java.lang.String"/>
	<field name="COMISION_FORM_PAGO" class="java.lang.String"/>
	<field name="ID_TIPO_REGIMEN" class="java.math.BigDecimal"/>
	<field name="TIPO_REGIMEN" class="java.lang.String"/>
	<field name="FECHA_CERT_SEGURIDAD_TRA" class="java.sql.Timestamp"/>
	<field name="ID_DECLARA_JURA_NOV" class="java.math.BigDecimal"/>
	<field name="FECHA_CONSIGNA_AFC" class="java.sql.Timestamp"/>
	<field name="FECHA_CONSIGNA_VOLUN_PEN" class="java.sql.Timestamp"/>
	<field name="ANHO_GRAVABLE_INT_VIV" class="java.math.BigDecimal"/>
	<field name="ANHO_GRAVABLE_MEDICINA" class="java.math.BigDecimal"/>
	<field name="APLICA_PENSION_MENOR" class="java.math.BigDecimal"/>
	<field name="APLICA_APORTE_SOLIDARIO" class="java.math.BigDecimal"/>
	<field name="VALOR_APORTE_SOLIDARIO" class="java.math.BigDecimal"/>
	<field name="APLICA_TEXT_APORTE_SOLIDARIO" class="java.math.BigDecimal"/>
	<field name="VALOR_OTRA_ENTIDAD" class="java.math.BigDecimal"/>
	<field name="BASE_APORTE_SOLIDARIO" class="java.math.BigDecimal"/>
	<field name="TOAL_MENSUAL_OTRA_ENTIDAD" class="java.math.BigDecimal"/>
	<field name="PORCENTAJE_ENTIDAD" class="java.math.BigDecimal"/>
	<field name="PORCENTAJE_OTRA_ENTID" class="java.math.BigDecimal"/>
	<field name="VALOR_APO_SOLIDARIO_OTRA_ENTID" class="java.math.BigDecimal"/>
	<field name="ADJUNTO_OTRA_ENTIDAD" class="java.lang.String"/>
	<field name="BASE_PROPORCION_APO_SOLID" class="java.math.BigDecimal"/>
	<field name="ADJUNTO_RUT_CONTRA" class="java.lang.String"/>
	<field name="ADJUNTO_ARL_CONTRA" class="java.lang.String"/>
	<field name="ADJUNTO_PENSIONADO_CONTRA" class="java.lang.String"/>
	<field name="ADJUNTO_CAJA_COMP_CONTRA" class="java.lang.String"/>
	<field name="ADJUNTO_FONDO_SALUD_CONTRA" class="java.lang.String"/>
	<field name="ADJUNTO_FONDO_PENSION_CONTRA" class="java.lang.String"/>
	<field name="FECHA_GENERA_RUT_CONTRA" class="java.sql.Timestamp"/>
	<field name="RESPONSABLE_FACT_ELECT" class="java.math.BigDecimal"/>
	<field name="TARIFA_ESTAMPILLA" class="java.math.BigDecimal"/>
	<field name="VALOR_ESTAMPILLA" class="java.math.BigDecimal"/>
	<field name="VALOR_BASE_ESTAMPILLA" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_SEG_SOCIAL" class="java.math.BigDecimal"/>
	<field name="TIPO_SEG_SOCIAL" class="java.lang.String"/>
	<field name="ID_CIUDAD" class="java.math.BigDecimal"/>
	<field name="CIUDAD_FORMATO" class="java.lang.String"/>
	<field name="ID_ACTIVIDAD_CIIU" class="java.math.BigDecimal"/>
	<field name="CODIGO_CIIU" class="java.lang.String"/>
	<field name="DESCRIPCION_CIIU" class="java.lang.String"/>
	<field name="ID_DEDUC_VOLUN" class="java.math.BigDecimal"/>
	<field name="CUENTA_DEDUC" class="java.math.BigDecimal"/>
	<field name="TERCERO_DEDUCCION" class="java.lang.String"/>
	<field name="TIPO_CUENTA_DEDUC" class="java.lang.String"/>
	<field name="ID_DIAN_ACTIVIDAD" class="java.math.BigDecimal"/>
	<field name="CODIGO_ACTIVIDAD" class="java.lang.String"/>
	<field name="DESCRIPCION_DIAN_ACT" class="java.lang.String"/>
	<field name="VALOR_RENTA_EXCENTA_25" class="java.math.BigDecimal"/>
	<field name="CIFRA_CONTROL_40" class="java.math.BigDecimal"/>
	<field name="ADJUNTO_OTROS" class="java.lang.String"/>
	<field name="IVA_COMISIONES" class="java.math.BigDecimal"/>
	<field name="NUMERO_FACTURAS" class="java.lang.String"/>
	<field name="RUBRO_INF" class="java.lang.String"/>
	<field name="FUENTE_INF" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="60" splitType="Stretch">
			<textField pattern="dd-MMM-yyyy   hh:mm aaa">
				<reportElement mode="Opaque" x="905" y="40" width="250" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="200" y="0" width="705" height="40"/>
				<textElement textAlignment="Center" verticalAlignment="Bottom" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Sistema de Radicación Virtual de Cuentas
Informe Carga Masiva Cuentas por Pagar]]></text>
			</staticText>
			<image>
				<reportElement x="0" y="10" width="130" height="40"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
			<staticText>
				<reportElement mode="Opaque" x="905" y="28" width="250" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Fecha de Impresión:]]></text>
			</staticText>
			<textField>
				<reportElement x="200" y="40" width="705" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Periodo: " + $P{fecha_ini} + " a " +$P{fecha_fin}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="11" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="10" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="200" y="0" width="120" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[TipoDocumentoIdentidad]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="70" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[PCIConexion]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="70" y="0" width="60" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Consecutivo]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="130" y="0" width="70" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[FechaRegistro]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="445" y="0" width="120" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[ConsecutivoCompromiso]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="565" y="0" width="100" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[TipoCuentaPorPagar]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="665" y="0" width="90" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[ValorPesos]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="755" y="0" width="70" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[TasaCambio]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="825" y="0" width="80" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[ValorIVA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="905" y="0" width="250" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[TextoCreacion]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1235" y="0" width="90" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[NumeroDocSoporte]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1155" y="0" width="80" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[TipoDocSoporte]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1325" y="0" width="80" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[FechaSolicitud]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1405" y="0" width="60" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Expedidor]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1465" y="0" width="180" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[NombreFuncionario]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1645" y="0" width="100" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CargoFuncionario]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="320" y="0" width="125" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[NumeroDocumentoTercero]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1745" y="0" width="100" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Observacion]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1845" y="0" width="100" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[urlDocumento]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1945" y="0" width="95" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[urlDescripcion]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="10" splitType="Stretch">
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="200" y="0" width="120" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TIPODOCUMENTOIDENTIDAD}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="0" y="0" width="70" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PCICONEXION}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="70" y="0" width="60" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CONSECUTIVO}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="130" y="0" width="70" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{FECHAREGISTRO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1645" y="0" width="100" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CARGOFUNCIONARIO}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="445" y="0" width="120" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CONSECUTIVOCOMPROMISO}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="565" y="0" width="100" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TIPOCUENTAPORPAGAR}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="665" y="0" width="90" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALORPESOS}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="755" y="0" width="70" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{TASACAMBIO}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="825" y="0" width="80" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALORIVA}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="905" y="0" width="250" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{entidad_cliente}.toString() == "1"?
$F{TEXTOCREACIONSGC}:
$F{TEXTOCREACION}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1155" y="0" width="80" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TIPODOCSOPORTE}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1235" y="0" width="90" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUMERODOCSOPORTE}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1325" y="0" width="80" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{FECHASOLICITUD}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1405" y="0" width="60" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{EXPEDIDOR}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1465" y="0" width="180" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NOMBREFUNCIONARIO}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="320" y="0" width="125" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUMERODOCUMENTOTERCERO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1745" y="0" width="100" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1845" y="0" width="100" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1945" y="0" width="95" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="12" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="24" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="488" y="12" width="89" height="12" forecolor="#575757" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Página "+$V{PAGE_NUMBER}+" de "]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement mode="Opaque" x="578" y="12" width="60" height="12" forecolor="#575757" backcolor="#FFFFFF"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="488" y="0" width="150" height="12" forecolor="#575757"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<text><![CDATA[Websafi - Radicación Virtual]]></text>
			</staticText>
		</band>
	</pageFooter>
	<summary>
		<band height="11" splitType="Stretch"/>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="1155" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
