<?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="comprobante_traslado_contab" language="groovy" pageWidth="750" pageHeight="900" orientation="Landscape" columnWidth="710" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.1269722013523664"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="id_movimientos_dv" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="numero_letras" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_vigencia" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_cen_op" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="username" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="tag_sgr" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[0]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select
tab0.id_movimientos_dv
, tab0.fecha_mov
, tab0.ID_VIGENCIA
, to_char(tab0.fecha_doc, 'dd-mm-yyyy') as fecha_doc
, tab0.id_tipo_almacenamiento_ini
, tab0.id_espacio_ini
, tab0.id_tipo_almacenamiento_fin
, tab0.id_espacio_fin
, tab0.num_doc
, tab0.id_mae_ter_ini
, tab0.id_mae_ter_fin
, tab0.id_usuario
, 1 as cantidad
, tab4.prefijo
, tab4.id_cen_op
, tab9.prefijo as prefijo_fin
, tab9.id_cen_op as id_cen_op_fin
, tab5.descripcion as desc_corta_tipo_mov
, tab5.id_tipo_movimiento
, tab8.id_concepto_movimiento
, tab8.descripcion as desc_concepto_movimiento
, tab9.id
, tab9.descripcion as desc_ts_td
, tab0.observaciones
,tab4.nom_cen_op
,tab0.anulado
,tab0.estado
,tab0.fecha_anu,

tab1.digitos,
tab1.nombre,
nvl(tab1.cod_aux,' ') as cod_aux,
nvl(tab1.auxiliar,' ') as auxiliar,
tab1.nitocc,
tab1.tercero,
tab1.tercero_completo,
tab1.DEBITO,
tab1.CREDITO

from in_movimientos_dv tab0

left join ts_td tab9 on tab9.id = tab0.id_ts_td

join centro_operacion tab4 on tab4.id_cen_op = tab0.id_cen_op
join centro_operacion tab9 on tab9.id_cen_op = tab0.id_cen_op_fin
join in_tipo_movimiento tab5 on tab5.id_tipo_movimiento = tab0.id_tipo_movimiento

join in_concepto_movimiento tab8 on tab8.id_concepto_movimiento = tab0.id_concepto_movimiento

left join(

    select

    dig.digitos,
    dig.nombre,
    aux.cod_aux as cod_aux,
    aux.nombre as auxiliar,
    ter.nitocc,
    ter.nombre as tercero,
    nvl(ter.nitocc,'') || ' - ' || nvl(ter.nombre,'') as tercero_completo,

    --doc.doc_soporte as doc_mov,
    trim(
      replace(
      replace(
      replace(
      translate( doc.doc_soporte, 'QWERTYUIOPASDFGHJKLÑZXCVBNMqwertyuiopasdfghjklñzxcvbnm?¿`+-,.-;:_!¡{}[´]*=)(/@#~$\%', '0' ),
      ' ' ,
      '' )
      , chr(39) ,
      '' ),
      chr(38) , '')
    ) as doc_mov,

    mov.ID_MOV_CONT,
    mov.ID_DOCUMENTO,
    mov.ID_CAD,
    mov.ID_VIGENCIA,
    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,
    mov.ID_AUXILIAR,
    mov.ID_SUB_AUX,
    mov.ID_CENTRO_COSTO,
    mov.ID_SUB_CENTRO_COSTO,
    mov.DEBITO,
    mov.CREDITO,
    mov.VALOR_BASE,
    cad.id_periodo_contable

    from cn_movimiento_contable@CONTABILIDAD.ANM.LOCAL mov

    join cn_documento@CONTABILIDAD.ANM.LOCAL doc
    on doc.id_cad = mov.id_cad
    and doc.id_cen_op = mov.id_cen_op
    and doc.id_cia = mov.id_cia
    and doc.id_vigencia = mov.id_vigencia
    and doc.id_documento = mov.id_documento

    join cn_control_cad@CONTABILIDAD.ANM.LOCAL cad
    on mov.id_cad = cad.id_cad
    and mov.id_cen_op = cad.id_cen_op
    and mov.id_cia = cad.id_cia
    and mov.id_vigencia = cad.id_vigencia

    left join cn_subc_digitos@CONTABILIDAD.ANM.LOCAL dig
    on dig.id_cia = mov.id_cia
    and mov.id_clase_cuenta = dig.id_clase_cuenta
    and mov.id_grupo_cuenta = dig.id_grupo_cuenta
    and mov.id_cuenta_mayor = dig.id_cuenta_mayor
    and mov.id_catalogo = dig.id_catalogo

    left join cn_auxiliar@CONTABILIDAD.ANM.LOCAL aux
    on mov.id_auxiliar = aux.id_auxiliar
    and mov.id_catalogo = aux.id_catalogo
    and mov.id_cuenta_mayor = aux.id_cuenta_mayor
    and mov.id_grupo_cuenta = aux.id_grupo_cuenta
    and mov.id_clase_cuenta = aux.id_clase_cuenta
    and mov.id_cia = aux.id_cia

    left join cn_mae_ter@CONTABILIDAD.ANM.LOCAL ter
    on mov.id_mae_ter = ter.id_mae_ter

    where
    (cad.id_tipo_comprobante = case when $P{tag_sgr} = 0 then 36 else 41 end or cad.id_tipo_comprobante = case when $P{tag_sgr} = 0 then 36 else 97 end)
    --cad.id_tipo_comprobante = case when 0 = 0 then 36 else 41 end
    --cad.id_tipo_comprobante in (36,41,97)
    --and mov.id_vigencia = 2016
    --and doc.doc_soporte = '133396'

)tab1
on tab0.id_movimientos_dv = tab1.id_documento
and tab0.id_vigencia = tab1.id_vigencia
and EXTRACT(MONTH FROM tab0.fecha_mov) = tab1.id_periodo_contable

