<?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="certif_ingre_reten_dian_2024" language="groovy" pageWidth="612" pageHeight="792" whenNoDataType="NoDataSection" columnWidth="572" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.4641000000000144"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<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="whereFuncionarioNumDoc" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereFuncionarioTipoDoc" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="id_anhos" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="fecha_expe" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="comando" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereRetiro" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select

'$' || replace(trim(TO_CHAR((select round(valor_uvt * 4500,-3) from ts_uvt where vigencia = tab0.id_anhos), '9,999,999,999,999')),',','.') as uvt_4500,
'$' || replace(trim(TO_CHAR((select round(valor_uvt * 1400,-3) from ts_uvt where vigencia = tab0.id_anhos), '9,999,999,999,999')),',','.') as uvt_1400,
'$' || replace(trim(TO_CHAR((select round(valor_uvt * 2800,-3) from ts_uvt where vigencia = tab0.id_anhos), '9,999,999,999,999')),',','.') as uvt_2800,

tab0.*

from(

SELECT DISTINCT
case when nomb.fecha_termina between  to_date( $P{fecha_ini}, 'dd/mm/yyyy') and to_date( $P{fecha_fin}, 'dd/mm/yyyy')
then 1 else 0 end as retiro,

(select firma.nombre
from no_inf_firma firma_inf
left join no_firma firma ON firma.id_firma = firma_inf.id_firma
where
firma_inf.comando=$P{comando}
and rownum = 1) as firma,

(select max(tab0.secuencia) from no_consecutivo_certif tab0 where tab0.id_anhos = $P{id_anhos}
$P!{whereFuncionarioNumDoc}
$P!{whereFuncionarioTipoDoc}) as secuecnia,
to_char(
case when nomb.fecha_ingreso > to_date( $P{fecha_ini}, 'dd/mm/yyyy') then nomb.fecha_ingreso else to_date( $P{fecha_ini}, 'dd/mm/yyyy') end
, 'yyyy-mm-dd') as fecha_ingreso,
to_char(
case when nomb.fecha_termina < to_date( $P{fecha_fin}, 'dd/mm/yyyy') then nomb.fecha_termina else to_date( $P{fecha_fin}, 'dd/mm/yyyy') end
, 'yyyy-mm-dd') as fecha_termina,
tipdoc.abreviacion,
ciu.nombre as nombre_ciudad,
tab8.coddepto as coddepto,
substr(tab9.codmun_text,3) as codmun_text,
datcom.nit,
digito_verificacion(datcom.nit) as dv,
datcom.nombre_empresa,
tab0.id_certif_ingre_reten as id_certif_ingre_reten, tab0.id_tipo_doc as id_tipo_doc, tab0.num_doc as num_doc, tab0.id_anhos as id_anhos,
tab0.id_concep_nomina as id_concep_nomina, tab0.valor_enero as valor_enero, tab0.valor_febrero as valor_febrero, tab0.valor_marzo as valor_marzo,
tab0.valor_abril as valor_abril, tab0.valor_mayo as valor_mayo, tab0.valor_junio as valor_junio, tab0.valor_julio as valor_julio,
tab0.valor_agosto as valor_agosto, tab0.valor_septiembre as valor_septiembre, tab0.valor_octubre as valor_octubre, tab0.valor_noviembre as valor_noviembre,
tab0.valor_diciembre as valor_diciembre, tab0.valor_total as valor_total, tab1.tipo_documento as tipo_documento, tab1.primer_nombre as primer_nombre,
tab1.segundo_nombre as segundo_nombre, tab1.primer_apellido as primer_apellido, tab1.segundo_apellido as segundo_apellido, tab1.nombre_completo as nombre_completo,
tab1.nombre_apellido as nombre_apellido, to_char(tab1.fecha_nace, 'YYYY-MM-DD') as fecha_nace,
tab1.email as email, tab1.tel as telefono, tab1.direccion as direccion, tab1.pais_nace as pais_nace,
tab1.depto_nace as depto_nace, tab1.muni_nace as muni_nace, tab1.genero as genero, tab1.estado_civil as estado_civil, tab1.tipo_sangre as
tipo_sangre, tab2.codigo as codigo, tab2.descripcion as descripcion, tab2.codigo||' - '||tab2.descripcion as completo,
tab2.id_tipo_concepto as id_tipo_concepto, tab2.abreviatura as abreviatura, tab2.operador as operador, tab2.operadoropcional as operadoropcional,
tab2.cod2 as cod2, tab2.cod3 as cod3, tab2.id_concep_ajuste as id_concep_ajuste, tab2.id_concep_rein as id_concep_rein, tab2.id_acreedor as id_acreedor,
tab2.id_rubro as id_rubro, tab2.id_cpo as id_cpo, tab2.estado as estado, tab2.aplica_descuento as aplica_descuento, tab2.id_clase_fondo as id_clase_fondo,
tab2.usa_dias_calen as usa_dias_calen, tab3.id_consecutivo_certif as id_consecutivo_certif, tab3.secuencia as secuencia, tab4.codigo as codigo_tipcon,
tab4.descripcion as descripcion_tipcon, tab4.orden as orden_tipcon, tab4.codigo||' - '||tab4.descripcion as completo_tipcon

FROM NO_CERTIF_INGRE_RETEN tab0
JOIN NO_DATOS_FUNCIONARIO_V tab1 ON tab0.id_tipo_doc = tab1.id_tipo_doc AND tab0.num_doc = tab1.num_doc
JOIN NO_CONCEPTOS_V tab2 ON tab0.id_concep_nomina = tab2.id_concep_nomina
LEFT JOIN NO_CONSECUTIVO_CERTIF tab3 ON tab0.id_tipo_doc = tab3.id_tipo_doc AND tab0.num_doc = tab3.num_doc AND tab0.id_anhos = tab3.id_anhos
JOIN NO_TIPO_CONCEPTO tab4 ON tab2.id_tipo_concepto = tab4.id_tipo_concepto


left join (
  SELECT
   aut.*,
   ROW_NUMBER() OVER (
    partition by aut.num_doc
    ORDER BY aut.id_anhos desc, aut.id_meses desc
   ) AS rn
  from no_estado_func aut
)tab5
on tab0.id_tipo_doc = tab5.id_tipo_doc and tab0.num_doc = tab5.num_doc
and tab5.rn = 1

left join no_dp_v dp
on tab5.id_dp = dp.id_dp

left join (
    select
    aut.id_tipo_doc,
    aut.num_doc,
    min(aut.fecha_ingreso) as fecha_ingreso,
    max( case when aut.fecha_termina is not null then aut.fecha_termina else to_date( $P{fecha_fin}, 'dd/mm/yyyy') end ) as fecha_termina,
    1 as rn
    from(
         SELECT
         aut.*,
         ROW_NUMBER() OVER (
          partition by aut.num_doc
          ORDER BY aut.fecha_ingreso
         ) AS rn
        from no_nombramiento aut
        where
        (
        aut.fecha_ingreso between  to_date( $P{fecha_ini}, 'dd/mm/yyyy') and to_date( $P{fecha_fin}, 'dd/mm/yyyy')
            or
        nvl(aut.fecha_termina,sysdate) between  to_date( $P{fecha_ini}, 'dd/mm/yyyy') and to_date( $P{fecha_fin}, 'dd/mm/yyyy')
        )
    )aut
    group by
    aut.id_tipo_doc,
    aut.num_doc
)nomb
on tab0.id_tipo_doc = nomb.id_tipo_doc and tab0.num_doc = nomb.num_doc
and nomb.rn = 1

LEFT JOIN datos_compania dat on dat.id = 1
LEFT JOIN CENTRO_OPERACION tab7 ON tab7.id_cen_op = dat.id_cen_op AND tab7.id_cia = 1
LEFT JOIN DEPARTAMENTO tab8 ON tab7.id_depto = tab8.id_depto
LEFT JOIN MUNICIPIOS tab9 ON tab7.codmun = tab9.codmun

left join datos_compania datcom
on datcom.id = 1

left join ciudad ciu
on datcom.ciudad = ciu.id

left join tipo_documento tipdoc
on tipdoc.id_tipo_doc = tab1.id_tipo_doc

WHERE
tab0.id_certif_ingre_reten != '-1'
and tab0.agrupacion_orden < 2
AND tab0.id_anhos = $P{id_anhos}
$P!{whereFuncionarioNumDoc}
$P!{whereFuncionarioTipoDoc}

)tab0
WHERE
1 = 1


