<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="inf_anual_pend_liq" pageWidth="2000" pageHeight="850" columnWidth="1960" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.5000000000000042"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/canon/inf_anual_pend_liq"/>
	<property name="ireport.jasperserver.url" value="http://192.168.2.43:8090/jasperserver/services/repository"/>
	<parameter name="fecha_fin" class="java.lang.String"/>
	<parameter name="whereTitulo" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereCompetencia" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="fecha_ini" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTipoAuto" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="texto_auto" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT TAB0.* FROM (

    SELECT
    case when TAB2.LIQUIDADO = 1 then 'X' else '' end as bool_auto_marca,
    TAB2.LIQUIDADO as bool_auto,
    TAB2.ID_TITULO
    ,TAB2.ANUALIDAD
    ,TAB2.FECHA_INICIO
    ,TAB2.FECHA_FIN
    ,TAB2.ID_ANUAL_ETAPA
    ,ROUND(nvl((SELECT VALOR FROM CA_DET_LIQ_REPO_CANON WHERE ID_ANUAL_ETAPA = TAB2.ID_ANUAL_ETAPA), 0)) AS VALOR_PRECALCULADO
    , TAB8.COD_TITULO AS COD_TITULO
    ,(SELECT NOMBRE FROM RMN_COMPETENCIA WHERE ID_COMPETENCIA = TAB0.ID_COMPETENCIA) AS NOM_COMP
    ,(SELECT NUM_DOC FROM RMN_COMPETENCIA WHERE ID_COMPETENCIA = TAB0.ID_COMPETENCIA) AS NUM_DOC
    ,(SELECT NOMBRE FROM RMN_MODALIDAD WHERE ID_MODALIDAD = TAB6.ID_MODALIDAD ) AS NOM_MOD
    ,(SELECT ABREVIACION FROM CA_ETAPA WHERE ID_ETAPA = TAB2.ID_ETAPA) AS NOM_ETA
    ,TAB0.ID_COMPETENCIA
    ,(TAB3.AREA/10000) as AREA
    ,(SELECT TAB4.VALOR_MENSUAL FROM ca_smdlv TAB4 WHERE TAB2.FECHA_INICIO between TAB4.FECHA_INI AND TAB4.FECHA_FIN) AS SALARIO
    ,(SELECT DESCRIPCION FROM CA_NORMA_CANON  WHERE ID_NORMA = TAB5.ID_NORMA ) AS NOM_NORM
    , TO_CHAR(TAB2.FECHA_INICIO, 'YYYY') AS VIGENCIA, tab8.fecha_ter
    ,-- tasa de interes aplicada
    case
      when tt.aplica_usura=0 then ti.valor
      else tiact.valor
    end as tasa_interes_aplicada,

    titper.id_titular,
    per.num_doc as documento,
    nvl(per.raz_soc,per.nombre || ' ' ||per.primer_apellido || ' ' ||per.segundo_apellido) as titular,
    nvl(nvl(per.correo_notif,per.correo),per.correo_alt) as email,
    mun.ubicacion,
    mun.competencia_cmc,
    recdeb.id_debitos,
    recdeb.sec_debitos,

    TAB8.id_profesional,
    prof.documento as num_doc_profesional,
    prof.nombre as razon_soc_profesional,
    prof.email_usuario as email_profesional,
    TAB8.activo_pin

    FROM ca_anual_consolidado_v TAB2

    JOIN IN_TITULO_COMPETENCIA TAB0 ON
    TAB0.ID_TITULO = TAB2.ID_TITULO
    AND TAB0.ACTUAL = 1
    JOIN RMN_TITULO_MODALIDAD TAB6 ON
    TAB6.ID_TITULO = TAB2.ID_TITULO
    AND TAB6.ACTUAL = 1
    JOIN RMN_MODALIDAD modal ON
    TAB6.id_modalidad = modal.id_modalidad
    JOIN IN_TITULO_AREA TAB3 ON
    TAB3.ID_TITULO = TAB2.ID_TITULO
    AND TAB3.ACTUAL = 1
    JOIN CA_TITULO_NORMA TAB5 ON
    TAB5.ID_TITULO = TAB2.ID_TITULO
    AND TAB5.ACTUAL = 1
    JOIN RMN_TITULO TAB8 ON TAB8.ID_TITULO = TAB2.ID_TITULO
    join ca_titulo_tasa tt on tt.id_titulo = tab0.id_titulo and tt.estado=1

    left join ca_tasa_interes ti on tt.id_tasa_interes = ti.id_tasa_interes
    join ca_tasa_interes tiact on tiact.vigencia=to_char(sysdate, 'yyyy') and tiact.id_meses=to_char(sysdate, 'mm')

    left join(
        SELECT
         aut.*,
         ROW_NUMBER() OVER (
          partition by aut.id_titulo
          ORDER BY aut.id_titulo, aut.actual desc, aut.id_rol_titulo desc
         ) AS rn
        from rmn_titulo_persona aut
    )titper
    on titper.rn = 1
    and titper.id_titulo = TAB2.ID_TITULO

    left join rmn_persona per
    on  per.id_persona = titper.id_titular

    left join(
        SELECT
        mun.id_titulo,
        LISTAGG(mun.mpio_dpto, ', ') WITHIN GROUP (ORDER BY mun.mpio_dpto) as ubicacion,
        REPLACE( regexp_replace(LISTAGG(dep.competencia, ',') WITHIN GROUP (ORDER BY dep.competencia),'([^,]+)(,\1)*(,|$)', '\1\3') ,',' ,', ') as 		competencia_cmc
        FROM CMC.V_TITULOS_MUNICIPIOS_WEBSAFI@MUNICIPIOS_WEBSAFI_CMC mun
        left join rmn_departamento dep on dep.id_departamento = mun.id_departamento
        group by
        mun.id_titulo
    )mun
    on  mun.ID_TITULO = TAB2.ID_TITULO

    left join ca_det_liq_canon det
    on det.id_titulo = TAB2.ID_TITULO
    and det.id_anual_etapa = TAB2.id_anual_etapa
    and det.anulado = 0

    left join ca_recibo rec
    on rec.id_det_liq_canon = det.id_det_liq_canon
    and rec.vigencia = det.vigencia

    left join ca_recibo_debito_v recdeb
    on recdeb.id_recibo = rec.id_recibo
    and recdeb.vigencia = rec.vigencia

    LEFT JOIN ca_profesional_v prof  ON prof.id_profesional = tab8.id_profesional

    WHERE
    /*TAB2.LIQUIDADO = 0
    AND*/
    TAB2.FECHA_INICIO between TO_DATE($P{fecha_ini}, 'dd/mm/yyyy') and TO_DATE($P{fecha_fin}, 'dd/mm/yyyy')
    AND (SELECT MIN(C.FECHA_VIGENCIA) FROM CA_NORMA_CANON C WHERE  C.ESTADO = 1) <= tab8.fecha_inscripcion_rmn
    $P!{whereCompetencia}$P!{whereTitulo}
    --and tab6.id_modalidad in (152,5,6,32,72,2,9,33)
    and modal.APLICA_PLANILLA = 1

    ORDER BY
    TAB0.ID_COMPETENCIA, TAB2.ID_TITULO , TAB2.FECHA_INICIO

)TAB0

