<?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="caco_inf_indexacion" language="groovy" pageWidth="700" pageHeight="792" whenNoDataType="NoDataSection" columnWidth="556" leftMargin="72" rightMargin="72" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.3310000000000064"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/nomina/certif_general_anm"/>
	<property name="ireport.jasperserver.url" value="http://10.0.100.49:8080/jasperserver/services/repository"/>
	<parameter name="id_novedad_contrato" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_contrato" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT

to_char(sysdate,'yyyy/mm/dd') as  fecha_inf,

tab0.id_contrato as id_contrato, tab0.id_tipo_contrato as id_tipo_contrato,
tab0.descripcion as descripcion,
tab0.codigo as codigo, tab0.id_anhos as id_anhos,
tab0.fecha_proceso as fecha_proceso,
tab0.fecha_inicial as fecha_inicial,
tab0.fecha_termina as fecha_termina,
tab0.valor_compania as valor_compania, tab0.valor_entidad as valor_entidad,
tab0.valor_contrato as valor_contrato, tab0.aplica_salvedad as aplica_salvedad,
tab0.estado as estado,
tab0.fecha_log as fecha_log, upper(tab0.usuario_log) as usuario_log,
tab0.fecha_anu as fecha_anu, tab0.motivo_anu as motivo_anu,
tab0.usuario_anu as usuario_anu,
tab0.id_supervisor_cont as id_supervisor_cont,

tab0.codigo_tipcont as codigo_tipcont, tab0.descripcion_tipcont as descripcion_tipcont,
tab0.id_mae_ter_sup as id_mae_ter_sup, tab0.num_doc_sup as num_doc_sup,
tab0.dv_sup as dv_sup, tab0.razon_soc_sup as razon_soc_sup, tab0.correo_sup as correo_sup,
tab0.cargo_sup as cargo_sup, tab0.correo_ter as correo_ter, tab0.codigo_anhos as codigo_anhos,
tab0.no_completo as no_completo, tab0.completo_sup as completo_sup,
tab0.id_entidad_contrato as id_entidad_contrato, tab0.num_doc_ent as num_doc_ent,
tab0.dv_ent as dv_ent, tab0.razon_soc_ent as razon_soc_ent, tab0.completo_ent as completo_ent,
tab0.correo_ent as correo_ent, tab0.referencia as referencia,
tab0.referencia_tipo as referencia_tipo,

tab1.id_novedad_contrato as id_novedad_contrato,
tab1.id_ts_td as id_ts_td,
tab1.doc_soporte as doc_soporte,
tab1.id_tipo_nov_cont as id_tipo_nov_cont,
tab1.fecha_novedad as fecha_novedad,
tab1.observaciones as observaciones,
tab1.valor_desembolsado as valor_desembolsado,
tab1.valor_rendimientos as valor_rendimientos,
tab1.valor_no_ejecutado as valor_no_ejecutado,
tab1.valor_no_reconocido as valor_no_reconocido,
tab1.indexacion as indexacion,
tab1.valor_intereses_banco as valor_intereses_banco,
tab1.valor_intereses_mora as valor_intereses_mora,
tab1.reintegros_efectuados as reintegros_efectuados,

tab1.obser_indexacion,
tab1.obser_interes_mora,
tab1.obser_interes_banco,
tab1.obser_saldo_pendiente,
tab1.anexo_cetificado,

tab1.valor_no_ejecutado + tab1.valor_no_reconocido + tab1.indexacion + tab1.valor_intereses_banco + tab1.valor_intereses_mora - tab1.reintegros_efectuados as saldo,
tab1.no_certificado,
tab1.destinatario,
tab1.destinatario_cargo,
tab1.no_radicado,
tab1.objeto,
upper(tab1.usuario_log) as usuario_log_nov,

tab2.codigo as codigo_tipnov,
tab2.descripcion as descripcion_tipnov,
tab2.estado as estado_tipnov,
tab2.aplica_cartera as aplica_cartera,

tab0.valor_desembolso,
tab0.tag_subreport1,
tab0.tag_subreport2,
tab0.tag_subreport3,
tab0.valor_rendimiento,

