<?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="Libro_aux_ter_auxter_new" language="groovy" pageWidth="1000" pageHeight="612" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="960" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.7715610000000157"/>
	<property name="ireport.x" value="595"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/contab/Libro_aux_ter_auxter"/>
	<property name="ireport.jasperserver.url" value="http://192.168.2.43:8090/jasperserver/services/repository"/>
	<parameter name="whereClase" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="nom_periodo_ini" class="java.lang.String"/>
	<parameter name="vig_ini" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_grupo_cuenta" class="java.math.BigDecimal"/>
	<parameter name="whereAuxiliar" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTercero" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereCuenta" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="id_catalogo" class="java.math.BigDecimal"/>
	<parameter name="per_ini" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_cen_op" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="vigper_Ini" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="per_fin" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="vigper_Fin" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereCatalogo" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="nom_cen_op" class="java.lang.String"/>
	<parameter name="nom_periodo_fin" class="java.lang.String"/>
	<parameter name="whereGrupo" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="id_clase_cuenta" class="java.math.BigDecimal"/>
	<parameter name="id_cia" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_cuenta_mayor" class="java.math.BigDecimal"/>
	<parameter name="cuenta" class="java.lang.String"/>
	<parameter name="vig_fin" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["/home/acontreras/reports-dev/reports-dev_contab/Consultar Documentos/"]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT
nvl(sal.saldo_anterior,0) as saldo_anterior_ini,
nvl(salfin.saldo_anterior,0) as saldo_anterior_fin,
nvl(sal.saldo_actual,0) as saldo_actual_ini,
nvl(salfin.saldo_actual,0) as saldo_actual_fin,
lib.id_auxiliar_org,
lib.id_mae_ter_org,
nvl(case when lib.id_auxiliar_org is null and lib.id_mae_ter_org is null then sal.saldo_anterior
     when lib.id_auxiliar_org is not null and lib.id_mae_ter_org is null then salaux.saldo_anterior
     when lib.id_auxiliar_org is null and lib.id_mae_ter_org is not null then salter.saldo_anterior
     when lib.id_auxiliar_org is not null and lib.id_mae_ter_org is not null then salauxter.saldo_anterior
else 0 end,0) as saldo_anterior,

nvl(sal.saldo_anterior,0) as saldo_anterior_sin,
nvl(salaux.saldo_anterior,0) as saldo_anterior_aux,
nvl(salter.saldo_anterior,0) as saldo_anterior_ter,
nvl(salauxter.saldo_anterior,0) as saldo_anterior_auxter,

lib.*,

ter.NOMBRE AS NOMBRE_MAE,
ter.NITOCC AS NITOCC_MAE,
aux.COD_AUX AS COD_AUX,
aux.NOMBRE AS NOMBRE_AUX,

0 as SALDO_ANTERIOR2,
0 as SALDO_ACTUAL2,
0 as SALDO_ANTERIOR3,
0 as SALDO_ACTUAL3

