<?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="in_reve_mov_entrada_dv" pageWidth="1810" pageHeight="842" columnWidth="1770" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.100000000000001"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/inventario/inf_reve_mov_entrada_dv"/>
	<property name="ireport.jasperserver.url" value="http://localhost:18091/jasperserver/services/repository"/>
	<parameter name="fecha_ini" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="fecha_fin" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_cen_op" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTipoAlmacenamientoFin" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTerceroFin" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereEspacioFin" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereCenOp" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereEstado" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereAnulado" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTipoOrigen" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="username" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select

cont.digitos as digitos_grup,
cont.nom_cuenta as nom_cuenta_grup,
cont.cod_aux as cod_aux_grup,
cont.nom_aux as nom_aux_grup,

tab0.*,

tab1.id_inventario_dv,
nvl((tab2.costo_actual), 0) as total_inv_det,
nvl((tab1.valor_unitario), 0) as total_det,
cod.codigo_elemento,
tab2.descripcion

from
(

    select
    tab0.*
    , nvl(tab1.total,0) as total,
    case when tab0.anulado = 0 then nvl(tab1.total,0) else 0 end as total_estado

    from in_movimientos_dv_v tab0

    left join in_movimientos_dv_total_v tab1 on tab0.id_movimientos_dv = tab1.id_movimientos_dv
    and tab1.id_vigencia =tab0.id_vigencia
    and tab1.id_cen_op = tab0.id_cen_op and tab1.id_tipo_movimiento = tab0.id_tipo_movimiento

    where 1=1 and
    tab0.fecha_mov between to_date($P{fecha_ini}, 'dd/mm/yyyy') and to_date($P{fecha_fin}, 'dd/mm/yyyy')
    and tab0.id_tipo_movimiento = 1

)tab0

left join in_det_mov_dv tab1 on
tab1.id_movimientos_dv = tab0.id_movimientos_dv
and tab1.id_cen_op = tab0.id_cen_op
and tab1.id_vigencia = tab0.id_vigencia
and tab0.id_tipo_movimiento = tab1.id_tipo_movimiento

left join in_inventario_dv tab2 on
tab2.id_inventario_dv = tab1.id_inventario_dv

left join in_codigo_elemento_v cod
on tab2.id_catalogo = cod.id_catalogo
and tab2.id_clase = cod.id_clase
and tab2.id_linea = cod.id_linea

join in_tipo_almacenamiento tab3 on tab3.id_tipo_almacenamiento= tab0.id_tipo_almacenamiento_fin

left join (
  select
   aut.*,
   row_number() over (
    partition by aut.id_grupo, aut.id_linea, aut.id_clase
    order by aut.id_grupo, aut.id_linea, aut.id_clase
   ) as rn
  from in_param_contab aut
  where aut.id_tipo_transac = 1
)cont
on tab3.id_grupo_almacenamiento = cont.id_grupo
and tab2.id_clase = cont.id_clase
and tab2.id_linea = cont.id_linea
and cont.rn = 1

where 1 = 1
$P!{whereCenOp}
$P!{whereTipoAlmacenamientoFin}
$P!{whereEspacioFin}
$P!{whereTerceroFin}
$P!{whereEstado}
$P!{whereAnulado}
$P!{whereTipoOrigen}

and tab0.anulado = 0

