<?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="formato_control_pagos_SGC" language="groovy" pageWidth="612" pageHeight="792" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="572" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isSummaryWithPageHeaderAndFooter="true">
	<property name="ireport.zoom" value="1.5026296018031589"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="214"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/radicacionvirtualcuentas/formato_pago_contratista_SGC_2021"/>
	<property name="ireport.jasperserver.url" value="http://3.22.202.200:8080/jasperserver/services/repository"/>
	<parameter name="id_contratista" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_contrato" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_formato_pago" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_numero_pago" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select distinct

tab1.id_contrato,
tab1.num_contrato as num_contrato,
tab1.id_anhos as id_anhos,
tab1.fecha_contrato as fecha_contrato,
tab1.objeto as objeto,
tab1.obligaciones as obligaciones,
tab1.estado as estado_contrato,

tab1.fecha_ini as fecha_ini,
tab1.fecha_fin as fecha_fin,
tab1.meses_plazo as meses_plazo,
tab1.dias_plazo as dias_plazo,
tab1.numero_pago as cant_pago,

tab2.tipo_recurso as tipo_recurso,
tab2.id_tipo_doc as id_tipo_doc, tab2.num_doc as num_doc,
tab2.razon_social as razon_social,

/*Ticket 30722,toma el total segun rps, y resta adiciones - 20220811*/
rptotal.valor - (nvl(prorr.valor_anm_new,0)+nvl(prorr.valor_sgr_new,0)+nvl(rptotalnoejec.saldo,0)) + nvl(vigfut.valor_vigencia,0) as valor_inicial,
nvl(prorr.valor_anm_new,0)+nvl(prorr.valor_sgr_new,0) as valor_adicion,
rptotal.valor - nvl(rptotalnoejec.saldo,0) as valor_total,
rptotal.valor - (nvl(prorr.valor_anm_new,0)+nvl(prorr.valor_sgr_new,0)+nvl(rptotalnoejec.saldo,0)) + nvl(vigfut.valor_vigencia,0) + nvl(prorr.valor_anm_new,0)+nvl(prorr.valor_sgr_new,0) as valor_total_con_vig_futura,

'Pesos' as moneda,
rptotal.cdps,
rptotal.rps,

DBMS_LOB.SUBSTR(vigfut.forma_pago) as forma_pago,

contpri.id_contrato as id_contrato_contpri,
contpri.fecha_ini as fecha_ini_contpri,
contpri.fecha_fin as fecha_fin_contpri,
nvl(contpri.meses_plazo,0) as meses_plazo_contpri,
nvl(contpri.dias_plazo,0) as dias_plazo_contpri,

dadic.adicion1 as adicion1,
dadic.adicion2 as adicion2,
dadic.adicion3 as adicion3,

dprorro.prorroga1 as prorroga1,
dprorro.prorroga2 as prorroga2,
dprorro.prorroga3 as prorroga3,

prorr.observaciones_prorr as observaciones,

'' as requisito_pago,

vigfut.id_numero_pago as numero_pago,

pagos.sum_valor_pagar,
/*
pagos.id_formato_pago,
pagos.id_numero_pago,
pagos.valor_pagar,

'No' as modif_pago,
case when pagos.autorizado = 1 then 'Si' else 'No' end as req_pago,
case when pagos.aporte_volun_afc != 0 then 'Si' else 'No' end as des_afc,
case when pagos.valor_estampilla != 0 then 'Si' else 'No' end as estampilla,
case when pagos.responsable_fact_elect != 0 then 'Si' else 'No' end as obli_fact,

pagos.numero_facturas,
'Si' as apor_sss,
'No' as inv_ent,

'Cuenta de cobro'
    || (case when pagos.adjunto_arl is not null then '<br>Pago SSS' else '' end)
    || (case when pagos.adjunto_arl_contra is not null then '<br>Certificación Riesgo ARL' else '' end)
    || (case when pagos.adjunto_fondo_salud_contra is not null then '<br>Certificación afiliación EPS' else '' end)
    || (case when pagos.adjunto_fondo_pension_contra is not null then '<br>Certificación Afiliación Pensión' else '' end)
    || (case when pagos.adjunto_certif_bancaria is not null then '<br>Certificación Bancaria' else '' end)
as soportes,
to_char(pagos.FECHA_OBLIGADO,'dd/mm/yyyy') || ' - ' || pagos.RAZON_SOC_USU_OBLIGO as obliga,
to_char(pagos.FECHA_APROBADO,'dd/mm/yyyy') || ' - ' || pagos.RAZON_SOC_USU_APROBO as apro_fin,
*/
0 as fin