where
tab0.id_movimientos_dv = $P{id_movimientos_dv}
and tab0.id_vigencia = $P{id_vigencia}
and tab0.id_cen_op = $P{id_cen_op}
and tab0.id_tipo_movimiento = 2

order by
tab1.digitos,
tab1.cod_aux,
tab1.nitocc,
tab1.DEBITO,
tab1.CREDITO]]>
	</queryString>
	<field name="ID_MOVIMIENTOS_DV" class="java.math.BigDecimal"/>
	<field name="FECHA_MOV" class="java.sql.Timestamp"/>
	<field name="ID_VIGENCIA" class="java.math.BigDecimal"/>
	<field name="FECHA_DOC" class="java.lang.String"/>
	<field name="ID_TIPO_ALMACENAMIENTO_INI" class="java.math.BigDecimal"/>
	<field name="ID_ESPACIO_INI" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_ALMACENAMIENTO_FIN" class="java.math.BigDecimal"/>
	<field name="ID_ESPACIO_FIN" class="java.math.BigDecimal"/>
	<field name="NUM_DOC" class="java.lang.String"/>
	<field name="ID_MAE_TER_INI" class="java.math.BigDecimal"/>
	<field name="ID_MAE_TER_FIN" class="java.math.BigDecimal"/>
	<field name="ID_USUARIO" class="java.math.BigDecimal"/>
	<field name="CANTIDAD" class="java.math.BigDecimal"/>
	<field name="PREFIJO" class="java.lang.String"/>
	<field name="ID_CEN_OP" class="java.math.BigDecimal"/>
	<field name="PREFIJO_FIN" class="java.lang.String"/>
	<field name="ID_CEN_OP_FIN" class="java.math.BigDecimal"/>
	<field name="DESC_CORTA_TIPO_MOV" class="java.lang.String"/>
	<field name="ID_TIPO_MOVIMIENTO" class="java.math.BigDecimal"/>
	<field name="ID_CONCEPTO_MOVIMIENTO" class="java.math.BigDecimal"/>
	<field name="DESC_CONCEPTO_MOVIMIENTO" class="java.lang.String"/>
	<field name="ID" class="java.math.BigDecimal"/>
	<field name="DESC_TS_TD" class="java.lang.String"/>
	<field name="OBSERVACIONES" class="java.lang.String"/>
	<field name="NOM_CEN_OP" class="java.lang.String"/>
	<field name="ANULADO" class="java.math.BigDecimal"/>
	<field name="ESTADO" class="java.math.BigDecimal"/>
	<field name="FECHA_ANU" class="java.sql.Timestamp"/>
	<field name="DIGITOS" class="java.lang.String"/>
	<field name="NOMBRE" class="java.lang.String"/>
	<field name="COD_AUX" class="java.lang.String"/>
	<field name="AUXILIAR" class="java.lang.String"/>
	<field name="NITOCC" class="java.lang.String"/>
	<field name="TERCERO" class="java.lang.String"/>
	<field name="TERCERO_COMPLETO" class="java.lang.String"/>
	<field name="DEBITO" class="java.math.BigDecimal"/>
	<field name="CREDITO" class="java.math.BigDecimal"/>
	<pageHeader>
		<band height="172">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="108" y="122" width="341" height="20"/>
				<textElement verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{OBSERVACIONES}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="553" y="96" width="126" height="20" isRemoveLineWhenBlank="true"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{ID_VIGENCIA}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="479" y="96" width="74" height="20"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[VIGENCIA:]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="53" width="452" height="119"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement/>
				<text><![CDATA[]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="107" y="69" width="344" height="20"/>
				<textElement verticalAlignment="Middle">
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESC_CONCEPTO_MOVIMIENTO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="452" y="53" width="258" height="119"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement/>
				<text><![CDATA[]]></text>
			</staticText>
			<textField>
				<reportElement x="283" y="33" width="427" height="20"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font size="15"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[" COMPROBANTE DE "+$F{DESC_CORTA_TIPO_MOV}+" No."+$F{ID_MOVIMIENTOS_DV}.toString()]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="122" y="96" width="327" height="20"/>
				<textElement verticalAlignment="Middle">
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NOM_CEN_OP}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="1" y="148" width="107" height="20"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[ANTECEDENTE:]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="69" width="107" height="20"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[CONCEPTO      :]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" x="1" y="121" width="107" height="20"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[OBSERVACIONES: ]]></text>
			</staticText>
			<staticText>
				<reportElement x="479" y="69" width="74" height="20"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No.]]></text>
			</staticText>
			<staticText>
				<reportElement x="479" y="145" width="74" height="20"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[CIUDAD:]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="108" y="148" width="345" height="20"/>
				<textElement verticalAlignment="Middle">
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_DOC}==null?"":$F{DESC_TS_TD}+ " No. "+$F{NUM_DOC}+" del "+$F{FECHA_DOC}]]></textFieldExpression>
			</textField>
			<textField pattern="###0" isBlankWhenNull="true">
				<reportElement x="553" y="69" width="126" height="20" isRemoveLineWhenBlank="true"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ID_MOVIMIENTOS_DV}.toString()]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="553" y="145" width="126" height="20" isRemoveLineWhenBlank="true"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PREFIJO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="96" width="122" height="20"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[CENTRO OPERACION: ]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" x="479" y="122" width="74" height="20"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[FECHA:]]></text>
			</staticText>
			<image>
				<reportElement x="0" y="0" width="283" height="53"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
			<textField pattern="dd-MM-yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="553" y="122" width="126" height="20" isRemoveLineWhenBlank="true"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_MOV}]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="42" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="0" y="12" width="710" height="18" forecolor="#000000" backcolor="#BBC4CD"/>
				<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[Contabilidad.]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="220" y="30" width="120" height="12" 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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Auxiliar]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="340" y="30" width="170" height="12" 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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Tercero]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="30" width="50" height="12" 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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Cuenta]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="510" y="30" width="100" height="12" 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="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="610" y="30" width="100" height="12" 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="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="50" y="30" width="170" height="12" 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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Nombre Cuenta]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="10" splitType="Stretch">
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement x="610" y="0" width="100" height="10"/>
				<box leftPadding="0" 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{CREDITO}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="340" y="0" width="170" 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{TERCERO_COMPLETO}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement x="510" y="0" width="100" height="10"/>
				<box leftPadding="0" 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 isBlankWhenNull="true">
				<reportElement x="220" y="0" width="120" 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{COD_AUX} + " " + $F{AUXILIAR}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="0" y="0" width="50" height="10"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DIGITOS}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="50" y="0" width="170" 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{NOMBRE}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<summary>
		<band height="12">
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="710" height="12" forecolor="#000000" backcolor="#BBC4CD"/>
				<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[]]></text>
			</staticText>
		</band>
	</summary>
</jasperReport>
