<?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_nov_contrato" language="groovy" pageWidth="1700" pageHeight="612" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="1660" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.100000000000002"/>
	<property name="ireport.x" value="562"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/cartera/log_novedad_cartera"/>
	<property name="ireport.jasperserver.url" value="http://192.168.2.43:8090/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="whereTipoContrato" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereContrato" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereEntidadContrato" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereSupervisorCont" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTipoNovCont" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT
tab0.id_novedad_contrato as id_novedad_contrato,
tab0.id_contrato as id_contrato, tab0.id_ts_td as id_ts_td,
tab0.doc_soporte as doc_soporte, tab0.id_tipo_nov_cont as id_tipo_nov_cont,
tab0.fecha_novedad as fecha_novedad,
tab0.observaciones as observaciones,
tab0.fecha_log as fecha_log, tab0.usuario_log as usuario_log,
tab0.valor_desembolsado as valor_desembolsado, tab0.valor_rendimientos as valor_rendimientos,
tab0.valor_no_ejecutado as valor_no_ejecutado, tab0.valor_no_reconocido as valor_no_reconocido,
tab0.indexacion as indexacion, tab0.valor_intereses_banco as valor_intereses_banco,
tab0.valor_intereses_mora as valor_intereses_mora,
tab0.reintegros_efectuados as reintegros_efectuados,
tab0.no_certificado as no_certificado, tab0.destinatario as destinatario,
tab0.destinatario_cargo as destinatario_cargo, tab0.no_radicado as no_radicado,
tab0.objeto as objeto,
tab0.fecha_legalizacion as fecha_legalizacion,
tab0.dias_leg as dias_leg, tab0.obser_indexacion as obser_indexacion,
tab0.obser_interes_mora as obser_interes_mora, tab0.obser_interes_banco as obser_interes_banco,
tab0.obser_saldo_pendiente as obser_saldo_pendiente, tab0.anexo_cetificado as anexo_cetificado,
tab0.firmado as firmado,
tab0.fecha_firmado as fecha_firmado, tab0.usuario_firmado as usuario_firmado,
tab0.valor_ajuste_banco as valor_ajuste_banco, tab0.valor_ajuste_mora as valor_ajuste_mora,
tab0.valor_ajuste_indexacion as valor_ajuste_indexacion,
tab0.fecha_legalizacion_real as fecha_legalizacion_real,
tab0.fecha_legalizacion_limite as fecha_legalizacion_limite,
tab0.aplica_dia_ant as aplica_dia_ant,
tab0.fecha_inicial_indexacion as fecha_inicial_indexacion,
tab0.fecha_final_indexacion as fecha_final_indexacion,
tab1.id_tipo_contrato as id_tipo_contrato, tab1.descripcion as descripcion,
tab1.codigo as codigo, tab1.id_anhos as id_anhos, tab1.codigo_anhos as codigo_anhos,
tab1.fecha_proceso as fecha_proceso,
tab1.fecha_inicial as fecha_inicial,
tab1.fecha_termina as fecha_termina, tab1.valor_compania as valor_compania,
tab1.valor_entidad as valor_entidad, tab1.valor_contrato as valor_contrato,
tab1.aplica_salvedad as aplica_salvedad, tab1.aplica_indexacion as aplica_indexacion,
tab1.estado as estado, tab1.id_supervisor_cont as id_supervisor_cont, tab1.codigo_tipcont as codigo_tipcont,
tab1.descripcion_tipcont as descripcion_tipcont, tab1.id_mae_ter_sup as id_mae_ter_sup,
tab1.num_doc_sup as num_doc_sup, tab1.dv_sup as dv_sup, tab1.razon_soc_sup as razon_soc_sup,
tab1.correo_sup as correo_sup, tab1.cargo_sup as cargo_sup, tab1.correo_ter as correo_ter,
tab2.codigo as codigo_tipnov, tab2.descripcion as descripcion_tipnov,
tab2.estado as estado_tipnov, tab2.aplica_cartera as aplica_cartera,
tab3.documento as documento, tab3.descripcion as descripcion_td

FROM CACO_NOVEDAD_CONTRATO_V tab0

JOIN CACO_CONTRATO_V tab1 ON tab0.id_contrato = tab1.id_contrato

JOIN CACO_TIPO_NOV_CONT tab2 ON tab0.id_tipo_nov_cont = tab2.id_tipo_nov_cont

LEFT JOIN TS_TD tab3 ON tab0.id_ts_td = tab3.id

WHERE
tab0.id_novedad_contrato != '-1'
AND tab0.fecha_novedad BETWEEN to_date($P{fecha_ini}, 'dd/mm/yyyy') AND to_date($P{fecha_fin}, 'dd/mm/yyyy')
$P!{whereTipoContrato}
$P!{whereContrato}
$P!{whereEntidadContrato}
$P!{whereSupervisorCont}
$P!{whereTipoNovCont}