FROM RVC_CONTRATO_V tab1

LEFT JOIN RVC_CONTRATISTA_V tab2 ON tab1.id_contratista = tab2.id_contratista

left join(

    select
    aut.id_contrato,
    aut.id_anhos, aut.num_contrato,
    aut.fecha_ini,
    aut.fecha_fin,
    aut.meses_plazo,
    aut.dias_plazo,
    ROW_NUMBER() OVER (
        partition by aut.id_anhos, aut.num_contrato
        ORDER BY aut.id_anhos, aut.num_contrato, aut.id_contrato asc
    ) AS rn
    from rvc_contrato aut
    where
    (aut.num_contrato,aut.id_anhos) in ( select num_contrato,id_anhos from rvc_contrato where id_contrato = $P{id_contrato} )
    and aut.id_contrato <= $P{id_contrato}

)contpri
on contpri.num_contrato = tab1.num_contrato
and contpri.id_anhos = tab1.id_anhos
and contpri.rn = 1

left join(
    select
    tab0.id_formato_pago,
    tab0.id_numero_pago,
    tab4.valor as valor_vigencia,
    tab8.valor as forma_pago
    from RVC_formato_pago tab0
    join rvc_contrato tab1 on tab1.id_contrato = tab0.id_contrato
    left join co_contrato tab2 on tab2.id_contrato = tab1.id_co_contrato
    left join Co_seleccion_ep tab3 on tab3.id_seleccion_ep = tab2.id_seleccion_ep
    left join co_detalle_ep tab8 on tab3.id_estudios_previos = tab8.id_estudios_previos and tab8.id_campo_ep = 20
    left join CO_VIGENCIA_FUTURA tab4
    on tab4.id_estudios_previos= tab3.id_estudios_previos
    and tab4.fecha_ini_vigencia > tab0.fecha_fin_pago

    where
    tab0.id_formato_pago = $P{id_formato_pago}
)vigfut
on 1 = 1

left join(

    select
    sum(aut.valor_pagar) as sum_valor_pagar
    from rvc_formato_pago_v aut
    left join rvc_contratista cont
    on cont.id_contratista = aut.id_contratista

    where
    aut.id_contrato in ( select id_contrato from rvc_contrato where (num_contrato,id_anhos) in ( select num_contrato,id_anhos from rvc_contrato where id_contrato = $P{id_contrato} ) )
    and aut.id_numero_pago <= $P{id_numero_pago}
    and aut.estado = 1

)pagos
on 1 = 1

left join(
    SELECT
    rpcfp.id_contrato,
    sum(nvl(rpcfp.valor_rp,0)) as valor_rvcfp,
    sum(nvl(contrp.valor,0)) as valor,
    LISTAGG(rpcfp.cdp || '-' || (case when rpcfp.tipo_recurso = 0 then 'PGN' else 'SGR' end), ',') WITHIN GROUP (ORDER BY rpcfp.id_contrato DESC, rpcfp.id_rps_cdps_contrato DESC) as cdps,
    LISTAGG(rpcfp.rp || '-' || (case when rpcfp.tipo_recurso = 0 then 'PGN' else 'SGR' end), ',') WITHIN GROUP (ORDER BY rpcfp.id_contrato DESC, rpcfp.id_rps_cdps_contrato DESC) as rps
    FROM rvc_rps_cdps_contrato rpcfp
    left join rps_contrato_v contrp
    on contrp.rp = rpcfp.rp
    and contrp.vigencia = EXTRACT(YEAR FROM rpcfp.fecha_rp)
    and contrp.sgr = rpcfp.tipo_recurso
    where
    rpcfp.id_contrato in ( $P{id_contrato} )
    group by
    rpcfp.id_contrato
)rptotal
on 1 = 1

left join(
    select tab0.id_contrato, sum(tab0.valor) as saldo
    from RVC_RPS_SALDO_NO_EJECUTADO tab0
    where tab0.estado = 1
    and tab0.id_contrato in ($P{id_contrato})
    group by tab0.id_contrato
)rptotalnoejec on 1 = 1

