<?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_salida_con" pageWidth="750" pageHeight="900" columnWidth="710" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="0.8689931392100638"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="48"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/inventario/comprobante_salida_con"/>
	<property name="ireport.jasperserver.url" value="http://erp.comisiondelaverdad.co:8090/jasperserver/services/repository"/>
	<parameter name="id_movimientos_con" 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="entidad_cliente" class="java.lang.String"/>
	<parameter name="username" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select
 (select razon_soc from interceros_v where id_mae_ter = tab0.id_mae_ter) as tercero
, (select num_doc from interceros_v where id_mae_ter = tab0.id_mae_ter) as num_doc_ter
, (select descripcion from in_tipo_almacenamiento where id_tipo_almacenamiento = tab0.id_tipo_almacenamiento) as tipo_almacenamiento
, (select descripcion from in_espacio where id_espacio = tab0.id_espacio) as ubicacion
, (select razon_soc from interceros_v where id_mae_ter = tab1.id_mae_ter) as tercero_firma
, (select razon_soc from interceros_v where id_mae_ter = tab2.id_mae_ter) as tercero_firma2
, (select num_doc from interceros_v where id_mae_ter = tab1.id_mae_ter) as num_doc_ter_firma
, (select razon_soc from interceros_v where id_mae_ter = tab0.id_mae_ter_fin) as tercero_fin
, (select num_doc from interceros_v where id_mae_ter = tab0.id_mae_ter_fin) as num_doc_fin
, (select num_doc from interceros_v where id_mae_ter = tab0.id_usuario) as num_doc_elabora
, (select razon_soc from interceros_v where id_mae_ter = tab0.id_usuario) as razon_soc_elabora
, tab1.cargo
, tab2.cargo as cargo2
,tab0.*

,tab0.nom_cen_op
,tab0.id_orden_trabajo
,tab0.fecha_orden
,case when tab0.id_orden_trabajo is not null then ' ORDEN DE TRABAJO NO.'|| tab0.id_orden_trabajo ||' de ' || to_char(tab0.fecha_orden,'dd-mm-yyyy') else ' ' end as texto_orden_trabajo

from (

    select
    tab1.id_movimientos_con
    , tab1.fecha_mov
    ,tab1.id_vigencia
    , to_char(tab1.fecha_doc, 'dd-mm-yyyy') as fecha_doc
    , tab1.id_tipo_almacenamiento_ini as id_tipo_almacenamiento
    , tab1.id_espacio_ini as id_espacio
    , tab1.num_doc
    , tab1.id_usuario
    , tab2.cantidad
    , tab2.valor_unitario
    , tab2.valor_unitario*tab2.cantidad as total
    , tab2.id_det_mov_con
    , tab3.codigo_elemento as codigo_inventario_dv
    , tab3.desc_catalogo as desc_catalogo
    , tab3.id_catalogo
    , tab3.id_clase
    , tab3.id_linea
    , tab4.prefijo
    ,tab4.nom_cen_op
    , tab4.id_cen_op
    , tab5.descripcion as desc_corta_tipo_mov
    , tab5.id_tipo_movimiento
    , tab6.unidad
    , tab6.descripcion as desc_unidad_medida
    , tab6.id_unidad_medida
    , tab7.id_inventario_con
    , tab8.id_concepto_movimiento
    , tab8.descripcion as desc_concepto_movimiento
    , case when tab1.id_tipo_movimiento = 3 then tab1.id_mae_ter_ini else id_mae_ter_fin end as id_mae_ter
    , tab9.id
    , tab9.descripcion as desc_ts_td
    , tab1.observaciones
    ,tab1.id_mae_ter_fin
    ,tab1.anulado
    ,tab1.fecha_anu
    ,tab1.estado

    ,ord.id_orden_trabajo
    ,ord.fecha_orden

    from in_movimientos_con tab1

    left join in_det_mov_con tab2
    on tab2.id_movimientos_con = tab1.id_movimientos_con
    and tab2.id_cen_op = tab1.id_cen_op
    and tab2.id_vigencia = tab1.id_vigencia
    and tab2.id_tipo_movimiento= tab1.id_tipo_movimiento


    left join ts_td tab9 on tab9.id = tab1.id_ts_td
    left join in_codigo_elemento_v tab3 on tab3.id_linea = tab2.id_linea and tab3.id_clase = tab2.id_clase and tab3.id_catalogo = tab2.id_catalogo
    join centro_operacion tab4 on tab4.id_cen_op = tab1.id_cen_op
    join in_tipo_movimiento tab5 on tab5.id_tipo_movimiento = tab1.id_tipo_movimiento
    left join in_unidad_medida tab6 on tab6.id_unidad_medida = tab3.id_unidad_medida
    left join in_inventario_con tab7 on tab7.id_inventario_con = tab2.id_inventario_con
    join in_concepto_movimiento tab8 on tab8.id_concepto_movimiento = tab1.id_concepto_movimiento

    left join in_orden_mov_con ormov
    on ormov.id_movimientos_con = tab1.id_movimientos_con
    and ormov.id_vigencia_mov = tab1.id_vigencia
    and ormov.id_cen_op_mov = tab1.id_cen_op
    and ormov.id_tipo_movimiento = tab1.id_tipo_movimiento

    left join in_orden_trabajo ord
    on ord.id_orden_trabajo = ormov.id_orden_trabajo
    and ord.id_vigencia = ormov.id_vigencia
    and ord.id_cen_op = ormov.id_cen_op

    where tab1.id_movimientos_con = $P{id_movimientos_con}
    and tab1.id_cen_op = $P{id_cen_op} and tab1.id_vigencia = $P{id_vigencia}
    and tab1.id_tipo_movimiento = 3 --and tab1.estado = 0

--order by tab1.id_movimientos_con
)tab0