ORDER BY
id_anhos ,
codigo ,
id_tipo_nov_cont ,
fecha_novedad ,
no_certificado ]]>
	</queryString>
	<field name="ID_NOVEDAD_CONTRATO" class="java.math.BigDecimal"/>
	<field name="ID_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="FECHA_LOG" class="java.sql.Timestamp"/>
	<field name="USUARIO_LOG" 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="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="FECHA_LEGALIZACION" class="java.sql.Timestamp"/>
	<field name="DIAS_LEG" 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="FIRMADO" class="java.math.BigDecimal"/>
	<field name="FECHA_FIRMADO" class="java.sql.Timestamp"/>
	<field name="USUARIO_FIRMADO" class="java.lang.String"/>
	<field name="VALOR_AJUSTE_BANCO" class="java.math.BigDecimal"/>
	<field name="VALOR_AJUSTE_MORA" class="java.math.BigDecimal"/>
	<field name="VALOR_AJUSTE_INDEXACION" class="java.math.BigDecimal"/>
	<field name="FECHA_LEGALIZACION_REAL" class="java.sql.Timestamp"/>
	<field name="FECHA_LEGALIZACION_LIMITE" class="java.sql.Timestamp"/>
	<field name="APLICA_DIA_ANT" class="java.math.BigDecimal"/>
	<field name="FECHA_INICIAL_INDEXACION" class="java.sql.Timestamp"/>
	<field name="FECHA_FINAL_INDEXACION" class="java.sql.Timestamp"/>
	<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="CODIGO_ANHOS" class="java.lang.String"/>
	<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="APLICA_INDEXACION" class="java.math.BigDecimal"/>
	<field name="ESTADO" class="java.math.BigDecimal"/>
	<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_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="DOCUMENTO" class="java.lang.String"/>
	<field name="DESCRIPCION_TD" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="60" splitType="Stretch">
			<staticText>
				<reportElement x="460" y="0" width="685" height="40"/>
				<textElement textAlignment="Center" verticalAlignment="Bottom" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Sistema de Cartera y Contratación
Informe Novedades de Contratos]]></text>
			</staticText>
			<image>
				<reportElement x="0" y="10" width="140" height="40"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
			<staticText>
				<reportElement mode="Opaque" x="1445" y="32" width="215" height="14" 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="460" y="40" width="685" 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>
			<textField pattern="dd/MM/yyyy  hh:mm aaa">
				<reportElement x="1445" y="46" width="215" height="14"/>
				<box rightPadding="3"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="20" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="25" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="915" y="0" width="80" height="25" 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">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Valor Contrato o Convenio]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="120" height="25" 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">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Tipo Contrato]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="835" y="0" width="80" height="25" 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">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Contrapartida]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="700" y="0" width="55" height="25" 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">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Firmado]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="995" y="0" width="50" height="25" 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">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Aplica Salvedad]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1445" y="0" width="60" height="25" 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">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Documento Supervisor Contrato]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1505" y="0" width="155" height="25" 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">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Supervisor Contrato]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="120" y="0" width="60" height="25" 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">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[No. Contrato]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="180" y="0" width="130" height="25" 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">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Tipo Novedad Contrato]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="460" y="0" width="60" height="25" 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">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Fecha Inicial]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="520" y="0" width="60" height="25" 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">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Fecha Terminación]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="755" y="0" width="80" height="25" 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">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Aporte Colciencias]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="580" y="0" width="60" height="25" 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">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[No. Certificado]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="310" y="0" width="150" height="25" 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">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Destinatario]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="640" y="0" width="60" height="25" 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">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Fecha Novedad]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1045" y="0" width="100" height="25" 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">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Valor Desembolsos]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1145" y="0" width="100" height="25" 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">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Rendimientos Fianancieros]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1245" y="0" width="100" height="25" 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">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Resursos No Ejecutados]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1345" y="0" width="100" height="25" 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">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Recursos No Reconocidos]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="10" splitType="Stretch">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="120" height="10"/>
				<box leftPadding="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">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESCRIPCION_TIPCONT}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="835" y="0" width="80" height="10"/>
				<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">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_ENTIDAD}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="700" y="0" width="55" height="10"/>
				<box leftPadding="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" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[( $F{FIRMADO} == 1
    ? "Si"
    : "No"
)]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="995" y="0" width="50" height="10"/>
				<box leftPadding="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" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[( $F{APLICA_SALVEDAD} == 1
    ? "X"
    : ""
)]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1445" y="0" width="60" height="10"/>
				<box leftPadding="2">
					<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">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_DOC_SUP}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1505" y="0" width="155" height="10"/>
				<box leftPadding="2">
					<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">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOC_SUP}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="120" y="0" width="60" height="10"/>
				<box leftPadding="2">
					<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">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CODIGO_ANHOS}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="180" y="0" width="130" height="10"/>
				<box leftPadding="2" 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="Left" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESCRIPCION_TIPNOV}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="460" y="0" width="60" height="10"/>
				<box leftPadding="2">
					<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">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{FECHA_INICIAL}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="520" y="0" width="60" height="10"/>
				<box leftPadding="2">
					<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">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{FECHA_TERMINA}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="755" y="0" width="80" height="10"/>
				<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">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_COMPANIA}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="915" y="0" width="80" height="10"/>
				<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">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_CONTRATO}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="310" y="0" width="150" height="10"/>
				<box leftPadding="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">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESTINATARIO}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="580" y="0" width="60" height="10"/>
				<box leftPadding="2">
					<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">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NO_CERTIFICADO}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="640" y="0" width="60" height="10"/>
				<box leftPadding="2">
					<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">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{FECHA_NOVEDAD}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1045" y="0" width="100" height="10"/>
				<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">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_DESEMBOLSADO}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1145" y="0" width="100" height="10"/>
				<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">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_RENDIMIENTOS}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1245" y="0" width="100" height="10"/>
				<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">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_NO_EJECUTADO}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1345" y="0" width="100" height="10"/>
				<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">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_NO_RECONOCIDO}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="23" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="24" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="765" 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="855" 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="765" y="0" width="150" height="12" forecolor="#575757"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<text><![CDATA[Websafi - Cartera y Contratación]]></text>
			</staticText>
		</band>
	</pageFooter>
	<summary>
		<band height="25" splitType="Stretch"/>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="1660" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