left join(

    SELECT
    sum(nvl(prorr.valor_anm_new,0)) as valor_anm_new,
    sum(nvl(prorr.valor_sgr_new,0)) as valor_sgr_new,
    to_char(wm_concat(prorr.observaciones)) as observaciones_prorr
    FROM RVC_NOVEDAD_PRORR_TERMI prorr
    where
    /*Ticket 30722, se verifica tome la asociacion segun prorrogas y cesiones anteriores, doble prorroga, o cesion y prorrogas  - 20220811*/
    prorr.id_contrato_new in ($P{id_contrato}, (select novces.id_contrato from rvc_novedad_cesion novces where novces.id_contrato_new = $P{id_contrato}),
        (select novces.id_contrato from RVC_NOVEDAD_PRORR_TERMI novces where novces.id_contrato_new = $P{id_contrato}),
        (select novces.id_contrato from rvc_novedad_cesion novces where novces.id_contrato_new = (select novces.id_contrato from RVC_NOVEDAD_PRORR_TERMI novces where novces.id_contrato_new = $P{id_contrato}))
    )
    and prorr.fecha < (select fecha_fin_pago from rvc_formato_pago where id_formato_pago = $P{id_formato_pago})

)prorr
on 1 = 1

left join(

    select
    wm_concat(rn) as rns,
    sum(case when rn = 1 then adicion else 0 end) as adicion1,
    sum(case when rn = 2 then adicion else 0 end) as adicion2,
    sum(case when rn = 3 then adicion else 0 end) as adicion3
    from (


        select
        rownum as rn,
        prorr.id_novedad_prorr_termi,
        prorr.id_contrato,
        prorr.id_contratista,
        prorr.id_tipo_novedad_cont,
        prorr.fecha_ini_old,
        prorr.fecha_fin_old,
        prorr.fecha_ini_new,
        prorr.valor_anm_old,
        prorr.valor_sgr_old,
        prorr.fecha_fin_new,
        prorr.valor_anm_new,
        prorr.valor_sgr_new,

        nvl(prorr.valor_anm_new,0) + nvl(prorr.valor_sgr_new,0) as adicion,

        trunc(months_between(prorr.fecha_fin_new, prorr.fecha_fin_old)) || ' meses ' || (prorr.fecha_fin_new - trunc( ADD_MONTHS(prorr.fecha_fin_old, trunc(months_between(prorr.fecha_fin_new, prorr.fecha_fin_old))) )+1) || ' días' as prorroga,
        trunc(months_between(prorr.fecha_fin_new, prorr.fecha_fin_old)) AS meses_completos, -- Meses completos
        prorr.fecha_fin_new - trunc( ADD_MONTHS(prorr.fecha_fin_old, trunc(months_between(prorr.fecha_fin_new, prorr.fecha_fin_old))) ) + 1 as dias_diferencia -- Resto de los días

        FROM RVC_NOVEDAD_PRORR_TERMI prorr

        where
        /*Ticket 30722, se verifica tome la asociacion segun prorrogas y cesiones anteriores, doble prorroga, o cesion y prorrogas  - 20220811*/
        prorr.id_contrato_new in ($P{id_contrato}, (select novces.id_contrato from rvc_novedad_cesion novces where novces.id_contrato_new = $P{id_contrato}),
            (select novces.id_contrato from RVC_NOVEDAD_PRORR_TERMI novces where novces.id_contrato_new = $P{id_contrato}),
            (select novces.id_contrato from rvc_novedad_cesion novces where novces.id_contrato_new = (select novces.id_contrato from RVC_NOVEDAD_PRORR_TERMI novces where novces.id_contrato_new = $P{id_contrato}))
        )
        and prorr.id_tipo_novedad_cont != 3
        and prorr.fecha < (select fecha_fin_pago from rvc_formato_pago where id_formato_pago = $P{id_formato_pago})

        order by
        prorr.id_novedad_prorr_termi asc

    )
    where
    adicion != 0

)dadic
on 1 = 1

