<?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_general_titmin" language="groovy" pageWidth="1420" pageHeight="612" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="1380" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.9487171000000096"/>
	<property name="ireport.x" value="538"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/cartera/inf_general_titmin"/>
	<property name="ireport.jasperserver.url" value="http://192.168.2.43:8090/jasperserver/services/repository"/>
	<parameter name="per_fin" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[10]]></defaultValueExpression>
	</parameter>
	<parameter name="vig_fin" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[1000]]></defaultValueExpression>
	</parameter>
	<parameter name="fecha_fin" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTercero" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="fecha_ini" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTipoDebito" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereDebito" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="NomPuntoVenta" class="java.lang.String"/>
	<parameter name="whereTitulo" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="aplica_intereses" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_referencia2" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select tab0.* from (

    select
    0 as tag_nulo,
    tab0.*
    from (

        select

        prod.descripcion as descripcion_prod,
        concre.descripcion as descripcion_concre,

        nvl( debcre.observaciones_credet, debcre.observaciones) as obs,
        debcre.id_debito,
        debcre.id_anhos,
        debcre.id_punto_venta,
        debcre.id_tipo_debito,
        debcre.sec_debito,
        debcre.id_mae_ter,
        debcre.fecha_proceso,
        debcre.dias_pago,
        debcre.valor_bruto,
        debcre.valor_iva,
        debcre.valor_dcto,
        debcre.valor_total,
        debcre.id_mae_ter_ven,
        debcre.observaciones,
        debcre.id_tip_mon,
        debcre.valor_moneda,
        debcre.trm_debito,
        debcre.estado,
        debcre.fecha_anu,
        debcre.motivo_anu,
        debcre.periodo_ini,
        debcre.periodo_fin,
        debcre.usuariolog,
        debcre.id_pr_tipo_ingre,
        debcre.id_vencimiento,
        debcre.valor,
        debcre.fecha_vence,
        debcre.estado_ven,
        debcre.fecha_anu_ven,
        debcre.cancelado,
        debcre.id_credito_detalle,
        debcre.valor_bruto_credet,
        debcre.valor_retenciones,
        debcre.valor_abono,
        debcre.id_tip_mon_credet,
        debcre.valor_total_moneda,
        debcre.trm_credito,
        debcre.diferencia_cambio,
        debcre.observaciones_credet,
        debcre.id_credito,
        debcre.fecha_proceso_cre,
        debcre.sec_credito,
        debcre.id_tipo_credito,
        debcre.id_con_credito,
        debcre.fecha_cre,
        debcre.num_doc_cre,
        debcre.valor_cre,
        debcre.estado_cre,
        debcre.fecha_anu_cre,
        debcre.id_mae_ter_cre,
        debcre.motivo_anu_cre,
        debcre.vradicion,
        debcre.excedente,
        debcre.en_uso,
        debcre.excedente_en_uso,
        case when debcre.fecha_anu_cre<=to_date($P{fecha_fin}, 'dd/mm/yyyy') then 0 else 1 END AS ESTADO2,
        nvl( sal.saldo_anterior , 0 ) as saldo_anterior,
        nvl( sal.debitos_mes , 0 ) as debitos_mes,
        nvl( sal.creditos_mes , 0 ) as creditos_mes,
        nvl( sal.saldo_actual , 0 ) as saldo_actual,
        ter.num_doc,
        ter.razon_soc,
        tipdeb.desc_corta,
        debref.id_referencia1,
        debref.id_referencia2,
        case when debcre.id_credito_detalle = (select min(cred.id_credito_detalle) from ca_credito_detalle cred where cred.id_credito = debcre.id_credito) then nvl(debcre.EXCEDENTE,0) else 0 end AS EXCEDENTE2,
        case when debcre.id_credito_detalle = (select min(cred.id_credito_detalle) from ca_credito_detalle cred where cred.id_credito = debcre.id_credito) and debcre.en_uso = 0  and debcre.estado_cre = 1 then nvl(debcre.EXCEDENTE,0) else 0 end AS EXCEDENTE_saldo,

        case when debcre.id_credito_detalle = (select min(cred.id_credito_detalle) from ca_credito_detalle cred where cred.id_credito = debcre.id_credito) then

          --case when debcre.id_credito = (select exce.id_credito_aplicado from ca_excedentes exce where exce.id_credito_aplicado =  debcre.id_credito)
        --ACTUALIZACION 20170202
        case when debcre.id_credito = (select exce.id_credito from ca_excedentes exce where exce.id_credito =  debcre.id_credito and exce.en_uso = 1 and rownum = 1)

          then (select sum(exce.valor) from ca_excedentes exce where exce.id_credito =  debcre.id_credito and exce.en_uso = 1  and exce.id_credito_aplicado is not null) else 0 end
        --

        else 0 end AS EXCEDENTE3,
        nvl(novexce.valor,0) AS DEVOL_EXCE

        from ca_debito_credito debcre

        left join(

        select tab0.id_credito, nvl(sum(tab0.valor),0) valor
        from ca_excedentes tab0
        where tab0.id_nov_devol_exced is not null and tab0.en_uso = 1
        group by tab0.id_credito

        )novexce ON novexce.id_credito = debcre.id_credito
        left join  ca_saldos sal
        on sal.id_debito = debcre.id_debito
        and sal.id_vencimiento = debcre.id_vencimiento
        and sal.id_anhos = $P{vig_fin}
        and sal.id_meses = $P{per_fin}

        join interceros_v ter
        on ter.id_mae_ter = debcre.id_mae_ter

        join ca_tipo_debito tipdeb
        on tipdeb.id_tipo_debito = debcre.id_tipo_debito

        left join ca_debito_ref debref
        on debref.id_debito = debcre.id_debito

        left join ca_con_credito concre
        on debcre.id_con_credito = concre.id_con_credito

        left join (
          SELECT
           aut.*,
           ROW_NUMBER() OVER (
            partition by aut.id_debito
            ORDER BY aut.id_debito DESC
           ) AS rn
          from ca_debito_detalle aut
        )debdet
        on debdet.id_debito = debcre.id_debito
        and debdet.rn = 1

        left join ca_producto prod
        on prod.id_producto = debdet.id_producto

        where
        debcre.fecha_proceso BETWEEN TO_DATE( $P{fecha_ini} ,'DD/MM/YYYY') AND TO_DATE( $P{fecha_fin} ,'DD/MM/YYYY')
        and Prod.Aplica_Intereses = 0

    )tab0
    where
    1 = 1
    $P!{whereTercero}
    $P!{whereDebito}
    $P!{whereTipoDebito}
    $P!{whereTitulo}

      union

      select
      1 as tag_nulo,
      null as descripcion_prod,
      null as descripcion_concre,
      null as obs,
      null as ID_DEBITO,
      null as ID_ANHOS,
      null as ID_PUNTO_VENTA,
      null as ID_TIPO_DEBITO,
      null as SEC_DEBITO,
      null as ID_MAE_TER,
      null as FECHA_PROCESO,
      null as DIAS_PAGO,
      null as VALOR_BRUTO,
      null as VALOR_IVA,
      null as VALOR_DCTO,
      null as VALOR_TOTAL,
      null as ID_MAE_TER_VEN,
      null as OBSERVACIONES,
      null as ID_TIP_MON,
      null as VALOR_MONEDA,
      null as TRM_DEBITO,
      null as ESTADO,
      null as FECHA_ANU,
      null as MOTIVO_ANU,
      null as PERIODO_INI,
      null as PERIODO_FIN,
      null as USUARIOLOG,
      null as id_pr_tipo_ingre,
      null as ID_VENCIMIENTO,
      null as VALOR,
      null as FECHA_VENCE,
      null as ESTADO_VEN,
      null as FECHA_ANU_VEN,
      null as CANCELADO,
      null as ID_CREDITO_DETALLE,
      null as VALOR_BRUTO_CREDET,
      null as VALOR_RETENCIONES,
      null as VALOR_ABONO,
      null as ID_TIP_MON_CREDET,
      null as VALOR_TOTAL_MONEDA,
      null as TRM_CREDITO,
      null as DIFERENCIA_CAMBIO,
      null as OBSERVACIONES_CREDET,
      null as ID_CREDITO,
      null as FECHA_PROCESO_CRE,
      null as SEC_CREDITO,
      null as ID_TIPO_CREDITO,
      null as ID_CON_CREDITO,
      null as FECHA_CRE,
      null as NUM_DOC_CRE,
      null as VALOR_CRE,
      null as ESTADO_CRE,
      null as FECHA_ANU_CRE,
      null as ID_MAE_TER_CRE,
      null as motivo_anu_cre,
      null as VRADICION,
      null as EXCEDENTE,
      null as EN_USO,
      null as EXCEDENTE_EN_USO,
      null as ESTADO2,
      null as saldo_anterior,
      null as debitos_mes,
      null as creditos_mes,
      null as saldo_actual,
      null as num_doc,
      null as razon_soc,
      null as desc_corta,
      null as id_referencia1,
      null as id_referencia2,
      null as EXCEDENTE2,
      null as EXCEDENTE_saldo,
      null as EXCEDENTE3,
      null as DEVOL_EXCE

      from dual

)tab0