FROM (

    SELECT
    /*+ ROWID(TC) ROWID(DOC) ROWID(TD) ROWID(CLA) ROWID(GRU) ROWID(CUE) ROWID(CAT) ROWID(PER) ROWID(CAD) ROWID(MOV) */ cad.FECHA_CAD AS FECHA_CAD,
    mov.ID_VIGENCIA || SUBSTR('00' || cad.ID_PERIODO_CONTABLE, -2, 2) AS VIG_PER,
    cad.ID_PERIODO_CONTABLE,
    per.NOM_PERIODO,
    mov.ID_VIGENCIA,
    mov.ID_MOV_CONT,
    mov.ID_DOCUMENTO,
    mov.ID_CAD,
    mov.ID_CEN_OP,
    mov.ID_CIA,
    mov.ID_CATALOGO,
    mov.ID_CUENTA_MAYOR,
    mov.ID_GRUPO_CUENTA,
    mov.ID_CLASE_CUENTA,
    mov.ID_MAE_TER as ID_MAE_TER_org,
    mov.ID_AUXILIAR as ID_AUXILIAR_org,
    NVL(mov.ID_MAE_TER, -1) as ID_MAE_TER,
    NVL(mov.ID_AUXILIAR, 0) as ID_AUXILIAR,
    mov.ID_MAE_TER || mov.ID_AUXILIAR as AUXTER,
    mov.ID_SUB_AUX,
    mov.ID_CENTRO_COSTO,
    mov.ID_SUB_CENTRO_COSTO,
    mov.DEBITO,
    mov.CREDITO,
    mov.VALOR_BASE,
    cla.DIGITO AS dig_cla,
    cla.NOMBRE AS nom_cla,
    gru.DIGITO AS dig_gru,
    gru.NOMBRE AS nom_gru,
    cue.DIGITOS AS dig_cue,
    cue.NOMBRE AS nom_cue,
    cat.DIGITOS AS dig_cat,
    cat.NOMBRE AS nom_cat,
    tc.NOM_CORTO,
    tc.NOM_TIPO_COMPROBANTE,
    td.NOMBRE as NOM_TD,
    doc.DESCR_MTO,
    doc.DOC_SOPORTE,
    cue.NATURALEZA,
    cla.DIGITO || gru.DIGITO || cue.DIGITOS || cat.DIGITOS as cuenta

    FROM
    CN_TIPO_COMPROBANTE tc,
    CN_DOCUMENTO doc,
    CN_TD td,
    CN_CLASE_CUENTA cla,
    CN_GRUPO_CUENTA gru,
    CN_CUENTA_MAYOR cue,
    CN_CATALOGO cat,
    CN_PERIODO_CONTABLE per,
    CN_CONTROL_CAD cad,
    CN_MOVIMIENTO_CONTABLE mov

    WHERE
    mov.ID_CIA = cat.ID_CIA + 0
    AND mov.ID_CLASE_CUENTA = cat.ID_CLASE_CUENTA
    AND mov.ID_GRUPO_CUENTA = cat.ID_GRUPO_CUENTA
    AND mov.ID_CUENTA_MAYOR = cat.ID_CUENTA_MAYOR
    AND mov.ID_CATALOGO = cat.ID_CATALOGO
    AND mov.ID_CIA = cue.ID_CIA + 0
    AND mov.ID_CLASE_CUENTA = cue.ID_CLASE_CUENTA
    AND mov.ID_GRUPO_CUENTA = cue.ID_GRUPO_CUENTA
    AND mov.ID_CUENTA_MAYOR = cue.ID_CUENTA_MAYOR
    AND mov.ID_CIA = gru.ID_CIA + 0
    AND mov.ID_CLASE_CUENTA = gru.ID_CLASE_CUENTA
    AND mov.ID_GRUPO_CUENTA = gru.ID_GRUPO_CUENTA
    AND mov.ID_CIA = cla.ID_CIA + 0
    AND mov.ID_CLASE_CUENTA = cla.ID_CLASE_CUENTA
    AND cad.ID_PERIODO_CONTABLE = per.ID_PERIODO_CONTABLE
    AND doc.ID_TD = td.ID_TD
    AND mov.ID_CIA = doc.ID_CIA + 0
    AND mov.ID_CAD = doc.ID_CAD
    AND mov.ID_DOCUMENTO = doc.ID_DOCUMENTO
    AND mov.ID_CEN_OP = doc.ID_CEN_OP
    AND mov.ID_VIGENCIA = doc.ID_VIGENCIA
    AND tc.ID_CIA = cad.ID_CIA
    AND tc.ID_TIPO_COMPROBANTE = cad.ID_TIPO_COMPROBANTE + 0
    AND mov.ID_CAD = cad.ID_CAD
    AND mov.ID_VIGENCIA = cad.ID_VIGENCIA
    AND mov.ID_CEN_OP = cad.ID_CEN_OP
    AND mov.ID_CIA = cad.ID_CIA + 0

)lib