order by tab0.id_anhos , tab0.num_doc ,
tab0.orden_tipcon , tab0.codigo]]>
	</queryString>
	<field name="UVT_4500" class="java.lang.String"/>
	<field name="UVT_1400" class="java.lang.String"/>
	<field name="UVT_2800" class="java.lang.String"/>
	<field name="RETIRO" class="java.math.BigDecimal"/>
	<field name="FIRMA" class="java.lang.String"/>
	<field name="SECUECNIA" class="java.math.BigDecimal"/>
	<field name="FECHA_INGRESO" class="java.lang.String"/>
	<field name="FECHA_TERMINA" class="java.lang.String"/>
	<field name="ABREVIACION" class="java.lang.String"/>
	<field name="NOMBRE_CIUDAD" class="java.lang.String"/>
	<field name="CODDEPTO" class="java.lang.String"/>
	<field name="CODMUN_TEXT" class="java.lang.String"/>
	<field name="NIT" class="java.lang.String"/>
	<field name="DV" class="java.math.BigDecimal"/>
	<field name="NOMBRE_EMPRESA" class="java.lang.String"/>
	<field name="ID_CERTIF_INGRE_RETEN" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_DOC" class="java.math.BigDecimal"/>
	<field name="NUM_DOC" class="java.lang.String"/>
	<field name="ID_ANHOS" class="java.math.BigDecimal"/>
	<field name="ID_CONCEP_NOMINA" class="java.math.BigDecimal"/>
	<field name="VALOR_ENERO" class="java.math.BigDecimal"/>
	<field name="VALOR_FEBRERO" class="java.math.BigDecimal"/>
	<field name="VALOR_MARZO" class="java.math.BigDecimal"/>
	<field name="VALOR_ABRIL" class="java.math.BigDecimal"/>
	<field name="VALOR_MAYO" class="java.math.BigDecimal"/>
	<field name="VALOR_JUNIO" class="java.math.BigDecimal"/>
	<field name="VALOR_JULIO" class="java.math.BigDecimal"/>
	<field name="VALOR_AGOSTO" class="java.math.BigDecimal"/>
	<field name="VALOR_SEPTIEMBRE" class="java.math.BigDecimal"/>
	<field name="VALOR_OCTUBRE" class="java.math.BigDecimal"/>
	<field name="VALOR_NOVIEMBRE" class="java.math.BigDecimal"/>
	<field name="VALOR_DICIEMBRE" class="java.math.BigDecimal"/>
	<field name="VALOR_TOTAL" class="java.math.BigDecimal"/>
	<field name="TIPO_DOCUMENTO" class="java.lang.String"/>
	<field name="PRIMER_NOMBRE" class="java.lang.String"/>
	<field name="SEGUNDO_NOMBRE" class="java.lang.String"/>
	<field name="PRIMER_APELLIDO" class="java.lang.String"/>
	<field name="SEGUNDO_APELLIDO" class="java.lang.String"/>
	<field name="NOMBRE_COMPLETO" class="java.lang.String"/>
	<field name="NOMBRE_APELLIDO" class="java.lang.String"/>
	<field name="FECHA_NACE" class="java.lang.String"/>
	<field name="EMAIL" class="java.lang.String"/>
	<field name="TELEFONO" class="java.lang.String"/>
	<field name="DIRECCION" class="java.lang.String"/>
	<field name="PAIS_NACE" class="java.lang.String"/>
	<field name="DEPTO_NACE" class="java.lang.String"/>
	<field name="MUNI_NACE" class="java.lang.String"/>
	<field name="GENERO" class="java.lang.String"/>
	<field name="ESTADO_CIVIL" class="java.lang.String"/>
	<field name="TIPO_SANGRE" class="java.lang.String"/>
	<field name="CODIGO" class="java.lang.String"/>
	<field name="DESCRIPCION" class="java.lang.String"/>
	<field name="COMPLETO" class="java.lang.String"/>
	<field name="ID_TIPO_CONCEPTO" class="java.math.BigDecimal"/>
	<field name="ABREVIATURA" class="java.lang.String"/>
	<field name="OPERADOR" class="java.math.BigDecimal"/>
	<field name="OPERADOROPCIONAL" class="java.lang.String"/>
	<field name="COD2" class="java.lang.String"/>
	<field name="COD3" class="java.lang.String"/>
	<field name="ID_CONCEP_AJUSTE" class="java.math.BigDecimal"/>
	<field name="ID_CONCEP_REIN" class="java.math.BigDecimal"/>
	<field name="ID_ACREEDOR" class="java.math.BigDecimal"/>
	<field name="ID_RUBRO" class="java.math.BigDecimal"/>
	<field name="ID_CPO" class="java.math.BigDecimal"/>
	<field name="ESTADO" class="java.math.BigDecimal"/>
	<field name="APLICA_DESCUENTO" class="java.math.BigDecimal"/>
	<field name="ID_CLASE_FONDO" class="java.math.BigDecimal"/>
	<field name="USA_DIAS_CALEN" class="java.math.BigDecimal"/>
	<field name="ID_CONSECUTIVO_CERTIF" class="java.math.BigDecimal"/>
	<field name="SECUENCIA" class="java.math.BigDecimal"/>
	<field name="CODIGO_TIPCON" class="java.lang.String"/>
	<field name="DESCRIPCION_TIPCON" class="java.lang.String"/>
	<field name="ORDEN_TIPCON" class="java.math.BigDecimal"/>
	<field name="COMPLETO_TIPCON" class="java.lang.String"/>
	<variable name="sum_agrup1" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_TOTAL}]]></variableExpression>
	</variable>
	<group name="Funcionario">
		<groupExpression><![CDATA[$F{NUM_DOC}]]></groupExpression>
		<groupHeader>
			<band height="140">
				<staticText>
					<reportElement x="71" y="48" width="150" height="20"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="7"/>
					</textElement>
					<text><![CDATA[25. Número de Identificación:]]></text>
				</staticText>
				<textField>
					<reportElement x="71" y="68" width="150" height="30"/>
					<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">
						<font size="8" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_DOC}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="221" y="48" width="351" height="20"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="7"/>
					</textElement>
					<text><![CDATA[Apellidos y Nombres:]]></text>
				</staticText>
				<textField>
					<reportElement x="221" y="68" width="86" height="20"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.0"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{PRIMER_APELLIDO}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="0" y="128" width="460" height="12" backcolor="#CFD2D8"/>
					<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">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Concepto de los Ingresos]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="460" y="128" width="112" height="12" backcolor="#CFD2D8"/>
					<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">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Valor]]></text>
				</staticText>
				<staticText>
					<reportElement x="20" y="0" width="162" height="10"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.0"/>
						<rightPen lineWidth="0.0"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="7"/>
					</textElement>
					<text><![CDATA[5. Número de Identificación Tributaria(NIT):]]></text>
				</staticText>
				<textField>
					<reportElement x="20" y="10" width="162" height="20"/>
					<box>
						<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">
						<font size="8" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{NIT}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="182" y="0" width="30" height="10"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.0"/>
						<bottomPen lineWidth="0.0"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="7"/>
					</textElement>
					<text><![CDATA[6. Dv.]]></text>
				</staticText>
				<textField>
					<reportElement x="182" y="10" width="30" height="20"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.0"/>
						<leftPen lineWidth="0.0"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{DV}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="20" y="30" width="81" height="18"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.0"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="7"/>
					</textElement>
					<text><![CDATA[11. Razón Social:]]></text>
				</staticText>
				<textField>
					<reportElement x="101" y="30" width="471" height="18"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.0"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{NOMBRE_EMPRESA}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="0" y="0" width="20" height="48"/>
					<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="Left">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Retenedor]]></text>
				</staticText>
				<staticText>
					<reportElement x="0" y="48" width="20" height="50"/>
					<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="Left">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Trabajador]]></text>
				</staticText>
				<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
					<reportElement x="170" y="110" width="90" height="18"/>
					<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">
						<font size="8" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$P{fecha_expe}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="170" y="98" width="90" height="12"/>
					<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>
					<text><![CDATA[32. Fecha de Expedición]]></text>
				</staticText>
				<staticText>
					<reportElement x="0" y="98" width="170" height="12"/>
					<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="7"/>
					</textElement>
					<text><![CDATA[Periodo de la Certificación]]></text>
				</staticText>
				<staticText>
					<reportElement x="20" y="48" width="51" height="20"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="7"/>
					</textElement>
					<text><![CDATA[24. Cód. Tipo Documento]]></text>
				</staticText>
				<staticText>
					<reportElement x="260" y="98" width="160" height="12"/>
					<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>
					<text><![CDATA[33. Lugar donde se practicó la retención:]]></text>
				</staticText>
				<staticText>
					<reportElement x="420" y="98" width="55" height="12"/>
					<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>
					<text><![CDATA[34. Cód. Dpto.]]></text>
				</staticText>
				<staticText>
					<reportElement x="475" y="98" width="97" height="12"/>
					<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>
					<text><![CDATA[35. Cód. Ciudad/Municipio]]></text>
				</staticText>
				<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
					<reportElement x="260" y="110" width="160" height="18"/>
					<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">
						<font size="8" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{NOMBRE_CIUDAD}]]></textFieldExpression>
				</textField>
				<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
					<reportElement x="475" y="110" width="97" height="18"/>
					<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">
						<font size="8" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{CODMUN_TEXT}]]></textFieldExpression>
				</textField>
				<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
					<reportElement x="420" y="110" width="55" height="18"/>
					<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">
						<font size="8" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{CODDEPTO}]]></textFieldExpression>
				</textField>
				<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
					<reportElement x="20" y="68" width="51" height="30"/>
					<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">
						<font size="8" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{ABREVIACION}]]></textFieldExpression>
				</textField>
				<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
					<reportElement x="0" y="110" width="170" height="18"/>
					<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">
						<font size="8" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA["30.De: " + $F{FECHA_INGRESO} + " 31.A: " + $F{FECHA_TERMINA}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="221" y="88" width="86" height="10"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="7"/>
					</textElement>
					<text><![CDATA[26. Primer apellido]]></text>
				</staticText>
				<staticText>
					<reportElement x="307" y="88" width="86" height="10"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="7"/>
					</textElement>
					<text><![CDATA[27. Segundo apellido]]></text>
				</staticText>
				<staticText>
					<reportElement x="393" y="88" width="86" height="10"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="7"/>
					</textElement>
					<text><![CDATA[28. Primer nombre]]></text>
				</staticText>
				<staticText>
					<reportElement x="479" y="88" width="93" height="10"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="7"/>
					</textElement>
					<text><![CDATA[29. Otros nombres]]></text>
				</staticText>
				<textField isBlankWhenNull="true">
					<reportElement x="307" y="68" width="86" height="20"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.0"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.0"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{SEGUNDO_APELLIDO}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement x="393" y="68" width="86" height="20"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.0"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.0"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{PRIMER_NOMBRE}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement x="479" y="68" width="93" height="20"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.0"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{SEGUNDO_NOMBRE}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="212" y="0" width="90" height="30" forecolor="#000000" backcolor="#FFFFFF"/>
					<box topPadding="2" leftPadding="2" rightPadding="0">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Top" rotation="None" markup="none">
						<font fontName="SansSerif" size="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[7. Primer Apellido]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="302" y="0" width="90" height="30" forecolor="#000000" backcolor="#FFFFFF"/>
					<box topPadding="2" leftPadding="2" rightPadding="0">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Top" rotation="None" markup="none">
						<font fontName="SansSerif" size="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[8. Segundo Apellido]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="392" y="0" width="90" height="30" forecolor="#000000" backcolor="#FFFFFF"/>
					<box topPadding="2" leftPadding="2" rightPadding="0">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Top" rotation="None" markup="none">
						<font fontName="SansSerif" size="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[9. Primer Nombre]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="482" y="0" width="90" height="30" forecolor="#000000" backcolor="#FFFFFF"/>
					<box topPadding="2" leftPadding="2" rightPadding="0">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Top" rotation="None" markup="none">
						<font fontName="SansSerif" size="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[10. Otros Nombres]]></text>
				</staticText>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="524">
				<staticText>
					<reportElement stretchType="RelativeToBandHeight" x="0" y="262" width="572" height="12"/>
					<box topPadding="2" 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="Top">
						<font size="8"/>
					</textElement>
					<text><![CDATA[Nombre del pagador o agente retenedor:]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="0" y="274" width="572" height="11" backcolor="#CFD2D8"/>
					<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">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Datos a cargo del trabajador o pensionado]]></text>
				</staticText>
				<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
					<reportElement x="182" y="262" width="390" height="12"/>
					<box leftPadding="2">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0"/>
						<leftPen lineWidth="0.0"/>
						<bottomPen lineWidth="0.0"/>
						<rightPen lineWidth="0.0"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{FIRMA}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Transparent" x="0" y="295" width="342" height="10" backcolor="#FEFEFE"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.0"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="8"/>
					</textElement>
					<text><![CDATA[Arrendamientos]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="452" y="415" width="15" height="10" backcolor="#FEFEFE"/>
					<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="8" isBold="true"/>
					</textElement>
					<text><![CDATA[78]]></text>
				</staticText>
				<staticText>
					<reportElement stretchType="RelativeToTallestObject" x="432" y="457" width="140" height="67"/>
					<box topPadding="2" 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="Top">
						<font size="7"/>
					</textElement>
					<text><![CDATA[Firma del Trabajador o Pensionado:]]></text>
				</staticText>
				<textField isStretchWithOverflow="true">
					<reportElement stretchType="RelativeToTallestObject" x="0" y="457" width="432" height="67"/>
					<box topPadding="4" leftPadding="4">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Top" markup="none">
						<font size="6"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA["Certifico que durante el año gravable:" + "\n" +
"1. Mi patrimonio bruto no excedió de 4.500 UVT." + "\n" +
"2. Mis ingresos brutos fueron inferiores a 1.400 UVT." + "\n" +
"3. No fui responsable del impuesto sobre las ventas a 31 de diciembre del año gravable." + "\n" +
"4. Mis consumos mediante tarjeta de crédito no excedieron la suma de 1.400 UVT." + "\n" +
"5. Que el total de mis compras y consumos no superó la suma de 1.400 UVT." + "\n" +
"6. Que el valor total de mis consignaciones bancarias, depósitos o inversiones financieras no excedió los 1.400 UVT." + "\n\n" +
"Por lo tanto, manifiesto que no estoy obligado a presentar declaración de renta y complementario por el año gravable."]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement mode="Opaque" x="0" y="415" width="452" height="10" backcolor="#CFD2D8"/>
					<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" markup="none">
						<font size="8"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA["Deudas vigentes a 31 de Diciembre "]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="0" y="425" width="572" height="12" backcolor="#CFD2D8"/>
					<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">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Identificación de las personas dependientes de acuerdo al parágrafo 2 del art. 387 del Estatuto Tributario]]></text>
				</staticText>
				<textField pattern="#,##0.00" isBlankWhenNull="true">
					<reportElement x="467" y="415" width="105" height="10"/>
					<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="7"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Transparent" x="452" y="437" width="120" height="20" backcolor="#FEFEFE"/>
					<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="Top">
						<font size="7" isBold="false"/>
					</textElement>
					<text><![CDATA[82. Parentesco]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="0" y="437" width="80" height="20" backcolor="#FEFEFE"/>
					<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="Top">
						<font size="7" isBold="false"/>
					</textElement>
					<text><![CDATA[79. Tipo documento]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="170" y="437" width="282" height="20" backcolor="#FEFEFE"/>
					<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="Top">
						<font size="7" isBold="false"/>
					</textElement>
					<text><![CDATA[81. Apellidos y Nombres]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="452" y="285" width="120" height="10" backcolor="#FEFEFE"/>
					<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="7" isBold="true"/>
					</textElement>
					<text><![CDATA[Valor retenido]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="342" y="285" width="110" height="10" backcolor="#FEFEFE"/>
					<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="7" isBold="true"/>
					</textElement>
					<text><![CDATA[Valor recibido]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="0" y="285" width="342" height="10" backcolor="#FEFEFE"/>
					<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="7" isBold="true"/>
					</textElement>
					<text><![CDATA[Concepto de otros ingresos]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="0" y="305" width="342" height="10" backcolor="#FEFEFE"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.0"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.0"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="8"/>
					</textElement>
					<text><![CDATA[Honorarios, comisiones y servicios]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="0" y="315" width="342" height="10" backcolor="#FEFEFE"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.0"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.0"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="8"/>
					</textElement>
					<text><![CDATA[Intereses y rendimientos financieros]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="0" y="325" width="342" height="10" backcolor="#FEFEFE"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.0"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.0"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="8"/>
					</textElement>
					<text><![CDATA[Enajenación de activos fijos]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="0" y="355" width="342" height="10" backcolor="#FEFEFE"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.0"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.0"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Totales:(Valor recibido:Sume 61 a 66),(Valor retenido:Sume 68 a 73)]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="0" y="345" width="342" height="10" backcolor="#FEFEFE"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.0"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.0"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="8"/>
					</textElement>
					<text><![CDATA[Otros]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="0" y="335" width="342" height="10" backcolor="#FEFEFE"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.0"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.0"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="8"/>
					</textElement>
					<text><![CDATA[Loterías, rifas, apuestas y similares]]></text>
				</staticText>
				<textField>
					<reportElement mode="Transparent" x="0" y="365" width="452" height="10" backcolor="#FEFEFE"/>
					<box leftPadding="2">
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle" markup="none">
						<font size="8" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA["Total retenciones año gravable " + $F{ID_ANHOS} + " (Sume 60 + 74)"]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Transparent" x="342" y="355" width="15" height="10" backcolor="#FEFEFE"/>
					<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="8" isBold="true"/>
					</textElement>
					<text><![CDATA[67]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="342" y="345" width="15" height="10" backcolor="#FEFEFE"/>
					<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="8"/>
					</textElement>
					<text><![CDATA[66]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="452" y="365" width="15" height="10" backcolor="#FEFEFE"/>
					<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="8" isBold="true"/>
					</textElement>
					<text><![CDATA[75]]></text>
				</staticText>
				<textField pattern="#,##0.00" isBlankWhenNull="true">
					<reportElement x="467" y="295" width="105" height="80"/>
					<box rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.0"/>
						<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.math.BigDecimal"><![CDATA[]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Transparent" x="342" y="295" width="15" height="10" backcolor="#FEFEFE"/>
					<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="8"/>
					</textElement>
					<text><![CDATA[61]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="342" y="305" width="15" height="10" backcolor="#FEFEFE"/>
					<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="8"/>
					</textElement>
					<text><![CDATA[62]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="342" y="315" width="15" height="10" backcolor="#FEFEFE"/>
					<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="8"/>
					</textElement>
					<text><![CDATA[63]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="342" y="325" width="15" height="10" backcolor="#FEFEFE"/>
					<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="8"/>
					</textElement>
					<text><![CDATA[64]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="342" y="335" width="15" height="10" backcolor="#FEFEFE"/>
					<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="8"/>
					</textElement>
					<text><![CDATA[65]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="452" y="335" width="15" height="10" backcolor="#FEFEFE"/>
					<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="8"/>
					</textElement>
					<text><![CDATA[72]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="452" y="295" width="15" height="10" backcolor="#FEFEFE"/>
					<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="8"/>
					</textElement>
					<text><![CDATA[68]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="452" y="305" width="15" height="10" backcolor="#FEFEFE"/>
					<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="8"/>
					</textElement>
					<text><![CDATA[69]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="452" y="325" width="15" height="10" backcolor="#FEFEFE"/>
					<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="8"/>
					</textElement>
					<text><![CDATA[71]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="452" y="315" width="15" height="10" backcolor="#FEFEFE"/>
					<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="8"/>
					</textElement>
					<text><![CDATA[70]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="452" y="355" width="15" height="10" backcolor="#FEFEFE"/>
					<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="8" isBold="true"/>
					</textElement>
					<text><![CDATA[74]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="452" y="345" width="15" height="10" backcolor="#FEFEFE"/>
					<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="8"/>
					</textElement>
					<text><![CDATA[73]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="0" y="405" width="30" height="10" backcolor="#FEFEFE"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.0"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.0"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="7" isBold="true"/>
					</textElement>
					<text><![CDATA[3]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="0" y="395" width="30" height="10" backcolor="#FEFEFE"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.0"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.0"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="7" isBold="true"/>
					</textElement>
					<text><![CDATA[2]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="0" y="375" width="30" height="10" backcolor="#FEFEFE"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.0"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="7" isBold="true"/>
					</textElement>
					<text><![CDATA[Item]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="0" y="385" width="30" height="10" backcolor="#FEFEFE"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.0"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.0"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="7" isBold="true"/>
					</textElement>
					<text><![CDATA[1]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="30" y="375" width="437" height="10" backcolor="#FEFEFE"/>
					<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="7" isBold="true"/>
					</textElement>
					<text><![CDATA[76.  Identificación de los bienes y derechos poseídos]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="467" y="375" width="105" height="10" backcolor="#FEFEFE"/>
					<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="7" isBold="true"/>
					</textElement>
					<text><![CDATA[77. Valor Patrimonial]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="30" y="385" width="437" height="10" backcolor="#FEFEFE"/>
					<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="7" isBold="true"/>
					</textElement>
					<text><![CDATA[]]></text>
				</staticText>
				<textField pattern="#,##0.00" isBlankWhenNull="true">
					<reportElement x="467" y="385" width="105" height="10"/>
					<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="7"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Transparent" x="30" y="395" width="437" height="10" backcolor="#FEFEFE"/>
					<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="7" isBold="true"/>
					</textElement>
					<text><![CDATA[]]></text>
				</staticText>
				<textField pattern="#,##0.00" isBlankWhenNull="true">
					<reportElement x="467" y="395" width="105" height="10"/>
					<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="7"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Transparent" x="30" y="405" width="437" height="10" backcolor="#FEFEFE"/>
					<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="7" isBold="true"/>
					</textElement>
					<text><![CDATA[]]></text>
				</staticText>
				<textField pattern="#,##0.00" isBlankWhenNull="true">
					<reportElement x="467" y="405" width="105" height="10"/>
					<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="7"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[]]></textFieldExpression>
				</textField>
				<subreport>
					<reportElement x="0" y="0" width="572" height="262"/>
					<subreportParameter name="id_anhos">
						<subreportParameterExpression><![CDATA[$P{id_anhos}]]></subreportParameterExpression>
					</subreportParameter>
					<subreportParameter name="whereFuncionarioTipoDoc">
						<subreportParameterExpression><![CDATA[$P{whereFuncionarioTipoDoc}]]></subreportParameterExpression>
					</subreportParameter>
					<subreportParameter name="whereFuncionarioNumDoc">
						<subreportParameterExpression><![CDATA[$P{whereFuncionarioNumDoc}]]></subreportParameterExpression>
					</subreportParameter>
					<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
					<subreportExpression class="java.lang.String"><![CDATA["repo:subreport_certif_dian"]]></subreportExpression>
				</subreport>
				<staticText>
					<reportElement mode="Transparent" x="80" y="437" width="90" height="20" backcolor="#FEFEFE"/>
					<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="Top">
						<font size="7" isBold="false"/>
					</textElement>
					<text><![CDATA[80. No. Documento]]></text>
				</staticText>
			</band>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="40" splitType="Stretch">
			<rectangle>
				<reportElement x="0" y="0" width="572" height="40"/>
				<graphicElement>
					<pen lineWidth="0.75"/>
				</graphicElement>
			</rectangle>
			<image>
				<reportElement x="7" y="2" width="115" height="38"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:logo_dian"]]></imageExpression>
			</image>
			<image>
				<reportElement x="471" y="2" width="100" height="36"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:logo_numero"]]></imageExpression>
			</image>
			<textField>
				<reportElement x="122" y="0" width="348" height="40"/>
				<box>
					<leftPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Certificado de Ingresos y Retenciones por Rentas de Trabajo y de Pensiones \nAño Gravable " + $P{id_anhos}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="18" splitType="Stretch">
			<textField>
				<reportElement x="422" y="0" width="150" height="18"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{SECUECNIA}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="302" y="0" width="120" height="18" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[4. Número de Formulario:]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="302" height="18" 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="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Antes de diligenciar este formulario lea cuidadosamente las instrucciones.]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band splitType="Stretch"/>
	</detail>
	<columnFooter>
		<band height="28" splitType="Stretch">
			<staticText>
				<reportElement x="0" y="0" width="572" height="28"/>
				<box leftPadding="0" rightPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<text><![CDATA[Nota: este certificado sustituye para todos los efectos legales la declaración de Renta y Complementario para el trabajador o pensionado que cumpla con lo estabecido en el artículo 1.6.1.13.2.7. del Decreto 1625 de 2016 Único reglamentario en materia tributaria.
Para aquellos trabajadores independientes contribuyentes del impuesto unificado deberán presentar la declaración anual consolidada del Régimen Simple de Tributación (SIMPLE).]]></text>
			</staticText>
		</band>
	</columnFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="572" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
