<?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_exogena_dian_2276" language="groovy" pageWidth="3220" pageHeight="612" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="3180" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.1289478601075615"/>
	<property name="ireport.x" value="328"/>
	<property name="ireport.y" value="0"/>
	<parameter name="id_anhos" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<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="fecha_expe" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[Select distinct tab.* from (

select

13 as TDOC,

'$' || 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.retiro,
tab0.secuecnia,
tab0.fecha_ingreso,
tab0.fecha_termina,
tab0.abreviacion,
tab0.nombre_ciudad,
'11' as coddepto,
'11001' as codmun_text,
tab0.id_tipo_doc,
tab0.num_doc,
tab0.id_anhos,
tab0.tipo_documento,
tab0.primer_nombre,
tab0.segundo_nombre,
tab0.primer_apellido,
tab0.segundo_apellido,
tab0.nombre_completo,
tab0.nombre_apellido,
tab0.fecha_nace,
tab0.direccion as dir,
tab0.pais_nace,
tab0.depto_nace,
tab0.muni_nace,
tab0.pais_dir,
tab0.depto_dir,
tab0.muni_dir,

tab1.agrup1 as agrup1,
tab1.agrup2 as agrup2,
tab1.agrup3 as agrup3,
tab1.agrup4 as agrup4,
tab1.agrup5 as agrup5,
tab1.agrup6 as agrup6,
tab1.ces as ces,
tab1.otros as otros,
tab1.viaticos as viaticos,
tab1.apovol as apovol,
tab1.apoafc as apoafc,
tab1.prsetsoc as prsetsoc

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 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,
    upper(tab1.pais_nace) as pais_nace,
    upper(tab1.depto_nace) as depto_nace,
    upper(tab1.muni_nace) as muni_nace,
    upper(tab1.pais_dir) as pais_dir,
    upper(tab1.depto_dir) as depto_dir,
    upper(tab1.muni_dir) as muni_dir,
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.*,
     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')
)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



left join (

select
--tab.agrupacion_orden,
tab.id_tipo_doc,
tab.num_doc,
round(ABS(nvl( sum( case when tab.agrupacion_orden = 1  then tab.valor_total else 0 end) ,0 )),1) as agrup1,
round(ABS(nvl( sum( case when tab.agrupacion_orden = 2  then tab.valor_total else 0 end) ,0 )),1) as agrup2,
round(ABS(nvl( sum( case when tab.agrupacion_orden = 3  then tab.valor_total else 0 end) ,0 )),1) as agrup3,
round(ABS(nvl( sum( case when tab.agrupacion_orden = 4  then tab.valor_total else 0 end) ,0 )),1) as agrup4,
round(ABS(nvl( sum( case when tab.agrupacion_orden = 5  then tab.valor_total else 0 end) ,0 )),1) as agrup5,
round(ABS(nvl( sum( case when tab.agrupacion_orden = 6  then tab.valor_total else 0 end) ,0 )),1) as agrup6,
round(ABS(nvl( sum( case when tab.agrupacion_orden = 7  then tab.valor_total else 0 end) ,0 )),1) as  ces,
round(ABS(nvl( sum( case when tab.agrupacion_orden = 8  then tab.valor_total else 0 end) ,0 )),1) as  otros,
round(ABS(nvl( sum( case when tab.agrupacion_orden = 24  then tab.valor_total else 0 end) ,0 )),1) as  viaticos,
round(ABS(nvl( sum( case when tab.agrupacion_orden = 21 then tab.valor_total else 0 end) ,0 )),1) as  apovol,
round(ABS(nvl( sum( case when tab.agrupacion_orden = 22 then tab.valor_total else 0 end) ,0 )),1) as  apoafc,
round(ABS(nvl( sum( case when tab.agrupacion_orden = 23 then tab.valor_total else 0 end) ,0 )),1) as  prsetsoc


from (


    SELECT DISTINCT
    tab0.agrupacion_orden,
    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,
    case when tab2.operador = 1 then tab0.valor_total else tab0.valor_total * (-1) end 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


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

    group by
    --tab.agrupacion_orden,
    tab.id_tipo_doc,
    tab.num_doc

)tab1
on tab1.id_tipo_doc = tab0.id_tipo_doc
and tab1.num_doc = tab0.num_doc


WHERE
1 = 1

)tab

order by
tab.id_anhos,
tab.num_doc]]>
	</queryString>
	<field name="TDOC" class="java.math.BigDecimal"/>
	<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="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="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="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="DIR" 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="PAIS_DIR" class="java.lang.String"/>
	<field name="DEPTO_DIR" class="java.lang.String"/>
	<field name="MUNI_DIR" class="java.lang.String"/>
	<field name="AGRUP1" class="java.math.BigDecimal"/>
	<field name="AGRUP2" class="java.math.BigDecimal"/>
	<field name="AGRUP3" class="java.math.BigDecimal"/>
	<field name="AGRUP4" class="java.math.BigDecimal"/>
	<field name="AGRUP5" class="java.math.BigDecimal"/>
	<field name="AGRUP6" class="java.math.BigDecimal"/>
	<field name="CES" class="java.math.BigDecimal"/>
	<field name="OTROS" class="java.math.BigDecimal"/>
	<field name="VIATICOS" class="java.math.BigDecimal"/>
	<field name="APOVOL" class="java.math.BigDecimal"/>
	<field name="APOAFC" class="java.math.BigDecimal"/>
	<field name="PRSETSOC" class="java.math.BigDecimal"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="60" splitType="Stretch">
			<textField pattern="dd-MMM-yyyy   hh:mm aaa">
				<reportElement mode="Opaque" x="2460" y="40" width="240" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="530" y="0" width="1690" height="40"/>
				<textElement textAlignment="Center" verticalAlignment="Bottom" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Sistema General de Nómina