left join in_firma tab1 on tab1.id_tipo_movimiento = tab0.id_tipo_movimiento
and tab0.id_cen_op = tab1.id_cen_op and id_tipo_firma = 1
and (tab0.fecha_mov  between tab1.fecha_ini and case when  tab1.fecha_fin is null then sysdate else tab1.fecha_fin end)

left join in_firma tab2 on tab2.id_tipo_movimiento = tab0.id_tipo_movimiento
and tab0.id_cen_op = tab2.id_cen_op and tab2.id_tipo_firma = 2
and (tab0.fecha_mov  between tab2.fecha_ini
and case when  tab2.fecha_fin is null then sysdate else tab2.fecha_fin end)

where 1 = 1

order by
tab0.codigo_inventario_dv]]>
	</queryString>
	<field name="TERCERO" class="java.lang.String"/>
	<field name="NUM_DOC_TER" class="java.lang.String"/>
	<field name="TIPO_ALMACENAMIENTO" class="java.lang.String"/>
	<field name="UBICACION" class="java.lang.String"/>
	<field name="TERCERO_FIRMA" class="java.lang.String"/>
	<field name="TERCERO_FIRMA2" class="java.lang.String"/>
	<field name="NUM_DOC_TER_FIRMA" class="java.lang.String"/>
	<field name="TERCERO_FIN" class="java.lang.String"/>
	<field name="NUM_DOC_FIN" class="java.lang.String"/>
	<field name="NUM_DOC_ELABORA" class="java.lang.String"/>
	<field name="RAZON_SOC_ELABORA" class="java.lang.String"/>
	<field name="CARGO" class="java.lang.String"/>
	<field name="CARGO2" class="java.lang.String"/>
	<field name="ID_MOVIMIENTOS_CON" 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" class="java.math.BigDecimal"/>
	<field name="ID_ESPACIO" class="java.math.BigDecimal"/>
	<field name="NUM_DOC" class="java.lang.String"/>
	<field name="ID_USUARIO" class="java.math.BigDecimal"/>
	<field name="CANTIDAD" class="java.math.BigDecimal"/>
	<field name="VALOR_UNITARIO" class="java.math.BigDecimal"/>
	<field name="TOTAL" class="java.math.BigDecimal"/>
	<field name="ID_DET_MOV_CON" class="java.math.BigDecimal"/>
	<field name="CODIGO_INVENTARIO_DV" class="java.lang.String"/>
	<field name="DESC_CATALOGO" class="java.lang.String"/>
	<field name="ID_CATALOGO" class="java.math.BigDecimal"/>
	<field name="ID_CLASE" class="java.math.BigDecimal"/>
	<field name="ID_LINEA" class="java.math.BigDecimal"/>
	<field name="PREFIJO" class="java.lang.String"/>
	<field name="NOM_CEN_OP" class="java.lang.String"/>
	<field name="ID_CEN_OP" 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="UNIDAD" class="java.lang.String"/>
	<field name="DESC_UNIDAD_MEDIDA" class="java.lang.String"/>
	<field name="ID_UNIDAD_MEDIDA" class="java.math.BigDecimal"/>
	<field name="ID_INVENTARIO_CON" 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_MAE_TER" class="java.math.BigDecimal"/>
	<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="ID_MAE_TER_FIN" class="java.math.BigDecimal"/>
	<field name="ANULADO" class="java.math.BigDecimal"/>
	<field name="FECHA_ANU" class="java.sql.Timestamp"/>
	<field name="ESTADO" class="java.math.BigDecimal"/>
	<field name="ID_ORDEN_TRABAJO" class="java.math.BigDecimal"/>
	<field name="FECHA_ORDEN" class="java.sql.Timestamp"/>
	<field name="TEXTO_ORDEN_TRABAJO" class="java.lang.String"/>
	<variable name="valor_total" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{TOTAL}]]></variableExpression>
	</variable>
	<variable name="valor_total_pagina" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{TOTAL}]]></variableExpression>
	</variable>
	<background>
		<band height="860" splitType="Stretch">
			<staticText>
				<reportElement x="0" y="224" width="74" height="393"/>
				<box>
					<pen lineWidth="0.5"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement/>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement x="74" y="224" width="282" height="393"/>
				<box>
					<pen lineWidth="0.5"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement/>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement x="356" y="224" width="99" height="393"/>
				<box>
					<pen lineWidth="0.5"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement/>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement x="455" y="224" width="55" height="393"/>
				<box>
					<pen lineWidth="0.5"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement/>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement x="510" y="224" width="100" height="393"/>
				<box>
					<pen lineWidth="0.5"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement/>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement x="610" y="224" width="100" height="393"/>
				<box>
					<pen lineWidth="0.5"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement/>
				<text><![CDATA[]]></text>
			</staticText>
			<image>
				<reportElement x="169" y="280" width="494" height="337">
					<printWhenExpression><![CDATA[$F{ANULADO}.intValue()==1]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:anulado.jpg"]]></imageExpression>
			</image>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="610" y="0" width="100" height="37" forecolor="#ADA8A8">
					<printWhenExpression><![CDATA[$F{ANULADO}.intValue()==1]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="15"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{FECHA_ANU}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="466" y="0" width="144" height="37" forecolor="#ADA8A8" backcolor="#FFFFFF">
					<printWhenExpression><![CDATA[$F{ANULADO}.intValue()==1]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="15" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Fecha Anulación:]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="74" y="280" width="589" height="337" forecolor="#C5C5C5" backcolor="#FDFBFB">
					<printWhenExpression><![CDATA[$F{ESTADO}.intValue()==1]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="98"/>
				</textElement>
				<text><![CDATA[Borrador]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="283" y="0" width="183" height="37" forecolor="#ADA8A8" backcolor="#FFFFFF">
					<printWhenExpression><![CDATA[$F{ESTADO}.intValue()==1]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="15" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Comprobante Abierto]]></text>
			</staticText>
		</band>
	</background>
	<title>
		<band height="10" splitType="Stretch"/>
	</title>
	<pageHeader>
		<band height="189" splitType="Stretch">
			<textField>
				<reportElement x="283" y="33" width="418" height="20"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font size="14"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[" COMPROBANTE DE "+$F{DESC_CORTA_TIPO_MOV}+" No."+$F{ID_MOVIMIENTOS_CON}.toString()]]></textFieldExpression>
			</textField>
			<image>
				<reportElement x="0" y="0" width="283" height="53"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
			<staticText>
				<reportElement x="485" y="169" width="74" height="20"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[CIUDAD:]]></text>
			</staticText>
			<staticText>
				<reportElement x="485" y="82" width="74" height="20"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No.]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="106" y="169" width="363" height="20"/>
				<box>
					<bottomPen lineWidth="0.75"/>
				</box>
				<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})  + ($F{TEXTO_ORDEN_TRABAJO})]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="559" y="169" width="142" 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="82" width="106" height="20"/>
				<box leftPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[CONCEPTO        :]]></text>
			</staticText>
			<textField pattern="###0" isBlankWhenNull="true">
				<reportElement x="559" y="82" width="142" height="20" isRemoveLineWhenBlank="true"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ID_MOVIMIENTOS_CON}.toString()]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="485" y="112" 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="112" width="122" height="20"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[CENTRO OPERACION: ]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="142" width="107" height="20"/>
				<box leftPadding="2"/>
				<textElement>
					<font size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[OBSERVACIONES: ]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="559" y="112" width="142" 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="0" y="82" width="469" height="107"/>
				<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>
			<staticText>
				<reportElement x="485" y="142" width="74" height="20"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[FECHA:]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="122" y="112" width="327" height="20"/>
				<textElement verticalAlignment="Middle">
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NOM_CEN_OP}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="107" y="82" width="363" height="20"/>
				<textElement verticalAlignment="Middle">
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESC_CONCEPTO_MOVIMIENTO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="108" y="138" width="358" height="20"/>
				<box topPadding="6"/>
				<textElement verticalAlignment="Top">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{OBSERVACIONES}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="169" width="106" height="20"/>
				<box leftPadding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[ANTECEDENTE    :]]></text>
			</staticText>
			<textField pattern="dd-MM-yyyy" isBlankWhenNull="true">
				<reportElement x="559" y="142" width="142" 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>
			<staticText>
				<reportElement x="469" y="82" width="239" height="107"/>
				<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>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="48" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="0" y="22" width="74" height="25" backcolor="#E2D9D9"/>
				<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" rotation="None"/>
				<text><![CDATA[CÓDIGO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="74" y="22" width="282" height="25" backcolor="#E2D9D9"/>
				<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" rotation="None"/>
				<text><![CDATA[DESCRIPCIÓN]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="356" y="22" width="100" height="25" backcolor="#E2D9D9"/>
				<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" rotation="None"/>
				<text><![CDATA[UD. DE MEDIDA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="510" y="22" width="100" height="25" backcolor="#E2D9D9"/>
				<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" rotation="None"/>
				<text><![CDATA[VALOR UNITARIO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="610" y="22" width="100" height="25" backcolor="#E2D9D9"/>
				<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" rotation="None"/>
				<text><![CDATA[VALOR TOTAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="455" y="22" width="55" height="25" backcolor="#E2D9D9"/>
				<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" rotation="None"/>
				<text><![CDATA[CANT.]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="10" splitType="Immediate">
			<textField isBlankWhenNull="true">
				<reportElement x="0" y="0" width="74" height="10"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CODIGO_INVENTARIO_DV}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="74" y="0" width="282" height="10"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESC_CATALOGO}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="356" y="0" width="99" height="10"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESC_UNIDAD_MEDIDA}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00;(-###0.00)" isBlankWhenNull="true">
				<reportElement x="455" y="0" width="55" height="10"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{CANTIDAD}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement x="510" y="0" width="100" height="10"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_UNITARIO}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement x="610" y="0" width="100" height="10"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{TOTAL}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="74" splitType="Stretch">
			<textField>
				<reportElement x="292" y="47" width="110" height="12" forecolor="#575757"/>
				<textElement textAlignment="Right">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Página "+$V{PAGE_NUMBER}+" de "]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="292" y="35" width="164" height="12" forecolor="#575757"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<text><![CDATA[Websafi - Control De Recursos Físicos
]]></text>
			</staticText>
			<textField evaluationTime="Report">
				<reportElement x="402" y="47" width="54" height="12" forecolor="#575757"/>
				<box leftPadding="2"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="610" height="20" forecolor="#000000" backcolor="#E2D9D9"/>
				<box rightPadding="6">
					<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[PASAN ...]]></text>
			</staticText>
			<textField evaluationTime="Page" pattern="#,##0.00;-#,##0.00">
				<reportElement mode="Opaque" x="608" y="0" width="102" height="20" forecolor="#000000" backcolor="#E2D9D9"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{valor_total_pagina}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Opaque" x="0" y="59" width="356" height="12" forecolor="#575757" backcolor="#FFFFFF"/>
				<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Impreso por: "+$P{username}]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<lastPageFooter>
		<band height="265">
			<staticText>
				<reportElement x="0" y="20" width="710" height="97"/>
				<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/>
				<text><![CDATA[]]></text>
			</staticText>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="610" y="0" width="100" height="20" isRemoveLineWhenBlank="true" backcolor="#E2D9D9"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{valor_total}==null?new BigDecimal(0):$V{valor_total}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="283" y="34" width="141" height="20"/>
				<textElement/>
				<text><![CDATA[ELEMENTOS DE CONSUMO]]></text>
			</staticText>
			<staticText>
				<reportElement x="94" y="34" width="62" height="14"/>
				<box leftPadding="2"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[EGRESO]]></text>
			</staticText>
			<staticText>
				<reportElement x="15" y="64" width="87" height="20"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Ubicación     :]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="102" y="64" width="540" height="20"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TIPO_ALMACENAMIENTO}+ " "+$F{UBICACION}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="0" y="0" width="510" height="20" forecolor="#000000" backcolor="#E2D9D9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["  VALOR EN LETRAS: "+$P{numero_letras}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="510" y="0" width="100" height="20" forecolor="#000000" backcolor="#E2D9D9"/>
				<box>
					<topPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
				</box>
				<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[TOTAL:]]></text>
			</staticText>
			<staticText>
				<reportElement x="15" y="84" width="87" height="20"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Responsable:]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="102" y="84" width="540" height="20"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TERCERO}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="102" y="104" width="540" height="13"/>
				<box leftPadding="5" rightPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["CC/Nit: "+$F{NUM_DOC_TER}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="32" y="148" width="216" height="20"/>
				<box leftPadding="2" rightPadding="2">
					<topPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TERCERO}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="32" y="168" width="216" height="13"/>
				<box leftPadding="5" rightPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["CC/Nit: "+$F{NUM_DOC_TER}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="117" width="710" height="142"/>
				<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/>
				<text><![CDATA[]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="292" y="148" width="216" height="20"/>
				<box leftPadding="2" rightPadding="2">
					<topPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TERCERO_FIN}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="292" y="168" width="216" height="13"/>
				<box leftPadding="5" rightPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["CC/Nit: "+ $F{NUM_DOC_FIN}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="10" y="208" width="600" height="10" isRemoveLineWhenBlank="true"/>
				<box leftPadding="2" rightPadding="2">
					<topPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{entidad_cliente}.equals("4")?($F{ID_CEN_OP}.intValue()==28?("Vo.Bo. "+$F{TERCERO_FIRMA}+" - "+$F{CARGO}):($F{TERCERO_FIRMA}==null?"":($F{CARGO}+"                      : "+$F{TERCERO_FIRMA}+" ___________________________________"))):""]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="10" y="243" width="600" height="10">
					<printWhenExpression><![CDATA[1 == 0]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2" rightPadding="2">
					<topPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{entidad_cliente}.equals("4")?($F{ID_CEN_OP}.intValue()!=28?("Vo.Bo. "+$F{TERCERO_FIRMA2}+" - "+$F{CARGO2}+" ___________________________________"):""):""]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="10" y="226" width="600" height="10"/>
				<box leftPadding="2" rightPadding="2">
					<topPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{entidad_cliente}.equals("4")?($F{ID_CEN_OP}.intValue()==28?("Vo.Bo. "+$F{TERCERO_FIRMA2}+" - "+$F{CARGO2}):("Verificación técnica y elaborado por: "+($F{RAZON_SOC_ELABORA}==null?"":$F{RAZON_SOC_ELABORA})+" ___________________________________")):($F{RAZON_SOC_ELABORA}==null?"":"Elaborado por: "+$F{RAZON_SOC_ELABORA})]]></textFieldExpression>
			</textField>
		</band>
	</lastPageFooter>
	<summary>
		<band height="6"/>
	</summary>
</jasperReport>
