<?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="gen_archivos_siif_nacion_siif" language="groovy" pageWidth="1020" pageHeight="612" orientation="Landscape" columnWidth="980" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="2.0"/>
	<property name="ireport.x" value="576"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/nomina/gen_archivos_siif_nacion_siif"/>
	<property name="ireport.jasperserver.url" value="http://3.22.202.200:8080/jasperserver/services/repository"/>
	<parameter name="id_periodo_filtro" class="java.lang.String">
		<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>
	<parameter name="whereBanco" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTipoCuenta" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="tipo_banco_nom" class="java.lang.String"/>
	<parameter name="whereClasePlanta" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="id_tipo_atributo_contab" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[BigDecimal.valueOf(0)]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[/*
 Los conceptos que se encuentran como REINTEGROS asociados a conceptos de Devengados, pueden aparecer en la Hoja 2 (CONCEPTOS) o en la Hoja 3 (DEDUCCIONES), dependiendo de:

Si NO tiene parametrizado RUBRO PRESUPUESTAL, y SI tiene concepto SIIF, saldrá siempre como deducción en la hoja 3.

Si NO tiene parametrizado RUBRO PRESUPUESTAL, y NO tiene concepto SIIF, NO saldrá en ninguna hoja.

Si SI tiene parametrizado RUBRO PRESUPUESTAL, y SI tiene concepto SIIF, se verifica lo siguiente:

-- Si existe en la misma nómina el concepto original, realiza el neteo contra el concepto original, afectando la hoja 2 y NO saldrá en la hoja 3.
-- Si NO existe en la misma nómina el concepto original, saldrá en la hoja 3.
*/
Select
rownum as rn,
tab.* from(


select
tab0.* ,
(select distinct periodo.periodo from no_periodo_v periodo where periodo.id_periodo = $P{id_periodo_filtro} ) as periodo


from(

    select
    id_clase_planta,
    id_periodo,
    case when estado = 0 then null else id_bn end as id_bn,
    case when estado = 0 then null else id end as tipo_cuenta,
    id_tipo_doc,
    replace(codigo_siif,'0','0') as codigo_siif,
    num_doc,
    nombre_apellido,
    case when estado = 0 then 'CH' else 'AC' end as medio_pago,
    case when estado = 0 then null else replace(tipo_iden,'0','0') end as tipo_iden,
    case when estado = 0 then null else nit_bn end as nit_bn,
    case when estado = 0 then null else banco end as banco,
    codigo_ach,
    descripcion,
    case when estado = 0 then null else nombre_corto end as nombre_corto,
    case when estado = 0 then null else num_cuenta end as num_cuenta,
    sum(nvl(valor_dev,0)) as valor_dev,
    sum(nvl(valor_ded,0)) as valor_ded,
    sum(nvl(valor,0)) as valor,
    11 as tipo_cuenta_pagar

    from(

        select
        tab7.id_clase_planta,
        rub.descripcion as descripcion_rub, rub.rubro as  codigo_rubro, rub.id_tipo_atributo_contab,
        tab5.operador,
        tab.valor as valorsum,

        tab1.num_doc,tab6.nombre_apellido,
        tab3.codigo||' - '||tab3.descripcion as banco, tab3.codigo_ach,
        tab2.num_cuenta,
        case when nvl(tab2.estado,0) = 0 and tab7.estado = 0 and tab2.fecha_terminacion <= tab7.fecha_termina then 1 else nvl(tab2.estado,0) end as estado,
        case when tab5.operador = 1 then tab1.valor_liquidado
             when tab5.operador = 0 and tab5.id_tipo_concepto_org = 1 then (tab1.valor_liquidado * -1) else (tab1.valor_liquidado * -1) end as valor,
        /*
        case when tab5.operador = 1 and tab5.id_rubro is not null then tab1.valor_liquidado
             when tab5.operador = 0 and tab5.id_rubro is not null and tab5.id_tipo_concepto_org = 1 then (tab1.valor_liquidado * -1) else 0 end as valor_dev,
        case when tab5.operador = 0 and tab5.id_tipo_concepto_org != 1 then tab1.valor_liquidado
             when tab5.operador = 1 and tab5.id_rubro is null and tab5.id_tipo_concepto_org != 1 then (tab1.valor_liquidado * -1) else 0 end as valor_ded,*/

        /*validar si es concepto es de reintegro, que no tenga concepto original se coloca en deducido - 20200819
        o es reintegro y no tiene rubro - 20200916
        */
        case
            when ( esrein.id_concep_nomina is not null and tab5.id_rubro is null ) then 0
            when ( esrein.id_concep_nomina is not null and conorig.id_concep_nomina is null ) then 0

            when tab5.operador = 1 and tab5.id_rubro is not null then tab1.valor_liquidado
            when tab5.operador = 0 and tab5.id_rubro is not null and tab5.id_tipo_concepto_org = 1 then (tab1.valor_liquidado * -1)
        else 0 end as valor_dev,
        case
            when ( esrein.id_concep_nomina is null or ( esrein.id_concep_nomina is not null and conorig.id_concep_nomina is null ) or  ( esrein.id_concep_nomina is not null and tab5.id_rubro is null ) )
                and tab5.operador = 0 and tab5.id_tipo_concepto_org = 1 then tab1.valor_liquidado
            when ( esrein.id_concep_nomina is null or ( esrein.id_concep_nomina is not null and conorig.id_concep_nomina is null ) or  ( esrein.id_concep_nomina is not null and tab5.id_rubro is null ) )
                and tab5.operador = 1 and tab5.id_rubro is null and tab5.id_tipo_concepto_org = 1 then (tab1.valor_liquidado * -1)
            when tab5.operador = 0 and tab5.id_tipo_concepto_org != 1 then tab1.valor_liquidado
            when tab5.operador = 1 and tab5.id_rubro is null and tab5.id_tipo_concepto_org != 1 then (tab1.valor_liquidado * -1)
        else 0 end as valor_ded,

        tab1.id_periodo,
        tab1.id_tipo_doc, tab3.id_bn, terbn.NUM_DOC as nit_bn, tipiden.codigo_siif as tipo_iden,
        tab4.id,
        tab4.descripcion,
        tab4.nombre_corto,
        tab8.codigo_siif
        from no_liquida_nomina tab1

        left join no_concep_nomina tab5 on tab5.id_concep_nomina = tab1.id_concep_nomina
        left join pr_rubro_presup_v rub on  rub.id_rubro = tab5.id_rubro
        left join no_datos_funcionario_v tab6  on tab6.id_tipo_doc = tab1.id_tipo_doc and tab6.num_doc = tab1.num_doc

        --join no_pago_func tab2 on tab2.id_tipo_doc = tab1.id_tipo_doc and tab2.num_doc = tab1.num_doc
        left join (
          SELECT
           aut.*,
           ROW_NUMBER() OVER (
            partition by aut.num_doc
            ORDER BY aut.num_doc asc, aut.fecha_activacion desc, aut.id_pago_func desc
           ) AS rn
          from no_pago_func aut
        )tab2
        on tab1.id_tipo_doc = tab2.id_tipo_doc and tab1.num_doc = tab2.num_doc
        and tab2.rn = 1
        left join no_nombramiento_v tab7  ON tab7.id_tipo_doc = tab1.id_tipo_doc and tab7.num_doc = tab1.num_doc

        left join ts_bn tab3 on tab3.id_bn = tab2.id_bn
        left join interceros terbn
        on terbn.id_mae_ter = tab3.id_mae_ter
        left join tipo_identificacion tipiden
        on tipiden.id_tipo_identificacion = terbn.id_tipo_doc

        left join ts_tc tab4 on tab4.id = tab2.tipo_cuenta

        join tipo_documento tab8 on tab8.id_tipo_doc = tab1.id_tipo_doc

        left join(

            select

            tab.id_periodo,
            tab.id_tipo_doc,
            tab.num_doc,
            tab.nombre_apellido,
            tab.estado,

            sum(nvl(tab.valor,0)) as valor,
            sum(nvl(tab.valor_dev,0)) as valor_dev,
            sum(nvl(tab.valor_ded,0)) as valor_ded

            from(

                select
                rub.descripcion as descripcion_rub, rub.rubro as  codigo_rubro, rub.id_tipo_atributo_contab,
                tab5.operador,
                tab1.num_doc,tab6.nombre_apellido,

                case when nvl(tab2.estado,0) = 0 and tab7.estado = 0 and tab2.fecha_terminacion <= tab7.fecha_termina then 1 else nvl(tab2.estado,0) end as estado,
        case when tab5.operador = 1 then tab1.valor_liquidado
             when tab5.operador = 0 and tab5.id_tipo_concepto_org = 1 then (tab1.valor_liquidado * -1) else (tab1.valor_liquidado * -1) end as valor,
        case when tab5.operador = 1 then tab1.valor_liquidado
             when tab5.operador = 0 and tab5.id_tipo_concepto_org = 1 then (tab1.valor_liquidado * -1) else 0 end as valor_dev,
        case when tab5.operador = 0 and tab5.id_tipo_concepto_org != 1 then tab1.valor_liquidado else 0 end as valor_ded,
                tab1.id_periodo,
                tab1.id_tipo_doc

                from no_liquida_nomina tab1

                left join no_concep_nomina tab5 on tab5.id_concep_nomina = tab1.id_concep_nomina
                left join pr_rubro_presup_v rub on  rub.id_rubro = tab5.id_rubro
                left join no_datos_funcionario_v tab6  on tab6.id_tipo_doc = tab1.id_tipo_doc and tab6.num_doc = tab1.num_doc

                --join no_pago_func tab2 on tab2.id_tipo_doc = tab1.id_tipo_doc and tab2.num_doc = tab1.num_doc
                left join (
                  SELECT
                   aut.*,
                   ROW_NUMBER() OVER (
                    partition by aut.num_doc
                    ORDER BY aut.num_doc asc, aut.fecha_activacion desc, aut.id_pago_func desc
                   ) AS rn
                  from no_pago_func aut
                )tab2
                on tab1.id_tipo_doc = tab2.id_tipo_doc and tab1.num_doc = tab2.num_doc
                and tab2.rn = 1
                left join no_nombramiento_v tab7  ON tab7.id_tipo_doc = tab1.id_tipo_doc and tab7.num_doc = tab1.num_doc


                where
                tab1.id_periodo = $P{id_periodo_filtro}
                and tab5.pago_func = 1

                and (case when tab5.operador = 0 then 1 else (case when nvl(rub.id_tipo_atributo_contab,1) = 1 then 1 else 0 end) end) = 1

            )tab

            group by
            tab.id_periodo,
            tab.id_tipo_doc,
            tab.num_doc,
            tab.nombre_apellido,
            tab.estado

        )tab
        on tab.id_periodo = tab1.id_periodo
        and tab.id_tipo_doc = tab1.id_tipo_doc
        and tab.num_doc = tab1.num_doc

        left join(

            select
              liq.id_tipo_doc,
              liq.num_doc,
              concep.id_concep_rein as id_concep_nomina,
              liq.id_periodo,
              sum(liq.valor_liquidado) as valor_liquidado

            from no_concep_nomina concep

            left join no_liquida_nomina liq
            on concep.id_concep_nomina = liq.id_concep_nomina

            where
            concep.id_concep_rein is not null
            and concep.id_tipo_concepto = 1
            AND concep.id_rubro is not null

              group by
              liq.id_tipo_doc,
              liq.num_doc,
              concep.id_concep_rein,
              liq.id_periodo
        )conorig
        on conorig.id_concep_nomina = tab5.id_concep_nomina
          and conorig.id_tipo_doc = tab1.id_tipo_doc
          and conorig.num_doc = tab1.num_doc
          and conorig.id_periodo = tab1.id_periodo

        left join(

            select
              concep.*
            from no_concep_nomina concep

            where
            concep.id_concep_nomina in (select no_concep_nomina.id_concep_rein from no_concep_nomina
                    where
                    id_concep_rein is not null
                    and id_tipo_concepto = 1
                    AND id_rubro is not null)
        )esrein
        on esrein.id_concep_nomina = tab5.id_concep_nomina

        where
        tab1.id_periodo = $P{id_periodo_filtro}
        and tab5.pago_func = 1
        /*Filtra seegun atributo contable del rubro*/
        and (case when 0 = $P{id_tipo_atributo_contab} then 1
                  when tab5.operador = 0
                  then (case when tab.valor >= 0 and 1 = $P{id_tipo_atributo_contab} then 1
                             when tab.valor <  0 and 2 = $P{id_tipo_atributo_contab} then 1
                             else 0 end)
                  else (case when nvl(rub.id_tipo_atributo_contab,1) = $P{id_tipo_atributo_contab}
                             then 1
                             else 0 end) end
            ) = 1

    )
    group by
    id_clase_planta,
    codigo_siif,
    num_doc,nombre_apellido,
    tipo_iden,
    nit_bn,
    banco,codigo_ach,
    num_cuenta,descripcion,id_periodo,
    id_tipo_doc, id_bn, id, nombre_corto, estado

)tab0

where
1 = 1
$P!{whereFuncionarioNumDoc} $P!{whereFuncionarioTipoDoc}
$P!{whereClasePlanta}

and (

    tab0.num_doc not in (
     select nom.num_doc from no_nombramiento_v nom
      where nom.fecha_retiro is not null
      and (select no_periodo.fecha_ini from no_periodo
            where id_periodo = $P{id_periodo_filtro}) > trunc(last_day( nom.fecha_termina ))
    )

    or

    (select distinct periodo.id_tipo_periodo from no_periodo_v periodo where periodo.id_periodo = $P{id_periodo_filtro}) in (6,7,2,5)

)

order by
tab0.num_doc

)tab]]>
	</queryString>
	<field name="RN" class="java.math.BigDecimal"/>
	<field name="ID_CLASE_PLANTA" class="java.math.BigDecimal"/>
	<field name="ID_PERIODO" class="java.math.BigDecimal"/>
	<field name="ID_BN" class="java.math.BigDecimal"/>
	<field name="TIPO_CUENTA" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_DOC" class="java.math.BigDecimal"/>
	<field name="CODIGO_SIIF" class="java.lang.String"/>
	<field name="NUM_DOC" class="java.lang.String"/>
	<field name="NOMBRE_APELLIDO" class="java.lang.String"/>
	<field name="MEDIO_PAGO" class="java.lang.String"/>
	<field name="TIPO_IDEN" class="java.lang.String"/>
	<field name="NIT_BN" class="java.lang.String"/>
	<field name="BANCO" class="java.lang.String"/>
	<field name="CODIGO_ACH" class="java.lang.String"/>
	<field name="DESCRIPCION" class="java.lang.String"/>
	<field name="NOMBRE_CORTO" class="java.lang.String"/>
	<field name="NUM_CUENTA" class="java.lang.String"/>
	<field name="VALOR_DEV" class="java.math.BigDecimal"/>
	<field name="VALOR_DED" class="java.math.BigDecimal"/>
	<field name="VALOR" class="java.math.BigDecimal"/>
	<field name="TIPO_CUENTA_PAGAR" class="java.math.BigDecimal"/>
	<field name="PERIODO" class="java.lang.String"/>
	<variable name="total" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR}]]></variableExpression>
	</variable>
	<variable name="cantidad" class="java.math.BigDecimal" calculation="Count">
		<variableExpression><![CDATA[$F{NUM_DOC}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<pageHeader>
		<band height="20" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="50" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="490" y="20" width="70" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[TIPO DE CUENTA BANCARIA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="560" y="20" width="80" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[NUMERO DE CUENTA BANCARIA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="900" y="20" width="80" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[VALOR NETO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="70" y="20" width="90" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[TIPO DE DOCUMENTO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="160" y="20" width="90" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[NUMERO DE CEDULA O NIT]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="250" y="20" width="70" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[MEDIO DE PAGO ]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="820" y="20" width="80" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[TOTAL DEDUCCIONES]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="740" y="20" width="80" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[VALOR TOTAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="320" y="20" width="70" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[TIPO DOCUMENTO ENTIDAD BANCARIA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="390" y="20" width="100" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[NUMERO DE NIT DE ENTIDAD BANCARIA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="20" width="70" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CONSECUTIVO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="250" y="0" width="390" height="20" forecolor="#000000" backcolor="#8DBEEC"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[INFORMACION MEDIO DE PAGO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="250" height="20" forecolor="#000000" backcolor="#8DBEEC"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[DATOS DEL FUNCIONARIO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="740" y="0" width="240" height="20" forecolor="#000000" backcolor="#8DBEEC"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[TOTALES]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="640" y="20" width="100" height="30" forecolor="#000000" backcolor="#A0D0FD"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[TIPO CUENTA POR PAGAR]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="640" y="0" width="100" height="20" forecolor="#000000" backcolor="#8DBEEC"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CUENTA POR PAGAR]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="13" splitType="Stretch">
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="560" y="0" width="80" height="13" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_CUENTA}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="900" y="0" width="80" height="13" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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.math.BigDecimal"><![CDATA[$F{VALOR}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="490" y="0" width="70" height="13" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NOMBRE_CORTO}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="70" y="0" width="90" height="13" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CODIGO_SIIF}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="160" y="0" width="90" height="13" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="3">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_DOC}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="250" y="0" width="70" height="13" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{MEDIO_PAGO}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="820" y="0" width="80" height="13" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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.math.BigDecimal"><![CDATA[$F{VALOR_DED}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="740" y="0" width="80" height="13" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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.math.BigDecimal"><![CDATA[$F{VALOR_DEV}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="320" y="0" width="70" height="13" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TIPO_IDEN}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="390" y="0" width="100" height="13" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="3">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NIT_BN}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="0" y="0" width="70" height="13" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{RN}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="640" y="0" width="100" height="13" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TIPO_CUENTA_PAGAR}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="22" splitType="Stretch"/>
	</columnFooter>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="980" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