left join(

    select
    wm_concat(rn) as rns,
    min(case when rn = 1 then prorroga else null end) as prorroga1,
    min(case when rn = 2 then prorroga else null end) as prorroga2,
    min(case when rn = 3 then prorroga else null end) as prorroga3
    from (


        select
        rownum as rn,
        prorr.id_novedad_prorr_termi,
        prorr.id_contrato,
        prorr.id_contratista,
        prorr.id_tipo_novedad_cont,
        prorr.fecha_ini_old,
        prorr.fecha_fin_old,
        prorr.fecha_ini_new,
        prorr.valor_anm_old,
        prorr.valor_sgr_old,
        prorr.fecha_fin_new,
        prorr.valor_anm_new,
        prorr.valor_sgr_new,

        nvl(prorr.valor_anm_new,0) + nvl(prorr.valor_sgr_new,0) as adicion,

        trunc(months_between(prorr.fecha_fin_new, prorr.fecha_fin_old)) || ' meses ' || (prorr.fecha_fin_new - trunc( ADD_MONTHS(prorr.fecha_fin_old, trunc(months_between(prorr.fecha_fin_new, prorr.fecha_fin_old))) )+1) || ' días' as prorroga,
        trunc(months_between(prorr.fecha_fin_new, prorr.fecha_fin_old)) AS meses_completos, -- Meses completos
        prorr.fecha_fin_new - trunc( ADD_MONTHS(prorr.fecha_fin_old, trunc(months_between(prorr.fecha_fin_new, prorr.fecha_fin_old))) ) + 1 as dias_diferencia -- Resto de los días

        FROM RVC_NOVEDAD_PRORR_TERMI prorr

        where
        /*Ticket 30722, se verifica tome la asociacion segun prorrogas y cesiones anteriores, doble prorroga, o cesion y prorrogas  - 20220811*/
        prorr.id_contrato_new in ($P{id_contrato}, (select novces.id_contrato from rvc_novedad_cesion novces where novces.id_contrato_new = $P{id_contrato}),
            (select novces.id_contrato from RVC_NOVEDAD_PRORR_TERMI novces where novces.id_contrato_new = $P{id_contrato}),
            (select novces.id_contrato from rvc_novedad_cesion novces where novces.id_contrato_new = (select novces.id_contrato from RVC_NOVEDAD_PRORR_TERMI novces where novces.id_contrato_new = $P{id_contrato}))
        )
        and prorr.id_tipo_novedad_cont != 3
        and prorr.fecha < (select fecha_fin_pago from rvc_formato_pago where id_formato_pago = $P{id_formato_pago})

        order by
        prorr.id_novedad_prorr_termi asc

    )

)dprorro
on 1 = 1

WHERE
tab1.id_contrato = $P{id_contrato}
AND tab1.id_contratista = $P{id_contratista}

