<?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="inf_plan_pagos" language="groovy" pageWidth="1050" pageHeight="612" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="1010" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.3310000000000062"/>
	<property name="ireport.x" value="364"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/radicacionvirtualcuentas/inf_plan_pagos"/>
	<property name="ireport.jasperserver.url" value="http://3.22.202.200:8080/jasperserver/services/repository"/>
	<property name="ireport.layers" value="##Mon Jun 06 08:13:21 COT 2022\nlayer.1.name=Layer 1\nlayer.1.visible=true\nlayer.1.id=1\nlayer.0.name=Background\nlayer.0.visible=true\nlayer.0.id=0"/>
	<parameter name="whereIdContratista" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereNumContrato" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereEstado" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="num_contrato" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT
tab0.id_contrato,
tab0.id_contratista,
tab0.num_contrato,
tab0.estado,
tab12.id_obligacion,
tab0.adic,
rnp.numero,
to_char(tab12.fecha_sistema,'yyyy-mm-dd') as fecha_sistemas,
to_char(tab12.nro_orden_pago) as nro_orden_pago,
to_char(tab12.fecha_proc,'yyyy-mm-dd') as fecha_proc,
ta.razon_social,
tab0.numero_pago,

TO_CHAR(tab0.fecha_ini_pago,'yyyy-mm-dd') as fecha_ini,
TO_CHAR(tab0.fecha_fin_pago,'yyyy-mm-dd') as fecha_fin,

tab0.valor_mensual,
(tab0.valor_contrato + tab0.adic) as valor_contrato,
(tab0.valor_sgr+tab0.valor_anm) as valor_contrato_c

 FROM (SELECT num_contrato, LISTAGG(id_contrato ,', ') WITHIN GROUP (ORDER BY num_contrato) as id_contrato FROM RVC_CONTRATO  GROUP BY num_contrato) contrato
LEFT JOIN (SELECT tab0.id_contrato,
tab0.id_contratista,
tab0.num_contrato,
tab0.estado,
tab0.numero_pago,
tab0.valor_sgr,
tab0.valor_anm,
nvl(tab1.valor_anm_new,0) + nvl(tab1.valor_sgr_new,0) as adic,
tab.id_formato_pago,
tab.valor_mensual,
tab.valor_contrato,
tab.id_numero_pago,
tab.fecha_ini_pago,
tab.fecha_fin_pago
FROM RVC_CONTRATO tab0
LEFT JOIN RVC_FORMATO_PAGO tab ON tab.id_contrato=tab0.id_contrato AND tab.estado!=0
LEFT JOIN RVC_NOVEDAD_PRORR_TERMI tab1 ON tab1.id_contrato=tab0.id_contrato
) tab0 ON to_char(tab0.num_contrato) IN (contrato.num_contrato)
 LEFT JOIN RVC_CONTRATISTA ta ON ta.id_contratista=tab0.id_contratista
LEFT JOIN RVC_NUMERO_PAGO rnp ON tab0.id_numero_pago= rnp.id_numero_pago
LEFT JOIN (
 SELECT
   aut.*,
   ROW_NUMBER() OVER (
    partition by aut.ID_FORMATO_PAGO
    ORDER BY aut.ID_FORMATO_PAGO, aut.fecha_proc desc
   ) AS rn
  from (
  select

    tabpag.id_pago_obl_form_pago,
    tabpag.id_formato_pago,
    tabpag.id_pago_obl,
    tabpag.sgr,
        pag.nro_orden_pago,
    emi.fecha_proc,
    usu.num_doc ||' - ' || usu.nombre || ' ' || usu.apellido  as usuario,
    tab1.observaciones,
    tab1.id_obligacion,
    tab1.fecha_sistema

    FROM rvc_pago_obl_form_pago tabpag

    left join ts_pago_obl pag
    on pag.id_pago_obl = tabpag.id_pago_obl

    left join ts_emision_pago emi
    on emi.id_emision_pago = pag.id_emision_pago

    left join TS_OBLIGACION tab1
    on pag.id_obligacion = tab1.id_obligacion
    and pag.vigencia = tab1.ano_fiscal
    and pag.id_vigencia = tab1.id_vigencia
    and pag.secuencia = tab1.secuencia

    left join usuario usu
    on usu.username = emi.usuario

    where
    tabpag.sgr = 0
    and pag.estado is null

    union

    select

    tabpag.id_pago_obl_form_pago,
    tabpag.id_formato_pago,
    tabpag.id_pago_obl,
    tabpag.sgr,
            pag.nro_orden_pago,
    emi.fecha_proc,
    usu.num_doc ||' - ' || usu.nombre || ' ' || usu.apellido  as usuario,
    tab1.observaciones,
    tab1.id_obligacion,
        tab1.fecha_sistema

    FROM rvc_pago_obl_form_pago tabpag

    left join ts_pago_obl@PNG_SGR pag
    on pag.id_pago_obl = tabpag.id_pago_obl

    left join ts_emision_pago@PNG_SGR emi
    on emi.id_emision_pago = pag.id_emision_pago

    left join TS_OBLIGACION@PNG_SGR tab1
    on pag.id_obligacion = tab1.id_obligacion
    and pag.vigencia = tab1.ano_fiscal
    and pag.id_vigencia = tab1.id_vigencia
    and pag.secuencia = tab1.secuencia

    left join usuario usu
    on usu.username = emi.usuario

    where
    tabpag.sgr = 1
    and pag.estado is null


)aut

)tab12
ON tab12.id_formato_pago = tab0.id_formato_pago
and tab12.rn = 1
where
1=1
$P!{whereNumContrato}
$P!{whereIdContratista}
$P!{whereEstado}

