<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="inf_men_ingre_comp_sgr" language="groovy" pageWidth="1700" pageHeight="612" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="1660" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="2.1961500000000016"/>
	<property name="ireport.x" value="982"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/inventario/cons_ingre_dev"/>
	<property name="ireport.jasperserver.url" value="http://192.168.2.43:8090/jasperserver/services/repository"/>
	<parameter name="vigencia" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_meses" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereCenOp" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTipoAlmacenamiento" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTercero" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTipoOrigen" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereContratoCO" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereCatalogo" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTipoBien" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select
tab0.*
from(

    select distinct

    ing.id_contrato,
    ing.id_vigencia_cont,
    ing.id_cen_op_cont,
    ing.id_movimientos_dv,
    ing.id_vigencia_mov,
    ing.id_cen_op_mov,
    ing.id_tipo_movimiento,

    contab.digitos as cuenta,
    contab.nom_cuenta as nombre_cuenta,

    cod.codigo_elemento as codigo_elemento,
    inv.codigo as secuencia,
    inv.descripcion as descripcion_elemento,

    ep.id_estudios_previos,
    proy.proyecto_cod,
    proy.proyecto as proyecto,
    case when contin.id_contrato_co is null then null else (

        case when contco.orden_compra = 1 then 'Orden Compra No.' else 'Contrato No.' end

    ) || contco.no_contrato || ' del ' || contco.id_anhos end as contrato,
    contco.no_contrato as no_contrato,
    contco.id_anhos as anho_cont,

    detmov.valor_unitario as valor_bien,
    nvl(datsgr.por_sgr,0) as por_sgr,
    round( detmov.valor_unitario * datsgr.por_sgr / 100 , 2) as valor_sgr,

    mov.fecha_mov,
    cenop.nom_cen_op,
    cenop.prefijo,

    mov.id_cen_op,
    mov.id_tipo_almacenamiento_fin as id_tipo_almacenamiento,
    mov.id_mae_ter_fin as id_mae_ter,
    mov.id_tipo_origen,
    detmov.id_catalogo,

    contin.id_contrato_co,
    cla.id_tipo_bien,
    tipben.descripcion as desc_bien

    from in_contrato_mov_dv ing

    left join in_contrato contin
    on contin.id_contrato = ing.id_contrato
    and contin.id_vigencia = ing.id_vigencia_cont

    left join co_contrato contco
    on contco.id_contrato = contin.id_contrato_co

      LEFT JOIN co_seleccion_ep sel
      ON sel.id_seleccion_ep = contco.id_seleccion_ep
      LEFT JOIN CO_ESTUDIOS_PREVIOS ep
      ON ep.id_estudios_previos = sel.id_estudios_previos

    left join in_movimientos_dv mov
    on mov.id_movimientos_dv = ing.id_movimientos_dv
    and mov.id_vigencia = ing.id_vigencia_mov
    and mov.id_cen_op = ing.id_cen_op_mov
    and mov.id_tipo_movimiento = ing.id_tipo_movimiento

    left join in_det_mov_dv detmov
    on detmov.id_movimientos_dv = mov.id_movimientos_dv
    and detmov.id_vigencia = mov.id_vigencia
    and detmov.id_cen_op = mov.id_cen_op
    and detmov.id_tipo_movimiento = mov.id_tipo_movimiento

    left join in_inventario_dv inv
    on inv.id_inventario_dv = detmov.id_inventario_dv

    left join in_clase cla
    on cla.id_clase = inv.id_clase

    LEFT JOIN IN_TIPO_BIEN tipben ON tipben.id_tipo_bien = cla.id_tipo_bien

    left join in_tipo_almacenamiento tipalm
    on tipalm.id_tipo_almacenamiento = inv.id_tipo_almacenamiento

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

    left join in_param_contab contab
    on contab.id_tipo_transac = 1
    and contab.id_clase = inv.id_clase
    and contab.id_linea = inv.id_linea
    and contab.id_grupo = tipalm.id_grupo_almacenamiento

    left join in_saldo_inventario_dv sal
    on sal.id_inventario_dv = inv.id_inventario_dv
    and sal.id_vigencia = $P{vigencia}
    and sal.id_meses = $P{id_meses}

    left join centro_operacion_v cenop
    on cenop.id_cen_op = sal.id_cen_op

    left join(

        select

        tab0.id_estudios_previos,
        to_char(wm_concat(tab0.proyecto_cod)) as proyecto_cod,
        to_char(wm_concat(tab0.proyecto)) as proyecto

        from(

            select
            proyep.id_estudios_previos,
            'PGN: ' || LISTAGG(proy.codigo , ', ') WITHIN GROUP (ORDER BY proyep.sgr, proy.codigo) as proyecto_cod,
            'PGN: ' || LISTAGG(proy.codigo || ' ' || proy.descripcion, ', ') WITHIN GROUP (ORDER BY codigo) as proyecto

            from co_proyecto_ep proyep
            left join co_proyectos_all_v proy on proyep.id_cpo = proy.id and proyep.sgr = proy.sgr

            where proyep.sgr = 0

            group by
            proyep.id_estudios_previos

            union

            select
            proyep.id_estudios_previos,
            'SGR: ' || LISTAGG(proy.codigo , ', ') WITHIN GROUP (ORDER BY proyep.sgr, proy.codigo) as proyecto_cod,
            'SGR: ' || LISTAGG(proy.codigo || ' ' || proy.descripcion, ', ') WITHIN GROUP (ORDER BY codigo) as proyecto

            from co_proyecto_ep proyep
            left join co_proyectos_all_v proy on proyep.id_cpo = proy.id and proyep.sgr = proy.sgr

            where proyep.sgr = 1

            group by
            proyep.id_estudios_previos

        )tab0

        GROUP BY tab0.id_estudios_previos

    )proy
    on proy.id_estudios_previos = ep.id_estudios_previos

    /*left join(

        select

        tab0.id_contrato,
        sum(case when tab0.sgr = 1 then tab0.valor else 0 end) as valor_sgr,
        round( sum(case when tab0.sgr = 1 then tab0.valor else 0 end) * 100 / sum(tab0.valor) , 2 ) as por_sgr,
        sum(tab0.valor) as valor


        from(

            SELECT distinct

            tab0.id_contrato,
            tab0.id_rp,
            tab0.sgr,
            rps.valor

            FROM(

                SELECT
                leg.id_contrato,
                leg.id_rp,
                nvl(leg.vigencia_rp,EXTRACT(YEAR FROM leg.fecha_aprueba_poliza)) as vigencia,
                nvl(leg.rp_sgr,0) as sgr

                FROM co_legaliza_contrato leg

            )tab0

            left join rps_contrato_v rps
            on rps.rp = tab0.id_rp
            and rps.vigencia = tab0.vigencia
            and rps.sgr = tab0.sgr

        )tab0

        group by
        tab0.id_contrato

    )datsgr
    on datsgr.id_contrato = contin.id_contrato_co*/

    left join(

        select

        tab0.id_contrato,
        tab0.vigencia,
        sum(case when tab0.sgr = 1 then tab0.valor else 0 end) as valor_sgr,
        round( sum(case when tab0.sgr = 1 then tab0.valor else 0 end) * 100 / sum(tab0.valor) , 2 ) as por_sgr,
        sum(tab0.valor) as valor


        from(

            SELECT distinct
            leg.id_contrato,
            leg.id_vigencia as vigencia,
            nvl(leg.sgr,0) as sgr,
            leg.valor_cdp as valor

            FROM in_cdp_cont leg

	  where
	  leg.valor_cdp != 0

        )tab0

        group by
        tab0.id_contrato,
        tab0.vigencia

    )datsgr
    on datsgr.id_contrato = contin.id_contrato
    and datsgr.vigencia = contin.id_vigencia

    where
    ing.id_vigencia_mov = $P{vigencia}
    and ing.id_tipo_movimiento = 1

    and EXTRACT(YEAR FROM mov.fecha_mov) = $P{vigencia}
    and EXTRACT(MONTH FROM mov.fecha_mov) = $P{id_meses}
    and mov.anulado = 0

    /*no elementos de menor cuantia - 20210405*/
    and tipalm.id_grupo_almacenamiento not in (SELECT id_grupo_almacenamiento FROM in_grupo_almacenamiento where id_grupo_almacenamiento = 61)

)tab0

