<?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="balance_segur_social" language="groovy" pageWidth="800" pageHeight="800" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="760" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.210000000000005"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/radicacionvirtualcuentas/registro_contrato"/>
	<property name="ireport.jasperserver.url" value="http://localhost:18080/jasperserver/services/repository"/>
	<parameter name="fecha_ini" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="fecha_fin" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereIdContratista" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereNumeroRadicado" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereIdNumeroPago" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereIdApoyoSupervisor" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereIdSupervisor" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereIdContrato" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="id_anhos" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select
tab0.*,
TO_CHAR(tab0.saldo_contrato, 'FM9,999,999,999') as saldo_contrato_text,
LPAD(TO_CHAR(sysdate,'dd'),2,'0') as DIA_actual,
lower(numero_a_Texto ( to_char(sysdate,'dd'), 2, 'ESP' )) as dia_ACTUAL_letra,
trim(INITCAP(TO_CHAR(sysdate,'MONTH','nls_date_language=spanish'))) as MES_actual,
TO_CHAR(sysdate,'yyyy') as anho_actual,
lower(Fecha_a_Texto ( to_char(sysdate,'yyyy'), 2, 'ESP' )) as anho_ACTUAL_letra,

forpag.fecha_ini_pago,
upper( trim(initcap(to_char(forpag.fecha_ini_pago,'MONTH','nls_date_language=spanish'))) ) as mes_forpag,
to_char(forpag.fecha_ini_pago,'yyyy') as anho_forpag,
forpag.id_numero_pago,
forpag.numero_planilla,

round(nvl(forpag.valor_a_pagar,0) * 40 / 100) as valor_ibc_forpag,
nvl(forpag.aporte_salud,0) as aporte_salud_forpag,
nvl(forpag.aporte_pension,0) as aporte_pension_forpag,
nvl(forpag.aporte_fsp,0) as aporte_fsp_forpag,
nvl(forpag.aporte_arl,0) as aporte_arl_forpag