order by
tab0.num_doc,
tab0.sec_debito,
tab0.sec_credito]]>
	</queryString>
	<field name="TAG_NULO" class="java.math.BigDecimal"/>
	<field name="DESCRIPCION_PROD" class="java.lang.String"/>
	<field name="DESCRIPCION_CONCRE" class="java.lang.String"/>
	<field name="OBS" class="java.lang.String"/>
	<field name="ID_DEBITO" class="java.math.BigDecimal"/>
	<field name="ID_ANHOS" class="java.math.BigDecimal"/>
	<field name="ID_PUNTO_VENTA" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_DEBITO" class="java.math.BigDecimal"/>
	<field name="SEC_DEBITO" class="java.math.BigDecimal"/>
	<field name="ID_MAE_TER" class="java.math.BigDecimal"/>
	<field name="FECHA_PROCESO" class="java.sql.Timestamp"/>
	<field name="DIAS_PAGO" class="java.math.BigDecimal"/>
	<field name="VALOR_BRUTO" class="java.math.BigDecimal"/>
	<field name="VALOR_IVA" class="java.math.BigDecimal"/>
	<field name="VALOR_DCTO" class="java.math.BigDecimal"/>
	<field name="VALOR_TOTAL" class="java.math.BigDecimal"/>
	<field name="ID_MAE_TER_VEN" class="java.math.BigDecimal"/>
	<field name="OBSERVACIONES" class="java.lang.String"/>
	<field name="ID_TIP_MON" class="java.math.BigDecimal"/>
	<field name="VALOR_MONEDA" class="java.math.BigDecimal"/>
	<field name="TRM_DEBITO" class="java.math.BigDecimal"/>
	<field name="ESTADO" class="java.math.BigDecimal"/>
	<field name="FECHA_ANU" class="java.sql.Timestamp"/>
	<field name="MOTIVO_ANU" class="java.lang.String"/>
	<field name="PERIODO_INI" class="java.sql.Timestamp"/>
	<field name="PERIODO_FIN" class="java.sql.Timestamp"/>
	<field name="USUARIOLOG" class="java.lang.String"/>
	<field name="ID_PR_TIPO_INGRE" class="java.math.BigDecimal"/>
	<field name="ID_VENCIMIENTO" class="java.math.BigDecimal"/>
	<field name="VALOR" class="java.math.BigDecimal"/>
	<field name="FECHA_VENCE" class="java.sql.Timestamp"/>
	<field name="ESTADO_VEN" class="java.math.BigDecimal"/>
	<field name="FECHA_ANU_VEN" class="java.sql.Timestamp"/>
	<field name="CANCELADO" class="java.math.BigDecimal"/>
	<field name="ID_CREDITO_DETALLE" class="java.math.BigDecimal"/>
	<field name="VALOR_BRUTO_CREDET" class="java.math.BigDecimal"/>
	<field name="VALOR_RETENCIONES" class="java.math.BigDecimal"/>
	<field name="VALOR_ABONO" class="java.math.BigDecimal"/>
	<field name="ID_TIP_MON_CREDET" class="java.math.BigDecimal"/>
	<field name="VALOR_TOTAL_MONEDA" class="java.math.BigDecimal"/>
	<field name="TRM_CREDITO" class="java.math.BigDecimal"/>
	<field name="DIFERENCIA_CAMBIO" class="java.math.BigDecimal"/>
	<field name="OBSERVACIONES_CREDET" class="java.lang.String"/>
	<field name="ID_CREDITO" class="java.math.BigDecimal"/>
	<field name="FECHA_PROCESO_CRE" class="java.sql.Timestamp"/>
	<field name="SEC_CREDITO" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_CREDITO" class="java.math.BigDecimal"/>
	<field name="ID_CON_CREDITO" class="java.math.BigDecimal"/>
	<field name="FECHA_CRE" class="java.sql.Timestamp"/>
	<field name="NUM_DOC_CRE" class="java.math.BigDecimal"/>
	<field name="VALOR_CRE" class="java.math.BigDecimal"/>
	<field name="ESTADO_CRE" class="java.math.BigDecimal"/>
	<field name="FECHA_ANU_CRE" class="java.sql.Timestamp"/>
	<field name="ID_MAE_TER_CRE" class="java.math.BigDecimal"/>
	<field name="MOTIVO_ANU_CRE" class="java.lang.String"/>
	<field name="VRADICION" class="java.math.BigDecimal"/>
	<field name="EXCEDENTE" class="java.math.BigDecimal"/>
	<field name="EN_USO" class="java.math.BigDecimal"/>
	<field name="EXCEDENTE_EN_USO" class="java.math.BigDecimal"/>
	<field name="ESTADO2" class="java.math.BigDecimal"/>
	<field name="SALDO_ANTERIOR" class="java.math.BigDecimal"/>
	<field name="DEBITOS_MES" class="java.math.BigDecimal"/>
	<field name="CREDITOS_MES" class="java.math.BigDecimal"/>
	<field name="SALDO_ACTUAL" class="java.math.BigDecimal"/>
	<field name="NUM_DOC" class="java.lang.String"/>
	<field name="RAZON_SOC" class="java.lang.String"/>
	<field name="DESC_CORTA" class="java.lang.String"/>
	<field name="ID_REFERENCIA1" class="java.math.BigDecimal"/>
	<field name="ID_REFERENCIA2" class="java.lang.String"/>
	<field name="EXCEDENTE2" class="java.math.BigDecimal"/>
	<field name="EXCEDENTE_SALDO" class="java.math.BigDecimal"/>
	<field name="EXCEDENTE3" class="java.math.BigDecimal"/>
	<field name="DEVOL_EXCE" class="java.math.BigDecimal"/>
	<variable name="sum_valor_cre" class="java.math.BigDecimal" resetType="Group" resetGroup="Debito" calculation="Sum">
		<variableExpression><![CDATA[($F{ESTADO2}==0 ? 0 : $F{VALOR_ABONO} + $F{DIFERENCIA_CAMBIO} + $F{VRADICION} + $F{EXCEDENTE2} )]]></variableExpression>
		<initialValueExpression><![CDATA[0]]></initialValueExpression>
	</variable>
	<variable name="sum_valor_abono" class="java.math.BigDecimal" resetType="Group" resetGroup="Debito" calculation="Sum">
		<variableExpression><![CDATA[($F{ESTADO2}==0 ? 0 : $F{VALOR_ABONO} )]]></variableExpression>
		<initialValueExpression><![CDATA[0]]></initialValueExpression>
	</variable>
	<variable name="total_valor_cre" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[($F{ESTADO2}==0 ? 0 : $F{VALOR_ABONO} + $F{DIFERENCIA_CAMBIO} + $F{VRADICION} + $F{EXCEDENTE2} )]]></variableExpression>
		<initialValueExpression><![CDATA[0]]></initialValueExpression>
	</variable>
	<variable name="total_valor_abono" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[($F{ESTADO2}==0
    ? 0
    : $F{VALOR_ABONO}
)]]></variableExpression>
		<initialValueExpression><![CDATA[0]]></initialValueExpression>
	</variable>
	<variable name="total_valor_total" class="java.math.BigDecimal" incrementType="Group" incrementGroup="Debito" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_TOTAL}]]></variableExpression>
		<initialValueExpression><![CDATA[0]]></initialValueExpression>
	</variable>
	<variable name="total_saldo_actual" class="java.math.BigDecimal" incrementType="Group" incrementGroup="Debito" calculation="Sum">
		<variableExpression><![CDATA[$F{SALDO_ACTUAL}]]></variableExpression>
		<initialValueExpression><![CDATA[0]]></initialValueExpression>
	</variable>
	<variable name="sum_diferencia" class="java.math.BigDecimal" resetType="Group" resetGroup="Debito" calculation="Sum">
		<variableExpression><![CDATA[( $F{ESTADO2}==0
    ? 0
    : $F{DIFERENCIA_CAMBIO} + $F{EXCEDENTE2}
)]]></variableExpression>
		<initialValueExpression><![CDATA[0]]></initialValueExpression>
	</variable>
	<variable name="total_diferencia" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[($F{ESTADO2}==0
    ? 0
    : $F{DIFERENCIA_CAMBIO} + $F{VRADICION} + $F{EXCEDENTE2}
)]]></variableExpression>
		<initialValueExpression><![CDATA[0]]></initialValueExpression>
	</variable>
	<variable name="suma_aplica" class="java.math.BigDecimal" resetType="Group" resetGroup="Debito" calculation="Sum">
		<variableExpression><![CDATA[( $F{ESTADO2}==0
    ? 0
    : $F{EXCEDENTE3}
)]]></variableExpression>
	</variable>
	<variable name="total_aplica" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{EXCEDENTE3}]]></variableExpression>
	</variable>
	<variable name="saldo_excede" class="java.math.BigDecimal">
		<variableExpression><![CDATA[$V{total_diferencia}-$V{total_aplica}]]></variableExpression>
	</variable>
	<variable name="suma_excedente" class="java.math.BigDecimal" resetType="Group" resetGroup="Debito" calculation="Sum">
		<variableExpression><![CDATA[($F{ESTADO2}==0
    ? 0
    : $F{DIFERENCIA_CAMBIO} + $F{VRADICION}+$F{EXCEDENTE2}-$F{DEVOL_EXCE}-$F{EXCEDENTE3}
)]]></variableExpression>
	</variable>
	<variable name="suma_devolucion" class="java.math.BigDecimal" resetType="Group" resetGroup="Debito" calculation="Sum">
		<variableExpression><![CDATA[( $F{ESTADO2}==0
    ? 0
    : $F{DEVOL_EXCE}
)]]></variableExpression>
	</variable>
	<variable name="total_excedente" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[($F{ESTADO2}==0
    ? 0
    : $F{DIFERENCIA_CAMBIO} + $F{VRADICION}+$F{EXCEDENTE2}-$F{DEVOL_EXCE}-$F{EXCEDENTE3}
)]]></variableExpression>
	</variable>
	<variable name="sum_diferencia_migra" class="java.math.BigDecimal" resetType="Group" resetGroup="Debito" calculation="Sum">
		<variableExpression><![CDATA[( $F{ESTADO2}==0
    ? 0
    : $F{VRADICION}
)]]></variableExpression>
		<initialValueExpression><![CDATA[0]]></initialValueExpression>
	</variable>
	<group name="Debito">
		<groupExpression><![CDATA[$F{ID_DEBITO}]]></groupExpression>
		<groupHeader>
			<band height="10" splitType="Prevent">
				<textField pattern="#,##0.00;(-#,##0.00)">
					<reportElement stretchType="RelativeToTallestObject" x="465" y="0" width="60" height="10">
						<printWhenExpression><![CDATA[$F{TAG_NULO} != 1]]></printWhenExpression>
					</reportElement>
					<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="6"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{SALDO_ACTUAL}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement stretchType="RelativeToTallestObject" x="210" y="0" width="35" height="10">
						<printWhenExpression><![CDATA[$F{TAG_NULO} != 1]]></printWhenExpression>
					</reportElement>
					<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="6"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{SEC_DEBITO}]]></textFieldExpression>
				</textField>
				<textField pattern="dd/MM/yyyy">
					<reportElement stretchType="RelativeToTallestObject" x="365" y="0" width="40" height="10">
						<printWhenExpression><![CDATA[$F{TAG_NULO} != 1]]></printWhenExpression>
					</reportElement>
					<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="6"/>
					</textElement>
					<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_PROCESO}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(#,##0.00)">
					<reportElement stretchType="RelativeToTallestObject" x="405" y="0" width="60" height="10">
						<printWhenExpression><![CDATA[$F{TAG_NULO} != 1]]></printWhenExpression>
					</reportElement>
					<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="6"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_TOTAL}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="60" height="10">
						<printWhenExpression><![CDATA[$F{TAG_NULO} != 1]]></printWhenExpression>
					</reportElement>
					<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="6"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{ID_REFERENCIA2}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="1150" y="0" width="230" height="10" printWhenGroupChanges="Debito">
						<printWhenExpression><![CDATA[$F{TAG_NULO} != 1]]></printWhenExpression>
					</reportElement>
					<box leftPadding="3">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="6"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{OBSERVACIONES}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement stretchType="RelativeToTallestObject" x="525" y="0" width="625" height="10">
						<printWhenExpression><![CDATA[$F{TAG_NULO} != 1]]></printWhenExpression>
					</reportElement>
					<box>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement/>
					<text><![CDATA[Static text]]></text>
				</staticText>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="245" y="0" width="90" height="10" printWhenGroupChanges="Debito">
						<printWhenExpression><![CDATA[$F{TAG_NULO} != 1]]></printWhenExpression>
					</reportElement>
					<box leftPadding="3">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="6"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{DESCRIPCION_PROD}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="335" y="0" width="30" height="10" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[$F{TAG_NULO} != 1]]></printWhenExpression>
					</reportElement>
					<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="6"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[($F{ESTADO}==0 ? "Anulado" : "Activo" )]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="60" y="0" width="50" height="10">
						<printWhenExpression><![CDATA[$F{TAG_NULO} != 1]]></printWhenExpression>
					</reportElement>
					<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="6"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_DOC}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="110" y="0" width="100" height="10">
						<printWhenExpression><![CDATA[$F{TAG_NULO} != 1]]></printWhenExpression>
					</reportElement>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="6"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOC}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="26">
				<line>
					<reportElement x="0" y="17" width="1380" height="1"/>
					<graphicElement>
						<pen lineStyle="Dotted"/>
					</graphicElement>
				</line>
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement x="790" y="0" width="60" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
					</reportElement>
					<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="6" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{sum_valor_abono}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement x="730" y="0" width="60" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
					</reportElement>
					<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="6" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{sum_valor_cre}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="405" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#D2D0D0">
						<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
					</reportElement>
					<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" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Subtotales: ]]></text>
				</staticText>
				<textField pattern="#,##0.00;(#,##0.00)">
					<reportElement x="405" y="0" width="60" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
					</reportElement>
					<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="6" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_TOTAL}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(-#,##0.00)">
					<reportElement x="465" y="0" width="60" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
					</reportElement>
					<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="6" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{SALDO_ACTUAL}]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="true">
					<reportElement isPrintRepeatedValues="false" x="525" y="0" width="205" height="12" printWhenGroupChanges="Debito">
						<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
					</reportElement>
					<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="Center" verticalAlignment="Middle">
						<font size="6"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="true">
					<reportElement isPrintRepeatedValues="false" x="1150" y="0" width="230" height="12" printWhenGroupChanges="Debito">
						<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
					</reportElement>
					<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="Center" verticalAlignment="Middle">
						<font size="6"/>
					</textElement>
				</textField>
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement x="850" y="0" width="60" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
					</reportElement>
					<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="6" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{sum_diferencia}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement isPrintRepeatedValues="false" mode="Transparent" x="1090" y="0" width="60" height="12" printWhenGroupChanges="Debito" forecolor="#000000" backcolor="#FFFFFF">
						<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
					</reportElement>
					<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="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_excedente}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement mode="Transparent" x="970" y="0" width="60" height="12" forecolor="#000000" backcolor="#FFFFFF">
						<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
					</reportElement>
					<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="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_aplica}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement mode="Transparent" x="1030" y="0" width="60" height="12" printWhenGroupChanges="Debito" forecolor="#000000" backcolor="#FFFFFF">
						<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
					</reportElement>
					<box>
						<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="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_devolucion}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement mode="Transparent" x="910" y="0" width="60" height="12" forecolor="#000000" backcolor="#FFFFFF">
						<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
					</reportElement>
					<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="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{sum_diferencia_migra}]]></textFieldExpression>
				</textField>
			</band>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="119" splitType="Stretch">
			<staticText>
				<reportElement x="335" y="10" width="695" height="40"/>
				<textElement textAlignment="Center" verticalAlignment="Bottom" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Sistema de Cartera y Facturación
