<?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="liquidacion_deuda" language="groovy" pageWidth="420" pageHeight="400" orientation="Landscape" columnWidth="420" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
	<property name="ireport.zoom" value="2.1435888100000016"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="id_periodo_filtro" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="num_doc" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_novedad_vac" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_resolucion_tit" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereRemisionIN" class="java.lang.String">
		<defaultValueExpression><![CDATA["and id_remision_titulo in (0)"]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select
--tab0.anho_remision,
--tab0.numero_remision,
--tab0.cod_titulo,
tab0.id_concepto_deuda,
upper(tab0.descripcion_concepto) as descripcion_concepto,
tab0.id_tipo_liquida,
nvl(sum(tab0.valor_capital),0) as valor_capital,
nvl(sum(tab0.valor_interes),0) as valor_interes,
nvl(sum(tab0.valor_indexacion),0) as valor_indexacion,
nvl(sum(tab0.valor_abono),0) as valor_abono,
nvl(sum(tab0.saldo),0) as saldo,
nvl(sum(tab0.valor_abono_calc),0) as valor_abono_calc,
nvl(sum(tab0.valor_acuerdo),0) as valor_acuerdo,
nvl(sum(tab0.valor_embargo),0) as valor_embargo

from(

    select
    remdet.id_remision_titulo_det as id_remision_titulo_det,
    remdet.id_remision_titulo,
    remdet.cod_titulo,
    rem.id_par,
    rem.numero_correpondencia,

    rem.anho_remision,
    rem.numero_remision,
    rem.fecha_remision,

    tab0.id_liquida_concepto as id_liquida_concepto,
    tab0.id_debito as id_debito, tab0.id_concepto_deuda as id_concepto_deuda,
    tab0.fecha_ejecutoria as fecha_ejecutoria_liq,
    tab0.fecha_ini as fecha_ini, tab0.fecha_fin as fecha_fin, tab0.dias as dias,
    tab0.id_tasa_interes as id_tasa_interes,
    tab0.id_ipc_ini as id_ipc_ini, tab0.id_ipc_fin as id_ipc_fin,

    tab4.id_tipo_liquida,
    nvl(tab0.valor_capital,0) as valor_capital,
    nvl(case when tab4.id_tipo_liquida != 4 then tab0.valor_interes else 0 end,0) as valor_interes,
    nvl(case when tab4.id_tipo_liquida = 4 then tab0.valor_interes else 0 end,0) as valor_indexacion,
    nvl(tab0.valor_abono,0) as valor_abono,
    nvl(tab0.saldo,0) as saldo,
    tab0.porce_abono_calc as porce_abono_calc,
    nvl(tab0.valor_abono_calc,0) as valor_abono_calc,
    nvl(tab0.valor_acuerdo,0) as valor_acuerdo,
    nvl(tab0.valor_embargo,0) as valor_embargo,
    tab0.observaciones as observaciones,

    tab4.descripcion as descripcion_concepto,
    tab5.descripcion as descripcion_tasa,
    tab6.valor as valor_ipc_ini,
    tab7.valor as valor_ipc_fin,

    deb.sec_debito,
    deb.fecha_proceso,
    deb.id_anhos,
    deb.estado as estado_deb

    from  cbr_remision_titulo_det remdet

    left join cbr_remision_titulo rem on rem.id_remision_titulo = remdet.id_remision_titulo

    left join cbr_liquida_concepto tab0 on tab0.id_remision_titulo_det = remdet.id_remision_titulo_det
    left join cbr_remision_titulo rem on rem.id_remision_titulo = remdet.id_remision_titulo
    left join cbr_concepto_deuda tab4 on tab0.id_concepto_deuda = tab4.id_concepto_deuda
    left join ca_tasa_interes tab5 on tab0.id_tasa_interes = tab5.id_tasa_interes
    left join ca_ipc tab6 on tab0.ID_IPC_INI = tab6.ID_IPC
    left join ca_ipc tab7 on tab0.ID_IPC_FIN = tab7.ID_IPC

    left join ca_debito deb on tab0.id_debito = deb.id_debito

    where
    tab0.ID_LIQUIDA_CONCEPTO is not null

)tab0

where
tab0.id_remision_titulo != '-1'
$P!{whereRemisionIN}

group by
--tab0.anho_remision,
--tab0.numero_remision,
--tab0.cod_titulo,
tab0.id_concepto_deuda,
tab0.descripcion_concepto,
tab0.id_tipo_liquida

order by
tab0.id_concepto_deuda,
tab0.descripcion_concepto,
--tab0.anho_remision,
--tab0.numero_remision,
--tab0.cod_titulo,
tab0.id_tipo_liquida,
tab0.descripcion_concepto]]>
	</queryString>
	<field name="ID_CONCEPTO_DEUDA" class="java.math.BigDecimal"/>
	<field name="DESCRIPCION_CONCEPTO" class="java.lang.String"/>
	<field name="ID_TIPO_LIQUIDA" class="java.math.BigDecimal"/>
	<field name="VALOR_CAPITAL" class="java.math.BigDecimal"/>
	<field name="VALOR_INTERES" class="java.math.BigDecimal"/>
	<field name="VALOR_INDEXACION" class="java.math.BigDecimal"/>
	<field name="VALOR_ABONO" class="java.math.BigDecimal"/>
	<field name="SALDO" class="java.math.BigDecimal"/>
	<field name="VALOR_ABONO_CALC" class="java.math.BigDecimal"/>
	<field name="VALOR_ACUERDO" class="java.math.BigDecimal"/>
	<field name="VALOR_EMBARGO" class="java.math.BigDecimal"/>
	<variable name="capital" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_CAPITAL}]]></variableExpression>
	</variable>
	<variable name="interes" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_INTERES}]]></variableExpression>
	</variable>
	<variable name="indexacion" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_INDEXACION}]]></variableExpression>
	</variable>
	<variable name="valor_abono" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_ABONO}]]></variableExpression>
	</variable>
	<variable name="saldo" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{SALDO}]]></variableExpression>
	</variable>
	<variable name="abono_cal" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_ABONO_CALC}]]></variableExpression>
	</variable>
	<variable name="acuerdo" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_ACUERDO}]]></variableExpression>
	</variable>
	<variable name="embargo" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_EMBARGO}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<columnHeader>
		<band height="20">
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="420" height="20" forecolor="#000000" backcolor="#AED6FB"/>
				<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[LIQUIDACIÓN DEUDA]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="20" splitType="Stretch">
			<textField>
				<reportElement mode="Transparent" x="0" y="0" width="320" height="20" forecolor="#000000" backcolor="#A4CFF6"/>
				<box leftPadding="3">
					<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESCRIPCION_CONCEPTO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="320" y="0" width="100" height="20" forecolor="#000000" backcolor="#FFFFFF"/>
				<box topPadding="1" leftPadding="0" bottomPadding="1" 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="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_CAPITAL}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<summary>
		<band height="240">
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="320" y="120" width="100" height="20" forecolor="#000000" backcolor="#C7C7C7"/>
				<box topPadding="1" leftPadding="0" bottomPadding="1" 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="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{acuerdo}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="0" y="120" width="320" height="20" forecolor="#000000" backcolor="#C7C7C7"/>
				<box leftPadding="3">
					<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[VALOR ACUERDO]]></text>
			</staticText>
			<textField>
				<reportElement mode="Transparent" x="0" y="0" width="320" height="20" forecolor="#000000" backcolor="#A4CFF6"/>
				<box leftPadding="3">
					<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["INTERESES"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="320" y="0" width="100" height="20" forecolor="#000000" backcolor="#FFFFFF"/>
				<box topPadding="1" leftPadding="0" bottomPadding="1" 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="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{interes}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Transparent" x="0" y="20" width="320" height="20" forecolor="#000000" backcolor="#A4CFF6"/>
				<box leftPadding="3">
					<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["INDEXACIÓN"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="320" y="20" width="100" height="20" forecolor="#000000" backcolor="#FFFFFF"/>
				<box topPadding="1" leftPadding="0" bottomPadding="1" 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="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{indexacion}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="0" y="40" width="320" height="20" forecolor="#000000" backcolor="#C7C7C7"/>
				<box leftPadding="3">
					<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[TOTAL]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="320" y="40" width="100" height="20" forecolor="#000000" backcolor="#C7C7C7"/>
				<box topPadding="1" leftPadding="0" bottomPadding="1" 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="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{capital}+$V{interes}+$V{indexacion}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="0" y="60" width="420" height="20" forecolor="#000000" backcolor="#C7C7C7"/>
				<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[]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="320" y="100" width="100" height="20" forecolor="#000000" backcolor="#FFFFFF"/>
				<box topPadding="1" leftPadding="0" bottomPadding="1" 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="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{abono_cal}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Transparent" x="0" y="100" width="320" height="20" forecolor="#000000" backcolor="#A4CFF6"/>
				<box leftPadding="3">
					<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["VALOR ABONO (15%)"]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="0" y="80" width="420" height="20" forecolor="#000000" backcolor="#AED6FB"/>
				<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[LIQUIDACIÓN PARA ACUERDO DE PAGO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="160" width="420" height="20" forecolor="#000000" backcolor="#AED6FB"/>
				<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[LIQUIDACIÓN VALOR MAXIMO DE EMBARGO]]></text>
			</staticText>
			<textField>
				<reportElement mode="Transparent" x="0" y="180" width="320" height="20" forecolor="#000000" backcolor="#A4CFF6"/>
				<box leftPadding="3">
					<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["VALOR OBLIGACIÓN"]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="0" y="220" width="320" height="20" forecolor="#000000" backcolor="#C7C7C7"/>
				<box leftPadding="3">
					<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[VALOR DEL EMBARGO]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="320" y="180" width="100" height="20" forecolor="#000000" backcolor="#FFFFFF"/>
				<box topPadding="1" leftPadding="0" bottomPadding="1" 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="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{capital}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="320" y="220" width="100" height="20" forecolor="#000000" backcolor="#C7C7C7"/>
				<box topPadding="1" leftPadding="0" bottomPadding="1" 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="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{embargo}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="320" y="200" width="100" height="20" forecolor="#000000" backcolor="#FFFFFF"/>
				<box topPadding="1" leftPadding="0" bottomPadding="1" 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="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{interes}+$V{indexacion}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Transparent" x="0" y="200" width="320" height="20" forecolor="#000000" backcolor="#A4CFF6"/>
				<box leftPadding="3">
					<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["INTERESES / INDEXACIÓN"]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="0" y="140" width="420" height="20" forecolor="#000000" backcolor="#C7C7C7"/>
				<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[]]></text>
			</staticText>
		</band>
	</summary>
</jasperReport>