ORDER BY
tab1.id_anhos,
tab1.num_contrato/*,
pagos.id_numero_pago*/]]>
	</queryString>
	<field name="ID_CONTRATO" class="java.math.BigDecimal"/>
	<field name="NUM_CONTRATO" class="java.lang.String"/>
	<field name="ID_ANHOS" class="java.math.BigDecimal"/>
	<field name="FECHA_CONTRATO" class="java.sql.Timestamp"/>
	<field name="OBJETO" class="java.lang.String"/>
	<field name="OBLIGACIONES" class="java.lang.String"/>
	<field name="ESTADO_CONTRATO" class="java.math.BigDecimal"/>
	<field name="FECHA_INI" class="java.sql.Timestamp"/>
	<field name="FECHA_FIN" class="java.sql.Timestamp"/>
	<field name="MESES_PLAZO" class="java.math.BigDecimal"/>
	<field name="DIAS_PLAZO" class="java.math.BigDecimal"/>
	<field name="CANT_PAGO" class="java.math.BigDecimal"/>
	<field name="TIPO_RECURSO" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_DOC" class="java.math.BigDecimal"/>
	<field name="NUM_DOC" class="java.lang.String"/>
	<field name="RAZON_SOCIAL" class="java.lang.String"/>
	<field name="VALOR_INICIAL" class="java.math.BigDecimal"/>
	<field name="VALOR_ADICION" class="java.math.BigDecimal"/>
	<field name="VALOR_TOTAL" class="java.math.BigDecimal"/>
	<field name="VALOR_TOTAL_CON_VIG_FUTURA" class="java.math.BigDecimal"/>
	<field name="MONEDA" class="java.lang.String"/>
	<field name="CDPS" class="java.lang.String"/>
	<field name="RPS" class="java.lang.String"/>
	<field name="FORMA_PAGO" class="java.lang.String"/>
	<field name="ID_CONTRATO_CONTPRI" class="java.math.BigDecimal"/>
	<field name="FECHA_INI_CONTPRI" class="java.sql.Timestamp"/>
	<field name="FECHA_FIN_CONTPRI" class="java.sql.Timestamp"/>
	<field name="MESES_PLAZO_CONTPRI" class="java.math.BigDecimal"/>
	<field name="DIAS_PLAZO_CONTPRI" class="java.math.BigDecimal"/>
	<field name="ADICION1" class="java.math.BigDecimal"/>
	<field name="ADICION2" class="java.math.BigDecimal"/>
	<field name="ADICION3" class="java.math.BigDecimal"/>
	<field name="PRORROGA1" class="java.lang.String"/>
	<field name="PRORROGA2" class="java.lang.String"/>
	<field name="PRORROGA3" class="java.lang.String"/>
	<field name="OBSERVACIONES" class="java.lang.String"/>
	<field name="REQUISITO_PAGO" class="java.lang.String"/>
	<field name="NUMERO_PAGO" class="java.math.BigDecimal"/>
	<field name="SUM_VALOR_PAGAR" class="java.math.BigDecimal"/>
	<field name="FIN" class="java.math.BigDecimal"/>
	<variable name="sum_valor_pagar" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{SUM_VALOR_PAGAR}]]></variableExpression>
	</variable>
	<variable name="porcentaje" class="java.math.BigDecimal">
		<variableExpression><![CDATA[$V{sum_valor_pagar} / $F{VALOR_TOTAL_CON_VIG_FUTURA} * 100]]></variableExpression>
	</variable>
	<pageHeader>
		<band height="65" splitType="Prevent">
			<rectangle>
				<reportElement mode="Transparent" x="0" y="0" width="572" height="45"/>
			</rectangle>
			<image>
				<reportElement x="0" y="0" width="115" height="45"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
			<staticText>
				<reportElement x="115" y="0" width="407" height="10"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="7" isBold="true"/>
				</textElement>
				<text><![CDATA[FORMATO]]></text>
			</staticText>
			<staticText>
				<reportElement x="115" y="10" width="457" height="35"/>
				<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" markup="none">
					<font fontName="SansSerif" size="7" isBold="true"/>
				</textElement>
				<text><![CDATA[CONTROL DE PAGOS A PROVEEDORES Y CONTRATSTAS]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="115" y="45" width="77" height="20"/>
				<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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_CONTRATO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="0" y="45" width="115" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Número de Contrato]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="192" y="45" width="190" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Nombre del Contratista]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="382" y="45" width="190" height="20"/>
				<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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_DOC} + "\n" +