from(

    SELECT

    cont.id_acta_inicio,
    cont.adjunto,
    cont.fecha_log,
    cont.usuario_log,

    cont.id_contrato,
    cont.id_contratista,
    cont.num_contrato,
    cont.id_anhos,
    cont.fecha_contrato,
    cont.objeto,
    cont.obligaciones,
    cont.estado,
    cont.rp_anm,
    cont.rp_sgr,
    cont.fecha_rp,
    cont.fecha_poliza,
    cont.valor_anm,
    cont.cdp_anm,
    cont.fecha_cdp_anm,
    cont.valor_sgr,
    cont.cdp_sgr,
    cont.fecha_cdp_sgr,
    cont.dependencia,
    cont.meses_plazo,
    cont.dias_plazo,
    cont.fecha_plazo,
    cont.id_supervisor,
    cont.id_apoyo_supervisor,
    cont.fecha_ini,
    cont.fecha_fin,
    cont.year,
    cont.id_mae_ter_sup,
    cont.num_doc_sup,
    cont.razon_soc_sup,
    cont.cargo_sup,
    cont.correo_sup,
    cont.estado_sup,
    cont.id_mae_ter_apo,
    cont.num_doc_apo,
    cont.razon_soc_apo,
    cont.cargo_apo,
    cont.correo_apo,
    cont.estado_apo,
    cont.rp_anm || cont.rp_sgr as rp,

    contra.tipo_recurso,
    contra.num_doc,
    contra.razon_social,
    contra.correo,

    nvl(forpag.valor_mensual,0) as valor_mensual,
    nvl(forpag.valor_comisiones,0) as valor_comisiones,
    nvl(forpag.valor_pagar,0) as valor_pagar,
    nvl(forpag.valor_a_pagar,0) as valor_a_pagar,
    nvl(forpag.valor_total_reten,0) as valor_total_reten,
    nvl(forpag.aporte_salud,0) as aporte_salud,
    nvl(forpag.aporte_pension,0) as aporte_pension,
    nvl(forpag.aporte_fsp,0) as aporte_fsp,
    nvl(forpag.aporte_arl,0) as aporte_arl,
    nvl(forpag.aporte_volun_afc,0) as aporte_volun_afc,
    nvl(forpag.aporte_volun_pen,0) as aporte_volun_pen,
    nvl(forpag.valor_intereses_vivienda,0) as valor_intereses_vivienda,
    nvl(forpag.valor_dependientes,0) as valor_dependientes,
    nvl(forpag.valor_medicina,0) as valor_medicina,
    nvl(forpag.valor_embargo,0) as valor_embargo,

    (cont.valor_anm + cont.valor_sgr) as valor_contrato,
    nvl(forpag.valor_a_pagar,0) as valor_ejecutado,
    (cont.valor_anm + cont.valor_sgr) - nvl(forpag.valor_a_pagar,0) as saldo_contrato,
    round(nvl(forpag.valor_a_pagar,0) * 40 / 100) as valor_ibc,

    upper(tipreg.descripcion) as descripcion_tipreg,

    nvl(novsus.dias,0) as dias,
    novsus.observacion

    FROM rvc_acta_inicio_v cont

    left join rvc_contratista_v contra
    on contra.id_contratista = cont.id_contratista

    left join rvc_tipo_regimen tipreg
    on contra.id_tipo_regimen = tipreg.id_tipo_regimen

    left join (
        select
        nov.id_contrato,
        sum( nov.fecha_fin - nov.fecha_ini ) as dias,
        LISTAGG(nov.observacion, '; ') WITHIN GROUP (ORDER BY nov.fecha_ini) as observacion
        from
        rvc_novedad_suspension nov
        group by
        nov.id_contrato
    )novsus
    on novsus.id_contrato = cont.id_contrato

    left join(
        select
        forpag.id_anhos,
        forpag.id_contrato,
        forpag.id_contratista,

        sum( nvl(forpag.valor_mensual,0) ) as valor_mensual,
        sum( nvl(forpag.valor_comisiones,0) ) as valor_comisiones,
        sum( nvl(forpag.valor_pagar,0) ) as valor_pagar,
        sum( nvl(forpag.valor_a_pagar,0) ) as valor_a_pagar,
        sum( nvl(forpag.valor_total_reten,0) ) as valor_total_reten,
        sum( nvl(forpag.aporte_salud,0) ) as aporte_salud,
        sum( nvl(forpag.aporte_pension,0) ) as aporte_pension,
        sum( nvl(forpag.aporte_fsp,0) ) as aporte_fsp,
        sum( nvl(forpag.aporte_arl,0) ) as aporte_arl,
        sum( nvl(forpag.aporte_volun_afc,0) ) as aporte_volun_afc,
        sum( nvl(forpag.aporte_volun_pen,0) ) as aporte_volun_pen,
        sum( nvl(forpag.valor_intereses_vivienda,0) ) as valor_intereses_vivienda,
        sum( nvl(forpag.valor_dependientes,0) ) as valor_dependientes,
        sum( nvl(forpag.valor_medicina,0) ) as valor_medicina,
        sum( nvl(forpag.valor_embargo,0) ) as valor_embargo

        from rvc_formato_pago_v forpag

        where
        forpag.id_anhos <= $P{id_anhos}
        and forpag.estado = 1

        group by
        forpag.id_anhos,
        forpag.id_contrato,
        forpag.id_contratista
    )forpag
    on cont.id_contrato = forpag.id_contrato

    where
    cont.id_anhos <=  $P{id_anhos}

)tab0

left join rvc_formato_pago_v forpag
on forpag.id_contrato = tab0.id_contrato

where
1 = 1
and forpag.estado = 1
$P!{whereIdContratista}
$P!{whereIdContrato}