left join (

    SELECT
    sal.subcuenta,
    SUM(sal.SALDO_ANTERIOR) as saldo_anterior,
    SUM(sal.saldo_actual) as saldo_actual
    FROM CN_SALDO sal
    WHERE
    sal.ID_VIGENCIA = $P{vig_ini}
    AND sal.ID_PERIODO_CONTABLE = $P{per_ini}
    AND sal.ID_CIA = $P{id_cia}
    AND sal.ID_CEN_OP = $P{id_cen_op}
    group by
    sal.subcuenta

)sal
on sal.subcuenta = lib.cuenta

left join (

    SELECT
    sal.subcuenta,
    SUM(sal.SALDO_ANTERIOR) as saldo_anterior,
    SUM(sal.saldo_actual) as saldo_actual
    FROM CN_SALDO sal
    WHERE
    sal.ID_VIGENCIA = $P{vig_ini}
    AND sal.ID_PERIODO_CONTABLE = $P{per_fin}
    AND sal.ID_CIA = $P{id_cia}
    AND sal.ID_CEN_OP = $P{id_cen_op}
    group by
    sal.subcuenta

)salfin
on salfin.subcuenta = lib.cuenta

left join (

    SELECT
    sal.subcuenta,
    sal.id_auxiliar,
    SUM(sal.SALDO_ANTERIOR) as saldo_anterior
    FROM CN_SALDO sal
    WHERE
    sal.ID_VIGENCIA = $P{vig_ini}
    AND sal.ID_PERIODO_CONTABLE = $P{per_ini}
    AND sal.ID_CIA = $P{id_cia}
    AND sal.ID_CEN_OP = $P{id_cen_op}
    group by
    sal.subcuenta,
    sal.id_auxiliar

)salaux
on salaux.subcuenta = lib.cuenta
and salaux.id_auxiliar = lib.id_auxiliar_org

left join (

    SELECT
    sal.subcuenta,
    sal.id_mae_ter,
    SUM(sal.SALDO_ANTERIOR) as saldo_anterior
    FROM CN_SALDO sal
    WHERE
    sal.ID_VIGENCIA = $P{vig_ini}
    AND sal.ID_PERIODO_CONTABLE = $P{per_ini}
    AND sal.ID_CIA = $P{id_cia}
    AND sal.ID_CEN_OP = $P{id_cen_op}
    group by
    sal.subcuenta,
    sal.id_mae_ter

)salter
on salter.subcuenta = lib.cuenta
and salter.id_mae_ter = lib.id_mae_ter_org

left join (

    SELECT
    sal.subcuenta,
    sal.id_auxiliar,
    sal.id_mae_ter,
    SUM(sal.SALDO_ANTERIOR) as saldo_anterior
    FROM CN_SALDO sal
    WHERE
    sal.ID_VIGENCIA = $P{vig_ini}
    AND sal.ID_PERIODO_CONTABLE = $P{per_ini}
    AND sal.ID_CIA = $P{id_cia}
    AND sal.ID_CEN_OP = $P{id_cen_op}
    group by
    sal.subcuenta,
    sal.id_auxiliar,
    sal.id_mae_ter

)salauxter
on salauxter.subcuenta = lib.cuenta
and salauxter.id_auxiliar = lib.id_auxiliar_org
and salauxter.id_mae_ter = lib.id_mae_ter_org

left join CN_MAE_TER ter
on ter.id_mae_ter = lib.id_mae_ter_org

left join CN_AUXILIAR aux
on aux.id_auxiliar = lib.id_auxiliar_org
AND aux.ID_CLASE_CUENTA = lib.ID_CLASE_CUENTA
AND aux.ID_GRUPO_CUENTA = lib.ID_GRUPO_CUENTA
AND aux.ID_CUENTA_MAYOR = lib.ID_CUENTA_MAYOR
AND aux.ID_CATALOGO = lib.ID_CATALOGO

where

lib.VIG_PER between $P{vigper_Ini} AND $P{vigper_Fin}
AND lib.ID_CIA = $P{id_cia}
AND lib.ID_CEN_OP = $P{id_cen_op}
$P!{whereClase} $P!{whereGrupo} $P!{whereCuenta} $P!{whereCatalogo}
$P!{whereTercero} $P!{whereAuxiliar}

