<?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="subreport_certif_dian_2022" language="groovy" pageWidth="572" pageHeight="572" orientation="Landscape" columnWidth="572" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
	<property name="ireport.zoom" value="1.8181818181818186"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="id_anhos" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereFuncionarioTipoDoc" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereFuncionarioNumDoc" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select
--tab.agrupacion_orden,
tab.id_tipo_doc,
tab.num_doc,
/**
Solicitud GA-#31530: Se retira valor absoluto ABS() para el certificado, conceptos devengados, antes todas - 20220822::LAVILA
Se quita valor absoluto para agrupaciones de ingreso. para presentar negativo cuando realmente el valor es negativo
Las agrupaciones de deducciones si conservan valor absoluto
*/
round(/*ABS*/(nvl( sum( case when tab.agrupacion_orden = 1  then tab.valor_total else 0 end) ,0 )),-3) as agrup1,
round(ABS(nvl( sum( case when tab.agrupacion_orden = 2  then tab.valor_total else 0 end) ,0 )),-3) as agrup2,
round(ABS(nvl( sum( case when tab.agrupacion_orden = 3  then tab.valor_total else 0 end) ,0 )),-3) as agrup3,
round(/*ABS*/(nvl( sum( case when tab.agrupacion_orden = 4  then tab.valor_total else 0 end) ,0 )),-3) as agrup4,
round(ABS(nvl( sum( case when tab.agrupacion_orden = 5  then tab.valor_total else 0 end) ,0 )),-3) as agrup5,
round(/*ABS*/(nvl( sum( case when tab.agrupacion_orden = 6  then tab.valor_total else 0 end) ,0 )),-3) as agrup6,
round(/*ABS*/(nvl( sum( case when tab.agrupacion_orden = 7  then tab.valor_total else 0 end) ,0 )),-3) as  ces,
round(/*ABS*/(nvl( sum( case when tab.agrupacion_orden = 8  then tab.valor_total else 0 end) ,0 )),-3) as  otros,
round(/*ABS*/(nvl( sum( case when tab.agrupacion_orden = 24  then tab.valor_total else 0 end) ,0 )),-3) as  viaticos,
round(ABS(nvl( sum( case when tab.agrupacion_orden = 21 then tab.valor_total else 0 end) ,0 )),-3) as  apovol,
round(ABS(nvl( sum( case when tab.agrupacion_orden = 22 then tab.valor_total else 0 end) ,0 )),-3) as  apoafc,
round(/*ABS*/(nvl( sum( case when tab.agrupacion_orden = 23 then tab.valor_total else 0 end) ,0 )),-3) as  prsetsoc,
round(/*ABS*/(nvl( sum( case when tab.agrupacion_orden = 30 then tab.valor_total else 0 end) ,0 )),-3) as  covidvol,
round(/*ABS*/(nvl( sum( case when tab.agrupacion_orden = 31 then tab.valor_total else 0 end) ,0 )),-3) as  covidobl,
round(/*ABS*/(nvl( sum( case when tab.agrupacion_orden = 32 then tab.valor_total else 0 end) ,0 )),-3) as  cesconsig


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