order by
tab0.id_anhos,
tab0.num_contrato,
tab0.num_doc,
forpag.id_numero_pago,
forpag.fecha_ini_pago]]>
	</queryString>
	<field name="ID_ACTA_INICIO" class="java.math.BigDecimal"/>
	<field name="ADJUNTO" class="java.lang.String"/>
	<field name="FECHA_LOG" class="java.sql.Timestamp"/>
	<field name="USUARIO_LOG" class="java.lang.String"/>
	<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="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" class="java.math.BigDecimal"/>
	<field name="RP_ANM" class="java.math.BigDecimal"/>
	<field name="RP_SGR" class="java.math.BigDecimal"/>
	<field name="FECHA_RP" class="java.sql.Timestamp"/>
	<field name="FECHA_POLIZA" class="java.sql.Timestamp"/>
	<field name="VALOR_ANM" class="java.math.BigDecimal"/>
	<field name="CDP_ANM" class="java.math.BigDecimal"/>
	<field name="FECHA_CDP_ANM" class="java.sql.Timestamp"/>
	<field name="VALOR_SGR" class="java.math.BigDecimal"/>
	<field name="CDP_SGR" class="java.math.BigDecimal"/>
	<field name="FECHA_CDP_SGR" class="java.sql.Timestamp"/>
	<field name="DEPENDENCIA" class="java.lang.String"/>
	<field name="MESES_PLAZO" class="java.math.BigDecimal"/>
	<field name="DIAS_PLAZO" class="java.math.BigDecimal"/>
	<field name="FECHA_PLAZO" class="java.sql.Timestamp"/>
	<field name="ID_SUPERVISOR" class="java.math.BigDecimal"/>
	<field name="ID_APOYO_SUPERVISOR" class="java.math.BigDecimal"/>
	<field name="FECHA_INI" class="java.sql.Timestamp"/>
	<field name="FECHA_FIN" class="java.sql.Timestamp"/>
	<field name="YEAR" class="java.math.BigDecimal"/>
	<field name="ID_MAE_TER_SUP" class="java.math.BigDecimal"/>
	<field name="NUM_DOC_SUP" class="java.lang.String"/>
	<field name="RAZON_SOC_SUP" class="java.lang.String"/>
	<field name="CARGO_SUP" class="java.lang.String"/>
	<field name="CORREO_SUP" class="java.lang.String"/>
	<field name="ESTADO_SUP" class="java.math.BigDecimal"/>
	<field name="ID_MAE_TER_APO" class="java.math.BigDecimal"/>
	<field name="NUM_DOC_APO" class="java.lang.String"/>
	<field name="RAZON_SOC_APO" class="java.lang.String"/>
	<field name="CARGO_APO" class="java.lang.String"/>
	<field name="CORREO_APO" class="java.lang.String"/>
	<field name="ESTADO_APO" class="java.math.BigDecimal"/>
	<field name="RP" class="java.lang.String"/>
	<field name="TIPO_RECURSO" class="java.math.BigDecimal"/>
	<field name="NUM_DOC" class="java.lang.String"/>
	<field name="RAZON_SOCIAL" class="java.lang.String"/>
	<field name="CORREO" class="java.lang.String"/>
	<field name="VALOR_MENSUAL" class="java.math.BigDecimal"/>
	<field name="VALOR_COMISIONES" class="java.math.BigDecimal"/>
	<field name="VALOR_PAGAR" class="java.math.BigDecimal"/>
	<field name="VALOR_A_PAGAR" class="java.math.BigDecimal"/>
	<field name="VALOR_TOTAL_RETEN" class="java.math.BigDecimal"/>
	<field name="APORTE_SALUD" class="java.math.BigDecimal"/>
	<field name="APORTE_PENSION" class="java.math.BigDecimal"/>
	<field name="APORTE_FSP" class="java.math.BigDecimal"/>
	<field name="APORTE_ARL" class="java.math.BigDecimal"/>
	<field name="APORTE_VOLUN_AFC" class="java.math.BigDecimal"/>
	<field name="APORTE_VOLUN_PEN" class="java.math.BigDecimal"/>
	<field name="VALOR_INTERESES_VIVIENDA" class="java.math.BigDecimal"/>
	<field name="VALOR_DEPENDIENTES" class="java.math.BigDecimal"/>
	<field name="VALOR_MEDICINA" class="java.math.BigDecimal"/>
	<field name="VALOR_EMBARGO" class="java.math.BigDecimal"/>
	<field name="VALOR_CONTRATO" class="java.math.BigDecimal"/>
	<field name="VALOR_EJECUTADO" class="java.math.BigDecimal"/>
	<field name="SALDO_CONTRATO" class="java.math.BigDecimal"/>
	<field name="VALOR_IBC" class="java.math.BigDecimal"/>
	<field name="DESCRIPCION_TIPREG" class="java.lang.String"/>
	<field name="DIAS" class="java.math.BigDecimal"/>
	<field name="OBSERVACION" class="java.lang.String"/>
	<field name="SALDO_CONTRATO_TEXT" class="java.lang.String"/>
	<field name="DIA_ACTUAL" class="java.lang.String"/>
	<field name="DIA_ACTUAL_LETRA" class="java.lang.String"/>
	<field name="MES_ACTUAL" class="java.lang.String"/>
	<field name="ANHO_ACTUAL" class="java.lang.String"/>
	<field name="ANHO_ACTUAL_LETRA" class="java.lang.String"/>
	<field name="FECHA_INI_PAGO" class="java.sql.Timestamp"/>
	<field name="MES_FORPAG" class="java.lang.String"/>
	<field name="ANHO_FORPAG" class="java.lang.String"/>
	<field name="ID_NUMERO_PAGO" class="java.math.BigDecimal"/>
	<field name="NUMERO_PLANILLA" class="java.math.BigDecimal"/>
	<field name="VALOR_IBC_FORPAG" class="java.math.BigDecimal"/>
	<field name="APORTE_SALUD_FORPAG" class="java.math.BigDecimal"/>
	<field name="APORTE_PENSION_FORPAG" class="java.math.BigDecimal"/>
	<field name="APORTE_FSP_FORPAG" class="java.math.BigDecimal"/>
	<field name="APORTE_ARL_FORPAG" class="java.math.BigDecimal"/>
	<variable name="total_ibc" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_IBC_FORPAG}]]></variableExpression>
	</variable>
	<variable name="total_sal" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{APORTE_SALUD_FORPAG}]]></variableExpression>
	</variable>
	<variable name="total_pen" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{APORTE_PENSION_FORPAG}]]></variableExpression>
	</variable>
	<variable name="total_fsp" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{APORTE_FSP_FORPAG}]]></variableExpression>
	</variable>
	<variable name="total_arl" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{APORTE_ARL_FORPAG}]]></variableExpression>
	</variable>
	<group name="num_contrato">
		<groupExpression><![CDATA[$F{NUM_CONTRATO}]]></groupExpression>
		<groupHeader>
			<band height="26">
				<staticText>
					<reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="170" y="0" width="140" height="26" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[No. DE LA PLANILLA]]></text>
				</staticText>
				<staticText>
					<reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="400" y="0" width="90" height="26" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<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[VALOR APORTE SALUD]]></text>
				</staticText>
				<staticText>
					<reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="490" y="0" width="90" height="26" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<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[VALOR APORTE PENSION]]></text>
				</staticText>
				<staticText>
					<reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="310" y="0" width="90" height="26" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" 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 IBC MENSUAL]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="50" height="26" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[AÑO]]></text>
				</staticText>
				<staticText>
					<reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="50" y="0" width="120" height="26" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[PERIODO]]></text>
				</staticText>
				<staticText>
					<reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="580" y="0" width="90" height="26" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<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[VALOR APORTE FONDO DE SOLIDARIDAD PENSIONAL]]></text>
				</staticText>
				<staticText>
					<reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="670" y="0" width="90" height="26" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" 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 APORTE ARL]]></text>
				</staticText>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="29">
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="670" y="0" width="90" height="15"/>
					<box rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="8"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_arl}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="400" y="0" width="90" height="15"/>
					<box rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="8"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_sal}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="580" y="0" width="90" height="15"/>
					<box rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="8"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_fsp}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="490" y="0" width="90" height="15"/>
					<box rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="8"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_pen}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="310" y="0" width="90" height="15"/>
					<box rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="8"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_ibc}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="310" height="15" forecolor="#000000" backcolor="#FEFEFE"/>
					<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[TOTALES]]></text>
				</staticText>
			</band>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="80" splitType="Stretch">
			<image>
				<reportElement x="0" y="10" width="133" height="40"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
			<staticText>
				<reportElement x="0" y="0" width="760" height="60"/>
				<box>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Bottom" markup="none">
					<font fontName="SansSerif" size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[AGENCIA NACIONAL DE MINERIA
GRUPO DE RECURSOS FINANCIEROS
BALANCE SEGURIDAD SOCIAL]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="0" y="60" width="760" height="20" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<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>
				<textFieldExpression class="java.lang.String"><![CDATA["CONTRATO: " + $F{NUM_CONTRATO}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="16" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="198" splitType="Stretch">
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="310" y="73" width="90" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box bottomPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Bottom" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[( $F{DIAS} > 0
    ? "SI"
    : "NO"
)]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="0" y="73" width="310" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle" 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["5. EL CONTRATO FUE OBJETO DE SUSPENSIÓN:"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" mode="Transparent" x="310" y="118" width="90" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box bottomPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Bottom" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_CONTRATO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToBandHeight" mode="Transparent" x="0" y="103" width="310" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle" 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["7. TIEMPO DE SUSPENSIÓN EN DÍAS:"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToBandHeight" mode="Transparent" x="0" y="118" width="310" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle" 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["8. VALOR TOTAL DE LA SUSPESNIÓN:"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToBandHeight" mode="Transparent" x="0" y="88" width="310" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle" 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["6. MOTIVO DE SUSPENSIÓN:"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="310" y="88" width="450" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box bottomPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Bottom" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[( $F{DIAS} > 0
    ? $F{OBSERVACION}
    : "NINGUNA"
)]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="310" y="103" width="90" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box bottomPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Bottom" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[( $F{DIAS} > 0
    ? $F{DIAS}
    : ""
)]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToBandHeight" mode="Transparent" x="0" y="133" width="310" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle" 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["9. VALOR EJECUTADO DEL CONTRATO:"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToBandHeight" mode="Transparent" x="0" y="148" width="310" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle" 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["10. VALOR TOTAL DEL IBC OBLIGATORIO PARA COTIZAR AL SSS:"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToBandHeight" mode="Transparent" x="0" y="163" width="310" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle" 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["11. RELACION DE PLANILLAS DE LOS PAGOS AL SSS:"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" mode="Transparent" x="310" y="133" width="90" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box bottomPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Bottom" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_EJECUTADO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" mode="Transparent" x="310" y="148" width="90" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box bottomPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Bottom" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_IBC}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="0" y="13" width="310" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle" 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["1. NOMBRE Y APELLLIDOS DEL CONTRATISTA:"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="310" y="13" width="450" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box bottomPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Bottom" 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{RAZON_SOCIAL}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="0" y="28" width="310" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle" 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["2. No. DE IDENTIFICACIÓN:"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="310" y="28" width="90" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box bottomPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Bottom" 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{NUM_DOC}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="310" y="43" width="90" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box bottomPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Bottom" 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_TIPREG}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="0" y="43" width="310" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle" 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["3. TIPO DE REGIMEN:"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="0" y="58" width="310" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle" 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["4. VALOR TOTAL DEL CONTRATO (ANTES DE IVA):"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" mode="Transparent" x="310" y="58" width="90" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box bottomPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Bottom" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_CONTRATO}]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="15">
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="170" y="0" width="140" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="0" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUMERO_PLANILLA}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="400" y="0" width="90" height="15"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{APORTE_SALUD_FORPAG}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="490" y="0" width="90" height="15"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{APORTE_PENSION_FORPAG}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="310" y="0" width="90" height="15"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_IBC_FORPAG}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="0" y="0" width="50" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="0" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ANHO_FORPAG}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="50" y="0" width="120" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="0" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{MES_FORPAG}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="580" y="0" width="90" height="15"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{APORTE_FSP_FORPAG}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="670" y="0" width="90" height="15"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{APORTE_ARL_FORPAG}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<pageFooter>
		<band height="10" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="594" y="0" width="166" height="10" forecolor="#575757" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["APO3-P-001-F-009 / V1"]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band height="147" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement mode="Opaque" x="80" y="93" width="200" height="12" forecolor="#000000"/>
				<box>
					<pen lineWidth="0.75" lineStyle="Dotted"/>
					<topPen lineWidth="0.75" lineStyle="Solid"/>
					<leftPen lineWidth="0.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="0.0" lineStyle="Dotted"/>
					<rightPen lineWidth="0.0" lineStyle="Dotted"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOCIAL}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Opaque" x="0" y="93" width="80" height="12" forecolor="#000000"/>
				<box rightPadding="3">
					<pen lineWidth="0.75" lineStyle="Dotted"/>
					<topPen lineWidth="0.0" lineStyle="Solid"/>
					<leftPen lineWidth="0.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="0.0" lineStyle="Dotted"/>
					<rightPen lineWidth="0.0" lineStyle="Dotted"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Nombre:"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Opaque" x="0" y="83" width="80" height="10" forecolor="#000000"/>
				<box rightPadding="3">
					<pen lineWidth="0.75" lineStyle="Dotted"/>
					<topPen lineWidth="0.0" lineStyle="Solid"/>
					<leftPen lineWidth="0.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="0.0" lineStyle="Dotted"/>
					<rightPen lineWidth="0.0" lineStyle="Dotted"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Firma"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Opaque" x="80" y="105" width="200" height="30" forecolor="#000000"/>
				<box>
					<pen lineWidth="0.75" lineStyle="Dotted"/>
					<topPen lineWidth="0.0" lineStyle="Solid"/>
					<leftPen lineWidth="0.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="0.0" lineStyle="Dotted"/>
					<rightPen lineWidth="0.0" lineStyle="Dotted"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["CONTRATISTA"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Opaque" x="415" y="83" width="80" height="10" forecolor="#000000"/>
				<box rightPadding="3">
					<pen lineWidth="0.75" lineStyle="Dotted"/>
					<topPen lineWidth="0.0" lineStyle="Solid"/>
					<leftPen lineWidth="0.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="0.0" lineStyle="Dotted"/>
					<rightPen lineWidth="0.0" lineStyle="Dotted"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Firma"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Opaque" x="415" y="93" width="80" height="12" forecolor="#000000"/>
				<box rightPadding="3">
					<pen lineWidth="0.75" lineStyle="Dotted"/>
					<topPen lineWidth="0.0" lineStyle="Solid"/>
					<leftPen lineWidth="0.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="0.0" lineStyle="Dotted"/>
					<rightPen lineWidth="0.0" lineStyle="Dotted"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Nombre:"]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement mode="Opaque" x="495" y="93" width="200" height="12" forecolor="#000000"/>
				<box>
					<pen lineWidth="0.75" lineStyle="Dotted"/>
					<topPen lineWidth="0.75" lineStyle="Solid"/>
					<leftPen lineWidth="0.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="0.0" lineStyle="Dotted"/>
					<rightPen lineWidth="0.0" lineStyle="Dotted"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOC_SUP}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Opaque" x="495" y="105" width="200" height="30" forecolor="#000000"/>
				<box>
					<pen lineWidth="0.75" lineStyle="Dotted"/>
					<topPen lineWidth="0.0" lineStyle="Solid"/>
					<leftPen lineWidth="0.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="0.0" lineStyle="Dotted"/>
					<rightPen lineWidth="0.0" lineStyle="Dotted"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["SUPERVISOR"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="0" y="40" width="760" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Para constancia de lo anterior, firman la presente acta los que en ella intervinieron el día " + $F{DIA_ACTUAL} + " del mes de " + $F{MES_ACTUAL} + " de " + $F{ANHO_ACTUAL} + "."]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="0" y="0" width="80" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Observación:"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="80" y="0" width="680" height="30" forecolor="#000000" backcolor="#FFFFFF"/>
				<box topPadding="2" leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Top" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[( $V{total_ibc} >= $F{VALOR_IBC}
    ?"FORMATO PROCEDE PARA FIRMA Y CONTINÚA EL PROCESO DE ELABORACIÓN DE CUENTA DE COBRO"
    :"DEBE HACER AJUSTE AL IBC TOTAL DEL NUMERAL 10"
)]]></textFieldExpression>
			</textField>
		</band>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="760" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