$F{RAZON_SOCIAL}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="522" y="0" width="50" height="10"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Página " + $V{PAGE_NUMBER} + " de " + "2"]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="80" splitType="Immediate">
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="115" height="40" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Objeto]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="115" y="0" width="457" height="40"/>
				<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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{OBJETO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="0" y="40" width="115" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Valor ]]></text>
			</staticText>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement x="115" y="40" width="457" height="20"/>
				<box leftPadding="0" bottomPadding="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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_INICIAL}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="0" y="60" width="115" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Moneda]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="115" y="60" width="77" height="20"/>
				<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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{MONEDA}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="462" y="60" width="110" height="20"/>
				<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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RPS}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="192" y="60" width="80" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[CDP]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="382" y="60" width="80" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[RP]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="272" y="60" width="110" height="20"/>
				<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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CDPS}]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="40">
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="115" height="40" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Forma de pago]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="115" y="0" width="457" height="40"/>
				<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="Justified" verticalAlignment="Middle" markup="html">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{FORMA_PAGO}]]></textFieldExpression>
			</textField>
		</band>
		<band height="170">
			<staticText>
				<reportElement mode="Opaque" x="0" y="120" width="572" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[RELACIÓN DE PAGOS]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="136" y="140" width="64" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Pago Parcial]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="71" y="140" width="65" height="20"/>
				<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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[( $F{NUMERO_PAGO} == 1
    ? "X"
    : ""
)]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="0" y="140" width="71" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Primer Pago]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="200" y="140" width="64" height="20"/>
				<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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[( $F{NUMERO_PAGO} > 1 && $F{NUMERO_PAGO} < $F{CANT_PAGO}
    ? "X"
    : ""
)]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="360" y="140" width="62" height="20"/>
				<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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[( $F{NUMERO_PAGO} == $F{CANT_PAGO}
    ? "X"
    : ""
)]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="264" y="140" width="96" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Pago Final]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="512" y="140" width="60" height="20"/>
				<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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUMERO_PAGO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="422" y="140" width="90" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Número de Pago ]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="0" y="160" width="572" 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 fontName="SansSerif" size="6"/>
				</textElement>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="115" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Fecha de inicio]]></text>
			</staticText>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="115" y="0" width="77" height="20"/>
				<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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{FECHA_INI_CONTPRI}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="0" y="20" width="572" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[MODIFICACIONES CONTRACTUALES]]></text>
			</staticText>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="307" y="0" width="75" height="20"/>
				<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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{FECHA_FIN_CONTPRI}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="192" y="0" width="115" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Fecha de finalización (inicial)]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="382" y="0" width="115" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Plazo de ejecución]]></text>
			</staticText>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement x="115" y="40" width="77" height="20"/>
				<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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[( $F{ADICION1} != 0
    ? $F{ADICION1}
    : null
)]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="192" y="40" width="115" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Adición 2]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="382" y="40" width="115" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Adición 3]]></text>
			</staticText>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement x="307" y="40" width="75" height="20"/>
				<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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[( $F{ADICION2} != 0
    ? $F{ADICION2}
    : null
)]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="0" y="40" width="115" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Adición 1]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="382" y="60" width="115" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Prórroga 3]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="115" y="60" width="77" height="20"/>
				<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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PRORROGA1}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="192" y="60" width="115" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Prórroga 2]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="60" width="115" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Prórroga 1]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="307" y="60" width="75" height="20"/>
				<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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PRORROGA2}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="192" y="80" width="115" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Fecha de terminación (Después de modificaciones)]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="382" y="80" width="115" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Plazo de ejecución]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="80" width="115" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Fecha de inicio (Después de modificaciones)]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="192" y="100" width="115" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Observaciones]]></text>
			</staticText>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement x="115" y="100" width="77" height="20"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_TOTAL_CON_VIG_FUTURA}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="0" y="100" width="115" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[Valor (Después de modificaciones)]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="307" y="100" width="265" height="20"/>
				<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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{OBSERVACIONES}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="115" y="80" width="77" height="20"/>
				<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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[( $F{ID_CONTRATO} != $F{ID_CONTRATO_CONTPRI}
    ? $F{FECHA_INI}
    : null
)]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="307" y="80" width="75" height="20"/>
				<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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[( $F{ID_CONTRATO} != $F{ID_CONTRATO_CONTPRI}
    ? $F{FECHA_FIN}
    : null
)]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="497" y="0" width="75" height="20"/>
				<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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{MESES_PLAZO_CONTPRI} + " meses " + $F{DIAS_PLAZO_CONTPRI} + " días"]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement x="497" y="40" width="75" height="20"/>
				<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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[( $F{ADICION3} != 0
    ? $F{ADICION3}
    : null
)]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="497" y="60" width="75" height="20"/>
				<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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PRORROGA3}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="497" y="80" width="75" height="20"/>
				<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 fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[( $F{ID_CONTRATO} != $F{ID_CONTRATO_CONTPRI}
    ? $F{MESES_PLAZO} + " meses " + $F{DIAS_PLAZO} + " días"
    : null
)]]></textFieldExpression>
			</textField>
		</band>
		<band height="105">
			<subreport>
				<reportElement x="0" y="0" width="572" height="105"/>
				<subreportParameter name="id_contratista">
					<subreportParameterExpression><![CDATA[$P{id_contratista}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="id_contrato">
					<subreportParameterExpression><![CDATA[$P{id_contrato}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="id_formato_pago">
					<subreportParameterExpression><![CDATA[$P{id_formato_pago}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="id_numero_pago">
					<subreportParameterExpression><![CDATA[$P{id_numero_pago}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression class="java.lang.String"><![CDATA["repo:formato_control_pagos_SGC_det"]]></subreportExpression>
			</subreport>
		</band>
	</detail>
	<summary>
		<band height="130">
			<staticText>
				<reportElement mode="Opaque" x="0" y="80" width="572" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[MODIFICACIONES CONTROL DE PAGOS]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="572" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<text><![CDATA[BALANCE DEL CONTRATO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="20" width="115" height="30" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="false"/>
				</textElement>
				<text><![CDATA[Valor Contratado]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="50" width="115" height="30" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="false"/>
				</textElement>
				<text><![CDATA[Valor Ejecutado]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="181" y="20" width="115" height="30" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="false"/>
				</textElement>
				<text><![CDATA[% de ejecución financiera del Contrato]]></text>
			</staticText>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement x="115" y="20" width="66" height="30"/>
				<box leftPadding="0" bottomPadding="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 fontName="SansSerif" size="6" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_TOTAL_CON_VIG_FUTURA}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement x="115" y="50" width="66" height="30"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{sum_valor_pagar}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="181" y="50" width="115" height="30" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="false"/>
				</textElement>
				<text><![CDATA[% por ejecutar]]></text>
			</staticText>
			<textField pattern="#,##0.00 %" isBlankWhenNull="true">
				<reportElement x="296" y="20" width="64" height="30"/>
				<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 fontName="SansSerif" size="6" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{porcentaje}/100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00 %" isBlankWhenNull="true">
				<reportElement x="296" y="50" width="64" height="30"/>
				<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 fontName="SansSerif" size="6" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[1 - ($V{porcentaje}/100)]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement mode="Transparent" x="360" y="20" width="212" height="60" forecolor="#E0E0E0" backcolor="#FEFEFE"/>
				<box leftPadding="2">
					<pen lineWidth="0.75" lineColor="#010101"/>
					<topPen lineWidth="0.75" lineColor="#010101"/>
					<leftPen lineWidth="0.75" lineColor="#010101"/>
					<bottomPen lineWidth="0.75" lineColor="#010101"/>
					<rightPen lineWidth="0.75" lineColor="#010101"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Resporte aquí alertas u observaciones."]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="0" y="100" width="115" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="false"/>
				</textElement>
				<text><![CDATA[¿Se requirió actualizar la información del Contrato?]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="115" y="100" width="33" height="20" forecolor="#E0E0E0"/>
				<box leftPadding="2">
					<pen lineWidth="0.75" lineColor="#010101"/>
					<topPen lineWidth="0.75" lineColor="#010101"/>
					<leftPen lineWidth="0.75" lineColor="#010101"/>
					<bottomPen lineWidth="0.75" lineColor="#010101"/>
					<rightPen lineWidth="0.75" lineColor="#010101"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Si"]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="148" y="100" width="33" height="20" forecolor="#E0E0E0"/>
				<box leftPadding="2">
					<pen lineWidth="0.75" lineColor="#010101"/>
					<topPen lineWidth="0.75" lineColor="#010101"/>
					<leftPen lineWidth="0.75" lineColor="#010101"/>
					<bottomPen lineWidth="0.75" lineColor="#010101"/>
					<rightPen lineWidth="0.75" lineColor="#010101"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["No"]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="181" y="100" width="115" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="false"/>
				</textElement>
				<text><![CDATA[Fecha]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="422" y="100" width="150" height="20"/>
				<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 fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="296" y="100" width="64" height="20" forecolor="#E0E0E0"/>
				<box leftPadding="2">
					<pen lineWidth="0.75" lineColor="#010101"/>
					<topPen lineWidth="0.75" lineColor="#010101"/>
					<leftPen lineWidth="0.75" lineColor="#010101"/>
					<bottomPen lineWidth="0.75" lineColor="#010101"/>
					<rightPen lineWidth="0.75" lineColor="#010101"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["día/mes/año"]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="360" y="100" width="62" height="20" backcolor="#E4E4E4"/>
				<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 fontName="SansSerif" size="6" isBold="false"/>
				</textElement>
				<text><![CDATA[Firma]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="0" y="120" width="572" 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 fontName="SansSerif" size="6"/>
				</textElement>
			</textField>
		</band>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="572" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