calmor.FECHA_INI,
calmor.FECHA_FIN,
calmor.tasa_total_ind,
calmor.IPC_INCIAL,
calmor.IPC_FINAL,
TO_CHAR(calmor.tasa_total_ind, 'FM9,999,999,999.99') || ' %' as tasa_total_ind_text,
calmor.VALOR_CAPITAL,
calmor.VALOR_ind as valor_interes,

calmorfin.FECHA_FIN as FECHA_FIN_fin,
calmorfin.FECHA_FIN as FECHA_FIN_mes,

reint.fecha_novedad as fecha_cre,
nvl(reint.valor_abono,0) as valor_abono,

tab1.valor_ajuste_indexacion

FROM CACO_CONTRATO_V tab0

left join caco_novedad_contrato tab1
on tab1.id_contrato = tab0.id_contrato

left join caco_tipo_nov_cont tab2
on tab2.id_tipo_nov_cont = tab1.id_tipo_nov_cont

left join (
  SELECT
   aut.*,
   ROW_NUMBER() OVER (
    partition by aut.id_novedad_contrato
    ORDER BY aut.fecha_ini asc
   ) AS rn
  from caco_calculo_indexacion aut
)calmor
on calmor.id_contrato = tab0.id_contrato
and calmor.id_novedad_contrato = tab1.id_novedad_contrato

left join (
  SELECT
   aut.*,
   ROW_NUMBER() OVER (
    partition by aut.id_novedad_contrato
    ORDER BY aut.fecha_ini desc
   ) AS rn
  from caco_calculo_indexacion aut
)calmorfin
on calmorfin.id_contrato = tab0.id_contrato
and calmorfin.id_novedad_contrato = tab1.id_novedad_contrato
and calmorfin.rn = 1

left join(

    select
    tab0.id_novedad_contrato,
    min(tab0.fecha_cre) as fecha_cre,
    sum(tab0.valor_abono) as valor_abono
    from(
        SELECT
        tab0.*,
        debcre.id_credito,
        debcre.sec_credito,
        debcre.fecha_cre,
        nvl(debcre.valor_cre,0) as valor_cre,
        nvl(debcre.valor_abono,0) as valor_abono,
        nvl(debcre.excedente,0) as excedente,
        debcre.observaciones_credet

        FROM caco_novedad_contrato_debito tab0

        left join ca_debito_credito debcre
        on debcre.id_debito = tab0.id_debito

        where
        tab0.id_novedad_contrato = $P{id_novedad_contrato}
        and tab0.estado = 1
        and debcre.id_credito is not null

    )tab0

    group by
    tab0.id_novedad_contrato

)cred
on cred.id_novedad_contrato = tab1.id_novedad_contrato

left join(
    select
    tab0.id_novedad_contrato,
    max(tab0.fecha_novedad) as fecha_novedad,
    sum(tab0.valor_reintegro - tab0.valor_excedente) as valor_abono
    from(

        SELECT
        tab0.*,
        reint.id_novedad_contrato

        FROM caco_novedad_reintegro tab0

        left join caco_nov_cont_reint reint
        on reint.id_novedad_reintegro = tab0.id_novedad_reintegro

        where
        reint.id_novedad_contrato = $P{id_novedad_contrato}

    )tab0

    group by
    tab0.id_novedad_contrato
)reint
on reint.id_novedad_contrato = tab1.id_novedad_contrato


WHERE
tab0.id_contrato = $P{id_contrato}
and tab1.id_novedad_contrato = $P{id_novedad_contrato}