where
1 = 1
$P!{whereCatalogo}
$P!{whereCenOp}
$P!{whereContratoCO}
$P!{whereTercero}
$P!{whereTipoAlmacenamiento}
$P!{whereTipoOrigen}
$P!{whereTipoBien}
and tab0.por_sgr > 0

order by
tab0.id_vigencia_mov,
tab0.codigo_elemento,
tab0.secuencia]]>
	</queryString>
	<field name="ID_CONTRATO" class="java.math.BigDecimal"/>
	<field name="ID_VIGENCIA_CONT" class="java.math.BigDecimal"/>
	<field name="ID_CEN_OP_CONT" class="java.math.BigDecimal"/>
	<field name="ID_MOVIMIENTOS_DV" class="java.math.BigDecimal"/>
	<field name="ID_VIGENCIA_MOV" class="java.math.BigDecimal"/>
	<field name="ID_CEN_OP_MOV" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_MOVIMIENTO" class="java.math.BigDecimal"/>
	<field name="CUENTA" class="java.lang.String"/>
	<field name="NOMBRE_CUENTA" class="java.lang.String"/>
	<field name="CODIGO_ELEMENTO" class="java.lang.String"/>
	<field name="SECUENCIA" class="java.math.BigDecimal"/>
	<field name="DESCRIPCION_ELEMENTO" class="java.lang.String"/>
	<field name="ID_ESTUDIOS_PREVIOS" class="java.math.BigDecimal"/>
	<field name="PROYECTO_COD" class="java.lang.String"/>
	<field name="PROYECTO" class="java.lang.String"/>
	<field name="CONTRATO" class="java.lang.String"/>
	<field name="NO_CONTRATO" class="java.math.BigDecimal"/>
	<field name="ANHO_CONT" class="java.math.BigDecimal"/>
	<field name="VALOR_BIEN" class="java.math.BigDecimal"/>
	<field name="POR_SGR" class="java.math.BigDecimal"/>
	<field name="VALOR_SGR" class="java.math.BigDecimal"/>
	<field name="FECHA_MOV" class="java.sql.Timestamp"/>
	<field name="NOM_CEN_OP" class="java.lang.String"/>
	<field name="PREFIJO" class="java.lang.String"/>
	<field name="ID_CEN_OP" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_ALMACENAMIENTO" class="java.math.BigDecimal"/>
	<field name="ID_MAE_TER" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_ORIGEN" class="java.math.BigDecimal"/>
	<field name="ID_CATALOGO" class="java.math.BigDecimal"/>
	<field name="ID_CONTRATO_CO" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_BIEN" class="java.math.BigDecimal"/>
	<field name="DESC_BIEN" class="java.lang.String"/>
	<variable name="valu_tot" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_BIEN}]]></variableExpression>
	</variable>
	<variable name="sub_tot" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_SGR}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="60" splitType="Stretch">
			<staticText>
				<reportElement x="240" y="0" width="877" height="40"/>
				<textElement textAlignment="Center" verticalAlignment="Bottom" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Sistema General de Inventarios