WHERE
1=1
and (TAB0.fecha_ter is null OR TAB0.fecha_inicio<TAB0.fecha_ter)
--and TAB0.VALOR_PRECALCULADO != 0
$P!{whereTitulo}
$P!{whereTipoAuto}

order by
tab0.fecha_inicio,
tab0.cod_titulo]]>
	</queryString>
	<field name="BOOL_AUTO_MARCA" class="java.lang.String"/>
	<field name="BOOL_AUTO" class="java.math.BigDecimal"/>
	<field name="ID_TITULO" class="java.math.BigDecimal"/>
	<field name="ANUALIDAD" class="java.math.BigDecimal"/>
	<field name="FECHA_INICIO" class="java.sql.Timestamp"/>
	<field name="FECHA_FIN" class="java.sql.Timestamp"/>
	<field name="ID_ANUAL_ETAPA" class="java.math.BigDecimal"/>
	<field name="VALOR_PRECALCULADO" class="java.math.BigDecimal"/>
	<field name="COD_TITULO" class="java.lang.String"/>
	<field name="NOM_COMP" class="java.lang.String"/>
	<field name="NUM_DOC" class="java.lang.String"/>
	<field name="NOM_MOD" class="java.lang.String"/>
	<field name="NOM_ETA" class="java.lang.String"/>
	<field name="ID_COMPETENCIA" class="java.math.BigDecimal"/>
	<field name="AREA" class="java.math.BigDecimal"/>
	<field name="SALARIO" class="java.math.BigDecimal"/>
	<field name="NOM_NORM" class="java.lang.String"/>
	<field name="VIGENCIA" class="java.lang.String"/>
	<field name="FECHA_TER" class="java.sql.Timestamp"/>
	<field name="TASA_INTERES_APLICADA" class="java.math.BigDecimal"/>
	<field name="ID_TITULAR" class="java.math.BigDecimal"/>
	<field name="DOCUMENTO" class="java.lang.String"/>
	<field name="TITULAR" class="java.lang.String"/>
	<field name="EMAIL" class="java.lang.String"/>
	<field name="UBICACION" class="java.lang.String"/>
	<field name="COMPETENCIA_CMC" class="java.lang.String"/>
	<field name="ID_DEBITOS" class="java.lang.String"/>
	<field name="SEC_DEBITOS" class="java.lang.String"/>
	<field name="ID_PROFESIONAL" class="java.math.BigDecimal"/>
	<field name="NUM_DOC_PROFESIONAL" class="java.lang.String"/>
	<field name="RAZON_SOC_PROFESIONAL" class="java.lang.String"/>
	<field name="EMAIL_PROFESIONAL" class="java.lang.String"/>
	<field name="ACTIVO_PIN" class="java.math.BigDecimal"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="60" splitType="Stretch">
			<rectangle>
				<reportElement x="0" y="0" width="393" height="60"/>
			</rectangle>
			<image>
				<reportElement x="137" y="10" width="111" height="40"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:logo_entidad_2.png"]]></imageExpression>
			</image>
			<staticText>
				<reportElement mode="Transparent" x="393" y="0" width="710" height="40" forecolor="#000000" backcolor="#FFFFFF"/>
				<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="11" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[VICEPRESIDENCIA DE SEGUIMIENTO, CONTROL Y SEGURIDAD MINERA
GRUPO DE REGALIAS Y CONTRAPRESTACIONES ECONOMICAS]]></text>
			</staticText>
			<textField>
				<reportElement x="393" y="40" width="710" height="20"/>
				<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="11" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["CANON SUPERFICIARIO - PLANILLA LIQUIDACION CANON"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Transparent" x="1103" y="40" width="120" height="20" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Página "+$V{PAGE_NUMBER}+" de "]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement mode="Transparent" x="1223" y="40" width="80" height="20" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<topPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Transparent" x="1103" y="0" width="120" height="20" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Código:"]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement mode="Transparent" x="1223" y="0" width="237" height="20" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<topPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["MIS4-P-004-F-005"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Transparent" x="1103" y="20" width="120" height="20" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["VERSIÓN"]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement mode="Transparent" x="1223" y="20" width="237" height="20" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<topPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["1"]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="1303" y="40" width="157" height="20" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<topPen 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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{texto_auto}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<columnHeader>
		<band height="12" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="593" y="0" width="60" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[ETAPA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="393" y="0" width="70" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[FECHA INICIO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="463" y="0" width="70" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[FECHA FIN ]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="533" y="0" width="60" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[ANUALIDAD]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="220" y="0" width="53" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[NORMA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="653" y="0" width="70" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[AREA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="273" y="0" width="120" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[MODALIDAD]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="723" y="0" width="70" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[TASA INTERÉS]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="70" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
				<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="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[COD.EXPEDIENTE]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1103" y="0" width="120" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[COMPETENCIA P.A.R.]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="793" y="0" width="70" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[VALOR]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="70" y="0" width="150" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[TITULAR MINERO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="983" y="0" width="120" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[UBICACIÓN]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1303" y="0" width="157" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[OBSERVACIONES]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1223" y="0" width="80" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[SE CAUSA SI/NO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1460" y="0" width="120" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CORREO ELECTRONICO ]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="863" y="0" width="120" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[COMPETENCIA CMC]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1580" y="0" width="44" height="12" forecolor="#000000" backcolor="#87CAD2"/>
				<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="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[LIQUIDADA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1624" y="0" width="44" height="12" forecolor="#000000" backcolor="#87CAD2"/>
				<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="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[ND]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1668" y="0" width="60" height="12" forecolor="#000000" backcolor="#87CAD2"/>
				<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[PIN]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1728" y="0" width="60" height="12" forecolor="#000000" backcolor="#87CAD2"/>
				<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[Doc. Profesional]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1788" y="0" width="172" height="12" forecolor="#000000" backcolor="#87CAD2"/>
				<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[Profesional]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="16" splitType="Stretch">
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="393" y="0" width="70" height="16"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_INICIO}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="463" y="0" width="70" height="16"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_FIN}]]></textFieldExpression>
			</textField>
			<textField pattern="###0" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="533" y="0" width="60" height="16"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{ANUALIDAD}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="593" y="0" width="60" height="16"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NOM_ETA}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="793" y="0" width="70" height="16"/>
				<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 size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_PRECALCULADO}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="70" height="16"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{COD_TITULO}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.0000;(#,##0.0000)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="653" y="0" width="70" height="16"/>
				<box leftPadding="2" rightPadding="4">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{AREA}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="273" y="0" width="120" height="16"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="5"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NOM_MOD}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="723" y="0" width="70" height="16" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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[$F{TASA_INTERES_APLICADA}+" %"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1103" y="0" width="120" height="16"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{COMPETENCIA_CMC}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="70" y="0" width="150" height="16"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="5"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DOCUMENTO} + " - " + $F{TITULAR}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="220" y="0" width="53" height="16"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NOM_NORM}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="983" y="0" width="120" height="16"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{UBICACION}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1223" y="0" width="80" height="16"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1303" y="0" width="157" height="16"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1460" y="0" width="120" height="16"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{EMAIL}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="863" y="0" width="120" height="16"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NOM_COMP}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1580" y="0" width="44" height="16" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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[$F{BOOL_AUTO_MARCA}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1624" y="0" width="44" height="16" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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[$F{SEC_DEBITOS}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1668" y="0" width="60" height="16"/>
				<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">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[( $F{ACTIVO_PIN}.intValueExact() == 1
    ? "Si"
    : "No"
)]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1788" y="0" width="172" height="16"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOC_PROFESIONAL}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1728" y="0" width="60" height="16"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_DOC_PROFESIONAL}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="10" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="12" splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band height="8" splitType="Stretch"/>
	</summary>
</jasperReport>