Estado General de Cuenta por Titulo Minero]]></text>
			</staticText>
			<image>
				<reportElement x="0" y="10" width="154" height="40"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
			<staticText>
				<reportElement mode="Opaque" x="1090" y="26" width="290" 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="335" y="50" width="695" 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>
			<textField pattern="dd/MM/yyyy  hh:mm aaa">
				<reportElement x="1090" y="38" width="290" height="12"/>
				<box rightPadding="3"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="0" y="72" width="110" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2"/>
				<textElement 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[Filtro de Presentar ND:]]></text>
			</staticText>
			<textField pattern="dd-MMM-yyyy   hh:mm aaa" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="110" y="72" width="1060" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2"/>
				<textElement 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.lang.String"><![CDATA[( $P{aplica_intereses} == 1
    ? "Con intereses automaticos"
    : "Sin intereses automaticos"
)]]></textFieldExpression>
			</textField>
			<textField pattern="dd-MMM-yyyy   hh:mm aaa" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="110" y="84" width="1210" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#FFFFFF">
					<printWhenExpression><![CDATA[$P{whereTercero}.length() > 1]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2"/>
				<textElement 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.lang.String"><![CDATA[$F{NUM_DOC} + " - " + $F{RAZON_SOC}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="0" y="84" width="110" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#FFFFFF">
					<printWhenExpression><![CDATA[$P{whereTercero}.length() > 1]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2"/>
				<textElement 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[Filtro de Beneficiario:]]></text>
			</staticText>
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="true">
				<reportElement isPrintRepeatedValues="false" x="0" y="108" width="1380" height="11" printWhenGroupChanges="Debito"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="6" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[""]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="0" y="96" width="110" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#FFFFFF">
					<printWhenExpression><![CDATA[$P{whereTitulo}.length() > 1]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2"/>
				<textElement 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[Filtro de Titulo:]]></text>
			</staticText>
			<textField pattern="dd-MMM-yyyy   hh:mm aaa" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="110" y="96" width="1060" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#FFFFFF">
					<printWhenExpression><![CDATA[$P{whereTitulo}.length() > 1]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2"/>
				<textElement 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.lang.String"><![CDATA[$P{id_referencia2}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="12" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="31" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="525" y="0" width="35" height="31" forecolor="#000000" backcolor="#A4CFF6"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Secuencia Crédito]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="210" y="0" width="35" height="31" forecolor="#000000" backcolor="#A4CFF6"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Secuencia
Débito]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="365" y="0" width="40" height="31" forecolor="#000000" backcolor="#A4CFF6"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Fecha
Proceso]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="405" y="0" width="60" height="31" forecolor="#000000" backcolor="#A4CFF6"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Valor
Nota Débito]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="560" y="0" width="40" height="31" forecolor="#000000" backcolor="#A4CFF6"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Fecha
Crédito]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="730" y="0" width="60" height="31" forecolor="#000000" backcolor="#A4CFF6"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Valor Recibido]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="790" y="0" width="60" height="31" forecolor="#000000" backcolor="#A4CFF6"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Valor Abono]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="700" y="0" width="30" height="31" forecolor="#000000" backcolor="#A4CFF6"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Estado]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="60" height="31" forecolor="#000000" backcolor="#A4CFF6"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Titulo]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="465" y="0" width="60" height="31" forecolor="#000000" backcolor="#A4CFF6"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Saldo]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="850" y="0" width="60" height="31" forecolor="#000000" backcolor="#A4CFF6"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Dif. Cambio / Excedente]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1150" y="0" width="230" height="31" forecolor="#000000" backcolor="#A4CFF6"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Observaciones]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="970" y="0" width="60" height="31" forecolor="#000000" backcolor="#A4CFF6"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Aplica Excedente]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1090" y="0" width="60" height="31" forecolor="#000000" backcolor="#A4CFF6"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Saldo a favor]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1030" y="0" width="60" height="31" forecolor="#000000" backcolor="#A4CFF6"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Devolucion Excedente]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="245" y="0" width="90" height="31" forecolor="#000000" backcolor="#A4CFF6"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Concepto Debito]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="335" y="0" width="30" height="31" forecolor="#000000" backcolor="#A4CFF6"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Estado]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="600" y="0" width="50" height="31" forecolor="#000000" backcolor="#A4CFF6"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Número
Consignación]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="650" y="0" width="50" height="31" forecolor="#000000" backcolor="#A4CFF6"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Fecha
Consignación]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="110" y="0" width="100" height="31" forecolor="#000000" backcolor="#A4CFF6"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Titular]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="60" y="0" width="50" height="31" forecolor="#000000" backcolor="#A4CFF6"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Documento]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="910" y="0" width="60" height="31" forecolor="#000000" backcolor="#A4CFF6"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Excedente SGC]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="10" splitType="Prevent">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1150" y="0" width="230" height="10" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
				</reportElement>
				<box leftPadding="3">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{OBS}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="525" y="0" width="35" height="10" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
				</reportElement>
				<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="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{SEC_CREDITO}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="560" y="0" width="40" height="10" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
				</reportElement>
				<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="6"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_PROCESO_CRE}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="730" y="0" width="60" height="10" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
				</reportElement>
				<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="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_ABONO} + $F{DIFERENCIA_CAMBIO} + $F{VRADICION} + $F{EXCEDENTE2}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="790" y="0" width="60" height="10" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
				</reportElement>
				<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="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_ABONO}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="700" y="0" width="30" height="10" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
				</reportElement>
				<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="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[($F{ESTADO2}==0 ? "Anulado" : "Activo" )]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="525" height="10" isRemoveLineWhenBlank="true" printWhenGroupChanges="Debito">
					<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
				</reportElement>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="850" y="0" width="60" height="10" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
				</reportElement>
				<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="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{DIFERENCIA_CAMBIO} + $F{EXCEDENTE2}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1090" y="0" width="60" height="10" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#FFFFFF">
					<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
				</reportElement>
				<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{ESTADO2}==0
    ? 0
    : $F{DIFERENCIA_CAMBIO} + $F{VRADICION}+$F{EXCEDENTE2}-$F{DEVOL_EXCE}-$F{EXCEDENTE3}
)]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="970" y="0" width="60" height="10" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#FFFFFF">
					<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
				</reportElement>
				<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{EXCEDENTE3}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1030" y="0" width="60" height="10" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#FFFFFF">
					<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
				</reportElement>
				<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{DEVOL_EXCE}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="650" y="0" width="50" height="10" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
				</reportElement>
				<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="6"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_CRE}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="600" y="0" width="50" height="10" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
				</reportElement>
				<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="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_DOC_CRE}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="910" y="0" width="60" height="10" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{ID_CREDITO} != null]]></printWhenExpression>
				</reportElement>
				<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="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VRADICION}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<pageFooter>
		<band height="25" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="594" y="13" width="96" 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="691" y="13" width="58" 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="594" y="1" width="155" height="12" forecolor="#575757"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<text><![CDATA[Websafi - Cartera y Facturación]]></text>
			</staticText>
		</band>
	</pageFooter>
	<summary>
		<band height="75" splitType="Stretch">
			<textField pattern="" isBlankWhenNull="true">
				<reportElement isPrintRepeatedValues="false" x="525" y="0" width="205" height="12" printWhenGroupChanges="Debito"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement x="465" y="0" width="60" height="12"/>
				<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="6" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_saldo_actual}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement x="405" y="0" width="60" height="12"/>
				<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="6" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_valor_total}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="405" height="12" forecolor="#000000" backcolor="#B9B9B9"/>
				<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" 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>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement isPrintRepeatedValues="false" x="1150" y="0" width="230" height="12" printWhenGroupChanges="Debito"/>
				<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="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement x="730" y="0" width="60" height="12"/>
				<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="6" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_valor_cre}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement x="790" y="0" width="60" height="12"/>
				<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="6" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_valor_abono}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="970" y="0" width="60" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="1090" y="0" width="60" height="12" 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="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_excedente}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement isPrintRepeatedValues="false" x="850" y="0" width="60" height="12" printWhenGroupChanges="Debito"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="1030" y="0" width="60" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[]]></textFieldExpression>
			</textField>
			<subreport>
				<reportElement x="0" y="25" width="1380" height="50" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$P{aplica_intereses} == 1]]></printWhenExpression>
				</reportElement>
				<subreportParameter name="fecha_fin">
					<subreportParameterExpression><![CDATA[$P{fecha_fin}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="whereTipoDebito">
					<subreportParameterExpression><![CDATA[$P{whereTipoDebito}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="per_fin">
					<subreportParameterExpression><![CDATA[$P{per_fin}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="whereTercero">
					<subreportParameterExpression><![CDATA[$P{whereTercero}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="fecha_ini">
					<subreportParameterExpression><![CDATA[$P{fecha_ini}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="vig_fin">
					<subreportParameterExpression><![CDATA[$P{vig_fin}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="whereTitulo">
					<subreportParameterExpression><![CDATA[$P{whereTitulo}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="whereDebito">
					<subreportParameterExpression><![CDATA[$P{whereDebito}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression class="java.lang.String"><![CDATA["repo:estado_gen_cuenta_tit_min_canon_subreport2"]]></subreportExpression>
			</subreport>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="910" y="0" width="60" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[]]></textFieldExpression>
			</textField>
		</band>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="1380" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