Informe Mensual de Ingresos de Compras por el SGR]]></text>
			</staticText>
			<image>
				<reportElement x="0" y="16" width="124" height="40"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
			<staticText>
				<reportElement mode="Opaque" x="1357" y="28" width="203" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Fecha de Impresión:]]></text>
			</staticText>
			<textField pattern="dd-MMM-yyyy   hh:mm aaa">
				<reportElement x="1357" y="40" width="203" height="12"/>
				<box rightPadding="3"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="240" y="40" width="877" 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{id_meses} + " de " + $P{vigencia}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="20" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="20" splitType="Stretch">
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="1117" y="0" width="120" height="20" 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[% SISTEMA GENERAL DE REGALÍAS]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="1420" y="0" width="140" height="20" 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[UBICACIÓN]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="1357" y="0" width="63" height="20" 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[FECHA DE COMPRA]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="320" y="0" width="255" height="20" 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[DESCRIPCIÓN DEL ELEMENTO]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="1237" y="0" width="120" height="20" 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[VALOR SISTEMA GENERAL DE REGALÍAS]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="985" y="0" width="132" height="20" 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[VALOR DEL BIEN]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="865" y="0" width="120" height="20" 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[No. CONTRATO / ORDEN COMPRA]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="70" height="20" 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[CÓDIGO CONTABLE]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="240" y="0" width="80" height="20" 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[SECUENCIA]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="70" y="0" width="170" height="20" 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[DESCRIPCIÓN CÓDIGO CONTABLE]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="575" y="0" width="290" height="20" 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[PROYECTO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1560" y="0" width="100" height="20" 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[TIPO BIEN]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="10" splitType="Prevent">
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1237" y="0" width="120" height="10"/>
				<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="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_SGR}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="985" y="0" width="132" 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="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_BIEN}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="320" y="0" width="255" 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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESCRIPCION_ELEMENTO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1117" 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 textAlignment="Center" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{POR_SGR} + "%"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1357" y="0" width="63" 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 textAlignment="Center" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{FECHA_MOV}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1420" y="0" width="140" 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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NOM_CEN_OP}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="70" 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 textAlignment="Center" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CUENTA}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="865" 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 textAlignment="Center" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CONTRATO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="240" y="0" width="80" 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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SECUENCIA}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="70" 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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NOMBRE_CUENTA}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="575" y="0" width="290" 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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PROYECTO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1560" y="0" width="100" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2">
					<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="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESC_BIEN}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="24" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="575" y="12" width="80" 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="655" y="12" width="46" 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="575" y="0" width="126" height="12" forecolor="#575757"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<text><![CDATA[Websafi - Inventarios]]></text>
			</staticText>
		</band>
	</pageFooter>
	<summary>
		<band height="12" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="985" height="12" forecolor="#000000" backcolor="#BCBABA"/>
				<box rightPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen 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[TOTAL: ]]></text>
			</staticText>
			<textField pattern="#,##0.00">
				<reportElement mode="Opaque" x="1237" y="0" width="120" height="12" forecolor="#000000" backcolor="#BCBABA"/>
				<box rightPadding="2">
					<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{sub_tot}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00">
				<reportElement mode="Opaque" x="985" y="0" width="132" height="12" forecolor="#000000" backcolor="#BCBABA"/>
				<box rightPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen 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{valu_tot}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="1357" y="0" width="303" height="12" forecolor="#000000" backcolor="#BCBABA"/>
				<box rightPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen 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[ ]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1117" y="0" width="120" height="12" forecolor="#000000" backcolor="#BCBABA"/>
				<box rightPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen 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[ ]]></text>
			</staticText>
		</band>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="1660" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