order by
tab0.id_concepto_movimiento ,
tab0.desc_tipo_almac_fin,
tab0.id_vigencia,
TAB0.ID_MOVIMIENTOS_DV,
cod.codigo_elemento,
tab1.id_inventario_dv]]>
	</queryString>
	<field name="DIGITOS_GRUP" class="java.lang.String"/>
	<field name="NOM_CUENTA_GRUP" class="java.lang.String"/>
	<field name="COD_AUX_GRUP" class="java.lang.String"/>
	<field name="NOM_AUX_GRUP" class="java.lang.String"/>
	<field name="ID_MOVIMIENTOS_DV" class="java.math.BigDecimal"/>
	<field name="ANULADO" class="java.math.BigDecimal"/>
	<field name="ESTADO" class="java.math.BigDecimal"/>
	<field name="FECHA_ANU" class="java.sql.Timestamp"/>
	<field name="FECHA_DOC" class="java.sql.Timestamp"/>
	<field name="ID_VIGENCIA" class="java.math.BigDecimal"/>
	<field name="MOTIVO_ANU" class="java.lang.String"/>
	<field name="NUM_DOC" class="java.lang.String"/>
	<field name="OBSERVACIONES" class="java.lang.String"/>
	<field name="FECHA_MOV" class="java.sql.Timestamp"/>
	<field name="FECHA_MOV_TIME" class="oracle.sql.TIMESTAMP"/>
	<field name="VALOR_FACTURA" class="java.math.BigDecimal"/>
	<field name="VALOR_AJUSTE" class="java.math.BigDecimal"/>
	<field name="TIENE_IVA" class="java.math.BigDecimal"/>
	<field name="ID_CEN_OP" class="java.math.BigDecimal"/>
	<field name="NOM_CEN_OP" class="java.lang.String"/>
	<field name="DESCR_CEN_OP" class="java.lang.String"/>
	<field name="PREFIJO" class="java.lang.String"/>
	<field name="ID_TIPO_MOVIMIENTO" class="java.math.BigDecimal"/>
	<field name="DESC_TIPO_MOV" class="java.lang.String"/>
	<field name="ESTADO_TIPO_MOV" class="java.math.BigDecimal"/>
	<field name="DESC_CORTA_TIPO_MOV" class="java.lang.String"/>
	<field name="ID_CONCEPTO_MOVIMIENTO" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_MOV_CONCEP_MOV" class="java.math.BigDecimal"/>
	<field name="DESC_CONCEP_MOV" class="java.lang.String"/>
	<field name="DESC_CORTA_CONCEP_MOV" class="java.lang.String"/>
	<field name="TRASLADO_REGIONAL" class="java.math.BigDecimal"/>
	<field name="ESTADO_CONEP_MOV" class="java.math.BigDecimal"/>
	<field name="ID_TS_TD" class="java.math.BigDecimal"/>
	<field name="DOC_TS_TD" class="java.lang.String"/>
	<field name="DESC_TS_TD" class="java.lang.String"/>
	<field name="DEC_CORTA_TS_TD" class="java.lang.String"/>
	<field name="COMPLETO_INI" class="java.lang.String"/>
	<field name="NUM_DOC_INI" class="java.lang.String"/>
	<field name="ID_MAE_TER_INI" class="java.math.BigDecimal"/>
	<field name="COMPLETO_FIN" class="java.lang.String"/>
	<field name="NUM_DOC_FIN" class="java.lang.String"/>
	<field name="ID_MAE_TER_FIN" class="java.math.BigDecimal"/>
	<field name="ID_ESPACIO_INI" class="java.math.BigDecimal"/>
	<field name="ID_ESTRUCTURA_INI" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_ESPACIO_INI" class="java.math.BigDecimal"/>
	<field name="DESC_ESPACIO_INI" class="java.lang.String"/>
	<field name="NIVEL_ESPACIO_INI" class="java.lang.String"/>
	<field name="COORD_X_INI" class="java.math.BigDecimal"/>
	<field name="COORD_Y_INI" class="java.math.BigDecimal"/>
	<field name="ESTADO_ESPACIO_INI" class="java.math.BigDecimal"/>
	<field name="ID_ESPACIO_FIN" class="java.math.BigDecimal"/>
	<field name="ID_ESTRUCTURA_FIN" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_ESPACIO_FIN" class="java.math.BigDecimal"/>
	<field name="DESC_ESPACIO_FIN" class="java.lang.String"/>
	<field name="NIVEL_ESPACIO_FIN" class="java.lang.String"/>
	<field name="COORD_X_FIN" class="java.math.BigDecimal"/>
	<field name="COORD_Y_FIN" class="java.math.BigDecimal"/>
	<field name="ESTADO_ESPACIO_FIN" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_ALMACENAMIENTO" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_ALMACENAMIENTO_INI" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_ALMAC_INI" class="java.math.BigDecimal"/>
	<field name="DESC_TIPO_ALMAC_INI" class="java.lang.String"/>
	<field name="ESTADO_TIPO_ALMAC_INI" class="java.math.BigDecimal"/>
	<field name="DEPRECIABLE_INI" class="java.math.BigDecimal"/>
	<field name="ID_GRUPO_ALMACENAMIENTO_INI" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_ALMACENAMIENTO_FIN" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_ALMAC_FIN" class="java.math.BigDecimal"/>
	<field name="DESC_TIPO_ALMAC_FIN" class="java.lang.String"/>
	<field name="ESTADO_TIPO_ALMAC_FIN" class="java.math.BigDecimal"/>
	<field name="DEPRECIABLE_FIN" class="java.math.BigDecimal"/>
	<field name="ID_GRUPO_ALMACENAMIENTO_FIN" class="java.math.BigDecimal"/>
	<field name="COMPLETO_ANU" class="java.lang.String"/>
	<field name="NUM_DOC_ANU" class="java.lang.String"/>
	<field name="ID_MAE_TER_ANU" class="java.math.BigDecimal"/>
	<field name="ID_CEN_OP_FIN" class="java.math.BigDecimal"/>
	<field name="NOM_CEN_OP_FIN" class="java.lang.String"/>
	<field name="DESCR_CEN_OP_FIN" class="java.lang.String"/>
	<field name="PREFIJO_FIN" class="java.lang.String"/>
	<field name="TOTAL_MOVIMIENTO" class="java.math.BigDecimal"/>
	<field name="COMPLETO_USU" class="java.lang.String"/>
	<field name="ID_USUARIO" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_ORIGEN" class="java.math.BigDecimal"/>
	<field name="DESCRIPCION_TIPORG" class="java.lang.String"/>
	<field name="ABREVIATURA_TIPORG" class="java.lang.String"/>
	<field name="TOTAL" class="java.math.BigDecimal"/>
	<field name="TOTAL_ESTADO" class="java.math.BigDecimal"/>
	<field name="ID_INVENTARIO_DV" class="java.math.BigDecimal"/>
	<field name="TOTAL_INV_DET" class="java.math.BigDecimal"/>
	<field name="TOTAL_DET" class="java.math.BigDecimal"/>
	<field name="CODIGO_ELEMENTO" class="java.lang.String"/>
	<field name="DESCRIPCION" class="java.lang.String"/>
	<variable name="total_valor" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{TOTAL_DET}]]></variableExpression>
	</variable>
	<variable name="total_item" class="java.math.BigDecimal" calculation="Count">
		<variableExpression><![CDATA[$F{TOTAL}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="80" splitType="Stretch">
			<textField pattern="dd/MM/yyyy h:mm a" isBlankWhenNull="true">
				<reportElement x="1540" y="27" width="230" height="16"/>
				<box rightPadding="3"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="291" y="59" width="699" height="21">
					<printWhenExpression><![CDATA[$F{ID_VIGENCIA}!=null]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="14" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Periodo de "+$P{fecha_ini}+" hasta "+$P{fecha_fin}]]></textFieldExpression>
			</textField>
			<image>
				<reportElement x="0" y="9" width="135" height="62"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
			<staticText>
				<reportElement x="291" y="0" width="699" height="59"/>
				<textElement textAlignment="Center" verticalAlignment="Bottom" markup="none">
					<font fontName="SansSerif" size="18" isBold="true"/>
				</textElement>
				<text><![CDATA[Informe de Revelaciones Contables
Movimiento Detallado de Entrada - Devolutivos]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1540" y="11" width="230" height="16" forecolor="#000000" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Fecha de Impresión:]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1540" y="43" width="230" height="16" 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 Operación:]]></text>
			</staticText>
			<textField>
				<reportElement x="1540" y="59" width="230" height="14"/>
				<box rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[!$P{whereCenOp}.equals("")?$F{PREFIJO}:"CONSOLIDADO"]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="6" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="28" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="64" height="28" backcolor="#88C2F9"/>
				<box leftPadding="2" 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="7" isBold="true"/>
				</textElement>
				<text><![CDATA[No Comprobante]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="109" y="0" width="60" height="28" backcolor="#88C2F9"/>
				<box leftPadding="2" 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="7" isBold="true"/>
				</textElement>
				<text><![CDATA[Fecha Comprobante]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="945" y="0" width="45" height="28" backcolor="#88C2F9"/>
				<box leftPadding="2" 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="7" isBold="true"/>
				</textElement>
				<text><![CDATA[Estado]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="865" y="0" width="80" height="28" backcolor="#88C2F9"/>
				<box leftPadding="2" 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="7" isBold="true"/>
				</textElement>
				<text><![CDATA[Valor]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="419" y="0" width="122" height="28" backcolor="#88C2F9"/>
				<box leftPadding="2" 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="7" isBold="true"/>
				</textElement>
				<text><![CDATA[Responsable]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="541" y="0" width="93" height="28" backcolor="#88C2F9"/>
				<box leftPadding="2" 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="7" isBold="true"/>
				</textElement>
				<text><![CDATA[Espacio]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="634" y="0" width="231" height="28" backcolor="#88C2F9"/>
				<box leftPadding="2" 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="7" isBold="true"/>
				</textElement>
				<text><![CDATA[Observaciones]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="64" y="0" width="45" height="28" backcolor="#88C2F9"/>
				<box leftPadding="2" 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="7" isBold="true"/>
				</textElement>
				<text><![CDATA[Centro Op.]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="990" y="0" width="70" height="28" backcolor="#88C2F9"/>
				<box leftPadding="2" 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="7" isBold="true"/>
				</textElement>
				<text><![CDATA[Fecha Anulación]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1640" y="0" width="130" height="28" backcolor="#88C2F9"/>
				<box leftPadding="2" 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="7" isBold="true"/>
				</textElement>
				<text><![CDATA[Usuario Elabora]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1060" y="0" width="120" height="28" backcolor="#88C2F9"/>
				<box leftPadding="2" 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="7" isBold="true"/>
				</textElement>
				<text><![CDATA[Tipo Origen]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="169" y="0" width="122" height="28" backcolor="#88C2F9"/>
				<box leftPadding="2" 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="7" isBold="true"/>
				</textElement>
				<text><![CDATA[Concepto Movimiento]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="291" y="0" width="128" height="28" backcolor="#88C2F9"/>
				<box leftPadding="2" 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="7" isBold="true"/>
				</textElement>
				<text><![CDATA[Tipo Almacenamiento]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1240" y="0" width="60" height="28" backcolor="#88C2F9"/>
				<box leftPadding="2" 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="7" isBold="true"/>
				</textElement>
				<text><![CDATA[Secuencia]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1300" y="0" width="240" height="28" backcolor="#88C2F9"/>
				<box leftPadding="2" 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="7" isBold="true"/>
				</textElement>
				<text><![CDATA[Descricpción]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1180" y="0" width="60" height="28" backcolor="#88C2F9"/>
				<box leftPadding="2" 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="7" isBold="true"/>
				</textElement>
				<text><![CDATA[Codigo Elemento]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1590" y="0" width="50" height="28" 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">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Auxiliar Grupo]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1540" y="0" width="50" height="28" 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">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Cuenta Grupo ]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="20" splitType="Stretch">
			<textField>
				<reportElement x="0" y="0" width="64" height="20"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{ID_MOVIMIENTOS_DV}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="109" y="0" width="60" height="20"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_MOV}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="419" y="0" width="122" height="20"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{COMPLETO_FIN}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="541" y="0" width="93" height="20"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESC_ESPACIO_FIN}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
				<reportElement x="865" y="0" width="80" height="20"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{TOTAL_DET}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="945" y="0" width="45" height="20"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[($F{ANULADO}.intValue() == 1
    ? "Anulado"
    : $F{ESTADO}.intValue() == 1 ? "Abierto": "Cerrado"
)]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="634" y="0" width="231" height="20"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{OBSERVACIONES}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="64" y="0" width="45" height="20"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PREFIJO}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="990" y="0" width="70" height="20"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_ANU}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="1640" y="0" width="130" height="20"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{COMPLETO_USU}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="1060" y="0" width="120" height="20"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESCRIPCION_TIPORG}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="169" y="0" width="122" height="20"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESC_CONCEP_MOV}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="291" y="0" width="128" height="20"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESC_TIPO_ALMAC_FIN}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement x="1180" y="0" width="60" height="20"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CODIGO_ELEMENTO}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="1300" y="0" width="240" height="20"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESCRIPCION}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement x="1240" y="0" width="60" height="20"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{ID_INVENTARIO_DV}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1590" y="0" width="50" height="20"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{COD_AUX_GRUP}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1540" y="0" width="50" height="20"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DIGITOS_GRUP}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="13" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="38" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="532" y="16" 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="621" y="16" width="60" height="12" forecolor="#575757" backcolor="#FFFFFF"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="514" y="4" width="173" height="12" forecolor="#575757"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<text><![CDATA[Websafi - Control De Recursos Físicos
]]></text>
			</staticText>
			<textField>
				<reportElement mode="Opaque" x="0" y="26" width="291" height="12" forecolor="#575757" backcolor="#FFFFFF"/>
				<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["Impreso por: "+$P{username}]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band height="41" splitType="Stretch">
			<textField pattern="###0">
				<reportElement mode="Opaque" x="64" y="0" width="45" height="12" forecolor="#000000" backcolor="#BCBABA"/>
				<box leftPadding="1" 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="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_item}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="64" height="12" forecolor="#000000" backcolor="#BCBABA"/>
				<box rightPadding="5">
					<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[MOVIMIENTOS]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="109" y="0" width="756" height="12" backcolor="#BCBABA"/>
				<box leftPadding="3" rightPadding="7">
					<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="7" isBold="true"/>
				</textElement>
				<text><![CDATA[TOTAL]]></text>
			</staticText>
			<textField pattern="#,##0.00;-#,##0.00">
				<reportElement mode="Opaque" x="865" y="0" width="80" height="12" forecolor="#000000" backcolor="#BCBABA"/>
				<box leftPadding="1" rightPadding="3">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_valor}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="945" y="0" width="825" height="12" backcolor="#BCBABA"/>
				<box leftPadding="3" rightPadding="7">
					<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="7" isBold="true"/>
				</textElement>
				<text><![CDATA[]]></text>
			</staticText>
		</band>
	</summary>
</jasperReport>
