<?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_subreport2" language="groovy" pageWidth="1830" pageHeight="572" orientation="Landscape" columnWidth="1830" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
	<property name="ireport.zoom" value="2.5937424601000085"/>
	<property name="ireport.x" value="2813"/>
	<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>
	<queryString>
		<![CDATA[select * from (

select

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

nvl( debcre.observaciones_credet, debcre.observaciones) as obs,
debcre.*,
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 = 1

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

order by
tab0.num_doc,
tab0.sec_debito,
tab0.sec_credito]]>
	</queryString>
	<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_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{VRADICION}  + $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{EXCEDENTE2} - $F{EXCEDENTE3} - $F{DEVOL_EXCE}
)]]></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{EXCEDENTE2} - $F{EXCEDENTE3} - $F{DEVOL_EXCE}
)]]></variableExpression>
	</variable>
	<variable name="variable1" class="java.math.BigDecimal" incrementType="Report" calculation="Sum">
		<variableExpression><![CDATA[$F{ID_DEBITO}]]></variableExpression>
		<initialValueExpression><![CDATA[0]]></initialValueExpression>
	</variable>
	<group name="Debito">
		<groupExpression><![CDATA[$F{ID_DEBITO}]]></groupExpression>
		<groupHeader>
			<band height="10" splitType="Prevent">
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="110" y="0" width="104" height="10"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="6"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOC}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement stretchType="RelativeToTallestObject" x="214" y="0" width="20" height="10"/>
					<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{DESC_CORTA}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(-#,##0.00)">
					<reportElement stretchType="RelativeToTallestObject" x="632" y="0" width="60" height="10"/>
					<box rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="6"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{SALDO_ACTUAL}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement stretchType="RelativeToTallestObject" x="234" y="0" width="35" height="10"/>
					<box rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="6"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{SEC_DEBITO}]]></textFieldExpression>
				</textField>
				<textField pattern="dd/MM/yyyy">
					<reportElement stretchType="RelativeToTallestObject" x="489" y="0" width="40" height="10"/>
					<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="dd/MM/yyyy">
					<reportElement stretchType="RelativeToTallestObject" x="529" y="0" width="43" height="10"/>
					<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_VENCE}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(#,##0.00)">
					<reportElement stretchType="RelativeToTallestObject" x="572" y="0" width="60" height="10"/>
					<box rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="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"/>
					<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="1457" y="0" width="223" height="10" printWhenGroupChanges="Debito"/>
					<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="692" y="0" width="765" height="10"/>
					<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 isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="60" y="0" width="50" height="10"/>
					<box rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="6"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_DOC}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="269" y="0" width="90" height="10" printWhenGroupChanges="Debito"/>
					<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="419" y="0" width="30" height="10"/>
					<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 pattern="dd/MM/yyyy" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="449" y="0" width="40" height="10"/>
					<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_ANU}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="1680" y="0" width="150" height="10" printWhenGroupChanges="Debito"/>
					<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{MOTIVO_ANU}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="359" y="0" width="60" height="10"/>
					<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["Intereses Aut."]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="26">
				<line>
					<reportElement x="0" y="17" width="1830" height="1"/>
					<graphicElement>
						<pen lineStyle="Dotted"/>
					</graphicElement>
				</line>
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement x="1097" 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="1037" 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="572" 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="572" 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="632" 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="692" y="0" width="345" 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="1457" y="0" width="373" 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="1157" 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="1397" 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="1277" 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="1337" 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 x="1217" 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[]]></textFieldExpression>
				</textField>
			</band>
		</groupFooter>
	</group>
	<columnHeader>
		<band height="42" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="110" y="11" width="104" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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="214" y="11" width="20" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Tipo
Deb]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="692" y="11" width="35" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Nota Crédito]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="234" y="11" width="35" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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="489" y="11" width="40" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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="529" y="11" width="43" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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 Vencimiento]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="572" y="11" width="60" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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
Documento]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="727" y="11" width="40" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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="1037" y="11" width="60" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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="1097" y="11" width="60" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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="877" y="11" width="30" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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="11" width="60" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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="632" y="11" width="60" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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="1157" y="11" width="60" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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 para Aplicar]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1457" y="11" width="223" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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="1277" y="11" width="60" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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 Aplicado]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1397" y="11" width="60" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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 Disponible]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1337" y="11" width="60" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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 Reint/Ajustado]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="60" y="11" width="50" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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="269" y="11" width="90" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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="957" y="11" width="80" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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 Credito]]></text>
			</staticText>
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="true">
				<reportElement isPrintRepeatedValues="false" x="0" y="0" width="1770" height="11" printWhenGroupChanges="Debito">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></printWhenExpression>
				</reportElement>
				<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["ND GENERADAS POR INTERESES AUTOMATICOS"]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="767" y="11" width="60" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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="827" y="11" width="50" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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="449" y="11" width="40" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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
Anulación]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="419" y="11" width="30" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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="1680" y="11" width="150" 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[Motivo Anulación]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="907" y="11" width="50" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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
Anulación]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="359" y="11" width="60" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Tipo Ingreso]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1217" y="11" width="60" height="31" forecolor="#000000" backcolor="#A4CFF6">
					<printWhenExpression><![CDATA[$V{variable1} == 0]]></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" 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 - POR DEPURAR]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="10" splitType="Stretch">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1457" y="0" width="223" height="10">
					<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="692" 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="727" 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="1037" 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="1097" 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="877" 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="692" height="10" 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="1157" 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{VRADICION}+$F{EXCEDENTE2}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1397" y="0" width="60" height="10" 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{EXCEDENTE2} - $F{EXCEDENTE3} - $F{DEVOL_EXCE}
)]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1277" 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="1337" y="0" width="60" height="10" 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="827" 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 isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="767" 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.lang.String"><![CDATA[$F{NUM_DOC_CRE}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1680" y="0" width="150" height="10" printWhenGroupChanges="Debito">
					<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{MOTIVO_ANU_CRE}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="957" y="0" width="80" height="10" isRemoveLineWhenBlank="true" printWhenGroupChanges="Debito"/>
				<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_CONCRE}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="907" y="0" width="50" height="10">
					<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_ANU_CRE}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1217" 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[]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<summary>
		<band height="12" splitType="Stretch">
			<textField pattern="" isBlankWhenNull="true">
				<reportElement isPrintRepeatedValues="false" x="692" y="0" width="345" 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="" isBlankWhenNull="true">
				<reportElement isPrintRepeatedValues="false" x="1457" y="0" width="373" 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)">
				<reportElement x="632" 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)">
				<reportElement x="572" 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>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement x="1037" 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="1097" 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="1277" 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="1397" 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="1157" 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>
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="572" 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="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="1337" 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="" isBlankWhenNull="true">
				<reportElement isPrintRepeatedValues="false" x="1217" 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>
		</band>
	</summary>
</jasperReport>