ORDER BY
tab0.id_anhos,
tab0.codigo,
tab0.fecha_proceso,
tab1.fecha_novedad,
calmor.fecha_ini]]>
	</queryString>
	<field name="FECHA_INF" class="java.lang.String"/>
	<field name="ID_CONTRATO" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_CONTRATO" class="java.math.BigDecimal"/>
	<field name="DESCRIPCION" class="java.lang.String"/>
	<field name="CODIGO" class="java.lang.String"/>
	<field name="ID_ANHOS" class="java.math.BigDecimal"/>
	<field name="FECHA_PROCESO" class="java.sql.Timestamp"/>
	<field name="FECHA_INICIAL" class="java.sql.Timestamp"/>
	<field name="FECHA_TERMINA" class="java.sql.Timestamp"/>
	<field name="VALOR_COMPANIA" class="java.math.BigDecimal"/>
	<field name="VALOR_ENTIDAD" class="java.math.BigDecimal"/>
	<field name="VALOR_CONTRATO" class="java.math.BigDecimal"/>
	<field name="APLICA_SALVEDAD" class="java.math.BigDecimal"/>
	<field name="ESTADO" class="java.math.BigDecimal"/>
	<field name="FECHA_LOG" class="java.sql.Timestamp"/>
	<field name="USUARIO_LOG" class="java.lang.String"/>
	<field name="FECHA_ANU" class="java.sql.Timestamp"/>
	<field name="MOTIVO_ANU" class="java.lang.String"/>
	<field name="USUARIO_ANU" class="java.lang.String"/>
	<field name="ID_SUPERVISOR_CONT" class="java.math.BigDecimal"/>
	<field name="CODIGO_TIPCONT" class="java.lang.String"/>
	<field name="DESCRIPCION_TIPCONT" class="java.lang.String"/>
	<field name="ID_MAE_TER_SUP" class="java.math.BigDecimal"/>
	<field name="NUM_DOC_SUP" class="java.lang.String"/>
	<field name="DV_SUP" class="java.math.BigDecimal"/>
	<field name="RAZON_SOC_SUP" class="java.lang.String"/>
	<field name="CORREO_SUP" class="java.lang.String"/>
	<field name="CARGO_SUP" class="java.lang.String"/>
	<field name="CORREO_TER" class="java.lang.String"/>
	<field name="CODIGO_ANHOS" class="java.lang.String"/>
	<field name="NO_COMPLETO" class="java.lang.String"/>
	<field name="COMPLETO_SUP" class="java.lang.String"/>
	<field name="ID_ENTIDAD_CONTRATO" class="java.math.BigDecimal"/>
	<field name="NUM_DOC_ENT" class="java.lang.String"/>
	<field name="DV_ENT" class="java.math.BigDecimal"/>
	<field name="RAZON_SOC_ENT" class="java.lang.String"/>
	<field name="COMPLETO_ENT" class="java.lang.String"/>
	<field name="CORREO_ENT" class="java.lang.String"/>
	<field name="REFERENCIA" class="java.lang.String"/>
	<field name="REFERENCIA_TIPO" class="java.lang.String"/>
	<field name="ID_NOVEDAD_CONTRATO" class="java.math.BigDecimal"/>
	<field name="ID_TS_TD" class="java.math.BigDecimal"/>
	<field name="DOC_SOPORTE" class="java.lang.String"/>
	<field name="ID_TIPO_NOV_CONT" class="java.math.BigDecimal"/>
	<field name="FECHA_NOVEDAD" class="java.sql.Timestamp"/>
	<field name="OBSERVACIONES" class="java.lang.String"/>
	<field name="VALOR_DESEMBOLSADO" class="java.math.BigDecimal"/>
	<field name="VALOR_RENDIMIENTOS" class="java.math.BigDecimal"/>
	<field name="VALOR_NO_EJECUTADO" class="java.math.BigDecimal"/>
	<field name="VALOR_NO_RECONOCIDO" class="java.math.BigDecimal"/>
	<field name="INDEXACION" class="java.math.BigDecimal"/>
	<field name="VALOR_INTERESES_BANCO" class="java.math.BigDecimal"/>
	<field name="VALOR_INTERESES_MORA" class="java.math.BigDecimal"/>
	<field name="REINTEGROS_EFECTUADOS" class="java.math.BigDecimal"/>
	<field name="OBSER_INDEXACION" class="java.lang.String"/>
	<field name="OBSER_INTERES_MORA" class="java.lang.String"/>
	<field name="OBSER_INTERES_BANCO" class="java.lang.String"/>
	<field name="OBSER_SALDO_PENDIENTE" class="java.lang.String"/>
	<field name="ANEXO_CETIFICADO" class="java.lang.String"/>
	<field name="SALDO" class="java.math.BigDecimal"/>
	<field name="NO_CERTIFICADO" class="java.math.BigDecimal"/>
	<field name="DESTINATARIO" class="java.lang.String"/>
	<field name="DESTINATARIO_CARGO" class="java.lang.String"/>
	<field name="NO_RADICADO" class="java.lang.String"/>
	<field name="OBJETO" class="java.lang.String"/>
	<field name="USUARIO_LOG_NOV" class="java.lang.String"/>
	<field name="CODIGO_TIPNOV" class="java.lang.String"/>
	<field name="DESCRIPCION_TIPNOV" class="java.lang.String"/>
	<field name="ESTADO_TIPNOV" class="java.math.BigDecimal"/>
	<field name="APLICA_CARTERA" class="java.math.BigDecimal"/>
	<field name="VALOR_DESEMBOLSO" class="java.math.BigDecimal"/>
	<field name="TAG_SUBREPORT1" class="java.math.BigDecimal"/>
	<field name="TAG_SUBREPORT2" class="java.math.BigDecimal"/>
	<field name="TAG_SUBREPORT3" class="java.math.BigDecimal"/>
	<field name="VALOR_RENDIMIENTO" class="java.math.BigDecimal"/>
	<field name="FECHA_INI" class="java.sql.Timestamp"/>
	<field name="FECHA_FIN" class="java.sql.Timestamp"/>
	<field name="TASA_TOTAL_IND" class="java.math.BigDecimal"/>
	<field name="IPC_INCIAL" class="java.math.BigDecimal"/>
	<field name="IPC_FINAL" class="java.math.BigDecimal"/>
	<field name="TASA_TOTAL_IND_TEXT" class="java.lang.String"/>
	<field name="VALOR_CAPITAL" class="java.math.BigDecimal"/>
	<field name="VALOR_INTERES" class="java.math.BigDecimal"/>
	<field name="FECHA_FIN_FIN" class="java.sql.Timestamp"/>
	<field name="FECHA_FIN_MES" class="java.sql.Timestamp"/>
	<field name="FECHA_CRE" class="java.sql.Timestamp"/>
	<field name="VALOR_ABONO" class="java.math.BigDecimal"/>
	<field name="VALOR_AJUSTE_INDEXACION" class="java.math.BigDecimal"/>
	<variable name="total" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_INTERES}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<pageHeader>
		<band height="108" splitType="Stretch">
			<image>
				<reportElement x="199" y="48" width="180" height="50"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
			<textField>
				<reportElement x="0" y="0" width="556" height="20" isRemoveLineWhenBlank="true"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="10" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["DEPARTAMENTO ADMINISTRATIVO DE CIENCIA TECNOLOGIA E INNOVACION - COLCIENCIAS"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="20" width="556" height="20" isRemoveLineWhenBlank="true"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="10" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["DIRECCION ADMINISTRATIVA Y FINANCIERA"]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="169" splitType="Stretch">
			<printWhenExpression><![CDATA[$V{PAGE_NUMBER} == 1]]></printWhenExpression>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="0" y="0" width="180" height="16" isRemoveLineWhenBlank="true"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75" lineStyle="Double"/>
					<leftPen lineWidth="0.75" lineStyle="Double"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="true" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Recursos No Ejecutados"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="$ #,##0.00" isBlankWhenNull="true">
				<reportElement x="180" y="0" width="90" height="16" isRemoveLineWhenBlank="true"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75" lineStyle="Double"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.75" lineStyle="Double"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="false" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_NO_EJECUTADO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="0" y="16" width="180" height="16" isRemoveLineWhenBlank="true"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.5" lineStyle="Double"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="true" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Recursos No Reconocidos"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="$ #,##0.00" isBlankWhenNull="true">
				<reportElement x="180" y="16" width="90" height="16" isRemoveLineWhenBlank="true"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.75" lineStyle="Double"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="false" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_NO_RECONOCIDO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="144" width="75" height="25"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75" lineStyle="Double"/>
					<leftPen lineWidth="0.75" lineStyle="Double"/>
					<bottomPen lineWidth="0.75" lineStyle="Double"/>
					<rightPen lineWidth="0.75" lineStyle="Double"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[DESDE]]></text>
			</staticText>
			<staticText>
				<reportElement x="75" y="144" width="75" height="25"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75" lineStyle="Double"/>
					<leftPen lineWidth="0.75" lineStyle="Double"/>
					<bottomPen lineWidth="0.75" lineStyle="Double"/>
					<rightPen lineWidth="0.75" lineStyle="Double"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[HASTA]]></text>
			</staticText>
			<staticText>
				<reportElement x="150" y="144" width="120" height="25"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75" lineStyle="Double"/>
					<leftPen lineWidth="0.75" lineStyle="Double"/>
					<bottomPen lineWidth="0.75" lineStyle="Double"/>
					<rightPen lineWidth="0.75" lineStyle="Double"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[CAPITAL]]></text>
			</staticText>
			<staticText>
				<reportElement x="340" y="144" width="70" height="25"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75" lineStyle="Double"/>
					<leftPen lineWidth="0.75" lineStyle="Double"/>
					<bottomPen lineWidth="0.75" lineStyle="Double"/>
					<rightPen lineWidth="0.75" lineStyle="Double"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[TASA FINAL]]></text>
			</staticText>
			<staticText>
				<reportElement x="410" y="144" width="146" height="25"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75" lineStyle="Double"/>
					<leftPen lineWidth="0.75" lineStyle="Double"/>
					<bottomPen lineWidth="0.75" lineStyle="Double"/>
					<rightPen lineWidth="0.75" lineStyle="Double"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[VALOR INDEXACIÓN]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="340" y="0" width="216" height="16" isRemoveLineWhenBlank="true"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="true" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Contrato / Convenio:"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement x="340" y="16" width="216" height="16" isRemoveLineWhenBlank="true"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="false" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESCRIPCION}+" "+$F{CODIGO_ANHOS}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement x="340" y="48" width="216" height="30" isRemoveLineWhenBlank="true"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="false" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOC_ENT}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="340" y="32" width="216" height="16" isRemoveLineWhenBlank="true"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="true" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Entidad:"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="93" width="556" height="20" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$V{PAGE_NUMBER} == 1]]></printWhenExpression>
				</reportElement>
				<box leftPadding="0">
					<pen lineWidth="0.75" lineStyle="Double"/>
					<topPen lineWidth="0.75" lineStyle="Double"/>
					<leftPen lineWidth="0.75" lineStyle="Double"/>
					<bottomPen lineWidth="0.75" lineStyle="Double"/>
					<rightPen lineWidth="0.75" lineStyle="Double"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="10" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["INDEXACIÓN"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="0" y="64" width="180" height="16" isRemoveLineWhenBlank="true"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.75" lineStyle="Double"/>
					<bottomPen lineWidth="0.75" lineStyle="Double"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="true" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Valor reintegro"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="$ #,##0.00" isBlankWhenNull="true">
				<reportElement x="180" y="64" width="90" height="16"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75" lineStyle="Double"/>
					<rightPen lineWidth="0.75" lineStyle="Double"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="false" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_ABONO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="0" y="32" width="180" height="16" isRemoveLineWhenBlank="true"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.75" lineStyle="Double"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="true" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Fecha de terminación del contrato"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="0" y="48" width="180" height="16" isRemoveLineWhenBlank="true"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="true" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Fecha del reintegro"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="dd-MM-yyyy" isBlankWhenNull="true">
				<reportElement x="180" y="48" width="90" height="16"/>
				<box leftPadding="0" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.75" lineStyle="Double"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="false" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{FECHA_CRE}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="dd-MM-yyyy" isBlankWhenNull="true">
				<reportElement x="180" y="32" width="90" height="16" isRemoveLineWhenBlank="true"/>
				<box leftPadding="0" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.75" lineStyle="Double"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="false" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{FECHA_TERMINA}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="124" width="556" height="20" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$V{PAGE_NUMBER} == 1]]></printWhenExpression>
				</reportElement>
				<box leftPadding="0">
					<pen lineWidth="0.75" lineStyle="Double"/>
					<topPen lineWidth="0.75" lineStyle="Double"/>
					<leftPen lineWidth="0.75" lineStyle="Double"/>
					<bottomPen lineWidth="0.75" lineStyle="Double"/>
					<rightPen lineWidth="0.75" lineStyle="Double"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="10" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["LIQUIDACIÓN DE INDEXACIÓN POR FECHAS"]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="270" y="144" width="70" height="25"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75" lineStyle="Double"/>
					<leftPen lineWidth="0.75" lineStyle="Double"/>
					<bottomPen lineWidth="0.75" lineStyle="Double"/>
					<rightPen lineWidth="0.75" lineStyle="Double"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[TASA INICIAL]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="12" splitType="Stretch">
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="0" y="0" width="75" height="12"/>
				<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"/>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{FECHA_INI}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="75" y="0" width="75" height="12"/>
				<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"/>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{FECHA_FIN}]]></textFieldExpression>
			</textField>
			<textField pattern="$ #,##0.00" isBlankWhenNull="true">
				<reportElement x="150" y="0" width="120" height="12"/>
				<box 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"/>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_CAPITAL}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement x="340" y="0" width="70" height="12"/>
				<box rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center"/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{IPC_FINAL}]]></textFieldExpression>
			</textField>
			<textField pattern="$ #,##0" isBlankWhenNull="true">
				<reportElement x="410" y="0" width="146" height="12"/>
				<box 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"/>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_INTERES}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement x="270" y="0" width="70" height="12"/>
				<box rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center"/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{IPC_INCIAL}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="9" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="10" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="1" y="0" width="52" height="10" forecolor="#B1B1B1" backcolor="#FEFEFE"/>
				<textElement 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.lang.String"><![CDATA["Página "+$V{PAGE_NUMBER}+" de "]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement mode="Opaque" x="53" y="0" width="322" height="10" forecolor="#B1B1B1" backcolor="#FEFEFE"/>
				<textElement 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.lang.String"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band height="109">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="0" y="28" width="350" height="16" isRemoveLineWhenBlank="true"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0" lineStyle="Double"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="true" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["TOTAL INDEXACIÓN A: "]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="$ #,##0" isBlankWhenNull="true">
				<reportElement x="410" y="55" width="146" height="16" isRemoveLineWhenBlank="true"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75" lineStyle="Double"/>
					<leftPen lineWidth="0.75" lineStyle="Double"/>
					<bottomPen lineWidth="0.75" lineStyle="Double"/>
					<rightPen lineWidth="0.75" lineStyle="Double"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="10" isBold="false" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_NO_EJECUTADO} + $F{INDEXACION}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="0" y="55" width="350" height="16" isRemoveLineWhenBlank="true"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0" lineStyle="Double"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="true" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["TOTAL INDEXACIÓN + CAPITAL"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="$ #,##0" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="410" y="28" width="146" height="16" isRemoveLineWhenBlank="true" backcolor="#D9D9D9"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75" lineStyle="Double"/>
					<leftPen lineWidth="0.75" lineStyle="Double"/>
					<bottomPen lineWidth="0.75" lineStyle="Double"/>
					<rightPen lineWidth="0.75" lineStyle="Double"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="10" isBold="false" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{INDEXACION}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="0" y="83" width="350" height="16" isRemoveLineWhenBlank="true"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0" lineStyle="Double"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="true" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["TOTAL INDEXACIÓN + CAPITAL + AJUSTE"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="$ #,##0" isBlankWhenNull="true">
				<reportElement x="410" y="83" width="146" height="16"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75" lineStyle="Double"/>
					<leftPen lineWidth="0.75" lineStyle="Double"/>
					<bottomPen lineWidth="0.75" lineStyle="Double"/>
					<rightPen lineWidth="0.75" lineStyle="Double"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="10" isBold="false" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_NO_EJECUTADO} + $F{INDEXACION} + $F{VALOR_AJUSTE_INDEXACION}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="dd-MM-yyyy" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="350" y="28" width="60" height="16" backcolor="#D9D9D9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75" lineStyle="Double"/>
					<leftPen lineWidth="0.75" lineStyle="Double"/>
					<bottomPen lineWidth="0.75" lineStyle="Double"/>
					<rightPen lineWidth="0.75" lineStyle="Double"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="false" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{FECHA_FIN_FIN}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="dd-MM-yyyy" isBlankWhenNull="true">
				<reportElement x="350" y="83" width="60" height="16"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75" lineStyle="Double"/>
					<leftPen lineWidth="0.75" lineStyle="Double"/>
					<bottomPen lineWidth="0.75" lineStyle="Double"/>
					<rightPen lineWidth="0.75" lineStyle="Double"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="false" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{FECHA_FIN_MES}]]></textFieldExpression>
			</textField>
			<textField pattern="$ #,##0" isBlankWhenNull="true">
				<reportElement x="410" y="0" width="146" height="12"/>
				<box 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"/>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="556" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