ORDER BY tab0.id_contrato,tab0.num_contrato, rnp.numero,tab0.fecha_ini_pago]]>
	</queryString>
	<field name="ID_CONTRATO" class="java.math.BigDecimal"/>
	<field name="ID_CONTRATISTA" class="java.math.BigDecimal"/>
	<field name="NUM_CONTRATO" class="java.lang.String"/>
	<field name="ESTADO" class="java.math.BigDecimal"/>
	<field name="ID_OBLIGACION" class="java.math.BigDecimal"/>
	<field name="ADIC" class="java.math.BigDecimal"/>
	<field name="NUMERO" class="java.math.BigDecimal"/>
	<field name="FECHA_SISTEMAS" class="java.lang.String"/>
	<field name="NRO_ORDEN_PAGO" class="java.lang.String"/>
	<field name="FECHA_PROC" class="java.lang.String"/>
	<field name="RAZON_SOCIAL" class="java.lang.String"/>
	<field name="NUMERO_PAGO" class="java.math.BigDecimal"/>
	<field name="FECHA_INI" class="java.lang.String"/>
	<field name="FECHA_FIN" class="java.lang.String"/>
	<field name="VALOR_MENSUAL" class="java.math.BigDecimal"/>
	<field name="VALOR_CONTRATO" class="java.math.BigDecimal"/>
	<field name="VALOR_CONTRATO_C" class="java.math.BigDecimal"/>
	<variable name="variable1" class="java.math.BigDecimal" resetType="Group" resetGroup="Contrato" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_MENSUAL}]]></variableExpression>
		<initialValueExpression><![CDATA[]]></initialValueExpression>
	</variable>
	<variable name="variable2" class="java.math.BigDecimal" resetType="Group" resetGroup="Contrato" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_CONTRATO_C} + $F{ADIC} - $V{variable1}]]></variableExpression>
	</variable>
	<group name="Contrato">
		<groupExpression><![CDATA[$F{NUM_CONTRATO}]]></groupExpression>
		<groupHeader>
			<band height="6"/>
		</groupHeader>
	</group>
	<group name="Contratista">
		<groupExpression><![CDATA[$F{ID_CONTRATISTA}]]></groupExpression>
		<groupHeader>
			<band height="105">
				<staticText>
					<reportElement mode="Opaque" x="300" y="74" width="100" height="30" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="1.0"/>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Fecha de la orden de pago]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="0" y="74" width="100" height="30" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="1.0"/>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[No. Obligación]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="400" y="74" width="100" height="30" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="1.0"/>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[No. del pago]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="100" y="74" width="100" height="30" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="1.0"/>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Fecha de la obligación]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="200" y="74" width="100" height="30" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="1.0"/>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[No. orden de pago]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="500" y="74" width="100" height="30" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="1.0"/>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Fecha inicial del pago]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="600" y="74" width="100" height="30" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="1.0"/>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Fecha final del pago]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="700" y="74" width="100" height="30" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="1.0"/>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Valor del pago mensual]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="800" y="74" width="100" height="30" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="1.0"/>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Saldo del contrato]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="900" y="74" width="110" height="30" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="1.0"/>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Valor acumulado de ejecución]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="100" height="30" forecolor="#000000" backcolor="#F5DE8B"/>
					<box>
						<pen lineWidth="1.0"/>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Nombre Contratista]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="0" y="30" width="100" height="30" forecolor="#000000" backcolor="#F5DE8B"/>
					<box>
						<pen lineWidth="1.0"/>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Número del Contrato]]></text>
				</staticText>
				<textField pattern="" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="100" y="0" width="200" height="30" backcolor="#F5DE8B"/>
					<box>
						<pen lineWidth="1.0"/>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font size="10" isBold="true" isUnderline="false" isStrikeThrough="false"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOCIAL}]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="100" y="30" width="200" height="30" backcolor="#F5DE8B"/>
					<box>
						<pen lineWidth="1.0"/>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="10" isBold="true" isUnderline="false" isStrikeThrough="false"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_CONTRATO}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="300" y="0" width="100" height="30" forecolor="#000000" backcolor="#F5DE8B"/>
					<box>
						<pen lineWidth="1.0"/>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Valor del Contrato]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="300" y="30" width="100" height="30" forecolor="#000000" backcolor="#F5DE8B"/>
					<box>
						<pen lineWidth="1.0"/>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Valor del pago mensual]]></text>
				</staticText>
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="400" y="0" width="200" height="30" backcolor="#F5DE8B"/>
					<box>
						<pen lineWidth="1.0"/>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="10" isBold="true" isUnderline="false" isStrikeThrough="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_CONTRATO_C}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="400" y="30" width="200" height="30" backcolor="#F5DE8B"/>
					<box>
						<pen lineWidth="1.0"/>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="10" isBold="true" isUnderline="false" isStrikeThrough="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_MENSUAL}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="600" y="0" width="100" height="30" forecolor="#000000" backcolor="#F5DE8B"/>
					<box>
						<pen lineWidth="1.0"/>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Valor Adición]]></text>
				</staticText>
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="700" y="0" width="200" height="30" backcolor="#F5DE8B"/>
					<box>
						<pen lineWidth="1.0"/>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="10" isBold="true" isUnderline="false" isStrikeThrough="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{ADIC}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="700" y="30" width="200" height="30" backcolor="#F5DE8B"/>
					<box>
						<pen lineWidth="1.0"/>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="10" isBold="true" isUnderline="false" isStrikeThrough="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_CONTRATO_C}+$F{ADIC}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="600" y="30" width="100" height="30" forecolor="#000000" backcolor="#F5DE8B"/>
					<box>
						<pen lineWidth="1.0"/>
						<topPen lineWidth="1.0"/>
						<leftPen lineWidth="1.0"/>
						<bottomPen lineWidth="1.0"/>
						<rightPen lineWidth="1.0"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Valor Total del Contrato]]></text>
				</staticText>
			</band>
		</groupHeader>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="66">
			<staticText>
				<reportElement x="400" y="0" width="200" height="50"/>
				<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" markup="none">
					<font fontName="SansSerif" size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[Sistema de Radicación Virtual de Cuentas Plan de Pagos]]></text>
			</staticText>
		</band>
	</title>
	<detail>
		<band height="13">
			<printWhenExpression><![CDATA[$F{ID_CONTRATO}!=null]]></printWhenExpression>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="100" height="12"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="10" isBold="true" isUnderline="false" isStrikeThrough="false"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$F{ID_OBLIGACION}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="400" y="0" width="100" height="12"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="10" isBold="true" isUnderline="false" isStrikeThrough="false"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$F{NUMERO}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="500" y="0" width="100" height="12"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="10" isBold="true" isUnderline="false" isStrikeThrough="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{FECHA_INI}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="600" y="0" width="100" height="12"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="10" isBold="true" isUnderline="false" isStrikeThrough="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{FECHA_FIN}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="700" y="0" width="100" height="12"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="10" isBold="true" isUnderline="false" isStrikeThrough="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_MENSUAL}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="800" y="0" width="100" height="12"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="10" isBold="true" isUnderline="false" isStrikeThrough="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_CONTRATO_C} + $F{ADIC} - $V{variable1}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="900" y="0" width="110" height="12"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="10" isBold="true" isUnderline="false" isStrikeThrough="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{variable1}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="100" y="0" width="100" height="12"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="10" isBold="true" isUnderline="false" isStrikeThrough="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{FECHA_SISTEMAS}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="200" y="0" width="100" height="12"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="10" isBold="true" isUnderline="false" isStrikeThrough="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NRO_ORDEN_PAGO}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="300" y="0" width="100" height="12"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="10" isBold="true" isUnderline="false" isStrikeThrough="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{FECHA_PROC}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<pageFooter>
		<band height="66" splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band height="50"/>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="1010" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