ORDER BY
lib.dig_cla ASC,
lib.dig_gru ASC,
lib.dig_cue ASC,
lib.dig_cat ASC,
lib.ID_AUXILIAR ASC,
lib.ID_MAE_TER ASC,
lib.VIG_PER ASC,
lib.FECHA_CAD ASC,
lib.ID_MOV_CONT ASC]]>
	</queryString>
	<field name="SALDO_ANTERIOR_INI" class="java.math.BigDecimal"/>
	<field name="SALDO_ANTERIOR_FIN" class="java.math.BigDecimal"/>
	<field name="SALDO_ACTUAL_INI" class="java.math.BigDecimal"/>
	<field name="SALDO_ACTUAL_FIN" class="java.math.BigDecimal"/>
	<field name="ID_AUXILIAR_ORG" class="java.math.BigDecimal"/>
	<field name="ID_MAE_TER_ORG" class="java.math.BigDecimal"/>
	<field name="SALDO_ANTERIOR" class="java.math.BigDecimal"/>
	<field name="SALDO_ANTERIOR_SIN" class="java.math.BigDecimal"/>
	<field name="SALDO_ANTERIOR_AUX" class="java.math.BigDecimal"/>
	<field name="SALDO_ANTERIOR_TER" class="java.math.BigDecimal"/>
	<field name="SALDO_ANTERIOR_AUXTER" class="java.math.BigDecimal"/>
	<field name="FECHA_CAD" class="java.sql.Timestamp"/>
	<field name="VIG_PER" class="java.lang.String"/>
	<field name="ID_PERIODO_CONTABLE" class="java.math.BigDecimal"/>
	<field name="NOM_PERIODO" class="java.lang.String"/>
	<field name="ID_VIGENCIA" class="java.math.BigDecimal"/>
	<field name="ID_MOV_CONT" class="java.math.BigDecimal"/>
	<field name="ID_DOCUMENTO" class="java.math.BigDecimal"/>
	<field name="ID_CAD" class="java.math.BigDecimal"/>
	<field name="ID_CEN_OP" class="java.math.BigDecimal"/>
	<field name="ID_CIA" class="java.math.BigDecimal"/>
	<field name="ID_CATALOGO" class="java.math.BigDecimal"/>
	<field name="ID_CUENTA_MAYOR" class="java.math.BigDecimal"/>
	<field name="ID_GRUPO_CUENTA" class="java.math.BigDecimal"/>
	<field name="ID_CLASE_CUENTA" class="java.math.BigDecimal"/>
	<field name="ID_MAE_TER" class="java.math.BigDecimal"/>
	<field name="ID_AUXILIAR" class="java.math.BigDecimal"/>
	<field name="AUXTER" class="java.lang.String"/>
	<field name="ID_SUB_AUX" class="java.math.BigDecimal"/>
	<field name="ID_CENTRO_COSTO" class="java.math.BigDecimal"/>
	<field name="ID_SUB_CENTRO_COSTO" class="java.math.BigDecimal"/>
	<field name="DEBITO" class="java.math.BigDecimal"/>
	<field name="CREDITO" class="java.math.BigDecimal"/>
	<field name="VALOR_BASE" class="java.math.BigDecimal"/>
	<field name="DIG_CLA" class="java.lang.String"/>
	<field name="NOM_CLA" class="java.lang.String"/>
	<field name="DIG_GRU" class="java.lang.String"/>
	<field name="NOM_GRU" class="java.lang.String"/>
	<field name="DIG_CUE" class="java.lang.String"/>
	<field name="NOM_CUE" class="java.lang.String"/>
	<field name="DIG_CAT" class="java.lang.String"/>
	<field name="NOM_CAT" class="java.lang.String"/>
	<field name="NOM_CORTO" class="java.lang.String"/>
	<field name="NOM_TIPO_COMPROBANTE" class="java.lang.String"/>
	<field name="NOM_TD" class="java.lang.String"/>
	<field name="DESCR_MTO" class="java.lang.String"/>
	<field name="DOC_SOPORTE" class="java.lang.String"/>
	<field name="NATURALEZA" class="java.lang.String"/>
	<field name="CUENTA" class="java.lang.String"/>
	<field name="NOMBRE_MAE" class="java.lang.String"/>
	<field name="NITOCC_MAE" class="java.lang.String"/>
	<field name="COD_AUX" class="java.lang.String"/>
	<field name="NOMBRE_AUX" class="java.lang.String"/>
	<field name="SALDO_ANTERIOR2" class="java.math.BigDecimal"/>
	<field name="SALDO_ACTUAL2" class="java.math.BigDecimal"/>
	<field name="SALDO_ANTERIOR3" class="java.math.BigDecimal"/>
	<field name="SALDO_ACTUAL3" class="java.math.BigDecimal"/>
	<variable name="sum_debito_mes" class="java.math.BigDecimal" resetType="Group" resetGroup="Grupo Mes" calculation="Sum">
		<variableExpression><![CDATA[$F{DEBITO}]]></variableExpression>
	</variable>
	<variable name="sum_debito_auxter" class="java.math.BigDecimal" resetType="Group" resetGroup="Grupo Auxiliar Tercero" calculation="Sum">
		<variableExpression><![CDATA[$F{DEBITO}]]></variableExpression>
	</variable>
	<variable name="sum_credito_mes" class="java.math.BigDecimal" resetType="Group" resetGroup="Grupo Mes" calculation="Sum">
		<variableExpression><![CDATA[$F{CREDITO}]]></variableExpression>
	</variable>
	<variable name="sum_credito_auxter" class="java.math.BigDecimal" resetType="Group" resetGroup="Grupo Auxiliar Tercero" calculation="Sum">
		<variableExpression><![CDATA[$F{CREDITO}]]></variableExpression>
	</variable>
	<variable name="id_mae_ter" class="java.math.BigDecimal" resetType="None">
		<variableExpression><![CDATA[-1]]></variableExpression>
	</variable>
	<variable name="id_auxiliar" class="java.math.BigDecimal" resetType="None">
		<variableExpression><![CDATA[-1]]></variableExpression>
	</variable>
	<variable name="saldo_acumulado_mes" class="java.math.BigDecimal" resetType="Group" resetGroup="Grupo Auxiliar Tercero" incrementType="Group" incrementGroup="Grupo Mes" calculation="Sum">
		<variableExpression><![CDATA[( $F{NATURALEZA}.toString()=="D" ?
    $V{sum_debito_mes}-$V{sum_credito_mes} :
    $V{sum_credito_mes}-$V{sum_debito_mes} )]]></variableExpression>
		<initialValueExpression><![CDATA[]]></initialValueExpression>
	</variable>
	<variable name="saldo_acumulado_auxiliar" class="java.math.BigDecimal" resetType="Group" resetGroup="Grupo Auxiliar Tercero" incrementType="Group" incrementGroup="Grupo Auxiliar Tercero" calculation="Sum">
		<variableExpression><![CDATA[( $F{NATURALEZA}.toString()=="D" ?
    $V{sum_debito_auxter} - $V{sum_credito_auxter} :
    $V{sum_credito_auxter} - $V{sum_debito_auxter} )]]></variableExpression>
		<initialValueExpression><![CDATA[]]></initialValueExpression>
	</variable>
	<variable name="saldo_fila" class="java.math.BigDecimal" resetType="Group" resetGroup="Grupo Auxiliar Tercero">
		<variableExpression><![CDATA[( $F{NATURALEZA}.equals( "C" )
    ? $V{saldo_fila} - $F{DEBITO} + $F{CREDITO}
    : $V{saldo_fila} + $F{DEBITO} - $F{CREDITO}
)]]></variableExpression>
		<initialValueExpression><![CDATA[$F{SALDO_ANTERIOR}]]></initialValueExpression>
	</variable>
	<group name="Grupo Cuenta" isReprintHeaderOnEachPage="true">
		<groupExpression><![CDATA[$F{CUENTA}]]></groupExpression>
		<groupHeader>
			<band height="59">
				<staticText>
					<reportElement x="0" y="0" width="960" height="12">
						<printWhenExpression><![CDATA[$F{AUXTER}.toString()!="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>
						<font size="8"/>
					</textElement>
					<text><![CDATA[]]></text>
				</staticText>
				<staticText>
					<reportElement x="701" y="12" width="259" 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>
						<font size="8"/>
					</textElement>
					<text><![CDATA[]]></text>
				</staticText>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement mode="Transparent" x="105" y="12" width="596" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{NOM_CLA}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="701" y="22" width="259" 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>
						<font size="8"/>
					</textElement>
					<text><![CDATA[]]></text>
				</staticText>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement mode="Transparent" x="0" y="12" width="105" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{DIG_CLA}]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement mode="Transparent" x="0" y="42" width="105" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{CUENTA}]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement mode="Transparent" x="105" y="22" width="596" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{NOM_GRU}]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement mode="Transparent" x="105" y="42" width="596" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{NOM_CAT}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="105" height="12" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Cuenta]]></text>
				</staticText>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement mode="Transparent" x="0" y="22" width="105" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{DIG_CLA}+$F{DIG_GRU}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="701" y="32" width="259" 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>
						<font size="8"/>
					</textElement>
					<text><![CDATA[]]></text>
				</staticText>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement mode="Transparent" x="0" y="32" width="105" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{DIG_CLA}+$F{DIG_GRU}+$F{DIG_CUE}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="105" y="0" width="596" height="12" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Nombre cuenta]]></text>
				</staticText>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement mode="Transparent" x="105" y="32" width="596" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{NOM_CUE}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="false">
					<reportElement x="701" y="42" width="259" height="10"/>
					<box rightPadding="3">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="6"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{SALDO_ACTUAL_INI}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="701" y="0" width="259" height="12" forecolor="#000000" backcolor="#88C2F9"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Saldo]]></text>
				</staticText>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="25">
				<textField>
					<reportElement mode="Opaque" x="196" y="0" width="344" height="12" forecolor="#000000" backcolor="#BCBABA"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.0"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.0"/>
					</box>
					<textElement verticalAlignment="Middle" markup="none">
						<font size="8"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{CUENTA}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="196" height="12" backcolor="#BCBABA"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.0"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Saldo Actual Subcuenta : ]]></text>
				</staticText>
				<textField pattern="#,##0.00;(#,##0.00)">
					<reportElement mode="Opaque" x="540" y="0" width="100" height="12" backcolor="#BCBABA"/>
					<box leftPadding="2" rightPadding="3">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="6" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{SALDO_ACTUAL_FIN}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="640" y="0" width="320" height="12" forecolor="#000000" backcolor="#BCBABA"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle" markup="none">
						<font size="8"/>
					</textElement>
					<text><![CDATA[]]></text>
				</staticText>
			</band>
		</groupFooter>
	</group>
	<group name="Grupo Auxiliar Tercero">
		<groupExpression><![CDATA[$F{AUXTER}]]></groupExpression>
		<groupHeader>
			<band height="29">
				<staticText>
					<reportElement x="0" y="0" width="960" height="12">
						<printWhenExpression><![CDATA[$F{AUXTER}.toString()!="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>
						<font size="8"/>
					</textElement>
					<text><![CDATA[]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="0" y="17" width="60" height="12" forecolor="#000000" backcolor="#D4E8FA"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Fecha]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="60" y="17" width="45" height="12" forecolor="#000000" backcolor="#D4E8FA"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Tip. Cp]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="196" y="17" width="44" height="12" forecolor="#000000" backcolor="#D4E8FA"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[CAD]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="701" y="17" width="259" height="12" forecolor="#000000" backcolor="#D4E8FA"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Descripción]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="640" y="17" width="61" height="12" forecolor="#000000" backcolor="#D4E8FA"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Doc. Sop]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="340" y="17" width="100" height="12" forecolor="#000000" backcolor="#D4E8FA"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Débito]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="440" y="17" width="100" height="12" forecolor="#000000" backcolor="#D4E8FA"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Crédito]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="540" y="17" width="100" height="12" forecolor="#000000" backcolor="#D4E8FA"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Saldo]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="340" y="0" width="100" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#B1D6FB">
						<printWhenExpression><![CDATA[$F{ID_MAE_TER}!=-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" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Tercero: ]]></text>
				</staticText>
				<textField>
					<reportElement x="440" y="0" width="261" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[$F{ID_MAE_TER}!=-1]]></printWhenExpression>
					</reportElement>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.0"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="6"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[($F{NITOCC_MAE} .toString().equals("null")
    ? ""
    : $F{NITOCC_MAE} + " - ") +