order by
--tab.agrupacion_orden,
tab.num_doc]]>
	</queryString>
	<field name="ID_TIPO_DOC" class="java.math.BigDecimal"/>
	<field name="NUM_DOC" 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"/>
	<field name="COVIDVOL" class="java.math.BigDecimal"/>
	<field name="COVIDOBL" class="java.math.BigDecimal"/>
	<field name="CESCONSIG" class="java.math.BigDecimal"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<detail>
		<band height="212" splitType="Stretch">
			<textField pattern="#,##0">
				<reportElement x="460" y="152" width="112" 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[$F{AGRUP2}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0">
				<reportElement x="460" y="162" width="112" 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[$F{AGRUP3}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0">
				<reportElement x="460" y="182" width="112" 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[$F{APOVOL}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0">
				<reportElement x="460" y="202" width="112" 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[$F{AGRUP5}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="0" y="152" width="445" 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[Aportes obligatorios por salud a cargo del trabajador]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="0" y="162" width="445" 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[Aportes obligatorios a fondos de pensiones y solidaridad pensional a cargo del trabajador]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="202" width="445" 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">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Valor de la retención en la fuente por ingresos laborales y de pensiones]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="0" y="182" width="445" 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[Aportes voluntarios a fondos de pensiones]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="140" width="445" 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 Aportes]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="445" y="140" width="127" 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>
			<textField pattern="#,##0" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="460" y="130" width="112" height="10" backcolor="#CFD2D8"/>
				<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" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{AGRUP1} + $F{CES} + $F{AGRUP6} + $F{VIATICOS} + $F{PRSETSOC} + $F{OTROS} + $F{CESCONSIG}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="0" y="130" width="445" 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">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Total de ingresos brutos (Sume 36 a 48)]]></text>
			</staticText>
			<textField pattern="#,##0">
				<reportElement x="460" y="0" width="112" 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[$F{AGRUP1}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="0" y="0" width="445" 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[Pagos por salarios o emolumentos eclesiásticos]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="445" y="152" 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[50]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="445" y="0" 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[36]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="445" y="130" width="15" 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">
					<font size="8"/>
				</textElement>
				<text><![CDATA[49]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="445" y="162" 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[51]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="445" y="182" 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[53]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="445" y="202" 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[55]]></text>
			</staticText>
			<textField pattern="#,##0">
				<reportElement x="460" y="192" width="112" 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[$F{APOAFC}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="445" y="192" 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[54]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="0" y="192" width="445" 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[Aportes a cuentas AFC]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="0" y="40" width="445" 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[Pagos por comisiones]]></text>
			</staticText>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement x="460" y="40" width="112" 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="445" y="40" 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[40]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="0" y="30" width="445" 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[Pagos por servicios]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="445" y="30" 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[39]]></text>
			</staticText>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement x="460" y="30" width="112" 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="0" y="20" width="445" 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[Pagos por honorarios]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="445" y="20" 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[38]]></text>
			</staticText>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement x="460" y="20" width="112" 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="0" y="50" width="445" 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[Pagos por prestaciones sociales]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="445" y="50" 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[41]]></text>
			</staticText>
			<textField pattern="#,##0" isBlankWhenNull="true">
				<reportElement x="460" y="50" width="112" 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[$F{PRSETSOC}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="0" y="60" width="445" 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[Pagos por viáticos]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="445" y="60" 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[42]]></text>
			</staticText>
			<textField pattern="#,##0" isBlankWhenNull="true">
				<reportElement x="460" y="60" width="112" 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[$F{VIATICOS}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="0" y="70" width="445" 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[Pagos por gastos de representación]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="445" y="70" 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[43]]></text>
			</staticText>
			<textField pattern="#,##0" isBlankWhenNull="true">
				<reportElement x="460" y="70" width="112" 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[$F{AGRUP6}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement x="460" y="80" width="112" 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="445" y="80" 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[44]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="0" y="80" width="445" 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[Pagos por compensaciones por el trabajo asociado cooperativo]]></text>
			</staticText>
			<textField pattern="#,##0" isBlankWhenNull="true">
				<reportElement x="460" y="90" width="112" 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[$F{OTROS}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="445" y="90" 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[45]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="0" y="90" width="445" 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[Otros pagos]]></text>
			</staticText>
			<textField pattern="#,##0" isBlankWhenNull="true">
				<reportElement x="460" y="100" width="112" 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[$F{CES}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="445" y="100" 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[46]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="0" y="100" width="445" 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[Cesantías e intereses de cesantías efectivamente pagadas al empleado]]></text>
			</staticText>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement x="460" y="120" width="112" 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="445" y="120" 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[48]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="0" y="120" width="445" 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[Pensiones de jubilación, vejez o invalidez]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="0" y="10" width="445" 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[Pagos realizados con bonos electrónicos o de papel de servicio, cheques, tarjetas, vales, etc.]]></text>
			</staticText>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement x="460" y="10" width="112" 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="445" y="10" 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[37]]></text>
			</staticText>
			<textField pattern="#,##0" isBlankWhenNull="true">
				<reportElement x="460" y="110" width="112" 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[$F{CESCONSIG}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="0" y="110" width="445" 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[Cesantías consignadas al fondo de cesantias]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="445" y="110" 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[47]]></text>
			</staticText>
			<textField pattern="#,##0" isBlankWhenNull="true">
				<reportElement x="460" y="172" width="112" 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="0" y="172" width="445" 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[Cotizaciones voluntarias al régimen de ahorro individual con solidaridad - RAIS]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="445" y="172" 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[52]]></text>
			</staticText>
		</band>
	</detail>
</jasperReport>