Informe Exogena DIAN 2276]]></text>
			</staticText>
			<image>
				<reportElement x="0" y="0" width="130" height="60"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
			<staticText>
				<reportElement mode="Opaque" x="2460" y="28" width="240" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" 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[Fecha de Impresión:]]></text>
			</staticText>
			<textField>
				<reportElement x="530" y="40" width="1690" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Periodo: " + $P{fecha_ini} + " a " +$P{fecha_fin}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="20" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="50" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="60" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Tipo de documento del empleado]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="60" y="0" width="70" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Número identificación del empleado]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="130" y="0" width="100" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Primer apellido del informado]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="230" y="0" width="100" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Segundo apellido del informado]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="330" y="0" width="100" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Primer nombre del informado]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="430" y="0" width="100" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Otros nombres del informado]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1020" y="0" width="120" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Pagos por salarios]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1140" y="0" width="120" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Pagos por emolumentos eclesiásticos]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1260" y="0" width="120" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Pagos por honorarios]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1500" y="0" width="120" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Pagos por comisiones]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1380" y="0" width="120" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Pagos por servicios]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1620" y="0" width="120" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Pagos por prestaciones sociales]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="530" y="0" width="190" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Dirección]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1980" y="0" width="120" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Pagos por compensaciones por el trabajo asociado cooperativo]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1860" y="0" width="120" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Pagos por gastos de representación]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="2220" y="0" width="120" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Pagos realizados con bonos electrónicos o de papel de servicio, cheques, tarjetas, vales, etc.]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="2100" y="0" width="120" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Otros pagos]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1740" y="0" width="120" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[ Pagos por viáticos]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="2940" y="0" width="120" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Aportes a cuentas AFC]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="2580" y="0" width="120" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Aportes Obligatorios por salud]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="2820" y="0" width="120" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Aportes voluntarios a fondos de pensiones voluntarias]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="3060" y="0" width="120" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Valores de las Retenciones en la fuente por pagos de rentas de trabajo o pensiones]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="2460" y="0" width="120" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Pensiones de Jubilación, vejez o invalidez]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="2340" y="0" width="120" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Cesantías e intereses de cesantías efectivamente pagadas]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="720" y="0" width="100" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Departamento del beneficiario]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="820" y="0" width="100" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Municipio del beneficiario]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="920" y="0" width="100" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[País del beneficiario]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="2700" y="0" width="120" height="50" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Aportes obligatorios a fondos de pensiones y solidaridad pensional y Aportes voluntarios al - RAIS]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="10" splitType="Stretch">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="60" 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 textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TDOC}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="60" y="0" width="70" height="10"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_DOC}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="330" y="0" width="100" height="10"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PRIMER_NOMBRE}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="130" y="0" width="100" height="10"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PRIMER_APELLIDO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="230" y="0" width="100" height="10"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SEGUNDO_APELLIDO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="430" y="0" width="100" height="10"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SEGUNDO_NOMBRE}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1020" y="0" width="120" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{AGRUP1}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1140" y="0" width="120" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[0]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1260" y="0" width="120" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1260" y="0" width="120" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[0]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1380" y="0" width="120" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[0]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1500" y="0" width="120" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[0]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1620" y="0" width="120" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{PRSETSOC}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="530" y="0" width="190" height="10"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DIR}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="2820" y="0" width="120" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{APOVOL}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="2700" y="0" width="120" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{AGRUP3}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="2580" y="0" width="120" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{AGRUP2}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="3060" y="0" width="120" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{AGRUP5}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1740" y="0" width="120" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VIATICOS}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1860" y="0" width="120" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="2220" y="0" width="120" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[0]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="2100" y="0" width="120" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{OTROS}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1860" y="0" width="120" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{AGRUP6}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1980" y="0" width="120" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[0]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="2340" y="0" width="120" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{CES}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="2460" y="0" width="120" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[0]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="720" y="0" width="100" height="10"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DEPTO_DIR}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="820" y="0" width="100" height="10"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{MUNI_DIR}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="920" y="0" width="100" height="10"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PAIS_DIR}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="2940" y="0" width="120" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif" size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{APOAFC}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="11" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="24" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="1303" y="12" width="87" height="12" forecolor="#575757" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Página "+$V{PAGE_NUMBER}+" de "]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement mode="Opaque" x="1390" y="12" width="60" height="12" forecolor="#575757" backcolor="#FFFFFF"/>
				<box leftPadding="2"/>
				<textElement 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[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="1303" y="0" width="147" height="12" forecolor="#575757"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<text><![CDATA[Websafi - Nómina]]></text>
			</staticText>
		</band>
	</pageFooter>
	<summary>
		<band height="14" splitType="Stretch"/>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="2700" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