($F{NOMBRE_MAE} .toString().equals("null")
    ? ""
    : $F{NOMBRE_MAE})]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="105" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#B1D6FB">
						<printWhenExpression><![CDATA[$F{ID_AUXILIAR}!=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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Auxiliar:]]></text>
				</staticText>
				<textField isBlankWhenNull="false">
					<reportElement x="105" y="0" width="235" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[$F{ID_AUXILIAR}!=0]]></printWhenExpression>
					</reportElement>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.0"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="6"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[($F{COD_AUX} .toString().equals("null")
    ? ""
    : $F{COD_AUX} + " - ") +

($F{NOMBRE_AUX} .toString().equals("null")
    ? ""
    : $F{NOMBRE_AUX})]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="105" y="17" width="91" height="12" forecolor="#000000" backcolor="#D4E8FA"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Tipo Doc.]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="240" y="17" width="50" height="12" forecolor="#000000" backcolor="#D4E8FA"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Doc.]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="290" y="17" width="50" height="12" forecolor="#000000" backcolor="#D4E8FA"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Sec.]]></text>
				</staticText>
				<textField evaluationTime="Auto" pattern="#,##0.00;(#,##0.00)">
					<reportElement x="701" y="0" width="259" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[$F{AUXTER}.toString()!="null"]]></printWhenExpression>
					</reportElement>
					<box rightPadding="3">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="6"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[( $F{AUXTER}.toString()!="null"
    ? $F{SALDO_ANTERIOR}
    : 0
)]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="19">
				<textField pattern="#,##0.00;(#,##0.00)">
					<reportElement mode="Opaque" x="540" y="0" width="100" height="12" isRemoveLineWhenBlank="true" backcolor="#D2D0D0">
						<printWhenExpression><![CDATA[$F{AUXTER}.toString()!="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" markup="none">
						<font size="6" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{saldo_acumulado_auxiliar} + ( $F{AUXTER}.toString()!="null"
    ? $F{SALDO_ANTERIOR}
    : 0
)]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="false">
					<reportElement mode="Opaque" x="440" y="0" width="100" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#D2D0D0">
						<printWhenExpression><![CDATA[$F{AUXTER}.toString()!="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_credito_auxter}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="false">
					<reportElement mode="Opaque" x="340" y="0" width="100" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#D2D0D0">
						<printWhenExpression><![CDATA[$F{AUXTER}.toString()!="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_debito_auxter}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement mode="Opaque" x="196" y="0" width="144" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#D2D0D0"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.0"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle" markup="none">
						<font size="4"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[($F{AUXTER}.toString().equals("null")
    ? ""
    : "." )]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement mode="Opaque" x="0" y="0" width="196" height="12" isRemoveLineWhenBlank="true" backcolor="#D2D0D0"/>
					<box rightPadding="0">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.0"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle" markup="none">
						<font size="8" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[($F{AUXTER}.toString().equals("null")
    ? ""
    : "Saldo Actual Auxiliar : " )]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement mode="Opaque" x="640" y="0" width="320" height="12" forecolor="#000000" backcolor="#D2D0D0">
						<printWhenExpression><![CDATA[$F{AUXTER}.toString()!="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" markup="none">
						<font size="4"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[]]></textFieldExpression>
				</textField>
			</band>
		</groupFooter>
	</group>
	<group name="Grupo Mes" isReprintHeaderOnEachPage="true">
		<groupExpression><![CDATA[$F{VIG_PER}]]></groupExpression>
		<groupFooter>
			<band height="12">
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="196" height="12" backcolor="#E5E3E3"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.0"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Subtotal Mes : ]]></text>
				</staticText>
				<textField>
					<reportElement mode="Opaque" x="196" y="0" width="144" height="12" forecolor="#000000" backcolor="#E5E3E3"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.0"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.0"/>
					</box>
					<textElement verticalAlignment="Middle" markup="none">
						<font size="6"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{NOM_PERIODO}+" "+$F{ID_VIGENCIA}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(#,##0.00)">
					<reportElement mode="Opaque" x="540" y="0" width="100" height="12" backcolor="#E5E3E3"/>
					<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" markup="none">
						<font size="6"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{saldo_acumulado_mes} + ( $F{AUXTER}.toString()!="null"
    ? $F{SALDO_ANTERIOR}
    : 0
)]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement mode="Opaque" x="340" y="0" width="100" height="12" backcolor="#E5E3E3"/>
					<box rightPadding="3">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="6" isBold="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{sum_debito_mes}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement mode="Opaque" x="440" y="0" width="100" height="12" backcolor="#E5E3E3"/>
					<box rightPadding="3">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="6" isBold="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{sum_credito_mes}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="640" y="0" width="320" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#E5E3E3"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle" markup="none">
						<font size="4"/>
					</textElement>
					<text><![CDATA[]]></text>
				</staticText>
			</band>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="60" splitType="Stretch">
			<textField pattern="dd-MMM-yyyy   hh:mm aaa">
				<reportElement mode="Opaque" x="701" y="16" width="259" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="701" y="28" width="259" 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[Centro de operacion:]]></text>
			</staticText>
			<staticText>
				<reportElement x="196" y="0" width="505" height="40"/>
				<textElement textAlignment="Center" verticalAlignment="Bottom" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Sistema de Contabilidad
Análisis auxiliar y tercero]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="701" y="4" width="259" 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 Impresion:]]></text>
			</staticText>
			<textField>
				<reportElement x="196" y="40" width="505" 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{nom_periodo_ini}+" de "+$P{vig_ini}+" a "+$P{nom_periodo_fin}+" de "+$P{vig_fin}]]></textFieldExpression>
			</textField>
			<textField pattern="dd-MMM-yyyy   hh:mm aaa">
				<reportElement mode="Opaque" x="701" y="40" width="259" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{nom_cen_op}]]></textFieldExpression>
			</textField>
			<image>
				<reportElement x="0" y="6" width="140" height="40"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
		</band>
	</title>
	<pageHeader>
		<band height="20" splitType="Stretch"/>
	</pageHeader>
	<detail>
		<band height="10" splitType="Stretch">
			<textField pattern="#,##0.00;(#,##0.00)">
				<reportElement stretchType="RelativeToTallestObject" x="440" y="0" width="100" height="10"/>
				<box rightPadding="3">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{CREDITO}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy">
				<reportElement stretchType="RelativeToTallestObject" x="0" 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.util.Date"><![CDATA[$F{FECHA_CAD}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)">
				<reportElement stretchType="RelativeToTallestObject" x="540" y="0" width="100" 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" markup="none">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{saldo_fila}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="640" y="0" width="61" 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{DOC_SOPORTE}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement stretchType="RelativeToTallestObject" x="196" y="0" width="44" height="10"/>
				<box rightPadding="3">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ID_CAD}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement stretchType="RelativeToTallestObject" x="60" y="0" width="45" 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{NOM_CORTO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="701" y="0" width="259" 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{DESCR_MTO}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)">
				<reportElement stretchType="RelativeToTallestObject" x="340" y="0" width="100" 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{DEBITO}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement stretchType="RelativeToTallestObject" x="105" y="0" width="91" 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{NOM_TD}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="290" 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{ID_MOV_CONT}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="240" 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{ID_DOCUMENTO}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<pageFooter>
		<band height="24" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="402" y="12" width="89" 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="492" y="12" width="60" height="12" forecolor="#575757" backcolor="#FFFFFF"/>
				<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="402" y="0" width="150" height="12" forecolor="#575757"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<text><![CDATA[Websafi - Contabilidad]]></text>
			</staticText>
		</band>
	</pageFooter>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="960" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
